Experience Summary

A total of *+ years of hands-on experience in SQL development on SQL Server 2008 R2 and 2012, 2016, 2017 and SSIS, SSRS and Power BI with strong business and technical acumen. Worked on Azure SQL Databases for more than one year and the ability to manage DBA and T-SQL developer activities for complex projects. Skills Summary

● 6+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (SSIS SSRS Power BI).

● Experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS) and Reporting Services (SSRS)

● Have experience in MS SQL Server 2008 R2/2012/2016/2017.

● T-SQL programming skills, query optimization & performance tuning and execution plan.

● Good understanding of RDBMS concepts and experience in writing Joins, Sub queries, indexes, Views, Stored procedures, Functions and Triggers using SQL Server.

● Have experience in SQL Server Data Base Administration Operations like Performance Tuning and Backup & Restore.

● Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.

● Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.

● Involved in DBA activities such as backups and restores.

● Have a strong knowledge of Business Intelligence and Data warehousing Concepts.

● Experience in Integration of various Data Sources like MS Excel, Flat Files, CSV Files, and OLEDB Sources into the staging area and load target data into Data warehouse.

● Have a good experience in designing the SSIS Packages with different types of Control Flow Tasks and Data Flow Transformations, Securing and Deploying the Packages.

● Experience in building the Azure Cloud Databases and transferring data to Azure using SSIS.

● Generated Sub-Reports, drilldown reports, Drill through reports and Parameterized reports using SSRS.

● Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

● Utilized Power BI desktop to design multiple scorecards and interactive dashboards with various visualizations like table, matrix, tree map and location map to display information required by different departments and upper-level management.

● Installed and configured on premises gateway for Power BI service.

● Scheduled Automatic data refresh through gateway for Power BI service.

● Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

● Ability to multitasks, and adaptable to new environments and technologies. Proactive team player with capability of handling responsibilities independently as well.

● Extensive experience in architecture, design and development of Client-Server and Distributed Web Applications with 3-Tire and N-Tire Architecture.

● Experience in agile methodology TFS (Team foundation server)

● Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.

● Have excellent communication and presentation skills.

● Have strong analytical and problem-solving skills. Education

B.E Mechanical engineering (SRKR Engineering college BHVRM, A.P) Page 1 of 5

Certifications

Microsoft 70-761: Querying Data with Transact-SQL

Employment History

Name of the Company Designation From To

Cognizant technologies Analyst Jan 2012 Dec 2016

H.S.B.C India Analyst Dec2018 Feb 2020

Projects Handled:

Project #3: Win Web Vendor Invoice Vouchering

Duration Feb 2020 to till date

Technology SQL Server 2017, Visual Studio 2017(SSDT), SSRS, Power BI, Azure SQL Data Base Client Clean Harbors, USA

Project

Abstract

Clean Harbors is a publicly traded company that maintains a vast network of service centers and waste management, treatment and disposal facilities and provides a broad range of services. WinWeb is an internal application to maintain the environmental waste, energy, and industrial services information

Role Sr Software Engineer

● Created the Complex SQL Queries, User Functions, stored procedures, CTE’s, Views, Indexes also created schema and Tables.

● Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

● Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL.

● Working on live site issues to fix slow running stored procedures and provide Root cause analysis.

● Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.

● Responsible for extracting the data from OLTP and OLAP using SSIS.

● Designed the incremental data load process for swift ETL operation.

● Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

● Scheduled Automatic data refresh through gateway in Power BI services.

● Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Project #2: Wells Fargo Bank

Duration Dec 2018 to Feb 2020

Page 2 of 5

Technology SQL Server 2017, Visual Studio 2017(SSDT), Power BI Client Wells Fargo Bank.

Project

Abstract

Wells Fargo & Company is an American multinational financial services company with a significant global presence. a Data Center Analyst Consultant (Technology Business Systems Associate) in Technology as part of Chief Technology Office, Data Center Management team. Role Analyst

● Extract the data from different social data sources like Facebook, Twitter, BARB, Google Analytics, Tube mogul and various DSP’s and integrate these advertising or conversion data using ETL.

● Requirement Analysis & create architecture briefing document for ETL workflow.

● Designed the incremental data load process for swift ETL operation.

● Led Unit Testing & Functional Testing and system integration testing.

● Led Production deployment activities and bubble support.

● Extensive client interaction during development, deployment and problem understanding phases.

● Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Project #5: Equator

Duration Jan 2017 To June 2018

Technology SQL Server 2008 R2/2016, SSIS packages

Client Altisource, USA

Project

Abstract

Equator is an Altisource business unit. It is a technology innovator providing infrastructure Software as a Service (“iSaaS”) solutions that offer advanced end to end solution. Equator’s web-based platform provides industry participants with end-to-end workflow management tools, comprehensive decisioning and transaction automation capabilities within a vibrant online marketplace that facilitates residential transactions. Almost all the banks use Equators platform to handle their foreclosure properties.

UST-Global is the only vendor for equator with supporting half of the technology work force. Role T-SQL Developer/ ETL developer

● Creating tables, schemas, stored procedures, views, triggers, functions.

● Migrating SQL Server 2008 SSIS packages to 2016.

● Creating new SSIS 2016 packages based on requirement.

● Creating metadata for existing table structure and OLAP purposes.

● Creating new configurations and jobs for different environments. Page 3 of 5

Project #4: PI SAFE

Duration Jan 2012 To Dec 2016

Technology SQL Server 2008 R2, SSIS packages

Client Optum Insight, USA

Project

Abstract

PI-Safe is medical coding tool, which interacts between a health care provider and the insurance company. The process involves in assigning codes to diagnoses and procedures that are performed by the healthcare providers. Once the procedure and diagnosis codes are determined, the medical biller will transmit the claim to the insurance company. To assigning the proper codes PI-Safe tool contains the modules Import Data, Import Charts, Chart Review, Coding, QA-Coding and Export DX-Info, Reports. PI-Safe tool protects import and export patient data in encrypted format and uses the secured VPN tunnel for transferring data.

Role T-SQL Developer/ ETL developer

● General database administration tasks like backup, restores, automation via jobs and alerts, performance optimization.

● Writing complex T-SQL code for stored procedures, views, triggers, functions, etc.

● Writing ad-hoc and development support activity scripts.

● Fine tuning existing queries and Stored procedure code.

● Trouble shooting T-SQL code and performance issues.

● Responsible for schema changes, table and Index creation.

● Performed the automation of various maintenance tasks via SQL jobs (Backups, disk, user, and database maintenance)

● Perform in-depth performance monitoring and tuning of DB Servers, databases, and T-SQL queries. Frequently used various tools like SQL Profiler, System monitor, DMV’s, and SQL alerts.

● DB designing (new table designing and change in existing table structure)

● Worked with application developers to decide the data fetching strategies for application UI and reports.

● Performed database maintenance tasks like index rebuilding, fragmentation detection and removal, consistency check, etc.

Project #2: Trace the Race

Duration Mar 2014 To Dec 2016

Technology SQL Server 2012, SSIS packages

Client Tyece, Hong Kong

Project

Abstract

Horse racing is a popular sport which attracts huge crowds. Nevertheless, bettors face many difficulties in predicting winning horses to make profit. The principal factors affecting a race were determined namely jockeys, new horses, favorite horses, previous performance, draw, type of horses, weight, rating and stable have been examined and appropriate weights have been assigned to each of them depending on their importance.

Page 4 of 5

Role T-SQL Developer

● General database administration tasks like backup, restores, automation via jobs and alerts, performance optimization.

● Writing complex T-SQL code for stored procedures, views, triggers, functions, etc.

● Creating new SSIS packages for added functionality/change requirements.

● Fine tuning existing queries and Stored procedure code.

● Trouble shooting T-SQL code and performance issues.

● Responsible for schema changes, table, and Index creation.

● Perform in-depth performance monitoring and tuning of DB Servers, databases, and T-SQL queries.

● Worked with application developers to decide the data fetching strategies for application UI and reports.

● Writing maintenance and ad-hoc packages to do data fixing to production servers.

● Optimizing existing SSIS packages.

● Writing SQL jobs for the execution of SSIS packages. Project #1: Ploutos Staffing Solutions

Duration May 2013 To Dec 2015

Technology SQL Server 2012, SSIS packages

Client Ploutos LLC, USA

Project

Abstract

Ploutus is staffing firm where it provides services in different sectors mainly into healthcare (Medical coding, medical billing, physical therapist, nurse practitioner etc.) and into IT, customer service and other sectors

Role Developer

● Interacted with Client for Requirements Collection and analyzed those requirements.

● Involved in the development of the application.

● Created databases, tables and wrote stored procedures, cursors and various database objects.

● Analyzed and tuned complex queries/stored procedures in SQL Server for faster execution.

● Scheduled and monitored all maintenance activities of SQL Server.

● Scheduled regular backup jobs and kept track of database by receiving the emails on alerts.

● Designed and Developed ASP.NET pages using C#.NET.

● Developed Business Layer and Data Access Layer components.

● Used Application Blocks for ADO.NET Connection, Command, Data Sets, Data Adapter, Data Reader, and XML to retrieve and store data in SQL Server.

● State and Session management of the application using database for storing the session and state information

Page 5 of 5

Contact this candidate