Profileimage by Anonymous profile, Data Analyst & Reporting :  Business Intelligence, Dashboard creation, MIS reports, Data Researcher
available
Contact

Last update: 27.08.2019

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

Graduation: Bsc in IT, Diploma in E & C
Hourly-/Daily rates: show
May vary depending upon the project scope
Languages: English (Full Professional)

Attachments

CV-Udaya.doc

Skills

Data Analyst & Reporting.
Over 4+years of expereince handling various kinds of data. 
Have expereince working in Retail, CPG and IT sectors.
Wellversed in Data Collection, Data Cleansng, Data Validation, Data Analysis.
Have worked on getting the insights from the data.
Good Command on MS Excel and Powerpoint
Have an exposure working in Tableau, Oracle SQL
Have worked on Dashboards and Reports Creation, updation and Maintenance
On-time on delivering the reports as per the periodic schedule.
A quick learner and a detail oriented professional.

Project history

  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
  1. 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
  1. 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

Other

Hello, 

Please contact on the Data Analysis and Reporting projects!

Thanks for ypur time!

-Regards,
Udaya

Contact form

Contact details