SUMMARY

• Highly motivated Power BI developer and Data Analyst with around 5+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Confidential - managed data centers.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Expert in Data Preparation, Data Modeling and Data Blending.
• Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation
• Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Confidential SQL Server
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• Proficient in integrating Confidential Flow, Power BI and Power Apps for end to end BI solutions on client requirements.

TECHNICAL SKILLS

Languages: Transact SQL, DAX,HTML, Python.

Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access

Analysis/Reporting tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Power BI.

ETL Tools: DTS, SSIS, Data Stage

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Other Tools: Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Power BI Developer

Responsibilities:

• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.
• Developed Reports for Surface and Xbox organizations, worked on multiple projects with multiple stakeholders across the board.
• Developed reports for special projects like Surface NEO, Surface DUO which were recently introduced for the summer 2020 launch.
• Automated processes for reporting and analytics using Confidential Flow.
• Cut down many manual processes with the help of Confidential flow using the API’s available for various scopes.
• Established TFS 2 SQL syncs and built the pipeline infrastructure to retrieve the AZDO data into on-prem SQL databases.
• Implemented Row Level Security across various reports based on the project tenting.
• Created PBI reports to monitor gateway health, workspace health and created alerting system for analytics team.
• Developed a refresh reliability report for all the datasets under my scope.
• Involved in designing and publishing visually rich and intuitive PowerBI dashboards for executive decision making.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Implemented projects using Agile Methodology.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
• Enabled Power BI refresh by embedding power app in the report, with which a user can refresh the dataset without having to be the dataset owner. This is done with the integration of Power BI-Power App and Flow.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Created alerts over sensitive metrics build for many stakeholders based on the data.
• Built a Data hygiene metric for each report, which alerts the owner of the data source to keep the data clean for the analytics teams to consume for reporting.
• Currently ramping up on Kusto query language and R.
• Played a crucial role in refactoring allXbox reports when migrated from on prem to cloud factoring in schema changes.

Environment: MS SQL Server, SQL Server reporting services, MS SQL Server 2016T-SQL, DAX, SQL Server, PowerBI Desktop,MDX, Confidential Visual Studio 2014, Excel, Azure, SSMS.

Confidential

Power BI Developer

Responsibilities:

• Developed various healthcare metrics and helped the senior management take effective decisions.
• Generated SQL scripts based on the requirements from stakeholders and retrieved it for front end visualization.
• Created a model which integrates Power BI, Power Apps, Share point, Azure Data factory into a single working model.
• Developed documentation for reporting for various processes with prior reporting experience.
• Developed various insights over complex raw data for the management and stakeholders.
• Helped setup the sync’s between cloud and on prem data sources.
• Implemented Row Level Security across various reports based on the project tenting.
• Created gateway monitoring by capturing the logs and created an alerting the system for the reporting Dev’s.
• Spun up a new DB’s, established a sync with TFS, created SSRS reports for every new project created.
• Involved in extensive use of T-SQL, created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Maintained tabular models and helped the stakeholders with updating the logic with code changes under the scope.
• Involved in developing solutions for complex health care data by using DAX.
• Implemented projects using Agile Methodology.
• Involved in database development using stored procedures, triggers, views and cursors.
• Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Created alerts over sensitive metrics build for many stakeholders based on the data.
• Successfully retrieved data from multiple data sources like Data Lake, Azure Analytics View.
• Setup communication pipeline between organization and the doctors under the company’s network.

Environment: MS SQL Server, SQL Server reporting services, MS SQL Server 2016T-SQL, DAX, SQL Server, Power BI Desktop, MDX, Confidential Visual Studio 2014, Excel, Azure, SSMS.

Confidential

Data Analyst

Responsibilities:

• Extensively used Excel and Tableau for the reporting in the organization.
• Developed Process Model for company’s operations in the data department.
• Designed and developed the company catalogue to various retail investors in the retail market.
• Retrieved data making API calls to make sure the company the executive management had up to date data.
• Helped in gathering the requirements from the clients and played a catalyst role in setting up the deal communication framework.
• Used Sales Force, Pitch Book, JIRA for various operations in the business.
• Implemented and maintaining a successful billing process to ensure timely and accurate billing monthly.
• Responsible for evaluating, configuring and testing customer claims.
• Leveraged MS Office stack for various operations in the firm.
• Review clinical data to promote timely, relevant, accurate and consistent information use.
• Process claims by reviewing and researching each claim based on medical benefit plan
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Developed and provided formal training and presentations/lectures to all new members on the team to ensuring they understand the data infrastructure, policy and business.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Managed inventory system to look out for coupon books.
• Used Visio to recreate the representations of various pipelines and dependencies in the firm using Visio.
• Extensively leveraged SharePoint to have version histories of various documents worked on by the team.
• Did market research and industry research to prepare the investment thesis for the company, through which the first round of funding secured $500k in 2015.

Environment: Agile methodology, MS Office, MS Visio, MS Project, MS SharePoint, UAT, SQL, MS Access, MS Excel, Operations, Testing, Funding, Research, SQL.