[go: up one dir, main page]
Scribd
Upload
195 views8 pages

Mis Executive

Hari has over 3.5 years of experience in Management Information Systems using advanced Excel, macros, and SQL. He has expertise in generating timely and accurate daily, weekly, and monthly reports for analysis using Excel pivot tables, lookups, and other formulas. Hari also has strong skills in macros and VBA, including automating workbooks, opening/closing files, and creating user forms. He has worked with databases like Snowflake, handling tasks like data loading, queries, and report generation.

Uploaded by

Hari Kappera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
195 views8 pages

Mis Executive

Hari has over 3.5 years of experience in Management Information Systems using advanced Excel, macros, and SQL. He has expertise in generating timely and accurate daily, weekly, and monthly reports for analysis using Excel pivot tables, lookups, and other formulas. Hari also has strong skills in macros and VBA, including automating workbooks, opening/closing files, and creating user forms. He has worked with databases like Snowflake, handling tasks like data loading, queries, and report generation.

Uploaded by

Hari Kappera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 8

Hari

Mobile: +91-8310707270 E-mail: kapperahari555 @gmail.com

3.5 Years of Experience in Management Information System (MIS) using Advanced Excel,
Macros, SQL .

Career Summary:

● MIS reporting using Advance Excel extensively at operational and client level
● Implement and analysis data to create daily, weekly, and monthly reports
● Generate timely and accurate reports for analysis. Creating MIS report and presenting it

to the concerned Department

● Central data Co-ordination point with key departments and ensuring that deliverables

are met

● Generated Excel Pivot Tables and used various Lookup functions for mapping
● Design reporting formats to provide accurate information in a clear and concise manner
● Implementing new strategies for better growth of the team

● Generating all kind of Templates for Tracking the data / for Analysis
● Maintain good relationship with Suppliers and clear the Claims. Designed and built the

reports using advanced Excel and VBA Macros

Macros (VBA)

● Automation of workbooks and sheets using VBA


● Opening and closing files from drives using VBA

● Hands on Experience on all data types

● Can write Sub and Function Procedures

● If and else-if functions

● Using For loop, Do Loop and Do while Loop

● Creation of User Forms

Professional Applications:

● Operating System : MS DOS, All Windows based OS

● Packages : MS Office (Word, Excel & PowerPoint),Vba,Power Bi

Technical Profile:

● Expertise working with Advance Excel

● Basics of Visual Basic for Applications(VBA) and Macros


● Vlookup, Hlookup, Index, Match,Choose, Indirect

● Formulas - Logical (IF, AND, OR, NOT), Arithmetic (SumIfs, CountIfs, AverageIfs)

● Text Formulas (Replace, Substitute, Find, Left, Search),

● Date Formulas

● Working with Pivot table, Slicers, Hyperlinks and Graphs

● Well-acquainted in working with complex SQL queries with Joins, Functions, Sub-
queries, Views and Set operators.
● Experience in writing complex SQL scripts using Statistical Aggregate functions and
Analytical functions.

● Good knowledge snowflake cloud database Used COPY/INSERT, PUT,GET com-

mands for loading data into Snowflake tables from internal/external stage.

● Good knowledge Experience in working with AWS S3 and Snowflake cloud data

warehouse.

● Good knowledge Created Clone concepts to maintain zero copies in Snowflake.


● Good knowledge snowflake features like
clone,table_types,task,snowpipe,snowsql,partitioing,,clusterining&performance
tuning,stream,datashare etc

● Good exposure in Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for
continuous data loading.

● Good knowledge informatica power center ETL tool


● Good knowledge power bi desktop, power query

Academic Profile:

● BTech from JNTU, Anantapur, with aggregate of 72% in 2014.

Professional Experiences:
Local-cube Commerce Pvt Ltd—MIS-EXECUTIVE-2020-2021

● Giving Targets and monitoring the achievements


● Create Monthly Attendance & Daily Expenses report using ERP tool
● Create quarterly Incentives report to the sales team
● Scheduling con-call to Managers for business review meeting
● Generating MIS reports on daily, weekly and monthly basis
● Coordinating with Sales team
● Daily Tracking STATIONARY, MOBILES, DIGITAL, MONEY TRANSFERS,

Category wise sales Data using Excel.

● Tracking QC complaints about products.


● Co-ordinate with the dispatch team for dispatch the stocks on time.

Swiggy.( Bundle Technologies Private Limited )- Mis Executive-ADS-FINANCE June2021-


Feb 2022
● Worked on commission master tracker based on restartent level
● Ld. monetization based on km wise price and city wise report
● Worked on Weekly base report tracking commission different partner’s with
● Calculated commission different partner in Weekly base report
● Different channel level calculated commission weekly supply review report
● Weekly tracking Weekly base report dashboard AND different classifier
● Worked on aiv (average item value) &Ain (average item net take)
● Generating MIS reports on daily, weekly and monthly basis
● Forecast working based on category Access,Bandwork,domino's pizza,natioanl,city
report in weekly report
● Worked on cancellation order in calculated in Weekly base report
● Worked on cloud database in snowflake pulling data into snowflake database
● Bulk loading from external stage (AWS S3) to internal stage (snowflake) using COPY
command.
● Loading data into Snowflake tables from internal stage and on local machine.
● Used COPY, LIST, PUT and GET commands for validating internal and external stage
files.
● Used import and export from internal stage (Snowflake) VS external stage (S3 Bucket).
● Writing complex Snowflake sql scripts in Snowflake cloud data warehouse to Business
Analysis and reporting.
Personal Profile:

Name : K.Hari
Father’s Name : K.Subramanyam
DOB : 25-06-1992
Marital Status : Married
Languages : English, Telugu, Kananda

I hereby declare that all the above-furnished information is correct to the best of my
knowledge

Place: Bangalore
Date: [K.Hari]

You might also like