We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

SUMMARY

  • Over 8 years of experience as a Business Analyst and Product Manager in various sectors of business, with In - depth knowledge of SDLC (System Development Life Cycle) with all phases of Waterfall, Agile, Prince II/Scrum, HP ALM and Quality Centers, and Kanban.
  • Knowledge of evolving FHIR standards and interoperability using APIs.
  • Experienced in IBM Curam systems, healthcare EDI transactions, Enrollment, Billing, Eligibility, Claims report, Patient Healthcare Management, electronic Health Records Management, Regulatory Compliance (HIPAA), Document Management, Health Care applications and Insurance domain applications.
  • Strong SQL skills with sound understanding of relational database, object-oriented programming, data modeling, data mapping and data warehousing and used tools like Tableau,Informatica, and Hadoop for working with Big Data.
  • Sound understanding of relational database, object-oriented programming, data modeling, data mapping and data warehousing.
  • Sound familiarity with automated regression testing suite and tools to design Test Plans and Test Scripts.
  • Experienced in using Rational ClearQuest for Defect, Change Control Management.
  • Experienced in data modeling and data migration using Salesforce APIs to/from an existing data warehouse and integration with ERP; and in upgrade and migration of HP Quality Center Projects.
  • Deep understanding of factors that drive customer success for Salesforce (or similar) implementations and how they directly contribute to long term customer retention.
  • Familiar with commercial loan regulatory compliance, risk, audit, customer due diligence and credit management technologies, including Loan IQ and advanced artificial intelligence technology for credit risk management.
  • Skilled in risk analysis and auditing to make sure relevant compliance regulations have been met.
  • Track record of quick resolution and on-time delivery of business analysis initiatives including cross-functional analysis of system, application or contract dependencies and risks, and data flow issues.
  • Skilled at translating functional and non-functional requirements into technical requirements.
  • Expert at conducting competitive research and analysis, and at applying business and marketplace knowledge to identify goals, metrics and analytics to measure product value.
  • Proficient in conducting JAD sessions to design, document and review business documents like Business Requirement Document, Functional Requirement Document and System Requirement Specifications.
  • Skilled at communicating and influencing functional and technical team members at all organization levels.
  • Conducted root cause analysis of problems and defined business processes both “AS-IS” and “TO-BE”.
  • Proficiency in all phases and methodologies of Software Development Life Cycle including Waterfall, Agile/Scrum, RUP.
  • In-depth knowledge of designing, capturing, consolidating and maintaining key metrics with Agile and Scrum Protocols, including Sprint session planning.
  • Understanding of Microservice architecture, REST services and JSON contracts.
  • Hands-on in creating UML Diagrams for Business Process Modeling like Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Data Flow Diagrams using Visio.
  • Expertise in conducting Requirement Gathering Sessions, Feasibility, Impact Analysis, Cost and Benefit Analysis, User Acceptance Testing (UAT), Risk Based Testing and Risk Analysis.
  • Experience across various businesses and project types (including custom software development, COTS and SAAS implementation, O&M support)
  • Knowledge of business analysis methodologies like BABOK tasks and techniques.
  • Experienced at using AWS Cloud platforms and their features.
  • Expertise in data visualization and analysis with Power BI, Tableau and Qlik.
  • Excellent skills in analysis, design, development and implementation of ETL and reporting components.
  • Highly skilled in structured planning methods for project evaluation including GAP Analysis, SWOT Analysis, Feasibility Analysis and Risk Analysis.
  • Skilled in using change control and bug tracking tools like Clear Quest, Rational Requisite Pro and Quality Center for identifying, analyzing and documenting defects including version and change control.
  • Able to build strong-identity teams that apply their diverse skills and perspectives to achieve common goals.
  • Strong derivatives trading and product knowledge including credit, commodity, equity, foreign exchange and volatility / variance derivatives
  • Experienced in modern software development and oversaw multiple product deliveries.

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst

Confidential

Responsibilities:

  • Provide a governance oversight and control function over risk data.
  • Work on SAFe framework with other scrum teams for coordinating tasks.
  • Conduct market analysis and plan collaboratively with UX Design and Technical teams, Product Manager and Clients regarding what kind of products do and do not add value to clients and designed BRDs and FRDs.
  • Manage team of JIRA and Confluence administrators implementing Atlassian JIRA Cloud COTS products for users.
  • Provide technology leadership and take accountability for the execution of Integration Shared Service (ISS) ERP roadmap.
  • Integrate Health IT project with Health IT Interoperability Networks and utilize FHIR.
  • Created Data Mapping Document and created roadmap for transition from current state to future state.
  • Use IBM Curam system solution for Eligibility and Enrollment.
  • Provide major information on the IBM Curam data model and explained entities and attributes in the model and the relationships between them following the SDLC life cycle.
  • Managed team of JIRA and Confluence administrators implementing Atlassian JIRA Cloud COTS products for users.
  • Design strategy for developing and implementing new EDI interfaces and converting historical data.
  • Work with leaders from digital marketing, the C-suite and direct patients for designing custom innovative digital healthcare product strategy solutions to position the company as the digital healthcare market leader.
  • Schedule jobs, create workflows, create and configure plans on the IBM Cognos ICM 8.x platform.
  • Facilitate in the development, design, implementation and production support for new healthcare products and enhancements to existing healthcare software tools.
  • Act as liaison with stakeholders on implementing new enhancements to the Billing and Enrollment systems and data backlog in accordance with HIPAA regulations.
  • Partner with Plan representatives, and perform analysis to transform the various inputs into business requirements to support a new BCBSA application and enhancements to existing software tools.
  • Assists in the assessment of solutions, provide recommendations and analyzes Plan specific and system-wide impacts associated with solutions.
  • Perform requirement walkthroughs with technical and user groups to confirm acceptance of business requirements and wireframes.
  • Responsible for ensuring all artifacts are completed timely and updated as needed.
  • Prepare for and participate in roadshow and training.
  • Worked with business and technical team to assure effective and successful implementation of business and system enhancements.
  • Created User Requirement Specification (URS) and Change Request (CR) document for system application development.
  • Performed Data Analysis, Data Modeling and Data Presentation and imported data from SQL Server DB to Power BI to generate reports.
  • Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis workflow in Agile central.
  • Solve complex problems and develop innovative solutions related to the Salesforce CRM platform while driving for OOTB solutions and articulate pros/cons of customizations.

Environment: IBM Curam, ERP, JIRA, SharePoint, Squirrel SQL, MS-Visio, MS Office Suite (Word, Excel, Power Point, Outlook), Agile Methodology, Pivotal Cloud Foundry, Axure, and Swagger

Product Manager

Confidential, Minneapolis, MN

Responsibilities:

  • Worked with partners to assess user experience (UX) and understand how to better serve their service needs.
  • Helped with migration from Oracle database to Hadoop for Big Data project implementation.
  • Documented Testing Procedures and wrote scripts for use in Automated Regression Testing Suite.
  • Used SQLServer and Oracle for ClearQuest and RequisitePro backend servers.
  • Monitored and audited for compliance with relevant rules and regulations and reported any breach thereof to management.
  • Created and managed epic and user stories in Agile Central using Confluence tool for data collaboration and project management.
  • Configured and integrated cloud based PaaS application like Office-365 and Dropbox for Single Sign on (SSO) functionality using Active Directory Federation Services (ADFS) and Microsoft Azure Active Directory.
  • Worked with MDX queries and developed reports using SQL Server Reporting Services (SSRS).
  • Designed, tested and deployed complex solutions using IBM Cognos Report Studio to meet business requirements.
  • Monitored and audited for compliance with relevant rules and regulations and reported any breach thereof to management.
  • Assisted Process & Service Owners in continuous process improvements and enhancements by encouraging continuous automation of incident, change & problem management process on ServiceNow platform.
  • Removed roadblocks and obstacles that may impair product teams to help ensure delivery of the project in order to meet strategic, financial and technical goals.
  • Designed and developed project document templates based on Software Development Lifecycle methodology.
  • Utilized Power BI to keep dashboards and reports up to-date with on premise data sources.
  • Used BABOK and Agile methodologies while creating Business and Functional requirements documents.
  • Created and managed epic and user stories in Agile Central using Confluence tool for data collaboration and project management.
  • Involved in Data Modeling and joining queries in MS Access to fetch the desired output for analysis.
  • Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
  • Wrote SQL queries to validate the data and run ad-hoc queries to show the data to the business.
  • Used MS Excel to organize company data and budget reports into detailed pivot tables.
  • Automated manual MS Excel tasks using macros which lead to a 12% boost in productivity.
  • Worked with stakeholders for SAAS implementation and O&M support and used AWS Cloud platform.

Technical Product Manager

Confidential, St. Paul, MN

Responsibilities:

  • Ensured the level of data quality meets Risk Data and Reporting Governance Framework and Standards by establishing processes, procedures and controls at all stages of the risk data lifecycle.
  • Interviewed End-Users to collect business process requirement and did UX design on Design Studio.
  • Used BABOK methodologies to establish strategic objectives and key performance indicators.
  • Met with users and stakeholders as needed to understand processes, pain points and system waste in order to identify where to improve the user experience and designed business, functional and non-functional requirements.
  • Created epics to drive improvements to product vision, features and back end systems, and adjusted for new business models.
  • Implemented and administered Atlassian JIRA Cloud COTS product upgrades, and partnered with other IT staff to coordinate infrastructure maintenance and system migrations.
  • Provided first and second level support for end users of the ERP JDE Enterprise One application by providing specific system and business expertise when necessary to solve.
  • Assisted Project Manager in developing Use Cases and Project Plans.
  • Defined the source to target data mappings, business rules and data definitions.
  • Implemented and administered Atlassian JIRA Cloud COTS product upgrades, and partnered with other IT staff to coordinate infrastructure maintenance and system migrations.
  • Worked with in-house developed software and package implementations and familiar with Loan IQ.
  • Analyzed risks and audited incoming and outgoing transactions.
  • Collaborated with underwriting authority and exercised discretion to analyze commercial loan prospects.
  • Evaluated potential loan markets to develop prospects for loans and kept abreast of latest regulations.
  • Developed Excel models to derive the amortization schedule for whole loan products and mortgage backed securities.
  • Experienced with in-house developed software and package implementations for credit card operations.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Developed visualizations using Tableau for better understanding of data, performed data cleaning, normalization, data transformation
  • Managed changes to the scope of the project.
  • Conducted User Interviews, Gathered Requirements, analyzed Requirements and managed Changes using Rational Suite.
  • Analyzed system to be implemented for production to ensure that it handles incomplete and accurate data and performed default method of calculations for various mortgage products.
  • Configured Automatic Payment Program for account payables including partial payment.
  • Generated Business Intelligence by utilizing raw data drawn from the EDW and applying various Excel functions including VLOOKUP and pivot tables to aggregate data.
  • Supported modeling of strategic financial plans to ensure reliable and comprehensive budgets, stress tests and forecasts for both internal and external stakeholders.
  • Interfaced with Client as part of the requirements engineering team to finalize the project scope.
  • Performed Data and Cost Analysis using account payable data.
  • Designed and implemented SCEIS SAP Report Manual.
  • Involved in corporate lending module as Single Point of Contact for the engagement.
  • Involved in depth understanding of credit risk management for the application.
  • Analyzed Customer Due Diligence Report for retail and commercial banking customers.

Technical Product Manager

Confidential, New York, NY

Responsibilities:

  • Knowledge of the risk data requirements for validation, analytics, reporting, MIS and modeling capabilities.
  • Consulted with business partners and made recommendations to improve the effectiveness of Big Data systems, descriptive analytics systems, and prescriptive analytics systems.
  • Deployed, and maintained core server-side infrastructure components for a high-performance, HL7 FHIR-based clinical decision support engine.
  • Documented use of Salesforce Marketing Cloud application and data management to support client's marketing & communication goals, and implemented data migration using Salesforce APIs.
  • Analyzed, designed, and led new areas of application within ERP JDE Enterprise One.
  • Wrote Confidential scripts using the IEG2 editor, IBM Curam data mapping and work queue provisioning within IBM Curam 6.0 framework.
  • Created test cases using the IBM Curam Application tool for Confidential regions with the help of Confidential.
  • Ensured that HIPAA compliant regulations are followed to display minimum benefit information that the Provider is required to pass on the EDI transactions.
  • Assisted ETL developers in mapping the extracted data about client Enrollment and health insurance Claims from source system and loaded into the target Billing system after applying required transformation.
  • Created various reports including Billing Payment, Billing Grouping Payment and Discount reports.
  • Identified Use Cases from Functional Requirements, and communicated to the technical and business teams.
  • Worked with Azure Cloud PaaS architect on the complex project for the data center assessment and application migration and setting up Disaster Recovery environment in the Azure cloud.
  • Integrated process into build system which auto-generates XML and JSON supported REST API documentation from source code improving API documentation quality and availability while reducing maintenance costs.
  • Conducted root cause analysis of problems and organized requirements into logical groupings of essential business processes, rules, functional and non-functional requirements, to help with making informed decisions.
  • Identified goals, metrics and appropriate analytics to measure the performance of products and continually made recommendations and refinements to products based on learnings.
  • Wrote SQL Queries to extract data from different data sources to map into central repository using Hadoop.
  • Conducted Functional and GUI Testing to ensure that the User Acceptance Criteria was met.
  • Maintained Traceability Matrix to ensure that all Functional Requirements were addressed at the Use Case level as well as the Test Case Level.
  • Prioritized outstanding defects and system requests, and prepared Requirement Traceability Matrixes to track such requirements.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Used Excel Sheets, flat files to generate tableau ad-hoc reports.
  • Generated Tableau dashboards with forecast and reference lines.
  • Used AWS command line client and management console to interact with AWS resources and APIs.
  • Wrote Use Case Specifications and created TO-BE Business Process Workflow Diagrams and Sequence Diagrams in MS Visio.
  • Conducted Requirements Workshops to verify and validate business requirements.
  • Designed Use Case Diagrams using MS Visio to show interaction between the actors and the Use Cases as well as to demonstrate the relationship between the Use Cases.
  • Communicated with Business Groups, Stakeholders and Users to develop the Vision Document.
  • Recorded meeting minutes from Joint Application Development (JAD) sessions and obtained sign-offs from JAD participants.
  • Documented AS-IS Business Workflows adhering to UML Standards.

ENVIRONMENT: IBM Curam, Hadoop, Big Data, JIRA, Agile, Scrum, Rational Unified Process, Unified Modeling Language, JSON, Power BI, Tableau, Qlik, ANSI SQL, SQL, MS Access. SWOT analysis, Financial modeling and valuation, AWS, Microsoft Azure, ServiceNow, Software Development Life Cycle, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest, HIPAA, MS Word, MS Ecuram

Hire Now