SUMMARY
15 years of experience in analyzing, designing and developing mission critical
software applications with a reputation of meeting the project goals within the
complex resource and time constraints.
As a Lead and Senior Developer, worked on challenging projects with increasing
responsibilities in various consulting and industry maintenance background.
Extensively worked in Data Warehousing and Business Intelligence reporting
using Informatica, Business Objects and Oracle Databases.
Extensive years of experience in a diversified platform of UNIX and NT.
Experience in Oracle Forms, Developer 2000 and Oracle Reporting.
Extensive Experience in SQL, PL/SQL, Unix shell scripts and ETL methodologies
Strong knowledge in Analysis of Problem Severity
Excellent inter-personnel and communication skills.
Proven records for handling multiple projects.
Experience in handling on call production support 24/7 on a rotation basis.
Extensively used Remedy to create and resolve tickets and update the call-log
to maintain the history.
Proactively intimate the users about the job status in case of failure and its
updated status.
Worked during off-hours depending upon the severity of the tickets.
Analyze the problem of the ticket, fix and run in the test environment and
after getting confirmation from the user, it is moved to the production system.
Used Scripts to load the Monthly or Quarterly data manually through SQL*Loader
and intimate the user after successful completion.
Proficient in Oracle 10g/9i/8i in writing and using SQL queries, SQL *Loader,
Stored Procedures, Triggers, Materialized Views, Cursors, Partitioning, Exception
handling and Optimization tuning techniques using Explain plan , SQL Trace.
TECHNICAL SKILLS
Data Base Systems
Oracle 10g/9i/8i, Sybase 11.5, Informix, SQL Server Business Intelligence:
Business Objects 6.0/XI R2,Crystal Reports
ETL:
Informatica 7.x, Business Objects Data Integrator 6.0 GUI
Developer 2000, PVCS Version Control
Other Skills
Pro*C and UNIX shell scripting, SQL, PL/SQL, AutoSys , Remedy, SAP,
Salesforce Hardware
HP, SUN, VAX/VMS and Pentium Client machines
PROFESSIONAL EXPERIENCE
Yakshna Solutions, Inc. Herndon, VA
December 2009 to Present
(Sr.Oracle Consultant, Tax2efile.com)
Accomplishments:
Mentoring developers for best SQL practice
Co-ordinate the development and deployment schedules
Monitor Quality Inspection and deployment process
Design and development of IRS Form tax2efile application database
Mentoring developers to create stored procedures for batch process to transfer
the data
Responsible for Developing, Enhancing and Maintenance of Oracle Procedures and
Packages
Performance tuning of the application
Environment: Oracle 10g, PL/SQL, SQL Server 2005
United Therapeutics Corporation, SilverSprings, MD
Jun 2007 Nov 2009
(Sr.Oracle Consultant - HR Portal and SalesForce /SAP Integration )
Accomplishments:
Managing a team of 10 developers and testers
Gathering the requirements from the business users
Co-ordinate the database and application development and deployment schedules
Designing, Developing, Implementing and ETL process using Data Integrator
Exporting Dataflow, Workflow, and Jobs
Responsible for Developing, Enhancing and Maintenance of Oracle Procedures and
Packages
Mentoring developers to create PL/SQL packages for batch process to transfer
the data from Transactional database to ORDB.
Scheduling and Monitoring of Jobs under each project using BO Web
Administrator.
Scripts to clean up repository error and log files.
Skilled in monitoring Oracle Database using Quest Toad to minimize the
performance problems.
Prepared documents detailing various database design and maintenance
procedures.
Conducted PL/SQL training session for co-workers to educate about the latest
PL/SQL features, PL/SQL performance tuning.
Developed test plan, test cases and test scripts to thoroughly test the data
warehousing application.
Collections of performance data for specific time range using STATSPACK.
Applied BULK techniques extensively for batch data loads for pharamaceutical
distributor information transfer from Salesforce to SAP and vice versa.
Environment: Sun Solaris, Oracle 10g, PL/SQL, Business Objects, Crystal Reports
GAVS Information Services Private Ltd, Chennai, India
Feb 2002 May 2007
(Technical Lead/Sr. Software Engineer, Hunter Douglas, StorageTek, USA)
Accomplishments:
Designing, Developing, Implementing and ETL process using Data Integrator
Extracted data from SAP using R/3 dataflow.
Helped to develop reusable objects using Business Objects Data Integrator
Used Slowly Changing Dimension to keep track of Historical Data.
Used Repository manager to create Repository, User groups, Users and managed
users by setting up their privileges and profile.
Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy,
Router Transformations.
Used the Debugger to test the data flow from source to target.
Used the parameter file for sending the error log to check whether it is
failed or successful
Responsible for Developing, Enhancing and Maintenance of Oracle Procedures and
Packages.
Created Unix Shell Scripts and AutoSys jobs to schedule various job processes
including auto alerts.
Created PL/SQL batch processes to load external data using SQL*LOADER.
Generated system specific PL/SQL packages, procedures, functions and stand
alone back-end processes.
Developed the Aces Service Contract Module using Informatica.
Environment: Oracle Sun OS 5.8, Windows 2000, Informix, Oracle, SAP, BODI 6.0,
Business Objects Web Administrator, Informatica 6.0/7.X
Kumaran Systems, Inc. MD, USA
Nov 1999 Jan 2002
(Project Lead/Oracle Consultant)
Clients: Baltimore Gas & Electric (BGE)
California Power Exchange (CalPx)
General Electric Retail System (GERS)
Quest Diagnostics,
Stroh Brewery Company,
US Navy
Accomplishments:
Development of a batch scheduler using Oracle DBMS_JOB.
Building of Connectors that do the data extraction from various billing system
into the CVM suite, the billing system involved are CSG and Portals Infranet,
DST Invosis DDP SQL and Intele Cable.
Mentoring developers and testers on Oracle SQL query performance tuning
Maintained and supported the Portal Billing system for development and testing
of the CVM suite applications.
Involved in the analysis and design of the Migration procedures for the
project, which is in the Digital Unix Oracle Forms 3.0 to Oracle Developer 2000
in Digital Unix platform with Y2K complaints.
Assisted in the migration process by providing the proper technical and
funcational support.
Designed the basic data driven menu structure using Forms 4.5 to link the full
project.
Involved in testing, problem solving and implementation of the project after
migration.
Environment: Windows NT, HP-UNIX, Oracle, Sybase 11.5, Business Objects 5.0,
SQL*Advantage,
Web Intelligence 2.5, Informatica 5.1, Autosys
Kumaran Software, Chennai, India
Jun 1997 Oct 1999
(Sr. Programmer/Systems Analyst)
Clients: Intertek Testing Services, UK,
Iowa Court, Access, Inc,
Precor Corp., Chevron Oil Corp., USA
Accomplishments:
Worked in migration projects from Unify, Access to Oracle7.0 with Developer
2000
Involved in the database migration preparations from Unify Database to Oracle
7.x.
Provided technical supports and handled the customer integration and
implementation and support.
Lead a team of 5 for the migration of a Project from Forms 3.0, Reports 1.1 to
Oracle Developer 2000.
Involved in Migration and Quality Assurance of several migration projects
Environment: SCO-Unix, Windows NT, Oracle 7.x, Developer 2000, PL/SQL
Computer Rock, India
Jun 1995 May 1997
(Programmer Analyst)
Accomplishments:
Developed Accounts receivable system, Payroll Processing System, Customer
details, Product details and Invoice details.
Maintained various details regarding different types of products, orders and
customers
Generated reports based on customer details, and Invoices which were overdue
Maintained complete information about employee benefits
Created PL/SQL packages to support batch data loads.
Environment: SCO-Unix, Oracle Developer (Forms 3.0, Reports 1.1), SQL
EDUCATION
Masters in Computer Science
|
