SUMMARY

• Over 8+ years of IT experience in design and development of ETL solutions using Ab Initio, DB2, teradatafor supporting data migration, data transformations & processing in data warehouse and data integration of BI reporting environments.
• 3+ years of experience in leading L3 production support and enhancement team of Confidential BI reporting applications.
• Excellent noledge of Data Warehousing and Business Intelligence Concepts and working wif Data Modeling Methodologies.
• Hands - on experience in improving performance and troubleshooting of Ab Initio graphs.
• Extensive hands-on experience in core Ab Initio concepts of Parallelism, MFS, PDL and ICFF.
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Developed generic Ab Initio graph for loading teradata using Fast load or API based on data volume.
• Strong working noledge on AbInitio suite of products ACE, BRE, Metadata hub & data profiler.
• Exposure to open source ETL tools like Talend, Pentaho and Hadoop conceptsof HDFS, HBASE, Sqoop and Pig.
• Hands on experience in installing, configuring Oracle‘s Gloden Gate data replication tool.
• Excellent noledge in ETL interfacing of heterogeneous source systems like Oracle, Teradata, MS SQL Server, DB2,flat files and legacy system.
• Expert in system analysis and troubleshooting, test plan strategy, release planning and built custom ETL process for trend analysis of reporting products.
• Flexible, enthusiastic and team player wif excellent communication skills, ability to grasp new concepts and implement productively.
• Experience in handling concurrent projects in an offshore-onsite development model.
• Experience in Agile model of ETL development.
• Domain expertise in Card& Paymentsystem.

TECHNICAL SKILLS

ETL tools: Ab Initio3.1.6, Conduct IT

Scripting Languages: Unix shell scripting

Data Replication Tool: Oracle Gloden Gate

Databases: DB2, Teradata, Oracle

Defect Tracking Tool: HP Quality Center

Operating Systems: IBM AIX, Solaris, Windows 7

Schedulers: Control-M, Dollar U

Others: Sybase power designer,Visio, ManageNow

PROFESSIONAL EXPERIENCE

Senior Ab Initio Developer / Technical lead

Confidential - Memphis, TN

Responsibilities:

• Work wif various MIS analysts to understand requirements for BI dashboard and create ETL transformations to load snapshot and aggregate tables.
• Design and built custom plans using Conduct ITto integrate PSETs based graph executions, establish dependencies wif various modules, implement resource pools.
• Built custom ETL graph and implemented SCD type-2 to load dimension tables includes dynamic generation of transformations using PDL interpretation.
• Built ETL process to load reporting hierarchy dimension, implemented metaprogramming to generate dynamic DMLs& transformations for implementing SCD type-2 change. Also used secure hash algorithm-1 to mask specific dataset.
• Build Conduct IT plans to integrate graphs, common load process and implemented resource sharing for concurrent use of teradata fast load utility and source database unloads.
• Built graph and plan to load any target Teradata table sourced from excel sheets.
• PSET driven ETL load process invokes fast load or API utility based on volume of the feed.
• Built batch process to call MS sharepoint web service, transform XML dataset and load hierarchy delegation dimension table.
• Perform dollar-U scheduler change, scripts to trigger plan for ETL process.
• Defect support, lower environment scheduling, monitoring, job abend restart and root cause analysis.
• Prepare migration plan and production history load instructions.

Ab Initio technical lead

Confidential - Phoenix, AZ

Responsibilities:

• Understand the legal requirement for GBT (Travel service new venture) & GCS separation, identify the impacted BI ETL processes and propose design solution.
• Active contribution towards re-architecture of BI applications GCS-GBT separation.
• Developed one-off AbInitio graph to migrate 20 million records into POA denormalized format involved 300+ different reports/transformation logic to load data into new OLTP system.
• Developed ETL process using block compressed lookups to load corporate control account accesses to establish inter & intra corporate security.
• Design and built ETL load process for BI reporting application (Microstrategy) to isolate rep access for new venture employees.
• Build one-off ETL process, prepare dry run ETL graph in AbInitio for internal user migration into new system.
• Worked on redesigning existing MSSU (MIS Service & Setup Utility) ETL application loads ODS report trigger database for IBI webfocus reporting tool.
• Worked in enhancing existing report posting ETL process which pushes 1 million report files to SAN by creating user and report specific directory structure.
• Worked in a challenging project for conversion of C++ code to Ab Initio ETL graphs based on input and output response from the conventional system behavior.
• Exposure in infrastructure upgrades like configuring NFS, SAN addition to ETL servers.
• Fair understanding of mainframe programs to convert into Ab Initio code.
• Active contribution in the discussion of LDM and PDM for new tables in DB2 OLTP database.
• Involved in performance and tuning of Ab Initio ETL graphs, processes and load routines.
• Developed customized shell scripts to trigger Ab Initio process in runtime.
• Created mapping documents wif the required transformation logic, sources tables & fields for loading the target tables.
• Design and built job schedulers using Control-M.
• Provide warranty support post production, identify and fix non issues.
• Release planning of ETL process wif interfacing applications to mitigate high business risk involved in migrating user information from POD to POA reporting platforms.

L-3 support analyst

Confidential

Responsibilities:

• Work on DB2, unix load process job abend circumvention and root cause analysis.
• Provide recommendation and code enhancements for theidentifiedroot cause.
• Analyzed and fine-tunedDB2 SQLs.
• Work wif IBM SME support for optimizing heap size and web server load balancing settings.
• Publish manual work effort statistics on a monthly, quarterly and yearly basis and recommend reoccurring issue resolutions to save manual effort put forth by team.
• Setup automation alert scripts to monitor JVM exception logs, file system warning and batch job end of day status email.
• Maintenance and enhancement of shell script load and reporting posting process.