Project Data

ADITI GOGNA

***** ********** ****

Boyds, MD ****1

(Cell): 240-***-****, Email: *****.*****@*****.***

RELEVANT EXPERIENCE:

• 7+ years experience as a Business Analyst with full project life cycle experience in Mortgage Banking,

Financial industry, and Hospitality Services.

• Diverse experience in Information Technology and Software Development life cycle that includes requirements

gathering, design, analysis, regression analysis, development, testing, implementation, UAT coordination, and

production support for data warehouse projects.

• Familiar with client/server, and web application development tools; software development methodologies, and

design techniques.

• Strong experience with SQL, Visio, Requisite Pro, ClearCase, ClearQuest, RUP, UML, and MS Project.

• Recent experience includes data analysis, mapping, and data reconciliation and creating SQL scripts for data

validation, reports, data migration, data conversion and ETL transformation verification.

TECHNICAL SKILLS:

Languages: Java and J2EE based applications programming, UNIX Shell programming, Perl Scripting,

SQL, PL/SQL, Visual Basic (VB), HTML, DHTML, XML.

Applications: Ab Initio, Access, MS Project, PowerPoint, Visio, Dreamweaver, Informatica, DataStage,

AquaLogic 6.x

Databases: Oracle 9i/10g, Sybase, SQL Server.

Methodologies: Rational Unified Process (RUP), Waterfall, JAD/RAD, eXtreme Programming, SDLC

Process, SCRUM.

Other: UML, Use cases and Use case diagrams, Data Flow diagrams, Entity Relationship Diagrams, corporate

data dictionary.

EDUCATION:

Bachelor’s of Business Administration, George Washington University, Washington D.C.

PROFESSIONAL EXPERIENCE:

BUSINESS REPORTING ANALYST, Fannie Mae, Washington DC September 2010 to April 2011

Project: PLMBR (PLS Loss Mitigation Business Reporting) is the system of record for business reporting on PLS

Loss Mitigation. This involves the tracking of loans in pools that back PLS (Private Label Securities) deals and the

projects associated with forensic reviews and subsequent repurchases/recoveries or other settlement of

claims. The workflow involves multiple counterparties (trustees, originators, servicers, and issuers), forensics

vendors, and internal Fannie Mae groups (CMRM, Legal, and NUC). The PLMBR system will facilitate internal

business users providing updates to project status as well as provide data consolidation and reporting of updates

from vendors.

Responsibilities:

• KT sessions with the development team while the SharePoint site was under development for UAT testing

purposes.

• Generated weekly status reports via Access / Excel.

• Understanding the Data dependencies, Business Logic, Reporting needs, for Data Validation and report

generation.

• As part of UAT testing, Involved in validating the report generated via SharePoint to the access

version. Documenting any discrepancies with the reports and prioritizing for current or deferred for future

releases. All bugs were documented via Quality Center 10.0, regression testing and closing them.

• Creation of Test Plan, Test Case Specifications, Test Data, Identification Exit Criteria, Post Production

shakeout testing steps, shakeout Test completion document for the PLS Loss Mitigation Status Report, Project

Tracker Report via SharePoint / SQL Server DB.

• Documenting Business Requirements Document as well as creating / updating Access DB for Invoice

reconciliation of each vendor on a monthly basis.

• Involved in weekly discussion with the litigation department and the underwriters for progress in individual

projects and verification of these changes reflected in the reports.

• Worked closely with the vendors for reconciling any data issues indentified and updating the Data

requirements, if needed for them.

BUSINESS ANALYST, N.E.W., Sterling, VA, December 2009 to August 2010

Responsibilities:

• Built and authored system requirements related to software/applications development.

• Translated business requirements into functional design documents.

• Built and authored use cases as they relate to business requirements.

• Participated in technical design workshops

• Developed functional expertise around N.E.W.’s business processes

• Worked with business partners to develop new business processes supporting N.E.W.’s service and offerings.

• Document materials for UAT training, this includes but not limited to UAT test cases, UAT test Scenarios, UAT

Test Plan.

• Assistance in documentation of training materials required subsequent to release for end users.

• Work closely with the business user to understand areas of improvements in the existing flow.

• Document, maintain and prioritize items on the issue log and communicate agreed upon changes to the

development, QA and UAT teams.

• Involved in getting CM approvals for all functionality changes agreed upon for a release.

• Work closely with PM for scheduling on time delivery of all artifacts.

IT ANALYST, Credit Suisse, Raleigh, NC, June 2009 to September 2009

Summary:

Credit Suisse is in Investment Bank based throughout the world, which deals with wide variety of derivatives and

financial instruments. It provides complete range of financial advisory and capital-raising services to corporate

clients, financial sponsors and governments worldwide.

Project: Risk Planning and Assessment

Responsibilities:

• Managed data across transactional systems to warehousing and reporting/analytics (ETL).

• Assisted with the reconciliation, detection, prevention, across different databases and environments.

• Assisted in developing the implementation strategy directed for migrating the applications to production.

• Assisted in ensuring that standards and controls are implemented in the technical design and application

implementation.

• Applied statistical concepts to data evaluation, statistical variance assessments, root cause and data analysis via

MS Access.

• Assisted in identifying the deferred requirements for the project.

• Performed Gap Analysis.

• Involved throughout software development process and production migration / validation.

• Interface with management to effectively derive and translate statistical information as it relates to Enterprise

Data and Data Warehouse applications to including statistical analysis, data sampling, and database querying.

SR. BUSINESS ANALYST / UAT LEAD, Fannie Mae, Herndon, VA, July 2008 to December 2008

Summary:

Project’s objective was to capture activities related with REO loans, delinquent Non REO’s loans, and provide

granularity to the costs associated with these loans for Taxation. The data warehouse project used Ab Initio for ETL

jobs and dimensional data modeling monthly, quarterly and year-to-date reports.

Project: Tax SF REO

Responsibilities:

• Involved in understanding and creating requirements for applications end-to-end functionalities. Gathered and

documented business requirements and managed requirements using Doors. Documented Data, Functional, and

Interfaces requirements.

• Created Mock up screens using Visio for displaying data in the AquaLogic portal from different applications.

Created requirements as to how the data was retrieved in the portal using stored procedures and web services.

Involved in identifying various segments that will be displayed on the

app and combining those functionality from usability perspective.

• Acted as main point-of-contact (POC) for business, development and testing teams for all the requirements

related issues. Assisted project manager in maintaining issues and action items lists. Documented and

maintained project related activities, including meeting minutes, release documents, project schedules etc, on

share point site. Managed change request (CR) process using the Tracker tool.

• Led UAT (User Acceptance Testing) effort by creating UAT Plan, Test Cases and UAT summary report as part

of the standard project deliverables documentation. Created RTM (Requirement Traceability Matrix) to

associate Test Cases and requirements (UAT), Used Mercury Quality Center tool to manage defect tracking.

• Identified, named, defined and modeled numerous data elements in RMTM database tables using Erwin and

mapped new/existing data for upload. Performed data analysis, validations, and analyzing data quality issues

using SQL scripts.

• Involved in analyzing/interpreting ER diagrams, data dictionary and data models from various source systems

for data mapping activities.

• Involved in identifying the gold source, and flow of accounting transactions in the upstream general ledgers.

• Created requirements for time dimensional reports, including quarterly and monthly summary reports. Helped

reports developers in understanding data elements and business knowledge for creating reports with proper

diagrams and charts, for upper management.

• Validated the monthly and the ad-hoc reports generated by the application using Business Objects.

• Used Clear Quest tool to manage defect tracking.

• Verified reports data in excel spreadsheets against the database.

Environment: Ab Initio, Oracle 9i/10g, Shell/Perl Scripts, WebFocus, Sun Solaris Servers, Quality Center,

ClearQuest, DOORS, MS Visio, MS Project, Business Objects

IT Analyst / UAT, Financial Industry Regulatory Authority (FINRA), Rockville, MD, August 2006 to March 2008

Project:

Web CRD: Central Registration Depository (Web CRD®)

Web CRD keeps record for all Broker/Dealer firms, individuals as well as Investment Advisers. The Application

was designed to support industry regulation by FINRA, other SROs and states.

Web CRD streamlined the registration process by maintaining the qualification, employment, disclosure histories,

fingerprint requirements, registration fees and renewal fees.

Responsibilities:

• Involved in updating and maintaining corporate data dictionary.

• Documented Functional requirements and GUI mock ups required for the above applications.

• Documented Requirements for maintaining Firms, and Individuals accounts balances via PeopleSoft.

• Acted as main POC for Business Users, Development and Testing teams for all the requirements related issues.

• Worked on AquaLogic Portal application, which was a combination of a .Net application, Documentum and

Cognos 8. Involved in testing various interfaces, which included data validation using SQL scripts,

WebServices testing by generating XML documents, Entitlements testing and other functional testing.

Identified bottlenecks in the application while working with automation team.

• Identified, named, defined and modeled numerous data elements in RMTM database tables using Erwin and

mapped new/existing data for upload.

• Created/updated ER diagrams as required using Erwin for the upgrade project.

• Performed data analysis and validations using SQL.

• Created reports using SQL, PL/SQL, and UNIX for daily and monthly registration statuses.

• Assisted the PM in maintaining the Issues and action Items lists.

• Documented Meeting Minutes and maintained all the documentation on share point site.

• Documented manual pricing processes that were developed using End User Computing (EUCs).

• Managed change request (CR) process using the tracker.

• Coordinated UAT (User Acceptance Testing) created UAT Plan, Test Cases and UAT summary report as part of

the standard Project deliverables documentation.

• Tested Ad-hoc reports developed using Oracle, SQL, PL/SQL, and UNIX.

• Created RTM (Requirement Traceability Matrix) to associate Test Cases and requirements (UAT).

Environment: .Net, XML, AquaLogic 6.x, SQL, PL/SQL, ERwin, UNIX, Oracle 9i/10g, TOAD, Requisite Pro,

Tracker

IT Analyst, Country Wide, VA, January 2005 to June 2006

Projects: Application Reconciliation System, Loan Origination

Summary:

The Application reconciliation system tracks all Mortgage, Home Equity, Credit Card and personal Line Loan

applications from inception to booking along with monitoring throughout statistics. Once identified, the system

allows the user remediate failed loan applications using various methods. Once in place, the system is expected to

have considerable impact on the company’s bottom line by reducing the number of missing, incomplete and

erroneous loan applications.

Responsibilities:

• Worked on implementation of Business requirements for business testing and Implementation.

• Involved in gathering the changes requested, conducting GAP analysis, and providing estimates on the

implementation of these changes to management.

• Created Metadata definitions from Business Rules and helped refine the metadata management strategy.

• Created complex transformation like sorter, filter, routers, joiner and aggregators to load data.

• Ad-hoc reports developed using Oracle, SQL, PL/SQL, and UNIX.

• Developed and implemented data naming conventions and documentation for enterprise system planning.

• Created Sequence Diagrams, Class Diagrams and Activity Diagrams to update Business Process flows.

• Actively involved with business stakeholders to analyze, and resolve issues with the implementation of

business logic.

• Defects were documented in ClearQuest.

• Evaluated existing data bases for potential problems. Validated the data flow upon execution of batch jobs.

• Involved in validating FIX protocol for Data Conversion and executing back end testing using SQL.

• Created high quality System design requirement specifications and supporting documents for business systems.

• Worked on complex business problems, analyzing and evaluating current business methods and procedures for

improvements.

• Imposed several Joins, Filters, and Alerts to restrict the unwanted data and highlight the required data.

• Used PeopleSoft to replicate firms accounting transactions and maintaining balances.

• Used Business Query to load data directly to Excel and used Excel coding functions to make the data more

presentable to the users.

Environment: J2EE, XML, UNIX, Shell Scripting, SQL, PL/SQL, Oracle 9i, WebLogic, TOAD, Dreamweaver,

Visio, ClearQuest, ClearCase

BUSINESS ANALYST/UAT, Goldman Sachs, NY, May 2002 to November 2004

Project: Analyzer Reporting Tool

Summary:

Project was designed to accommodate client's analysis/reporting needs. Analyzer/Browser is a reporting tool, which

retrieves information of the customer from Goldman Sachs database and gives them the report of purchase/sale of

their stock and profit/loss they incurred on the transaction. These reports also give them a foresight so that the

analyst can instruct GS accordingly.

Responsibilities:

• Documented functional requirements, data requirements, and business rules with utmost clarity that was easily

understood by development team.

• Conducted JAD sessions to gather and document the requirements. Created use cases and data-flow diagrams.

• Participated in the development of requirements and evaluation of metadata repositories.

• Worked closely with the users to enhance the functionality and performance of existing applications by

suggesting new changes that added value to the system.

• Coordinated and monitored team meetings with business users, testing team and development team.

• Analyzed ER diagrams and data models to conduct data verification and validation.

• Created complex SQL in order to perform data profiling, aggregation, and extraction.

• Involved in coordinating testing effort with the off-shore team.

• Validated database referential integrity and reports with database using SQL scripts.

Environment: J2EE, Oracle 9i, SQL, PL/SQL, VB, WebSphere, UNIX, TOAD, ClearQuest, Visio, Windows 2000

Contact this candidate