SUMMARY

• Self motivated Business Analyst with more than 6 + years of extensive experience in the field of Business Analysis, Quality Assurance, Process Modeling, Data Modeling and Master Data Management. Experience with client server and web based applications.
• Proficient in requirement analysis and possess an expertise in developing RUP software methodology. Extensive experience in visualizing the design of the system using UML methodology.
• Excellent analytical skills along with interpersonal, communication and self - organizing skills. Hands-on management experience developed and established through a variety of cross-functional businesses team assignments.
• Strong knowledge in the field of Finance Industry, Insurance Sector, Retail Banking, Investment Banking.
• Well acquainted with all phases of Software Development Life Cycle (SDLC) methodologies like Agile SCRUM and Waterfall.
• Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, User Stories, technical documents like MRD, PRD, SRS, ERD and Story boards and Requirements Traceability Matrix (RTM).
• Experienced in Master Data Management (MDM), ETL processing, Data Integration, Data Warehousing and reporting on management information.
• Change Management and Impact analysis.
• Considerable knowledge in the analysis, design, and implementation of Master Data Management (MDM) and business processes, using established system analysis, business and system process design, research and implementation methodologies, placement of business controls, data modeling and application development, applying Unified Modeling Language (UML).
• Excellent in SQL/PLSQL, Database Procedures, Triggers and Joins.
• Adept at creating and transforming business requirements into Software Requirement Specification (SRS) and designing business models using Business Intelligence, use case models, workflow models, analysis models, class diagrams, activity diagrams, sequence diagrams, and collaboration diagrams.
• Expertise in writing and executing SQL queries and Data Mapping.
• Solid business, communication, and presentation skills, adept at creating, editing, and coordinating extensive communication networks facilitation of Joint Application Development (JAD) sessions and interviews, reports, implementation requirements, project status reports, to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Acted as liaison between management and development team for requirements.
• Worked extensively with the development team in application development to ensure that all customer requirements are covered and the solution is on schedule.Business Analyst

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential, Gainesville, FL

Responsibilities:

• Worked for Version document with SME. Primary Liaison between Business User and Development Team.
• Conducted GAP analysis between current system functionalities and the planned system expectations
• Served as a resident expert of governance policies, key performance indicators(KPI)
• Facilitated discussions and partnership from each stakeholder in existing policies to optimize processes and maximize organizational efficiency while minimizing risk.
• Extensive experience in all phases of RUP and SDLC processes
• Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.
• Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team for development of the system.
• Represented the Data Governance and Quality Practice Office in key business Initiatives to ensure alignment and consistency within the discipline of Data Quality
• Held regular meetings with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand
• Worked in mainframe environment and used SQL to query various reporting databases.
• Deep understanding of Structured System Development Methodologies.
• Evaluated Homeowners, Automobile and Umbrella policies for new and renewal business.
• Conducted User Acceptance Testing
• Assisted Project Manager and User managers to conduct Market Research and Feasibility Studies, and to develop Scope/Vision Documents.
• Requirements were gathered from the seven business functions within the Data Management organization.
• Worked on the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Developed information cycle diagrams, data flow diagrams, in MS Viso.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents.
• Able to update Microsoft share point portal with the updated project documentation.
• Created logical data modeling using tools like CA ERwin data modeler
• Able to analyze and Map source to target mappings using client Tool CDMA (Code and Data Mapping Application) to further develop enterprise data warehouse.
• Applying Master Data Management (MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objectives and initiatives
• Performed data analysis and ETL techniques for loading high volumes of data and smooth structural flow of the data.
• Assisted Project Manager in development and documentation of Project Plan
• Closely worked with SMEs and Identified, researched, analyzed, and defined key issues of the Business flow.
• Collected and documented business processes as well as Business Rules and then translate to the Business Flow Chart
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Analyzed and Documented Business Requirement Document (BRD), User Stories, Functional Specification Documentation, and System Requirement Documentation, using UML methodologies
• Designed and developed Use Cases using UML and Business Process Modeling.
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing.
• Developed User Manual and Provided User Training.

Business Analyst

Confidential, East Rutherford, NJ

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology.
• Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Worked on the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Developed Sequence Diagrams, OOD using UML.
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Queried database using SQL for backend testing.
• Worked on several mainframe based applications running on an AS/400 platform.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.
• QA of Java scripting. Write Requirements of what is needed to be accomplished with programming and also accomplish increased user productivity and satisfy data capture needs. Test all new/modified java programming.
• Advising Java programmers of any corrections needed to programming for user and data capture needs. Document all bugs in programming for developers to correct. Update and modify Access Database that supports Java scripts.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Business Data Analyst

Confidential, Ewing, NJ

Responsibilities:

• Performed JAR/JAD Sessions, walkthrough with Business, Legacy, Configuration/Interface Developers and ETL Team to provide comprehensive data
• Prepared the meeting minutes and submitted them to the client
• Application was built based on Agile Methodology (SCRUM)
• Worked closely with Senior Management to create the Milestones, sub-tasks, deliverable date, resource breakdown using Microsoft Project plan to meet project deadlines
• Involved in Config-Screen Composition, rules design and interface development for Guidewire PolicyCenter and BillingCenter implementation
• Translated the Business requirements into Technical and Data Specifications for the implementation of PolicyCenter & BillingCenter for workers compensation and Personal Auto products
• Involved in creation of Data Dictionary describing Admin Entities, Business Entities, Typelist and data model extensions for PolicyCenter and Billing Center data Model
• Converted policies from the mainframe to PolicyCenter
• Converted prior term billing data from the mainframe to BillingCenter
• Processed Assigned Risk Quotes and issued Voluntary Renewals
• Provided the data mapping with transformation logic for loading the data into interim datastore, Data Warehouse, Datamart
• Provided the data mapping for Policy Center to GL Staging feed involving aggregated logic for Estimated Annual Premium, Surcharges and Unearned Premium metrics
• Provided the data mapping with transformation logic for PC - ISO feed for providing Premium, Claims (Losses, Reserves) data to support Regulatory Reporting
• Performed data analysis, querying on COBOL (VSAM) files and provided data mapping, transformation algorithm between source and target system
• Performed data analysis, data profiling and data cleansing in support of data quality using Microsoft SQL Server Management Studio
• Prepared test plan, test cases and executed test phase in the Configuration, Conversion, QC, UAT Environment to ensure correctness of ETL process and fix Data quality issues
• Validated operational/analytical reports for verifying conversion and data loading activities
• Used HP ALM Quality Center to report defects and worked closely with developers to fix defects

Business Analyst Analyst

Confidential, New York, NY

Responsibilities:

• Translated business needs and end users specifications into effective and comprehensive/complete business requirements.
• Worked with waterfall and Agile methodologies of Software development Life cycle (SDLC) to carry out different phases of project including gathering and documenting business requirements.
• Built design requirements for large projects involving line of business, software/hardware developers and the vendors.
• Created Use-Cases, User stories and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes
• Analyzed Business needs clearly and from them documented the business requirement (BRDs), Functional (FSDs) and technical design document
• Participated in the logical and physical design sessions, developed HLD (High Level Design) documents (reports).
• Carried out JAD (Joint application development) sessions with the line of business for the clarification of the business needs or follow up, getting hold of documentation related to the problem and documented analysis and findings
• Conducted Brainstorming sessions with the team to get as much as information about the existing systems while imputing ideas and coming up with the effective solutions.
• Engaged in Exporting/Importing Data between different data sources.
• Gained Knowledge of ETL (Extract, Transform, Load) suite while working on Data Mapping
• Performed extensive requirement analysis including data analysis by running look up and gap analysis
• Communicated findings and Status of the project on a regular basis to all levels of management.
• Managed workload of junior business analysts on the team, and monitored milestones and critical dates to identify potential jeopardy of schedule and identified/mitigated risk.
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
• Worked with developers for ETL and Data Warehouse development.
• Wrote SQL queries on data staging tables and data warehouse tables to validate the data results.
• Lead the testing initiative - develop test strategy and test plan, conduct integration testing and Facilitated User Acceptance Testing (UAT) and in developing content and training materials for the stakeholders and the business users.
• Conducted Error Analysis, by doing experiments and making measurements, drawing meaningful conclusions.
• Extensive experience in Gap Analysis of the As-Is and Should-Be process within the organization for implementation of RUP.
• Worked as part of Access management to provision the new systems (applications) access to the new hires on-boarded.
• Coordinated with line of Business, PMO team and systems access issues resolution team while provisioning systems access to the new hires.
• Gained knowledge of XML and Beyond compare while working on and comparing loans side by side.
• Project management update and controlling to ensure on time delivery