Developer Data
Resume:
Kenneth Wolin
Phoenix, AZ *5008
***.*****@*****.***
Summary of Qualifications
Kenneth Wolin offers over 20 years experience including more than 15 years specializing in the design, development and implementation of business intelligence solutions.
During his career he has held positions ranging from DBA to developer to technical architect to project lead to corporate director. Ken brings expert level skills to all areas of a project including: requirements gathering, data architecture, database design and front-end implementation. Moreover, Ken is a dedicated problem solver with demonstrated abilities for both understanding and explaining issues from business as well as technical perspectives and, his project successes are characterized by a hands-on motivational leadership style.
Professional Experience
American Express, Phoenix, AZ 1/2014 – Present
Technical Lead Developer
Primary Responsibilities:
Spearheading project to implement MicroStrategy Visual Insights and
Self-Service Analytics Internationally.
Uplift of MicroStrategy 9.01 to 9.41
Analyzing other Visual Insight Tools to meet specific business needs. (Networking Visualizations)
Creating Reports, Dashboards, and Visual Insights using MicroStrategy as the reporting tool.
Key Technologies:
MicroStrategy 9.41 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Delivery Services, and Narrowcast, Web Visual Insights, and Desktop Visual Insights.)
Netezza, Oracle, and Teradata
Informatica
Selling Source, Las Vegas, NV 4/2013 – 11/2013
Sr. Business Intelligence Analyst
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Analyze all Data and Build all MicroStrategy Schema Objects
Build reports and Dashboards to provide Business Users with Analytics.
Reports and Dashboards using MicroStrategy as the reporting too tool.
Key Technologies:
MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
SQL Server
Bayer Healthcare, Warren, NJ (Contract – Cognizant, Inc.) 2/2013 – 5/2013
Architect
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds delivered on Mobile IPads..
Analyze all Data and Build all MicroStrategy Schema Objects
Build reports and design Mobile Dashboards to provide Business Users with Analytics.
In the Architect role I built out a new datasets of and create new
Reports and Dashboards using MicroStrategy as the reporting tool and Mobile delivery.
Key Technologies:
MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast)
Oracle and SQL Server
Hyundai Motors, Costa Mesa, CA (Contract – Cognizant, Inc.) 9/2012 – 2/2013
Architect
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Analyze all Data and Build all MicroStrategy Schema Objects
Build reports and Dashboards to provide Business Users with Analytics.
Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
In the Architect role I built out a new datasets of and create new
Reports and Dashboards using MicroStrategy as the reporting tool.
Key Technologies:
MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast)
Oracle and SQL Server
The Gap Inc., San Francisco, CA (Contract – Nelson Technologies) 2/2012 – 9/2012
Architect
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Build reports and Dashboards to provide Business Users with Analytics.
Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
In the Architect role I built out a new datasets of and create new
Reports and Dashboards using MicroStrategy as the reporting too tool.
Key Technologies:
MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
DB2 and Teradata Database
Intel Corporation, Chandler, AZ (Contract – Randstat Technologies) 5/2011 - 2/2012
Lead Developer
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Build reports and Dashboards to provide Business Users with Analytics.
Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
In the Architect role I built out a new set of and create new
Reports and Dashboards using MicroStrategy as the reporting too tool.
Key Technologies:
MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
SQL Server and Teradata Database
Department of Energy – Richland, WA (Contract – Qlarion, Inc) 2/2011 – 5/2011
Senior Architect / Lead Report Developer
New Warehouse based on Sybase backend
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
In the Architect role I built out a new set of data and create new
Reports and Dashboards using MicroStrategy as the reporting too tool.
Key Technologies:
MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
Sybase Database
Walt Disney Studios, Burbank, CA (Contract – Global Touchpoints, Inc) 9/ 2010 – 2/2011
Senior Architect / Lead Report Developer
Review current on-going projects for Best Practices.
Primary Responsibilities:
Work with the Business Users to define analytics required for the existing reports and the new
Reports that will be available from the various new data feeds.
Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
In the Architect role I built out a new set of data from upgraded Siebel System and create new
Reports and Dashboards using MicroStrategy as the reporting too tool.
Key Technologies:
MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
DB2 Database
Wellcare Health Plans, Inc. (Contract - Momentum Consulting) 5/2010 - 9/2010
Acting Senior Architect
Review current on-going projects for Best Practices.
Primary Responsibilities:
Collected reporting requirements from the business users based on the existing and new data sources.
Review existing projects and evaluate current Schema to add new data sources.
Architected a new set of data sources and added them to the current project. Created new Reports, Dashboards, and Scorecards using both IBM Cognos tool and MicroStrategy.
Key Technologies:
MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Narrowcast)
IBM Cognos
Teradata Database
United States Post Office (Contract – Prime Software Technologies) 10/2009 - 3/2010
Acting Senior MicroStrategy Architect
Review current on-going RDM projects for Best Practices.
Primary Responsibilities:
Interviewed the business users and the current project personnel to draw up a project plan for the Architectural changes requested and outlined the steps to implement them.
Review existing projects as MicroStrategy Architect and evaluate consolidating Dimensions and removing Duplicates.
Interpret MicroStrategy Integration Manager results to pinpoint Reports that need to be changed for new consolidated data structures I have Architected and created.
Documented all changes and created a roadmap to the data for both before the changes and after the Architect changes for future reference.
Key Technologies:
MicroStrategy 8.11 (Desktop, Architect, Intelligence Server, Report Services, Narrowcast)
MicroStrategy 9 (Integration Manager)
Teradata Database
Wolters Kluwer (Now Symphony Health Solutions) (Contract) 7/2009 - 10/2009
Review project and reporting request from business users and delivering them using multiple methods.
Develop Microstrategy Office to PowerPoint reports that dynamically update for 2 key clients.
Primary Responsibilities:
Review existing projects and meet with clients to develop reporting package
Create MicroStrategy Office PowerPoint Decks with over 60 reports that will now automatically update.
Lead MicroStrategy Developer
Key Technologies:
MicroStrategy 8.02 (Microstrategy Office, Intelligence Server, Desktop, Report Services, Narrowcast)
MicroStrategy 8.1 (Microstrategy Office, Intelligence Server, Desktop, Report Services)
Microsoft PowerPoint 2003
Bank of America (Contract – iOLAP, Inc) 8/2008 – 2-2009, 6/2009
Survey Design of Projects with an eye toward Best Business Practices.
Report Services Document Construction for Global Treasury Division.
Primary Responsibilities:
Review Project Architecture, Data Implementation, and Existing Reporting
Created MicroStrategy Dashboards to represent the 2 highest levels of the Treasury hierarchy. Upon acceptance the reports were opened up to all levels of the Treasury Sales hierarchy. The Desktops that I created with Banks of America were included in Microstrategy Regional Meetings with the Managing Director of the Treasury Division presenting them across the country.
Lead MicroStrategy Developer
Key Technologies:
MicroStrategy 8.02 (Intelligence Server, Desktop, Report Services, Narrowcast)
Ryder Systems (Contract - iOLAP, Inc) 2/2009 – 3/2009
Data Architecture
Integration of New Data Sources.
Primary Responsibilities:
System Integration of New Data Sources
Lead MicroStrategy Developer
Lead MicroStrategy Architect
Key Technologies:
MicroStrategy 8.021 (Intelligence Server, Desktop, Report Services, Narrowcast, Architect)
Verispan, LLC (Now IMS Health) (Full Time Employee ) July 2003 – March 2009
Retail Pharmacy Analysis-
Led implementation of Retail Pharmacy Chains business intelligence solution.
The solution allowed analysis of drug efficiency across client and non-client pharmacies with data sourced from multiple prescriber and patient data stores.
Solution included a 1TB+ data warehouse with over 2000 users.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Lead Narrowcaster Developer
Key Technologies:
MicroStrategy 8.02 (Intelligence Server, Desktop, Narrowcast)
Oracle 10g
Oracle Designer - ERWin
Marketing Science-
Led development for Marketing Science Department QC effort
Worked closely with key business users to develop reports in MicroStrategy to support the quality control of Verispan patient data
Solution included a 1TB+ data warehouse.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Key Technologies:
MicroStrategy 8.01 (Intelligence Server, Desktop, Narrowcast)
Oracle 10g
Oracle Designer - ERWin
Vector One Indication-
Leader of team to design and build a new data warehouse on Oracle 10g that created Verispan’s first opportunity to combine their prescription data with patient and hospital diagnosis data.
The reports allowed sales force management to target areas of significant opportunities where qualifying brands were under utilized.
Solution included a 1 TB+ data warehouse with over 300 users.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 8.0 (Intelligence Server, Desktop, Web)
Oracle 10g
Oracle Designer - ERWin
Total Patient Tracker-
Designed a new data warehouse to focus on market research analytics and project management.
The product was used by Verispan client companies to research total unique patient counts by brand using market basket analysis reports
Solution included a 1 TB+ data warehouse with over 300 users.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 8.0 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Media Market Analyzer-
Lead Developer in the design and reporting teams for warehouse.
Developed reports at Zip Code and MSA levels to assist Verispan client companies in planning media buying activities for the purpose of recruiting patients for clinical trials.
Solution included a 1 TB+ data warehouse with over 300 users.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 7.0 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Astra Zeneca-
Led the design teams for a data warehouse to allow reporting by the Oncology, Respiratory, Cardiovascular, and Neuroscience business units.
Delivered reports to District Managers at the territory level for the purpose of analyzing Territory Rep performance.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 8.1 (Intelligence Server, Desktop, Narrowcast, Web)
Oracle 10g
Oracle Designer - ERWin
Quintiles Transnational (Purchased by Verispan) Dec 2001 – Jul 2003
Allergan, Inc-
Led JAD sessions to determine business rules and practice requirements for reporting and design to analyze retail pharmacy information in combination with other managed care and hospital data sources.
Reports enabled the Large Account Managers to target and to realize sales data changes by Manager.
Primary Responsibilities:
Project Manager
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 6.0 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Dura Pharmaceuticals-
Created reporting package to allow district, regional and home office sales managers to view sales activity and pinpoint sales opportunities.
Integrated call management data from Seibel call system.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 6.0 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Center for Disease Control (Public Health Surveillance)-
Lead developer on a warehouse that tracked prescription trends at national, MSA, and Zip Code levels enabling the CDC to spot trends that could indicate the beginning of a disease outbreak.
Application tracked large purchases of particular brands that could be a leading indication of a Homeland Security problem.
An example of this type analysis would be large purchases of Cipro the brand name drug used to treat Anthrax.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 6.5 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Amaxis (Purchase by Qunitiles) May 1999 – Dec 2001
Amgen-
Worked with client for initial data base schema, reporting, implementation, and training.
Architected a star schema for the Oncology Marketing Business Unit. Warehouse combined internal, IMS prescription, wholesale, prescriber and managed care data with integrated Seibel Prescriber Call Data.
First time the client had a total view of business using the various internal and external syndicated data sources
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 6.5 (Intelligence Server, Desktop, Web)
Oracle 9i
Oracle Designer - ERWin
Sepracor Pharmaceutical-
Architected a schema design for the purpose of analyzing sales data captured by the Sales Logix territory management system in combination with IMS prescription data
The reports were automatically exported to multiple worksheets in Excel that contained macros to reformat data.
One of the custom reports was a Weekly Activity Report which showed the hours spent actively calling on Physicians and the corresponding increase or decrease of prescription dollar activity.
Primary Responsibilities:
Lead Project Architect
Lead MicroStrategy Developer
Performance / Aggregate Tuning
Technologies:
MicroStrategy 5.5 (Intelligence Server, Desktop)
Microsoft Excel
Oracle 9i
Oracle Designer - ERWin
Technical Skills
Operating Systems
Microsoft Windows 2000 Advanced Server, NT 4.0, Win 95/98
RDBMS
Oracle 9i, 8i, 8
SQL Server
DB2
OLAP Client Tools
Member MicroStrategy Beta Test Team
MicroStrategy 8, 7i, 7.0, 6.0, 5.0
Development
Data Modeling: ERWin
Visual Basic
Education
St. Joseph’s College – Rensselaer, Indiana
B.A., Economics with an emphasis on Finance, Money and Banking
SetFocus – Parsippany, NJ
Microsoft Business Intelligence Master’s Program
Contact this candidate