Power Bi It Support

Deepti BANSAL

ad15sv@r.postjobfree.com, Phone +1-317-***-****, Fishers, IN

Objective

To work in a progressive and growth-oriented organization, which provides a conductive/flexible work environment that challenges skills & facilitates opportunities to learn and grow as a professional.

Professional Summary

Passionate about understanding business problems, identifying pain areas, analyzing them, and working with IT team to help clients to achieve business goals in a most comprehensive way.

Coordinated with the IT support team to assist in planning, requirements gathering, analysis, verification, and maintenance of application within the organization.

Experience in creating Power BI reports and Dashboards with Rich visualizations on Sales & Marketing Domain

Experience working on sources like SQL Server, Oracle, Excel, Flat file to load data into Power BI.

8yrs of Domain knowledge of Pharmaceutical/Healthcare Industry related to Sales and Marketing Business Unit.

Knowledge of working in Scrum Framework

Education

Post-Graduation Diploma in Business Administration with ‘A’ Grade from Symbiosis Pune University, India

Bachelor of Commerce from Delhi University, Delhi India

High School from Central Board of Secondary Education, Delhi, India

Achievements

Early Promoted in M/s. Sanat Products Ltd. for beyond excellence performance.

Many Organizations level “On the Spot” Award

Technical Skills and Tool Used

Primary Skills : Requirement Gathering, Business Analyst, Scrum Framework

Reporting Tool : Power BI, Advanced Excel

Expression Language : DAX, SQL

Database : SQL Server 2014/2016, Oracle

Operating System : Windows XP /7/Window 10

Other Tools : MS Office, JIRA

Personal Particulars

Visa Status : H4 with EAD valid till Feb’2025

Soft Skills : Workaholic, Team Spirit, Hardworking and Dedicated, Quick Learner

Work Experience

State of Indiana: Team Lead / Project Coordinator Jan’2023 to Present

The following are the responsibilities performed -

Maintain High touch information database used by the State Counselors in SharePoint

Act as a liaison between Public and State agencies to provide information related to State, Federal, and Local Government Agencies

Answers queries using Zendesk, real-time chats, and information lines.

Responsible for update of Subject matter in the database and other resource systems

Daily Reporting Status

DSM Sinochem Pharmaceuticals: Sr. IT Sales Administrator Jun’2013 to Dec’2013

The following are the responsibilities performed -

Create Visuals and Reports in Power BI Desktop and publish into Power BI Service.

Generating reports using DAX time intelligence functions and other kind of DAX functions.

Co-ordination with Sales team for Sales Forecast (volume & price) collection and compilation

Sales loss tracking through sales managers/heads

Tracking implementation of sales excellence action plans and preparing reports of the same.

Prepares routine sales and marketing reports with respect to Sales, TSS, Marketing activities

Collaborating with field staff, stockiest, warehouse and different departments.

Analysis the Primary & Secondary Sales in every month.

Analysis Product wise/Value Stock & Sales report.

Analyzes trends and recommends adjustments address and/or capitalize on trends.

Prepare monthly reports covering key Performance Indicators, contribution margins on each product.

Monitoring chronic cases, and regular defaulters.

Making presentations for new Products.

Involved in creating relationships between dimensions and measure groups as per business requirement.

Gandour India Food Processing Pvt. Limited: IT Sales Administrator May’12 to May’13

The following are the responsibilities performed

Handling Sales MIS and creating weekly, monthly, and quarterly reports using excel.

Prepares routine sales and marketing reports with respect to Sales, TSS, Marketing activities

Collaborating with field staff, stockiest, warehouse and different departments.

Preparing & analyzing the Data and making MIS & Reporting to management.

Creating Sales Target Allocation and achieving Sales Target Report

Stock Management at CFAs, Order management & payment management

Analyzes trends and recommends adjustments address and/or capitalize on trends.

Responsible for handling all enquiries, request for information, etc. between the company and its team & Channel partners

Scrutinizing orders received from the dealers / customers and preparing order acknowledgements

Capturing Market Feedback (Enterprise Feedback Management)

Escalate Issues/Queries to Program Managers

Dabur Limited: Assistant IT Sales Administrator Jan ‘10 to Apr ‘12

(Sanat Product Limited)

The following are the responsibilities performed

Support Sales team as needed including data entry and coordination with the Recruiting team

Calendar administration – scheduling internal and external reminders, calls, meetings, events

Coordinate and attend all sales meetings, publish minutes, and action plans.

Develop, maintain, and publish weekly updates and sales reports utilizing graphics to communicate trending sales and market activity.

Publish weekly sales activity reports to VP Sales.

Prepare a sales report for Monthly, Quarterly & Yearly.

Consolidate MIS

Provide Monthly Sales Data analysis reports to CEO & Regional Sales Heads.

Coordinate revisions to all line price lists with the Logistics Chain Deptt.

(Prior Experience with Euphoric Pharmaceutical & Brawn Lab as Sales Admin can be provided on request)

Contact this candidate