Data Sales

Ramakrishna Ponnapalli +1-714-***-**** ***********.**********@*****.***

Designation

ETL & DW Principal Consultant Current Location Princeton NJ US

Experience

16+ Years

Summary

** ***** ** **tensive technical experience as Project Lead/Solution Architect/ Business Analyst / Data Architect implementing large and complex data warehousing and ETL projects, Data Integration projects and client-server applications.

Primary Skills: MSBI-SSIS 2012/2014/2016, SSRS, SQL Server, VB.Net, C#.Net, ASP.Net, ADO.Net, Oracle, JSON, Power BI, AWS (GLUE, S3, Redshift, Athena, GITLAB, SCALA, Python).

Highly Skilled in implementing advanced DB concepts like SQL, functions, procedure, indexes, partition, and query optimization.

10+ years of experience in Data Governance, Data Dictionary, Data Flow Design, Data Cleansing and Data Integration.

Extensive experience in defining Data Integration strategies, Enterprise Data Architecture, defining Data Quality standards, Data Modeling, Data profiling, Data analysis, Relational Database Management systems, ETL and Database development and coding standards and maintenance processes.

Participating in technology and business initiatives, implementing technology improvements to Data Warehouse environment. Well versed with data modeling using Star schema, snowflake schema and Data Vault.

Contributing to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business.

Estimating time to deliver the solutions and participating in an agile team meeting.

Working with technical staff and business partners to translate requirements into technical designs and mapping specifications.

Adapting ETL processes to accommodate changes in source systems and new business user requirements.

Implementing and enhancing ETL programs using SSIS, SSAS and SSRS against Microsoft SQL Server Data Warehouse.

Defining and capturing meta-data and rules associated with ETL processes and Developing and testing extraction, transformation and load (ETL) processes.

Performing unit and coordinate the system testing and validation tasks with the business.

Creating and Maintaining technical and user documentation, providing on-call support of the Data Warehouse batch processing.

Well versed with ITIL processes like incident Management, Problem management, service Management, Change management and release management.

Extensive Experience in creating Web and Windows applications using C# and vb.Net.

Leadership experience

Experienced in Project Management and Leading multiple Project Life-cycle Management projects (PLM).

Experienced in providing effective leadership and mentoring development and support teams and also work as individual contributor.

As Project Lead, experienced in creating Weekly Dashboards, Monthly reports and also perform Project Management Review with the Quality team and higher management.

Extensive experience in resource management, conflict resolution and Performance reviews.

Experienced in performing Design reviews, Code reviews and Unit Test Case reviews.

Experienced in handling large projects spread across multiple geographic locations and experienced in providing Leadership and mentoring the teams.

Keeping all the stake holders informed about the project status and mitigating any risks.

Demonstrates interpersonal skills required to successfully work in a team environment and communicates effectively across a variety of stakeholder groups.

Ability to identify opportunities and transform them into quantifiable and achievable initiatives

Proven ability to create and document business requirements, business processes, and project plans.

Experience in defining detailed business requirements to support strategic and/or tactical projects.

Experience in creating business cases, operational models, and financial models.

Dynamic and self-starting individual who is able to work independently or as part of a team with minimal guidance and direction.

Continuously update new skills to keep abreast of industry trends and state of the art technology.

Effectively prioritize and assign work in order to meet deadline and demonstrate excellent written, verbal, and presentation skills.

Effectively communicate with both technical and non-technical users on both onshore and offshore.

Educational Background

MCA (Masters in Computer Applications) in 2003.

Domain Experience

US Health Care Insurance, Pharma and Life sciences, Power Distribution, Manufacturing.

Tools

Languages

C#, VB.Net, PL\SQL, T-SQL, ASP.Net

ETL, BI Cloud Technologies

SQL Server Integration Services 2012/2014/2016, SSRS, Power BI, AWS(GLUE, S3, Redshift, Athena, GITLAB, SCALA)

Databases

SQL Server 2012, SQL Server 2016, Oracle 11i

CRM/Cloud Platforms

Salesforce, Oracle CRM On-Demand

Servers & Tools

Middleware: IIS

IDE: Visual Studio2003/2005/2008/2010/2015

Database: SQL Server 2005/2008/2012/2014/2016, Oracle 10g, Oracle 9i

Design Skills: Object Oriented Programming.

Development Methodologies: Waterfall, Agile methodology

Scheduling: TWS, SQL AGENT, Windows Scheduler, and Auto-sys.

Others

XML/XSLT: XML, HTML 5, CSS

Source Control: SVN, Visual Source safe, MS-TFS

Operating System: Windows NT/2003/2005/XP/7/8 Vista

Genpact Headstrong LLC – 07/03/2019 to Present

Key Projects

Project Name: Commercial Data Repository (CDR)

Client: Otsuka Pharma, NJ

Role: Principle Consultant.

From: 07/03/2019 to Present.

The purpose of this project is to support and maintain the Commercial Data Warehouse repository. The Commercial data at Otsuka is a Repository from multiple sources such as IQVIA, Prometrics, Medi-pro, Veeva, Optum Etc. This primary data includes the Sales, Claims, Sampling Data and analytics. CDR itself acts as a source to multiple downstream applications and provides data to analytics and reporting. The applications components include the landing and loading databases, ETL packages that help data extraction, transformation and loading from multiple source types. Currently working on Migration of CDR to AWS Cloud Platform (GLUE, S3, Redshift, Athena, GITLAB, SCALA).

Take the complete ownership of application and manage the application in onshore-offshore model.

Act as SME and provide leadership to the teams on specific areas of data warehousing and ETL.

Develop Logical and Physical data models, Dashboards for external and internal Customers. Also develop Adhoc reports for stake holders using Power BI.

Perform Root Cause Analysis and solve problems on Data related Issues and Business issues.

Ensure code fixes and changes are applied on time with accuracy and required documentation.

Work with multiple stake holders including Otsuka business, Genpact executive management, project teams, analytics and reporting teams, vendors and all other upstream and downstream systems.

Perform the requirements analysis, functional and data specifications, code files, test the fixes and finally ensure deployment.

Perform the code reviews, test case reviews and deployment documentation reviews.

For enhancements, provide guidance to the team on the finalized requirements, business rules, Intermediate data sources and approach.

Ensure the team adheres to Incident Management, Problem Management, Change management Document and other ITSM processes, procedures and best practices.

Manage and Lead the project to completion within the approved Time, Quality and cost.

Mastech Digital Inc – 10/25/2017 to 05/31/2019

Key Projects

Project Name: PCOM (SQL Server) to CITI (Sales Force) Data Migration.

Client: Pfizer Pharma, NJ

Role: Data Migration Lead

From: 08/01/2018 to Present (Expected Closure 05/31/2019).

The purpose of this project is to migrate SQL Server based products complaints information and attachments to PGS BT’s Complaint Intake, Triage and Investigation (CITI) module, which is a Salesforce Application. The scope of this project is limited to the 3 source systems PCOM Doc base, SQL Data Warehouse and PQC Tracking logs. The data is migrated to two identical systems CITI and CITI Secondary. CITI holds the PCOM records created on or after 1st January 2016, while CITI Secondary will contain PCOM data prior to 2016 and Data from SQL Server data Warehouse. Also, all PCOM records prior to 2016 will be in “Closed” or “Cancelled” state. The migration will be performed using Valiance In-Sight Methodology and migration applications – TRU-console and TRU-migrate Frameworks developed on SSIS. Automated data comparison and validation will be performed using TRU-Compare and the runs are coordinated using TRU-Console.

Analyze the Business requirements and review them with business users / clients, lay down the road map or project plan for data Migration process and data validation processes.

Perform the Data analysis, data profiling and remediation as per Requirements and enable working sessions with the team and clients if required to finalize the requirements.

Provide the finalized requirements, business rules, Intermediate data sources, SQL scripts to the team and help them configure Tru-Migrate, Tru-Compare SSIS jobs to perform the data migration and data validation.

Participate in client meetings and provide regular status updates and data validation reports in multiple stages like dry runs, Validations and Production runs.

Perform and Review the data migrations and validations using configured TRU-Migrate and TRU-Compare tools.

Document and review the validation and Production run test reports and get them signed off from all stake holders and ensure timely completion of project.

Manage and Lead the project to completion within the approved Time, Quality and cost.

Project Name: EDMS Migration.

Client : Reckitt Benckiser, NJ

Role: Data Migration Lead

From: 11/01/2017 to 07/31/2018

The purpose of this project is to migrate data from SQL Server 2012 (Source) into the Salesforce (Target) system. The activities include cleansing and enrichment of rules to map and populate attributes (fields) and data involved in the migration of data. This includes the identification of attributes to be migrated and detailed field mapping and business rules to be applied. TRU-Migrate tool is used to migrate data, and TRU-Compare tool to test and validate data.

Created SQL-server database for data extraction, loading and enrichment.

Created SSIS packages to enrich validate the data as per the business rules and generate output in the form of text files.

Created SSIS packages to consolidate the migration logs and generate summarization reports.

United Health Group / Optum technologies - 12/2007 to 10/2017

Key Projects

Project Name: MA-LTSS

Client: State of MA

Role: Development Lead/ETL, Data Architect

Team Size Handled: 3

From - 11/01/2016 to 10/6/2017

MA-LTSS is a health care program for eligible Mass health members by the state of MA, US. UHG is the TPA for EOHHS to help effectively implement this program. As TPA UHG will provide clinical, administrative/operations, and systems support to the Mass Health program in accordance with Mass Health Regulations for the state of MA.

This is an ETL integration project with “Salesforce” that has the following primary functions

Extract Data like Membership, Physicians, Eligibility, Claims, Pharmacy information, enrollment, Assessment from source systems.

Extract data from multiple source files (Like Text, delimited and XML) and Integrate with “Salesforce” database. This involves cleansing, validating, enrichment and Audit of Data before it is sent to “Salesforce”.

Pull Sales force data and create a Backup database in SQL Server.

Create inputs for LTSS business processes and downstream applications.

Provide data for Analytics and Reports.

Tools / Language Used: SSIS, SQL Server 2016, Task Factory, TWS, Sales force

Contribution:

Lead ETL and Database solution architecture and development.

Worked closely with the Business team to understand and review the requirements.

Defined the data integration strategies, data modeling approach and database design.

Developed the Architecture, Data Model and Data Mart for MA-LTSS.

Worked closely with the Data analysts and understand the data requirements.

Created BRD and technical design documents and several other process documents from user stories.

Designed and developed the ETL packages using SSIS to extract data from delimited files and XML files,

Created stored procedures in SQL server that will cleanse, push this data to sales force.

Created Databases, Tables, Stored Procedure, Views, Cursors and Indexes using T-SQL.

Migrate the data from SQL Server 2012 to SQL Server 2016.

Automated the ETL processes by creating batch scripts and scheduling them on Tivoli Workload scheduler (TWS).

Created the Process and procedure documents and reviewed the documents created by the team.

Prioritize the work and allocate it to team members. Track the progress on daily basis and keep the management informed.

Perform design and code reviews and ensure proper merging and versioning.

Worked closely with the testing team to fix the issues.

Participated in all stake holder and status meetings and provided periodic updates.

Transitioned knowledge to M&O team.

Performed multiple deployments.

Ensured all the Design and training documents and approved for every release.

Project Name: Settlements Plus and E-Incentives

Role: Project Lead and SME

Team size Handled: 6

From - 07/01/2011 to 10/31/2016

This Project creates Incentives to Capitation providers paid every quarterly/Annually for the preventive care provided. This uses Medical and pharmacy Claims, Provider Contracts, Membership and eligibility, Capitation, withholds and payments information to evaluate the incentives to be paid to the provider. This application uses SSIS for ETL, SSRS for reporting, SQL server database, VB.Net, ASP.Net for Front end web application and TWS for scheduling.

Tools / Language Used: SSIS, SSRS, ASP.NET, C#, VB.Net, SQL Server, TWS

Contribution:

SME for S-plus and E-Incentives applications.

Mentored the team of 5 with functional and technical knowledge and created a successful team.

Provide application support as per ITIL processes standards like Service Management, Incident Management, Problem Management, Change Management and Release management.

Prioritize the work and allocate it to team members. Track the progress on daily basis and keep the management informed.

Perform design and code reviews and ensure proper merging and versioning.

Involved in gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation for multiple projects.

Identify the impacted components (Asp.Net web forms, SSIS packages, .Net executables, SSRS Reports, SQL server tables, views and Stored procedures) based on the requirements.

Document the changes that need to be made for each of the impacted components.

Create new SSIS packages to extract, transform and Load data by using Execute SQL tasks, Data flow tasks, Script tasks, Send Mail tasks, Execute Process task, Execute Package Tasks.

Implemented the migration of DTS packages (SQL Server 2000) to SSIS Packages (2008).

Worked closely with the SQL server DBA team and implemented the SQL server Database Migration from 2008 to 2012.

Created Custom, Matrix and sub reports using SSRS.

Created and modified database objects including tables, triggers, views, stored procedures, Indexes and Functions.

Involved in Deployment, scheduling and Running SSIS packages on SQL server.

Modified web forms and Standalone executables and deployed them.

Created batch scripts and scheduled newly created SSIS packages using TWS scheduler.

Experience in maintaining critical production SQL servers and troubleshoot database

Key Projects Delivered as SME, Development lead and architect

Functional SME for E-Incentives Application.

Contract consolidation project (SSIS, SSRS, VB.Net, SQL server).

Unified Data Warehouse adoption project (SSIS, SSRS, VB.Net, SQL server).

Migration of SQL Server 2000 DTS packages to SQL Server 2008 SSIS Packages

Migration of Windows 2003 to 2012 on Database and application servers.

SQL server database migration for 2005 to 2012.

Settlements plus Reports migration from SSRS 2005 to SSRS 2008.

Migrated 40 SSIS batch jobs from Auto-sys scheduler to Tivoli workload Scheduler.

Developed System operating and Data Controls for inbound Data (SSIS, SSRS, SQL server and VB.Net).

Development Lead and architect for Medicare adoption enhancements.

Implemented Automations and Processes improvements saving $400K/annum over the period of 5 years.

Project Name: United Network Outreach

Role: Development Lead

Team size: 4

From - 06/01/2009 to 06/30/2011

This project is used in physician/Healthcare provider contracting process to track the contracting processes starting the first outreach to contract finalization and implementation. C# and VB.Net standalone applications are used for data integration with inbound and outbound systems and work flows using Oracle CRM on-Demand Web services.

Tools / Language Used: Oracle CRM On-Demand, C#, .Net Framework 2.0, Auto-sys, MS-DOS Batch scripting

Key Deliverables:

AOT Report automation to automate the report generation process

LabCorp Feedback Automation (Oracle CRM Integration)

Provider Address back filling Project (Oracle CRM Integration)

Process stage Automation (Oracle CRM Integration)

Update Parent Child Relationship (Oracle CRM Integration)

Task Refinement Configuration Updates (Oracle CRM Integration)

Lab Data Mart for Lab Reporting (Oracle CRM Integration)

Month end User Inactivation (Oracle CRM Integration)

Task Mass Upload Utility (Oracle CRM Integration)

Update Survey User-Id Utility (Oracle CRM Integration)

Update Incident Web services (Oracle CRM Integration)

Contribution:

Act as SME and technical lead, for all the development modules.

Collaborated with client for requirements and reviews.

Prepared used cases, High and low-level design.

Review the design with the on-shore partners and clients.

Perform design reviews, code reviews and Unit test case reviews.

Provide functional assistance and leadership to the team.

Coordinated with onshore and offshore teams to remotely integrate code, perform code fixes, and do release management.

Coordinate with the testing team to fix bugs.

Coordinate with the clients for any issue resolution, status reporting updates and changes and delivery.

Review the Technical design documentation.

Create the weekly and Monthly dashboards and present them to the management

Create the metrics documents and perform Quality Audits with internal Audit team.

Project Name: Discharge Management Protocol Re-Engineering

Role: Associate Lead

From - 12/17/2007 to 05/31/2009

This project handles the post hospitalization protocol for behavior health patients to ensure periodic checkups and post hospitalization care. This creates a post hospitalization schedule for the behavior health patients and ensures preventive care is provided. This application that was migrated from MS-Access to Java and Oracle.

Contribution:

As SME and technical lead, done Business Analysis and reverse engineering of complete DMP application.

Collaborated with client for requirements and reviews.

Prepared used cases, High and low-level design.

Review the design with the on-shore partners and clients.

Perform design reviews, code reviews and Unit test case reviews.

Provide functional assistance and leadership to the team.

Coordinated with onshore and offshore teams to remotely integrate code, perform code fixes, and do release management.

Coordinate with the testing team to fix bugs.

Coordinate with the clients for any issue resolution, status reporting updates and changes and delivery.

Review the Technical design documentation.

Create the weekly and Monthly dashboards and present them to the management

Create the metrics documents and perform Quality Audits with internal Audit team.

Reliance Energy Limited - 01/2004 to 11/2007

Projects Delivered

Corporate Management Information system

Billing Amendment Module

Power Supply Module

Consumer Complaint Module

Role: Deputy Manager (IT-Development)

From -

Tools / Language Used: ASP.Net, C#, .Net Framework 2.0, Oracle 9i

Contribution:

Perform Business Requirement Analysis and act as SME.

Create the architecture, technical design documents and Database components like tables, views, stored procedures and triggers.

Develop the Windows and Web forms using C#, ASP.NET, VB.NET

Provide design inputs to developers and Lead the development.

Perform design reviews, code reviews and Unit test case reviews.

Manage the project schedule, Task Allocation and SPRF tracking.

Provide technical and functional assistance to the team, Coordinate with the testing team to fix bugs.

Periodically coordinate with the clients through meetings for any issue resolution, status updates and changes.

Contact this candidate