SUMMARY:

• Over 10 years of experience in IT industry wif over 7 years as Data warehouse Developer
• Strong experience in Ab Initio and its product suite.
• Strong experience in UNIX, EME, Metadata management
• Expertise in setting up Ab Initio ETL environment and migration scripts
• Strong Ability to handle tasks simultaneously and work in multiple / multi - functional projects.
• Experienced in all phases of teh Systems Life Cycle, including project definition, analysis, design, coding, testing, implementation and support.
• Experience includes wif reporting tools like Cognos, Business Objects, Crystal Reports
• Demonstrated competency in implementing business intelligence and data warehousing solutions for diverse industries.
• Experienced wif reading data from different databases like DB2, SQL server, Oralce, Mainframe.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Abinitio Developer

Responsibilities:

• Worked as Designer to create Data flow processes between source à target
• Used Abinitio suite of products like GDE, CO
• Worked wif Cognos reporting tool to deliver reports for management.
• Expertise in analyzing requirements and converting them into implementation units for ETL design process.
• Involved in Designing teh ETL process and implementing wif Ab Initio.
• Identified and designed high level ETL Dataflow diagrams.
• Designed Generic graphs dat dynamically switch to different behavior based on formal arguments.
• Created PSETS for Generic graphs for Reposit tracking of run-time statistics.
• Worked on complex copybooks to generate DML dat is conditional and nested.
• Designed and developed Generic UC (Universal cleansing) graphs dat systematically clean source data.
• Created projects and common project parameters used between applications.
• Migrated code between development and testing environments.
• Performed Dependency analysis and fix code/environment issues accordingly.
• Fine tune graphs for maximum performance utilizing parallel features of multi-file system.
• Perform general Database administrative tasks.

Environment: GDE v1.13.13, Co- OP v2.13.1 built on AIX, EME, Teradata, DB2, Oracle, Clear case, Cognos, Crystal reports

Confidential

Ab Initio Developer

Responsibilities:

• Expertise in Designing ETL process and Data Flow Diagrams
• Expertise in coding ETL process using Ab Initio
• Expertise in Developing graphs to read mainframe Tapes and DASD. Generate complex DML using copybooks.
• Created complex graphs dat implement complex Business Process Rules. Used new and advanced components.
• Expertise in accessing sources like DB2, Oracle and UDB (Datawarehouse platform)
• Expertise in handling huge terabyte data files and loading teh data to UDB
• Expertise in SQL coding and fine tuning graphs for high performance
• Expertise in writing Unix /PERL scripts

Environment: Ab initio1.11.12, co-op 2.11, Unix AIX, PERL, Oracle 9, Control-M, DB2, Oracle, SAS, Crystal reports

Confidential

Ab Initio Developer

Responsibilities:

• Establish teh data warehouse (GEM II and QRTZ II) as a central repository of BOCS data.
• Build analytical and operational infrastructures to support noledge-based work
• Establish teh data warehouse as teh information hub for a future CRM architecture
• Build a high-performance data warehouse using Ab Initio dat offers high availability and scalability to meet teh growth objectives of BOCS
• Build a data warehouse using Ab Initio dat provides high data quality and accurate metadata.
• Convert teh Data from FDR system to TYSYs system Using Ab Inito as ETL tool.
• Involved in interacting wif all functional heads of teh different departments and End-Users on regular basis to gather teh exact requirements for their use.
• Based on teh requirements, creating teh System Design Document (SDD)
• Involved in extracting teh legacy database (DB2) to teh Oracle8i using AbInitio.
• Developed Ab Initio ETL process for Dimension and Fact tables loading and interpret teh transformation rules for all target data objects and develop teh software components to support teh transformation as well as estimating task duration.
• Developed teh graphs to meet teh Cleansing and Transformation process using all teh Transform Components.
• Developed graph’s using data, component and pipeline parallelism.
• Used Ab Initio GDE to create Fact tables using Transform components such as Rollup, Reformat, Join and Partition components such as Partition by Key and Partition by Round robin and Departition components such as Gather and Merge.
• Responsible for deduping and consolidating customer records from various sources to create master customer list
• Prepared and implemented data verification for teh Data Warehouse as well as to design and implement data staging methods and stress testing of ETL routines to make sure dat they don’t break on heavy loads.
• Involved in generating teh Metadata for teh Input port of an Input table component
• Deploy graphs on to teh test staging area and schedule batch jobs
• Used Ab Initio to create Summary tables using Rollup components.

Environment: Ab initio1.11.12, co-op 2.11, Unix, PERL, Oracle 8i, Red Bricks, AutoSys, LBMS Methodology, DATA STAGE

Confidential

Sr. Java Developer

Responsibilities:

• Involved in developing Java XML, XML Java Conversion efforts
• Developed and Maintained JSP, Java Script code.
• Involved in creating and changing properties.
• Used sql statements to update,insert and add new properties.
• Involved in developing teh application using teh EJB, Servlets.
• Developed numerous Enterprise Java Beans for teh application.
• Extensive hands on Java Web Server and Web Logic 3.5
• Involved in design and deployment of Distributed Components.
• Created stored procedures.

Software: Java 1.0, Servlets, EJB 1.1, Oracle 8.0, Web-Logic Tengah 3.5