Business Management Project Sql Server Sales .Net

Pavan Chintlapati

mailto:*******@*****.***

Cell phone: 805-***-****

Senior C#/.Net Architect/manager with experience in financial and

insurance domains, Strong team player with excellent interpersonal

skills, customer focus and result orient. Manage large projects with

responsibilities including budgeting, capacity planning, tracking,

risk mitigation, contingency planning and staffing.

ACCOMPLISHMENTS

. Led fixed income development in BoA secondary markets division for 3

years, handling extreme volatility in requirements and projects, and

meeting stringent accuracy and turnaround requirements of traders.

. Managed outsourcing of middle and back office operations and systems.

. Managed very large databases and data by which all trading, hedging,

modeling, and operations were conducted.

. End-to-End Countrywide/BAC merger: Secondary/Capital Markets Led for a

few work streams.

. Technology Management Consulting: Project scope, cost/time estimation,

staffing, design, implementation, Client management and responsible for

on time delivery.

SKILLS

Languages C# 2.0/3.5, Forte, Java, Perl, Regular expressions, UML,

Erwin4.1, JavaScript.

Architectur Windows services, n-tier web applications, web services,

es batch processes, WinForms

Frameworks/ .NET(2.0/3.5), ASP.NET, AJAX, LINQ, Penagon FileNet, TFS,

Source VSS, StarTeam, Harvest, CVS.

Controls

Databases MS SQL Server 2005/2000, Sybase, Oracle 8i, DB2 7.1, SQL

ASA Anywhere

Methodologi Agile, Waterfall

es

Industries Banking/Financial, Retail, Insurance, Utilities.

EXPERIENCE

09/05-03/10 Vice President, Bank of America, Calabasas, CA

Architected and led development of mission-critical server applications to

support Capital Markets functions of Wall Street trading, securitization

and hedging in a dynamic and fast paced environment. Managed large multi

terabyte data ware house and data by which all trading, hedging, modeling

and operations were conducted.

End-To-End Data Strategy Initiative

Formulated the next generation data strategy and system Architecture road

map for Mortgage and Insurance Organization (HL&IT)

1. Performed intensive R&D, Cost Benefit Analysis and evaluation of various

industry standard data management frameworks and tools encompassing ETL,

Metadata, Data Quality, Data Integrity tools.

2. Provided complete solution Architecture (Hardware, Network, Software) to

meet existing SLA and to scale accordingly to the anticipated future

volumes.

3. Designed the Architecture to conform to the Federal DMAP - Data

Management and Accountability Policy guidelines, incorporating those

policies/concepts such as Data Lineage, Data Marts, Data Stewards and Data

Custodians along with proposing use of consistent tools for target

Provisioning framework.

4. Led JAD sessions with key business users to capture user stories, pain

points and to map key business elements for every application.

Conversion ETL Tool

1. Led design and Development of the ETL tool though various phases of

SDLC.

2. Managed resources off shore and onshore.

3. Was responsible for Cost/Time Estimation, Project Scope and Proposal

preparation.

4. Acted as functional Lead and liaison between business and development

teams.

5. Was responsible for providing inputs on hiring, performance reviews,

promotions and compensation changes.

6. Implemented Object pooling and Thread pooling modules.

Technologies: C# .NET, SQL Server 2005.

BulkBid - Exposing Financial Models as Service

BulkBid is a SOA application used by senior management/executives to make

strategic acquisition decisions by evaluating target portfolios.

1. Interacted with business to capture requirements and pain points.

Translate business requirements into technical specification documents.

2. Designed contracts to expose business models as web services. Interacted

with business and coordinated with impacted groups.

3. Designed and developed web services using C# to expose various business

functions like GSE (Government sponsored Enterprise), eligibility rules,

fixed income models and SnP loss models.

4. Designed database schema and SP to store request's response and

intermediate results.

5. Performed extensive and intricate data analysis to tie out the SOA

interfaces to the production data/results.

6. Was Responsible for Operations - production deployment and Support.

Technologies: C# 2.0, SQL server 2000, XML, Windows Service, Web Service

Fixed Income MBS Modeling

1. Interacted with business to capture requirements and pain points.

Translate business requirements into technical specification documents.

2. Led development and maintenance of various fixed income models for

investor pricing of MBS, handling allocation of upto $50B of loans each

month. Interfaced directly with trading desk and coordinated with impacted

groups and supporting groups like PMO and QA to ensure timely and accurate

delivery of critical business functionality.

3. Designed database schema, classes and interfaces for complex financial

algorithms for MBS Forced Execution calculation, loan-level pricing and

eligibility, G-fee analysis.

4. Performed extensive and intricate data analysis and validation for

project deliverables using SQL.

5. Was Responsible for Operations - production deployment and Support.

Technologies: C#, SQL Server 2005, Excel, Powershell

Wall Street trading tool framework

Pathfinder is a framework for RAD development of financial models and

trading. It provides features common to all models, including database I/O,

dynamic compilation and distributed processing.

1. Architected and implemented 'Find in Files' functionality to enable

search across models.

2. Led the migration of the framework from .Net 1.1 to .Net 2.0.

3. Architected and implemented Custom Panel (WinForms) interface for

traders to update market spreads.

4. Contributed ideas to enhance framework, explorer-like interface for

navigating models and dynamic web references.

Technologies: C# .NET

Countrywide - Bank of America merger initiatives

Led requirements analysis, design and development for multiple transition

projects to merge origination and servicing systems of the two companies.

1. BAC loans conversion: Developed ETL application and business logic to

route BoA loans through countrywide secondary marketing platform for

reporting purposes.

2. MSP Redirect & Servicing conversion: Led requirements analysis and

functional specifications development, in addition to implementing code

changes for secondary marketing ETL platform. This was part of a larger

initiative to replace the outsourced BAC servicing platform with

Countrywide's in-house platform in order to save the organization millions

annually in licensing costs.

09/03-09/05 Sr. .Net Architect, Wipro Technologies, Mountain View, CA

Managed top Fortune 500 clients like, Farmers Insurance, PEPSI, SBC,

Southern California Edison etc.

1. Systems Engineering and Process Improvement.

2. Estimation and Proposal preparation.

3. Analysis, Design of Application Systems.

4. Onshore Offshore Team building and setup.

5. Client Management.

CRN: Customer Restoration Network- Farmer's Insurance Claim Division

05/05-09/05 Simi Valley, CA

Led project for systems integration of claims application (CRN) with

litigation case management tool (PROLAW) by leveraging existing B2B

framework. The initiative improved administration of law suits, reduced

life cycle time for a case, provided operational expense relief, reduced

panel referrals and established service bench marks.

1. Led requirements gathering sessions with the business.

2. Created Architectural, Design, Use case, Activity flow diagrams.

3. Architected the semantic database layer.

4. Managed resources and Customer (Single point of contact) along with

onshore/offshore coordination.

Technologies: C# .NET, UML, ASP.Net, Oracle 8i, IBM MQ Server, Harvest.

DSD: Direct Store Delivery - Pepsi Frito-Lay 01/04-

04/05 Dallas, TX

The goal of Direct Store Delivery (DSD) Advantage project was to improve

effectiveness of the frontline sales force of Frito-Lay (FL) US and Chilled

DSD divisions of Pepsi Co. A handheld application was developed to support

the day-to-day activities of Frito-Lay's routine sales force consisting of

approximately 17,000 route sales people in FLUS.

1. Led Requirement gathering and analysis sessions.

2. Led JAD sessions for design and development of framework component

architecture.

3. Acted as functional Lead and liaison between business and development

teams.

4. Designed and developed Windows Services to integrate DSD with INGEN.

5. Was responsible for hiring, performance reviews, promotions and

compensation changes.

6. Led Code and Test case review sessions to maintain high quality

standards.

7. Was responsible for Onshore - Offshore Co-ordination, Client

Management and timely delivery.

Technologies: WinCE4.2, WinCE5.0, .Net compact framework, SQL ASA Anywhere,

Erwin4.1, C# .NET, UML, StarTeam, Bluetooth.

06/99-09/03 Module Lead / Consultant, HCL Technologies

Designed and deployed mission-critical financial systems for World Wide

Customers like St.George Bank ( Australia), Alliance Bank ( Malaysia),

AMAL Insurance ( Malaysia) and many more...

1. Played key role in process Improvement initiatives and SEI-CMM5 (2002)

and Six Sigma (2003) certifications for the company, which was on of the

top five organization goals.

2. Was instrumental in meeting key deliverables for ensuring SEI-CMM

level 5 certification as key member of the FAR (Functional Area

Representative) group.

3. Was responsible for Cost/Time Estimation, Project Scope, Proposal

preparation and Client presentation.

4. Analysis and Design of Application and Database Management Systems.

5. Was responsible for staffing, reviews and compensation

recommendations.

ABB: Web Intranet Portal, Alliance Bank Berhd 11/02-

09/03 Kaula Lumpur, Malaysia

Designed and built corporate intranet portal to enable ABB to share

corporate information across the organization. Additionally, implementing a

web based corporate repository system and a workflow based claims

management system for addressing internal staff claims.

1. Led the System Requirement analysis team to conduct project

feasibility analysis.

2. Led core design team for designing/implementing the initial solution

using .Net.

3. While stationed onsite at customer location, managed deployment,

gained customer confidence, provide training, and obtained UAT.

4. Essayed the role of Configuration Manager and established backup

policies, VSS version controlling, Traceability matrix and change

Management.

5. Was responsible for Onshore - Offshore Co-ordination and Client

Management.

Technologies: Panagon FileNet E-Process, ASP, ASP.Net, SQL Server 2000,

FileNet Content, Windows NT/2000.

CLAS: Customer Lending Application, St. George Bank

03/01-03/02 Sydney, Australia

CLAS is a GUI based application. The project is a complete business

solution for different loan denominations applicable in St. George bank. It

works for credit cards, personal loans, portfolio loans, housing loans and

other secured loans offered by the bank.

. Involved in design, coding and testing of various modules for the

application.

Module 1:

. Quickly grasped the existing functionality to improve the old

Architecture.

. Special Technique was implemented for multiple references and simple

references of data and without fully knowing them could quickly grasp

and show the results.

Module 2:

. Responsible for 3 major modules of "Quick Quote Release" (Notes,

Tracking, Quick Quote Usage System).

. Developed the Exception Handling module for the application.

. Responsible for production deployment - Huge success winning the

confidence of the customer.

Module 3:

. Worked in the Loan Decision System (LDS), which had interaction with

MQSI and Mainframes system. Captured information available in CLAS to

transmit it to the host interface via XML Templates. Information was

filled into the XML templates and passed to the Host system. The Host

system decision was captured and displayed in CLAS.

Technologies: Forte 3.0.N.1 (Forte 4GL), DB2 7.1, MQ Series, WinNT 4.0, AIX

Server, OCX Release 5.0

EDUCATION

1999 Bachelor of Technology Major in Computer Science, Delhi Institute of

Technology (DIT), University of Delhi, India

TRAINING

. Dynamics of Interpersonal Communication, UCLA Extension, Los Angeles. -

2008.

. Essential .NET 2.0 with C#, Developmentor, Malibu Hills - 2007.

. Introduction to Secondary and Mortgage Capital Markets, Countrywide,

Calabasas - 2005.

. Corporate Training on Project Management Program (PMI) by Wipro

Technologies. - 2004.

. MCAD and MCSD Certified. - 2003.

. Attended New Leader's Program in Wipro Technologies - 2003.

Contact this candidate