SUMMARY

• Dedicated and highly accomplished Business Intelligence professional with 7+ years of experience and proven expertise in data warehousing and business intelligence tools, Tableau, Power BI, MSBI (SSRS, SSAS, and SSIS), and Azure Data tools such as Azure Storage accounts, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Database and Azure Analysis Services. Prowess for generating actionable insights and solving complex challenges. Known for strong critical thinking and analytical skills as well as ability to complete projects accurately, on time and within budget.
• Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, and Azure Synapse Analytics and Controlling and granting database access and Migrating on - premise databases to Azure cloud using Azure Data factory and Databricks.
• Experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS), DAX, OLAP Cubes, Star Schema and Snowflake Schema .
• Strong experience with T-SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Expertise in creating Dashboards, Scorecards, drill down reports, Standard reports, Views, Pivot tables, Charts for Data analysis using Power BI, Tableau 8.x/9.x/10.x and SSRS.
• Served as Power BI admin and performed key operations like scheduled refresh, creating Power Apps, workspace management, maintaining Azure security groups, and user role assignment.
• Worked extensively on Tableau desktop and server to design, create, and maintain reports and dashboards that monitor performance measurement, scorecards, and KPIs.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Generated reports and visualizations by connecting to various data sources (SAP HANA, MS SQL Server, Snowflake, DB2, Teradata, MS Access, Share Point, Excel, CSV).
• Expertise in using Common Data Service entities creation and using in Power BI desktop to create reports
• Insight statistical knowledge with p-value, A/B testing, UAT, hypothesis testing, linear regression and logistic regression.
• Experience in extracting data from data sources and transforming it using SQL and R.
• Followed SDLC methodologies in performance of all development activities, including design, development, test and quality assurance support.
• Outstanding communication, presentation, problem-solving & relationship-management skills.
• Team player with good logical reasoning ability, coordination and able to complete projects independently.
• Prowess in generating actionable insights, comprehensive professional skills on solving complex challenges.

TECHNICAL SKILLS

Cloud Technologies: Azure Data Factory, Databricks, Synapse Analytics, Azure Data Lake Storage, SQL Database, Azure Analysis Services, Azure Storage Account, Blob Storage

Tools: and Packages: SQL Server Management studio, Visual Studio, Enterprise Manager, SQL Profiler, SQL Server Data Tools, DTS, Report Builder

Reporting Tools: Power BI, Tableau, SSRS, SAP BO, Excel

Database Technologies: SQL Server, SAP HANA, Snowflake, Common Data Service, DB2, MS Access, Teradata

ETL Tools: SSIS, SSAS, Tableau Prep

Scripting: SQL, Python, VB, TSQL, R

Testing: HP ALM, Octane

Other Tools: JMP, Minitab, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Manage BI Strategy, including data sourcing, acquisition, integration, as well as all activities related to analytics and reporting.
• Created Pipelines in ADF using Linked Services / Datasets / Pipeline / to Extract, Transform and load data from different sources like SAP HANA, Blob storage, Azure SQL Database, write-back tool and backwards.
• Created Data ingestion methods using SAP BODS to load data from SAP CRM and SAP ECC into SAP HANA.
• Developed Spark applications using Spark - SQL in Databricks for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.
• Migrated some of the systems from SAP HANA to Snowflake hosted on Azure cloud using ADF, Blob, and Databricks.
• Built numerous technology demonstrators using Confidential Edison Arduino shield using Azure EventHub and Stream Analytics, integrated with Power BI and Azure ML to demonstrate the capabilities of Azure Stream Analytics.
• Designed and implemented migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools).
• Deployed and tested (CI/CD) our developed code using Visual Studio Team Services (VSTS).
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Developed reports using the data imported in the local Power BI environment for Finance, Sales, Warehouse, Supply chain, Delivery Execution, Production, and Fleet departments.
• Worked on Common data service, stored and managed data that's used by business applications and created entities and entity relationships.
• Trained over 100 end users across 10 departments on how to use created Power BI reports and interact with the reports in Power BI service as well as in mobile app.
• Provided analytical insights using Power BI reports which helped business in saving $1 Million in a year in the fleet and delivery departments by tracking breakage and damaged products.

Confidential, Richmond, VA

BI Developer

Responsibilities:

• Developed ADF pipelines to automate ETL activities and migrate SQL server data to Azure SQL database.
• Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa.
• Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse. Made the package dynamic so it fit the environment.
• Developed schemas for business applications with providing full-life cycle architectural guidance and ensured quality technical deliverables.
• Managed a project moving monthly balanced scorecard and KPI metrics into Power BI, saving team 40 hours/month in workload.
• Developed data profiling, munging and missing value imputation scripts in Python on raw data as a part of understanding the data and its structuring.
• Manage team of analysts responsible for executing business reporting functions, performing analysis and drive operational metrics.
• Formulated the strategy, development and implementation of executive and line of business dashboards through Power BI.
• Managed internal Sprints, release schedules, and milestones through JIRA. Functioned as the primary point of contact for the client Business Analysts, Directors and Data Engineers for project communications.
• Conducted analysis on labor metrics, and identified critical issues like excessive overtime, absenteeism, ineffective scheduling, and proposed solutions to improve temporary labor utilization.

Confidential, Confidential, OH

Programmer Analyst

Responsibilities:

• Extensively utilized SSIS packages to create complete ETL process and load data into database which was to be used by Reporting Services.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to SQL tables.
• Created Azure Data Factory pipelines based on existing SSIS packages to automate ETL processes.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel.
• Provided in-depth analysis that involves compiling and analyzing large data sets using statistical methods and optimization modeling tools and presenting the results in a detailed format using Tableau, that drives management decision making.
• Created new forecasting model that consolidated different markets leading to quicker, more dynamic forecasts and greater efficiencies; Dealt with time series data (decomposition, forecasting).
• From analyzing sales and inventory data, decreased warehouse costs by 35% by eliminating dead inventory.

Confidential

Business Intelligence Analyst

Responsibilities:

• Built Reports with MS SQL Server Reporting Services 2012 (SSRS) implementing tabular, matrix (crosstabs), bar and line charts, spark charts, and multi-tiered drilldowns as well as advanced formatting such as data driven color coding, visibility, and both fixed and movable headers.
• Successfully developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from SQL statements.
• Developed complex T-SQL queries and stored procedures for the purposes of moving and maintaining data and to run reports based on MS SQL Server 2012.
• Designed and developed advanced table partitioning and partition swapping systems for rapid maintenance of very large tables and to improve query performance on same.
• Built ad hoc reports such as an analysis grid with the capability to drill down at a hierarchical level and functions as print and download.
• Developed SQL queries to aggregate data such as profit margin, cost per sales, revenue per Sales.
• Worked with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use.
• Tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update or delete.

Confidential

Jr. Data Analyst

Responsibilities:

• Responsible for gathering requirements from stakeholders and operational analysts and identifying the required data sources for the requests.
• Developing reports, maintaining report definitions, maintaining report manager portal using SQL Server Reporting Services (SSRS).
• Developing and maintaining OLAP cubes using SQL Server Analysis Services (SSAS).
• Developing ETL packages using SQL Server Integration Services (SSIS) and bulk-loading utilities.
• Extracted, analyzed and presented in graphical format using Excel, such a way that stakeholders can make key decisions.
• Reduced overall stocking locations by more than 10% by redesigning the strategic sourcing network.
• Optimized inventory by developing new safety stock methods designed to reduce excess by 15% with no effect on service levels.
• Identified critical data collection points and made sure that the data is accurate and created SOP (Standard Operating Procedures for data collection).

SQL BI Developer

Confidential

Responsibilities:

• Designed and created new data warehouse for new reporting systems as per the industry best practices using star schema.
• Experience in MOLAP (Multidimensional Cube) and ROLAP (RDBMS) to develop customized reports in MS SQL Server database.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Developed scripts to load data into Power BI and worked with multiple data connections including Access, SQL Server, and SAP HANA.
• Organized and led meetings with business stakeholders to clarify and document reporting requirements.
• Created calculation views using HANA SQL and GUI from SAP tables and existing views as per reporting needs.
• Used custom SQL to import the data into Power BI from SAP HANA views and live connection in Power BI.
• Performed data transformation operations in the query editor for data cleansing and other transformations.
• Developed reports using the data imported in the local Power BI environment for Finance, Sales, Warehouse, Supply chain, Delivery Execution, Production, and Fleet departments.
• Worked on Common data service, stored and managed data that's used by business applications and created entities and entity relationships.
• Created custom organization owned entities and maintained metadata.
• Worked on fields, global option sets and created and applied business logic for entities. Created power bi reports using common data service entities.
• Involved and represented my company in weekly shared bottler BI production support, BI bottler and team meetings along with the other bottlers.
• Created new Power BI reports based on existing Analysis for Office reports and performed Ad-HOC reporting on daily basis to meet the business user demands.
• Documented the dashboard needs, critical success factors of the business, related KPIs and the designs.
• Participated in the COSMOS DB and Azure Data Warehouse Proof of Concept processes.
• Completed several huge data extracts and performed ETL operations for an internal project.

BI Developer

Confidential

Responsibilities:

• Developed highly optimized stored procedures, functions, and database views to implement the business logics and created clustered and non-clustered indexes.
• Worked with Data definition language (DDL) and Data Manipulation Language (DML) queries for defining data structures.
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated, and worked with Script Task to perform a custom code.
• Designed, deployed and maintained complex canned reports using SQL Server 2013 Reporting Services (SSRS) and PowerPivot.
• Created complex SSIS/ETL packages to load data from various heterogeneous sources to the database and transformed the data accordingly to fit into the current reporting system.
• Designed incremental daily loaded for large and small data warehouses, data marts as per the reporting requirement.
• Collaborated with internal partners and organizations in the design, testing, development, and maintenance of business intelligence and reporting solutions to support business needs with a specific focus on Power BI.
• Developed, validated and executed complex data sourcing and transformation, developed advanced reports and dashboards using SQL, VB, SSIS, and Power BI.
• Implemented advanced Power BI functionalities and features including Power BI server, data gateway, row level security, etc.
• Worked on large data sets from multiple data sources and applied data warehousing techniques to act as a single source point.
• Performed complex data analysis that answers business questions for internal customers; interpreted results and made recommendations to business areas based on findings.
• Developed project plans and timelines; responsible for project commitments to quality and on-time deliverables.
• Evaluated data needs of assigned projects, assured data integrity and suitability, and determined data collection methods, metrics definitions.
• Performed troubleshooting for technical details/ issues with the reporting solutions.
• Acted as a mentor to other analysts, trained stakeholders on the Power BI reports created.
• Drive weekly Operations meeting and provide insights from analyzed data, to drive several KPI’s for business.
• Reviewed trends in data sets, used SQL query operations to filter the data to understand the opportunities for clients.

SQL Developer

Confidential

Responsibilities:

• Designed Contract Retention database using SQL Server 2008 technology.
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Developed data mapping documentation to establish relationships between source and target tables including transformation processes
• Developed and implemented SSIS 2008 ETL processes to load data from source files to target table
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated, and worked with Script Task to perform a custom code.
• Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
• Provided in-depth analysis that involves compiling and analyzing large data sets using statistical methods and optimization modeling tools and presenting the results in a detailed format using Tableau, that drives management decision making.
• Support the manufacturing leadership team in prioritizing & resolving current manufacturing issues.
• Utilized T-SQL to pull data from various databases and created various dashboards, scorecards and reports to support loan business decision making.
• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using Tableau.
• Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts, Data Extracts build-in Excel.
• Built daily, weekly, monthly graphs and charts of loan data using R and Stored Procedures.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
• Created new forecasting model that consolidated different markets leading to quicker, more dynamic forecasts and greater efficiencies; Dealt with time series data (decomposition, forecasting).
• From analyzing sales and inventory data, decreased warehouse costs by 35% by eliminating dead inventory.