SUMMARY

• More than 8 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Successfully managed BI projects in onshore and offshore locations.
• Extensive experience in design and delivery of large datawarehousing projects.
• Led the Ab Intio Center of Excellence for Confidential
• Trained in Ab Initio architecture and latest product suite from Ab Initio Corp.
• Experience in conducting Ab Intio training including development of training materials
• Strong experience in Software Design and Development primarily in various Data warehousing/Business Intelligence projects.
• Has been involved in Design, Development, and Implementation of Business Applications under UNIX.
• Strong expertise in ETL development, analytics and Data warehousing concepts
• Experience in several RDBMS environments
• Developed a utility (in Perl) for ensuring better deliverables by checking the code for redundancies and compliance with standards.
• Extensive experience in banking (TD Bank, Amex, Confidential Group, JPMChase, Barclays) and telecom (AOL, British Teleom) sector. Worked in Insurance (Standard Life) sector.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player.

TECHNICAL SKILLS

ETL: Ab Initio 3.0.3 (GDE, COOP, EME, Data profiler, BRE), Informatica

RDBMS: Oracle 10g, MS-SQL Server 6.5/7.0, Teradata, Netezza, Redbrick

Languages: C, Shell, Perl, Oracle SQL

O/S: Windows NT/2000 Server, HP-UX 11.1, Linux, Sun Solaris

Scheduler: Autosys, Maestro

Modelling: Erwin, Visio

Processes: Confidential ’s QMS (Quality Management System)

PROFESSIONAL EXPERIENCE

Confidential , UK

ETL Lead MBNA Phase 1

Responsibilities:

• Responsible for leading a project team in delivering solution to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer.
• Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Ab Initio GDE and Coop 3.0.3, Web Services, EME, BRE, Metadata Hub, Oracle, Foxpro, SQL Server and AIX.

ETL Lead 

Responsibilities:

• Responsible for leading a project team in delivering solution to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing estimation, scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Ab Initio GDE and Coop 3.0.3, Wed Services, EME, BRE, Metadata Hub, Oracle, Foxpro, SQL Server and AIX.

ETL Lead Barclays

Responsibilities:

• Responsible for leading a project team in delivering solution to our customer in the Finance sector.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the project.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in BI and ETL and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Key projects handled so far include UKRB-FSCS, Customer Matching SCV

Environment: Ab Initio GDE 1.15, COOP 2.15, EME, BRE, Teradata, Tivoli, HP-UX

Integration Analyst

Responsibilities:

• Work with Business in translating business requirements into Functional Requirements Document and to Detailed Design Documents
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization; Analyze product impact
• Interaction with CRM and Legacy teams and creating the functional requirements.
• Delivery management in Agile Methodology.
• Present and defend product designs and architecture to clients
• Coordinate and communicate tasks with developers
• Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product
• Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process

Environment: Ab Initio(GDE, EME, Coop, Continuous Flows), TIBCO, Chordiant, Oracle, Teradata, Erwin, Cognos, Unix

Architect/ BI Project Lead

Responsibilities:

• Handled Multiple roles and responsibilities; Lead architect, Designer, project manager in the BI project as well as one data migration project.
• Outside the BI requirements, implemented integration and migration of heterogenous databases into Oracle using Ab Initio as the data migration tool.
• Spearheaded the whole effort and successfully migrated Ab Initio environment from 2.13 to 2.15.
• Delivery and resource management
• Designed and developed ETL codes. Involvement in architecture, design and review as well as data modelling.

Environment: Ab Initio, Linux, SAS, SQL Server 2005, Oracle, PL/SQL, Autosys, Erwin,SAS

Confidential

Architect/ BI Project Lead

Responsibilities:

• Liaison with Ab Initio Corporation
• Conducting various trainings and workshops in and out of Confidential .
• Asset development
• Engaging in presales support, working with RFPs
• Providing delivery support to various projects.
• Consulting assignments in various client locations
• Taking interviews, mentoring and helping in resource development.

Environment: Ab Initio GDE, EME, BRE, Coop, Data Profiler

ETL Designer

Responsibilities:

• Creating the ETL design documents
• Design and code review
• Effort estimation
• Interacting with modeling and reporting team to finalize the design

Environment: Ab Initio, Linux, OBI, Oracle

ETL Lead

Responsibilities:

• Development and unit testing of Ab Initio graphs
• Code reviews and peer reviews
• Creating technical design documents

Environment: Ab-Initio, Unix.

ETL Developer

Responsibilities:

• Code reviews and peer reviews
• Creating technical design documents

Environment: Ab-Initio, Unix, Redbrick, Netezza