SUMMARY

• Highly experienced business IT professional with 7+ years of experience in commitment to excellence and implementation of the best practices enterprise wide.
• Extensive experience in roles such as Senior Business Analyst with excellent knowledge to the full Software Development Life Cycle (SDLC) methodologies, frame works and processes.
• More than 7 years of experience working as a Business Analyst on multiple domains like Finance, Mortgage and healthcare industries.
• Expertise in Software Development Life Cycle (SDLC), Object Oriented Analysis and Design and Agile Methodology.
• Experienced in all areas of project life cycle in a highly structured change management environment using both proprietary methodologies, Agile Techniques and RUP (Rational Unified Process).
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Organized JAD sessions to flush out requirements.
• Good understanding of Project Process and ability to analyze business problems and identify solutions.
• Worked extensively with the team to meet business requirement, create prototypes and analyze workflow.
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications.
• Responsible for writing the flow of event document for each integration point between Ariba and JDE systems. That includes Description, Preconditions, Primary and Alternate flow of events, Post - Conditions using Rational Rose
• Extensive experience inDimensional Data Modelingusing Star/Snowflake schema, Fact and Dimensions tables, and Physical & Logical data modeling.
• Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.
• Well versed in Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices.
• Well-versed in direct and remote analysis with strong critical thinking communication, information security and people skills.
• Good Experience in Ariba EProcurement
• Over 5 years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse.
• Prepared documents to conduct user Acceptance testing.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Skilled in performing Gap analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Exposure to Change Request Management tools like Clear Quest.
• Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.
• Effective in executing multiple tasks and assignments ahead of schedule. Reputation for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations.
• Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

TECHNICAL SKILLS

Business modeling: Microsoft Visio, IBM Rational Rose.

Documentation: Microsoft Word, Rational Requisite Pro

Front end tools: Microsoft front page, Microsoft Project, Microsoft Office, .Net, Java, J2EE

Version Tools: Clear Case/ Clear Quest, Clarity

Defect Tracking: Mercury Quality Center

Testing: Mercury Quick Test Pro, Win Runner

Reporting tools: Microstrategy,Crystal Reports

Languages: SQLAcess, PL / SQL, VB Script, Java Script, C, C++, HTML,VHDL

Databases: Oracle 8.x/ 9i/10g, MS Access, MS SQL Server, DB2

Operating Systems: Windows NT/2000/95/98/XP, UNIX, Linux(SSL,VPN)

ERP: SAP, Oracle

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Business /Data Analyst

Responsibilities:

• Gathered and analyzed the requirements and converted them into User Requirement Specifications and Functional Requirement Specifications for the designers and developers to understand them as per their perspective.
• Performed GAP analysis of AS IS and TO BE systems and modeled them for better understanding of the business process.
• Gathered and analyzed the business requirements for each release to prepare the System Requirement Specifications.
• Involved in preparing the mockup screens
• Work with Test team about the product behavior descriptions contained in the SRS to derive Test plans, cases and procedures.
• Documented Release Enhancements Notes.
• Analyzed and reengineered mission critical processes.
• Documented requirements and translates into appropriate system requirement specifications.
• Provided Business analyst support to a project, including producing Business case analysis and documentation, detailed requirements definition.
• Provide all necessary logical and physical data modeling DDL (SQL Data Definition Language) code to data architecture and database administration teams as required to develop and support the financial reporting system data repository
• Involved in Performance monitoring and tuning.
• Successfully used Agile/Scrum method for gathering requirements and facilitated user stories workshop. Also documented user stories and facilitated story point discussions to analyze the level of effort on project specifications
• Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.
• Monitored databases and make adjustments to improve performance of database or applications that use the data.
• Developed and maintained compliance to database standards and procedures. Assist with design and organization of database during systems development process
• Worked with the technical development team to deliver a system to meet the Business needs.
• Performed requirements analysis, Business process development, applying detailed problem solving skills.
• Participated and contributed in daily scrums, Sprint meeting and Sprint review meetings.
• Involved in SDLC of application developed using AGILE methodology
• Facilitated Joint Application Development (JAD) sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.
• Conducted meetings with users and other stakeholders to elicit, organize and document the requirements.
• Developed Use Cases using UML based on the needs of Business Users.
• Used MS Office suite (Word, Excel, Access, Visio, Power Point, Outlook, and Project) for project tracking, documentation, and presentation.
• Collected and documented business processes as well as business rules. Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Verified the functional aspect as per the Business Process and validated the interfaces with the other systems and data conversion from the legacy system.
• Conducted meetings with ETL team in order to provide source-to-source staging data requirements/ definitions/ for mapping purposes.
• Enhanced the Test Cases by analyzing the Specification Documents.
• Tuned many SQL statements as part of De-Bugging
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases using Mercury Quality Center.

Environment: SQL, Toad, UML, Agile/Scrum, MS Project, MS Visio,J2ee, Sharepoint, HTML, Mercury Quality Center.

Confidential, Bentonville, AR

Sr.Business Analyst

Responsibilities:

• Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the business and IT processes.
• Collected and documented business processes as well as business rules. Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Reengineered and implemented new processes
• Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
• Formed a bridge between the Project Manager and different technical teams with effective presentations as well as verbal and written communication.
• Met with all developers and project stakeholders to lead a kickoff meeting. Defined and introduced the project, team members' roles, and key deliverables. Mapped out timelines, milestones, communication processes, question and answer session.
• Generated excitement and buy-in to secure commitment to project objectives, and shared a group vision to start the team on a motivated track.
• Created the Enterprise Information Group encompassing Business Intelligence Center of Excellence, Data Governance Working Group, Enterprise Data Warehousing and Master Data Management. Provided strategic vision and direction with operational and business leaders for enterprise information initiatives enabling Executives to make information-based decisions.
• Used SQL and Toad and assisted in data cleansing. Helped optimize the data warehousing efforts by tuning the SQL queries
• Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers
• Worked on customer service requests for SQL and database tuning, software patches and upgrades, as well as database migration and duplication.
• Involved in migrations to upgrade Oracle 9i database to Oracle 10g and hardware and software testing.
• Worked on client requests support for Oracle bugs, development and implementation of backup/recovery strategies, configuring replication environments, as well as database process automation.
• Analyzed Computer System Validation documents including User Requirements (URS) and functional Specifications (FS) for DOORS, IAS, MiniTab.
• Involved in Customizing the Test Cases and Test Plan according to the requirements of the project.
• Assisting QA testers and analysts with the report generation feature and mentoring them in interpreting the test result graphical charts
• Facilitated business requirements gathering sessions with the client, and developed Use Cases/Activity Diagrams as well as Functional Specifications using UML/Visio.
• Enhanced the Test Cases by analyzing the Specification Documents.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases using Mercury Quality Center.

Environment: HTML,DB2,Oracle,Windows,MSVisio,MSProject,QTP,Outlook,AID,Syfact,SAN

Confidential, Austin, Texas

Sr.Business System Analyst

Responsibilities:

• Met with Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models
• Worked on End to End process for supported ERP.
• Tested BHC implementations on Ariba e-procurement.
• Gathered the requirements of Global B2B application has a basic automated process that works with Ariba eProcurement systems.
• Gathered requirements for customizing Ariba Integration Events and Schema tables for data pulls and push’s for different Ariba Partition.
• Instrumental in developing and implementing Business Continuity and Disaster Recovery (BCP & DRP) Plans for corporate sites throughout Texas, Ohio and California.
• Created company policies and procedures governing corporate security, email and Internet usage, access control, and incident response.
• Hand selected employees from Information Technology department to build Risk Assessment Team charged with analyzing all critical systems, developing reports to document system vulnerabilities, and recommending appropriate solutions.
• Tailored SDLC process to support in corporation of requirements management and design tools CaliberRM and Together Architect
• Worked on customer attributes and properties information related to Buyer Hosted Catalogues.
• Assisted the Project Manager in creating and updating theRisk Assessment Planidentifying the Risks to the Project due to dependencies of the Project on internal Blocks and external Vendors / Entities etc. Also provided Mitigation plans for the Risks and Issues identified.
• Gathered Business Requirements and wrote Business Requirements Document (BRD) by working with the client IT staff, project managers.
• Work with Test team about the product behavior descriptions contained in the SRS to derive Test plans, cases and procedures.
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.
• Created use cases, activity diagrams and state diagrams using Rational Rose.
• AnalyzedBusiness requirementsandSystem specificationsthereby developedTest Strategies, Test Plans,Test CasesandTest Scriptsfor theFunctional, GUI, Integration, Security, Performance, Regression and Installation testing.
• PerformedSystem Testingto ensure that the compiled software components of the Applications adhere toProject Standards, Performance Criteria and Functional specifications.
• Actively involved inwalkthroughsandmeetingswith Project Team to discuss related business and project issues..
• UsedMS Visioto create various Business models likeUse Cases, Activity Diagrams, andState Charts.
• Functioned effortlessly and efficiently, as a liaison between the development, testing, and management group. Actively participated in Joint Meetings with the various teams involved in the development process.
• Served as the primary liaison between the business and information technology teams.

Environment: Rational Rose, Oracle 10g,Windows, Microstrategy, MS Visio, MS Project, Test Director, Win Runner, and Load Runner, Ariba.

Confidential

Jr. Business Analyst

Responsibilities:

• Creating user requirements document by interacting with end users and developers
• Prepared Use case models based on Business Requirements documentation gathered through interactions with users.
• Worked throughout the Software Development Life Cycle (SDLC), which included requirements, specifications, design, analysis and testing.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Involved in development and implementation of comprehensive database using Data Modeling, Process Modeling, Use cases and Test cases.
• Strong domain knowledge on Mortgage (Point of Sale and Loan Origination system), Banking (Treasury - Check Processing system), Retail (Point of sale)
• Expertise in designing and maintaining Test Strategy, Test Plan, Traceability and Testability matrix, Test Scripts and Test Data.
• Interact with business users like Loan Officers, Mortgage Consultants, Sales, Vendors and Business to analyze and test the business requirements.

Environment: MS Project, Visual Basic, EDW, MS SQL Server and Microsoft Windows.