Lead Business Analyst Resume
Herndon, VA
SUMMARY
- A Certified Scrum Master with more than 10 years of experience in Credit Card, banking, financial and secondary mortgage industry. Well versed with all phases of various SDLCs with extensive experience in business requirement gathering and strong understanding of lending, claims processing, reporting, controls assessment and compliance.
- Strong knowledge of many software development life cycle (SDLC) methodologies including Rational Unified Process (RUP), Agile, Extreme Programming (XP), Waterfall, and other proprietary technology delivery frameworks and processes.
- Certified Scrum Master (CSM) with in depth knowledge and understanding of Agile principles, implementation practices and the ability to motivate a team to adopt the scrum practices to deliver high value early on in the project life cycle
- 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)
- Hands on experience in managing requirements using Requisite Pro and DOORS, STPsoft.
- Extensive experience in working with 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.
- Familiar with Business Objects and Crystal Reports requirements, setup, testing and deployment.
- Experience with Data modeling in a decision support environment. Good understanding of Data conversion practices and hands on experience
- 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, Testing Management and Modeling Tools: Requisite Pro, DOORS, STPsoft, HP Quality Center, Microsoft Visio
Change Management And Version Control: Clear Case, Clear Quest
Databases: MS SQL Server, MS Access, Oracle 9I, My SQL, DB2, Sybase
Project Management: MS Project, MS PROJECT SERVER
Other Tools: MS Office (MS Word, Power Point, MS Excel), RapidSQL, Toad
PROFESSIONAL EXPERIENCE
Confidential, Herndon VA
Lead Business Analyst
Responsibilities:
- Served as the lead Business Analyst on two projects leading the requirements gathering and documentation effort
- Managed and guided the team of BAs through the SDLC on various project activities to make sure the team delivers quality deliverables
- Worked with Business area to perform requirements prioritization at high level to plan the product releases
- Guided the team in identifying the vertical value slices of the feature stack so that high value features can be delivered as early as possible
- Extensively worked on requirements gathering, storyboarding, process mapping and gap analysis
- Used DOORS as a tool to create, manage and share project artifacts such as requirements documents and user stories
- Identified one off scenarios and combination scenarios that would test the functionality for situations that the tools couldn’t identify so that critical functionalities are tested for all possibilities
- Maintained requirements traceability matrix in DOORS and used the tool for communicating and sharing the documentation with other parts of the team.
- Conducted walkthroughs with business area to obtain requirements signoffs, and complete requirements reviews with technical teams to communicate the business need and expected solutions so that the technical team can understand the requirements in their entirety and develop the desired product accurately
- Performed process analysis to identify gaps and documented the recommendations to achieve a leaner business process
- Created Business Flow Diagrams, Dataflow diagrams, UML Activity diagrams and use cases diagrams
- Provided training support during roll out for the customers and responsible for answering their questions in a timely manner
- Lead parts of UAT to create a strategy, create test plan and document test cases for critical features
- Performed bug tracking and analysis to provide the development team with resolution support
- Tracked issues through resolution and regression testing to make sure proper fixes are deployed without breaking other parts of the code
- Performed status reporting and resource allocation during various sdlc processes to make sure phases are completed in time and while achieving high business value.
Confidential, McLean VA
Lead Business Analyst
Responsibilities:
- Worked on Developing a Rules Engine for Reimbursement System that evaluates claims and incentives paid to servicers
- Worked with Business area to define the rules, maintain a Business Rules Spreadsheet that governed the rules automation in rules engine
- Defined functionality to create a scalable, high performance rules engine that non-technical business users can manage themselves by defining/changing, testing and reporting on the rules criteria
- Managed the creation of extensive Audit functionality to manage the quality of rules
- Identified ways to make the rules engine robust by adding conflict and redundancy detection functionality in the Rules engine
- Worked on creating a design that would allow other teams to make use of the functionality by plugging in to the process and receive the service (SOA)
- Worked on creating new business processes to identify and mitigate risks and inefficiencies in existing processes
- Worked as the lead business analyst on ACH payment processing, Audit and queue management functionalities in the ERS Replatforming effort
- Defined Reporting requirements, data sources and data transformations needed to address operations management and accounting reconciliation reporting needs
- Created Data mapping documents, extensively involved with technical team to create the data model for reporting server, identified optimal ways of data transfer (such as flat files, XML documents) and loading processes to the reporting server
- Utilized MISMO standards for defining data dictionaries and xml file formats in all associated applications and loan and claim data transfers
- Obtained good understanding of Default Fees and Claims business processes and involved systems under Default Asset Management
- Documented Tax reimbursement requirements and performed in depth analysis of all assessed taxes that real estate properties can encounter
- Analyzed tax calculation and payment processes and policies followed by Confidential and servicers to document appropriate requirements for claims reimbursement
- Gathered requirements through one-on-one sessions, brainstorming, JAD sessions and process improvement sessions
- Performed extensive analysis for identifying requirements for income reporting for 1099 purposes for various claims reimbursements
- Documented requirements and oversaw the design and implementation of data feed to appropriate systems for 1099 tax reporting requirements
- Performed control impact assessment and incorporated requirements to account for applicable regulatory compliance
- Documented and managed requirements in Requisite Pro per the guidelines provided by Confidential SDLC. Managed RTM in STPsoft for traceability and testability
- Performed walkthroughs to explain requirements, and obtain signoff from business area officers, including senior directors and VPs
- Worked as the communication link between Confidential business area and Vendor contacts for requirements definition, elicitation and any issue resolution
- Worked on defining vital reports that feed data to GL journal entries. Analyzed the processing of numbers that generate JEs and identified ways to automate them through the system
- Provided training to business users on use of new system, obtained feedback and communicated to Vendor for improving the system
- Documented Test Scenarios, steps and data points for facilitating User Acceptance Testing effort. Identified business scenarios that would test the system from business rules perspective, and maintained an issue log to escalate and manage issues properly
- Performed UAT in testing phase to assist the testing team meet aggressive schedule goals
- Created change requests in ClearQuest. Managed them through implementation for any necessary regression testing and issue escalation
- Actively participated in reviewing Test Plans, Design Documents and Requirements documents created by other team member on different parts of the project
Confidential, Cincinnati, OH
Lead Business Analyst
Responsibilities:
- Worked with Project Manager to create Project Plan
- Strategies to work with 4 operating companies and thousands of branch locations scattered all across US and Canada
- Created project timelines and resource requirements to develop the interfaces
- Lead the requirements gathering effort
- Worked on the project of Master Data management, identifying strategies to properly manage, and utilize parts data from various suppliers
- Created Data mapping documents and data migration plan for integrating parts databases
- Gathered and documented reporting requirements and dashboard design for trending and analysis purposes
- Documented Business Requirements and Business Process Maps of current and future business processes
- Identified gaps in current business processes and opportunities for improvement in future state
- Coordinate efforts with Architecture team to perform data mapping with legacy systems and data design for interface development
- Interviewed business users, business stakeholders, and directors to gather accurate business requirements
- Presented deliverables to panels of upper management to obtain approval on implementation strategy
- Conducted status meetings with various business units to keep team coordinated.
- Performed appropriate closeout procedures to properly document and archive the work products after management’s decision to shelf the project due to budget constraints
Confidential, Richmond, VA
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 the technical team in orchestration of the Single Sign-On system. Documented the system requirements and obtained sign-offs.
- Worked with multiple business areas to understand the authentication process and helped design the SSO that would satisfy the requirements for all systems involved
- Analyzed regulations and the legalese in circulars, bulletins and news releases to extract requirements. Documented requirements and maintained the high profile Applicability Matrix
- 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), COAF ( 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.).
- Conducted release planning to lay out the plan and product backlog for next 8 sprints including LOE and timelines
- Documented Assessment results and facilitated 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
- 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.
- Managed delivery expectations from customer and kept the team priorities on track.
- Drove sprint planning to give performers enough direction on customer requests to plan tasks for the sprint. Created burndown chart and tracked team’s progress. Worked on change management and help decide which changes to accept and communicate to customers
- 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
- Analyzed the data conversion protocols and performed data quality analysis. Recommended corrective actions.
- 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.
- 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
- Created and managed extensive documentation on Business Operating Procedures (BOP) for DLOD (Daylight Overdraft) E2E as-is and to-be business processes
- 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
- 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.
- Responsible for facilitating and arranging JAD Sessions, Business Interviews with the stakeholders and end users.
- 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.
Confidential, New Jersey
Sr. Business/Systems Analyst
Responsibilities:
- 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 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.
- Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.
- Created the Service level agreement to meet all current business requirements and anticipated future enhancements.
Confidential, New Jersey
Business Analyst
Responsibilities:
- Worked with a team of 4 Business Analysts. Was an integral part of business process redesign. Worked as a systems analyst on COTS products, being involved in the complete SDLC process
- 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
- Linked business processes to organizational objectives, performed critical path analysis, and identified opportunities for business process improvement.
- Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.