SUMMARY

• Almost 8 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2016/2014/2012/2008 R2/2008 with experience in Finance and Insurance domains.
• Experience in SQL Server and SSIS (Integration Services) package design, development, and deployment using SQL 2012 advanced features in Control flow, data flow, Error Handling and event handling.
• Involved in heavy data migration/ETL activities using BCP and SQL Server Integration Services (SSIS) ( 2016/2014/2012/2008 r).
• Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
• Optimizing, debugging, and creating stored procedures in SQL 2012 and Resolved issues in applications that are usingC#.NET,VB.NET
• UsePowerShelladvanced function features, extensive error handling, and logging
• Real time Experience in Modifying SSIS Package & Create SSIS Package by using different sources like XML, SSAS cube, Web - service.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Strong experience in Stored Procedure, User Defined Function, T-SQL coding, Performance Tuning and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Responsible for writing parameterized queries for generating tabular report, Sub reports, using global variables expressions and functions, sorting the data, defining the data, defining the data sources and subtotal for the reports using SSRS 2016/2012/2008 R2/
• Strong knowledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
• Extensive experience in SSRS (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them.
• Migration of SSRS reports from SQL 2012 to SQL 2016.
• Developing reports on SSAS & SSRS on SQL Server (2106/2014/2012/2008 R2) Good Experience and understanding of SSAS, OLAP cube and Architecture.
• Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS).
• Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, and Star schema for OLTP/OLAP systems.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS

Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint, Sql Server Data Tools for Visual Studio 2012/2010/2008 , Erwin 8/7.2 Data Modeler, MS Visio, CrystalReports7/8/8.5, Business Objects, JIRA Microsoft office 2010/2012

Database: MS SQL Server 2016/2014/2012/2008 R2, SQL CMD, Microsoft Office 2012/2010/2007 , MS-Access. MS Excel, Oracle8i/9i

Operating System: Windows 7/XP/2010/2008, Windows server 2008/2007

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server\SSIS\SSRS Developer

Responsibilities:

• Gathering Requirements from Client and understand current Database and system environment and then integrate it with business logic and made documentation on it.
• Worked with Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports
• Based on documentation generated different data model for the Data Warehouse and worked on Data mapping/Data profiling & create hierarchy as per business requirements.
• Start working on specification and transformation meanwhile start working to create new structure of DW and other objects like ETL Store Procedure,
• UsePowerShelladvanced function features, extensive error handling, and logging
• Develop the web applications usingC#and maintain database in SQL Server 2012
• Optimizing, debugging, and creating stored procedures in SQL 2012 and Resolved issues in applications that are usingC#.NET,VB.NET
• WrotePowerShellscripts for automating time consuming specialty needs for external clients
• Generated SSIS Package for ETL Process and develop source to Client data mappings using SSIS various tasks such as Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement.
• Created Views and Synonym to reduce complexity of end user.
• Developedbigdataingestion framework to process multi TBdataincludingdataquality checks, transformation, and stored as efficient storage formats like parquet using Spark Scala API.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2
• Migration of SSRS reports from SQL 2012 to SQL 2014.
• Generated Sub-Reports, Drill down reports, Drill through reports, Tabular Report and parameterized reports using SSRS.
• Created AD HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.

Tools: & Technologies: MS SQL Server 2014, T-SQL, SSIS 2014, SSRS 2014, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, BIDS, Erwin v7.1, Windows XP, MS Office 2010, MS Access

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Requirements and understanding the functional work flow of information from source systems to destination systems.
• Developed complexT-SQLcode for the application conversions.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, oracle, SQL Server 2012 and Flat files.
• 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.
• Wrote Server-side Stored Procedures and Triggers, formulated Backup/Recovery strategies, Optimizing Query Plan, Performance Tuning.
• Actively involved in writingT-SQLProgramming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• 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.

Tools: & Technologies: Visual Studio 2014/2012, Microsoft SQL Server 2014, SSIS 2014, SSRS 2014, SSAS 2012, JIRA, DB2, Team foundation server, SQL Developer, MS SQL Profiler, SQL Server Database Engine Tuning Wizard, Maestro Scheduler, Windows Server 2008, MS Office 2010, MS Access, MS Visio.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Filtered bad data using complexT-SQLstatements, and implemented various constraint and triggers for data consistency
• Wrote stored Procedures, Functions and Triggers as per the requirements.
• Designed and implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2014 and wrote the SQL queries, Stored Procedures and views.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, Triggers and problems related to the privileges
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.
• Interacting with onsite people, taking clarifications regarding applications and Formulating SQL queries and stored procedures on assigned modules
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart usingLookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Designedand developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created AD HOC reports with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs
• Responsible for requirement gathering and creating requirement and technical document.
• Built data connection to the database using MS SQL Server and Have worked with Database testing and SQL queries.

Tools: & Technologies:SQL Server 2012/2008R2 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS) SSDT for visual studio 2010, TSQL,C# .Net framework, XML, MS Visual Source Safe and Windows Server 2008,Crystal Reports

Confidential

SQL Server Developer

Responsibilities:

• Worked with non-technical colleagues and provide them SQL 2008 queries and store procedures to make their task easy and less time consuming.
• Created complex SQL join queries, views, and store procedures.
• Write Stored Procedures, ad hoc queries, join operations, dynamic SQL to extract the data in smoother and quicker manner out of Database.
• Design and implementation of stored procedures and triggers for automating tasks
• Worked as adeveloperin creating complex Stored Procedures, Functions, Triggers, Views and complexSQLstatements for applications.
• Developed complexT-SQLcode for the application conversions
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Worked on data cleansing techniques using look-ups, conditional split, and fuzzy lookup.
• Provided efficient error handling to SSIS packages.
• Prepared the reports using SSRS 2008 from scratch.
• Created parameterized, drill down reports and Changed old reports as per requirements using SSRS 2005.
• Create report model to give flexibility to users to create their own reports in SSRS.

Tools: & Technologies:MS SQL Server 2008, SSIS 2008, SSRS 2008, MS Office 2007, MS Access, MS Excel.