SUMMARY

• 17 years of IT consulting and software development experience in multiple sectors including Banking, Financial Services, Retail, Insurance, Telecom and Public sectors
• IT Consultant with 17 years of experience in specializing in project management, team leadership, analysis design, development, maintenance, architecture and post production support
• 9 years of strong leadership and consulting experience. Supervised and Administered various teams ranging from 2 to 15 team members
• 12 years of technical experience in ETL data integration, Data Warehouse and Business Intelligence (OLAP/Reporting) applications
• Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica and Datastage
• 12+ years of Relational Database experience like Oracle (10g/9i/8i/8.x), DB2 9.x, SQL, PL/SQL, SQL*Plus
• 10 years of experience handling various Finance clients like Confidential, Confidential and Confidential
• Proven skills on estimation, project planning, execution, team building, communication, resource planning and forecasting, strategic planning, project tracking, quality improvement, system/process designing, business development, customer relationship management, presentation and status reporting
• Adherence to Process, Quality and Documentation in compliance with CMM Level 5
• Efficiently utilized the team by forecasting, proactive planning and resource levelling
• Exhibited excellent team building and motivating skills by arranging induction and trainings programs, reward systems and out of the work team building events
• Experience in coordinating development and production maintenance efforts from contracts and outsource technical teams in a global environment
• Hands - on experience leading all stages of system development efforts, including requirements definition, system analysis, design and development, testing, maintenance and support
• Received customer appreciations regularly and achieved Single Source/Business Partner status with the customer
• Excellent communication skills, able to explain complex technical structures in an understandable user-friendly format

TECHNICAL SKILLS

Database Development: ORACLE 8i, 9i and 10g, 11g, DB2 9.5, PL/SQL, SQL*Plus

Programming Languages: Visual Basic.NET, Visual Basic, C++

Data warehousing Tools: Informatica Power Center 7.0 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer), IBM Infosphere Datastage 11.5, Infosphere Information Server, IBM InfoSphere Master Data Management(MDM)

OLAP/Reporting Tools: Cognos 8, Crystal Reports, Tableau, SAP Reports

Tools: /Products: Toad, FileNET, Robo Help, Microsoft SharePoint and Microsoft Infopath, Salesforce CRM

Operating Systems: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Consultant

Responsibilities:

• Worked as Sr. ETL Developer during the analysis, planning, design, development, and implementation stages of projects
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into theORACLEdatabase
• Design and Develop ETL solutions based on business requirements
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design
• Involved in system analysis, design, development, testing and documentation of Bell DTH/ Bell WHI Projects
• Worked In agile/scrum mode and developed tables for SAP reports
• Created unix scripts for handshaking between different systems in Confidential
• Perform unit testing, support quality assurance testing, and conduct performance testing and optimization
• Review of deliverables and take ownership on any defects in the delivery
• Involved in Impact analysis of user queries, planning and scheduling of fixes
• Analyze identified Client and User problems, estimation, planning and scheduling of fixes
• Helped in fixing of Integration testing and Acceptance Testing issues/defects
• Status reporting and resolving issues within the team and with the customers

Environment: Oracle 11g, IBM Datastage 11.5, Infosphere Information Server, Jira, ERWIN, SAP Reporting, CA7 Scheduler

Confidential

Senior ETL Developer

Responsibilities:

• Designed and developed DataStage jobs, job sequences to implement the business requirements and design specifications
• Performed various data operations using IBM Datastage
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Worked in IBM Maser Data Management tables (MDM) for Customer Contact Transformation Project
• Used and worked in Salesforce (agile accelerator) for project and test life cycle and for workload tracking
• Worked In agile/scrum mode and developed dimensions and fact tables for Tableau reports
• Created Unix scripts to automate ETL loads based on business requirement
• Liaison between Business Analysts and development team to define and finalize business rules and data formats
• Review of deliverables and take ownership on any defects in the delivery
• Involved in Impact analysis of user queries, planning and scheduling of fixes
• Responsible for Unit testing, QA testing and Integration testing of the system
• Supports users during functional, UAT, regression, and performance testing
• Involved in production implementation and production support of the entire system
• Support after the implementation and resolving post implementation problems

Environment: DB2 9.5, Unix, IBM Datastage 11.3, Infosphere Information Server, IBM InfoSphere Master Data Management(MDM),JobTrac Scheduler, Tableau (Reports, Dashboard), IBM MDM, Salesforce CRM

Confidential

Lead Developer

Responsibilities:

• Successfully exhibited Analysis, System Design, Development and Delivery skills with outstanding quality using IBM Datastage and DB2
• Involved in design and development of Data Mining Project which mines all Business Corporations across Ontario to find likelihood of Tax defaulters
• Responsible for installation, configuration and testing of latest version of Datastage
• Worked in FAIRS project to build one single shared warehouse from ONTTAX database
• Created various Cognos Reports for Auditors and Collectors in Confidential
• Worked in migrating ICS system data/reporting to IBM datastage
• Participated in requirements gathering and analysis sessions for Collections project
• Created Mapping document, Design document for every Major production release
• Work load balancing based on the requests and priorities of the activities
• Responsible for Unit testing and Integration testing of the system
• Involved in production implementation and production support of the entire system
• Support after the implementation and resolving post implementation problems
• Providing solutions to technical problems encountered during enhancements

Environment: DB2 9.5, Unix, IBM Datastage 8.7, Infosphere Information Server, CA7 Scheduler, ERWIN, Cognos (Reports, Dahsboard)

Confidential

Project Lead/ Sr.Informatica Analyst

Responsibilities:

• Managed a team of 5 BI resources at India-offshore
• Successfully Coordinated with the customer and offshore team located in India to execute projects
• Coordinate and guide the team on the work requests and deliverables
• Improving team productivity through Knowledge acquisition, retention and documentation
• Mentored the team on the technical, operational and customer handling aspects
• Responsible for requirements gathering from business users, created functional specifications document
• Responsible for creating and maintaining Reporting application, including a detailed schedule and estimating of activities
• Responsible for Analysis, Design, Construction, testing and Implementation using Informatica and Oracle
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extracted data from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to Reporting Database
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
• Involved in ensuring timely and satisfactory recovery and resolution of end-client application issues
• Responsible for Daily Validation and Reconciliation of data using Oracle PL/SQL
• Automated procedures, ensured quality, programming and project management standards were met

Environment: Oracle 10g, Unix, Informatica v7.x

Confidential

Project Lead / Informatica Technical Lead

Responsibilities:

• Managed a team of 8 BI resources at India-offshore
• Responsible for creating and maintaining Project Plan, including a detailed schedule and work breakdown structure and estimating of activities
• Coordinated the Data warehouse team in Analysis, Design, Construction, testing and Implementation
• Responsible for training the team, workload assignment, guiding the team, monitoring the progress, and status reporting until delivery.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Understand the business needs and implement the same into a functional database design.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Responsible for Impact Analysis and automation of 1000 Informatica, Pro*C and Oracle Programs
• Created re-usable transformations/mapplets and used across various mappings
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Designed the Data Mart defining Entities, Attributes and relationships between them.

Environment: Oracle 10g, Unix, Informatica v7.x, Pro*C

Confidential - Minneapolis

Project Lead

Responsibilities:

• Managed a team of 8 resources at India-offshore
• Responsible for creating Business Requirements document and Traceability Matrix for every release
• Provided direction and leadership to the IT team of programmer analysts, systems analysts and technical specialists; including scheduling, assignment, review/monitoring work
• Responsible for creating SOX Audit reports using Cognos Cubes and Cognos Impromptu
• Everyday interaction with 12 to 15 business users to create security administration documents and upload them onto SharePoint
• Automated Audit application using Microsoft Visual Basic.NET
• Coordinate and guide India offshore team on the work requests and deliverables
• Responsible for creating and maintaining Project Plan, including a detailed schedule and work breakdown structure and estimating of activities
• Prepared process fulfillment documents for 125 types of requests flowing in Confidential Corporation
• Create Individual Metrics and Team Metrics in SharePoint
• Review and update the Functional documents in SharePoint

Environment: Oracle 10g, Cognos Impromptu, Visual Basic.NET, Microsoft SharePoint and Microsoft InfoPath

Confidential

Project Lead

Responsibilities:

• Managed a team of 16 resources
• Prepared Project plan and updated the same regularly
• Manage the project, ensuring contractual responsibilities are met
• Responsible for task allocation and resource management
• Coordinated in Incorporating the application level security in the product
• Report Design for the entire system using Oracle and Crystal Reports
• Coordinating with the team for design, development and testing of the product
• Analyze identified Client and User problems, estimation, planning and scheduling of fixes
• Helped in fixing of Internal Acceptance Bugs and Acceptance Testing Bugs.

Environment: Oracle 9i, Java, Java Script, Html, Crystal Reports

Confidential, Buffalo

Project Lead

Responsibilities:

• Interacted with the users and collected requirements for every project
• Maintained client applications using IDM Desktop objects and Visual Basic .NET
• Designed an automated utility tool for uploading and updating of data in all tables
• Design and development of VB and VB.NET screens.
• Report Design for the entire system using Oracle and Crystal Reports
• Prepared Project plan and updated the same regularly
• Prepared Technical Design Document and Functional design document for every project.
• Involved and interacted with Clients in High Level Design, Low-level design.

Environment: Oracle 8i, Visual Basic.NET, Visual Basic, Visual Source Safe, FileNET, Crystal Reports

Confidential

Developer/Module Leader

Responsibilities:

• Design of GUI screens and Business validations for the entire system
• Performed Unit Testing and system testing using Visual Basic and Oracle.
• Report Design for the entire system using Oracle and Crystal Reports
• Report Design for the entire system.
• Fixing of Internal Acceptance Bugs and Acceptance Testing Bugs for the entire system/project.

Environment: Visual Basic, Visual C++, Oracle 8i, Crystal Reports, MQ Series, CICS, DB2, Robo Help, Oracle 8i, Toad