Jatin

PROFILE SUMMARY            

Proficient in reviewing data associated with projects & ensure that data is always accurate.

Efficient in delivering the reports within agreed SLA and TAT

Proficient in building medium to complex periodic reports using advanced Excel and be able to automate Reports using VBA

Ability to create charts and graphs to compare corporate performances, Revenue, sales etc.

Proficient in Design and develop models using VBA programming for Excel

Proficiency in writing VBA macros to send bulk mails through excel.

Proficient increating MIS reports ,dashboards and in Advanced excel(vlookup,Hlookup,pivot table, sorting, conditional formatting ,filter,concatenation,sumif,count,counta, count if, index , match ,Data validation etc for generation of reports.)

Good knowledge of VBA Macro (For Loop, For Each Loop, Function, Event Etc.

Prepared PPT Slides of process Description which include SIPOC and other Performance Review

Supported the Data repository mainly for product library, customer info under master Data Management(MDM) Module of of SAP

Zeal to achieve the desired objective.

Complete knowledge of Accruals, deferred expenditure &revenue and other accounting concepts

Complete knowledge of calculating shrinkage and Attrition rate

Expertise in Executing data Pull Requests Using SQL

Professional exposure to System Development Life Cycle (SDLC)

CORE COMPETENCIES

Process Management & Transition

Organized and goal oriented 

Complete knowledge of the tools(DFD,E-R Diagram, Flowchart etc.) required to prepare SRS and other Documents 

Proficient in Fetching Data as per the requirements from database through complex queries using SQL Developer.

Proficient in preparing MIS Dashboards for various processes.

Client Relationship Management

Managing service operations for rendering and achieving quality services, providing customer support by answering queries & resolving their issues and ensuring minimum TAT

Assessing the customer feedback, evaluating areas of improvements, providing critical feedback to the associates on improvements and achieving higher customer satisfaction matrices

Team Management

 leading, training and monitoring performance of the team members for maintaining excellence in the service operations

Evaluating effectiveness of training & development programmes; formulating or reviewing training strategy and determining appropriate instructional methodologies and formats

Producing and presenting attrition ,attendance and shrinkage report of a Team

Small Milestones achieved at office in career

Successfully implemented Email Automation Macro for process improvement using excel VBA

Successfully implemented Ms-Access Database connectivity with forms using excel VBA

Consolidation of excel files into single workbook is done 

Time sheet prepared and implemented for Biometric Data

Time capturing Dashboard produced in google sheets which displayed the actual time, planned time and difference in RAG form

ORGANISATIONAL EXPERIENCE

Supertech Limited                Assistant Manager (HR-PMS-MIS) Dec 2019 – Till Date

Role:

Define and monitor KRA of Team Members. 

Maintain Quarterly PMS of employees. 

Generation of monthly collection Report(Using Pivot) and calculation of variable pay based on defined policies(if formulae) and conclude on applying  conditional formatting 

Generation of Monthly MIS.

Calculation of Variable pay(P4p) of Direct Sales Team based on standardized defined policies for the Bookings Received from monthly MIS.

Generation of Pivots for Daily Sales Activities on Weekly basis at sales head level.

Generation of Adhoc Reports for Collection Team based on seasonal new scheme Bonanza for achieving collection Targets.

Implementation of new policy for calculating P4P using Excel VBA.

Genpact India Ltd.        Process Developer (Analyst)                 Dec 2015- Feb'18

Role:-

Responsible for preparing cash flow statement

Responsible for performing variance analysis & presenting ratio Analysis of company’s Financial Figures.

Responsible for making voucher entry in sap and extracting MTD,YTD Reports During month end closing using Tcodes

Responsible for fetching raw data through different technologies and analyze to prepare insightful reports

Responsible for Performing data cleansing in excel after reconciling the data flowing from various sources and updating in data warehouse during spend analysis.

Responsible for implementing packages using pl/sql on requirement

Responsible for supplier evaluation and Assessing the Risk using RAG Score using Excel and thereafter producing Pivot reports and charts and sending Emails to client

Responsible for extracting report from SAP using T-codes to Excel and send to client after editing in necessary format 

Responsible for Highlighting deviations for discussion with requesters before PRs Approved by me and other Stakeholders through online chat process

Organizing and attending a special conference call with the stakeholders l for the PRs above $100k,or if the stakeholder is available online then online chat process is initiated

Analyzing Purchase Requisition and Approving for the preparation of purchase orders in PR To PO Process

Making and issuing Purchase orders based on quotations to the selected suppliers.

Following up with the suppliers for order confirmation.

.