SUMMARY

• Over 9 years of Experience in the field of Information Technology working as a Business Analyst / System Analyst in different domains such as Sales and Marketing, Maintenance and Support, Financial and Telecommunication.
• Extensive experience in Business Performance Management, Process Management, Business Process Reengineering, Statistical Analysis System and Enterprise Content Management.
• Expertise in identifying, developing and documenting Business and Functional Requirements Specifications (FRS), Software Requirement Specifications (SRS), organizing discussions, Software Development Life Cycle (SDLC) and requirement elicitation sessions.
• Adept with industry standard methodologies like Rational Unified Process (RUP),Object Oriented Analysis and Design (OOAD), agile development and Iterative method.
• Extensive experience in creating and executing Test plans and Test Scenarios.
• Worked with architects & developers using Teradata SQL Assistant executing SQL queries & stored procedures.
• Experience in Data Migration, Data Conversion, Data Extraction, Transformation and Loading (ETL) using SQL SERVER 2000 and PL\SQL Scripts.
• Extensive experience in interacting with business users to identify information needs and initiating process changes, gathering requirements and authoring Use Cases, Use Case diagrams, Sequence diagrams, Activity Diagrams based on UML methodology using tools like Rational Rose and MS Visio.
• Have full life cycle experience throughout data modeling, data migration strategy and software application architecture.
• Good understanding of SAS and other statistical software packages.
• Experience in conducting Joint Requirement Planning (JRP), Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Felicitated technical design sessions with DBAs, developers & QA Team. Experience in leading multidisciplinary teams along with hands on expertise in Process identification, Project Coordination, direct customer interaction and leadership responsibilities.
• Experience in creating and documenting both business and technical Metadata documents from Metadata Repositories.
• Extensive experience in creating UML diagrams and creating mockups and wireframes for web navigation screens.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts and documenting all phases of QA process with Hands - on experience in Manual and Automated testing using Win Runner, Load Runner and Test Director.
• Extensive experience in working with Mercury tools like Mercury ITG (IT governance center) and Mercury Quality Centre (Test Director). Also good understanding of Rational Suite including Requisite Pro, Rose, Clear Case, Clear Quest.
• Experience working in the SOA environment.
• Proficient using testing tools to design and develop test plans and test scripts for multi-platform Client Server and Web applications.
• Executed Test Cases manually and also using QTP, Selenium, logged the defects, and reported using JIRA, Test Rail and Quality Center.
• Diversified Experience in Smoke testing, Functional testing, Integration Testing, Black Box testing, GUI testing, System testing, Regression testing and User Acceptance testing.
• Good understanding of Data Warehouse, Tera Data and Data Mart Systems.
• Good understanding in SQL, T-SQL, PL/SQL, Mainframe and Web Development.

TECHNICAL SKILLS

Business Skills: Requirements Gathering, Gap Analysis and Impact analysis, Risk Analysis, Use Case Modeling & Analysis, Business Process Analysis, Research & Modeling, Data Modeling, Statistical Analysis System, Data Mapping, Reporting Analysis, Business Process Definition Requirements, Agile Methodology.

Operating Systems: Windows 95/2000/NT/XP, UNIX, Linux and MS-DOS

Web Technologies/ Applications/Languages: HTML,MS SharePoint, JavaScript, JSP, Web Services, Java, J2EE, XML, JDBC,CSS, C++, Liferay Portal, Quad, SQL

RDBMS: SQL, PL*SQL, MySQL, DBMS, MS Access, Relational data bases, Oracle

Application Servers: Apache Tomcat, BEA WebLogic server

Testing Tools: Test Director, Load runner, Win runner, QTP, Quality center, Lotus notes, Bugzilla, SVN, Maven, Robot framework

Scripting: XML, HTML, Java Scripting, PHP, Python

SAP: BW (Business Warehouse), SAP HR (Human Resources)

PROFESSIONAL EXPERIENCE

Confidential, NY

Business Systems Analyst

Responsibilities:

• Functioned as the bridge between functional business units and IT.
• Developed, implemented and documented software development and SQA processes.
• Engaged with stakeholders in project feasibility, kick-off meetings and stakeholder analysis
• Initiated discussions with the business stakeholders and Subject Matter Experts (SMEs) to understand and document business needs
• Assisted the Product Manager and Product Owner in getting the product features aligned with their Roadmap
• Configured and administered JIRA as the team's Agile management tool.
• Provided JIRA training to the software development team and business stakeholders.
• Developed the product backlog along with Product Owners
• Co-lead the Clients agile transformation.
• Participated in sprint planning, daily scrums, testing, retrospectives and sprint reviews.
• Facilitated "three amigos" work sessions between developers, product owners and business analysts
• Identified the client/organizational needs and provide suitable agile system based solutions
• Guided the development teams to break down large and complex user stories into simplified versions for execution
• Tested the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories
• Coordinated project initiatives with software developers, stakeholders, project managers and software testers
• Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.
• Participated in the development and grooming of Project Backlog Stories (Requirements) with business and technology partners.
• Assisted in entering and updating Issues (Epics, Stories, and Tasks) onto JIRA Agile application.
• Assisted in the development of Project Impact and Process Control Plan documents.
• Gathered requirements for business definition and facilitate JAD/JAR sessions with stakeholders to refine functional requirement
• Facilitated daily scrum, sprint planning and sprint retrospectives meeting
• Identified and remove obstacles that will keep the team from achieving their goals
• Support the product owner in maintaining the product backlog and scheduling next release
• Ensured effective implementation of agile process
• Communicated with clients and inform the organization about the customer business needs
• Implemented new Change Control process with executive team
• Assisted IT in the development and implementation of a new release and off-release process and scheduling with executive team signoff
• Orchestrate backlog grooming, creating epics and user stories
• Developed a set of Key Performance Indicators for measurement and analysis by gathering requirements and facilitating meetings between various teams in the department.
• Developed dashboards and reports to show the performance of the networks, and the variance in compliance to the Service Level Agreements.
• Developed detailed reports on agent vs. agentless monitoring to show the possibility of network being exposed to attacks in case of agentless monitoring.

Environment: Salesforce, MS SharePoint, HP Quality Center, MS Office, CRM, Windows, Web Services, MS Visio.

Confidential, Charlotte, NC

Sr. Business System Analyst

Responsibilities:

• Identified the Business needs, developed Scope Models as per the Business Vision and worked on identifying project scope and business value to mitigate scope creep and gaps.
• Conducted user interviews, gathered requirements, analyzed, and documented Business Requirements for different departments in LBS for understanding the business reporting functionality of the legacy system.
• Created the TO-BE state of the reports after analyzing the AS-IS documents for different departments and getting new requirements from the report SME’s and Business Application owners.
• Performed GAP analysis, analyzed the current state and future state of the system, worked on developing the current workflows and mapping the requirements
• Discussed status updates with the project manager in identifying the progress and meeting deadlines.
• Functioned as the primary liaison between the business users, developers and the data teams throughout the project cycle.
• Managed traceability to identify and maintain the relationships between business requirements, design specifications and test requirements.
• Created the functional design documents for individual reports which included the data selection criteria and prepared the Detail Design of the report.
• Worked on requirements verification and validation. Confirmed the quality and accuracy of the stated requirements, and ensured that all the requirements accurately reflect project scope and baseline these requirements in a finalized requirements package.
• Point of contact between the off-shore development teams, onsite Project Team and other related departments.
• Followed SDLC waterfall approach with its various workflows, artifacts and activities which allowed increased understanding of the problem through successive refinements and helped us grow an effective solution over multiple iterations.
• Extensive use of Rational Requisite Pro and Rational Clear Case.
• Researched/Analyzed the various steps in the current state analysis of the reports and then wrote the Business Requirement Document (BRD) and Functional Requirement Document (FSD) in such a way that the developers could create the reports.
• Developed content and training materials. Recommended enhancements and identified new business requirements.
• Worked with the data team to ensure data mapping and to identify data gaps.
• Reviewed Use Cases and translated the Use cases into Test cases.
• Provided management with daily statistics of the test creation, execution and discuss any blocking issue.
• Tracking defects with severity using Quality Center and involved in defect root cause analysis. Created weekly issue logs and provided documentation to discuss and share with the team for resolution to common problems and solutions.

Environment:IBM Ration Suite(Clear case explorer, Clear Quest and remote client), Tortoise SVN,XML Spy, JIRA, Beyond Compare, Contivo Mapping Tool, Tomcat Server, JIRA,, MS SharePoint, XSLT, Datapower.

Confidential

Business/ Systems Analysis

Responsibilities:

• Participated in activities related to consulting with end users (e.g., clients, internal customers, etc.) to determine the scope and objectives of proposed programs and enhancements in the application.
• Assisted with identifying requirements utilizing end user feedback; write test scenarios and cases for new and existing programs based on detailed design specifications and given requirements while adhering to established policies, procedures, and deadlines.
• Developed detailed Test Cases against the Use Cases, and the Functional and the Technical Specification documents.
• Wrote detailed test cases clearly and show the steps necessary to execute the tests, and the expected results associated with each step.
• Appropriately name and place step numbers for each step in the test case and provide accurate details for clear execution of the test cases.
• Prepared and gathered the test data necessary for the test execution in the QA environment.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Created training plans, prepare training materials and deliver training to internal and external users for new and existing tools and processes.
• Executed the written and approved test cases against the delivered applications into the test environment and enter the test results with Pass or Fail criteria.
• Communicated with the development team on any issues that arise from the execution.
• Created packages using SSIS from heterogeneous sources like Access Database, Flat Files, Excel and CSV, SQL Server database sources handling Outbound Member Files, Inbound Claims File and Inbound Provider Files.
• Designed the application to meet users requirement document and also developed a web based database application for emergency communication based on WebLogic, oracle.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Worked with the Business Objects developers to provide input for generating automated and ad-hoc Business reports.
• Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2005 environment and deploy the data.
• Experience in calling a Web Service, through SSIS Package through the transformation, and wherein you declare a variable with its URL link.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.
• Involved in using BI tools like Import and Export Wizard for developing the packages
• Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Worked with QA and Development staff to report, verify and close the defects and resolve any issues that arise during testing.
• Participated in defect triage, prioritization and review meetings on a daily basis.
• Ensured that the reported defects in Quality Center get fixed by the development team and get retested in the test environment.
• Updated & worked with the business team to recommend appropriate training, communication and scheduling as systems are deployed into development, test & production.
• Updated the status of the bugs by either closing or rejecting the bugs appropriately. Ensured that the defects are properly retested and marked in Quality Center with appropriate statuses and comments based on the Defect Management methodology document. Ensured speedy closure of the defects.
• Provided support to other divisional staff as they perform QA testing of enhancement and features by providing in-service QA support.
• Helped the User Acceptance Testing (UAT) team with the design of their test cases at the business level, and support the UAT team to meet their objectives.
• Worked with the Customer Support group and help in reproduction of the defects in QA, and the closure of the reported defects.
• Participated as a member of Software Development Life Cycle (SDLC) development teams from project initiation through implementation as assigned.
• Worked as a QA member of the Scrum team running in an agile methodology.
• Adhered to the overall QA processes and ensure that the processes are followed by all members of QA and the development. Be a QA champion and educate the staff with the methodology.
• Provided input to the technical writing staff by reviewing the documentation.
• Reviewed all Technical and Functional specification documents and give technical feedback to the Business Analysts to ensure that the documentation meets the QA testing objectives for more thorough testing.
• Created automation test scripts using HP Quick Test Pro for the regression testing purposes.
• Followed the automation methodology and ensure that all scripts are written clearly and enough comments have been placed in the code for other members of the team to understand the code.
• Consistently recognized for excellent problem-solving and analytical skills by programmers, project managers and supervisors
• Engaged with stakeholders during the project feasibility, kick-off meetings and stakeholder analysis
• Worked with the Product Manager and Product Owner in getting the product features aligned with their Roadmap
• Created the project plan that identified specific tasks to be executed and within the expected timeline
• Ensured the timelines are realistic and meet the project goals.
• Planned and coordinated efforts with both the On-Shore and Off-Shore development teams.
• Executed action plan items to ensure project goals are met
• Monitored the progress of the project and updated the Project Status weekly on SharePoint indicating dates, deliverables and risks
• Interacted with 3rd party vendors to describe project goals and to get their commitment to the timeline
• Ensured that the development team delivered the code by the targeted code drop dates
• Mature understanding of Quality Assurance Methodology STLC relative to SDLC.
• Experience in adopting the testing throughout the development process by employing the RUP stands and Agile Methodologies.
• Exposure in both manual and Automated Testing of Client/Server & Web-based applications with focus on Quality Assurance including Functional (GUI, Input domain testing etc.) Non - Functional (Performance Testing using Load runner, usability etc.) Regression, UAT etc.
• Experience in reviewing Test Procedures, defining Test cases according to IEEE 829 standards, reviewing and maintaining Test scripts, detecting and analyzing bugs and report those issues to developers
• Experience in using Test Management tools like QC, for tracking the bugs and stores the Test results. Thoroughly used QC for test management and bug tracking.
• Software functional Testing of UI and Web Applications. Knowledge in creating Test Procedures, Test plans, Test cases and reviewing them for quality assurance. Tracking defects and interacting with team members in fixing errors.