SUMMARY

• Over 11+ years of experience as Microsoft SQL Server Business Intelligence Development (SSIS, SSRS, SSAS) in Production, Development & Staging Environments, along with around 3 years of data visualization using Power BI & Tableau
• Strong Communication & Management skills with Excellent Role - playing capabilities
• Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, SSAS, Microsoft SQL Server 2016/2012/ 2008 R2/ 2008/2005, T-SQL, MDX, Power View, Power Pivot, Power BI, Tableau
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles
• Well experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like SQL Server, Teradata, Oracle with multiple Terabytes of size and various levels of complexity
• Vast experience in creating complex SSIS packages, SSRS reports, Building SSAS Cubes, creating SQL Stored procedures, User defined functions, writing complex MDX
• Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages, DTS and BCP utility
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Involved in migration of SSIS Packages 2012 CU5 and troubleshoot migration issues
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel and Oracle
• Processing and storing JSON via SQL server. Used JSON functions connect relational and NoSQL concepts in SQL Server
• Parsed JSON text and read or modify values in SQL Server. Transform arrays of JSON objects into table format
• Format the results of Transact-SQL queries in JSON format
• Designing and Deployment of Reports (SSRS) for the End-User requests using Web Interface & SSRS
• Expertise in Performance tuning, Optimization by using SQL Profiler
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors using SQL Server 20 with T-SQL
• Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC)
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experience in implementing Transactions and XML configuration files to SSIS Packages
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Designed, developed, implemented, and supported Power BI, Tableau dashboards
• Expertise in writing complex DAX functions in Power BI and Power Pivot, created Dax Queries to generated computed columns in Power BI
• Generated computed tables in Power BI by using Dax
• Integrated data sources and databases with Tableau and designed and developed data models and backend queries for presenting data.
• Created data queries and reports using Tableau, Visual Studio, SQL Server Management Studio, SSRS, and Excel
• Created Dashboards with different style using Tableau components like List Box, Slider, Buttons, charts and Bookmarks
• Created custom queries/reports designed for quality verification and information sharing
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports, and MS Excel spreadsheets
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS) using SQL SSRS 20
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security
• Experience in the integration of SSRS Reports using various web parts into Dashboards and Sharepoint
• Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions
• Experience in SSAS cube Building
• Design and develop OLAP Cubes using SQL Server Analysis Services (SSAS)
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Good experience in Dimensional Data Modeling Star and Snow Flake Schemas

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, Oracle 10g

ETL Tools: SQL Server Integration Services(SSIS)

Reporting Tools: SQL Server Reporting Services(SSRS)

Analysis Services: SQL Server Analysis Services(SSAS)

Data modeling Tools: MS Visio 2003/2007, Rational Rose

Web Designing: HTML, CSS

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005, DreamWeaver 8.0

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, NC

Database/Report Lead Developer

Responsibilities:

• Gathering requirements from the end-user-departments of the organization
• Designing and developing SSIS ETLs for loading/refreshing data warehouse
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Creating stored procedures for dimension table loading, SSRS Reports, Power BI Report
• Developed different types of SSRS reports like Drill Down, Drill through, Cross tab reports
• Creating SSRS reports and Power BI dashboards
• Participating in scrum calls, and conducting developers-team calls for status and progress

Environment: SQL Server 2016, T-SQL, Microsoft BI, Visual Studio 2019, Power BI

Confidential, Morrisville, NC

BI/Database Lead Developer

Responsibilities:

• Gathering requirements from the different departments of the organization
• Designed and developed Integration Services (SSIS) and Reporting Services (SSRS) objects
• Designing generic & custom SSRS Reports for the all/individual the practices, and corporate management
• Developed Different types of complex SSRS reports like Drill Down, Drill through, Cross tab reports
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the end-user requirements
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Creating SSIS ETLs for providing Outbound extracts (in several formats - csv, txt, excel) to the vendors, as per the requirements
• Designed SSIS Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load
• Developing new versions of reports in Tableau using Analysis on older SSRS Reports
• Involved in Analyzing, designing, building, testing of OLAP (Data warehouse) cubes with SSAS and in adding calculations using MDX
• Created & Developed, in SSAS (Data warehouse), storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Prepared and published customized reports/dashboards using Tableau/Power BI
• Created different Action filters, Parameters and calculated fields to create most complicated dashboards in Tableau/Power BI
• Worked with Tableau administrator in managing Production, Test and Development environments

Environment: SQL Server 2016, T-SQL, Microsoft BI, Visual Studio 2017 Pro, SQL Server Data Tools, Tableau, Power BI

Confidential, Madison, WI

SQL BI Lead Developer

Responsibilities:

• Gathering requirements from the Client/end-user
• Co-ordinating with off-shore team, tracking the developments
• Planning with the management team & development teams, regarding the current / future projects & deliverables / developments
• Designing and developed Integration Services (SSIS) and Reporting Services (SSRS) objects
• Designing and Building the Dimensions and cubes (Data warehouse) with star schema using SQL Server Analysis Services (SSAS)
• Experience in modifying MDX Cubes and Dimensions in SSAS
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS
• Designing SSRS Report templates on the Health insurance data
• Developing various types of complex SSRS reports like Drill Down, Drill through, Cross tab reports
• Created Dashboards for top level management using Tableau/Power BI
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the end-user requirements
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Creating SSIS ETLs for providing Outbound extracts (in several formats - csv, txt, excel) to the vendors, as per the requirements
• Designed SSIS Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Extracting values from JSON text and use them in queries
• All the developments were done in accordance with HIPAA standards

Environment: SQL Server 2016, T-SQL, Microsoft BI, Windows Server 2012, Visual Studio, SQL Server Data Tools, Tableau, Power BI

Confidential, Winston-Salem, NC

SQL BI Lead Developer

Responsibilities:

• Designed and developed Integration Services (SSIS) and Reporting Services (SSRS) objects
• Designed Reporting Server and Dashboards
• Developed reports using SSRS, Power BI, Tableau and created High Level Dashboards
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the end-user requirements
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Designed SSIS Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Stored JSON data in SQL Server. Combine relational SQL Server data and JSON data
• Worked with MDX to query SSAS (Data warehouse) cube’s data
• Created new cubes and modified existing cubes using SSAS to make data available for the decision makers
• Designed user defined hierarchies in SSAS including parent-child hierarchy
• Used MDX to define KPI’s, calculated members in the cubes
• Designed, developed, tested, and maintained PowerBI using DAX functional reports based on user requirements on top of the Tabular Model
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements
• Utilized Tableau, Power BI (Power View) to create various analytical dashboards that depicts critical KPIs, along with slicers and dicers enabling end-user to make filters
• Generated ad-hoc reports in advanced Excel (like pivot tables/lookup/etc), Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Writing complex MDX & DAX formula Develop the complex Dashboard
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Designed complex data intensive reports in Power BI/Tableau utilizing various graph features such as gauge, funnel, line better business analysis
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.

Environment: SQL Server 2014, T-SQL, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Team Foundation Server (TFS), Power BI, Tableau

Confidential, St. Louis, MO

Senior Database Lead

Responsibilities:

• Designed the architecture of Integration Services (SSIS) and Reporting Services (SSRS)
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Designed SSIS Package to do ETL Auditing and designed Stored Procedure to keep track of Daily Load.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Designed and developed ETL using SSIS, to bring data from heterogenous systems into staging server
• Applied medium to complex level ETL transformations
• Developed reports using SSRS, Power BI, Tableau, and created High Level Dashboards
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements

Environment: SQL Server 2012/2008 R2, T-SQL, Teradata, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Team Foundation Server (TFS), Tableau, Power BI

Confidential, Greensboro, NC

Senior Technology Specialist - SQL BI

Responsibilities:

• Responsible in integrating the data from different sources through packages using SSIS, analyzing the data and creating cubes using SSAS
• Responsible for designing reports using SSAS cube, OLTP as a data source in SSRS
• Generated various Drill-through Reports, Parameterized Reports, Matrix and Tabular Reports
• Responsible for designing database, creating tables, stored procedures, user defined functions and implementing joins, index using T-SQL
• Responsible in monitoring the SSIS packages which run at scheduled intervals and fix the failures
• Responsible for deploying the reports in Web Server and Report Server respectively
• Involved in integrating the modules of the application
• Responsible in monitoring and troubleshooting SQL jobs and the log shipping
• Involved in deploying SQL scripts, SSIS packages and Web Applications to production server on a weekly basis
• Gathering requirements from stakeholders with respect to Database details, Project Workflow, etc.
• Actively participated in Database design and development
• Worked as Database developer
• Created Tables, views, Stored Procedures, Functions, Views, MDX
• Extracted data from various sources such as DB2, Oracle, Teradata fixed width and de-limited flat files, cleansed and loaded data into Teradata and Flat file targets using Informatica and PL/SQL
• Actively participated in SSRS solution designing and developing

Environment: SQL Server 2012, SSRS, SSIS, SSAS, DB2, Teradata

Confidential, St. Petersburg, FL

Senior Software Design Engineer - SQL BI

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database
• Created SSIS packages to load data from several databases and several sources to SQL Server using various transformations in SSIS.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Used Hudson/Autosys for Job scheduling
• Created reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used various formatting techniques like interactive sorting, grouping to created user-friendly reports.
• Created report snapshots to improve the performance of SSRS
• Created Dashboards with different style using Power BI/Tableau/Tableau components like List Box, Slider, Buttons, charts and Bookmarks.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Documentation for all kinds of reports and SSIS packages.
• Experience in Marks, Publisher and Security concepts
• Experience with creating Worksheets and Dashboard
• Experience with Tableau & Power BI for Data Acquisition and data visualizations
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes

Environment: MS SQL SERVER SSIS, SSRS 2008 R2, Windows Azure SQL, SSRS 2012, Tableau, Power BI

Confidential, Tampa, FL

Senior Database Developer

Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules
• Installed SQL Server 2005 Servers, multi instances
• Responsible for security and roles
• Responsible for development of Procedures, Functions and database Triggers
• Designed Data was stored in MS SQL Server
• Created indexes and analyzed its role for optimizations
• Developed Dynamic search queries and results with manipulated data
• Responsible for developing file transfer controls

Environment: MS SQL SERVER SSIS, SSRS 2008 R2, SSRS 2012