Milan Nagar

• Fetching data from SQL and creating insightful reports and visualization into Excel and Power BI
• Creating and maintaining Sales report, Logistics report, Procurement report, warehouse inventory stock report, Damaged and Dangerous stock report, Incoming(Purchase Orders) and outgoing(Sales Orders) stock reports, shipment reports into Power BI by Direct query or Get Data feature.
• Transforming the data into Power Query and creating visualization using DAX functions like, CALCULATETABLE, SUM, IFS, FILTERS, LOOKUPVALUES, etc.
• Managing work flow to build or modify Power BI reports into Sharepoint and Power BI Report Server.
• Managing admin access to Power BI Report Server.
• Maintaining day to day to tracker of tasks.
• Taking care of adhoc activities given by department manager.
• Creating SOPs of newly built reports and modifying the same for existing reports.

• Understanding the business requirement in weekly meetings and convert them into insightful information.
• Importing data into SQL using syntax. Creating Tables using complex queries, Creating Views and Stored Procedures.
• Connecting the SQL data source into Power BI through Get Data feature and building insightful reports using as per requirements.
• Transforming the data into Power Query and creating visualization using DAX functions like, CALCULATETABLE, SUM, IFS, FILTERS, LOOKUPVALUES, etc.
• Create relationships between data and develop tabular and other multidimensional data models.
• Managing On-premise data gateway bridge to provide quick and secure data transfer.
• Managing row level security withing Power BI report.
• Managing Power BI Embedded services to integrate Power BI dashboards or reports into web based portal.
• Working with users and team members at all level for performance improvement and suggestions.

• Building complex queries in MySQL.
• Fetching data from MySQL, analyzing raw data and processing it using Excel.
• Responsible for getting data from Client server, Extracting, Importing into Software and Validating.
• Creating and sending invoices to Pharmacies based on the final quality checked data.
• Preparing Sales Dashboard, Productivity Dashboard for US and India Team, Prescribers Dashboard based on Physician and Patient data.

Automation Project

• Handling and coordinating with the IT developers to organize new Projects.
• Creating business requirement documents for new projects like automation, software development, etc.
• Analysis of monthly revenue report of client and company.
• QA and UAT of automated report screen in Software.
• Worked on Power BI desktop to get the visualization done using DAX functions.
• Data Transformation and Data Modeling in Power BI desktop using Power Query.
• Created visualization with clustered and stacked charts, Map view, Donut charts, Pie Charts, Table view, etc.

Team Lead

• As a teamlead, Supervised work of employees to keep on task for timely completion.
• Used coordination and planning skills to achieve results according to schedule.
• Participated in team-building activities to enhance working relationships.
• Managed team of 3 employees, overseeing hiring, training, and professional growth of employees.
• Managing a team of staff that ensure good data quality in the clients system by reviewing and processing inquiries and

• Actively listened to customers' requests, confirming full understanding before addressing concerns.
• Identified issues, analyzed information and provided solutions to problems.
• Increased customer satisfaction by resolving issues.

• Data reconciliation of Shrinkage, sales & Damage report which was received from the store daily.
• Preparing MIS of each data received and managing circulation and distribution to the top management.
• Coordinating with operation team members and store / warehouse manpower and collate data from various departments.
• Monitoring SAP & ERP report activity, upload inventory count and generate final report and circulate to the top management.
• Preparing presentations and providing weekly, monthly, and quarterly basis and providing to business (store/warehouses) and top management as per their requirements.