SUMMARY

• Accomplished Technical Project Lead/Manager with around 13.5 years of overall experience.
• Expertise in SDLC (Analysis, Design, Development, Testing, Implementation and Maintenance) of Data Warehousing projects having extensive experience as a consultant in Healthcare/Insurance sector for more than 12 years and Banking sector for around 1.5 years. Organized and detail - oriented with proactive and hard-working nature.
• Oversee multiple projects across all phases and work as part of an inter-disciplinary team to achieve project milestones.
• Develop PM Plan, CM Plan, Status Reports, Cost Estimates and Resource Plans.
• Collaborate with business and vendors for Requirements elicitation and proper expectations setting.
• Mentor and guide team to implement and maintain development best practices.
• Provide End to End Design solutions for ETL flow including High-Level Design and Low-Level Design.
• Define Development framework, Testing strategy and Deployment Plans.
• Review Design, Code, Test Cases and assist in Root cause analysis of defects.
• Prepare SDLC checklist, make vital decisions and drive decision-making across the board.
• Coordinate various client meetings with stakeholders like walkthroughs of Requirement document, Design document, Project milestones, Status reports, Knowledge transition etc.
• Maintenance and support of Production environment at Enterprise level using various scheduling tools like WLM, Tivoli etc.
• Expertise in Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Teradata, Oracle, DB2, Flat files, XML files using Informatica PowerCenter.
• Extensive Experience in database design, data staging and implementation for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Worked on multiple databases like Oracle, Teradata, DB2, SQL Server as the back-end of ETL development.
• Unix Shell scripting, SQL Query tuning and optimization/reconciliation of the ETL code.
• Worked on Informatica PowerExchange to create data maps for Mainframe VSAM files and databases and CDC implementation.
• Good knowledge of Informatica Cloud, R programming and basic understanding of Hadoop concepts including Pig and Hive languages.

TECHNICAL SKILLS

Data Warehousing tools: Informatica PowerCenter/PowerExchange/Cloud, Teradata Utilities FastExport/BTeq/FastLoad/MLoad/TPump, Cognos Powerplay

Databases: Oracle, Teradata, DB2, SQL Server

Programming language: SQL, PL/SQL, Unix shell script, R programming, Pig/Hive, HTML, Core Java

Tools/Utilities: MS Word, Excel, Outlook, PowerPoint, Visio, Citrix, ClearQuest, WLM, Tivoli, Mercury Test Director, VSS, Clear-case, SharePoint, HP Service manager, ServiceNow

Operating systems: Windows, UNIX

Soft skills: Lead/Management, Seeing the Big Picture, Delegating/Mentoring Team, Resilience, Process improvement, Decision making

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead/Manager

Responsibilities:

• Provide project level effort estimations and Requirement analysis for new enhancements.
• Supervise end to end design of the ETL flow and provide High level as well as Low level design documentation.
• Conduct best practices as per coding standards, Lead code reviews and provide feedback.
• Design Unit testing framework as per requirement, Lead Unit test plan reviews and provide feedback.
• Conduct thorough unit testing and integration testing.
• Evaluate project data for accuracy and take the lead in setting project targets and priorities.
• Provide accurate and detailed weekly task status reports to client.
• Conduct project risk identification and mitigation action planning.
• Mentor and guide team to complete the assigned tasks to meet the aggressive timelines.
• Supervise production deployment and post production support.

Confidential

Tech Lead/Manager

Responsibilities:

• Provide project level effort estimations and Requirement analysis for new enhancements.
• Supervise end to end design of the ETL flow and provide High level as well as Low level design documentation.
• Conduct best practices as per coding standards, Lead code reviews and provide feedback.
• Design Unit testing framework as per requirement, Lead Unit test plan reviews and provide feedback.
• Conduct thorough unit testing and integration testing for the new enhancements.
• Evaluate project data for accuracy and take the lead in setting project targets and priorities.
• Provide accurate and detailed weekly task status reports to client.
• Conduct project risk identification and mitigation action planning with the project manager.
• Mentor and guide team to complete the assigned tasks to meet the aggressive timelines.
• Supervise production deployment and post production support.

Confidential

Tech Lead/Manager

Responsibilities:

• Provide project level effort estimations and Requirement analysis for each phase of the project.
• Supervise end to end design of the ETL flow and provide High level as well as Low level design documentation.
• Conduct best practices as per coding standards, Lead code reviews and provide feedback.
• Design Unit testing framework as per requirement, Lead Unit test plan reviews and provide feedback.
• Conduct multiple data analysis as per Association’s feedback on Test data for each phase to get Level 1 to Level 4 Certification from Association.
• After getting Level 4 Certification supervise production deployment and post production support.
• Provide accurate and detailed weekly task status reports to client.
• Conduct project risk identification and mitigation action planning with the project manager.
• Mentor and guide team to complete the assigned tasks to meet the aggressive timelines.

Confidential

Tech Lead/Manager

Responsibilities:

• Provide project level effort estimations and Requirement analysis for each phase of the project.
• Supervise end to end design of the ETL flow and provide High level as well as Low level design documentation.
• Conduct best practices as per coding standards, Lead code reviews and provide feedback.
• Create a Managed File Transfer (MFT) process with help of MFT team to accept new pharmacy files from third party vendors Caremark and Medco for new account.
• Create Mainframe GDG with help of Mainframe Admin to maintain Rx files on Mainframe server for new account.
• Convert the EBCDIC format source file into ASCII format using Informatica Power Exchange and load the data into landing zone using ETL process.
• Create new partitions to the landing Zone tables for each new account and load the pharmacy data from landing zone to three layers of EDW database, ODS schema, UPH schema and IHS schema.
• Create process to finally send data to downstream applications like Care-Radius, Optum, Value Option and ViPS/GDIT for reporting purpose.
• Provide help to 3rd Party Rx production support team for any ad-hoc queries and production issue remediation.

Confidential

Tech Lead

Responsibilities:

• Analysis, design, coding and testing of Small group and Consumer module enhancements
• Preparing technical design documentation for Small group and Consumer module enhancements
• Providing Production support and defect fixes for Small group and Consumer module enhancements
• Analysis, design, coding and testing of Medicare and Medigap modules
• Preparing technical design documentation for Medicare and Medigap modules
• Providing Production support and defect fixes for Medicare and Medigap modules

Confidential

Tech Lead

Responsibilities:

• Analysis and design of claims and eligibility modules
• Design Unit testing framework as per requirement, Lead Unit test plan reviews and provide feedback.
• Coding and unit testing of claims and eligibility modules
• SIT support for defect fixes and code deployment to production
• Taking over additional modules and getting production issue fixes for the same
• Mentoring the offshore team to complete the assigned tasks

Confidential, Richmond VA

Tech Lead

Responsibilities:

• Analysis of RIMs for existing code fix / enhancements
• Preparing approach for the RIMs and conducting SDLC processes to implement the same in production
• Production issue fix and supporting the PRC team in production runs
• Mentoring the offshore team to complete the assigned tasks

Confidential, Richmond VA

Tech Lead

Responsibilities:

• Analyze source systems and business requirements
• Creating Requirement Documents and Conducting Requirements walkthrough with all the project stakeholders
• Helping onsite and offshore development teams in Requirements understanding
• Map the requirement to the corresponding elements as part of the design.
• Review Technical Design documentation and Unit test cases
• Conducting SDLC processes to meet the requirements of different phases of the project including deployment in production

Confidential

ETL Lead

Responsibilities:

• Resource co-ordination and mentoring the team to complete the assigned tasks
• Analyze source systems and business requirements.
• Map the requirement to the corresponding elements as part of the design.
• Technical Design documentation and Unit test cases.
• Development of code to load data to the target tables from different sources.
• Unit testing for the respective modules and technical review.

Confidential

Business System Analyst

Responsibilities:

• Functional and Non-functional business requirements elicitation
• Analyze business requirements and convert them in a technical documentation format

Confidential

Lead/Senior Analyst

Responsibilities:

• Resource co-ordination and mentoring team to complete the assigned tasks
• Analyze source systems and business requirements.
• Map the requirement to the corresponding elements as part of the design.
• Technical Design documentation and Unit test cases.
• Development of code to load data to the target tables from different sources.
• Unit testing for the respective modules and technical review.

Confidential, Richmond VA

Tech Lead

Responsibilities:

• Maintenance and issue fixes of all the EDL and few EDW production jobs and extracts
• Automating the jobs with proper dependencies using scheduling tool WLM
• Review and provide approvals to development teams for production migration in SDLC review meetings
• Catered to ad-hoc requests for code analysis and job runs in production environment
• Having weekly Status calls with client and provide status reports
• Prepared project management documentation like Planview, Traceability Metrix and CM Plan
• Resource co-ordination and mentoring team to complete the assigned tasks