SUMMARY

• 8+ years of Industry experience as a Business/Systems/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Mapping and Data Modeling.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Skilled in Requirement Gathering, Gap Analysis, UAT, Training & Support (L1 &L2) with Client Interactions.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Experience in the ETL (Extract, Transform and Load) of data into a data ware house/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehouse Data Modeling and Design.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Programming Languages: C,C++,Java, SQL, PLSQ

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases: MS - Access, MySQL, SQL Server, Oracle, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo,.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Identified the business needs and performed fit gap analysis.
• Developed budget planning report & timelines of the project by conducting walk-through sessions and meetings involving various leads from Development, QA and Technical Support teams.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Developed UML diagrams like Activity/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams using MS Visio thus defining the Business Process Model.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Worked on data modeling and produced data mapping and data definition documentation.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Involved in analyzing existing system logic and operation, gap analysis and developing recommendations for procedures to solve end user problems.
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis using iRise tools.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase..
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Participated in Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements and solution to the existing application problem from business perspectives.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.

Confidential, Columbus, OH

Business Analyst/Data Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Coordinated activities with project manager and various other teams using MS Project.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• 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.
• Involved in generation and execution of SQL queries.

Business Analyst

Confidential, Chicago IL

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted interviews with key business users to collect requirement and business process information.
• Conducted JAD and Business Process Modeling sessions, bringing together project stakeholders from across the enterprise.
• Conducted subsequent physical audits to insure compliance and maintenance of high service standards to independent agents
• Eliciting client requirements and preparing various RFP, FRD, and SRS documents
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Bugs that would enhance the usability of the application were logged using Rational ClearQuest.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Involved in preparing a simple and detailed User manual for the application, for an intended user.