Professional Summary:

• Over 15 years of experience in Data Warehousing and ETL in Banking, Finance and Telecomm domains.
• Over 8 years of Experience in various Ab Initio Products.
• Designed/Developed Continuous graphs and Batch processing jobs, Excellence in Performance tuning and Exposure to Various Performance Testing Techniques in Ab Initio.
• Created a Complete Production system consisting of graphs, wrapper scripts with appropriate rollback/ recovery options using Conduct>It plans
• Designed Error and Logging Framework ELF for error and log capturing
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Extensive experience in ETL Design, Development, Data Analysis, Requirements Gathering, Gap Analysis, Production Support, Incident/Problem Management, Release Management, Configuration Management, and Testing.
• Hands on experience with BI tools Actuate, Cognos .
• Worked on all phases of SDLC from requirement gathering to product support.
• Good knowledge of Hadoop ecosystems, HDFS, Hive, Pig, Sqoop, Map Reduce, Flume, Oozie.
• Exceptional planning, prioritizing, organizing, execution and delivery management skills.
• Excellent business communication skills, both written and verbal.
• Critical thinking with good negotiating, influencing, and delegating skills.
• Excel at communicating with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives
• Ensuring the delivery from the projects adhered to the appropriate levels of quality, on time and within budget, in accordance with the plan and governance models
• Effective Issues and Risks management with status tracking and compliance with quality tools and standards
• Leading the initiative, aiming towards business process engineering to bring in improvements /productivity enhancements from the delivery perspective
• Team management includes conflict resolution, issue management, individual appraisals and performance analysis, review.
• Prepare, Baseline project plans including schedule management plan, change management plan, stakeholder management plan, quality management plan, and configuration management plan.
• Track Issue Register and Risk Register and publish the updates as and when necessary to the stake holders.
• Estimate Budgets for small/large Project Proposals, Perform cost control activities and monitor costs timely - includes monthly billing activities.
• Report Customers with exact and precise information during Monthly Review Meetings with the Executives.
• Experienced working in a global environment with multidisciplinary, cross-functional and cross-cultural team.
• Experience on large-scale projects with Customer Interface and alliance/partner resources in delivering timely and cost-effective solutions.

Technical skills:

• ETL Tools : AbInitio GDE, Co-op, EME , SQL Loader, TOAD
• Hadoop / BigData : Hadoop, MapReduce, Hbase, Sqoop, Hive, Pig, Flume, Oozie
• Database : Oracle 10g/9i, SQL Server 2000/2005, Teradata V2R5, V2R6, Sybase IQ 15.1
• Languages : SQL, PL/SQL, Java, XML, SAS macros, shell scripting
• Data Modeling Tools : Visio
• Operating Systems : Linux, AIX, Windows

Professional Experience:

Confidential

• Designed innovative way of dynamic directory creation to enhance existing design and meet requirement such that there is minimum code change
• Redesigned multiple marts in turn saving lot of man hours in terms of continuous data analysis
• Creating Project Plan for monthly deliverables.
• Managing work allocation for team across geographies.
• Manage project quality reviews.
• Perform production cutover planning and coordination of enhancement releases.
• Responsible for designing various marts and dimensions in centralized data repository Consolidate Data Mart for mission critical systems catering to Credit Risk, BASEL III, regulatory reporting requirements.
• Improved cycle run time by redesigning mart and ETL processes.
• Providing estimates and creating Design documents.
• Highly experienced in Ab Initio branch usage to allow parallel development.
• Designed common projects which are used across applications to minimize DB overload.
• Design and develop various Ab initio graphs to pull data from source systems, cleanse, transform and load data into databases.
• Developed scripts which automated loading process to Sybase IQ database.
• Created, Debugged and modified various shell scripts in UNIX environment.
• Liaise with testing and processing team by providing them run book / processing documents and giving them a detailed walk through.
• Participate in Database design discussions.
• Weekly status update to management team.

Environment:

Abinitio GDE 2.14/15, 3.0.4, Co>Operating System 2.14, 3.0.5, LINUX, AIX, Oracle 10g, Sybase IQ 15, Autosys, Cognos, Microsoft Project

Confidential

ETL Lead

Responsibilities:

• Build credibility, establish rapport, and maintain communication with clients.
• Responsible and accountable for the coordinated management of multiple related projects.
• Reviewing HLD, Data Mapping and LLD Documents.
• Designed common components that are reused across applications.
• Reviewing and monitoring project progress, planning managing dependencies and risks, Resource Planning, Project Tracking and Forecasting.
• Assist in conducting internal Ab-Initio training.
• Providing inputs for Statement of Work and contract creation to secure new and follow-on work.
• Coach, mentor and lead personnel within a technical team environment.
• Actively participate in staff recruitment and retention activities.

Environment:

Abinitio GDE 2.14/15, Co>Operating System 2.14/2.14, TOAD, UNIX,

SQL, PL/SQL, Oracle 9i/10g, JMS, XML, Microsoft Project

Confidential

Tech Mahindra

Responsibilities:

• Analyzing existing code in SAS macros and create a Technical Design Document to be used as a base for ETL Extraction, Transformation, Loading implemented in AI.
• Co-ordinated with business owners for requirement analysis and defined business and functional specifications.
• Involved in design and development of Ab Initio graphs.
• Involved in developing Low level design documents.
• Created and modified various UNIX Shell scripts.
• Involved in Change Management, Production Support, and Troubleshooting.
• Responsible for providing matrices to clients for number of tickets resolved, pending etc.

Environment:

Abinitio GDE 1.15, Co>Operating System 2.15, TOAD, UNIX, SQL, PL/SQL, Teradata, Control M, SAS Macros 9.0

Confidential

Senior Technical Associate

Responsibilities:

Worked on major migration and system optimization projects for clients including BT.

Environment:

Abinitio GDE1.11, Co>Operating System 2.11, UNIX, SQL, Oracle 9i , Actuate 7.2