SUMMARY

• Over 7 years of experience in Information Technology, having in - depth knowledge in Analysis, Design, Development, Testing and Production/Maintenance of Client/Server (OLTP) and Data Warehouse Applications.
• Having 6+ years of experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio for full life cycle development in building a data warehouse.
• Expertise in all phases of the Software Development Life Cycle(SDLC), including project definition, analysis, design, coding, testing, implementation and support.
• Extensive experience in Data Modeling, Database Design and Development as Developer/Analyst using Oracle(8i/9i/10g), DB2 UDB, SQL, PL/SQL Procedures/Functions and Packages.
• Extensively worked in Data Warehousing concepts, Dimensional modeling like Star Schema and Snowflake Schema.
• Specialized in ETL methodology for supporting Data Analysis, Extraction, Transformations and Loading, in a corporate-wide-ETL Solution using Ab Initio.
• Strong experience in Ab Initio GDE, CO>operating System. Created complex Ab Initio graphs for data processing, data migration and data analyzing purpose.
• Experience in using EME for version control.
• Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs in Ab Initio and also experience with Ab Initio Co-operating System in application tuning and debugging strategies.
• Developed several Ab Initio complex graphs for transforming, cleansing & loading Data marts.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Component Parallelism, Pipeline Parallelism, Data parallelism and Multi File System (MFS) techniques.
• Strong experience in writing conditional DML for vector type records and DML for COBOL copy book, Excel and XML files.
• Extensively used Utility commands, Air commands and environmental parameters to access information in the EME repository.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory sort in joins and rollups to speed up various Ab Initio graphs and optimum maxcore parameter for memory optimization.
• Strong working experience in Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMon), UNIX scripting, PL/SQL, SQL, SQL*Plus, SQL*Loader, Bulk Copy (BCP), Stored Procedures, Functions, Packages.
• Extensive experience in writing efficient and well tuned SQL Queries and UNIX Scripts (K-Shell).
• Involved in production support (24/7) for data warehouse. And also supported reporting.
• Experience in handling the hierarchical data.
• Unique ability to understand and long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills.
• Got trained and certified in MongoDb from coursera.org
• Got trained in Qlik View in order to perform basic defect analysis.

TECHNICAL SKILLS:

Operating Systems: UNIX (Sun Solaris, HPUX 10), WINDOWS 98/NT/2000/XP/Vista

Database Management Systems: Teradata, Oracle(11g,10g, 9i), DB2-UDB, SQL Server (2000, 2005, 2008), MS ACCESS

Programming Languages: C, C++, SQL, PL/SOL, UNIX Shell Scripting

ETL Tools: AB INITIO (Co-Operating System 2.15/2.14, GDE 3.04/1.15/1.14 , EME), Continuous Flows

Reporting Tools: COGNOS, QlikView

Utilities: AUTOSYS, PLAN

PROFESSIONAL EXPERIENCE

Confidential, Berkeley Heights, NJ

Ab Initio Developer

RESPONSIBILITIES:

• Working in all phases of the Software Development Life Cycle (SDLC), including project definition, analysis, design, coding, testing, implementation and support.
• Working in ETL methodology for supporting Data Analysis, Extraction, Transformations and Loading, in a corporate - wide-ETL Solution using Ab Initio.
• Understanding the requirements of the end users/business analyst, reviewing the business specs and developing strategies for ETL Process.
• Working with various heterogeneous systems like Oracle, SQL Server, DB2 and Flat Files.
• Participating in requirement meeting with the business analysts and ETL Architect to understand source and data warehouse model and cleansing/transformation rules.
• Indentifying various scenarios and assessing the data related to those.
• Conducting required source system analysis and data availability audit.
• Extract applicable data from source systems, including Domestic and International, into a prototype repository.
• Carrying out Code Walkthrough and Review of Testing.
• Using data extract analysis to supplement understanding of data completeness and accuracy.
• Preparing and continuously improving the Low Level Design Documents, High Level Design Documents, and Run books for the project.
• Working in an AGILE model, continuously improving the business specs.
• Evaluating the new requirements and also performing the impact analysis.
• Working in team and coordinating with everyone in the group for suggestions and improvements in the project.
• Perform Root Cause analysis for User requests.
• Created a robust FrameWork, using stored procedures and shell scripts, which articulate the whole ETL Process.
• Created a unique archival mechanism in this process which handles the ETL Archival Process.

Environment: Ab Initio GDE 3.0.4.1, Co>Operating System 3.0.3.9, AUTOSYS, UNIX, Oracle 11g, SQL developer, DB2 and SQL Server.

Confidential, Memphis, TN

Ab Initio Developer

Responsibilities:

• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Involved as designer and developer for BCR Raceway project.
• Followed the Scrum or Agile methodology in the development phase of the project.
• Extensively worked on the P-sets.
• Involved in preparing the Mapping specification document.
• Automated the development of Ab initio graphs and functions utilizing the Meta data from EME.
• Extensively involved in writing SQL queries (Sub queries and Join conditions) and anonymous PL/SQL blocks to test various business rules.
• Created the wrapper scripts for various business cases.
• Developed various Ab Initio transformation graphs based on the business requirements.
• Worked with the third party companies, Acxiom and Epsilon, to improve the data availability.
• Has used AUTOSYS for scheduling jobs in Development Environment.
• Prepared detailed documents for the completed and well-reviewed graphs.
• Worked with the QA, UAT and PROD support teams to resolve the incident tickets during the initial phase of support.

Environment: Ab Initio GDE 1.15.9, Co>Operating System 2.15.9, AUTOSYS, UNIX, windows, TERADATA, Teradata SQL Assistant v2r6, Oracle, SQL developer.

Confidential, Herndon, VA

Ab Initio Developer

Responsibilities:

• Involved in analyzing business needs and document functional and technical specifications based upon user requirements with extensive interactions with business users.
• Development of source data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Created the minispecs for different applications.
• Making automate the development of Ab initio graphs and functions utilizing the Meta data from EME.
• Performing transformations of source data with transform components in Ab initio
• Wide usage of lookup files while getting data from multiple sources and size of the data is limited.
• Involved in project promotion from development to UAT and UAT to production.
• Involved inProduction implementationbest practices.
• Used different EME air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: Ab Initio GDE 1.15.7, Co>Operating System 2.15.7, Control M, UNIX, windows, Oracle, DB2, SQL Server.

Confidential, Westbrook, ME

Ab Initio Developer

Responsibilities:

• Created Ab-Initio graphs to load large volume of data.
• Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions and tested various graphs for their functionalities.
• Involved in writing low level design documents.
• Mentor for junior developers.
• Developed Jobs and used Ab-Initio as an ETL tool to load the final loads.
• The project is to centralize the reporting system, previously used a hard coded program.
• Wrote several SQL* loader programs to load small loads into temporary tables for the data, which may be required to move among different Unix servers and databases while the program is running.
• Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify the functional, data quality, performance of graphs.
• Documentation of complete graphs and its components.
• Created unit test cases to identify the failure points.
• Also involved in the production support.

Environment: Ab Initio GDE1.14, Co-Op 2.14, UNIX, windows, PL/SQL, Oracle 9i