Susan Sawchuk
Dania Beach, FL ****4
ac1wsw@r.postjobfree.com
Objective
A Data Warehouse / Business Intelligence related position in an organization that will benefit from my initiative, capabilities and contribution. I am especially interested in a position with the potential for exercising my current data warehousing skills, communicating and presenting Business Analytics. I am an enthusiastic, dependable professional who excels in a challenging environment.
Accomplishments
Key participant in growing the Florida DOT reporting practice from simple SQL queries to a full DW and BI environment
Deliver presentations to C-level management to request BI and DW project endorsements
Over 15 years in the I.T. industry as a Data Warehouse Engineer, Manager, Project Manager, Senior Systems Analyst, LAN Administrator and IT Diploma course instructor at a college
Consistent progression of increased responsibility throughout professional career
Successful track record with high responsibility positions
Chosen as 1 out of 10 finalists (out of 1200 employees) to lead strategic direction of Crown Life Insurance, Inc. (called “THE DREAM TEAM”)
Strong ability to analyze business issues and provide solutions
Skills
Over 15 years of strong Systems Experience with a technically diverse background
Proven experience and understanding of Data warehousing and Business Intelligence practice
Data Warehousing from inception to post-implementation phases, in both Project Management and technical roles
Team Building, Team Management
Creative Problem Solving
Strong Technical Assessment
Strong organizational and motivational skills
Excellent communication and interpersonal skills
Assist with Project Budgeting and Cost Analysis
Documentation of systems, business requirements, initiation, project scope and progression, technical, corporate and strategic planning
Skills: Project Management, Data Warehousing, Business Intelligence, Data Analysis, Business Analysis, Gap Analysis, Data Modeling (relational and multidimensional), exposure to both Oracle queries and UNIX administration, Reporting (client and web based) and Data Transformation (ETL), Training
Technologies: Microsoft Project, Teradata SQL Analyzer, DBVisualizer, Toad, SQL Server Management Studio, Cognos through version 10 (Framework Manager, Configuration, Report Studio, Analysis Studio, Transformer, some Metrics Studio), Cognos Administration, Business Objects, Tableau (Jr), Oracle 7 through 11, SQL Server, Sagent ETL, DTS ETL, SQL Plus, PL/SQL, Transact SQL, ERwin, UNIX, some Developer/2000 and ROSS, SQL query development, Visio, PowerPoint
Employment Experience
Business Intelligence Solutions Specialists January 2015 - Present
Clients: ADT, Bluegreen Vacations, Sheridan Health Corp, JM Family, Office Depot, Prologis
Title: Data Warehouse/Business Intelligence (DW/BI), Data Analyst, Project Manager, Business Analyst, Functional Analyst, UAT Coordinator, Functional Architect
Responsibilities: Hands on positions with multiple roles focusing on Data Warehousing, Business Intelligence, Data Analysis, Business Analysis, Project Management, Data Modeling, Data Profiling and QA/UAT. Participated in architecture and strategy sessions to support business endeavors and initiatives. Spearhead and coordinate special initiatives/projects of both business units and technical participants. Liaison and coordinate activities among the Business, newly acquired companies, various technology teams (internal and external). Collaborate with the business teams, customers, data providers, IT, and project teams (PMO) to elicit, document, and manage business data requirements for Data Integration (DI) and Data Warehouse (DW) projects. Coordinate and investigate nature of requests and/or enhancements and direct and manage to appropriate areas for completion. Coordinate project and team members (Solution Architect, SME, Business) for requirements, deliverables, documentation and sign-offs using a custom Agile and Waterfall approach.
Technologies: Oracle, SQL Server Management Studio, Teradata, SQL, Clarizen (Project Management and Time Tracking), Footprints and Visio. Gap Analysis, Business Requirement Documents, TFS, Microsoft Project, Brightworks, Cognos tool suite, Teradata SQL Analyzer, DBVisualizer, SQL, Gap Analysis, Visio, SalesForce, PowerPoint, Access, LucidCharts, ALM, Jira. Lead UAT endeavors and related documents/sign-off.
Viacom January 2013 – January 2015
Title: BI Developer (Cognos/Business Objects)
Responsibilities: Business Intelligence and Data Warehousing initiatives to support Viacom’s reporting and information requirements. Initiatives include liaising with project team of business users, consultants and other development staff in performing the analysis, design, construction, testing, implementation, release and change management and all other phases of systems development and maintenance. Interface with department teams and/or vendors to support existing and new applications, products and tools. Conduct formal presentations of new and proposed BI deliverables, solutions and technologies. Evaluate and implement new technologies.
Technologies: Microsoft Project, Requirements gathering, design, document, implement and train, Data Analysis, Cognos Suite: Framework/Metadata Layers, Cognos Administration and Configuration, Report Studio (reports and dashboards), Analysis Studio (multidimensional cubes), Transformer, Business Objects, SQL (Stored Procedures, SQL syntax), Oracle, SQL Server, Visio, PowerPoint
Univita Health November 2012 – January 2013
Title: Business Intelligence Data Analyst
Responsibilities: Work with development teams to build Data Warehousing and Business Intelligence applications for their Healthcare and Health Insurance systems. Deliver data and information to business through ad hoc, formal reporting and dashboard mechanisms. Act as a liaison between various technology and business teams. Create and maintain de-normalized and dimensional data models, entity relationship diagrams or other forms of documentation in support of business requirements. Perform Data Analysis, Data Mining, Data Modeling and Analytics.
Technologies: Microsoft Data stack: SQL Server, T-SQL, SSIS
Florida DOT December 2005 – November 2012
Title: Sr. DW BI Consultant and Team Lead
Responsibilities: Data Warehousing, BI Team Lead for Enterprise 1 team in Cognos 10 environment. Analysis, design and development of Dashboards, Reports and Cubes using Framework Manager, Report Studio and Analysis Studio, QA and training in entire suite. Presentations to C-level management, including Proof of Concept demonstrations. Participate in data modeling and reviews for the ODS and Data Mart layers. Create SQL queries for result sets and to validate report output. Project schedule and management responsibilities and setting of priorities for team members, including interviewing, hiring and mentoring. Work with management and other team leads to define future path and projects. Partner with business units to determine and incorporate business reporting changes and new reporting requirements. Implement post implementation review sessions. Work with Vendors re: software acquisition process.
Technologies: Framework Manager, Cognos Configuration, Report Studio, Analysis Studio, Transformer, some Metrics Studio), Oracle 9 - 11, Microsoft Project, SQL, Data Modeling, ERwin, UNIX, some ETL (Informatica).
JM Family (Chronarch Inc.) April 2004 – December 2005
Title: Consultant (Return engagement)
Responsibilities: Data Warehousing and Business Intelligence project at JM Family, responsibilities include Business Analysis, Cognos development, PL/SQL queries, review conceptual designs of other colleagues, testing, documentation, QA and training. Participate in data modeling review and solution sessions.
Technologies: Cognos suites of tools (Client and Web), Oracle, PL/SQL, SQLPlus
Adjoined Technologies October 2003 – April 2004
Title: Sr. Principal Consultant (Return engagement)
Responsibilities: Project Manager for Data Warehousing projects (most recent at Burger King Headquarters). Held two positions on this project, in addition to Project Manager, also acted as the Business Analyst. And Project Manager, Adjoined and Burger King resources. Review milestones, assign tasks, produce required documentation for both PM and Business Analyst, monitor timelines, conduct status meetings and report and ensure the project stays on-time and within budget. Cognos report and cube development for a consulting company. Project with ACH Foods on a DW strategy and implementation, including business analysis, hardware and software selection and implementation, data modeling and mentoring.
Technologies: Oracle, BI Software (Cognos Suite of tools, BO), various project management software, Erwin and BPwin and IDEF0 modeling methodology for BPR.
JM Family (Encore Development) July 2003 – October 2003
Title: Analyst, 4 month contract
Responsibilities: To work with JM Family associates to analyze their current environment and configuration, make recommendations, advise on best practices and help to implement these solutions using the Cognos suite of tools (Impromptu, Transformer, PowerPlay, both client and web versions), SQLServer and Oracle.
Argonaut Insurance Company August 2002 – July 2003
Title: DW Analyst, 1 year contract
Responsibilities: Data warehousing position including information gathering, analysis and data modeling (star and snowflake). Develop and implement reports and multidimensional cubes utilizing the Cognos suite of products (Impromptu, Transformer, PowerPlay, Visualizer, both client and web versions) and Oracle Discoverer. Conduct analysis and information gathering meetings. Additional technical skills used include: Oracle, SQLPlus and the installation of the Cognos product suite and supporting technologies.
ANC Rental Corporation April 2002 – August 2002
Title: BI Analyst (Return engagement)
Responsibilities: Responsible for ensuring the operation of the Business Intelligence production environment (24x7) including analysis, execution and delivery of informational requests. Technologies utilized include Oracle, SQL and PL/SQL and Cognos (Impromptu, PowerPlay and Transformer).
LNR Property Corp. November 2001 – January 2002
Title: Data Warehouse Consultant
Responsibilities: Create and automated the data dictionary for their Focus System. Logical and physical design using available software applications: Excel and Word.
ANC Rental Corporation May 2001 – October 2001
Title: BI Analyst
Responsibilities: Responsible for ensuring the operation of the Business Intelligence production environment including analysis, execution and delivery of information requests. Technologies utilized include Oracle, SQL and PL/SQL and Cognos (Impromptu, PowerPlay and Transformer).
Adjoined Technologies January 2000 – April 2001
Title: Project Manager/Principal Consultant
Responsibilities: Member of the Intelligence Solutions Team, specifically targeting Data Warehousing initiatives. Project Manager for “in house” development projects (custom application) and related research. Technologies utilized include Oracle, ERwin, Cognos (Impromptu, PowerPlay, Transformer, Web and Server components), Discoverer and some Business Objects.
Cap Gemini Ernst & Young June 2000 – December 2000
Title: Consultant
Responsibilities: Design, develop and implement a Data Warehouse at CGEY’s client, Ontario Power Generation, a nuclear site utilizing Oracle, SQL Server, SQLPlus, Transact SQL, Sagent’s ETL tool, DTS, Erwin and Cognos’ Impromptu and PowerPlay. Also responsible for Oracle components, data transformation and migration while adhering to business rules.
CTV May 2000 – June 2000
Title: Consultant
Responsibilities: Delivery a prototype Datamart to facilitate decision making regarding a full-blown data warehouse. Contract was put on hold due to a takeover of CTV. Technologies utilized include Oracle, Oracle Discoverer, SQLPlus and ERwin.
Noranda Inc. June 1998 – May 2000
Title: Consultant
Responsibilities: Focus on the ROSS payroll system, all aspects of project management, some development and implementation of upgrades, conversions, Oracle, UNIX, Cognos’ Impromptu and PowerPlay, SQL Plus and PL/SQL scripts and interfaces.
Roche Pharmaceuticals June 1998 – March 2000 (part-time)
Title: Consultant
Responsibilities: Involved in SAP, Oracle, SQLPlus, Cognos Suite of tools and transformation tools (ETL) for regulatory reporting requirements.
Crown Life Insurance Co.
Title: Sr. Systems Analyst/Project Manager January 1995 - May 1998
Responsibilities: Research, evaluate, recommend and incorporate new technologies and standards for Crown Life, act as liaison for end user and technical requirements, manage projects, data modelling, database design. Project manager for data warehouse initiative including design, development and implementation, data dictionary, data transformation and migration. Involved in the PeopleSoft Financials’ implementation specifically geared at reporting. Project manager, including interviews, task assignment, project scheduling, career planning and evaluations.
Title: Project Leader March 1994 - January 1995
Responsibilities: Manage projects and people, including candidate selection, reviews and assigning responsibilities. Provide direction for new development and maintenance.
Title: Lead Information Center Analyst August 1992 - March 1994
Responsibilities: LAN administration, provide direction for LAN technologies and LAN support personnel within business unit.
Title: Information Center Analyst March 1992 - August 1992
Responsibilities: LAN administration, system development and maintenance.
PHH Canada Inc.
Title: Database Analyst/Administrator June 1991 - March 1992
Responsibilities: Logical and physical design, act as liaison between systems personnel and users, develop long range IT plans, training personnel in DA concepts, setting and monitoring standards for logical and physical database design.
Title: Programmer/Analyst January 1990 - June 1991
Responsibilities: Dedicated full-time to a multi-stage project including: system analysis, design, construction, system testing, implementation, user training, and documentation.
Title: IS Support Analyst March 1989 - January 1990
Responsibilities: Support Homequity's critical financial systems, with emphasis placed on designing and implementing replacement sub-systems.
Title: Technical Programmer October 1988 - March 1989
Responsibilities: Develop and implement training seminars, provide hardware/software/technical support to all Canadian offices, support Billing and General Ledger Systems for Homequity.
George Weston Limited October 1987 - October 1988
Title: Microcomputer/LAN Administrator
Responsibilities: Network administration, technical support, develop and deliver training seminars for corporate office and subsidiaries. Assigned special projects for owner and second in command, Mr. Weston and Mr. Lindsay.
Mode Technologies April 1986 - October 1987
Title: System Design Analyst
Responsibilities: Pre and post sales support, company needs analysis and implementation, develop and implement training programs and programming.
Compucollege January 1984 - July 1985
Title: Instructor/Trainer
Responsibilities: Develop, implement, and teach computer programming and systems analysis diploma courses. Course curriculum included both practical and theoretical instruction including: multiple languages, operating systems, word processors, accounting packages, fundamentals, theory, systems analysis & design and flowcharting.
Education
University of Toronto
Toronto, ON
Course in Bachelor of Arts program
Herzing Institute
Winnipeg, MB
Course in Computer Programming and Business Systems Analysis
Wadena Composite High School
Wadena, SK
Graduated with an A average
References
Available upon request