GAUTAM ROY MBA, PhD, CSM

**** ******** ** ***** ** 75074 Tel. 316-***-****

email: abmn0e@r.postjobfree.com

SUMMARY

. More than 18 years experience in managing delivery to architect, design,

develop, deliver and support market driven and customer focused IT

solutions and supporting IT infrastructures

. Certified scrum master with passion and dedication to foster

understanding of Agile development and team adherence to the Agile work

practices to deliver tangible business outcomes

. Expert communicator and facilitator with great interpersonal skills -

effective in presentations, training, formal and informal interactions

with executive management, business leaders and technology professionals

. Entrepreneurial self starter capable of functioning with high efficiency

as a team leader and player

. Extensive knowledge and experience of relational, multi-dimensional

databases and data warehouses from conceptual, logical and physical

perspectives

. Considerable skills in construction, review, interpretation and

communication of Process flows, Entity Relationship and Data Flow models

. Knowledge and substantial experience in Client-Server, n-tier

architecture and managing scalability and deployment in ASP, Enterprise

and standalone systems

. Experienced in managing various aspects of the software development

lifecycle (SDLC) including requirements gathering, design, development,

testing, deployment and support

. Wide-ranging experience in managing process and artifacts in

methodologies such as Waterfall, RUP, Agile (Scrum, XP and Lean) -

frameworks and metrics for OPM3, ISO, CMMI, Six Sigma standards

. Strong skills in Software estimation - effort, time and budget - using

function point estimation (IFPUG 4.1), variant FP methods, Use Case

points, Agile COCOMO and story points

. Expertise in object oriented analysis and design (OOAD), unified modeling

language (UML), use cases, UI development, usage models, layout and

wireframes, test cases and user training

. Advanced quantitative skills in applying probability distributions,

statistical inference, ANOVA, MANOVA, regressions (GLM), Cluster

analysis, Factor analysis and simulations to drive quantitative

management decision making

. Strong knowledge and Experience of regulatory standards and auditing for

AML/BSA, SOX, COSO, capital adequacy Basel II standards, etc.

. Specialized experience and knowledge in financial risk management -

quantifying credit and market risk and applying advanced estimation

concepts like application of t-distribution and empirical distribution on

rate change probabilities, Monte-Carlo simulations, value at risk,

transition matrix, etc.

EDUCATION & CERTIFICATION

MBA - Case Western Reserve University, Cleveland, OH 2003

Concentration in Finance & Supply Chain Management - GPA-3.7

PhD in Applied Geochemistry, Osmania University, Hyderabad, India 2000

Certified Scrum Master (CSM)

IT SKILLS

Operating Systems: Windows 98, ME, 2000, NT, XP, Vista, UNIX, AS400/RPG

Databases: MS SQL Server, Oracle; DB2; MySQL; Hyperion-Essbase (multi-

dimensional); Teradata

Languages: SQL, PL/SQL, C++ / VC++, VB.Net, C#, JavaScript, XML, XAML,

Java

Productivity Tools: MS Office - Word, PowerPoint, Excel (VBA), Access;

MS Plan Enterprise, SharePoint, Live Meeting, Team

Foundation Server, Visual Studio; Adobe Acrobat, Photoshop;

VISIO, MS Project; Clarity, Open Workbench; TeamPlay;

Planview; Version One, Rally, Mingle;

Rational Suite -RequisitePro, Rose, ClearCase, ClearQuest;

Optimal Trace, Enterprise Architect; Test Manager, Software

Architect, WBI Modeler; CaliberRM, DefineIT, TestDirector,

QualityCenter, Jira

Data tools: SAS, SPSS, STATA; ErWin, LBMS; Informatica, Ab-initio; Crystal

Reports, Business Objects; SQL Server Integration Services

(SSIS), SQL Server Reporting Services;

ESRI ArcGIS; STORM, LogWare, Arena (Decision Modeling);

EXPERIENCE

Capital One, Plano TX Nov 2009 - present

Agile Coach/Project Manager

An agile coaching and project management role with cross-functional Agile

(Scrum) Teams in deployed in a onsite-offshore model to architect and

deliver the Mortgage Data Warehouse Program. The Mortgage Data Warehouse is

built in Terradata using Ab-Initio as the ETL tool consolidating data from

different Legacy Source Systems (resulting from Bank acquisitions) for

managing loss mitigation, credit risk, customer information system to

provide a 360 degree view of the customer and analytics for segmentation,

loyalty, rewards, pricing, etc, and regulatory compliance. The mortgage

industry standard (MISMO) compliant core (3NF) feeds; the presentation

layer integrates with the Bank and Card data warehouses in Teradata, a BI

layer using Business Objects delivers specialized reporting and a

specialized SAS data mart (SAS Dome) delivers advanced analytical modeling.

Project management is done in a transitional agile-waterfall mode with

Clarity as the principal tool.

Responsibilities:

. Facilitate interactions with customers, expert resources and stake

holders and process feedback to clarify business requirements and

define initial project scope and Sprint zero

. Play an active role in designing the Governance process flows for the

management and to ensure continued stake holder buy in

. Actively help and coach Product Owners in managing the Product Backlog

- explain the tradeoffs in Release Planning story and sprint goal

selection with respect to the velocity attained by teams

. Conduct and facilitate estimation sessions for the product backlog

item estimation (PBIE Story points) and the sprint backlog task break

downs and item estimations

. Coach and mentor the teams with respect to core scrum practices of the

daily standup, sprint planning, sprint demos, retrospectives and

maintaining the scrum board (information radiator).

. Mentor and help business systems analysts and data modelers understand

fundamental concepts of agile modeling, advanced financial concepts

and mortgage finance

. Conduct design storming for the logical and physical data models and

coach the teams in using acceptance test driven development

. Particiapate in model reviews for logical and physical models and

conduct Sprint retrospectives for the teams

. Maintain the product and sprint burndown charts for the teams and

report out on trends and expectations to stakeholders and management

. Maintain the impediments log, take proactive action in resolving or

escalating impediments and consolidate/update the Program risks and

issues register

. Present periodic reports to management and stakeholders on Agile

metrics like Business value delivered and cost incurred per Backlog

item and facilitate value based backlog prioritization

Octapace Consulting, Detroit MI May 2009 - Nov 2009

Agile Trainer

A leadership role in organization of training programs and imparting hands

on training to product owners, business/systems analysts, QA analysts and

project managers in utilizing Agile methods and best practices to improve

quality and time to market in delivering IT systems. Trained six on-site

off-shore cross functional teams in leveraging multiple tools and

technologies - both object oriented as well as database (conceptual,

logical and physical) and business intelligence -to develop, deploy and

support effective IT solutions and in BPO-Call Center settings.

Responsibilities:

. Coach and mentor the teams with respect to core scrum practices of the

daily standup, sprint planning, sprint demos and retrospectives

. Actively coach Product Owners in managing the delivered functionality

through the Product Backlog by Refactoring - Themes, Epics and

Stories

. Explain the tradeoffs in Release Planning story and sprint goal

selection with respect to the velocity attained by teams

. Explain and conduct working sessions on the product backlog item

estimation (PBIE Story points) and the sprint backlog task break downs

and item estimations in relation to conventional methods (Use

case/function points)

. Coach project managers in understanding the trade-offs between Triple

Constraint project management and Agile methods and managing

impediments risks and issues

. Explain the importance of maintaining the product and sprint burndown

charts for the teams and report out on trends and expectations to

stakeholders and management

. Train and demonstrate determining Agile metrics like Velocity,

Business value delivered, defects per sprint, etc reporting to

management and stakeholders and facilitating value based backlog

prioritization

. Explain the concepts of managing large scale programs through the

'scrum of scrum' approach

. Mentor and train business systems analysts, quality analysts and

developers to work together as cross functional teams, understand

fundamental concepts of agile modeling, design storming and

refactoring principles

CCH (a Wolters Kluwer business), Wichita KS Jan 2007- Apr 2009

Lead Designer

A key role in designing the NextGen version of an international market

leading software suite for Tax and Accounting firms - the full line

software will be completely scalable and marketed for a variety of

deployments including web-based ASP, Enterprise and a standalone version.

The ASP (.Net 3.5 standard) solution utilizes a SOA and is delivered

through a SaaS model. The solution was developed in a transitional

waterfall-scrum model using onsite-off shore teams.

Specific areas:

Workflow Management - made major contribution in meeting deadlines and

optimizing the design and delivery of the Next Generation software to

manage 360 degree workflows in CPA practices

Accounts Receivable and Billing - led all round efforts to design an

improved solution encompassing functionality from two market leading

legacy systems and provide core inputs for customer relationship

management

Criteria Builder - designed an improved visual SQL based analytics

builder for the NG suite and led data mapping and data migration

efforts from legacy systems - solution is now implemented.

Responsibilities:

. Mentor and Participate in core Scrum ceremonies Release Planning,

Daily stand-ups, sprint planning, sprint demos and retrospectives

. Facilitate story workshops and interactions with internal subject

matter experts (SMEs), customers and system integrator consultants to

capture the core functional requirements of the relevant modules

. Examine the detailed functionality of the two principal legacy systems

(Practice Advantage and Practice Management) with respect to the

modules under design to reconcile and elicit functional requirements

. Explain functionality and conduct design storming sessions to provide

guidance to off-shore development teams

. Participate and review the data model and standardized data

representation for the suite

. Participate, review and mentor other analysts in structured analysis

of functional requirements and elucidation through UML 2.0 activity

diagrams and use cases to complete system requirements specifications

(SRS)

. Participate in the design of the user interface (UI) and maintain the

standardized UI documentation

. Review the UI design and definition of the XAML for effective user

communication and experience

. Provide key inputs in database development from conceptual and logical

perspectives and maintain the data definitions supporting the

functionality

. Coordinate the efforts of the design and testing teams by maintaining

maintain traceability in Caliber RM and other requirements

documentation

. Participate in architectural and code review sessions (weekly Practice

coordination meeting) to optimize the delivered solutions

. Review help and user documentation to effectively communicate the

product functionality in end users training materials

. Training call center support groups to effectively handle calls and

trouble shoot customer issues

Visteon Corp., Van Buren MI; Apr.2006-Dec.2006

BI Project Manager

Played a key role during in managing delivery on the Data Warehouse

Enhancement Program, for the leading automotive global supplier, that

involved consolidating data from multiple sources, architectural

optimization, design and development of analytical business intelligence

solutions. The development approach followed an onsite-offshore extreme

programming (XP) model.

Specific areas:

Multi-dimensional database - led the design effort for understanding

business requirements and delivering a multi-dimensional database

within the analytics data warehouse by consolidating information from

multiple transactional databases (B2B and B2C), data warehouses and

ERP systems deployed by the company.

M&A and Marketing forecast models - key role in design, development

and calibration multiple internal forecasting and segmentation models

- the models (SAS and Essbase) are currently in use by the M&A and

Marketing divisions.

Responsibilities:

. Facilitate meetings with the key customers and stakeholders to

understand and clarify business requirements

. Periodic presentations of progress, metrics and demonstrations of

developed solution to sponsors and stakeholders

. Hands on role with the client's analytical staff to elicit, prioritize

and clarify requirements for complex analytical models

. Key role in prioritizing requirements and scope to develop and

communicate the release plan

. Analyze and re-factor the release plan, create and continuously update

the iteration plan

. Identify, present and create stakeholder consensus for standard

acceptance testing criteria

. Facilitate implementation through Test Driven Development (XP)

methodology to accelerate project deliverables

. Mentor and aid in devising effective pair negotiation and pair

programming between onsite and offshore pairs

. Supervise documentation of the data requirements and facilitate in the

design meetings for the transactional and multi-dimensional databases

. Lead and participate in the data modeling efforts, standardization

and conduct model reviews

. Lead role in communicating and clarifying with architects and

developers to ensure timely delivery of proof of concept (POC) and

prototype solutions

. Demonstrate and communicate the efficacy of proposed methodology and

solutions to business managers and retain continuous sponsor buy-in

. Maintain estimates of resources, effort and time and regularly present

metrics to management.

. Key role in anticipating, identifying and managing risks associated

with the projects through appropriate and timely risk mitigation

efforts.

. Coordinate all quality assurance efforts, UAT and end user training to

ensure a smooth hand over of the new solutions

Option One Mortgage Corporation (A subsidiary of H&R Block), Irvine CA;

Feb.2005-Apr.2006

Senior Project Manager

This role involved managing delivery and stakeholder expectations,

coordinating development, hands on design (including SAS models for default

and prepayment behavior) of multiple in house process improvement and

product development project initiatives under the Capital Markets Program

for the leading Sub-Prime Mortgage originator. The development was managed

in a transitional waterfall-agile environment.

Specific areas:

Mortgage Pricing - led the project team to design a subsystem to

provide real time product price matrices and drive product innovation

based on customer segmentation and quantitative risk models to

increase subprime mortgage loan originations - project developed using

an onsite-offshore model and implemented successfully.

Loan reserves (SOX compliance) - delivered the process and technology

to maintain tracking and audit trail for non-performing loans, obtain

a provision for loan losses in compliance with Sarbanes-Oxley Act of

2002.

Mortgage Portfolio Optimization - led team to develop a system to

implement standardized multi-objective non linear optimization

(Simulated Annealing) technique in constituting optimal loan

portfolios for given aggregate risk characteristics leveraging data

from transactional (origination and servicing) databases as well as

data warehouse repositories - provided the capital markets management

improved choices to portfolio loans, securitize or sell whole loans in

the capital markets

Responsibilities:

. Interface with and facilitate productive interactions with end users,

sponsors, subject experts and stake holders to finalize the scope of

the project

. Lead the effort in documentation of existing process flows, identify

process gaps and elicit efficient requirements for solution design

. Review the constructing the process flow diagrams, data flow diagrams,

activity diagrams and use cases for the proposed system

. Participate in refining data requirements and constructing the optimal

data model from the conceptual, logical and physical perspectives

. Hands on participation with client's analytics group in modeling and

testing models

. Participate and review the GUI design and definition of the XML

schemas to effectively communicate financial data

. Coordinate in the design and testing of the analytics required and

demonstrate prototype solutions to management

. Key role in refactoring business requirements to constitute the

product backlog

. Facilitate communication of business requirements to the architects

and Scrum team and ensure efficient design and development

. Principal role in maintaining product and sprint backlogs and

reporting to management to ensure continued buy-in from project

sponsors

. Play a key role in anticipating, monitoring and managing risks and

dependencies to remove impediments

. Ensure quality and lead the quality assurance efforts in preparing

test strategy, reviewing test scripts and scenarios - continuously

incorporating user feedback

. Coordinate the effort in user acceptance testing, incorporating user

feedback and end user training

. Ensure complete documentation of the system, publication of multiple

product brochures and related marketing material and delivery on time

and within budget to the satisfaction of the client

SBK Brooks Investment Corp., Cleveland OH May 2003-Feb. 2005

Financial Project Manager

A program management role at an investment bank included managing multiple

projects encompassing end to end activities - form the trading floor

through the middle office to the back office. Advanced analytics and

quantitative methods were used (SAS was among the principal analytical

tools) to arrive at the statistical models for the systems together with

structured Monte Carlo and quasi Monte Carlo simulation methods:

Specific areas:

Marketing Database - led team to identify data requirements and

consolidate firm's marketing database, facilitating effective

analytics to segment customer base, determine loyalty, rewards and

risk tolerance, identify and categorize prospects resulting in 10%

increase portfolio related trading volume.

Trading system - led project to research and design an integrated

system with VOIP based trading calls, quality observation (NICE), STP

trade clearance. trading algorithms and adequate disaster recovery

provisions the firm's offices in Cleveland, New York and Chicago -

increased daily trading throughput by 12%.

Hedging Model - led an internal/offshore development team to prepare

and implement cross hedging models for firm's fixed income inventories

using Treasury futures and options.

Pricing Municipal New Issues - designed and delivered to the trading

desk a customized pricing system for municipal new issues and

structuring cash flow scenario to match client needs using Munex

software.

Responsibilities:

. Make pre-sales presentation to client's to top management and obtain

sponsor buy-in for the project

. Analyze the existing system and identify gaps through interaction with

end users, stakeholders and sponsors to define the scope of the

project

. Present portfolio progress and demonstrate deliverables to retain top

management buy in and continued sponsor support for the program

. Continuously monitor metrics and progress and present to the capital

markets and portfolio management executives

. Design the process flow, data flow, activity diagrams and use case for

the proposed system

. Develop and standardize the data models to deliver optimal

functionality just-in-time.

. Develop the required analytics for the estimation of the cross hedge

including historical simulation and structured Monte Carlo simulation

(SMC)

. Maintain Estimates, WBS, resource requirements and deployment, costs

and risks for the project.

. Develop timeline, set project milestones and ensure on time delivery

for the duration of the project.

. Prepare and evaluate of RFI, RFP and RFQs for budgeting, vendor

evaluation and selection

. Coordinate and monitor complete end to end deployment and testing of

software, hardware and network resources

. Prepare training and marketing materials for fund managers and sales

persons to utilize the system and present the analytics to prospective

clients

. Ultimately responsible to deliver the project in time and within

budget

The Benedict Group Inc., Cleveland OH May 2002- May 2003

Senior Project Manager

This assignment involved architecting and managing the program to deliver

process improvement and the supporting technology improvements in the

organization delivering hardware and software educational resources. The

delivery was managed using an onsite off-shore iterative model:

Specific areas:

Student Centered Learning - researched, evaluated technology

alternatives and developed an optimal solution for developing an

interactive web based instructional medium including VOIP for

interactive tutoring and publication of online teaching materials and

testing.

Computers For Education - led project to optimize logistic sourcing

and delivery process for delivery and support of hardware resources

including refurbished computers for inner city schools reducing

operating costs by 6.5%.

Responsibilities:

. Interface and facilitate interactions with end users, sponsors,

experts and stake holders to finalize the scope of the project

. Documenting existing process, gaps and identifying the requirements

and the proposed solution

. Make pre-sales presentation to client's to top management and obtain

sponsor buy-in for the project

. Supervise and review construction the process flow diagrams, data flow

diagrams, activity diagrams and use cases for the proposed system

. Participate and supervise in the construction of the optimal data

models for the functionality delivered

. Develop the data model and solution to implement an iterative optimal

solution algorithm for logistical optimization of operations

. Supervise design and testing the analytics and present proof of

concept (POC) to top management

. Communicate design to the architects and developers to ensure

efficient design and development

. Maintain estimation, work breakdown structure, resources, costs and

risks for the project

. Ensure quality and lead the quality assurance efforts in preparing

test strategy, test scripts and scenarios - incorporating user

feedback

. Leading the effort in user acceptance testing, incorporating user

feedback and user training

. Supervise documentation of the system and delivery on time and within

budget to the satisfaction of the client

NETHERLANDS COLLABORATION PROGRAM, Hyderabad, India 1990-2001

Project/Program Manager

Played a leadership role in multiple project and program management

assignments to manage the architecture and delivery of IT Strategic

solutions for an International collaborative venture. The programs were

aimed at working with India's large Public Sector organizations in an

attempt to realize increased productivity and process efficiency and

facilitate Privatization. The key objective of the collaboration was to

drive process improvements by leveraging information technology and data

driven solutions. My role in the program was to take full responsibility

for managing the architecture, design, customization and deliver solutions

to the following major clients:

Client: NATIONAL THERMAL POWER CORPORATION (India's Energy Industry Leader)

Specific areas:

Acquisition Models - led the project team to design a data model,

develop a consolidated data warehouse and data mart to deliver a

valuation, target selection and metrics generation models to select

State Electric Board acquisition targets - implementation added $10

million to company's annual revenues.

Environmental Management Metrics - led the project to develop process

models, data acquisition and development of data warehouses - design

and deliver analytics, statistical (SAS) models and spatial (GIS)

models and metrics with multiple teams to document, reengineer,

monitor, report on the client's environment management processes - the

implementation helped gain ISO 14000 certification

Client: NATIONAL MINERAL DEVELOPMENT CORPORATION

Exploration Risk Minimization - led multiple project teams to design

and develop multiple data warehouses and deliver geo-statistical (SAS)

models and spatial (GIS) models to minimize risks in gold, diamond and

precious metal exploration - creating annual savings of $3.6MM in

drilling costs

Client: NATIONAL TECHNOLOGY MISSION

Startup Turnaround - led projects to carry out due diligence and

valuation on technology based startups funded - reduced loan

delinquency from 50% to 10% creating annual savings of $3.6MM

Sourcing Databases - led effort to design and develop a centralized

shared data warehouse and delivered alternate process models for

inventory management and valuation; evaluated and identifed new

sourcing alternatives to increase supply chain efficiencies for

hardened steel - savings of ~$2 MM

User Training Programs- Organized and conducted training sessions in

multivariate analysis for industry managers and regulators

Responsibilities:

. Continuous interaction with client's executive management during the

tenure of the Program to obtain approvals, retain buy in, periodically

present progress and demonstrate deliverables

. Hands on leadership role in architecting optimal process and data

models, KPIs and analytical optimal solutions based on advanced

quantitative modeling

. Manage a talented staff of 45-50 people responsible for the complete

SDLC

. Provided the development and production support teams with domain

expertise and mentoring

. Led the efforts to define and manage project scope of multiple

projects and programs

. Review and evaluate the work of the staff and provide input to

periodic performance reports

. Effectively communicate problems, issues, risks, solutions, etc. via

written or oral methods to various levels of stakeholders, senior

management and executive sponsors

. Work with multiple teams and vendors to set SLAs, project and program

goals

. Ensure meeting project goals while managing change and working with

difficult project constraints

. Monitor compliance with the established project management

methodologies, policies, procedures and best practices

. Interact with team members, IT and business leadership to achieve

project goals

. Actively manage risks associated with the projects and take

appropriate measures to address them

. Manage and produce project and program communications including:

status reports, cross-project interactions, business, departmental,

customer and IT interactions

. Review, validate, align and approve architecture and design in line

with enterprise-wide standards, corporate vision and strategic

directions

. Maintain an "end to end" view of the overall solution being developed

by various project teams and assure the design integrity of those

solutions

. Maintain general awareness of all the current and planned project

initiatives and also understands their dependencies or impacts on each

individual project and the programs

. Provide leadership to various project managers and teams to help them

to anticipate development challenges, scalability and performance

issues

. Research improvements in current & emerging technologies and identify

opportunities to innovate in solving technology and business

challenges

. Support and manage activities to develop and maintain client

relationships

Contact this candidate