We provide IT Staff Augmentation Services!

Etl Lead Mbna Phase 1 Resume

3.00/5 (Submit Your Rating)

UK

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.

Confidential, UK

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.

Confidential

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

Confidential

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

Confidential

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

Confidential

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

Confidential

ETL Lead

Responsibilities:

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

Environment: Ab-Initio, Unix.

Confidential

ETL Developer

Responsibilities:

  • Code reviews and peer reviews
  • Creating technical design documents

Environment: Ab-Initio, Unix, Redbrick, Netezza

We'd love your feedback!