SUMMARY

• Over 71/2 years of experience in SQL Server database and Data Loading and Reporting tools with SSIS, SSAS, SSRS, and Power BI.
• Having more than 3 years of experience in developing reports in Power BI and Migrating reports from SSRS to Power BI.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T - SQL, Database Design including ER diagrams, normalization.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), SQL Clustering, Rules, Performing Tuning, Query Optimization and Data Validation issues.
• Worked with both OLTP DB and OLAP DWH
• Created, Built and deployed successfully dynamic SSIS packages into SQL Servers 2014/2012/2008 databases and scheduled them according to the requirements.
• Performed Data Quality Services (DQS) to enable a data and to maintain the quality of the data and to ensure that data is suitable for its business usages.
• Having experience with C#.
• DQS enables to discover, build and manage knowledge about the data which are used to perform data cleansing, matching and profiling.
• Created and Configured Data Source and Views, Dimensions, Cube, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services and MDX.
• Proficient in Developing SSIS Package to perform ETL on data into the Data Warehouse (DWH) from Heterogeneous databases such as Oracle, DB2 and MS Access, Microsoft Azure.
• Worked with RDBMS implementation using SQL, PL/SQL and MySQL on Oracle Database.
• Expert in creating the MDX cubes and dimensions (SSAS).
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connections from heterogeneous sources (Excel, CSV, Oracle, Flat files, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task, SCD, Lookup, Bulk Insert, Merge and union all.
• Expert in developing Data Warehouse architecture, ETL framework and BI Integration using Reports and Dashboards.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
• Experience in writing Parameterized Queries for generating stylish Tabular reports, Drill down, Drill through, Cascading, Parameterized, click through, Matrix, Chart, Snap shot reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Experience in working with large databases in SQL, Oracle and Teradata.
• Involved in SSAS cube maintenance activities including troubleshooting and Data Visualizations using SSRS and Crystal Reports and Power View.
• Knowledge in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot tables, scatter plots, pie charts and packed bubbles and use multiple measures for comparison such as Individual Axis, Blended Axis and Dual Axis.
• Widespread knowledge in using report building tools like PowerBI, Tableau and Qlikview.
• Worked for production support for multiple projects. Mainly focused on clearing issues in the ETL packages and SSRS Reports.
• Experience in working at various levels of software development cycles such as Analysis, Designing, Developing and Testing & Implementation of business applications in Client Server/RDBMS for Windows platform.
• Good knowledge in Normalizing and De-normalizing the tables and maintain Referential Integrity by using Triggers and Primary and Foreign Keys.
• An empathetic listener and persuasive speaker with excellent written and verbal skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, MySQL, MDX, C, C#, Java

Databases: MS SQL Server 2016, 2014, 2012, 2008R2, MS Access

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS Cube and Tabular), Visual Studio, Red Point Data Management

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, FACT & Dimension Tables, Normalization and De-Normalization Techniques

Reporting Tools and Utilities: SQL Server Management Studio (SSMS), SSRS, Crystal Reports, PowerPivot, Power BI, Tableau

Operating Systems: Windows Family, UNIX

Packages: MS Office, Microsoft Office SharePoint Server 2007

PROFESSIONAL EXPERIENCE

BI Report Builder

Confidential, Burlington, MA

Responsibilities:

• Studied the existing OLTP systems and interacted with Data Architect for facts, dimensions and star schema representation for new data mart.
• Involved in integrating data from different OLTP databases to Azure DW for Data Marts.
• Involved in discussions with business users to get better understanding of the requirements what they are expecting to see in the reports.
• Developed reports for Adhoc queries and from OLTP using Power BI from scratch and shared with business users.
• Migrated existing SSRS reports into Power BI.
• Integrating data from various sources and applying transformations to the data while loading the data into Data Mart staging tables.
• Worked on incremental loads for daily processing to feed the source tables incrementally for the Facts and Dimension Tables of Data Marts. To load the data from source to data mart, we used two packages i.e., Type 1 and Type 2 for incremental loading
• Wrote complex stored procedures to populate data into Facts and Dimension tables for the Data Marts.
• Developed SQL Queries for fetching complex data using joins, sub-queries, CTE’s.
• Developed DAX queries in Power BI reports for measures and calculated columns.
• Optimizing SQL Queries to improve the performance and also for the faster retrieval of data from tables.
• Generated YOY reports as bar charts, graphical charts, table visuals for the management using different techniques like data filtering, adding interactivity, deploying reports to power bi server.
• With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
• From power bi dashboard itself business users will get all the information they required instead of going through the report. Dashboard was developed in such a way that it will gives information to the users to take a proper decision to increase the business.
• Worked on creating pipelines in ADF to trigger existing SSIS package deployed in SSIS Catalog through LIFT and SHIFT Existing SSIS Package method in V2 of Azure Data factory.
• Gave production support for live project and troubleshooting time taking queries.

Environment: SQL Server 2016,2017 T-SQL, Excel, Power BI Desktop, Power BI Web, Azure DW, Visual Studio 2015, Azure Data Factory.

Senior MSBI/SQL Developer

Confidential

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business projects across the organization.
• Developed Custom Visualization in Power BI such as Liquid Fill Gauge, Bar Charts, etc.,
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Created various complex reports, Dashboards and manage those using SQL Server Reporting Services.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Developed SQL Queries for fetching complex data using joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Worked with database developers in all phases. Having a good knowledge on database design according to the client specifications and requirements
• Designed various kinds of reports on given data and some of the reports like cascade, parameterized and linked reports that will help to drill-down process in the report.
• To load the data from source to data mart, we used two packages i.e., Type 1 and Type 2 for incremental loading.
• We written complex SQL Queries for analyzing the data to design the reports for various stake holders and also optimizing SQL Queries for faster retrieval of data.
• With the help of visualizations in Power BI, created various visualization like Pie charts, Bar graphs, Tree maps etc., that will helpful easily to understand the data.
• Holding the responsibility for deploying the SSIS packages and scheduling the packages through jobs in all phases including development, testing and production.
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, look up, Data Conversion, Merge Join.
• Used SSIS and SQL Server stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Extensively worked on production support that includes Deployment of SSIS packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Extensively worked on ETL packages to extract, transform and load data from different sources like Excel, Flat files, Execute SQL Tasks, Data Flow Task, Derived Columns Tasks.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to Cloud.
• Shared reports in Power BI service to entire Organization in Office 365.

Environment: SQL Server 2016, T-SQL, PL/SQL, Excel, Power BI Desktop, Power BI Web, Azure Database, Visual Studio 2015, MS Excel, Microsoft Azure.

Senior BI/Power BI Developer

Confidential, St Louis, MO

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate.
• Developed Queries for generating reports in SSRS 2012 for Complex Executive Dashboards and Customer Performance dashboards to analyze the KPI’s for all global clients.
• Created database objects like Procedures, Functions, Triggers, Indexes, and Views using T-SQL in SQL Server.
• Optimizing SQL Queries to improve the performance and also for the faster retrieval of data and also for the improving the performance of SQL Queries.
• Used various transforms in SSIS to load data from accounting software Quick Books in the form of flat files to the SQL databases.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables and views and other SQL joins for building various applications.
• Helped our customers with different refresh issues in the Power BI online service.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Utilized Power BI for Office 365 to amplify data visualization with collaboration and data management.
• Developed multiple dashboards with Power BI depicting differing KPIs for business analyses.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Employed bar charts, bubble charts, and Power map to answer business questions with Power BI.
• Created, maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Studied the existing OLTP system(s) and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Involved in recreating the analytical reports using MS Access Database using SSRS to eliminate any Manual Processing.
• Involved in integrating SSRS Reports with QR Codes, Micro QR Codes, and Standard barcodes using third party applications to track the Samples at various levels from receiving to testing.
• Created Accounting Reports based on Quick Books data for Region wise sales, sales by client, Sales by State, quarterly sales for all the Global clients.
• Experienced in using Power-Pivot for analyzing the raw data and team meetings and during requirements gathering.
• Created SSRS Report to automatically print the label for the Sample Scheduling for the Analysts, eliminating the manual process and paper based approach.
• Involved in both Unit Testing and Integration Testing to ensure all the software deliverables are following the end user business and technical requirements.
• Involved in embedding the SSRS Reports and Dashboards in the internal web applications.
• Worked on the POC of Creating Monthly Quality Assurance Reports, letters for some of the exclusive clients and setup subscriptions to deliver these Reports based on a schedule.
• Involved in generating several Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Worked on caching the reports to improve the Report Retrieval Time.
• Used SVN to manage the team’s software development lifecycle including deriving product backlog items and conducting sprint review meetings.
• Actively involved in User Acceptance Test (UAT) for various end-users across the departments, to explain them the full functionalities of the SSRS Reports and Dashboards.
• Worked with high level end-users, communicating the progress and developments in a timely manner.

Environment: MS SQL Server 2012, MS Reporting Services 2012, MS Access, Microsoft Visual Studio 2012, SQL Server Integration Services 2012, Tortoise SVN, T-SQL, Micro QR Readers, Windows XP Professional, MS Excel 2013, Power Pivot, Power BI, Power View.

MSBI Developer

Confidential, Trenton, NJ

Responsibilities:

• Integrated ceding companies claim data, from heterogeneous data sources (flat file, csv) and legacy system (DB2, Access, Excel) into centralized data warehouse using SSIS.
• Created staging areas for data processing (cleansing, validation, audition) and transformation (aggregation, lookup, filter).
• Studied the existing OLTP systems and interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart.
• Used Master Data Service (MDS) to manage the usage of the data among different groups of similar data. We can organize the data into models, create rules for updating the data, and control who updates the data.
• Used open queries to fetch data from DB2 source systems.
• Used Bulk Binds and Records processing to improve the performance of processing.
• Created views, Indexed Views, Power pivot to support internal Reporting requirements and modified the existing reports based on End User Requirements.
• Used different kinds of SQL Joins to join more number of tables.
• Extracted data from Oracle, MS SQL databases to create Pivot tables need for the end users.
• Involved in Extraction, Transformation and Loading (ETL) of data in the data warehouse for DB2 database using Informatica and SSIS.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Participated in the migration of applications to quality assurance and the production environment.
• Performed necessary production support tasks involving on-call responsibilities both during and after work hours.
• Designed visualizations based on claims, frauds, on the health care insurance policies to get an idea about the people who are trying to get the claims from the company.
• Involved in User Acceptance Training (UAT) with user to create reports using Report Builder tool.
• Generated reports using Global Variables, Expressions and Functions for the reports.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
• Used Microsoft Team Foundation Server (TFS) to manage the team’s software development lifecycle including deriving product backlog items and conducting sprint review meetings.

Environment: MS SQL Server 2012, MS Reporting Server, Report Builder, Microsoft Visual Studio 2012, SQL Integration Services 2012, T- SQL, Windows XP Professional, MS Excel.

SQL Developer

Confidential, Santa Clara, CA

Responsibilities:

• Worked on the Reports module of the project as a developer on MS SQL Server 2008 R2 (using SSRS, T-SQL, scripts, stored procedures and views).
• Filtered and cleansed bad data from legacy system using complex Transact - SQL statements in staging area, and implemented various constraints for data consistency.
• Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Build cubes using SSAS and created reports from Analysis Services using MDX query designer.
• Involved in storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
• Provide analytical support of global supply chain management strategies, goals, and objectives Serve for various projects and reports and collect and analyze information using SQL Query tools, and make recommendations to the team.
• Extensively used BI tools like integration service, Reporting Services and Analysis services in MS SQL Server.
• Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through reports, Tabular, Matrix, etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Used various SSIS transformations like Conditional Split, Multicast, Fuzzy look up etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into Data warehouse.
• Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Line Charts, Pivot Tables in Excel and Tableau.
• Created cubes with Start schema in SSAS and developed SSRS report based on the cubes.
• Used performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Environment: SQL Server 2008 R2, T-SQL, Excel, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SVN version controlling, Tableau.