SUMMARY:

• Over 7 years of IT experience in software Analysis, Design and Development of various software applications in client server environment.
• 7 years of experience in providing Business Intelligence solutions in Data Warehousing for Decision Support Systems and OLAP application development.
• Extensive experience in developing strategies for Extraction, Transforming and Loading mechanism using Ab Initio in Banking and Health Care Industries.
• Very good knowledge of Data Warehousing concepts and Dimension Modeling like Star Schema and Snowflake Schema.
• Worked in all phases of Software Development Life Cycle (SDLC).
• Experienced in Abinitio Plan - it to prepare Plans to replace Shell Wrapper Scripts.
• Excellent Skill in Abinitio EME, Migrations and all other Administrative tasks.
• Much familiar in writing UNIX shell scripting and AutoSysJil scripts for Job Scheduling.
• Proficient in Relational Database Management Systems Oracle, Teradata, SQL Server.
• Good programming skills in SQL, PL/SQL, Teradata Macros.
• Very Good knowledge of working with Ab Initio GDE, EME, Express>It, Query>It, Conduct>It and Co>operating system.
• Involved in development of ETL applications following Agile (Scrum) Methodology.
• Well versed with various Ab Initio parallelism techniques and implemented Ab Initio Graphs using Data parallelism and Multi File System (MFS) techniques.
• Extensively experienced in using ETL tools like Ab Initio, Informatica Power center.
• Extensively used ETL methodologies for supporting Extraction, Transforming and Loading of data to and from heterogenous systems.
• Experience in debugging COBOL stored procedures.
• Experience in writing SQL Stored procedures and Triggers.
• Good understanding of AB Initio SANDBOX and Graphs parameters to make the graph generic.
• Experience working with continuous graphs.
• Expert in writing Unix shell scripting and used it for automating many client processes.
• Worked on Teradata utilities like Fast Load, Multiload, BTEQ and Fast Export to export and load data to different source systems including flat file.
• Expertise and well versed with many of the Ab Initio components like Transform, Sort, Lookup, Dedup sort, Partition, Gather, Scan, Database components and FTP.
• Had converted several Complex PL/SQL procedures into Abinitio graphs.
• Developed numerous Ab Initio ETL graphs to load and unload data from oracle database tables using Input tables and output table components.
• Very Good Experience with Relational Databases, Oracle and DB2.
• Have experience in preparing Requirement Document (FRD), Technical Design documents(TDD), Functional, Unit Test Case Documents (UTD) and Code review document (CRD).
• Good understanding about working of Control-M scheduler.
• Provided Production support to the multiple projects, analyzing issues and debugging the graphs.
• Good knowledge ofAb Initio Metadata Hub.
• Good knowledge about Cloudera Bigdata systems like HDFS.
• Excellent Analytical and problem solving skills.
• Very good professional written and verbal communication skills.

TECHNICAL SKILLS:

OS: Unix, Linux, Windows

Databases: DB2 (Teradata 15/14), MS SQL Server, Oracle 10g/9i/8i

Languages: SQL, PL/SQL, BTEQ, TPT, XML, Unix Shell Scripting, Korn Shell (Ksh)

Microsoft Office: MSViso, MS Excel, MS Access

BI Concepts: OLAP, OLTP, Data Marts, Dimensional Modeling.

WORK EXPERIENCE:

Ab Initio Developer

Confidential, Louisville, KY

Responsibilities:

• Interacting with Marketing/Business stake holders, gathering Requirements, Analyzing and managing the delivery, covering the entire Data Warehouse development lifecycle.
• Used components of Ab Initio to extract, transform and load data from multiple data sources like Teradata (DB2), Flat files, XMLs etc. to target data marts.
• Cleansed the data using various Ab Initio components like Join, Rollup, Dedup-Sort, Reform, Replicate, Partition by expression, Partition by Key, Partition by round robin, Scan, Filter by Expression, Gather and Merge.
• Read and processed Cloudera HDFS files using Ab Initio components.
• Written Unix scripts in the Ab Initio Graphs.
• Much familiar with the concept of Sand box, EME for check in & checkout process.
• Modified the Ab Initio component parameters, introduced phases, checkpoints to avoid deadlock, utilized data parallelism and thereby improving the overall performance to fine-tune the execution times.
• Designed and Built Ab Initio Graphs for unloading data from different source systems.
• Responsible for different Data mapping activities from Source systems to Teradata. 
• Good experience with dml utilities like m db, Cobol-to-dml.
• Extensively used EME for Version control and Code Promotion.
• Involved in tuning of SQL queries to improve performance of the Graphs.
• Tested Abinitio graphs in development and Test environments using test data, fine tuning the graphs for better performance and migrated them to the Production environment.
• Extensively used the Teradata utilities like BTEQ, Fast load, Multiload, DDL Commands and DML Commands (SQL). 
• Created high level, low level design documents for data integration
• Helped entry level resources in understanding the workflow and on boarding into the team.
• Developed Ab Initio Graphs with complex transformation rules through GDE.
• Developed Complex Ab Initio XFRs to derive new fields and solve various business requirements. 
• Developed several Unix wrapper scripts to schedule Abinitio Graphs and implemented Restorability
• Extensively used EME for Version Control and Code Promotion.
• Created Test Plans, Test Cases and Test Scripts for all testing events such as System Integration Testing(SIT), User Acceptance Testing(UAT) and Unit Integration Testing 
• Written Unix scripts to automate Ab Initio processes.
• Created Test data to help QA team in testing of the AB Initio Graphs.
• Written various dml and dbc files.

Environment: Ab Initio (GDE V3.0.4.2), Co-Op V3.0.3, Oracle 10g, Teradata, Unix,Korn Shell Scripting Control-M.

Ab Initio Developer

Confidential, Irving, TX

Responsibilities:

• Involved in High level designing and detailed level designing.
• Extracted data from various sources like databases, delimited flat files and XMLs.
• Worked on Continuous graphs in one module where we used to get Abinitio queues (from Tibco source) and used to process through JMS subscribe, JMS publish.
• Developed various Abinitio Graphs based on business requirements using various Components.
• Used Abinitio Pan>it to Keep the Job Dependencies Work-flow.
• Test Abinitio graphs in development and migration environments using test data, fine tuning the graphs for better performance and migrate them to the Production environment.
• Extensively used lookups to Increase the performance of the graph to avoid Joins.
• Extensively used air commands For Abinitio code migrations, Check-in, check outs.
• Written Shell Scripts to schedule the Abinitio Graphs by supplying parameters.
• Extensively used Ab Initio Parallelism feature of Component, Data and Pipeline parallelism.
• Review the test case results with the team and report the results to business accordingly.
• Testing the graph once development is completed and preparing Unit test case documents, code review documents.
• 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.
• Worked with the migration teams and DBA during major release
• Used Partition components like partition by expression, partition by key, etc., to run the middle layer processing parallel.
• Effectively used Multi file system (MFS) to execute the graph parallelly.
• Extensively worked in the UNIX environment using Shell Scripts.

Environment: Ab Initio (GDE 2.14, Co>Op 1.14), Oracle 10g, SQL, Linux

Ab Initio Developer

Confidential

Responsibilities:

• Involved in the meeting with Business Analysts to finalize the requirements and documented them.
• Created Design documents for the implementation of the project.
• Responsible for Performance-tuning of Ab Initio graphs. 
• Used Command line check-in, checkouts.
• Used the Ab Initio Web Interface to Navigate the EME to view graphs, files and datasets and examine the dependencies among objects.
• Used top down approach for the creation of the Data Marts.
• Test Ab Initio graphs in development and migration environments using test data, fine tuning the graphs for better performance and migrate them to the Production environment.
• Created Ab Initio Scripts to Extract, Transform and Load data from various source systems like flat files, XML files etc. to Oracle Database.
• Involved in development of complex and efficient SQL scripts in the process of debugging various Ab Initio graphs.
• Performed Lookups, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Utilized Oracle Database in the development of reports for the business users.
• Led a small team of 3 to deliver a develop an efficient application using AB Initio architecture.
• Used various multi and single stage components like Rollup, Normalize, Dedup sort, reformat to create the graphs.
• Involved in unit testing the application and deployment.
• Experience in writing Jil Scripts to submit AutoSys Jobs.
• Involved in Design documentation of the whole project.

Environment: Ab Initio (GDE 1.14.30), Co-Op 2.14.74, Oracle 10g, Unix,Linux, AutoSys.

Confidential

Programmer 

Responsibilities:

• Involved in understanding business requirements, analysis and design of the ETL mappings.
• Used Ab Initio to extract, transform and load data from various source systems to staging area and target Data warehouse.
• Built complex SQL queries to analyze data and fix the issues in the data warehouse. This helped in achieving the bug-free code in the ETL mappings.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio function like is valid, is defined, is error, string substring, string concat and other string * functions.
• Involved in successful implementation of the requirements and on time delivery to the client.
• Actively coordinated with the testing teams (QA) to complete the task in time.
• Implemented tuning of Ab Initio graphs and SQL queries used in the graphs for optimal performance.
• Was involved in developing automation scripts using shell scripting to reduce the human effort while fetching daily reports. Through this, we could able to reduce man power requirement.
• Constantly interacted with the clients about the status of few critical jobs to be done.
• Handling critical job failures and trouble shooting them.
• Worked on generating Business login using Business Rules Engine (BRE).
• Scheduled jobs using Control-M scheduler.
• Supporting maintaining nightly jobs on an on-call basis.
• Worked on Teradata to write complex queries to debug ETL process.
• Very good experience on Healthcare system and PBM industry.
• Worked on InformaticaPowercenter for three months during training phase and developed an application.

Environment: Ab Initio (GDE 1.13.18), Co-Op 2.12, Unix shell scripting, Unix, Teradata.

Dot Net Intern

Confidential

Responsibilities:

• Developed application from the scratch involving in every stage of Software Development Life Cycle.
• Used Visual Studio as IDE for creating front end.
• Written JavaScript for client side validation.
• Used SQL Server as backend data server.
• Used SQL for Ado.Net statements to retrieve data from the database.
• Implemented an innovative idea of multiple DBAs by distributing the work to multiple team members.
• Documented the project and performed Unit testing.

Environment: .Net framework, HTML, CSS, Visual Studio, SQL Server.