SUMMARY

• Extensive 8+ years of experience in Database development for OLTP (Batch Processing, Online Processing); OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server.
• Strong SQL Server Developer Skills including writing Transact - SQL Queries, Stored procedures, User defined functions, Views and Good understanding of Normalization /Denormalization, Database design and Modeling (logical and physical).
• Experience in writing SQL scripts for data transformation and data loading, mapping between the various systems and identifying data anomalies and with cleanup script.
• Experience in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Experience in Setup Jobs, Maintenance plans for backups, rebuilding indexes, check server health, alert, notifications
• Experience in creating and managing different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
• Optimizing queries, table normalization and demoralization, clustering, T-SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), RDBMS, data dictionaries, and data integrity.
• Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Reports, Backup and Disaster Recovery.
• Experience in scheduling jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
• Experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Experience in developing stored procedures, functions, Joins, triggers, views, materialized views,
• Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2008/2012/2014/2016 and MS Access databases.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping, conversion, and data load.
• Experience in creating jobs, alerts, and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Knowledge in creating Basic Table Report, adding calculated Values, Using Document Maps, Tablix Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views for speedy performance using SSMS and SQLCMD.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility, and efficiency.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008/2008R2/2012 to MS SQL Server 2016.
• Experience in Version Control System SVN, VSS, TFS.
• Preparing accurate reports to document design flaws and bugs as well as modifying existing software or system to correct errors and improve performance.
• Collaborating with other programmers and developers in the whole development process and using structured analysis and design to determine steps to develop programs.
• Determining user requirements, including project budgets and timelines as well as providing consultative services to clients and project team members on technical issues
• A self -motivated Individual with exemplary analytical and problem-solving skills.

TECHNICAL SKILLS

Databases: SQL Server 2016/ 2014/2012/2008 , 14, Oracle 9i & 10g, MySQL4/5, Snowflake

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL & BI Tools: SSIS, Informatica, SSRS, SSAS, PowerBI, IBM Cognos Analytics, OBIEE, Tableau.

Languages: SQL, TSQL, HTML, CSS, C, C++, C#, Visual Studio, JavaScript.

Other Tools: TFS, GitHub, TeamCity, Octopus, SVN

Scripting: Java Scripting, Shell Scripting

Operating Systems: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential, Fort Mill

SQL Developer

Responsibilities:

• Involved in the Confidential Data Migration, performance testing and locating bottlenecks and successfully met Confidential aggressive deadlines.
• Wrote complex SQL scripts for data transformation and data loading, performed mapping between the various systems due to major schema changes.
• Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
• Working as database support by coding stored procedures for data access and loading.
• Performance tuning and benchmarking to the SQL code.
• Identified data anomalies and wrote scripts for data cleanup.
• Working on Team city and Octopus for Deployment.
• Designing the new database in different servers.
• Included the performance tuning for the complex stored procedures.
• Involved in the data transfer from one system to the other systems by using import and export wizard.
• Designing the scripts as per the company standards.
• Involved in the Unit testing.

Environment: SQL Server 2014, SSIS, C#, Visual Studio, TFS, GIT, Team City, Octopus.

Confidential, Madison, WI

SQL /MSBI Developer

Responsibilities:

• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Performed the role of DBA for all SQL Server database environments, Creating the logins and SQL server agent jobs.
• Monitoring Server and databases Performance tuning (Disks space, lock, and block, query running slow).
• Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
• Analyzing the execution plan and index management for better Query Optimization.
• Scheduled to Rebuild and reorganize the index.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from multi-terabyte data warehousing systems.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Developed SSIS(ETL) components.
• Regularly monitoring the production logs to ensure the data flow is going fine.
• Working on job fails on production/ acceptance servers.
• Working on the HPSD service.
• Used server-side controls to dynamically change the look of the application. Created Web page elements like navigation controls and Calendar Controls once and reused across multiple areas of the site.
• Assisted in designing and developing new features and functionality for software applications as per requirements as well as in identifying and debugging defects in application code.
• Discussions with customers on service call issues, if required.
• Developed Power BI reports and dashboards from multiple data sources.

Environment: SQL Server 2016, SQL Server Business Intelligence Studio SSIS, SSRS, SSAS, C#, Visual Studio, OLE DB, Excel, Access 2010, SVN, GIT, QlikView, Version One.

Confidential, Tampa, FL

SQL /MSBI Developer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Performed the role of Senior Database Architect for all SQL Server database environments.
• Involved in developing database objects such as procedures, triggers, constraints, indexes, and views using SQL Server 2016.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from multi-terabyte data warehousing systems.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Regularly monitoring the production logs to ensure the data flow is going fine.
• Working on job fails on production/ acceptance servers.
• Working on the HPSD service.
• User Access Management - Granting/ revoking a user access to the database on both the acceptance and production environments.
• Monthly activity - Changing the new reporting month parameter in the dashboards on both the acceptance and production environments every month start.
• Used server-side controls to dynamically change the look of the application. Created Web page elements like navigation controls and Calendar Controls once and reused across multiple areas of the site.
• Assisted in designing and developing new features and functionality for software applications as per requirements as well as in identifying and debugging defects in application code.
• Discussions with customers on service call issues, if required.

Environment: SQL Server 2012, SQL Server Business Intelligence Studio SSIS, SSRS, SSAS, Erwin

Confidential

Software Engineer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Performed the role of DBA for all SQL Server database environments.
• Performing the DBA roles like Monitoring the jobs creating the tables and indexes.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views using SQL Server 2016.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from multi-terabyte data warehousing systems.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Developed C# scripting for packages.
• Used JIRA for Version Control needs, task check-ins.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS ) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients.
• Loaded Data into Oracle Tables usingSQL Loader.
• Creation of database objects liketables, views, materialized views, procedures, and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Involved in Denormalization of existing tables for faster query retrieval.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Environment: SQL Server 2014/2012/2008 , SSRS, SSIS, SSAS, C# Scripting, JIRA, BCP, DTS, SQL Mail, SQL Server Management Studio, T-SQL, XML, oracle 9i, Toad, MS Excel and MS Access, Visual Team Foundation Server, DTS, Crystal Reports, IBM Cognos, Informatica.

Confidential

SQL Server Developer

Responsibilities:

• Upgraded legacy 2000 databases to SQL server2008.
• Created jobs to import/ export data, Involved inDatabase Backup andrecovery.
• Created and maintained various logins and managed security based on the required access.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Implemented high availability on the various servers usingreplication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Studying the business requirement document, interact with the client and prepare the Report Requirement Specifications document and changing the existing one as per Business Intelligence Competency methodology.
• Experience of implementations with C# and the .NET platform.
• Experience of implementations with Windows Forms App (.NET Framework).
• Developed SSIS(ETL) components.
• Optimized the performance of queries with modifications inT-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources usingSSIS.
• Created variousSSISpackages based upon the requirement.
• Created various reports usingSSRS.
• Regularly monitoring the production logs to ensure the data flow is going fine.
• Working on job fails on production/ acceptance servers.
• Working on the HPSD service.
• User Access Management - Granting/ revoking a user access to the VRT database on both the acceptance and production environments.
• Monthly activity - Changing the new reporting month parameter in the VRT dashboards on both the acceptance and production environments every month start.
• Used server-side controls to dynamically change the look of the application. Created Web page elements like navigation controls and Calendar Controls once and reused across multiple areas of the site.
• Creating the files and copy the files from one place to another place by using Linux.
• Assisted in designing and developing new features and functionality for software applications as per requirements as well as in identifying and debugging defects in application code.
• Discussions with customers on service call issues, if required.

Environment: SQL Server 2012, SSRS, SSAS, Rational Clear Quest.