SUMMARY

• Over 8+ years of experience as a Database engineer using MS SQL 2008/2012/2014/2016, BI Stack in various industries.
• Extensive noledge dealing with Relational Database Management Systems (RDBMS), OLAP, OLTP systems.
• Experience in creating various SQL server Objects like Tables, Views, Stored Procedures, User Defined Functions.
• Experienced in writing Complex T - SQL scripts to support Ad-hoc needs.
• Very good noledge in fine tuning long running T-SQL scripts by breaking down complex scripts to simple once, Creating Indexes, Updating statistics and so on.
• Hands-on experience in Database Administration Operations like Backup, Recovery, Installing, Configuring, Managing, monitoring and using SQL Profiler.
• Extensive experience in ETL (Extract, Transform and Load) activities using SSIS.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and loading them into various heterogenous sources.
• Experience in creating complex SSIS packages which contains several control flow tasks like Execute SQL Tasks, Script Tasks, Data Flow Tasks, For Each Loop, and so on.
• Experience in transforming data using Data Flow Tasks like Derived Column, Data Conversion, Row Count, Merge Join, Union All, etc.
• Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints, and Logging for Complex SSIS Packages.
• Experience in various kinds of SSIS Deployments like Catalog Deployment, File Based Deployment, and SQL Server Deployment.
• Wide experience in Creating OLAP Cubes using SSAS.
• Experience in identifying dimensions, attributes, hierarchies, calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Experience in creating Reports Using SQL Server Reporting Services (SSRS).
• Experience in creating various complex reports in SSRS (tabular, drill down, drill through, matrix, chart, and parameterized) per requirements.
• Experience in creating various kinds of Subscription Reports, Linked Reports, Cached Reports in SSRS.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing needs.
• Proficient in OLTP, OLAP and Data Warehouse Design concepts.
• Very good noledge in various kind of schema’s in OLAP like Start Schema, Snow Flake Schema.
• Hands on experience in designing DW Databases using Inmon, Kimball methodologies.
• Hands on experience in designing databases using tools like VISIO, ER Studio.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation.
• Published reports and dashboards designed in Power BI utilizing Power BI service.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies and participated in sprint planning, retrospective, estimates etc.

TECHNICAL SKILLS

Operating Systems: Windows XP/2007/2010/Vista

RDBM/Databases: MS SQL Server 2008/2012/2014/2016, MS Access 2010, MySQL

Programming Languages: T-SQL, Dynamic SQL, DOS Scripting

Data Modeling: MS Visio, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema, Relational, Dimensional and multidimensional modeling and De-Normalization Techniques, MS- Access

Data Design Tools: MS Visio, Smart Draw

BI Tools: SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), Power BI, BIDS

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Visual Studio Team Foundation Server (TFS)

Application Packages: MS Office, Microsoft SharePoint Server

PROFESSIONAL EXPERIENCE

Confidential

Sr SQL/BI (SSIS/SSRS)/Power BI Developer

Responsibilities:

• Gathered requirements by discussing with the Users and the Team members.
• Involved in database design process and data modeling process using diagrams and Visio.
• Involved in importing and exporting data from text files, MS Excel and other OLEDB sources into SQL Server using SSIS/DTS and Vice Versa.
• Created Joins, Views, Stored Procedures, Functions and Triggers and also scripted Sub Queries using T-SQL involving multiple number of tables.
• Studied the existing OLTP system(s) and Created Facts, Dimensions and Star Schema representation for the Data Mart.
• Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Created several Staging Databases.
• Managed the ETL processes between various environments through SSIS configuration.
• Created the derived columns from the present columns for the given requirements.
• Normalized the source data for loading the data into Dimension and Fact tables using ETL controls in SSIS.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Designed, developed and maintained Power BI visualization solutions.
• Transformed and combined the data using Query Editor in the Power BI and Published Power BI Desktop reports created in Report view to the Power BI Service.
• Created Calculated columns and measures in Power BI based on report requirements.
• Created Ad Hoc reports by building models in Report Builder using SSRS Model Designer and Report Builder.
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multivalue, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created Pivot Tables and Pivot Charts in MS Excel.

Environment: s: SQL Server 2016, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Visio, Power BI, MS Excel.

Confidential

SQL/SSIS/Power BI Developer

Responsibilities:

• Involved in Various meetings with different levels of End/Business Users to gather business requirements.
• Involved in the Design and Development of several new projects.
• Involved in development of new Data model for Enterprise wide Self-Service Solution.
• Involved in integration of three major systems into one consolidated DW.
• Created several database objects like Tables, Views, Stored Procedures and Indexes.
• Wrote complex Stored Procedure to automate the processes.
• Involved in writing several T-SQL scripts to support daily operations.
• Involved in fixing of dimensions which were having corrupt data.
• Developed and maintained ETL jobs for data warehouse/Marts.
• Created several SSIS Packages to extract data from heterogeneous sources (like Flat File, Excel, and OLEDB) to SQL-Server and Vice-Versa.
• Implemented several Transformation, Logging, Package Configurations and other SSIS features while creating SSIS Packages.
• Created Master Package(s) to call child packages and implemented various error handling mechanism.
• Created visualizations with drill down, drill through features in Power BI.
• Built and published customized interactive dashboards utilizing Excel Power BI.
• Published Power BI desktop models to Power BI service to create highly informative dashboards and to get quick insights.
• Implemented Parallelism mechanism to nightly jobs so that Jobs run 50% faster.
• Maintained very good communication with offshore team to ensure that offshore team receives all the business requirements to keep project on track.
• Supported and modified several SSIS and T-SQL Scripts.
• Very good experience in handling multiple projects.

Environment: MS SQL Server 2014/2016, T-SQL, MS Excel, Power BI, Visio, T-SQL, Data Modeling, SSIS.

Confidential, Plainville CT

SQL/ BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Involved in designing of Datamart using Star Schema.
• Created Views, Stored Procedures and scripted Sub Queries using T-SQL involving multiple numbers of tables.
• Involved in creating script of the entire database.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data from various Sources to Database and Vice Versa.
• Involved in importing and exporting data from MS Excel and other OLEDB sources into SQL Server using SSIS.
• Developed SSIS Packages to populate Datamart from various types of source files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Involved in using Script Control flow task to find the last written time of the file.
• Involved in creating SSIS Package Configuration using variables and SQL Server.
• Created Master Package to call other packages and Processing Cube using SSIS.
• Deployed SSIS packages using File System Deployment.
• Maintained & Created Cubes using SSAS.
• Involved in creating Named Queries in Data Source View, creating new Dimensions, Modifying Dimensions to add new Hierarchies and other stuffs in SSAS.
• Involved in adding Calculated Measures, KPI’S and Partitions.
• Created ROLAP and MOLAP SSAS Cubes based on requirement.
• Deploying OLAP Cubes.
• Involved in editing already existing reports by adding parameters, adding new groups and changing underneath data source (Sprocs).
• Created many Drills-Through, Drill-Down and Linked Reports.
• Created reports which can handle input parameters from users and reports which can handle dynamic coloring of cells/data as per values.
• Involved in Deploying Reports to the report manager in both prod and dev servers.
• Deployed reports using both BIDS and Report Manager.

Environment: SQL Server 2012/2014, T-SQL, BIDS (Business Intelligence Development Studio)SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), MS Excel.

Confidential, ST Louis MO

SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in Database Design process and Data Modeling process using Visio and ER Studio.
• Created Views, Stored Procedures, Functions.
• Involved in Creating Indexes to optimize the query performance.
• Developed SSIS Package to Extract, Transform and Load data using various Control Flow and Data Flow tasks.
• Involved in importing and exporting data from text files, MS Excel and other OLEDB sources into SQL Server using SSIS and Vice Versa.
• Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Used various dataflow tasks like Aggregate, Derived Column, Data Conversion, Merge Join, Sort, Union, Lookup, Conditional Split, Multicast to perform various kinds of transformations.
• Created several reports with multiple input parameters and sometime even cascade parameter reports.
• Designed Various Reports using different reporting features such as Group By, Drilldowns, Drill Through etc.
• Created Linked reports and reports which had subscriptions.
• Worked on performance tuning of long running SSRS reports by creating cached reports and other techniques.
• Deployed reports into the report manager using Report Builder and by uploading the rdl file into report manager and connecting it to Data Source.
• Created Pivot Tables and Pivot Charts in MS Excel.

Environment: SQL Server 2008-R2/2012, T-SQL, BIDS (Business Intelligence Development Studio), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Visio, MS Excel.

Confidential, Hoover AL

SQL Server Development DBA

Responsibilities:

• Participated in the Installation of SQL Server. Installed SQL Server Enterprise manger tools and BI tools on Windows 2003/2008.
• Create and Maintain databases after logical and physical database design.
• Set database Access Privileges for different users and user groups using Active Directories and SQL Server Logins.
• Wrote various kinds of DDL and DML statements.
• Create database objects including Tables, Triggers, Views, Stored Procedures and Indexes.
• Wrote Procedures/Stored Procedures/Functions in T-SQL for various applications which sits on top of the database.
• Implemented the Indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Involved in Code Reviewing and Suggesting changes to script to meet ANSI SQL standards.
• Used various SQL Server Performance tools and commands like Execution Plan, Set Statistics IO to read logical reads, DBCC to check inconsistency in DB.
• Did Performance tuning of long running Stored Procedures.
• Used SQL Profiler and SQL Sentry to read catch the long running SP’s / Select statements.
• Maintenance of clustered and non-clustered indexes.
• Create Jobs and Monitor job history for maximum availability of data and to ensure consistency of the databases.
• Involved in creating SQL Server Coding Standards Document.
• Used various tools like IDERA, Litespeed and SQL Server Native Tools to Backup and Restore Database.

Environment: MS SQL Server 2008/2012, T-SQL, MS Excel, Visio, ER Studio, T-SQL, Data modeling, IDERA, LiteSpeed, SVN (Tortoise SubVersion), WinMerge.

Confidential, Atlanta GA

SQL/BI Developer

Responsibilities:

• Wrote complex SQL queries to populate data from different tables and which was used for reports.
• Developed ETL Packages using SSIS to populate data from different sources, for example flat files/SQL/Oracle Server to the Staging Database and tan into the Data Warehouse. The packages created included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Created Cubes and populated them with Dimensions and Facts from the Staging Database.
• Created reports by linking data from Data Warehouse Cubes using SQL Server 2008 Reporting Services.
• Created drill down reports using SQL Server 2008 Reporting Services.
• Deployed the generated reports on to the server.
• Script SQL statements to extract data from the SQL Server for data cleanup.
• Monitored the table-spaces for the production databases on daily basis and increasing the sizes if required.
• Fine-tuned SQL queries using hints for maximum efficiency and performance.

Environment: MS SQL Server 2008, SQL Server Reporting Services, Report Manager, Report Viewer, SQL Service Integration Services (SSIS), MS Excel.

Confidential

MS SQL Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
• Created Tables, Indexes and Constraints.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Defined stored procedures for module integrity and application.
• Wrote Procedures/Stored Procedures/Functions/Triggers in T-SQL for various applications which sits on top of the database.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Used SQL Server Profiler to trace the slow running queries.
• Analyzed and debugged jobs and procedures.
• Performed Backup operations.

Environment: MS SQL Server 2008, T-SQL, MS Excel, SQL, T-SQL, SQL Query Analyzer, Profiler.