We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

SUMMARY OF QUALIFICATIONS:

  • Progressive fourteen plus years of hands-on experience interfacing with clients as a Business Analyst, designing and implementing e-business and marketing solutions and managing multiple projects simultaneously.
  • Extensive business analysis experience this includes leading requirements analysis and gathering from users/stakeholders, document analysis, process observation, and documentation efforts, project timeline, business case, strategy mapping, benchmarking, scheduling and facilitating joint application requirements JAR gathering sessions, business process flows and rules, cost and benefit analysis of automating processes, RACIs, project plans, financial analytics, gap analysis, risk and constraints assessment, solution alternative analysis, concept description, technical blue prints, UML diagramming / visual modeling, scenario analysis, wire framing, application interface specifications, user training, presentations, and reference materials.
  • Experienced in constructing IT proposals based on identified needs of the organization/clients
  • Strong in full Software Development Life Cycle SDLC , Rational Unified Process RUP , Iterative Process, Agile Development Methodologies Scrum , Six Sigma/LEAN methodology, Project Management Office PMO , Project Management Methodologies PMM , and keep track of change managements tickets and project's releases.
  • Efficiently leveraged MS SharePoint for Project Management success.
  • Five years of experience in configuring and filtering CRM tools to meet the needs of Marketing Customer Service, and Sales organization's mission.
  • Experienced working with onshore and offshore technical and quality assurance teams on designing, testing, and implementing system changes.
  • Experienced in supporting Data Warehousing through the use of strong SQL skills, data mapping, data profiling, data modeling, data mining, Online Analytical Process OLAP and Extract Transform and Load ETL utilities.
  • Experienced working with XML files with exposure on troubleshooting of integration issues.
  • Expert in developing detailed QA and UAT Master Plans, test cases, test scripts, system testing, prepare training materials, and performing user training.
  • Strong in creating and editing complex reports, statistics, dashboard, graphs and presentation for critical business management decision making and continuous business process improvement.
  • Excellent in management, business, leadership, written and oral communication skills
  • Experienced in performing managerial task such as project planning, budgeting, scooping, delegating of task, writing and delivering performance reviews, setting salary and bonus, and assisting subordinate employees with career development.
  • Experienced in working with project team members to translate the high-level Business Requirements into Functional and Non-Functional Requirements.
  • Carry out end-to-end business analysis and map stakeholder's/user's requirements to the features in the software product set.
  • Strong knowledge of generally accepted accounting principles based on Sarbanes-Oxley guidelines.
  • Possesses the ability to work independently, organize work effectively and take initiative in fast-paced work environment while managing multiple tasks and deliverables simultaneously.

WORK EXPERIENCE:

Confidential

Consultant Sr. Business Systems Analyst

  • Joined with the Pharmacy Finance for re-engineering of the Outpatient Pharmacy Data Warehouse. Performed analysis of business and user needs from their user stories or developed user stories from their service request, in order to develop functional requirements document to data mine receivables for the Data Mart initiatives of Claims/Billable Events project. Was responsible for coordinating and overseeing work with multiple third party Revenue Cycle Management vendors for Claims/Billable Events transactions.
  • Added new entity for created filtered lists of MS Dynamics CRM data in the .Net platform such as targeted outpatient pharmacy accounts that were considered billable and generated account receivable aging report on a monthly basis.
  • Created a sequential workflow that associates tasks in the SharePoint Task list in document library.
  • Participated in the implementation of Electronic Medical Records EMR and Electronic Health Records EHR software platform to utilized HL7 and business intelligence in the improvement of digital collection of patient health information to effectively capture patient's chart and demographics, progress notes, problems, medications, vital signs, past medical history, immunizations, laboratory data, and radiology reports.
  • Utilized expertise in health care, data exchange via HL7 format, data integration of different sources such as XML, test files, MS Access accdb, etc. , data analytics, data modeling, and data warehousing, and understanding of the organization's systems and capabilities to ensure the most efficient use of resources.
  • Performed analysis and designs of new format of membership notifications for eligibility notification for the Low-Income Subsidy LIS beneficiaries for both dual-eligible and non-dual-eligible individuals, and beneficiary attestation of creditable prescription drug coverage to ensure CMS compliance with format, accuracy, and QA of output. Worked with the Core compliance to determine guidance impact on member notification request.
  • Worked in conjunction with the business users and development teams, was responsible for the creation and execution of application test scripts, scenarios, and test plans that validated initial business requirements.
  • Participated in the analysis and design to modify Claims application, General Ledger, and Accounts Receivable to improve Revenue Cycle Management processes and to comply with the version 5010 of the HIPAA EDI standards: EDI Health Care Claim Payment and Advice Transaction set 835 EDI Health Care Claim Transaction set 837P 837I 837D and NCPDP D.0 for retail pharmacies EDI Health Care Claim Status Notification 277 .
  • Collaborated with cross functional team to improve Revenue Cycle Management processes and for the conversion of ICD-9 coding system for diagnostic code CM and procedural coding system PCS to its respective ICD-10 codes plus additional ICD-10 codes which need to be added and defined in the look-up table.
  • Environment: IBM z/OS, IBM System i5/OS, IBM Rational Software Delivery Platform, RUP, UML, Business Processes, SDLC, Agile Scrum, PMO standards and practices, Microsoft Dynamics CRM 2010, J2EE, SOA, SOAP, XML, WSDL, HTTPS, CA ERwin Data Modeler R9.2, EPIC software platform, SAS SQL Procedure 9.3,SAS Macro Language 9.3, SAS/IML 9.3, MS SharePoint, MS Project, MS Access, MS Visio, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, Informatica 9.5, Business Objects XI, Crystal Reports, Hyperion, Oracle 10, Toad for Oracle 12.5, VS Team Foundation Server, MS SQL Server 2008 2010, SSRS, SSIS, BIDS, SSMS, stored procedures, triggers and functions, MicroStrategy, HP Quality Center 11,HL7, SFTP, FTPS, AS2 protocols.

Confidential

Consultant Business Analyst

  • Served as Key Personnel in providing functional and technical support for the deployment of California Court Case Management System CCMS including data integration and data exchange services of 58 superior courts with justice partners statewide and developing business requirements, user stories and acceptance criteria, business models, created and managed Proof of Concept POC , and led the development of functional and technical requirements for electronic filing of case in compliance with PMO's standards, practices, and methodologies.
  • Created Request for Information RFI and sent to E-Filing Service Providers. Conducted extensive assessment and analysis of E-FSPs e-filing capabilities and the needs of several trial courts, and drafted a feasible statewide e-filing solution architecture leveraging/repackaging CCMS functional components and technology and in collaboration with trial courts and Electronic Filing Service Providers or EFSPs.
  • Created Request for Proposal RFP and distributed them to prospective EFSPs in an effort to build a consortium of EFSPs. Was responsible for project communication and outreach with vendors, courts, attorneys, justice partners and others.
  • Efficiently stored project artifacts into SharePoint Shared libraries to centralize and managed relevant project's information, schedules, documents, change request, risk, constraints, issues, and budget.
  • Documented e-filing functional, technical, E-Filing service roadmaps with its network and server architecture, connectivity standards and requirements in addition to statewide e-filing master services contract and others relevant to a statewide e-filing solution.
  • Analyzed, developed, and implemented new procedures and methodologies or enhances existing items, related to the success of the projects and ongoing, and kept track of change managements tickets and project's releases.
  • Environment: IBM z/OS, IBM System i5/OS, WebSphere MQ Series, IBM Blueworks Live Business Process Modeler, SDLC, Agile Development Methodologies Scrum , Axure RP UI UX Wireframing kit , HTML, ER Studio, PMO standards and practices, Six Sigma, J2EE, SOA, SOAP, XML, WSDL, HTTPS, MS SharePoint, MS Project, MS Access, MS Visio, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, Business Objects XI, Crystal Reports, Oracle 10, Toad for Oracle 12.1, VS Team Foundation Server, MS SQL Server 2008 2010, SSRS, SSIS, BIDS, SSMS, Apple iOS 5.0, stored procedures, triggers and functions, HP Quality Center 11, Teradata.

Confidential

Consultant Business Systems Analyst /Team Lead

  • Joined with the Customer Billing Information team for the smooth transition of Customer Account Information from Fujitsu Consulting to Amdocs by capturing all Knowledge Transfer KT , Forward Shadow FS , Reverse Shadow RS , and Stable State SS sessions and prepared System Appreciation Document. Was responsible for CMM V Project Lead with the budget of 2.5M with duration of 8 months which was completed for six months with a savings of 0.625M.
  • Performed project lead task such as identifying stakeholders, selecting project team, scooping, risk and constraints management plan, wrote Statement of Work. Developed WBS Work Breakdown Structure , scheduled tasks through Gantt Chart, prepared budget proposal, procurement, developed Project Management Plan. Led project execution managed cost, scoop, schedule, and quality managed project issues change control process deliverables acceptance and implementation. Managed project closeout, turnover to operations, documented lessons learned, and archived project documents and artifacts. Wrote and delivered performance reviews of the team members.
  • Performed data modeling, data mapping, data profiling, data flow diagrams, ETL, data mining, data mart, in support of the data integration and data warehousing initiatives. Performed Business Requirements analysis and gathering, created user stories and acceptance criteria, storyboard designing, wire framing, developed functional requirements, and technical requirements.
  • Leveraged SharePoint to generate the interactive summary of the projects, project task information, automated alerts, dashboards, Key Performance Indicator Red, Amber, Green status indicator.
  • Configured and administered MS Dynamics CRM modules of Call Center's tools to establish business rules for routing media configured and managed queuing features. Created filtered lists of CRM data such as targeted customer accounts, prospects not contacted in four months, customers with specific products, and can then be leveraged these views to better interact with customers.
  • Developed UAT Master Plans, test scripts, test requirements, conducted system testing, prepared training materials and user training and management presentation, and maintained system documentation. Provided regular status reports to IT management and business community published meeting minutes and maintained project plans.

Environment: IBM z/OS, IBM System i5/OS, WebSphere MQ Series, IBM WebSphere Business Process Modeler V7.0, Agile Development Methodologies Scrum , Dreamweaver 11.0, HTML, PMO standards and practices, Axure RP UI UX Wireframing kit , Six Sigma, J2EE, SOA, SOAP, XML, WSDL, HTTPS, JCAPS, WebEx, Teleconference Bridge, SDLC, Microsoft Dynamics CRM 4.0 and 2011, MS SharePoint, BizTalk, MS Project, MS Access, MS Visio, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, CA Clarity PPM, CA ERwin Data Modeler 8, IBM Cognos 8, Business Objects XI, Crystal Reports, Oracle 10, Toad for Oracle 12.1, VS Oracle E-Business Suite Service and Marketing components , Team Foundation Server, Informatica, MicroStrategy, MS SQL Server 2008 2010, SSRS, SSIS, BIDS, SSMS, Apple iOS 4.3, HP Quality Center 10, SCLM, COBOL, CICS, IMS, DB2, SQL, QMF, SPUFI, stored procedures, triggers and functions, Workbench, Project Control Book.

Confidential

Consultant Business Systems Analyst/ Team Lead

  • Joined with the re-engineering of Vehicle Distribution and Ordering Systems. Appointed by Interactive Marketing Group to develop core models named Sales Lead Processing Engine and Sales Lead Governance Engine a Rules-Based Engine for the Sales Lead Delivery System. Created and managed Proof of Concept POC . Was responsible for CMM V Project Analysis Lead with the budget of 3.8M with duration of one and half year which was completed for one year and four months with a savings of 0.75M.
  • Performed project lead task such as identifying stakeholders, selecting project team scooping, risk and constraints management plan, wrote Project Charter. Developed WBS, scheduled tasks through MS Project's Gantt Chart, prepared budget proposal, procurement, developed project management plan. Led project execution managed cost, scoop, schedule, and quality managed project issues change control process deliverables acceptance and implementation. Managed project closeout, turnover to operations, documented lessons learned, transition checklist, and archived project documents and artifacts. Wrote and delivered performance reviews of the team members.
  • Created Request for Information RFI and sent to sales lead aggregators such as e-Loyalty, Cars.com, etc. Created Request for Proposal RFP and distributed them to prospective leads aggregator in an effort to who should we officially awarded the contract of providing us the aggregated sales leads from internet source.
  • Performed requirement analysis and gathering. Developed user stories and acceptance criteria, Functional Requirements Document for Leads to Sales Comparison Report Dealer Performance Report and Subscription State Dealer Pricing. Wrote Business Requirement for Subscription State Dealer Pricing Documents, Dealer Billing Statement, and Supply Chain Management.
  • Developed Use Cases, Activity Workflow, and Business Process Modeling, simulation, and analysis for Sales Lead Processing and Sales Lead Governance engines. Performed data modeling, ETL, data mart, data profiling, data mapping and data flow diagrams in support of Data Warehousing and Data Store initiatives.
  • Created and edited complex reports, statistics, graphs and presentation. Created service roadmaps with its network and server architecture, and connectivity standards and requirements.
  • Leveraged SharePoint to facilitate Project information collaboration, maintained project artifacts in shared libraries, jointly developed documents with document workspaces, requirement clarification with discussion boards, initiated meeting artifacts with meeting workspaces.
  • Customized MS Dynamics CRM online to include a drop-down menu that enables call center agents to select specific government codes for TREAD Transportation Recall Enhancement, Accountability and Documentation Act reports and associated that with a customer and support ticket. Created filtered lists of CRM data such as customer history, customer vehicle information, and issues raised, entering detailed notes so that other agents can have a comprehensive view in future interactions with the customer.

Environment: IBM z/OS, IBM System i5/OS, IBM Rational Software Delivery Platform, Eclipse 3.2, SOA, XML, SOAP, HTML, Axure RP UI UX Wireframing kit , MS Dynamics CRM 4.0, MS SharePoint, MS Project, MS Access, Oracle 10, MS SQL, Oracle E-Business Suite Service and Marketing components , BizTalk, MS Visio, MS PowerPoint, MS Word, MS Excel, Adobe Photoshop, Dreamweaver 9.0, ERwin Data Modeler 7, Business Objects XI, Crystal Reports, IBM Cognos 8, SSRS, SSIS, Data Transformation Services, UML, IBM WebSphere Business Process Modeler V6.2, IBM Rational ClearCase V 6, IBM Rational ClearQuest V 6, RAD development methodology, Iterative Development Life Cycle, Agile Development Methodologies Scrum , Six Sigma, SOX, Logility Voyager Solutions V 6.2, ERD, MicroStrategy V8, Informatica, Teradata, Mercury Quality Center 8, OLAP and ETL, COBOL, CICS DB2, SQL, QMF, stored procedures, triggers and functions.

Confidential

Consultant Sr. Business Analyst

  • Joined with Core System Integration group in the analysis and development of integrating Wellpoint's Star Membership System with the Wisconsin's Membership System. Star Membership System processes Claims, Benefits, and Eligibility, Billings, Receivables, Worker's Compensation, financial reporting, and Underwritings transactions together in compliance with Medicare Modernization Act 2003 MMA and with Centers for Medicare Medicaid Services CMS that provides direction and technical guidance for administration of Federal effort to plan, develop, manage, and evaluate health care financing programs and policies. Was responsible for coordinating and overseeing work with multiple third party revenue cycle management vendors.
  • Devised and documented Functional and Non-Functional Requirements based on the client's business requirements by identifying business needs and the costs and benefits of implementing computing solution in compliance with HIPAA requirements including the maintenance of ICD-9 coding system for diagnostic code ICD-9-CM and procedural coding system ICD-9-PCS , ANSI X12 Transaction Set 4010, and NCPDP Data Interchange Standards for the pharmacy services.
  • Performed analysis and designs of new format of membership notifications for Late Payment Notification LEP , eligibility notification for the Low-Income Subsidy LIS beneficiaries for both dual-eligible and non-dual-eligible individuals, and beneficiary attestation of creditable prescription drug coverage to ensure CMS compliance with format, accuracy, and QA of output. Worked with the Core compliance to determine guidance impact on member notification request.
  • Participated in the analysis and design to modify Claims application, General Ledger, and Accounts Receivable to improve Revenue Cycle Management processes and to comply with the new mandate for: EDI Health Care Claim Payment and Advice Transaction set 835 EDI Health Care Claim Transaction set 837 EDI Health Care Claim Status Notification 277 .
  • Performed Business Requirements gathering, gap analysis, developed performance metrics and ad-hoc analysis, business process modeling, use cases, activity diagram, Simulation, and analysis risk assessment, storyboard designing, wire framing, data modeling, developed functional requirements, and requirements management. Performed project presentation to senior and executive level management.

Environment: IBM z/OS, UNIX, IBM WebSphere Business Process Modeling notation tool, IBM Rational Rose Tool Suite, Biztalk, and Project Management Methodology, .Net Framework, QNXT, ER Studio r7.5, Microsoft Solution Framework for Agile Development, SAS SQL Procedure 9.1,SAS Macro Language 9.1, SAS/IML 9.2, Visual Basic.Net, MS SQL, MS Access, MS Excel, VB .NET, MS Visio, MS Project, Oracle 9 10x, PL/SQL, XML, HTML, ASC X12N, DB2, SQL, QMF, Embarcadero ER/Studio, COBOL, CICS DB2, SQL, QMF, stored procedures, triggers and functions, SFTP, FTPS, AS2 protocols.

Confidential

Consultant Hands-On Project Manager

  • Managed 7 staffs to re-engineer Hospital Materials Management Systems, General Ledger, Accounts Payable, and Accounts Receivable to web enable running on IBM Mainframe for the interface processes with Pharmacy Inventory Systems running on a web based platform.
  • Performed project lead task such as identifying stakeholders, selecting project team, scooping, risk and constraints management plan, wrote Statement of Work. Developed WBS, scheduled tasks through MS Project's Gantt Chart, prepared budget proposal, procurement, developed project plan. Led project execution managed cost, scoop, schedule, and quality managed project issues change control process deliverables acceptance and implementation. Managed project closeout, turnover to operations, documented lessons learned, transition checklist, and archived project documents and artifacts. Wrote and delivered performance reviews of the team members.
  • Was responsible for CMM V Project Management with the budget of 2.2M with duration of one and half year which was completed for one year and five months with a savings of 0.12M.
  • Worked with team of Network and Data Security in implementing and debugging hacking or intrusion detection utilities and provided expertise in the monitoring and analysis companywide networks security issues.
  • Environment: IBM z/OS, System Development Life Cycle Methodology, Project Workbench, MVS Utilities, COBOL 370, Micro Focus COBOL, PL/1, IBM Assembly, CICS, CICS Transaction Gateway, TSO/ISPF, IMS DB, DB2, QMF, VSAM, DB2, Stored Procedures, Triggers, MS Project, MS Visio, MS PowerPoint, MS Access, MS Excel, VB .NET, Endeavor, CA7.

Confidential

Consultant Business Systems Analyst

  • Joined for the re-engineering of the Results Management System and Claims Processing Systems in utilizing HL7 as a standard for exchanging information between Results Management System, Claims Processing Systems and other medical applications and modified the procedure documents and Business Requirements Document to that effect. Gathered business requirements from stakeholders to build information system and constructed business models using Class Diagrams, Use Cases Diagrams, Sequence Diagrams, Communication Diagram, Deployment Diagram, Functional and Non-Functional Document Requirements.
  • Devised and documented a general system design based on the client's anticipated requirements by identifying business needs and the costs and benefits of implementing computing solution for the development of Clinical Information System improved Revenue Cycle Management processes and maintained ICD-9 coding system for diagnostic code ICD-9-CM and procedural coding system ICD-9-PCS .
  • Performed analysis and designs of new format of membership notifications for eligibility notification for the Low-Income Subsidy LIS beneficiaries for both dual-eligible and non-dual-eligible individuals, and beneficiary attestation of creditable prescription drug coverage to ensure CMS compliance with format, accuracy, and QA of output. Worked with the Core compliance to determine guidance impact on member notification request.
  • Participated in analyzing and designing new format of membership notifications as it relates to coordinating the system request and monitoring the process to ensure CMS compliance with format, accuracy, and QA of output. Worked with the Core compliance to determine guidance impact on member notification request.
  • Environment: IBM S/390, Project Management Methodology, EPIC software platform, UML MS Visio, MS Word, MS Excel, MS PowerPoint, MS Access, MS Excel, VB6, Oracle 9x, Iguana HL7 Interface engine with Chameleon Development Toolkit, JAD, PCS/ADS, MS PL/SQL, XML, ASC X12N, COBOL 370, DB2, SAS SQL Procedure 8.1,SAS Macro Language 8.1, SAS/IML 8.2, SAS STAT 8.1.

Confidential

Consultant - Business Systems Analyst

  • Performed system analysis, design and modifications of Hospital Materials Management Systems, General Ledger, Accounts Payable, and Pharmacy Inventory System for the Y2K compliance project.
  • Participated in identifying project issues that might impact to other areas. Participated in the development of test plan document and the estimation of testing efforts for product Releases.
  • Reviewed requirements, specifications and other documentation and performed functional analysis of applications and new application features. Raised issues, questions, and concerns as appropriate.
  • Environment: IBM z/OS, System Development Life Cycle Methodology, Project Workbench, MVS Utilities, RFI, RFP, RFQ, COBOL 370, Micro Focus COBOL, PL/1, IBM Assembly, CICS, CICS Transaction Gateway, TSO/ISPF, IMS DB, DB2, QMF, VSAM, DB2, Stored Procedures, Triggers, MS Project, MS Visio, MS PowerPoint, MS Access, MS Excel, VB6, Endeavor, CA7.

Senior Team Leader

Confidential

  • Coordinated, supervised and accountable for the daily activities of subordinates. Was responsible to lead the system analysis, design, and development of any new assigned application within On-line Banking System Unit. Main responsible for the system analysis on the maintenance of Plastic Card Control System, Kiting Detection System, Telephony VRU for Customer Bank Account Inquiry, and Automated Teller Machine Systems and Point of Sales terminals.
  • Performed project lead task such as identifying stakeholders, selecting project team, scooping, risk and constraints management, wrote Project Charter. Developed WBS, scheduled tasks through MS Project's Gantt Chart, prepared budget proposal, procurement, developed project plan. Led project execution managed cost, scoop, schedule, and quality managed project issues change control process deliverables acceptance and implementation. Managed project closeout, turnover to operations, documented lessons learned, transition checklist, and archived project documents and artifacts. Wrote and delivered performance reviews of the team members.
  • Led the design and development of the following projects that enable the company to save 2.8 million from payments of licenses, technical supports and training's from different vendors:
  • Major accomplishments include:
  • Joined with Real Estate and Commercial Loan Applications team in the analysis and design of Real Estate Loan Servicing Systems to identify, analyze and improve existing business processes to meet new goals and objectives, such as increasing profits and performance, reducing costs, and accelerating schedules.
  • Led the Enhancement of Plastic Card Control Systems PCCS to accept Pseudo PIN Verification Key.
  • Led the development of the utilization of Excrypt Secured Application Processor ESAP in a multi-platform environment.
  • Developed the utilization of Magtek PIN PAL in the generation of secured Customer Select PIN on the host through PCCS.
  • Developed and maintained new system that generates ATM and POS statistical reports.
  • Restructured PCCS VSAM files definition to minimize CI and CA splits and dead space
  • Developed and maintained strategies for data disaster recovery as contingent plans in case of disaster and
  • Restructured PCCS batch processing in order to reduce downtime of on-line systems.

Environment: IBM ES9000, System Development Life Cycle Methodology, MVS Utilities, COBOL II, CICS, IMS DB, DB2, QMF, TSO/ISPF, VSAM, MS Access, MS Excel, MS Access, MS Excel, Endeavor, CA7, Dyl-280, File-Aid, Xpediter, RFI, RFP, RFQ, MS Project, MS Visio, MS PowerPoint, ESAP, Magtek PIN PAL, VRU, ATM and POS terminals etc.

Hire Now