Sujoy Ganguly. Ph: 512-***-****. Email: abl5q5@r.postjobfree.com

Driven Dynamic, business-savvy Business Analyst with excellent

communication skills, and more than seven years of combined experience

in Public Sector, Pharmaceuticals, Manufacturing, Semiconductors and

specialty Consumer Goods.

PROFESSIONAL SUMMARY:

. 8+ years of experience in Business Analysis, gathering business and

functional requirements, and defining specifications across the entire

Software Development Life Cycle and Rational Unified Process in the

areas of Public Sector, Pharmaceuticals, Manufacturing, Semiconductors

and specialty Consumer Goods. Deep experience with SDLC in multiple

business verticals.

. 8+ years of experience in Business Process Re-engineering, Business

Process Optimization, system scope definition, enhancements,

customizations.

. 8+ years of experience in gathering requirements by conducting JAD and

RAD sessions, one-on-one interviews, brainstorming sessions,

requirement reviews, storyboarding and system walkthroughs.

. 8+ years of experience with AGILE methodologies and techniques:

continuous integration, automated or xUnit test, pair programming,

test driven development, design patterns, domain-driven design, code

refactoring.

. 8+ years of experience in documenting requirements and preparing

Business Requirements Document (BRD), Functional Requirements

Specifications (FRS), System Requirements Specifications (SRS),

Requirement Traceability Matrix, Users Guides, etc

. 8+ years of experience in visual modeling and business process

modeling using MS Visio and Rational Rose.

. 8+ years in writing Use Case Narratives and preparing Entity-

Relationship diagrams, Use Case Diagrams, Data Flow Diagrams,

Workflows, Activity Diagrams, Sequence Diagrams, Collaboration

Diagrams, Class and Object diagrams

. 8+ years of experience in conducting Gap Analysis between "As Is" and

"To Be" systems.

. 7+ years of experience in SAP R/3 systems, specifically relating to

SAP SD (Sales and Distribution) and HCM (Human Capital Management)

modules.

. Expert level resource in "order-to-cash" and HR business processes and

functionalities.

. Expert with 7+ years of experience in data mapping and ETL.

. Have led efforts to gather user feedback via Usability and Feasibility

studies.

. Expertise in MS Word, Excel and Powerpoint.

. Expertise in retrieving data using Business Objects Universes,

personal data files, stored procedures and free hand SQL methods

. Expert tester: 7+ years of experience in compiling unit test scripts,

integration test scripts, regression test scripts and leading the

testing effort at client sites.

. 8+ years of experience in Integration, Performance and Regression

testing and User Acceptance Testing for various projects using manual

methodologies and automated tools.

. Solid working knowledge of Mercury Quality Center, WinRunner and Load

Runner.

. SOX Compliance expert - worked closely with SOX principles, controls

and audit teams.

. Solid experience working with different Content Management Systems.

. Excellent interpersonal and communication skills. Strong leadership

qualities and problem solving skills.

TECHNICAL PROFICIENCIES:

Business Analysis Tools: Rational Suite of tools, Adobe Fireworks, UML,

Rational tool suite, MS Visio, MS Excel

Programming Languages: C, C++, JAVA, Visual Basic, FORTRAN, COBOL

SAP Modules: Sales & Distribution (SD) Order Management & Pricing, SAP HCM

and Cross functional experience in MM, WM and FI. Worked on versions 4.5B,

4.6C and ECC 5.0

SAP Business Objects 6.5, XI R2

Web Technologies: HTML, DHTML, JSP, EJB, XML, Java Script, VB Script, Web

logic server and Web sphere

RDBMS: MS SQL Server, Oracle, MS Access

Operating Systems: UNIX, Windows 95/98, Windows NT/2K/XP

PROFESSIONAL EXPERIENCE:

Senior Business Analyst, City of San Antonio, San Antonio, Texas

Apr '09 - Present

Project Description: The city of San Antonio (COSA) employs various

disjoint systems to execute sales within its various departments. The goal

of this project was to conduct an in-depth analysis of the As-Is financial

and sales business processes at the various departments (60+ business

areas), track the flow of revenue into SAP - the financial system of

record, and to create the To-Be landscape description for a new Point of

Sale (POS) system which would integrate seamlessly with SAP in real-time at

the sales transaction level.

RESPONSIBILITIES

. Requirements Gathering and Documentation Expert - Interacted with over

70 end-users from all levels to gather requirements, understand their

current business processes and bottlenecks, and translate their input

into lucid, crisp functional and technical requirements. Built an

exhaustive traceability matrix (MS Excel) to ensure that the

completeness and sequence of requirements was maintained. Assisted the

business in defining and maintaining cascading priorities and

dependencies within requirements. Employed UML modeling extensively to

capture requirements. (Activity, Class, Use Case, Timing and State

Machine Diagrams).

. Systems Integration Expert: Analyzed existing system landscape to

integrate MS Sharepoint with SAP Business Objects.

. Financial Business Analysis Expert - Conducted 60+ efficient,

streamlined JAD and JAR sessions to precisely articulate the business

requirements of various COSA departments. These departments used

payment collection mechanisms ranging from plain hand-written

notebooks to stand-alone, stable systems which did not interface with

SAP or the cash registers.

. BPE - Business Process Re-engineering - Observed 70 + end-users and

documented their system actions to identify the scope for business

process improvements. My findings significantly lessened average

transaction time. Worked with the IT team to examine these findings

and incorporate recommendations into revised training material. My

input was slotted into short-term fixes, long-term training issues and

quick fixes though spot end-user re-training.

. Documentation Expert - created As-Is and To-Be documentation for 60 +

COSA departments. This exhaustive body of work contained MS Visio

flowcharts for each separate business process and was the first

official record of the systems and methods within these departments.

It also contained documentation about recommendations, process issues,

and violations. All documentation was maintained within Sharepoint.

. System Architecture Expert - Worked closely with various COSA IT teams

(SAP, Mainframe systems, support teams and Business User team leads)

to articulate the various systems landscapes in use - in many cases

this documentation did not exist earlier. Owned deployment timeline

for the various system fixes that had been identified. This involved

understanding the inter-dependencies of the adjustments and the order

in which they would be deployed. Advocated and educated the business

on Agile methodologies to create track-able progress in small

increments by developing-testing-integrating. The final proposed

solution was a centralized, Object-oriented website which presented

relevant functionality based on User ID class.

. Business User Expert - Obtained sign-off on key POS requirements for

the various systems. Interacted with high-level stakeholders to

demonstrate, through presentations, the Return on Investment (ROI)

associated with the new POS system, all advantages thereof, the impact

of real-time integration with SAP and the crucial need to create

various system enhancements. These presentations were key in gaining

business user confidence.

. End User Interaction Expert - Shadowed the end users of 60+

departments to analyze their actual system actions. More than 14 stand-

alone systems and over six custom-built systems were observed,

analyzed and documented from the perspective of their interfaces to

SAP.

. Documentation Expert - For each of the 60 departments, created in-

depth Visio flows, knowledge documents (Excel) and As-Is process

description documents to comprehensively document all business

processes, pain points, key findings, recommendations, process

streamlining milestones, SAP user action faults, SAP security flaws

and unique requirements for that department. Developed Use Case

diagrams, ER Diagrams, and Activity Diagrams.

. GAP Analysis Expert - Spearheaded the effort to work with business

stakeholders at all levels, from customer service representatives and

supervisors to financial controllers and IT team leads - ensured that

all key findings were presented to the correct teams with the

appropriate urgency, priority and terminology. Spearheaded the effort

to perform GAP analysis in order to bridge the As-Is and To-Be

landscapes at the client.

. SAP Expert - Leveraged broad SAP knowledge to present workarounds,

recommendations and training suggestions to the business unit leaders

of all COSA end users who were using SAP for their daily sales tasks.

. Credit Card Services Expert - For those departments using credit card

terminals, analyzed their current processes, documented and escalated

Payment Card Industry (PCI) Non-Compliance issues and suggested

improvements to current COSA credit card usage Service Level

Agreements (SLAs).

. End User Training Expert - Worked with the users to provide them with

how-to's, tips and tricks in the system.

. Created RFP (Request for Proposal) document for this project. This

cross-referenced document presented potential POS vendors with all

requisite requirements, constraints and system features, slotted by

department, type of requirement and a scoring system which assigned

the "weight" in importance of the requirement to determine each

vendor's score.

. Expert at usage of MS Excel, Adobe Fireworks, MS PowerPoint, MS Visio,

SharePoint and MS Word.

Senior Business Analyst, FREESCALE SEMICONDUCTOR, Austin, Texas

Feb '08 - Jan '09

Project Description: A world leader in supplying microchips to commercial

sectors such as automobiles phones and appliances, Freescale semiconductor

does business in 20+ countries and has 24,000 employees. The client uses

the SAP HCM application to perform its HR actions. As a senior business

analyst of the HCM support team I worked with clients from around the

globe, collecting, executing, testing and deploying their local business

requirements.

RESPONSIBILITIES

. User Interaction Expert - Conducted efficient, streamlined JAD and JAR

sessions to precisely articulate the business requirements of various

clients.

. Business Process Re-Engineering: Masterminded and executed a perennial

security program which automatically adjusted the SAP security roles

(access) of employees, based on Personnel Actions executed on them

(Promotion, Separation, Country Reassignment, etc). Ensured that this

program was SOX compliant and worked with firm auditors to examine and

justify the program output. This program replaced a tedious and error-

prone manual process to execute these changes - that process typically

arrested 64 man-hours each week.

. Documentation Expert - created detailed documentation about new

interfaces, extracts and customization programs detailing their

operational flow through flowcharts (MS Visio), ER (Entity

Relationship) diagrams and functional specification templates.

. Business Process Optimization - Executed a high level change required

in the interface between Watson Wyatt (Reward system used by client to

store pay information) - and SAP. Articulated this significant program

change, scoped the architecture of the new system through detailed

Visio flowcharts, realized the program, supervised the execution,

tested the object after completion and finally worked with the WW team

to ensure system accuracy.

. Eligibility expert - created complex custom programs which measured

and detected changes in eligibility metrics for target employees.

. Spearheaded the effort to perform GAP analysis in order to bridge the

As-Is and To-Be landscapes at the client.

. Crystallized the requirements from users, into functional

specifications and worked with the users to approve these.

. Deep experience using IBM Lotus Notes for Change requests - and

maintaining versions of functional specifications / test scripts.

. Worked closely with the business users to understand their issues -

provided optimal suggestions and ensured that the functional

specifications addressed all their needs.

. Authored Requirements documents, functional specifications, unit test

scripts, integration test scripts, regression test scripts, and

reviewed technical design documents with the developers.

. Worked with an offshore team of 5 developers in India, and ensured

that tasks were not affected by the time difference.

. Built a traceability matrix to ensure completeness and sequence of

requirements was maintained.

. Developed Use Case diagrams, ER Diagrams, and Activity Diagrams

. Worked closely with the vendor's UI team to model and customize the

screens, which met user defined requirements, organizational and

regulatory standards.

. Owned the business task of using ImageNow software to connect scanned

images of paper documents (W-4, etc), to the Personnel records in SAP.

. Served as primary business analyst in the HCM areas of personnel

change requests, organizational management and Personnel Actions.

Manned the help desk for these areas.

. Conducted UAT, Integration and Regression Testing.

. Worked with the users to provide them with how-to's, tips and tricks

in the system.

Business Analyst and SAP Tester, JAMES HARDIE BUILDING PRODUCTS, Oct

'06 - Feb '08

James Hardie Building Products is a construction materials giant which

makes the finest quality wood substitute construction materials available

today. This is the company's brand new transition to SAP and the effort

necessitated a vast number of customizations, enhancements and interfaces.

As the on-site SAP business analyst and tester, this project required me to

test a very large number of interfaces and enhancements.

RESPONSIBILITIES

. Responsible for supervising and testing 60+ enhancements and

customizations created to tailor SAP ECC 5.0 to the client's

requirements - acted as business analyst, suggested standard SAP

alternatives to new business needs, determined scope, time, effort and

impact.

. Documented all enhancements in detailed functional specifications

which contained detailed MS Visio flowcharts detailing user input,

program methodology, error messaging, fail safe mechanisms and

backups.

. Managed the test strategy for the SAP SD phase of this implementation.

Created and executed test script, maintained error detection and

resolution matrix, managed regression testing after individual bug

fixes were rolled into the Golden (quality assurance)environment and

maintained list of known issues.

. Responsible for testing 20+ interface programs which combined the

James Hardie ECC 5.0 box with MANUGISTICS; which the client uses for

transportation planning and logistics.

. Managed the offshore support team, supplied them with crystallized

requirements from the business, tested their deliverables, obtained

business sign-off. Engineered and validated 10+ customized reports for

end-users at the plants; conducted recursive JAD and JAR sessions,

trained the business users in SAP.

. Provided help desk support, quickly resolved production issues,

researched and identified root causes, tested and deployed fixes

daily, carefully monitored system to validate subsequent behavior for

accuracy.

. Acted as the primary, on-site firefighter during project Go-Live -

manned 3 locations in and around Dallas, TX, comprising of the

Customer Service unit and 2 plants. Worked with the staff at all 3

locations to ensure a smooth Go-Live.

. Interacted with all levels of users at the project nerve center.

Worked with the PMO to deliver timely, well-formulated results and

status. Worked with the developers to ensure all programs were bug

free and on track for delivery. Worked with the different user groups

to show them beta-versions of their programs - garnered feedback used

this to adjust programs.

. Migrated reporting systems to Business Objects with SAP as the back-

end. Gained acceptance of a conversion of an Access reporting system

into Business Objects.

. Provided support for Business Objects XI R3.0 production environment.

. Responsible for creating, scoping, executing, testing and deploying 11

+ conversion programs which not only imported data from client's

legacy systems but also validated the incoming data and then aligned

this data optimally.

. Created the comprehensive end user training documentation used by the

client for a highly detailed, cross-referenced guide to "walk" an

order through its entire life cycle; from creation through shipping to

invoicing; including all interactions to and from MANUGISTICS.

. Designated as SME for providing input to RWD who translated my input

into the master comprehensive ECC 5.0 work step instructions / end

user training manual

. Discovered vital system weaknesses: Conducted exhaustive unit testing

of each individual object; the nature of the large number of bugs

found drove a re-work of the interface to MANUGISTICS and caused all

the developers to revisit their programs in light of the new vital

issues. Suggested key modifications to new design which leveraged

existing advantages which in turn, minimized rework effort while

maximizing efficiency and avoiding cumbersome workarounds / new coding

. Formulated unit, cycle and integration test scripts for each object as

well as for the entire James Hardie life cycle. The cycle test scripts

were written with the end user audience in mind and captured their key

concerns by displaying their actual deliverables as expected results

. Based on the results of the testing, recommended modifications and

deletions of certain enhancements; the recommendations were accepted

. Wrote functional specifications for a number of specialized reports.

The most significant one was the CSR (customer service representative)

One stop enquiry screen which gave the CSR view-only access to all

ensuing documents for a sales document. This enabled them to answer

customer queries instantly.

Business Analyst NOVARTIS, East Hanover, New Jersey

Jan'06- Oct '06

The Novartis pharmaceutical roster renders it a heavyweight player in

categories like Oncology and Ophthalmology which produce the finest

specialty OTC and Rx medications available in the market today. This

project required configuration-tuning, gathering new business requirement

for enhancements and resolving several ongoing production issues.

Production Support, Enhancements Testing and End User Training Project (SAP

Version 4.6C)

RESPONSIBILITIES

. Scoped existing systems for errors and bugs such as persistent credit

holds on order processing- investigated the issues and created

functional specifications for the bug fix. Then, provided a thoroughly

tested solution.

. Conducted JAD and JAR sessions with the users to cement the business

needs, included UML descriptions; determined scope and depth of the

new objects; advised the business on optimal usage; wrote illustrated

How-To documents.

. Conducted Status review meetings with all levels of users - from the

directors of Customer Service and IT, to plant workers responsible for

shipping and packing orders.

. Created detailed functional specification documents replete with ER

Diagrams, Use Case diagrams and Data flow diagrams.

. Created Cut Sheet Report for customer service end user - gathered user

requirements, wrote functional specs and test plans, reiteratively

validated the implementation, performed UAT and executed end user

training. Expert at delivering highly customized reports with speed

and accuracy.

. Implemented Agile methodology to ensure that programs were developed

in track-able increments, tested and deployed into the quality control

environment.

. Deep experience with ETL (Extraction, Transformation and Load) and

data mining.

. Deep experience using IBM Lotus Notes for Change requests - and

maintaining versions of functional specifications / test scripts.

. Constructed reports that would replace the deliverables of a newly

acquired company to a 3rd party asynchronous vendor for statistical

sales and commissions analysis. Interfaced with the business and IT

teams of the acquired company, executed the complete special report

life cycle for this instance. Performed unit and integration testing,

interfaced with liaison to ensure deliverable accuracy. Ensured that

both the business and the developers obeyed the specs.

. Constructed "Peek Screen"- dashboard-type, instant, ad-hoc,

comprehensive sales order summary with respect to pricing. Wrote

functional specs, aided developers in delivering as-needed final

version and data mapping, performed unit testing, compiled instruction

manual. Suggested enhancements and identified bottlenecks.

. Performed in-depth analysis of the business process and identified an

integrated solution to identify units of measure at various views

during sales order processing.

. Modified configuration to disable modification of sales orders after

certain business milestones had been reached. Conducted a complex user

requirements and usability study to verify the feasibility of this

feature.

. Identified and resolved problems in the warehouse- ATP check was being

over-ridden due to automated, scheduled background job - CSR was being

forced to release extra quantities of goods to meet warehouse demands.

Physically observed warehouse processes for several days, worked with

the shippers / CSRs, analyzed business process and configuration to

identify the root cause; engineered, implemented and deployed the

solution, conducted follow-up.

Business Analyst and Production Support, NOVARTIS, Fremont, Michigan

Oct'05-Dec'05

The most proficient and influential pharmaceutical entity in the USA as

well as in Europe, Novartis boasts lays claim to a world-wide presence and

a plethora specialized prescriptions drugs as well as OTC products. This

assignment was primarily concerned with training the customer service

organization one year after Go-Live, troubleshooting and scoping their

existing mechanisms for functional enhancements.

RESPONSIBILITIES:

. Conducted per-person interviews and collected as-is methodologies of

accomplishing tasks. Studied these processes, identified problem

scenarios and counseled / trained the CSRs on the correct SAP

substitute process.

. Created functional specifications based on the approved entries, from

the Customer Service Unit's "wish-list". Defined the requirements

clearly to the IT team, then executed on the approved functional

specifications.

. Used the GAP analysis inputs to clearly quantify the differences

between the As-Is and To-Be systems. Articulated these findings

through Use Case and Class diagrams.

. Worked directly with high-level business stakeholders - delivering

KPIs to these users.

. Performed analysis of shipping patterns and was a key resource in

constructing an "On-Time shipping report" which was used as a key

metric in business decision making.

. Deep experience using Lotus Notes for Change requests - and

maintaining versions of functional specifications / test scripts.

. Became designated conduit between business super-users and core SAP

team in translating issues efficiently and appropriately, in the

correct jargon. Interacted with the different groups to deliver the

correct information, in the right format, at the right time.

. Performed exhaustive and comprehensive testing on several specialized

reports to be used to ensure SOX compliance.

. Studied and documented known configuration faults with the ATP

(Availability to Promise) check; investigated and verified suitable

workarounds and trained CSRs on these.

. Played a key role in the implementation of an SD/FI cross functional

project which required posting to special G/L accounts on unique

scenarios.

. Constructed and executed test scripts for several reports written by

the development team. Caught bugs, negotiated and updated functional

specs and ensured a speedy and efficient sign off from business users.

. Worked extensively with customized order types and condition types.

Corrected incorrectly set-up variants. Investigated issues with

billing blocks and pricing conditions.

Business Analyst, PRUDENTIAL CYBER SYSTEMS, Chennai, India Jan '03

- Aug '04

. Led effort to re-visit a previously unsuccessful blueprinting effort;

mapped business process to SAP via a protracted GAP Analysis effort;

recommended the appropriate sales document types, material

determination processes.

. Modified existing SAP process for contracts to service unique business

requirements during manual sales order entry.

. Communicated with the client's management team consistently, to give

them status reviews.

. Configured sales area, sales document types, rejection reasons,

customized system for unique behavior for particular delivery blocks.

. Interfaced with off-site business owners to gather business needs;

after presenting them with demos of standard SAP reports, masterminded

the scope and flow of 12 customized reports.

. Created detailed functional specs for the ABAP team; due to tight

timelines, recommended priorities for pieces of functionality.

Illustrated functionality via Entity Relationship and Use Case

diagrams.

. Tested and verified the developments with exhaustive basic and sanity

testing; identified bugs; re-tested after each bug fix.

. Interacted with end users and business users to explain basic SAP

functionality and capabilities; shortcuts and report navigation.

Demonstrated every single business scenario with detailed screenshots

and business process procedures.

. Researched the end user comfort level with their legacy systems;

documented those processes which had counterparts in SAP; illustrated

workarounds for those which could not be implemented in SAP.

. Conducted end user training workshops; documented test scripts;

pursued and obtained business sign offs.

. Was eventually designated as the key resource for all sap questions

regarding my assigned business unit.

Developer, Verification Office, GSM team - NORTEL NETWORKS, Richardson,

Texas Jan '01 - Jan '02

. Provided real-time "pager" support for critical GSM issues.

. Was part of cutting-edge support team responsible for resolving code

issues by processing error call logs.

. Conducted exhaustive root cause analysis of code failures.

. Simulated and recreated problem in a live lab across all supported

versions of GSM.

. Coded and implemented software solutions within a C over UNIX

platform.

. Through exhaustive testing, ensured that the patch resolved the issue

without creating new ones.

. Demonstrated the patch performance to a stringent review process

before dipping into code.

. Was responsible for high-priority issues relating to Caller-ID and

Signal Handovers.

. Was responsible for diligent, alert and inter-departmental research to

contribute to a root cause analysis tool.

. Was called upon to provide technical input and support to clients

directly.

EDUCATION:

. Texas Tech University, Lubbock, Texas.

Master's in Computer Science

Focus in Operating Systems, Advanced Programming, Robotics and

Artificial Intelligence.

. University of Madras, Madras, INDIA.

Bachelors Degree in Computer Engineering (BE) - Apr '95 to Apr '99

Focus in Software Programming, Information Systems Analysis Design and

Internet Development

Contact this candidate