SUMMARY

• 20 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 Data Stage, 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 HP Service Center, 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 remedy 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 IBM DB2, 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, IBM DB2

Business Intelligence: Business Objects 6.0/XI R2,Crystal Reports

ETL: Informatica 7.x, Business Objects Data Integrator 6.0, IBM DataStage 11.5

GUI: Developer 2000, PVCS Version Control, Forms 9i, Reports

Other Skills: Pro*C and UNIX shell scripting, SQL, PL/SQL, AutoSys, Remedy, HP Quality center, Caliber, SAP, Salesforce

Hardware: HP, SUN, VAX/VMS and Pentium Client machines

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Data Engineer

Responsibilities:

• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the DB2/Mainframe database.
• Designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Aggregator.
• Designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort.
• Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
• Used the Data Stage Director to monitor the status of the jobs.
• Creation of jobs sequences.
• Documented ETL test plans, test cases, test results, and validations based on unit testing, prepared test data for testing, error handling and analysis.
• Scheduling the Datastage jobs using Cybermation.

Environment: Sun Solaris, IBM DB2, SQL Server, Java, XML, Cybermation, Rally, Data Stage

Confidential, Arlington, VA

ETL Developer

Responsibilities:

• Developed, Enhanced, Maintenance of ETL process using Informatica
• Extensively used mappings like Lookup, Sorter, Aggregator, Rank and Router transformations for populating target table in efficient manner.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager
• Supported Informatica Powercenter ETL jobs.
• Monitored Oracle Database using Quest Toad to minimize the performance problems.
• Prepared documents detailing maintenance procedures.
• Loading of XML type data into Oracle table using plsql functions.
• Created test plan, test cases and test scripts to thoroughly test the application.

Environment: Sun Solaris, Oracle 10g, PL/SQL, Java, XML, Autosys, Bugzilla, Informatica

Confidential, SilverSprings, MD

Sr. Oracle Consultant

Responsibilities:

• 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
• 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.
• 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: Oracle 10g, PL/SQL, Informatica 7.x, Business Objects, Crystal Reports

Confidential

Technical Lead/Sr. Software Engineer

Responsibilities:

• Created Unix Shell Script for a group of Sessions as a job, which is used to run the job scheduling process.
• In case of failure of any PL/SQL program, SHELL scripts are used to ftp and mail notification from UNIX server
• Emailing the Success jobs to Logs mail public folder and Failure jobs to Error Logs mail public folder.
• Notifying the users for the failed jobs and the estimate time of data availability after recovery.
• Finding the cause of failure, fix and run the job manually and notify the users after successful completion of the job.
• Used AutoSys for running the jobs using a job box for the various scripts.
• Error detection and correction is implemented in all of the PL/SQL programs to notify the on-call person in case of failure.
• Development and Customisation of Database Triggers to adopt new business rules
• Manually running the Scripts to load International Quarter/Month Close Data (ACES & Legacy System) into the Warehouse tables using SQL Loader, Packages and Procedures.
• 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.
• 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
• Documented the mappings used in ETL processes.
• Migration of a Project from Forms 4.5 to 9i, Reports 6i.
• Involved in Migration and Quality Assurance of several migration projects
• Maintenance of existing Oracle based systems and integration.

Environment: Oracle Sun OS 5.8, Windows 2000, Informix, Oracle, Informatica 6.0/7.X, SAP, BODI 6.0, Business Objects Web Administrator, Oracle Forms, Oracle Reports

Confidential

Project Lead/Oracle Consultant

Responsibilities:

• 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 Portal’s 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*AdvantageWeb Intelligence 2.5, Informatica 5.1, Autosys

Confidential

Sr. Programmer/Systems Analyst

Responsibilities:

• 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

Confidential

Programmer Analyst

Responsibilities:

• 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