Sr. Business Analyst Resume
Franklin Lakes, NJ
OBJECTIVE: Looking an opportunity in a dynamic company which allows challenging, detailed work while providing leadership and technical growth in IT business analyst where I will be able to utilize my knowledge and expertise.
SUMMARY:
- Over 7+ years of diverse experience in IT Industry with 6+ years as a business analyst.
- Extensive experience in financial and banking sectors including mortgage backed securities (MBS), collateral mortgage obligation (CMO), asset backed securities (ABS), collateral debt obligations (CDO), account reconciliations and general ledger (GL) journal entry (JE) automation, Credit card and direct banking, Auto loans, Small business lending.
- Strong knowledge of many software development life cycle (SDLC) methodologies including Rational Unified Process (RUP), Agile, Extreme Programming (XP), Waterfall, Spiral Model and other proprietary technology delivery frameworks and processes.
- Hands on experience in creating Business Process Models, which defined the high level business activities and processes and provided a foundation for the Use Case model.
- Expertise in the development and interpretation of Business Requirement Document (BRD), Business Process Document, Functional Requirements Specifications (FRS), Use Case Specification (Business and Application), Use Case Models, Systems Design Specifications (SDS), and Business Continuity Plans (BCP), Requirements Traceability Matrix (RTM)
- Experience in implementing RUP methodology, Agile methodology
- Hands on experience in managing requirements using Requisite Pro and Doors.
- Extensively used Unified Modeling Language (UML) to graphically represent system\'s blueprints, business processes and; the as-is and to-be system functionality.
- Used IVR to help customers receive anonymous calls about their test results or content update.
- Working experience in the Analytical CRM for health care customers and their custom data management.
- In-depth knowledge of Claims Processing with FACETS.
- Worked heavily on Clinical Trials using IVR to conduct global clinical trials and manage the large volumes of data generated.
- Assisted in Clinical Data Management and Clinical Trials Management.
- Gathered business requirements through JAD sessions and one-on-one interviews with the Business Stakeholders and tracked the requirements using CALIBER.
- Performed collection, coding, and assessment and reporting of adverse event data using ARISg.
- Worked in the ARISg Implementation of the EHR-Pharmacy Module.
- Expertise in modeling using Use Case Diagram, Sequence Diagrams and Activity Diagrams.
- Adept in creating test cases and scripts; and conducting User Acceptance Testing (UAT).
- Extensive experience in creating SQL queries to facilitate UAT.
- Excellent at coordinating extensive communication networks and facilitation of joint application design (JAD) sessions, brainstorming sessions and interviews.
- Extensive experience in managing and controlling change using Clear Quest and performing version control using Clear Case.
- Well versed with Cost benefit analysis and ROI analysis.
- Exposure to PeopleSoft Enterprise General Ledger, PeopleSoft Enterprise Cash Management and SQR.
- Experience with Data modeling in a decision support environment.
- Exposure to QA Principle SEI CMM levels, ISO 9001, Software Development Analysis.
- Knowledge of Sarbanes Oxley (SOX) Act, Section 404 key controls as implemented through project management methodologies.
- Strong analytical skills and excellent at identifying root causes and executing corrective actions.
- Experience in preparing Project Schedules and performing; Milestone Tracking and Resource Allocations using MS Project.
- Exceptional ability to work under high pressure and proven to work independently or as a part of a team.
- Strong Knowledge of Document Management and Workflow automation.
EDUCATION:
Master of Science in Information Network and Computer Security
PROFESSIONAL EXPERIENCE
Confidential,Franklin Lakes, NJ January 2008 - Present
Sr. Business Analyst
Project: The project was to solve negative balancing problem and automated the solution. Negative balance occurs when pharmacy has no activity and has payment owed to the client. An imbalanced occurs between Account receivable, integrated check writes and other related system. Any manual adjustment affects the Audit and compliance rules (835). An automated system was to be created to solve this problem. As per the D.O STD and Eligibility changes the member number and Rx number had to be expanded for compliance reason. Rx and member number expansions (in terms of bytes) were to be populated into the IW. The impact of the change on various systems was to be estimated and analyzed. I also worked for the Pharmacy benefit Management (PBM) application.
I was responsible for:
- Negative balance
- Analyze the requirement; understand compliance complications as per D.0 5010 HIPPA
- Understand the HIPAA Regulation 835(implementation guide) and gathering requirement from the BRD for compliance regulation.
- Worked on Pharmacy Benefit Management (PBM)
- Requirement gathering for Negative Balance Forwarding regulation.
- Complete a through comparison of the present manual system to the required automated system.
- Conduct Joint Application Development sessions with various teams for requirement gathering and documenting meeting minutes
- Worked with Project Tracking System for information tracking and traceability
- Work with the business owner and SME for audit compliance for each of the deliverable
- Working with the technical teams for systems reviews and processing impact
- Using SDLC methodology to start with processing of the requirement
- Completed an Impact analysis on existing systems by the change
- Understand the compliance requirement to convert the system into an automated system.
- Creating flow charts for the process flow, use cases and Functional requirements
- Drafting FRD using optimal trace.
- Drafting SOP for tickets and maintenance issues.
- Update project plan with IBM portfolio manager
- Multi-tasking various project both under negative balance and other SSR
- Member number and RX number expansion for D.0 5010 HIPPA
- Expand member number from 18 bytes to 20 byte storage
- Expand Rx number from 7 byte to 12 byte storage
- Understand the inbound and outbound systems in this process
- Conduct JAD work sessions to understand the working system impact
- Create work scenarios and work session to come up to the most economical scenario of change.
- Create layout and mockup of the change to be made in form of the report.
- Worked on Impact analysis for each of the systems and their sub entities for both inbound and outbound systems
- Create business requirement and functional requirements using optimal trace.
- Work with the technical team for the development of Member and Rx number expansion
- Having cross functional review where in required for setup.
- Creating tractability between the business requirement and functional requirements.
- Work with the QA team for testing
Environment: UNIX, Windows XP, Oracle, Teradata, SQL, TOAD, SQL*Plus, Java, Asp.Net, UML, MS Office, Agile
Confidential,Indianapolis, IN November 2007 – December 2008
Business System Analyst
Project: Front End Enhancements (FEE)
Project was based on Agile Methodology; at Precision Rx Specialty Solutions we use application TurboCAP as the FRONTEND Referral/Order Management application for processing specialty prescriptions. The application contains Patient, Insurance and Drug information. Most departments use this application to load Referrals and process Orders. TurboCAP is integrated with ProPBM, ProSERV, Back End Fulfillment System (QMSI) and various 3rd party applications like GENTRAN, RightFax, and PC ChargePro etc.
Project: Coordination of Benefits (COB)
The purpose of this project is to implement the functionality necessary to support correct end-to-end processing of Coordination of Benefits (COB) to ensure compliance with the Centers for Medicare and Medicaid (CMS) regulations in with regard to COB. This project will address any gaps in Precision Rx Specialty Solutions enrollment systems to adhere to the CMS guidance for following:
- Send COB survey to new members within 30 days of enrollment confirmation.
- Send COB surveys annually to all existing members. Must make several attempts to collect the information using multiple methods.
- Utilize Silverlink to make automated outbound calls to members who do not respond to the COB surveys.
- Maintain history of COB survey mailing and COB data collected.
- Pass COB data to Pharmacy.
- Worked on Pharmacy Benefit Management (PBM).
- Point of contact for iteration and scrum works for agile methodology.
- Pass COB data to the CMS COB contractor Group Health Incorporated (GHI).
- Identify and resolve any COB discrepancies between the health plan and Group Health Incorporated (GHI).
Project: Case Management (CM)
At Precision Rx Specialty Solutions we use application Case Tracker as the FRONTEND Case Management application for processes related to case management i.e., gathering and tying together information concerning patients, payers, employers, providers, facilities etc. At Precision Rx Specialty Solutions the application will help users to keep track of cases – patients, which doctors are involved, diagnoses made, treatments prescribed or given, current status and progress, care and service plans being used, as well as other companies or individuals who are involved with a case. The application will also allow users to generate reports, maintain billing and accounting, and manage their schedule.
I was responsible for:
- Worked with SME’s (CMS & PBM), production staff to identify and map detailed current processes, gaps and failure points, perform root cause analysis and developed BTRD that supported overall strategy, goals and objectives.
- Was involved in all phases of SDLC, and understands and documented comprehensive business requirements, developed statements of work, process flows, performed gap analyses, performed system integration testing and assisted team members when possible.
- Conducted user interview sessions, gathered user specification and analyzed the requirements.
- Identifying and documenting business rules, created detailed Use Cases.
- Performed System Analysis and Design using UML.
- Worked in Agile Methodology.
- Performed analysis on ANSI ASC X12 TRANSACTIONS for example 270, 271, 276, 277, 835, 837 and NCPDP VER 5.1 Claim Submission & Claim Response Files to and from PBMs.
- Using detailed knowledge of Turbo CAP application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.
- Participated in the logical and physical design sessions and developed design documents.
- Assisted in developing test plan, test conditions and test cases to be used in testing based on functional specifications and/or product design.
- Assisted User acceptance testing of system, developed and maintained quality procedures, and also ensured that appropriate documentation was in place.
- Played key role, as a resource in understanding how systems carried out business functions and assisted in ensuring timely and effective implementation.
- Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and plans, and conducted project related presentations.
- Assisted in development of training materials for new technology and process improvement.
Environment: Sybase Power Designer 15, MS Visio 2007, MS SQL Server 2008, Team Foundation Server, REACT, C#, Visual Studio 2008, Biz talk Server 2006 R2,MS Office Suite 2007,MS Project Professional, MS SharePoint Services, Visual C#, Web Services, XML, EDI X12, SSIS 2008, Trizzetto FACETS, Mainframe,DB2,Performance Point Server, Team Test Agent, Windows Server 2003
Confidential,Calabasas, CA October 2006 – October 2007
Business Analyst
Project: FDM Application
Countrywide Financial Corporation has transformed into a leading provider of consumer and B2B financial services in domestic and international markets. The objective of the FDM project was to improve reporting capabilities and data redundancy for the finance department. Data marts were created for functional areas having on time reporting and performance issues.
I was Responsible for:
- Responsible for identifying scope, business and data requirements and artifacts of the project.
- Interacted with cross-functional teams to facilitate gathering of business requirements.
- Responsible for organizing meetings between various functional departments and our team in order to understand what data they are using, what dimensions are they grouping by, how often the reports are generated etc.
- Responsible for writing FRS, URS and Logical Data Modeling Document.
- Creating data models such as Logical and Physical data models using Erwin.
- Involved in data analysis and Data mapping of existing reports to identify and document iteration and business metrics.
- Responsible for understanding the functionality of the present reporting server and then assisted in the modification and design of reports to answers End Users unusual questions.
- Acted as consultant to the ETL and Front-End programmers.
- Figure out to make queries yield comparable data and then took part in the designing of queries for different DB in the Enterprise Datawarehousing.
- Served as a liaison between Clients and Technical Staff to resolve any conflicts.
- Analyzed Business Requirements and segregated them into high and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using ERwin.
- Conducted user interviews, JAD session.
- Conducted the FRS, URS and LDM reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study.
- Actively participated in the design and creation of quick databases to store/manipulate subsets of data in conjunction with client reports.
- Actively involved in User Acceptance testing and Training of the end users.
- Was involved in CCB, quality and risk management activities. Generated management reports on weekly and monthly basis.
- Developed Process flow diagrams to document the existing system.
- Involved in writing the Test Plan, numerous Test Cases and Test Scripts using Test Director.
- Organized, categorized and prioritized requirements to maintain focus on project scope. Used customizable attributes such as priority, status and difficulty for each requirement in order to organize and prioritize.
- Created test cases for FDR to perform Integration tests and verify the integrity of the accounts built on FDR.
- Manual testing for checking the data flow of the application using SQL.
- Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
- Performed Functionality, Integration, and System Testing.
Environment: RequisitePro, Teradata SQL Assistant 7.1,Toad, RUP, UML, Power designer 12.5, Microsoft Excel, Ab Initio, Acquisition (internal process), Business Objects
Confidential,New York April 2005 – September 2006
Senior Business Analyst
Project: HLPMS Application
Worked, as a Senior Business Analyst on its Home Loan Management System This application is an online workflow system to book and monitor the loan portfolios. The business of this division is to process loan application from potential clients/customers, evaluate their eligibility, approve them, and maintain the loans till their closed. This includes client, debtor, invoice, pricing, and account information. Invoices are funded and payments are processed with accounts being managed accordingly. Reports are generated for internal and external use. The bank’s general ledger is synchronized with that of the system. The loan is repaid and removed from the system. The five primary stages in the life cycle of a loan are the request, processing, booking, maintenance, and closure stages. Joined the project while it was in the design & development
I was Responsible for:
- Responsible for defining the scope and business rules of the project, gathering business requirements, and documenting them textually or using models.
- Conducted user interviews, JAD sessions for deriving and writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS) documents.
- Reviewed and analyzed the Business Requirements, performed gap analysis.
- Wrote high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using Rational Rose.
- Higher understanding and to resolve conflicts between Clients and production Staff.
- Actively conducted the FRS and URS reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study.
- Categorized, prioritized and scrubbed requirements to manage project scope. Used attributes such as priority, status and difficulty for each requirement to bring order in organization and prioritization of the project.
- Involved in preparing flow diagrams for the decision logic using Visio tool.
- Involved in preparing Test Plans, Test Cases and Test Procedures.
- Assisted with CR and control, development issue, quality and risk management activities. Generated management reports on weekly and monthly basis.
- Used SQL to manually test the data flow of the application.
- Conducted GAP analysis on the conversion process.
- Tested backend of the application to validate the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
- Conducted Functionality, Integration and System testing.
- Actively involved in UAT and application training sessions of the end users.
- Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
Environment: MS-Office, MS-Visio, Oracle 9i, TOAD, UML, Erwin, MS-SQL Server 2000, SQL, PL/SQL,UNIX, Windows NT