SUMMARY

• More than 8 years of IT Experience in Database Design, Development and business intelligence of Confidential SQL Server 2016/2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains.
• Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS .
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization .
• Developed PL/SQL Triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored Procedures, Functions and Packages for moving the data from staging area to data mart.
• Good knowledge on Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL) .
• Created data base on Confidential Azure, setting up connection strings and connecting SQL server AZURE databases from locally installed SQL Server Management Studio( SSMS ) for developers
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development, ETL development using Confidential SQL Server Integration Services (SSIS), Business Intelligence delivery using Confidential SQL Server Analysis Services (SSAS) and Reporting solutions using Confidential SQL Server Reporting Services (SSRS) .
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder ( list, matrix, graphs, sub-reports, tablix ).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012 .
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access , Excel , CSV , flat files using connectors, tasks and transformations provided by SSIS .
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Integrated Custom Visuals based on business requirements using Power BI desktop .
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema .
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports, Power BI, Tableau

Relational Databases: SQL Server 2016/2014/2012/2008 R2/2005, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Ticketing Tools: Incident Management (ICM)

Other Tools: Confidential Office 2003/2007/2010 and 2013, Power pivot.

Data Modeling Tools: Confidential Visio 2003/2007/2010 , Erwin and Power Builder.

SQL Server Tools: SQL server Management Studio, Confidential Visual Studio 2010/2013/2015

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Confidential, WASHINGTON

POWER BI Consultant

Responsibilities:

• Providing 24X7 production support for critical ETL processes and strategic financial reports.
• Created new database objects like procedure, functions, packages, triggers and views using T-SQL in development production environment for SQL server.
• Scheduling the SSIS packages to run as jobs on periodic basis according to the requirement using SQL Server Agent.
• Creating complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Creating Power BI reports and Dashboards based on the requirement of the client.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Used DAX functions to generate spreadsheets and pivot tables.
• Establish Import connection to store the data source in the Power BI and creating measures using DAX, creating parameters, changing columns name to make them more user-friendly.
• Created and maintained the data sources in On Premises Gateway.
• Involved in troubleshooting, resolving, and escalating Power BI issues.
• Used Incident Management (ICM) to create tickets for various productivity issues to ensure transparency and prioritize work flow.
• Created monthly reports in Power BI based on the tickets for reducing the issue count in the future.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Informatica, SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Excel, Windows XP, Power BI Desktop/Service.

Confidential

SR. SQL DEVELOPER

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Performed tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2012
• Installed and configured SQL Server 2008R2/2012 in Test environment with latest service packs and migrated few databases
• Created indexes, Constraints and rules on database objects
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Developed physical data models and create DDL scripts to create database schema and database objects
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS).
• Integrated custom visuals based on business requirements using Power BI desktop.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular Database.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Created drill down and drill through reports with parameters in Power BI and SSRS.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web
• Created Customized and interactive dashboards using multiple data sources
• In depth knowledge in Tableau Advance Analysis features like Actions, Calculations, forecasting, Parameters and Trend lines
• Worked on Dual Axis concept while working with reports with Tableau
• Created conditional filters and Action links to filter the data on dashboard with Tableau.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Created Cubes using different types of OLAP methods like Multidimensional OLAP ( MOLAP ), Relational OLAP ( ROLAP ).
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Oracle 9i/10g/11g, Informatica, SQL Server Analysis Services (SSAS), Tableau, Visual Studio 2010, MS Excel, Windows XP, Tableau desktop 7.0/8.1/8.2/9.0 .

Confidential

Power BI/MSBI DEVELOPER

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Develop complex Enterprise and Divisional level Power BI reports and dashboards using the full array of features including DAX queries.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts .
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop .
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Creating Dashboard Reports using Power BI and Tableau.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Created Dimensions with the cube wizard and individually and Generated Named calculations and named queries.
• Developed customized reports using Power BI Desktop based on the requirement
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations .

Environment: MS SQL Server 2008R2/2012/2014, Oracle 9i/10g/11g, SSIS, SSRS, Management Studio, Visual Studio, DTS, Windows 7,MS Office 2010/2013,Windows Server 2008 and Windows Server 2008 R2,Visio 2010/2013,Power BI Desktop, Power BI Service.

Confidential

MSBI DEVELOPER

Responsibilities:

• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services ( SSIS ) 2008.
• Planned, designed, and implemented processes to receive, transform and load valuable data from external sources into local databases.
• Designed SSIS Packages to load data from different sources like excel, flat file, csv etc.
• Designed Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, mail task, Derived Column, and For Each Loop, Data Conversion etc .
• Provided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes
• Developed perspectives to simplify the process of browsing the cubes
• Used Lookups Transformation to get the data from reference data sets

Environment: SQL Server 2008R2/2012 Enterprise Edition, Business Intelligence, SSIS, T-SQL, MDM, SSRS, Windows Server 2008, Oracle 9i, MS excel 2008, Confidential Visual Studio 2008 .