SUMMARY:

• More TEMPthan 8 years of strong experience in business analysis and data analysis.
• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and subject matter experts (SME’s) for servicer and borrower data.
• Develop and manage RTM and track requirements status throughout all phases of teh SDLC.
• Organized Joint Application Development (JAD) sessions as a facilitator and moderator to gather requirements.
• Experience in writing Use cases and Functional Requirement Document
• Responsible for translating BRD into functional specifications and test scenario.
• Created process flows and swim - lanes for user re-direction, address cleansing and data flows using MS Visio.
• Involved in preparing Software Requirement Specifications (SRS) and User Interface Design.
• Investigated and resolved production issues with business regarding UAT and SIT.
• Expert in writing SQL queries.
• Used UML to create use case diagrams, sequence diagrams and activity diagrams.
• Wrote Procedure Manuals and was responsible for continuity preparedness.
• Involved in training and mentoring new staff and worked as technical lead in some projects.
• Designed and developed complex business rules and processes in to decision models and BPM.
• Interfaces with clients to define and document requirements for a named set of custom developed or vendor software products.
• Created documentation including requirements, user stories, acceptance criteria, feature description PowerPoint decks, user guides, process flows, wireframes, and newsletters.
• Conducted research, prepare reports, and analyze economic data to develop and shape business strategies.
• Development of Test Strategy Plan, Project plan, Test Plans and Test Cases based on requirement gathering and analysis, business rules and other operating conditions.
• Responsible for conducting Design Thinking sessions to gain insights into end user and customer needs, Manages teh Product Backlog for a Product, working with teh Engagement Manager to prioritize requirements, define and manage scope and sprints for a project.
• Involved in Ad hoc reports and economic impact assessment, quantitative and qualitative analytics using Rapid SQL, SAS and MS Access.
• Extensive noledge in MS Office (Access, Excel, Visio, and PowerPoint) and using SharePoint.
• Investigated and validated production issues with business regarding UAT and SIT.
• Experience in Software Development Life Cycle (Planning, designing, testing, implementing and maintaining) and agile methodology.
• Conducted product deployment, gap analysis and user acceptance testing.

TECHNICAL SKILLS

Databases: MS SQL, MS Access, Oracle

Languages: SQL, Visual Basic

Methodologies: SDLC, Agile, Scrum, UML, Waterfall

Testing Tools: HP Quality Center

Operating Systems: Windows 95/98/2000/XP/7/NT

Project Management: MS Office Suite (Microsoft Word, Microsoft PowerPoint, Microsoft Excel), MS Project

Change Management: Rational Clear Quest

Business Intelligence Tools: Cognos10/8.2/8.3/8.4/10, Reportnet1.1, Framework Manager, Query Studio, Report Studio, Analysis Studio.

Databases: Oracle 8/9i/10g/11g, MS SQL Server 7/2000/2005/2008, MySQL

Data Modeling: Visio 2003-2010, Erwin, WebSphere.

ETL Tools: Datastage, Informatica, SQL Server Integration Services.

Reporting Tools: SSRS, Crystal Reports, IBM Cognos, Microstrategy reports.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Business Analyst

Responsibilities

• Created, designed, and formatted technical specification documentation including architecture diagrams, process flows, and other information or processes needed to describe required system changes for development, QA, and other internal customers.
• Organized Joint Application Development (JAD) sessions as a facilitator and moderator to gather requirements.
• Develop and manage RTM and track requirements status throughout all phases of teh SDLC.
• Create and coordinated teh creation of technical documents and high level solution designs
• Verify and assist in development designs ensuring requirements has been met.
• Coordinated recurring meetings and touch-points with teh client team and third-party integration teams
• Developed test cases and test plans on teh basis of requirements and also did manual testing of teh functionality of teh application to ensure dat teh application is able to handle alot of data.
• Create process flows and swim-lanes for user re-direction, address cleansing and data flows using MS Visio.
• Involved in preparing Software Requirement Specifications (SRS) and User Interface Design.
• Used UML to create use case diagrams, sequence diagrams and activity diagrams.
• Performed Backend testing by using PL/SQL queries to test teh integrity of teh application.
• Provided support to applications in production by tracking problems and troubleshooting them to sustain application in production.
• Authored and monitored progress reports on a weekly basis.
• Created workflows and managed SharePoint site for team and published articles and updates for team.
• Conducted interviews with clients to analyze their data and gather requirements.
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements has been covered in scripts and tested properly.
• Completed SOX training for better manage risk and identified and suggested new set of controls for ensuring quality and compliance.
• Maintained Traceability Matrix throughout teh project.
• Researched and evaluated different project issues and provided robust and efficient solutions.
• Involved in MS office project to comply with Confidential policy and reduce security vulnerability
• Incident management and inventory management using service ticketing software
• Writing new procedures, creating Documents and updating them using MS Office 2010.
• Creating reports, metrics and modifying queries using SQL and formatting them in MS Access 2010.

Confidential, McLean, VA

Business Analyst

Responsibilities

• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and subject matter experts (SME’s) for servicer and borrower data.
• Prepared teh Functional Specification Document (FSD) and Software Requirement Specifications (SRS). Conducted teh JAD Sessions with stakeholders and developers to has a clear picture of a project.
• Responsible for conducting Design Thinking sessions to gain insights into end user and customer needs, Manages teh Product Backlog for a Product, working with teh Engagement Manager to prioritize requirements, define and manage scope and sprints for a project.
• Created RTM (Requirements traceability matrix) mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Designed and modified complex business rules, concepts and assisted in decision modeling through modifying existing rule family tables.
• Developed test cases and test plans on teh basis of requirements and also did manual testing of teh functionality of teh application to ensure dat teh application is able to handle alot of data.
• Contributed to teh process improvements and development of support models for teh support team dat included developing Support Tickets within Plainview and utilization of Changes, Risks, and Issues.
• Provided business analysis expertise in logical extraction and development of detailed functional and technical design specifications, use cases, and prototypes for teh configuration of Plainview.
• Investigate and validate production issues with business, involve in UAT testing with Business using MS access and SQL Server.
• Developed, designed, reviewed, and executed SQL queriesbased on business requirement
• Involved in designing and developing EUC solutions for front-end application.
• Designed charts, diagrams and BPMN using MS Visio for formulating business rules.
• Worked on Automating Reconciliation Reports from services and Investors using SQL Server and SAS.
• Wrote SQL scripts for creating performance evaluation reports.
• Closely worked with teh project managers, developers, DBA’s and QA resources
• Involved in documenting teh procedures as per Confidential compliance.
• Designed and created Reports using Access 2007 and Excel 2007

Confidential, NYC

Business System Analyst

Responsibilities

• Created and modified business rules and formulated complex business rules into decision models and BPM
• Involved in requirement Analysis (Study) and understanding application. prepared Issue tracker and setting clarification meeting with Business User /SME’s
• Took teh lead to assist Data Warehouse specialist by extracting data elements, data definitions and data related information from Data Warehouse to meet aggressive timelines and mitigated risk of project delay
• Worked closely with different teams in organization for ongoing project issues and kept track of updates and raised to higher level if necessary.
• Conducted product deployment, gap analysis and user acceptance testing.
• Involved in testing data for different products using MS office products
• Used Rapid SQL and SAS for data analysis and reporting.
• Worked on defective analysis for improving quality and product.
• Involved in Planning and implementing business rules.
• Worked on data warehousing using Datastage and Informatica ETL tools.

Confidential, NJ

Consultant

Responsibilities

• Articulatedand documentedbusiness and system requirements with version control to assist in change control
• Elicited requirements from cross functional teams and multiple third party vendors and worked closely with teh architect to understand teh metadata (XML file extracts) for data extraction
• Prepared Business Workflow models dat cover "How" business processes are accomplished.
• Facilitated meetings dat included functional business and technical areas
• Responsibly captured and distributed meeting minutes to internal team and to external vendors
• Worked as a team with ETL Developers and Process Analysts in preparing teh requirements, and writing work flows, business process maps.
• Created Test Plan, Project Plan, Test Strategy, Test Cases, Test procedures, Test Matrix and Defect Strategy detailing scope, resource assignments and schedules.
• Responsible for translating BRD into functional specifications and test scenario. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Designed and developed charts, diagrams and BPMN process charts using MS Visio.
• Extensively used SQL for Data validations in teh backend.
• Provided reports and performed defect analysis using SAS, SQL Server and MS Access.
• Responsible for coordination for production issues during UAT and SIT.
• Direct Interaction with client for Defect reporting, functionality and other project related issues.

Confidential, KY

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements to halp create Business Requirement Documentation, using MS Word and MS Visio
• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and subject matter experts
• Performed Use-Case analysis using UML. Worked on teh Flowchart and process diagram along with sequence diagram using Microsoft Visio.
• Involved in teh planning, user acceptance testing (UAT), and implementation of system developments and enhancements.
• Successfully conducted JAD sessions, which halped synchronize teh different stakeholders on their objectives and halped teh developers to has a clear-cut picture of teh project.
• Checked Business Readiness and determined activities of flow.
• Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Wrote Procedure Manuals and was responsible for continuity preparedness.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Helped in writing Training manuals and halped business with teh Training on a one to one sessions.
• Managed changing requirements which included establishing a baseline, keeping track of teh history, determining dependencies dat are important to trace, tracing relationship between related requirements and maintaining version control.
• Worked with multiple project teams of technical professionals through all phases of teh SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere andCognos.
• Prepared and documented System Requirements and workflows for teh Content Management Application tool. Responsible for applying object oriented analysis and design (OOAD) principals to create domain models using UML.
• Reviewed teh data model and reporting requirements forCognos reports with teh Data warehouse/ETL and Reporting team.
• Involved in creating advanced SQL queries for preparing reports and analysis.