SUMMARY

• A result oriented Sr. Business/Data Analyst having more than 6+ years of experience in Credit Card, banking, financial and secondary mortgage industry.
• Well versed with all phases of various SDLC’s with extensive experience in business requirement gathering and strong understanding of Lending, direct Collateralized Assets (ABS, CDO, MBC & CMO) account reconciliations and PeopleSoft general ledger.
• Over 7+ years of diverse experience with 6+ years as a business analyst.
• Extensive experience in financial and banking sectors including mortgage backed securities (MBS), collateral mortgage obligation (CMO), asset backed securities (ABS), collateral debt obligations (CDO), account reconciliations and general ledger (GL) journal entry (JE) automation, Credit card and direct banking, Auto loans, Small business lending.
• Strong knowledge of many software development life cycle (SDLC) methodologies including Rational Unified Process (RUP), Agile, Extreme Programming (XP), Waterfall, Spiral Model and other proprietary technology delivery frameworks and processes.
• Hands on experience in creating Business Process Models, which defined the high level business activities and processes and provided a foundation for the Use Case model.
• Expertise in the development and interpretation of Business Requirement Document (BRD), Business Process Document, Functional Requirements Specifications (FRS), Use Case Specification (Business and Application), Use Case Models, Systems Design Specifications (SDS), and Business Continuity Plans (BCP), Requirements Traceability Matrix (RTM)
• Experience in implementing RUP methodology, Agile methodology
• Hands on experience in managing requirements using Requisite Pro and Doors.
• Extensively used Unified Modeling Language (UML) to graphically represent system's blueprints, business processes and; the as - is and to-be system functionality.
• Expertise in modeling using Use Case Diagram, Sequence Diagrams and Activity Diagrams.
• Adept in creating test cases and scripts; and conducting User Acceptance Testing (UAT).
• Extensive experience in creating SQL queries to facilitate UAT.
• Excellent at coordinating extensive communication networks and facilitation of joint application design (JAD) sessions, brainstorming sessions and interviews.
• Extensive experience in managing and controlling change using Clear Quest and performing version control using Clear Case.
• Well versed with Cost benefit analysis and ROI analysis.
• Exposure to PeopleSoft Enterprise General Ledger, PeopleSoft Enterprise Cash Management and SQR.
• Experience with Data modeling in a decision support environment.
• Exposure to QA Principle SEI CMM levels, ISO 9001, Software Development Analysis.
• Knowledge of Sarbanes Oxley (SOX) Act, Section 404 key controls as implemented through project management methodologies.
• Strong analytical skills and excellent at identifying root causes and executing corrective actions.
• Experience in preparing Project Schedules and performing; Milestone Tracking and Resource Allocations using MS Project.
• Exceptional ability to work under high pressure and proven to work independently or as a part of a team.
• Strong Knowledge of Document Management and Workflow automation.

TECHNICAL SKILLS

Requirements Management and modeling Tools: Requisite Pro, Doors, Rational Rose, Raven, Microsoft Visio

Change Management and Version Control: Clear Case, Clear Quest, Quality Center

Statistical Tools: Minitab, SPSS

Programming Language: C, Java, SQL

Databases: MS SQL server, MS Access, Oracle 9i, My SQL, DB2, Sybase

Project Management: MS Project 2000, MS Project Server

Other Tools: MS Office (Word, Power Point, Excel), Interwoven, Test Manager, RapidSQL

PROFESSIONAL EXPERIENCE

Confidential, NY

Lead Business Systems Analyst/ Process Engineer

Responsibilities:

• Worked as a facilitator to conduct assessment sprints with lines of business and horizontals
• The team followed the Agile Methodology to achieve results and coordinate effort with fast results
• Worked with business users and compliance advisors to gather requirements
• Analyzed regulations and the legalese in circulars, bulletins and news releases to extract requirements
• Documented requirements and maintained the high profile Applicability Matrix in a requirement management tool
• Created Business Process Maps, SIPOC, RACI and standards to be used as tools to communicate information, progress and approach to senior management, VP and SVP level and to be used as guidance documents by Businesses to build new processes
• Provided Process Engineer support to conduct assessment to various lines of business and horizontals such as CBR (Credit Bureau Reporting), Privacy, AML, US Card, GFS (Global Financial Services), Confidential Auto Finance and Staff Groups such as Brand
• Analyzed the US Card business processes, such as acquisition campaign and card offers, soliciting customers, customer management intent, credit policy, collection of delinquent accounts, recover charged off accounts, payment processing, authorizations.
• Worked with Credit Bureau Reporting to assess the controls and monitoring surrounding various business processes
• Worked on figuring out gap remediation plan surrounding controls and monitoring for business processes such as developing new products/product features, collateral fulfillment (secure card), identity verification processes, and fulfillment. (Fulfillment includes, correspondence, plastics, funds disbursement, rewards redemption, etc.).
• Created detailed process documentation to figure out and implement action plan for compliance to in corporate new or changed regulation and legislation and changes in existing applicability
• Conducted release planning to lay out the plan and product backlog for next 8 sprints(4 months) including LOE and timelines
• Documented Assessment results and facilitate communication between various teams and business groups to conduct follow ups and issue resolution
• Created CMAS (Compliance Management Assessment Spreadsheet) which was a key product of assessments
• Worked with Issue Resolution Team to work on the Gaps identified in the Assessments and to create Gap remediation document that involved figuring out the steps to remove the control and monitoring gaps
• Worked with the CREST team to figure out the most efficient way to store the live requirements document and Applicability Matrix
• Worked on designing the database and uploading the Requirement and Assessment data to CREST.
• Conducted extensive testing (system and acceptance) to the system to identify any problems in the CREST system that may have arose due to changes in the database design
• Designed reports of monitoring results to be used by SLT to manage compliance and report out to auditors and examiners
• Acted as a liaison between the team and lines of business to communicate business ideas to the team and get team’s feedback and suggestion to be taken to business.
• Identified the requests that should be taken into sprints and initiated dialogue with customer
• Used Interwoven as a tool for Enterprise content management.
• Gathered and documented requirements for enhancement requests from customer. Used Quality Center to manage requirements and traceability
• Managed delivery expectations from customer and keep the team priorities on track. Worked on managing multiple projects with varying priorities and different delivery dates.
• Provided suggestions for a better product to customers with half baked requests.
• Assisted in testing of deliverables and managed feedback from customers
• Worked on change management and help decide which changes to accept and communicate to customers
• Created burndown chart and tracked team’s progress
• Drove sprint planning to give performers enough direction on customer requests to plan tasks for the sprint
• Participated in various activities like hours estimation, story sizing, team velocity determination to use as tools to manage work for the team that will enable us to deliver high value at sustainable speed.
• Participated in various program management activities like conducting feasibility analysis of incoming requests and negotiating with customers for expectations and deliverables.
• All the tasks listed above involved extensive back and forth communication across businesses (SMEs’ and performers) to extract the knowledge and then obtain feedback and conduct implementation of new or changed business processes.

Confidential, McLean VA

Sr. Business/Data Analyst

Responsibilities:

• Analyzed business processes and created process maps. Wrote standard and complex SQL Queries ( tool: RapidSQL) to perform Data Validation, Analysis and Data Mapping of Sybase and DB2 data.
• Owned a complete Liquidity and Contingency (L&C) portfolio for Non-Mortgage Instruments
• Created one-to-one mapping of data submitted to OFHEO and reporting instructions provided by OFHEO
• Performed in depth analysis of the data processing code (primarily coded in SQL for Non-mortgage instruments) to determine discrepancies and deviations from the required format and content
• Worked with business users and SME’s to analyze the existing business processes and document the same
• Obtained required information from business users, OFHEO report instructions and MDR (Meta Data Repository) and reported any missing or wrong information in MDR and also supplied the right and relevant information.
• Suggested efficient and optimal methods of data processing (data formats and coding) for submission to OFHEO
• Created inventory of manually maintained tables, data dictionary of reported fields and tables, formats and their valid values for use in analysis and planning for all the arms of the initiative
• Conducted walkthroughs with SME’s and Stakeholders to describe the ‘as-is’ and ‘to-be’ business processes
• Removed unwanted and inefficient data processing steps including temporary tables and consolidated the code for optimal performance
• Identified manual processes and manually maintained tables and worked with business users to automate data processing
• Trained the new resources joining the team for data analysis and created training manuals for new data reporting methodologies for the business users
• Prepared Business Rules Spreadsheets, Code Narratives and Summary Reports for gap analysis.
• Conducted reviews of documents prepared by data analysts and business users to be submitted to the directors for signoffs
• Obtained signoffs on Code narratives and Business Rules Spreadsheets from SME’s and Business side Directors
• Identified data element dependencies and processing trails and created to-be business rules and code for extracting, transforming and loading data from transactional database to CDW and then to the tables reported to OFHEO.
• Created and maintained issues log and identified ways to tackle issues and discrepancies
• Communicated project status to various arms of the project including stakeholders, business users, initiative and SME sides

Confidential, Washington, DC

Sr. Business Analyst

Responsibilities:

• Analyzed business needs and requirements for new business processes to integrate the E2E business flow to follow the new PSR (Payment System Risk) Policies enforced by FRB on GSE’s
• Used a hybrid of RUP and waterfall as the SDLC. Also worked in teams that followed Agile methodology
• Created and managed extensive documentation on Business Operating Procedures (BOP) for DLOD (Daylight Overdraft) E2E as-is and to-be business processes
• Worked with the end users, development team and upper management to communicate progress and to keep every team on the same page
• Interacted extensively with FRB (Federal Reserve Bank) to understand the new methods implemented to enforce overdraft policies
• Lead parts of UAT to test the trade entry, settlement and maturity system that was integrated with IWT (Integrated Wire Transfer) for sending and receiving the wires to and from FED.
• Created business process maps for the as-is and to-be process in Rational Rose.
• Worked on the complete analysis and documentation of every Wire transaction process and functionality of IWT system (Integrated Wire Transfer)
• Tested the messaging system SWIFT for day to day funding and investment trading
• Conducted individual and group (JAD) sessions with business and technical units.
• Followed the RUP guidelines and created RUP artifacts.
• Analyzed business requirements, business process and system architecture/design.
• Responsible for defining and documenting Business Requirements (SRD) and Functional Specifications (FSD).
• Designed Use-Case Models after understanding scope of the project and the business model.
• Followed the UML based methods to create Sequence Diagrams, Collaboration Diagrams and Class Diagrams.
• Responsible for facilitating and arranging JAD Sessions, Business Interviews with the stakeholders and end users.
• Developed system and defined metrics to evaluate performance in innovation, customer satisfaction & employee participation.
• Worked with business users on legacy systems to generate expected results.
• Conducted walk through sessions with users and SME’s to get sign-offs on expected results.
• Worked with Cash Management and Wire Room to conduct tests and provide training to business users.
• Conducted DLOD end-to-end UAT testing on the various systems such as ORION, STAMPS, SWIFT, STATS, DTA, STN, IWT, PISCES, iSTAR, Automated Trade Blotter.
• Refined and validated requirements and create RTM (Requirements Traceability Matrix) to validate the completeness of requirements and test plan. Used Quality Center for this purpose.
• Conducted data extraction and data validation to test the system from the business perspective.
• Identified and tested one-off scenarios to test the robustness of the system.
• Coordinated and prioritized outstanding defects and enhancements identified during UAT, and escalated the same if necessary to achieve the deadline.
• Updated the issues log with all issues identified during UAT and communicated the same to all stakeholders.
• Participated in daily UAT status meeting with all teams involved to resolve outstanding issues.
• Conducted walk through sessions with users and SME’s to get sign-offs on testing results.
• Sent UAT status e-mails to stakeholders and involved teams outlining the UAT progress, issues and unresolved defects.

Confidential, NJ

Sr. Business/Systems Analyst

Responsibilities:

• 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 as us.
• Worked with the SME’s, and baseline team to redesign the business process.
• 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.
• Managed change and was responsible for creating CQ tickets for all defects, enhancements and change requests.
• Mentored my team to use FMEA (Failure Mode Effect Analysis; a Six Sigma tool) to identify critical test scenarios for UAT to minimize the risk caused by aggressive timeline.
• 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 Rational Test Manager and created traceability to Doors.
• Conducted UAT and made sure all identified defects and enhancements were logged in clear quest.
• 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 TDP and SOX.
• Ensured that changes in business process have strong controls and meet the reporting requirements of Confidential ’s internal audit, PriceWaterHouseCoopers audit, and SOX.
• Lead the baseline and SME training.
• Created the Service level agreement to meet all current business requirements and anticipated future enhancements.

Confidential, NJ

Sr. Business Analyst

Responsibilities:

• Worked with a team of 4 Business Analysts.
• Was an integral part of business process redesign.
• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked as a systems analyst on COTS products, being involved in the complete SDLC process
• Created business process workflow diagrams (Activity diagrams) for the as-is and to-be process in Rational Rose.
• Created Business Use-Case Model and Business use Case specifications after accessing the status and scope of the project and understanding the business processes.
• Produced functional specifications and led weekly meetings with OutlookSofts consultants and business units to discuss outstanding technical issues and deadlines that had to be met
• Created and managed use-case templates and traceability relationships in RequisitePro.
• Managed all the requirements (Business and Application use cases) in RequisitePro, making requirements available to all team members and to maintain traceability between requirements, design, SIT test cases and UAT test cases.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Managed and controlled change using Clear Quest, associated requirements to specific change request/enhancements/defects and made sure that other teams were following the change requests guidelines.
• Linked business processes to organizational objectives, performed critical path analysis, and identified opportunities for business process improvement.
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
• Updated the issues log with all issues identified during UAT and created defect tickets in clear quest for all defects and enhancements identified during UAT.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Gathered requirements from business users and created business requirement documents.
• Identified and documented business rules and created detailed Business Requirements and Software Requirement Specifications.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Worked on writing functional specification for reporting module that handled credit and consumer risk management services.
• Supported and assisted Developers (JAVA, JSP) and QA in developing Quality Control (QC) test plans and test scripts, as well as supporting and assisting clients in all testing phases through UAT.
• Organized and Performed GUI Testing, Functional Testing, Regression, General Acceptance Testing (GAT) and support for User Acceptance Testing (UAT)
• Created requirement traceability matrix (RTM) using excel.

Confidential, Houston, TX

Business Analyst/Business Engineer

Responsibilities:

• Facilitated requirement gathering sessions for different business areas reporting needs.
• Conducted tools and platform selection analysis. Worked with developers and software vendors to conduct POC.
• Assisted in developing use cases, test scenarios and implemented test plan.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Confidential, Arkansas

Business Engineer

Responsibilities:

• Identified the vital few processes, implemented process improvements and applied Six Sigma where ever appropriate.
• Planned supervised and coordinated all tasks required to design, develop, implement, test and document a custom Production planning Application.
• Communicated and coordinated activities with Production Control, maintenance and outside contractors
• Software Technologies used: MS SQL SERVER, Visual Basic 6.0 and MS Access