SUMMARY:

• 9 years of experience as a Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications.
• Over 7 yearsof experience in I.T., 2 Years working as Salesforce Business Analyst and ERP Consultant in Salesforce.com.
• Salesforce experience using Workflow & Approvals, Reports, Dashboards, Analytic skills
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Experience in vendor Insurance products - Advanced Claims (CSC), Policy Management System (CSC).
• Analyzing health and life insurance processes and procedures to conceptualize New Business Enrolment process, Commissions Process, and Claims process
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analysis, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experienced in conducting requirement analysis, use case design, designing test plans and developed database schemas based on the logical models.
• Extensive experience in configuring data mapping between different Databases.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• 2 years use of Selenium web driver, for testing purposes
• Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Extensive experience in conducting Joint Application Development (JAD) sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Knowledgeable in principles, working and structure of databases like Oracle, SQL Server and MySQL.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams), Class Diagrams based on UML using Rational Rose
• Worked extensively on user requirements gathering, gap analysis, and development of functional speculations for critical mission accomplishing projects.
• Proficient in Functionality Testing, Black Box Testing, System Testing, Integration Testing, and Regression Testing.
• 3 years SAS Programming, along with PC SAS Inventory Management concepts
• 3 years customer service experience, involving face to face customer interaction
• 2 years with HR, office budgeting and payroll processes.
• Basic knowledge of what Primavera is about. Scheduling appointments and recording timely hours and highlighting key dates tasks and milestones, measuring progress, assuring governance, improving team collaboration and prioritizing project investments and resources
• COGNOS Business Intelligence • Written and oral communication
• Performed requirement analysis through face to face interaction with project managers, SMEs and other leads of a project.
• Interacted with leads from different areas of an organization to discuss developments of a project in terms of how this will impact a certain area and the overall organization.

TECHNICAL SKILLS:

Methodologies/Visual Modeling: RAD, Six Sigma, Product Life Cycle, SWOTAnalysis, GAP Analysis, Cost Benefit Analysis, Cost Effect Analysis, Unified Process, User Stories, Agile Development and the employment of System Development Life Cycle (SDLC) Methodologies, AGILE/SCRUM

Operating systems: Windows 95/98/NT/2000/XP/7

Microsoft Tools: MS Project, MS Visio, MS Office, MS Outlook,MS FrontPage

Languages: C, C++, SQL, PL/SQL, Java

Tools: Word, Excel, Rational Rose, RequisiteProRational Software Modeller, Clear Quest, Visio, Project

Databases: Oracle MS Access, SQL

Skills: OOAD, UML, RUP, SDLC, JAD

Version Control: Rational Clear Case

Testing Tools: Quality Center, Rational Test Manager, WinRunner, Load Runner, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Business Analyst

Responsibilities:

• Analyzing current working trends, and defining new working scope.
• Gathering requirements for new projects.
• Extensively using MS Visio for Project planning purposes.
• Using SharePoint as a means of communication, giving project updates, etc.
• Proposed new changes and working methods for the teams here in Bloomington and Lake Elmo, MO.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint and SharePoint), MS Visio

Confidential, Bloomington, IL

Content Developer/Business Analyst

Responsibilities:

• Gathered data from course plans and developed them into different drafts for employee courses
• Responsible for keeping to Learning and Development standards using MS Office
• Analyzing reviews from all SME, QC and Learning and Development reviews and making changes in developed documents
• Responsible for making sure the developed files follow Learning and Development standards
• Responsible for making sure that the current template formats are uploaded to local SharePoint site
• Provided content management support for different teams around L&D, by ensuring the projects were met fully on time as well as completed.
• Communicated reasons for business changes to the end client

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint and SharePoint)

Confidential, Bloomington, IL

Business Integration Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Worked with change management team to bring new changes across different DC’s
• Responsible for building business process flows using PowerPoint and Visio
• Analysis of business requirements and system requirements of the client
• Responsible for gathering business requirements from the projects leads to build project plans
• Process mapping, data cleansing, data migration and validation of data table structure in areas of Systems, Claims, Integrated Solution Department, and Integrated Customer Platform.
• Understanding of various aspects of these different areas, how they operated, what their procedures are for providing information etc
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Working closely with the current data stewardship team with tasks such as data mapping, analysis of current and proposed data feeds to ensure data quality
• Worked with team members to feed in updates made to project plans into MS Project
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc
• Provided support for primavera planners during project planning stages
• Defined the scope of the requirements for a project
• Identified and scoped the current process gaps and system enhancements
• Involved in project management using MS Project
• Authored weekly reports, submitted to executive board for Learning & Development.
• Managed the requirements gathering process including scheduling interview and brainstorming sessions with user groups to gather, prioritize, and to decompose business and technical requirements
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
• Played a substantial role in the process definitions and business and functional requirements gathering, in an effort to develop a practical technology solution for automating sales methodology
• Used knowledge management by capturing developing and sharing new working strategies
• Extensively used MS PowerPoint to develop the solutions for a project plan
• Helped with Data Mapping between the Systems
• Assumed ownership of T-Plans, L&D reports and Dashboard for Integrated Solution Department
• Performed requirement analysis through face to face interaction with project managers
• Communicated reasons for business changes to the end client
• Communicated what business changes are to take place, why they are taking place and how they impact the area.
• Worked extensively with MS Excel
• Prepared Business Process Management (BPM) using tools such as Visio, PowerPoint

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, MS Project)

Confidential, Hartford, CT

Business Systems Analyst/Quality Analyst

Responsibilities:

• Extensively used MS Visio to develop the solution concept, business timeline and wireframes
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Collaborated in building a business analysis process model using PowerPoint, and Visio
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions
• Worked with team on organization change management, by engaging current team members to adopt new working strategies.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Part of organizational change structure for one of the departments, was responsible for maintain changes as well as implementing them.
• Reported back on changes to be made and why
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution
• Understanding of various aspects of Insurance business like documentation of NB (New Business), policy administration, Sales and Marketing, Accounting, Actuarial, Underwriting, Claims, Products Pricing, Quality, Risk Analysis, AML guidelines, KYC Norms, SOX Rules etc
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
• Working closely with the current data stewardship team with tasks such as data mapping, analysis of current and proposed data feeds to ensure data quality
• Provided key initiatives in working with users in defining project and system requirements
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc
• Was responsible for defining the scope of the requirements
• Identified and scoped the current process gaps and system enhancements
• Involved in project management using MS Project
• Documented prescribed Process Improvement Framework (PIF) practices using a swim lane format
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis
• Authored progress and completion reports, which were then submitted to project management on a weekly basis
• Used Selenium web driver for testing application
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users
• Helped with Data Mapping between the data mart and the Source Systems
• Assumed ownership of Use Case Diagrams, Use Case narratives and other various artifacts
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed activity diagrams in Rational Rose software, so as to have a diagrammatic view of the workflow
• Managed the requirements gathering process including scheduling interview and brainstorming sessions with user groups to gather, prioritize, and to decompose business and technical requirements
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
• Played a substantial role in the process definitions and business and functional requirements gathering, in an effort to develop a practical technology solution for automating sales methodology
• Design and develop the data load process using XML Style sheets and ACORD
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs
• Worked extensively with MS Excel
• Utilized project plans to fit into user stories
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool
• Prepared Business Process Model and Notation (BPMN) for process modeling using Rational Rose
• Specializes in ecommerce projects part of architecture analysis, design, development & implementation in different agile projects
• Implemented complex scalable CMS and e-Commerce solutions for enterprise-level companies using Hybris platform.
• Worked with the offshore team on a B2B implementation for 3M as a Team Lead and mentored some of the team members through Hybris design and implementation issues. Additionally, I also implemented the product availability and pricing webservices along with the shopping cart and checkout functionality

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, MS Project), GuideWire, .NET, Crystal reports, Mainframes, Java, J2EE, Hybris V5, RUP, UML, AWD, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential, Dallas, TX

Quality Analyst/Business Systems Analyst - Team lead

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Worked on creating various ad-hoc reports and pivot tables using MS Excel
• Implemented and harvested Business Rules from cross-functional teams like Claims, Product Pricing Team, Policy Admin Team and Actuarial Data using ILOG
• Served 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
• Worked in the RUP framework in requirements analysis management and used standard artifact and tool mentors suggested in RUP
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system
• Created macros for preparing test cases in Excel for validating process of P&L tool, order management, Allocation Strategies and Modeling
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Analyzed Performance Monitor graphs
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps
• Involved in making Use Case Diagrams, Activity Diagrams, and using analysis and design models tools like MS Visio, Rational Rose through RUP, Agile and Waterfall Model
• Helped with Data Mapping between the data mart and the Source Systems
• Extensively used Test Director to review and update the status of entire testing process
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling
• Participated in Documenting Processes and Policies in property and casualty insurance
• Trained End-users and customer service agents on the CRM (Customer Relationship Management) application
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs
• Worked extensively with MS Excel
• Developed and maintained Service Oriented Architecture (SOA) governance process costing models and metrics ensuring architecture compliance
• Provide customer service and support for Property & Casualty risk management needs
• Designed forms using Adobe lifecycle.
• Worked on client server systems and supporting databases.

Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Macros, GuideWire, .NET, Crystal reports, Mainframes, Java, J2EE, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner.

Confidential, Albany, NY

Business Systems Analyst

Responsibilities:

• Managed the requirements gathering process including scheduling interview and brainstorming sessions with user groups to gather, prioritize, and to decompose business and technical requirements
• Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models
• Played a substantial role in the process definitions and business and functional requirements gathering, in an effort to develop a practical technology solution for automating sales methodology
• Developed the wireframe and mock-ups for the prototype of the web based application in MS Visio
• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model
• Understanding of health insurance products (Product Pricing, Medicare, Medicaid, Claims, Adjudication, HIPPA regulations, Underwriting, Actuarial Practices, EDI etc.)
• Involved in and test session on HIPAA Privacy policy
• Conducted ROI, Technical feasibility and operational feasibility studies
• Responsible for conducting research and root cause analysis for customers with the goal of recommending and implementing new processes and solutions to problems. Resolved issues and improve operational performance.
• Elicited, documented, and analysed health and life insurance processes and procedures to conceptualize New Business Enrolment process, Commissions Process, and Claims process; and created a set of requirements to be used for workflow automation
• Involved in a broad range of solutions around Policy Administration System implementation - from full project ownership to providing critical solution accelerators
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Provided expert consulting services to clients in the areas of business process management, strategic planning and Lean Six Sigma implementations
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Involved in making Use Case Diagrams, Activity Diagrams, and using analysis and design models tools like MS Visio, Rational Rose through RUP, Agile and Waterfall Model
• Defined Functional Test Cases, documented, Executed test script in Facets system
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Used MS Access and Excel to cleanse and assemble accounting data and develop reports
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Worked with Claims, enrolment, eligibility verification for members and providers, benefits setup, and backend payment cycle in facets
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL)
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project; educate clients and stakeholders on the benefits and risks associated with the project.
• Always maintained excellent problem-solving and communication skills; and effectively listened, negotiated, debated, discussed, brainstormed, communicated, and collaborated with a variety of individuals and groups
• Utilized project plans to fit into user stories
• Used Adobe lifecycle planning methods

Environment: Oracle, SQL, Crystal Reports, Business Objects, XML, SDLC, DB2, RUP, UML, UAT, Windows, Rational Enterprise suite, MS Excel, MS Word, MS SharePoint, MS Office