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 Knowledge of customers information, water and sewer consumptions matrix, billing cycle, delinquency etc.Participating in Business Requirement gathering from businesses, stakeholders and converting them to Business Requirement Documents (BRD) and performed role of Business Analyst.Created Data Mining process to identify customers with various matrix for business reporting needs.Analyzed existing SSIS package, make changes to improve its performances, add standard logging and configuration system.Created numerous simple to complex queries, views and stored procedures involving Multi-table joins and self joins and correlated subqueries.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.Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.Created new tables, modified existing tables, stored procedures and triggers on SQL Server database to enhance SSIS performances.Created new tables, modified existing tables, stored procedures and triggers on SQL Server database to enhance SSIS performances.Created replication process on SQL server for transactional data to and from different server.Provide production support to existing SSIS packages, debugging and monitoring them.Created ETL package to load data from PeopleSoft (Oracle Database) to Data Warehouse (SQL Server).Created package to download and upload data from third party system to production system.

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 from Source system.• 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 (Data Type, Configuration tables, Control tables and Fact and Dimension tables and application use for different teams requirement such as HEDIS, C and D Measures applications)• 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.• Performed Database performance analysis by looking at execution plans, building or modifying existing indexes, re-writing queries for performance and index utilizations, etc.• Design and developed new SSIS packages for data migration, transformation and loading, scheduling SQL jobs using Control-M.• Analyzed existing SSIS package, make changes to improve its performances, add standard logging and configuration system.Environment: SQL Server 2012, 2008 R2, SSIS, SSRS

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.• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.• Created new tables, modified existing tables, stored procedures and triggers on SQL Server database to enhance SSIS performances.

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 such as WINSCP.∙ Created SSIS package to use third party API as source and destination for data load process.∙ Created package to download and update data from Sharepoint portal based list.∙ Created packages to update and insert data from SQL Server to Oracle database using Merge and TableDifference (third party tools).∙ Created package to load data from flat files to staging table and included event handler and logging for incorrect data.∙ Created new tables, modified existing tables, stored procedures and triggers on SQL Server database to enhance SSIS performances.∙ Created replication process on SQL server for transactional data to and from different server.∙ Provide production support to existing SSIS packages, debugging and monitoring them.∙ Created ETL package to load data from PeopleSoft (Oracle Database) to Dataware House (SQL Server).∙ Created package to download and upload data from third party system to production system.∙ Developed Stored Procedures, views, tables to handle new SSIS implementations on Sql Server and Oracle Database.∙ Created logins and users on SQL server database and provided then proper access to various database on SQL Servers.∙ Monitored Jobs/logs on SQL server profiler, Third Party application (UC4) for debugging and performance issues.∙ Load data to data warehouse, fact and dimension tables, design and develop cubes using star schema and snow flake schema.

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 database.∙ Designed various SSIS/SSRS packages for ETL and Reporting including writing to flat files, appended files, transformation and loading data to/from third party systems, report generation, etc.∙ 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.∙ Implemented Change Capture Data (CDC audit) to captures records Inserts, Updates and Deletes on various databases.

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 documents related to the development, worked with the fit-Gap analysis team, identified projects that need to be moved to 9.0 environments On Project CostingProject costing overview- Funding Sources, Creating Projects and Activities, defining project budgets, project analysis, reports and queries. On technical side, worked on some SQRs, records, pages, and reports.

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

Master Of Science (M.S.)

Master Of Science (M.Sc.)