Charu Garg

281-***-**** ad36kd@r.postjobfree.com

Experience in PowerApps applications & BI development using the Microsoft Power Platform in addition to 7 years of experience in design, development and implementation of Power BI dashboards, scorecards & performance reports.

Provided full lifecycle Power BI administration (patches, updates, AD security, account management, capacity management, documenting processes) including the ability to work with data owners, solution managers, and report developers to support their needs following Hershey self-service best practices and guidelines.

Proven qualifications in data modeling, analyzing requirements, planning, designing, and implementing innovative database solutions that meet or exceed challenging business needs.

Experience in creating rich Power BI visualizations, DAX queries and Power Query, M code language for data integration and transformation as per the business requirement.

Provided strategic and tactical contribution to ensure full project life cycle design, development, and implementation of database solutions.

Designed, developed custom reports, scorecards and dashboards using Power BI, Tableau and Alteryx

Experience in tools like Microsoft Team Foundation Server (TFS), Visual Source Safe (VSS), DevOps for version controlling of the application and for implementing agile/scrum software development methodologies.

Excellent communication and presentation skills, with the ability to articulate new ideas and concepts to technical and non-technical partners.

Ability to generate and maintain code documentation using clear communication practices.

Excellent customer service skills and the ability to effectively communicate and collaborate with diverse internal and external stakeholder groups and individuals.

Lead offshore Application Managed Services team to provide daily production system and user support ensuring the delivery of resolutions within Service Level Agreements.

Maintain the performance and optimization of certified reports/datasets and analytical solutions.

The Hershey Company, Pennsylvania June 2022- Present

Data Visualization Engineer at Hershey

As part of the Data Visualization Engineering team, engaged with Hershey Information Services partners, business stakeholders, and vendors to deliver enterprise-grade, best-in-class data analytics, and visualization solutions.

Provided a solution delivery experience with a focus on the optimization of Power BI environments for usability, performance, flexibility, testability, standardization, and automation.

Acted as a trusted advisor, providing guidance and leadership for complex projects and issues, offering insights and recommendations on best practices, including performance improvements.

Worked with a diverse team of business analysts, data scientists, technical engineers, data architects, and project managers to deliver outcomes aligned with our business partner’s strategy.

Reported directly to the Manager of Data Visualization Engineering to ensure consistency and compliance of deliverables to frameworks and governance processes.

Managed power bi licenses through power bi report and power automate flow to communicate with Power BI pro license users.

Implemented power apps to gather user response for cleaning up power bi capacity.

Environment: Power BI Desktop and Service, Knowledge of relational/non-relational databases such as Teradata, Snowflake, Databricks, Azure Data solutions, SAP Business Warehouse, and Hadoop, working knowledge of agile frameworks, Word, Excel, PowerPoint, Outlook and SharePoint, SQL Management Studio, PBIVIZ, Microsoft Azure, Azure Databricks, Power Platform, Power Apps, Power Automate, Microsoft 365, Power shell script, Tableau, Alteryx

Halliburton, Houston April 2021 -March 2022

Production Enhancement Data Analyst\Power BI Report Developer

Worked with fracking data to analyze for product owners, executives, and stakeholders review, alongside a team of data scientists, data engineers, and data analysts.

Researched existing system databases to identify valuable data and crystalized the business logic required to translate this into useful BI information.

Gathered and translated business requirements and built-out insightful BI solutions, following established departmental design patterns.

Worked on a wide range of project requirements: BI Tool Development, System Integrations, and backend System Analyses.

Created Power Automate flows to automate business processes.

Developed a comprehensive custom Power App to enhance the process with a user-friendly GUI interface. The app automated approvals through Power Automate, delivering transparency, reducing fill times, and eliminating manual errors.

Environment: Power BI Desktop and Service, SQL Server Database, Word, Excel, PowerPoint, Outlook and SharePoint, SQL Management Studio, PBIVIZ, Starburst, Microsoft Azure, Azure Databricks, Power Platform, Power Apps, Power Automate, Microsoft 365.

Occidental Petroleum, Houston April 2019 -April 2021

HSE Data Analyst\Power BI Report Developer

Supported OXY’s Health, Safety and Environment (HSE) corporate report/dashboard creation and maintenance efforts.

Design, develop, deploy and maintain high-quality Microsoft Power BI dashboards, reports and visualizations based on discovered requirements.

Collaborated with internal HSE and IT experts and consultants to understand their needs for self-service reporting solutions. Liaising and consulting closely with technical team members to weigh technical considerations against business requirements to develop solutions.

Worked on ad hoc needs - assisting in data validation, cleaning up and importing/exporting requests as needed.

Migrated Spotfire dashboards and reports to self-service Power BI solution with complex DAX and Power Query

Published Power BI Reports through the Azure Service and made Power BI Dashboards available in Web clients and mobile apps.

Environment: Power BI Desktop and Service, SQL Server Database, Spotfire, Reporting Services (SSRS), Word, Excel, PowerPoint, Outlook and SharePoint, SQL Management Studio, SAP Insight, Intelex.

British Petroleum, Houston October 2018 – April 2019

Power BI/ SQL Report Developer

Developing Power BI dashboard for Drilling managers to get insights in drilling data in real time, Used R code to develop complex calculations and graphs, Used Python code to perform data manipulation, scheduling reports to send emails at scheduled time every day, Used Microsoft Power BI online Services to schedule reports to be refreshed at predetermined time, Used SSIS to load csv files into SQL DB.

Distribution International, Houston July 2018 – September 2018

SQL Report Developer

Actively involved in extracting data for integration by writing SQL queries and developed data Models for different departments for reporting.

Federal Mogul Motorsports, MI August 2017 – June 2018

SQL/Report Developer

Actively involved in gathering and analyzing the user requirements in coordination with Business and

developed custom selection of reports ordering using Microsoft Power BI and SSRS

SOAP Engineering, Houston Tx January 2017 - August 2017

SQL/BI Report Developer

Developed reports like Matrix, Drill down, Drill through, and Map Visualization using Microsoft Power BI tool.

ZEKELMAN Industries, Chicago, IL September 2016 – December 2016

SQL Developer

ZEKELMAN previously known as JMC Steel Group is the largest independent steel pipe and tube manufacturer in North America. Leveraging operating divisions of Atlas Tube, Wheatland Tube, Picoma, Energex Tube, and Sharon Tube, they are the most trusted and comprehensive resource for structural application-specific tubular steel products and solutions in the country.

Cardinal/Sonexus Health, Lewisville Tx May 2016 – August 2016

SQL Developer

Del Monte Foods, Inc, Modesto, CA Oct 2015 – April 2016

Sales Performance Dashboard Developer

Leverage live data and real-time dashboards to review current sales performance to identify underperforming areas of business, determine the variance between actual revenue and sales targets by segment.

Sharp Electronics, Mahwah, NJ Dec 2014- Oct 2015

SAP Business Objects Reporting Analyst

Created scalable, multi-dimensional, dynamic Design Studio Analysis Applications and dashboards based on SAP BusinessObjects Business Intelligence (BI platform)

ATM Monitoring System,EFI India Pvt Ltd, India Dec 2008 -June 2010

Hospital Management,EFI India Pvt Ltd, India Apr 2007 – Nov 2008

Time Tracking System, EFI India Pvt Ltd, India Nov 2005 – Mar 2007

Budget Management System, TCGIvega, India Aug 2004 – Oct 2005

EDUCATION:

Bachelor of Engineering (Electronics & Communications)

Visvesvaraya Technological University, Belgaum (Karnataka, India)

Graduated in July 2004

Contact this candidate