Project Management & Tracking BI Reporting Solutions, Data Analytics

Payal Baheti

513-***-**** • *****.*.******@*****.*** • Chicago, IL • https://www.linkedin.com/in/payalbaheti

SUMMARY

• Overall 10+ years of experience in Business Intelligence, Project Management, Data Reporting,

Product Management and Business Analysis.

• Proven track record of managing, designing and integrating complex technical processes/projects

within high profile and deadline oriented environments.

• Experienced in both strategy and tactical management of BI projects as well as development and

operations side of BI.

• End to end data warehousing experience across full project life cycle from inception to

deployment.

• Deep knowledge of Business Intelligence, Data Modeling and Business Process Re engineering

methods.

• Solid experience leading planning, analyzing, requirements, designing, building, and testing

applications, to maintaining and modernizing legacy applications.

• Strong Data Warehousing skills including ETL and end user access issues.

• Experienced in Data Analysis and Reporting to various levels of management, including setting up

reporting according to senior management goals and ad hoc reporting.

• Outstanding record of implementing advanced technology to build innovative business solutions

and systems that work, change easily, and last.

• Proven strategic and big picture thinking skills.

• Always aligns organizational goals to project timelines which leads to tangible outcomes.

• Excellent analytical, problem solving, and decision making skills.

• Excellent verbal, oral, written communication and presentation skills.

• Exceptional interpersonal skills with ability to gain the confidence and respect of senior

executives.

• Proven ability to work with all levels of management, and the most senior of Subject Matter

Experts.

• Ability to work independently and organize workload with minimal direct supervision.

• Strong technical, management and leadership skills.

• Knack for finding ways to improve business processes and speed up time to market.

• Exceptional ability to learn new industries and business processes quickly.

• Experienced the challenges of ownership. Self driven and always strive for excellence.

STRENGTHS

• Masters in Information Systems with 4.0/4.0 GPA, Bachelors in Information Technology

• Industry experience in Digital Media, Legal, IT Consulting Services, Professional Services and

Intranet

• Awarded 2 times certificate of appreciation at Thomson Reuters for collaboratively working with

business team in identifying untapped niches and effectively executing plans to improve business

processes

CORE COMPETENCIES

• Project Management & Tracking • BI Reporting Solutions •

Data Analytics & Management

• Business Process Improvement • Data Warehouse Analysis •

Cost & Budget Estimates

Page 1 of 7

• Project Delivery & Methodology • Project Risk & Scope

• Database/System Analysis

• Information Discovery • Data Governance

• GAP Analysis

• Management of Cross Functional Teams • Agile Principles •

Product Development

• Change Control Management • Business Contingency

• Requirement Gathering

WORK EXPERIENCE

ONE NORTH INTERACTIVE – CHICAGO, IL

AUG 2012 – CURRENT

Sr. Technical Business Analyst

Acted as a BI Project Manager for a Business Systems team of 4 to deliver BI projects that provided

exceptional business value to the organization. Heavily involved in managing, planning & reporting

on project activities.

Role & Achievements:

• Created and executed reports that increased Hosting revenue by 20%; executed new product

plan in 2013; introduced and executed new contract and pricing plan in 2014.

• Managed & provided Financial Datasets, associated business intelligence and analytic

capabilities at organization level for leadership team to make superior decisions.

• Formulated a business strategy for migration of Hosting environments in 2015 to increase

efficiency and automating processes across all business areas into one project resulting in a much

stabilized operations.

• Provided continuous improvement feedback to teams resulting in increase of productivity by

14% and the quality of deliverables by 21%.

• Improved business processes with systematic analysis of data with regard to the organization's

historical performances and identification of key areas of improvement.

• Automated Monthly Operating Metrics Report for the leadership team to help them forecast,

budget and analyze the overall health of the organization.

• Guided upper management by implementing Corporate Dashboard Reporting Tool including

Total Utilization, Net Bill Rates, Backlog, Hosting & Services Revenue/Margin, and Employee

Turnovers.

• Lead and managed an enterprise wide effort of identifying the Key Performance Indicators

(KPIs) across all the domains of the organization.

• Provided Quarterly Services/Client/Project Profitability reports and revenue analysis by using

automated tools. Developed business intelligence dashboards and assisted in its integration on

multiple data platform.

• Act as single point of contact and subject matter expert/evangelist for Operations & Business

Intelligence for business improvements initiatives.

• Strategically planned and managed applications that collected business minded intelligence and

helped to better align the Business processes with the overall Business objective of the

organization.

• Created project plan & provided day to day project management supervision to communicate the

project path, timelines for project delivery, cost estimates & managed resources to successful

completion.

• Collaborated with Analysts and Project Managers on major initiatives, providing recommendations

on reporting opportunities that capitalize strengths and capabilities of the existing infrastructure.

Page 2 of 7

• Launched data quality improvement initiatives at organization level to establish Data

Governance & Stewardship and documented end to end data flow from the source systems to the

data warehouse.

• Ensured milestones were met in line with the schedule. Tracked issues facilitated resolutions and

provided weekly status.

• Performed extensive Data analysis and reporting on resource utilization management to

improve performance and identify risks and issues.

• Provided leadership insight to internal teams on projects and daily reports to internal senior

management.

• Conducted rigorous/fact based research and analysis on competitors from several data sources to

produce final recommendation strategy to increase the market leadership.

• Protected team from over commitment, manage backlog, and prioritize resolution of defects/bugs.

• Kept the team together all the time to ensure successful execution and provided visibility to

team impediments/risks and helped eliminate them.

• Managed go live activities and coordinated with other IT teams to ensure successful migration to

the production environment.

• Took over from Head of Operations to manage and coordinate Hosting Billing Operations

which includes Hosting contracts, billing and decommissioning of applications.

• Analyzed shortcomings of maintaining Hosting cancellations notes in spreadsheets and created

automated reports to categorize Hosting notes into systematic groups and faster client status.

• Manage overall project risk management framework, including investigation, escalation and

effective mitigation of identified risks.

• Provided leadership to introduce a results driven team and help mentor other departments by

facilitating regular knowledge sharing sessions.

• Successfully managed the transition of WebEx from GoToMeeting for the entire organization.

• Conducted a successful Hosting Fire Drill that validated the disaster recovery solution was

accurately configured and the production service group could fail over to the secondary hosting

environment.

• Managed migration of business systems to Microsoft Azure environment and make intranet

applications cloud based.

Technical Business Analyst

As a Project lead, successfully established One North Interactive's new business system infrastructure

and implemented enterprise wide initiative in Time Management and Task management tools as a

part of splitting from Thomson Reuters.

Role & Achievements:

• Educated and enforced best practices for BI design, development, and deployment. Guided the

team through the creation and maintenance of proper documentation for all deployed solutions.

• Lead Business Systems to report project status, risks and issues to senior management.

• Provided traceability across the project life cycle, tracking requirements status, managed change

and version control, and tracing requirements to other project phases and work products.

• Designed and implemented reports in SQL Server Reporting Services (SSRS) and Business Objects

to provide detailed revenue information to drive Service's product profitability, backlog and

utilization.

• Gathered legacy system requirements by shadowing Account Coordinators, Account Managers,

prepared questionnaires and interviews to quickly identify GAPS in the system.

• Worked as a liaison between the stakeholders to elicit, analyze, communicate and validate

requirements for business process changes.

Page 3 of 7

• Responsible for overseeing the projects requirements phase and facilitated meetings to create

Project Scope document, System Requirements, Requirements Traceability Matrix.

• Collaborated with stakeholders in all phases of the application development life cycle, including

functional requirements, technical design and user acceptance for support and enhancements to

existing applications.

• Identified the need to update organizations rate/role card to align with current organization

structure while staying in compliance with Client contracts.

• Assigned, tracked and managed project task and activities in MS Project, documentation, time

information for flexible resources and contractors.

• Designed efficient tools that that enabled all users to perform better and achieve their

monthly/yearly targets, in turn creating revenue for the organization.

• Acted as a Subject Matter Expert on Application knowledge for preparing training presentation,

Quick Reference Guides and assisting with any issues/questions that arose from training.

• Designed use cases and design for development of applications using MS Office Suite, MS Visio.

• Conducted regular Trainings for entire organization on available reports and business

intelligence to ensure that operations were efficient and smoother.

• Ensured Finance and Management teams have access to an efficient reporting system, an

upgraded Intranet with enhanced technology and reports.

• Created new processes and data audits/indexes to ensure business system data integrity and

improve overall performance.

• Demonstrated problem solving skills, delegating work, following up with Account folks and

coordinating various activities in the business.

• Provided market research comparison on various solutions that were beneficial to/implement

in our organization, to be able to make conscious choice of the product.

Environment: SQL Server Reporting Services (SSRS), Crystal Reports, Business Objects, QuickBooks,

Microsoft Azure, O365 Tools, Salesforce, JIRA, .NET, VB.NET, Visio, Project, SQL Server, PL SQL,

HTML, XML, MS Access, Oracle, MS Office suite, Google suite.

THOMSON REUTERS – CHICAGO, IL

JAN 2009 – AUG 2012

Technical Business Analyst

Participated in cross functional teams and built relationships with key internal clients and business

partners including Marketing, Customer Experience, Sales and Executive Leadership to understand

and improve each business area using technology enhancement keeping it in line with Organization

goal and strategy.

Role & Achievements:

• Designed and implemented efficient tools that saved $1.2 million in annual Hosting business.

• Provided ongoing support/escalating issues when necessary for the business systems

TimeTracker (Home grown application developed using C# .Net, ASP and AJAX technologies),

Client Center, SalesForce, Hosting Business Apps.

• Developed detailed requirements and functional design to migrate company’s legacy billing

system to SAP by utilizing existing corporate SAP functionality. Coordinated with Finance and

upper management team to determine business process changes. Successfully implementation of

the project resulted in:

Significant operational efficiencies. (~3 4 days per resource)

Improved single reporting capabilities within SAP, thus enabling Centralization of data

Single billing experience for Customers

Enabled future development.

Page 4 of 7

• Lead the redesign of company’s marketing website that was awarded the ‘Outstanding website’

in 2009 by the Web Marketing Association during the annual Web Award Competition.

• Supported end of the month finance billing activities.

• Helped create a Data Warehouse to drive a more robust reporting system that provides support,

analysis and insight to help the business drive superior financial results.

• Worked with the team to identify data sources, document requirements and generate reports

requested by leadership team on weekly, monthly and quarterly basis.

• Planned and coordinated system releases with business, technology and infrastructure teams.

• Implemented and designed tools that transform excel based manual computations to

automated billing computations within the Hosting business.

• Maintained Time Tracker system by fixing bugs reported by Client Services/Finance Team using

classic ASP.

• Fixed SQL Server Report's design and formatting issues and matched numbers and financial data

provided by senior members of the team.

• Made sure that all billing/cancellations followed a process.

• Provided proper guidance to Finance team to correctly write down/move time from prior months.

Emphasized that not changing revenue/numbers for the closed months is the right thing to do

• Made sure that all changes were implemented using a better, in fact the right approach.

Environment: SAP, Agile, SDLC, Waterfall, .NET, VB.NET, Visio, Project, SSRS, Crystal Reports,

Business Objects SQL Server, PL SQL, HTML, XML, MS Access, UNIX, IBM Websphere, Oracle, MS

Office suite.

THOMSON REUTERS – CHICAGO, IL

SUMMER 2008

Web Developer (.Net) Intern

Developed new functionality and maintained existing application to incorporate changes in several

business systems and marketing website to keep it up to date with the latest product trends and

organization goal.

Role & Achievements:

• Made sure that Business Systems application and JIRA application are always up and running.

Brought the applications back up online when they experiences unscheduled downtime.

• Participated in formulating and defining system solutions and objectives, based on user needs

and a thorough understanding of business processes.

• Delivered clear, compelling deliverables for internal client presentation to make a firm business

decision.

• Followed a structured approach to organize requirements into logical groupings of essential

business processes, business rules, and information needs that insures any critical requirements

are not missed.

• Mapped process flows; assess as is processes through user interviews, data collection and

analysis, design and evaluation of to be process solutions.

• Responsible for ensuring requirements (User Stories) are aligned to fulfill models and value

stories for the business and customers

• Teamed up with both internal and external software development groups to provide functional

specifications in form of use cases, business process flows, prototypes and reporting requirements.

• Experienced working with technical Writing teams and ensured the delivery of a high quality

software application.

• Updated the existing time tracker system with new processes and reporting enhancements that

allowed the business to cut down on errors and other manual processes.

Page 5 of 7

• Assisted and lead the creation of business and technical specs for organization’s Internal

Systems, developed new modules by introducing new .Net technologies.

• Optimized search indexes on websites and Robots.txt files

• Automated manual tasks, created new processes and data audits to ensure business system data

integrity.

Environment:.NET, Visio, SSRS, Crystal Reports, Business Objects, MS Project, SQL Server, PL SQL,

UNIX, JIRA, HTML, XML, MS Access, IBM Websphere, Oracle, MS Office suite.

DEPAUL UNIVERSITY – CHICAGO, IL

OCT 2007 – DEC 2008

Web Developer (Part Time)

Developed new functionalities for enhancing the Theatre School’s website for better Usability, Design

and overall site Responsiveness.

Role & Achievements:

• Maintained the Theatre School’s website by performing regular updates.

• Normalized database tables and performed extensive query optimization. (SQL Query

Analyzer)

• Cleaned up and rewrote front end HTML and CSS to meet validation requirements.

• Performed the full spectrum of Web related tasks, including rapid prototyping, design and layout,

server side programming (primarily PHP), MySQL databases, AJAX interactivity, standards

compliant XHTML and CSS, testing, training, hosting, security, and ongoing updates.

Environment: PHP, MySQL, HTML, AJAX, MS Office.

HEXAWARE TECHNOLOGIES LTD – MUMBAI, INDIA

JUNE 2005 – JUNE 2007

Software Engineer

Helped several business clients for end to end implementation of new data migration system, business

enhancements and eliminate manual process with ultimate goal of increasing efficiency and cut cost.

EDUCATION

DEPAUL UNIVERSITY – CHICAGO, IL

NOV 2008

Master of Science (MS) – Information Systems, GPA: 4.0/4.0

SNDT UNIVERSITY – MUMBAI, INDIA

MAY 2005

Bachelors of Technology (B.Tech.) – Information Technology, GPA: 3.6/4.0

HONORS AND AWARDS

• 2010 Award – Focus on Financial Excellence at Thomson Reuters

Certificate of Excellence for Achievement

Category: Performance Matters

• 2009 Web Award at Thomson Reuters

For Outstanding Achievement in Web Development

http://www.webaward.org/winner.asp?eid=13775

Page 6 of 7

Page 7 of 7

Contact this candidate