SUMMARY:

• More than 10 years of total IT experience in design, analysis, development, documentation, coding, and implementation including Databases, Data Warehouse, ETL Design, AbInitio and Testing of Data warehousing business systems.
• Solid experience in developing 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 Multifiles, Partitioning and Departitioning components etc and fine tune the applications for optimal performance.
• Strong skills in Oracle are PL/SQL programming and in Performance Tuning of SQL by analyzing the Explain Plan to create proper index type.
• Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs in Ab Initio
• Sound working knowledge in parameterizing Abinitio graphs and creating PSETS.
• Experience using various Ab Initio component sets like Transform, Datasets, Sort, Partition, De-partition, Compress, FTP and other miscellaneous component groups. Involved in Unit testing of Ab Initio code, Integration Testing and System testing in pre-production environment.
• Excellent programming skills with ability to automate routine tasks using UNIX shell scripting and a good experience in SQL.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, and Teradata and worked integrating data from Flat files.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Worked on designing Ab Initio graphs for various Data warehouse and Data Mart ETL processes.
• Experience in Data analysis, Database design and Data migration. Developed several Ab Initio applications for transferring, cleaning, loading and populating various Data marts of a uniform database type on UNIX platform.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• 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.
• Proven abilities in improving Application performance, capacity planning.
• Diagnosed production issues to ensure a timely recovery and minimal impact to our business users.
• Good experience in providing immediate solutions by creating graphs for the business users Adhoc Requests.
• Handled the code in different environments (UAT, PROD) and created the docs for code promotions.
• Supported ETL developers by providing technical assistance, troubleshooting and alternative solutions.
• Client interaction for requirement gathering, system analysis, Impact analysis, technical / functional specifications of the project, liaising extensively with offshore/onsite model.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS:

ETL: Ab Initio GDE 1.14/1.15/3.0.4 Co-Operating System 2.14, 2.15, 3.1.6, SAS

Databases: Oracle 10G/9i/8i, TeradataV2R6, DB2, SQL Server 2016/2014

Languages /Scripting: C, C++, JAVA, SQL, PL/SQL, HTML, Java Script, XML, UNIX Shell Scripting

Scheduling: Autosys, Control-M, Automic

Operating Systems: Windows NT/98/2000/XP, UNIX, LINUX

Reporting Tools: WebFocus, Business objects

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Sr. ETL Developer

Responsibilities:

• Provide technical support and issue resolution to critical applications at SLU.
• Work closely with the business teams to ensure critical application are available for the business and several management centers across SLU.
• Gather detail requirements and turn them into the technical specifications.
• Provide resolutions to the defects created by various business teams and students across the University.
• Provide technical solutions utilizing SSIS, Oracle, Linux, and ERP application knowledge .
• Work with the external IT vendors to ensure the integrations are functional.
• Work with the software vendors and the technical support teams to apply break fixes.
• Participate in the Software upgrades by implementing software patches and releases.
• Analyze data and application issues and develop fixes.
• Work with the IT operations to implement changes into various environments.
• Work closely with the PMO team and provide technical updates to the issue resolution and IT projects.
• Develop Adhoc reports using various reporting tools.
• Work liaison between the SLU Business and technology teams across SLU.
• Generate detail design documentation for the technical solutions and ensure the change requests are delivered to the Business at SLU.
• Coordinate User Acceptance testing to ensure the software/process/integration implemented meets the business requirements.
• Manage offshore team deliverables and work with the business to ensure project tasks are completed on time and under budget.

Environment: SSIS, ERP Integrated applications: App Xtender application, Axiom application, Blackboard application, Workflow, Clean Address, Self Service application for Employees and Students, Linux Shell Scripts, Window Batch Scripts, WebFocus reporting tool, Cognos tool, Oracle database development and real-time integrations etc.,

Harte Hanks, Chelmsford, MA

Sr. AbInitio Developer

Responsibilities:

• Performed Analysis, designing and preparing the functional, technical design document, and code specifications.
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources
• Involved in developing UNIX Korn Shell wrappers to run various Ab Initio Scripts.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, normalize, gather, merge etc.
• Worked on improving the performance of Ab Initio graphs by using various Ab Initio performance techniques.
• Design Documentation for the developed graphs.
• Used components like run program and run sql components to run UNIX and SQL commands in AB Initio. used the components like filter by expression, partition by expression, replicate, partition by key and sort Components.
• Working with Departition Components like Gather, Interleave in order to departition and Repartition the data from Multi File accordingly.
• Create Summary load jobs using Rollup, Scan & Aggregate.
• Scheduled Ab initio jobs using Control-M.

Environment: Ab initio GDE 3.1.6/1.15/1.14 , Oracle, UNIX, Control-M.

Confidential, Tampa, FL

Sr. AbInitio Developer

Responsibilities:

• Gathered Business requirements and Mapping documents.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Responsible for the detailed design and documentation. Provided technical solutions for the Process requests raised by Data team to fix the issues in the existing system.
• Designed, developed and Unit tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Created and modified various graphs based on the business rule enhancements.
• Involved in writing test cases to validate the code changes.
• Extensively used Database and Dataset components like Input file, Input table, and Output table and Transform components like Join, Rollup, Scan, Filter by expression, Reformat and other components like Merge, Lookup, Input/Output table and Sort.
• Used Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Extensively used various inbuilt transform functions like string substring, string lpad, string index, lookup functions, date functions, error functions.
• Extensively used Ab Initio Co-OS commands like m ls, m wc, m dump, m copy, m mkfs, etc. Utilized multi file system (MFS) to execute the graph parallel.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory joins and rollups to speed up various Ab Initio graphs. Designed and developed parameterized generic graphs.
• Closely monitored the Autosys batch jobs in ETL batch run during System, Integration and Acceptance test runs.
• Worked closely with migration team to migrate the ETL code changes from development environment to System, Integration and Production environments.
• Extensively worked in the UNIX environment using Shell Scripts. Created test cases and performed unit testing for the Ab Initio graphs. Documented Unit testing. Logged and resolved defects in the roll out phase. Responsible for supporting the functional team and troubleshooting any production issues.

Environment: Ab Initio GDE 1.15, 1.14, 3.0.4 Co-Operating System 2.15, Oracle 10g, UNIX, Autosys, Business Objects.

Confidential, Long Island City, NY

Sr. Ab Initio Developer

Responsibilities:

• Involved in creating the Physical models from business requirements.
• Migrating SAS code into AbIntio Code.
• Developed graphs separating the Extraction, Transformation and Load process to improve the efficiency of the system
• Involved in designing Load graphs using Ab Initio and tuned the performance of the queries to make the load process run faster.
• Extensively used Partition components and developed graphs using Write Multi-Files, Read Multi-Files, Filter by Expression, Run Program, Join, Sort, Reformat, Dedup
• Implemented Lookups, lookup local, In-Memory Joins to speed up various Ab Initio Graphs.
• Extensively used Enterprise Meta Environment (EME) for version control
• Involved in unit testing and assisted in system testing, integrated testing, and user acceptance testing.
• Followed the best design principles, efficiency guidelines and naming standards in designing the graphs
• Designed and build Ab Initio generic graphs for unloading data from source systems. Validated the unloading process with the row count of the landed file with that of the source table row count
• Write script wrappers, using unix, to call Ab Initio applications
• Designed Ab-Initio graphs using GDE Conditional components
• Developed shell scripts for Archiving, Data Loading procedures and Validation
• Used Test Director to keep track of bugs
• Experience using Quality Centre
• Created a Production support document and documented the Test case work book, High level Design and Detail Design documents.

Environment: Ab Initio CO>op 2.15, Ab Initio GDE 1.15, SAS, TOAD, SQL, PL/SQL, UNIX Sun Solaris, Oracle 9i/8i

Confidential, Chapel Hill, NC

Sr. AbInitio Developer

Responsibilities:

• Analyzed Business and Accounting requirements from the Accounting and Business Detail level Process design.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Designed, developed and Unit tested Ab Initio graphs using GDE for Extraction, Transformation and Loading of data from source to target.
• Involved in writing test cases to validate the code changes.
• Involved in designing the Data model.
• Implemented component level, pipeline and data parallelism using Ab Initio for ETL process. Extensively involved in performing EME dependency analysis.
• Used Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Extensively used various inbuilt transform functions like string substring, string lpad, string index, lookup functions, date functions, error functions.
• Extensively used Ab Initio Co>OS commands like m ls, m wc, m dump, m copy, m mkfs, etc. Utilized multi file system (MFS) to execute the graph parallel.
• Worked on improving performance of Ab Initio graphs by using various Ab Initio performance techniques like using lookups, in memory joins and rollups to speed up various Ab Initio graphs. Designed and developed parameterized generic graphs.
• Developed, Tested and Validated Teradata-BTEQ scripts and Teradata Macros.
• Created Staging and Target Teradata/Oracle objects.
• Extensively worked on Fast Export and Fast Load utilities to unload and load data.
• Extensively worked in the UNIX environment using Shell Scripts. Created test cases and performed unit testing for the Ab Initio graphs. Documented Unit testing. Logged and resolved defects in the roll out phase.

Environment: Ab Initio GDE 1.15, Co>Operating System 2.15, Oracle, Teradata 13.0, UNIX Shell Scripting.

Confidential, Deerfield, IL

AbInitio Developer

Responsibilities:

• Worked closely with the Business Analysts and Application Leads for Requirement study, Analysis and design of the application.
• Created low level design documents for various application processes.
• Developed reusable graphs which loads different tables applying different load strategies.
• Extensively worked on most commonly used components to complex components like Normalize, Denormalize, Scan, Rollup, Partition, Departition components etc.
• Used Ab Initio’s Multifile systems for improving heavy data loads.
• Proposed multiple solutions to a given issue and extrapolated one optimal solution - this way of problem solving won superior customer experience
• Proactively tuned applications to minimize execution times and improve user experience.
• Solved complex SQL performance issues and determined appropriate SQL tuning solutions.
• Extensively worked on FastExport and FastLoad utilities to unload and load data.
• Migration of Ab Initio Objects from development to QA environment and prepared appropriate documentation for code move to QA and production environment.
• Created Staging and Target Teradata/Oracle objects.
• Developed UNIX wrapper scripts to call Ab Initio deployed graphs.
• Scheduled Ab Initio graphs using Control-M.
• Prepared test plan, test cases and tracking the defects.
• Involved in end to end data validation by interacting with the business (UAT)

Environment: Ab Initio GDE 1.15, Co-Operating System 2.15, Oracle 10g, DB2, Teradata V2R6, Control-M.

Confidential

Ab Initio Developer

Responsibilities:

• Study and understand all the functional and technical requirements to better serve the project
• Developed Ab Initio graphs using different components for extracting, loading and transforming external data into data mart.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Component like Filter by Expression, Partition by Expression, Partition by round robin, reformat, rollup, join, scan, normalize, gather, replicate, merge etc
• Developed Ab Initio graphs for Data validation using validate components like compare records, compute checksum etc.
• Implemented Data Parallelism through graphs, by using Ab Initio partition components.
• Documentation of complete Graphs and its Components.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab Initio partition components to segment data.
• Involved in Ab Initio Design, Configuration experience in Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume environment and data processing at Terabytes level.
• Involved in automating the ETL process through scheduling.
• Used Autosys for scheduling the jobs.
• Responsible for cleansing the data from source systems using Ab Initio components such as reformat and filter by expression.
• Developed psets to impose reusable business restrictions and to improve the performance of the graph.
• Developed several partitions based Ab Initio Graphs for high volume data warehouse.
• Scheduling the bug fixes for development/UAT and production migration.
• Create test scripts for the Integration testing and support for Integration testing.
• Analyzing the Production bugs logged in Test Director.

Environment: Ab Initio CO>OS 2.15, GDE 1.15, Oracle