We provide IT Staff Augmentation Services!

Business System Analyst Resume

4.00/5 (Submit Your Rating)

Dublin, OH

SUMMARY

  • Senior IT professional seeking a contract role as a Technical Business/ System Analyst within the Content Management space where I can utilize a range of technical, functional, and business capabilities encompassing Content Management Systems (Web/Enterprise/Portal), Digital Analytics, Campaign Management, Customer Relationship Management, Business Process Modeling, Digital Asset Management, Software Systems/Developer/User Documentation across the entire SDLC from Analysis & Design to Development and Deployment.
  • Extensive experience in analysing and requirements gathering and writing system functional specifications including use cases and evaluating business process Models.
  • Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data governance and Metadata Management, Master Data Management and Configuration Management
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Experience in technical writing of validation protocols Installation Qualification (IQ), Operational Qualification (OQ), Performance Qualification (PQ) and Standard Operating Procedures (SOP) according to 21 CFR Part 11 and FDA regulations.
  • Knowledge of compliance to FDA 21CFR Part11, 50, 56, 58, 210, 211, 312, 314.80, 820.
  • Expertise in database design and development, Database audits along with working on HEDIS and Star - Reporting processes.
  • Immense experience with using report builder, Discover (Ad Hoc) and Workspace Analysis.
  • Experienced in testing different healthcare ERP solutions such as FACETS, Med Plus, EPIC and other claim processing solutions
  • Experienced in Business and System Analysis, process improvement, project management.
  • Created and managed JIRA templates and complex JIRA workflows including project workflows, screen schemes, permission scheme and notification schemes.
  • Assisted team in the adaption to the SAFe Agile methodology including coaching and participating in Scrum Stand Up.
  • Experience in Veeva CRM and Veeva Vault Content Management applications.
  • Expertise in Data analysis and reporting using MY SQL, MS Power Point, MS Access and SQL assistant.
  • Experienced in various databases Design of development and Production environment involving Oracle, SQL server, MY SQL, DB2, MS Access and Teradata.
  • Expertise in developing small applications with Tera data at the backend.
  • Hands on experience in writing test scripts, preparing test data, testing ETL Mappings and creating SQL scripts.
  • Executed A/B testing for landing pages experiences testing using Adobe Target and promoting target based experiences
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Hands on experience using Jira for issue tracking, user stories, and requirements, as well as Confluence
  • Professional experience in business analysis, operations management and development, design, documentation and testing.
  • Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
  • Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions.

TECHNICAL SKILLS

Development Methodologies: RUP, AGILE, Waterfall, ESDM, STV

Databases/ Query Tools: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase, SQL*LIMS LabWare LIMS and Web LIMS

Digital Marketing: Google Analytics, Google AdWords, E-mail Marketing

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools: Informatica, MDM, CDM Business Objects, Cognos, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Dublin OH

Business System Analyst

Responsibilities:

  • As a Business Analysis work for a software rationalization/design digital marketing POC consulting engagement focused on the redesign of the company’s “eTools” desktop software used to assist RA Sales department, OEMs, system integrators, distributors and customers in the selection and configuration of products and completion of a Bill of Material.
  • Lead overall online marketing/digital marketing efforts in coordination with internal and external Digital Marketing Teams, Web Developers, etc.
  • Provided strategic leadership on orchestrating end-to-end digital analytics solutions leveraging the Adobe Experience Cloud (Analytics, Audience Manager, AEM, Target, and Campaign) and Google Analytics.
  • Working to gather Requirements for migrating of Content from Portal to Adobe AEM and functionalities including Multi-site management and multi-channel management and Digital Asset Management.
  • Implemented extensive digital marketing in conjunction with google analytics PPC & AdWords Campaigns for geo-fencing re-marketing.
  • Designed, authored, reviewed and revised Clinical Data Management Plans and Drug Safety Technical Reports are FDA 21 CFR Part 11 compliant.
  • Designed report templates based on the requests by account managers and Functional Specification Documents for the reports.
  • Delivered solutions with Waterfall and Agile methodology by collaborating with business and solutions team and ensuring that solution meets business intent.
  • Provided FDA 21CFR Part 11 Documentation Remediation for corporate-wide Clinical Trial System
  • Referred to medical dictionary (MedDRA). Created and maintained custom medical drug and non-drug dictionaries.
  • Designing screens in Adobe Experience Manager (AEM) and building a POC in AEM Environment
  • Analyzing web analytics data (Omniture, Google Analytics) implement and maintain Adobe Analytics (Omniture) to help decision-making on key digital marketing and online sales projects.
  • Designed, wrote, edited and built content for web, social media plus other digital properties; managed collection portfolios and uploaded product files for the web.
  • Documenting and streamlining Veeva Vault intake workflows with BPMN, Scrum, workflow optimization methods. Documentation of Veeva Vault Intake processes for sales aids, approved e-mail. Documentation and streamlining of convention booth sales aid deployment.
  • Excellent experience in highly regulated enterprise model of Clinical Trial Management System (CTMS), Inventory Management Systems and EQMS (Track wise).
  • Worked on e-submissions and having good knowledge of CDISC, Code of Federal Regulation (21 CFR Part 11), ICH, GCP guidelines.
  • Mapped process flow; assess as-is processes through user interviews, data collection and analysis, design and evaluation of to-be process solutions.
  • Led the modernization of website using Adobe Experience Manager (AEM) platform to drive key buying actions & seamless customer experience with A/B testing using Adobe Target.
  • Extensive use of Excel to create Functional Specification Documents & Templates.
  • Designed the process flow diagrams for flow of information and report creation process.
  • Conducted RAD sessions for the report users, requestors, and the developers
  • Gathered business requirements, performed Gap Analysis for clients requirements and generated system workflows.
  • Responsible for digital marketing agencies centered on providing consultative, customized digital and traditional marketing and advertising solutions to key businesses in the various regions
  • Responsible for tracking and analyzing all digital marketing and advertising activities - click-through rates, conversion rates, cost-per-click, and cost per acquisition.
  • Evaluate processes and functional controls are in place and align with firm policies, procedures and regulatory expectations, updating BRD's and JIRA's.
  • Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
  • Analyzed valuation of tradable market securities with data mining and data management software (SQL query) which led to a significant minimized data error.
  • Documented various artifacts as per the FDA 21 CFR Part 11 considerations as well as Good Manufacturing Practices (GMP) and Good Clinical Practices (GCP).
  • Was involved in maintaining and cleaning up of the regression test case database i.e. identifying the redundant or irrelevant test cases and deleting them from the database so that the software certification process is expedited.
  • Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
  • Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
  • Wrote detailed specifications for various reports generated using Cognos.
  • Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
  • Worked as a liaison between the Business and Technology Department and enhanced communication lines between executives, managers, and peers
  • Facilitated the scrum events and managed Agile Lifecycle in JIRA from planning to sprint deployment. Tracked and communicated team velocity and sprint/release progress.
  • Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
  • Documented use cases, created use case diagrams that described the behavior of the system and modeled them in Rational Rose.
  • Proficient in using Agile Scrum methodologies, performed roles of Product Owner, Scrum Master following sprint/standup sessions and used JIRA & Version One extensively to write Epics, User stories, analyzed the Iteration Burn Down charts and reviewed defects.
  • Identified, organized, and documented the changing requirements of the project using Rational RequisitePro.
  • Developed high-impact presentations and communication tools to communicate strategic plans across the organization and to executive leadership.

Confidential - Kenilworth, NJ

Business Analyst

Responsibilities:

  • Acted as a liaison between stakeholders: system users, clients and managers, who have a business problem, and software development team to gather requirements and document workflows and results of Business Analysis into Business Requirement Document.
  • Gathered business requirements for CRM, Inventory and Quotation modules of Epicor ERP system through detailed discussions with business stakeholders.
  • Requirements of migrating of Content from legacy system to Adobe AEM and functionalities including Multi-site management and multi-channel management and Digital Asset Management.
  • Participate and help to drive Dynamics CRM 365 implementations through all project phases including discovery, definition, build, test and deploy
  • Drove successful transformation of existing organizations from Waterfall to Agile.
  • Involved in end-to-end test efforts and provide extensive support during all phases of System, Integration and UAT.
  • Analyzed current business processes and issues. Created detailed process maps for an end to end architecture diagram using MS Visio as part of Requirement Specification document
  • Worked with business stakeholders in creating user acceptance criteria and conducted/coordinated UAT.
  • Interviewed SMEs (Subject matter Experts), report owners to recommend processes for new implementation of (GxP) or (non-GxP) Cognos Reports.
  • Facilitated requirement gathering sessions, helped business to understand what can be accomplished quickly out of the box on AEM when compared to customizations.
  • Provided LIMS migration, configuration, implementation, LIMS Master Data, LIMS Lab Advantage to meet site requirements.
  • Assisted in Building, planning and implementing annual digital marketing strategy and budget including, email marketing plan, content marketing plan and social media strategy
  • Supported user requests for assistance in using the Lab’s LIMS and related applications, and in accessing related lab information - including providing query support and conducting ad hoc data analysis.
  • Scheduled and facilitated Agile ceremonies- Release Planning, Backlog grooming, Sprint backlog, Sprint Planning, Program Increment planning, Daily Stand Ups.
  • Drafted SDLC documents such as GxP assessments, 21 CFR Part 11 assessments, user requirements specifications (URS), design specifications (DS), traceability matrices (TM) for computerized systems.
  • Managed the employee SOP training/tracking process
  • Supported the QA and UAT teams during testing and production deployment by performing sanity checks.
  • Involved in creating reports on Veeva CLM objects and key messages for analysing asset utilization
  • Provided daily technical support for LabWare 7 Laboratory Information Management System (LIMS) users including troubleshooting problems at the master data level including logging of batches, results entry and reporting
  • Responsible for managing a JIRA board and prepping upcoming sprints with requirements.
  • Worked with business owners and stakeholders to understand and develop BRD (Business requirement documents) for CMS and DAM (Adobe AEM) implementation.
  • Supported the team in planning activities for Data staging, development and UAT activities.
  • Part of the master data team and participated in data migration activities. Interacted with the users in collecting the data and involved in uploading of Master Data using tools like LSMW.
  • Responsible for Resource Management and Identifying System Design based on the business requirement for OTC Master Data.
  • Coordinated with product and channel managers to develop tagging strategy and prepare design documentation for site catalyst implementation via Tealium.
  • Conducted User Acceptance Testing (UAT) by managing identified issues and ensuring all issues are resolved. Also have experience in Smoke testing, UAT, Regression Testing and integration testing.
  • Assisted in refining and maturing the agile processes to make software development more efficient.
  • Created/Maintained business requirement documents, use cases, Process flows & End User Guidelines for Legal applications in Jira.
  • Involved in marketing channels processes including strategy, online advertising, social media, branding, and communications, PR and web design.
  • Experienced in reporting Defects using Defects tracking tools such as Quality Center and JIRA.
  • Conducted JAD sessions with Developers, Project Managers and Business Owners.
  • Worked with business stakeholders in creating user acceptance criteria and conducted/coordinated UAT.
  • Worked closely with business users, in-house technical team and external vendor to conduct data mapping and migration, system configuration/customization for the ERP system
  • Part of User Acceptance testing team, involved in creating Test Strategy, Plan & Summary Report
  • Conducted User Acceptance Testing (UAT) by managing identified issues and ensuring all issues are resolved. Also have experience in Smoke testing, UAT, Regression Testing and integration testing.

Confidential

Business Analyst

Responsibilities:

  • Performed all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle which involved gathering, analysis and documenting business and technical requirements from both formal and informal sessions.
  • Drafted Product Definition Document (PDD), Request for Proposal (RFP) for various portals under the digital project.
  • Collaborated with Clinical and IT staff to support HEDIS business requirements and maintain consistency and integrity of data collection and storage.
  • Designed a database schema in MY SQL by gathering requirements and recognizing insights of the hierarchical BOM structure
  • Performed and led complex system integration tasks and problem solving under the limited supervision of senior engineering staff.
  • Used Adobe products such as Adobe target and Adobe analytics for A/B testing and analyzing the page visits, clicks on pages.
  • Involved in executing and CMOs, align their business objectives and goals to recommend Adobe Digital Marketing Solutions like AEM, Analytics etc.
  • Processed claims processing in QNXT with advanced HSA/HRA functionality and claim re-pricing functionality. Utilized the different modules in QNXT with extensive use of benefit plans.
  • Validated model by real dataset. Data source from various platforms SQL Server and My SQL.
  • Created Use Cases and Business Requirement Document after accessing the status and scope of the project and understanding the business processes.
  • Provided input to the HEDIS system that used Quality Compass to provide a selection base for various healthcare plans.
  • Performed Feasibility Study and Risk Analysis to identify the critical requirements from the user's perspective.
  • Involved in on a database driven web based CTMS solution for tracking regulatory and clinical data in a clinical trials environment
  • Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
  • Worked with the SMEs (Subject Matter Experts), IT managers, software architects to identify the key changes pertaining to HIPAA, and participated in Health Management to communicate effectively with them.
  • Performed Requirement Analysis, Impact Analysis and documented the requirements using Rational Requisite Pro.
  • Reviewed the Joint Requirement Documents (JRD) with the cross-functional team to analyze the High-Level Requirements.
  • Capture functional and non-functional requirements specific to data exchange and data integration in the domains -Enrolment and Billing, Print Fulfilment, Claims Disbursement, Ancillaries and Provider Data Management.
  • Documented and reviewed test cases for the written user scenarios with the testing team.
  • Created weekly project status report (WPSR), project performance scorecard and Requirements traceability metrics.
  • Involved in full development of life cycle (SDLC) within Cognos reporting from developing Business requirements to QA and Production support.
  • Analyzed Hybrid and Supplemental Data for Medicare Advantage PPO to create Microsoft Excel spreadsheets reports.
  • Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.

We'd love your feedback!