SUMMARY

• Dynamic career of over 10+ year’s that reflects pioneering experience & year - on-year success in Business Intelligence.
• Enterprising leader with a strong record of evaluating information gathered from multiple sources, decomposing higher information into details, investigating key business requirements and providing clear & concise analysis.
• Worked in all phases of BW/BI full life cycles including analysis, Design, Development, Administration, post-production support, Implementation, documentation, and end-user training.
• Worked as Subject Matter Expert (SME).
• Extensive experience in implementing ETL, Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, and Azure Data bricks, Azure Analysis Services, SQLServer Integration Services, SQL Server Reporting Services and Tableau.
• Used Enterprise Edition/Parallel stages like Datasets, Change Data Capture, Row Generator, many other stages in accomplishing the ETL Coding.
• Good hands on Azure Data Factory
• Around 5 years of IT experience as on Azure Cloud . Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory
• Responsible for creating SQL datasets forPowerBIand Ad-hoc reports and expert on creating multiple kind ofPowerBIReports and Dashboards.
• Mastering/Leading in the development of applications/tools usingPython.
• Deployed web parts and features asSolution PackagesusingPower Shellcommands tool at different levels includingsite collections,web applicationsand at eachsite level.
• Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the difference user groups in the organization.
• Expertise in writing complex DAX Queries and Expressions in Power BI and Power Pivot.
• Skilled in development of complex & large-scale business applications that save time, eliminate redundancies and improve quality.
• Hands-on experience in Tableau (Administration & Development), MS Business Intelligence Tools (SSIS, SSRS & SSAS), Oracle Business Intelligence (Developer), MS SQL Server, Teradata, IBM & Oracle Database.
• Well versed with all types of BI Reporting Tools like Power BI, Tableau, and BO.
• Involved in importing the data from various source systems and create the rich dashboards using Power BI.
• Expert in creating dashboards visualizations in Blank Canvas to user friendly reports.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Involved in trouble shooting of performance issues which were associated with Tableau reports in server.
• Quick leaner with excellent communication, analytical & relationship management skills; well organized with a record that demonstrates self-motivation & creativity to achieve corporate & personal goals.

TECHNICAL SKILLS

• Power BI
• Tableau
• ETL
• SQL
• SSIS
• SSRS
• Data Modelling

PROFESSIONAL EXPERIENCE

Sr. Power BI/MSBI Lead Developer

Confidential, Austin, TX

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling usingPower BI.
• Created data bricks notebooks using Python (PySpark) and Spark SQL for transforming the data that is stored in Azure Data Lake stored Gen2 from Raw to Stage and Curated zones.
• Involved in developing the end to end ELT pipelines for migrating the on-premises Oracle database to Azure SQL Data warehouse.
• Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups like sales, operations and finance team needs.
• Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the Power BI dashboards.
• Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure and scheduling the cube through Azure Automation Runbook
• Support and resolve any issues that occur with SSRS and SSIS packages that run daily.
• Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
• Hands On experience in developing ETL DTS Packages and SSIS Packages for integrating data using OLEDB connection from various sources like excel, csv, Flat file by using multiple transformations provided by SSIS Packages.
• Worked on various tasks and transformations in SSIS likeExecute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Monitored and scheduled daily backup jobs for SharePoint Farm and databases using SQL Management Studio and PowerShell.
• Used WindowsPowerShellto deploy, backup, restore and number of out of the box command lets.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Managed administrator approvedSandbox Solutionform templates by using central admin andPowerShell.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, and line better business analysis.
• Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.
• Involved in creating the external and internal tables in Azure SQL Data Warehouse and created stored procedures to move the data from external to internal tables.
• Involved in performance tuning of Azure SQL Data Warehouse by detecting the data skew problems by creating the right distribution for each of the dimension and fact tables.
• Orchestrate daily scrum, review, and sprint planning
• Use JIRA to keep track of user stories and sprints
• Make sure to sustain team velocity and have an ideal burndown chart
• Have weekly meetings with business product owner to gather requirements for creating user stories
• Sprint planning is aligned with the vision of the stakeholders
• Road map is constantly updated according to stakeholders’/ Business’s expectation
• Provide leadership and direction across the Configuration management, Integrations, incident management and Support issues.

Sr. SQL-Power BI Report Developer

Confidential

Responsibilities:

• Installed and setup Azure/Power BI environment in the organization.
• Expertized in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.
• Developed ETL processes involving migrations and in sync processes between two databases.
• Used various sources to pull data into Power BI such as SQL Server, Oracle.
• Worked in the Mayor’s Dashboard team, gathered requirements from the Mayors staff and Cabinet chiefs.
• Mentored and Trained team members to create reports/dashboards using Power BI.
• Implanted custom solution deployment strategy and scripted automated deployment PowerShell scripts.
• UsedPowerShellto backup and restore the SP farms.
• Worked on understanding the existing reports in SAP BO and migrated them to Power BI.
• Worked in Creating DAX Expressions and implement Partitions in Tabular models
• Serviced and maintained the Power BI servers by taking up timely backups and disk clean ups using batch scripts.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily and used all types of transformations that are available in Power BI query editor.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Created a visualization reports in Power BI such as bar charts, line charts, area charts, combo charts, donutcharts, scatter plot to analyze the percentage of patients for different criteria’s.
• Determined calculations (measures) to generate new fields in Power BI reports with Data Analysis Expressions (DAX) formulas.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Used Python and VB scripts to ETL data from various data sources to SQL Server and AWS cloud services.
• Leveraged the power of visualization by making them interactive by using drill down, drill through, filters, slicers.
• Skilled in SSISerror and event handling: precedence Constraints, Break Points, Check points and Logging.
• Implemented various SSIS data transformation tasks like Lookups, Fuzzy Lookup, Merge Join, Conditional Splits and Event Handlers, Error Handlers, etc.
• Responsible for installation/Upgradation of Azure server in the organization
• Partnered with Power BI technical support team, to resolve complex problems that required escalation. Provided detailed descriptions of issues in trouble ticket system and followed up diligently to ensure swift resolutions.

SQL/MSBI/Power BI Developer

Confidential

Responsibilities:

• Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server.
• Perform Data Profiling, Data pipelining, and Data Mining, validating and analyzing data (Exploratory analysis / Statistical analysis) and generate reports.
• Automated SSIS Execution using Windows Scheduler using DTExec Command.
• Created logging, custom logging and error handling packages.
• Grouping, aggregating, and splitting data using SSIS.
• Scripting using SSIS for data cleansing, encrypting, decrypting sensitive information.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Conducted Data Migration processes in the SQL Server environment using SQL Server Integration Services 2016.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed C# scripting for packages.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Design and develop logical and physical data models that utilize concepts such as Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Tableau according to the requirements.
• Published Tableau Reports in the required originations and Made Tableau Dashboards available in Web clients and mobile apps.
• Created Dashboard and the Content Pack for the originations to get the updated Tableau Reports and added the refresh time for each view in the dashboard.
• Built Ad - Hoc reports in Tableau depending on business requirements was one of the major responsibilities.
• Create reports in Tableau preview portal utilizing the SSAS Tabular Model via Analysis connector.
• Created many Complex Query’s and used them in Tableau Reports directly to generate reports on the fly.
• Worked on TFS for performing tasks.
• Used GitHub for code repository.

Business Data Analyst

Confidential

Responsibilities:

• Gathering requirements from clients and convert to user stories for the internal teams.
• Highly analytical and process-oriented data analystwith in-depth knowledge of database.
• Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.
• Developed Key Performance Indicators to monitor sales and decreased costs
• Spearheaded data flow improvement.
• Successfully interpreted data in order to draw conclusions for managerial action and strategy.
• Used statistical techniques for hypothesis testing to validate data and interpretations
• Presented data and conclusions to team in order to improve strategies and operations.
• Proposed solutions to improve system efficiencies and reduce total expenses.
• Manage the planning and development of design and procedures for metrics reports
• Develop new reports and delegate tasks to team members
• Perform market analysis to efficiently achieve objectives, increasing sales
• Investigate and conduct studies on the forecasts, demand, and capital of products
• Optimized data collection procedures and generated reports on a weekly, monthly, and quarterly basis
• Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.