SUMMARY

• Around 7 years of strong experience in Microsoft SQL Server in administration, testing, development and production environment as an MS SQL Developer.
• Experience in Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
• Strong experience in creating T - SQL objects, working wif DDL/DML, performs most of teh SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Experience in Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL/SSIS processes, dimensional modeling and reporting tools.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing. creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Strong experience in MS SQL Server 2014/2012/2008 r2/2008 suite of products including SSIS, SSRS and SSAS.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experienced in creating, configuring and scheduling teh Dynamic SSIS packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Experience in designing and developing dashboards using QlikView/Qlik sense by extracting teh data from multiple sources (SQL Server, Web Services, Teradata, Flat files, Excel, Access etc.)
• Used triggers and constraints to maintain teh consistency of teh databases.
• Highly experienced in Performance Tuning, Handling Indexes, and Query Optimization.
• Team orientedindividual wif a results driven attitude, strong interpersonal and Communication skills in effective information exchange and interaction wif clients at all Levels of management
• Excellent communication and inter-personal skills, accustomed to work in a team Environment wif tight schedules and capable of working efficiently under pressure.

TECHNICAL SKILLS

Database: MS-SQL Server 2014/2012/2008 r2/2008, Oracle 11g Express, My SQL 6.0 and

Microsoft Access, T-SQL, PL-SQL.:

Database Tools: SSIS, SSRS, SSAS, SQL Server Management Studio.

Design Tools: MS Visio, Erwin 9.0/7.1, ER Studio.

BI Tools: QlikView 11/10, QMC, Qlik Publisher, Qliksense 3.x.

Platform & Frameworks: Windows 10/7, Windows Server 2003/2008, DOS, etc.

Other: Microsoft Project, TFS, Microsoft Office Suite.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server/ SSIS/ SSRS Developer

Responsibilities:

• Worked wif business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Worked wif Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
• Created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Wrote Distributed Queries between SQL Servers.
• Worked wif various tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Created various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• Created SSIS packages to load data from teh OLTP system to a Data mart for analyzing data.
• Built teh email QC system to analyze teh accuracy of teh data warehouse ETL process and generate teh email to all teh team members.
• Built teh automated ETL system for teh Group Practice data mapping by utilizing teh Lookup, slow changing dimension in teh Microsoft SSIS.
• Performed transformations like Conditional Split, Sorting and included data about teh environment using teh Audit Transformation.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
• Created reports using SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.

Environment: MS SQL Server 2014, T-SQL, SSRS, SSIS, SSAS, Oracle 10g, Windows server 2008, Visual Studio 2015, Windows 10

Confidential

SQL Server/ SSIS/ SSRS Developer

Responsibilities:

• Worked wif integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Designed and developed Logical Data Flow by applying complex transforms as per business rules for loading teh extracted data into Enterprise Data warehouse.
• Developed User Defined Functions, store procedure. Responsible for error handling in stored procedure, indexes to generate teh distinct data based on teh type of teh customer base, wrote T-SQL queries.
• Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system to SQL server.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from teh existing diversified data sources.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling teh packages.
• Developed various Error Handling Strategies for teh successful run of teh build packages.
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 9.0.
• Created dynamic reports using SSRS, generated report models using report builder for teh end users.

Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Microsoft Visual studio 2010, Windows server 2008, Windows 7, MS Office 2010, ASP.NET 3.5.

Confidential

ETL Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures.
• Wrote data retention process for reporting database to keep 60 days report history.
• 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.
• Designed ETL packages to load data from multiple sources.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created SSIS Packages for feed process to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created complex queries to automate data profiling process needed to define teh structure of teh pre staging and staging area.
• Used SQL Server Reporting Services to generate reports by passing parameters through URL Developed reports.
• Worked wif teh QA and Production Team for setting teh Configurations for teh SSIS packages for Test and Production Deployment.
• Work closely wif Business Management to prioritize business and information needs.
• Optimized teh entire reporting system performance by tuning teh procedure queries and build indexes in teh Reporting system.
• Created Qlik sense dashboard as per business requirements.
• Modify existing Qliksense dashboard based on business requirement.

Environment: MS SQL Server 2008R2, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008, MS Office 2007, Qlik Sense 3.x, Windows 7.

Confidential

ETL Developer

Responsibilities:

• Worked wif application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully Installed and configured MS SQL Server 2008r2 on teh production server.
• Optimized teh performance of queries wif modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary. Involved in designing system including tables, Stored Procedures, Indexes, UDF and triggers.
• Implemented SSIS (ETL) to extract and transform data from DB2, Oracle, RDBMS and Flat files/CSV, SQL Server 2008 instances and to load into staging and tan to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all, lookup, fuzzy lookup, fuzzy grouping and merge join and derived column.
• Created SSIS Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system to SQL server.
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) also based on Business Requirement Document Designed and created Report templates, bar graphs and pie charts based on teh financial data.
• Developed and rendered monthly, weekly and Daily reports as per teh requirement and gave roles, user access wif respect to security in report manager.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup.

Environment: Microsoft SQL Server 2008r2, SSIS, SSRS, Microsoft Visual studio 2008, Windows server 2008, Windows 7.

Confidential

MS SQL Developer

Responsibilities:

• Designed and analyzed teh SQL Server database and involved in gathering teh user requirements.
• Logical and Physical design of database for project on basis of user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Extracted teh data from Flat Files, transformed (Implemented required Business Logic) and Loaded into teh target Data warehouse.
• Scheduled SQL Server Agent Jobs to run every day to update changes in teh base tables
• Used triggers and constraints to maintain teh consistency of teh databases.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert teh data depending on teh criteria into teh tables of hub.
• Modified teh existing database by adding teh tables and maintained relationships between teh tables.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server 2005 Reporting Services.
• Created report subscription using data driven subscriptions and setting up automatic delivery of user.

Environment: MS SQL Server 2008, Microsoft Visual studio 2008, Windows 2007, Erwin v7.0, Crystal Report 8.5