SUMMARY

• Highly experienced business IT professional with 8+ 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.
• 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.
• 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.
• 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.
• Accomplished, motivated and versatile PLM consultant with 3 years of Functional and Technical experience in Business Process Development, Administration, SOA and ERP Integration, Support and Maintenance, Data Migration, Up gradation and Implementation of Oracle Agile PLM
• Prepared documents to conduct 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 RoseDocumentation 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.
• Documented Release Enhancements Notes.
• Analyzed and reengineered mission critical processes.
• 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
• Handling administration for Agile PLM FAQMS.
• 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-through's to analyze SQL code efficiency.
• Designed mock ups of UI layout and created assets for use in multiple shipped titles.
• 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.
• Manage PLM and process engineering projects with leading technologies based on strategic goals.
• Developed Use Cases using UML based on the needs of Business Users.
• 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.
• Tuned many SQL statements as part of De-Bugging

Environment: SQL, Toad, UML, Agile/Scrum,MS Project, Pentaho BI Suite, 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.
• Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
• 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.
• Develop sound PLM solutions to address customer objectives.
• Used SQL and Toad and assisted in data cleansing. Helped optimize the data warehousing efforts by tuning the SQL queries.
• Serve as subject matter expert with respect to the annual benefit changes and rules associated with the Medicare Part D program.
• Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers
• Worked on client requests support for Oracle bugs, development and implementation of backup/recovery strategies, configuring replication environments, as well as database process automation.
• 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.
• Created Traceability Matrix to ensure that all the requirements are covered by the test cases using Mercury Quality Center.

Environment: HTML, DB2, Oracle, Windows, MS Visio, MS Project, QTP, Outlook,AID,Syfact,SAN

Confidential, Austin, Texas

Sr.Business System Analyst

Responsibilities:

• 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.
• 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.
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.
• AnalyzedBusiness requirementsandSystem specificationsthereby developedTest Strategies, Test Plans,Test CasesandTest Scriptsfor theFunctional, GUI, Integration, Security, Performance, Regression and Installation testing.
• Actively involved inwalkthroughsandmeetingswith Project Team to discuss related business and project issues..
• UsedMS Visioto create various Business models likeUse Cases, Activity Diagrams, andState Charts.

Environment: Rational Rose, Oracle 10g,Windows, 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.
• 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.
• 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.