SUMMARY:

• A logical thinker with experience of 3+ years in the field of Data Warehousing using Ab Initio tool with relational databases like Oracle, DB2, SQL Server. Worked on all phases of data warehouse development lifecycle from gathering requirements to testing, implementation and support.
• Self - motivated and proactive leader with technical and exemplary communication skills.
• Exceptional ability to create, implement and improve IT standards, policies, and procedures
• Experience in understanding of the Specifications for Data Warehouse ETL Process and interacted with the designers and the end users for informational requirements
• Expertise in all components in the GDE of for creating, executing, testing and maintaining graphs in Ab Initio.
• Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, DB2.
• Expertise and well versed with various Ab Initio Transform, Partition, De-partition, Dataset and Database components.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files.
• 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.
• Developed various UNIX shell wrappers to run Ab Initio and Data base jobs. Practical experience with working on multiple environments like production, development, testing.
• Thorough knowledge in EME, check-ins, checkouts, command line interface, air commands and Dependency analysis.
• Extensively used Ab Initio EME data store/sandbox for version control, code promotion and impact analysis.
• Strong knowledge of Data Warehousing concepts and Dimensional modelling like Star Schema and Snowflake Schema.
• Performed weekly project status reporting and overall project co-ordination within On-Shore and Offshore team members
• Scheduling of Ab Initio jobs with TWS.

TECHNICAL SKILLS:

ETL Tools: Ab Initio- GDE, Ab Initio- EME, SQL Loader

Database: Oracle, DB2, MS SQL Server

Scheduler: TWS

Operating System: Windows, Unix

Languages: Python, PL/SQL, C/C++, VB.net, HTML, PHP, XML

Scripting: Unix Shell (ksh)

Application: MS Office Products, Visio, Erwin

PROFESSIONAL EXPERIENCE:

Abinitio Developer

Confidential

Responsibilities:

• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Psets, XFR, deployed scripts, DBC files for connectivity, create Package and exports
• Develop scripts to automate the execution of Ab Initio graphs using shell scripts under Unix environment developed code migration strategies from one environment to the other
• Participated in business, detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process
• Data loading from various source systems to DB2/Oracle tables. Creating database objects according to the Design
• Proficiency in using Oracle database and thorough knowledge in SQL programming
• Designed and developed parameterized generic graphs
• Participated in regular project status meetings & Defect triage meetings
• Coordinated with DA and QA (Quality Analyst) team in User Acceptance testing and Production support team in code migration to Production environment.
• Improved the performance of Ab Initio graphs by using Lookups, Max-core, In-Memory Joins and parallelism techniques for maximum usage of cache memory. And used Check pointing and phasing to improve reliability of the application
• Worked with the Users during the User Acceptance Testing Phase and made sure their queries are answered and the business requirements are met
• Scheduled jobs using TWS to run at a specific time
• Involved in the production migration activities as well which included tag creations, code migrations, job executions and monitoring
• Enhancement of existing graphs in each release by adding extra functionality or changing existing transform (xfr files) functions
• Worked along with the developer to set up the daily and monthly batch processing jobs.

Abinitio Developer

Confidential, Chicago, IL

Responsibilities:

• Developed Generic graphs for data cleansing, data validation and data transformation
• Demonstrated expertise utilizing ETL tool (Ab Initio), including RDBM systems like Oracle and DB2
• Used UNIX environment variables in All the Ab Initio Graphs
• Designed programs for data extraction and loading into Oracle database
• Prepared business, detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process
• Implemented several Ab Initio graphs using Multi File System (MFS) techniques
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose
• Worked with data mapping from source to target and data profiling to maintain the consistency of the data. Experienced with SQL queries. Knowledge of checking the data flow through the front end to back end and used the SQL queries to extract the data from the database to validate it at the back end
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures
• Worked with production support team to debug issues in production and for migrations from pre-prod to production
• Performed unit testing, Integrated testing, involved in UAT, code review and performed code migration to different environments
• Worked with different EME air commands like air lock show, air object version, air object show-permissions, air sandbox run, air tag create, air project export
• Used checkpoint and phasing to avoid deadlocks and to re-run the graph in case of failure
• Weekly project status reporting and overall project co-ordination within On-Shore and Offshore team members
• Train the new team members with various tools used along with environment and business knowledge transfer

Jr. Abinitio Developer

Confidential

• Supported Testing Team in providing data, loading the Data in Test Environment, provided sqls for testing the Test cases
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process
• Involved in creation of proper test data to satisfy all required test cases and performed unit testing on all deliverables also was part of the code review team
• Created XFRs during the data transformation phase prior to creating load ready files
• Created Database Configuration files (.dbc) and involved in creating SQL statements with .sql extensions, which will be used in Database transformations to extract the data from different source tables and to load into the target table
• Worked on modifying the Ab-Initio component parameters utilized data parallelism and thereby improved the overall performance by optimizing the execution time
• Created and Performed reviews of all ETL designs, graphs, and test plans
• Created Autosys scheduling jobs for Ab Initio graphs
• Designed and developed Ab-Initio graphs using Aggregate, Join, Rollup, Scan, look up and transformation rules
• Used different Ab-Initio components like dedup, sort, de-normalize, join, scan, reformat, filter-by expression, partition by key, Sort, Reformat and fuse in various graphs