PRAVEEN JAMPALA
BANGALORE,Karnataka
Summary
14 years of experience in Reporting & Analysis that includes evaluating large-scale data, performing analysis, visualizing information and designing dashboards. Expertise in determining end user needs, mapping clients’ business requirements, converting highly business oriented information into clear, concise technical view for effective development and support. Quality experience in providing highly effective MIS and Analytical Reports. Bridging the gap in domain understanding between the client and technical team. Working with the development team to get the bugs fixed. Good knowledge on SQL, Analyzing and visualizing the data in Power BI. Knowledge in developing basic report generation logic using Python. Demonstrated ability to extract, transform, and analyze data from various sources to generate informative reports. Experienced in utilizing libraries and frameworks such as Pandas, Matplotlib, and Seaborn to visualize and present data effectively. Skilled in customizing report formats and automating report generation processes for improved efficiency. Created Python scripts to automate the extraction of data from databases and APIs for report generation. Developed data preprocessing pipelines to clean and format raw data for accurate reporting. Implemented data aggregation and summarization techniques to provide valuable insights in reports. Working Knowledge in python for automating Daily tasks supporting from other data source like Excel. Preparing Automated Excel for clients for daily update report through Excel development tools like Power Pivot. Preparing stimulazied queries to retrieve the data from the Source as per business requirement. Maintaining internal DB to publish dashboards/presentations on time & maintain the data accuracy. Ad-hoc reporting, competition product & behavior analysis.
Overview
14
14
years of professional experience
Work History
Specialist in Sales Reporting and Analysis
Mobily InfoTech Pvt. Ltd., (Etihad and Etisalat Co)
09.2016 - Current
- Working closely with business and Consumer teams and programs to identify, define and document analytical reporting needs baseline problem statement through deep dive analytics
- Consolidating information into cohesive and insightful analytical reports for use in decision-making
- Gathering and maintaining wide array of data-related business processes and reporting that involves both entering information into existing databases and creating new processes and programs to accurately input and store critical data
- Designing reports as per client requirements and creating reports using MS Excel and SQL Database
- On demand/standard reports to be prioritized and provided wherever necessary within agreed timelines
- Contacting and communicating with stakeholders of project and deliver desired output in conformance with client expectation
- Internal and External tables are loaded, checked, maintained, and updated with latest records and accurate
- Quality of documentation of scripts and reports/dashboards (to be clear, organized, accurate, and comprehensive)
- Providing Analytical Support for Business/Consumer Marketing through Analysis, Revenue Forecasting and Adhoc business solutions
- All raw reports, which has to be delivered on daily basis for more than 60 days, has to be automated
- Assisting in analysis preparation and consolidation of Bi-Annual Budget and Planning; analyzing and interpreting monthly variances and trends between budgets, actual and prior results in developing projections and forecast
- Acting as liaison between program managers, technical analysts and functional experts to provide suitable business solutions and project tracking
- Identifying system and process improvement opportunities which will positively impact client.
Executive in Process and Business Intelligence and Management Information Systems
IFFCO TOKIO General Insurance
02.2011 - 08.2015
- Working in Corporate Office and reporting directly to Executive Vice President–Business Intelligence and MIS
- Overseeing smooth execution of Planning and controlling all MIS activities as per the information needs of the Branch, Department Heads, Operations Committee as well as Marketing and Underwriting Departments of Company
- Serving as point of contact between MIS Department and Business Heads and Department heads within the company by retrieving key information
- Preparing Adhoc Reports according to User Requirement by using Toad, Qlik View,Db2 tool
- Preparing Daily Reports from Siebel using Toad and submitting to End Users
- Coordinated with owners of company metrics to ensure consistency on key performance measures
- Designed and documented the processes of metrics production
- Facilitated discussions on target setting and controlled the groups in a team
- Compiled and distributed conclusions into executive materials such as presentations and boot camp activities.
Education
Bachelor of Science - Information Technology
Nimra Institute of Science & Technology
Vijayawada04.2010
Skills
- Reporting & Analysis
- Dashboards & Data Visualization
- Process Improvements
- Project Execution & Support
- Requirement Gathering & Analysis
- Business Support System
- Client Relationship Management
- Business Intelligence Analytical Support
- Power BI
- SQL
- Teradata
- Python
Databasetools
Teradata
Othertools
- MS Word
- MS Excel
- MS PowerPoint
Knowledgepurview
- Experience handling KPI’s in Telecom and Insurance Domain
- Good Experience in working on Subqueries which help to stimulate the fast execution
- Enhancing Knowledge in Power BI and having knowledge on and visualizing the data
- Creating different visualizations using Bars, Lines and Pies, Maps, Bubbles, Tree maps and Highlight tables
- Developing aggregates, hierarchies, charts, filters, quick filters, table calculations, and trend line calculated measures
- SQL & Database concepts and capability to write complex queries
- Using MS Excel for Report generation, creating business objects for automation and scheduling daily, weekly and monthly reports
- Understanding the business issues and challenges of the organization. Suggesting areas of improvement.
- Reviewing and editing business requirements, specifications, business processes and recommendations related to proposed solution.
- Working in the Business Intelligence team in analyzing the company financials and arriving at desired solutions.
Functionalarea
- IT Telecom
- Insurance
Personal Information
Date of Birth: 05/05/1988
Timeline
Specialist in Sales Reporting and Analysis
Mobily InfoTech Pvt. Ltd., (Etihad and Etisalat Co)
09.2016 - Current
Executive in Process and Business Intelligence and Management Information Systems
IFFCO TOKIO General Insurance
02.2011 - 08.2015
Bachelor of Science - Information Technology
Nimra Institute of Science & Technology
Similar Profiles
GAMAL ELDIN BADAWY MOHAMEDGAMAL ELDIN BADAWY MOHAMED
Director Technical Business Solutions Design at MOBILY - Etihad EtisalatDirector Technical Business Solutions Design at MOBILY - Etihad Etisalat
Hissah AldolaimiHissah Aldolaimi
Senior Legal Researcher at Etihad Etisalat Company (Mobily)Senior Legal Researcher at Etihad Etisalat Company (Mobily)
YASIR HAFEEZYASIR HAFEEZ
Big Data and BI Automation Principal at Etihad Etisalat MobilyBig Data and BI Automation Principal at Etihad Etisalat Mobily