Etl Lead Mbna Phase 1 Resume
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, UKETL 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.
ConfidentialETL 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
ConfidentialIntegration 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
ConfidentialArchitect/ 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
ConfidentialETL 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
ConfidentialETL Lead
Responsibilities:
- Development and unit testing of Ab Initio graphs
- Code reviews and peer reviews
- Creating technical design documents
Environment: Ab-Initio, Unix.
ConfidentialETL Developer
Responsibilities:
- Code reviews and peer reviews
- Creating technical design documents
Environment: Ab-Initio, Unix, Redbrick, Netezza