Data Analyst & Reporting : Business Intelligence, Dashboard creation, MIS reports, Data Researcher

1. PMO-Reporting Analyst at Accenture(ASAP Info Systems) since Mar 2015 to Jan 2016.

Client                    : Life Science Client
Team worked       : PMO Reporting
Tools used            : MS-Excel, VB-Macros, PowerPoint, HPSC
Domain                 : Technical
Role                       : Reporting and Analytics
Objectives : 

• To generate the Daily, Weekly & Monthly reports.
• Generate Powerpoint Presentations showing the trend and SLA

Responsibilities:

• Extract the data from different databases, tools
• Update the monthly and weekly reports with the extracted data
• Develop, Format and align the data to match the template
• Analyze and Work on the adhoc request
• Create SLA, Performance and Summary Decks

2. Software Engineer at Technosoft Corporation Pvt. Limited since Oct 2013 to Feb 2015.

Client                    : Target USA
Team worked       : Target-EBI-VMO
Projects worked   : JBP-Joint Business Planning, Risk Console-SSIS-ETL Job, Compass,
                              Weekly Traffic Light instocks, Batchloads, Vendor Scorecard
Tools used             : MS-Excel, VB-Macros, SQL-Server-SSIS, Powerpoint, Tableau, Mainframe
Domain                  : Retail
Role                       : Reporting and Analytics, Job submission and monitoring
Objectives :  

• To generate the department wise and division wise sales report of the vendors partnered with Target
• To generate the PowerPoint presentations with Sales, Guest Traffic, Transaction Graphs 
• To generate Weekly In stocks and Out of Stock reports

 
Responsibilities:

• Extract the data from different databases, Portals
• Update the monthly and weekly reports with the extracted data
• Develop, Format and align the data to match the template
• Develop and update the macro, if any changes required
• Analyze and Work on the adhoc request
• Create Dashboard and reports
• SSIS-ETL Job submission and run the package by connecting to the different databases like Teradata, IBM-DB2
• Mainframe batchloads and Vendor Survey jobs submission

3. Consultant at Symphony Marketing Solutions Pvt. Limited From May 2007 to May 2009.

Client                     : L’Oreal, Coty, Johnson & Johnson, P&G, Playtex
Team worked        : KCCIP - Beauty
Projects worked    : IRI-US-KCCIP
Tools used             : MS-Excel, VB-Macros, Workbench (Database Dictionary), Stub (Mainframe tool)
Domain                  : Retail
Role                       : Reporting and Analytics, Product Placement in the database
Objectives :

• Project on the US Consumer Packaged Goods (CPG) Market Analysis on the Client Products Sales and where they stand in the market and provide suggestions to improve their Products Moving in Market.

Responsibilities:

• Data Coding from the sources like image of the product, item send receipts, Store file descriptions and manufacturer websites to get the characteristics of the UPC’s and fill the information on the tool called Workbench.
• Placing the products/UPC’s based on the category, Manufacturer, brand, weight etc in the Unix based application called stubs which is used as a backend for database to run the sales data.
• Communicating with the client / On-Shore Team to get the Coding and Placement information of the new products through E-mail , Chat and Voice Call
• Pull the relevant data from the tools, Format and send the Client reports in Excel Fomat on Monthly basis
• Worked on Sales Trend report, Brand wise report, Client Vs. Competitor report, Internal SLA reports on Completion rate & Coding Quality report