Peter Weinstein Email & Phone Number

Wethersfield, Ct, Us

Primary responsibility includes planning and business analysis. Lead a team of up to 3 BI professionals.BUSINESS INTELLIGENCELead the effort to deliver a Sales Planning tool that derived new business sales goals based on a business unit's corporate financial plan with overrides for local knowledge of agency production capacity. Lead the effort to deliver a suite of analytical tools that provided the ability to analyze submission and production results. Partnered with Communication, Implementation and Training teams to ensure a seamless roll-out to a user base of 2,000+.Reduced Ad-Hoc report requests 33% by analyzing needs and providing self-service Cognos and Excel reports for common requests.

Hartford, Connecticut Area

Primary responsibility includes strategy, planning and business analysis.BUSINESS INTELLIGENCEPrepared a start-up healthcare insurance organization to meet essential business intelligence needs by evaluating RFP proposals for payer, provider, member and patient analytics.

Primary responsibility includes strategy, planning, hiring and mentoring. Led a team of up to 4 BI and data warehouse professionals as well as intermittent third-party resources.BUSINESS INTELLIGENCEDeveloped predictive models to identify high potential athletes that were likely to accept a scholarship.Simplified BI methodology complexity by defining deliverables in terms of performance goals, indicators and measurements.Contained hiring costs by making use of creative techniques that identified promising entry-level candidates and hired a 4 person BI team for $300,000.ENTERPRISE ARCHITECTURESimplified enterprise architecture methodology complexity by identifying the basic TOGAF artifacts that were needed to create a viable architecture.Contained training costs by developing customized TOGAF enterprise architecture training and presenting it in-house over a period of 5 days.

Primary responsibility includes strategy, planning, hiring and training. Led a team of up to 7 BI and data warehouse professionals as well as intermittent third-party resources.BUSINESS INTELLIGENCEPrepared the university for cross-departmental data mining capability by proposing and obtaining approval for a $6.5 million 3 year data warehouse expansion project with a sustainment cost of $1.3 million.Improved the ability to meet Hyperion and FOCUS BI requests by analyzing and adjusting the staffing levels required to meet a 4 hour average request response time.DATA WAREHOUSINGExpanded data warehousing capability by proposing and obtaining approval for a DataStage ETL tool that was compatible with PeopleSoft supplied ETL and at the same time provided advanced features for in-house development.Streamlined DataStage ETL environment installation by leading a project team that worked collaboratively to deliver a stable IBM server, Oracle database and DataStage ETL tool infrastructure in 6 weeks.

Primary responsibility includes tactics, standards, training and hands-on administration and development. Led a team of up to 6 BI and data warehouse professionals as well as intermittent third-party resources.BUSINESS INTELLIGENCEExpanded admissions application processing capability by developing a Hyperion BI solution that allowed the department to track key performance indicators and perform advanced data mining.Maximized user self-service Hyperion data mining capabilities by providing frequent learning opportunities such as classroom training and user-group participation.DATA WAREHOUSINGImproved reliability and repeat-ability of services by creating a set of standards that were applied across all Cognos and Datastage ETL development efforts and DB2, Oracle and SQL Server database configurations.Ensured a seamless PeopleSoft ERP user upgrade experience by leading a project to retrofit the existing student administration data mart structure for compatibility with the new version.

Education record

Certificate, Computer Programming

Bachelor Of Arts (Ba), Natural Sciences