SUMMARY:

• AbInitio ETL Architect/Technical Manager with close to 12 Years of IT Experience
• Expertise in ETL tools in Data Integration and Data Warehousing space
• Expertise in multiple products of AbInitio GDE, Conduct>IT, Metadata Hub, Control Center, AbInitio Express>IT, Elementum, AbInitio EME Management Console, AbInitio Data Profiler, AbInitio Key Server Administration Console
• Expertise in Unix shell scripting, SQL and PL/SQL
• Experience in Data Modeling for OLTP system
• Worked on Data Lake implementation project using Hadoop.
• Exposure in Retail and Banking Domain
• Experience as an AbInitio Administrator
• Experience in estimation and planning
• Executed projects in Waterfall and Agile Methodologies.
• Experience in executing Development, Maintenance, Support and Administration projects
• Experience in leading and managing team, with peak team size of 30 members
• Onsite Experience of 3 years in London, UK
• Experience working in fast - paced environments demanding strong, positive, proactive, adaptive to changes, hard working and honest.

SKILLS SUMMARY:

Operating System: Windows 7, UNIX

Languages: UNIX Shell Scripts, PL/SQL

Database: Oracle, Teradata, Netezza, DB2

Versioning Tools: AbInitio EME, Microsoft VSS, Clear Case

Schedulers: AbInitio Control Centre, Confidential Tivoli Workload Scheduler, Control-M Scheduler, CA7, Windows Scheduler, Crontab Sheduling

Metadata Tools: Metadata Hub (Ver 3.1)

Data Profiler & Cleansing: AbInitio Data Profiler (Ver 3.1), Quality Stage

Data Modeling: ERWin, ERStudio

Other Tools: Toad, Microsoft Visio, Mercury Quality Centre, ServiceNow, Remedy, JIRA

EXPERIENCE HIGHLIGHTS:

Confidential

Technical Architect/Manager

Responsibilities:

• Designing EME Project Architecture for all the projects moving to the new environment
• Setting up EME branching for multiple environments and formulate code migration strategy
• Creating generic graph and logging framework
• POC for Voltage Encryption integration with AbInitio jobs
• Defining standards and best practices in new environment
• Re-designing existing applications as per new standards
• Managing vendor team of 7 members

Confidential

Data Integration Architect/Lead

Responsibilities:

• Setting up best practices and standards for Data Lake AbInitio Integration code
• High Level and Low Level Designs
• Design, Graph and Plan reviews
• Development of generic scripts and graphs
• Ensuring all the datasets are proper for appropriate representation in Metadata Hub
• Importing and resolving Metadata imports issues. Approving different changesets
• Managing users and roles on Metadata Hub
• Planning for overall build for AbInitio for different Development Phases.
• Tracking and managing overall delivery for AbInitio.
• Setting up new ODC with 49 capacity at Hinjewadi, Pune for SunTrust
• Manage Supply, Distribution, Continuous Development and A2A (Application to Application) Pune teams with overall team size of 16.

Confidential

Technical Manager

Responsibilities:

• Planning for overall build for AbInitio and Control-M for COFE Re-platform Project.
• Tracking and managing overall delivery for AbInitio and Control-M for COFE.
• Setting up best practices and standards for AbInitio environment
• Design and Graph reviews
• Managed AbInitio team
• Managed Control-M team

Confidential

AbInitio Technical Lead

Responsibilities:

• Design and Graph reviews
• Generic graphs development
• Generating configurations of Express>IT templates
• Managing team of 5 members on development and support activities

Confidential

AbInitio Consultant/Administrator

Responsibilities:

• Leading the offshore team of 4 members
• Setting up best practices and standards for AbInitio environment
• Estimating and Managing Service Requests
• Design and Graph Reviews
• Level 3 support and monitoring using AbInitio Control Center
• Impact Analysis of Service Requests using AbInitio Metadata Hub
• Automation of recurring maintenance tasks
• Performance Tuning of the graphs
• Worked on EME code migrations across different environments.
• User administration on AbInitio Metadata Hub and AbInitio Operations Console
• Maintenance of Metadata Hub Import Feeds and Import Rules
• GDE and Server AbInitio License Management
• Maintenance of Application Hub and Web Application Servers
• Development and trouble shooting for different AbInitio graphs

Confidential

AbInitio Lead/Architect

Responsibilities:

• Setting up best practices and standards for AbInitio environment
• Leading a team of 2 members onshore and 8 members offshore
• Estimation for the different requests coming from the client
• Design and Graph reviews
• Designing for various graphs on AbInitio
• Common and Generic graphs development
• Installation and setup of Elementum server
• Installation and setup of AbInitio Gateway server
• Coding and trouble shooting for different AbInitio graphs
• Unit Testing for the graphs
• Performance Testing and Tuning of the graphs

Confidential

AbInitio Lead

Responsibilities:

• Leading the team of 11 members
• Estimation for the different requests coming from the client
• Coding and trouble shooting for different AbInitio graphs
• Graph reviews
• Unit Testing for the graphs
• Supporting SIT and UAT activities