SUMMARY:

• Over 9.5 years of extensive IT experience working in Analysis, Design, Development, Testing and Implementation of Data Warehousing and Business Intelligence solutions for Confidential and Confidential industries.
• Strong DW ETL experience in Informatica Power Center 9.6/9.1/8.6/8.5 , Informtica Power Exchange, Unix, BTEQ and Showcase Warehouse builder
• Basic hands on experience in SSRS Reporting solutions.
• Working in SAFE and Agile methodology for last 4 years.
• SAFE 4.0 certified and current project is operating in Distributed Agile with 80% offshore team.
• Vast SQL knowledge and Database experience in UDBDB2, Teradata, MSSQL, Sybase and Oracle.
• Strong in relational database design concepts, played data modeler role and hands - on experience in Power Designer and Rochade
• 4.5 years of onsite experience in US interacting with Business users and SMEs in analyzing the business process requirements and transforming them into documents, designing and rolling out the deliverables
• Implemented several ETL solutions and data warehousing projects working with leading clients Healthnet, WellPoint and Northwestern Mutual Confidential
• Good Experience in Effort and Cost Estimation, Project Planning (Resourcing, Requirement gathering, Design, Build, unit testing, QA support and UAT support), and Configuration Management.
• Led the team in multiple PI planning events and played key role in System demos, PI plan reviews and Inspect and Adapt sessions.
• Performed Development Lead roles to run the Enterprise Projects as single member at onsite and leading the offshore team providing guidance and support and manage the deliverables.
• Played Project/Support transition lead role in multiple assignments coordinating the activities with different teams and ensured smooth transition of applications.
• Quick learning and understanding of client system architecture makes asset to any project, with excellent logical, analytical, communication and organizational skills
• Involved in functional and technical analysis, design, system impact analysis, gap analysis and documentation
• Ability to meet deadlines and handle multiple tasks, flexible in work schedules and possess good interpersonal and communication skills

TECHNICAL SKILLS:

ETL/ Reporting tools: Informatica PowerCenter 9.6/9.5.1/8.6.1/8.1.1, Informatica Power Exchange, Showcase Warehouse builder, SSRS

Scheduling tools: Autosys, WLM

Database: UDBDB2, Teradata, SQL server, Sybase, Oracle

Database Tools: Rapid SQL, Teradata SQL assistant, TOAD, SQL Developer

Programming Languages: Unix Shell script, BTEQ, C

Testing Tools: HP Quality Center

Documentation and Management: MS Office toolset, Visio, Sharepoint, TFS, LeanKit

PROFESSIONAL EXPERIENCE:

Confidential, MILWAUKEE, WI

DEV LEAD

• Joined the Project core team as development lead during initial phase and led the team till the project closure
• Responsible for managing the delivery of three offshore teams during project execution.
• Responsible for conducting the agile/safe ceremonies for the distributed agile teams and represented team in the PI planning and system/solution demos
• Handled communication with various teams in the enterprise as development/deployment lead for FSS Project
• Interacted with various business areas in company and socialised the project need and business benefits along with Project steering committee
• Responsible for presenting the designs approaches and get the approvals from Enterprise architecture teams.
• Responsible for submitting the impact analysis on 30+ compliance applications while adding new unique identifier for field staff.
• Coordinated various department deployments and channelized the communication process to compliance departments from project standpoint.
• FSS Project put forward new idea of bypassing the legacy system data flow with an alternate path using BIIP (New enterprise DB2 platform) and get the data to Compliance through Informatica ETLs as and when required.
• Involved in all the production issues and defect fixes that has been taken care as part of the project .

Confidential, MILWAUKEE, WI

DEV LEAD

• Lead the s mall and large project team activities for the application changes from onsite for Compliance Best Practices
• Responsible for getting the business requirements form the business clients and work towards proposing the feasible technical solutions
• Responsible for analysing requirements and come up with design approaches using various technical methodologies
• Leading the offshore team and make sure all the questions and constrains are discussed with clients and provided proper guidance for completing the technical changes in time.
• Responsible for proposing the new enhancement ideas with their estimate cost and time lines
• Implemented several Informatica and Unix ETL solutions in Compliance space interacting with various source system like EBIS, IPS and vendor Broker interfaces like Etrade, Vanguard, Schwab etc
• Work with Mainframe Engineers and take care of ETL Informatica solutions to load the mainframe data into various Compliance applications using Power exchange.
• Responsible for working with data specialists and data modellers and put forward the new requirements data modelling changes for the project
• Responsible for taking care of all the deployment activities from onsite working with various migration teams with in the organisation
• Played the role of primary contact for Complaince application support
• Responsible for proving support to offshore teams during critical times and handle firefighting situations.

Confidential

TEAM LEAD/MEMBER

• Smooth handling of daily KT sessions from the vendor for a period of one month
• Understanding the entire process flow and logics in the Individual Infomart.
• Was responsible for presenting reverse KT for the vendor and to submit the Infomart application architecture understanding documents to client.
• Had taken the ownership of the production deployment of one release which was developed by vendor team and provided the warranty support
• Taken the lead role for the two Infomart releases as part of source repointing.
• Was responsible for preparing the analysis documents for the 2013 releases
• Requirement gathering and preparation of TSD and design approvals for SSCR projects
• Development of BTEQ scripts and INFA workflows.
• Involved in testing and troubleshooting the scripts and providing the solutions.

Confidential

TEAM LEAD/MEMBER

• Leading the development activities from offshore for ECR small group projects.
• Was responsible for analyzing the data model for the new data mart and provided the required changes as per the business needs.
• Was responsible for providing the technical specification documents and the necessary SDLC documents as per the Customer standards.
• Was responsible for mentoring and training team and to coordinate all the development activities with onsite counterpart
• Development of BTEQ scripts and Informatica mappings and workflows for the Membership module
• Taken the lead role for the entire SDLC process and production deployment
• Handled the daily status calls and coordinated the development of Segmentation piece from Bangalore team
• Has prepared the Test plan and Test case documents on time for Unit testing. .

Confidential

TEAM LEAD/MEMBER

• Development and testing of ETL jobs based on the business requirements
• Maintenance of the daily production jobs and handling the issues in SLA time.
• Minor Enhancements and Project on Performance improvement on DW jobs.
• Requirement gathering and preparation of TSDs and Test case documents for Minor Enhancements on DW
• Being part in preparation of KT document and reverse KT PPT presentation to client during starting of the project.
• Analysis and handling issues in AS/400 RPL/CL Programs as part of ETL jobs
• Handling the Service Requests and Remedy Tickets on Data warehouse production and resolving in issues and achieving 100% SLA
• Conducted trainings and KT sessions for new joiners and DW basics trainings to team members in Confidential vertical.
• Played key role in up-gradation of Showcase 6.5 to 8 versions.