Sr. Salesforce Business Analyst Resume
Kalamazoo, MI
SUMMARY:
- A Sr. Business Analyst with over 10+ year’s hands - on experience including the understanding of Business Process Flow and Business Analysis and an extensive experience in all the stages of Software Development Life Cycle (SDLC). Possess experience in the Pharma and Health care Industries and Life Sciences.
- Proficiency in gathering business requirement, analyzing them and break it down to relate the whole lay out for rest of the team.
- Experienced performance-driven leader with expertise in building and leading commercial capabilities across diverse brands.
- A good team player with a blend of proven excellent interpersonal skills, healthy relationship management with the managers, effective communicator and problem solver adept in providing superior client services, relationship building and business support, and have performed efficiently as a leader in the need of hour.
TECHNICAL EXPERTISE:
- Expertise in collecting, understanding and transmitting as well as documenting the business requirements and business processes for the project, and translating them into functional specifications.
- Expertise in commercial effectiveness.
- Experience as a Salesforce.com as a Business analyst with the proficiency in implementation, configuration, analysis and understanding of Salesforce CRM
- Sales and Marketing experience in client relationship management, process management and leadership.
- Prepared presentations and setting up meeting with clients for marketing product purpose and ensuring that client needs are satisfied.
- Proficient in the Rational Unified Process and all the associated workflows and artifacts.
- Experience in the field of Information Technology in the Healthcare-Life Sciences / Pharmaceutical / Pharmacy Benefit Management PBM / encompassing business systems planning, procedural development, reporting and validation.
- Strong experience of working with the Salesforce.com platform, including Sales Cloud, Service Cloud, Community Cloud, Salesforce CPQ.
- Work experience in sales and marketing industry.
- Experience in business development as well as sales and marketing within various industries.
- Highly focused on clinical and commercial supply
- Detailed understanding of Sales, Marketing and Service cloud on Salesforce.com.
- Recognized for the ability to create and execute integrated commercial efforts against key customers that creates competitive advantage and increased market share
- Cooperated with Data managers and biostatisticians for QA, Statistical Analysis Plan development, analysis and reports using SAS
- Experience in design and development of Enterprise products in life science and healthcare domain.
- Expertise and experience in Object Oriented Analysis and Design (OOAD) and UML as a business analysis methodology for application functionality designs. Expertise in using CASE tools.
- Advanced knowledge of the Pharmaceutical industry and products & services, equipped with strong sales and business development skills
- Dataflow analysis using use cases, dataflow diagrams, state diagrams, activity diagrams, state chart diagrams, communication diagrams, behavioral state machine diagrams, class diagrams, sequence diagrams, deployment diagrams, data flow diagrams (DFD), entity-relationship diagrams and collaboration diagrams using Rational Rose and MS Visio.
- Support the testing, validation and implementation of large-scale regulated systems for pharmaceutical and life science clients.
- Expert in Salesforce Sales cloud, Marketing cloud and Service cloud implementation
- Experience in SAS Administration skills, data warehousing and business intelligence
- Experience in Product Development, Regulatory Affairs, Regulatory Compliance, Quality, and Commercial Operations
- Excellent knowledge and deep understanding of industry standard methodologies like Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models), ISO9000, Capability Maturity Model Integration (CMMI) and Six Sigma and Rational Tools used during various phases of RUP such as Inception, Elaboration, Construction and Transition.
- Developed Macro programs to send SAS procedure output to different destinations
- Sound knowledge of HIPAA, HL7, LO ICD9 CM, NDC, CPT4, EDI, ASTM, DICOM,HMO, PPO, Sarbanes-Oxley Act (SOX), ACORD, BASEL II, SOPs (Standard operating Procedures) and forms, GMP’s terms and Practices.
- Interacting with stakeholders, gathering requirements, rating them and assigning priorities to each of them.
- Worked extensively on Pharmacy Benefit Manager (PBM), NCPDP, PBM Migrations, Claims, Enrollment, Membership, Billing, products/benefits etc. at all clients.
- Worked on different EDI healthcare transactions like 837 for submitting claims, 835 for payments, 834 for benefit enrollment, and 820 for premium payments to insurance products, 270,271 for health care benefits and eligibility, 275 for patient information, 276, 277 for claims status and 278 for transmitting health care service information.
- Managed defect lifecycle for all software bugs detected throughout the SDLC (software development lifecycle).
- Innovative strategic leader, proactive and creative marketing professional in conceiving & implementing marketing strategies, to take products and services to new successful levels
- Worked on HIPAA AS compliance to ensure standardized electronic transmission of healthcare data, claim & payment transactions. Conducted NASCO claims analysis, NASCO membership analysis, testing and validation.
- Experience in 21 CFR Part 11 (Electronic Records and Electronic Signatures) remediation planning and implementation across all aspects of the business operations.
- Knowledge of cGxPs for Pharmaceutical, Biologics, Medical Device, and Quality Systems: 21 CFR Parts 210, 211, & 820.
- Conducted analysis of HIPAA rules to ensure that the new applications are HIPAA compliant
- Acted as a liaison between the client and technical teams. Ensured that the business requirements were clearly and unambiguously communicated to the IT team.
- Strong SQL Server 2005 skills to build optimal database structure. Familiarity with TOAD. Knowledge of Relational Databases, Data Warehousing. ETL concepts.
- Experience in Lightning Components and SalesForce Lightning Design System (SLDS) with Salesforce Marketing cloud.
- Knowledge of Anti Money Laundering (AML) Guidelines, Bank Secrecy Act (BSA), OFAC and Patriot Act.
- Experience analyzing and debugging all areas of an EDI transaction data flow. Maintained EDI transaction tracking.
- Experience in conducting System Integration Testing (SIT), User Acceptance Testing (UAT), Performance Testing, Functionality Testing, Stress Testing, Load Testing as per HIPAA. Experience with testing process that complies with FDA regulations, particularly 21 CFR, part 11,including Validation plan and Protocol, Installation Qualification (IQ), Operation Qualification (OQ),Performance Qualification (PQ) specifications.
- Expertise in negotiation, short and long range planning, developing and making presentations to clients, business users and senior management, communicating technical information effectively, prioritizing and maintaining effective relationships with various IT teams.
- Leading and conducting JAD sessions to develop architectural solution that meets the business requirements, resolve open issues and change requests.
COMPUTER SKILLS:
Methodologies: OOAD, RUP, UML, SDLC, JAD, Six Sigma, CMM, RAD, SCRUM
Languages: C, C++, Java, C#, XML, SQL, UNIX
Operating Systems: Window NT/95/98/2000/XP/Vista, Unix
Change Management Tools: Rational Clear Quest, Test Director
Business Modeling Tools: Rational Rose, Rational SODA, Requisite Pro, Clear Case, Clear Quest, Microsoft Visio
Project Management: MS Office Suite, MS Project, MS Visio
Databases: MS SQL server, MS Access, Oracle 11i, RDBMS Concepts, Database DevelopmentVersion Control Systems Rational Clear Case, PVCS
Web Technologies: ASP, HTML, XML, Adobe Photoshop, Adobe Light room, Dreamweaver, Flash
Testing Tools: Rational Test Manager, Mercury Test Director, Win Runner, Load Runner, Rational Robot, Quick Test Professional
PROFESSIONAL EXPERIENCE:
Confidential, Kalamazoo, MI
Sr. Salesforce Business Analyst
Responsibilities:
- Provide guidance and direction to ensure adherence with Company quality and customer service standards, clinical initiatives, ethical business practices, and ensure business unit goals are aligned with national and global Company objectives. Develop and implement programs, action plans, educational materials, policies, and procedures based on best practices collaborating with field teams to c-level stakeholders and vendors to improve the lives of those we serve through the utilization of technology.
- Monitored SQL queries, PL/SQL stored procedures, triggers on back end as a part of data analysis and data validation.
- Performed the role of Business Analyst, interacted with various business user groups for gathering the requirements for salesforce.com CRM implementation.
- Managing branch activities of Sales and Marketing with Pharmacist and Sales Representatives.
- Knowledge on SAS procedures, Reports, input, created temporary and permanent folders
- Plans, develops and manages marketing campaigns with clients to ensure their marketing needs are met.
- Developed commercial assessments of healthcare companies to identify and evaluate in-licensing and emerging global market opportunities via collaboration with major affiliates and regions.
- Create and evolve the Salesforce Marketing Cloud strategy and coordinate go to market efforts
- Monitoring & Control of Sales Executives and Pharmacists in terms of Basic Working, Sales and collections and overall Business Development
- Bridging the gap between technology and compliance by implementing systems for the life science industry.
- Executing Structured SAS-SQL Teradata code to synthesize large amounts of relational data to optimize complex member communications products to key audience.
- Integrated the Web Services for extracting the data from external systems to display in the pages of Salesforce.com
- Planned and executed physician events with Marketing and Communications Department
- Serve, as a liaison between business and technical teams translating technical/architectural specification into relatable business needs in the development of applications, databases, and reports.
- Worked on HP ALM/QC Tool Support, Customer Ticket resolution and Interface with HP Support and also did Setup and configuration of HP ALM/QC.
- Worked on importing data into SAS from various types of source like .txt files, excel spreadsheets and creating the SAS datasets
- Worked closely with the sales and marketing team to customize lead management by utilizing sales cloud using salesforce.com.
- Innovative strategic leader, proactive and creative marketing professional in conceiving & implementing marketing strategies, to take products and services to new successful levels
- Expert in report creation for Life Sciences Operation Team.
- Worked on PBM, NCPDP, Specialty Pharmacy, COB’s etc. including Mail Order Pharmacy
- Project Manager facilitating technical and educational acquisition efforts converting electronic health data, human resource applications, SharePoint migration, other corporate technical resources, and the creation of audit tools while maintaining the integrity of all data, minimizing the impact to resources, patient care and billing processes.
- Involved in importing and exporting of clinical data across a variety of applications to and from SAS
- Prepared and operationalized strategic and tactical marketing plans and budget for life science products.
- Developed materialized views, stored procedures, functions, triggers, packages in MSSQL for various business requirements.
- Supported multiple lines of business for creation of ad hoc reports utilizing SAS
- Gathered business requirements, designed and developed, implemented, and cross-trained corporate employees in SharePoint solutions including web pages, content, custom lists, and managing permissions.
- Developed professional training materials supporting EMR documentation utilized nationwide driving a 25% reduction in acquisition life cycle.
- Converted multiple excel reports to SAS reports to increase reporting efficiency.
- Assists clients in determining budgets and scope marketing materials, project and campaigns
- Identified redundant system transactions which were impacting the overall productivity by keeping track of all the data using SQL Server. Participated in the research and evaluation of new products, services and proposed AML solutions.
- Created and documented Salesforce application requirements by working with end users and key stakeholders
- Export Requirement from MS Word/MS Excel to HP ALM.
- Improved requirements prioritization process enterprise wide. Led cross-functional (Business, Dev, QA, UAT, Education, Legal, Compliance) teams in streamlining HP Quality Center application tracking capabilities, successfully implementing a 30 day reduction in SDLC, improving workflow and resources utilization.
- Supported and approved all clinical system enhancements, following complete SDLC/product workflows from inception to completion assuring all stakeholders’ business needs were met or exceeded.
- Liaised between multiple development teams and business user groups to create an enterprise wide e-scribe solution streamlining and improving patient medication management and medical staff compliance.
- Ensure quality improvement activities were within scope providing detailed reports aimed at reducing effort, improving reimbursement and improving end users moral.
- Customized existing Visual force to align with Salesforce new Lightning UI experience.
- Analyzed user requirements to set up HP ALM to support client requirement.
- Prioritized requirements and resolved Clinical Services helpdesk tickets documenting in Remedy Ticketing and HP Quality Center meeting 100% of weekly goal. Wrote scripts for knowledge base to assist internal clients in faster technical resolutions.
Environment: SQL, IMS, EMC Documentum, .Net, HTML, SAS, XML,Oracle, SAP, Rational Requisite Pro, Rational Rose, UML, SQL, MS-Office, MS Project, MS Visio, Test Director.
Confidential, New York City, NY
Sr. Salesforce Business Analyst
Responsibilities:
- Responsible for supporting divisional and clinical level educators in the use of Company EMR (CMS certified MIQS), document imaging methods, LMS, Kronos, ADP, Microsoft Office Suite, SharePoint, intranet, and associated applications.
- Worked on marketing campaign that focused on merging sales, marketing, and customer service and support databases within Salesforce platform.
- Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables, listings and graphs
- Involved in a mission to help customers create a healthier and safer world by providing innovative healthcare and life-science products and services solutions around the globe.
- Worked on various Salesforce.com standard objects.
- Created SAS programs to extract claims data effecting 10 million dollars in identified overpayments
- Ensure patients receive safe and effective dialysis treatment; the clinic meets the new Conditions of Participation found in the Federal Register at 42 CFR Part 494 (Subpart A-Subpart D; sections 49 .180 ) and; to ensure the clinical staff comply with all policies and procedures.
- Successful implementation of marketing Campaigns related with different brands
- Periodic Conversion of database to SAS data sets, efficient in capture and retrieval of clinical data
- Project managed and provided business system analysis for acquisitions and new clinics in major software and system implementation and conversions, directing training in all company systems including Microsoft Outlook, EMR, HR onboarding, SharePoint, clinical education, clinical policy and procedure implementation, ESRD network communications, CMS CROWNWeb and NHSN notifications and tracking, ensuring regulatory compliance through entire process.
- Conducting a general analysis of the reports obtained from various departments such as sales marketing, distribution, production etc.
- Identified and documented issues, risks, gaps and their impact to the project life cycle.
- Ensured 100% clinical compliance with state and CMS regulations and billing compliance during acquisitions.
- Motivating & managing sales and marketing team in achieving sales targets
- Develop and maintain general-purpose SAS macros for data validation, extraction, manipulation, analysis and reporting
- Developed and maintained all operational and technical flows using Visio and Power point and worked on Specialty Pharmacy, mail order pharmacy, COB, Formulary, claims etc.
- Programmed Excel Quality Analysis Improvement Program tools improving moral and retention
- Worked on Automating Web portal, Excel, PDF, TXT and Email automations using UI PathStudio.
- Wrote and edited over 100 clinical and technical policy and procedures for existing, startup and acquisition use including document controls utilizing Access database, Excel, and SharePoint
- Collaborate with vendors in maintaining compliance in reporting metrics to CMS through process mapping, QA, UAT and system implementation.
- Developed BI solution using SharePoint and Microsoft Excel, tracking facilities progress in appropriately registering and participating in CMS required programs, NHSN (infection reporting) and CROWNWeb.
- Streamlined access and facilitated consistent reporting at the facility level by working with ESRD Networks and staff to implement a national standardized form for patient data collection and reconciliation reducing administrative level of effort.
- Involved in Analysis, design, development and implementation of salesforce.com applications
- Authorized operational compliance trending reports utilizing SharePoint custom lists feature reducing the amount of rejected claims.
- Supported multiple physician practices during denovos, acquisitions and regulatory changes in writing sustainable best practice reports and educating professionals on documentation relative to CMS Quality Payment Program (QPP)
- Involved in enterprise Service Cloud implementation using Salesforce
- Implemented electronic documentation strategies to ensure internal quality improvement activities were monitored and reportable leading to a 98% initial Department of Health survey passing rate.
- Worked extensively and individually with department leads to elicit requirements and identify business needs, designing, developing, testing and deploying custom built SharePoint sites providing training for all users.
- Partnered with HR to implement new onboarding program to include tracking Patient Care Technician certification status as required by CMS.
- Identified need and established professional development programs. Developed Clinical Nurse Manager training program in collaboration with other Corporate Educators and VP of Operations improve retention by 18% within first 3 months of implementation.
- Created internal audit tool leading to a 98% deficiency free initial surveys for all new clinics.
- Developed, published, and implemented nationwide staff development programs, organized and led webinars to provide updates on company systems and policy and procedures to include open line Q & A session
Environment: J2EE, SQL Server, XML, HL7, UML, Oracle, SAS,MS Visio, MS Office, MS Project, Filenet.
Confidential, West Chester, PA
Business System Analyst / Business Analyst
Responsibilities:
- Upgrade HP ALM 11.0 to HP ALM 11.5 and Setup and configuration of HP ALM/QC.
- Studied and assessed the clients systems and business processes. Developed project plans and managed scope.
- Modified existing SAS programs and created new programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
- Worked with Life Sciences in the Large enterprise Pharma space.
- Worked with Project Manager for Vendor Assessment and Proof of Concept (POC).
- Authored Project Charter documents.
- Involved in SAS Enterprise Miner with use of DATA Mining
- Scoping business requirement and document User Requirements Specification (URS).
- Develop System Requirements Specification (SRS), System Design Specification (SDS) and System Configuration Specification (SCS).
- Build UML diagrams and developed workflows and lifecycle around business rules.
- This Project governed by 21 CFR Part 11, 21 CFR Part 820.70(i) and CFR Part 210/211, 606.
- Develop Test Plans, Test Scripts & reported bugs passed, failed & retested.
- Created and managed project templates, use case project templates, requirement types and traceability relationships in HP ALM.
- Developed SAS programs for ad-hoc tables and listings in support of Data Management
- Authored EMC Documentum (DCTM) scripts in document life cycle and work flows.
- Developed test scripts for IQ, OQ, and PQ to validate Documentum, WebTop & DQL systems.
- Execute manual/ automated test script in Integration, Regression, OQ, PQ & UAT test cycle.
- Maintained the Test Matrix and Requirement Traceability Matrix (RTM).
- I am the Liaison between departments such as Accounting, Pharmacy Operations, and Clinical Pharmacy and worked extensively on PBMS, coordination of benefits, Mail Order Pharmacy as required.
- Used Testing Methodology throughout Software Development Life Cycle (SDLC).
- Encountered Issues during Test execution documented and track till issue resolved and closed issue after re-testing Issue.
- Performed Issue Management, communicated with vendor/developer and closed after retested.
- Conducted internal audits for validation packages of applications.
- Documented Expectation Report and Validation Summary Report after each testing life cycle.
- Carry out full project lifecycle and taken business approval for production.
Environment: SQL, IMS, EMC Documentum, .Net, HTML, XML, Oracle, SAP, Master Data Management(MDM), Rational Requisite Pro, Rational Rose, UML, SQL, MS-Office, MS Project, MS Visio, Test Director.