SUMMARY

• A Business Analyst with Around 7 years of experience in the field of Insurance, Finance, Healthcare and Banking.
• Diverse experience in Information Technology with focus on Business Analysis, Business Modeling, Requirement Gathering, Documenting Requirements (BRDs/FRDs/Use Cases), and Software Validation.
• Experienced in all phases of Software Development Life Cycle (SDLC), quality management systems and project life cycle processes. Highly skilled in Salesforce.com (SFDC) administration and implementation.
• Extensive knowledge about Sales force setup menu, Configuration, custom Application Development, Administration, Data Migration and Deployment of applications to Force.com platform.
• Sound knowledge of creating SQL Queries for Data Validation and Data Integration.
• Experience in data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions.
• Served as a Subject Matter Expert (SME). Also Collaborated efforts with technical staff and subject matter experts to establish the technical vision of product and analyze triple constraint tradeoffs.
• Excellent knowledge of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models), Rational Tools used during various phases of RUP and BPM Tools
• Proficient in creating User Story, Use Cases, Use case diagrams, Sequence diagrams, and Activity diagrams.
• Adequate knowledge in EDI/HIPAA health information & health care services regulatory environment working knowledge and compliance experience along with proficiency in using ICD10/ CPT/ANSI/HL7 coding standards.
• Worked closely with the system architect to facilitate the design and development of Business Rule Engines to support SOA architecture and defining web services, web methods and orchestrations.
• Experience in cleanse, govern and manage the quality and lifecycle of master data using MDM tools.
• Comprehensive understanding of the Organizational Framework that help to map the AS - IS and TO-BE model using the GAP Analysis and plan and monitor effective approach to build/buy solutions to the business problems/needs/opportunities.
• Experience with building reports-SSRS, Crystal Reports, Dashboards for analytics - Performance Point Services and collaborative team sites (using Microsoft SharePoint Server 2010).
• Comfortable with gathering requirements and analysis for a Service Oriented Architecture, Identity Management, Legacy Migration, COTS Solution and working with global teams.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members, including other elicitation Techniques like focus groups and workshops
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Reports.
• Detail-Oriented Energetic Team Player, Motivated With Multi-Tasking Capabilities, Problem Solver, And Hands-On Leader With Exceptional Presentation And Client/Customer Relation Skills.
• Strong Analytical, Administration And Problem Solving Skills Dedicated To Maintain The High Quality Standards. Good Communication Skills, Ability To Work Independently.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 8/7/2003/2008/ XP/NT, Unix, Linux (Ubuntu), Win 9X Win Server 2003

CRM: SalesForce.com(SFDC), Force.com Platform, Apex Programming Language and Visual force pages

SDLC Methodologies: Agile, Waterfall, Spiral, RUP Process and Prototyping

Internet Languages/ Web Applications: UML, HTML, SQL

Databases and Tools: SQL Server 2005 and 2008, My SQL, Distributed DB, Oracle 8i/9i/10g, MS Access, My SQL, PL/SQL, MDM

Quality Management: IBM Rational Manual Tester, Quality Center, QTP, Rational Clear Quest, Rational Requisite Pro, Rational Rose, JIRA

Project Management: Microsoft Project Professional

Change Management: Rational Clear Quest 7.1, Requisite Pro v7.1

Languages: C/C++, Java, Shell Scripting, Python, VB.Net, JavaScript, CSS, VB6, SQL, XML, ASP.NET, C#.NET

Version Control: Rational Clear Case, Visual Source Safe, Team Foundation Services

Business Intelligence / Reporting: SQL Server Reporting Services (SSRS), Performance Point Services, MSBI, ETL, Informatica, SFDC Reports

Content Management System: Microsoft SharePoint Server 2010

Others: MS Office Suite (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Business Process Analyst

Responsibilities:

• Involved in the analysis of the functional, technical specifications, data mapping document and conceptual diagrams.
• Wrote system requirements specification (SRS) and functional requirements specification (FRS) and Data Requirement Matrix (DRM) documents as per the business requirements and process flow.
• Documented user stories and modeled use case diagrams by utilizing MS Visio.
• Conducted Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on a Business Requirement.
• Worked with the Solutions Architect to maintain technical documentation for DW design (Star Schema and Extended Star Schema, ETL, DW).
• For ETL worked on documenting Transformations and creating Mapping document
• Provided technical leadership to project team by design the ETL architecture, design ETL process and workflows and managing scope
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Created Use Case Models,Wireframes & Mock-ups, Analysis Models, Design Models, Use Case Diagrams, Behavior Diagrams (sequence diagrams, activity diagrams) based on UML methodology
• Worked with SQL queries to extract application data to perform application validations.
• Wroteprocess flow andbusinesscase documentsof existing processes.
• Define and document Adjuster Licensing business functions and process
• Manage Project scope, milestones, risks and user acceptance tests with internal and external stakeholders
• Create an Implementation and Migration Plan in co-operation with the portfolio and project managers
• Prepared test data for the functional test cases, manual test planning and creation of the test cases based on the user expectations.
• Evaluated test results and prepared test summary reports. Performance testing analysis was also done by analysis the results from balance and load tests.

Environment: MS Project, Oracle, ETL, MS Visio, Microsoft Office Suite, Java, Quality Center, Agile, PL/SQL, SQL Server 2008, SSRS,XML, JIRA

Confidential, Malvern, PA

Sr. Business Analyst

Responsibilities:

• Responsible for the business process management function supporting the technical support team globally
• Manage projects to drive global alignment with strategic directives within support organization geared towards improving assisted customer experience
• Manage short term process improvement/re-engineering initiatives to increase operational efficiency
• Define and gather business requirements and work with IT to deploy scalable system solutions
• Interacted with the end users and stakeholders, gathered technical requirements from the legacy system
• Participated in JAD sessions for requirement gathering, analysis, and design
• Helped draft the scope document and suggested improvements
• Worked as enhancement team member and performed the roles of salesforce.com admin in the organization.
• Analyzed software requirements, negotiate terms and participated in implementing COTS-based solutions.
• Generated weekly status reports and Ad-hoc reports to monitor the progress and identify critical points to reallocate resources and Decision support for Software Development Life Cycle.
• Experienced in ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Developed Test Cases for Deployment Verification, ETL Data Validation, based on technical specifications/Data design documents and Source to Target mappings.
• Architecting the ETL solution end- to- end using Informatica 9.5.1
• Worked with SQL Queries for data manipulation. Analyzed extracted data from the data warehouse.
• Expert in conducting JARs & Client Workshops, Documenting BRDs/FRDs/Use Cases
• Perform the impact analysis of the requirement and suggest the gaps in the requirement.
• Coordinate with the offshore development team on the progression, development of the requirements and analysis of Policy data stored in various databases within the defined timelines.
• Helped QA testing team to create test scenarios and to execute them using TFS and QC.
• Analyze the defects in UAT and Production and categorize them, prioritize them and then assign it to the right resource for fixing the defect.

Environment: MS Office Suite, SQL Server, Informatica, SFDC Sales Cloud, MDM, Agile, SCRUM, Oracle, Rational Clear Quest, Rational Requisite Pro, UML, MS Visio, TFS.

Confidential, Alpharetta, GA

Business Analyst

Responsibilities:

• Managed Project scope, milestones, risks and user acceptance tests with internal and external stakeholders
• Conducted meetings with users and other stakeholders to elicit, organize and document the requirements and also created project status reports and feasibility reports for stakeholders.
• Gathered and analyzed the requirements and converted them into Business Requirement Specifications (BRS) and Functional Requirement Specifications (FRS) for the designers and developers and QA Team to understand them as per their perspective.
• Designed and developed use cases, activity diagrams, and sequence diagrams using Net Beans
• Created "As-Is Business Models" using GAP analysis to understand the existing claim settlement process flow through interacting with SMEs, underwriters and Finance department.
• Documented Business Rules surrounding the complex calculations for the service credit eligibility using JIRA.
• SQL queries to filter data within the Oracle database.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Worked intensively with Medicare & Medicaid claims and claims processing for HIPAA transactions
• Involved in requirements gathering and preparing the technical system design and System Design analysis of the flow of EDI transaction sets 834, 835, 997.
• Validated data at the back-end to ensure that all the Claims related data had been loaded to the corresponding Data Sets in the back-end and the pricing for these Claims was completed as per the Standards.
• Analyzed the results, generated reports and tracked the defects using Quality Center; Created and maintained the Test and Traceability Matrix.
• Create CRUD cycle using Oracle MDM. Analyzed metadata about master data. Developed Master data model.
• Used SAP ERP modules for implementation of billing plans, other financial operation functions such as AR, collections, or revenue recognition
• Researched and wrote backlog of user stories, test cases for QA teams, defects and tech debt for 3 SCRUM teams and maintained backlog in JIRA tool.
• Conducted System, Integrated and Regression testing to the application using Business, Functional, User Acceptance and Usability testing
• Prepared test data in HIPAA compliant X12N format for both inbound and outbound healthcare EDI transactions.
• Implemented detailed planning, business process analysis, and participated in testing of COTS-based solutions and assets management. Delivered training to the respective teams.

Environment: Windows Server 2008, Oracle, SQL, MS Excel, MS Visio, MS Project, Java, JavaScript, SOAP, UML, SDLC/Agile, HP Quality Center (HPQC)

Confidential

Business Analyst

Responsibilities:

• Conducted brainstorming sessions to extrapolate the requirements that are not stated
• Worked with business sponsors for eliciting business/functional requirements and generated use cases in accordance with RUP Best Practices.
• Extensively used Rational Requisite Pro to document, review and analyze the requirements.
• Used UML and RUP methodology to capture, analyze and translate business requirements.
• Developed business Use Case scenarios, sequence diagrams and class diagrams.
• Prepared Rational Suite (Clear Quest and Requisite Pro) training materials for user and administrators and trained nearly thirty of them in the branch office.
• Structured flexible test plans, test cases and test scripts to test entire application based on business requirements, technical specifications, and product knowledge and use case scenarios.
• Analyzed the existing system and generated code decomposition specifications from VBA and SQL and defined functional capabilities and business rules utilizing use case analysis to assist the development team in designing the configuration of a C# SOA (Services Oriented Architecture) with .Net and a SQL Server backend application.
• Addressed all aspects of the loan life cycle, starting from identifying a prospective client to the loan closure.
• Interpret customer requests and take appropriate action to produce high levels of customer satisfaction that are balanced with business needs.
• Plan and co-ordinate new client deployment and upgrades to existing clients
• Work effectively on a global team with clients, product managers and offshore development engineers.
• Identified and validatedbusinessrules and data elements. Performed Data mapping and logical data modeling.
• Used SQL queries in data analysis.
• PreparedBusinessRequirements Documents to enlist the high-level scope of the project.
• Created Process Flow diagrams, Data Flow diagrams (DFD), State Diagrams, Activity Diagrams and Entity Relationship diagram (ERD) in MS Visio using UML for various modules of the project as needed.
• Designed the security, roles and permissions model to replace the pre-existing model giving the users a more secure and flexible security plan.
• Designed and supported House holding Automated Commissioning and Award, Created multiple House holding views using SAS tool.
• Conducted multiple JAD sessions to synchronize different stakeholders on their objectives and gathered requirements.
• Developed Test Plan, Test Scenarios and Test cases based on the Use cases and Functional specifications and also performed manual testing of the functionality of the application by inserting varying data on different test runs.
• Performed User Acceptance Testing on behalf of end-user to ensure that the user requirements are satisfied and properly tested.
• Assisted in implementation and deployment of the best SCM processes with seamless integration among various phases of Software Development Life Cycle (SDLC) such as Change Request and Product Life Cycle Management utilizing UCM component of Rational Suite.

Environment: Agile Scrum Methodology, MS Visio, HP Quality Center, ASP.NET, SQL Server 2005, SSRS, Rational Requisite Pro, Rational Clear Quest, Rational Clear Case, UML, VB, .NET, BCC, CSC, Windows 2000, UNIX, Microsoft Office suite, Quality Center (QC)

Confidential

Business Analyst

Responsibilities:

• Designed, developed and distributed external client facing reports on a monthly, quarterly and annual basis to support the company’s performance and cost savings value to the customer
• Conducted JAD sessions for business requirements elicitation
• Involved in conducting GAP analysis to evaluate the current system and the proposed business requirements.
• Created data flow diagrams to visualize the execution and flow of the project.
• Wrote’ SQL queries (tables and joins) for data consolidation.
• Analyzed, designed and developed internal departmental reporting to monitor performance against departmental goals as well as client and state regulations. Generated graphical reports using MS Excel.
• Management of system tables for cost of drugs, client discounting and future client savings analysis
• Assisted PM in bug tracking and issues in the BRD.
• Participated in SWOT analysis and identified risks and potential benefits.
• Assisted in analyzing future client claims data to rationalize the potential cost savings to be realized by utilizing Express Scripts services

ENVIRONMENT: Windows, MS Office, MS Access, SQL, MS Project, MS Visio, UML, JAVA, MS Project Professional, Rational Clear Case, RUP