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 BFSI domain covering across Property& Casualty Insurance, Reinsurance, Banking/Finance (Financial Accounting, Investment Banking)
• Served as SME for Insurance companies in Property Casualty & Reinsurance domains.
• Experienced in Pharma domain specifically with Pharmacy Benefit Management(PBM)
• 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.
• 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

Lead Business Analyst

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 s 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

Lead 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

Sr 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, New York, NY

Sr Business Analyst

Responsibilities:

• Complete Software Development Life Cycle experience including analysis and review of business requirement specifications, design, and development and testing of system functionality as per the RUP Iterative Software Development Life Cycle process.
• Interacted with the stakeholders to understand the scope of the project, identify business rules, gathered and documented the requirements through surveys and JAD sessions.
• Worked with SME’s of different groups to gain detailed knowledge of Investments Banking and Capital Market and also to understand the cross impacts of the system.
• Interviewed the Subject Matter Experts (SME) by asking detailed questions.
• Created the user requirement specification document and helped convert them to system functionality documents and managed them in Rational Rose Requisite Pro.
• Identified and defined actors, made use cases and grouped them and prepared data flow diagrams, activity diagrams, sequence diagrams, state transition diagrams in MS Visio.
• Held walkthroughs with the developers and QA teams and communicated interface requirements.
• Used Rational Clear Quest to manage and track defects, prioritized defects with each build and made sure that they were communicated to the affected teams and also make enhancement requests.
• Elicited requirements through the process of pre-discovery and Discovery, which were extensive knowledge acquisition sessions.
• Documented answers from those sessions; conducted and analysis and crested post discovery documents.
• Rapid Application Development (RAD) principle was used in acute functionalities to design, document and manage requirements throughout the life cycle of the project, including definition, design and testing phases.
• Worked closely with product managers in developing, creating and implementing marketing strategies to effectively grow the Banks loan and deposit book.
• Maintained commercial lending transactions and worked closely with the Banks Advertising agency to deliver product campaigns.
• Organized public relation events sponsored by the Bank creating strong brand recognition.
• Maintained the requirements traceability matrix as linked to code in order to keep the clients and all the teams up-to-date with the current progress of the project.
• Worked closely with the QA team during the functionality testing and helped in the UAT.

Environment: Unix Solaris 8, .Net 3.0, Requisite Pro, UML, MS Project, Share Point, Windows Server 2003, MS Office Suite, MS Visio, Clear Case, SQL server 2005.

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 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.