Aleksandar Zecevic

01/2022 – 10/2024            Choreograph    Toronto, ON                        Data Engineer

Migrated client applications from on-premises DW (Oracle) to cloud platforms (Snowflake and Azure). 

Maintained the data model for our consumer database, which contains Personally Identifiable Information (PII) and over 800 individual attributes. Worked on modules for suppressions, individual matching, and geo services.

Designed and developed data pipelines (Informatica IICS, Snowflake, Python, ADF) to ingest and store both structured and unstructured data. Conducted activities related to data profiling, data lineage and metadata repository. 

Participated in the project to decommission our data centers, including three in the U.S. and one in Canada. 

06/2019 – 01/2022      Wunderman Thompson Data    Houston, TX           Data/ETL Architect  

Contributed to the conversion of an on-premises Oracle-based Enterprise Data Warehouse to a Big Data (Hadoop) platform, facilitating a multi-tenant framework. In my role as a Data and Ingestion Architect was responsible for:

• Developing a data model for a PostgreSQL metadata database (metadata driven ingestion process, data lineage).
• Implementing error handling and recovery mechanisms for ingestion process failures.
• Engaged in Agile project management by writing user stories and facilitating sprint planning.

Created project plan and executed the migration of enterprise scheduling tool (from Tidal to Ctrl-M).

Evaluated cloud data platforms (OCI, Azure, Snowflake, AWS, GCP) to inform future development strategies.

Utilized the Azure Portal for cost management and for setting up Windows and Linux virtual machines. Employed the Azure Database Migration Service to convert SQL Server databases to Azure.

tools: Oracle Exadata, Informatica PowerCenter, Hadoop, PostgreSQL, Kafka, Azure, Agile 

04/2013 – 06/2019      KBM Group    Houston, TX                       Data Warehouse Architect 

Building data warehouse solutions in the domain of marketing and campaign management for healthcare insurance (Humana, Mutual of Omaha), telecom (Verizon) and aviation (Air Canada) clients.

Responsibilities included data modeling, creating ETL specifications, project management, mentoring developers, conducting code reviews, and supporting both BI and DBA teams.

Provided a range of services to clients, including model scoring for members and prospects, suppression management, demographic analysis, multi-channel interactions, sales and policy reporting, and response attribution.

Created relational and dimensional models using Erwin, and generated database objects in Oracle Exadata and SQL Server databases. Supported client users with business intelligence tools, including Business Objects, Tableau, Power BI, Cognos and SAS.

Assisted account managers in the initial phases of new projects by providing LoE estimates and developing high-level project management plans. Developed policies for data governance, data cleaning, data retention and MDM.

tools: Oracle Exadata, Informatica, Erwin, Business Objects, Tableau, SQL Server, Power BI, SAS.

09/2011 – 04/2013      Fortelligent    Boston, MA                      Business Intelligence Consultant

Implemented large scale BI system for telecom client. Led development for Prepaid Data Mart and IP-based TV Data Mart (U-verse, DirectTV). Consolidated large volume data from multiple business units and external sources and loaded into hosted Netezza database. Developed custom applications for data quality and data profiling. 

Managed the secure transfer of data and equipment from Fortelligent to its parent company (KBM) data center.

tools: IBM Netezza, SQL Server, Teradata, Business Objects, SSIS

05/2006 – 09/2011      KnowledgeBase Marketing    Houston, TX               Data Engineer

Developed and maintained customized Data Warehouse solutions for major healthcare insurance and pharmaceutical clients, hosted within company data centers.

Designed, deployed, and managed operational data stores to capture customer data via data feeds and user-managed interfaces. Developed dimensional data marts for BI analysis and campaign management using the Epiphany marketing tool. Created universes and reports in SAP Business Objects. Defined SAS matrices for customer scoring models.

Developed ETL processes using Informatica, SQL, triggers, and stored procedures. 

Gathered requirements through extensive client engagement, documentation, and prototyping. 

Developed Project plans, defined Statement of Work (SOW) and Service Level Agreements (SLA).

Performed DBA tasks including managing data files, tablespaces, and performance tuning. 

tools: Oracle, Informatica, Business Objects, Epiphany

04/2005 – 05/2006      JPMorganChase, Global Equity    Houston, TX       Technical Team Lead 

Led the Houston-based development team, collaborating closely with business stakeholders in New York and London.

Directed the development of a Global Data Warehouse for Order and Execution data (Cash Equities) at JPMorgan Chase Investment Bank, serving as a central source for multiple data marts and BI applications.

Focused on key business objectives, including customer order execution quality, optimal order routing, market health analysis, trading risk management, and broker compensation insights.

Integrated data from diverse sources (structured and unstructured), including financial and stock market feeds, raw stock market data, broker datasets, and public records.

Additional responsibilities included evaluating tools, coaching developers, interviewing candidates, troubleshooting technical issues, project management and setting team priorities.

tools: Informatica 7, Oracle 9i, Sybase, Linux, Java, Eclips/CVS, Erwin

10/2004 – 04/2005      CIBC Bank    Toronto, ON               Data Warehouse Consultant 

Defined standards and provided architectural guidance for the ETL development team. Designed the overall data flow, enhanced the data model, developed prototype Informatica mappings, conducted design and code reviews, supported code promotion, and mentored team members.

Integrated data from multiple sources, including the Wholesale Credit Data Warehouse, Special Debts Database, and Small Business Clients, to create a consolidated Data Mart for the bank's Impaired Loan Portfolio.

04/2004 – 10/2004      Bank of Montreal    Toronto, ON           Business Intelligence Consultant 

Participated in a large bank data warehouse project utilizing DB2, Ab Initio, SQL Server, Unix, and Mainframe, with a focus on implementing the Basel Accord and achieving Level 3 CMMI compliance.

Facilitated team meetings to address issues, promote integration, and ensure coordination across lines of business.

Managed a configuration management system, encompassing Change Management, Release Management, technical documentation, QA testing, and issue tracking.

05/2000 – 04/2004     TELUS Mobility    Toronto, ON                          Technical Lead 

Developed a multilayer Data Warehouse environment leveraging Oracle, Cognos Business Intelligence, and SAS.

Utilized Informatica, PL/SQL, and Unix scripting to design and implement robust ETL processes.

Established strategies for change data capture, error handling, and data integrity, utilized Erwin for relational and dimensional modeling. Developed Master Data Management and Metadata repository.

Managed daily operations of the Enterprise Data Warehouse to meet SLA and end-user expectations.

Collaborated with Infrastructure and DBA teams to ensure stability, security, and optimal performance of the data warehouse and reporting environment, focusing on capacity planning and tools evaluation.

Coordinated multiple projects, translating project plans into actionable tasks for team members.

04/1999 – 05/2000      Bayer Pharmaceutical   Toronto, ON             Data Warehouse Analyst 

Led database and ETL development for a Data Warehouse project integrating SAP, Oracle, Essbase (OLAP), and ActaWork (ETL), utilizing PL/SQL, UNIX scripts, and Erwin to design and manage data flows.

Developing multiple data marts (Cost Analysis, Sales&Distribution, Material Management), leveraging SAP source data to support targeted business insights and reporting.

Ensured data accuracy and consistency through data proofing, tracked data lineage, optimized performance, and defined comprehensive test cases to support data reliability.

Collaborated with stakeholders and SAP teams to analyze and document data requirements, conducting end-user interviews and assessing current business processes to ensure alignment with project goals.

11/1998 – 04/1999      Agora Food Merchant/Sobeys    Toronto, ON              Data Architect

As a member of Enterprise Architecture team (eight application architects and two data architects) designing enterprise application systems via an integration layer and core database, with a focus on implementing Oracle Master Data Management.

Collaborated extensively with cross-functional teams, ensuring clear communication and alignment across diverse roles. The project concluded following the acquisition of Agora by Sobeys.

05/1998 – 11/1998      HEPCOE Credit Union   Toronto, ON             Systems Business Analyst

Developed data models (conceptual and physical, data dictionary), and maintained the reporting database, with a strong focus on systems integration, data integrity, and minimizing redundancy.

Designed a detailed project plan for migrating data from Geac mainframe to SQL Server, ensuring minimal disruption.

Conducted business process modeling, data gathering, and analysis, and collaborated closely with developers and finance stakeholders to ensure alignment on project requirements.

Gained hands-on experience with financial products, including retirement planning (RRSP/RRIF), fund transfer/bill payments (TelPay), credit bureau services (Equifax), and credit card processing (MasterCard).

05/1997 – 05/1998      City of Brampton        Ontario, Canada           Data Conversion Specialist  

Served as a core team member on a project to acquire a new Payroll/HR information system. Responsible for gathering requirements and data conversion. Planned and executed the migration of HR data from the AS/400 system to the HP 9000, ensuring data integrity and seamless transition.

Completed the Bates Project Management course in Project Planning and Control and contributed to the development of the project charter, work breakdown structure (WBS), and overall implementation plan.

Bachelor of Computer Science

Computer Science Department