SUMMARY

• Over 8 years of experience as Business Analyst in the Banking & Finance, Retail, E - commerce, Healthcare and Energy domain with noledge of Business Case Development, Development of IT Enabled Business Solutions and Business Analysis.
• Skilled in preparing Business Cases, Business Requirements Documents, Use Cases, Functional and Technical Specification Documents, Requirement Traceability, Traceability matrices, Test plans, Test scripts and Software Development Plans.
• Full understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
• Expertise in creating Business Requirement Document (BRD), Requirement Traceability Matrix (RTM), Functional Requirements Document (FRD), Use Cases Specification, Non-Functional Requirement Document.
• Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment as well as software engineering methods like Rational Unified Process (RUP), Agile and Waterfall Method
• Solid noledge of applications provided by Asset Management & Wealth management trading platforms offered by major financial institutions.
• Installed computer hardware and tested new software for compatibility, ease of installation and viability
• Experience in designing Test Strategies, Test Cases, and Test Scripts and conducting User Acceptance Testing (UAT).
• Diverse experience includes developing reporting and procedural standards
• Experienced in managing client-interactions, project planning, scheduling, and development teams
• Knowledge of risk management, performance measure development, process development, and WBS development.
• Experience with the technical integration requirements which included the Warehouse Management System (WMS), Retail Management System (RMS), Point of Sales (POS) System, ECommerce Ship from Store, and the BI data warehouse, as a result of retiring a major legacy application (Island Pacific)
• Experience in membership, billing and claims payment processing in relation to HIPAA X12,EDI codes 834, 837, 835, 820,and ICD-9/ICD-10.
• Experience working in iterative and Agile and Scrum project environments
• Conducted Joint application development (JAD) sessions with relevant Subject Matter Experts to assess and document current configuration.
• Extensive experience in end-to-end (E2E) and Business-to-Business (B2B) testing.
• Skillful GAP analysis, Cost benefit analysis, Risk assessment, and SWOT analysis.
• Experienced in using different UML diagrams including Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Collaboration Diagrams.
• Good working noledge of SQL, PL/SQL, and T-SQL.
• Excellent understanding of web-based and client-server B2B workflows and e-Commerce, Banking processes including accounting transactions such as General Ledger, Revenue Determination, Payment Reconciliation, AR and Tax
• Track and maintain Stakeholder requested enhancements and changes using SharePoint.
• Proficient in writing SQL queries to extract member and provider data from FACETS
• Hands on experience with Data Warehousing, Dimensional Modeling, Data Analysis, Data loss prevention, Data Mapping, and Data profiling.
• Excellent Team Building and Problem Solving skills in conjunction with strong Technology and Engineering background
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, and SQL, and condensing number of reports to simplify processes
• Ability to articulate alternative solutions and reasoning behind the alternatives.
• Excellent communication and presentation skills along with strong interpersonal & analytical skills.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Responsible for initial phases of data integration for enterprise wide Application Using Service Oriented Architecture (SOA) and Enterprise Service Bus (ESB) Platform.
• FACETS experience in capturing HIPAA related EDI data, accepting inbound transactions from multiple sources and batch processing of claim data.

TECHNICAL SKILLS

Databases: MS Access, SQL Server 2005, Oracle10g/11g

Requirement Management Tools: Rational Requisite Pro

Reporting Tools: Rational SODA, Crystal Reports

Business Intelligence (BI) Tools: COGNOS

Programming Language: SQL, PL/SQL, Visual Basic, Java, J2EE dBase

Web Technologies: HTML, XML, JavaScript, VB Script

Operating Systems: Windows XP, Vista, Windows, Unix, VMware

Business Modeling Tools: Microsoft Visio, UML, Rational Rose, Cognos, RUP, Agile, Scrum

Project Management: Microsoft Project, Microsoft Office (Word, Excel, PowerPoint), JIRA, SPIRA

Testing Tools: Quality Center, QTP, Rational Clear Quest, Win Runner, Loadrunner

Version Control Systems: Rational Clear Case, PVCS

PROFESSIONAL EXPERIENCE

Confidential - Jersey, NJ

Business Analyst / Functional Analyst

Responsibilities:

• Gatheird business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's)
• Provided support to developers with requirement classification, travel domain expertise and testing during Agile/Scrum iterations.
• Designed and deployed the custom objects, custom tabs, validation rules, workflow rules, auto-response rules to suit the needs of the application.
• Responsible for Extraction, Transformation and Loading (ETL) of data into new database management system.
• Wrote complex SQL queries using joins, sub queries to retrieve data from the database.
• Analyzed Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification
• Involved in End-to-End testing of the Application, to ensure right data is being validated through all the interfaces, Reservations, Specials & Packages.
• Monitored progress against business functionality, requested objectives to ensure dat projects meets the specific release criteria.
• Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.
• Designed UI Screens to maximize user experience, created and incorporated the wireframes into BRD/FSD
• Signed-off all releases before they enter production
• Designed and developed scenarios based on business requirements.
• Involved in planning and executing complex category of management data studies with large volumes of data.
• Assisted in Data analysis by generating reports in salesforce.com and MS Access.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.

Environment: MS Office, MS Visio, UI/UX, UNIX, Documentum, Windows, SQL, SQL Server, VBScript, C#. Cognos Data warehouse, ETL tools, DOORS, Database, C++, NET, ASP.NET

Confidential -Melbourne, FL

Business Analyst

Responsibilities:

• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence
• Validating the claims flow from HIPAA Gateway to FACETS.
• Defined roles and responsibilities of participants in the business process.
• Developed and maintain information and documentation related to developing and modifying business processes and systems.
• Designed and developed project document templates based on SDLC methodology
• Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan)
• Identified gaps in the business process.
• Worked on EDI transactions: 270, 271, 834, 835, and 837 to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes Used Test Director, PL/SQL for testing the application
• Helped in defining Change Management Process for Release Management Team.
• Mapped process flow assess as-is a process through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
• Prepared Business Object / Business Process Models dat included modeling of all the activities of business from conceptual to procedural level.
• Designed and developed Use Cases using UML and Business Process Modeling.
• Consulted with healthcare insurance company to develop conversion specifications for other insurance Coordination of Benefits (including Medicare)
• Established RUP (Rational Unified Process) methodology and provided assistance in developing Use cases and project plans.
• Involved in Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPPA 837, 834,204,820, 271, 270, and proprietary format files and Reports development.
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Assisted process owners in process training and implementation.
• Conduct meeting with the stakeholders and assess their accurate involvement with ICD-10.
• Streamlined the Restatement Financial Data Warehouse access review Process.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Documented Requirements for Management Reporting out of Clear Quest using Crystal Reports.
• Facilitated Change Control Board and Governance Board meetings and acted as a liaison between parties impacted by the change requests.

Environment: MS Office, SQL Navigator, HIPPA, EDI Transactions, Trizetto Facets, Clear Case, HTM, UML, MS Project, RUP, Guidewire, SQL, DB2, Oracle, Visio, ClearQuest

Confidential - Washington, DC

Business Analyst

Responsibilities:

• Work with the Data warehouse Architect team for better ETL performance and reports and increase report functionalities. Worked on creation of Cognos 8 packages.
• Created all necessary test documentation and test plans for implementation of complex multi-server multi-domain software enhancements to one of the largest GDS of airline inventory in the United States.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Communicate with overseas airlines office via mail, telephone and faxing.
• Worked on various databases and analyzed the data using SQL and Oracle.
• Conducted extensive requirement analysis. Worked with Informatica developer to extract and transform data from various DB2 database to the data warehouse.
• Created the To-be business process maps to communicate the solutions to the entire team as well as to gain the approval of the SMEs and the management team.
• Identified gaps and performed gap analysis with respect to CMS requirements.
• Responsibilities included oversight of design, configuration, development, implementation, and test of all enhancements and updates to the legacy (IMS) mainframe platform (Sceptre) supporting Flight operations.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Performed Testing Life Cycle during the various phases of the application. Involved in converting manual test cases into automated scripts using TSL on Mercury Win runner, QTP.

Environment: MS Office, MS Sharepoint, MS Access, MS Project, Unix, Windows NT/XP, Amadeus Ticket Quota System (TQS), sabre software, Oracle, JIRA, Scrum, SQL, PL/SQL, Cognos, Sybase, J2EE, .NET, ASP.NET, Business Objects, Quality Center, Online Ticketing, Sabus, Saas, Tableau, Load Runner, Rational Rose, Clear quest.

Confidential - Minneapolis, MN

Business Analyst

Responsibilities:

• Involve in documenting project details in project charter, identify impacts, process/data flowing, business & functional requirements, project plans & schedules, issues log, risk analysis, cost benefit analysis, lessons learned, and project closure documentation
• Identified the major tasks, timelines for each tasks and assisted the project manager in preparing the project plan using MS Projects. Also involved in defining the Project Charter, Scope and PMO reports.
• Identified and documented business rules and mapped with business requirement and functional requirement.
• Translated the business requirement document (BRD) into Functional Specification Document (FSD) and posted screen mockups and wire frames wherever necessary.
• Provides procedural, compliance and audit support to Chase Wealth Management Operations
• Standardize documents for agile project implementations
• Identified user needs and business requirements and communicated design deliverables, such as specifications, templates, storyboards, wireframes, and mock-ups.
• Used XPath and DOM to work with dynamic and static objects in Selenium.
• Interaction with the Subject Matter Expert and business users for requirements gathering by conducting more TEMPthan one JAD sessions
• Prepared status reports and provided the project status to project manager and business stakeholders.
• Created UAT test cases executed UAT testing with business users and trained the users on the new systems.
• Extensively worked with on-shore and off- shore models.
• Designed and developed use cases, activity diagrams, and sequence diagrams.
• Conducted user interviews, gatheird requirements, and analyzed the requirements using Rational Rose, Visio and Requisite pro.
• Assisted the team lead in planning & conducting JAD sessions, preparing the minutes of the meetings and developed the requirement specifications documents (BRD).
• Designed and developed project document templates based on Scrum to manage deliverables and expedite product release
• Prepared screenshots, UI interface diagrams and wireframes using MS word, PowerPoint and Visio.
• Reviewed wireframes with users, collected feedback, and revised design when necessary.
• Assisted designers and programmers to analyze the business requirements for developing initial estimates for the project.
• Participated at test plan meetings, testing status meetings and defect analysis meetings.

Environment: UAT, BRD, JAD, Requisite Pro, Agile, Scrum, Quality Center, MS Project, MS Office (MS Word, MS Excel, MS Access), Crystal Reports, Java, Oracle

Confidential - Glen Lyon, PA

Business Analyst

Responsibilities:

• Responsible for integrating ERP, Payment gateway, Tax System to Hybris as a part of ecommerce systems.
• Worked with gathering information from the initial Change Requests, initial user stories, and meeting notes and converting them into a User Story document; updated and created Process flows.
• Tracked defects using JIRA and generate defect summary reports.
• Created and maintained Quality Database to track Quality Assurance audit results and trends to management and training team
• Visit local merchants for on-site installations, technical support and training of POS (Point of Sales) devices
• Worked with the users to finalize the user stories and gather their approval; participated in the grooming meetings to breakdown the work items into testable units.
• Designed and developed use cases, activity diagrams, and sequence diagrams.
• Conducted user interviews, gatheird requirements, and analyzed the requirements using Rational Rose, Visio and Requisite pro.
• Performed extensive GAP analysis, Data Analysis, Data Requirement Analysis and Data Mapping.
• Publish weekly POS (Point of Sales) reports internally and call out category trends, opportunities and risks.
• Assisted with User Acceptance Testing, developed and maintained quality procedures ensuring dat appropriate documentation is in place.
• Support major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Attend meetings on behalf of the Global POS (Point Of Sales) team.
• Participated in the Project Retrospection to review the project and discuss learning and improvement areas; utilized detailed noledge of application features, scope and impact of business needs throughout analysis.

Environment: POS (Point of Sales), Requisite Pro, Quality Center, ERP, CRM, Hybris, MS Office (MS Word, MS Excel, MS Access), Crystal Reports, Java, Oracle.

Confidential -Weston, FL

Business Analyst

Responsibilities:

• Follow up with engineering teams to provide a correction of errors document dat provides solutions, which will prevent the issue from happening going forward.
• Involved in CRM processes like Design, development, planning, testing and integration of Salesforce
• Create internal monitoring alarms and reports by designing queries using SQL.
• Action upon ad hoc tasks requested by business partners to support day to day operations.
• Give clear and concise feedback on questions/concerns made by the business regarding database logic.
• Work with key business stakeholders, engineering development, and PMO on developing system enhancements.
• Collaborate with the development team on designing clear and concise project requirements.
• Participate and provide signoff based on User Acceptance Testing results.
• Drive and lead execution of new product initiatives through strategic development ensuring target scope in both ecommerce applications and back-end systems using Waterfall and Agile development methodologies.
• Performed the analysis of several websites like EBay, Amazon, Confidential, Target, JCPenney, Macy, Levi's, Calvin Klein, US POLO etc. to identify competitive advantages and value addition to Walmart.
• Provide product support to Enterprise, Supply Chain, Omni Channel and Order management applications.
• Partner with continuous product engineering teams on investigating systemic issues.
• Create and execute SQL queries to find clues on what may be causing the opportunity.
• Perform root cause analysis on production issues.
• Gather and write functional/business requirements used by engineers and programmers on multiple ecommerce applications as well as collaborate with User Experience/Interface designers to develop wireframes/schematics dat support such requirements.
• Got involved in requirements elicitation and analyzing requirements during the requirements analysis phase of the projects.
• Coordinating workflow across ecommerce, IT, UI, retail and UAT teams
• Developed functional specification and implements store-side order entry system dat interfaced with electronic catalog and POS system.
• Offer post implementation support on enhancements dat has been introduced into production.
• Performed GUI testing and analyzed end to end functionality by testing the application manually.
• Track and report upon testing activities, including testing results, test case coverage, defects discovered and their status on a weekly basis.

Environment: Ecommerce, POS, SQL Server 2008 R2, .NET 4.0, UAT, Google Apps for Business, Windows, MS Project, Agile, JAD, MS Visio