SUMMARY

• 7.5 years of total IT experience on multiple technologies and domain.
• 5+ years of experience in developing software throughout lifecycle, from identifying requirements, Design, Development to QA debugging, Implementation, testing and support. Proven background of completing projects on time and under budget.
• 2.5 years of experience as a team lead; skilled in motivating and leading peers, and scheduling project activities.
• Extensive technical skills in Extraction, Transformation and Loading of the data from multiple sources into Data warehouse using Ab Initio V2.15/ Ab Initio 3.0/ Informatica 8.0/ Oracle/ DB2/ Unix/Linux Operating systems.
• Strong knowledge of Data Modeling methodologies such as Star Schema and Snowflake Schema and tools such as Ab Initio Data Profiler.
• Good exposure to multiple relational databases including Oracle, DB2.
• Good knowledge on Banking and Telecom Domain.
• Extensively used EME for version control, Repository manager.
• Experience in scheduling process using job schedulers such as CA7, Autosys.
• Experience in developing wrapper scripts for scheduling Ab Initio Graphs, Informatica Mappings.
• Thorough knowledge of korn shell scripting, SQL, PL/SQL programming.
• Experience in writing SQL query, Procedures, Triggers, and Functions necessary for maintenance of the databases in the data warehouse development lifecycle.
• Superior analytical, time management and problem - solving skills.
• Impressive ability to TEMPeffectively communicate a broad set of topics, ranging from business terminology to complex technical solutions, to a diverse audience.

TECHNICAL SKILLS

Operating Systems: Windows XP/7, Unix (AIX/HPUX), Linux

Languages: C, SQL/PLSQL

Databases: DB2, Oracle 10g/9i, SQL Server

Database utilities: Toad for Oracle, Toad for DB2, DB2 command editor

ETL Tools: Ab Initio V2.15, Ab Initio 3.0, Informatica 8.0

Software Engineering: SDLC

Web Languages: HTML

Scheduling Tool: CA7, Autosys.

PROFESSIONAL EXPERIENCE

Computer Systems Analyst

Confidential, Richmond, VA

Responsibilities:

• Working as an Onsite Developer wif clients, Business Analysts, Data Modelers and creating Ab Initio graphs from Scratch.
• Working in Agile team, involving business requirement discussions & decisions.
• Preparation of High level & Detail level design documents.
• Preparation of Source to Target Mapping documents.
• Reverse Engineering & analysis for Teradata tables back to source files.
• Code migration from development to production after unit testing & system testing.

Environment: Ab Initio V2.15, Ab Initio 3.0, CTRL-M, Oracle SQL Developer, Teradata SQL Assistant, Windows XP, UNIX (HP-UX), LINUX

Assistant Technical Consultant

Confidential, Foster City, CA

Responsibilities:

• Worked on resolving the data lineage issues by modifying the existing graphs and addressing the dependency analysis errors.
• Creating the graphs for the new requirements and tuning the graphs for better performance.
• Involved in code reviews, performance tuning strategies at ab initio and Database level.
• Modified the AbInitio component parameters, introduced phases, utilized data parallelism and thereby improving the overall performance to fine-tune the execution times.
• Used different EME Air commands in project promotion like air tag create, air save, air lock, air project export etc.
• Involved in project migration from development to QA and QA to UAT and then to PROD.
• Fixed Defects / Bugs reported by the Testing Team.
• Extensively used PDLs in the process.

Environment: Ab Initio 3.1.5, DB2 Command Editor, AQT, Windows 7, UNIX (HP-UX)

Technical Analyst

Confidential, Atlanta, GA

Responsibilities:

• Application production support comprising of incident, user request and problem tickets. This includes Emergency break fix and associated unit testing.
• Perfective maintenance to avert future foreseeable application issues, in order to improve performance, quality, reliability, efficiency, usability and maintainability of the application.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Knowledge Transition planning and preparing system appreciation documents.
• Business continuity activities including, disaster recovery planning and support for exercises and events.
• Business Impact analysis of system changes and implementing necessary changes in the application.
• Implement perfective maintenance to improve the system health and performance.
• Defect prevention and documenting learning’s.
• Resolve production incidents and document the steps involved in resolution.
• Coordination wif Enterprise Testing Organization for maintenance and execution of regression test scripts.
• Capacity planning and co-ordination.

Environment: Ab Initio V2.15, Ab Initio 3.0, CA7, DB2 Command Editor, Windows XP, UNIX (HP-UX), LINUX

Technical Analyst

Confidential

Responsibilities:

• Complexity of the system - High
• More TEMPthan 1500 Informatica workflows were involved.
• More TEMPthan 650 scheduling jobs were involved.
• More TEMPthan 650 UNIX Scripts were involved.
• Development of enhancement requests for the Data Quality Items
• Planning and execution of Test Cycles.
• Impact Analysis for the change requests.
• Defect tracking & fixing activities.
• Daily support of the application involving monitoring.
• Leading offshore team.
• Performing process related activities.
• Code migration activities across the test environments.

Environment: Informatica 8.0, Autosys, Toad for DB2, Toad for Oracle, Windows XP, UNIX (AIX)

Senior Software Engineer

Confidential

Responsibilities:

• Designed and Built Ab Initio Graphs for unloading data from different source systems.
• Worked wif DB2 to retrieve the data from source systems for data processing.
• Involved in the migration of the code in QA environment wif QA team and completed rigorous unit testing of each graph.
• Extensively used Enterprise Meta Environment (EME) for version control.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs.
• Writing the generic .dbc files for the Development, Testing and Production Environments.
• Designed reusable Centralized graphs as a part of this project. These graphs are being used wif minimal changes for the Quotes data of other regions.
• Testing the graphs for performance. Performance improvement measures included the use of the Multi file system feature of Abinitio. This brought about a substantial improvement in performance deriving on the inherent parallelism features of Abinitio.

Environment: Ab initio 2.15, DB2, Autosys, Windows XP, UNIX (HP-UX)

Senior Software Engineer

Confidential

Responsibilities:

• Offshore lead activities.
• Data loading from various source systems to DB2/Oracle tables.
• Data Validation.
• Compile Unit Test cases and execute perform Unit Testing.
• Performed Peer review.
• Implementing defect prevention strategies.

Environment: SSIS, DB2, oracle 10g, Toad for DB2, Toad for Oracle, Windows XP.