VICKRAM NEWAR

***/**, ***** ******, ****** – **, Khandsa Road, Gurgaon – 122001 (Haryana) · 965-***-****

Email · adfrpq@r.postjobfree.com

Highly energetic MIS Analyst (Data Analytics) with 8+ years of professional experience in the industry. Seeking a role where responsible for Analysis and supporting to the higher management. Seeking a challenging position in a reputable organization to expand my learning, knowledge, skills and experience. A highly organized and hard-working individual for a responsible position to gain and explore experiences within the Industry.

EXPERIENCE

DATES FROM APR -2017 – TO MAR 28 2020

SR. EXECUTIVE – FINANCIAL DATA ANALYSIS, FAREPORTAL INDIA pvt ltd

Responsible for Daily Agent Productivity Reports, Handling Daily Charge-back Analysis, Fraud Analysis Reports, Daily Absorption reports. Hourly Charge-Back Analysis Report. Comparison Report over Daily Sales vs Won/Loss/Exposure Report summary, Debit Memo reports, Financial P&L Statement Analysis, Monthly Expense schedule, Revenue Analysis Dashboard, Report Automation, Deduction Tracker Reporting, ER Monthly Activities Analysis reports. To automate other departmental reports through VBA Macro-coding. Responsible for organizational Budgeting and forecasting on HC, Cost (Salary, Bonus, Incentives and other Employee Expenses). Global Revenue analysis and reporting, Creating PowerPoint presentation for MBR (Monthly Business Review). Report migration from Excel to Power BI, by Data consolidation automation from various data sources within the Organization. Tracking Budget vs. Actual spends for Capex and Opex related expenses. Periodic GL account reconciliation/analysis. Assure data integrity and accuracy. Oversee and manage the continued development of Financial Plan, Forecasting and Modeling tools, Microsoft Dynamics (Navision).

DATES FROM JAN -2014 – TO JAN -2017

BUSINESS ASSOCIATES, worldwide business management outsourcing

Responsible for Daily/weekly/monthly Statement reports, Publishing Interactive Dashboard over Daily Sales vs Daily Target. Revenue Dashboard and Lost prevention. Creating Daily Absorption over Win vs Loss Comparison report. Import and Export Documentation, creating work orders into CRM and communicating with the partners and drivers for smooth delivery process. Invoicing into the partners website and following up for the payment with the clients. Connecting with the Shipping Port Executive for smooth entry and reservations for the Trucks. Communicating with the vendors and customers for any kind of Loss and Damages of containers. Basically, I was responsible for Maersk Line and Hapag Lloyd customers since they large volume of containers coming into the Shipping Port.

DATES FROM JUNE – 2010 – TO JAN-2014

BUSINESS ASSOCIATE, infinity e-services pvt ltd

Responsible for Daily Sales report and Tracking Daily Agents Sales using CRM software where lead made by the Agents. Responsible for revenue Dashboards and Sales Data Analysis to support Organizational Decision making.

EDUCATION

2003 - Class x, jawahar navodaya vidyalaya, jnv william nagar, east Garo hills, meghalaya.

2005 - Class XII, jawahar navodaya vidyalaya, jnv william nagar, east Garo hills, meghalaya.

2009 -BBA, SIMTS, New delhi

ANALYTICAL SKILLS

Develop records management processes and policies

Identify areas to increase efficiency and automation of processes

Set up and maintain automated data processes

Identify, evaluate and implement external services and tools to support data validation and cleansing

Produce and track key performance indicators

Develop and support reporting processes

Monitor and audit data quality

Liaise with internal and external clients to fully understand data content

Gather, understand and document detailed business requirements using appropriate tools and techniques

Design and carry out surveys and analyze survey data

Manipulate, analyze and interpret complex data sets relating to the employer's business

Prepare reports for internal and external audiences using business analytics reporting tools.

Provide sector and competitor benchmarking

Excellent numerical and analytical skills.

Finding out the possibilities for process Automation using VBA and other tools.

Knowledge of data modelling, data cleansing, and data enrichment techniques.

The capacity to develop and document procedures and workflows

The ability to carry out data quality control, validation and linkage

An understanding of data protection issues.

The ability to produce clear graphical representations and data visualizations.

ACHIEVMENT

Awarded with Shining Star Q4, for automating 4 Best Reports for the

Process development to achieve Monthly Goals. This helps in reducing

Human intervention and analysis with one click.

CERTIFICATION

SQL/PLSQL Course from Web Jyoti.

Advance excel and VBA from Advance Excel Institute.

POWER BI – Data Modeling and DAX Analysis, Tableau, Digital Marketing Certified

Learning Business Intelligence from Udemy Online.

Contact this candidate