Simon Lee Email & Phone Number

As Senior Analyst - Business Intelligence, responsible for leading a team of Informatics Managers to deliver on the data analysis and campaign needs of the Marketing team. Key responsibilities include:* Acting as the subject matter expert on customer data for the Marketing senior leadership team (Acquisition and Retention) and product/market managers.* Working closely with channel partners to ensure accurate and timely campaign lead generation and delivery.* Identifying and acquiring new sources of data to enrich the overall set of customer information available for Marketing* Designing and implementing data extraction and transformation processes to enrich the data capabilities of the Marketing team and maintain a stable and reliable reporting environment.* Coaching and mentoring team members on data availability and programming techniques.* Ensuring that the strategic and tactical goals of the Marketing area are met through efficient and effective use of enterprise data.

As an Informatics Manager (Marketing Analytics/Insight), responsible for providing customer profile data analysis and reporting as well as campaign lead lists for multiple marketing channels (Direct Mail, Outbound Calling, Bill Messaging, etc.). Key responsibilities included:* Executing analytical programs and distributing results to the various requestors (Sales, Marketing, etc.).* Developing and maintaining new product performance tracking reports, working directly with the customer to determine the correct data requirements and criteria, validating results. * Developing special marketing management studies, research and analyses.* Developing and maintaining ad-hoc and recurring campaigns for marketing channels (Door to Door, Direct Mail, Telephone, Email, Bill Messaging), working directly with the product and market managers on campaign requirements, advising them on data availability and best practices.* Developing and maintaining data extraction and transformation and other data manipulation tasks using SQL scripts to combine and summarize data to support reporting and campaign list generation. * Collaborating with various levels of management to share/implement business improvement associated to analysis.* Ensuring that learnings from previous initiatives serve as an input into the subsequent initiatives and to be champions and promoters of knowledge management.

As an Information Systems Architect (Senior Business Analyst), responsible for developing and maintaining several key Business Intelligence and Data Warehouse Solutions for a wide range of internal stakeholders. Key responsibilities included:• Working with internal stakeholders and projects to manage new or changed data warehouse reporting requirements throughout the data warehouse development life cycle (design, plan, build, operate), including co-ordination of external resources (xwave) to meet deliverables.• Priming the design, development, implementation and administration of data warehouse structures (such as tables, views and indexes) within the larger data warehouse environment;• Developing and maintaining reporting objects (e.g PowerPlay cubes and reports and associated drill-through Impromptu and IWR reports) in an automated production environment;• Consulting with internal stakeholders to develop and deliver ad-hoc and recurring reports using SQL and Impromptu, including creating Impromptu catalogs and importing new data sources to support these reports;• Developing and delivering customized Cognos training material for beginner and advanced users;• Advising and coaching internal stakeholders on information availability within the Enterprise Data Warehouse environment;• Acting as the single point of contact for internal stakeholders needing data warehouse assistance.• Modeling and documenting data warehouse structures and processes.• Communicating data warehouse changes with internal stakeholders and team members.• Leading a process improvement initiative to improve the collection, maintenance and distribution of documentation on the contents of the data warehouse.

As a Senior Business Intelligence and Data Warehousing Consultant, responsible for developing and maintaining several key Business Intelligence and Data Warehouse Solutions for a variety of clients. Key responsibilities included:• Designing, developing, implementing and administering star schema data marts within a larger data warehouse environment;• Designing, configuring and administering web-based Cognos environments using DecisionStream, PowerPlay Enterprise Server, Impromptu Web Reports (IWR) and an Upfront portal with Access Manager security;• Developing and maintaining data marts and their associated PowerPlay cubes and reports in an automated production environment, including drill-through Impromptu and IWR reports;• Developing and maintaining a web-based system using PowerHouse Web to allow users to maintain their own business structure for automatic inclusion into PowerPlay cubes and associated IWR reports;• Implementing new installations and upgrades to existing Cognos based Business Intelligence infrastructures including DecisionStream, PowerPlay Enterprise Server, PowerPlay, Impromptu, Impromptu Web Reports (IWR), Upfront and Access Manager;• Conducting new product trials and evaluations, and presenting implementation recommendations; • Creating and customizing tables, views and indexes in the data warehouse;• Consulting with customers to develop and deliver ad-hoc and recurring reports using SQL and Impromptu, creating Impromptu catalogs and importing new data sources to support these reports;• Designing, configuring and administering a web-based delivery channel for customer reports;• Developing and delivering customized Cognos training material for beginner and advanced users;• Developing and maintaining a customized batch reporting system for recurring reporting;• Working with customers to advise on data availability within their data warehouse environment.

As an Infrastructure Support Specialist, responsible for a high availability UNIX-based client/server system in both production and development environments. Responsibilities included:• Monitoring system performance;• Responding to system errors;• Applying and testing software patches/upgrades;• Performing system enhancements (hardware and software);• Documentation, user training as well as maintenance and user support.

As a Desktop Support Team Leader, responsible for 15 Desktop Support Technicians who were responsible for corporate PC hardware/software support. Responsibilities included:• Coaching;• Policy direction;• Mentoring;• Leadership;• Providing technical resources in support of their daily activities;• Interfacing with users needing PC planning and support staff and advice for internal projects; • Recruiting and hiring new support staff members to improve team skills and efficiency.

As a Desktop Support Technician, responsible for correcting errors with, and maintenance for, over 2000 desktop systems, many of them impacting external customers. Responsibilities included:• Supporting over 3000 users in a corporate Help Desk environment;• Over-the-phone troubleshooting and problem resolution;• Dispatch of on-site technical support;• Providing on-site technical support for desktops, laptop, printers, PDA's, scanners with hardware/software errors;• Interfacing with users and user managers to provide technical advice and recommendations, schedule work, determine requirements and deal with issues.

Masters Certificate In Business Analysis, Business Analysis

Diploma In Applied Computer Technology, Information Technology

The school changed its name to ITI after graduation.

Bachelor Of Arts, History

Studied post-war British history