Senior Business Systems Analyst Resume Profile
MA
SUMMARY
- 12 years of industry experience in Project Management and Business Analysis
- Experienced working in all the stages of the Software Development Life Cycle by following different methodologies RUP, Agile, Waterfall and CMMI
- Experienced in Application Integration, Up-gradation, Revised Architecture, Enhancement, Customization and Development
- Experience working in new domain in every project: Healthcare, Banking, Finance, Bio Technology and Construction
- Experienced in Disaster Recovery Plan Business Continuity Plan implementation and management, CMMI5 Process Implementation, Project Planning and Project management
- Experienced in Cost Benefit Analysis, Feasibility Analysis, Impact Analysis, Gap Analysis, conducting Conference Room Pilot CRP presentation, Change Management, Vendor Management, JAD Sessions, Requirements Walkthrough Sessions, Dashboard Meetings, Project Status Reporting and User Training
TECHNICAL PROFICIENCIES
- OS : Windows, UNIX
- Languages : PL/SQL, SQL, JSP, VB, JAVA, C, .net, HTML, XML, HL7
- Management Tools : Visio, MS Project, Rational Rose, Rational Requisite Composer, Test Director, Quality Center, PlanIT, Visual Studio, MS Office, PowerPoint, MS Project, Textpad
- Version Control Tools : MS Visual Source Safe, Lotus Notes, MS Share Point, Livelink, Massforge
- Bug Tracking Tools : Repository Tool, Rational Clear Quest, Lotus Notes, Peregrine, Clarity, RADAR
- Testing Tools : Win Runner, Load Runner, Beyond Compare
- Reporting Tools : Cognos
- Database Query Tools : Toad, HOBS Query Tool, SQL Navigator, SQL Plus, MS sql Server
- Databases/Middleware Servers : Oracle, MS Access, MS sql server, MS BizTalk, Cloverleaf, Webmethods, Informatica
- ERP Systems : Oracle Service Contracts, Install Base, Inventory, AP, AR, HRMS OAB, HR , Siebel CRM, Oracle Discoverer
WORK EXPERIENCE
Confidential
Manager
Project Overview
Working on Affordable Care Act based Massachusetts Health Insurance Exchange HIX project, a public facing product/website known as Health Connector. It was implemented in production on Oct 1, 2013. HIX project had started in collaboration with UMass Med, State of MA EOHHS , Federal Government and Health Connector to create a Health Insurance Exchange HIX which is being used by the MA residents to shop and enroll in the eligible health care plan Medicaid, CHIP, and Private Insurance etc .
Responsibilities
- Managing Incident Management and Defect Management efforts/team and prioritizing production issues/defects for upcoming releases
- Working with Business Stakeholders and vendor to clarify requirements and prioritize change requests and defects post-production
- Leading various functional teams during pre and post production phases: Account Creation, User Roles and Permissions, PSI/ARD, ID Proofing, Linking, Plan Management, Shopping, Plan Selection, Account Management, Premium Assistance and Premium Billing
- Serving as liaison between state and the vendor companies for managing project plans for JADs and approving requirements documents
- Interviewed CMS, User Experience Team, Issuers health insurance providers , MA eligibility system team and Health Connector team for gathering Massachusetts HIX Health Insurance Exchange system requirements
- Documented proposed business process models and other documents for various components of HIX system PSI, ARD, ID Proofing, Automatic Linking, Navigator/CAC application process, Multi Factor Authentication, Interfaces-HIX to issuer/CMS/IRS, security requirements, etc.
- Reviewed and updated vendor created Business Requirements Document, Functional requirement Documents and Use case development of enrollment and eligibility, plan management, login password, audit logs, account provisioning and account administration areas
- Worked with the vendor for designing wireframes for HIX system's User Interfaces
Confidential
Functional Lead
Project Overview
APM Portal re-engineering project is to re-design the portal on Liferay interfacing Salesforce with advanced features and user interface.
Responsibilities
- Interviewed Product Managers, Customer Support Team, User Experience Team and Gomez Clients end users for existing issues with the legacy system and vision of the new Portal
- Conducted walkthrough of the new portal features with end users for the feedback
- Created Vision documents, functional requirement documents and use cases for various features of the portal, like login password, audit logs, account provisioning, account administration, global search and test provisioning
- Proposed new organization permission hierarchy for enhanced security and defined various user groups, roles and permissions
- Designed wireframes for User Interface of the new portal
- Defined requirements for the collective intelligence CI one chart project with enhanced functionality on the existing portal
- Created SQL queries to extract the data from database to verify the CI chart data
- Defined and documented interface requirements from new portal to salesforce
- Created test plan and traceability matrix and conducted design review sessions with development team
Confidential
BA Lead
Project Overview
GeDI project is to manage implementation of Siebel CRM, Lab Information Management Systems LIMS SCC , middleware server MS BizTalk , its related interfaces EDI , billing system Xifin and BI reports.
Responsibilities
- Conducted interviews and facilitated requirements walkthrough with business SMEs and Scientists for elicitation, documentation and approval of business requirements related to LIMS customization to accommodate Genzyme's testing process for various AP, Flow, Cytogenetics, Molecular and Biochem tests
- Documented requirements for client setup, test setup AP, Flow, Cyto, Biochem and Molecular , EDI profile setup, transmission type and mode at BizTalk and Cloverleaf server, Siebel CRM and Xifin for each client
- Communicated customization and setup requirements for SCC LIMS and WebMethods for the XML routing to developers
- Documented the interface requirements between LIMS, Oracle Apps Siebel CRM, AP, AR , Xifin and interfacing applications
- Defined, documented and configured the bill codes of different Lab Tests AP, Flow, Bio-Chemical and Cytogenetic tests from in SCC for SCC-Xifin interfacing
- Created functional requirements documents for various standard and customized Lab test report templates, XML output and transformation map from XML to HL7 for bills, claims and reports at BizTalk and Cloverleaf
- Documented and tested interface and configuration requirement between LIMS and Oracle Apps AP and AR modules
- Documented Data warehouse ETL and report requirements of Medical Affiars and Marketing team using Business Objects from various applications used by cross-functional teams Siebel, Xifin, SCC and WebMethods
- Created complex SQL queries for testing the BI reports, client interfaces report data and billing data
- Created Traceability matrix, Test strategy, Test Plan and managed requirements and testing activities with testing team, business team, web methods team, development team and SOFT vendor team
- Worked with the change management group for the additional and revised requirements using JIRA
- Guided a team of business analysts and testers for testing of the Electronic Client interfaces by interface data flow XML and HL7 between Client, BizTalk, Cloverleaf, FUSION, SCC, Web Services and the End Client
- Proposed usage of Beyond Compare tool to minimize the testing efforts and errors and implementation of best practices from the past experience, like sharing data across different teams and effective usage of LiveLink
Confidential
Oracle Consultant
Project Overview
This project was an enhancement project for Oracle Apps Service Contracts and its interfacing modules Inventory, Sales Orders, AP, AR, Catalyst, Install base and Siebel CRM .
Responsibilities
- Facilitated sessions with business users, defined and documented business and functional requirements for Oracle Apps Service Contracts, Install Base, AP and AR
- Defined locations, customers, approval groups, lookup codes and control options approval procedures for Service Contracts module Setup the clients at Siebel CRM and tested the same
- Documented functional test conditions, Test strategy/Scripts and tested the interface data flow between Catalyst, Install Base, AP, AR, invoices and Contracts modules of Oracle Apps and assisted Business Owners in UAT
- Created Extracts for various data and report requirements for performing testing and fixing the accounts differences between AP and AR module
- Created complex SQL queries help the team extracting the data for day-to-day testing for enhancement/fixes
Confidential
While employed with Infosys Technologies Limited, she had worked on consulting projects in US, Croatia and India with teams located in India and the Client Country:
Confidential
Senior Business Systems Analyst
Project Overview
This project was to migrate and implement Disaster Recovery Plan for applications which supported critical business functions and achieve industry parity in Ameriprise's business to meet required RTO and RPO during a disaster.
Responsibilities
- Planned and documented migration of business critical files and applications Lotus Notes, Paybase, PFW etc. of the bank from existing location to another location to enable disaster recovery, which ensures business continuity in case of disaster
- Performed analysis on the business integration, up-gradation and revised architecture for the applications migrated
- Performed feasibility Analysis, Gap Analysis and Cost Benefit Analysis for all the applications to shortlist for migration
- Planned for the maintenance of the Current Application Systems while managing the migration and hardware set up of the same application to the new location with the multiple lines of businesses, migration team and IBM
- Coordinated with change management process for engaging vendors for hardware setup and extra storage allocation
- Created and maintained project plan and weekly project dash board
- Defined test strategies and test Plans for Functional and User Acceptance testing
Confidential
Banking Business Analyst
Project Overview
This project was to customize and implement Finacle , Retail Banking Business Solutions Software, in replacement to the banking software used at the HPB along with building Data Warehouse and reports
Responsibilities
- Documented banking processes of HPB in the Requirements Specifications and Approach RSA documents using use case scenario and UML use case diagrams and then mapped with the banking processes followed in Finacle-Retail Banking Software
- Performed gap analysis for interfaces modules of Finacle to interact with other banking softwares of Payment Systems ACH , PoS, Corporate and Retail customer's charges, Corporate and Retail customer bank statements and Loans, to find out the gaps in the Finacle product as per the Bank's requirement
- Interviewed business users for defining the automated processes for the Payments System which was manual process before implementation of Finacle. Made flow diagrams on Visio and user interface prototype on MS FrontPage
- Defined High level design documents, which were used by developers to do programming and customizing Finacle
- Created prototype for the UI of Finacle CRM module, based on the enhancement requirements
- Documented and tested Data warehouse ETL and report requirements by creating complex SQL queries
- Developed exchange rate module using Java Scripts, JSP and SQL queries
- Wrote complex SQL queries for analyzing the trend of the Bank's existing data to test the customized application
- Demonstrated all the modules in the Conference Room Pilot CRP presentation to HPB bank users and business owners
Confidential
ERP Analyst
Project Overview
The project was the enhancement and production support for OAB and HRMS module of Oracle Apps. HOBS Health and Other Benefits System , customization of OAB, was used for maintaining the Health benefits by FesCo. This Project was awarded as Best Managed Project and was certified CMMI5.
Responsibilities
- Analyzed enhancement possibilities of HOBS system, based on the issues related to the various health insurance plans/policies HIPPA, COBRA etc and Annual enrollment process
- Managed the configuration activities of the OAB system, prepared test plan, test Scripts and performed system regression testing for various clients
- Analyzed issues with the business logic of the application based on the new health insurance plans and the interface with the HRMS module HR, OAB
- Documented the requirements related to Account Receivable module
- Performed data mining using complex SQL queries for getting the population/data for the analysis and testing
- Reviewed test cases prepared by the team members and documented defects in the defect tracking tool and to identify key issues using Fish-Bone diagrams to increase the product quality
- Managed and coordinated activities between onsite and India teams
- Ensured quality by performing defect prevention analysis using Pareto Chart
- Implemented the processes, like Quality Assurance checks, Version Control for the documents and deliverables etc., to maintain the project at CMMI5 level
Confidential
Design Engineer
Project Overview
This project was to replace legacy software, used for designing the housing complexes, with the user friendly windows based Software. Also new software was implemented with up gradation in the design methods.
Responsibilities
- Researched and documented requirements for the up gradation of the software to design pipeline system for the housing complexes
- Presented different design options in the analysis report and prepared cost benefit analysis report based on the complexity of the system, implementation cost of the software for the company and implementation cost for the end users
- Prepared requirements specifications documents and high level design document to be used by the developers
- Prepared software prototype using MS FrontPage
- Facilitated sessions to share knowledge about the pipeline designing concept among the team members
- Prepared test strategy and test plan for the functional testing and user acceptance testing
- Prepared project closure report and user manual
