PROFESSIONAL SUMMARY:

• Over 15 years’ of experience as Sr. Business Analyst / Data Steward (MDM)/Data Analyst in pharmaceutical industry.
• Awarded: Above and Beyond Award for Ensuring Quality for Merck deliverables Project (2010)
• Experience utilizing Excel and SAS with the Data Team to extract detailed data for analysis. Data Steward
• Experience with SFDC, Veeva, Customer Master Data and Data Warehouse, Reltio MDM. DDD, XPO and XPO Plantrak monthly and weekly data, WXDM, RXDM.
• Enterprise organizations including Confidential.
• Used Mainframe tools to retrieve, analyze, transform and report data.
• Exposure to Claims, Accumulator, Benefits, Eligibility. Developed detailed work plan to ensure project success. Worked on completion of PPT (Patient Profile Transfer)

TECHNICAL SKILLS:

• IBM Mainframe utilities
• IDMS database
• TSO
• UCC7
• ISPF
• SDSF
• OLP
• BETA92
• Cybernation
• CISC
• MS Windows
• Power Point
• Excel
• Outlook and WS FTP
• IDMS Database and VPN. Windows XP and Windows 7. PeopleSoft. Sales Force.com. Veeva. Reltio. Knowledge of SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

Sr. Business Analyst

Responsibilities:

• Responsible for evaluation and validation of HCPs, HCOs and HCA’s data using Reltio, prescribers and non - prescriber data and sales according to alignment and territories.
• Utilized Third party sources ( Confidential, DRG, AMA, NPI and internal sources) to assess and cleanse data for match and merge and to ensure system wide consistence across the divisions
• Detect and addressed concerns in data, and escalate to management.
• Monitor and improve data quality and suggest innovative solutions to data questions.
• Worked with global team, subject matter experts, and client teams to build and implement MDM Solution.
• Worked with client business (Sales, Operations, Marketing, etc.) and resolved concerns.
• Manage data migration and initial Data Quality and Load: Initial data load with high-quality data from different source systems
• Implemented and drove accountability of data policies and standards, requirements, and the concerns of all business stakeholders for the Data Stewardship Team.

Sr. Business Analyst

Responsibilities:

• Tested new products built for end users and conducted analysis phases of projects where the solution was deployed.
• Created robust and reliable test cases based on input for deployment during standard testing phases. Analyzed test results and made decisions and recommendations.
• Communicated results and coordinates logistics to the Systems Analysts, Developers, and other key IT staff and leadership as appropriate.
• Troubleshoot complex setup and to isolate, determine and report defect root cause. Documented defects with detail, accuracy, and conciseness while ensuring defect reproduction. Performed automated and manual testing, documenting associated results.

Sr. Business Analyst / Sr. Data Analyst

Responsibilities:

• Provided support to the organization in regards to the processing and validation of various Pharmaceutical data sources like Confidential prescription data utilized by field and home office personnel.
• Worked with Data Providers to capture and integrate sales data for use in internal deliverables such as Field Reporting (Veeva), Incentive Compensation, Analysis and Targeting.
• Entered Data on a daily basis into MDM and other source/target systems on an as needed basis. Monitored the workflow process for new data requests, changes and inactivation and entering data in appropriate systems.
• Ensure organizational and healthcare professional data integrity by using external sources to validate all new entries as appropriate. Worked on 2 projects creating business and person accounts during the open window for Q4.

Business Analyst / Data Analyst

Responsibilities:

• Worked with business partners to gather requirements for requested changes, review system capabilities, operational workflow and scheduling limitations to determine if requested business requirements or program change is possible within existing system. Inform/escalate project issues and facilitate issues resolution. Provide knowledge and investigative support to senior project stakeholders and documenting on SharePoint.
• Worked collaboratively with other departments and clients to resolve issues. Strong requirements elicitation and conflict resolution skills handled multiple priorities and demonstrated ability to manage timelines and meet tight deadlines and work independently.
• Assisted with Data collection and analysis, identified problem areas and recommended revising existing processes and SOW and communicated all findings with Managements.
• Worked on a Tracker to track different projects submitted by Sr. Managers and provide reporting, presentation using and assistance to supervisor using Mainframe, Power Point, Excel, Share Point and other ESI applications.

Business Analyst

Responsibilities:

• Tested new products built for end users and conducted analysis phases of projects where the solution was deployed.
• Created robust and reliable test cases based on input for deployment during standard testing phases. Analyzed test results and made decisions and recommendations.
• Troubleshoot complex setup and to isolate, determine and report defect root cause.
• Documented defects with detail, accuracy, and conciseness while ensuring defect reproduction. Performed automated and manual testing, documenting associated results
• Communicates results and coordinates logistics to the Systems Analysts, Developers, and other key IT staff and leadership as appropriate.

Confidential, Parsippany, NJ

Sr. Business Analyst/Data Steward analyst

Responsibilities:

• Coded reports for high profile pharmaceutical companies such as Confidential -Aventis, Merck, Novartis, Bayer Diagnostic, Genentech, J&J, Shire, Forest, Pfizer, GSK, Watson, Allergan, and Amgen, Biogen, Esai, Daiichi
• Created deliverable reports and analyzed large data in various audits such as DDD, Xponent, Xponent Plantrack, NRX, TRX, Early View Weekly, GPS, DMD, WXDM, Managed Care intellect as well as Confidential Data Warehousing Products in both Raw and Projected Data in both Retail and non-Retail Data. Reconciled weekly data for further projects. Worked with Large Dataset for MDM accounts ( Prescribers and Business accounts) and maintained Data base for specific clients.
• Lead efforts to assist in updating information in source systems to ensure all eligible customers are set up in MDM
• Performed a weekly review of targeted client rosters to ensure all changes, additions and deletions are captured in source system (MDM).
• Worked closely with internal and external stakeholders to understand business needs to identify enhancements to reporting and Master Data management
• Created and modified client’s files used for individualized client report creation and extracted data from company designed database such as: Physician, Hospitals, Warehouse, and Group Practice, Sales force alignment for monthly and weekly reports used for sourcing, forecasting, inventory and compensations. Analyzed Data for Confidential Physician compared to Physician Data from Client to eliminate dups.
• Verified clients’ own file by combining data from multiple sources for Data Cleanup and removed duplicates, consolidated information from Excel and Mainframe for verification purposes, used Excel Macro’s for calculation and used FTP to transfer data from mainframe jobs into excel to verify data. Coordinating re-runs and downloads for different extracts and corresponding with client service on when datasets will be created.

3