Pranav Kumar Email & Phone Number

Mckinney, TX, US

Plano, Texas, United States

Dallas/Fort Worth Area

San Antonio

San Antonio Water Services is a public utility Company owned by City of San Antonio. The Primary responsibilities are design, development and maintenance of Data Warehouse, design and development of SSIS packages and Reporting Services, Performance tuning, Database audits, SQL jobs and Agents along with ad-hoc reports and processes improvements.Extensive.

San Antonio, Texas Area

• Designed and Developed database for HEDIS and C-and D-Measures including Fact and Dim tables, ETL packages to load data from source to target tables, Writing processes for claims, lab, pharmacy, Member Eligibility data.
• Design and Developed for HEDIS and C- and D-Measures processes to calculate denominator, numerator and exclusions based on CMS and HEDIS requirement for each measures for 2014, 2015 and 2016 requirements.
• Designed and Developed Reporting tables for Star Reporting for measures.
• Participated in URDS project (Re-Write of entire Database on dimensional model design using star schema model) during initial phase of conception and design. Provided architectural assessment for design consideration.
• Worked on complex SQL Queries for performance tuning, space utilization, data integrity and consistency across entire application development.
• Built SSIS packages (data extraction and loading) for different applications across different servers and database with configuration and variables to handle different scenario.

Austin, Texas Area

• Integration Service Administration including deployment, monitoring of jobs and packages, provide support to production environment, check logs for failure and fix issues with packages.
• Gather business requirement, analyzed existing data source, develop ETL process, data validation in development and UAT environments and move packages to production environment and deploy jobs.
• Analyzed existing SSIS package, make changes to improve its performances, add standard logging and configuration system.
• Created numerous simple to complex queries, views and store procedures involving Multi-table joins and self joins and correlated sub queries.
• Designed SSIS package to import legacy data into new database, transformed values and data type, made validation on data integrity for data consistency.
• Implemented stored procedure error handling for logging and debugging.

Oklahoma City, Oklahoma Area

∙ Analyzed existing SSIS package, make changes to improve its performances, add standard logging and configuration system.∙ Created numerous simple to complex queries, views and store procedures involving Multi-table joins and self joins and correlated sub queries.∙ Created new package to download data from ftp servers (secured) using third party tools.

Mckinney, TX

∙ Analyzed existing database (tables, views, stored procedures, indexes, constraints, etc.) and designed new and improved database schema based on existing business functionality. ∙ Created Stored Procedure for complex business logic to integrate with sitecore and website design teams, designed tables using RDMS rules, recover deleted rows from production.

Greater Atlanta Area

Experience in PeopleSoft Financials and SCM modules, strong Oracle and PeopleSoft Customization and upgrade skills. Experience with SQR, Application Engine, PeopleCode, Application Packages, Application Designer, Application Messaging, Component Interface, Data Conversion, Toad, SQL. Analyzed 8.8 developments in the entire financial module, wrote technical.

Master Of Business Administration (Mba), Entrepreneurship/Entrepreneurial Studies

Master Of Science (M.S.)

Master Of Science (M.Sc.)