Systems Analyst Resume
Milwaukee, WI
SUMMARY
- Extensive Experience in Information Technology with Business Analysis, System Analysis & Technical Writing in HealthCare, Salesforce, E commerce, Finance and Pharmaceutical Environments.
- Extensive knowledge of Software Development Life Cycle (SDLC) methodologies like Agile, Waterfall, RUP and having through understanding of various phases like Requirements, Analysis, Design, Development and Testing.
- Extensive experience working with MS office suite including Word, Excel, Visio, Power point, Project, outlook, publisher and Access.
- Expertize include Creating Business Requirements Documents (BRD), Functional/Technical requirement document (FRD/TRD), Change requests, Use Cases, RFP’s, Business Systems Design and Requirements Traceability Matrix (RTM), Agile User stories.
- Experience in effective project management techniques and creating project plan, project budget, tracking project milestones and resource allocation for senior management reporting.
- Designing business models using UML diagrams - Sequence Diagrams, Activity Diagrams, Process flow Diagrams and Data Flow Diagram using MS Visio and Rational Rose.
- Extensive experience writing SQL and Access queries for data extraction and Access and identity management.
- Knowledge of Web services, Drug Formulary and Sales force, Pharmaceutical experience.
- Possess good knowledge Salesforce, Medicare, Medicaid and regulatory standards such as HIPAA, X12, HL7.
- Strong Technical writing skills for Validation Deliverables such as Quality Assurance Plan (QAP), Validation Strategy Document, Requirement Specifications, Design Specifications, Standard Operating Procedures (SOP), Traceability Matrix (RTM), Qualification Protocols (IQ, OQ, PQ) and Validation Summary Report.
- Extensive experience documenting User manuals, Training materials, FAQ’s and Standard operating procedures (SOP).
- Knowledge of Web services, SOA, JIRA, SQL, Sales force, AS 400, PLSQL, BI tools like Cognos.
- Experience in designing test plans, defining test cases, developing and maintaining test scripts, analyzing bugs and interacting with development team members in fixing the defects.
- Hands on experience in ScriptMed™ and ScriptMed™ 6.0.
TECHNICAL SKILLS
Regulations: HIPAA, X12 (EDI), FDA guideline.
OS: HP-UNIX, Windows 95/98/NT/XP
Applications: Microsoft FrontPage XP, Cognos, Scriptmed, Sales force, E rooms, AS 400, Microsoft IIS, HTML, XML, UML, SQL, Facets, Adobe suite
Testing Tools: HP Quality Center, HP ALM, Quick Test Professional, Load Runner, Test Director
Databases: Microsoft Access and MS SQL Server, Relational database, Relational database Management systems (RDBMS), Teradata database
Content Management: Documentum, eRoom, SharePoint, Filenet, Clear Case, JIRA
PROFESSIONAL EXPERIENCE
Confidential, Milwaukee WI
Systems Analyst
Responsibilities:
- Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
- Worked on various SalesForce.com Standard objects such as Accounts, Contacts, Leads, Campaigns, Reports and Opportunities.
- Updated data from onsite and offsite applications using Cast Iron tools to manage Sales leads and opportunities.
- Used MS Project, and developed a project collaboration platform (E rooms) as a toolkit to store project schedules, requirement documents, test plans and requirement documents for sharing purposes, using E rooms.
- Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts and Field Updates to manage the Workflow & Approvals.
- Performed Data Mapping, Identifying the fields Preparation of Data Dictionary/Meta Data of the data elements.
- Created the ETL data mapping documents between source systems and the target systems for the Integrations.
- Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager, Development Lead, Data Modeler, Data Mapper, Architect etc.
- Performed Data Analysis to primarily identify Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
- Analyzed the databases that are proposed to sunset.
Confidential, Tampa FL
Business Systems Analyst
Responsibilities:
- Participating interviews with Process Owners, Business groups and Functional Heads to gather functional information and facilitated meetings to understand the business process.
- Mainly gathered requirements for the IOWA and GOERGIA rebid process.
- Worked on the enrollment, Provider, Communications and Correspondence sections and also scheduled client meetings.
- Provided ongoing Salesforce.com maintenance and administration services including periodic cleansing, custom objects and workflows.
- Implemented Security access to the user profiles by creating Object level security, field level security and record level security.
- Experience in using Apex Data Loader for various data related operations like data inserting, deleting, and exporting.
- Analyzed the Scope of the Requirements, and managed requirements to avoid Scope Creep.
- Assist with management of day-to-day SFDC end user support cases, resolving cases in an efficient way.
- Extensively used SharePoint for maintaining the project status and store the Project deliverables.
- Played an active role in gathering, analyzing and documenting the business requirements and creating BRD
- Brain storming sessions with the Business Group and Technology Group to eliminate “to be nice” requirements from the BRD and facilitate clear understanding of the user specifics.
- Facilitating Joint Resource Planning and Joint Application Designing (JAD) sessions for clear understanding of the responsibilities
- Coordinating with QA Team members to explain and develop the Test Plans, Test cases, Test and Evaluation strategy and methods for unit testing, functional testing and usability testing.
- Checking the integrity of the newly added features and their effect to the existing ones with regression testing and integrity testing
- Organizing UAT meetings, gathering test data from test data management team Checking for ‘release gating’ issues and conveying back to developers for rectification.
Confidential, Deer field IL
Responsibilities:
- Performed Joint Application development (JAD) techniques, Brainstorming and one on one interviews for requirement gathering.
- Gathered requirements from Business and documented in the Business Requirement Document, Functional Requirement Document.
- Effectively involved in ScriptMed deliverables, components include design, development, quality assurance, documentation.
- Managed business reporting requirements using tools with Cognos.
- Actively participated in daily Scrum meetings to prioritize and track the Sprint backlog items and reported BI requirements using Cognos.
- Worked with Technical SME’s and IT lead to get their input on Business requirements and converted them into Technical requirements and BI reporting using Cognos.
- Responsible for Data manipulation and worked on MS Visio, MS SharePoint, Web services.
- Developed User stories, Test Plan and Test Cases/Test Scripts and also performed defect tracking on HP Quality Center.
- Act as a resource in understanding how is carry out business functions and assists in ensuring the timely and effective implementation and worked on BI reporting by IBM Cognos.
- Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and plans accordingly and client development standards and SOX compliance
- Created a dashboard for formatted reports and generated Ad hoc reports, when requested by the business team.
- Effectively managed Defect coordination & Triage process, by performing thorough Root cause analysis on defects to appropriately manage, assign and close them.
- Created Test cases and worked on Defects using HP ALM.
Confidential, Lincoln NE
Sr. Business Analyst
Responsibilities:
- Involved in performing GAP analysis between the current and Future state using MS Visio
- Involved in documenting Technical requirements, reviewing them with IT and facilitating approvals.
- Conducted walkthroughs of all completed specifications with the team to make sure the documentation is complete and development estimates are accurate.
- Served as the main liaison between Business users and Development staff to ensure that all requirements are completed as per the schedule and user stories communicating business requirement changes to the business users and client development standards and SOAP compliance
- Created project plan, track project deliverables and created flow charts using MS Visio.
- Provided effective project management by presenting project status to the project core team and third party vendor on weekly basis using MS PowerPoint in conjunction with the project manager.
- Developed and maintained project issues and risk log, and reported the same to senior management on weekly basis.
- Worked to develop the User stories for future references and audit purpose
- Mainly worked on different mainframe screens like Provider Eligibility, Recipient Eligibility, Claims data entry UB04.
- Created and maintained an online project document repository using SharePoint
- Worked on the electronic Claims creations in HIPAA file viewer.
- Developed Standard Operating Procedures (SOPs), User Training Materials, User Access guides, Online help, end user guides and FAQ’s for customer service and Claims operations and Claims imaging/OCR end users and worked on Web services.
- Worked on writing SQL queries for data extraction and reporting purposes.
- Coordinate with QA Testers to schedule testing, gain access to systems for remote testers, and ensure testing is documented per quality standards/templates.
- Performed Root-Cause analysis for any defects that were reported during testing and assigned to the appropriate party for effective defect triage and coordination.
- Assisted in Unit, Integration, and Regression testing for the developed features of the system.
- Interacted with developers and various members of team to discuss and resolve defects arose during the UAT execution with the help of ClearQuest
Confidential, NJ
Sr. Business Analyst
Responsibilities:
- Performed extensive analysis on system's 'As Is' and 'To be' flow to build the User Requirements Specification.
- Performed GAP analysis for ICD-9 to ICD-10 migration for client development standards and SOX compliance
- Participated in ICD-9 to ICD-10 General Equivalence Mapping (GEM).
- Documented business rules for maintaining financial neutrality between ICD-9 and ICD-10 codes.
- Developed scrum artifacts such as User Stories, Product Backlog, Sprint Backlog and Sprint Burn down chart.
- Facilitated Sprint planning meetings and developed Sprint backlog based on inputs received from the meeting.
- Performed GAP analysis to identify and measure details in current business process and the future business process in conjunction with Subject Matter Experts (SME’s)
- Performed JAD sessions and interviews with the vendor, to understand their system and created flowcharts, activity diagrams using MS Visio.
- Created Use Cases and BRD then converted them into FRD/TRD using Rational RequisitePro
- Uploaded project documents on Sharepoint. Maintained document versioning and approval process via Sharepoint.
- Developed UML artifacts such as Activity diagram, Class diagram, Process flow diagram, Data flow and Swim lane diagrams.
- Worked on Advance Loan System and mortgage, developed process for Reconciliation of General Ledger for all proceed transactions across all the municipalities of the State on Web services.
- Documented and created Business flow for Business processing of BtoC and CtoB and Guidewire Suite.
- Worked on Gathering and documenting PCI regulations and requirements for credit card payments.
- Worked to develop the Requirement Traceability Matrix (RTM) for Access management and Identity management.
- Build the organization's role hierarchy by adding the Roles as per the organization structure and created custom profiles to satisfy the organization's hierarchy.
- Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts and Field Updates to manage the Workflow & Approvals.
- Worked on various Salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports. Prepared high quality process documentation, and business Requirement document (BRD).
- Involved in documenting User manuals, training materials, and online help User Access Guides, FAQ’s, End User guides, Statement of Work (SOW) and Standard operating procedures (SOP).
- Wrote business rules, worked with Business Intelligence professional and Sr. data architect for successful application of the business rules to the business processes
- Prepared and delivered business/system/functional requirements documents, Created requirements traceability matrix using business requirements document, Functional design document and technical design document.
Confidential, TX
Sr. Business Analyst
Responsibilities:
- Developed artifacts of Unified Modeling Language (UML) such as Activity diagram, Sequence Diagram, Process flow diagrams by using MS Visio and wrote User stories.
- Performed GAP analysis to identify and measure details in current business process and the future functional requirements of revenue report output in conjunction with Subject Matter Experts (SME’s).
- Conducted JAD sessions and Brainstorming sessions with cross functional teams and one on one interview with SME’s to elicit Business requirements.
- Created Project plan, project budget and actively tracked project milestones.
- Prepared RTM (Requirement Traceability Matrix) to link all Business requirements with Technical Requirements and Test scripts on Web services.
- Worked on Cryptography, CMP and SOA for Insurance Division and created diagrams using MS Visio
- Contributed in developing Standard operation procedure (SOP’s), Statement of Work (SOW), End User manuals, Statement of Work (SOW) and training materials for system operations.
- Drafted the Remediation Plan for the Project Management approval after Gap Analysis.
- Created Test Cases and Test Scenario’s for Unit, Integration and UAT testing.
- Managed, assigned and resolved defects from Unit and UAT testing.
Confidential, WI
Business Analyst
Responsibilities:
- Involved in gathering and synthesizing business requirements and translated into functional and non-functional requirements to be used as input to the functional design specifications.
- Designed and developed all Use cases and UML models using MS Visio for client development standards SOX compliance
- Provided technical assistance in identifying, evaluating and developing systems and procedures that were cost effective and met business requirements.
- Collected and documented business processes as well as business rules. Conducted meetings and workshops to discuss high level requirements and developed User Requirement specification Document (URD).
- Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation.
- Wrote use case specifications and designed artifacts like UML diagrams (Use Case, Activity, and Sequence Diagrams).
- Prepared Sequence Diagrams, Activity Diagrams and Agile User stories.
- Responsible for creating and maintaining functional design document and deployment plan documents.
- Facilitated and organized different meetings, planned meetings and stakeholders for web services and Access management.
- Played a key role in the planning, testing, and implementation of system enhancements and conversations.
- Conducted User Acceptance Testing and Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements.
- Designed and implemented basic SQL queries for QA testing and report /data validation.
Confidential
Business Analyst
Responsibilities:
- Performed extensive analysis on system's 'As is' and 'To be' status to build the Requirement Specification.
- Created complex Use Cases, BRD’s, FRD’s and client development standards and SOX compliance.
- Business Processes and Work Flow Diagrams using MS Visio.
- Worked extensively with IT team for developing and documenting Technical Requirements for the implementation.
- Prepared RTM (Requirement Traceability Matrix) using HP Quality Center to link all requirements with Test scripts.
- Created Project plan, Cost benefit analysis, risks and tracked critical project milestones effectively and reported them to management on weekly basis.
- Also created and maintained project budget and resource allocation reports.
- Developed UAT scripts for the system and performed dry run to find out the issues in system workflow
- Facilitated User Acceptance Testing (UAT) for different modules of Life Insurance.
- Active participation in creating system User Access Guides, Training materials, FAQ’s, Statement of Work (SOW) and End Users manuals.
- Identified opportunities for improvement such as updating SOPs, creating templates and modifying defect tracking cycle.
Confidential
Business Analyst/ QA
Responsibilities:
- Identified opportunities for business process improvement and initiated efforts to make improvement and documented BRD.
- Conducted meetings for gathering requirements from Business Users of different departments in JAD sessions for understanding the functionality of the Business.
- Conducted Workflow and GAP analysis to derive requirements for existing systems enhancements.
- Served as primary contact with Subject Matter Experts and the champion of their needs across the SDLC.
- Studied project planning and business process and analyzed existing procedures and reported them to management to improve productivity.
- Interacted with users for verifying User Requirements, managing change control Process, Updating existing Documentation.
- Prepared graphical depictions of Use cases, Use case diagrams, State diagrams, Activity diagrams, Sequence diagrams and creation of technical design using MS Visio.
- Worked on RTM, documented Test cases, test scripts and used HP ALM.
- Interacted with the QA team to conduct system testing, Functional testing and integration testing on the application.