Business Analyst Resume Washington, DC - Hire IT People (2024)

SUMMARY

• Over 7 years of experience in Business/ Business Systems, creating Business and functional requirements (BRDs and FRDs), process flows, and Use Case/ Stories documentation, using IT Business Analytics, Modeling, and SDLC.
• Advise the business SMEs (Subject Matter Experts) on the most appropriate User Experience, keeping in mind the achievement of the required functionalities for the full Project life cycle.
• Mentor and coach junior team members, to achieve project milestones in a timely, and efficient manner.
• Experienced in BPM (Business Process Modeling), using BPMN (Business Process Modeling Notation), and UML (Unified Modeling Language) to design Use Cases/ Process Flows and Activity diagrams. Created FRS (Functional Requirement Specifications) thru whole SDLC (System Development Life Cycle) by requirements gathering, analysis, Design, testing/ maintenance using RUP (Rational Unified Process), UML, and MS Visio.
• Defect/ issues resolutions, during Systems Testing, White/ Black Box Testing, IST (Systems Integration Testing), (Functional/ RT (Regression Testing), and UAT (User Acceptance Testing)) during Release Phase.
• Advise the Project / Program Managers in analysis of the Project staying on - track for its critical activities, tasks, and budget constraints.
• Analyze technical issues for Business SMEs/ management/ development teams to identify and evaluate technical solutions options including; collaborating with project teams to resolve technical hurdles, solution proof-of-concept (POC), and evaluating Commercially Off-the-shelf third party products. Perform GAP Analysis and work with Stakeholders and end Users to create procedures, meeting SLAs (Service Level Agreements).
• Outstanding Analytical, Leadership, Interpersonal, and communication skills. A Team player. Student mentality. Ability to Adapt and learn New Tools, Techniques and Approaches.
• Facilitate J.A.D. (Joint Application Development) and J.R.D. (Joint Requirements Development) sessions, with Project Sponsors and Development team.
• Ability to collaborate with peers in both business and technical areas to deliver optimal business process solutions in line with corporate priorities. Able to work independently and in team environments
• Outstanding ability to build productive relationships with clients, vendors, and user & cross-functional groups.
• Excellent interpersonal, collaborative and documenting skills.
• Strong analytical, problem-solving and communication skills with emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management
• Ability to understand, analyze and design business processes and workflows with the objective of providing recommendations for the best use of technology for improvement

TECHNICAL SKILLS

Languages: SQL, UML, JAVA

RDBMS: Oracle 9.x, SQL Server 2000, MS Access, DB2

Process Methodology: RUP, SDLC, UML, JAD, GUI, UAT, RTM

Requirements Management: Rational RequisitePro

Business Modeling: MS Visio, Smart Draw

Change Management Tools: ClearQuest, MS Visual Source Safe

Applications: MS Office Suite, Adobe Suite, Rational Suite

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, Washington, DC

Responsibilities:

• Acting as liaison between PMO, EDI Party Master IT teams and stakeholders (Secondary Mortgage lines of business such as Capital Market, Single Family, Multifamily, Finance, Middle Office, Cash Processing, Cash Management, Counterparty Credit Risk management and others).
• Analysis of business cases, use cases and documenting business requirements document (BRD).
• Gathering functional and nonfunctional requirements and maintaining them using DOORS requirements management system in release 1 and as user stories in Rally (Agile/Scrum) in release 2.
• Creating/updating process flows (AS - IS) and (TO-BE) of the system and its interfaces.
• Data analysis, data mapping and definition of conversion and sourcing data requirements.
• Creating business glossary as well as technical data dictionary.
• Eliciting UAT scenarios and test cases following the V-Model, documenting and maintaining them using Quality Center/ALM.
• Creating and maintaining Requirements Traceability Matrix (RTM) with UAT cases (test coverage).
• Executing UAT cases, conducting production shake-out, tracking results for the UI, vending, database validation (SQL, TOAD, SOAP, TIBCO GEMS), conversion, sourcing, reporting (BOXI), Blackrock modules.
• Tracking, determining severity and priority, assignment and remediation of defects.
• Scope analysis, gap analysis, risk reporting and mitigation.
• Daily, weekly and post release UAT status reporting to project management and PMO.
• Project coordination and remediation of project issues.
• Writing/Updating user manual for the evolving system.
• Training and knowledge transfer of business analysis/systems analysis and UAT concepts to team members.

Business Analyst

Confidential, Northbrook, IL

Responsibilities:

• Gather and manage Business/ Stakeholder/ functional requirements through the complete SDLC, using iterative project methodology.
• Conduct in - person/ online interview sessions with various stakeholders to solicit their visions/ requirements about the opportunity/ initiative at hand.
• Capitalize on opportunities to maximize the benefits/ project outcomes by highlighting unexpressed requirements.
• Analyzing the internal and external processes, dependencies, SOPs, interfaces, and, mapping them to specific business needs, objectives and desired functionalities.
• Creating detailed and clear documentation of desired enhancements to ensure accurate mapping and integration with different dependent systems, both internal and external, to business processes to achieve maximum efficiency to allow maximum automation and great user experience for both, external, as well as internal users.
• Accurately document the As-is business processes to facilitate analysis, comparison, and mapping with desired to-be solutions, duly capturing the Gaps, by creating the to-be Process flow diagrams, data-flows and Use Cases.
• Analyze and document the existing systems architecture to facilitate an accurate assessment of dependencies between different applications, databases, and impacted functionalities.
• Manage project documentation/ versioning using MS Sharepoint.
• Manage client Change requests in light of newly desired functionalities.

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Documented system requirement specifications for new CLEAR platform and create dataflow prototypes to simulate interface for integration between closing systems. Established a business Analysis methodology around the Agile Methodology \Iterative approach.
• Involved in major part of software development life cycle requirement analysis, testing, implementation and support.
• Functioned as a subject matter expert (SME), process, and operational expert to conduct end user training.
• Participated in requirement gathering from all areas of the business and provide tactical and strategic deliverables.
• Gathered business Requirements, analyze data and workflows.
• Defined the scope and progressed from problem statement to well - documented designs.
• Identified and validated high potential business opportunities for stakeholders.
• Analyzed requirements utilizing various methods such as sample data from sql queries, screenshots, reports, prototype screens, sourcing information, and other data models.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Extensive work experience with portfolio managers and Compliance Manager to configure the rule-based scenarios for capturing the business requirement.
• Performed GAP analysis between source and target data elements and executed reports for different module such as: Escrow, Fair Market Value, Real Estate Owned, Repurchases, Interest Income, Amortization, Home Equity line of Credit and Remittances.
• Analyze the data delinquencies and work with ETL developers to coordinate necessary code changes.
• Generate and presented weekly status report for project sponsor team and maintain issue and defect logs.
• Worked with QA team in writing the test plan and test cases and outlined the test parameters for each release.
• Created standard test case template according to the company requirements and standards.
• Extensively wrote SQL queries to verify data as per transformation requirements.
• Involved in DBA tasks such as table creation and maintenance, create indexes, optimize queries, and grant privileges.
• Involved in creation of database tables, global temporary tables, cluster tables, partition tables and index-by tables using storage parameters.
• Worked with developers and wrote stored procedures, stored functions, packages and used in many forms and reports.
• Created indexes on tables and optimizing stored procedure queries.
• Kept a log of staging and target tables to perform data mapping for reconciliation.
• Updated corporate project ranking system Viper with project related request, inquiries and issue and escalate/route to corresponding team for follow-ups and resolution.
• Involved in UAT and assisted operations in production readiness testing for dress rehearsal.
• Extensively used data stage for transformation and data mapping in ETL Process while using mapping.
• Wrote SQL queries to test the integrity of the database in the development, staging and production environment.
• Wrote SQL Statements to extract data from the tables.
• Involved in testing different reports in the QA Environment.
• Extensively work on Access, Excel, Word, PowerPoint, and MS Project.

Business Data Analyst

Confidential, Des Moines, IA

Responsibilities:

• Involved in System Analysis & Design of the Enterprise Data Visualization Architecture
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Worked closely with all team members in implementing Tableau BI tool in all IT projects
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for Analytical Projects and Data Visualization teams
• Conduct business requirement review sessions with IT and Business teams to understand what the outcome should be based on data elements.
• Involved in generating Daily/Weekly Finance trending reports using Tableau by identifying the dimensions, measures, measure values & level of details for Business Analytics & Top Executives to give an overview current Trends
• Successfully integrated views with the SharePoint Portal using Page Viewer Web Part.
• Prototyped Visualization of Time Series and Data Transparency in tableau for attendance, payroll, and benefits data Integration
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups
• Improved performance by tuning Operational Dashboards for Oracle and SQL Server based Data Warehouse
• Defined best practices for Tableau report development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Worked on various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.

Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Requirements Elicitation and planning for Application Enhancements.
• Business Analysis for Claims to support IT and Business Enhancements in the application.
• Use Agile management tool - VersionOne to developed the product backlog along with Product Owners.
• Participate in sprint planning, sprint reviews, daily scrums and testing.
• Support day to day business operations of claims processing and settlement using the Business Application.
• Software Development Life Cycle management using ALM- Quality Center.
• Estimation and Schedule of IT and Business Enhancements in the application.
• Functional analysis, configuration and testing of Application Enhancements.
• Lead a team of Associate Business Analyst and Business Analyst in the project.
• Pre-sales Consulting, Proposal and Project Planning.
• Product Development Consulting on Idea and Innovation implementation.
• Conduct training for newly joined Adjuster and Claims Staff on Enhancements and Application features.
• Build, Deployment and Release management for application using Anthill Pro and Udeploy.
• Production tickets analysis and support using Servicenow and BMC Remedy.
• Web based FNOL Submission Application maintenance and Support
• Defect management using ALM- Quality Center.