Power Bi Architect

Key Skills

Profile Summary

BI Architect

Banking, Finance, retail, Insurance &

Pharmaceutical Industry

Process Improvement/Enhancement

Client facing and coordination

Strategic Planning & Execution

Vendor Assessment/Management

Requirements gathering and delivery

Cross-functional Coordination

Proficient in Oracle, SQL, Snowflake, Business Objects, Microsoft Power BI, Microsoft Fabric, SSAS, Power BI Self Service Models, MicroStrategy, Cognos . Practical exposure to the all the phases of the SDLC Proven success in end-to-end service delivery management and ensuring effective management of various resources to client requirements; capabilities in optimizing/process performance and efficiencies Distinguished skills in interacting with Business Managers, Consultants, Vendors, Clients and translating their requirements into functional specifications Keen Analyst with excellence in gathering and understanding requirements of clients; coordinating with Onshore/Offshore Delivery Leads for updating any changes according to the client requirement

Worked as Key Facilitator in enabling clients/stakeholders achieve their strategic objectives by designing & implementing business solutions with management processes to facilitate the required change Leveraged capability of motivating and leading talented professionals; expertise in building large teams that well exceed corporate expectations Strong Experience in Developing Operational and Analytical Reports, Testing Reports and Creating and Executing Test Plans

Excellent experience in implementing Dimensional Modeling Techniques like star-schema, snowflake schema

Career Timeline

2006-2010 2010-2013 2013-2015 2015-2016 201*-****-****- Till date Soft Skills

Education

Masters in Computer Applications Swami Ramanand Teerth University, Nanded in in 2003

Bachelors in Computer science from Swami Ramanand Teerth University, Nanded in 2000

Swapnil Labhe *************@*****.*** +1-262-***-**** Sr. BI Architect with extensive experience in Banking and financial services, Retail, Energy Commodities & Pharmaceutical industry. Proven track record in exhibiting skills in Personnel

and Project Leadership

Sr Project Leader in

Nucsoft Ltd, Mumbai,

India

Project Leader in

LNT Infotech in

Pune India and

USA

BI Architect in Fresh

Direct LLC,

Woodbridge, NJ, USA

Associate Projects

in Cognizant

Technology

Services Pvt Ltd,

Pune, India

Sr Consultant in

Capgemini America

Inc, Wisconsin, USA

BI Developer Castleton

Commodities

International, NY

Current Employer

2024 – till date working as VP – Business Intelligence in Castleton Commodities International, New York

(Microsoft Power BI, Snowflake, Bit Bucket, Power Automate, Tableau, Microsoft Fabric, Cognos, MicroStrategy) Key Result Areas:

Played a vital role of mentor for leading various energy commodities desks US Power Strategy, Global Oil, Physical Gas, Natural Gas, Physical Power

Worked as Subject Matter Experts between offshore and end users

Working on POCs for initiating Microsoft Fabric for various projects of Data Engineering, ingestion and Visualizations

Connected to different sources of websites and pulled data in Azure SQL/Synapse for data analytics through Fabric

Played a very important role of requirements gathering, knowledge transfer to offshore and delivering it within target date/time

Streamlined complex Power BI Reposts/ dashboard and fined tuned those for better performance

Initiated new processes like deployment pipelines for prod deployments across the environments like DEV-UAT- Prod

Worked as dual role of Business Analyst and coordinated with ETL team for the specifications to convert the business requirements into ETL

Actively working on creating data model in Power BI and designing the dashboards

Played a particularly key role while Data visualization in dashboards and reports. Actively worked upon Use of MAPs and changes in dashboards

Use of Complex DAX expressions to produce well-tuned measures and extensive use of Power query and M power been taken care while working with business users.

Created the Dynamic Reports with updating the same with use of Dynamic parameters and custom functions.

Designed and implemented reports with Import and Direct query

Successfully scheduled reports through Enterprise gateways om servers.

Use of self-service BI as Connecting to datasets in Power BI service from desktop, Quick measures for common calculations, easily distribute dashboards and reports to large audiences with Power BI apps

Actively working as technical lead for migration from Business Objects to Power BI

Designed Power BI models to replace universes and making sure that self-service is smooth for end users Former Employer

Since Aug-2016 with Fresh Direct LLC, Bronx, USA as BI Architect (SAP Business Objects 4.x, Microsoft Power BI, MicroStrategy, SQL) Key Result Areas:

Analyzing the existing System through direct Client Interactions. Also responsible for requirement gathering, effort estimation. Developed analytics training courses to create sustainable process of on boarding new analysts. Led process improvement of Inbound, Outbound, Manufacturing, FD Express, Transportation, Merchandising, Customer Service Identified opportunities by forming a coalition to frame the problem and create a project plan Goal: to expedite and unify performance feedback to the business Quickly learned MS Power BI and Decision Point Dashboards & partnered with IT to install the application Improved data governance by building data controls within Microsoft Power BI Led merchants through transition, resulting in high adoption of Power BI Fostered transparency of issues with consolidated view of KPIs and trends. Successfully reduced merchants’ time spent researching category performance. Transforming the requirements into BRDs and responsible for receiving sign off for those from business Also played a major role in creating technical specifications for the dashboards and Business objects reports Worked as dual role of Business Analyst and coordinated with ETL team for the specifications to convert the business requirements into ETL

Working on COS sales dashboard in Microsoft Power BI Coordinating with business for their requirements and working to come up with best possible solution

Actively working on creating data model in Power BI and designing the dashboards Working in Fresh Direct with Power BI for Marketing, Operations and finance reporting. Played a very important role while Data visualization in dashboards and reports. Actively worked upon Use of MAPs and changes in dashboards

Use of Complex DAX expressions to come up with well-tuned measures and extensive use of Power query and M power been taken care while working with business users.

Created the Dynamic Reports with updating the same with use of Dynamic parameters and custom functions. Designed and implemented reports with Import and Direct query Successfully scheduled reports through Enterprise gateways om servers. Use of self-service BI as Connecting to datasets in Power BI service from desktop, Quick measures for common calculations, easily distribute dashboards and reports to large audiences with Power BI apps Actively working as technical lead for migration from Business Objects to Power BI Designed Power BI models to replace universes and making sure that self-service is smooth for end users Highlights: Achieved the following:

Designed over 200 + dashboard for plant which are live and operational now Worked on Power BI for Johnson & Johnson, Raritan, NJ to create interactive BI reporting as Efficiency Reports on Lot Production

Trending And Analysis of Quality Control Data

Recommendations Based Clinical Trial Reporting

And Financials Per Batch Produced for Each Product Product Go to market assessments (how much spend and types of activity is involved, expected and actual results) Also created KPI reporting as

Process efficiency Cost of Sales

Inventory levels

Batch Losses and cycle times

Quality standards of a product line

Trained the SMEs in Power BI to have self-service assistance Successfully converted universes into Power BI data models to have it available for users to enable self-service Working on current issues successfully from last 5+ years to resolve users’ issues and deliver Improved IT operational service levels achieved operational service efficiency by 70% with reduced headcount of 9 Worked effectively towards improving the SLA for the SAP & DBA team which resulted into significant results Prepared the Technical Specification Document (TSD) based on the understanding of given Business Specification Document

(BSD).

Ability to follow standards for procedures and documentation Excellent communication skills, strong analytical, problem solving, and conceptual skills. Excellent Team Leading, Team Management and User Interaction Skills. Prepared the SOP which showcased end-to-end Application & Database business; this initiative brought in additional business *************@*****.*** +1-262-***-****

Previous Experience

Aug’2016 – Till date with Fresh Direct LLC, Bronx, USA as BI Architect – SAP Business Objects, Microsoft Power BI, Oracle, SSAS, SSMS Aug’2015 – Aug’2016 with Capgemini America Inc as Sr Consultant for client West Bend Mutual Insurance, Wisconsin, USA – SAP Business Objects, Microsoft Power BI, Oracle, SSAS, SSMS Nov’2013 – Aug’2015 with LNT Infotech, India and USA as Project Leader for client Citibank and Johnson & Johnson, USA- SAP Business Objects, Oracle, Power BI

July’2010 – Nov’2013 with Cognizant Technology Services India Pvt Ltd, India and UK as Associate Projects for client JP Morgan, Bank of New York Melon, Barclays, UK - SAP Business Objects, Oracle Aug’2006- July-2010 with Nucsoft Ltd, Mumbai, India as Sr Project Leader for clients Fullerton India Credit, Citibank, Bank of Baroda

- SAP Business Objects, Oracle

IT Skills

SAP Business Objects 3.x, 4.x, Web Intelligence, CMC, Administration, Universe Design Tool, Information Design Tool, Import Wizard, Promotion Management, Version Management

Microsoft Power BI, Power BI Report Builder, Power Bi Service, DAX, Azure MicroStrategy Semantic Layer, Data Blending

Oracle SQL, SQL Server, MySQL, Import/Export, SQL Loader, SQL* Plus, MS Access, Toad, SQL Developer Star-Schema Modeling, Snowflakes Modeling, FACT, Dimension tables MS office Package

Internet Applications

Personal Details

Languages Known: English, Hindi, Marathi

Email ID:- *************@*****.*** Contact Number:- +1-262-***-**** Linked In Profile:- linkedin.com/in/swapnil-labhe-873a3a13 *************@*****.*** +1-262-***-****

Contact this candidate