GAUTAM TARADE

Tarade Nivas, ***/*A Nr Laxmi Saree Centre, Pandharkar Vasti, Panchataranagar Akurdi Pune 411035, Maharashtra, India

ad3uvo@r.postjobfree.com

+91-738*******

Objective: - Excellent and dynamic data analyst seeking opportunity to work in a friendly and fast growing environment where my analytical and result-oriented skills will be of great value in achieving the company’s missions and goals.

Areas of Expertise and Tools

MS Excel MS Access SQL Server 2019 (Basic) Oracle Business Intelligence Enterprise Edition (OBIEE) Data-Driven Insights Analytical Skills Leadership Reporting Salesforce SAP Fieldglass Power BI

Core Proficiencies and Special Attributes:

14 years of experience in MIS/Data Analysis field.

Able to work with deadline oriented, capable of effective problem solving, excellent leadership and organizational skills, attention to detail and accuracy, flexible, results driven

Analyzing Results, Data Analysis techniques, task prioritization, data preparation

Company Performance Summary Dashboard, Reports and Dashboards, Business analysis summary report, Initiative, Commitment.

Education:

Bachelor of Engineering in Information Technology, Pune University-India, June-2006

Professional Experience:

Capgemini India Pvt. Ltd., Pune-India (Data Analyst Lead) Aug:2021 to till date

Experience in developing and implementing a reporting solution for SAP Fieldglass like monthly KPI reports, inflation report at global level for management.

Responsible for preparing quarterly Savings file at global level, Leadership reporting

Support to the business users in terms of reports like any ad hoc requirement.

Active involvement for co-coordinating with BI team for transforming SAP/KPI reports into Power BI Dashboard in terms of requirement analysis, UAT, data verification.

Active involvement in the process of enhancement of system tools like BI Dashboard, SAP.

Proactively identifying any report that can help to improve business performance.

Experience gathering and translating business user's requirements into effective and efficient Reports and Dashboards.

Experience in creating different visualizations like column, line, Pie, Doughnut, Bar etc.

Skilled at assessing business needs, working in groups, suggesting ideas that enhance efficiency and performance

Technology components used: SAP Fieldglass, Power BI Dashboard, MS Excel, MS Access.

Winner of the Enabling Champion for the period 01 Apr 2023 to 30 Jun 2023

McDermott International, Inc., Dubai - UAE (Proposal & Estimation Analyst) Sep:2015 – Sep:2020

Daily/Monthly updates of data, formatting and scrubbing raw data and uploading into the Salesforce.

Build reports and Dashboards - Creating reports, summaries, and customized dashboards for cross-functional teams.

Developing and maintain daily, weekly, monthly and quarterly reports in Salesforce.

Maintaining clean and up-to-date data in the Salesforce application.

Responsible for gathering bid related information from proposal specialist.

Worked closely with Business Development and P&E Team to continually identify and gather required enhancements for Salesforce updation.

Supporting team members for resolving IT related queries.

Dashboards, charts, graphs, diagrams in Tableau

Worked cross-functionally to establish reporting standards.

Generating various reports (Budget Vs actual booking), statistical analysis from Tableau.

Location, status wise reports, summaries, visualizations in Tableau.

Landmark Group, Dubai – UAE (MIS Analyst) Apr:2011 –Sept:2015

Carry out analysis of given data and draw correct inferences, in keeping the objectives of analysis. Ensure accurate and timely preparation / compilation, aggregation, analysis and delivery of MIS reports and presentations for review.

Preparing MIS reports, purchase order Vs receipt summary, dashboards location wise, supplier wise, product wise, top/bottom trend.

Design new dashboards or, modify the existing report formats to improve the quality of key information and to highlight key areas for growth of business performance, review and decision-making.

Maintaining sell throu reports on daily (DSR), weekly, monthly, (MTD, YTD) as well as ad-hoc basis.

Margin reports, sales analysis, receipt Vs sale summary, stock analysis, aging report, stock valuation at store/terr/dept level.

Season wise good/bad seller products, actual vs. target sale trend analysis at product type/group/gender level to identify business growth.

Creating ad-hoc reports as per requirement of management. Analyze current business performance and suggest improvement measures.

Educating (supplied regular support) new planners, buyers in reviewing the reporting structure. Ensure that the buying, planning department receives timely and qualitative information at all levels of product regarding all aspects of the business.

Conducted regular meetings with buyers, planners to analyze performance. Regular support in terms of reports to other functions like Marketing, Finance, Quality, Shukran.

Preparing OTB (open to buy) summary for buyers/planners for budget purpose.

Collect, forecast, analyze, evaluate and report data in order to increase sale productivity.

Preparing markdown reports managed store replenishment and analyzed buying reports.

Bharati Airtel limited, Pune – India (Sr. MIS Executive) June:2009 – Mar:2011

Pagepoint is call center for Bharati Airtel limited –a top mobile service provider in India.

Preparing same day resolution (SDR), service request trend (SR) report, Service level achievement (SLA) report, repeat calls, valid-invalid dashboard, QOS (Quality of service for TRAI).

Providing reports to pagepoint management as well as numerous Airtel process owners in order to increase efficiency in service.

Providing various reports like repeat non-repeat, open, reopen, closed SR, SR per customer as on basis.

Providing raw data, dashboards to process owners for weekly, monthly review.

Maintaining calling (incoming) data, MIS data in MS excel MS access as per need.

Reconciliation of different report and correction of data after discussing with the team, highlighting strong/weak area.

Provides information to management by assembling and summarizing data; preparing reports; making presentations of findings, analyses, and recommendations.

Coordinate with process owners for monthly review meetings and presentations.

Provide analytical insights to the management to make decisions.

Prosys Infotech Private Limited, Pune – India (Jr. Programmer) Oct:2007 – May:2009

Prosys-eMIS is MIS automation solution based on Microsoft business intelligence framework, contains professional input and technical tools to build the MIS and other analytical reports according to business requirements.

The user can interact with the report to summarize and drill down, study trends and create different views and graphs.

Responsible for coding forms (GUI), making reports, firing queries, cleaning data, attaching all these components to eMIS solution.

MS access forms for GUI, which imports data using macro from inputs like, excel text files.

Courses Completed:

Microsoft Power BI - Up & Running with Power BI Desktop.

Microsoft Excel-Excel Power Query, Power Pivot & DAX.

Complete Introduction to Google Data Studio 2020 Edition.

SQL Server Tutorial

Refer LinkedIn Profile for certificates.

Domain knowledge : Insurance Aug-2006 – Sep 2007

Worked with Bajaj Allianz General Insurance Company limited, Pune –India as MIS Executive in Operation Support department.

Academic Projects:

Title: Network Backup System

Domain: The Network Backup System Software deals with backup of data stored on client connected to System Administrator. This type of software is required in various organizations for backup. Main aim of the software is to enable system administrator to take backup of any data from any location in LAN. The backed up data is stored in compressed form.

This system is installed on single machine in LAN so there is no need of client server architecture. Any PC can host the software. The system is having 3 options: Backup, Restore, Tools. Administrator can take new backup, update last backup, view backup contents, delete backup. Also restore last backup, restore selected backup along with selected files/folders to its original locations. Administrator can set the scheduling time and at that time backup will automatically start. The backup will be stored in compressed form.

Tools: Core Java, Swings, MS Access

Sponsored By: Bharat Software, Pune.

Role-played: Analysis, designing, coding, and testing.

Title: College Management System

Domain: The system is developed for a college. It stores all the information related to management, departments, teaching staff, non-teaching staff and students. An administrator can perform various operations like display, insertion, deletion and modifications.

Tools: Core Java, Servlets, HTML, Tomcat server, MS Access 2000.

Role-played: Analysis, designing, coding, and testing.

Personal information:

Marital status: Married, Nationality: Indian, Languages: English, Hindi, Marathi Passport number: U9124457 {01-Apr-2021 to 31-Mar-2031}

DOB: 24-Dec-1983 (Pune-India)

Contact this candidate