SHANKHAJIT GHOSH

PROFILE:

** ***** ** ***** ** project experience as a Business Analyst, DBA and Research/Solutions Analyst.

* ***** ********** ** * Sr. Business Systems Analyst / Project Lead in business analysis, system

analysis, business process management, IT risk analysis / management, data analysis/ data modeling,

process designing, QA analysis/Testing, project co ordination/ management.

Proven track record as a business analyst / business process architect in financial (including Fortune 50

companies and big 4 consulting experience) / retail financial services/ mortgage banking, education /

publishing industry, accounting, insurance, healthcare, government 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, Feature Driven Development) to Rational Unified process (RUP).

Extensive experience with application development, web based solutions development, e-commerce,

relational databases, data warehouses, ERP, ECM and CRM 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.

W ell versed with Six Sigma and CMMI principles.

Very well versed in technical writing, documentation, presentation and delivery.

Project experience with various technologies, frameworks, applications, principles (SOX, ITIL guidelines).

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

Excellent communication, analytical, management and interpersonal skills.

IT COMPETENCIES:

Object-oriented analysis and design; Experience with Rational Unified Process

Software Engineering

(RUP); UML modeling (use cases, sequence, collaboration, activity, state

chart, class, package, deployment diagrams) and structured modeling

(dataflow diagrams & ERDs); Solid experience with all stages of SDLC

(ranging from traditional to agile development practices), JAD/JAR, RAD.

Quality assurance and testing.

Programming / scripting Java, C, C++, C#, PL/SQL, VBA, Delphi, ASP.NET, HTML, XML, Action

Languages Scripts

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

Software Platforms W indows 9x/NT/2000/XP, Mac OS X, UNIX/Linux, Mainframe Systems

Application Packages: Enterprise Architect, Rational Requisite Pro, Rational Rose, MS VISIO,

Business Objects, MicroStrategy, Cognos, Peoplesoft Financials, Teradata,

IRise, Visual Source Safe, Sharepoint, Team Foundation Server, ClearCase,

Crystal Reports, MS Office, MS Project, IBM Workbench, IBM Websphere.

Testing tools Test Director/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:

Shankhajit Ghosh 1

McGraw -Hill Education (SSG Technology Group) January, 2009 – Present

8787 Orion Pl, Columbus, Ohio

L ead Business Systems Analyst

ConnectED release 1.1.1 to 1.1.3: ConnectED is an online portal education system t o be used by the K-12

school system across United States. ConnectED has its own con tent management system (ECM / CMS)

and is integrated with other applications (such as AdvanceTracker, MyBooks, JRN, Passkey etc.) owned by

McGraw-Hill education/SSG Technology Group. ConnectED offers online courses, classroom management,

assignments and assessments, user license management on McGraw-Hill contents, user profile

m anagement and various reporting capabilities. ConnectED is associated with CMS and RMS (relationshi p

m anagement system) through which the authorized users can also manage simple and complex assets,

course structures, publishing of assets, licensing management.

Roles and responsibilities:

Acting as a liaison 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.

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

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.

Creating / Updating AS-IS/TO-BE Business Process Models and validating with stakeholders.

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 mapping, template designing ( including pseudo coding in SQL) f or

ConnectED and RMS reports.

Writing test cases / test scripts f rom requirements, use cases, business rules and UI spec documents.

Maintaining and formatting test scripts in Quality Center 9.2.

Executing test scripts (including SQL queries) on different ConnectED and CMS modules, ConnectED-

RMS interfaces.

Performing ConnectED GUI testing using Quick Test Professional (QTP).

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

T racking/managing test defects/issues in Quality Center 9.2 and coordinating bug remediation.

T echnical Documentation as per Six Sigma Standards, release review decks f or the evolving application.

Uploading, maintaining and distributing documents on MS SharePoint.

Creating and updating user manuals f or ConnectED modules.

Environment: MS Visio, Case Complete, UML, SnagIT, IRise, MS Office, MS Project, Quality Center 9.2, QTP,

W inRunner, Oracle 10g, Java/J2EE, Crystal Reports, MS SharePoint, Base Camp, DHTML, XML, MS Windows.

Shankhajit Ghosh 2

JP Morgan & Chase (Retail Financial, Default -Program Mgmt) F ebruary, 2008 – November, 2008

3415 Vision Dr, Col umbus, Ohio

Sr. Business Analyst / Business Process Modeler

Default, Voyager: T he Voyager project is a 70 + m illion dollar project involving the implementation of new

servicing systems for JPMorgan Chase & Co. T hese servicing systems are to support both t he Servicing

and Default business units, covering approximately 5.5 million m ortgage l oans. In this assignment all the

Prime, Non Prime, HE (Home Equity), mortgage banking, investment banking processes are being revisit ed,

refined and a number of legacy systems are being upgraded/replaced with new versions. Voyager included

updating/replacing/integrating applications such as CheckTracker, iVault, debt management systems(DM S),

DRI, MSP/Lending Portal, F ixed Income products, various reports, cash management systems, enterprise

content management system, external (e.g. Fidelity, DRI, Lexis-Nexis, Fannie Mae, Freddie Mac, Banko,

F irst American etc) and internal interfaces.

Roles and responsibilities:

Assisting Retail Financial Services / Default Program Management and IT in project scoping, gap

analysis, managing resources f or conversion/integration projects.

Acting as a liaison between stakeholders f rom different Lines of Business (such as Bankruptcy,

Foreclosure, Claims, REO, Invoice Processing and Quotes, Collections, Debt Settlement Agencies, Loss

Mitigation, DCD, DFR, Cash Management, Customer Care/HR, ECM etc) 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, various bonds and other products/applications.

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.

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 and documenting/managing deliverables.

Following up with Stakeholders (including Vendors) to complete work Items and reaching milestones.

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

Creating/ managing/sharing software architecture documents f or monthly releases.

Eliciting requirements for relational databases, stored procedures, triggers and various reports.

Usability analysis/ Prototyping/ UI designing using iRise, Photoshop, SnagIT. Obtaining UI sign-offs.

W riting User Acceptance T est Cases f rom requirements and managing them in Mercury Quality Center.

Performing system testing (with PL/SQL queries), UAT on the evolving systems by default and Chase IT.

T est defect tracking in Quality Center and coordinating bug remediation.

Managing, version controlling, distributing project documents, release review decks via Sharepoint.

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

T raining users, peers on various deliverables, process steps/methodologies, tools, applications.

T echnical writing with compliance with CMMI level 3 practices and presentation of documents.

Environment: RequisitePro, IBM Workbench, IBM W ebsphere Commerce 6.0, BEA Weblogic, Rational Data

Architect, Rational Software Architect, iRise, SnagIT, SharePoint/MOSS, C NET, Business Objects, Oracle 10g

release 2, DHTML, XML, IBM-IMS, TSO/Mainframe Systems / COBOL, Cyrstal Reports, MS Project, Quality

Center, Quick Test Professional ( QTP), ClearCase.

Shankhajit Ghosh 3

Clerk of the Circuit Court - Hillsborough County, Florida ( MIS) April, 2007 – December, 2007

T ampa, Florida

L ead Business Systems Analyst

T raffic Court and Highway Safety Admin System: Hil lsborough County G overnment, Florida i nitiated an

effort t o automate their traffic court system. The business processes were revised and the legacy systems

were reengineered. New application models were developed which interfaced with legacy systems and

eventually replaced them. The business/system process was divided into four segments – I ntake, Case

Management, In-Court Processing, Payment Processing (including Bonds/Bond holder Management ).

F amily Law and Domestic Violence Court s: T he FDV court processes were also remodeled and

implemented similar t o the traffic court system. FDV system had f our segments – Case Initiation, Case

Management, In-Court Processing, Payment Processing (including Bonds/Bond holder Management)..

Roles and responsibilities:

Interfacing between different lines of stakeholders in Hillsborough County (Tampa, FL), Florida State

Government (in Tallahassee), IT/ MIS and other external interfaces.

Assisting PM in project scoping, Creating/Managing RFI, RFP, iteration planning, creating and assigning

product backlog items, sprint backlog items, sprint backlog tasks.

Mentoring / Training Junior Business Analysts and QA Analysts for conversions/system integrations.

Gathering requirements as per ITIL guidelines in Agile (SCRUM) environment and obtaining sign-off.

Business Process reengineering and documenting the AS-IS and TO-BE business process models/

Workflows in Enterprise Architect (EA) f or Government web portals and applications.

Detailing, documenting and managing requirements and business intelligence rules f or Intake, Case

Management, In-Court processing, Payment/Statement Processing, Credit Card processing modules.

Gathering requirements and business rules for Enterprise Content Management Systems (ECM).

Generating requirement reports and conducting periodic requirement reviews.

Coordinating daily stand-up (Agile/SCRUM) reviews between team members and subject matter experts.

Gap Analysis, Operational Risk Analysis, IT Risk Analysis and preparing contingency plans.

Constructing Use Cases, activity diagrams, sequence diagrams as needed during the lifecycle.

Creating class diagrams, package diagrams, data flows for evolving databases and data warehouses.

Defining EDI/ EDW / ETL requirements, data mapping, stored procedures, triggers, layouts f or huge

number of batch and on-request financial reports the county clerks are using.

On-site and offshore Vendor Management.

Presenting Software Requirements Specification (SRS) to stakeholders and obtaining sign-off.

Managing change/enhancement requests and updating software architecture documents.

Developing UI Screens / prototypes/ Wireframes using MS Visio, MS Paint, iRise Visual Studio.

Functional and Integration testing of different modules of the application.

Creating T est Plans, Test Scripts ( with PL/SQL) and running test cases for various applications.

Creating UAT test scripts and Coordinating UAT sessions.

T racking test bugs in T eam Foundation Server and assigning them to team members.

T echnical writing/ creating user guidelines/reference manuals f or the implemented system.

Environment: Enterprise Architect – Corporate Edition, MS Visio, MS Office, Business Objects, Team

Foundation Server(TFS), Sharepoint/MOSS, C NET, Oracle Siebel 7.8, Teradata, Peoplesoft Financials, SQL

Server, XML, iRise, Mainframe / TSO / COBOL, BEA Weblogic, Crystal Reports, Quality Center, MS Project,

Linux ( Red hat).

Shankhajit Ghosh 4

PricewaterhouseCoopers LLC (USIT division) July, 2006 – April 2007

3109 W. MLK Jr. blvd, Tampa, Florida

Business Systems Analyst / Business Architect

1. Knowledge Gateway Search: Knowledge Gateway Search is used by US firms for searching critical

information and supporting day to day work by all PwC employees. Gateway Search is basically used for

searching documents, searching people by topic, searching people by name. Knowledge Gateway Search is

implemented by utilizing various data sources/collections and tools.

Other Projects at PwC: 2. F ederated 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. Knowledge Vista.

Roles and responsibilities:

Acting as a liaison between business users and IT stakeholders (managers, tech leads, developers, testers,

subject matter experts etc.)

Assisting the PwC Project Managers with the project planning, estimation, deliverables and milestones.

Analyzing/ documenting business requests, business process models, RFI/RFP for multiple initiatives.

Eliciting / documenting business and system requirements, business rules complying with Sarbanes-

Oxley (SOX) principles, functional/technical specifications f or ERP, ECM, EDW, EDI, audit plans.

Actively participating in release scoping, gap analysis, operational/regulatory risk analysis, IT risk

analysis, documenting change requests/ contingency plans f or monthly and quarterly releases.

Coordinating/Interfacing between offshore teams (US, UK and Asia) and vendors.

Detailing business requests to functional, non-functional/architectural requirements with use case

scenarios and other UML diagrams in Rational Rose, UI Mock ups / wireframes and prototypes.

Creating software requirements specification (SRS) and obtaining sign off from the stakeholders.

Creating / Updating AS-IS/TO-BE Business Process Models and validating with stakeholders.

Gathering database, data warehouse requirements and creating class diagrams, data flow diagrams.

Obtaining UI and functional design (using iRise) sign-off f rom stakeholders.

Acting as a subject matter expert for search applications and interfacing various stakeholders.

Creating UAT test plan, writing UAT test scripts, coordinating and conducting UAT .

Data mapping, validation, testing ( PL/SQL) of financial and SOX compliance reports.

QA analysis / defect tracking with compliance with Six Sigma Principles (DMAIC).

T echnical Documentation as per Six Sigma Standards, release review decks f or the evolving systems.

T raining end users on the evolving applications/new functionalities.

Environment: Rational Rose, Rational Requisite Pro, UML, IBM WebSphere Commerce 6.0, Rational Software

Architect, Rational Data Architect, SnagIT, IRise, MS Office, MS Project,, Mercury Test Director 8.0 SP2 / Quality

Center, BEA Weblogic, Microsoft VSS 6.0, Oracle, Informatica, Java, Documentum, PeopleSoft Financial s 8.4

and 8.9, Cognos, Crystal Reports, Oracle Siebel 7.8, Mainframe Systems / COBOL, ClearCase, ClearQuest.

Westfield Insurance. ( Westfield IT) O ctober, 2005 – May, 2006

1 Park Cir, W estfield center (Lodi), Ohio

Business Analyst

AIS /APR Rewrite 1.0: W estfield Insurance implemented the AIS 1.0 (Agency Information System) system to

support various new functionalities for all the end users as well as other systems referenced to and from the

legacy AIS system (That has now been updated to AIS 1.0). The agency production record (APR) system was

also added with the capability of incorporating new data formats, functionalities, agency and policy information.

Existing, new and customized APR (online and hardcopy) reports were supported by the new system.

Shankhajit Ghosh 5

AIS Decommissioning: The legacy AIS system at Westfield insurance was decommissioned in stages by

turning off the existing components and functionalities and replacing them with new additions. The AIS Interim

Solution was constructed to support the users and other systems while decommissioning the legacy AIS.

AIS 2.0 organizational mapping: The AIS 2.0 on-contact system was responsible for handling the

organizational mapping (business organization and geographical distribution) and provide information to the APR,

AIS, Peoplesoft financials and other systems at Westfield.

Roles and responsibilities:

Acting as liaison between Personal Lines, Commercial Lines, Surety, Marketing and IT groups.

Conducting JAD sessions and gathering software requirements and business / web intelligence rules.

Eliciting business and technical requirements for evolving property and casualty insurance systems.

Documenting needs, features, business rules, supplementary specifications etc in Requisite Pro.

Managing the attribute matrix, traceability matrix, traceability tree in RUP framework.

Operational risk modeling, IT risk modeling, preparing contingency plans f or Westfield IT.

Confirming all requirements with the vision document (project charter) and business rules verification.

Providing various requirement reports in Rational SoDA f or different user groups.

Process Models, Use Case Analysis, Activity Diagrams, E-R Diagrams/RDBMS Designs, UI prototypes.

Providing data mapping, report requirements, pseudo code for stored procedures and triggers.

Presentation of Use Cases, UI designs / wireframes and software requirements to business groups.

Eliciting Enterprise data warehouse requirements/validation rules and obtaining SRS sign-offs.

T raining/mentoring peers on using Rational Requisite Pro, Rational Rose and Rational SoDA.

Creation/management of test plan, test scenarios, test cases ( using PL/SQL)

Conducting UAT (User Acceptance Testing) and provide recommendations.

T echnical Writing as per CMMI Level 3 standards and production support for W estfield-IT applications.

Environment: Rational Rose, Rational Requisite Pro, Rational SoDA, MS Project, Mainframe / COBOL, SQL

server, Teradata, Business Objects, J2EE,Crystal Reports, Documentum, PeopleSoft Financials, Test Director.

HCR Manor Care. (IT) [Pharma / Healthcare] O ctober, 2004 – September, 2005

333 N Summit Street, Toledo, Ohio

Business Systems Analyst

PF-04 billing system: PF-04 is a multi million dollar benchmark application. The legacy billing/invoice processing

and tracking systems were being decommissioned by the new systems/enhanced functionalities to integrate

individual healthcare departments and associated nursing and rehabilitation centers operated by Manor Care, Inc.

Roles & Responsibilities:

Business process re-engineering f or PF04 online system and providing/documenting suggestions.

Requirement gathering, documenting project deliverable in agile environment (extreme programming).

Conducting JAD/requirement workshop f or billing, clinical trials, reports f or positive safety/efficacy.

Performing gap analysis, operational risk modeling, IT risk modeling and risk management.

Creating Use Cases, Class diagrams, Activity diagrams, database models and UI/ Wireframes.

Creating Functional and Design Specifications/Technical Writing for ECM, EDW/ETL applications.

Process analysis and creation of Business intelligence rules / web intelligence rules.

Creating test plans (Test First Development), UAT, System Testing (PL-SQL)/Defect Tracking.

Environment: Borland Caliber, MS Office, MS Visio, MS Project, Mainframe / COBOL, BEA Weblogic,

Informatica, Sieble(CRM), Oracle, Peoplesoft Financials, JSP, JavaScript, DHTML, J2EE, XML / WSDL,

Documentum, Erwin, Photoshop, Dreamweaver, Macromedia Flash, Mercury Test Director, UNIX.

Shankhajit Ghosh 6

Fifth Third Bank ( 5/3 IT) July, 2002 – September, 2004

1 Seagate, Suite 220, Toledo, Ohio

Business Analyst

E- Portfolio View: provides real-time Internet access to the bank’s corporate institutional account information,

including deposits, interests, account activity and investments/ Fixed Income/Brokerage Analysis. The Project

was undertaken to enhance the existing functionality of (1) convenient access to real-time account information, (2)

ability to download account information, (3) option to enroll staff or service providers (e.g., corporate accountant,

auditor or financial advisor) along with addition of new reports.

Roles and responsibilities:

Requirement gathering and documenting project deliverables f or the web development lifecycle.

Creating/Managing business cases, RFPs, RFIs, business and system requirements, change requests.

Operational risk analysis, IT risks analysis and management f or Fifth Third Processes and systems.

Creating use cases, activity diagrams, class diagrams, package diagrams in RUP framework.

Documenting/Managing business rules, requirements f or distributed applications and web portals.

Business process management and creating workflow diagrams/process models.

Gathering Business Rules for Fixed Income/Security products such as ABS, MBS, CDO, CMO etc.

Conducting JAD sessions to resolve issues pertaining to development and testing.

Creating functional and software architectural design specification documents f or different applications.

Gathering requirements for Relational Databases, data warehouses (EDW), ECM, financial reports.

Creation and Management of data models, class diagrams, UI Designs / Prototypes.

Developing a concise test plan and creating/ defining the test steps and test scenarios/test scripts.

UAT, System Testing (with PL/ SQL queries), Defect Tracking in Test Director.

Environment: Rational Rose, Rational Requisite Pro, UML, IBM BPM – W ebSphere, MS-Project, BEA Web

Logic, Java, DB2, Microstrategy, Teradata, Mainframe / COBOL, Filenet, DHTML, XML, CSS, Test Director.

ABB Inc. (IT / MIS) March, 2001 – July, 2002

29801 Euclid Ave, W ickliffe, Ohio

Business Systems Analyst / Solutions Analyst

# W orked on ABB’s regression testing software as a Research Analyst/Research Engineer on the initiative of

interfacing/integrating various real-time applications owned/utilized by ABB-USA, ABB-Europe and ABB-Asia.

# W orked as a System Analyst on researching, designing and defining regression testing software.

Praxis Softek Solutions Ltd April, 1998 – F ebruary, 2001

Sector-V, Salt Lake, Calcutta, India

Database Administrator/ Business Systems Analyst

W orked as a DBA ( MS Access, SQL Server, Oracle) on various projects/software solutions for Praxis Softek

Solutions ( e.g. Financial billing system for Matsushita Financial Trust/Japan, Employee Management System

f or Nokia, billing/ claims/clinical trials system for Apollo Hospitals Group – The Largest Healthcare in Asia).

PROFESSIONAL MEMBERSHIPS:

Association for Computing Machinery (ACM)

American Society for Quality (ASQ)

Agile Alliance, USA

REFERENCES: Available on request.

Shankhajit Ghosh 7

Contact this candidate