Resume

Sign in

IT Professional- Data Analysis, Data Modeler & ETL Datastage Developer

Location:
Oshawa, ON, Canada
Posted:
March 29, 2018

Contact this candidate

Resume:

Profile

A PMP-certified professional/IT professional with cognate experience in development and management of information technology infrastructure in the Insurance & Reinsurance, Pharmacy Health-Benefits Management, Medical Health-Care (Medicaid/Medicare) Claims Processing, Nuclear/Energy and Banking sectors.

Demonstrated expertise in all facets of project life cycle, implementation, integration, change management, quality assurance and enhancement of large-scale systems with ability to deliver cutting-edge, cost-effective and high-performance technology solutions.

People management and team building skills.

Demonstrated ability to be flexible/ adaptable in exercising judgment in a changing environment and to manage competing priorities.

Proven ability to learn business processes quickly and to work well with business partners at different levels within the organization.

Strong ability to assess risk and apply management principles to technology applications/products and business functions.

Experience delivering technology and business application solutions in a large-scale, multi-platform systems environment.

Core Competencies

Project Management Professional

Enterprise Data Warehousing / Data Lakes

Software Development

Windows & Unix Network Administration

Disaster Recovery

Hardware & Software Integration

Data Migration/Integration

Systems Analysis & Design

Information Systems Management

Project Management (Waterfall, Agile and SCRUM methodologies)

Hardware & Software Integration

Data Profiling/Mapping/ Analysis/Quality

Technical Support

Telecommunication & IP Telephony

Enterprise Resource Planning

Technical Skills

Enterprise Data Warehousing (TeraData)

Guidewire DataHub

Guidewire InfoCenter

Guidewire Physical & Logical Data Models

Unix (Shell) and Perl Scripting languages

Micro-Focus COBOL

CICS

UniCenter Easytrieve

PL/SQL

Peoplesoft

IBM DB2 RDBMS

MS-Office Certified Expert

XML/BI Publisher

Guidewire Claim Center

Big Data Hadoop (NoSQL) technologies

MicroStrategy BI Visualization/Dashboards Tool

Tableau BI Visualization Tool

Talend

Google Analytics/Data Studio

Data Management Governance

Alignment of Business and technical requirements

JCL

Unix CRON Job Scheduling

SQL

SharePoint

MVS COBOL / Mainframe

TSO/ISPF

ORACLE PeopleSoft (ERP)

Microsoft AX Dynamics

ETL Integration Tools - IBM InfoSphere DataStage / Talend / SSIS

TERADATA EDW / RDBMS

Data Management Domain Architecture

Guidewire Suite Data Model

Python

ORACLE RDBMS

MS Excel Power User / Expert Certification

Indus Passport (Ventyx Assets Suite (ERP)

MS Excel VBA and Macros scripting

Professional Affiliations

Project Management Institute (PMI) - Southern Ontario (Toronto) Chapter

Canadian Information Processing Society (CIPS)

Education

Master of Science in Information Systems, University of Nairobi, Nairobi, Kenya

Bachelor of Science in Computer Science, University of Lagos, Lagos, Nigeria

Certificates and Training

PMP Certification- PMP Number 1937640

Oracle

oDatabase (including SQL and PL/SQL) Administration Certificate

oBackup & Recovery Certificate

oAdvanced PL/SQL

oPeoplesoft certificate

Programming/ Scripting Languages

oAdvanced COBOL language training

oAdvanced Macro and VB Scripting

oAdvanced PL/SQL

MicroStrategy

oAdvanced Reporting Certificate

oDashboards and Data Discovery Certificate

oEnterprise Applications Certificate

PeopleSoft (ERP)

oTechnical Developer Training Certificate

Microsoft

oExpert Certification (Windows, Word, Excel, PowerPoint MS Outlook)

Others

oERP INDUS PASSPORT (ERP) 10.0.4 / 10.0.5 / VENTYX ASSETS SUITE / IFA (ERP) 2.2 Certificate for Indus Passport IAS / IFA Applications Developer (new XML / JAVA SCRIPT User Interface)

oCompTIA A+ (Hardware and Software) Certification

oIT - Nuclear Quality Assurance Compliance & Safety Training

oFederal Energy Regulatory Commission (FERC – USA) STANDARD OF CONDUCT Training

oHealth Canada - Health Information Security and Privacy Course

oHealth Insurance Portability and Accountability Act (HIPAA – USA) Security Awareness Course

oIT Application Security Principles

Work Experience

Royal & Sun Alliance (RSA) Insurance Canada Aug 2016 – Sept 2017

Senior Business Intelligence/Data Warehousing Analyst

Project: Claims Management Info - Guidewire CC / ETL DataStage / Data Analysis & Modelling

Project Objective: to implement a common business transformation/intelligence platform across the Canadian businesses (RSA & Johnson Inc) that will provide a single source of all business claims metrics and management information for the entire organization, accessible from any workstation with the appropriate security approvals.

Project Goals: to design the Landing (Acquisition) Layer and the Integration Layer in Teradata EDW. To produce logical and physical data models and DDL for these two layers. To design the STM mappings -Data Mapping and Lineage documents) from the respective Legacy Source Systems into the Landing and Integration Layers, and to develop, test and implement the ETL and the EDW layers into Production.

Involvement:

Key player in a highly technical project team with the responsibility to deliver RSA Canada's remediated Enterprise Data Warehouse from architecture design to the implementation of large-scale BI/MI solutions that utilize diverse technologies to maximize ROI. Team’s responsibilities included Extract Transform and Load (ETL) Framework design, data acquisition approach, data integration approach, reporting and reconciliation.

Key player in all aspects of DW, ETL architecture, ETL development, Data architecture, requirements analysis, data sourcing, Data analysis and Profiling, Data Quality and Gap analysis.

In collaboration with the PMO, took part in negotiated solutions with all level of project stakeholders; including the end-users.

Took part in managing business expectations by delivering clear and concise presentation of proposed solutions, data gaps and data quality issues including tradeoffs and alternatives.

Mentored and worked in collaboration with the off-shore resources.

Ensured appropriate systems development and project management processes are followed by the off-shore resources

Worked collaboratively with the QA team in the definition of appropriate test plans and carrying out quality QA testing and UAT.

Contributed valuable technical inputs towards effective management of the project plans and the project management triangle – cost(budget), time(schedule) and scope.

Carried out detailed analysis of the various COBOL programs of the HUON mainframe/DB2 (and VSAM) legacy system used for claims processing with the aim of determining the impact of decommissioning the legacy system and replacing it with Guidewire Claims Center.

Used advanced SQL queries in IBM DB2 claims database to carry out extensive data analysis for the data integration ETL process which uses the COBOL copybooks as metadata in IBM InfoSphere Data Stage.

Participated in the implementation of Guidewire ClaimsCenter involving data-related architecture for legacy system data migration to the ClaimCenter and legacy system data harmonization approach.

Participated in the Logical and Physical Data Modeling tasks involved in the Project and work closely with the Data Modelers in the Logical modelling specifics involved in Teradata EDW FSLDM’s major subject area model for detailed Mapping and Integration with Guidewire Claims Center.

Designed some of the future state processes to generate some of the down-stream actuarial extract reports/files from the new Teradata EDW layers.

Took part in the MicroStrategy reporting projects to generate user-requested reports and dashboards from the presentation/access layers of the EDW.

Participated in all the ETL DataStage’s processes (acquire, integrate, prepare for access, assure quality, validation) in the Enterprise Data Warehouse Architecture from the respective Source Systems through Acquisition/Landing Layer to Integration Layer and then to Presentation/Access Layer.

PROFESSIONAL SUMMARY

10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.

Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers

Good understanding of views, Synonyms, Indexes, Joins and Partitioning.

Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.

Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.

Exceptional communication and presentation skills and established track record of client interactions

PROFESSIONAL SUMMARY

10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.

Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers

Good understanding of views, Synonyms, Indexes, Joins and Partitioning.

Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.

Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.

Exceptional communication and presentation skills and established track record of client interactions

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Technical Environment:

HUON P&C Insurance Legacy System, TERADATA Enterprise Data Warehousing, Guidewire Claim Center, IBM InfoSphere DataStage (ETL), MicroStrategy BI Software, IBM DB2 RDBMS, DBVisualizer, SQuirreL SQL Client, Micro-focus COBOL, MVS Mainframe, JCL, DB2, CICS, TSO/ISPF, SPUFI, Easytrieve, Teradata SQL Assistant, Teradata BTEQ, Teradata Fast Load, Teradata Multi Load, Teradata Fast Export, Tpump, Tableau software and server.

Express Script Canada Aug 2009 – Apr 2016

Senior Technical Consultant / Lead Software Engineer

Provided leadership and technical expertise to the maintenance, development, testing, implementation and support of the Pharmacy Benefit Admin/Management Information System comprising of the Claim Management (Eligibility and Claims Adjudications), Benefit Management and Provider Management modules. Modules handle claims processing and payments; Billing remittances and funding; Online access to information and changes to eligibility information; Reports that monitor benefit programs; and Network management; Also provide information to Call Centre personnel to handle questions from dental and healthcare providers.

Worked with IS and Business Management to evaluate user requests, clarify objectives and functional requirements for new or modified computer programs.

Assisted in determining feasibility, time requirements, compatibility with current system and system capabilities.

Worked with project team to formulate detailed program specifications using analysis and design methodology.

Prepared project definition documentation for projects.

Assisted with definition and implementation of applications in a multi-platform distributed environment.

Carried out analysis, design, and coded programs in COBOL and was also part of the team that maintains the production system on day-to-day basis.

Wrote documentation describing program development, logic, coding, and corrections.

Developed user manuals and operating procedures.

Provided research and follow-up on production problems.

Trained users and provided technical assistance to resolve application and operating issues.

Used Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis to uncover structural defects in data sources.

Developed Datastage ETL jobs as per business rules using ETL design document

Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.

Used various DataStage stages to load data from Source to target.

Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.

Monitored ongoing performance of systems and developed updates or modifications according to business needs.

Worked with end users to provide production operation support including system setup and processing and data extraction.

Implemented BI solutions in MS SQL Server 2012 database using SSRS, SSIS and SSAS

Provided off-hour support with on call rotation.

Provided assistance to team with issues needing technical expertise.

Trained and mentored new or existing team members as required.

Ensured familiarity with resource materials.

Technical Environment:

ESI Pharmacy Benefit Management Information System, Micro-focus COBOL with NETEXPRESS 5.0, C, Java, VB6, HP UNIX, Windows 2003 serve/clients, ORACLE 9i/11g, MS SQL Server 2012, SQL, embedded SQL, PL/SQL (Packages, Procedures, Functions and Triggers) Unix Shell Scripting, CVS (Version Control / Change Management Utility)

EDS, Newark, Delaware, USA Nov 2007 – Aug 2009

Senior Technical Consultant/Senior Software Engineer

Key player in the maintenance, new development, testing, implementation and support of the Medicaid Management Information System (MMIS) Project for the Delaware State Department of Healthcare Services comprising of the following modules: Provider Information System; Client Information System; Claims Processing System; Reference Table Maintenance; Benefit Management System; Quality Assurance / Utilization management; Drug Rebate Information System; Notification Alerts; Correspondence / Electronic Communication; Imaging / Document Management; Interact Voice Response; and E-forms.

Liaised with EDS internal users of MMIS and State users in the Delaware State Department of Healthcare Services to support the MMIS / EDS project infrastructure.

Member of the EDS team that carried out the upgrade and maintenance, as well as change controls of enhancements and new features to the MMIS system.

Identified, analyzed, and devised solutions to identified business and technical information technology problems reported by the State.

Designed, coded, tested, implemented and validated COBOL programs in the MMIS for business and technical information technology related issues as per requirements from the State.

Supported the UNIX and DB2 RDBMS infrastructure and environment used by the MMIS application and MMIS Architecture, development and implementation platforms.

Key player in the compliance to (and maintenance of) the regions for the development, Model Office, UAT and Production environments for the MMIS Project(s).

Assisted with environmental problem resolutions and capacity/performance testing for the MMIS system.

Performed lifecycle application development (analysis, design, code, test, and implementation)

Monitored day to day performance and supported the MMIS applications.

Extracted data from different source systems into Target DB2 database during the ETL development using DataStage.

Used DataStage to Import clients data residing in the host systems in DB2 for data integration.

ENVIRONMENT/TOOLS: Medicaid Management Information System (MMIS), Micro-focus COBOL, C, Java, AIX UNIX, Windows 2003 serve/clients, DB2 Universal Data Base, Ascential DataStage 7.0(Designer, Director), SQL, embedded SQL, Unix Shell and LINUX Scripting, PIV (Project In Vision) project management tool, VCTL (Version Control / Change Management Utility.

Duke Energy, Charlotte, North Carolina, USA Dec 2006 – Oct 2007

Senior Technical Consultant / Senior Applications Analyst

Played a key role in the development of COBOL programs, testing, implementation and support of the Duke Energy Nuclear Asset Suite System Projects that featured the following modules: Inventory Management; Contracts Management; Purchasing; Work Management; Account Payables; Action Tracking; Document Management; Equipment Tag Out; Engineering Change; System administration; and Material Safety Data Sheets

Used PeopleSoft ERP system and Oracle (RDBMS) Database System interfaced with ‘Indus Passport (now called Ventyx Assets Suite, a specialized high-volume ERP (Enterprise Resource Planning) software specially for the Energy/Nuclear Industry and

Performed analysis, wrote specifications, handled programming, and planned and executed testing while working with other business and technical users and consultants.

Worked on defects and financial customizations to tables, panels and programs

Coded XML views containing the tailoring changes for the new UI architecture.

Worked on the Engineering Change Project for the new UI architecture.

Participated in the implementation of the 10.4 and 10.5 versions of software for the new UI architecture for Work Management and Supply Chain applications.

Technical Environment:

MicroFocus COBOL, Oracle 9i, PuTTy, SQL, PL/SQL, Toad, SQL Developer, Golden, UNIX, Scripts, MS Office, Excel, Word, PowerPoint, Access, Lotus Notes, ChangeMan DS, Windows XP Pro, Indus Portal J, XML Spy, Analyst, Peoplesoft, Workbench, Microsoft Outlook, SourceEdit (SPF) Standard, Test Director, Beyond Compare, Hummingbird, NextAxiom

Royal Bank of Canada May 2004 – Dec 2006

Senior Technical Analyst (Consultant)

Performed a variety of tasks on diverse projects/assignments with the Global Technology Support group that provides 24/7 support for all IT infrastructures of the Bank all over the world. Analyzed, coded, tested and implemented solutions;

Reviewed requests and developed detail specifications for programming assignments;

Provided guidance, leadership and training to junior staff members;

Ensured system development integrity according to industry-accepted standards and practices; and provided 2nd tier technical support to ServiceLevel Agreements (SLA).

ENVIRONMENT/TOOLS: MS Windows, SCO Unix, Oracle 9i, SQL, PL/SQL, MVS COBOL/Mainframe, JCL, DB2, CICS, QMF, ChangeMan, TSO/ISPF, SPUFI.

Metafore IT Inc. Apr 2002 – May 2004

Senior Technical Consultant

African Reinsurance Corporation Nov 1988 – Mar 2002

Head of IT Department

African Alliance Insurance Company, Lagos, Nigeria Apr 1986 – Nov 1988

IT Manager

Royal Exchange Assurance, Lagos, Nigeria Aug 1980 – Mar 1986

Programmer Analyst/Senior Programmer Analyst



Contact this candidate