Assistant Manager
Apollo Hospitals Enterprise Limited
Total years of experience :18 years, 0 Months
Supported the objectives of the Reporting and Analysis
•Provided business solution in term of designing excel dashboards, upgrading exist Reports and enhancing performance of the Excel Reports.
•Automated Reports with excel macros wherever required and to avoid manual stesp.
•Liaised with different teams across the group in designing Human Resources planning solution using excel dashboards and report.
•Extracting data from the Oracle database using SQLTechniquesand preparing adhoc reports to Top Managemt
•Designed Dashboard layouts, developing reports with complex formulas, and delivering them on tight dead-lines with high accuracy.
•Modifying the existing templates to suit to the adhocrequirement and debugging the excel formulae and macro code.
.
Steelwedge (Payroll of TechMinfy
As a
As a Technical Sales Reporting Analyst, support the objectives of the Reporting and Analysis
•Center of Excellence (COE) by delivering manual and automated reports.
•Interacting with Business Units across the globe through relationship teams and develop and/or modify business critical reports based on stakeholder requirements.
•Liaise with teams across geographies. Independently develop reports for different brands of IBM.
•Drill down to the root cause of erroneous reports and analyze the variances.
•Document SOP’s, best practices and trouble shooting guides.
•Strictly adhered to timelines and SLA’S.
•Job responsibilities included to work with Cognos Developer and will be responsible for the Transitioning legacy reports to Cognos Business Intelligence solution.
•Learning and Working on Hyperion, BRIO and Cognos and Essbase addins for the report generation and automating reports using in-house tools depending on scope and requirement.
•Liaise with Business Analytics Advisor/ Sales leaders and development team to understand the new requirements QA the Project Qualified tracks.
•Transitioning reports to SR CoE from other teams which fall in within the scope.
•Responsible for report enhancements/ maintenance..
•Provide inputs and guidance on daily execution to ensure accuracy and timeliness on Process Operations.
•Ensure Business Compliance. Manage service level compliance and inform manager of out-of-line situations.
•Report on potential problems and out of line situations
•Working with business users to design and develop Cognos BI 10.2 reports using Report Studio with data drill-down and slice-and-dice options
•Monitored Automation server for successful running of the automated tasks.
•Develop and implement test plans to ensure successful delivery of a project
Analyzing Business unit (Monstergulf.com) status in terms of the Revenue across all the products, Teams and Regions
• Managing the central repository of information for various products of the company.
• Managing the central repository of sales data and coordinating with different teams across the organization for the same.
•Writing customized macros depending on the requirements for the analysis of the products.
•De-duplicating the data from Marketing team and passing the same to the telemarketing team for Lead Generation.
•Preparing daily, weekly and monthly metrics reports for the performance of voice calling data across teams of telesales and telemarketing.
•Preparing daily, weekly and monthly performance reports of teams of telesales and telemarketing in Monster gulf.
•Preparing Adhoc Reports for Top- Level Management as on need basis
•Pulling out Data-Dumps from Business Objects and Seibel-CRM for Data analytics using SQL Techniques
•Working with “Advanced Excel” with Filtering and Scripting Macros and VBA Programming.
•Providing data for Mass-Communication mailers for the corporate teams for telemarketing activities
Analyzing historical and current Business Unit status in terms of the customer base across all the products and segments across all the cities
•Analyzing Company status in terms of the Revenue across all the products and segments across all the cities
• Managing the central repository of information for various products of the company
•Writing customized macros depending on the requirements for the analysis of the products.
•Preparing daily, weekly and monthly reports for the performance of of the data voice and fixed line business.
•Preparing the rate plans and calculating Equity ratio for launching of new plans for corporate customers
•Acting as single point of contact for the information of the customer base and revenue across all the products and segments across all the cities
June
•Responsible for all activities related to launch of other towns
•Analyzing Company status in terms of the customer base across all the products and segments across all the cities and revenues for the same.
•Organizing several Market Research surveys depending upon the needs and analyzing the data of the same.
•Driving micro level rollout of telecom services in a city within committed timelines.
•Conducting primary & secondary market research to assess revenue and demand potential
•Doing survey on new product launch, schemes of TTSL and other competitors.
Providing ongoing MIS support to all other groups to resolve operational issues related to network rollout
•Wireline Rollout Survey: Was a part of the wire line survey team, which identified potential wire line buildings in Hyderabad and submit recommendation on DP capacity in respective buildings.
• Migration: Assisted Marketing & other groups to successfully migrate UT DEL’s &PTB’s to wire line.
•Data Collection: Assisted TTL in gathering information on SDCA’s, data on Leased circuits, city demographic information as part of the market demand estimation
• Analyzing competitor data to support Sales and Marketing decisions using Oracle Discoverer.
• Managing the central repository of information regarding network coverage and capacity for the company
•Maintaining entire MIS of the Department.
•Coordinating with all the Departments such as Planning, Design, Construction & Network for proper implementation of the rollout.
•Organizing and Taking part in Brand promotional activities of the company.
•Working with event management organization, internal departments and sales teams for managing events.
Visakhapatnam in the project of implementing Computer Education in various Govt Educational Institutions
(