SUMMARY:

Information Management and Reporting Professional, with 20+ years of progressive experience in all aspects of Information Management including Project Management, Business Analyses, Problem solving, Systems Design & Development, Rollout and Change Management, Systems Administration. Hands - on experience in business process engineering, implementation of new service delivery methods \ procedures\ techniques and developing applications for Country, Region and Global level Finance, Supply Chain, Sales, Marketing, Commercial, Research and Development Functions. Expert functional end-to-end Corporate P&L reporting and accounting. Work as a Team Leader and Team Player to excel in highly matrixed environments with onsite and offshore resources.

TECHNICAL SKILLS:

Systems Expertise: IBM Cognos Confidential, SAP, Oracle, Microsoft SQL environments.

Strong working knowledge of: MS office suite - Excel, Word, Access, PowerPoint and MS Project

PROFESSIONAL EXPERIENCE:

Confidential

Global Application and Project Manager

Responsibilities:

• Responsibilities included identifying, assessing, analyzing, developing and implementing innovative information management and reporting solutions in partnership with local and global business functionn leaders / stakeholders and subject matter experts. Lead all aspects of solutioning including, gathering and prioritizing users’ requirements, defining the technical architecture, designing the application, testing and roll out management and users training. Provide technical supports for 40+ data management and reporting tools, for approximately 3000 users in Country, Region and Global functions.
• Project Manager for an application to consolidate Global Long Term Demand and Capacity Planning.
• Oversee ground up design, governance and deployment of the planning tool for the Global Marketing and Supply Chain Functions.
• Tool helped collect and report 10 year SKU Level volume forecasts for making Capacity Investment decisions.
• Designed a Clinical Trial Data Flow automation tool for the Oncology Program Finance Officers to track and forecast financial information for Global Trials.
• Built a simple Tender tracking tool for the Russia Country Pharma Organization that helped Finance and Commercial
• Functions to plan and report Tender risks and opportunities.
• Led a financial planning application consolidation and migration initiative that consolidated multiple server environments for several countries into a single instance that reduced overall support costs by 50%.
• Designed and implemented end to end Financial Planning and Budgeting tool, based on SAP and Confidential, for Canada, Turkey, Brazil, Mexico and the Middle East North Africa Region. Automated data transfers and simplified data consolidations that reduced average planning and budgeting cycle time by 40%. Led the requirements definitionsystem design, implementation and change management work streams.

Application Manager

Confidential

Responsibilities:

• lead various corporate and strategic planning initiatives for commercial, finance, development and managed markets functions.
• Manage the consolidation, filing and reporting of Strategic Plans, Budgets, Monthly Forecasts and Demand Plans with an offshore resource team.
• Reduced budget submission cycle times by 20% and improved the accuracy using process changes and system automation.
• Implemented an allocation methodology for Marketing Spend, for the Confidential, across the entire $10B portfolio.
• Methodology and system design automated the manual tasks of allocating non brand related expenses to appropriate Cost Centers.
• Improved Spend Transparency and Forecast Accuracy for the Confidential by automating data entry, transformation, and management reporting.
• Led application migration for 3000 users from Confidential version 9.5.2 to 10.2, including training activities.

Project Leader

Confidential

Responsibilities:

• Managed activities for optimization and improvement of existing environment, analyze gaps for cost savings and reduce manual steps and human error.
• Designed and implemented ODBC interfaces for automating financial data load, extract and reporting operations for Confidential which is an innovative iPad-based executive management reporting & analysis solution that efficiently integrates Finance, Business Analysis and Marketing Science.
• Led Technical architecture and design for a Medical Forecasting application to Improve forecast accuracy, enhance transparency for monthly medical spend.
• Create fully automated Confidential application for managing Commercial and Government Contracting revenue deduction data from Model N and Medicaid data from Revitas Flex systems.
• Led application migration for 3000 users from Confidential version 8.4 to 9.5.2

Senior System Developer

Confidential

Responsibilities:

• Responsible for new development and maintenance of UNIX, SyncSort, DataStage, SAS and Automation of ETL process job streams for major Data Warehouse.
• Implemented several enhancements to automate and streamline processing for Customer Analysis Data Integration (CADI) VB applications including Account Mapping System(AMS), design/structures and Managed Status applications for processing marketing data in the Confidential data warehouse (Oracle database), PL/SQL.
• Developed and implemented processing to import data from Siebel SFA system to Confidential data warehouse.
• Led Production support of weekly and daily Confidential ETL processes of for Unix-based and SAS data load jobs.

System Analyst /Developer

Confidential

Responsibilities:

• Migrated Aim Quest application to VB base Viper Incentive \ Payroll system.
• Developed, implemented, and supported promotional tracking system.
• This project consisted of a VB application to control and manage all promotional products utilized by the sales force in marketing Confidential products.

Confidential

System Analyst /Developer

Responsibilities:

• Developed, and supported the Marketing Research Analysis System for a Major Pharmaceutical Company.
• The system was designed to review incoming email, process and merge the data with Excel templates.
• Developed and implemented a medical billing application.