Professional Summary

• 8 years of experience as a Business Analyst on Web Based Application, and Data Warehousing projects in Financial and Insurance Industries.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle SDLC such as Rational Unified Process RUP , Agile methodologies such as Agile XP and Agile Scrum, and Waterfall.
• Highly experienced in Data Warehousing, Business Intelligence Reporting, Designing Cubes and Dimensional Models Fact tables and Dimensional Tables .
• Experience working in Financial Markets, business requirements, and project management.
• Strong proven expertise on UML diagrams Use case diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams .
• Organized 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 BA tools including Microsoft SharePoint, and Microsoft Office Professional.
• Expertise in using Data Modeling Tools for creating Logical Physical Data Models star schema and snowflakes schema using ERWIN .
• Experienced with Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System.
• Technical expertise in BI, DW, Data profiling, Data Cleansing, Data Integrity, reference Data, Data Security and Data Quality Management.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• 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.
• Highly analytical and process-oriented with excellent interpersonal communication and presentation skills.

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
• Databases - MS Access, Oracle 11g/10g/9i, SQL Server 2008/2005, DB2
• Programming Languages SQL, C/C ,PLSQL
• Microsoft Office Suite- MS Word, MS Excel, PowerPoint, MS Visio, MS SharePoint, MS Office
• Reporting tools - Business Objects, Crystal Reports,Micro Strategy
• Defect Tracking Tools Quality Center, Clear-Quest
• Version Control-Requisite-Pro and Clear-Case
• ETL Tools- Informatica 9.1/8.x, DataStage 8
• Database Design Modeling- Dimension Modeling Star and Snowflake , Relational Modeling, Erwin

Professional Experience

Confidential

Data warehouse/Business Analyst

Responsibilities:

Conducted JAD sessions with the Business SMEs to understand/ analyze/ documentbusiness needs. 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 Conducted in depth analysis to classify elements into business Entities / Dimensions. Used dimensional modeling skills to classify business elements into Dimensions and Facts. Used KPI matrix Key Performance Indicators to determine the business usage patterns of Facts against Dimensions. Created BDMs Business Dimensional Models using MS Visio and conducted BDM review sessions with the business. Constructively worked with project manager and other development leads in creating LOEs and Project Timelines. Helped project management in creating WBS Work Breakdown Structures. Worked closely with DBAs in creating physical models and creations of DDLs. Extensively used SQL to access source data and analyze it. Wrote Functional requirement specifications documented using DOORS. Conducted requirement review sessions with the project team to present requirements. Created and maintained requirements traceability matrix RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan. Closely worked with the testing team in development of comprehensive test cases and test scenarios. Helped developers and testers in resolving any issues found during the development life cycle. Provide weekly updates to project management in the form of issue impact analyses and progress reports. Environment:DB2, Micro Strategy 9, Quality Centre 10, Doors, Informatica power center, Rational Clear Quest, MS Share Point, MS Project, SQL, PL/SQL, Rapid SQL, Windows XP, MS Visio, ERWIN

Confidential

Data Warehouse/ Business Analyst

Responsibilities:

With the input from business SMEs Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Diagrams and Class Diagram. Created Use Case scenarios and maintained Use Cases business use cases and system use cases and modeled use case diagrams using MS Visio for the application. Elicited business requirements through interviews, surveys, prototyping and observations in the requirement definition phase. Worked with Team Lead, Developers, Business Analysts, Project Managers, etc. to achieve project goals timely and effectively Prepared interview questionnairesfor the users and gathered requirements to write specifications and to shape software development process. Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus. Reviewed Test Strategy and Test Plans to ensure that they reflect and include all functional, Performance, Usability and Security requirements. Created BDMs Business Dimensional Models using MS Visio and conducted BDM review sessions with the business. Facilitated JAD sessions with management, SME Subject Matter Experts , vendors, users and other stakeholders for open and pending issues to develop specifications. Identified and documented issues, risks, gaps and their impact to the project life cycle. Provided recommendations and alternatives. Elicited demands from the stakeholders and analyzed them for consistency, flexibility and completeness in all phases of the software development life cycle SDLC using agile methodology. Conducted JAD sessions with Subject Matter Experts SMEs to obtain domain level information Extensively used SQL Queries to mine data from warehouse and present mock reports for business validation. Environment: DB2, Micro Strategy 9, Quality Centre 10,Informatica power center Workflow Designer, Manager, Monitor ,Doors, Rational Clear Quest, MS Share Point, MS Project, SQL, PL/SQL, Rapid SQL, Windows XP, MS Visio, ERWIN

Confidential

Business Analyst/Data Analyst

Responsibilities:

• 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, brainstorming sessions and meetings with stakeholders.
• 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 update BA related activities on the schedules and collaborate on the project
• 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 resources.
• Performed analysis on transactional database and data validation using TOAD DB2 for getting historical data for some of the elements.
• 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, Oracle, SQL, Micro Strategy

Confidential

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, Data Warehousing
• 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.
• 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:Quality Center, SQL server, SQL, Oracle, SSIS, SSRS, MS Visio, Rational Clear Quest, Rational Clear Case, Rational requisite pro, JAD, Windows XP