[EZLINK] Resume for Manager - MIS Reporting Analyst, Willing to work in Singapore. MCA
Ranjana Batra
U-12/23, DLF Phase-3,
Opp. Microsoft Bld.
Gurgaon, Haryana, India
Ph: 09818491738
Email :
ranjana_batra@hotmail.com
Academic Qualification
Masters in Computer Application (MCA) from IGNOU IN 2003.
Pursuing MBA - Finance
B.Com from K.R.G. College, Gwalior with 75%
Professional Qualification
Certificate in Computing from IGNOU.
Diploma in Software Technology from CMC Ltd.
Diploma in Computer Programming & Application.
Certificate Course in Oracle 8 with Visual Basic 6 from SSI Ltd.
Certificate Course in JAVA & Adv. JAVA from E-Biz Technologies.
Others
PMI Certified Project Management Course from AstroWix Project
Management Institute
Six Sigma White Belt Training and certification
Six Sigma Green Belt Training
Professional Experience
WNS Global Services from 14th
May06 till date
Working as a Manager-MIS
Agilent Technologies from 1st March 03 – 6th May 2006
Working as Sr. MIS Reporting Analyst
Magnum Software Solutions Feb 2003 to Sep 2003
Worked as a Software Programmer
Others – 5+ years of working experience.
Thorough knowledge of Brio Reporting & Data Warehousing Concepts.
Have a valid 10 years business VISA of US
Traveled to US and Malaysia couple of times for Projects and
Trainings.
Current Responsibilities
· MIS Reporting and analysis for Indirect Spend ( Brio Hyperion
Tool )
o Understanding the Business and its Requirements
o Gathering the requirements from user
o Creating Channel MIS Reports
o Extraction of data from Data Ware housing tables
o Preparing graphs using he modified data for business analysis
o Coordinating the production of monthly, quarterly, and annual
performance reports for senior management.
o Indirect Spend by Business Groups
o Monthly , Weekly & Daily Report Creation
o Creating MIS Reports and Analysis for sourcing managers
across the globe
o Maintaining supplier compliance across the regions.
o Testing on data models in Brio
o Preparing dashboards for the regions.
o Worked as a support in designing and reforming travel
policies on the basis of the analysis done. Was part of the expense
review project.
o Also involved in the automation of the reports.
o Involved in cost saving analysis for the organization.
o Analysis of Spend by Regions and producing actionable
information.
o Producing Cost Savings Report
o Producing Balanced Scorecard for 17 different metrics
· Re-Engineering the existing processes – reengineered EAR
process
o Evaluate the existing process
o Finding out the anomalies, problems, TAT
o Finding out the solutions of the anomalies
o Work on reduction of TAT
o Taking feedback from the users
o Incorporate the changes and impart trainings.
· Part of Expense Audit Project
o Expense Audit Project for travel policy reformation (
Traveled to US and Malaysia couple of times on a project)
· Reporting for Supplier Rationalization (Global) – Checking
the supplier compliance and making sure the people are using the
preferred vendors and deactivating the suppliers hardly used.
· Working on EDW data models testing etc - Testing the
functionality of the data models designed in Brio and making sure
that the data is compliant with the requirement.
· Supporting Global Sourcing Managers - Supporting global
sourcing managers in various global projects and helping them
extracting data, creating reports and analysis as per their
requirements.
· Preparing dashboards for the different regions – Preparing
dashboards showing spend data trends, reasons for increase and
decrease in trend, finding out top suppliers for the company,
contracts with the suppliers and negotiating the contracts for the
company and closing the contracts not used further using Ariba.
· Managing Contracts
o Evaluating the contracts in Ariba
o Extracting spend data of the contractors
o On the basis of evaluation of the spend data with the
contractors , renew the contracts, renegotiating the terms of the
contracts as per the business need or close the contracts from Ariba
o Contact reporting
Projects in Agilent
1. Competitive Bid Process :
Explanation : To identify and analyze POs raised over the
competitive bid limit established by the organization.
Tools : Brio Reporting Tool, Ms Excel, Ms Access, Oracle Application
2. Supplier Rationalization.
Explanation : To identify and analyze all the active and in active
suppliers from the last 2 years so that inactive suppliers can be
deleted from the yellow pages of preferred suppliers.
Tools : Brio Reporting Tool, Ms Excel, Ms Access Oracle Application
3. Expense Policies Reformation Project in US
Explanation : To reform the expense and travel policies and to
identify the cases where these policies are misused
Tools : Dedicated tool designed in Visual Basic and Ms Excel by using
Macros
4. White Belt Project related to automation of Indirect Spend
Reports.
Explanation : Project is based on atomizing daily indirect spend
report and weekly report. TAT of Daily Indirect Spend report reduced
from 30 mins to 5 mins. TAT of Weekly Indirect Spend report reduced
from 45 mins to 6 mins.
5. Expense Awareness report project for EMG and SPG group
Explanation : Project is to generate Expense Awareness report for EMG
and SPG group. Just on a click of a button it generates different
expense reports for various departments which is to be sent to
different groups. It generates the reports which is to sent to around
160 managers.
Tools : Brio Hyperion Reporting Tool, Ms Excel, Visual Basic
6. Automation of EAR Tool – Green Belt Project
This is a web based tool for designing and analyzing Expense
Awareness Reports. This keeps track of Employee Expenses related to
travel and other expenses. This tool generates 168 reports with
analysis and converts the reports in PDF format and send it to
controllers.
Tools: Excel, MS-Access & ASP
Software Development Experience: 2 Years
Modules Covered
Operating System Ms Dos 6.22, Unix, Windows'95, Windows'98,
Windows 2000
Application Softwares Ms Excel, Power Point, Ms Word ,
Visual Basic 6
DBMS & RDBMS Hyperion Brio ( data extraction tool )
Dbase, FoxPro, Ms Access, Oracle 8 ( SQL, PL/SQL, Forms, Reports,
ODBC ),
Prog. Languages `C', Advance `C', HTML, `C++', Basic,
COBOL,
Fortran, Pascal, Assembly
Language.
Networking Networking Concepts, Windows
NT 4
(With Installation and administration)
Others Internet, Multimedia, Minitab
Date Of Birth 19-12-77
Hobbies Listening Music, Traveling, Computers, Reading latest
Advancements in Computer Field.
Achievements Also Written Computer Course Books ( NCERT ) up to
8th Class
White Belt Project – e-reporting
Green Belt Project – e-reporting@EAR
Personal Traits Sincere, Dedicated, Enthusiastic about new
assignments and projects , Honest, Ability to work with team or if
required as an independent player.
Date:
Place: Gurgaon
Ranjana Batra
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ezlink/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ezlink/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:ezlink-digest@yahoogroups.com
mailto:ezlink-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
ezlink-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to: