SUMMARY

• 8+years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Intelligence, Data warehousing, Data Mapping, Data Validation, Data Integrity, Master Data Management (MDM), Reporting, Data Governance, Data Stewardship and Data Modeling.
• Experience as a Business Analyst in Pharmaceutical domain and experience as a passionate business, process, and qualitative analyst with expertise in understanding business problems.
• Experience working in all the phases of the SDLC in Waterfall, Agile/Scrum and RUP methodologies.
• Experience in Business Intelligence, Data warehousing & advance analytics implementation within several business areas like Pharma Life Science commercials, finance, Compliance & Clinical Trial Management System, CRM, Accounting, Supply chain management.
• Experience in Salesforce CRM Administration, configuration, standard data model, security, and automation such as validation rules, workflows, and process flows and development.
• Extensive experience working QA and Validation capacity in sterile manufacturing, Biotechnology,
• Experience in software development methodologies such as Waterfall, RAD, RUP and AGILE SCRUM.
• Implementation of Data warehouse and strong understanding of Data warehouse concepts, Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, Physical & logical data modeling, Star Schema, Snow schema.
• Experience inRequirementsModellingby creating Business Process Model Notation BPMN, Use - Case models, User Stories, AS-IS, TO-BE process models, Entity Relationship Diagrams and Activity Diagrams.
• Hands on experience in developing Custom Reports and different types of Tabular reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Hands on experience in establishing CCPA and GDPR frameworks using the WireWheel, Big ID and Collibra
• Experience in data extracting(ETL), MIS Reporting, data Conversion and manipulation, transformation, data cleansing and suppressions, data validation & error trapping, testing and loading large data sets into SAS from various applications/databases (Oracle, Teradata, DB2, SQL server, Access, Spread sheet, text files) and environments (windows, UNIX, TSO/MVS Mainframe).
• Experience in Master Data Management (MDM), Data Quality Management (DQM), Data Integration (DI), Metadata Management (MM), Data Governance (DG)
• Experience onSalesforceCRM platform Worked on different environment ofSFDCsuch as Sales and Service Clouds.
• Extensive experience as Data Analyst on data warehousing projects and expert in Data Cleansing/Data Conversion/Data Mapping/Data Migration concepts.
• Experience in Dimensional Modeling using Star schema and Snow schema.
• Experience, providing statistical programming support for multiple clinical research projects in pharmaceutical, biotechnology and contract research organization (CRO) industries
• Experience in ETL tool using info Informatica 8.x/7.x (PowerCenter Designer, Repository Manager, workflow Manager, workflow Monitor).
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Demonstrated ability to adapt into new environments, learn new skills and participate/lead teams.
• Acquainted with SQL, Quality Center, Quick Test Pro, Win Runner and load Runner.
• Experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• 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.
• Have worked in Data Market Systems,BPMand SQL queries.
• Worked closely with various project stakeholders, SME’s & developers to understand and document business requirements, functional requirements and design specifications for new applications along with enhancements to the existing applications.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Management Tools: Power Designer, Rational Rose, Visio

Methodologies: RUP, Scrum (Agile), Waterfall, SDLC, KANBAN Waterfall

Business Modeling/Project Tools: Smart Draw, MS Visio, Just in Mind Prototype, Snag it, Axure, MS Office Suite-Certified Expert (Word, Excel, PowerPoint, Access), SharePoint, Confluence

Database: RDBMS Oracle, MS Access, IBM DB2, SQL Server 2000

Programming Languages: SQL, UML, XML, Java, HTML, COBOL, CICS, VSAM, Mainframe, C, C++, Java, Python

Defect Tracking Tools: HP Quality Centre, ALM, QTP, Jira, SixSigma, Bugzilla, Mercury

Data Analysis/ Defect Management Tools: Tableau, R Studio, Power BI, MS Excel (VLOOKUP, Report and Dash Boards, Pivot Tables), SSAS, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

Sr. Business Analyst

Environment: Microsoft Office Suite, MS Visio, SOA, Java, Clinical Trial Management System CTMS, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, SAS,UML, RUP, rRDM Agile,Mercury TestDirector, Mercury LoadRunner

Responsibilities:

• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Collaborated with Clinical Research to accommodate to New Business Requirements.
• Performed the Data Modelling effort for the gaps identified while data mapping.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Involved in the Support for a major effort to improve the Data Warehouse Management System (WMS) capabilities of Supply Chain.
• Responsible for SDLC/rRDM artifacts from requirements thru deployment in an Agile SCRUM environment.
• UtilizedBusiness Process Model Notation (BPMN)mapping process in creating over process flow documentations
• Validated and analyzed stories againstBPMNdocumentations using scenario based methodology
• Involved in end to end Veeva Implementation for the Bio-Pharma industry, R&I, Diabetes Care etc.
• Implemented the project using the Waterfall Methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).
• Content management of documents to be published, customizing the entire permissions of clients (based on active subscription - contract), automate the entire permission standards from Salesforce CRM,API design management(Logic and workflow)
• Develop/customize BPMN Workflows as per the client requirements. to customize and leverage issue management workflow in Collibra
• Extract data quality rules, DQ results, profiling results and score carding summary and populate in Collibra.
• Created various types of data visualizations using Python and Tableau.
• Effectively participate in clinical research activities including design, consent, data gathering and data retrieval
• Regular interaction with the core developers helped us in fixing the defects in less time.
• Created system design, documentation and process modeling for massive worldwide Supply Chain and Procurement ERP system for Concur T E, Ariba Sourcing, Ivalua, OneSource, Concur implementation and various other tools.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries and PL/SQL stored procedures to filter data within the Oracle database.
• Worked on data modeling and produced data mapping and data definition documentation. Configured the Data mapping between Oracle and SQL Server 2005.
• Created report models for ad hoc reports and deployed on report server using SSRS.
• Played key role in defining test automation procedure and standards, creating Win Runner and QuickTest Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Create SQL scripts, complex stored procedure, provide database support, data analysis and scripts for data cleansing and scrubbing etc
• Identified the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the mappings using dataflux.
• Played active role during daily scrum meeting and task planning as part of agile methodology
• Production support applications break fixes were immediately resolved as well as modifications/updates, MIS Reporting, ETL, Data conversion, manipulation and occasionally new applications were implemented using SAS/UNIX scripting, X Manager Reflections, Teradata, FUTRIX, Tableau.
• BusinessProcess Management (BPM), Use Case modelling using UML, Data Modelling, Project
• Met project milestone dates for Technical Use Cases and Test Script completion dates for Phase releases.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
• Extensively used Informatica Client tools like Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Used Teradata utilities Fast Load, Multi Load, tpump to load data.
• Created automated Load test scripts using Load Runner.
• Conducted technology comparison, tool/solution assessment and solution selection from several potential solutions, including SharePoint, Clinical Trial Management System CTMS and customized systems.
• Conducted GUI and functionality testing using QTP.
• Involved in designing and developing data management application on with central operational database.
• Provide IT quality compliance support to R&D and Medical Devices projects.
• Worked in identifying the efficient Design flow for migrating from SQL Server to Oracle Exadata Platform.
• Tested Inbound and Outbound Feeds of different format (XML, Pipe-Delimited, CSV)
• Conducted data driven testing using QTP to conduct backend testing
• Critically evaluated information gathered from multiple sources and worked with customers to assess whether data conformed to data governance approved mappings and standards.
• Carrying out data mapping, impact analysis for data governance projects working closely with data stewards and model execution teams.
• Involved in process modeling, conducted & Participated in Joint Application Development (JAD) sessions with System Users.
• Consultant at a medical device company on a GxP program documenting laboratory and production applications.
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Performed Load and Stress Testing using Load Runner.
• Automated confidence tests that run on new builds on regular basis.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Involve in preparing Trace Matrix to design test cases
• Preparing Weekly action report & QA feed back to QA team & Manager.

Confidential, Thousand Oaks, CA

Business Analyst

Environment: Mainframes, COBOL, JCL, Db2, Oracle, rRDM, Java/J2EE, SDLC, Rose, MACROS, MS SQL 2000, Cognos, ETL, MS Word, MS Excel, MS Visio, SAS,Pivot Tables, Agile/Scrum LoadRunner, WinRunner

Responsibilities:

• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Involved in all phases of SDLC from root cause analysis,databaseand technical support with timely delivery against aggressive deadlines.
• Analyze and map business processes forBPMN modellingand process automation
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables
• Created Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports using SSRS and Crystal Reports.
• Involved in Supply chain Management module to implement ERP application
• Conducted Enterprise Analysis, created a Business Process Model Notation Map and authored a Gap Analysis to address the gaps in the system
• Integrated Salesforce CRM with Siebel CRM explicitly using web services API.
• Provided subject-matter expertise in the team’s transition from Waterfall to Agile, process improvement, establishment of rRDM quality standards and best practices.
• Participated in the Data Governance working group sessions to create Data Governance Policies.
• Used Collibra connector to pull the data from the Collibra Metadata tool.
• Integrated different services with the Collibra and used MuleSoft for transforming from one format to other.
• Integrated different databases with Collibra using MuleSoft.
• Creating mockups of Dashboards and individual data visualizations in MS Excel.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions
• Documenting the Data quality scores in Collibra using integrations with Informatica Data Quality.
• Used different Control Flow Tasks and Data flow Tasks for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Researching, analyzing, projecting cost of inventory for projects, reconciling balances, process mapping, developing policies and procedures to improve tracking and issuing of Watershed material, preparing MS Excel, and MS Word Reports for Senior Management.
• Responsible for managing process of recycling and disposal of used material and obsolete.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Used Data Loader for insert, update, upsert, and bulk import or export of data from Salesforce Objects. Used it to read, extract and load data from comma separated value (CSV) files.

Confidential, Indianapolis, IN

Business Analyst

Environment: Scrum, Agile, Unix, ClearQuest, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Macros, Sybase, PL/SQL VBScript, C#. Microsoft Office Suite, SOA, SDLC, MS Access, SAS,Microsoft Visio, Pivot Tables, DOORS, Cognos, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner

Responsibilities:

• Analyzed and reviewed various low-level and high-level requirement documents such as Technical Requirement Documents (TRD), Use Cases, Design Documents (DD), Application Design Documents (ADD), and Process Flow Diagrams.
• Experience in Clinical Data Analysis in accordance with guidelines and providing Clinical Study Reports.
• Identify source systems, connectivity, tables, and fields, ensure data suitability for mapping.
• Designed data flow models, and performed functional decomposition analysis on various business processes.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.
• Create workflow using Business Process Model Notation (BPMN), and Visio.
• Responsible for developing strategic objectives that ensured supply chain efficiencies, reliability and responsiveness. Supported the Reengineering of a Supply Chain Management Gap Analysis.
• Business rules and Policies were defined for some of the data assets. Based on the results obtained from external data quality tools that validated these business rules (in the form of data quality rules), relevant data quality metrics were loaded into Collibra against the data assets
• The data assets obtained from the reporting tool, the data integration/ETL tool and the databases (transactional and the data warehouse on which the reports are run) were obtained and loaded into Collibra.
• Responsibilities included creating production as well as Adhoc reports using PC/SAS/SQL accessing DB2 as well as Oracle databases.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Responsible for requirement and design documentation review, test plans, identifying and reporting software anomalies and test results.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Conducts coverage analysis of clinical research trial procedures to delineate standard of care and research procedures; reaches out to research site to assist in determining charge direction.
• Conducted process mapping and process pinch points during a Kaizen activity to reduce tool and manpower waste.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Created test scripts for all the test cases in PL/SQL.
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the end-users to gather key issues involved in the project and propose the new solutions.
• Used the guidelines of the Rational Unified Process (RUP) to strategize the Implementation of Rational Unified Process effort in different iterations and phases of the project.
• Supported the assigned project manager with creating detailed project plans assisted in developing, scheduling and tracking project timelines.

Confidential, Foster City, CA

Data Analyst

Environment: XML, Java, J2EE, JSP, RUP, VoAVPN, Oracle, MS Visio, MS Office, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, SAS,Quick TestPro, Agile,Rational Clear Case,Doors, IBM WebSphere

Responsibilities:

• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Worked as an Interface between the Users and the different teams involved in the application development for the better understanding of the Business and IT Processes.
• Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
• Extensive experience in Clinical Data Management, data analysis and generated CRT tables, reports, graphs for FDA submission according to protocol.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Use of cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports & custom reports in SSRS.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical data base in the form of Star Schema for Data Mart Design.
• Ensuring the Decommissioning approach identified for the systems is GMP compliant if different than regular SOP Process.
• Involved in Preparation of Test Procedures, Test Scenarios, Test Cases and Test Data. Tested the company's Salesforce CRM application.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Designed and implementbusinessintelligence solutions for reports and ETL functionality, Testing.
• Followed PPD's System Life-Cycle (SLC) and Computer System Validation (CSV) procedures, as appropriate
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Performed data analysis and development for the Customer Offers and Targeting team, using SAS Enterprise Guide, SAS Grid, Unix, Teradata, and Proc SQL.
• Responsible for designing, developing, testing, documenting and delivering technology solutions for Microsoft Dynamics ERP, Management Reporter, Crystal Reports, and SQL Server including customizations and alterations to existing applications.
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the mappings. Identify and document the source to target mapping data lineage.
• Created the design and technical specifications for theETL processof the project.
• UsedInformaticaas an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Promoted, Implemented and Tested Informatica objects from Development to UAT to Production environments.
• Organize JAD Sessions to collect requirements from Subject Matter Experts SME's and prepare business requirement and Technical requirements that provide appropriate scope of work for technical team to develop prototype and overall system.
• Represented the BPM team in a project involving modeling internal business processes using ARIS process mapping software to identify redundancies
• Was responsible for helping in the progress of serversystemsfor thePharmaR&D data center.
• Extensive use Enterprise Document Management System (EDMS) such as Livelink and Ms SharePoint
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Responsible for providing analytical support in the Design, Development and Implementation of Project.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Confidential, Louisville, KY

Business Analyst

Environment: UML, UAT,MS Word, MS Excel, Visio, MS Project, Windows XP, SQL,SSIS,SSRS,XML, UML, Scrum / Agile, QTP, Sprint Planning, User Stories, Power MHS,JIRA,SQL SERVER.

Responsibilities:

• Involved in tracking business goals, performance and status across the projects.
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Thoroughly involved in creating 837 I and P encounters file, handling file edits and rejection files from the state and SFTP connection/ for file transfers
• Responsible for updating weekly status to the Project Manager.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation. Involved in HIPPA Complaint X12N837 Transaction testing.
• Implemented EDI applications to process Health Care transactions as per the HIPAA implementation. Wrote SQL Queries for Back End Testing.
• Created Use cases, Class Diagrams, Sequence Diagrams and Data Flow Diagrams using Rational Rose and Visio for new procedures that would help improve existing processes
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice.
• Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
• Created Source to target Data mapping document of input /output attributes with the proper transformations which would help for the easy development of SSIS bridge.
• Assisted in working in establishing EDI system security by suggesting the solution and getting the solution implemented
• Analyzed change requirements for Providers, Contracts and Claims processing modules configuration in Facets system for Medicaid and Medicare Advantage Plans.
• Manipulated large quantities of data using tools such as Python, Microsoft Excel, SQL and Tableau
• Created Dashboards for Managers.
• Created Data Quality Scripts using SQL and Hive to validate successful data load and quality of the data. Created various types of data visualizations using Python and Tableau.
• Wrote and executed SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Tested connection between MIT and tandem DB (Care Cast) to make sure successful incoming and outgoing file transfers between two systems.
• Created and maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).
• Assisted project managers and technical leads through design and implementation by identifying, analyzing, redesigning and documenting all phases ofSDLC.
• PerformedGap analysisand provided prospective solutions which were discussed with theProduct Owners
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Design and develop the data load process using XML Style sheets and ACORD.
• Analyzed clients systems and business processes.
• Responsible for gathering requirements, data mapping, gap analysis, andprocessflowand activity diagrams in changing old MMIS and Involved in testing new MMIS.
• Used Agile methodology to gather requirements and work with the development and testing team Produced requirements and system work products including: Business process and data flow diagrams, Use cases/User Stories, Wireframe
• Conducteddatamodeling JAD sessions and communicateddata-related standards.
• Designed Use Cases, Use Case diagrams, Sequence diagrams in UML methodology using MS Visio.
• Well versed with HIPAA, Facets System, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Tracked Business requirement traceability matrix (RTM).
• ImplementedHIPPA Privacy and Security rulesfor Implementing HER.
• Built and maintained complex SQL queries for data analysis and data extraction.
• Extracteddatafrom Oracle database andSQLserver database for designingSSIS packages in Visual Studio.
• Authored and updated test plan and test scripts using QTP
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Netezza.
• Created Business Process Flow Diagrams to assist the Technical Team.
• Assisted the QA team, by testing web applications using Quality Center.
• Created several types of reports usingSSRSlike parameterized, drill down and drill through reports.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Used MS Visio for business flow diagrams and defined the workflows.
• Created Window declarations, added and maintained methods and functions in Silk include files.
• Documented the complete process flow to describe program development, logic, testing and implementation, application integration and coding.
• Planning testing scenarios, preparation of test cases and data validation using PL/SQL. Create adhoc reports for testing purpose.
• Incorporated Scrum eventsBacklog refinement, sprint planning, standup meetings and retrospective meeting.
• Interacted with underwriters to understand multiple data points.
• Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process
• Generated the detailed reports of the bugs, pass-fail report, and comparison chart and reported the same in Test Director.