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 teh 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 noledge 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 noledge 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 noledge of korn shell scripting, SQL, PL/SQL programming.
• Experience in writing SQL query, Procedures, Triggers, and Functions necessary for maintenance of teh databases in teh 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

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 teh data lineage issues by modifying teh existing graphs and addressing teh dependency analysis errors.
• Creating teh graphs for teh new requirements and tuning teh graphs for better performance.
• Involved in code reviews, performance tuning strategies at ab initio and Database level.
• Modified teh AbInitio component parameters, introduced phases, utilized data parallelism and theirby improving teh overall performance to fine-tune teh 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 teh Testing Team.
• Extensively used PDLs in teh 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. dis 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 teh 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 teh application.
• Implement perfective maintenance to improve teh system health and performance.
• Defect prevention and documenting learning’s.
• Resolve production incidents and document teh 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 teh system - High
• More than 1500 Informatica workflows were involved.
• More than 650 scheduling jobs were involved.
• More than 650 UNIX Scripts were involved.
• Development of enhancement requests for teh Data Quality Items
• Planning and execution of Test Cycles.
• Impact Analysis for teh change requests.
• Defect tracking & fixing activities.
• Daily support of teh application involving monitoring.
• Leading offshore team.
• Performing process related activities.
• Code migration activities across teh 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 teh data from source systems for data processing.
• Involved in teh migration of teh 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 teh best design principles, efficiency guidelines and naming standards in designing teh graphs.
• Writing teh generic .dbc files for teh Development, Testing and Production Environments.
• Designed reusable Centralized graphs as a part of dis project. These graphs are being used wif minimal changes for teh Quotes data of other regions.
• Testing teh graphs for performance. Performance improvement measures included teh use of teh Multi file system feature of Abinitio. dis brought about a substantial improvement in performance deriving on teh 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.