SUMMARY

• 7+ years of IT experience as a Business Analyst in all the disciplines of the Product Development Life Cycle (PDLC): requirement gathering, analysis, testing and implementation.
• Good Experience in Business Analysis and Business Modeling methodologies and Iterative Software Development Life Cycle (SDLC) using Agile, waterfall and Rational Unified Process (RUP).
• Proficient in creating UML Diagrams including Use Cases Diagrams, Activity Diagrams, using Enterprise Architect and MS Visio.
• Strong experience in soliciting client requirements through interviews, workshops, and existing systems documentation and procedures.
• Proficient with tools like Requisite Pro, Enterprise Architect, MS Visio and MS Office.
• Expert in tracking, tracing and managing requirements using Requisite Pro.
• Hands on experience in writing functional specifications based on user requirements. Strong skills in user research and analysis of the existing systems. Proficient in understanding business/customer needs and technology.
• Outstanding knowledge in defining Test cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT).
• Ability to interact with individuals at all levels with exceptional skills in forming and facilitating Joint Application Development (JAD)
• Good understanding of Reverse and forward Engineering, Logical and Physical model.
• Excellent in Data modeling for ODS and DW using Erwin data modeling tool.
• 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 Enrichment, Data Integrity, Reference Data, Data Security and Data Quality Management
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Deep understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining
• Strong skills in Data warehouse design using Star Schema roll out for the fact and dimension tables.
• 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
• Extensive knowledge in design of logical and physical data modeling using Erwin tool
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Ability to interact with customers, self - motivated with good communication skills and capable of handling multiple tasks. Quick Learner, Excellent Team Player with good interpersonal skills.
• Able to master new concepts and applications within a timeframe and Capable of rising up to mounting challenges.

TECHNICAL SKILLS

Requirements Management: Rational Requisite Pro, Enterprise Architect, HP Quality Center

UML Diagrams: MS Visio, Rational Rose, Enterprise Architect

Wireframes & Screen Design: MS Visio, Axure

Test Cases: HP Quality Center

Defect Tracking: HP Quality Center, Rational Clear Quest, TRAC

Enterprise Apps: MS Office 2003/2007, MS Project, MS Visio

Software Methodology: Agile, Waterfall, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

Business Analyst

Responsibilities:

• Interacted extensively with various business groups, stakeholders and users to develop the Vision Document that is aligned with corporate strategic objectives
• Documented the “AS-IS” Business Workflows adhering to UML standards
• Conducted JAD sessions to define requirements and finalize the Functional Requirement Document (FRD)
• Organized meeting minutes from JAD sessions and obtained sign-offs from JAD participants
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, functional and non-functional requirements
• Identified use cases from the functional requirements, wrote use case specifications and created “TO-BE Business Process Workflow” diagrams (activity diagrams) in MS Visio
• Designed User Interface-level wireframes detailing interaction models and user experience using Axure.
• Conducted requirement workshops to verify and validate business requirements
• Created use case diagrams using MS Visio to show interaction between the actors and the use cases as well as to demonstrate the relationship between the use cases
• Used Data warehousing for Data Profiling to examine the data available in an existing database
• 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, Data Stage, Data Warehousing
• Created job schedules to automate the ETL process.
• Worked on data modeling and produced data mapping and data definition documentation
• Maintained a Traceability Matrix to ensure that all functional requirements are addressed at the use case level as well as the test case level
• Performed functional and GUI testing to ensure that the user acceptance criteria are met
• Co-coordinated the User Acceptance Testing (UAT) on a daily basis with the SME’s to make sure that all the business requirements are addressed in the application
• Coordinated project scheduling and status reporting with the project manager

Environment: Java, J2EE, Visual Basic, MS Excel, Microsoft Visio, HP Quality Center,Axure,Erwin,SQL

Confidential, Cranston,RI

Sr.Business Analyst

Responsibilities:

• Participated in meetings to understand the in scope systems for various cycles based on different regions
• Interacted with data modeling team to understand the logical and physical data model
• Designed workflows in MS Visio of the data demand in order to define end-to- end process
• Created training document for IBM-BDW for the off shore team in INDIA.
• Documented meeting minutes of weekly status call, coordinate PMO issue calls, maintain issue log and escalate the issues to respective SME’s
• Responsible for managing and maintaining the project status in MS Project.
• Worked on reference data acquisition requirements from various sources identified based on logical data model analysis
• Analyzed the target records for different products to create transformation surveys for product processors
• Worked on validation documents for different products based on target records.
• Designed mapping documents for target record to logical data model.
• Consolidated local value to standard value transformations based on survey analysis of in scope product processors for various regions.
• Point of contact between Data model team and business for resolving the transformation gaps by discussing with respective business team.
• Created metadata load ready files using consolidated transformation mappings to be loaded into standard metadata hub for ETL team usage.
• Experience in data demand mapping for trade products with logical model and uploading the mapping in metadata hub
• Worked on pre-validation of raw files for SIT and analyzing the breaks in the data sent by product processors which is to be transformed and maintained in datawarehouse.
• Compiled the reports based on the results from source configuration utility tool for the steering committee.
• Reviewed and validated test cases based on business requirements for different positive and negative scenarios.
• Maintained the project support artifacts in SharePoint and project plan for datawarehouse.

Environment: IBM- Banking Data Warehouse, InfoSphere Data Architect (IDA), Erwin v7.3, Oracle SQL 2009, MS Visio 2007, MS Office Suite 2010, MS Project 2007

Confidential, Philadelphia,PA

Business Analyst

Responsibilities:

• Mapped ‘Dealer Reserve Pricing Admin system Services’ Process using MS Visio
• Gathered user and business requirements through interviews, surveys, and prototyping. Stored and modified requirements in MS Word
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software Elaboration phase:
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Documented all custom and system modification.
• Assigned problems to appropriate software development team for fixes.
• Created and managed project templates, use-case project templates, requirement types and trace-ability relationships in Requisite Pro.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director.
• Suggested measures and recommendations to improve the current application performance

Environment: Java, J2EE, Web sphere, Visual Basic, MS Excel, Microsoft Visio, PL SQL, SQL, Oracle 9i, Unix, WinNT, Win Runner & Test Director

Confidential, New York, NY

Business Analyst/Data Analyst/Data Warehouse

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.
• Involved in gathering 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.
• 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, Data Stage, Data Warehousing
• 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.
• Created 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.
• Reported and monitored the status using Clear Quest defect tracking tool. Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: Enterprise Architect,Microsoft Visio,SQL,Erwin,Clear Quest,Rational Rose

Confidential, Baltimore, MD

Business Analyst Consultant

Responsibilities:

• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in multiple JAD sessions for identifying requirements.
• Worked extensively with the users and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Used Rational Unified Process (RUP) for business requirements, business process design (Use Cases using UML) and activity and to analyze requirements.
• Created Use-Cases after accessing scope of the project and understanding the business processes.
• Designed use cases and activity diagrams using Enterprise Architect.
• Responsible for PowerPoint Presentation for reporting to senior management.
• Interacting with various stake holders for building business use cases.
• Provided Assistance in developing test case scenarios. Assisted in testing the application and reporting the bugs to the development team.
• Conducted project related presentations and provided reports to the higher management

Environment: Enterprise Architect,Load Runner,MS Excel,MS Office 2007,MS Visio

Confidential

Business Analyst Consultant

Responsibilities:

• Worked with business users for defining business requirements, wrote specifications and translated statement of work into business and system level requirements.
• Performed business and system level analysis, and provided documentation for deliverables.
• Developed detailed functional specifications and developed reports.
• Interfaced with internal clients and technical vendors on new feature requirements.
• Provided support to project team with implementation of new features.
• Planning, Scheduling, Tracking and Requirements Management.
• Used RUP and UML methodologies and Requisite Pro tool to design, document, and manage requirements throughout the full lifecycle of the project, me.e. definition, design, and testing phases.
• Refined and realized Use Case models and created UML diagrams to reflect use case narratives.
• Analyzed Use Case specifications and Use Case models for technical criteria.
• Conducted JAD sessions with underwriter and marketing team to capture business requirements and system behavior.
• Prepared Activity diagrams using wireframes.
• Executed test scripts developed by QA team to check functionality of the application.
• After successful development and testing of the product, participated in product release and deployment to end-user.

Environment: Java,J2EE, MS Visio,MS Excel,Enterprise Architect,HP Quality Center,MS Office 2007.