PROFESSIONAL SUMMARY:

• Over 5 plus years of experience in Database design, SQL Development, data analysis and Business Intelligence concepts in various environments like Production, Development, Test, OLTP and OLAP.
• Experience in SSIS, SSAS AND SSRS of MS SQL Server tools.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Expertise in using high level design of ETL package in MS SQL Server to integrate data from heterogeneous sources like Excel, .CSV, Oracle, flat file, Text Format Data.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Expert in creating Ad - Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SQL SSRS.
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Drill-Down Reports, and Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS) in Business Intelligent Development Studio (BIDS).
• Advanced Excel (Pivot Tables/Power Pivot, Power Query, etc.).
• Experienced in Qlik View Server and Publisher maintenance for creating scheduled jobs for QVD extracts and report reloads.
• Acquired experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies, and wide range of Graphs using Tableau.
• In depth knowledge in creating, modifying, deploying and browsing the cubes with multiple measures and multiple dimension hierarchies in SSAS.
• In-depth knowledge of T-SQL (DDL, DML, DSL, DCL, and SQL CMD), MDX and XQUERY ­­­ (XML).
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Skilled at optimizing large complicated SQL statements.
• Knowledge of Statistics and experience using statistical packages (Excel, R, Python, SPSS or SAS).
• Expertise in development of Data Warehouse for both dimension tables and fact tables by initial load/ongoing load process using SCD/Merge/CDC, Parent/Child SSIS packages using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Expert in creating Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Sub-Queries, Joins, and Table Variables and Views involving multiple tables and Exception Handlers.
• Experience in verifying and tuning stored procedures created by developers using Execution plans, SQL Server Profiler, Data Tuning Advisor and maintenance tasks.
• Extensive knowledge in writing Stored Procedures, try-catch blocks, analyzing query plans, using extended managing indexes and locks, troubleshooting deadlocks and blocking, monitoring baselines and threshold values.
• Effective in design and development of Logical and Physical database using the methods and principles of normalization, dimension modeling, Data Modeling and SQL Server Enterprise manager.
• Experience in configuring linked services, Dataset and integrating Pipelines (end to end) in Azure Data Factory.
• Exposure Azure Data Bricks, USQL, ADLS (Azure Data Lake Service), Blob Storage, SQL DW, Log Analytics, ADF, and Azure Data Catalog.
• Good knowledge on Azure Database, Azure DW, and Azure Data Factory in SQL Server 2014 Cloud Environment.
• Good knowledge of System Development Life Cycle (SDLC), methodologies and principles.
• Worked on Erwin modeling tool to design database objects and Architecture.
• Excellence in Data Migration by using tools like Migration Wizard, Import and Export Data, Bulk Insert, BCP, SSIS, and SQL Server Upgrade Advisor.
• Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project.
• Excellent knowledge on Agile Development and Test-Driven Development.
• Acquired hands on experience in migrating SQL servers from /2008R2 and from SQL server 2008/2008R2 to 2012/2014.
• Experience in working with tools like LightSpeed, RedGate and Native SQL Backup and acquired experience in scheduling jobs on Log shipping and Maintenance plans.
• Good analytical, time management, organizational and problem-solving skills with the ability to handle multiple projects and work in a deadline-driven environment.
• Experience in providing off hours production support for 24x7 over weekends on rotation basis.

TECHNICAL SKILLS:

Programming Languages: SQL, TSQL, Dynamic SQL, MDX, XML, Python, JS

MS: SQL Server 2008/2008R2/2012/2014, Microsoft Access.

ETL Tools: SQL Server Integration Services (SSIS) 2008/2008R2/2012, DTS.

OLAP Tools: SQL Server Analysis Services (SSAS) 2008/2008R2/2012.

Reporting Tools: SQL Server Reporting Services (SSRS) 2008, Crystal Reports.

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools, Enterprise Manager, SQL Profiler, Query Analyzer.

Operating Systems: Windows Server 2008/2008R2/2012/2014, Linux, Unix.

Data Modeling Tools: Agile, Erwin, MS Office suite, MS Project, MS Visio

Visualization Tools: MS Power BI, MS Excel, Tableau, Qlik View.

Portal Technologies: SharePoint 2010, Microsoft Office SharePoint Server 2007, Office 2010, Share Point Designer2010.

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

SQL Developer

Responsibilities:

• Working on integration services and created ETL Packages to perform extract, transform and load data from different source to destination tables.
• Worked on implementing Client Onboarding process steps as part of ETL from All scripts Pro & touch works source systems to our Centralized Data warehouse using SSIS.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Working on different types of transformations, for example Slowly Changing Dimensions, Look-up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion etc. when creating SSIS packages to satisfy the business requirements.
• Working on Error handling mechanisms by using Event Handlers for different executable in SSIS packages.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created SSIS packages to migrate data from Oracle to SQL Server 2008R2.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support and also have experience in incremental data loading.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Worked with BI tools like Tableau and Power BI to generate visualized reports.
• Integrated reports from SSRS with SharePoint 2010 and created/deployed reports and BI Dashboards in Performance point/SharePoint 2010.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of reports in SSRS.
• Used Google Analytics to track the user traffic to the GIMS application.
• Working on data modeling tool like MS Visio to visualize database structure.
• Designing and creating database objects like Tables, views, stored procedures, indexes etc.
• Worked on creating and modifying complex Store Procedures and Functions per the requirements.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Upgrading and Installation, creating and managing databases, integrating MS SQL Server and Upgrading SQL servers to 2008 R2.
• Responsible for quantifying and optimization of the performance of upgradable packages to SQL Server 2008/2008R2/2012 from SQL server 2005 and Oracle.
• Experienced in maintain domain integrity and referential integrity by using constraints.
• Created and maintained triggers functionalities as per the necessity.
• Creating logins and mapping the user to roles by assigning permissions.
• Supporting design, implementation & support a multi-terabyte point-of-sale Data warehouse, performing Database design, implementation, creation & tuning of Data Aggregation mechanisms.

Environment: MS SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008/2008 R2/2012, SSIS, SSRS, SCOM, SQL Profiler, DTS, HA/DR, Performance Analysis, ETL, MS Visio, Cognos 8.2, SSDT, Database mirroring, Replication, Reporting Services.

Confidential, Plano, Texas

Business Intelligence Engineer

Responsibilities:

• Assisted with the design, implementation & support a multi-terabyte point-of-sale Data warehouse, performing Database design, implementation, creation & tuning of Data Aggregation mechanisms.
• Used Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional Data models such as Star Schemas.
• Responsible for creating Stored Procedures, functions, triggers, Views, T-SQL scripts, and PL/SQL as per the specifications and requirements.
• Responsible for creation and optimization of T-SQL scripts, PL/SQL packages, and PowerShell scripts.
• Build metadata for reporting applications and build reports.
• Gained experience in creating DTS packages for ETL, automation scripts for alerts.
• Created Tabular models (SSAS) using Tabular model project template that provides a design surface for creating a model, tables, relationships, and DAX expressions.
• Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services (SSRS) and exported them to Excel format for managers and Quality Analyst team for easy validation.
• Good experience of working with Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using SSAS.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).
• Developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of reports in SSRS.
• Design Percentage, Month over Month and Year over Year measures after importing data into Power BI desktop using DAX and Power Query functions. Slice measure in Power BI tile using calculated Dimension fields in Power BI.
• Responsible for the development, automating, compiling, and preparing reports, dashboards, cubes, etc. (Completed with initial direction but actual tasks completed independently).
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of reports in SSRS.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio
• Integrated reports from SSRS with SharePoint 2010 and created/deployed reports and BI Dashboards in Performance point/SharePoint 2010.
• Understands solution design satisfying the business requirements and uses knowledge within assigned tasks.

Environment: SQL Server 2008/2012, SSIS (2008/2012), SSRS (2012), ETL, Data Transformation Services (DTS), Visual studio, SAN, DTS, OLTP, OLAP Power BI, VB.Net, Oracle 10/11 PL/SQL, Visual Studio, SQL Profiler, Power shell, SSIS, SSRS, ETL, SAN, DTS, HA/DR.

Confidential, Columbus, OH

SQL Server Developer /DBA

Responsibilities:

• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Responsible for the Installation, Configuration and maintenance of SQL Servers 2005/2008/2008 R2/2012.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services ( SSIS ), DTS, Bulk Insert utilities.
• Scheduling and monitoring the ETL packages.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in SQL Optimizing and performance tuning by using SQL Profiler, Index Tuning Wizard, Windows Performance monitor, Database Tuning Advisor (DTA), DBCC Commands, and Query Execution Plans.
• Wrote stored procedures for report generation in SQL Server2012.
• Worked in the team responsible for the migration of SQL server 2005 to SQL Server 2008/2008R2/2012 according to the requirements.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Stored Procedures to validate the data coming with different data discrepancies using data conversions.
• Created sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for newly created Markets.
• Designed, Implemented and maintained regular DBA tasks like scheduling jobs, creating maintenance plans, user’s permissions and servers handling.
• Worked with tools like LightSpeed, RedGate and Native SQL Backup and acquired experience in scheduling jobs on Log shipping and Maintenance plans.
• Ensuring high availability of the database exploiting the concepts of Mirroring and Log shipping.
• Monitoring the Disk spaces on all the servers as per the requirements of the development team.
• Performing database maintenance activities like Backups, Restoring, re indexing etc.
• Responsible for maintaining production servers, monitoring performance issues, trouble shooting and solving production issues to ensure database optimization.
• Worked on creating Team projects for Reporting and Integration using TFS.
• Work with testing teams; perform UAT testing with business users.
• Worked on Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Environment: SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008/2008 R2, Oracle 10g, Transact-SQL, SCOM, Native Backup, SQL Profiler, Power shell, SSIS, SSRS, ETL, SAN, DTS, HA/DR, Native Backup, Litespeed, Agile, Erwin.

Confidential

SQL Server Developer (DTS/SSIS/SSAS/SSRS)

Responsibilities:

• Experience in writing complex SQL queries involving multiple tables, inner and outer joins, and stored procedures.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Designed and optimized all the SSIS packages and exported data from text file to SQL Server Database. Analyzed reports and fixed bugs in stored procedures.
• Responsible for writing T-SQL code for creating cursor and handling the data validations.
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
• Understanding the OLAP processing for changing and maintaining the Warehouse Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS.
• Expert in deploying the SSRS reports using Report manager.
• Good experience in writing MDX queries for developing reports in SSRS.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005/2008/2008 R2.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server.
• Created Reports showing the sales of various products in a particular Year, Quarter and Month using Business Objects.
• Developed excel reports through Power pivot and Pivot tables.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Skillful in designing and deploying the reports for End-User requests using Web Interface and SSRS (Ad-hoc Reporting).

Environment: SQL Server 2005/2008/2008 R2 with clustering, Windows 2003/2008, Replication, T-SQL, DTS, SSIS, SQL Profiler, Crystal reports, SSRS, Business objects, SQL Server 2008 Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, SSAS, MS SharePoint, MS Access, MS Excel, VB.NET, Team Foundation Services.

Confidential

SQL Server Developer

Responsibilities:

• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Developed Relational and Dimensionally Modeled Relational Models in Framework Manager.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in building DTS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in Importing/Exporting Data from various data sources like SQL Server, Excel, DB2 and Flat file using DTS utility.
• Expertise in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views.
• Experience in SSAS with all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Experience in using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Expertise on Business intelligence analytical tools like SSIS, SSAS, SSRS and generated Ad-hoc reports for reviews.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Worked extensively with Crystal Reports.
• Experience with SSAS, SSRS, Tabular-based reporting, and Tabular Data Models.
• Experience in creating reports, data driven subscription reports by using Report Builder in SSRS.
• Expert in deploying the SSRS reports using Report manager.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.

Environment: SQL Server 2005, 2008, 2008R2 (Enterprise edition), Windows 2000/2003, MS Clustering, Erwin, SQL Profiler, Crystal Report, MS Visio, SSIS, SSAS, SSRS, DTS, Query Analyzer, Database Mirroring, Replication, T-SQL, MS-Access.