SUMMARY

• Over 6+ years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2016/2014/2012 /2008 R2/2008 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2016/2014/2012 /2008 .
• Strong SQL development skills including writing Stored Procedures, Triggers, Views, and User Defined functions.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models
• Handled ETL process development, implementation and support for Terabyte+ data warehouse environments
• Worked to establish connectivity between ASP.Net applications by using ODBC.
• Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
• Extensive experience in creating enterprise reports using SSRS 2008 using Report Manager, Report Builder, and BIDS
• Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
• Knowledge in calculating measures and dimension members using MDX, mathematical formulas, and user-defined functions
• Have hands on experience in Performance Tuning and Query Optimization. Worked on identifying and resolving blocking and deadlocks
• Extensively worked in Migration for MS SQL 2005 to MS SQL 2008 to MS SQL 2012
• Worked with different types of Replication Models like Transaction, Snapshot, and Merge
• Experience with version control systems like Microsoft Visual Source Safe (VSS), Team Foundation Server (TFS).
• Good team player with strong analytical skills

TECHNICAL SKILLS

• Oracle 9i/10g,MS SQL SERVER 2014/2012/ 2008 , MS Access 2007/2010\/2013 DB2
• Windows 9x/NT/2000/XP platforms, MS Dos and UNIX
• Enterprise Manager, SQL Profiler, SQL Server
• Management Studio, DTS, SSAS, SSIS,SSRS
• Microsoft Visual Studio 2010/2008, Crystal Reports, and MS Office, Erwin 4.0
• SSIS, SSAS, ETL, and OLAP
• Transact SQL, C, Visual Basic 6.0, VB.Net, ASP.NET, Java, HTML.

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Design, develop and deploy reports need for Business Intelligence reporting; Development of Stored Procedures, packages, views and functions in Oracle or MS SQL server using SQL Server
• Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
• Worked on scheduled SSRS Data Driven subscriptions/Normal Subscriptions based on daily, weekly and Monthly.
• Involve in improving the performance of the system.
• Develop ETL Packages with different data sources (SQL Server, Flat Files, Excel Sources files and XML files etc.) and load the data into target tables by performing different kinds of transformation using SQL Server Integration Services (SSIS)
• Develop various T-SQL stored procedure triggers, views and adding/changing tables for data load and transformation and data extraction.
• Automate SSIS packages using the SQL server agent jobs
• Developing Reports using Business Intelligence tools, create data models, participate in data architecture and warehouse sessions. Developed Query for generating Drill Down and Drill Through reports on SSRS Microsoft Visual Studio(MSVS).
• Created many Drill Through, Drill Down, Parameterized reports using SSRS 2008
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Used Power BI to develop data analysis prototype, and used power view and power map to Visualize reports.

Environment: MS SQL Server 2016/2014/2012 , SQL BI Suite SSIS, Visual Studio 2012, C#, Asp.Net 4.0, Visual Source Safe (VSS), Share Point, MS Project, MS Access, VBA, Power BI

Confidential

SQL BI Developer

Responsibilities:

• Working with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL.
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls.
• Designing and Developing SSIS Packages to import and export data from MS Excel, XML, SQL Server 2008, Flat files and used SSIS Package Configuration, Expressions, passing variables dynamically, logging, Event Handler.
• Design and develop Reports using Business Intelligence reporting tools such as SQL Server Reporting Servers (SSRS) or Congo’s.
• Created Stored Procedures, Triggers and Views on SQL Server
• Management Studio. Worked with Business Intelligence tools to developed reports and SSIS Packages.
• Deployed and Scheduling reports using Subscriptions and Data-Driven Subscriptions.
• Querying, creating stored procedures and writing complex queries and T-SQL joins to address various reporting operations and also random data requests.

Environment: MS SQL Server 2014/2012, SQL BI Suite SSIS, Visual Studio 2012, C#, Asp.Net 4.0, Visual Source Safe (VSS), Share Point, MS Project, MS Access, VBA.

Confidential

SQL/Reports Developer

Responsibilities:

• Extensive experience in creating reports using SSRS 2008/2010/2012 using Report Manager, Report Builder, and BIDS
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created Subscriptions and Data-Driven Subscriptions on report manager to automate the generation of SSRS reports.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed Power Maps using Excel 2013 for Reporting.
• Developed applications in Visual Basic .Net with EDI files and SQL Server.
• Designed SSRS reports using different data regions like Table, Matrix, List, Sub-reports and Charts. Created Drill down and drill through reports for easy navigation within the reports.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS Microsoft visual studio(MSVS)

Environment: MS SQL Server 2012/2008R2, SQL server Reporting Services, Microsoft Visual Studio 2010/2008, MS Excel, T-SQL, Visio.

Confidential

System Analyst

Responsibilities:

• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
• Developer SQL Scripts in SQL Server Management studio (SSMS).
• Created SSIS packages using different transformation to pull the data from source to the destination and design SSIS Packages to extract, transfer, and load (ETL) existing data into SQL Server 2008 from different environments.
• Create Stored Procedures to transform the Data and work extensively in T-SQL for various needs of the transformations while loading the data.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance. That increases my ability in Performance Tuning, Query Optimization.
• Skilled in Agile and Waterfall software development life cycle methodologies.
• Enhancing the reports and deploying to the site.
• Upgraded SQL Server 2005 to SQL Server 2008.

Environment: SQL Server 2008/2008 R2, MS Excel 2007- 2010, ETL, T-SQL, BIDS, MS SQL Server Reporting Services(SSRS), MS SQL Server Integration Services(SSIS).