SUMMARY

• 7+ years of experience as Business Analyst in various domains of Finance, Banking, Insurance and Entertainment sectors. Excellent Communication skills, Team Participation skills, Leadership qualities, Analytical skills & Problem Solving skills
• Excellent knowledge of industry standard methodology Software Development Life Cycle (SDLC) such as Rational Unified Process (RUP), Agile methodologies such as Agile XP and Agile Scrum, and Waterfall
• Design and review of 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)
• Experienced working on Data Warehousing assignments, Business Intelligence Reporting, and understanding Fact and Dimensional Tables
• Strong proven expertise on UML diagrams (Use case diagrams, Activity Diagrams etc.) using MS Visio
• Facilitated and coordinated various project meetings such as JAD sessions, user meetings, walkthrough sessions, and Change Request Analysis
• Proficient at creating Use Cases, GAP Analysis, Process Flows & Works using UML
• Extensive Process reengineering by documenting and evaluating existing business processes
• Proficient in using PM/BA tools including Microsoft Project Professional, Microsoft SharePoint, and Microsoft Office Professional
• Expertise in creating Dimension Models such as star schema and snowflakes schema using ERWIN
• Expertise in using Data Modeling Tools for creating Logical & Physical Data Models
• Proficient in working with various Data quality processes such as Data mapping, Data validation, Data mining etc.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Expertise in application development with full lifecycle implementation of large Data Warehouse including project Scope, Requirements gathering, Star Schema design, Snowflake Schema, Data modeling and ODS
• Experience in writing SQL queries and store procedures in SQL and PL/SQL
• Experience in end - to-end ETL process including Data Extraction, Transformation and Loading from source systems
• Hands on experience in performing User Acceptance Testing (UAT) and have extensively prepared Test plans, Test scenarios, and Test Cases
• Expertise in conduction regression & feature testing on Windows, iPad& iPhone.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/XP, Unix

Software Methodologies: SDLC, SCRUM, Agile, Waterfall Model, Rational Unified Process (RUP), Rapid Application Development (RAD), Object Oriented Design & Analysis, ER Modeling and Database Design

Databases: MS Access, Automated Enrollment, Oracle (SQL), SQL Server, Oracle 10g, DB2, IBM AIX

Programming Languages: HTML, Java, C/C++,PLSQL

Microsoft Office Suite: MS Project, MS Word, MS Excel, PowerPoint, MS Visio, MS SharePoint, MS Office

Reporting tools: Business Objects, Crystal Reports, OBIEE, SSRS, Cognos

ETL Tools: Informatica, SSIS, Adeptia

Business Modeling Tools: Rational Rose, Clear-Quest, Requisite-Pro and Clear-Case

Testing Tools: Serena Team Track, PVCS Tracker, HP Quality Center, IBM Clear Quest, iPhone SDK simulator

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Business Analyst

Responsibilities:

• Worked with Team Lead, Developers, Business Analysts, Project Managers, etc. to achieve project goals timely and effectively
• Prepared User Stories for various business scenarios to meet the acceptance criteria
• Ensured that User Stories were of the highest quality which delivered the business value
• Guided the development teams to break down large and complex user story into simplified versions for execution
• Created acceptance criteria using BDD based on requirements, wireframes and design documents
• Acted as a point of contact for Development Team for requirements clarifications
• Assisted the development team with demos to the Product Owner and ensured that any changes requested in the demos were implemented
• Tracked new and changed requirements throughout the project.
• Coordinated Sprints, from Iteration Planning thru daily scrum, and Iteration Reviews and Retrospectives
• Also conducted functional testing on different WebBrowsers and platforms like iPhone, and iPad and provided feedback to the development team
• Rigorously performed Smoke Test&Regression Testing
• Recommended and structured tests home pages, category, landing pages for iPhone apps
• Created UI mockups and wireframes with the creating team for iPhone apps using OmniGraffle
• Conducted feature testing for iPad on Safari, and logged visual and functional defects using JIRA
• Involved in maintaining the content of the website using MSExcel
• Conducted Feature testing for iPhone app using iPhone SDK simulator
• Outlined content structure that covers body text, headings, body text, linking between pages

Environment: jBehave, Selenium,Agile Scrum, JIRA, WIKI, MS Visio, Microsoft Excel, Notepad ++, Microsoft Word and Microsoft Project, OmniGraffle, iPhone SDK simulator, FireFox3.6, Firefox 8, Safari, Google Chrome, Quality Centre, Internet Explorer 8, iPad version iOS 5, iPhone

Confidential Dallas, TX

Business Analyst/Data Analyst

Responsibilities:

• Implemented Agile model with complete line of traceability for all the artifacts of development projects
• Collaborated with Fixed Income Sales and Trading Group, Analysts and Portfolio Managers, Performance Measurement, Marketing and Client Reporting Teams
• Involved in requirement gathering, which included interviews, brainstorms and meetings with stakeholders and Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Extensively involved in all the waves to make sure documented functional requirements are met
• Used Microsoft Project to manage schedules, deadlines, resources and collaborate on the project
• Lead multiple project teams of technical professionals throughout all the sprints using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos
• Prepared the list of functions, and mapped on to the users by creating users groups and authorizations
• Identified the organizations, and categorize them in to types of organizations, attach them to parent organizations and setting the statuses
• Defined organizations, grouping the users based on the designations, functions of the users based on the organization charts
• Defined the resources and their types, defined the rules for allocating and provisioning
• Defined the group entitlements and assigned these entitlements to groups, organizations, users or user groups
• Defined the processes for approvals, approval rules and standard template e-mail messages for active such as allocation of the resource, e-mail for password expiry etc
• Defined password policies and tasks and scheduling the tasks schedules
• Gathered information of Adapter factories for various resource
• Performed analysis on transactional database and data validation using TOAD(DB2) for getting historical data for some of the elements
• Designed the separate universe using SAP Business Objects XI for data mart
• Defined the new universe which was created by identifying dimensions and measures
• Identified the roll-up or aggregation rules, granularity or hierarchy rules in data mart for all the data elements
• Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.

Environment: Windows XP/ Vista, MS Office Suite, SharePoint, HP Quality Center, Clear Case, IBM Lotus, MS Project, MS-Visio, ERWIN, TOAD(DB2), SAP Business Objects XI

Confidential New York, NY

Sr. Data Analyst/ Business Analyst

Responsibilities:

• Gathered and translated Business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Resolved the revolving issues by conducting and participating in JAD sessions with the Business and developers.
• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Analyzed the reverse engineered (Enterprise Originations EO) physical data model to understand the relationships between already existing tables. Cleansed unwanted tables and columns as part of Data Analysis responsibilities.
• Designed and implemented basic SQL queries for testing and report/data validation
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Responsible for understanding design and structure of different databases. Also involved in writing ad-hoc queries for data mining using different data mining tools.
• Created DMR (Data mapping Repository) documents using the Metadata extracted from the Metadata repositories.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Was responsible for indexing of the tables in that data warehouse.
• Worked with different groups through all phases of the SDLC using technologies including SQL server, Erwin, SSIS, SSRS, Data Stage
• Created job schedules to automate the ETL process.
• Worked on data modeling and produced data mapping and data definition documentation
• Collaborated with Business teams in the creation of the Functional Design document and Source to Target Mapping document.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Involved in creating star schema using Kimball’s methodology.
• Involved in building and maintaining Data marts, Fact Tables, Dimensions and joined them to extract meaningful data.
• Collected the information about different Entities and attributes.
• Used Forward Engineering technique to create tables.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing
• Helped in creating end user manuals and procedure manuals

Environment: Java, J2EE, HTML, WebLogic, Mainframe, AS/400, Quality Center, Windows 2000 Advanced Server, SQL server, Oracle, SSIS, SSRS, MS Visio, RUP, Rational Rose 2002,, Rational Clear Quest, Rational ClearCase, Rational requisite pro, JAD, rational test manager, Rational Robot

Confidential New York, NY

Data Analyst/Business Analyst

Responsibilities:

• Interacted with clients to finalize the Business Requirements for the application.
• Closely interacted with designers and software developers to understand application functionality, navigational flow and updated them about end-user sentiments
• Performed feasibility and adaptability study to identify the business critical areas from User perspective
• Developed detailed ERDs and DFDs using modeling tools following the SDLC structure
• Performed Risk Analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Defined system requirements to Use Case, Use case scenario and Use Case narrative using the UML Methodologies
• Produced the visual models for the application using Rational Rose to create Use Cases, State Charts, Sequence Diagrams, and Activity Diagrams
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders
• Authored progress and completion reports, which were then submitted to project management on a weekly basis
• Verified the hyperlinks that connect files inside the portfolio or those leading to pages outside of web.

Environment: Windows Server 2003, Rational Rose, Rational Requisite Pro and UML, Rational Clear Quest, HTML, Microsoft Visio, Test Director, Calipso

Confidential New York, NY

Business Analyst

Responsibilities:

• Involved in designing business requirement collection approach based on the Project scope and SDLC Methodology
• Coordinated and prioritized outstanding risks and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
• Worked on Quality Center to capture, trace and manage requirements during the projects lifecycle
• Conducted JAD sessions with Project’s Stakeholders identifying problems and coming up with best alternative to resolve that. Created targeted Questionnaires for SME’s to gather requirements
• Implemented UML methodologies to design Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, and Sequence Diagrams
• Created Use-Cases and Business Use-Case Model after accessing the status, scope of the project and understanding the business processes
• Interviewed Subject Matter Expert’s to recorded requirements that could be reviewed and understood by management and all other stakeholders
• Managed all the requirements in MS Word templates, making requirements available to all team members.
• Performed Feasibility Analysis and Risk Analysis on vendor/third party tools.
• Conducted walkthroughs with the development team and QA Team and other relevant stakeholders to review Testing Strategies and Test Plans ensuring that the test cases reflect the user needs
• Helped prepare test plan for the system. Developed and implemented test cases on the GUI interfaces to ensure that requirements were met

Environment: Windows 98/ 2000, MS Office Suite, MS Visio, Requisite Pro, Agile Methodology

Confidential

Jr. Business Analyst

Responsibilities:

• Involved in developing the business model for expediting the claim settlement process
• Defined frameworks for the application development and analyzed the areas of improvement
• Interacted with the software development team and claim settlement experts to liaison the business requirement to ensure that the application under development confines to the business requirement
• Integral part of all stages of Software Development Life Cycle, based on RUP framework.
• Assisted the senior business analyst in defining the scope, and business rules of the project
• Involved in analyzing of functional specifications, technical specifications, data mapping document and conceptual diagrams
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked with SQL queries using SQL Server for data manipulations
• Facilitated business requirement meetings with internalbusiness analystgroup, the IT team as well as the business users
• Gathered information needed for business reporting requests and establish the business requirements needed to properly extract data
• Conducted workflow and GAPanalysis to derive requirements for existing systems enhancements
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS)
• Understand and articulate business requirements from user interviews, and workshops and then convert requirements into technical specifications
• Involved in maintaining and managing different versions of documents using Rational Clear Case

Environment: Windows NT/2000, Sun Solaris, Web Logic, Oracle, Forms 6i, SQL Plus 8.0, PL/SQL, Pro*C, Java, JSP, Servlets, JDBC, Designer 2000, SQL Impact, Rational and Mercury Suite of testing Tools