SUMMARY:

• Expertise in Business Analysis, Data Analysis, and Testing in domains such as Mortgage, Investment Banking, Finance. Posses a combination of business, technical, project management and analytical skills.
• Four plus years of experience in Mortgage Banking. Seven plus years in information technology involving business analysis, data warehouse, reporting, database design and database implementation.
• Extensive experience in investment banking, asset management, trade back office, securities, clearance and settlement, loan origination process retail and correspondent, and all related verticals.
• Expertise in design, development and analysis of front end application, middle tier and back end systems.
• Experience with Service Oriented Architecture (SOA) enhancing system by leveraging existing services or reusability of services.
• Extensive experience in business performance management, process management, business process reengineering and gap analysis (as is - to be) and design review.
• Extensive and diversified experience in implementing Software Development Life Cycle (Agile, RUP, Waterfall).
• Excellent with use of MS Access for prototyping and mocking relational databases, MS Excel for analysis and presenting by producing charts, graphs, pivot tables, lookups.
• Managed documentation of projects; Requirement Traceability Matrices (RTM), risk management plans, updated the requirement repository and provided status of documents to PMO team and release team.
• Extensive experience in data transformations, conversion and interface, data loading, database modeling and sql performance tuning.
• Detailed understanding of Informatica- mapping, source analyzer, target, mapplet, transformations (expression, lookups), joiner, filter, router, update strategy, sequence generator, work flow manager.
• Experience with star schema modeling and knowledge of snowflake dimensional modeling.
• Conducted Joint Application Development (JAD) sessions/meetings to coordinate with everyone involved in the project.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects, Crystal Reports, SSRS, MS Access.
• Involved in database monitoring activities, capacity planning, and SQL tuning.
• Extensive experience in loading high volume data, worked extensively with data migration, data cleansing and ETL processes.
• Extensive experience with UAT and various other test efforts in a data warehouse environment like data validation, data analysis, functional testing, integration testing and system testing.
• Excellent communications skills, analytical skills, logical reasoning skills, interpersonal skills, great work ethics and a great team player.

TECHNICAL SKILLS:

Modeling Methods/Tools: ERWIN, ER Studio, Rational Rose, UML, XML Spy

SDLC Methodologies/ Tools: Waterfall, Agile, Rational Unified Process (RUP), Use Cases, JAD/RAD Sessions, Requisite Pro, DOORS, Rational Rose, Borland CaliberRM 10.0

Project Management: MS Project (PERT, Gantt charts), OECM (Oracle) 10gR3, CMMI, MS Project Server, SWOT Analysis, CPM, WIP, Alexsys Team *2.

Reporting Tools: BOXI R2, WebI, DeskI, InfoView, Crystal Report, SSRS, MS Access, Oracle Reports 9i/6i

Databases: Oracle 8/9i/10g, MS SQL Server 00/ 05, MS-Access 00/ 03/ 07, DB2, Sybase.

Web/App Servers: Web Logic, WebSphere, Java Web Server, Tomcat, Apache, IIS 5.0.

Quality Assurance: Test Director, Remedy, Quality Center, Borland SilkCentral

Operating Systems: MS Windows 98, 00/XP/ NT/Vista, UNIX, Linux.

Languages: SQL, PL/SQL, Java, C++, VBA, HTML, XML, CSS, ColdFusion, JavaScript, Perl, J2EE, .Net.

Others: MS Office (Word, Excel, PowerPoint, Access, Outlook, SharePoint, Visio), TOAD, SQL Server Management Studio, SQL*Plus, MISMO, JIRA, Bugzilla.

WORK EXPERIENCE:

Confidential

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Worked on the gap analysis of the existing files (Fannie 2000-Character, Freddie Form 11 and 13) sent to the agencies against the ULDD and documented the best approach to successfully meet the pressing deadlines.
• Worked with Secondary/Capital Markets team to successfully identify data needs to produce the Fannie 2000-Character, Freddie 11 and 13 files. This involved conducting intensive analysis and understanding of origination versus servicing data.
• Educated other analysts, business partners and capital markets team the concept of MISMO 3.0, MISMO data points and corresponding containers in relation to the ULDD file.
• Worked with the Loan Origination System (LOS) vender point of contact to hand off originations requirement from Aurora business teams and also involved in weekly meetings in resolution of outstanding bugs.
• Proficient with The Mortgage Originator (TMO) Aurora’s LOS and the screen flow in Mocha TN5250. Capable of understanding AS400 RPG code, function calls and sub-routines for in-depth analysis of logic. Used Mocha, iSeries (DBU) and Aqua Data Studio to query the AS400 data for research and data analysis.
• Performed data analysis to develop forty plus canned reports for the retail loan originations and correspondent channels. All canned reports built by offshore developers using Crystal Report 2008 and run against Corporate Data Warehouse (CDW) Data Marts.
• Performed end-to-end data analysis for sixty plus ad-hoc reports for various groups within the company- Sales, Operations, Compliance, Credit Risk, Collateral Management, Finance etc. and made available with BO Universe.
• Wrote test scripts and test plans for data verification, data validation, unit testing and UAT of canned and ad-hoc reports. Also extensively involved in testing Business Objects Universes.
• Evaluated stored procedures used to populate Lehman reports and mapped the fields against live AS400 files for developers to rebuild the reports and tested the reports for functionality and performance.
• Involved in gap analysis and regression testing of existing reports in production environment following the decoupling of Aurora Loan Services from Lehman Brothers Holdings.
• Prepared Data Load Specification for Informatica developers to incrementally load daily data from legal, billing, origination, servicing, appraisal, etc. systems into Stage and Audit layers within MDIA.
• Reverse engineered using MS Visio to obtain unique keys in the tables in the source database and recreate the ER diagram to simplify the documentation of what could be a complex RDMS concept. Conducted demo sessions for database architect and ETL developers for fitting the data from the new sources into the existing NDL model.
• Built MS Access database to temporarily host data provided by an external appraisal management vender in flat files for analysis and documentation of keys in the underlying tables.
• Prepared mapping document for data going into MDIA and out into CDW data mart. Also, documented the extraction of data from MDIA to the extracts that feed other downstream processes.
• Reverse engineered using Informatica Power Center. Evaluated existing maps in development environment to ensure the fields from the source systems are appropriately mapped into various layers within MDIA and into the Data Mart or extracts.
• Wrote UNIX script to validate the extract file is generated at pre-designated locations. Executed UNIX script for count validation and FTP the file to the local box for field level testing, verification and validation.
• Involved in requirement gathering for additional reports related to Customer Relationship Management (CRM), Client Scorecard, Final Docs, Intraday Hedging, Business Process Management (BPM), etc.
• Collaborated with manager to standardize the data mapping process and data mapping template to better facilitate the database architect and ETL developers.
• Participated in corporate wide data governance initiative that required holding the respective departments responsible for owning the data points, agreeing on companywide definition for terms in common amongst departments and coining master terms based of MISMO nomenclature and definition and maintaining a Data Dictionary to in corporate any additional projects.

Environment: Informatica PowerCenter 8.6.1/8.1.1, BO XI 3.1(WebI), Oracle 9i/10g, SQL Server 2005, DB2, UNIX, AS400 Mocha W32 TN5250, Aqua Data Studio 8.0.7, DB Artisan 8.5, ER Studio, Tidal, MISMO 2.4, XML Spy, WebI, Infoview, JIRA.

Confidential, Jersey City, NJ

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Gathered Report Requirements, analyzed existing Business Objects Report data and worked with Developers to implement Universes by adding objects, editing joins mapping the existing objects with renamed tables.
• Convened with Stakeholders/ SMEs to define system scope, identify problems, and resolve issues to ensure a stable and accurate solution.
• Identified and analyzed key processes for Global Markets and Asset management businesses, executed the results by performing extensive research and conducting client interviews.
• Performed reviews for the financial processes at Investment Banking and Asset Management divisions. In addition, analyzed relevant business processes and supporting applications for trade capture, risk management, clearance and settlement, etc.
• Documented and translated the requirements into and Business Requirements Document (BRD) and Technical Requirement Document (TRD).
• Documented and updated the Interface Specification Document (ISD) to keep up with the changing environment.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirements.
• Documented Use Case scenarios in various functional areas and also designed UML Models that provided a view of the requirements.
• Produced functional specifications and led weekly meetings to discuss requirements and implementation issues.
• Responsible for identifying gaps in the software between core functionality and user defined requirements and developed, updated, maintained Data Mapping Document and tracked the RTM for various implementations.
• Ensured WMR PR and CR functionalities, delivered by the development team, are as specified by the business group in the Business Requirements, Functional Specifications, and Technical Specification Documents.
• Developed and performed business data validation and integrity checks on the key data flows during various stages using SQL.
• Designed and developed ETL technical requirements for CRC account adapters (WMR and Hearsay), holdings, product prices, hedge fund and private equity product prices from functional requirements.
• Developed mappings, workflows to extract data from various sources like XML files, DB2, flat files to reporting data store and staging area to analyze the data as part of input analysis.
• Worked on Input analysis to determine the quality of source systems and SLA requirements.
• Analyzed data extensively using MS Excel and MS Access.
• Developed mappings using normalizer, aggregator, lookup, web services and xml components using Informatica 8.1.
• Collaborated with Developers to schedule ETL process and workflows in Autosys.
• Worked on data cleansing, validations, de-duplication, enumeration, transformation, error handling for various modules of CRC Accounts, Product prices, Hedge Fund prices, Private equity prices, and Hearsay accounts.
• Worked with BO consultants to develop universes and reports for Performance Review using Business Objects XI R2.
• Worked on unix scripts for request and response mechanisms from various source systems CRC (Client Reporting Configuration), TMS (Transaction management System), ADP, RDS (Reporting Data Store).

Environment: Informatica Power Center 8.1, Requesite Pro, Agile, ClearCase, ClearQuest, Business Objects XI R2, Crystal Report XI, DB2, Sun Solaris 5.8, Java, XML, Autosys.

Confidential, NY

Business Analyst/ Data Analyst

Responsibilities:

• Acquired in depth knowledge on Securities back office operation through processing (STP) platform for end-to-end automation of trade settlement such as - trade processing, settlement, position management.
• Gathered and identified business requirements from the business stakeholders, users, SMEs and translated into FRD, BRD, and system specifications. Interact with all levels of project development team.
• Produced Functional Specifications for large trading systems. Reviewed and analyzed the entire Batch Jobs schedule and provide the analysis to the Technology support team to meet the goal.
• Assisted the project manager in creating detailed project plan and scheduling and tracking project timeline using MS Project.
• Prepared a package of Process Flow diagrams to document the existing system and used Rational Rose UML notations for Object Oriented Design and Documentation.
• Worked on Data Modeling including creating of Conceptual and Logical Models using ERWIN.
• Analyzed business processes and created process maps. Wrote standard and complex SQL Queries to perform Data Validation, Analysis and Data Mapping of Sybase and DB2 data.
• Wrote the UI Documentation and Report Specification for all executive summary and detail level reports.
• Worked with Capability Maturity Model as a guide to monitor the growth of all the processes throughout the project.
• Assisted in dimensional logical model and physical model as per business requirements.
• Designed data staging area and created High level ETL design to meet the data requirements.
• Developed mappings & mapplets to load NTAPS data into NCDI DWH target table / staging area from various sources using transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Router, Sorter, Sequence, Joiner and Filter.
• Created the workflows by including various sessions, mappings, event wait, timer, source and target connections using Power Center Workflow manager and monitor.
• Automated the process for scheduling the jobs using Informatica Scheduler and from UNIX command line.
• Validated the data by creating data validation scripts to verify the loading process.
• Performed data analysis and processing by selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects, which are grouped into classes for convenience and business intelligence reporting.
• Assisted test lead and testers understanding business process and helped them for successful completion of Unit Testing, Regression Testing and Functional Testing.
• Played a key role in UAT and validating the source to target data mapping.
• Composed a Disaster Recovery Document (DRD).
• Conducted sessions for the end users and documented various manuals.

Environment: Informatica 7.1, Business Objects XI R2, Requisite Pro, ClearCase, ClearQuest, Oracle 10g/9i, Sql Server 2005, DB2, Putty, ERWIN, TOAD, Java, Unix, Windows XP, Peoplesoft GL, NTAPS, Xenos.

Confidential, Houston, TX

Business Analyst/Data Analyst

Responsibilities:

• Gathered System Requirements on Mortgage Servicing, Loan Processing Engine, Payment Processing Calculations for Applying P&I Payments Accounting and generation of control reports and assisted in verifying data from other databases.
• Assisted project manager with the creation of project plan covering Project Schedule, Assignment of tasks, Risk management Plan and Test Strategy.
• Conducted multiple one on one and brainstorming sessions with the SME’s to understand the as-is process and gather business requirements.
• Created as-is data flow and work flow diagrams and to-be data flow and work flow diagrams and conducted walkthrough sessions for these diagrams to make sure that the business and SME’s were on the same page.
• Worked on the functionality of Credit Risk, Operational risk and regulatory exposure that were all integrate to the Single-Family system to provide access to total exposure by customer for decision making, while using Loan documentation packages and performed functional testing on these.
• Created Business use case model, business use case specification, supplementary GUI requirements, reporting requirements and non functional requirements to capture all the business requirements. Used DOORS or requirements and documents management.
• Created Use Case model, Sequence Diagram, activity diagrams in UML using rational rose.
• Managed all requirements and traceability between requirements, design, SIT test cases and UAT test cases using DOORS.
• Participated in developing ETL’s for Data extraction, Data transformation and loading.
• Collaborated with architect to build logical and physical database models using ERWIN.
• Created Data Flow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Played a pivotal role in conducting Functional testing, Regression testing, and User Acceptance Testing (UAT).
• Created UAT test plan and conducted a walkthrough session to make sure all other teams (Development, SIT, Deployment, SME and Baseline) understood their roles and effort.
• Created test cases and test scripts for user acceptance testing and maintained them in Test Manager and created traceability to Doors.
• Conducted UAT and made sure all identified defects and enhancements were logged into in-house Access tool (Defect Enhancement Tracking System- DETS).
• Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.
• Overlooked the project binder and approvals log and ensured that all approvals and signoffs were attained as per schedule and met with the guidelines laid down by SOX.
• Ensured that changes in business process have strong controls and meet the reporting requirements of Aegis’s internal audit, and SOX.
• Created the Service level agreement to meet all current business requirements and anticipated future enhancements.
• Represented the team in Change Control Board (CCB) meetings to ensure that the changes proposed were approved by the board and migration of impacted codes to production occurred at scheduled time.

Environment: Oracle 8i/9i, MS Suite, SQL, Toad, Informatica, ERWIN, Rational Rose, Win Runner, DOORS, MS Access (DETS), ClearCase.

Confidential, CT

Business Analyst

Responsibilities:

• Involved in requirement gathering, analysis of the requirements from the business owners and users.
• Interacted in change control process, updating existing documentation. Posted the meeting minutes in the company Wiki page for access by the offshore team.
• Created RTM (Requirements traceability matrix) mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Performed Requirements Management that involved change control, version control and Requirement status tracking.
• Analyzed Requirements to generate Use Case Model, Activity Diagrams, Process Flow Diagrams and Class Diagrams.
• Drilled into existent SOA services to leverage maximum application/ software reusability.
• Maintained SOA standards, worked with SOA meta- model, SOA governance and SOA architecture for the loan processing engine.
• Formatted the Reports as per the Report requirements using Business Objects, which allows the users to analyze the data.
• Monitored, load tested and reported on the GECF Business objects Cluster environment supporting more than 1000 users.
• Actively Involved in General Ledger Reconciliation. Wrote SQL queries against Oracle database for report validation of the Accounts Receivable and Accounts Payable tables.
• Worked closely with BO Reporter to develop ad-hoc complex AP/AR/GL reports for users using Web intelligence 2.7.2/6.1a
• Helped develop full client reports using drill down, slice and dice, cross tab, and pivot table using Business Objects and published using Broadcast Agent.
• Created process documents, reporting specs and templates, material and slideshow presentations for the application development teams and managements.
• Involved in UAT, test plans, documentation of test reports etc.

Environment: Agile, JIRA, Wiki Page, Requisite Pro, SOA, Business Objects 5.1.6/6.1a, Web Intelligence 2.7.2/6.1a, Oracle 8.1.7, IIS.