Sr Business systems analyst
Resume:
SANDRA ROCA
*******@*****.*** 647-***-**** www.linkedin.com/in/rocasandra
OBJECTIVE
To pursue a career focused on Data Warehousing and Business Intelligence delivery. Ideally, in an innovative company, as a Senior BI/DW Consultant where my skill set would be utilized to meet the company’s goals and objectives.
QUALIFICATION HIGHLIGHTS
25+ years of solid working experience in IT industry with a Bachelor degree in Computer Science and Mathematics,
In depth experience as a hands-on analysis, design, development, application architecture, management and implementation of Business Intelligence (BI) and Data Warehousing (DW) systems, 3 years experience in project management and 2 years experience in team management.
Delivered projects for enterprises such as the WSIB (Workplace Safety and Insurance Board), Telus, Canadian Tire, Northbridge Insurance, Toronto Hydro, Royal & Sun Alliance (RSA Insurance) and Standard Bank (South Africa).
Extensively working on Cognos (v6 to v10.2.2), DB2, SAS, Netezza, Teradata, Oracle, SQL server, SSIS, SSRS, SSAS, OLTP, OLAP, Multidimensional Cubes, MDX, SharePoint, JCL, Easitrieve, Unix scripting.
Knowledgeable in integration and ETL tools such as DataStage, Informatica, Alteryx, SAP BODS and SSIS. Experience with data warehouse appliance such as Netezza and Teradata.
Knowledgeable in Data Warehouse and Data Mart design including Dimensional Modeling (Star & Snowflake Schemas), ER Modeling, 3 Normal Forms, Normalization and Demoralization, Logical Model and Physical Model, Fact/Dimension/Hierarchy identifications using Erwin, Visio.
Demonstrated experience and understanding the best practices in all aspects of data warehousing (Inmon/Kimball approach). Solid experience in Data Warehouse Development Lifecycle (SDLC) including system analysis, design, implementation, testing, deployment, and maintenance.
From Business Case to Data Visualization, I have designed and developed solutions by combining Business Process with Information Technology.
Extensive expertise in BI Reporting using Cognos, SAS, SSRS, Crystal Reports, Business Objects, Tableau, Microstrategy.
Authored numerous best practices, technical reports, processes & workflows, and methodology documents to standardize implementation, support infrastructure and sustainment teams, and to promote knowledge sharing.
ROLES
BI / DW Solution Architect
BI Project Manager
Business intelligence technical lead/specialist
Senior Systems Analyst
Senior Business Systems Analyst
Senior Developer
PROFESSIONAL EXPERIENCE
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/EDW Technical Specialist, 08/2018-to date
Worked on Cognos 10.2 Claim Center Guidewire reports – developed Framework Manager models, packages and Report Studio reports. Created deployment packages in Cognos configuration management.
Promoted code via GIT, BitBucket and Source tree in order to manage code versioning, code deployments and defect fixes into higher environments
Liaised with Business on business requirements changes and updates. Documented changes in the Business requirements document.
Produced mapping documents to map new EDW report fields to the relevant database fields and documented in the Data dictionary
Produced complex SQL queries to evaluate defect impact on the data in the EDW and reported to management and business.
Documented Cognos Workbooks for business use on published Cognos reports.
Conducted Business sessions for report design overview and training of published reports on the portal
Guidewire Claim Center, Guidewire DataHub and Info Center, SQL Server, SQL, HPQC (HP Quality Center), Cognos Framework Manager, Cognos Report Studio, Bit Bucket, GIT, Source tree, SAP BODS,
Royal & Sun Alliance (RSA) - Toronto, BI Business Systems Analyst Consultant, EDW/Management Information 05/2017-to 08/2018
Worked on multiple projects of the Management Information team: gathered requirements, identified and documented processes and workflows, provided coordination, responsible for testing, defect management, production support, project implementation tasks and tracked project tasks.
Integrated Legacy data warehouse and the new data warehouse’s data in multiple online client applications: Broker portal, Client Inquiry and Claims Notification.
Worked closely with the Solution Architects, Developers and Quality Assurance Analysts in identifying best solutions and uses of technology to drive business growth, requirements and efficiencies.
Produced mapping documents to map new EDW Claim Center Guidewire fields to legacy fields in order to integrate the data.
Produced complex SQL queries to create data extracts from the Teradata data warehouse in order to map data.
Conducted gap analysis for reporting elements on current reports against the new data warehouse.
Liaised between business and technology stakeholders throughout the entire project’s lifecycles
Guidewire Claim Center, Teradata, DB2, Seapine, Webfocus, SQL, Microstrategy, AS400, JIRA, SAS
Toronto Hydro - Toronto, BI Business Analyst Consultant, Engineering Analytics Project 10/2016-05/2017
Worked on Self-serve implementation of Data warehouse environment: gathered requirements, identified and documented processes and workflows, provided coordination, responsible for standard project documentation, and tracked project tasks.
Worked closely with the Solution Architect and Developers in identifying best solutions and uses of technology to drive business growth, requirements and efficiencies.
Performed data profiling and data analysis of the source data and existing Data warehouse systems
Identified all stakeholders and established productive and trustful relationships with all stakeholders.
Gathered and documented detailed functional and non-functional requirements from stakeholders
Documented current and future environment states
Assisted Project Manager to coordinate project activities.
Responsible for tracking scope changes
Liaised with other project areas to coordinate interdependencies and resolved project issues
Accountable for producing high quality documentation including all Toronto Hydro project management documents, including: PSD (Project Specification Document), SD&S (Systems Design and Support Document), issue tracking document and Decision logs, Current and Future state documentation.
Participated in Risk, Issue assessment and Lessons learned recording.
Provided coordination, tracking and reporting on testing as well as defect management
Tableau, Alteryx, Oracle, Netezza, SQL Server, HPQC (HP Quality Center)
Northbridge Insurance - Toronto, BI Business Analyst, Business Analysis Team 10/2015-11/2016
Worked on integration project to ensure Duck Creek source data (policy administration system) would integrate efficiently and seamlessly with Current state reporting systems.
Worked closely with the Solution and Data Architects in identifying best solutions and uses of technology to drive business growth, profitability and efficiencies.
Facilitated the gathering and management of diverse requirements in a Business Intelligence environment with the goal to achieve a common solution.
Worked closely with Data Architects to ensure the data models fulfill the needs of the business.
Performed data profiling and data analysis of the source data.
Assessed the impact of new or changing operational source systems on the Data Warehouse and BI environment.
Worked with systems analysts, application developers and business analysts to identify options for potential solutions and the impact to systems, while assessing both technical and business suitability.
Tested system enhancements and products for discrepancies, and documented relevant data changes in an accurate and timely manner as required.
Developed and maintained a knowledge and understanding of company operations/procedures, and insurance industry trends/developments, to enhance the Systems analysis process.
Liaised between business and technology stakeholders throughout the entire project lifecycle.
Created Business Requirement Documents (BRD’s), Functional Specification Documents (FSD’s), Solution Alternative documents (SAR’s) as well as weekly status updates and implementation Plans.
SAS, DB2, SQL Server, DQ Analyzer, SQL, Mainframe, JCL, Microstrategy, Microsoft Team Foundation Server (TFS)
Canadian Tire Corporation - Toronto, BI Solution Architect, Architecture Team 05/2011-09/2015
Provided technical expertise in all aspects of the Business Intelligence Solution, including infrastructure, ETL (DataStage 8.x) and Front end artifacts (Cognos 8.x /10.x), on AIX, Linux and Wintel platforms, using Oracle, DB2, SQL Server, big data (Hadoop) and Netezza.
Ensured scalability, security, availability, integration, maintainability of BI systems
Involved in implementing and designing an Enterprise Data Warehouse as well as migration of existing DB2 EDW to Netezza platform
Experience working in Agile project teams, Sprint delivery reviews and daily standup meetings. Collaborate in backlog grooming and Sprint planning.
Provided mentorship to junior team members and coached accordingly. Acted as Information management team lead.
Work with the business in order to understand business requirements and convert them into workable solutions
Create solution blueprints, design sheets, business requirements documents, risk logs, issue logs, object tracker and other project documentation related to BI solutions on major IM projects as well as small work and pre-projects/assessments
Provided input into architecture, design, development, infrastructure and process enhancement. Defined custom architecture requirements around solutions as well as articulated strengths and weaknesses associated with alternative solutions.
Involved in a BI Tool evaluation process that evaluated 8 leading BI tools: QlikTech, IBM Cognos 10, SAP Business Objects, Microstrategy, SAS, Oracle, Information Builders, Tableau, Jaspersoft and Microsoft
Served as a consultant and researcher in support of applications development teams, applications integration teams, and business partners.
Determines boundaries for the components of an architecture or application.
Provided input for tactical or strategic plans and solutions.
Provided advice/input to ensure that clients meet their business objectives.
Consulted with various project teams to resolve technical difficulties.
Provided interpretation of data processing policies, practices and technical standards.
Telus Mobility - Scarborough, BI Technology/Solution Architect, Systems for Business Intelligence 09/2008-04/2011
Provided technical expertise in all aspects of the front end Business Intelligence Solution, including infrastructure and Front end artifacts (e.g., scalability, security, availability, integration, maintainability)
Experience with Framework Manager, Report studio, Query studio and Analysis studio.
Upgraded Cognos platform (series 7.3 and 8.2) to Cognos 8.4 – architecture, installation and migration
Offered technical and operational assistance and feedback on potential design improvements
Provided input into architecture, design, development, infrastructure and process enhancement
Produced all related documentation including framework, methodology, process, diagrams, templates, workshops
Established and maintained architecture standards and frameworks for application components and provided direction to project teams to ensure compliance
Mentored and coached junior team members
Played a leading role and worked with development team, business and vendors in evaluating applications and technologies. Conducted Proof of concept projects for Microsoft BI and Microstrategy 9
Liaised with Business users and maintained excellent customer service and relationships
Telus Mobility - Scarborough, Sr. Systems Analyst, Systems for Business Intelligence 10/2003-09/2008
Installed, configured and tested Cognos 8 on Unix Sun Solaris and AIX servers
Led the migration of existing catalogs, reports and cubes from Cognos Series 7 to Cognos 8
Managed a Proof of Concept based on two Business Intelligence tools – Cognos ReportNet 1.1 and Microstrategy 8.
Created Framework Manager models and packages for the Proof of concept as well as Report Studio reports. Also used, Query Studio and Analysis studio to develop reports.
Administered Cognos services on Unix servers, including stopping and starting services and upgrades of all server components.
Provided impact assessment s for new projects
Produced technical specifications for development of Cognos artifacts
Provided mentoring to Cognos developers in order to help them progress in their professional development and optimized performance of existing Powerplay cubes
Involved when datamarts were designed to ensure that the end user’s requirements could be produced in Powerplay cubes or in the reports
Interviewed end users to determine and document requirements for reports, data quality and performance
Was responsible for communication to all of the Data warehousing business users
Provided the Business with BI development and deployment plans to allow for better analysis of key performance indicators within the corporation.
Gathered reporting requirements and business rules from users.
Developed and maintained Impromptu catalogs and reports, as well as Impromptu web reports.
Developed dimension and data maps needed to develop Cognos Powerplay cube models.
Developed and maintained PowerCube models in Cognos Powerplay Transformer.
Tested delivered systems solutions and monitored systems after implementation to ensure they satisfied requirements.
Provided on-going support and training to the business on the data warehouse and the new subject areas as they were provided.
Acted as Impromptu Web Administrator which allowed the clients to schedule and distribute Impromptu reports more efficiently. Conducted Cognos 8 Administration.
Managed Operational issues for Data Warehouse team. Assigning and following up development progress within the team.
Experience with scheduling via Control-m, Clearcase for version control of scripts and ClearQuest for Change management.
Oracle 9i/10 and Unix – Sun Solaris 9/10 as well as AIX platforms.
Working knowledge of Informatica and shell scripting
Workplace Safety & Insurance Board (WSIB) – Toronto, BI/Information Management Specialist 07/2002-10/2003
Communicated and liaised with clients to identify and define their requirements.
Evaluated business requests to determine feasibility.
Designed and built systems, customized it to meet user requirements, including translating system design into program design specifications and developed specifications to resolve programming issues.
Worked closely with the analysts and business clients to resolve any requirement/specification issues.
Designed, created & wrote custom reports in both SAS and Cognos for clients.
Built Catalogs and cubes using Cognos tools/products.
Provided BI best practices to clients, did extensive data analysis, data extraction and transformation.
Built, tested and implemented SQL queries for extraction and creation of tables and views (DB2/Unix).
Standard Bank of South Africa – Home Loans, Management Information Systems, BI Project Manager 11/2000-05/2002
Partnered the Home Loan business unit to ensure that a high quality of service and good relationships were maintained.
Ensured the business needs are defined and fully understood by all project participants and stakeholders.
Evaluated the feasibility of the business needs and identify opportunities or alternatives so as to optimize the business requirements.
Communicated and enforce adherence to Group Architectures and Security Policies
Monitored project costs and resources, plan and prepare schedules for a range of activities, assign work to team members, monitor progress, and respond to changing priorities.
Ensured that practices, procedures and principles of project management, as well as project development and life cycle methodologies are enforced.
Kept abreast of Business Intelligence methodologies, techniques and trends as well as trained the business in the use of Cognos tools/products.
Participated as well as run workshops during the needs assessment, analysis, design and dimensional data modeling of new systems, as well as enhancements to existing systems.
Assisted with the on-going business discovery and development, to ensure that business requirements were constantly being met.
Ensured the maintenance of the metadata repository as well as the data’s conformance to the Data Management standards for the Enterprise
Led the team so as to achieve results using matrix management in order to achieve excellent delivery of systems.
Managed staff and provided guidance. Evaluated job performance and conduct salary reviews and promotions.
Standard Bank of South Africa, Enterprise Data Warehouse, Project Managers Team, BI Project Manager/Leader 01/1999-11/2000
Assisted all the business units to ensure that a high quality of service was delivered and that good relationships were maintained.
Identified opportunities and recommended suitable solutions for the business’ relevant strategies
Planned, ran and managed projects and work requests for all of the Bank’s business units.
Conducted peer reviews of more junior team members as well as mentored and coached them
Designed Data Marts and the development and implementation thereof for the Enterprise Data Warehouse. Also involved in implementing projects developed with the Cognos suite of products.
Actively participated in all aspects of the Data Warehouse projects during their life cycle. Prepared documentation through all project development phases.
Applied and enforced Architectural standards, policies and procedures.
Maintained and adhered to quality assurance procedures.
Defined and adhered to budget and schedules. Ensured that projects were developed according to time and cost specifications
Ensured that project objectives and business requirements are met.
Assisted the business users in finding the right information/solutions.
Coded, tested, corrected and maintained procedures relating to the Data Warehouse, Data Marts and applications.
Adhered to Change Management services and comply to Production standards and procedures.
Reviewed and documented the Data Warehouse methodologies for the Project Management life cycle.
Maintained the Commercial Banking data mart and managed all enhancements to this system
Standard Bank of South Africa, Enterprise Data Warehouse, Systems Analyst/Developer 03/1993-01/1999
Program in SAS, DB2, MVS, JCL, Easytrieve and Easytrieve plus (MVS mainframe platform)
Develop the Matrix Profitability Analysis System application for Group Finance Division.
Participate in workshops for all phases of development, this included definition, analysis, construction, implementation and maintenance.
Maintain the system after implementation in the production phase. Maintain production checklists.
Be on call out when required to assist in system maintenance after hours.
Be responsible for changes, conversions and problem solving.
Liaise with all business users to ascertain needs and provide quality service.
EDUCATION
University University of the Witwatersrand - BSc (Bachelor of Science)
(1989 – 1992) Computer Science and Mathematics (majors)
2001 Project Management Diploma course – Harold Kerzner Methodologies - School of Project Management, Pretoria, South
2001 Certificate in Management – Graduate Institute of Management and Technology/Henley College
2006 Business Systems Analyst Course (Gathering Business requirements, Use Case Modeling, Workflow Modeling)
2009 - 2010 Leadership Now management program (Telus)
2011/2012 Leadership training (Canadian Tire)
2015 TOGAF 9
LANGUAGES
English : Speak, Write, Read (Fluent)
Portuguese: Speak, Write, Read (Fluent)
Afrikaans: Speak, Write, Read (Good)
French : Speak, Read, Write (Fair - Good)
ACHIEVEMENTS
Architecture award for delivery of Dealer Dashboard project
Advanced Toastmaster Gold (ACG), Advanced Leader Bronze, Competent Leader (CL)
President Uptown Toastmasters Club (3 years), previously VP of Membership and VP of Education
Engagement Award (department) – September 2009
Nominated for Leadership Now program – April 2009
Architect Award (department) - March 2007
Commended for Cognos 7 and 8 installations on the Unix environment 2005/2006
Awarded ‘Team Machine’ points for successful project completions – 2004/2005
High Five award for ‘Commitment and Contribution’ - December 2000
Contact this candidate