PROFILE

**+ years of extensive experience in Power BI developer/Data Analysis having multiple skill sets and extensive working experience in Business Intelligence Technologies with expertise in SQL Server Development, and Power BI for building, deploying, and managing applications.

Led the development of end-to-end Power BI reporting solutions for large clients including data modeling, dashboards, apps, content packs, SQL queries and ETL processing, workflow, and transformations

Hands-on experience in the medallion architecture process and aligning them in reporting and visualization.

Hands-on experience in Azure using Azure data factory, Azure DevOps, sparks notebooks through synapse and data bricks to complete medallion Lakehouse architecture.

Hands-on Experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2014/2016/2017/2019.

Excellent understanding of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling, and reporting tools.

Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, and common table expressions (CTEs) on Microsoft SQL Server.

Formed various measures and calculated columns utilizing DAX in Power BI to answer business questions. Performed time series analysis using DAX expressions in Power BI.

Excellent hands-on experience in groups, hierarchies and measures, KPIs, well versed in creating DAX (Data Analysis Expressions) functions in creating Power BI reports.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density chart

Created and managed workspaces, apps, dashboards, and packs for various business users across multiple tenants.

Build solution-driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Power BI Pro.

Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of them.

Shared dashboards and reports with user groups by using the Power BI App and content packs.

Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down charts, and tabular reports using Power BI.

TECHNICAL SKILLS

Programming Skills

C, Python (NumPy, Pandas, Sklearn, SciPy), R, Scala, JavaScript, XML, SQL, Machine Learning, PySpark

Tools

Tableau, Adobe Analytics Omniture, QlikView, Optimizely (A/B Testing), Microsoft Excel, PostgreSQL, Oracle SQL, MySQL, Power BI, Power BI Desktop, Power BI Service,SAP Hana, Kafka, Content Square, Jenkins, Kubernetes, MAKO-One Ribbon

Cloud Architecture

Amazon AWS, EC2, EC3. Lambda, Elastic Search, Elastic Load Balancing, Azure Data Lake, Data Factory, Azure Databricks, Azure SQL Database, Azure SQL Data Warehouse, Big Data, Hadoop, Hive, Oozie, Scoop

Frameworks

Django, Flask

IDE(s)

PyCharm, Eclipse, Android Studio, Spyder

Database

SQL Server, MySQL, Sybase, Oracle, MongoDB

Operating Systems

Linux, UNIX, VMware, Windows

Servers

Apache Tomcat, HP Server, WebLogic

PROFESSIONAL EXPERIENCE

Stryker CorporationSeptember 2021 - Current

Stryker Corporation,Allendale, NJ

Goal:The project goal is to transform the existing reports as well as new reports according to Quota Year by keeping all the current functionality.

Responsibilities:

Migrated reports from Teradata, Cognos, Web Intelligence, Desktop Intelligence, and Kirby reports into Power BI reports and performed ETL based on business requirements.

Experience with Azure SQL database migration process from different data sources and utilize them in power BI reports. Utilized medallion architecture to enhance the reporting experience for clients.

Worked on integration of medallion Lakehouse architecture and star schema design with an enterprise Power BI data model ensuring quality data through Lakehouse’s bronze, silver, and gold layers.

Managed and maintained the transformation process to optimize data in Medallion Lakehouse.

Worked on power bi reports enhancement process based on SAP Hanna database.

Created complex reports using parameters, groups, calculations, drill down and drill up, and customization using filters and actions.

Expert in working with power query editor for data transformation using Advance editor, Merge, Append, managing rows and columns and parameters.

Designed Power BI dashboards for a healthcare organization, integrating patient data from MongoDB to monitor and analyze treatment outcomes, leading to an improvement in patient care quality.

Developed a Power BI-based reporting system for electronic health records (EHRs) stored in MongoDB, enabling healthcare professionals to access patient histories, lab results, and medication information in real-time, enhancing clinical decision-making.

Implemented an analytics solution using Power BI to track and visualize hospital operational metrics such as bed occupancy rates, staff allocation, and patient wait times, improving hospital efficiency and patient satisfaction.

Utilized Power BI to aggregate and visualize data from MongoDB for healthcare compliance reporting, ensuring adherence to regulations such as HIPAA, and enhancing data security and patient privacy.

Created interactive dashboards in Power BI for analyzing clinical trial data stored in NoSQL databases, facilitating faster insights into drug efficacy and patient responses, and accelerating the pace of medical research.

Strong experience in understanding business requirements and creating advanced chart types, visualizations, and complex calculations according to that.

Managed Row-level security and its access to Power BI in different environments and integration with the Power BI Service Portal.

Managed user access, gateway connections, data security, and refreshes as an admin for workspaces as well as deployment pipeline and Apps.

Managed Azure security groups for access control for Power BI and different levels of database security.

Worked on KPIs to create the new measures, Calculated columns as well, and calculated tables using different Dax functions.

Worked on Bookmarks, Page navigations, different filter options, drill-through, Selection, Interaction, and other rich Graphic visualization functions to provide the decision-making view to users.

Strong experience in different visualization using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree-maps, etc. using Power BI.

Worked on performance improvement of developed power BI reports.

Interacted with end users for possibilities and improvements, Documenting the different stages of the Project.

Tested reports in different environments as well as performed detailed review and analysis process.

Tool & Environment:Power BI Desktop, Power BI Service, Medallion Lakehouse, Azure Synapse, Azure Databricks, Azure data factory, Data Gateway, SAP HANNA Studio, DAX, SQL, MS Excel, Windows 10, DAX Studio, M Query, SSRS, SSAS, SharePoint.

Sumitomo Mitsui Banking Corporation March 2018 – August 2021

Power BI Developer/Admin,New York, NY

Goal: Analyze the credit card and loan payment for marketing and policy improvement and provide the decision-making data of reports and dashboard to the bank leads, so they can make faster decisions based on analyzing client data.

Responsibilities:

Migrated old legacy reports/files into AWS Cloud and performed ETL based on business requirements

Combined data from different sources such as SQL server, MS Access, Excel, CSV, and Text files by using Power Query

Extracted data from SQL Servers, Smartsheet, SharePoint, Oracle, Azure, excel sheets, flat files, and CSV files.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Strong experience in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business needs through Power BI

Employed Python's matplotlib and seaborn libraries to create sophisticated visualizations, which were then embedded into Power BI reports for enhanced data storytelling.

Installed, configured, and maintained Power BI Report Server.

Managed Row level security with Power BI and integration with the Power BI Service Portal

Published Power BI reports in the required originations and made Power BI dashboards available to other colleague by sharing & and subscribing to their email.

Spearheaded the development of Power BI financial dashboards for a major bank, leveraging MongoDB to visualize complex datasets, resulting in a 25% improvement in credit risk analysis and portfolio management.

Integrated MongoDB with PowerBI to create real-time transaction monitoring systems, enhancing fraud detection capabilities and securing customer transactions.

Automated the extraction, transformation, and loading (ETL) process from MongoDB to Power BI, streamlining the reporting workflow for banking operations and reducing manual.

Designed custom Power BI reports to track and analyze key banking metrics such as loan performance, deposit growth, and customer segmentation, aiding in strategic decision-making.

Implemented data governance frameworks within Power BI environments, ensuring compliance with financial regulations and data security standards, particularly for sensitive banking information.

Built content pack to share datasets, reports, and dashboards to various departments in the company to distribute only data required by each department.

Automated the refresh and update of Power BI datasets using Python scripts, ensuring real-time data availability and accuracy in reports.

Used Python to connect Power BI with non-standard data sources, expanding the scope of data analytics and reporting capabilities.

Streamlined dataset features by using drop and rename methods, optimizing the data structure for effective analysis in Power BI dashboards.

Implementedmap and applymap for element-wise operations, refining data granularity for detailed insights in Power BI visualizations.

Enhanced data accuracy and analysis readiness by automating preprocessing tasks with Python, directly contributing to error-free and dynamic reporting in Power BI.

Interacting with the end users, documenting the requirements, and suggesting the capabilities.

Delivered reports with subscription functions in Power BI premium service.

Built analysis reports and visualizations using DAX functions like table function, aggregation function, and iteration functions

Hands-on designing and deploying rich Graphic visualizations with drill-down and Dropdown menu options and Parameterized dashboards using Power BI desktop.

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI.

Build reports Using SmartView and Excel Add-ins.

Involved in development, performance tuning, and optimizations for data/dimension loads, calculations, and overall Essbase performance.

Tool & Environment: Power BI Desktop, Power BI Service, Data Gateway, MS SQL Server 2019, Oracle Database, DAX, T SQL, XML, MS Excel, Windows 8, DAX Studio, Business Object, Web Intelligence Rich Client, Desktop Intelligence, SharePoint, Smartsheet.

Newell Brands January 2015 – February 2018

Power BI Developer/Admin,New York, NY

Goal: The project goal was to transform the complex data into well-presented information for efficient management of multiple stores, overcome retail sector challenges and flourish and have future insight into the retail industry.

Responsibilities:

Performed Power BI Desktop Data modeling, which cleans, transforms, and mash-up Data from multiple sources.

Combined data from different sources such as SQL server, MS Access, Excel, CSV, and Text files by using Power Query data blend.

Created interactive reports customized for the business using Power BI Desktop.

Incorporated Python's Pandas library to perform sophisticated data transformations, using functions like merge, groupby, and pivot_table to consolidate and restructure data from SQL Server, MS Access, and Excel, preparing it for insightful analysis in Power BI.

Experience in Performance Tuning and Query Optimization.

Build a Power BI dashboard and generate reports by leveraging Python's extensive data handling capabilities to blend data from various formats, using read_sql, read_csv, and read_excel from Pandas, followed by concat or join methods to create a unified dataset for Power BI reporting.

Developed schemas, tables, triggers, indexes, sequences, constraints, functions, and procedures, also used Python for large data transformation as well as visuals.

Installed configured and maintained Power BI Report Server.

Developed calculated columns and measures using DAX in Power BI

Built analysis reports and visualizations using DAX functions like table function, aggregation function, and iteration functions.

Executed dashboard setups and data manipulation using DAX.

Created reports and dashboards using Bars Chats, PIE Chart, Donut Charts, Gauge, MAP, Waterfall Charts, Filters, and Slicers.

Used Power BI enterprise GATEWAY to keep the dashboards and reports up to date.

Published reports to Power BI services (Pro) and scheduled subscriptions and various sharing options (workspace, content pack, and Apps).

Developed dynamic Power BI dashboards for a retail chain, integrating sales and inventory data from NoSQL databases to provide insights into product performance, leading to a 10% reduction in stock-outs and overstock situations.

Utilized Power BI and NoSQL to analyze customer purchase patterns and preferences, driving targeted marketing campaigns that increased customer engagement.

Enhanced supply chain visibility for retail operations by creating Power BI reports that tracked logistics and inventory metrics in real-time, improving supply chain efficiency.

Experience in Microsoft BI stacks SSIS, SSRS, and SSAS, Azure to transform, debug, and manage data.

Worked on transforming and validating data using SSIS transformation such as lookup, Merge joins, and sort columns.

Worked on tuning up and changing some of the existing SSRS reports into Power BI reports requested by the user.

Developed Python scripts to automate repetitive data processing tasks, utilizing schedule library for periodic execution of scripts that preprocess data, update Power BI datasets in real-time, and maintain dashboard accuracy.

Responsible for deploying the reports, dashboard, and content packages on all environments. Formed database objects like tables, users, roles, stored procedures, and triggers.

Tool & Environment:Power BI Desktop, Power BI Service, Data Gateway, DAX, T-SQL, SQL Profiler, XMLA, SSIS, SSRS, SSAS, Python, MS Excel, Windows 10, MS SQL Server 2018/2019.

Transform Solution Pvt LtdApril 2010 – April2014

Data Analyst,Surat- Gujarat, India

Goal: The project was about creating packages for extracting and loading data in a data warehouse and according to business users’ various reports were implemented. Gather and Prepare documentation to create the reports.

Responsibilities:

Generating and designing Business Intelligence solutions and application development in the financial industry.

Used Data Transformation Services to import the data in SQL server from heterogeneous data sources like Excel Access and Oracle.

Work with executives and other business leaders to identify opportunities for improvement

Create reports for internal teams and/or external clients

Designs, develops and supports solutions utilizing Oracle relational database management system

Collaborate with team members to collect and analyze data

Establish KPIs to measure the effectiveness of business decisions

Pioneered the use of Power BI for retail space optimization, analyzing foot traffic and sales data from NoSQL sources to maximize shelf space utilization and product placement effectiveness.

Conducted comprehensive market basket analysis using Power BI and NoSQL data, identifying cross-selling and up-selling opportunities that boosted average transaction values.

Structure large data sets to find usable information

Experience in creating multidimensional cubes using SSAS.

Work with a team of analysts and other associates to process information

Create presentations and reports based on recommendations and findings

Develop store procedures and drill-through reports using SSRS.

Performed data analysis and data profiling using SQL on various source systems including SQL Server.

Extensive knowledge and experience in producing tables, reports, graphs, and listings using various procedures and handling large databases to perform data manipulations.

Interpreting and working with data models, data flows and data dictionaries, logical& and physical Data modeling, Normalization, and De-Normalization techniques for both OLTP and OLAP systems.

Tools & Environment: SQL Server 2012/2008, MS Excel 2003-2007, ETL, T- SQL, Oracle Database, MS SQL Server Integration Services (SSIS), SSRS, SSAS

EDUCATION

Bachelor of Commerce- Financial accounting and Management, Akhand Anand arts & commerce college, Gujarat, India.

Master of science- Information System technology, Wilmington university, new castle, Delaware

Email: ad3oha@r.postjobfree.com

Phone: 732-***-****

Rachana Patel

Contact this candidate