SUMMARY

• 8 Years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Data Mapping, Translating Requirements into Specifications and Application Design.
• Strong skills in needs determination and client account development.
• Familiar with structured design and coding in batch and real time environments.
• Over six years of programming proficiency - application development expertise using Crystal Reports, Crystal Enterprise, Business Objects, Info view, WEBI, DESKI, Experienced working with Oracle, MS Access, SQL Server databases.
• Adept in performing Gap Analysis, Feasibility Analysis, and SWOT Analysis to check the compatibility of the existing system infrastructure with newbusinessrequirements. .
• Proficient in coordinating User Acceptance Testing with the Business Customers
• Proven analytical, methodical and resourceful approach to Problem Solving, Root-cause Analysis, Conflict Resolution, and Negotiation Strategies to meet the business requirements.
• Proficient in gathering and analyzing user requirements, creatingBusinessRequirement Documents (BRD), Functional Specifications Documents (FSD), Prototyping, UML Diagrams using various tools including MS Visio, Rational Rose.
• Very good understanding in coordinating Joint Application Development (JAD) sessions.
• Extensively worked with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient in Microsoft Word, Power Point and Access.
• Responsible for understanding business requirements, analysis, proof of concept, configuration of Workday HCM product and creating documentation as needed.
• Participated in Project Assessment, Functional Analysis, Business Process Modeling, and Requirements Gathering; and convertedBusinessRequirements into Functional Specifications using UML Techniques.
• Extensive experience in creating and executing test plans for functional tests, QA tests, regression tests, smoke tests and UAT using Test Link.
• Structured Interviews to converge towards a product design, which is acceptable to Business Customers and feasible for Developers.
• Experience in at least in 4 Workday areas such as Absence management, Time tracking, Compensation, Talent management, Performance, Benefits, Reports, calculated fields, Workday Studio integration & Dashboard creation.
• Cooperate with cross-functional teams within the organization including marketing, advertising, merchandising, and visual planning.
• Proven experience in improving resource efficiency, shortening project span, and reducing project cost performing Variance Analysis simultaneously through system modeling methodologies Agile, Rational Unified Process (RUP), Rapid Application Development (RAD) and Waterfall.
• Strong organization skills with the ability to work on multiple projects/assignment simultaneously.
• Strong interpersonal and communication skills with the ability to express technical and business concepts.

TECHNICAL SKILLS

Operating Systems: MS-DOS, WINDOWS 95/98/NT 4.0/2000/XP

Internet/Web Tools: ASP.Net 3.5/2.0/1.1 /ASP 3.0/ 2.0, WCF,COM/DCOM, JSP, JAVASCRIPT, Jquery, Xquery, Microsoft InfoPath, XML, HTML, DHTML, CSS, VBSCRIPT, SOAP, WSDL, FTP, WCF, WPF, Dreamweaver

Programming Languages: PL/SQL, MS/SQL, T-SQL

Databases/ RDBMS: SQL SERVER 2005/2000/7.0 , SQL Server Express, ORACLE 10g/9i/8i/, SYBASE, DB2 UDB, Microsoft Access, My SQL

Other Packages: Erwin, Front page98, TOAD.

Source Control Tools: Visual Source Safe

Reporting Tools: SAP BO XI, Oracle XML Publisher, SQL Server Reporting Services

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Sr Business Analyst

Responsibilities:

• Act as a liaison between the business units, QA and the technology teams. Lead JAD sessions and act as the lead facilitator for various projects from start to finish through the SDLC.
• Participate in Code Reviews, System Testing and UAT followed by production verification, post production testing and support.
• Wrote SQL scripts to validate/test data from source system to Operational Data Store (ODS) to Data warehouse.
• Reported bug to BI team while testing/validating data warehouse.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Researched client and internal data integrity issues using SQL database queries, Business Objects reporting, and other forms of data analysis.
• Used Team Foundation Server (TFS) for tasking and monitoring the progress of the task assigned.
• Proactively participated and involved in requirement gathering process and transformed Business requirement into the Functional Specifications documents (FSD).
• Designed and reviewed the various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Presided over new store planning process which involved advertising; collaboration with merchants and visual merchandising; strategies for pre-open and post-open sales; and inventory analysis.
• Co-ordinate the workflow among team members and managed project deliverables like Business Requirement Document (BRD), Functional Specification Document (FSD) and progress through regular meeting with internal stakeholders.
• Researched client and internal data integrity issues using SQL database queries, Business Objects reporting, and other forms of analysis.
• Analyzed point of sale and inventory data in order to make recommendations to our clients on distribution channel management strategies and techniques
• Logged and tracked issues using HP Quality Center and submitted customer requests for enhancement
• Served as a liaison between client and the Development and Technical Teams
• Tested systems and/or system changes accurately to insure system efficiency, integrity, productivity, and maintainability. Worked on QA efforts related to new releases. Created and executed test scripts using HP Quality Center
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Involved in all major cycles and phases of the project from scope definition, risk analysis to user acceptance testing and monitoring the release of the product.
• Worked with the clients on final signing process in the User Acceptance Testing (UAT) stages.
• Provided guidance and recommendations on process improvements and "best practices.”

Environment: MS Office Suite, SAP BO, SharePoint, Siebel, MS Visio, SQL, Docu Sign, Oracle, SHP, Sql Server, MS Project, oracle

Confidential, Baltimore, MD

Business Systems Analyst

Responsibilities:

• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders and offered recommendations on appropriate solution.
• Conducted user interviews and documented business and functional requirements.
• Worked with a Team that consisted of representatives from ITS, Provider Data Quality, Account Management, and the Health Plans.
• Communicated and interacted on a regular basis with the team lead, project manager, business owners, and development teams during different stages of the project life cycle.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Successfully was able to Gather Requirements and present the requirement documentation for Signoff.
• Documented change requests and provided the reasons and root cause of the changes.
• Analyzed the data behind the requirements and translated the requirements to development.
• Tested data according to the requirements in the BRD by using SQL queries and Front End of Facets.
• Developed a Test Plan and created Test scripts to validate the Test Cases.
• Provided technical and procedural support for User Acceptance Testing (UAT).
• Assisted in providing production support for SQL server or SSIS technical issues
• Uses SQL Developer to query backend transactions of researched transactions and update the system with corrected information that the system or users neglected to update
• Utilizes Rational ClearCase to collaborate on reviewing software test plans and test scripts. Develops test procedures and test cases based on test plans, software design documentation, other available information, and past testing experience. Review the results of test execution, compare output to expected results, and document discrepancies in incident reports
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Developed test plans, test scripts and test scenarios for Unit, Integration, Regression and System Testing
• Involved in writing Gap Analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions
• Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
• Created and maintained relationships between business objectives, requirements, solution and deliverables by creating and managing requirement traceability.
• Responsible for gathering and documenting the Business Requirements Document ( BRD)
• Conducted the GAP, risk analysis and presented the issues and concerns at the JAD sessions to all the stakeholders. Documented the proceedings of the JAD session.
• Utilized the Requirements Traceability Matrix to ensure that all teams are using the correct and appropriate requirements, and sub-requirements for satisfaction of customer needs.
• Prepared and consolidated all mock-ups/UI design, logical and business flow modeling, and requirements gathering activities in an agile work flow environment.
• Authored high and low level use cases use case diagrams, activity diagrams, sequence diagrams, data flow diagrams to define system interactivity and specify functional requirements based on UML methodologies, using Rational Rose and MS Visio.
• Conducted meetings/working sessions to focus on analyzing and obtaining requirements from all target user groups, SME’s.
• Organized, keyed and maintained project plan and milestones into MS Project to prioritize the multiple tasks and create dependencies for go-live.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio, MS-Project), Rational Requisite Pro, SWOT analysis, XML, SQL,.

Confidential, TX

Business System Analyst

Responsibilities:

• Worked closely with the FC’s to understand AG Edward’s investment banking products and brokerage options as a part of the project.
• Worked with the mainframe team, FC’s, stakeholders and management team in gathering various requirements for the project.
• Gathered and documents the requirements using Rational Requisite Pro.
• Discussed these requirements with other members of the team like the DBA, Project Manager, Application developers and the FC’s.
• Worked on the various phases of SDLC.
• Performed project management activities such as task scheduling, resource allocation and developing charts.
• Designed detailed logical class diagrams, activity diagrams and other high level process flows.
• Facilitated JAD (Joint Application Development) sessions with the management team, stakeholders, FC’s and mainframe team.
• Performed high level security data risk analysis, GAP Analysis among different applications, incorporated these gaps into models and documents.
• Co-Authored in making the Use-cases and the functional requirements document.
• Worked with the mainframe team, caliper application developer and other members of the project team to develop a test base, plan and then create test cases, test scripts and documented them using Test manager.
• Worked with application developers to create a test strategy to implement various phases of testing like Unit testing, volume testing and Integration testing.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Facilitated UAT (User Acceptance Testing) with the stakeholders, management team, FC’s and Mainframe team,
• Responsible for the overall growth of the project from requirement gathering to testing.
• Worked with the UNIX server team to gather the requirements for the project and documented them in the Requisite Pro software.
• Worked with the Caliper Application Developer and the end users to develop a test base.

Environment: MS Visio, MS Word, MS Excel, Test Manager, Java, Windows NT/2000, F-Secure Client, MS SQL Server.

Confidential, Miami, FL

Business Analyst

Responsibilities:

• Documenting Technical/Functional Requirement Document for design team to design the application based on the requirements.
• Analyzed Business Requirement Documents (BRD) and created corresponding User Stories, and Functional Specifications.
• Conducted project review meetings.
• Designed and developed Use Cases and UML diagram.
• Conducted user interviews, elicited requirements and analyzed the requirements in an agile environment.
• Working closely with various stakeholders to gather Business Requirements through Meetings, Discussions, and JAD Sessions.
• Initiating Requirement Document Review Meetings and conducting Gap Analysis if any, on the basis of requirements given at the initial stage of the project.
• Created Work Flow Diagrams using MS Visio.
• Created Mock-ups for better visualization and understanding of the software solution for the stakeholders, developers, and testers.
• Working as a liaison between the stakeholders, various SMEs, the developers, and testers.
• Maintaining and updating SharePoint with approved documents after getting them reviewed by the stakeholders.
• Participation in SCRUM, stands up, and Sprint planning meetings.
• Worked actively with the QA (Quality Assurance) team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).
• Analyzed test results and reported necessary corrective actions to the development team. Aided in regression analysis.
• Monitored Defect Tracking system to prioritize defects and devise a plan for future enhancements.
• Generated detailed readiness assessment for migration to cloud-based services such as Office 365 for enterprises using MAP Toolkit
• Interviewed various subject matter experts, asked the right questions to uncover all necessary information, including their needs, strategies and their goals.
• Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model.

ENVIRONMENT: Agile methodology, MS Visio, MS Project, MS Office, UML Diagrams and Flow Charts.