We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

San Francisco, CA


  • 10 years of experience as a Business Systems Analyst with solid project management experience, testing, documentation, modeling and systems implementation and experience in performing analysis in areas of strategy and planning, intelligence, data, cost - benefit and workflow business processes.
  • Excellent knowledge of Software Development Life Cycles (SDLC) using methodologies like Agile Process, Rapid Application Development and Waterfall models.
  • In-depth knowledge and expertise in SDLC methodologies, Project Management, and Enterprise Data Management Lifecycle components.
  • Project Management Office formulation, enterprise wide multiple project management, process development, lead, mentor and coach using Agile methodologies including Scrum and XP.
  • Business System Analyst with overall 10 years of experience including Project management, Business analysis, business process management and business process re-engineering.
  • Project management experience involves delegating responsibilities, budgeting, designing time schedules and work breakdown structures, preparing weekly status reports for management, communicating and presenting the reports, and resolving issues and conflicts.
  • Strong experience in MS Project, MS Center and PMO.
  • Expertise in managing multiple projects while maintaining constant communication with the relevant stakeholders.
  • Good Knowledge of HIPAA Compliance Life Cycle, HIPAA Insurance Regulations and Claims Processing acquiring immense knowledge in EDI ANSI X12 Transaction sets including 270, 271, 276, 277, 278, 820, 834, 835, and 837 (P, I, D).
  • Demonstrated skill in management of varied business channels, identifying new sales opportunities, and maintaining excellent customer relations.
  • To ensure requirements and its value to the organization are identified and agreed upon by all stakeholders.
  • An array of skills working with the customer and user communities in defining agreed upon requirements, overcoming obstacles and providing solutions, and ultimately producing usable applications that meet customers’ expectations and generate value to the organization.
  • Expertise in creating training methods, training document, conducting trainings with the help of subject matter experts.
  • Self-motivated and independent, yet able to work in a medium as a team member and communicate ideas effectively.
  • Possess a disciplined, professional and quality centered approach with strong analytical and problem solving skills. Able to work under pressure and in a dynamic cross cultural-environment.
  • Extensive use of the PMBOK guidelines and practices.
  • Knowledge and extensive use of Six Sigma and DMAIC.
  • Exceptional data analysis and reporting skills using SSRS, Crystal Reports and MS Excel.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading process in a corporate-wide-ETL Solution.
  • Used SSAS to conduct analysis of the existing systems by slicing and dicing the data to implement the reporting requirements.
  • Experience in working on IBM Cognos TM1 application (Framework Manager, Query Studio, Report Studio and Transformers).
  • Extensively used SAP Business One for ERP Solutions.
  • As a Sr. Business Analyst, oversaw strategic IT development projects through entire lifecycle including initiation, planning, execution and closure. A self-directed leader with rich expertise defining, developing and implementing change through strategic initiatives and process improvement.
  • Experience in analyzing Business Requirements Documents (BRD), Functional Requirement Documents (FRD) and propose changes as per various internal and external requirements gathered for process improvement.
  • Experience in performing SWOT, Risk & Cost/Benefit analysis and tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM).
  • Experience in conducting Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs, and customer interviews.
  • Hands-on experience in creation of Use Case Scenarios, process modelling using UML like Use Case Diagrams, Data Flow Diagrams, Activity diagrams, and Sequence diagrams using MS Visio and Rational Rose.
  • In-depth understanding of AS-IS and TO-BE scenarios and experience in converting requirements into technical specifications for preparing test plans .
  • Experience in conducting User Acceptance Testing (UAT), verifying performance, reliability and fault tolerance issues and in designing and developing test plans and test cases .


Requirements Gathering Tools: IBM Rational Requisite Pro v7.1.2

Modeling & Designing Tools: IBM Rational Rose, MS Visio, Enterprise Architect 9, Adobe Dreamweaver CS5.5

Configuration Management: Microsoft Virtual SourceSafe, IBM Rational ClearCase v7.2.2

Testing Tools: HP Win Runner 9.2, HP Load Runner 9.1, Quick Test Pro (QTP) 8.2-10.0

Defect Tracking: IBM Rational Clear Quest 7.1, Mozilla Bugzilla 4.0, HP ALM Quality Center 11.0

SDLC Methods: Agile, RUP, Waterfall, Prototyping

Languages: SAS Enterprise Guide 6.1-9.4, HTML, SQL, XML, UML

Project Management: IBM Cognos TM1 8.4-9.5, SAP Business One, MS Office Suite 2010, MS Project 2010, Six Sigma, DMAIC

Application Servers: Oracle BEA Web Logic 8.1/9.1, Apache Tomcat 7.0, IBM Web Sphere v7

Databases: Teradata SQL Assistant 14, Oracle 7.3-10g, IBM DB2, Sybase v7.1, MS SQL Server 2005/2008/2012

BI and Reporting Tools: SSIS, SSRS, SSAS, Business Objects, IBM Cognos, Informatica

Operating Systems: MS Windows 2000/XP/7, Red Hat Linux 5, Oracle Solaris 10

Other Tools: CA Erwin 7.3, Quest TOAD 10, MS FrontPage 2003, Adobe Photoshop CS5


Confidential, San Francisco, CA

Business Systems Analyst


  • Defined, classified, prioritized and documented business, user and functional requirements, business process maps ("As-Is/To-be") flows and context diagrams.
  • Worked closely with stakeholders for the common security related requirements as well as application based custom requirements.
  • Validated the business, user and functional requirements and developed Use Cases and User Centered Designs. Used UML and Rational Rose to produce models like Context Diagrams and Activity Diagrams.
  • Generated reports using the SSRS and deployed it on SharePoint Server.
  • Reviewed BRD and used Requisite Pro to manage, analyze and convert business requirements into FSD.
  • Studied the business problems, opportunities, and priorities in the context of the requirements and recommended solutions to achieve goals.
  • Led Joint Applications Requirements (JAR) Capturing Session and Joint Application Development (JAD) sessions to understand, capture and confirm requirements and resolve cross-functional and geographical issues.
  • Involved appropriate functional units in meetings and communication plan to ensure a seamless project implementation.
  • Oversaw and participated in data analysis and documentation and created business test cases with expected results.

Environment: VBScript, XML, MS office, MS Visio, MS SharePoint, MS Project, Oracle8i, MS Access, SQL, Oracle SQL Developer, JIRA, Confluence, Lotus Notes.

Confidential, San Francisco, CA

Business Systems Analyst


  • Gather business rules for non-homogeneous data coming from various source systems.
  • Reviewed and deciphered SAS code to extract business rules and create data dictionary.
  • Extracted data from Teradata database and used extensive ad-hoc queries (SQL) to create/modify/delete data .
  • Consolidated business and functional rules by leading weekly meetings and JAD sessions with business, marketing, development and QA team.
  • Created business requirement document (BRD) and got it signed off by marketing team.
  • Worked with developers and QA team in database design and development of retirement services cumulative tables for marketing team.
  • Reviewed business rules and participated in testing plan co-development and quality assurance.
  • Acted as requirements project lead for medium to large projects, directing and coordinating requirements project staff and activities.
  • Oversaw production support of core projects, including gathering and documenting requirements, translating functional requirements to technical requirements, preparing and managing the project plan, and recommending solutions.
  • Partnered with business users and acted as a liaison between business and technical teams.
  • Coordinated development, testing, and implementation of solutions with vendors .
  • Used Rational Unified Process Methodology in developing use cases, use case model, supplementary requirements, and business rules.
  • Used IBM Rational ClearQuest to review and track defects found during functional and regression testing.

Environment: MS SharePoint, MS Project, SAS Enterprise Guide 6.1-9.4, SQL, MS Outlook, SQL Scripting, IBM Rational ClearQuest 7.1, Teradata SQL Assistant 14.

Confidential, San Francisco, CA

Systems Analyst


  • Created and managed the entire process flows and created the Requirements Traceability Matrix .
  • Reviewed UML based diagrams using Rational Rose and MS Visio for Use Cases and Activity Diagrams , for better understanding of the layout of the new process.
  • Reviewed requirements and participated in database design and development as well as testing plan co-development and quality assurance.
  • Extracted data from Oracle database and used extensive ad-hoc queries (SQL) to create/modify/delete data .
  • Was responsible for execution of batch jobs and validation of backend batch job’s status using command line from Unix Shell and Autosys. Prepared test cases for functional and regression testing of UI web-based application .
  • Developed test cases in test plan and test sets in test lab of HP Quality Center and worked extensively with mainframe to modify QA test data to create test scenarios.
  • Involved in conducting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT) . Provided analysis and insight to QA Team in defects and bugs tracking.
  • Performed component upgrade documentation and testing of new check scanners and its integration with various windows OS and web browsers.
  • Performed testing for DP alerts templates for content migration from Documentum to Tridion under CMS Alerts Migration Project.
  • Used IBM Rational ClearQuest to open and track defects found during functional and regression testing.
  • Worked with web designers to approve UI prototypes that were presented to the client business team and navigation experts.
  • Followed the functional and business requirements by leading JAD sessions and participatory Design Sessions involving major leads from the Technical Department.

Environment: MS SharePoint, MS Project Plan, MS Access, MS Visio, SQL, Lotus Notes, SQL Scripting, HP ALM Quality Center 11, IBM Rational ClearQuest 7.1, Oracle SQL Developer 3.2.

Confidential, Oakland, CA

Business Systems Analyst


  • Worked with business and technical team to review health insurance products’ features and define customer acceptance criteria. Interacted with Third-Party Administrators (TPAs) for administrative support and outside vendors for insurance cards and welcome books.
  • Implemented Self-Funding (SF) program for new clients and facilitate Self-Funding health insurance to old customers and monitored SF program implementation project for seven new customers and provide updates in daily meetings.
  • Updated project timelines every day for new clients using Microsoft Visio and publish project progress, monitoring stats and history, issues and lessons learned on MS SharePoint website. Also, managed Technology and Services Management (TSM) teams’ SharePoint website and create cross-walk tables for each client to define the relationship between KP and TPAs.
  • Created Dashboard for SharePoint website using Crystal Reports to report trends in technical issues by regions, clients and issue types. Report also prepared for dynamic trends in technical issues with time.
  • Used Crystal Reports to develop reports for technical partners, business partners and other stakeholders.
  • Implemented basic SQL queries in SSRS to test and report data validation in order to identify scalability of project at every level of organization.
  • Used SSAS to conduct analysis of the existing systems by slicing and dicing the data to implement the reporting requirements.
  • Attended JAD sessions with financial budgeting team and other developers for enhancing the project needs.
  • Used and maintained Cognos TM1 cubes and custom built hierarchies for Cognos financial Reporting.
  • Worked closely with the managers for enhancing the reporting needs as an output from IBM Cognos TM1.
  • Assigned Medical Record Numbers (MRNs) to new members and processed missing MRNs everyday with the help of regional teams. Provided assistance in processing monthly provider files from TPA to middleware to regional team. Processed claims-paid and denial reports monthly and authorization reconciliation reports weekly using SQL, MS Access and MS Excel .
  • Worked for all five tracks (infrastructure, provider, membership, accumulation and case installation) of SF production issues. Identified technology services management issues, found root causes and prepare lessons learned logs on SharePoint website. Worked with business & technical team and outside vendors to resolve health service providers’ issues in production.
  • Served as a subject matter expert (SME) for the provider track of the work flow of SF program. Participated and hosted daily live and online SF progress and issues resolution meetings. Developed dashboard on SharePoint website to show technical issues’ trends categorized by clients, issue types and regions.
  • Represented various projects in Change Control Board (CCB) meetings and worked with Change Acceptance Board (CAB) for production approvals and deployments. Analyzed and worked around the project validation plans and conducted multiple walkthroughs before the signoff of the documents.

Environment: MS SharePoint, SAP Business One 8.8, MS Project Plan, Crystal Reports 2011, IBM Cognos TM1 9.5, MS Access, MS Visio, SQL, Lotus Notes, SQL Scripting.

Confidential, Franklin Lakes, NJ

Business Systems Analyst


  • Managed requirements from system users and prepared business requirement documents using Rational Requisite Pro .
  • Used best practices for IBM Cognos TM1 for creating dimensions, cubes in TI process (ordering, indexing, loading the data in cubes and naming convention).
  • Understood the multidimensionality of the data for designing DMR models in Cognos TM1 8 .
  • Designed dimensions and cubes in Cognos TM1 by analyzing and identifying different data sources.
  • Designed and developed numerous documentations based on Capability Maturity Model Integration (CMMI) model & Six Sigma standard. Also applied CMMI standards to help set process-improvement objectives and priorities, improve processes, and provide guidance for ensuring stable, capable, mature processes and to serve as a guide for improvement of organizational processes.
  • Reviewed numerous Business Requirement documents and converted those into use cases, functional & system requirement specifications so that developers can understand the business process and rules according to their perspective.
  • Some of the Business & Functional requirement document I created and reviewed includes but not limited to: defining business rules for calculations of member balances before and after sun-setting current application; True Up Process: Designing Audit File, Accounting Adjustment File, Refund & Write-off File; Invoice Validation process & workflow; Payment History files transfers process & workflow; Billing Profile for Members and Clients process & workflow; defining Retro-active Adjustment Processes; CMS historical payment files.
  • Defined and developed requirements for Banking pre-registration file, remittance file, Lockbox, Credit Card & ACH/EFT Processes, Banking Customer Service Interactive Voice Recognition (IVR), Non-Sufficient Funds (NSF), Cash Reconciliation, Member communication letters, delinquency letters, and Invoice samples.
  • Created different Standard Operating Procedures (SOPs), policies and workflows.
  • Analyzed and developed business and functional requirements for the Financial Client Reporting website and including Med D Banking Payment Option for the members & Clients in the Medco Home Page.
  • Performed the Data Analysis for Data staging & Teradata Database design for the To-Be reporting system. Created Data Mapping specs for different source system including IBM Mainframe system, Teradata, and Data Warehouse to target system, share drive, access database and application.
  • Designed and created different Reporting Metrics identifying the file, delivery method, format, and delivery schedule. Created & designed the different requirement document and data modeling documents to stage all the daily and month end reports and extracts expected to be received from the new vendors into the mainframe servers and loading it to the Teradata database and to the individual share drives.
  • Was responsible for researching and reviewing functional specification documents for custom Lotus Notes database projects.

Environment: Requisite Pro, MS Project Plan, SAP Business One 8.8, Teradata, IBM Cognos TM1 8.4, UML, SQL, Oracle 10g, SQL Scripting.

Confidential, New York, NY

Business Systems Analyst


  • Actively participated in defining Scope of Project, gathered business requirements, and documented them following Unified Modeling Language .
  • Extensively involved in implementation of effective requirements practices, including gathering User Requirements, and analyzing User Requirement Document (URD), and functional specification document (FSD), use and continuous improvement of a requirement gathering processes.
  • Applied RUP methodology with its various workflows, artifacts and activities to manage life cycle from Inception to Transition phase.
  • Acted as liaison between external clients and SMEs to generate and standardize product requirements specification documents such as URS/FRS/Use Cases.
  • Employed UML methodology in creating UML Diagrams such as Use Cases, Sequence Diagrams, State Diagrams, Activity Diagrams and business process and workflows.
  • Assisted JAD sessions to identify the business flows and determine whether the EDI X12 Transaction, Code set and Identifier aspects of HIPAA, impacts any current or proposed systems.
  • Involved in GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 835, and 837 (P.I.D) to identify key data set elements for designated record set.
  • Involved in designing & determined 3-tier architecture for the claim processing system. Assisted team lead in developing Requirements Traceability Matrix (RTM) to trace the relationship between business and functional requirements to test cases.
  • Involved in conducting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT) . Provided analysis and insight to QA Team in defects and bugs tracking.
  • Led JAD sessions with important stakeholders to hash out the conflicting and unnecessary business requirements.
  • Reviewed and followed System Analysis document worked to secure vendors to develop and implement system conversion and wrote Request for Proposals (RFPs).

Environment: HTML, UML, AJAX, Microsoft Visio, QTP, SQL, MS Project Plan and CSS.

  • Master of Science, Stanford University, Stanford, CA
  • Bachelor of Technology, IIT Bombay, India

Hire Now