Business Analyst

Summary

MBA with over * years of experience in Information Technology and Business

Analysis in mortgage, finance and government agencies. Excellent project

management skills with an ability to understand the client business domain,

formulate business goals and ensuring that they are met. Experience in

gathering user requirements, analyzing them and translating them into

business requirements. Highly motivated and efficient team player

possessing excellent analytical, interpersonal, communication,

documentation skills and a focused approach towards achieving target goals.

Technical Skills

Operating System Windows 95/98/2000/NT/XP, Unix

MS Office MS Word, Excel (Pivot Tables, VLookup), PowerPoint

RAD Tools MS Front Page

Reporting Tools Crystal Enterprise 7.0

Project Management MS Project 2013, DOORS, Visio, Rational Unified

Tools Process, Requisite Pro, Rules Express

Configuration CVS, PVCS, Clear Case

Management Tools

Software Testing Tools Test Director 8.0

Defect Management Tools Test Director, Rational Clear Quest, Remedy v6.3

E-Learning Tools Captivate4 and 5

Professional Experience

Department of Health, Washington DC

Aug' 14 - Mar'15

Senior Business Analyst

Project: WIC and Home Visitation

Food, nutrition counseling, and access to health services are provided to

low-income women, infants, and children under the Special Supplemental

Nutrition Program for Women, Infants, and Children, popularly known as WIC.

Home visiting programs serve pregnant women and families with children from

birth to age 5. Focus on families at risk because the parents are younger

than 21, low income, live in at-risk communities, have a history of child

abuse.

. Served as a liaison between the client, the users and the technical

team.

. Elicited requirements through requirement workshops, client site

visits and ensuring the right questions are asked to surface essential

requirements information and develops solutions ideas from

requirements.

. Worked with the project manager to define release scope and provide

time estimates for work being requested using MS Project.

. Worked on system enhancements and bug fixes thus making sure that the

requirements gathered are clear and complete.

. Gathered requirements for developing DASHBOARDS for various sections

of DOH like immunization, WIC, Home visitation etc.

. Created a Power Point presentation to demonstrate the design and

layout of DASHBOARDS.

. Worked closely with developers on day-to-day business to resolve any

queries and understand the system (CARES) thoroughly.

. Created troubleshooting guides and recorded and edited voiceover

scripts for e-learning materials for the Home Visitation system.

. Working knowledge in creation of various food packages for different

participants.

. Experienced in AGILE.

. Generated various benchmark reporting (Excel and MS Word) for Home

Visitation using QUICKBASE thus ensuring all reports met the deadlines

set by Congress.

Document Systems Inc; Washington DC

May' 14 - Jul' 14

Business Analyst

Project: CFSA

DSI provides services and technology solutions that enable customers to

gain control of mission critical data and enhance mission critical business

processes with faster, secure and valuable information. The scope of the

project will enable the CFSA (Child and Family Services Agency) to quickly

and efficiently share case file documents (forms) internally as well as

with external stakeholders and customers. The process and technology

supports data security and data retention policy, and protects against data

loss (lost or misplaced case volumes or forms, for example).

. Developed a Taxonomy plan that provided a single methodology for

categorizing information across all CFSA programs.

. Gathered requirements (MS Word) in order to create a Workflow and

Process Plan (VISIO 2013 and Power Point) for conversion and document

preparation that is cost effective, efficient and productive.

. Worked closely with SME's and demonstrated how the Taxonomy will be

used to populate metadata fields based on systems design and use.

. Gathered metadata, analyzed and worked on Glossary to support the

Taxonomy System

. Met key deliverables and tasks on time.

Metropolitan Police Department, Washington DC

Feb'10 -

May'14

Business Analyst

Special Operations Division

The Automated Traffic Enforcement Unit (ATEU) is charged with managing the

automated traffic enforcement assets of the metropolitan police Department

(MPD) to enforce traffic regulations on the streets, roadways, and highways

in the District of Columbia. The Automated Traffic Enforcement programs

currently consists of photo enforcement of relight violations and both

mobile and fixed radar enforcements of speeding on District roads and

highways. The Government of the District of Columbia, Office of

Contracting and Procurement (OCP), on behalf of the DMV is providing a web-

based ticket processing system call TASS (Ticket and Adjudication

Management Services) for the adjudication of violations, accepting payments

of tickets, maintenance of records of tickets issued in the District of

Columbia for all vehicles. Making sure all the systems involved in issuance

of tickets entails a smooth integration and coordination of data with

various vendors and systems.

. Key player in the department's biggest expansion and launch of New

Photo Enforcement Technology called DC Street Safe which doubled the

program's capacity.

. Analyzed and managed large amounts of data through its life cycle thus

making sure that the flow of data from one system to another (Camera-

Vendor-Processing) was accurate, consistent and reliable that helped

management in making critical decision and meeting deliverables.

. Making sure the ticket processing system's (CITEWEB and CITENET) is as

efficient, user friendly and will support in generating a variety of

reports and analytic tools in order to see results in enforcements,

patterns of traffic, identifying new locations for camera's, and flow

of data from one system to another system and monitor productivity of

processors.

. Worked as a primary liaison with the QA and development teams and

vendors for major releases and helped in numerous successful

implementations.

. Conducted RCA, Root Cause Analysis as an iterative process to resolve

existing issues with the processing systems that resulted in better

quality control.

. Evaluated and tested new or modified software programs to verify that

programs function according to user requirements and conform to

established guidelines.

. Experienced in planning and executing tests from large systems wide

tests (UAT, Regression) to individual functional tests and regression

tests. Methods include AGILE and WATERFALL.

. Wrote, revised, and verified quality standards and test procedures (MS

WORD and POWERPOINT) for program design and user functionality.

Reviewed, on a regular basis, operational procedures to ensure that

they are being performed in the most economical and efficient manner.

. Created reports (EXCEL, PIVOT Tables, VLOOKUP) and developed analytic

tools to improve the ticket processing system and electronic traffic

enforcement tools including: tracking location data, ensuring

integration between vendor programs, investigating system errors and

evaluating and providing solutions for improving user productivity.

. Experienced in Learning Management Systems (Captivate 4 and 5) to

consolidate training initiatives on a scalable web-based platform of

training manuals (LPR's, ALARMS, CIC Training, and other computer

based self-training programs).

. Participated in UAT for LPR's (License Plate Readers). Made sure that

all requirements for the HH (HandHelds) were tested using various

scenarios and conditions, and ready to hit the streets.

. Thorough knowledge of the current Ticket Processing System and a clear

understanding of the life cycle of a ticket from its inception to its

final NOI (Notice of Infraction) to the registered owner of the

vehicle.

. Enhanced my knowledge on the need for safer roads for pedestrians and

drivers and making sure the endeavor to have 'Zero' fatalities will

someday be accomplished.

Fifth Third Bank, Charlotte, NC

Dec'08 - Feb'10

Business Analyst

Project: Fifth Third Processing Solutions

Fifth Third Bank has various divisions and five main lines of banking

namely Branch Banking, Fifth Third Processing, Commercial Banking, Consumer

Lending and Investment Advisors.

Scope of the project was to adding features and enhancements to existing

credit management products such as online applications, online account

access, online bill payment, wire transfers, and viewing and downloading

monthly statements. One of the main objects of this project was to enhance

the application process for loans in order to meet business and regulatory

requirements.

. Worked with SME's in Finance, Investment, Commercial and Personal

banking to document existing business processes, and performed

Business Process Re-engineering.

. Performed Fit-Gap Analysis and gathered both functional and non-

functional requirements based on interactions with process owners &

stakeholders.

. Followed the adaptive RUP framework for the Project life cycle (PLC).

. Updated and maintained Use Cases, Activity Diagrams and Workflow

Diagrams using UML and MS Visio.

. Ensured Wires processed are in compliance with the Bank's Overdraft

Policies and are properly approved.

. Released customer ACH files to the Data Center to insure financial

entries to client accounts are properly charged/credited.

. Documented business processes as well as business rules and worked

with users to define the project and system requirements.

. Developed Test scenarios and implemented Test Plans for UAT. Assisted

in quality testing of the application using functional and regression

testing on various browsers such as Internet Explorer and Safari and

reporting bugs to the development team.

. Maintained Project notes and files to ensure Deliverables were met and

tracked on a regular basis.

. Trained end-user groups, and documented functional instructions and

user guidelines.

. Gained valuable Project Management experience working with software

development teams, tracked schedules, timelines and budgets, and

monitored daily tasks using MS Project and MS Excel.

. Facilitated Joint Requirements Planning (JRP) sessions between

technical, business and regulatory teams to ensure that requirements

are met, and issues during the development phase are resolved.

Freddie Mac, McLean, VA

Oct'07 - Nov'08

Business and QC Analyst

Project: Rules Management - Credit

Freddie Mac has established negotiated TOB's (Terms of Business) to

purchase loans from the Seller. These contracts are created as per the

Sellers' Master Agreements (MA), Master Commitments (MC) or amendment to

the existing contract, and the loans are processed using either of the two

systems: the Selling System (PE Sourcing) and the Legacy System (MIDAS

LOP). Once the Sellers define and accept the terms of the contract, the

Seller delivers loans against the contract. Based on the terms of the

contract, product and credit terms are setup in the Selling and/or Legacy

systems. The primary objective of this project involved implementing new

financial products by creating and modifying mortgage products using

mainframe MIDAS (Mortgage Information Direct Access System). This involved

analysis of Business Requirements for completeness and accuracy. Worked

closely with internal business partners to manage and maintain project

release timeline. Followed all QC procedures to ensure SOX compliance.

. Analyzed contracting documents in Deals on a daily basis and set up

business rules in Terms, Products, and Agreement (TPA) system (Web

Application) for a variety of Terms of Business (TOB) using Freddie

Mac database & repository (DOORS, DPM (Deal Pipeline Manager).

. Generate daily and weekly reports for Single Rule Exception (SRE),

Special Characteristic Code (SCC) SRE, and Negotiated Values/Products

work status. Generate weekly and monthly check-in report from Remedy

v7 system.

. Expertise in managing requirements and traceability using Requisite

Pro and DOORS.

. Analyzed LEGACY requirements and set up products and programs in

MIDANET and CSWEB. SME (Subject Matter Expert on Setup and Quality

Control activities. Trained and mentored new recruits within a group

on Setup and Quality Control.

. Used DOORS to write the detailed requirements for application control

and functional specifications.

. Analyzed functional requirement specifications and wrote detailed Test

plans, Test cases and executed Test scenarios.

. Met all deliverable times and participated in 7 scheduled releases

within a year and that was the highest number of releases held in one

year.

. Provided source documents for one of Freddie Mac's Key Control's TEC

19 which when tested passed the PWC (Price Waterhouse Coopers) and

KPMG internal and external audit.

. Generate the reports on Ad-Hoc request (in Excel) for Deals or Data in

TPA per management's request.

. Scheduled Project Team meetings prior to releases to ensure timelines

and guidelines were being met. Participated in weekly Legacy meetings

and responsible for the meeting minutes and distribution of minutes to

concerned parties.

. Contributed towards the "Knowledge Transfer and Transition" document

in place by creating and updating Process and Procedures for business

flow (Using Visio & Word) and also composed instructions or manuals

for new system or process flow (Using PowerPoint)

. Managed & monitored business rules request from community mailbox and

open remedy tickets if it's needed.

. Adhered to department practices, standards, policies, procedures and

methodologies.

Fannie Mae, Bethesda, MD

Feb'07 - Sept'07

Business/Data Analyst

Project: Data Quality (Data Steward Team)

The goal of the Project was aimed at maintaining Data Quality Standards set

by HCD (Housing and Community Development). This involved updating and

maintaining the metadata repository known as the CDM for various systems

used by the Company in order to develop an Enterprise Level Repository that

incorporated both the Single-family as well as Multifamily data. Provided

Data Quality Analysis around issues related to Multi-Family HCD Data, which

included creating 'As-Is' and 'To-Be' lineage diagrams, providing proposed

system changes and lastly closing out Data quality issues. Data quality

reports were created on a daily, weekly and monthly basis for various teams

to assure the quality of data.

. Led the efforts on the conversion project of the in-house Metadata

Repository (CDM) to the Enterprise Level Metadata Repository (EMR).

Responsibilities included verifying and mapping the attributes in

various systems, meeting with business leads and data modelers to

validate definitions, physical names, business names, data types,

codes values, data source etc. to conform to the HCD (Housing and

Community Development) Standards.

. Used DOORS for capturing, analyzing and managing changes to

requirements.

. Worked along with members of the Enterprise team to implement

standards and procedures for changes to the new Enterprise Level

Metadata Repository.

. Created RTM using Doors, that traced Application Use Cases to Business

Requirement Document, Test Cases to Application Use Cases, Test Cases

to Report Requirements and Test Cases to Supplementary/GUI

specifications

. Communicated to the IAWC (Information Architecture Working Committee)

for approvals towards project level compliance and DST process review.

. Worked with various teams to create 'As-is' and 'To-be' flows for

identified critical data elements using MS Visio and Powerpoint. Was

able to provide system changes and data quality checks that needed to

be added to the systems to insure quality of data.

. Generated data corrections reports together with proposed resolutions,

documentations, system impact analysis for the Data Governance Board

meeting.

. Implemented the data corrections in Production through various

implementation procedures.

. Through data analysis, I was able to close out data quality issues

that existed between the various systems.

ABN Amro, Chicago, IL

Sep'05

- Jan'07

Business Analyst

Project: MHFD

The project aimed at developing a system that creates financial reports in

turn replacing the existing manual process to obtain data; Primary job

responsibility was to gather requirements for creation of these financial

reports. The scope of the project was to, Automate the manual processes for

obtaining data, Store data on the CDW, Generate financial reports for

internal and external reporting (e.g. Annual Reports). Generate analytical

reports for internal use (e.g., Multifamily Loan Details Report). The

automation will make these reporting processes more practical and agile,

thereby helping to meet the corporate mandate to close the books within 18-

days. By replacing manual processes with automated systems, controls will

be monitored, thereby adhering to Sarbanes-Oxley compliances.

. Gathered requirements in order to ensure that the Multifamily Housing

Finance and Development's long-term vision to build a MHFD

(Multifamily Housing Finance and Development) Data Mart for historical

data, against which reports can be run for a variety of purposes, is

fulfilled.

. Managed all requirement documents using Doors.

. Collected requirements for the MHFD (Multifamily Housing Finance and

Development) automated reconciliation's in a technology independent

context.

. The new application's requirements were gathered in order for it to

achieve the following functionalities: Store data in data tables,

Perform calculations necessary for financial reporting, Provide

auditable history of monthly activity and reporting, Provide about 30

reports for analysis, Comply with existing FASB Pronouncements and

Accounting Policies at the time of build.

. Entered requirements in and change requests in Requisite Pro.

. Effectively automated financial reporting for Accounts Receivables and

Payables and tighten data security that benefited in better analysis,

reporting and communication at the management level.

. Involved in Change Management Configuration using Rational Clear-

Quest.

. Worked closely with the UAT team to resolve issues or concerns from

the SIT (Systems Integration Team). Created and maintained the UAT

suite (Test Plan, Test Cases, Test Scripts). Analyzed UAT results.

. Interacted with the Business Users through interviews and (Joint

Application Development) JAD sessions.

. Participated in preparing flow diagrams using MS Visio.

. RUP process model was used for the different phases of the application

development of the Software Development Life Cycle.

. Examined user requirements, attended Change Request meetings,

documented changes and implemented change control procedures using the

Rational Clear Quest.

. Networked with developers to report software bugs and re-tested the

fixed issues.

. Gave constructive input in terms of Modification Requests and

Enhancement Requests.

. Maintained Risk Register and Issues Log.

. Responsible for weekly status reports (MS Excel and POWERPOINT).

Education:

MBA (Marketing), Loyola University Chicago

January 2000

Contact this candidate