Summary

A senior Consultant with over 25 years of information technology experience. The last 15 years have focused coordinating the analysis and design of business systems. The approach taken is to develop and maintain a thorough understanding of the needs of both the business and technical perspective. Expertise includes, PM , SDLC methodologies, BPM management, Feasibility studies, Financial Securities, package recommendations, BI, functional specifications, testing interfaces and migration planning. Knowledge transfer includes mentoring users, training sessions and business systems documentation. In addition, exposure to SOA, enterprise repository tools, metadata concepts, OOD development principles. Government of Canada security clearance at SECRET level.

Business Experience

Confidential

SR BI/ETL Developer

Environment:

• MS Suite of Tools with Windows XP Professional/Win 7, IBM Infosphere Datastage 8.5, IBM Infosphere Server EE ,. Erwin, Oracle10g,DB2 Sql Server,MS Suite, Erwin,Toad, DBVisualizer, FTP utilities, SQL, and QC 10.
• Mainframe work included using tso/spf, PDS files, GDGs, SAS utilities and determining data quality and layouts in Hex and text formats.
• ETL Developer Responsibilities Extract, Load and Transform ETL
• Background Applied
• Solid experience in designing, developing, testing, and implementing ETL solutions using IBM DataStage
• Expertise in RDBMS, Data Mart and Data Warehouse design. Knowledge of data modeling
• Experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
• Strong understanding of ETL best practices
• Experience writing well documented unit tests and executing them
• Working knowledge of scripting in Korn Shell scripting
• Experience of reverse-engineering data mappings.
• Ability to express complex technical concepts effectively, both verbally and in writing
• Strong understanding of SDLC and Agile Methodologies
• Guidewire knowledge for PC, BC, and CC.
• Mainframe working experience in SAS, COBOL and Flat files
• WSIB ETL methodologies and job design with integrating input/jobs.

Responsibilities

• Provided technical assistance, advice and guidance to Business Technology Services BTS staff and WSIB business users in response to enquiries on the functionality of BI/ETL tools, and data in EIW and related datamarts to ensure efficient and un-interrupted IM services to the business users.
• Developed both parellel and server jobs.
• Loaded Historical target table using Mainframe and SAS layout.
• Used complex file stage to load binary and text data to target tables.
• Provided support for Enterprise Warehouse operations e.g. monthly update of EIW and datamarts, EDW, and IM Catalogue related systems to ensure the delivery of timely, accurate and reliable data to WSIB business users. This included monitoring the update processes, updating/maintaining the appropriate system documentation, identifying potential problems and implementing solutions to ensure the efficiency and reliability of the IM operations.
• Maintained the ETL environments by monitoring their performance to ensure functionality, integrity and security of the environments and compliance with BTS information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within BTS for resolution.
• Wrote complex SQL as part of the retreiving source data to pass to other stages that in part including transformation stagea, sort, join and change management stages.
• Monitored and administer automated and manual data integration and ETL jobs to verify execution and measure performance.

Confidential

SR. Data/Systems

Environment:

• MS Suite of Tools with Windows XP Professional, IBM Infosphere Datastage 8.7, IBM Infosphere Server EE with QualityStage,. Erwin, Oracle10 11, PL/Sql and SQL, and QC 10.
• This project included the Modernization of the current systems and a major data cleansing project.
• The work primarily included the move of legacy Landing area to a Staging for cleansing.
• I was in charge of the LCS Stock transfer of data for MTO.
• This included data analysis, mapping, and business transformations using information documented on MQC then summary into excel spreadsheets.
• The next step included a Design document that outlined the data model with referential integrity, audit controls of counts and runs.
• Recovery was also built into the design to insure quick recover and minimal downtime.
• Developed processes for cleansing, transforming, and validating, that I loaded into the Staging area.
• Used QualitylStage in the Standardization, Matching and Survival of the name and address rows.
• Trained staff in IBM Infosphere Datastage 8.7

Confidential

Business Analyst/ETL Designer

Environment: UNIX, DB2, Datastage 7.5 PX and Server, Putty, FTP, SAP 6, Purchasing, PO, and AP.

• Responsible for understanding Business Process and managing with Business users to meet specific user requirements.
• Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.
• Responsible for documenting user requirements and translated requirements into system solutions.
• Implementation plans and schedules are also developed.
• Develop processes for cleansing, transforming, extracting, integrating and loading data with use of Datastage.
• Written complex queries to facilitate the supply of data to other teams.
• Responsible for using different types of Stages such as FTP, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.
• The ultimate target on the assignments was to ease the access of data without the need to constantly request of build complex structures resulting in a time delay of creating the necessary cubes and data marts.
• The ease of accessing customized data improved the timely delivery of user reports using ETL assisting in the extraction of detail data at sufficient level for purposes of driving down to the level of detail data at the ad hoc request of the user.
• Procurement used SAP data to populate a procurement fact tables that included the following dimension tables
• Customer, Purchasing Organization, Standing Offer, PO, PO line items, Vendor, Amendment, Amendment Reason, and GL.
• Stages included where the Merge, outer joins , Database access using ODBC, Lookup transformations containing mappings and business rules. The organized data was then passed to Cognos BI to create cubes and various business-enhancing reports.
• Using the Data Mapping document data it was a case where 75 of the data was mapped one for one with the remainder 25 containing ETL code logic to fulfill the medium to complex business rules. Millions of rows of data was loaded using a high performance DB2 Load utility measured in seconds and minutes.
• Another data mart involved five dimensions, PO Header, PO Line Item, Amendments, Amendment Reason, Standing Order and Purchasing Organization.
• The purpose of both fact tables was to make Procurement Data readily available to access for creating ad hoc reporting cubes.
• The data architecture involved 3 layers that included a data landing zone, a staging business preparation, cleansing and modeled in MDM structures to be used for example by data marts.
• Documented matrix testing involved developer testing from end-to-end using the business requirements as a basis for the expected results and regression testing. Further testing was done in UAT before being promoted to Production.

Confidential

Business Analyst/ETL Designer

Environment:

• MS Suite of Tools with Windows XP Professional, SDLC, Mainframe, IBM Infosphere Datastage 8.1, IBM Infosphere Server, Teradata Mulit-Loads, Oracle, SQL, QC 9.2.
• My responsibilities included migrating from Datastage 7.5 to Datastage 8.1.
• Main responsibilities related to Capital Market instruments.That included for example mutual funds and series, equities, convertible bonds, asset backed securities and mortgage-backed securities.
• Recompiled over 800 Datastage Jobs, and reviewed any compile errors very few required modifications .
• Converted over 400 Datastage jobs form 7.5 to 8.1.
• Datastage 7.5 jobs where checked out from the production library, and compiled in the Datastage 7.5 development Unix environment.
• Data was copied to the development environment and used for testing.
• Once the jobs worked in the newly created 7.5 environments with semi-production data they where then ready to be moved to the Datastage 8.1 environment using the same code and data.
• The migrated jobs work fine with some date and field size issues.
• Also, worked on a number of Datastage applications as per user-documented enhancements.
• In some cases Datastage jobs and Teradata BTEQ were executed using Mainframe JCL.
• Datastage jobs followed documentation standards from BRD, a Technical requirements document and code reviews, and production documentation that all had to be signed off.
• Enhancements where done using Datastage 8.1 only. They involved the removal of unused code and the optimization of jobs stages reducing unnecessary stages and streaming the process flow.
• Other enhancements required the changes of database structures where attributes where either removed or introduced for new functionality. Transformation rules and layout changes introduced where tested in DIT form end to end.
• Stages in part included the join, merge, and copy, match, sequencers, sorts, removal of duplicates stage, funnels, heavy used of stage variables, and constraints.
• Data manipulation in part included flat files, hash files, datasets, Teradata SQL updates, inserts, deletes and deltas.
• Used routines for job run controls, debugging, counts, and e-mail notifications for either successful or failed jobs.
• Worked with data architects, SME's, ETL architects, and users to ensure requirements where met.
• Once the jobs where completed and successfully running in SIT and UAT tested they where promoted back into production.

Confidential

Technical Consultant

Environment:

• MS Suite of Tools with Windows XP Professional, VM, LINUX, Shell Scripts, SDLC, IBM Infosphere Datastage 8.1, IBM Infosphere Server, Teradata, Oracle, Java, Mainframe, Cobol, and SQL.
• Project included working on Financial Systems AEP Analytic Environment Program.
• Design and Developing JOBS and testing, Creation of test data.
• Contribute to the design and implementation of data acquisition strategies to populate the dimensional data.
• The majority of the project consisted of the acquisition of various types of complex forms of data and transforming to the AEP Warehouse.
• Quickly acquired detailed understanding of the data sources and implementing solutions that efficient, broken into understandable and maintainable job.
• Used lookup stage with reference to Oracle tables for insert/update strategy and updating of slowly changing dimensions.
• Involved in performance tuning of the ETL process and performed the data warehouse testing.
• Involved in unit, performance, regression and integration testing of data stage jobs and prepared Documentation.
• Developed Korn Shell scripts to automate file manipulation and data loading procedures.
• Helped in preparing the mapping document source to target.
• Familiarity with Teradata Multi-load, Fastload, BTEQ, Teradata SQL, Oracle, SQL Server, DB2 database systems and reporting methodologies.
• Participated in daily status meetings with team leads including the testing lead.
• Knowledge transfer and mentoring staff and troubleshooting.
• Involved in tuning aspects of the datastage client and Servers.
• Performance tuning involved the monitoring and helping in determining a solution for high server and client memory usage.
• Monitored datastage performance using 'Performance Analyzer' and UNIX TOP.

Confidential

Senior BI/BW Analyst via Agency

Environment:

• MS Suite of Tools, Mainframe IBM 390, UNIX servers, ETL Tools, SDLC, WEB Servers, DB2, SQL, BO XI, .NET, SQL Server, Metadata, Microsoft Office, MS Visio, and Quality Center 10.0 QC .
• Developed functional specifications for a portion of the SIRIUS System that included functional business descriptions, business flow diagrams and data flow/process mapping following the AVIVA BRD and other documentation standards.
• Held working sessions with financial users regarding results expected and guidelines on how to go about the testing cycle. The sessions included the use of BO, the SIRIUS universe, corporate financial reports including hierarchies, and their own internal reports for validation to the MINDS-CDW reports.
• Performed research and data analysis on issues arising in the projects, ensuring timely notification and escalation of possible issues, along with options and recommendations required for meeting business requirements.
• Worked with data modelers and ETL designers/developers to contribute to the design and implementation of data acquisition strategies to populate the dimensional data model.
• Worked on the MINDS Project Management Information DW . Provided relevant BI project deliverables as well as testing towards production implementations.
• Completed the architecture reviews and assisted in the data architecture of the APM DB2 staging tables to be used in the corporate initiative of moving towards a Enterprise Data Architecture.
• Extensive involvement in the cleansing of source Mainframe data used by down stream applications and the Data Warehouse.
• Enforced metadata standards that included structures and dimensions.
• Worked with third parties and business partners for example, SQLaison to compliment the areas of expertise in ETL and complex DW designs.
• Used BO 5.9 and BO XI extensively and gained significant business knowledge or insurance. Related to CATS, MLC and various versions of Large Loss and Ceded Large Loss.
• Provide maintenance support for test environment and testers.
• Completed the Business Object XI R2 Accelerated Knowledge in-house self training and gained the skill of developing BO XI reports. Used BO XI in the development of ad-hoc reports when debugging user financial reports.
• Courses: In-house self-training: Business Objects, and BO XI R2 and C11 Principles of Insurance.

Confidential

Business/ETL Analyst

• Worked closely with other project team members including data architects, solution architects and SMEs.
• XML was instrumental as part of IT strategy to move towards a SOA environment.
• Worked closely with financial business users to understand the current state and target state business processes and participated in the mapping of legacy to new target system.
• Created business process models, data flow diagrams, and provide input to data models/
• Designed a validation process for existence of 'essential/core' data. Rows in error were routed to users via e-mail notifications.
• Worked closely with the Development team to validate that the Technical design met the business requirements.
• UAT testing included the creation of Test Plans/Scripts based on the user requirements.
• Created and execute test cases and scripts, recording and communicating defects through the approved defect management process.
• Supported project change control protocols.

Confidential

Business/System Analyst

• Project Platform: Windows XP, Microsoft Office, MS Visio, Unix, Data Warehousing, Star Schema, ERWIN, SAP ECC6.0, BI 7.0,RWD uPerform recording/replay software , ClearQuest, and Mainframe.
• Worked on the Legacy to SAP implementation project.
• Worked with different Business groups/users and in particular financial users to understand the Business Requirements for the project.
• Main responsibilities related to Capital Market instruments.. That included for example mutual funds and series, equities, convertible bonds, asset backed securities and mortgage-backed securities.
• Worked with senior Capital Market senior management analyzing securities and a migration strategy to SAP.
• Reviewed legacy systems and new business requirements and providing input to the Data Architects to help create/update Logical/Physical Data Models for the Data Warehouse.
• Documentation incorporated both business requirements and Data Warehouse components.
• Testing included reviewing Test Plans/Scripts to ensure adequate coverage of the proposed design that focused on the new financial charts of accounts.
• Wrote audit reports with counts and totals, as well as the random data sampling to validate loads.

Confidential

Data/ETL Analyst

• Project Platform: Windows 2000, Data Warehousing, Mainframe, Endeavor, JCL, TSO, SPF, COBOL, ETI, Oracle and Teradata.
• Worked on the new Credit Fraud System
• Project involved the modification of the existing system to include additional attributes to enhance fraud detection.
• Extensive involvement in identifying and documenting interfaces.
• Involved in source to target data analysis, business rules, and mappings.
• Data model included approximately 55 tables.
• Worked in co-operation with other projects and in the sharing of subject area data.
• Interacted with the Business Analyst and Technical Team Leads.

Confidential

BI/Systems Analyst

• Platform: Windows 2000, Microsoft Office, MS Visio, Mainframe, COBOL, Unix, SQL Server, Oracle 9i and 10g.
• Software: SAP 5.0, SAP BW 3.5, BI 7, and .NET.
• Worked on the PTC EIS Executive Information System using SAP BW BI .
• Interacted with the management and users to identify areas of high ROI.
• Focused on SAP modules FI, CO, AM, MM, and SD.
• Involved in documenting Info Cubes requirements at the Executive and Departmental levels.
• Involved in source data analysis from legacy systems.
• Writing technical specifications based upon functional requirements.
• Research, identify, and apply new technology solutions to improve business intelligence delivery via portals using iViews and Netweaver.

Confidential

• Business/Data Analyst Platform: Windows 2000, and Mainframe, Microsoft Office, MS Visio, Unix, Oracle 9i and 10g.
• Software: Ascential DataStage ETL , SeeBeyond EAI , Erwin Allfusion , SAP 5.0, and Visio.
• Meeting and review of functional specifications documentation.
• Business Analysis skills such as: requirement gathering, process mapping impact analysis and testing were used and throughout this project and various other client projects.
• Analysis of core areas included Customer, Customer Profile, Materials and Claim.
• Documented Data Interfaces requirements to existing systems.
• Security requirements. LDAP and VSP.
• Data analysis using functional specifications documentation and wrote DW test scripts.
• Presentations to architects and staff.

Confidential

Business/Data Analyst

• Platform: Windows 2000, Microsoft Office, MS Visio, and AIX UNIX.
• Software: SAP4.6B, BW2.0B, Erwin, Toad, PL/SQL, Oracle, and SQL.
• Worked on the Cost to Serve CTS Project that included an Enterprise Data Warehouse.
• Involved with gathering and clarifying management requirements.
• Documentation included mappings of source to target and using Visio and Word data flow diagrams.
• Enforced metadata standards that included structures and dimensions.

Confidential

Systems Analyst

• Platform: Windows XP, and AIX UNIX.
• Software: Data Analyst, ODS, Java, Web methods, PL/SQL, Oracle, Unix, DataStage 7, and SQL.
• Worked on the integration of company merger/partnership with Bank of America and Vital.
• Involved in Data Analysis, Design, Development and writing test scripts.
• The process involved integrating the MAS and MSS subject areas.
• MAS include the merchant, account information and demographics and the MMS system included terminal setup and usage at the merchant sites.
• A new ODS Staging area was design to incorporate both components that would be used by the new Vital Express System.

Confidential

Systems Analyst

• Platform: Windows XP, and AIX UNIX.
• Software: ERWin, DW/Star Schema Design, ODS, EDW, Webmethods, PL/SQL, Oracle, Unix, DataStage 7, and SQL.
• Work on the JABIL system populating an ODS with inventory data and in particular vendor in-transit data. To improve inventory liability accounting for inventory that Lexmark sells to vendors as components and then buys back at a later point in time as finished products.
• Involved in Architecture, Design and Development and writing test scripts.
• Very tight schedule to meet last quarter implementation deadline.
• Documented test scripts from the business requirements and verified DW data accuracy and compliance using SQL.

Confidential

Business Analyst

• Platform: Windows XP, and AIX UNIX.
• Software: AllFusion ERWin , DW/Star Schema Design, PL/SQL, Oracle, DB2, DataStage 6, .NET and SQL.
• Work on the Activation Tracking System. High visibility on a short time frame.
• Involved in Architecture, Design and Development.
• Environment included Erwin, Oracle 8i 9 and SQL.
• UAT and DW Testing and Defect Tracking with Users and developers.
• DataStage was used for cleansing and complex data transformation to feed interfacing systems.

Confidential

Systems /ETL Designer

• Software: ERWin, DW, Star Schema Design, Oracle, DB2, DataStage 7.1, DB2 UDB, SQL, Websphere, JAVA, JSP, and Synergy.
• Worked on the Technician Dispatch system. JSP front end, middle tier using Websphere with J2EE and backend using DataStage 7.1 with DB2.
• This system also includes the use of GPS to gather information on technician and vehicle assignment, their locations and job status.
• Reviewed system defects, wrote specs, test scripts and made optimization recommendations and modifications.
• Worked in cooperation with Data Architects, Testers, ETL Team members and Business Analysts.

Confidential

Migration Analyst

• Platform: NT 4.0, Windows 2000, and AIX UNIX.
• Software: Erwin, Oracle, DataStage 5.2 and 6, SAP 4.6C, and Toad.
• Worked on a SAP Data Migration of the SAP manufacturing module specifically PP, CC- Routings .
• Worked with Data Architects on optimizing data relationships, mappings and identifying gaps.
• Defined Mappings and test scripts between Legacy, ODS and SAP.
• Wrote technical specifications as well as involved in ETL development.
• Designed complex SQL necessary to fulfill aerospace DW/ETL requirements.

Confidential

DW Architect /Senior ETL Designer

• Platform: Mainframe, NT 4.0, and UNIX.
• Software: ErWin, Oracle, DataStage , Star Schema , PL/SQL and SQL.
• Involved in the DSE analysis/design and development project that included using multi-dimension Star Schemas.
• Mainframe legacy data was passed to DataStage as a major part of the ETL sourcing process.
• Incorporated the usage of Group-1 software for address validation and standardization.

Confidential

Senior ETL Designer

• Platform: NT 4.0, HP, and AIX UNIX.
• Software: JBuilder, Java, Weblogic, Oracle, ETL tool DataStage 5.1, and SQL.
• This project involved the development of a new retail pharmacy store system.
• External metadata was used to control extraction, transformation and loading of sensitive data.
• Complex sourcing of error prone flat file data was cleansed using ETL and UNIX utilities.
• Involved in the Pharmacy ODS/DW design and development using Star Schema DW modeling.

Confidential

CRM/Data Warehouse Architect

• Platform: NT 4.0, HP, Solaris, AIX, and MVS.
• Software: Java, EJB, JSP, Javascript, XML, HTML, WebSphere, Weblogic, ERWin, Oracle 8.1.6, Star Schema, SQL, ,NET, VB, and Cobol.
• Responsibilities included CRM work in the phases of business/data analysis, design, prototyping, customizing and external data interfaces.
• Data modeled Forecasting and Planning business areas to be used in gap analysis.
• Evaluated the Data Warehouse component of CRM vendors that in part included, Siebel, YouCentric, Clarify,Onyx, Oracle, and Vantive.
• Mentored the junior project manager on all ETL project details and tasks.
• Supervised a team of 6, held weekly status meetings with the team members and management

Confidential

Business/CRM Analyst Platform: MS Project98, Windows 2000, NT4.0, Oracle 8i, Oracle 8 Lite,TCP/IP ,Weblogic ,J2EE, Java, EJB , JSP, XML, Erwin and Star Schema.

• Involved in the development of CRM software based on multi-tier OO meta data design, with EJBs, Java and XML technology.
• Responsible for the Enterprise Application Integration EAI selection that included a detail report of requirements, vendor profiles, and recommendations.
• This project was critical in that it had to provide a flexible architecture to interface with any type of external system from legacy, ERP, and the WEB, using adapters to handle flat files, XML, and RDBMS written in Java, and CORBA and DCOM compliant.

Confidential

SAP Data Architect

• Platform: HP Unix, Windows NT, Oracle 8, MQSeries, TCP/IP, VB6, DataStage, ODS, Data Warehousing, Data Mining, Crystal Reporting, Cognos, IDMS/R, IBM Mainframe, Cobol, TSO, and SPF.
• ERP Software: SAP R/3, SAP BW 1.2b ABAP, BDC, ALE, IDOCS, and CATT.
• Business Packages: SAP R/3 Versions 3F and 4.0B Oracle 8 , Modules: PS, HR, FI, FICO MM.
• The target environment was to consist of a Data Warehousing and Data Marts approach through an operational data store ODS facility.
• SAP R/3 to legacy data mappings with accompanying test scripts.
• Sequencing of Master File Loads, review of master and transactional files.
• Testing financial data BDC modules, and loading data using CATT.

Confidential

Data Analyst

• Platform: SUN 3000 and 10000, MVS, CMS and UNIX.
• Software: Oracle, PeopleTools, SQR, SQL,PeopleCode, Cobol, TCP/IP, EDI, Visio, ETL tool Convoy ETL Tool , and MS Project.
• Business Packages: Integral, PeopleSoft Financials 7.0 and 7.5.
• Responsibilities included helping Sears convert their legacy financial systems to PeopleSoft Financials. The approach used contained two major components.
• The first is logical in nature and involved the analysis of the legacy system VSAM files and then the corresponding PeopleSoft tables.
• The second step is physical and involved the extraction of mainframe legacy files via Cobol programs generated by Convoy.

Confidential

Data Warehouse Architect

• Platform: AIX, RS/6000, SP2s, NT Client and Server.
• Software: Oracle Designer/Developer, Erwin, Star Schema, PL/SQL, SQL, VB5, Pro C, Visual C , Oracle 7 8, Information Advantage, Java, Cobol, EDI, Visio, and MS Project.
• Areas of responsibility included system integration of new packages and the legacy systems, and having architecture responsibility in the area of Merchandising and Retail Systems.
• Involved in product reviews focusing on the underlying Data Warehouse and Data Model, central processing versus distributed, data replication, messaging, multi-tier designs, user interfaces and portability.
• Data modeling included writing a report evaluating the ARTS Erwin data model a retail industry standard data model and leading a team of two in determining its potential usage within the Store systems.

Confidential

Systems/Data Analyst

• Enterprise platform included the following: ORACLE 7, SQL, AIX , Mainframe Interfaces, IMS, SAP R/3, and the OpenRSA Retailing Suite .
• Worked within the Corporate Information Architecture as Application Architect in the development of an IT Architecture using IBM methodology.
• Worked with a team of senior application architects led by IBM with a primary responsibility of an ETL migration architecture that spanned all systems within the enterprise.
• The team held weekly reviews on infrastructure related topics such as development standards, quality assurance reviews that related to architecture components data base selection, data warehousing, methodology , and the construction and loading of a central repository that contained application architectures and integration implementation plans.
• The RSA package data model was reviewed with the new Logistics logical data model to determine the gaps and as a starting point to identify and document modifications to the package physical data model.
• The legacy databases and files were also examined in preparation of identifying interfaces and conversion requirements.

Confidential

Systems/Data Analyst

• Platform included the following: ORACLE 7, FORMS V4, SQL, ERwin, Star Schema, ACCESS , Pro C,AIX, DCE, 3-Tier Architecture using Encina, and VB Enterprise.
• Worked within the Information Resource Planning and Architecture team.
• Involved in the Computer Aided Dispatch CAD data warehouse project that included the extraction of operational data ODS into fact/dimension tables.

Confidential

Senior Systems Analyst/Developer

• DOFASCO was migrating their IBM mainframe legacy systems to an HP-UX, LAN, Client/Server environment using the Oracle database and related GUI software.
• Responsibilities included writing specs, and testing using PL/SQL, and SQL.

Confidential

Migration Analyst

• Platform: IBM mainframe with DB2, QMF, VSAM, SAS and COBOL II.
• My responsibilities included data analysis in the migration of the Ontario Cancer Registry Information System OCRIS system from an IBM Mainframe to HP Unix.

Confidential

Senior Data Analyst

Worked on the Graduated Driver License System within the Regulation Division of MTO. The systems platform included IMS DB/DC, DB2, and IBM mainframe.

Confidential

Senior Systems Analyst/Team Leader

Worked on the Revenue Strategy Project as a Senior Analyst responsible for the Assessment function, one of the six major functional areas. Technical platform included using DB2, CICS, and COBOL II.

Confidential

Senior Data Analyst

Worked as a Data Modeler on the Gas Accounting System that captured customer order information that assisted in the operation of the pipeline and provided billing data.

Confidential

Team Leader/Senior Data Analyst

Worked in Data Resources group as a Strategic Data Planner using the IEW CASE tool. The work was segmented into corporate data architecture, application data modeling, application architecture and technology architecture.