Business Analyst

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

Profile

• Over 6 years of experience in business analysis, requirements gathering in financial and transportation

industry.

• Practical understanding of rational unified process (RUP), software development life cycle (SDLC),

waterfall, iterative, joint application development (JAD), rapid application development (RAD) and

agile methodologies.

• Experience in generating business requirements, use cases and UML diagrams with emphasis on use

case diagrams, state diagrams, sequence diagrams, activity diagrams and collaboration diagrams for a

variety of application functionality designs.

• Experience in requirement gathering for database projects, preparing Physical Data Models and Test

Plan Specifications for Enterprise Data Warehousing.

• Experience in networking with individuals at various levels.

• Involved in documenting test cases, scripts and resolving User Acceptance Testing (UAT) concerns by

coordinating with QA team.

• Involved in project requirements, estimating schedules, maintaining project documentation and

managing workloads.

• Trained and applied Six Sigma and Lean for process improvement and efficiency.

• Sound knowledge of US GAAP, General Ledger Accounting, Account Reconciliations

• Accomplished several projects successfully working in a team as well as individually.

• Enterprising and self-motivated personality with excellent communication, presentation &

interpersonal skills.

TECHNICAL SKILLS:

Operating Systems Windows95/98/00/XP and NT

Languages SQL,PL/SQL,C,C++, VB

Rational Tools Rational Rose, Rational Requisite Pro, Rational Clear Case.

Project Management MS Project, MS Visio, Software Development Life Cycle (SDLC), Unified

Tools/Methodology Modeling language(UML), Rational Unified Process (RUP)

Testing Tools Test Director, Win Runner, Load Runner

Other Tools MS Office suite, SharePoint2.0, Team forge

Databases Oracle, Access, Sequel server, Enterprise Data Warehouse, Teradata

FedEx Services (CTC) Memphis TN Oct 2012 – To date

FedEx Corporate Security

Business Analyst

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

FedEx Corporate Security caters to Global community in 315 locations and addressing on Workplace violence,

Fraud, Customer Property Loss, Executive Protection, Terrorism, Facility Physical Security, Contingency

Planning, Intel Property Theft/Infosec

Project: Developing Security Training Module web site in SharePoint which contains Applications/Systems

training, Investigative Techniques, T3 training (Train The Trainer), a one stop shop for Global security team, for

Specialists and uniformed security personnel.

• Gathered requirements for the proposed site to be developed with SME’s, Security Operations Manager

and Security IT team and with SDRA (Security Research & Data Analytics ) Agents

• Prepared High Level Design (HLD) doc, Standard Operating Procedures (SOP) And Approvals for the

same.

• Documented Project Initiation Doc and presented to entire team

• Proposed various initiatives and key features for the concerned Project.

• Created Branding of Training module and involved in Legal Approval process.

• Responsible for developing training module for entire security team on applications by creating

Printable Job Aid’s, Web Ex’s, FAQ’s and Quick Tip Sheets.

• Responsible for writing User Guides, lesson Plans covered under different categories

• Creating a new site in SharePoint and creating Document Library and lists, Surveys etc

• Integration of all 3 departments in Security--Security Training, Investigative Techniques, T3 training

(Train The Trainer)modules on the new site

FedEx Services (WTC) Memphis TN Jan 2012 –June 2012

Business Applications Analyst

FedEx Services is the largest transportation, business services and e-commerce provider in the country, offering

integrated business applications through operating companies competing collectively and managed

collaboratively.

Project 1: The project was a database project, creating a new database for FedEx Supply Chain to record and

store revenue information for Data Integration into Enterprise Data warehouse (EDW) for ITG 138432. This

shall help OPCO’s access and get a full view of customer’s details across the OPCO’s. Invoicing information

was given manually for each customer and the need for automation of the process for FSC Transactional Data

Move to EDW, enabling the users to have consolidated information of all OPCO’s when reviewing customers

total revenue for FedEx.

Project 2: This project is part of Data Acquisition for CMDM data for Incremental EDW extract for ITG

135966, which was done semiannually but undertaken for monthly extract for performance improvement. The

current CMDM D&B maintenance process responsible for applying the semiannual D&B reference data

updates to CMDM hub seamlessly and accurately.

Project 3: This project is process automation for tables moving from production to L6 staging environment for

ITG 135966. This effort was done manually hence the need for automation is undertaken for the purpose of

testing from Business end.

Project 4: This project is enhancements to the existing process and doing an incremental to EDW for ITG

138649- Known Shipper Account. This effort was done on a monthly basis and now an incremental has to be

undertaken for certain enhancements.

Project 5: Integration testing was performed for this effort for ITG 136214-FTN CIH Integration.

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

• Gathered requirements by conducting interviews with user groups, OPCO companies (FSC) (CMDM),

EDW end users, DBA’s, JAD and Go/No Go meetings.

• Coordinating with DBA group, Development Group, Source systems IT group, EDW infrastructure

group and seamlessly bringing the project to completion.

• Prepared Systems Requirement document (Functional, Non-functional), Detailed Test Plan

Specifications, Physical Data Model.

• Prepared Mapping and Sizing documents, data base analysis, Traceability Matrix etc.

• Prepared Service Level Agreement and adhering to FedEx compliance standards for all documentation.

• Designed Business High Level Workflows, HLD.

• Coordinating and processing in regard to space allocation in EDW for CMDM team and EDW

Infrastructure group.

• Data Acquisition process (ETL) thoroughly documented and represented.

• Used MS Word for requirement gathering and documentation, MS Excel for Mapping and Sizing

Documents, MS PowerPoint for Business High Level Workflows etc.,

• Conducted Integration Testing and Monitored User Acceptance Testing and preparing test cases and Post

Load Checkout Procedures after moving into Production.

• Created adhoc reports, analyzed data, developed business cases, defect documents etc.

• Querying and analyzing data in Terra data using SQL.

• Thoroughly documented all existing applications.

• Prepared process automation documentation and loaded to production.

• Successfully and seamlessly loaded all assigned projects to production and monitored production

support.

Environment: Windows MS Office and Windows XP, MS Word, MS PowerPoint and MS Excel, Teradata, SQL,

AbInitio, Team forge,.

Cox Communications Atlanta GA Sep 2010 – Sep 2011

Business Analyst

Cox Communications is the third largest cable entertainment and broadband services provider in the country.

The project was in regard to enhancements in OPTIXver.2.0 where certain enhancements are made in a broad

classification on different entities of customer account, address serviceability, CIR, Provisioning, Product

pricing and promotions and estimates in the newer version.

• Conducted interviews of all user areas, Cox Business Services (CBS), internal department heads to elicit

their requirements for the new system.

• Prepared Business Requirements Document for the project.

• Designed Product Use Cases and UML models using RUP.

• Data flow between OPTIX and ICOMS represented and documented.

• Prepared Non Functional Requirements (NFR), database analysis report, Traceability Matrix etc.

• Developed detailed Workflow Analysis for areas not automated.

• Used MS Word for requirement gathering and documentation.

• Thoroughly documented all existing applications to be replaced.

• Created adhoc reports (via SQL, Access, and Excel), analyzed data and developed business cases, data

models.

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

• Involved in new processes, offered graphical and text based requirements.

• Responsible for weekly status update reports.

Environment: Windows MS Office and Windows 2000, MS Word and MS Excel, UML, MS Visio.

Wells Fargo & Company, San Antonio

Business Analyst June 2009 – June 2010

Wells Fargo & Company (NYSE: WFC) is a diversified financial services company providing Banking,

insurance, investments, mortgage and consumer finance.

Wells Fargo Golden West UAT project revolves around the Treasury’s Home Affordable Modification Program

(HAMP-MAP). The objective of HAMP/MAP is to create an affordable housing Payment by modifying terms

of the loan, for borrower(s) who have a monthly mortgage Payment ratio of 31% or greater and are in default or

in imminent danger of default. Under the HMP, a servicer will use a uniform loan modification process to

provide a borrower with Sustainable monthly payments.

• Involved in Requirements Gathering from user groups and analyzed workflows and UI screen

dynamics.

• Customized the RUP framework and implemented it in the project.

• Assisted in creating Statement of Work (SOW) document for various capabilities in the initial

requirements gathering phase.

• Experience to create, edit, and view requirements; trace Business Acceptance Criteria (BAC) to the

User Stories and generate reports.

• Designed and developed all Use Cases and UML models using RUP.

• Identified, researched, investigated, analyzed, defined and documented business processes and

Use case Scenarios

• Created Use Cases based on the Business Needs and Features (BNF’s) provided by the business team.

• Experience to centrally store, manage and access business artifacts across all platforms.

• Designed Activity and Sequence Diagrams in UML .

• Organized Joint Application Development (JAD) sessions, walkthroughs and interviews.

• Prepared presentations in MS Power Point, which was used in JAD sessions and to tract progress.

• Worked with the UI Proto types in creating mock up screens and validated if the requirements are in

sync with the prototypes created.

• Assisted in all project documentations.

Environment: UML, Oracle, SQL, MS Visio, MS Office and Windows 2000, Rational Rose, Requisite Pro.

HDFC Standard Life Insurance, Hyderabad, India

Business Analyst August 2007 – Jan 2009

HDFC Standard Life is one of the largest insurance companies in its class with approximately 3500 insurance

contractor agents. The project requirement was to develop a system to integrate and upgrade the claims

processing service and other disparate systems on a common environment for their Life Insurance division.

Project involved in assimilating its isolated systems into a synchronized system, providing remote access

through a web interface and maintaining the infrastructure required for these systems.

• Researched and assessed client systems and business processes.

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

• Explored all aspects of the claim processing lifecycle, starting from identifying a claim to its closure.

• Used MS Word document for requirement gathering.

• Worked intensively on various phases in the project lifecycle to design the system in such a way that the

high risk claims could be easily identified and monitored.

• Involved in walkthroughs with business team, architects and developers to refine the requirements.

• Generated use-case diagrams using UML.

• Streamlined clerical work processes and mapped to the automated system

• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.

Environment: MS Visio, UML, Oracle, SQL, MS Office and Windows 2000, Rational Rose, Requisite

Pro, MS SharePoint 2.0.

GE CAPITAL INTERNATIONAL SERVICES (GENPACT)

100% subsidiary of GE CAPITAL.

Process Analyst June 2004 – July 2007

GECIS is a 100% subsidiary of GE CAPITAL with Process management in Finance & Accounting. It is a global

leader in business processes and technology management, with over 49000+ employees focused on processes

and engaged in improving client processes and driving business impact. The process was to perform Financial

Planning and Analysis (FP&A) for Penske Truck Leasing Inc.

• Generating reports from Hyperion and performing financial analysis according to the client’s request.

• Data analysis for a specific period and reporting to the manager.

• Performance analysis for each quarter and reporting it in a specified format to the AVP.

• Applied Lean and Six Sigma for process improvement and process quality.

• Resolving issues arising during the process course and preparing root cause analysis for the same.

• Assisting the manager and AVP for financial planning for the next quarter.

• Formulating a course of action or strategy for the financial stability and maintainability of the process in

accordance with the client specifications and getting approval for the same from management.

• Preparing documents, doing process reviews and training new members.

• Coordinating team meeting, documenting minutes and getting approval from the management and its

implementation.

• Assisting the client remotely for closing activities.

GE CAPITAL INTERNATIONAL SERVICES (GENPACT)

100% subsidiary of GE CAPITAL.

Process Associate/ Process Developer April 2001 – June 2004

GECIS is a 100% subsidiary of GE CAPITAL with Process management in Finance & Accounting. It is a global

leader in business processes and technology management. The project was to transition General Ledger, Fixed

assets, BRS, Ledger accounts, Accounts payable/receivable, Account Reconciliations for Penske Truck Leasing

Inc.

Projects:

• Transitioned new process on Account reconciliations for Penske Truck Leasing Inc, St Louis 2001

Project Duration: 4 Months

Hephsiba Emmanuel

E-Mail – ********.******@*****.***

Home: 210-***-****

• Transitioned new process on Balance sheet Account Reconciliations for Barclays (London) when

working for GE Insurance Holdings.

Roles & Responsibilities:

• Reconciling Bank Reconciliation Accounts, General Ledger Accounts, and Account Reconciliation

for Penske Truck Leasing Inc

• Compliance – Incorporating Six Sigma criteria along with Clients criteria.

• Documented SOP (Standard Operating Procedures) for all the transitioned processes and conducting

overview sessions with team members.

• Coordinating between the Team and Client and reporting to the Manager/AVP- Accounting Services.

• Worked on Hyperion, Oracle & AS 400 for analysis and reporting.

• Running reports on Hyperion, General Ledger and supporting reports for the SDO.

• Analysis of monthly & quarterly data, Green & Black Belt projects (SPOC) for senior management

reporting.

• Applied Lean and Six Sigma for process improvement and process quality.

• Coordinating with Technology Team (Client Technology and GE Technology) to resolve issues

related to basic tools of reconciliation.

• Training team members on client account reconciliations and client accepted process methodologies.

• Double reporting of the accounts in Pounds and Euro according to clients specifications.

• Used Six Sigma DMAIC methodology to improve process efficiencies.

• Reviewing account reconciliations(Team Leader), analysis for middle & senior management

presentations, performance reporting – Dash Boards, Transitioning New Processes from client site

Achievements:

• Awarded “Team Extra Miller” Award, twice in 2002 and 2003 for Digitization initiatives.

• LEAN Trained and completed 2 projects to reduce wastage and improve process quality.

• Business Excellence Initiatives – “E Make “through digitizing, paperless office.

• Creation of process tool to impact productivity; Escalation Matrix for quick resolution of open items.

Educational Background

Master in Business Administration

Bachelor in Accounting (Commerce)

Status: Permanent Resident

Contact this candidate