SUMMARY

• Over 5 years of experience in developing BI applications utilizing SQL server, MSBI stack, and Power BI.
• Strong technical knowledge inSQL Server BI suite (Reporting, Analytics, Dashboards) using SSRS, SSAS and SSIS.
• Extensive experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Developed analytical reports/dashboards from dimensional modelsto identify critical KPIs utilizing Power BI.
• Gained experience in developing parameterized, drill down, drill through, chart, matrix, ad - hoc, and sub-reports utilizing SSRS.
• Proficient in makingDAX queries in Power BI desktop .
• Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
• Experience in extracting data from data sources and transforming it using SQL and R.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc.
• Developed tabular and multidimensional models that are compatible with warehouse standards.
• Experienced in designing and developing SSRS reports using data from ETL loads, SSAS cubes and various heterogeneous data sources.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
• Excellent in analytical thinking for translating data into informative visuals and reports using POWER BI.
• Outstanding communication, presentation, problem-solving & relationship-management skills.
• Proven ability to work well in a multi-disciplined team environment and adopt at learning new tools and processes with ease.

TECHNICAL SKILLS

Database: MS SQL Server 2016, 2012, 2008/R2, My SQL, Oracle

Programming: SQL, Python, T-SQL, R, VB

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Power BI, Excel

Operating Systems: Windows Vista/XP/7/10, Linux, Mac

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Excel), OLAP&OLTP

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Power BI Developer

Responsibilities:

• Understanding the end-to-end scope of work and design architectural solutions accordingly.
• Gathered business requirements and articulated project scope and expectations, by working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models for the Revenue Growth management (RGM).
• Design and implementation of database models, data flow diagrams, database schemas, db scripts, structures, and data standards to support a robust data management infrastructure.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Enforced naming standards and data dictionary for data models.
• Integrate all data in the data management platform enabling accessibility.
• Design, and implement application database code objects, such as stored procedures and views.
• Using SQL to query Databases Performing various validations and mapping activities.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Validated accuracy of data to ensure database integrity.
• Implemented advanced Power BI functionalities and features including Power BI server, data gateway, row level security, and IAM.
• Used query editor for data cleansing and data transformations.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using SSAS and produced ad-hoc, standard and super user reports usingSSRS.
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS)
• Retrieved data from data warehouse and generated a series of meaningful business reports usingSSRS.
• Validated and tested reports, then published the reports to the report server.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Environment: Power BI, SSIS, SSRS, SQL, Power Pivot, SQL Server 2013, VB

Confidential, St. Petersburg, FL

Power BI Developer

Responsibilities:

• Created, updated, and maintained reports and dashboards in Power BI.
• Created Power Bl datasets, reports, and dashboards to meet business requirements.
• Implemented Power BI Embedded reports and dashboards into our organizational portal for external users to access the reports and dashboards.
• Implemented Row Level Security (RLS) for the Power BI Embedded reports.
• Configured and managed Embed Premium Capacity in the Power BI service to share the reports to the external users.
• Published PowerBIDesktop reports created in Report view to thePowerBIservice.
• Administered and maintained the data refreshes for the reports and provided user access to the reports.
• Created several DAX functions for various calculations for efficient data visualization in Power BI.
• Developed complex calculated measures using Data Analysis Expression language.
• Created reporting mock-ups and prototypes.
• Created tables, views, and stored procedures as data source for the Power BI reports and dashboards as per Business requirements.
• Responsible for gathering requirements by interviewing the users for developing reports and dashboards for business analysis.
• Optimized the performance of the reports using performance analyzer in the Power BI Desktop.
• Created performance tuning methods on report level metrics using DAX studio.
• Identified the data source and defining them to build the data source views.
• Updated and maintained the existing Power BI reports and dashboards.

Environment: Power BI Desktop, Microsoft Azure, MS SQL Server 2018, Microsoft Visual Studio, Power BI Service,Power Pivot, MS Excel, DAX Studio.

Confidential

SQL BI Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Created Database objects - tables, views, and functions.
• Rebuilt Indexes and Tables as part of performance tuning exercise.
• Successfully implemented physical database design in SQL Server 2008R2.
• Wrote Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Evaluated database population routines (ETL) and ensure quality of production load processes.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Wrote T-SQL queries using inner join, outer join, and self joins, merge join and implemented functionality for removing duplicate records like using CTE and ranking function.
• Worked collaboratively with DBA to Improve Performance of the database by creating Stored Procedures, Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server.
• Worked on Huge Data Transfers from and to SQL Server Databases using SSIS and used Configuration Files and Environment Variables for production deployment.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to load data into SQL Server using various transformations in SSIS.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created Sub-reports, Parameterized and Drill-through, Drill-down reports, Matrix reports and Summary reports in SSRS.

Environment: MS SQL Server 2008/2008R2, SSIS/SSRS, Query Analyzer, T-SQL, Windows Server 2008R2, SharePoint server, DTS Designer, Visual Source Safe, Microsoft Visio 2007, SQL Profiler, MS Excel 2010, MS Word 2010, Powerpoint 2010.

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).