Role : Senior PowerBI ,Kusto Developer

Environment : Azure Dataware House (Kusto),PowerBI.

Project Overview:

. Microsoft drives the world forward by tackling its biggest challenges, bringing real progress and possibility to every corner of the planet —Analysis of the performance metrics for over all Process with the help the DSRE Project.

Responsibilities:

1. Had a close look on the azure dataware house kusto cluster.
2. After many analysis and comparison between the sql,Kusto got the limitations and developed the Kusto queries for sla automated calculation for millions of records.
3. Deploying the queries in PowerBI as per the requirement of the client.
4. This develop of Kusto query and deployment made manually task to be reduced and also provide security levels to the data.

• By this Kusto deployment to PowerBI made the Reports to be automated and for easy reference of client and users with Business intelligence visuals

Client :General Electronics (GE)

Role :Process Analyst.

Environment :Power BI, Oracle ERP,SQL Database.

Project Overview:

• GE Drives the world forward by tackling its biggest challenges, brining real progress and possibility to every corner of the planet – Extracting awaiting action report of onhold Invoices and analysing each invoice and getting approved as per the invoice discount date, and represented this the discount captured with high dollar amount wise and Top supplier wise through most powerful tool called Power BI.

Responsibilities:

1. Work on all discounted invoices that are on hold for payments and make sure the discount is captured within the discount gates
2. Prepare a weekly discount lost report and share it with Business with discount lost %
3. Continuously follow-up with Business/ Buyer team/ Vendor to get a resolution to release the invoice for payment which can be paid in discounted terms.
4. Improved the discount gain % from 69% to 86% in a span of 8 months.
5. Prepare a detailed flowchart and provide reasons for loss of discount.
6. Setup calls/ meetings with Business Units and discuss improvement ideas in reducing Discount lost %.

• Improvements which had Impact:

1. Worked with IT team and automated the process of sending auto notifications for invoices on hold.

• To reduce discount lost due to late submission, suggested business to consider invoice receive date as invoice date so there will be 0% loss of discount

Client:General Electronics (GE)

Role:Power BI Specialist

Environment:Power BI, Oracel R12, Supplierconnect, Aravo.

Project Overview :

GE drives the world forward by tackling its biggest challenges, bringing real progress and possibility to every corner of the planet —Analysis of 3000 Suppliers Payment method via EFT or check in SCX and Vendor look up Tool. review supplier sites identified as Check and to update as EFT.

Responsibilities:

• Gathered Business Requirements, interacted with Business Leads, Business Stakeholders.
• Extracted Vendors Report via SQL in SCX, Aravo.
• Analysis of Extracted Data to provide Best decisions for Business.
• For this data, extensively worked on Dax Calculations part and used extensively power query.
• Assisting all the stake holders to enhance Data driven culture and supporting decision making depends on data.
• Closely worked with Vice President, International Head of Sales and prepared Adhoc reports

Client :General Electronics (GE)

Role :Project Lead and Procurement specialist.

Environment :SQL Server, Support Central, Oracle service cloud.

Project Overview :

• The goal of this project is to build an automated, dynamic and streamlined reporting and visualization framework for End users and prepares Major Real Estate Developer for their 22 critical monthly reports using Power BI to improve productivity and bring more flexibility in the current process framework. The scope of this project is to understand the workflow fileds from all regions (Latam, NAM, Europe, APAC, META, China) sources and structures associated with the current workflows, framework and recommend, architect and implement a more streamlined and automated framework that not only helps build mores for Buy desk and also configurable for End users which improves productivity with reduced manual effort.

Responsibilities:

• Gathered Business Requirements, interacted with the Users, SMEs of all Regions of corporate to get a better understanding of the Business Processes.
• Made a master file, Charter with high level steps to make interaction call easy for review.
• Involved in Technical Specification Document (TSD) and understanding the User requirements
• Develop and design interactive workflows.
• Resolved the performance issues of the Reports and Feedbacks.
• Served as Power Bi Developer meeting deadlines and budget requirements.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures