SUMMARY:

• IT professional with 10 years of industry experience.
• Experience in full Software Development Lifecycle (SDLC) from association with end - users for requirements determination, defining the system scope, system analysis, Business Case Development to Rollout, Production, testing, maintenance and documentation.
• Proficiency in transforming business requirements into functional specifications, focusing on business process workflow analysis and design, business process, user-interface design and process flow modeling.
• Lead and organized requirements gathering sessions and JAD sessions with Subject Matter Experts as needed in order to document decisions regarding process improvement and future state of business processes.
• Excellent technical documentation skills in preparing Business Requirements Document (BRD), Use Case Document, Functional Requirement Document (FRD), Software Requirements Specification (SRS), Workflows.
• Thorough knowledge of Object Oriented Analysis and Design using UML, RUP, Waterfall, Agile- SCRUM, RAD methodology and rational tools.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity diagrams), and Class Diagrams based on UML methodology using Rational Rose.
• Extensive knowledge of Business Process Management (BPM), Requisite Pro, DOORS and MS Visio.
• Expertise in project scope, analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, system testing, implementation and production support.
• Extensive ETL experience in data warehouse and BI applications integration using Informatica (Power Center/Power Mart/IDQ and Business Objects.
• Knowledgeable in physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with RDBMS and other relational databases such as Microsoft SQL Server (T-SQL), Oracle (PL/SQL), DB2 (UDB), and MS Access.
• Experience in SQL programming, comprehensive knowledge of Core Java JSP, XML and Web Services..
• Excellent organizational and interpersonal skills with a strong facility for acquiring new knowledge very rapidly, problem-solver skilled at analyzing business needs.
• Excellent communication skills (written and verbal), ability to proactively build relationships with other team members and interact with Business Units and all levels of Management within the organization.
• Experience in conducting GAP Analysis, User Acceptance Testing (UAT), SWOT Analysis, Cost Benefit Analysis and ROI analysis.
• Experience in developing project plans using MS Project and MS Share Point, identifying documents, and validating requirements and reengineering process.
• Experienced in creating test scenarios analysis with the testing team, creating macros in excel and reporting defect management and test status matrices.
• Experience working with business users as well as senior management.

TECHNICAL SKILLS:

SDLC Methodologies: Agile, RUP, Waterfall, Rapid Application Development (RAD), V-Model

Requirement Management: MS Visio 2010, MS Office, Rational Requisite Pro, Rational Rose, IBM DOORS

Project Management: MS Project 2010, MS Office 2010, Lotus Notes, MS Outlook

Presentation: MS Office/Excel/PowerPoint 2010

Database: Sybase, MS SQL, SQL, SQL Server, Oracle, Data Studio, MS Access, DB2

Change Management: Rational Clear Quest

Version Control: Rational Clear Case, MS SharePoint 2010 (MOSS 2010)

Operating System: Window XP, Window 7

Data Modeling Analysis: Rational Rose, MS Visio, ERwin Studio

Databases: SQL, PL/SQL

Bug tracking and reporting: HP Quality Center, Rational Clear Quest, JIRA

Tools: TOAD, SQL Developer, SharePoint, Rapid SQL, PC SAS, MS Query, Cucumber.

WORK EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Involved in gathering the requirements for the application, responsible for writing Functional Requirement Specifications (FRS), publishing the requirements in DOORS upon business to sign-off on the BRD.
• Responsible for defining the scope and implementing business rules of the project, gathering business requirements functional analysis, and SRS documentation.
• Performed gap analysis ensuring business SOX compliance.
• Created and distributed project deliverables - project estimates, test strategy, project plan, test artifacts, and status reports to the project management team.
• Hosted daily defect meetings with all stakeholders, updated them on problem status and ensured speedy resolutions.
• Assigned tasks among development and QA teams, monitored and tracked progress of project following Agile methodology.
• Coordinated QA and development activities in designing test scenarios and test scripts involving testing of web services (SOAP and REST) and XML using SOA tools - Soap UI for the local WSDL/with URL to test application's complete business flow.
• Coordinated and analyzed database performance working closely with Performance testing team.
• Involved in SIT test execution and support to create complex queries for database testing of various types of database such as DB2, MSSQL, Oracle and Sybase using various query tools mentioned above in Environment and tools section.
• Support UAT team and walkthrough test artifacts (test strategy, test plan and summary reports, test cases and various query patterns) for their testing.
• Used advanced Excel functions to create macros, generate spreadsheets and pivot tables for reporting.

Environment: IBM Doors, OO Modeling, SQL, Sybase, SoapUI, REST, HTML, SQL Server, Oracle, DB2, MS Access, MS Query, PC SAS, Rapid SQL, UAT, UML, HP ALM, MS Visio, PowerPoint, MS-Project, SharePoint, MS Office, Windows 7.

QA Analyst

Responsibilities:

• Collated business requirements, translating them into functional specifications.
• Identified possible improvements to financial and operational efficiency and created Powerpoint presentations to convey the same to the stakeholders.
• Provided input to the development of formal business cases.
• Established and maintained communication channels with senior managers, key team members and stakeholders.
• Documented Business Requirements Document, Functional Requirements Specification and to define the scope and objectives.
• Developed project plans and ensuring plan adherence.
• Used analytical tools, reports and Key Performance Indicators to monitor operational performance.
• Worked closely with stakeholders to determine the priority of specific requirements based on their value to the business.
• Worked with QA team to prepare test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Performed data quality analysis using advanced SQL skills.
• Extensive SQL querying on Staging, Datawarehouse and DataMarts. Developed estimates for business analysis tasks.

Environment: IBM DOORS 9.5, SQL, UAT, MS Visio, Datawarehouse, SQL Server 2014 Management Studio, Microsoft Office, MS Excel/Access and PowerPoint, SharePoint, Windows 7.

QA Analyst

Responsibilities:

• Analyzed Business Requirements and created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams according to UML methodology thus defining the Data Process Models.
• Created use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.
• Used SQL for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
• Worked with diverse teams to get the current workflow for detailed business process.
• Conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clarity on the requirements of the project.
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.

Environment: Visio, MS-Excel, MS Access, SQL, OO Modeling, UML, SharePoint, MS Office/PowerPoint.

Sr. Business Analyst

Responsibilities:

• Responsible for requirements gathering and analysis for each sprint by the study of client applications and clarifications through sprint review meetings.
• Worked on documenting the ETL framework that included load pattern for staging using ETL tool, file archival process, data purging process, batch execution process.
• Wrote SQL scripts to validate data transformation and cleansing rules, test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update. Validated Data Quality transforms using IDQ.
• Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations using IDQ.
• Built marketing model to track month-to-date performance and cost, make recommendation for adjustment, beat the monthly loan issuance goal for both borrower and investor.
• Responsible for creating mapping documents for requested data fields from Third Party Systems to the Business Intelligence data structures (databases, tables, stored procedures, DTS packages) to support the collection, tracking and reporting of business data.
• Worked with the QA team to keep a traceability of the defects in the application.
• Planned for the tasks targeted for the next sprint with the business, developers and all other stakeholders.

Environment: Agile, Requisite Pro, Rational Rose, Agile, Informatica Power Center/IDQ, SQL, PL/SQL, SQL, UAT, MS Office, MS Visio, UML, SQL Server 2014, Visio, SharePoint, MS-Excel, MS-Access, HP ALM .

Business Analyst

Responsibilities:

• Gathered requirements during the Requirements phase of the project.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
• Designed and implemented basic SQL queries for QA Testing and Report/Data Validation.
• Worked closely with the QA Team Lead in Creation, Preparation, and Implementation of quality assurance reviews and the development and execution of test plans.
• Implemented basic SQL queries for QA Testing and Report / Data Validation.
• Acted as User Acceptance Testing coordinator, and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Utilized corporation developed Agile methodology to perform required job functions and process improvement.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Conducted change management assessments and statistical analyses that improved the efficiency and effectiveness of the commission calculator performance.
• Prepared, analyzed and distributed monthly revenue report, quarterly historical performance report for finance SEC regulation.
• Involved in the full corporate compliance with regard to regulatory requirements lifecycle from GAP analysis, mapping, implementation, and testing for processing of Application workflow, associated risks and solutions.

Environment: Rational Unified Process (RUP), UML, SQL, Rational Test Manager, Rational Clear Quest, UAT, Windows, MS Office, HTML, Windows.

Systems Analyst

Responsibilities:

• Created the functional requirements specification from the business requirements.
• Understanding/gathered b usiness concepts /requirements from business owner and translating them into detailed business requirement via Use Case Diagram and Data Flow Diagram in MS Visio.
• Prepared BRD (Business Requirement Documents) and other supporting documents such as user manuals, Release Notes containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Assisted with User Acceptance Testing with prospective users. Developed and maintained Standard Operating Procedures (SOP).

Environment: MS Visio 2007, MS PowerPoint, MS Office, MS Project 2007, MS Outlook, SDLC, OO analysis, UML.

Business Analyst

Responsibilities:

• Gathered business requirements and turned them into technical requirements.
• Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Created Business Procedure Documentation to depict business process flow.
• Responsible for creating and maintaining the Requirements Traceability Matrix (RTM).
• Involved with the Architect, Stakeholders, and developers to discuss and finalize the Test scenarios.
• Wrote SQL queries to retrieve relevant data using SQL from various databases.
• Analyzing and understanding different data sources to be utilized that meet the requirements.
• Provided support to the Project Managers in effective and efficient reporting of project status especially before key milestone deliverables.
• Responsible for analyzing source system data & data elements and data mapping documents.

Environment: Microsoft Visio, JIRA, SQL, Microsoft Office, Microsoft Excel, HTML.

Business Analyst

Responsibilities:

• Gathered and reviewed requirements from the End Users to understand the application and determined user/business/functional requirements and user stories for web solutions.
• Interfaced with Subject Matter Experts to document business processes and systems features/function.
• Worked extensively with the client in solving their business problems through innovative solutions well within the defined deadlines and exceeded client’s expectations.
• Worked with the technical team in planning, developing and executing comprehensive System Integration Testing phase of the projects and was successful in uncovering critical defects before the projects/solution went into UAT.
• Scheduled and attended internal team meetings with developers and data team to talk about defects.
• Trained user on how to operate the application and go through with the Functionality of the application.

Environment: Rational Rose, Microsoft Office, Microsoft Excel, HTML, Java, XML.