Gopal Seelam
Email: gopal.vba1@gmail.com Mobile : 9966 225 224
SUMMARY
6 year 6 months experience in MIS Reporting, Analysis, Automation,
Hands on experience on SQL
Hands on experience on VBA Macros
Knowledge on Tableau
WORK EXPERIENCE
May’2019 – Till today
Sr. MIS Executive (Marketing Team)
OpenPlay Technologies Pvt Ltd (Inno Park)
Job Responsibilities:-
Write and Develop the SQL Queries to Retrieve the data for Daily Reports
Prepare Summarized Reports (Daily, Weekly, and Monthly) and update the Business
performance to the Reporting head.
Prepare and Analyze the Business Trends Based on States (GEO Wise).
Update all reports in Google Sheet.
Deals with Client about the budgets and Performances.
Preparing Affiliate, SEO, SMM, Google Ad wards and Kofluence Reports
Planning & budgeting the weekly and monthly targets And Analyze the performance as
well.
Implement and update daily dashboards.
Maintain the trend of Business, prepare and execute actions needed.
Accuracy on timely communication and ADHOC reports.
Active participation in weekly business reviews, preparing reports and analyze the financial
parameters for reviews.
Produce descriptive statistic reports using graphs with the help of Pivot Charts, Data
Validation and filtered data (Pivots) in MS-Excel and present the reports.
V-LOOKUP, H-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF(S),
COUNT IF(S), INDEX, MATCH, COMPLEX FORMULS and mixed functions.
Apr’2017 – Oct’2017
Feb’2018 – Apr’2019
MIS Executive (Finance Team)
ANI Technologies (Ola cabs)
Job Responsibilities:-
Automated daily reports & data from Database server and share with top level Management.
Analyze & Monitor the performance of Business on several parameters.
Implement and update daily dashboards.
Day on Day Hour on Hour Business reviews
Maintain the trend of Business, prepare and execute actions needed.
Calculate and process Incentives/Bonus daily/weekly/fortnightly/Monthly
Taking care of Third party Vendor in regard with Payments
Accuracy on timely communication and ADHOC reports
To Maintain consistency on Supply, design supply schemes and Analysis
To Maintain quality assign calling sheets and monitor their performance week on week
Active participation in weekly business reviews, preparing reports and analyze the financial
parameters for reviews
Produce descriptive statistic reports using graphs with the help of Pivot Charts, Data
Validation and filtered data (Pivots) in MS-Excel and present the reports.
V-LOOKUP, H-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF(S),
COUNT IF(S), INDEX, MATCH, COMPLEX FORMULS and mixed functions.
Planning & budgeting the weekly and monthly targets
Please Note- From Nov’2017 to Jan’2018 I have worked Berkadia Services Ind Pvt Ltd for a
Short Period (3 Months).
Sep’2015 –Mar’2017
MIS Executive (Finance Team)
Palred Online Technologies Pvt. Ltd., Hyderabad.
Job Responsibilities:-
Extracting data from Database (SQL) and consolidate data using EXCEL to prepare meaning full data
to the management.
Stock reports.
Preparing Sales Reports on daily, weekly, and monthly basis.
Reconcile of Vendor’s (Accounts Receivables) Accounts and Follow up for Payments from Vendors and
pass Journal Entries in ERP (Tally).
Produce descriptive statistic reports using graphs with the help of Pivot Charts, Data Validation and
filtered data (Pivots) in MS-Excel and present the reports.
To do the comparative analysis & document the reports for the higher management using functions
like V-LOOKUP, H-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF(S), COUNT
IF(S), INDEX, MATCH, COMPLEX FORMULS and more.
Generating reports requirement by Management.
Bank Reconciliation.
Journal entries posting.
Jan’ 2015 –Aug’2015
Accounts (MIS) Executive
Anukar ProjectsPvt Ltd, Hyderabad.
Job Responsibilities:-
Bank Reconciliation.
Journal entries posting.
Preparing Stock reports.(Sand, Iron, Bricks etc)
Goods received/invoice received clearing.
Performing of Balance sheet reconciliation.
Extracting data from TALLY and consolidate data using EXCEL to prepare meaning full data to the
management with the help of ADVANCE EXCEL.
Produce descriptive statistic reports using graphs with the help of Pivot Charts, Data Validation and
filtered data (Pivots) in MS-Excel and present the reports.
To do the comparative analysis & document the reports for the higher management using functions
like V-LOOKUP, H-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF(S), COUNT
IF(S), INDEX, MATCH, COMPLEX FORMULS and more.
Generating reports requirement by Management.
PERSONAL SKILLS AND QUALIFICATIONS
Certified Microsoft Office Specialist (Core) Excel 2015
Analytical, problem solving and troubleshooting skills
Adaptable to work for long periods without losing patience and enthusiasm
Ability to work on own initiative and as part of a team
EDUCATIONAL BACKGROUND
CA Inter(Group-1),2011 from ICAI
Bachelor’s Degree in Commerce,2008 from S.K. University, Ananthapur
CERTIFICATIONS
Information Technology Training (ITT) from ICAI
Microsoft Office Specialist certified by MICROSOFT
PERSONAL DETAILS
Father’s Name : Parusha Ramudu S
Date of Birth : 10th July, 1987
Marital Status : Married
Languages Known : Hindi, English & Telugu
Address : 520, Plot 10, Sri Durga Apartments,
SR Naik Nagar, IDA Jeedimetla,
Hyderadab - 500055
I hereby declare that the information given above is true to the best of my knowledge.
DATE:
PLACE: HYDERABAD (Gopal Seelam)
