SUMMARY

• 7+ years of top flight experience as a Business Analyst in Financial industry with expertise in Retail Banking, Credit Card Processing, Online Banking and Other Financial Services.
• Performed Requirement Gathering and Analysis for Business, Functional and Technical requirements.
• Documentation in the form of Artifacts and Specs. Creation of industry standard documents such as BRDs, FSDs, User Stories and Use Case specs.
• Proficient in Business Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Business Process Reengineering, mining, Automatic and manual testing
• Conducting and facilitating JAD Sessions that involved both the functional side and technical team for further decision - making.
• Solid understanding of SDLC methodologies like Waterfall method, AgileScrum and Rapid Application Development (RAD)
• Experience in analyzing and creating Narrative Use Cases, Use Case Diagrams, Activity Diagrams, and Class diagrams Data/Flow/Navigational flow diagrams using UML Tools such as MS Visio.
• Excellent Communication, Presentation and Interpersonal skills, Self-starter, Team player with Project Management and Leadership skills.
• Well versed in project management tools likeMS Project for status reporting and planning.
• In depth knowledge of creating BRD, FRD, Use Cases, Activity, Logical diagrams, Sequencediagrams and Class diagram to extract Business Process Workflow, thereby helping the development team and quality assurance teams in understanding the requirements
• Experience in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing different methodologies.
• Excellent application of Business Process Mapping and Modeling. Process modeling and diagrams include UML i.e. Use Case diagrams, Activity diagrams and BPMN in the form of process flows comprehensively capturing the AS-IS model and TO-BE model.
• Business Situation analysis and best practices using GAP analysis, Cost-Benefit analysis and SWOT technique.
• Assistance and collaboration with senior managers on Planning and setting project goals. Participant in conflict resolution during team meetings. Played a key role in Communication between the different teams and resources to better integrate the processes.
• Teammate par excellence while executing individual duties in a timely and optimal manner. Aptitude to quickly grasp new technologies and systems.
• Creating and maintaining source to target Data Mapping documents.
• Cognizant of Data Analysis by Data miningtechniques.
• Extensive experience in working with Relational Database Management Systems like SQL Server and Microsoft Access
• Experience with Data analysis and SQL querying with database integrations for large organizations.
• Strong knowledge of SQL Query, stored procedures, data analysis and data validation using SQL.
• Experience in dealing with different data sources ranging from MS Access and Excel
• Developed Test cases to validate application. Capable of preparing Test Plan and Test Scenario.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss functional & non-functional requirements, test plan, resource utilization, and defect tracking strategies.
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS).
• Experience in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Requirements Traceability Matrix (RTM) to verify and validate documented requirements.
• Proficient with User Acceptance testing (UAT) to check the various functionalities of the system.

TECHNICAL SKILLS

Process/Modeling Tool: Software Development Life Cycle (SDLC), MS Visio, SSIS, Reporting tools, Crystal Reports, ERP Package Oracle E-Business Suite.

Software Modeling: Flowcharts, Wire Frames, Business Process Flow

Methodology: UML, RUP, Business Modeling and Data Modeling, Water-fall, Agile (Adapted) - SCRUM

Databases: MS Access, SQL serverLanguages SQL, XML and HTML, Mainframe, .NET, Visual Basic

Operating Systems: MS-DOS, WINDOWS 98/2000/NT/XP/2003 SERVER, VISTA

Office Tools: MS Office 2007/2005/2003/2000 , Word, Excel, PowerPoint, Access

PROFESSIONAL EXPERIENCE

Confidential, OKLAHOMA CITY, OK

BUSINESS ANALYST

Responsibilities:

• Worked with Project manager to identify best approach for gathering requirements
• Performed Reviews and Audits for various processes
• Involved in business process reengineering, including gathering and documenting requirements, documenting workflows and developing functional specifications for the programmers
• Scheduled and facilitated weekly status report meeting for the Project Team and for key Stakeholders.
• Gathered BusinessRequirements Document (BRD), created FunctionalRequirementsDocument (FRD) and analyzed data/workflows, defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs. Prepared user guidelines for easy access of the application.
• Conducted Data Analysis to find missing data fields in the application and customize them and extensively used Rational Requisite Pro.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Worked on design and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization using My SQL Server/ Oracle.
• Extensively used Agile Methodology in the process of the project management based on SDLC.
• Used MS Word & Visio to document data flow of the AS IS process and TO BEprocess.
• Conducted JAD sessions to get SME’s input on how to implement the application for Group Disability Claims.
• Gathered Business requirements for Integration points and mapped them with Functional requirements. Extensively used MS Excel during the course of the project.
• Worked as an Interface between the users and the different teams involved in the application development for betterunderstanding of the business and IT processes.
• Designed and implementedSQLqueries for QA testing and report / data validation
• Analyzed Business Requirements from BlackBox testing perspective; reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Assisted Data Quality Analysts to ensure data quality breaks and operational data issues are identified and resolved. Retrieved Data using SQL queries and did Data Mapping and Data analysis.
• Created sample Wire frames to make system better understood by Business and technology teams.
• Performed GAP analysis to identify the gap between the optimized allocation and integration of the inputs, and the current level of allocation.
• Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show end-to-end business model and businessprocess mapping exercise including swim lanes.
• Performed Data Analysis and Data validation by writing basic queries against the database.
• Identified Test Harnesses, which assisted QA effortin reducing the redundancy of Automation Scripts and made them more reusable.
• Experience in the documentation of system and business requirements and specifications, design and development of use and test-case scenarios and root-cause analysis, GAP analysis, developing test plans, test scripts using SQL, conducting System Integration testing (SIT), user acceptance testing (UAT), training, and implementing new processes and technology.

Confidential, CHARLOTTE, NC

BUSINESS ANALYST

Responsibilities:

• Create business requirements documentation (BRD), UML use cases, gap analysis, process models, mockups, test scenarios, concept diagrams and business activity diagrams.
• Performed tasks within the requirements life cycle - gather high-level requirements via interviews and JAD sessions and filter those requirements into functional and non-functional specifications.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Created and updated Project Track Plan Slides via MS PowerPoint, MS Project, MS Excel, and MS Visio.
• Facilitated collection of requirements from system users and preparation of business requirement documents using Rational RequisitePro that provided appropriate scope of work for technical team to develop prototype and overall system.
• Utilized agile software development methodology to manage and control software and product development.
• Used agile methodology to Conduct Data Analysis to find missing data fields in the application and customize them and extensively used Rational Requisite Pro.
• Daily involvement with the agile software development life cycle, documenting and working through systems issues as part of a business analysis team.
• Created Data Stage jobs to extract transform and load data into various sources like relational databases, application systems, temp tables, flat files etc.
• Used SQL queries to gather information to conduct Data Analysis on the client profile data to find missing data fields in the database and customize them.
• Facilitated JAD sessions by formulating and defining systems scope and objectives through research and fact-finding combined with understanding of business systems, business requirements, and industry requirements.
• Documented current and future business processes, process flows, data flows, and created class, sequence, and activity diagrams.
• Assisted project team in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture & Database Modeling.
• Developed and presented mockups for end users.
• Reviewed test strategy and test plans to ensure that test cases reflect user needs for the functional, user interface, performance, usability and security requirements.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensure that critical requirements are not missed.
• Coordinated work plan between the Project Team and business representatives using MS Project; scheduled and tracked progress for team members of project throughout completion.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).

Confidential, PITTSBURG, KS

BUSINESS ANALYST

Responsibilities:

• Created and reviewed business requirements, functional specifications, project schedules, documentations and test plans.
• Prepared financial statements, including Balance Sheet, Cash Flow and P&L statements and prepared detailed variance explanations verses budget and current estimate to relate to Project Manager.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted interviews with key business users to collect requirement and business process information.
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive requirement analysis including data analysis and GAP analysis.
• Partnered with the technical areas in the research and resolution of system and process problems.
• Designed and developed project document templates based on SDLC methodology.
• Used Advanced SQL queries for data validation in Relational DBMS.
• Performed extensive Cost benefit analysis, Requirement Analysis including data analysis and gap analysis. Designed and developed project document templates based on Agile Methodology (Extreme Programming)SDLC methodology.
• Reviewed, Created and Maintained data mapping documents.
• Reviewed and Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
• Developed business requirement specification documents as well as high-level project plan.
• Comprehensively worked with requirement gathering using RequisitePro and Visio.
• Designed and developed all Use Cases and UML models using Rational Rose and Visio.
• Developed requirement reports for day-to-day retail banking needs for opening account, online banking by using Rational SoDA and Visio.
• Implemented basic SQL queries for QA testing and data validation using SQL Server.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.

Confidential, NEW YORK CITY, NY

BUSINESS ANALYST

Responsibilities:

• Worked with the business community to define business requirements and analyze the possible technical solutions.
• Worked extensively with SMEs in understanding and documenting their requirements.
• Co-authored business requirements document (BRD) with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Involved in creating Software Requirement Specifications (SRS)/Functional Specification Documents (FSD).
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Involved in all SDLC /Agile Process and following Client Process to support the Project.
• Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and mock-ups using UML Methodology
• Facilitated and managed meeting sessions with committee of SMEs from various business areas.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using RequisitePro.
• Performed Data Analysis of existing data through SQL and MS Access.
• Worked to createData MappingDocuments and worked with business to write transformation rules through SQL.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured appropriate documentation is in place.
• Helped the testing team documenting the system requirements and testing system development. Designed and implemented basicSQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT)
• Developed timelines for project, managed timelines and resources to successful completion.