Summary




7 years of full scope experience as a Business Analyst in online services, healthcare, television media and not-for-profit.
Developed monthly and quarterly reports that showed revenue growth and performance for AdCenter, Search, Display, Windows Live Services and Windows Mobile using SQL Server Reporting Services 2005, Access and Excel.
Expert understanding of Excel with advanced functions, filters, pivot tables and complex formulas.
Designed and prepared accurate and timely monthly, quarterly and yearly financial analysis reports using SQL Server Reporting Services 2005 and Crystal Reports.
Experience with database software like, MySQL, FoxPro and performing database builds and utilization.
Experience extracting data from a large database using SQL or Access and creating various reports.
Maintained the SharePoint sites by updating the report folders with current reports and updating the document library with internal memos and corporate policies in different formats like Word, Acrobat PDF or HTML.


Employment

July, 2008 -  December, 2008
Role Business Analyst

Work with key stakeholders, end users and project team members to identify and resolve issues throughout project phases of assessment, design, build, testing, training and implementation using SDLC.

Work with the project manager, business visionary and end users, IT architects and developers and project sponsor to define business requirements and to map them to the product s vision or objective to in turn find a solution.
Documentation

Write requirements specifications for report development according to standard templates, using natural language for the Online Services Business with emphasis on defining revenue drivers and volume in terms of revenue per thousand impressions for a given rate. The reports include but not limited to, Revenue Summary reports and Scorecards.

Decompose high-level business requirements for AdCenter, Search, Display, Messenger and Windows Live Services into business requirements, specified in an appropriate level of detail suitable for use by report developers who base their work on the requirements and by the solution development team members.

March, 2008 -  July, 2008
Role Senior Financial Analyst

Responsibilities :
Participated and collaborated in financial analysis with the financial team to support and improve the clinical operations decision making, benchmarking, budget planning, closing/ performance monitoring, revenue/ charge setting, cost accounting process, government reporting and other analysis for decision making.
Extensive use of Excel 2007 to create solutions for complex business reporting needs, ad hoc reporting needs under time constraint.
Professional graphical analysis designed for team, organizational and senior management presentations and team collaboration sites.
Managed complex reporting spreadsheets for scorecard analysis of organizational initiatives worldwide, using multiple data sources, financial and people data and incorporating business rules governing compliance of people structures advanced formulas, no VBA by request.
Through project planning with finance directors and analysts, built financial models to guide management in decision making.
Data extraction, advanced pivot tables, trend analysis and variance reporting.
Developed budgeting and forecasting reports as supplemental tools.
Developed and maintained systems to provide clinical operations/ management with financial data and metrics to enable short and long-term decision making.
Gathered data from a variety of research resources, external research entities.
Developed tracking database to provide reliable, timely information.

July, 2006 -  February, 2008
Role Business Analyst

Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
Collaborated with Business Owners, external ad agencies, third-party technology distributors to facilitate communication for successful project launches.
Conducted business analysis, project assessment and feasibility determination. Analyses of data feed requirements for MSN products and applications used to reduce outsourced fees.
Scoping or Documentation

Translated project requirements into project objectives and tasks, facilitated task assignments to project resources and monitored and reported on tasks and developed detailed project schedules, resource plans, status reports and contributed to the effectiveness of the project team.
Strategized project scoping and business requirements documents, to communicate the project roadmap.
Quality Assurance
Participated in peer reviews and inspections of requirements documents and participated in peer reviews of reports derived from requirements specifications to ensure that the requirements were interpreted correctly.
Reporting
Developed monthly and quarterly reports that showed revenue growth and performance for AdCenter, Search, Display, Windows Live Services and Windows Mobile using SQL Server Reporting Services 2005 and Excel.
Managed the monthly Scorecard process.

Documented data structure, generated SQL Server 2005 SQL queries and provided user support production training.

June, 2005 -  June, 2006
Role Revenue/Data Analyst

Revenue Operations and Strategic Planning
Investigated and analyzed areas of Revenue loss in the area of Ad Delivery, outside vendors, agencies and internal procedures and sales programs.
Partnered with analyst efforts, to assist Ad Production and Ad Systems teams in assessing inventory and revenue implications of new technologies.
Retrieved site metrics, impressions delivered, for various websites that were served by third party advertising.
Created internal reports for Advertising Account Managers to compare 3rd party impression delivery reported by the Walt Disney Internet Group.
Conducted daily variance investigation and analysis.
Projects included providing quality assurance of live sponsorships on ABCNews.com and providing daily ABCNews and ABC.com Video ad impression metrics.

January, 2002 -  June, 2005
Role Data Business Analyst

Financial Systems
Data Analysis
Provided support and analysis of data collection, mapping and aggregation and balancing functions.
Analyzed data to identify trends and provide potential root cause analysis and recommendations.
Provided continuity and accuracy in reporting by validating and testing data, identifying missing/erroneous data, disparities/inconsistencies between data sources and validating accuracy/consistency with stated business rules.
Creating automation of reporting processes using Excel, Access and VBA.
Worked as a Excel Developer and developed applications to enhance business processes.
Performed statistical analysis to support 6 Sigma teams in establishing appropriate baselines.
Business Analysis
Defined the organization's strategic goals and purposes and determined the organization's customers or stakeholders to align the business processes to realize the organization's goals.
Responsible for the design, preparation and delivery of accurate and timely monthly, quarterly and yearly financial analysis reports using SQL Server Reporting Services 2005 and Crystal Reports.
Developed business rules, developed and refined SQL Server 2000 database architecture.
Financial Analysis
Partnered with Financial Analysts to conduct periodic analysis of General Ledger and P and L performance vs. budget and prior year, focusing on identifying controllable and providing recommendations for resolution to the management team.

Managed the budget process with finance team for defined areas of responsibility, analyzing the submitted budget figures ensuring completeness and accuracy and assessing risk for the completed budgets, validating and communicating all actionable alternatives to achieving the established targets.
Managed the monthly forecast process for the current period and full fiscal year, detailing performance variances and corrective action.
Maintained the ERP finance database system.
Converted statistics into meaningful graphs, charts and presented the information to all levels of staff and management.

March, 1998 -  December, 2001
Role Senior Accountant

Responsibilities : Responsible for maintaining and enforcing the Company's revenue recognition policy by analyzing contracts to ensure proper revenue recognition compliance.

Education

Skills


Customer liaison, researcher, Other software : Project, SQL Server 2000/2005 : SAP, SQL Server Reporting Services 2000/2005, Access, Data warehousing, Crystal Enterprise and Crystal Reports, Office Suite, Share Point.


Miscellaneous

Implemented and maintained the required process and internal control environment and performed control procedures, like approval of product discount pricing, VSOE studies and monitoring activities and PCS significance analysis, to ensure business units are complying with company policy and are recording revenue. Interpreted SOP 97 - 2, SAB 104 and related guidelines.
Analyzed results of product and client profitability, identifying areas for research and possible action suggesting methodology refinements for continual improvements.
Hinkwale Malawo________________________________________________________________Professional Resume
m
3