SUMMARY

• 8+ Plus Years of experience in BI as Team Member / Team Lead and involved in the entire SDLC i.e. Understand and Analyze the Project Requirements/Functional Specifications by interacting with Business and IS/IT Managers, Project Planning, Design (Logical and Physical), Development, Testing, Implementation and Maintenance of various DW/DM’s and Client/Server applications under Unix/Windows Environments. Also includes effective communication/co - ordination with in the team and Product managers/Business and strict Process Adherence (CMM)
• Developed several Ab Initio applications for Extraction, Transformation, Cleansing and Loading into Data Warehouse/Data mart. Used Ab Initio with Very Large Database Systems (VLDB) that are Massively Parallel (MPP) by utilizing the concepts of Multi files, Continuous Components, Partitioning and De partitioning components etc and various built in functions (substring, lookup…) and fine tune the applications for optimal performance.
• Sound knowledge in EME (Check In, Check Out), Dependency Analysis and Sand-Box/Project parameters, also experience with air commands
• Expertise in developing Korn Shell Scripts and AWK scripts for ETL Process Automation and Capacity Planning, File Retention Management, Control Database etc.
• Extensively used Ab Initio data profiler for analyzing quality of enterprise master data.
• Exposure to SQL*Loader, Export & Import Utilities, SQL, PL/SQL and Tuning Oracle SQL.
• Strong in coding SQL,PL/SQL,T-SQL,Stored Procedures and Triggers in PL/SQL
• Experience with Oracle Partitioning Methods (Exchange and Range), Materialized views, and Oracle Optimization.
• Sound knowledge of Teradata Architecture and hands on in writing Teradata SQL’s, Macro’s, Tuning Teradata DB queries and making use of Teradata utilities like, Fast Load, Fast Export, Multi Load.
• Hands on experience on Ab Initio performance tuning and optimization.
• Extensive experience in Data migration and production support activities.
• Sound Knowledge of Data Warehouse/Data Mart/ODS & Data Modeling Techniques.
• Demonstrated ability in grasping new concepts (Both Technical & Business) and utilize them as needed.
• Highly motivated team player with strong communication, organizational and analytical skills and with a passion to work in challenging environment and adaptable to varying circumstances.
• Hands o experience on development of Ab Initio GDE complex graphs for data loading and data validation and data profiling
• Hands on experience working on tools like Ab Initio data profiler for analyzing quality of complex master data
• Good knowledge on master data management, data quality and data

TECHNICAL SKILLS

Database: Oracle(11g,10g,9i,8i), Teradata, sql server,DB2

ETL Tools: Ab Initio GDE 3.1.3, 3.1.0, 1.15, Informatica

Data Profiling: Ab Initio data profiler 3.0.4,3.1.3

Language: SQL, PL/SQL, BTEQ Scripts, Unix Shell/AWK Programming

Operating System: UNIX, Linux, Windows 2000/NT

Testing Tools: HP quality center, Test director

Dev Tools: SQL developer, Toad

Design Tools: Erwin, Microsoft Visio

Reporting Tools: Business Objects, Crystal reports,SSRS

Other Tools: Winscp, Hyperion Essbase, Office Suite2000/03/07,MS project, Confidential clear case, Remedy

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Ab Initio Technical Analyst

Responsibilities:

• Involved in the requirements definition and analysis in support of the extensive data analysis.
• Designed the IDD document by analyzing the SRS and Mapping documents.
• Developed Ab Initio Graphs as per detail design document.
• Developed complex Ab Initio XFRs to solve various business requirements.
• Worked on critical production defects related to climes processing using Ab initio analytical skills.
• As a member of production support team involved in building solution for defects and deploying fixes in to production.
• Involved in daily business delta load in to production systems and generated data load reports for business using Ab initio.
• Extensively used Unix for migration of code and data fixes in to production system
• Also used Ab Initio Partition and Departition components to enable Parallelism.
• Profiled enterprise master data using Ab Initio data profiler for data quality and data loading.
• Extensively used Ab Initio data profiler for physical elements conformity, validity and completeness of source data.
• Used string like functions for comparing enterprise master data for better matching of customer demographic data.
• Used quick profile techniques in GDE for data sets and physical element analysis (like column width as per mapping specifications).
• Redesigned existing graphs to bring down processing time.
• Designed and developed complex graphs in Ab Initio using Graphical Development Environment (GDE).
• Used the conditional components during graph development and built conditional DMLs.
• Worked on peer reviews and code reviews after development.
• Developed a process to execute graphs/scripts in serial or parallel mode with full restartability.
• Developed generic graphs using psets to minimize development and maintenance costs.
• Process tuned existing Ab Initio processes for efficiency using parallel components, lookup files and MFS concepts.
• Performance tuning of Ab Initio ETL graphs and processes using various parallelism techniques, proper memory usage, planned phasing and layout.
• Developed Korn shell scripts for file processing.
• Developed various Ab Initio graphs for data cleansing using Ab Initio functions like is valid, is error, is defined, string trim, and string concat functions.
• Involved in the migration of data files to load into oracle.
• Created the Test Cases on various forms of the application.
• Did the Unit Testing of newly developed graphs.
• Check in/Check Out existing applications Using EME in order to perform the necessary modifications
• Used different EME air commands in project promotion like air tag create, air save, air load, air project export etc.

Environment: Ab Initio GDE 3.1.3,3.0.5.2, Ab Initio Data Profiler 3.0.4.1,3.1.3,DB2 Oracle, Teradata, XML,UNIX, UNIX Korn Shell, Windows XP

Confidential, Irving, TX

Ab Initio Analyst

Responsibilities:

• Understanding and analyzing the Data Model and Technical Specifications document.
• Setting up the Sand box, Sandbox Parameters and Graph Parameters.
• Created data sets for staging the temp data before loading into oracle partitioned tables.
• Profiled enterprise master data using Ab Initio data profiler for data quality and data loading.
• Extensively used Ab Initio ETL tool to create graphs that Extract data from diverse source systems, transform it and finally load it into target oracle tables by making use of components like Lookup, Reformat, Redefine format, Filter by Expression, Join, Sort, Dedup Sorted, Run SQL, Phases, Checkpoints, Multi files, Partitioning and De-partition components that make the graphs run parallel.
• Extensively used Ab Initio data profiler for physical elements conformity, validity and completeness of source data.
• Used string like functions for comparing enterprise master data for better matching of customer demographic data.
• Used quick profile techniques in GDE for data sets and physical element analysis (like column width as per mapping specifications).
• Extensively used HP quality center and info man for defects raising problem solving virtual tickets.
• Involved in the design of graphs for migration of components to the higher Ab Initio versions.
• Involved in production support activities for data load and data analysis requests.
• Performed extraction of data from Teradata and oracle and flat files for preparing test data for various projects using Ab Initio graphs.
• Testing and tuning the Ab Initio graphs and Oracle SQL’s for better performance.
• Performing the unit testing and organizing the peer reviews at the end of each application.
• Developing the Korn Shell scripts for wrapper automation of ETL by taking care of the exception-handling
• Preparing the implementation plan for Production team to carry out the tasks one by one on Production DB.
• Involved in the optimization of graphs for better performance.
• Worked as production support for delta loads and ETL deployment bug fixes.
• Configured/Scheduled the Ab Initio graphs using Tivoli scheduling tool.
• Support/Maintenance during the stabilization phase (moving to production).
• Worked on complex Ab Initio graphs for master data profiling and data analysis for better data quality.
• Worked closely with MDM and ESB teams for real time updates.
• Developed generic graphs and created DMLs for various files.
• Involved in loading Confidential info sphere model transactional model for enterprise master data view for data standardization to store various business units in to tables.
• Performed extensive Backend Testing using SQL .
• Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis.

Environment: Ab Initio GDE 3.1.3,3.0.5.2, Ab Initio Data Profiler 3.0.4.1,3.1.3, Oracle 10g, 11i, Teradata 13.0,Unix, HP Quality center10.0, IBMclearcase7.0.1,PLSQL,Windows,XML, Excel, Access, Visio, winSCP,Remedy.

Confidential, IL

Ab Initio Developer

Responsibilities:

• Involved in analyzing scope of application, defining relationship within the groups of data.
• Made the design decision regarding usage of various Ab Initio components by keeping the performance and efficiency into priority consideration.
• Used Components container of Ab Initio to extract and transfer the data from multiple operational data sources to destination data marts in Oracle.
• Designed data transformation from Transient to Staging Fact and Dimension Tables to Warehouse.
• Enhanced PLSQL store procedures for data loading and demographic update of enterprise master data.
• Extensively used various Ab Initio components like Reformat, Input file, Output file, Join, Sort, Normalize, Input Table, Output Table, Loads Table, Fuse, Update DB, Gather Logs and Run DB Sql for developing graphs.
• Expertise in generating various Ab Initio functions for data profiling an data transformation and data loading.
• Used various Ab Initio built-in Transform components like Rollup, Aggregate, Reformat, Scan, Join to implement the business rules.
• Used component parallelism, Pipe line parallelism techniques while generating complex graphs.
• Expert in using de-partitioning and partitioning components according to requirements.
• Expert in generating graphs according to the logic transformation by the business rules.
• Generated Configuration files (.CFG) using Korn Shell Script.
• Expert in Creating DMLs by specifying the Record format with delimiters for building graphs in Ab Initio.
• Experience in Teradata RDBMS using Fast Load, Fast Export, Multi Load, T Pump, Teradata SQL Assistance and BTEQ Teradata utilities
• Involved in various production support activities for data quality and data loading issues.
• Written Unix Shell Scripts to load data from different sources.
• Expert in writing complex Sql and Plsql for data profiling and data loading requirements .
• Responsible for creating test cases for to make sure the data originating from source is making into target properly in the right format.

Environment: Ab Initio(GDE1.13),Oracle,teradata,MSaccess,Erwin3.5.2,SQL,PLSQL,SQL*Loader,Solaries8unix shell scripts, windows, Hp quality center.

Confidential, VA

Ab Initio Developer

Responsibilities:

• Preparing the vision scope document and the deck for project kickoff.
• Preparing the technical specification document by interacting with the dev lead.
• Setting up the development environment for the project by coordinating with the onsite team.
• Involved in development and production support activities for various LOB across the bank.
• Setting up the sandbox environment for the project.
• Creating/Modifying Stored Procedures and Packages for data extraction and loading that are owned and controlled by another portfolio and loading the relevant data into DDW.
• Developing the parameterized Ab Initio graphs for load process by using components like Lookup, Reformat, Replicate, Filter by Expression, Normalize, Join, Gather, Run SQL….
• Creating the continuously enabled graphs with the use of Queues and Multi Files.
• Created all the necessary tables/views, BTEQ scripts, Macros in Teradata.
• Prepared the test plan, test cases and tracking the defects using Hp Quality Center.
• Creating the wrapper (Korn Shell) scripts for loading data to the development environment.
• Involved in End-to-End data validation with the Business.
• Configured/Scheduled the Ab Initio graphs, shell scripts using Control-M scheduling tool.

Environment: Ab Initio 1.11.16.2, Oracle 9i/10g, PL/SQL, Teradata V2R5 and Teradata Utilities (Query man, BTEQ), Shell Scripting, Red Hat Linux, Control M Scheduler, Hp quality center, Micro Soft Visio