SUMMARY

• Over 8+ years of experience working as a Business Analyst in business and functional requirements gathering, analyzing requirements, data analysis, data mapping, business process re - engineering, object-oriented designing, unified modelling language (UML), SDLC methodology (RUP, Agile, SCRUM) and project management in finance and insurance domain, very good team player with excellent communication and presentation skills.
• Experienced in conducting joint application development (JAD) and Rapid application development (RAD) sessions.
• Wide-ranging experience in Property Casualty Insurance, Reinsurance, Accounting, Finance, Pharmacy Insurance (PBM) and Investment banking domains
• Expertise in Data Modelling, Data Analysis, GAP Analysis, Requirement Analysis, Business Modelling, Data Migration, Data profiling, and Dimensional Modelling.
• Worked with the General Ledger to ensure that all transactional data conformed to GAAP standards.
• Extensive use of Excel Macros and Excel Pivot tables for data manipulation.
• Served as SME for Insurance companies in Property Casualty & Reinsurance domains.
• Generated portfolio analysis and P&L reports by performing risk analysis and risk management (Credit Risk, Market Risk, Reinvestment Risk, and Inflation Risk) based on the client investment objectives.
• Expert in Financial Planning, Forecasting, Budgeting and utilization of variance analysis to manage project to completion on time and within budget.
• Highly proficient in developing and managing MS access and SQL server database for data entry, storage and generation of reports to facilitate management decision making processes.
• Ability to implore various negotiating strategies to gather resources for project implementation.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
• Self-motivated, diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills with strong analytical skills

TECHNICAL SKILLS

Business Modeling Tools: Rational Rose, MS Visio, MS Project

Requirements Management Tools: Rational Requisite Pro

Operating System: Windows 7/VISTA/NT/ XP/ ME/ 2000/ 95/ 98, UNIX

Databases: MS Access, Excel, MS-SQL Server, Oracle, Sybase, DB2

Testing Tools: Rational Functional Tester, Quality Center, Clear Quest and Bugzilla

Reporting Tools: Crystal Reports, Cognos, Micro strategy

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Business Analyst/ Data Analyst (PBM)

Responsibilities:

• Worked on HIPAA Transaction Codes specifically on EDI 837, 835 and 834 to in corporate enhancements
• Updated the meeting minutes of JAD Sessions
• Worked as the primary liaison between the business user and the developers throughout project cycle.
• Interacted with the Subject Matter Experts (SME) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Updated the GAP Analysis Spreadsheet by performing GAP Analysis to understand the difference between both the billing systems
• Lead JAR sessions for requirement elicitation with different stakeholders and analyzed requirements
• Designed ER Diagrams, Use Cases, Class Diagrams and Sequence Diagrams & authored the BRD, FSD and traceability matrix
• Coordinated between the client and IT team and tracked the project status, using MS Project for all phases of SDLC
• Instigated end-user trainings for client; Also initiated webinars, goal-setting and feedback sessions for the technical team
• Managed requirement traceability matrices and documented functional design specifications
• Assisted in creating and improved receivables & payables business process for the company
• Facilitated user acceptance testing activities & worked with Project managers to mitigate deviations

Environment: Rx Home, Alpha E View, Nrx, ESD, SQL Server, RUP, MS Office, MS Visio, MS Project.

Confidential, Warren, NJ

Business Analyst

Responsibilities:

• Identify project stakeholders and their roles in the project with major deliverables and collected business requirements for the project.
• Identified resource requirements. Develop project schedule that included resource availability and set milestones for reporting.
• Performed feasibility and risk analysis to identify the business critical areas from User perspective.
• Developed Use Case diagrams, manage complex Use Cases, business flow diagrams using MS-Visio so that developers and other stakeholders can understand the business process.
• Worked extensively on Adobe and Oracle forms/reports, ISO Forms requirements.
• Identify ISO rates, rules and forms to implement in the system.
• Track testing issues, maintained weekly status checks, and met the exit criteria for UAT.
• Conduct status and review meetings to assess project progress with regard to project plan.
• Measured project performance on time and budget as per the project plan.
• Verified deliverables for each phase with project stakeholders.
• Tracked testing issues, maintained weekly status checks, and met the exit criteria for UAT.
• Review project progress with the C level executives and get approvals/signoffs.
• Specifically Received appreciation from the top Management for my work. The Management promoted me by giving me more responsibilities and salary raise.

Environment: Windows XP, MS Excel, MS Project, MS Visio, UML, RUP, Oracle Reports, Adobe Reports, SQL Server, QTP, Scrum/Agile, HP Quality Center

Confidential, Tampa, FL

Business Analyst

Responsibilities:

• Involved in gathering and analyzing business requirements from existing and proposed models.
• Conducted user interviews, gathered requirements, and analyzed the requirements using Requisite Pro.
• Met with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
• Prepared BRD and FRD for the gathered requirements.
• Conducted JAD sessions to allow different stockholders to communicate their perspective, resolve any issues and come to an agreement quickly.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and Data warehouse.(DWH)
• Performed a key role in preparing software requirement specification (SRS), business requirement documents (BRD), user interface design, designing of application architecture and database modeling in project teams.
• Proper Documentation Preparation after System study and then data modeling and database designing on Oracle
• Created and executed Complex SQL Queries to generate Expected Results for UAT per the data requirements
• Established business analysis methodology using agile dynamic systems development process.
• Created Data Stage jobs to extract, transform and load data into Data warehouses (DWH) from various sources like relational databases, application systems, temp tables, flat files etc.
• Designed and implemented basic SQL queries for QA testing and report / data validation..
• Developed use cases, workflow and screen mock-ups.
• Worked extensively on Relational database and wrote SQL Queries.
• Interacted with the different SMEs deciding about the design and format of the reports.
• Worked with data modelers and helped in enhancing data quality, data integration and data enrichment.
• Coordinated work plans between project manager and client using MS Project.
• Evaluated given problem, situation and crisis; investigate for solutions using data analysis practices and prepare analysis reports.
• Determine the methodologies and procedures for carrying out effective data analysis.
• Organized workshops, explaining technical design of the reports to be uploaded on business objects.

Environment: Rational Requisite Pro, RUP, UML, SQL, PL/SQL, MS Office Suite, Windows, Crystal Reports.

Confidential, Cranberry Township, PA

Business Analyst

Responsibilities:

• Analyzed, developed, tracked and enhanced Business Requirements into Functional Requirements using Rational Requisite Pro
• Participated in UAT Activities associated with each project
• Worked on HIPAA Transaction Codes specifically on EDI 837, 835 and 834 to in corporate enhancements
• Updated the meeting minutes of JAD Sessions
• Worked as the primary liaison between the business user and the developers throughout project cycle.
• Interacted with the Subject Matter Experts (SME) and stakeholders to get a better understanding of client business processes and gather business requirements.
• Updated the GAP Analysis Spreadsheet by performing GAP Analysis to understand the difference between both the billing systems
• Gathered Requirements and developed Data Flow Diagrams
• Worked with QA Team to execute Test cases
• Focused on the scope and desired outcomes of multiple projects for the Medicare Preferred users of the company
• Analyzed the business requirements as per HIPAA standards
• Involved in working with QA Team to prepare Test Plans and Test cases base on User Requirement Documents using Quality Center.

Environment: Mercury Test Director, Windows, MySQL, TOAD, SQL Server, RUP, MS Office, MS Visio, MS Project.

Confidential, Washington, DC

Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Used mainly agile methodology as to release a number of prototypes to satisfy stakeholders expectations & adapt to changing circumstances.
• Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial)
• Prepared requirements document for Commercial Auto, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Negotiated with teams from projects to decide if modules should be implemented independently, or Parallel
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Performed criteria table updates for each project.
• Updated the impacted MS Access tables.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Facilitated and led Daily Scrum sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any)
• Provided data modeling support for numerous strategic application development projects.
• Reviewed and analyzed Vision and Scope documents; Identified Key issues and Risks involved in developing the new BPM system.
• Participated in meetings to establish and enforce SharePoint best practices and standards to manage proper security group naming conventions & security assignment processes
• Participated in requirements meetings, writing requirements in Caliber RM, converting requirements from Caliber RM to HP Quality Centre
• Documented and delivered Functional Specification Document to the project team.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Interacted with the developers on resolving the reported bugs and various technical issues.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

Environment: Agile, Microsoft Office Suite, Microsoft Visio, Windows NT/XP, SQL, SQL Server, Quality Centre, Business Objects, Test Director.

Confidential

Business Analyst

Responsibilities:

• Ensured proper accounting of general ledger transactions and prepared monthly general ledger reconciliations.
• Collected and documented business processes as well as business rules. Involved in Gap analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Prepared system requirement documents, high-level design documents, functional specifications, techno-commercial proposals, and training materials.
• Assisted testing team in understanding the business rules and the system development.
• Reviewed technical specifications to develop test plans, test objectives, test cases and scripts.
• Responsible for the preparation of the monthly financials, quarterly forecasts, and annual budgets

Environment: MS SQL Server, MS Project, Windows 2000, MS Visio, UML, MS Office, GUI testing.