SUMMARY:

• Senior Business Analyst with 8+ years of extensive experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications Expertise in Finance, insurance, Business Process Engineering, Systems/ Solutions Engineering, Strategic planning, and Systems Analysis, Strong oral and exceptional written business communication skills.
• Over Seven years of professional experience as a Business Analyst
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Excellent in Developing and evaluating business process Models.
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Enormous experience with business process setup using UML Use Case Modeling, Business Process Modeling, QA testing, RUP, Agile and UAT.
• Strong experience in RUP Business modeling process.
• Worked on editors in the Guidewire Studio to modify PCF files, including various screen components like DVs, LVs, LDVs and Cvs.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Proficient in Database (Oracle, SQL Server) testing skills using advanced SQL, PL/SQL
• Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
• Hands on work experience with Waterfall, and Agile software development methodology.
• Develop business rules and perform event handling in GScript using Guidewire Studio.
• Created Access databases and data mapping document for data stage ETL transactions.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Excellent in Developing and evaluating business process Models.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Knowledge of STP and SWIFT messages.
• Solid understanding of the ETL (Extract, Transform and Load) Process of data into a data ware house/data mart.
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.

TECHNICAL SKILLS:

Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP, CVS, TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA, DB2. Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Rational XDE, DOORS, Cobol, RequisitePro, Caliber RM, Crystal Reports, various NIKU products, C, C++, SharePoint, Docushare, BASIC, Intermediate level-Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Rocky Hill, CT

Sr. Business Analyst

Responsibilities:

• Adjudication of Short Term and Long Term Disability Claims.
• Developed test scripts for the HR functionality like New Hires, Terminations, Promotions, Demotions, Transfers, short term disability, Long Term Disability, etc.
• Identification and Investigation of insurance fraud.
• Initiated independent medical exams and rehabilitation programs.
• Work closely with Business Owners and Stakeholders to outline Business Requirements using rational requisite pro.
• Tracked UAT issues/bugs and prepared reports.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Design methodologies SDLC, Object Oriented Methodologies, Agile, Scrum, and MVC.
• Conducted Knowledge Transfer (KT) session regularly about the application, Eligibility, Waterfall and Post mod Check criteria for the available more than 50 products.
• Generate DDLs and provided them to ETL for FSD support and also to the DBA for database implementation.
• Work with System analyst and IS teams to understand the flow of data.
• Create project plan to carry out testing for implementation & upgrade of existing legacy system with Guidewire Policy Center & Guidewire Billing Center.
• Reviewed and analyzed data from various sources.
• Worked in designing and implementation of Guidewire jobs with Technical leads.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Created Mapping Documents, Report Mockups and modified existing report mockups as to CMS requirements and finalized for development
• Created DFD (Data Functional Design) artifacts that incorporated the process flow Visio, S-T Mapping document and all the specifications for proper ETL implementation.
• Conduct internal and final DFD reviews with the ETL team (EIS), Data Quality and Metadata Management team, data architects, and business and application data stewards.
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Formulated logical statements of business requirements researched and evaluated alternative solutions and recommend the most efficient solution for system design.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Work with Compliance and Regulatory operations to follow and monitor different IT process bound by CMS Regulations.

Environment: Windows XP, Business Objects, Waterfall, Agile, MS Excel, ETL, UAT, Word, Visio, power point, SQL, DB2, SAS database

Confidential, Jersey City, NJ

Sr. Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Used XML for building and parsing of Application Configuration file.
• Used Castor to create objects from XML documents.
• Conceptualized primary process flow diagrams using Microsoft Visio and CaseWise tool sets.
• Used Meta Broker for importing metadata from Erwin Tool and export warehouse Data to Business Objects for reporting purpose.
• Business Process Modeling, Mapping, Requirements management using various SDLC methodologies such as Waterfall, Agile and RUP Processes.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Developed business requirement specification documents as well as high-level project plan.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle
• Gather business requirements through interviews, JAD sessions and observation sand created the business Requirements documentation for building UI for viewing data through Guidewire Policy Centre.
• Worked with various SDLC models like Waterfall Model, JAD and Agile (SCRUM) by having thorough understanding of various phases such as Requirements, Analysis/Design, Development and Testing.
• Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
• Designed and developed all Use Cases and UML models using Rational.
• Developed Sequence Diagrams, OOD using UML.
• Involve in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and cognos ETL loading strategy designing.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Developed requirement reports for day-to-day retail banking needs for opening account, online banking using rational SoDA.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Provided the team with experiential knowledge of PolicyCenter out of the box functionality in order to gather business requirements for the implementation of Guidewire Auto Insurance suite for a Non-life Business Transformation Program.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Worked with marketing team in knowing what exactly bank’s client wants.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Partnered with the technical areas in the research and resolution of system and process problems.
• Analyzed research on operational procedures and methods and recommend changes for improvement - with an emphasis on automation and efficiency.
• Conducted benchmarking activities to identify best practices.
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director
• Performed User Acceptance Testing (UAT).

Environment: Windows NT 4.0, Erwin, SQL, XML, Agile, UAT, ETL, Dbase3, Waterfall, MS Access, HTML.

Confidential, Newnan, GA

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Performed Cost benefit, ROI and ROM studies
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Communicate with Customer Service on ACORD Forms design and other technical problems
• Design and develop the data load process using XML Style sheets and ACORD.
• Completed the documentation of Claims Scenario’s for the source system
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• Created UAT test strategies, including regression and integration testing, wrote test scripts, end-to-end testing scenarios and test plans, managed testing, defect reporting and change requests.
• Created use case scenarios and documented work flow and business process.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Involved in all phases of Software development life cycle (SDLC) using Waterfall and Agile/ scrum methodology.
• Designed and Developed ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from the various source systems feeds.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked closely with higher management to estimate and determine, efforts and resources required to start Guidewire practice.
• Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to conducting UAT
• Involved in mapping data from SWIFT securities reporting messages.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Queried database using SQL
• Worked directly with users of the Multi-Channel Desktop to gather and document their business requirements. Followed up with the users to test the implementation, achieved sign-off and continued to move the system toward go-live.

Environment: Oracle9i, MS Access, ETL, SQL, MS Excel, Agile, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case, UAT, Rational Clear Quest, Waterfall, MS Office suite, MS Visio.

Confidential, Bloomington, IL

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
• Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
• Involved in project cycle plan for the source XML data extraction process, data analysis, transformation and ETL loading strategy designing.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Established a Business Analysis methodology around the Rational Unified Process.
• Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
• Documented artifacts required for each cycle in Agile/Scrum. Used JIRA Agile for management of team projects.
• Designed set of Waterfall SDLC templates used by project teams.
• Developed business process models in RUP to document existing and future business processes.
• Worked extensively with MS Excel and MS access
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
• Established a business analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans and manage scope.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted testing, and Implementation of system enhancements and conversions.

Environment: Mainframes, COBOL, JCL, Db2, Agile, Oracle, Java, J2EE, Rose, ETL, MS Word, MS PowerPoint, MS Excel, MS Visio, Load Runner, Waterfall, Win Runner.

Confidential, Portsmouth, NH

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Executed all aspects related to employee health insurance, worker's compensation, life insurance, long/short term disability, employee discount/store benefits including company events coordination.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Extensive use of Excel to create Functional Specification Documents & Templates.
• Designed the process flow diagrams for flow of information and report creation process.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Assured that all Artifacts are in compliance with corporate Agile Policies and guidelines.
• Conducted RAD sessions for the report users, requestors, and the developers.
• Documented all the changes in the initial templates and was responsible for Release Management.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Prepared for GAP Analysis; identified and documented improving areas to meet capital requirement regulations.
• Created presentations explaining the entire report development process, while drawing a comparison between the legacy & the new report.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Helped with Data Mapping between the data mart and the Source Systems.

Environment: SQL Server 2000, Windows, HL7 v2.X, Agile, Crystal Reports, ETL, Oracle, Mantis Defect Tracking, UML, MS Office, MS Visio