Business Analyst and I.T professional, with experience in the Financial and Pharmaceutical areas in enterprise environments. Excellent communicator, unique mix of people and technical skills. Strong work ethic, teamwork, leadership skills, flair for innovation with background in people leadership & project management, Emphasis on Mathmatical/Statistical Business/Data Analysis, Database and Data Warehousing, SQL – Triggers/Stored Procedures, BI.
GRADUATE SCHOOL 2004-2007
University Consortium involved with the St. Louis RCGA – Regional Commerce and Growth Association
Rensselaer Polytechnic Institute Washington University Florissant Valley College
Master Data Management, Database Modeling, SQL & PL/SQL, Data Warehousing, Data Mining Algorithms.
EDUCATION & ASSOCIATIONS
University of Illinois
- Institute of Electrical and Electronic Engineers - AMSTAT (Stats)
PFIZER Cambridge, MA
Managed development & operation of Oracle/IBM DB2 backend database systems.
Designed data warehouse to extract key info on compounds & their characteristics for research and market implementation for future Clinical (Pre-Clinical) Trials 1-IV (Survival/Adverse Events - KM) and Adverse Events (Arisg).
Implemented SAS programs to capture statistics/graphs for univariate and multivariate statistics.
Statistical breakdown showing patient responses in various phases of drug dosages and SOP's that improve business operation. Assisted CRO's, CRA's & RN's with Data Collection - CRF's
Achieved 20% speed increase on queries and 15% cost reduction by improving production time through formulated table layouts and analysis and scheduling methodologies with Oracle Discoverer, Informatica, Microstrategy, B.O./Crystal Reports with Data Mining methods.
Created ER diagrams-table for Oracle/DB2 instances for data querying from various tools such as Business Objects - Crystal Reports, Brio Query, and Access/Excel.
Managed data, designed database and enhanced performance; delivering applications and business processes aimed at helping clients reduce costs, enhance organizational flexibility, and improve business and IT performance internally and with CRO's using as EDC/Intense Clinical Lab Testing, Pharmacology, Adverse Event Monitoring.
Performed technical support for Oracle products, including Quest SQL Navigator and Developer 2000
Supported database administrators and technical staff in ODBC setup and SQL connectivity
Assisted setting up SAS PROCs to enable the completion of highly complex population studies
Assigned to design forms; write, debug and revise PL/SQL Triggers; and support UNIX connectivity for Biometrics (BLAST)/SAS UNIX users
Admin for Windows networks, and provided level 2 and 3 technical support of all Pfizer's clinical with such products as B.O. Crystal Rept., COGNOS.
EDS – Electronic Data Systems
SED Program TX
Applications Developer / Systems Administrator
Productively gathered business solution claim information and captured large amounts of complex medical financial claims (risk pools) data to assess rates charges of risk pools saving the HMO about $3 million over a 5+ year period
Systems Engineer for the database warehouse programmatic updates for statewide Medicare A & B reimbursement claims (principal component of a EDS’s $100 Million contract with BCBSMA) ensuring compliance to SLA requirements that helped avoid thousands of dollars in penalties,.
Worked with physicians and pharmacist on data warehousing on formularies, ensuring quality control and compliance to state and federal and corporate regulatory controls.
Presented mathematical and programmatic methods to HMO executives to enable better negotiation of contracts with physicians and clinics regarding Diagnosis using ICD Codes, Claim Processing and rate structures. Assisted accountants in producing a "Financial Results" document for HMO-Blue that accurately outlined its financial status, client risk pools progress within various departments for re-engineering project
Designed data mining algorithms for extraction of data from the IBM mainframe, as well as providing analysis of hidden trends, financial information, benchmarks, medical claims data and health demographics for the HMO that achieved a four-star rating from HMO-Blue as noted in NEWSWEEK, June 24, 1996, putting it into the Top 20 Rating of HMO's.
SAIC LaJolla, CA
• Systems Engineer in La Jolla and Herndon VA & CT, for U.S. Navy Hospital Research Facilities.
You need to be a member of AnalyticBridge to add comments!