Subhadra Ravindran

Project Manager/Lead Business Analyst

acb7fs@r.postjobfree.com

224-***-****

Overview:

• Around 8 years of experience as an Project Manager/Lead Business Analyst in Business Intelligence

and Data Governance in various sectors of business.

• Formulated and defined systems scope and objectives for complex, high-impact projects.

• Expert ability to collaborate with senior leadership, senior technologists and Business Partners to

define business processes, analyze operational efficiencies, implement creative solutions and

measure delivery results.

• Ability to use logical sound judgment and experience to determine the appropriate course of action

based on scenario, procedures, and guidelines, for a given situation.

• Manage and report Projects Pipeline, resource forecasting, estimation, scheduling, financial tracking

& project metrics.

• Actively participated in QA, User Acceptance Testing to validate the code before moving to

production.

• Develop and maintain business partnership with functional leads. Coordinate ongoing information

sharing sessions, understanding the goals of the respective Business Unit/functions, consistently

provide counsel that enables BU to be successful.

• Ability to manage, organize and control activities of resources aligned to multiple projects with

varying levels of complexity; experience managing scope and capacity for multiple projects.

• Excellent analytical skills by conducting change impact assessments that provide foundational data

for project recommendations leading to a project implementation plan.

• Ability to define the client’s requirements within the context of their business. Ability to assess the

opportunities, benefits, risks, and success factors of a potential solution.

• Ability to make effective decisions under pressure.

• Accountable for project/program success and resolution of all issues that arise.

• Provided direction and technical leadership; acts as a technical resource in all phases of the

development and implementation process.

• Provided in-depth and sophisticated analysis with interpretive thinking to define problems and

develop innovative solutions.

• Influenced strategic functional decisions through advice, counsel or provided services which directly

impact the business.

• Persuades and influences others through strong and comprehensive communication and diplomacy

skills.

• Ability to Multitask and meet development milestones ensuring high quality & on-time delivery.

• Creative and innovative thinker with excellent communication and Organizational skills bringing

energy, enthusiasm and leadership skills to problem resolution.

Technical Skills:

Methodologies: Agile, Waterfall

Databases: Oracle 9i, and SQL Server

ETL Tools: AbInitio, Datastage

Languages: Korn Shell scripting, SQL, PL/SQL

Version Control Tools: EME, CVS, Clear Quest

Other Tools: Toad, SQL Developer, MS Visio, Excel, Word, Power Point.MS Office, Suite,

MS Project, SharePoint, Share File, Box, Requisite Pro, Clear Case, HP Quality

Center, HP Blue Print, PlanView, Clarity

Reporting Tools: Familiar with Tableau, Cognos, SAS, and Crystal Reports

Operating Systems: UNIX, MS DOS 6.22, and Windows NT/XP/2000

Education:

Bachelor degree in Science, University of Madras, India

Experience:

High Tower Advisors Sep 2013 – Current

Project Manager/ Business Analyst/

• Provide technical inputs to a range of monitoring and evaluation assignments.

• Develop strong working relationships with Clients, Partners and stakeholders.

• Responsible for Analysis, Design, Scheduling, Construction, Validation (QA, UAT) and delivery of

solutions to meet the Client’s expectations.

• Responsible for creating and validating test plans and test scripts for QA and UAT with business

partners and provided signoff to move the code to production.

• Actively participated in QA, User Acceptance Testing to validate the P&L, Revenue & Clearing,

General Ledger Dashboard in Tableau.

• Evaluate existing systems and procedures providing recommendations for improvements.

• Manage and mentor team of consultants assigned to project.

• Measure progress and monitoring performance (overall, scope, schedule, costs, quality of the

project)

• Lead risk management within project teams, ensuring risks has appropriate mitigation and

contingency plans.

• Prepared and delivered status report to stakeholders on a regular basis.

• Facilitated project and stakeholder meetings effectively and provided meeting minutes in a timely

manner.

• Responsible for plan, schedule, and control project activities to fulfill objectives and satisfy project

requirements.

• Working closely with business in gathering the requirements to build the PnL dashboard in Tableau.

• Working closely with the developers in performing regression testing and performance testing for all

the PnL reports created in Tableau.

• Responsible for creating User Entitlements for Users to access the P&L, Revenue & Clearing,

General Ledger Dashboard in Tableau.

• Responsible for creating User Training Manual and training the users to use the tool.

• Responsible for creating Business process flows, Project requirement documents for multiple

projects.

• Ensure satisfaction until the project is complete.

Environment: Tableau 8.0, SharePoint, Box, Sharefile, MS Excel, MS Word, MS Visio, MS Office.

Citi Retail Services Dec 2011 – Sep 2013

Project Manager/Lead Business Analyst

• Worked closely with the newly formed Data Governance team and functional areas (Decision

Management, Marketing, Risk, BI, Operations, Finance, IT) to develop and implement an overall

MIS strategy and governance model for teams providing MIS reporting, files, development, or

infrastructure in support of Citi Retail Services;

• Participated in Data Governance Council meetings, Steering committee meetings and working

sessions to create Data Governance program roadmap and responsible for Business Requirements

definition and documentation.

• Developed and implemented strategies, programs, and standards that promote data quality, accuracy,

usability, reliability, security, consistency, compliance and accountability.

• Identification and implementation of tools for Metadata Repository (DAI), Data Quality (DQIP), to

enhance the organization’s data related capabilities and to help in monitoring and measuring of data.

• Leading the effort in rationalizing PnL data marts of various functional areas and implementing new

PnL data mart in centralized EDW location.

• Analyzed and documented Risk and Mitigation plan for all projects.

• Performed Data Analytics of Technology teams to evaluate alternative systems and organizational

options and recommended a co-ordinated approach in order to meet the Customer and Stakeholder

needs.

• Assessed impacts/effort for Technology teams and led cross functional task force to identify and

document functional requirements, work flow, distribution paths, information sources, and system

specifications for a project.

• Responsible for exporting the project requirements from Blueprint to HP Quality Center for

requirement traceability.

• Facilitating Test Case review sessions with QA team

• Responsible for reviewing and validating the test cases and QA output files.

• Led offshore team in allocating the cost and effort of the projects in Plan View.

• Responsible for overall management of all projects created in Planview to solution the Business

requests.

• Responsible for setting up Work Breakdown Structure in Portfolio Management tool for all CRS

project to track the project status.

• Owned the project plan & schedule and is directly involved in managing the project activities to

achieve the project objectives and responsible for preparing project plans, identifying and requesting

resource.

• Owned the resources and is responsible for managing resource schedules, responding to resource

requests from Project.

• Regularly communicate progress and budget to client and development team.

• Oversee and organize project tasks and details using project management tools.

• Acted as a Mentor to Peers, new or lower level analysts and allocate projects.

Environment: MS Share Point, MS Visio, Excel, Word, Power point, Project, HP Quality Center, HP Blue

Print, Plan View, APEX (Cognos), DAI(Abinitio) – Meta data repository, Translation Hub

(Abinitio)- Data Quality

JP Morgan & Chase Apr 2010 – Nov 2011

Lead Business System Analyst/ Project Manager

• Worked closely with Reverse Engineering (RE) team to design Functional Requirements Document

(FRD) with decoupling of the PaymentNet4 (P4) Online Transaction Processing (OLTP) and

Reporting databases

• Ensured the reverse engineered P4 functional specs trace back to original PaymentNet3 (P3) Custom

Objects requirements (custom reports and custom Mappers) for PaymentNet4 migration project.

• Scheduled requirements turn over meetings and review completed FRD with design, build and QA

teams

• Reviewed and validated QA test cases created based on the turned over FRDs

• Supported design, build and QA during the build and testing of the Custom Objects

• Verified the output of the testing performed by the QA team and provided signoff on the same in

preparation for the release and migration of the code to production

• Provided assistance with all UAT or production related issues reported by business or clients

• Created Enterprise Change Management (ECMs) using ECM website to deploy Custom objects to

different environments (QA,UAT, production)

• Supported and conducted deployment sessions to deploy new code as per release schedule.

• Performed Gap Analysis, Risk Analysis, Cross Impacts Analysis, Cost Benefit Analysis.

• Responsible for providing RAG status for all the projects to the steering committee.

• Analyzed and documented Risk and Mitigation plan for Custom Objects.

• Responsible for creating Retrace ability matrix for all Reports and Mappers

• Reviewed Functional and Non Functional Requirements.

• Responsible for creating the templates and guidelines for documentation and posting in the Share

Point site.

• Managed the Documents and Object Specifications using IBM’s Clear Quest (CQ).

Environment: MS Share Point, MS Visio, Excel, Word, Power point, SQL Developer, MS Project, Rational

Clear Quest, Requisite Pro, Clear case, HP Quality Center.

Beam Global Spirits & Wine INC, Deerfield, IL Oct 2009 – Dec 2009

Analyst

• Involved in Product Data Management by capturing and maintaining information on products by its

brand, color, quantity, size, flavor, shelf life etc.

• Interacted with VISTAAR (Third party for Pricing) for pricing and tracking the product sales by sku

to strategize product pricing.

• Worked directly with internal and external clients on activities of moderate to high complexity.

• Responsible for creating test plans and test scripts for UAT with business partners.

• Involved in documentation for project approvals and with change management for project

implementations.

• Responsible for deliverables associated with all phases of the Systems Development Life Cycle.

• Translated business needs into User Requirements.

• Involved in design for the new projects, project enhancements and performance tuning.

Environment: Oracle 10g/ 9i, Toad, Linux, UNIX Korn shell scripting, PL/SQL, Windows, MS Visio,

Excel, Word, Power Point

Discover Financial Services - Riverwoods, IL Sep 2008 – Jul 2009

Associate Marketing Data Warehouse Analyst

• Gathered requirements from the business partners and developed new projects.

• Worked directly with internal and external agencies for new and already existing product

enhancements.

• Involved in design, development and implementation of ETL (extraction loading and transformation)

for high volume Data Warehousing projects.

• Responsible for deliverables associated with all phases of the system development life cycle.

• Interacting with the business users for high level design documentation.

• Responsible for all type of documentation like project approvals, test plan, test scripts,

• Responsible for reviewing and validating QA Test cases and QA output files.

• Actively Participated in Change management for project implementations and User Acceptance

Testing.

• Batch extraction and loading of data into the Marketing Data Warehouse.

• Participated in development projects as assigned. This includes analyzing, designing, coding,

testing, and implementing changes to data load and/or campaign fulfillment processes and systems.

• Supporting the ongoing maintenance and execution of DFS Portfolio Marketing processes,

• Execution of Portfolio Marketing Campaigns.

• Created the Source - Target mapping documents by analyzing the functional requirements provided

by Business.

• Monitor/ validate successful processing of campaign output files, including communicating with

downstream systems and/or fulfillment vendors as necessary.

• Research / trouble-shoot unexpected data load and/or campaign results, including potential data

quality and/or timing issues or incorrect campaign code.

• Scheduling and monitoring the jobs in JS Console.

Environment: Ab-Initio (Co-Op 2.14, GDE 1.14), EME, IBM-AIX 5.3, Affinium 5.3, IBM Mainframes, JS

Console, EDS live queue 9.1.1, Datahub 9.1.3, Peregrin software. MS Visio 2007, Excel,

Word, and PowerPoint

Nationwide Insurance - Columbus, OH January 2007 –

April 2008

Analyst

• Gathered requirements from the business users.

• Involved in design documentation and in creating test plans.

• Worked with all enhancements and change requests.

• Monitored the automated application, on any failure jobs were processed manually. Resolution of

tickets rose due to failure of jobs.

• Worked on improving the performance and tuning of the graphs of Ab-Initio graphs by using

Various Ab-Initio performance techniques such as using lookups instead of Joins etc.

• Involved in Production Support, and Troubleshooting.

• Helped in managing processes for moving code from development to production environments with

change management.

Environment: Ab-Initio (Co-Op 2.13, GDE 1.13), IBM-AIX 5.2, IBM Mainframes, DB2, UNIX Shell

Scripting, MS Word, Excel

AT&T - New Jersey November 2005–

December 2006

ETL Warehouse Consultant

• This project involves the maintenance of AT&T products information, Sales information, billing

information and rate plan information. Cleansing, loading and transformation techniques are applied to

the data received. Write multiple file components are used to generate the extract file that is sent to the

customer.

• Developed various Ab-Initio graphs for customer credit, contact detail, account detail, data inserts and

updates, calling plan, network service.

• Worked with all enhancements and change requests.

• Involved in Production Support, and Troubleshooting.

Environment: Ab Initio (Co-Op 2.13, GDE 1.13), IBM-AIX 5.2, DB2, Oracle 9i, SQL, UNIX Shell

Scripting, MS Word, Excel.

Contact this candidate