SUMMARY:

• Over 7 years of extensive experience as a in the Business Systems Analysis, Software Validation and business process re - engineering, with proven ability to articulate business values.
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Experience working very closely with the Data Leads and translating those data requirements to Business requirement specifications.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Strong experience in RUP Business modeling process.
• Modeling, Change Management, Technical, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Extensive experience in configuring data mapping between different Databases.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
• Responsible for assisting project and program managers in creating and maintaining project planning documents and reports.
• Strong Data Analysis skills with excellent knowledge on Enterprise Data Warehousing (EDW) and reporting tools like MicroStrategy and expert at creating SQL queries.
• Responsible for performing project metrics analysis, team communication, resource planning, risk analysis, report generation, and documentation control.
• Strong Business Analysis Skills including In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing and Practical knowledge of Rational Unified Process (RUP).
• Strong experience with Service Management processes and tools with a deep understanding of Problem Management.
• Understand Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile (specifically SCRUM)
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy, Data Warehouse, Data Modeling and Design.
• Extensive Knowledge of Systems Management, Design and Data Modeling.
• Hard-core experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Proven expertise in creating test plans, UML diagrams, flowcharts, screen mockups and systems requirements specifications.
• Excellent business writing skills in writing Preliminary Investigation Report, System Requirements document, Systems Design Specification and System Requirement Change Request.
• Excellent skills, facilitation, power point presentations, maintaining performance metrics, devising documentation & communicating to users.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Demonstrated high capacity to learn new technologies rapidly with no formal .
• Proficient at creating and transforming business requirements into software requirement specification (SRS) using Rational RequisitePro and designing business models using UML diagrams such as use case model, Class Diagrams, Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio.
• Understanding of BEA WebLogic Portal to simplify the production and management of custom-fit portals, allowing a shared services environment to roll out changes with minimal complexity and effort.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Expert in Root Cause Analysis, Feasibility studies and Risk Assessment studies.

TECHNICAL SKILLS:

Databases:: Oracle 11g/10g/9i, Teradata V2R6, 12.0, DB2 9.0, SQL Server 2008, Sybase12.5

Testing Tools:: Quality Center 10, IBM Rational Clear Quest/Clear Case, HP QTP,Load Runner, Soap UI

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case)

BI Tools: Business Object (Crystal Reports), OBIEE, Micorstrategy

ETL/DW Tools: Informatica, TOAD, SQL Developer, Autosys

Business Skills: Business Definition Requirements (BRD), Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis.

Packages: MS Office Suite, Visio, Dream Weaver, Adobe Photoshop

Operating System:: Windows 95/98, NT, 2000, XP, Vista, UNIX, DOS, Windows 7

WORK EXPERIENCE:

Confidential, OH

Sr. Business Systems Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
• Created functional requirement documents for the impacting projects
• Responsible for getting the data needs together to have the requirement specifications translated and worked on creating the BCD work necessities foe the same.
• Updated the impacted MS Access tables.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Responsible for taking on project management duties for projects of small size and low risk.
• Responsible for adhering to project management office policies, procedures, and methodologies.
• Responsible for providing support to ensure client/customer service expectations are met.
• Worked extensively with MS Excel and MS access
• Used Agile Scrum and Water Fall Model for building the application.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Enterprise Data Warehousing (EDW)/Business Intelligence (BI) expertise, wherein actively involved in Datamart Design, Modeling and Implementation.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Read the followed the ICP directives and initiated the project schedule process and iterated the schedule for the same.
• 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 JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Analyzed and validated data to ensure quality results and reporting by comparing results from Teradata queries, Enterprise Data Warehouse (EDW) queries and data entry.
• Used Microstrategy dashboards for data analysis and custom reports.
• Developed timelines for project delivery, and managed projects/resources
• Responsibility included modifications to a customer’s mainframe system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Interacting 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: Microsoft Office Suite, Microsoft Visio, Unix, Scrum, Microstrategy, Enterprise Data Warehouse (EDW), Business Intelligence, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#, DOORS, C++, NET, ASP.NET, Mainframes, COBOL, JCL, Db2, Oracle, Java, J2EE. Business Objects, TestDirector, LoadRunner

Confidential, CA

Business Systems Analyst

Responsibilities:

• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Stored and modified requirements in MS - Word and using TestDirector.
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Microstrategy layer.
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Worked as a Project Coordinator in creating the directives for the BCD and created the BCD work plans and schedules and interpreted everything into business language.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Helped with Data Mapping between the data mart and the Source Systems.
• Worked with businesses stakeholders and external vendors implementing and maintaining Business Intelligence reports and Data Warehouse functionality to support strategic initiatives.
• Responsible for managing Enterprise Data Warehouse (EDW) design, implementation and operations.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Scheduled meetings with developers, System Analysts (SA) and testers to collaborate resource allocation and project completion using MS Project.
• Manage Agile development groups through design, development, testing, and implementation providing coaching in Scrum methods and coordination between interdependent coding efforts.
• Designed and implemented Business Intelligence Solutions for the Reinsurance Group for strategic analysis for new businesses and investments.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Performed in-depth data analysis upon multiple Enterprise Data Warehouse (EDW) environments.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
• Played a major role in Interface testing both functionally and manually.
• Assisted the SA to document 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 traceability relationships in RequisitePro.
• Worked with users to gather business requirements and prepared BRD for the development of MicroStrategy Reports/Dashboards.
• Configured the Data mapping between Oracle and SQL Server.
• Used SQL for Data manipulation and data analysis.
• Developed estimates, project plans (Microsoft project), material, BI reports using Microstrategy.
• Have a thorough understanding of the norms involved in the ICP Playbook directives.
• Created the business continuity plan to plan for disaster Recovery.
• Involved in modeling the data base
• 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 for stress testing and UAT (User Acceptance Testing).
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
• Suggested measures and recommendations to improve the current application performance.

Environment: .NET, Test Director, XML, UNIX / Microstrategy, Scrum, Enterprise Data Warehouse (EDW), Business Intelligence, Oracle Platform, MS Visio, AGILE, Rational RequisitePro

Confidential, Birmingham, AL

Business Systems Analyst

Responsibilities:

• Managed the output requirement project for various Life insurance products.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
• Developed MicroStrategy reporting tool for employees to help them create their own customized report
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Coordinated participation and sign-off of various business partners and customers.
• Worked closely with all aspects of the Business Intelligence team in order to deliver the required solutions in a timely manner.
• Designed Enterprise Data Warehouse (EDW) solutions to expand Data Warehouse and accommodate business needs.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Worked with SQL to query the database.
• Responsible for providing business requirements within an AGILE software development SCRUM environment.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Involved in data mapping and data modeling
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MicroStrategy, Scrum, Enterprise Data Warehouse (EDW), Business Intelligence, Windows.

Confidential, Kansas City, MO

Business Systems Analyst

Responsibilities:

• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Involved in formatting data stores and generate UML diagrams of logical and physical data.
• Developed project plans and managed project scope.
• Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Involved in integration of various Customer Data Sources and provided Data Mapping from various sources.
• Data cleansing and creation of layouts and specifications for end-user reports, delivering an end-to-end Metadata Management solution in the process.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Conducted benchmarking activities to identify best practices.

Environment: HTML, XML, SQL, Rational Suite (Requisite Pro, Rose, Clear Quest, ClearCase), Excel, Access, MS-Word, MS-Outlook, MS-Power Point