SUMMARY:

• Seeking Senior level assignments in Data Integration/Datawarehousing ProjectsConsultancy and Project Management including involvement in Service Delivery Operations with an Organization of high repute in IT sector.
• A Technology - Driven Data Integration and ETL Professional with 11 years of comprehensive and in-depth experience in managing and implementing Data Integration and Design Projects for all phases of SDLC globally in UK, USA and India for top notch fortune 500 Financial Institutions. Extensive Knowledge and experience on working in BI & Data warehousing projects within Retail Banking & Financial Services and Credit Cards domain utilizing ETL tool Ab Initio as a backroom for loading datawarehouses with meaningful and valuable data for business.Insightful Knowledge of Data Management, Data warehousing and has good exposure to Proof of Concept (POC) design andSolution Designing.
• In my various consulting roles through the years, I have acquired strong stakeholder management skills and exposure to various proven industry standards which will help me provide strategic inputs to any future role I am involved with.
• In my career i worked in ascending order from developer to Seasoned ETL Architect to Applications Delivery Manager and Implementation Manager.
• I am exposed to risk analysis to quality management with skills of leading and motivating individuals to maximize levels of productivity; a customer-centric professional and knack for pushing large workforces for exceeding customer expectations in delivery of committed services and products.
• Worked and managed the Data Integration and datawarehousing projects at a role of Applications delivery manager and handled projects from inception to implementation.Delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with business change managers, technology managers and businesssponsors .
• Gathring business requirements and preparing design and technical specifications to fit into enterprise architecture level.
• Following up the Ab Initio standards and using best Ab Initio practices to give performance oriented solutions surrounding around ETL Ab Initio.
• Worked on best practices, technical blueprints, updating enterprise data models, and promoted them to the implementation teams, so there is no discrepancy between what CDO defines and what project team implements.
• Good understanding of metadata management best practices to implement a succesfull metadata repository.
• Leadership experience in Data Management activities, including Data Architecture and Data Modelling (logical and physical).
• Participated in data architecture reviews of applications as part of the project lifecycle and ensured that data governance processes are established and integrated in existing systems as well as in the formation of new and revised systems.
• Worked on both Banking and Insurance Domain.
• Designed and created numerous Data mappings/workflows to move data from source to target data warehouse as per business needs.
• Performed Conceptual Data Modeling, Logical Data Modelling, Physical Data Modeling and worked with different Solutions Architects from client end.
• Exposure in technical presentation, client liaison.
• Experienced in full life cycle of Software design process (SDLC) including requirements gathering, design, development, documentation, implementation and testing.
• 11 years of experience in working with one of the finest ETL tool Ab>Initio and its all versions.
• Experience in designing, developing and deploying Ab Initio Graphs, coordinating testing and production stages, trouble shooting and performance enhancement.
• Well developed business and requirements analysis skills, including good communication abilities (both speaking and listening) and stakeholder management (all levels up to managing director)
• Very well versed with ETL processing.
• Exposure in working on Unix Shell environment.
• Very good understanding of Data Warehousing Concepts.
• Vast experience of working with direct Bank Business Analysts and Solution Architects
• Hands on with Erwin data modeler for designing Business data models.
• Ability to understand SQL statements and relational database internal processes
• Highly motivated with ability to work efficiently in teams as well as independently.
• Integral part of ETL architects team providing Data Quality, ETL and reporting solutions.
• Expertise in handling Offshore-Onsite Coordination and handling big teams from client site.
• Highly proactive, with strategic sense to identify, anticipate and mitigate issues.
• Have ability to bridge disagreement and misunderstanding, creating ‘win-win’ solutions and fostering shared responsibility for both successes and failures
• Big data understanding, BasicHadoop framework Architecture and its whole ecosystem including awareness of other Apache projects.
• Worked in distributed and multicultural working environment. Results oriented and always keen to learn new technologies to acquire more business skills.

TECHNICAL SKILLS:

DATAWAREHOUSE TOOLS: Ab>initio 2.x, 3.x

OPERATING SYSTEMS: Mainframe MVS, UNIX (HP, Solaris) and Win-NT

LANGUAGES: C, C++

DATABASES: Oracle 10g, DB2

CASE TOOLS: Visio, ERWIN

SHELL & UTILITIES: Korn, BASH, CSH

ANALYTICAL TOOLS: Aware of use of TRIAD system by Confidential .

PROFESSIONAL EXPERIENCE:

Confidential, New York

ETL Ab Initio Project Lead

Responsibilities:

• Working for a Retail Banking Project in Confidential department to create, implement and maintain a one stop datawarehouse solution framework to store Confidential information for all bank customers enrolled in different products offered by bank.
• This will help bank to facilitate all customer information within and across countries to make decisioning on High Risk, Medium and low risk customers while issuing banking products or making periodic reviews on customers.
• I am working as an ETL Ab Initio Project Lead handling and maintaining direct communication with technology, business stakeholders and Business Analysts to make informed decisions on the project and keeping them appraised on project status. Also handling onshore-Offshore teams to review and prioritize work to make healthy and effective communication between teams.

ETL Applications Delivery Manager

Confidential, Chicago

Responsibilities:

• Lead a team of 30 team members for a Service Delivery project involving transition of 23,000 ETL jobs developed in Ab Initio from a competitor vendor who is serving Confidential from last 10 years.
• Provided all ETL guidance to team and succesfully completed the turnaround of Project and won confidence of client by supporting all the ETL service operations without any interference of competitor vendorin stipulated timelines.
• This leads topermanent billing for all 30 resources.
• Apart from this i am involved in all the COE operations related to new Data Integration ETL projects which majorly involves Ab Initio.

ETL Lead

Confidential, Chicago

Responsibilities:

• Working as ETL Ab>Initio Designer/Planner to create Batch and Real time applications by designing a Web Services Generic framework to be reusable across different projects.

Confidential

Responsibilities:

• Confidential is a batch process to utilize a generic framework of Data Management Framework System (DMF) to process more that 1500+ feeds of Transunion Products and create the Products data lookups and Indexes to form Confidential ’s (Indexed compressed flat files).
• These Confidential ’s are being utilized in the Real time application Confidential to process Consumer’s Products requests online via the Confidential Services and return the credit rating information about the customer’s.

Confidential

Ab Initio Designer/Project Lead

Responsibilities:

• Providing consultancy in ETL Projects involving Analysis, feasibility study, Requirement Gathering, identify the data requirements and information gaps and outlined the diverse steps to build an integrated data system, finalizing data models, Creating Technical Specs, Mentoring, Data Integration, data modeling, Ab Initio Design and development of graphs, testing,and implementation of projects and delivering to Production environment to load data marts in their data warehouse.

Confidential

ETL Ab Initio designer/Lead

Responsibilities:

• This will cater Authorizations at point of sale, ongoing collection accounts management, Plastic issues and payment hold decisions.
• TRIAD 8.5 decisioning tool supplied by Confidential is at the centre of this process to implement the final decisioning on the data generated from Confidential process.

Confidential

ETL Ab Initio designer and Architect

Responsibilities:

• Financial Services Authority ( Confidential ) of UK has mandated that Confidential conform to the Payment Services Directive regulations for availability of Funds to the payment service user’s payment account on the same day and in a stipulated time line when payment service user places cash on its payment account with a payment service provider in the same currency as that payment account.

Confidential

ETL Ab Initio Designer and developer

Responsibilities:

• This Project supports different card schemes transactions like Mastercard, VISA, JCB, Switch etc which are accepted at different merchant’s outlets and comes to Confidential via various channels. This project will give huge benefit to bank in retaining their merchants and capturing more merchants in the market by providing a single stop of all high class services.