Project Six Sigma

SHANKHAJIT GHOSH

Contact no: 419-***-****

Email: ********@*****.***

PROFILE:

. 15+ years of total IT project experience as Business Analyst, IT Analyst

/ Solutions Analyst and DBA.

. 12 years experience as a Sr. Business Analyst / Business Systems Analyst

in business analysis, system analysis, business process management,

process reengineering/process designing, process improvement, risk

analysis / management, data analysis/ data governance, QA

analysis/Testing, project co ordination/ management.

. Proven track record in Government, TAX/Partnership Tax (including Fortune

50 companies and big 4 consulting experience) / Retail Financial

Services/ Mortgage Banking, Investment Banking, Education / Publishing

Industry, Accounting, Insurance, Healthcare and other industries.

. Experienced in interfacing between various business users and IT

stakeholders.

. Very proficient with UML modeling, object oriented modeling, process

modeling, data modeling.

. Skilled in eliciting user demands and translating them to functional

and non-functional requirements.

. Hands-On experience with all stages of SDLC s ranging from traditional

(e.g. Waterfall) to Agile (Extreme Programming, SCRUM) to Rational

Unified process (RUP) or customized SDLC.

. Extensive experience with application development, web based solutions

development, e-commerce, relational databases, data warehouses, ERP, ECM,

CRM, SAAS systems, contingency plans, reports,.

. Extensive experience with SOA and wide range of COTS applications and

their customizations/MOTS [ e.g. PeopleSoft Financials, Documentum,

SharePoint/MOSS, Filenet, DRI, ACAPS, MSP/Lending Portal, OTN Financial

Brokerage Services, TFS, Different Data Warehouses( e.g. Teradata,

Oracle), BI tools, Reporting tools, IBM/Rational Tool suites, Verity,

Factiva, Oracle, Microsoft Tools and many more]

. Proficient in QA analysis, automated / manual testing and using

various tracking tools.

. Well versed with Six Sigma (DMAIC/DMADV) methodologies, CMMI principles

and Sarbanes Oxley (SOX) compliance.

. Proficient in technical writing, documentation, presentation and

delivery.

. Experienced in vendor management, training users / peers, building

consensus.

. Excellent communication, project management, customer management and

interpersonal skills.

IT COMPETENCIES:

Software Engineering Object-oriented analysis and design; Experience with

Rational Unified Process (RUP); UML modeling and

structured modeling (dataflow diagrams & ERDs); Solid

experience with all stages of SDLC (ranging from

traditional to agile development practices), Six Sigma

(DMAIC/DMADV), JAD/JAR, RAD, Quality assurance/testing,

SAAS.

Programming / Java, C, C++, C#, PL/SQL, Toad, VBA, Delphi, ASP.NET,

scripting Languages HTML, XML, SAS, Action Scripts

Databases MySQL, Oracle, SQL server, DB2, MS Access, ERwin, DB

Designer

Platforms Windows 9x/NT/2000/XP, Mac OS X, UNIX/Linux, Mainframe

Systems

Application Packages: Enterprise Architect, Rational Requisite Pro, DOORS,

Rational Rose, MS VISIO, Casewise, MicroStrategy, SAS,

Cognos, PeopleSoft Financials, Teradata, IRise, Siebel,

Sharepoint, TFS, SSIS, SSRS, ClearCase, Crystal

Reports, MS Office, MS Project, IBM Workbench, IBM

Websphere, Axure Pro.

Testing tools HP ALM, Quality Center, Test Partner, NUnit, Load

Runner, Win Runner.

EDUCATION:

Master of Science in Computer Science, USA

Bachelor of Engineering in Computer Science & Engineering, India

WORK EXPERIENCE:

Ernst & Young, LLP

February, 2011 - Present

1101 New York Avenue NW, Washington, DC

Lead Business Analyst

Project: Partnership Tax Allocation System (aka PTS/PTAS for Private

Equity, Banking and Capital Markets, OTC Derivatives, Corporate Joint

Ventures - Real Estate, Oil and Mining, Telecommunication Domains).

Roles and responsibilities:

. Lead Business Analyst/ liaison between EY IT/technology teams and

business domains for about 2.5 years.

. Leading business analysis, systems analysis, process improvement

following Six Sigma methodologies, project tracking and reporting for

partnership tax projects and maintenance releases.

. Creating and maintaining Business Process Flows (As-Is, To-Be), System

Flows/activity diagrams.

. Process improvement for multiple business domains following Six Sigma

(DMAIC principles for existing and DMADV principles for new processes).

. Finalizing/managing project scope and creating/maintaining SIPOC tables

while in DMAIC.

. Pareto Analysis, Root Cause Analysis, Analysis of Variance, CTQ tree and

histogram creation per Six Sigma principles.

. Eliciting, analyzing, documenting business needs, detailed functional and

non-functional requirements after closely working with stakeholders for

Partnership Tax Allocation System and internal and external interfaces (K-

1 suite, Thomson Reuters GoSystems, Fund Allocation Reporting Systems,

Partner Forms, EY Compliance Systems etc).

. Use case analysis, use case modeling using MS Visio and use case

documentation.

. Creating and maintaining Requirement Traceability Matrix (RTM), Use Case

Catalog.

. Prototyping/ maintaining functional UI screens using AxurePro 6.5.

. Specifying UI requirements and generating Software Requirement

Specifications (SRS) document.

. Performing gap analysis, IT risk analysis, operational and regulatory

risks analysis, producing reports.

. Data analysis, documenting data requirements/field level requirements and

maintaining data dictionary.

. Maintaining requirements/business rules for Enterprise Data Warehouse,

Business Intelligence Tools.

. Creating and maintaining reporting requirements, report mock ups.

. Facilitating requirements review, UI review sessions and obtaining sign-

offs from stakeholders.

. Managing change requests/enhancement requests, documenting updates and

obtaining sign-offs.

. Verification of test plan, test cases against requirements and providing

feedback/suggestions to QA teams.

. Writing performance test cases/click paths for the system and verifying

them with business and QA teams.

. Acting as subject matter expert (SME) and providing clarifications,

support to development and QA teams.

. Performing smoke testing, user acceptance testing (UAT) and providing

recommendations.

. Defect tracking and remediation using HP Application Lifecycle Management

11.0 (ALM) tool.

. Onshore and offshore project coordination between business, project

management, analysts, development team, test team and vendors on a

daily/need basis.

. Knowledge transfer and training of partnership tax domain and PTS system

to new team members.

. Contributing to and providing training of business analysis best

practices to new team members.

. Creating and sharing status reports, release notes for project and

maintenance releases.

Environment: MS Visio, AxurePro 6.5, MS Project, HP Application Lifecycle

Management 11.0 (ALM), .Net, C#, SSIS, SSRS, SQL Server, SharePoint,

Teradata, Documentum, UAT, Six Sigma (DMAIC/DMADV),TQM.

Fannie Mae

June, 2010 - January 2011

13100 Worldgate Dr (OB1), Herndon, Virginia

Lead Business Systems Analyst / IT Analyst

Project: RisknetFM (Reengineering) v19.0, RisknetFM v15.0 - 17.1

Roles and responsibilities:

. Acting as a liaison between IT/technology and business divisions (Capital

Markets, HCD-Mortgage, Single Family, Multifamily, Corporate, Affordable

Housing, Others) in Agile environment/following Fannie Mae's SDLC

practices.

. Scope Management, business analysis, systems analysis, data analysis,

project tracking for projects on Fannie Mae's financial risk management

system (RiskNet) and Risk Operations office.

. Analyzing, documenting and managing business needs, functional and non-

functional requirements for Mortgage and other Financial Risk Management

System, for internal and external interfaces.

. Business case analysis, use case analysis for various modules( like

Exposures, Ratings, Limits, Financials, Collateral, admin and reporting

modules etc) of RiskNetFM reengineering and production.

. Process reengineering: Creating / Updating AS-IS/TO-BE Business Process

Models, Workflows.

. Process improvement following Six Sigma (DMAIC/DMADV) strategies and

tools.

. Maintenance of SIPOC tables, CTQ Tree, histograms, root cause analysis

results in Six Sigma-DMAIC.

. Translating business requirements into system requirements, COTS

integration, MOTS specifications.

. Performing gap analysis, risk analysis, producing reports and disaster

recovery plans.

. Creating / updating Functional and UI Design Documents/wireframes and

obtaining sign off.

. Updating requirements/rules for Enterprise Data Warehouse and Business

Intelligence Tools.

. Researching issues, querying EDW, data analysis, data governance.

. Creating and updating interface control document for different project

releases.

. Creating and maintaining Requirement Traceability Matrix (RTM), tracking

relationships between Requirements, Use Cases, Test Cases (using Rational

RequisitePro).

. Executing test scripts /QA analysis, conducting UAT and tracking defects

in Quality Center.

. Onshore and offshore coordination between business, project management,

analysts, development team, test team and vendors. Providing

clarifications, details and support on a daily/need basis.

. Maintaining and sharing project documents via SharePoint.

. Performance tracking, enterprise reporting, technical documentation.

. Production support for evolved projects and enhancements.

. Creating and sharing Release Notes for project and maintenance releases.

Environment: Rational RequisitePro, MS Project, MS Visio, Java/AJAX, GWT,

Oracle, Business Objects, Quality Center, iCART, COTS, MOTS, Hyperion, HP

Quality Center, Six Sigma (DMAIC/DMADV), SharePoint.

Capital One (Rewards IT)

August, 2009 - June, 2010

15000 Capital One Dr, Richmond, Virginia

Sr. Business Systems Analyst/Project Coordinator

Project: Helix Program / Capital One Rewards enhancements - TLP and TS2

projects (worked with credit cards, mortgage/home loan/refinancing systems)

Environment: SCRUM, DOORS, Rational Rose, Clarity, MS Project, Risk

Resolve, Cognos, Teradata, Business Objects, Java/J2EE, VRU/VoIP, Siebel,

Quality Center, WinRunner, LoadRunner, Basel II, XML, Visio, Clarity,

Hyperion, SAAS, Dataflux, COTS, MOTS, Six Sigma (DMAIC/DMADV), TQM.

McGraw-Hill Education (SSG Technology Group)

January, 2009 - August, 2009

8787 Orion Pl, Columbus, Ohio

Lead Business Analyst

Project: ConnectED release 1.1.1 to 1.1.3

Roles and responsibilities:

. Acting as a liaison in Agile environment (SCRUM) between SSG Technology

groups (project management, analysis, interaction design, development, QA

etc), Editorial groups, CMS and RMS groups at McGraw-Hill.

. Participating in project planning, estimation, release scoping, tracking

status and deliverables, documentation management for monthly and

quarterly releases.

. Coordinating daily status review meetings, documenting and circulating

status tracking sheets and minutes.

. Researching systems, market-trends and prospective users to analyze and

document end-user expectations.

. Process re-engineering and improvement for multiple business domains

following Six Sigma (DMAIC and DMADV principles).

. Maintaining SIPOC tables, CTQ Tree, Root Cause Analysis results,

histograms in DMAIC.

. Eliciting, analyzing and documenting business needs, business and systems

requirements for Online Portal, ECM/Content Management, E Commerce, COTS,

MOTS, Customer Care systems.

. Performing gap analysis, IT risks analysis, change request management and

producing reports and contingency plans. Acquiring consensus from

different stakeholders.

. Use Case analysis and Use Case modeling using MS Visio, Case Complete and

MS Office.

. Usability analysis, creating/updating UI wireframes/prototypes and UI

specification documents.

. Gathering data modeling requirements and creating class diagrams, data

flow diagrams.

. Creating and Managing Functional Design documents (including Functional

and Supplemental Requirements, Use Cases, Functional Rules and Business

Rules Business Process Diagrams, UI Specs, Data Models) for ConnectED,

CMS and ConnectED-RMS integration.

. Obtaining approval/ sign off on Functional Design Documents (FDDs) from

various stakeholders.

. Collecting business rules, data requirements, template designing

(included using SQL queries) for ConnectED and RMS reports and

requirements for batch processing systems.

. Writing test cases / test scripts from requirements use cases, business

rules and UI spec documents.

. Maintaining and formatting test scripts in Quality Center 9.2.

. Executing test scripts (PL/SQL queries)/functional testing on different

ConnectED and CMS modules, ConnectED-RMS interfaces.

. Performing ConnectED GUI testing, confirming usability, regression

testing, load testing, stress testing.

. Writing UAT scripts and coordinating UAT on ConnectED, CMS and ConnectED-

RMS interfaces.

. Tracking/managing test defects/issues in Quality Center 9.2 and

coordinating bug remediation.

. Technical Documentation, release review decks for the evolving

application.

Environment: DOORS, UML, SnagIT, IRise, Casewise, MS Project, Quality

Center 9.2, QTP, WinRunner, LoadRunner, Oracle10g, PL/SQL, SAS for K-12,

Dataflux, Java/J2EE, JavaPOS, COTS, MOTS, Cognos, MS SharePoint, Six Sigma

(DMAIC/DMADV), Microsoft CRM 4.0.

JP Morgan & Chase (Retail Financial, Default-Program Mgmt) January,

2008 - November, 2008

3415 Vision Dr, Columbus, Ohio

Sr. Business Architect / Business Process Modeler

Project: Default Mortgage, Voyager

Roles and responsibilities:

. Assisting Retail Financial Services / Default Mortgage Program Management

and IT in project scoping, gap analysis, root cause analysis, managing

resources for conversion/integration projects.

. Acting as a liaison between stakeholders from different Lines of Business

(such as Bankruptcy, Foreclosure, Claims, REO, Invoice Processing and

Quotes, Collections, Affordable Housing, Debt Settlement Agencies, Loss

Mitigation, DCD, DFR, Cash Management, Transfer Agencies, Customer

Care/HR/Call Center etc), Merger and Acquisitions and Chase IT groups.

. Eliciting, documenting / detailing functional, non functional/

supplemental requirements, business rules/web intelligence rules from

users, existing systems for the evolving applications.

. Eliciting Business Rules for maintaining Home Loans, Fixed Income

Products/ Debt Securities, Financial Brokerage systems, Ecommerce

Systems.

. Assessment of Operational risks with ISO 4 step model, credit risks,

market risks, IT risks and preparing risk level matrix and contingency

plans/disaster recovery plans/business continuity plans. .

. Business Process Reengineering, creating/updating Business Process Models

(AS-IS and TO-BE) using IBM Workbench, IBM BPM - WebSphere following Six

Sigma (DMAIC/DMADV) principles.

. Process measurement (metrics), process monitoring, process improvement.

. Coordinating data exchange sessions between and gathering requirements

for EDI / transactions.

. Identifying external, internal Interfaces, data exchange points, ECM and

EDW requirements, work items, hand-offs, compliance rules, financial

report requirements, documenting/managing deliverables.

. Creating/Updating Use Cases, activity diagrams, class diagrams, data

Models/ data flow diagrams.

. Eliciting requirements for relational databases, batch processing systems

and various reports.

. Usability analysis/ Prototyping/ UI designing using iRise, Photoshop,

SnagIT. Obtaining UI sign-offs.

. Writing User Acceptance Test Cases from requirements and managing them in

Mercury Quality Center.

. Performing system testing (PL/SQL queries), UAT, regression testing, load

testing, stress testing.

. Test defect tracking in Quality Center and coordinating bug remediation.

. Managing, version controlling, distributing project documents, release

review decks via SharePoint.

. Training users, peers on various deliverables, process

steps/methodologies, tools, applications.

. Technical writing in compliance with Sarbanes Oxley (SOX) principles.

Environment: DOORS, Rational Rose, IBM Workbench, IBM Websphere Commerce

6.0, BEA Weblogic, Rational Data Architect, Basel II, iRise, SnagIT,

SharePoint/MOSS, C NET, Siebel, Business Objects, Oracle 10g release 2,

Dataflux, Peoplsoft Financials, DHTML, XML, SAS, COTS, MOTS, Cyrstal

Reports, MS Project, Quality Center, LoadRunner, WinRunner SAAS,

ClearQuest, Six Sigma (DMAIC/DMADV).

Clerk of the Circuit Court- Hillsborough County, Florida (MIS of

Hillsborough County, FL and State Government of Florida)

April, 2007 - December,

2007

Tampa, Florida

Business Analyst / Project Coordinator

Project: Traffic Court Admin System, Family Law and Domestic Violence Court

systems.

Environment: SCRUM, Enterprise Architect - Corporate Edition, MS Visio, MS

Office, Business Objects, Team Foundation Server (TFS), SharePoint/MOSS,

C NET, Oracle, MicroStrategy, Teradata, PeopleSoft Financials, SQL

Server, XML, Captiva, iRise, Mainframe / TSO / COBOL, BEA Weblogic, Crystal

Reports, COTS, MOTS, UAT, Quality Center, WinRunner, LoadRunner, Microsoft

CRM, MS Project, Six Sigma (DMAIC/DMADV).

PricewaterhouseCoopers LLC (USIT division) July,

2006 - April 2007

3109 W. MLK Jr. blvd, Tampa, Florida

Business Systems Analyst / Business Architect

Project: 1. Knowledge Gateway Search, 2. Federated Search Pilot, 3.

Accounting and Auditing Search, 4. KCurve2 (Web Portal) Search (for US, UK

and other Global firms), 5. Enterprise Content Management (ECM) system, 6.

People Search /Expertise, 7 SEP-IRA / TAX application, 8. Mortgage/Real-

Estate, 9. Knowledge Vista.

Environment: Rational Rose, Rational Requisite Pro, UML, Casewise, IRise,

MS Office, MS SharePoint, MS Project, Mercury Test Director 8.0 SP2 /

Quality Center, Microsoft VSS 6.0, Oracle, PL/SQL, MicroStrategy, Java,

Informatica, Documentum, PeopleSoft Financials, COTS, MOTS, Cognos, UAT,

LoadRunner, WinRunner.

Westfield Insurance (Westfield IT)

October, 2005 - May, 2006

1 Park Cir, Westfield center (Lodi), Ohio

Business Analyst

Project: AIS /APR Rewrite 1.0, AIS Decommissioning: AIS 2.0 organizational

mapping.

Environment: Rational Rose, Rational Requisite Pro, Casewise, MS Project,

Mainframe, SQL server, PL/SQL, Teradata, Business Objects, J2EE,Cognos,

Documentum, PeopleSoft Financials, Siebel, UAT, Test Director.

HCR Manor Care. (IT - Healthcare)

October, 2002 - September, 2005

333 N Summit Street, Toledo, Ohio

Business Systems Analyst

Project: PF-04 billing system, HCRF-04 healthcare monitoring system, HCRRM-

04 pharmacy tracking system projects.

Environment: Borland Caliber, MS Office, MS Visio, MS Project, Mainframe /

COBOL, BEA Weblogic, Informatica, Sieble(CRM), Oracle, PL/SQL, PeopleSoft

Financials, Siebel, JSP, JavaScript, DHTML, J2EE, XML, Captiva, Documentum,

Erwin, Dreamweaver, Macromedia Flash, MS SharePoint, UAT, Mercury Test

Director, UNIX, Six Sigma (DMAIC/DMADV).

ABB Inc. (IT / MIS)

March, 2001 - August, 2002

29801 Euclid Ave, Wickliffe, Ohio

IT Business Analyst / Solutions Analyst

# Worked as IT Analyst on ABB's regression testing software implementation

(manufacturing, real time systems).

REFERENCES: Available on request.[pic][pic][pic]

Contact this candidate