SUMMARY

• 8 years of strong experience in the IT industry as a MS SQL Server Developer/BI Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2017/2016/2014/2012/2008/2005/2000 for both OLTP & Data Warehousing Systems applications (SSRS, SSIS, and SSAS).
• Experience in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Designed ETL architecture for overall data transfer with the help of SSIS from the OLTP to OLAP.
• Experience in migration of data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS and DTS Utility
• Expert in SSIS script transformations using scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check.
• Strong knowledge in OLAP, Data warehousing, Operations Data Store concepts and ETL technologies.
• Experience in using SSRS and Microsoft Access for the custom and ad-hoc reporting purpose. Knowledge and basic practical experience in Tableau reporting.
• Excellent knowledge in Tuning SQL queries, T-SQL and PL/SQL queries & improving the performance of the Database
• Experience and Involve in deploying SSIS package on Azure Cloud and running those with Autosys.
• Expert in developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Performed and working experience in Python script for analysis the data and validation for business users.
• Knowledge and experience for UNIX command and PowerShell.
• Strong team player with excellent problem-solving skills and ability to take new roles, self-starter with excellent communication skills.
• Analyze performance of the system and ensure the performance objective and availability of the requirements.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/ 2008/2012/2014 /2016/2017 , MS SSRS 2000/2005/ 2008/2012/2014 , MS SQL SSAS
• 2014/2012, MS SSIS 2000/2005/ 2008/2012/2014 /2016, MS-Access, Erwin, Oracle, T-SQL, PL/SQL, HTML, Visual
• SourceSafe, Team Foundation server, Embarcadero, MS Office, Windows NT/ 2000 Server/ XP,HP Quality CenterVisual Studio 2010/2013/2015/2017 , Tableau 10.5., Python 3.6, PowerShell

PROFESSIONAL EXPERIENCE

Confidential

Database Developer/ETL Developer

Responsibilities:

• Involve in ETL Production support for failing ETL and SQL Server agent Jobs.
• Mostly Working with ‘MyInfo’ HR application team for backend code where user requesting fix issue or add some enhancement
• Working on using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, Teradata and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Creating Stored Procedure and Table schema based on requirement of application.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Working on incident tickets, Jira tickets, BUS tickets to fix issue from user side and directly work with user to resolve issue daily basis.
• Manage and monitor the system utilization by using the query optimizer and checking the execution plan.
• Experience in Database activities like Database design, development, database creation and maintenance, performance monitoring and tuning, and troubleshooting where it’s need it to improve.

HARDWARE/SOFTWARE: MS SQL Integration Services 2008/2012, MS SQL Server 2012/2016/2017 , Window XP, MS Word/MS Excel 2013, Visual Studio 2010/2015, SharePoint, Teradata Client 15, Oracle 11g, Ultra Edit, Jira tool

Confidential

Database Developer/ETL Developer

Responsibilities:

• Develop and change complex T-SQL, stored procedure code for the application.
• Involve for deploying Packages in Azure cloud and responsible for daily Production support failing ETL and Autosys Job.
• Create Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Involved in migration for Sybase DB to SQL DB server for multiple application DB.
• Performing indexes performance improvement using Index tuning wizard for tuning of indexes.
• Involve in various projects related to Data Modeling, Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Involve and implement migrating data from Sybase to SQL Server using SSMA and ETL process.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports;
• Manage and monitor the system utilization by using the query optimizer and checking the execution plan.
• Performed and develop Python script for data analysis and data validation for business users.

HARDWARE/SOFTWARE: MS SQL Integration Services 2012/2014/2016 , MS SQL Server 2012/2014/2016 /2017, C#, Window XP, Linux, MS Word/MS Excel 2010/2013, Visual Studio 2010/2015, Team Foundation Server, Sybase Central 6,Sharepoint,Python 3.6,PowerShell.

Confidential

Data Analyst

Responsibilities:

• Involved in performance tuning of the database and T-SQL queries using Database Engine Tuning Advisor. Provided technical support to internal developers and external clients.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Experience in using SSIS for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Developed stored procedure, views and database triggers in SQL Server 2008 R2/2012/2014

HARDWARE/SOFTWARE: MS SQL Integration Services 2008/2012, MS SQL Server 2008/2012, C#, VB.Net, Window XP, MS Word 2010, Visual Studio 2010, MS Excel 2010, Da Vinci Tool, R-programming.

Confidential

SQL Developer and DBA

Responsibilities:

• Created different tables, indexes, views, cursor, stored procedures and functions in SQL Server 2008 R 2/2012/2014.
• Migrate MS Access Database 2000 to SQL Server 2008 R2, converted MS Access query to T-SQL query.
• Designed and implemented the Stored Procedures and functions for automating tasks.
• Involved in performance tuning of the database and T-SQL queries using Database Engine Tuning Advisor. Provided technical support to internal developers and external clients.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2008 R2/2012/2014 Business Intelligence Reports, SQL Server 2008 R2/2012/2014 Reporting Services (SSRS).
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Hands on experience to develop and construct snowflakes Data Warehouse database to build Cube using SSAS for Ad-hoc Reporting and develop different KPI for measure.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Part of the team for Reverse engineering data modeling for data warehouse structure. Created Physical diagram in Visual Studio under ‘ADO.NET Entity Data Model’.
• Maintained and modified existing complex reports and developed drill down, linked, cascade parameter and ad hoc reports.

HARDWARE/SOFTWARE: MS SQL Integration Services 2008/2012/2014 , MS SQL Server 2008/2012/2014 , C#, MS SQL Reporting Service 2008/2012/2014 , SSAS,Source Safe, VB.Net, Window XP, MS Word 2010, Visual Studio 2008/2010/2012/2013 , MS Excel 2010,HTML,Java Script, Team Foundation Server.

Confidential

Billing Technical Support

Responsibilities:

• Experience on Databases MSSQL and MySQL experience with writing and editing SQL queries on MS SQL and MySQL Database.
• Experience in Database backup and Table backup and restore.
• Working on Cognos Reports and Drill down reports.
• Experience with one or more application servers, such as Tomcat, FTP.
• Troubleshoot issues, execute a course of action, test the issue to see if it is resolved, and reply to the customer with the results.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Excellent written and verbal communication skills
• Demonstrated ability to gather relevant information and diagnose issues effectively and efficiently
• Act as the first level support for customer issues via phone calls, email, or ticketing system.
• Ability to help clients resolve client-side issues as well as document server-side issues.

HARDWARE/SOFTWARE: MS SQL Server 2005/2008, MySQL, Windows Server 2008/2003, Windows NT 2003, Cognos Reporting Tool