SUMMARY

• Over 10+ years of Business Intelligence Analyst experience with expertise in MS SQL Server versions 2012/2014/2016 and MSBI suites SSAS, SSIS, and SSRS.
• Hands on experience working with other databases; Snowflake, Oracle Database 12C, AWS /Azure Cloud
• 4 years of hands - on experience with Power BI.
• ProvenPower BI development experiencewith desktop, Servers, and SaaS versions. Familiarity with Direct Query functionality within Power BI and performance tuning using performance analyzer.
• Worked on thePower Bi reports&dashboardswith SQL Server/Tabular SSAS sources
• Experience in working with agile methodology involving in Analysis, Design, Development, testing and deployment of MSBI solutions to the project and played key role in Agile team including participating in job sprints on SCRUM based projects.
• Expertise in building Power BI reports utilizing complex calculated fields, table calculations, filters, parameters, and Excel depending on the requirement by using DAX queries and publishing them on dashboards in Power BI Server in visualized form like Bar Chart, Pie Chart etc.
• Solid analytical, critical thinking and problem-solving skills to effectively resolve complex situations and issues
• Managed relationship between tables in Power BI using star schema and worked with both live and import data into Power BI for creating reports.
• Worked on POC to migrate existing on-premise BI platform to Azure Cloud.
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Data Factory in-order to load the data from on premise to Azure Data Lake.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, Functions (UDF), cursors, and triggers, locking issues, Bulk Insert, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER 2012/2014/2016.
• Expertise in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using Import Export Wizard, BCP, Bulk Insert utilities and DTS-SQL Server SSIS 2012/2014/2016.
• Expertise in Understanding the Technical Specifications, identifying defects and working on resolutions, modifying the SSIS packages according to the business change requests.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Configured Check Points, Break points, Event Handlers and Logging to the SSIS packages.
• Experience in developing OLAP Cubes by using SSAS, and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.
• Implemented complex query techniques of passing multi valued parameters and cascading parameters in MDX.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SSRS.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Adept in analyzing bugs, interacting with team members in fixing errors and doing UAT and assisted in Post - Production support.
• Experience in working with Database Architecture for Design and Development of Data models and warehouse includes Normalization, Performance Tuning, Development Life Cycle source control, ticketing systems and Version Control tools.

TECHNICAL SKILLS

Database Technologies: SQL Server 2016, Oracle 10g SQL, PLSQL, Oracle 11g/12c, Azure Cosmos DB, Azure Data Lake, Data Bricks, Azure SQL Server, CDS (Common Data Service)

Programming Languages: MySQL, SQL, Confidential -SQL, HTML, HTML5, CSS, XML, C#, Python

Business Intelligence Tools: MSBI (SSIS, SSRS & SSAS), Metadata, Power Apps

IDEs /Tools: MS Visual Studio 2016, SSMS

Other Tools: MS Office Suite (Word, PowerPoint, Visio), OLAP, OLTP, TFS, JIRA. MS Dynamics 365, ERWIN, Informatica

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Tableau Prep, Power Qwery

Reporting Tools: SSRS 2016, Tableau, Power BI, Crystal Reporting, Webi Reporting, Microsoft Access, Excel.

Automation Tools: UiPath

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, California

Sr. Power BI Developer /MSBI Developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in Power BI reports to support organizations strategic decisions.
• Developed Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight.
• Wrote DAX for creating calculated columns, measures, and custom tables.
• Enhanced existing reports by reviewing performance of measures, relationships, visuals, and cardinality level.
• Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.
• Created views, triggers, user defined functions to in corporate the flow of business and automated stored procedures.
• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements.
• Built and monitored indexes to bring down processing times from minutes to seconds.
• Improved SQL Queries to optimize the performance of a procedure from 5 minutes to 60 seconds.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created SSIS packages to extract, transfer and load data into the data warehouse on the daily basis.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make the package environment independent.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, Amazon Athena, SSAS Cube.
• Applied in-depth analysis before choosing between Direct Query and Import method.
• Worked extensively with SQL/Oracle DB on AWS/Azure cloud environment.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Donut Chart, Tree map etc. in Power BI.
• Created various reports in SSRS (Visual Studio version 2015) such as Cost Plus and supplement reports for Finance Department
• Wrote extensive Confidential SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for SSRS Report
• Extensively involved in Unit and UAT during the deployment of SSRS report.
• Loaded files from Tumbleweed to the SQL Database and modified and deployed SSIS package to suit to the business requirements.
• Building the pipelines to copy the data from source to destination in Azure data factory (ADF V1)
• Worked on creating dependencies of activities in Azure Data factory.
• Creating stored procedure and scheduled them in Azure Data factory.
• Creating Data factory in Azure Data factory.
• Worked on POC to migrate existing on-premises BI platform to Azure Cloud.
• Worked on Azure cloud in spinning of new resources under resource group.
• Worked on Azure Data factory to load the data from on premise to Azure Data Lake.
• Transforming Data In Azure Data Factory with the ADF Transformation
• Strong development skills with Azure Data Lake, Azure Data factory, SQL Data warehouse Azure Blob, Azure storage Explorer.
• Creating multiple data sets in Azure worked in migration of SQL Server 2008/2012/2014 to SQL Server 2016.
• Migrating the data from different Sources to the Destination with the help of ADF V1.
• Implemented Copy Activity, Custom Azure Data Factory Pipeline Activity For On Cloud ETL Processing.
• Scheduled jobs in Flows and ADF Pipelines.
• Moving CSV files from Azure blob to Azure SQL Server.
• Configured Integration Runtime (IR) to move the data from on premise to cloud.
• Worked on PowerShell scripts to automate the creation of resources and resource group.

Confidential, Dallas, Texas

Power BI Data Analyst //MSBI Developer

Responsibilities:

• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Secured the Power BI reports using Row Level Security (RLS) and DAX filters
• Created new calculations and KPI such as average life of products, profit margins utilizing DAX in SSAS
• Created views, triggers, user defined functions to in corporate the flow of business and automated stored procedures.
• Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements.
• Built and monitored indexes to bring down processing times from minutes to seconds.
• Improved SQL Queries to optimize the performance of a procedure from 5 minutes to 60 seconds.
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created SSIS packages to extract, transfer and load data into the data warehouse on the daily basis. Deployed SSIS Package into Production and used Package configuration to export various package properties to make the package environment independent.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, Amazon Athena, SSAS Cube.
• Continuously analyze existing KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps
• Worked with the business to develop a formal business glossary, defining metrics and KPI's, Customer reporting feedback, Functional KPI performance, Exec KPI performance and SDM performance KPI.
• Designed and implemented a prototype SQL Server DB, SSIS, and Power BI solution to report descriptive statistics of telemetry usage data for client’s SaaS cloud platform
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS)
• Built a Tabular Model cube from scratch data.
• Created relationships between tables inPower BIusingStar and Snowflakeschemas.
• Fetched data from Snowflake data warehouse and performed ETL on the platform
• Built Measures in tabular model using DAX queries and created partitions in tabular model.
• Designed and developed the SSIS Packages, to process the collection of data from sources like SQL Server 2014, Salesforce. Teradata, MS Excel, Flat files etc. and configured and scheduled to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards
• Responsible for designing and prototyping, testing, training, defining support procedures, and implementing practical business solutions
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Configured Integration Runtime (IR) in order to move the data from on premise to cloud.
• Worked on power shell scripts to automate the creation of resources and resource group.
• Experience working with Azure Data warehouse, created TSQL code to use polybase external tables in order to load data from ADL to ADW
• Performed database backup and deployment to the production server.
• Involved in modifying existing Data Stage Jobs for better performance.
• Created detailed technical documentation of various staging area operations for future reference and guidance.
• Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.

Confidential, San Jose, CA

Business Analyst

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Responsibility in developing SSAS Tabular (Star, Snowflake) and Multi - Dimensional cubes based on the client requirements.
• Agile methodology was used throughout the project, performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Performed complex SQL queries, triggers and stored procedures, views and user defined function and update database statistics.
• Experience in writing complexSQL queriesinvolving multiple tables with inner and outer joins, stored procedures
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS. Also prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Integrated data from SQL Server Parallel Data Warehouse (PDW) with data from Hadoop
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
• Wrote complex SQL/MySQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed reports on Report Server and SharePoint Server and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2014 Reporting Services (SSRS).
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2014 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed Monthly, Quarterly and Yearly reports Confidential branch and company level.
• Involved in table and for indexpartitioning performance and Manageability.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Confidential

Business Analyst

Responsibilities:

• All phases of the Project Development from requirements gathering (Functional and Database), Testing (System and UAT) for new projects and existing projects.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.
• Database maintenance, checking the database for any flaws and cleaning the database and help maintaining the correct data
• Identified requirements of data Projects, including defining the Database requirements, defining table structure, database relationships
• Closely worked with Business users in gathering requirements, acceptance criteria and helped business users in setting up environment for UAT testing
• Actively Presented biweekly Sprint Demonstration and Sprint Planning meetings
• Expertise in maintaining Agile tools like JIRA, RALLY and making sure the user stories move
• Closely working with Team members, and leading them in Sprint Planning and efficiently breaking the epics to user story level and assigning to developers based on skill set.
• Designed business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
• Wrote SQL queries and SQL Procedures in Oracle, SQL Server.
• Conducted JAD (Joint Application Development) sessions for requirements gathering and review.
• Provided status update of the project to the management team
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Used MS Visio for Process modeling and Business Process flow diagrams.