Developer Data

Dominic DiMira B.Sc

416-***-****

*******@*****.***

PROFESSIONAL PROFILE

Experienced Systems Analyst. Performed all roles within SDLC from participation in client strategic planning, client engagement meetings, analysis of customer requirements, software development and customization, testing and documentation aiming towards positive service delivery and complete customer satisfaction. Extensive experience in Telecommunications inventory and ERP. ETL design and implementation for small and large projects. Led teams providing both technical support and business requirements.

Employment History

Health Management Systems Vaughan, ON May 2015 –

Sr. Data Consultant

••Used Talend Open Studio to design ETL solutions to extract and manipulate data

••Data modeling to support HL7 format

••Management of databases in local environments

••Imported research databases and produced discrepancy reports using Talend ETL tool

••Various SDLC tasks to support flagship product ezHealthPal.com

Databases: MySQL

Languages: SQL

O/S: MS Windows

Tools: Excel, Talend

TieroneOSS Toronto, ON Feb 2013 – May 2015

Sr. Business/Data/System Consultant

••Led ETL design and implementation extracting legacy data to new source system

••Mentored others in database design, ETL planning and how to use tools

••Effective communication of design, plan and details to all parties

••Direct communication to end users, project management and developers

••Management of databases in local environments and providing instructions to production DBA

••Performed Database changes in production environment

••Imported network information and produced discrepancy reports using Excel and Pentaho SPOON ETL tool

••Tested results and tracked down root cause.

••Created and ran SQL scripts to investigate issues

••Supported Oracle's Objectel Telecom Inventory system by troubleshooting and performing/executing queries

••Gathered requirements from users, documented and managed execution

••Ported legacy order management system to new E-Portal framework

Databases: Oracle, SQL Server, Access

Languages: SQL, PL/SQL, Java, JavaScript, C++

O/S: MS Windows, HPUX

Tools: Excel, SQL Developer, NotePad++, Oracle Objectel, Pentaho/Kettle Spoon ETL

Buck Consultant/Xerox Toronto, ON Dec 2012 – Jan 2013

Database Analyst

••Created ETL tools to scan for embedded users, passwords and server configuration information in different types of legacy text files, different source code and database tables

••Used regular expression to match positive outcome and filter out false positives so client could identify required changes

••Used KETTLE SPOON ETL tool to import XML, source code, Java, C#, VB, ini, batch files and database tables and performed language specific searches

••Created rules for various sources using SQL and produced reports

••Reported to directly to IT Director

Technical Summary

Databases: Oracle, MS SQL SERVER, Excel

Languages: SQL, Java, C#, VB

O/S: MS Windows

Tools: Kettle Spoon

Mancor Oakville, ON Aug 2012 – Oct 2012

Programmer/analyst

••Created Visual Basic forms and VB code using Visual Studio for company’s Manufacturing ERP system

••Wrote SQL queries for MS ACCESS and MS SQL database

Technical Summary

Databases: MS ACCESS, SQL SERVER

Languages: Visual Basic

O/S: MS Windows

Don River Brampton/Toronto, ON June 2011 – Dec 2011

Sr. BUSINESS/DATA ANALYST

••Supported implementation at Rogers OSS, application to view/edit/create site locations in central database and push changes to Amdocs ARM system, site information was spread across different departments and data sources

••Led ETL portion of project, performed data cleanup of original sources and transformed and migrated data to spatial database, used latitude and longitude to confirm geographical locations

••Met with different users and departments to determine business and data requirements and processes.

••Updated requirements documentation and held user meetings to obtain sign off

••Used Open source tools, Pentaho KETTLE, Talend Open Studio, to extract data from Oracle, ACCESS, Excel data sources.

••Created staging databases and transformed data to normalize for comparisons, created exception reports for users to fix incorrect data

••Created migration scripts to change data depending on business rules

••Tested applications from offshore resources and communicated required changes

Technical Summary

Operating System: Windows, HPUX

Databases: Oracle, MS ACCESS, Excel

Software: Pentaho KETTLE, SPOON, Talend ETL, Word, Outlook, Oracle Objectel, AMDOCS ARM

Remedy Consultant – Remedy Developer at Eftia OSS Solutions, Ottawa, ON

Remedy Consultant – Remedy Developer at MTO (Ministry of Transportation), St Catherine’s, ON

Database Developer – PL/SQL Developer at GTTA (Greater Toronto Airport Authority)

Programmer/Analyst – Programmer/Analyst at Accugraph/Architel/Nortel/Metasov/Oracle

Programmer/Analyst - C Programmer at Remedy Software, Ref Retail Systems, RDS Tasks/ Diebold, MGV Retail systems

Education & Professional Development

North American College: E-Com Program: Java, C#, J2EE

Enhance Systems, Mississauga: Remedy Administrator’s Course

SAP Partner Academy, Boston: Course led to ABAP/4 Certification

Digital Training Centre: VMS, Ultrix and UNIX operating systems

University of Toronto: BSC Computer Science Degree

Contact this candidate