SUMMARY:

• Over 7+ years of systems development experience, with specialized experience in large Data warehouse systems, processes, and techniques.
• Experience in utilizing Ab Initio in the high - level design and deployment of full lifecycle terabyte-sized data warehouses.
• Had been responsible for merging the data/business of two business units of its global client. It also involves the conversion and loading of 3 years of customer level data into the target Data Mart and systems.
• A proactive approach to problem solving, taking ownership of issues & having the determination to follow things through.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Developed ETL mappings from source systems to target database using Ab Initio. Seasoned in data warehousing, data modeling, data marts, data migration and data analysis.
• Experience in Data Warehousing, ETL methodologies, technologies, using INFORMATICA and Ab initio.
• Vast experience in work environment with a mix of onsite-offshore Global Delivery model.
• Worked with Teradata and building Data warehouse/Data mart application worked with writing the complex queries using SQL assistant.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Experience in high level and detail designing
• Strong PL/SQL and SQL programming skills in database develop life cycle.
• Involved in developing Detailed or Low level design documents
• Involved in Source target mapping documents for the ETL process.
• Participated in development of detailed technical design for Account Build/Maintenance Service.
• Good Experience on preparing the Data mapping, Technical, Design and Support documents.
• Good experience on working as on-site co-coordinator and guiding offshore in right manner to complete the assigned tasks.

TECHNICAL SKILLS:

Methodologies: Object Oriented Design and Analysis, STAR & SNOWFLAKE modeling, Multi-tier Application Design, Reverse Engineering.

Ab: Initio GDE 1.13/CO>OS 2.13, GDE 1.15//CO>OS 2.15, GDE 3.1.1//CO>OS 3.1.4.5, GDE 3.1.7//CO>OS 3.1.6.3, Informatica Power Center 6.x, Informatica PowerMart 5.x.

BI Tools: Micro strategy, Business Objects 6.0/5.x (Designer, Supervisor, WEBI 6.1), Cognos.

Database & Tools: Oracle 9i/8i/7.x, Teradata V2R12/V2R13, MY-SQL and SQL Server 6.5/7.0/2008 Erwin 4.0

Application Servers: Oracle Application server, BEA Web logic 7.0, IBM Web sphere, IIS.

GUI: VisualBasic5.0/6.0, Developer 2000

Java: RMI, JDBC, JavaScript, VBScript, C, C ++, SQL, PL/SQL, ASP 2.0, HTML, XML

Operating Systems: SUN Solaris 8x, HP 11i, Linux, Windows XP/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Ab Initio Developer

Responsibilities:

• Closely working with the Subject Matter Experts (SME’s) for the Analysis, Design on Functional documents.
• Coordinating with source system owners.
• Involved in full life cycle for the project, Design, data Modelling, Requirements gathering
• Seasoned in data warehousing, data modeling, data marts, data migration and data analysis.
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Enforce standards and best practices around data modeling efforts.
• Ensure data warehouse and data mart designs efficiently support BI and end user
• Involved in Design, Development, testing and implementation using ETL AB initio.
• Created generic graphs to read multiple source Data from Hadoop Data Lake.
• Providing oversight and technical guidance for developers on Ab Initio.
• Lead the team with possible solutions in critical situation.
• Produced the required documents like Mapping Documents, Design Documents, and Use Case Documents.

Environment: Ab Initio (GDE 3.1.7, Co>OS 3.1.6.3Erwin 9.6, SQL Developer, Oracle 10G.

Confidential, Indianapolis, IN

Ab Initio Developer/Principal Data Analyst

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Responsible for translating technical design documents into detail design documents using skill sets like Ab Initio graph detail design/development/unit testing.
• Hands on experience with Meta data management (MDM) to build enterprise level Database.
• Designed Ab initio mappings by translating the business requirements.
• Lead the team with possible solutions in critical situation.
• Provided oversight and technical guidance for developers on Ab Initio.
• Work with the PMO team to provide regular update and adjust the time lines if necessary.
• Developed Tasks to integrate MDM into enterprise data.
• Used MDM process to create customer id’s across enterprise process.
• Experience working with Ab Initio Metadata Hub, administered in upgrading the data store and maintenance of the portal.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Worked on loading of data from several flat files sources to staging area using Teradata MLOAD, FLOAD and FASTEXPORT.
• Involved in the design, development and testing of the BTEQ, packages for the ETL processes.
• Good experience on working as on-site co-coordinator and guiding offshore in right manner to complete the assigned tasks.

Environment: Ab Initio (GDE 3.1.7, Co>OS 3.1.6.3), CONDUCT>IT, Teradata, AIX, KSH Scripting, Control-M.

Confidential, Irvine, California

Sr. Ab Initio Developer/ Principal Data Analyst

Responsibilities:

• Involved in Gathering the requirements for technical design, mappings and development.
• Involved in data analysis to identify the end to end flow issues.
• Closely worked with the SME’s for the Analysis, Design on Functional documents.
• Extensively used Partition by Key, Partition by Expression/ Round Robin, Filter by Expression, Sort, Reformat, Gather, Merge, Redefine, Replicate, Scan, Rollup, Join, Dedupsort, Normalize, Leading records and all type of dataset components to develop the ETL transformation logic.
• Involved in all the stages of SDLC during the projects
• Good hands on processing mainframe (MVS) files.
• Created the automated jobs using Operational console.
• Created the reports on the mainframe for source data validations.
• Used DB2 load utilities to load the data from different sources like MVS, UNIX files.
• Created the validation graphs to validate the source data.
• Generated reports using Ab Initio for the business users.
• Created generic graphs to generate external extracts for different users.
• Creating Graph level and Project level parameters according to the requirements or psets.
• Created CONDUCT-IT Plans to combine multiple graphs and support to Op Console jobs.
• Created test cases and data validation for Unit, System and Integration testing.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Created Oracle PL/SQL queries and Stored Procedures.
• Worked on data loads using Oracle PL/SQL and SQL*Loader.
• Deeply involved to support QA/UAT testing.
• Provided Production Support for the initial release of the project. Worked on production support in monitoring the jobs and took corrective action based on the job status.

Environment: Ab Initio (GDE 3.1.1, Co>OS 3.1.4.5), CONDUCT>IT, Ops-Console, MVS, Linux, KSH Scripting, Distributed DB2, Oracle.

Confidential, Pennington, NJ

Ab Initio Developer

Responsibilities:

• Involved In different modules of Enterprise data warehousing, Supply chain and .com projects
• Involved as a Business Analyst interacted with product and Technical Managers of the Source systems and came with Business transformation logic.
• Involved in Design, Development, Testing, Documentation and Implementation of the project.
• Involved in full life cycle for the various projects, Design, data Modelling, Requirements gathering, Unit/QA testing and production.
• Onsite co-coordinator - offshore team communication.
• Lead the team to complete the assigned Modules.
• Designed and developed mapping, transformation logic and processes in Abinitio for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Designed and Created complex graphs using Abinitio.
• Extensively used Partition by Key & Sort, Partition by Expression/ Round Robin, Filter by Expression, Sort, Reformat, Gather, Merge, Redefine, Replicate, Scan, Rollup, Join, Deformalize, Sort, Dedupsort, Normalize and all type of dataset components to develop the ETL transformation logic.
• Design Parallel Partitioned Ab Initio graphs using GDE Components for high volume data warehouse
• Worked with continuous components and XML components.
• Testing the graphs for performance. Performance improvement measures included the use of the Multi file system, Lookups, Max-core, In-Memory Joins and parallelism techniques for maximum usage of cache memory.
• Write and modify several application specific Config scripts in UNIX in order to pass the Environment variables.
• Generate SQL queries for data verification and backend testing.
• Involved in writing several Teradata BTEQ scripts to implement the business logic.
• Hands on experience with Teradata Sql Assistant to interface with the Teradata.
• Worked on production support in monitoring the jobs and took corrective action based on the job status.
• Worked extensively in UNIX environment creating Korn shell scripts in order to support Abinitio Graphs.

Environment: Ab Initio (GDE 1.15.1, Co>OS 2.15.115), Plan>IT, UNIX, KSH Scripting, DB2 9.5, Redhat Linux, Maestro Scheduler, Teradata V2R13.1.

Confidential

Ab initio Developer

• Worked in the Transport Management System (TMSV2) project for new enhancement.
• Analysis of the Specification provided by the client.
• Produced the required documents like Mapping Documents, Design Documents, and Use Case Documents.
• Creating the. dbc files for the Development, Testing and Production Environments.
• Involved in Source target mapping documents for the ETL process.
• Converted High level design documents to Low level design documents and developed Process flows. .
• Creating Graph level and Project level parameters according to the requirements or psets.
• Graphs are generated using Ab Initio components like Reformat, Join, Redefine Format, Sort, De Normalize, Input Table, Output Table, Update Table, Gather Logs, Run SQL, Write XML, Filter By Expression, Write Multiple Files and Custom components (FDQ Component) .
• Created continuous flows to crate purchase orders, load into DB2 tables.
• Extensively used continuous flow components.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Developed number of AbInitio Graphs based on business requirements using various AbInitio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, Broadcast, merge etc.
• Worked with continuous flow components and XML components.
• Good hands on migrating codes to QA and Production.
• Interacted with all teams like Business Analyst, Development Team, Testing Team, Configuration Management Team and Project Management.
• Performance and Tuning and Recovery issues with Oracle Database

Environment: Ab Initio (GDE 1.15.1, Co>OS 2.15.115), UNIX, KSH Scripting, DB2 9.5, AIX version 5.