SUMMARY

• Over 7 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing, Reporting and Software Applications.
• Over 7 years of Exclusive Experience in Ab Initio (GDE, Co>operating system).
• Expertise in ETL tools using Ab Initio (GDE, Co>operating system), DataStage and SQL Loader for data migration to Enterprise Data Warehouse.
• 3+ years of strong Teradata along with SQL Assistant and BTEQ experience. Solid skills and expert knowledge of Teradata version 2R5.x/6.x/13.x and utilities including TPUMP, MLOAD, FASTLOAD and FASTXPORT.
• Thorough knowledge in EME, check - ins, checkouts, command line interface, air commands and Dependency analysis.
• Hands on experience on analyzing data, data lineage and impact analysis using Metadata Hub.
• Administered management group settings to generate and view reports using Operations Console.
• Experience in Ab Initio EME/Sandbox to implement version control and impact analysis to manage various project across the organization.
• Excellent knowledge on Business Rule Engine (BRE) and Application Configuration Environment (ACE).
• Expertise in Rational Unified Process (RUP) Best Practices methodology and use Cases
• Extensive experience on developing Ab Initio Batch and Continuous Flow applications.
• Worked with MFS file system to implement MPP architecture for ETL process using Ab Initio tool.
• Performance tuning the complex Ab Initio graph, worked with tuning the memory parameter and Ab Initio best practice approach to implement the ETL process
• Worked in PVCS and EME Data store for source control maintenance and analyzing dependencies within and between various graphs.
• Ability to demonstrate command and use of industry accepted Ab Initio best practices and have completed terabyte level solutions preferably at multiple separate environments
• Worked extensively in the GDE (Graphical Development Environment) configuring, connecting, and testing the components to produce executable flow graphs on UNIX environment, Proficient with various Ab Initio Data Cleansing, Parallelism, and Transformation and Multi File System techniques.
• Thorough knowledge of DML (Data Manipulation Language), Unix Shell scripting (Korn and Bourne).
• Developed various UNIX shell wrappers to run Ab Initio and Data base jobs. Practical experience with working on multiple environments like production, development, testing.
• Excellent knowledge in Batch Jobs using UNIX CRON, AWK, UNIX Shell Script (csh, bash, ksh).
• Designed/Created several Multiload / Fastload scripts to load the staging/target tables Configured Ab Initio environment to connect to the Teradata database using db config, Input Table and Output Table Components.
• Strong skills in defining and implementing solutions, tools, processes and procedures to provide enterprise data integration and ETL services that meet business requirements
• Knowledgeable/experienced in data warehousing Teradata utilities & MS Reporting, over 3 years experience in analysis, design, and development of SQL Server Working knowledge of RMI, CORBA and IDL generation and mapping Servlets, JSP, and web tools like HTML, Java script, VB Script, Perl and ASP for java language.
• Conceptualized and implemented p-sets. Generic graphs and other ab-initio best practices.
• Migrated the code between repositories across different environments DEV/QA/Prod .
• Excellent Knowledge of Business Intelligence and Data Warehousing Concepts.
• Worked extensively on Business Objects, Crystal Reports, Oracle and MS SQL Server.
• Good Experience in Analysis and Design of Logical and Physical Database Models by using Erwin tool and good understanding of Data Modeling Methodologies Star Schema and Snowflake Schema.
• Good Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Teradata, DB2 UDB, Flat files and Legacy Systems.
• Proficient in designing and developing database applications using Visual Basic as front-end and RDBMS (SQL Server, MS-Access, and Oracle) as backend using ADO, DAO and RDO objects.
• Proficient in writing Stored Procedures, User Defined Functions and Triggers using T-SQL.
• Generated p-sets for running generic graphs
• Worked extensively on continuous flow applications.
• Good experience working with very large databases and Performance tuning.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 1.1x/3.2.x, Co>Operating System 2.1x,3.2.x), Informatica, DataStage, SQL*Loader and Teradata utilities

Database: Sybase SQL, Oracle 9i/8i/7.x, MS SQL Server 2000/2005, DB2 UDB, MS Access 2000/7.0 and Teradata V2RX,13.10

Reporting Tools: MicroStrategy 8.1.1/8.0.2/7 X (Desktop, Web, Intelligence Server, Report Services, Narrowcast Server, Enterprise Manager)

Testing Tools: Win Runner, Load Runner, Test Director, and Quick Test Pro.

Operating Systems: Microsoft Windows XP/2003/2000/9i/NT, IBM AIX Unix 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Sun Solaris 8 and DOS

Languages: C, C++, Perl, SQL, PL/SQL, Transact SQL, Interactive SQL, UNIX Shell scripting, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Technical AbInitio lead

Responsibilities:

• Worked and held responsible for applications like STAMP and HRCS.
• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Responsible for managing technical resources (Onshore and Offsite) within project schedule.
• Responsible for creating and executing development plans
• Excelled guiding and managing technical resources within project schedule and scheduling status meeting to get the status updates and discuss ongoing issue and blockers.
• Responsible for updating project manager regarding status of development efforts.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks throughout the project.
• Drove impressive improvements across the business as a result of IT implementations.
• Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
• Developed graphs using Ab Initio components and utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Shared knowledge with the developer on EME repository check-ins and check-outs.
• Implemented Ab Initio Plans and continues flows for some applications.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Worked on Batch jobs using UNIX shell scripting.
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments.

Environment: Ab Initio 3.2.5.x with Co>Op 3.2.6, Oracle, DB2, UNIX, MS Office, Mainframe, Windows 7, CA7

Confidential, Jersey City, NJ

Technical Ab Initio Consultant

Responsibilities:

• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Responsible for creating and executing development plans
• Excelled guiding and managing technical resources within project schedule and
• Scheduling status meeting to get the status updates and discuss ongoing issue and blockers.
• Responsible for updating project manager regarding status of development efforts.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks throughout the project.
• Drove impressive improvements across the business as a result of IT implementations.
• Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
• Helped in setting up the batch jobs using Autosys and UNIX Shell scripting.
• Developed graphs using Ab Initio components and utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Helped the developer to check-in, check-out and tag updating based on the rules levied by the client.
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments.

Environment: Ab Initio 3.0.1 with Co>Op 3.0.1, Oracle, SQL Server 2008, Teradata 13.10, UNIX, MS Office, Windows 7, Autosys.

Confidential, Durham, NC

Ab Initio Consultant

Responsibilities:

• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Responsible for creating and executing development plans
• Scheduling status meeting to get the status updates and discuss ongoing issue and blockers.
• Responsible for updating project manager regarding status of development efforts.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks throughout the project
• Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, partition by Round-Robin, interleave, gather, dedup sorted, scan, reformat and validate on newer version of Ab Initio.
• Developed Continuous Flow applications using Ab Initio continuous components like subscribe, MQ subscribe, Multipublish, Publish, Continuous join with DB, Continuous update table.
• Developed Conduct>IT plans and sub-plans by integrating graphs, scripts.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Extensive knowledge in setting up the continuous components in the graph to remove server overhead.
• Through knowledge in Batch processing jobs.
• Performed code reviews and supervised junior developers.
• PerformingUnit testing on dev box and involved in the System Integrated testing on test box.

Environment: Ab Initio 3.1.7 with Co>Op 3.1.7, Oracle 11g, Teradata 13.10, UNIX, Windows 7, Control-M.

Confidential, Dallas, TX

Ab Initio Consultant

Responsibilities:

• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Responsible for creating and executing development plans
• Responsible for managing technical resources within project schedule and budgets and involved in recruiting the resources.
• Responsible for updating project manager regarding status of development efforts.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks throughout the project
• Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, partition by Round-Robin, interleave, gather, dedup sorted, scan, reformat and validate on newer version of Ab Initio.
• Implemented Ab Initio Plans and continues flows for some applications.
• Worked on enhancement of existing Ab Initio applications and made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
• Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Worked on continuous components like Publish, Multi-publish and Subscribe.
• Performed code reviews and supervised junior developers
• PerformingUnit testing on dev box and involved in the System Integrated testing on test box.

Environment: Ab Initio 1.14 GDE with Co>op 2.14 Version, Ab Initio 3.1.1 with Co>Op 3.1.2, Oracle Database, Teradata, UNIX, Windows XP, Tivoli Work Scheduler.

Confidential, Cleveland, OH

Ab Initio Developer

Responsibilities:

• Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high level Conceptual Data Process Design for the projects.
• Responsible for creating and executing development plans
• Responsible for managing technical resources within project schedule and budgets and involved in recruiting the resources.
• Responsible for updating project manager regarding status of development efforts.
• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
• Handled the tasks of identifying system deficiencies and implementing effective solutions
• Handled the responsibilities of managing technical risks during the upgrade process of existing system from DTS to Ab Initio.
• Developed graphs using Ab Initio components such as join, rollup, lookup, partition by key, gather, dedup sorted, scan, normalize, reformat and validate.
• Extensively utilized Ab Initio Parallelism techniques and MFS Techniques with the Conditional Components and Conditional DML and thereby improved the overall performance by optimizing the execution time.
• Added a HTTP web services to the ISS plug-in.
• Worked along with the developer to set up the daily and monthly batch processing jobs.
• Performed code reviews and supervised junior developers.
• PerformingUnit testing on dev box and involved in the System Integrated testing on test box.
• Performance tuning the complex Ab Initio graph, worked with tuning the memory parameter and Ab Initio best practice approach to implement the ETL process.
• Created SCLM members to schedule the Ab Initio jobs on Tivoli Workstation Scheduler.

Environment: Oracle Database, Ab Initio 1.14 GDE with Co>op 2.14 Version, UNIX - Solaris SunOS 5.10, Windows XP, Mainframe, Cognos.

Confidential 

Ab Initio Developer

Responsibilities:

• Prepare ETL design documents, evaluate and recommend ETL solutions to meet user requirements; define and implement solutions to load and extract data from source data.
• Had conceived data from sources, cleansed, transformed and loaded in to target databases using an ETL tool, Ab Initio.
• Had developed shell scripts that customize Ab Initio graphs prepared using graphical interface, GDE that processes multiple queries on large data
• Had been responsible for replicating operational tables, transform and load data into operational data using ETL techniques.
• Designed/Created several scripts to load the staging/target tables Configured Ab Initio environment to connect to the Teradata database using db config, Input Table and Output Table Components Had been responsible for scheduling and exception-handling routines on designed ETL processes.
• Worked on modifying the Ab Initio component parameters utilized data parallelism and thereby improved the overall performance by optimizing the execution time.
• Extensive experience working with branches in EME and coordinating with other teams to merge them.
• Designed and developed AI Graphs for large projects in the Retention Marketing Domain.
• Had worked on modified DML and supported graph changes pertaining to Unix to Linux
• Had worked on migration of Ab Initio based applications (migration effort).
• Developed AI graph based fast-track ad-hoc projects marketing and legal support.
• Conducted and participated in design reviews to support Best Practices.
• Analyzed financial data reports intended for executive consumption.
• Debugged shell scripts and Perl based code that worked in conjunction with AutoSys
• Involved in the creation of Ab-Initio Graphs to extract, transform and load the data from mainframes.
• Worked extensively on Web service components like Call web service.
• Data cleansing operations were performed on the graphs using data cleansing functions.
• Configured Ab Initio environment to connect to the Oracle database using db config, Input Table and Output Table Components.
• Created test plans for all Ab Initio graphs.
• Created and Performed reviews of all ETL designs, graphs, and test plans.
• Tested the data using Informix SQL on the database to check whether the abinitio graphs are doing what it's supposed to do.
• EME and Harvest both has been used for version control simultaneously.
• PerformedUnit testing on dev box and, System testing, and Integrated testing on test box.
• Created Autosys scheduling jobs for Ab Initio graphs.
• Designed/Created several BTEQ scripts with data transformations for loading the base tables to Teradata database to apply the business rules manipulate and/or cleansing the data according to the requirements.
• SLA (Service Level Agreements) for the new processes were identified and documented

Environment: Oracle 8i/9i/10g, ERWIN, Ab-Initio 1.14.15 GDE with Co>op 2.13.1 patch level 40 built on AIX5-2-n32mt, Unix - Solaris, HP superdome/RP 8400, Perl, Brio/Hyperion, Windows NT/2000, XML, COBOL, DB2, RCS Version 5.7, Teradata Utilities (BTEQ, Fastload, Multiload, Tpump).