SUMMARY Information Technology professional with 25 plus years' experience in the pharmaceutical, manufacturing, and financial service sectors. Executive level demeanor, excellent project, technical, analytical, development skills, ability to easily communicate with business personnel as well as technical administrators. Demonstrated ability to handle multiple demands with competence, exhibiting high standards of quality, discretion and integrity with tact and diplomacy. 

AREAS OF EXPERTISE Provider of analytical reporting solutions for business users using any industry leading CRM software or reporting software or Excel Provider of C-level summaries, analytics, and key metrics to all levels of management Expert skills as an analyst in designing and leading the development of custom applications and interfaces for the transformation of data into useful information. Primary technical architect for multiple successful global Oracle application ERP implementations v10.7, v11i Primary technical architect of CRM, data warehousing and high availability solutions for Oracle database environments Lead analyst in collaborating with users to design financial, order management, periodic financial reporting

TECHNICAL SKILLS Skilled with Salesforce, QCommission, QuickBooks, NCPDP standards, PBM software Skilled with Windows batch, Powershell, and any SQL scripting, databases Skilled with Business Objects - Crystal Reports, Excel macros, Visual Basic Microsoft Office Excel, PowerPoint, Word, Access and Adobe Toolsets Skilled with data extraction, translation tools, ETL toolsets, Cognos, YellowFin In depth knowledge of Oracle Application Financials, Manufacturing, Order Entry/Shipping Modules In depth knowledge of MS SQL Server database and TSQL Working knowledge of TCP/IP protocol Network Layers Experienced with Oracle Tools: PL/SQL/SQL Plus /Discoverer/Express Benthic Software Golden32 SQL Scripting utility Financial Tools Analysis Services, Hyperion Enterprise, Pillar, OLAP, Essbase Security Policies Procedures

EMPLOYMENT HISTORY ConfidentialIT Director, formerly IT Manager and Senior Business Analyst Responsible for self-funded group implementation on PBM platform MeridianRx Setup multiple new companies and designed the application interface to be used by the new companies, managed multiple locations and all project development Analytical reports developer creating Microsoft SQL Server scripts and interfaces, Powershell and batch script development in addition to Excel pivot tables. Salesforce administrator, email administrator, financial systems administrator, Windows system administrator, VOIP Asterisk, FreePBx administrator Responsible for monthly commission's script development and generating reports IT applications and reporting analyst for all departments, clients, and vendors including C-level, management Liaison with Center for Medicare/Medicaid Services CMS Planned and executed computer room migration to new location, researched and provided analytical/financial comparisons for software applications and hardware components Directly reported to CEO, formerly reported to CTO Confidential Senior Business Analyst, Operations Responsible for implementing clients using PBM supplied software system, MedAccess setups, designing new or enhanced business processes, daily and longer term client requests for file interfaces, reports, setup questions related to eligibility and claims processing, NDC reporting using MediSpan or First DataBank. Handled eligibility, benefit linkages, interfaces, RDS submissions, client reports, analysis reports. Use MedOptimize, Oracle SQL toolset, Benthic software Golden32 , created SQL scripts, utilized SalesForce, and Intuit QuickBase service request management system. Implementation of file interfaces including NCPDP files and custom formats for eligibility, claims, and web portal configurations for new clients for discount card portfolio. Core team member for all new and enhanced client implementations Confidential IT Director and Senior Business Analyst Designed, developed, and supported SQL Server scripts, interfaces from MedImpact/SXC-Catamaran/AGELITY PBMs , Excel and MS Access forms, applications and reports to executive management, finance, and operations management. Trained personnel to use custom applications. Primary resource for producing eligibility/claims/analysis reporting. Developed and supported existing Microsoft Excel based macros for producing weekly, monthly sales and operation reports. Designed websites using GoogleSites and other freeware. Implemented QuickBooks Enterprise for Finance department. Directly reported to COO Confidential Assistant Vice President, Credit Management Designed, developed, and supported Excel and MS Access forms, applications and reports including Crystal reports to executive management, risk management, and product management for the consumer loan, residential loan, and credit card portfolios. Trained customer service personnel to use custom applications. Working with a team, evaluated multiple software applications from various collection vendors and negotiated with one of the industry leading software vendors for a new pre and post charge-off collections system with predictive dialing and workflow capabilities. Developed and supported existing Microsoft Excel based macros for producing weekly, monthly reports. Supported Windows XP Upgrade project by creating technical environment and authoring documents about MS Access and Excel macro solutions. Confidential Manager Lead Developer, Business Analytics Developed and deployed Hyperion Essbase applications, Oracle Discoverer reports, and Oracle Financial Analyzer business analytic application rollouts for US and Canadian sites for major Oracle Applications v11.5.9 ERP implementation. Personally responsible for insuring application functionality and application data functionality satisfied business user requirements. Worked closely with technical support personnel vendors and internal on product functionality and application performance. Collaborated with sales/marketing, finance, supply/demand chain, operations management to design custom reports. Responsible for all policies and procedures related to business analytic functionality. Trained hundreds of users on various applications and software packages. Worked directly on global reporting projects with headquarters in Israel. Worked closely with Oracle Consulting services to design, develop, and implement Oracle Express/Oracle Financial Analyzer OFA /Oracle Demand Planning ODP software applications over Oracle applications v11.5.8/11.5.9 Authored Reporting Strategy and architecture document for generic pharmaceutical manufacturer which included rollout strategies for Oracle Discoverer Plus web-based , Oracle Express/ODP/OFA, and Hyperion Essbase. After 3 months of employment, was able to replace two long term business analytic consultants Responsible for reviewing all Hyperion Essbase/Planning license and maintenance agreements. Worked with a global team to designed and developed multi-site daily net sales/gross margin reporting system by customer and product. Responsible for design and development of Hyperion Essbase applications and SPSS Showcase reports over DB2/400 and various corporate data stores. Created and rolled out over 200 reports in one year timeframe. Confidential Senior Business Analyst Developed Cognos Impromptu and PowerPlay reports for departmental reporting and trained company users to utilize Cognos toolsets, developed Hyperion Essbase cubes and reports. Implemented data warehouse using Cognos toolsets, Oracle database, and UNIX scripts reduced month end close days from 10 to 3 resource/report processing costs by over 150K. Additional responsibilities included managing Oracle Applications database environment including Order Entry, Shipping, General Ledger, Manufacturing modules. Managed and redesigned engineering hardware infrastructure and database schemas. Confidential Sr Programmer/Analyst AS/400 IBM RPG III, COBOL, and PL1 interactive forms, reports programming. SQL programming. Client Access reports, produced sales and operation month end reports for executive management. Confidential Programmer/Analyst AS/400 IBM RPG III, COBOL, and PL1 interactive forms, reports programming. SQL programming. Confidential Computer Operator -