SUMMARY

• Over 17 years of IT experience in Software Design, Development and Implementation with major focus on Data Warehouse and Business Intelligence applications
• Over 7 years of experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and Sessions
• Over 7 years of experience in Designing, Developing, Testing and Supporting data warehouse and business intelligence applications using ETL tool Ab Initio
• Strong development skills including the ability to work through entire development life cycle (SDLC) from gathering requirements through project implementation
• Experience with Ab Initio Co>Operating System, Application Tuning, Performance Enhancements and Debugging strategies.
• Well versed with various Ab Initio Parallelism techniques and implemented number of complex Ab Initio graphs using Data Parallelism and Multi File System (MFS) techniques
• Experience with Express>IT and Business Rules Engine
• Used Rational tools like Clear Case and Clear Quest for Defect/Change management and Ab Initio Enterprise Meta Environment (EME) for version controlling
• Hands on experience on complete Data Warehouse life cycle that includes writing Unix Shell custom/wrapper scripts, Stress Testing, Data Mining and Data Quality processes
• 13 Years of Senior level experience in writing Wrapper and UNIX shell scripts
• Experience working with databases like Oracle, Teradata, DB2, SQL Server, Sybase and PostgreSQL
• Excellent analytical, problem solving and business interaction skills with the ability to mentor and lead developers

TECHNICAL SKILLS

ETL TOOLS: AB INITIO (GDE 3.1.6.1/1.15.27/1.15.12/1.15.11.1/1.14.25/1.13.8.2/1.12.5.2/1.10.11/1.7.9 , CO>OPERATING SYSTEM 3.2.5.1/2.15.8.15/2.15.8/2.14.102/ 2.13. X/2.12.X/ 2.10.15/2.10 ), BRE, EXPRESS>IT, INFORMATICA 9.6/5.1

O/S: HP - UX B.10.20C, SVR4.2, NCR 3.X, SCO, WINDOWS 2000 FAMILY, NT 4.0, 95/98, NOVELL NETWARE, MS-DOS

DATABASE: ORACLE 7i/8i/9i/11g/12g, SQL SERVER 6.5/7.0, MS-ACCESS, DB 2 11 /9.5.4/5.0/6.0 , TERADATA V2R4/V2R5/12, Sybase ASE 11.5/12.5.2

OLAP TOOLS: BUSINESS OBJECTS 4.1.3/5.0/5.1/6.0 , CRYSTAL REPORTS 8.5/9.0, CRYSTAL ENTERPRISE 8.5/9.0.

DATA MODELING TOOLS: ERWIN 3.X/4.1, ORACLE DESIGNER 2000

ANALYSIS & DESIGN: STRUCTURED SYSTEMS ANALYSIS & DESIGN (SSAD) USING UML, VISUAL MODELING USING RATIONAL ROSE

SCRIPTING LANGUAGES: UNIX KORNE SHELL SCRIPT, JAVA SCRIPT

LANGUAGES: C, C++, SQL PLUS, PL/SQL, JAVA, PERL, SAS

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Senior Informatica Developer

Responsibilities:

• Develop several complex mappings in Informatica using various transformations, Mapping Parameters, Mapping Variables and Mapplets
• Develop workflows, used Worklets, tasks such as event waits, conditional flows, email and command
• Reusing the single workflow for loading data from various regional files with similar file structure using indirect loading as source type in session properties
• Expertise in Performance Tuning by identifying the bottlenecks Confidential sources, targets, transformations and session level.
• For SQL tuning: used techniques like Explain plans, Oracle hints re-designing the mappings
• Used Mapplets, Reusable transformations, Parameters and Variables to facilitate the reusability of Code
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions
• Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems
• Configured and scheduled Pre-and Post Session commands with Shell Scripts and invoked them using command task
• Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server
• Wrote stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes
• Developed Test Cases per Business and Technical Requirements and prepared SQL scripts to test data
• Performed unit test for Informatica mappings and workflows in both development and validation environments

Environment: Informatica Power Center 9.6, Oracle 11g, PL/SQL, SQL, SQL*LOADER, SQL Developer, Shell Scripting, UNIX Solaris8-SPARC-n32, DB2 Client 9.5.4/11, Control M enterprise manager 7.0.00, PostgreSQL Version 1.20.0, Microsoft Access 2010, TOAD data point 3.6, Core FTP Lite 2.2, HP ALM 11.0

Confidential, Herndon, VA

ABINITIO Designer & Developer

Responsibilities:

• Wrote application design document consisting of High level and detailed level designs
• Designed and developed Ab initio graphs and template graphs
• Entered metadata details into Oracle tables and executed them through autosys JIL
• Wrote Autosys Jil scripts and Wrapper scripts. Unit tested Ab Initio graphs
• Assisted in Business Testing, System Testing, UAT and Production

Environment: Ab Initio GDE (1.15.11.1) CO-OP (2.15.8.0), UNIX, Oracle 9.7.2, TOAD, Clear Case 7.0.1

Confidential, Memphis, TN

ABINITIO Designer & Developer

Responsibilities:

• Analyzed SQL and SAS scripts and converted them into Ab Initio Graphs
• Created High level design from existing SQL and SAS scripts
• Designed and developed graphs and wrote wrapper scripts
• Prepared test documentation and release notes to promote graphs to production

Environment: Ab Initio GDE (1.15.11.1) CO-OP (2.15.8.0), UNIX, Oracle 9.7.2, TOAD, Teradata 12, SAS 9.2

Confidential, Boston, MA

ABINITIO Lead Designer

Responsibilities:

• Designed and developed Ab initio graphs for the above mentioned projects
• Each application was unique in terms of design; Design Decision was based upon the source file, size and the frequency it arrives
• Unit tested the applications and extended a hand to production support
• Replaced source systems for state Street conversion project position, position lot and securities to glx0520 and dtl0520

Environment: Ab Initio GDE (1.14.25) CO-OP (2.14.102), UNIX (AIX), UDB2, BMC, ESP Scheduler 4

Confidential, Wall Street, NY

ABINITIO Team Lead

Responsibilities:

• Analyzed and documented the pre design process for Transaction Input and Payment Process modules of Oasys Financial
• Analyzed the existing C++ code and Stored procedures and documented functionality
• Wrote detailed ETL specs, Created High Level Design and designed flow charts
• After unit testing chunks of development code, advanced to integrated testing and promoted code to system testing. Wrote shell scripts

Environment: Ab Initio GDE (1.14.25) CO-OP (2.14.102), UNIX (AIX), Tarantella, Sybase ASE 12.5.2, Autosys 11

Confidential, Herndon, VA

ABINITIO Designer & Developer

Responsibilities:

• Worked closely with QA and UAT teams in resolving defects
• Worked on performance enhancements, tuning of the graphs and query optimization
• Wrote High level and Detailed level design and made the graphs prone to EPF standards
• Supported End-to-End testing and Full Volume Testing efforts
• Supported production support efforts on 24/7 basis and resolved defects in an efficient and timely manner.
• Wrote wrapper scripts, performed Smoke testing and ran scripts

Environment: Ab Initio GDE (1.13.13) Co-Op (2.13), UNIX, Teradata V2R4, Embarcadero Rapid SQL 7.3.3, Rational Clear Quest Version 2003.06.13.402.000 , Autosys 4.5

Confidential, Plano, TX

ABINITIO Team Lead

Responsibilities:

• Analyzed DTS Package code (Microsoft.NET) and documented its functionality
• Analyzed requirement details such as how to store, retrieve and load data in a data warehouse
• Extracted data from COBOL copy books into the ETL data mart
• Designed and developed graphs towards Batch Window Reduction
• Tested graphs to see if their runtime has improved compared to DTS Packages

Environment: Ab Initio GDE (1.12.8.2) Co-Op (2.12.x), Microsoft.NET, UNIX, Microsoft Visio 2003 pro, Teradata V2R4, Autosys 4.5, Mainframe

Confidential, Richmond, VA

ABINITIO Designer

Responsibilities:

• Worked on the data movement design, High level and Detailed level designs
• Wrote UNIX shell scripts, FTP scripts and wrapper scripts
• Developed graphs and documented design and development efforts
• Unit tested graphs and prepared mock data for testing purposes

Environment: Ab Initio GDE (1.12.8.2) Co-Op (2.12.x), UNIX, Microsoft Visio 2003 pro, Teradata V2R4

Confidential, Jacksonville, FL

ABINITIO Team Lead

Responsibilities:

• Performed business user interviews
• Designed, Developed and Unit tested data marts for data warehouse CAM
• Performed troubleshooting for errors in development and production environments

Environment: Ab Initio GDE (1.10.8) Co-Op (2.10.x), Autosys 3.3, UNIX, Microsoft Visual Source safe6.0, Erwin 4.0, Oracle 9i

Confidential, Long Island City, NY

ABINITIO Production Support

Responsibilities:

• Worked on Autosys job scheduling and monitoring
• Extended production support for 16 downstream systems
• Designed and Developed graphs for the Client wise data comparison between version 6.0 and version 7.0 of Seibel data. Wrote Unix shell scripts
• Unit tested the application and prepared technical documentation

Environment: Ab Initio GDE (1.10.8) Co-Op (2.10.14), TOAD 7.3, Autosys 3.3, UNIX, Microsoft Visual Source safe6.0, Erwin 4.0, INFOMAN, Oracle 9i

Confidential, Broomfield, CO

ETL Developer

Responsibilities:

• Used Ab Initio GDE for creating process flow diagrams, data unloads transformation and loading data into tables
• Implemented data parallelism using Ab Initio for ETL process
• Wrote UNIX Shell Scripts and wrapper scripts
• Worked with Teradata utilities like Fast Load, Multi Load to load data in to the Teradata Database and used Fast Export to retrieve data from Teradata sources

Environment: Ab Initio 1.12.5.2, EME, Business objects Suite 5.1, UNIX, Oracle 9i, Teradata V2 R4, ERWIN 4.1.4

Confidential, Rockville, MD

INFORMATICA Developer

Responsibilities:

• Worked with the Informatica tools such as Source Analyzer, Data warehouse designer, Mapping, Designer, Mapplet Designer and Transformation Developer
• Created and monitored batches and sessions using Informatica Server Manager
• Created test plans and test scenarios. Scheduled sessions for source and target systems
• Created Drill down reports, Sub reports and Cross-tab reports in report designer

Environment: Crystal Reports 8.5, Erwin 3.x, Informatica Power Center 5.1, Oracle 8i, DB2 7, and Windows NT.

Confidential, Middletown, NJ

C/C++ Developer

Responsibilities:

• Designed and developed new classes and established relation between the classes thus promoting Multi Inheritance
• Wrote stored procedures and triggers
• Wrote UNIX Shell Scripts

Environment: C, C++, UNIX (Sun Solaris 2.x), Sybase ASE 11.5, SOAP 1.1

Confidential

C/C++/UNIX Developer

Responsibilities:

• Created Class Libraries, used Pointers and Type Casting in C. Developed code using C++
• Wrote cursors, stored procedures and triggers using Oracle
• Wrote UNIX Shell script to generate a report once in every 2 hours using CRON

Environment: C, C++, Sun UNIX, Java JDK1.2, AWT/HTML, Oracle 7i, ADO, CRON, PERL5