PROFESSIONAL SUMMARY:

• Around 7 years of experience as a SQL Server Developer/Business Intelligence Developer focusing on system analysis, design, development, Database Administration & Support of MS SQL Server in production and QA, and SQL Server (SSIS, SSAS, SSRS) using Microsoft technologies and Business Intelligence.
• Area of experience includes Data Modelling, ETL, Data Warehousing, Business Intelligence, OLAP Cubes, Reports and Data Visualizations for Banking & Financial, Health Care, Wholesaler and Retailing domains.
• Hands on experience on SSIS, SSAS, SSRS, MDX, T - SQL, PL SQL, Power Pivot and Power View reports.
• Strong analytical and troubleshooting tuning skills using SQL Server databases, SSAS cubes, SSRS reports, SQL and MDX Queries.
• Expertise in ETL Developer using DTS package/ SQL Server Integration Services (SSIS) 2008/ 2012.
• Proficient in data extraction, cleansing/data integration, and loading from different data sources using SSIS and experience in creating jobs and schedule SSIS Packages.
• Hands on Experience on Data warehouse concepts Normalization and Demoralization.
• Hands on experience with Data Marts, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS) involved in Business Analysis of the OLTP and OLAP data in decision support.
• Proficient in creating, analyzing and testing of OLAP cubes in SQL Server analysis services (SSAS)using MDX.
• Experience in generating custom reports and various types of reports like Tabular, AD hoc, Matrix, Drill Down, Drill Through using SQL Server Reporting Services (SSRS) in BIDS.
• Proficient in developing visualizations with Tableau 10.x/9.x/8.x and deploying those visualizations to Tableau Server.
• Expertise in T- SQL (DML, DDL, DCL and TCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes and User Profiles.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related sub queries, in-line views and PL/SQL programming.
• Developed and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server2005/ 2008 R2/ 2012/ 2014 Analysis Services.
• Excellent knowledge and ability to work in all stages of Software Development Life Cycle (SDLC), Data Warehouse Life Cycle (DWLC).
• Expertise in installing, configuring, managing, upgrading and migrating, Backup/Restore, Writing & Debugging Stored Procedures, monitoring and troubleshooting SQL Server 2005/2008R2/2012/2016 database systems.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Experience in writing JavaScript, VBScript and batch files using DOS Commands.

TECHNICAL SKILLS:

Programming Languages: SQL, T-SQL, PL/SQL, MDX, C, VB Script, C#, VB .NET, Shell Scripting, JavaScript, Java. Classic ASP, Asp.net, .Net frame work.

Web Technologies: HTML 5, DHTML, XML, CSS 3, Angular JS

BI Tools: Microsoft BI (SSIS, SSRAS, SSRS), Self-service BI (Power Pivot, Power View, Power Query), DAX Studio, (Report Studio, Query Studio, Analysis Studio, Metric Studio), BIDS, Tableau, Power BI reporting tool.

ETL Tools: SSIS, Informatica, Talend, SAP - Business Warehouse, Power Query.

Database systems: MySQL, SQL Server, Oracle, DB2, Microsoft Access

Operating System: Windows 7/Vista/XP/2008/2003, Windows 9x, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. MSBI Developer

Responsibilities:

• Actively participated in interacting with the DBA’s and technical manager to know about the Business requirements andunderstand the function workflow of information.
• Involved in developing, implementing, and project supporting using SQL Server 2008, T-SQL, triggers
• Created SSIS Packages by using various Control Flow and Data Flow Tasks to execute SQL Task for each loop Container, Derived Column, and Data Conversion.
• Migrate existing data into the Power BI.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS
• Creating Ad Hoc, parameterized reports, linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2008 2008/R2,2012
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed complex calculated measures using Data Analysis Expression language ( DAX ).
• Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports and Dashboards.
• Merging and transforming data according to the requirements for ease of analysis in Excel by using Power Queryin Power BI.
• Creating Power Pivot models and Power Pivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance
• Developed Power BI reports using query logic based on business rules, and visuals selected by United stakeholders.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports
• Created different Power Pivot reports as per the client requirement.
• Defining data warehousefrom star and snow flake schema, fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Assist data modelers in designing of dimensional model for Star schema.
• Developed Power Maps using Excel for Reporting.

Environment: Microsoft SQL Server 2008/2012, Visual Studio 2008, T-SQL, SSIS, SSAS,SSRS, Business Intelligence Development Studio (BIDS), Power BI (Power Pivot, Power Query, Power Map, Power view), SQL server profiler, Team Foundation Server.

Confidential, CHICAGO, IL

SQL BI Developer

Responsibilities:

• Maintained physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and users in development and staging environment.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Generated multiple enterprise reports using SSRS from OLTP and OLAP, and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Developed reports, dashboards, and SQL queries using Tableau.
• Worked on gathering data requirements from different sources and data cleansing.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created and monitored workflows and tasks using Informatica PowerCenter.
• Created Clustered and Non-Clustered Indexes.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and development.
• Analyzed newly converted data to measure the data quality in data warehouse.
• Designed user interface for ASP.NET web forms and implemented application logic using C# and jQuery.
• Worked on converting the Asp.net Web Forms Application to Asp.net MVC.
• Designed C# forms and web pages to display SSRS and crystal reports for business reporting purpose.

Environment: T SQL, PL SQL, SQL Server 2017, SSRS, SSIS, ASP.NET, C#, Team Foundation Server (TFS), Visual Studio 2015, Team Foundation Server, SQL Server Management Studio, Informatica.

Confidential, IA

SQL BI Developer

Responsibilities:

• Participated in Status meetings with the clients, conducting reviews of the deliverables and defect tracking.
• Used SQL profiler and database Engine tuning advisor to optimize queries and enhance the performance of database.
• Worked on Data Flow Transformations like Slowly Changing Dimension, Conditional Split, Data Conversion, Derived Column, Look-up & Script Component, Aggregate, Audit etc.
• Designed data model from the scratch to assist the team in data collection to be used for Tableau visuals.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (8.x) reports
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Experience in Backup and Restore databases by SQL Server Management Studio and writing T-SQL.
• Migrated data from heterogeneous data sources (Data mart, Access, Excel, Flat file) to centralized SQL server databases using SSIS to overcome transformation constraints.
• Worked on Package and Project Configurations for Deployment of SSIS packages.
• Develop the Documents for Logging/Error Handling for SSIS Packages.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in creating Cubes using SQL Analysis Services (SSAS).
• Creating new Documentation, DB Schema designing, creating new ERD's using Visio.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2012 Reports Services (SSRS)
• Implemented various features of Crystal Reports like Parameters, report filters, formula, variables.
• Created test scripts and test cases to perform Unit and Integrated testing.
• Responsible for creating Drilldown, Drill through OLAP reports using SSRS 2012.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQLcreate, alter, and insert scripts.

Environment: SQL Server 2012, 2008 R2, SSIS, SSRS, MS 2003, SharePoint, Tableau, Business Intelligence Development Studio (BIDS), Visual Studio 2008 & 2005.

Confidential

SQL Developer

Responsibilities:

• Responsible for analysis, design and develop the code logic of the SQL databases and maintain it for production environment.
• Performed SDLC support services, duties include design, development and support,new account development, stakeholder identification, requirements analysis, product planning and scheduling,, managing projects and client expectations.
• Worked on Data Modeling of logical and physical databases using E-R diagrams.
• Involved in extensive data validation by writing several complex SQL queries
• Involved in back-end testing and worked with data quality issues.
• Used SQL Queries at the custom SQL level to pull the data in Tableau desktop
• Completed performance tuning of the dashboard in Tableau desktop.
• Working on Starand Snow flake schemas and built cubes using fact and dimension tables and deployed them to SSAS.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created OLAP cubes for analysis of sales in different locations using SSAS.
• Created SSIS(ETL) packages with ETL Import/Export wizard to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Implemented DAX (Data Analysis Expressions) to create various calculations like MTD actual totals, MOM and WOW comparisons.
• Implemented DAX functions for SSAS tabular models and Excel pivot tables.
• Generated reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel, Visual Studio,Database Engine Tuning Advisor, SharePoint, Tableau, Business Intelligence Development Studio (BIDS), Visual Studio 2008 & 2005.

Confidential

SQL Developer

Responsibilities:

• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Managed the security of the servers, as a part of Junior DBA administration duties.
• Backing up, restoring system & other databases as per requirements, and scheduled those backups.
• Developed SQL scripts for object transfer from one schema to another.
• Broadly involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views.
• Responsible for migrating databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and Deploying SSIS packages and extracting the data using SSIS from OLTP to OLAP.
• Successfully created dynamic configuration packages and Used Event Handlers for Exception Handling in SSIS packages.
• Involved in creating ODBC connections and database connections.
• Prepared reports for day-to-day and weekly/monthly purposes in various formats like MS Excel, PDF, and XML.
• Performed maintenance of Stored Procedures to improve the performance of different front-end Applications.
• Used SSIS for migration and SSRS for creating reports.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

Environment: SQL Server 2008/2005, SSIS, SSRS, SQL Server OLAP 2000, Reporting Services 2005, T-SQL, MS Access, Windows XP/2003 Server, Visual Studio 2008.