Summary:

• 10 years of experience with Project Management and Systems Analysis in the US in the fields of web applications, client-server applications, object oriented analysis, software validation, process re-engineering.
• Experience in vendor management and comparative vendor analysis
• Experience as a SOX Analyst for evidence gathering and key controls.
• Experience with CDO Collateralized Debt Obligations , CMO Collateralized Mortgage Obligations and other mortgage backed securitizations.
• Expert in Requirement Analysis, data analysis, Use Case development and UML modeling using Rational Rose.
• Extensively used Sharepoint for document management
• Experienced in Business Process Engineering, Project management, Business Analysis and Project Leadership.
• Working knowledge of Business Objects/Business Intelligence tools and PeopleSoft Financials.
• Experience in conducting feasibility analysis and project proposal and level of effort estimation
• Experienced in web technology with continuous contribution to full Software Development Lifecycle SDLC .
• Experienced in Entity Relationship Diagrams ERD .
• Proven ability in Data Flow Diagrams DFD , Flowcharts.
• Extensive experience in Methodologies, Process Engineering and Management Tools: Rational Unified Process, Agile, UML, Object Oriented Analyses and Design Principles/Patterns Rational Rose Enterprise Edition, MS Visio, MS Office Tools.
• Expert in modeling business process using Savvion Business process modeling tool, for studying, simulating and identifying bottlenecks in business processes.

Software/Hardware:

Windows95/98/NT/2000/XP, SQL, PL/SQL, Visual Basic 6.0, UML, MS Access, MS-SQL Server 7.0/2000, Oracle 7.x/8.0/8i, 9i, 11g DB2, Sybase, Siebel, KOFAX, Rational ClearCase, Telelogic Doors 9.0, Rational ClearQuest, PCM Remedy Plus, Bloomberg, Entity Relationship Diagram ERD , WinRunner 7.0/6.0, LoadRunner 7.5/7.02, Astra Load Test, Test Director 7.2, Quality Center.

Experience:

Confidential

Sr. Systems Analyst/Project Manager

Responsibilities:

• Managed requirements gathering and analysis for MAXe Java based workflow management system .
• Led and managed a team in Albany NY and Reston VA to standardize requirements management process
• Led all phases of the New York State of Health NY Health Insurance Exchange project from requirements gathering, stakeholder management, risk management and change management
• Interfaced between the NY Department of Health, MAXIMUS and CSC coordinating JAD sessions
• Successfully conducted ROI analysis of deliverables, costing and budgeting of releases, and scheduling of resources
• Planned and managed multiple smaller projects within the NY Enrollment Center Program aligning business goals to the technology solutions under budget and with resource constraints

Environment:

Oracle, .NET, ALM, Siebel, KOFAX, JAVA, SQL Server.

Confidential

Sr. Business Analyst

Responsibilities:

• Analyzed and documented requirements for Web based CRD Registration Disclosure for Brokerage Firms and Brokers.
• Analyzed and documents requirements for FINRA Disciplinary Actions Online system
• Analyzed and wrote requirements for BrokerCheck External interface for public disclosure
• Analyzed and documented requirements, interface with the SEC Securities and Exchange Commission to gather requirements for IAPD SEC's website for public disclosure
• Coordinated change management process with the developers and the testers.
• Performed business impact analysis for system changes and upgrades.
• Analyzed and documented requirements for IARD -- Form ADV changes related to Dodd-Frank financial regulation for Wall Street.
• Performed JAD sessions with business users, Development and Quality Control teams.
• Developed BA testing scripts and test suite
• Performed BA testing and created validation plan before project releases.
• Resolved customer complaints using customer issue tracking system.

Environment:

Oracle, .NET, DOORs, Visual Source Safe, StarTeam, Sharepoint, SQL Developer, CRT.

Experience:

Confidential

Sr. Systems Analyst/Jr. Project Manager

Responsibilities:

• Analyzed and gathered requirements for Single Family Loan Amortization reports, SFTA Phoenix Core Engine for Alternative Collateral Deals, PC Debt, SFVA and Microstrategy reports to accommodate FAS 140 amendment provisions.
• Worked in compliance with SDLC 2.3 using DOORs for requirements gathered.
• Worked with both SDLC 2.3 and AMCP 5.0 templates for creating requirements modules in DOOR s.
• Created mock data and exceptions lookup for unit testing for SFTA 3.0 ACD project.
• Performed data analysis to ensure data quality and data integrity.
• Worked with the SOX controls and application controls team so that requirements are compliant with the Freddie Mac approved application controls.
• Performed requirements analysis for collection tables in CDW Corporate Data Warehouse for the Net Position Monitoring System.

Environment:

Oracle, Sybase, Java

Confidential

Business Analyst Lead

Project:

Cost Segregation

Real Estate Allocation

CFO Direct

Responsibilities:

• Analyzed and gathered requirements for Cost Segregation study done for classes of assets.
• Created wireframes using Axure Pro for user interfaces for Cost Segregation interface and CFODirect website.
• Created features list and functional requirements from stakeholder requests using Requisite Pro
• Created data requirements in Requisite Pro and used Requisite Pro views for requirements approval from business area.
• Worked on project level of effort estimation for requirements elicitation and user acceptance testing
• Analyzed data using Toad and provided feedback to database design.
• Performed a feasibility study/analysis for Real Estate Partnership tax return process
• Performed estimation for requirements elicitation and analysis, development and testing for project proposal.

Environment:

Oracle, .NET

Confidential

Sr. Business/Systems Analyst

Project:

Voyager

Regulation AB Reporting

Responsibilities:

• Analyzed and gathered Regulation AB requirements for SEC reporting for Asset Backed securities.
• Performed GAP analysis for data requirements for Regulation AB reporting.
• Performed data mapping and impact analysis of several systems LOS, RE and MSP systems
• Authored Business Requirements Document BRD after conducting JAD sessions with the several stakeholders from the Business Area, Business PMO and Capital Markets IT group, including the Application Development team.
• Authored Functional Requirements Specifications document FSD after successful meetings with the Capital Markets business heads and the Application Development team.
• Authored application and business Use Cases for Capital Markets and Investor Reporting interaction processes.
• Did current and future state Business and Systems process mapping.
• Worked with the business rules and derivation logic for Regulation AB reporting.
• Created Requirements Traceability Matrix to map requirements, design parameters and test cases.
• Developed mock up reports using Business Objects Desktop Intelligence.
• Wrote sql queries to create mock up data for testing scenarios, using Toad.
• Analyzed business and technical processes for WAMU Washington Mutual and JP Morgan Chase capital markets systems integration.
• Worked closely with internal audit for internal application controls.

Environment:

Business Objects, Oracle, Java

Confidential

Sr. Business/Systems Analyst

Projects:

Financial Segment Reporting.

Adjusted GAAP Ledger.

Chartfield Request Automation CRA

Responsibilities:

• Worked on Corporate Financial Accounting as part of the UAT team for CRA.
• Worked on UAT and documentation for Adjusted GAAP Ledger.
• Created a database for Financial Segment Reporting using MS Access.
• Build an Access database for internal reporting purposes with extensive use of SQL queries.
• Created a database for Financial Segment Reporting using MS Access.
• Worked on preparing internal and external monthly as well as quarter end reporting for Loans in Acceleration in Retained Portfolio, T-Deals and ARM and Fixed financial products.

Environment:

PeopleSoft Financials, Access

Confidential

Sr. Business/Systems Analyst

Projects:

• Tax Enhancements Release 1.0
• Tax Enhancements Release 2.0
• Tax Reporting
• PDTax
• Tax Catch Up 2005/2006

Tax Get Current 2007 Responsibilities:

• Worked on Corporate Tax department as a business systems analyst to gather and analyze requirements and interfacing with the development and implementation team.
• Created sequence diagrams to represent process and data dependencies.
• Developed use case diagrams using Rational Rose using the Fannie Mae ELSIF Enterprise-Level Systems Implementation Framework and SLCM Software Life Cycle Management standards.
• Wrote Business Use Cases and Systems Use Cases to document business functionality needs from the system.
• Conducted JAD sessions allowing different stakeholders to communicate their perspectives with each other and resolving issues to come to a quicker agreement.
• Coordinated defect management while User Acceptance testing using Quality Center.
• Created Change Requests and coordinated meetings with the development team for level of effort LOE estimations.
• Created mock up reports for Tax systems for the Reports development team.
• Performed UAT for TER 1.0 process using Quality Center and documented UAT results and UAT summary report.
• Created Change Management process flow for the TER process.
• Created Requirements Traceability Matrix RTM using Rational Requisite Pro and MS Excel.
• Created Change Request tickets using Clear Quest.

Environment:

Oracle 11i, Sybase, JAVA

Confidential

Sr. Business/Systems Analyst

Projects:

• PE Loan Servicing UAT testing
• General Ledger Extract UAT testing
• People Soft Treasury Cash Extract UAT testing
• Securitization Accounting Close the Books Projects:
• Journal Entry Automation for Due to Investor process.
• Journal Entry Automation for Alternative Collateral Deals process.
• HR information systems and one or more HR functions
• Demonstrated experience with reporting tools such as Crystal Reports, Business Objects. Peoplesoft Query
• Account reconciliation Automation for Single Class securities
• Account reconciliation Automation for Due to Investor process
• Account reconciliation Automation for Alternative Collateral Deals reconciliation.
• NIM REMIC JE Automation

Responsibilities:

• Worked in Performing Loans department as a liaison between the business side of mortgage servicing and the testing of the PE servicing.
• Calculated the DSI for remediation of loan data for Bank of America.
• Worked with the Loan Portfolio specialists and Senior Loan Portfolio Specialist for reviewing the loan level reporting process.
• Created Use Case Diagrams using Rational Rose to represent business users' needs. Worked closely with system analysts to transition business use cases to class diagrams. Created sequence diagrams to represent process and data dependencies.
• Conducted status meetings for UAT and effectively raised time-sensitive issues and bottlenecks for Management attention.
• Gathered business requirements and wrote requirements using Freddie Mac proprietary Technology Delivery standards. Used Rational ClearCase for versioning of business requirements documentation.
• Created Requirements Traceability Matrix to map business use case identifiers to application use cases. Coordinated with developers and system testers and system analysts to successfully create Requirements Traceability Matrices for different project workstreams.
• Wrote Business requirements specifications and tagged them using Rational Requisite Pro.
• Simultaneously worked on seven different projects in different phases of the SDLC.
• Helped initiative director with the data volume assessment while choosing Third Party vendor COTS tool CheckFree Recon Plus Frontier .
• Worked closely with Deloitte to transform requirements into third party reconciliation tool requirements analysis and design.
• Created Test plan and test strategy for User Acceptance Testing for multiple projects.
• Wrote Test Cases and test scripts for User Acceptance Testing for different projects.
• Actively managed defects for UAT using Rational ClearQuest.
• Actively engaged in reengineering of business processes and suggested alternative process improvement paths for efficient time management for Securitization baseline team.
• Helped in Project management creating dashboards and management reporting in order to backfill the position.
• Performed due diligence on process control and quantification of the variances in Securitization Accounting reconciliation process working closely with the baseline accountants.
• Played the role of post production point of contact for issues and hot fixes.

Environment:

Oracle, Sybase, DB2, Java

Confidential

Systems Analyst and Usability Tester

Responsibilites:

Performed usability analysis and testing of the websites for Techsolv's corporate clients

Tracked and resolved marketing and usability issues of web display and content

Analyzed and worked with content management team for web content display

Performed Software testing both interface testing as well as backend testing for content-heavy websites for corporate clients

• Wrote SQL queries for data analysis
• Wrote Test Cases and test scripts for User Acceptance Testing for different projects.
• Actively managed defects for UAT using Rational ClearQuest
• Designed and conducted training sessions for team members for Dreamweaver and Flash web authoring tools
• Performed automated testing for various client websites using WinRunner

Environment:

Oracle, Java

Instructional Design Instructor

Confidential

Responsibilities:

• Consulted with Technology Grant recipients STEG/TEG on technology driven projects presented to the Governor.
• Advised faculty and staff teams on using database concepts and web design tools.
• Analyzed the grant proposals for STEG Staff Technology Enrichment Grant and TEG Technology Enrichment Grant grants on the basis of cost vs. benefit considerations.
• Created course materials in PowerPoint, for the technical classes taught at CIDD, which made it easier for new trainers to use the material and cut down on the time of creating course materials by 65 .
• Developed Intranet Mailing system prototype using JAVA technologies for CIDD Center for Instructional Design and Delivery .
• Developed Excel based macros to automate budget data load per department requirements.
• Designed SQL queries for customized reports and quality assurance checks.
• Involved in requirements gathering from faculty and staff to create training equipment database, using Oracle paired with ColdFusion. Designed logical model to meet information requirements and created physical data model.
• Successfully lead and managed a multicultural team with varying levels of web skills.
• Delegated different sections of the web site to members of the web team and troubleshot the problems and curbed the inefficiencies in the web pages.
• Tested and validated download efficiency and assess user-friendliness of the interface.

Environment:

Oracle, Java, Web CT

Confidential

Business Analyst/QA Analyst

Direct Marketing and Customer Information system

Responsibilities:

• Involved in Requirements gathering, Design Specifications, Preparing Unit Test Plans, Coding, User Acceptance Testing support, Support Maintenance.
• Worked with company IT, RA/QA and system user representatives to develop and implement validation plans for the company network.
• Responsible for generating validation policies and plans, including all necessary documentation.
• Documented the results of system validation tests.
• Used Test director for Requirements and Test Plan.
• Performed Database testing using database checkpoints.
• Performed Functional testing using automated tools like WinRunner.
• Integrated testing for the different modules.
• Wrote system validation policies, protocols and test plans.
• Implemented and monitored formal system change control procedures.
• Identified exceptions and variances with generally accepted system validation requirements and the development of corrective action plans.
• Developed Test Scripts using Test Script Language TSL .

Environment:

JD Edwards, Seibel, PeopleSoft