SUMMARY

• Extensive experience in eliciting, gathering, managing, documenting business, functional, technical and operational requirements and communicating effectively with Business, Technical and Operation teams
• Comprehensive knowledge on RUP, Waterfall, Agile, Iterative methodologies
• Hands on experience in documenting Business Requirements Document, Functional Specification Document, Solution Requirement Specifications (SRS), Technical Design Document (TDD)
• Expertise in documenting Use cases, Activity diagrams, Process flow and workflow diagrams, User manuals, Technical orientation guides,
• Experience working in Web Application Firewall team for Wholesale Security Services group process Site guides, Production support Runbooks, Playbooks and System Interface Agreements (SIAs), Service Level Agreements(SLAs)
• Experience in writing test cases, test plan for Assembly Testing and User Acceptance Testing. Coordinated testing activities with SIT, UAT teams
• Have been part of Requirements & Solution Review committee to ensure business requirements encompass all impacts
• Demonstrated experience working within data migration, conversion and integration projects
• Good experience in Middleware Services, Data warehousing, Data Modeling, ER Modeling, ETL data mapping, data sourcing, data profiling and BI Reporting
• Capable of verifying Tableau reports by writing complex SQL statements with joins, aggregate functions, and filter & search criteria to verify the integrity and correctness of the reports.
• Ability to write complex SQLs needed for ETL jobs and analyzing data
• Good experience in writing and grooming User stories, Acceptance criteria
• Experience in facilitating Scrum daily meetings, Sprint review and Retrospective meetings
• Experience in leading teams and possess excellent communication and interpersonal skills

TECHNICAL SKILLS

Domain Knowledge: Healthcare, Pharmaceutical, Banking, Finance, Insurance, Utilities

Methodologies: Agile, RUP, Waterfall

Tools: MS Office, HP ALM, MS Share Point Online/ 2010, CA Agile Rally, TOAD, Informatica 9.x/8.x, Tableau 10.x/Tableau 9.x, Office 365

Technical Skills: COBOL, SAP, SQL, CICS, PL/SQL, DB2, Java Basics, Oracle, IMS

PROFESSIONAL EXPERIENCE

Senior Business Systems Analyst

Confidential - El Segundo, CA

Responsibilities:

• Maintain daily refresh and weekly refresh data validation testing including UI and Database testing in QA, Staging and Production regions for PIP project and send Test Report to Management
• Prepared Business requirements document (BRD) and functional requirements document (FRD) for Claims Quality Control (CQC) Dashboard UI
• Written and executed CQC Database Unit and Integration testing
• Documented CQC Rules engine testing of data loading and functionality
• Executed Patient Intervention Report (PIR) Unit and System Integration testing for CA and NV states
• Prepared Functional Requirements Document (BRD) for PIP functionality such as PIP Home, Patient Management, Performance Measures
• Prepared technical requirements document for MedHx changes enhancement for various Provider Abstract Forms (PAFs)

Environment: MS SQL Server, SQL, MS Office, Visio, Sharepoint 2010, Microsoft Team Foundation Server

Sr. Business Systems Analyst

Confidential - Glendale, CA

Responsibilities:

• Gather Business needs and elaborate them into Business and Technical requirements for Grapple Dashboard components and its sub-components.
• Actively helped the Development Leads with developing suitable architecture to support ongoing and new projects.
• Create and and document necessary UML diagrams.
• Closely supporting QA to derive suitable Test Plan and understand the Business needs and requirements.
• Constantly validating the test cases and test results from QA with Development Leads.
• Working closely with the Project Managers to manage projects and their timelines.
• Working with Dev and Operation team to create a knowledge base to support Operations with production issues
• Documet content onboarding activities for on-premise and cloud content sources for different collaborative and task management functionalities

Environment: C#.Net, jQuery, Ajax, MVC 4, MS office, SQL, SQL Server, Team Foundation Server(Azure Devops Server), WCF, HTML, CSS, JavaScript

Sr. Business Systems Analyst

Confidential - Thousand Oaks, CA

Responsibilities:

• Develop a strong understanding of client’s Business Processes, Information needs and Systems to provide guidance for design and implementation activities
• Responsible for new enhancements in sales module
• Identify and assist in the implementation of new processes to help the flow of work of various departments
• Prepare test strategy, test plan and define test scenarios review with team to finalize
• Create SQL queries for end user reporting and database validations
• Preparation of Functional Designs, Configuration Designs and Test Scripts for new enhancements
• Managed data cleanup and data migration for all customer and historical sales order data.
• Created training documents and training materials for end users
• Conduct pre implementation testing and data validation in system test environments - working with key system users to ensure system setup and configurations

Environment: SAP, CA Agile Rally, SQL, SharePoint 2010, Office 365, MS Visio

Business Systems Consultant

Confidential - Woodland Hills, CA

Responsibilities:

• Document high level Business needs and convert them into Business Requirements Document (BRD)
• Develop Automated Reports, Adhoc queries to notify the Technical and Business stakeholders of malicious events and cyber-attacks.
• Worked on a hybrid methodology comprises of Agile-waterfall tailored to Confidential needs
• Prepared user stories and closely worked with Product Owner for grooming user stories, and documented Acceptance criteria.
• Experience in facilitating Scrum daily meetings, Sprint review and retrospective meetings.
• Created Host to URL mapping document to identify the applications to onboard for Confidential .
• Involved in eliciting and documenting WAF Process Site Guide by facilitating meetings with WAF tech team, Technology Operations Group and other tech teams.
• Created and maintained Environment Operations Runbook, Application Operations Runbook for WAF Tech team as a reference for production support and resolving cyber-attacks and events.

Environment: Imperva Secure Sphere x4500, Imperva Management Server (MX) M150, MQ, WebLogic

Business Systems Analyst

Confidential - Woodland Hills, CA

Responsibilities:

• Manage assignment (Projects/CRs) based on Business expectations & mitigate risk and/or escalate issues appropriately to project/CRs stake holders.
• Timely, concise communication provided to internal / external stakeholders to support involvement throughout the software development life cycle (RUP).
• Effectively manage stakeholder relationships and expectations through the respective communication channels and available forums (i.e. CRRB, ROM, Scope and BA elaboration or status meetings).
• Responsible for documenting and maintaining BRD, FSD, Use cases and technical architecture.
• Experienced in Data profiling, data quality checks.
• Worked on MS Office tools and Visio for various documentation needs and process flow diagrams.
• Provide Solution design, system impact analysis for simple to complex requirements
• Gathered and documented Reporting requirements for the contents and formats by communicating with end users, technical teams for SAP BO Reporting.
• Prepared BO reporting mockups for metrics, graphs, tabular reports, Dashboards.
• Document end to end process flow solution and review with application architect.

Environment: CRM/Siebel, Office 365, Informatica, ETL, Erwin, DB2, Oracle, HP Quality Center, .Net, Java, SAP BO, MS Office and Visio

Business Systems Consultant

Confidential - Chandler, AZ

Responsibilities:

• Interacted with the Business and Technical teams to understand business and technical needs.
• Created and maintained deliverables such as BRI (business requirements document), SRS (system requirements specification document), FSD (Functional Specification Document).
• Modeled and prepared artifacts such as Technical Architecture diagrams, Data Modeling, Interface diagrams, Process Flow Diagrams.
• Prepared technical and solution design documentation for SOA based GAMS for real time and batch integration.
• Applied various Mappings and various Transformations using ETL Informatica tool.
• Worked with ETL Architects and Development leads to discuss and document the Data warehousing, Data mart design, Data modeling, BI reporting needs and requirements.
• Prepared user stories and closely worked with Product Owner for grooming user stories, and documented Acceptance criteria.
• Participated in Scrum daily meetings, Sprint Review and Retrospective meetings.
• Prepared and executed SQL queries to validate data in GAMS batch validation and integration.
• Responsible for coordination of Unit and UAT test cycles.
• Assist Project Manager with managing project plan, scope, and control log for the release activities.
• Coordinated with middleware team for the configuration and connectivity of MQ queues, channels, and queue managers.
• Worked with end users, OBIEE reporting team for documenting Dashboard, Custom and canned reporting requirements.
• Worked on web service requirements documentation using API/REST services.
• Responsible for preparing project specific documentation and publishing status reports to stake holders and project team.
• Maintained all kinds of project documentation up to date for collaborating through SharePoint.

Environment: SOA, EAI, MS Office, Unix, Informatica, ETL, MQ, Data power, NDM, SharePoint, TIBCO Business Studio, Visio, Oracle, BMC monitor, OBIEE, Autosys

Systems Analyst

Confidential - Los Angeles, CA

Responsibilities:

• Interact with the Business team to understand business needs.
• Define and analyze the business requirements.
• Create and maintain SDLC deliverables such as BRI (business requirements document), SRS (system requirements specification document).
• Develop use cases from requirements including Visio process flow diagrams.
• Responsible for coordination of UAT test cycles.
• Created SQL queries for end user reporting and database validations.
• Gathered and documented end user reporting requirements, formats for SAP BO Reporting.
• Coordinate with all Tech teams to follow up on open action items, issues, risks, and constraints.
• Responsible for preparing project specific documentation and publishing status reports to stake holders and project team.
• Manage all documentation and access rights of team room in Lotus Notes.

Environment: z/OS, COBOL, Java, Web Services, SOA, Unix, MQ, MS Office, SAP, Agile Scrum, DB2, CICS, SQL, Easytrieve

Programmer Analyst

Confidential - Auburn Hills, MI

Responsibilities:

• Involved in Business Requirement Scoping and identifying high priority requirements for implementation.
• Converted Business Requirements into functional Requirements and documented in the FRD (Functional Requirements Document).
• Prepared Business process flow diagrams.
• Assisted in creating test plans and test cases for user acceptance testing.
• Managed all documentation and access rights in SharePoint.
• Tracked project status through MS Project Plan.

Environment: MS-Office, Visio, Quality Center, z/OS, COBOL, SQL, DB2, CICS