System Project

Zoran Jovicic

** ***** ******* *****, *******, ON, M3H 5L4 416-***-****

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

HIGHLIGHTSIT consultant with 30+ successful large system implementation/integration/data conversion projects.B.Sc. in Computer Science with 20+ years of hands-on experience designing, implementing, integrating and supporting complex computer applications. Specialist in data conversions/migrations. Expert for ETL/DW, ERP, SunGard/Ellucian Advance implementation, and data sanitization.Finance/Banking, Insurance, Retail, Telecommunication, Manufacturing, and Healthcare experience.Expertise with UNIX / Linux, PL/SQL, Ab Initio, Perl, AWK, ORACLE, DB2 and Sybase.

CONTRACT / PROFESSIONAL HISTORY

Feb ’12 – Jul ‘12 York University, Toronto, Ontario

System Integration ConsultantPerformed retrofit of the system-integration process for upgraded SunGard/Ellucian Advance ERP system. Resolved number of deficiencies and implemented enhancements using Oracle PL/SQL.

Aug ’11 – Feb ‘12 TD Securities

DW/ETL ConsultantHelped transition support and maintenance of Ab Initio ETL processes from one team to another.Participated in troubleshooting and support of Front, Middle & Back-office DW loads using Ab Initio. Supported code migrations for complex system of multiple environments, releases, and data sources.

Jan ’09 – Aug ‘11 CIBC Wealth Management, Toronto, Ontario

Senior IT ConsultantParticipated in Middle Office DW implementation. Developed and implemented dashboard summarizing operational issues for director level executives. Acted as subject matter expert for multiple projects. Worked on Expert System design, data analysis and documented transformation logic for various processes. Lead team of 3 developers to document ETL processes and propose improvements.Contributed to improving security of file transfers. Used Perl, UNIX shell scripts, T-SQL.Used Unicenter TNG to support execution and troubleshooting of jobs for Middle Office DW loads.

July ’08 – Dec ’08 Bank of Montreal, Toronto, Ontario

ETL Consultant, Projects: Basel, Anti Money Laundering Developed Ab Initio graphs for transforming and loading data to EDW. Part of ETL processing was in batch mode and part was continuous flow publishing the data to IBM MQ queue.Created wrappers, test cases, documentation and provided support and handover of the finalized code to the production support stuff.

Sep ’06 – July ‘08 York University, Toronto, Ontario

Data Conversion Specialist, Project: SunGard Advance implementationParticipated in implementation of SunGard Advance, fundraising and donor management systemArchitected and implemented, using Perl and PL/SQL, system for automated data-validation, identifying records for data cleansing. This system was used as project’s success metrics for all technical aspects of data conversion and audit, and it contributed to the smooth rollout of the new fundraising system.Translated hundreds of business rules to the code, listing in HTML form records that don’t satisfy the criteria. Implemented parsing solution for keeping the documentation in sync with the code.

Sep ’05 – Sep ‘06 Bank of Montreal, Toronto, Ontario

ETL Consultant, Project: Basel II implementationArchitected and developed Ab Initio graphs for processing and DW load of Basel II related data feeds from Moody’s, S&P, and other sources. Created wrapper scripts and documentation.Replaced tens of Ab Initio graphs with single graph, significantly reducing maintenance cost.Gained thorough understanding of the Basel II Capital Accord, fixed income financial products, derivatives, futures, options and swaps. Passing CSC exams later solidified this knowledge.Participated in the peer code-review process, testing, creating documentation and test cases, by following the requirements of the Carnegie Mellon’s CMMI methodology.

Jul ’04 – Sep ‘05 MFX Inc., Toronto, Ontario

Data Warehouse Developer, Project: DW support and data migrationSupported large data warehouse for the insurance industry, using ETL tool Ab Initio.Automated monitoring and ftp processes in the UNIX/Oracle/Perl/shell/Abinitio environment.Developed Perl, PL/SQL and UNIX shell scripts; created documentation using Toad and ERwin. Due to the increased complexity, interactively performed monthly and quarterly data loads.Trained other team members in using Ab Initio GDE (Graphical Development Environment).Participated in performing a large data-center move and migration of COBOL/mainframe application to COBOL on HP9000. Handed over the application support to another service provider.

Aug '01 – Jun ‘04 Indigo / Chapters Inc., Toronto, Ontario

ERP Consultant, Project: Maintain existing system during SAP implementationParticipated in data conversion from Retek to SAP. Provided 7x24 technical support of Retek system and Supply Chain Management (SCM) system for replenishment of over 300 stores across Canada.Developed tools for monitoring, automating, and troubleshooting of the Retek system. In-house developed OLAP and data mining tools using UNIX shell, PL/SQL, and Perl. Maintained and enhanced Retek system in live UNIX/Oracle environment; developed fail-safe automatic paging for critical errors.Worked with marketing loyalty team on enhancing Campaign Management System. Supported DW, data marts and Business Objects BI system. Participated in performance tuning. Performed customer base segmentation by mining multiple databases. Worked closely with marketing team to identify and create meaningful and actionable customer clusters. Developed, implemented, and automated ETL tools for NCOA address-correction of the Customer Loyalty Management system. Created reports, trend analysis, elaborate shell scripts, documentation and process procedures.

Aug. '00 – Jul ‘01 Nortel Networks, Toronto, Ontario

Integration Specialist, Project: Baan - i2 integration Played key technical role in system integration of Baan ERP (Enterprise Resource Planning) and i2 Active Data Warehouse for Nortel Networks. Participated in i2 – Baan data mapping. Implemented ETL tools for loading sales orders from Baan’s Oracle database with monthly value of over $1 Billion to i2’s forecasting system.Worked with i2 consultants to verify data loaded to the DP (Demand Planner), SCP (Supply Chain Planner), and RCP (Rhythm Collaboration Planner) engines; implemented loading of i2 data back to Baan and automated data extracts and loads.

Feb 00 – Jul 00 Digital Security Controls

Senior ERP Consultant, Project: ERP system migrationMigrated production Baan ERP application to a different UNIX server. Created custom reports, ad-hoc PL/SQL Oracle queries; enabled simultaneous printing of single Baan report to multiple printers.Performed system administration, support and troubleshooting of Baan ERP systems.

Jan 99 – Dec 99 Nortel Networks

Senior ERP Consultant, Project: Support of Nortel’s Baan instances worldwide Participated in successful implementations of multiple instances of Baan ERP. Supported users worldwide on multiple live Baan systems; worked on resolving complex Baan ERP and UNIX related technical problems. Automated Baan jobs and UNIX tasks on multiple application servers.Developed tools for monitoring Baan systems using Perl, Expect, and UNIX shell scripts.Developed numerous Expect scripts to automate repetitive tasks.Used WinRunner for automated testing of various Baan sessions.Performed various performance analyses, access-time measurements for the Oracle tables, and complex numerical and statistical analyses.Designed and developed dynamic UNIX menu structures using Perl and UNIX shell scripts.Created technical documentation and procedures using HTML, and trained team members.Participated in testing EDI functionality and interfacing with Oracle financials and other systems. IBM’s MQSeries was used for transferring EDI messages.

Nov. '97 - Jan. '99 Computer Associates/ Realogic, Cleveland, Ohio

Senior ERP Consultant, Project: ERP implementationParticipated in Baan ERP implementation for Sealy Inc., mattress manufacturer supplying 7000 retail outlets, enabling order-to-delivery in 24 hours. Setup system security, implemented automatic paging in case of security breaches or critical system problems; generated reports for auditors. Automated Baan jobs; developed tools for ERP system monitoring, administration and ETL using UNIX shell, Perl, AWK, Expect, Java and HTML. Worked on including Baan monitoring features, into CA Unicenter. Incorporated system documentation into Web based monitoring system enabling easy drilling-down trough documentation and historic data Performed data conversion and system upgrade from older release of Baan. Participated in implementing SAS business intelligence system. Provided training for team members and developers.

Oct. '95 - Nov. '97 Noranda Inc., Toronto, Ontario

Systems Analyst, Project: ERP ImplementationParticipated start-to-finish in implementation of ERP system and DW; administered ERP multi-company system with 100+ users; coordinated activities with the third party developers. Implemented nightly ETL from live Baan ERP system to the DW. Involved in Data Modeling. Created Baan reports, forms, and sessions, custom menus for all user groups, various dashboards and maintained system security.Developed new features for the Baan ERP system, participated in implementation of faxing, laser-check printing and sending bank wires directly from Baan. Implemented and maintained automated Baan jobs. Created technical documentation, procedures, and provided user training. Developed UNIX, AWK, and Expect scripts for system administration, data migration, and ETL.

Apr. '94 - Oct. '95 Healthware Technologies Inc., North Bay, Ontario

Data Conversion Specialist, Project: Y2K system upgrade for all clients Performed Y2K conversions and HIS (Hospital Information System) upgrades for 20+ clients. ETL developed for upgrade process; managed complex data conversions. Performed data conversions from Healthware to other vendor’s systems and vice versa. Familiar with HL7 standard.Sanitized patient data to meet strict privacy requirements; created unique demo HIS DB and catalogue of standard reports, dramatically improving sales. Created 100+ reports using various report writers.Coordinated system upgrades with project sponsors; supported and trained end-users on new systems.

Apr. '92 - Apr. '94 Yozoki Computer Services, Toronto, Ontario

Programmer/AnalystDeveloped modules for warehousing applications in INFORMIX-4GL under UNIX, using SQL. Created numerous UNIX shell scripts. Tuned DB design for better performance and wrote documentation.

Sep. '90 - Apr. '92 UPI-AMAI, Sarajevo, Bosnia

Information System DesignerTransferred single-user dBase and Clipper business applications to multi-user UNIX PCs using INFORMIX-4GL. Developed ETL tools and migrated data from mainframe Honeywell DPS-66 to PC's. Participated in development of the software for shop-floor control.

EDUCATION & CERTIFICATIONS

Jun. 1991 Bachelor of Science Degree in Computer Science

University of Sarajevo, Bosnia, Major in Information Systems

Feb. 1998 Certified in Baan IV ERP Advanced Enterprise Tools

2004, 2009 Brainbench certification in Perl

Sep. 2007 Canadian Securities Course (CSC), Canadian Securities Institute

Aug. 2009 Anti Money Laundering, Canadian Securities Institute

Contact this candidate