Paul Samuel Kommula

[email protected]

732-844-3322

PROFESSIONAL SUMMARY:

Over 7 years of IT experience in Design, Development and Maintenance of Database applications using SQL Server 2016/2014/2012/2008R2/2005.
Expertise in scripting DDL, DML, T-SQL (Complex VIEWS, Stored Procedures (SP), Functions, Triggers and Indexes).
Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.
Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.
Good Experience in Extraction, Transformation and Loading (ETL) in SQL Server database using SQL Server Integration Services (SSIS).
Experience in Implementing Checkpoint, Transactions, Logging.
Experience in building Package Deployment and Package Configurations.
Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
Good experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
Proficient in developing all types (Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports) of Complex Reports using SQL Server Reporting Services (SSRS).
Experience in Implementing Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.
Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
Good Experience in Managing/deploying reports to both the modes/environments (SharePoint and Native-Report Manager).
Expertise in Subscribing Reports (Standard and Data Driven Subscription) using SSRS in both the modes (SharePoint and Report Manager).
Knowledge on Tableau reporting tool for visualization.
Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.
Good Knowledge inSQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005).
Used SSAS Cubes as data source for Reports Development.
Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
Worked on PowerBI and prepared dashboards using Tableau to make it more attractive.
Experienced in developing ETL packages using SSIS SQL Server Integrated Services.
Abilities to perform VB .NET programming, Experience of LAN administration
Built backend Excel, Access, 1010, JDA, WMS and other system queries to feed reports and automated tasks
Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI), Inversion of Control (IOC), Singleton, MVVM and MVC.
Developed SSIS packages bringing data form various heterogeneous sources like:
Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
Experience in Software Development Life Cycle (SDLC) including requirementsgathering, writing technical specifications and Production support/Maintenance Activities.
Expert in developing Windows applications, web applications, windows services and web services in Microsoft visual studio, .NET IDE using C# .Net 1.1, C#.Net 2.0, VB .NET, ASP.NET, ADO.NET and Sql server.
Proficient in developing SOAP and RESTful Web Services.
Experience in Object-Oriented Programming within networks as well as online applications
Self-starter and quick learner with strong analytical and problem solving and troubleshooting skills.
Good Experience in Agile Methodology and Water Fall Methodology
Good Experience in Logistics, Retail, Insurance.
TECHNICAL SKILLS:

BI Data Warehouse Tools
SSRS, SSIS, SSAS, Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, Sharepoint.
Databases
MS SQL Server 2012/2008/2005, MS Access, Oracle.
Languages
C,C++,HTML,XML,T-SQL,MYSQL,DHTML,VB.NET,JavaScript,.Net, PHP,PLSQL, VB script, Web Services, Python.
App. /Web Servers
IIS 5.0/6.0
Reporting/ETL
SSRS, SSIS, SSAS, Report Builder.
Platforms/OS
Windows 98/2000/2003/XP/NT/Vista, Windows 7
Version Control Tools
Team Foundation Server, SVN
Microsoft Technologies
ASP.NET 1.1, ASP.NET2.0, VB.NET, C#.NET, ADO.NET, ADO, ASP
Others
SQL Server Data Tools, BIDS, SQL Server Management, Studio, Visual Studio.Net 2005/2008/2010, Office 2005/2008/2010, FTP, Share Point 2007/2010, JIRA
PROFESSIONAL EXPERIENCE:

Deloitte, Little Rock, AR                                                                                                       Sept 2018- Till Date

Team Lead/Asst. Manager

Deloitte is one of the biggest four accounting companies, Deloitte provides audit & assurance, consulting, risk and financial advisory, risk management, tax, and related services to the clients.With more than 150 years of hard work and commitment to making a real difference, our organization has grown in scale and diversity—approximately 245,000 people in 150 countries and territories, providing audit & assurance, tax, legal, risk and financial advisory and consulting services—yet our shared culture remains the same.

Responsibilities

·       Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.

·       Created and maintained Databases, Tables, Stored procedures,Triggers, Views, SQL Agent jobs,Indexes, database check constraints, and business rules using T-SQL.

·       Involved in MS SQL Server2014Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization of slow performance queries by looking at ExecutionPlan for better Tuning of the database, Database Maintenance Plans and Database Consistency Checking DBCC commands.

·       Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

·       Generated ad-hoc reports in Excel PowerPivot and sheared them using Power BI to the decision makers for strategic planning, Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging.

·       Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

·       Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.

·       Created SSISpackage to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Datamart using SSIS transformations.

·       Worked on different SSISTaskssuch as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

·       to build SSIS packages with a combination of multiple Control Flow Tasks, Data Flow Taskslike FTP & SFTP (COZYROC tools), Multiple Hash(MD5) Execute SQL, Execute Process, Script Task, File System, Send Mail Task also worked on Sequence & For Each Loop Containers

·       Used SSIS Transformations like Derive Column, ConditionalSplit, Aggregate, Row Count, Pivot Transformation, Lookup, Sort, Union All, Data Conversion, Script component to load data into Data Warehouse.

·       Develop SSIStemplates which can be used to develop SSIS packages in such a way that they can be dynamically deployed into Dev, Test, SIT, UAT and ProductionEnvironments.

·       Administered SQL Server 2016 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.

·       Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.

·       Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.

·       Scheduled and Monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.

·       Currently designing .NET system architecture for ASP migration project. Developed .Net Web forms using ASP.Net 2.0, Visual Basic. Net and Microsoft Visual Studio 2003. Developed Web Forms using C# and ASP.NET

·       Developed utility libraries for database access using ADO.Net, file storage and logging using data stream, and notifications using SMTP clients. Worked on Cascading Style Sheets and XML- Schemas.

·       Designed, deployed, and maintained complex canned reports using   SQL   Server 2016 Reporting Services (SSRS).

·       Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

·       Created Parameterized Queries, generated Tabularreports, Subreports, CrossTabs, Drilldown reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SQL Server Reporting Services (SSRS).

·       Used SSIS2014 to create ETL packages( dtsx files) to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAPdatabases

Environment: MS SQL Server 2017/2016/2014 Enterprise Edition, SSIS 2014,2012,  SSRS 2014,2012, T- SQL, VSS, Windows Sever 2008,2010 SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio, Power BI, ASP.NET2.0, C#.NET, ADO.NET

Vitamin Shoppe, Secaucus, NJ                                                                                        Apr 2017- Sept 2018

Team Lead

Vitamin Shoppe, Inc. (VSI), is a multi-channel specialty retailer and contract manufacturer of vitamins, minerals, herbs, specialty supplements, sports nutrition, and other health and wellness products. The Company operates through three segments: retail, direct and manufacturing. The retail segment includes Vitamin Shoppe, Super Supplements and Vitapath retail store formats. The manufacturing segment provides custom manufacturing and private labeling of vitamin, mineral and supplement (VMS) products, and develops and markets its own branded products for both sales to third parties and for the VSI product assortment.

Created PL/ SQL Procedures, Functions, Packages, Views, Materialized Views, Triggers.
Creating PL/ SQL triggers, sequences, and stored procedures using Toad and SQL Developer
Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
Integrated Custom Visuals based on business requirements using PowerBI desktop.
Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL.
Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service. Published the dashboard reports to Power BIservice for navigating the developed dashboards in web.
Involved in designing STAR Schema for the business processes.
Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
Involved in loading of data into different databases Oracle, SQL server from legacy systems and flat files using complex scripts.
Implementation of MS SQL Server 2016/2014 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
Responsible for installation and Configuration of SQL Server 2014 and 2016 database and configuration of Report manager.
Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2016/2014.
Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
Developed, deployed, and monitored SSIS Packages.
Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2014/2016.
Created Custom Triggers, Stored Procedures, Packages and SQL Scripts. Involved in the continuous enhancements and fixing of production problems
clients. Worked on Cascading Style Sheets and XML- Schemas.
Developed SQL Queries and Procedures for storage and retrieval of data using ADO.Net and LINQ to SQL. Developed Web Services for user authentication and file transfer.
Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
Generated server sidePL/ SQL scripts for data manipulation, validation and materialized views for remote instances
Improved the application performance significantly by tuning SQL Queries and PL/ SQL program units. Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target using PL/SQL.
Designing data models, contributed to the overall design and implementation of the data warehouse.
Participated in all data warehouse planning and execution.
Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment (SSIS).
Environment: MS SQL Server 2017/2016/2014/2012 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio, Power BI, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Stuidio.NET 2005

HealthEC LLC, Piscataway, NJ                                                                                                    Jan 2017 – Apr 2017

SQL/MSBI developer

HealthEC is a leading innovator in empowering the exchange of healthcare information, providing a complete end-to-end solution to manage Population Health. HealthEC provides knowledge, expertise and technology solutions to the healthcare industry to effectively and efficiently manage its community. HealthEC Population Health Management platform provides the flexibility to integrate all of the critical components of a Care Management program into a single integrated platform – from patient attribution through care coordination and analytics for payers, providers and employers.

Responsibilities:

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
Involved in ETLarchitecture enhancements to increase the performance using query optimizer.
Experienced in writing complex SQL Queries, complex Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
Created SSIS packages to create csv files and excel sheets.
Created global temporary tables in the Execute SQLSQLtask and created reports based on the global temporary tables inside the data task flow.
Used Package Configurations to make the SSIS Package reusable in any server.
Used Execute SQLTask, Data flow Task, Sequence Container, For Each Loop Container, File System Task, Execute Package Task.
Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQLServer using SSIS/DTS using various features like data conversion etc.
Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
Responsible for Scheduling Jobs, Alerting and Maintaining SSISpackages.
Created SSRS reports like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
Created reports based on both cascading and standard parameters.
Created different Parameterized Reports (SSRS 2012/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
Designed and built cube using SQL server Analysis Services for salary analysis.
Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
Extensive experience in SSAS (SQLServer Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.
Experience in writing complex MDX queries for calculated members and measure groups.
Environment: MS SQL Server 2014/2012/2008/2005 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio.

Ashfield Healthcare, Ivyland, PA                                                                                               Aug 2016-Jan 2017

SQL/MSBI Developer

Ashfield offers a wide range of world-class, market leading services that include medical sales teams, inside sales, contact centers, nurse educators, patient support programs, medical communications, medical information, meetings and events, market research, pharmacovigilance and training.

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files. Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
Involved in ETL architecture enhancements to increase the performance using query optimizer.
Implemented Event Handlers and Error Handling in SSIS packages.
Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
Advanced extensible reporting skills using SQLServer 2012ReportingServices (SSRS).
Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL ServerReportingServices (SSRS).
Worked on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
Expertise in providing comprehensive solutions in multi-industry, multi-cultural environments. Exceptional project management skills with vast experience in working within tight time frames
Review and approve quotations from contract manufacturers by following cost review procedures that incorporate the analysis and calculation of cost of goods sold (COGS).
Coordinated with front-end for implementing logic in stored procedures and functions.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
Involved in upgrading from SQL Server 2008 to SQL Server 2012. Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2012 Upgrade Advisor.
Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Environment:  SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003, Oracle EBS Supply Chain including: Advanced Procurement, Value Chain Execution, Order Orchestration and Fulfillment, Asset Lifecycle Management, Manufacturing, Product Value Chain Management Value Chain Planning

MasterCard, O’Fallon, MO                                                                                              Dec 2014 – July 2016

SQL Server Developer

MasterCard is a technology company and payments industry leader. For more than four decades, MasterCard have been a driving force at the heart of commerce, making the global economy safer, more efficient, more inclusive and more transparent for all. Consumers, merchants, business partners and governments in markets around the world have reaped the benefits of master card innovative products and solutions which, simply put, are designed to make life easier.

Responsibilities:

Writing TSQL, PL/SQL, stored procedures, functions and complex queries for migrating legacy Oracle 10g to SQL Server 2012.
Experience working in multiple projects both OLTP and OLAP (Data warehouse) databases.
Designed and developed SSRS reports exactly similar to the Crystal Reports (Migration of Crystal Reports to SSRS Reports).
Created complex Stored Procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL JOINs and statements for applications.
Designed and development of SSIS (ETL) packages for Data Extraction, Transforming and Loading the data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
Migrating SSIS packages from SQL Server 2008 version to SQL Server 2012 version.
Experience in implementing Event Handlers, Checkpoints and Logging to maintain active SSIS packages.
Automating the SSIS packages execution through SQL Mail Agent jobs, scheduling the jobs adding notifications for success and failure.
Designed and Developed Drill-through, Drill-down, Cross Tab (Matrix) Reports and Sub-Report using SSRS.
Applying optimization techniques to improve the performance of the queries and taken care of performance issues across TSQL, SSIS and SSRS reports.
Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
Implemented the Best Practices and Coding Standards for SQL Server, SSIS & SSRS.
Experienced working in Development, Testing and Production servers.
Environment:  MS SQL Server2012/2008, Oracle, MS SQL Server Reporting Services, SQL Server Integration services, ETL,  Data Modeling, T-SQL, SQL Profiler, XML, MS Access, Excel

Micro-Core Solutions, Bangalore, India                                                                      Mar 2013 – Jun 2014

Junior SQL DBA/Developer

As a SQL SERVER DBA, I supported in the administration and development of Finance and Payroll databases and applications.

Responsibilities

·       Actively participated in gathering of User Requirement and Specification.

·       Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.

·       Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure                 database optimization.

·       Implementing Backups and Restoring when necessary.

·       Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

·       Developed DTS Packages to transfer the data between SQL Server database and files.

·       Extensively Developed SQL scripts for maintaining administration tasks.

Environment:  SQL Server 2005/7.0/2000, HTML, Enterprise Manager, Windows 2K, SQL Profiler, DTS, and BCP.

Education Details

1.     Masters in Information Technology from Wilmington university in 2016

2.     Bachelors in Computer Science from JNTUH in 2013.