Sr. Business Analyst Resume
Abbott Park, IllinoiS
SUMMARY
- Over all 6+ years of professional experience as a Business Analyst in Pharmaceutical domain.
- Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
- Excellent in Developing and evaluating business process Models.
- Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
- Strong understanding of information technology capabilities and dependencies, including platforms, content management, e-document strategies and process mapping.
- Excellent skills in forming and facilitating Joint Application Design (JAD) for eliciting data requirements that support the business requirements and documenting data flows.
- Strong experience in RUP Business Modeling process.
- Experience with data migration (ETL development), document data manipulation processes and scripts
- Directly managed multiple projects involving multiple team sizes. One of the key projects involved Clinical Trial using SCRUM development methodology handling highly sensitive data. Recommendations established new firm wide coding and testing standards.
- Experienced in maintaining software applications on Mainframe, HP-Unix and Windows based system
- Extensive working knowledge in validating systems like Inventory management, LIMS, CMS and EDM.
- Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
- Gained extensive knowledge and understanding of MITA, MMIS, Electronic Medical Health Record EMHR and Pharmacy Benefit Management PBM.
- Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
- Exposure to Client/Server, Web Application developmental tools and Software development and design.
- Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
- Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
TECHNICAL SKILLS
Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP, CVS,TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA,DB2. Windows 98/2000/XP, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Data Stage, Adobe Photoshop, Flash, Rational- Rational Rose, Mercury Testing Center, Rational XDE, DOORS, Cobol, RequisitePro, CaliberRM, Crystal Reports, Cognos, various NIKU products, C, C++, SharePoint, Docushare, BASIC, Intermediate level-Visual Basic
PROFESSIONAL EXPERIENCE
Confidential, Abbott Park, Illinois
Sr. Business Analyst
Responsibilities:
- Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
- Extensively involved in data modeling Advisor to the criminal justice agencies stakeholders on the best practices.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Worked on receiving Encounter files from their PBM (Pharmacy Benefit Manager), verifying the data content by transactional analysis.
- Extensive experience in Healthcare/Claims and encounters adjudication with knowledge of industry compliance standards like HIPAA and EDI X12 transactions (834, 837, 835, 270/271, 276/277).
- Defined charter, scope, schedule, and resources for projects productizing R&D programs, managing (and often defining and delivering) customer needs via marketing requirement documents (MRD) and product requirement documents (PRD) with program milestones, user documentation and QA, increasing profitability while building a best practices organization.
- Created the configuration document for custom setup for various user groups such as HR, marketing, R&D & sales, research analyst & investigators.
- Administration of Clinical R&D software including Oracle clinical, Cleanups PMD, Forecasting and sales and marketing software Spotfire and Cognos
- Worked on requirements of the 835 HIPAA projects, 276/277, 278, 837, and HIPAA EDI Transactions across enterprise.
- Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
- Gathered requirements and modeled the data warehouse and the underlying transactional database
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Lead Business Intelligence reports development efforts by working closely with MicroStrategy, Teradata, and ETL teams
- Gathered Business/Functional Requirements from Business/R&D Users.
- Directed the clinical trial data capture and worldwide data collection systems for various therapeutic areas.
- Designed and implemented a web service to support the outsourcing of clinical trial disclosure.
- Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
- Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
- Organize requirements into high level Use Cases and low-level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
- Apply UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders.
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Collaborates with the Medical Director(s) and business associates (e.g., healthcare plan, PBM, consultants) to define the best approaches to find areas for improvement and trend mitigations
Confidential, Rocklin, CA
Business Analyst
Responsibilities:- Used Requisite Pro for the Requirement Documents Preparation and Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level. Followed top down, leveled technique for building Business Process Models.
- Defined the current clinical and financial business processes reengineering and practices.
- Reviewed administrative and clinical practices and procedures: point of care, scheduling, registration, clinical documentation, patient care, and charge entry, medical coding and diagnostic testing procedures associated with multiple business units.
- Modified existing COBOL programs on Mainframe to add a new payment code. It includes adding a new column in the claim’s payment table and unit testing.
- Assisted with development of strategy for managing SharePoint permissions in conjunction with Active Directory and future implementation of Identity Lifecycle Management functionality
- Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.
- Involved in creating and testing Professional, Institutional and Pharmacy claims through API to Diamond.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
- Worked with Claims, enrollment, eligibility verification for members and providers, benefits setup, and backend payment cycle in facets.
- Detailing logic and data flow of the system for migrating the system from Mainframe to Client/Server platform
- Expertise in EDI files transferred to Trading Partners in HIPAA 5010 standards
- Worked on developing and testing functionality for the subgroup’s module like PBM Pharmacy Benefit
- Customize and extend the Oracle E-Business Suite using flex fields, Forms Personalization, Oracle 10g PL/SQL and SQL*Plus scripts
- Wrote shell scripts to run Micro focus Cobol programs to convert utility files
- Worked on Pharmacy Systems' Condor Rx-90, CS-90, and CS-90+ prescription management systems
- Interaction with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process
- Extensive experience in all phases of RUP and SDLC processes
- Monitored client expectations through client involvement and communication throughout the lifecycle of the project; educate clients and stakeholders on the benefits and risks associated with the project.
Confidential, New York
Sr. Business Analyst
Responsibilities:
- Interacted with clients to gather all requirements to formulate business specifications and translate those into application functionality, decide when to advocate and when to compromise to arrive at a mutually acceptable solution.
- The project/s involved various development, enhancement, production and R&D support activities connected to clinical microbiology.
- Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk and increase the quality of application before deployment.
- Involved in assessing 21CFR part 11 requirements and evaluate the organization’s current validation state.
- Contributed to the preparation of Master validation test plan, relevant to the components involved in maintenance of electronic documents in accordance with 21CFR PART 11 regulations.
- Responsible for managing activities and deliverables for all study conduct partners (Site Management Organizations, Pharm Sci, CROs, Vendors and etc.)
- Coordinated the mainframe update of mid-day processing and update of the backend DB2 database.
- Gathered and documented requirements for Pharmacy benefit managers (PBMs) for health insurance carriers
- Coordinate distribution of SOPs to Pharm Sci.
- Developed a Legacy Document Conversion Utility (LDCU) Tool that converts legacy documents documents migrated from a legacy docbase to Pharm Sci control documents.
- Documented workflows and results of business analysis and obtain sign-off from client on specifications.
- Participated in meetings to establish and enforce SharePoint best practices and standards manage proper security group naming conventions & security assignment processes
- Stored stake holder conversations as part of CRM Activities in detail using ACT 5.0.
- As part of CRM Activities, gathered client data, managed, tracked and analyzed this data to improve customer relationships and targeted marketing campaigns and pricing along with Marketing Team.
- Worked at different stages of the Software Development Life Cycle (SDLC) with business users, developers, and stakeholders.
- Involved in creating test cases for 834, 837, 820, 270/271 transactions and validating the EDI files.
- Performed Gap Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
- Assisted the technical team in translating application functionality into application architecture and the production of a System Functionality document.
- Analysis of data both on Mainframes and SQL server database
- 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.
- Involved in mentoring specific projects in application of the new SDLC based on the RUP, especially from the project management, requirements and architecture perspectives.
- Designed and developed Project document templates based on RUP methodology.
- Responsible for the Design and execution of test plans to ensure that business requirements and functional specifications are tested and fulfilled.
- Complete Understanding of the long-term business objectives and suggest technical strategies to meet those objectives.
- Conducted FRS (regulatory) and URS reviews and walkthroughs with the designers, developers and stakeholders.
Confidential, New Brunswick, NJ
Business Analyst
Responsibilities:
- Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
- Part of the team developing the business use cases/system use cases using the RUP Methodology and processes for Logical Data Model and Physical data Model.
- In the analysis and design phase dealt with data architectural team to assist in understanding the functional requirements, technical requirements documentations and design of logical and physical data models.
- Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
- Part of the Architecture data management team to ensure the process is done correctly with other business analysts, data architecture team, and technical teams.
- Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
- Created different users, roles, Document libraries, Form Libraries, Team sites for projects, Issue Lists on SharePoint Server 2003
- Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript
- Designed the universes by creating the Business Objects data model.
- Designed and implemented basic SQL queries for testing and report/data validation
- Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Wrote Test Cases and performed User Acceptance Testing, documented the in detail defects using the Defect Tracking report.
- Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.