Profile

Extensive experience in Database/Data Warehouse analysis, design, development, implementation and administration (Teradata, DB2, Oracle, SQL Server, MySQL, Mongo)

worked across various domains like financial services, insurance, telecommunication, education, retail, shipping and marketing industries.

Strong ETL & stored procedures skills and a passion for maintainable, high performance code (Informatica, DataStage, Unix Shells, AWK, C).

Strong Business Intelligence Skills (BusinessObjects, Crystal Reports, MicroStrategy, Domo).

Excellent team player and communication skills and enjoy coaching and training others.

Adapt positively to changing business expectations and new challenges.

Technical Skills

Database Servers: DB2 LUW 10x/9x/8x, SQL Server 2008/2012/2014/2016, Teradata 14/13.10/13/12, Oracle 12c/11g/10g, MySQL 5.0 - 5.6, Sybase 5.7, Mongo 3.4 and MS Access.

Operating Systems: AIX, Linux, Windows 2003/2008/2012R2

Backup, Monitoring and Development: Oracle Enterprise Manager, DB2 Control Centre, Quest Central, Spotlight, TOAD, RMAN, Erwin, MKS, Teradata SQL Assistant.

Business Intelligence Tools: MicroStrategy, BusinessObjects XI, Crystal Reports.

ETL Tools: Informatica, DataStage V7.5/8, Ksh.

Marketing Tools: Unica

Languages: SQL, C, Ksh.

Professional Experience

Goldman Sachs (Infosys client) Jul. 2020 – Present

The leading global investment banking, securities and investment management firm that provides a wide range of financial services

Technical Lead

Market Data Services (MDS)

Work with Onshore/Offshore teams to coordinate, prioritize and track workload for MDS Processes

Gather requirements for tactical and strategic enhancements to the current MDS processes.

Coordinate with Onshore/Offshore teams of Database Admins, Operating system admins, ETL admins to deliver an uninterrupted MDS processes

Monitor, own and resolve alerts within SLA.

Document incident resolution steps and incident work around steps in MDS Confluence.

Manage the breaking points in current MDS processes.

Provide support for user tickets

Support and monitor current MDS processes to finish within SLA

Regulatory Operations

Work with Onshore/Offshore teams to coordinate, prioritize and track workload for Position Reporting and Transaction & Order Execution Reporting for regions: Americas, Asia and EMEA.

Gather requirements for tactical and strategic enhancements to the current reporting processes.

Coordinate with Onshore/Offshore teams of Database Admins, Operating system admins, ETL admins to deliver an uninterrupted flow of data and reports in compliance with Regulatory Rules & Regulations for Position Reporting and Transaction & Order Execution Reporting for regions: Americas, Asia and EMEA.

Work with Regulatory Relations team to deliver the data and reports in compliance with Regulatory Rules and Regulations for Position Reporting and Transaction & Order Execution Reporting for regions: Americas, Asia and EMEA.

Monitor, own and resolve incidents within SLA.

Document incident resolution steps and incident work around steps in Runbooks

Manage the breaking points in current processes.

Provide support for manual tickets

Support current processes of Position Reporting and Transaction & Order Execution Reporting for regions: Americas, Asia and EMEA.

Deliver top quality data and reports within the set timeframe to comply with Regulatory Rules and Regulations for Position Reporting and Transaction & Order Execution Reporting for regions: Americas, Asia and EMEA.

Margin & Valuation

Work with Onshore/Offshore teams to coordinate, prioritize and track workload for Margin & Valuation Processes

Gather requirements for tactical and strategic enhancements to the current Margin & Valuation processes.

Coordinate with Onshore/Offshore teams of Database Admins, Operating system admins, ETL admins to deliver an uninterrupted Margin & Valuation processes

Monitor, own and resolve alerts within SLA.

Document incident resolution steps and incident work around steps in Margin & Valuation Runbooks.

Manage the breaking points in current Margin & Valuation processes.

Provide support for user tickets

Support and monitor current Margin & Valuation processes to finish within SLA

Applications:

Margin

Valuation

Regulatory Operation

Market Data Services (MDS)

Environment: DB2, Sybase, SQL Server, Oracle, PostgreSQL, Linux, Autosys, Linux, Confluence, Keystone

Apple (Infosys client) Jan. 2020 – Jun. 2020

The global technology leader that design, develop, and sell consumer electronics, computer software, and online service.

Technical Lead

Application support of Campaign Management System (Teradata, OL7.7, Zsh)

Application support of Unica (Oracle, Unica)

Created and resolved incident tickets using Espresso and problem tickets using Radar

Monitored and resolved end to end Campaign ETL processes and alerts.

Applications:

Campaign Management System (CMS)

Environment: Teradata, Oracle, Unica, Linux, Autosys, Radar, Espresso

intel (Infosys client) Nov. 2018 – Dec. 2019

The global leader in semiconductor chip manufacturing and the inventor of the x86 series of microprocessors.

Technical Lead

Support of NGRP BRD (Next Generation Revenue Planning- Business Reference Data) Processes (Teradata, MSSQL)

Support of Demand & Forecast Processes (Teradata, MSSQL)

Support of Finance processes (Teradata, MSSQL)

Documented alert resolution steps in Confluence Runbooks.

Applications:

Demand & Forecast

NGRP-BRD

Finance

Environment: Teradata, MSSQL, Autosys, Linux, Confluence, Jira

Apple (Infosys client) May. 2018 – Oct. 2018

The global technology leader that design, develop, and sell consumer electronics, computer software, and online service.

Technical Lead

Application support of AppleCare processes (Oracle, Unica, Teradata, OL, Bash)

Created and resolved incident tickets using Jira

Monitored and resolved end to end AppleCare ETL processes and alerts.

Applications:

AppleCare

Environment: Oracle, Unica, Teradata, Linux, Autosys, Espresso, Radar

DDB Dec. 2016 – May. 2017

One of the leading creative advertising and marketing agency in the world and won many award in highly ranked adverting festivals and business magazines.

Database Admin/Developer

Gathered business requirements for CRM Database of the new account of a multinational conglomerate

Designed SQL Server CRM for a newly acquired account of a multinational conglomerate (SQL Server)

Implemented The SQL Server CRM of the multinational conglomerate (SQL Server).

Automated Feed files loading to CRM.

Created a communication campaign for the newly acquired account of a multinational conglomerate (SQL Server, Adobe)

Applications:

Customers

Batch Campaign

Triggered Emails

Household Identifiers

Environment: SQL Server 2014/2016, Windows PowerShell, Jira.

Lotlinx May 2015 – Dec. 2016

A digital marketing firm based in Chicago that enables consumers to go directly from ads to dealers website inventory pages using their deeplink technology.

Database Admin/Developer

Documented MySQL and Mongo databases to facilitate migration and new applications.

Migrated MySQL and Mongo data to IBM DashDB (DB2 cloud data warehouse).

Support MySQL and Mongo databases daily operations.

Participated in scrum process like Sprint planning, backlog discussion, user stories allocation for sprints (Jira).

Provided code review comments for sprint items developed by team members.

Created and applied databases backup and restore plans and schedules.

Created and supported new marketing campaigns related application tables.

Support Domo (fully managed cloud business intelligence) queries and scheduled jobs.

Support daily, weekly and monthly reports queries and schedules.

Applications:

CHUG2 (vendor and crawl data)

VVO (campaigns)

VDN (dealers requests)

TRACKING (crawl tracking)

Environment: IBM DashDB (DB2), MySQL 5.6, Mongo 3.4, Linux (Ubuntu), Bash Shell, AWK, Java, Jira.

Loblaws Inc May 2011 – Apr. 2015

Canada largest Food Retailer and wholesaler, also provides personal banking and insurance products

Team Lead - Senior Specialist

Supported Enterprise Data Warehouse (EDW) applications, ETL processes and reports (DB2 LUW, Oracle, SQL Server, Teradata, Sybase, MySQL 5.0, AIX, Linux, Windows 2008, MS Access, Korn Shell, Awk, BODS4, BusinessObjects, Microstrategy, Autosys).

Engaged with Business Units to enhance current and develop new business rules, processes and reports.

Developed and modified scripts to accommodate business processes (DB2 LUW, Oracle, Teradata, Bteq, Fexp, Mload, Tpump, SQL Server, Sybase, Korn Shell, Awk, BODS4).

Developed and modified business reports to accommodate new and changed business requirements (DB2 LUW, Oracle, Teradata, Microstrategy, BusinessObjects).

Performed gap analysis to identify missing parts in current state to accommodate business requirements.

Documented end-to-end applications data loading processes (DB2 LUW, Oracle, SQL Server, Teradata, Bteq, Fexp, Mload, Tpump, MySQL 5.0, AIX, Linux, Korn Shell, Awk, BODS4, Microstrategy, BusinessObjects, SharePoint).

Documented applications failures work around to minimize business impact of failures (DB2 LUW, Oracle, SQL Server, Teradata, Bteq, Fexp, Mload, Tpump, MySQL, AIX, Linux, Korn Shell, Awk, BODS4, SharePoint).

Documented scripts functionality and dependency of all supported applications (DB2 LUW, Oracle, SQL Server, Teradata, Bteq, Fexp, Mload, Tpump, MySQL, AIX, Linux, Korn Shell, Awk, BODS4, SharePoint).

Created RKM (Remedy Knowledge Management) IT knowledge articles for Service Desk (BMC Remedy IT Service Management Suite).

Supervised EDW offshore support team daily activities and provided Second Level Support for EDW.

Reviewed code and database design to insure compliance with established code and application standards.

Reviewed and approved application changes delivered by development team based on supportability and business requirements.

Applications:

STAS (Store Time & Attendance System application)

Precima (Customer analytics and marketing application)

Daily and weekly stores data loading application

Oracle to Teradata daily and weekly data loading

IPFR (Integrated Planning, Forecasting & Replenish application)

Intactix (Space & Category management and Planograms application)

Loyalty (Loblaw customer loyalty - points and offers – program application)

SAP to Teradata periodical data loading (hourly, twice daily, daily, weekly)

Environment: DB2 LUW, Oracle, SQL Server, Sybase, Teradata, Bteq, Fexp, Mload, Tpump, MySQL 5.0, AIX, Linux, Korn Shell, Awk, BODS4, BusinessObjects, Microstrategy, ITIL.

Royal Bank of Canada Mar. 2005 – Apr. 2011

Canada largest bank provide personal & commercial banking, wealth management, insurance, corporate & investment banking and transaction processing services on a global basis.

Senior Technical Systems Analyst

Administered, monitored and tuned Event Detection applications databases (AML, CAMPS, FACTS, Syfact) (DB2 LUW, DB2 for Z/OS, DB2 Connect 9, Oracle, SQL Server, Korn Shell, AIX, Solaris, Windows 2008).

Installed, configured, upgraded, applied updates and supported remote Event Detection databases (Geneva, Cayman Islands, Barbados, Bahamas, Singapore, Channel Island) (DB2 LUW 8x/9x, SQL Server 2000/2005/2008, Linux, Windows).

Participated in database development and QA (Quality Assurance) activities of Event Detection databases (DB2 LUW 8x/9x, Oracle, SQL Server, Korn Shell, AIX, Tivoli Storage Manager (TSM), SharePoint).

Developed and supported stored procedures for Event Detection databases (DB2 LUW 8x/9x, SQL Server, Oracle, PL/SQL, C, AIX, Windows).

Developed and supported DataStage jobs and scripts for financial data ETL from data sources to EDW and from EDW to Event Detection databases (DB2 LUW 8x/9x, DB2 for Z/OS, DB2 Connect 9, Teradata, Bteq, Fexp, Mload, Tpump, SQL Assistant, C, Korn shell, AIX, Windows).

Engaged with Business Units to enhance current and develop new business rules, processes and reports.

Administered and supported ETL processes using SQL SSIS (SQL Server Integration Services) from AML & CAMPS databases to SYFACT database (DB2 LUW 8x/9x, SQL Server 2005/2008, SSIS, AIX, Windows).

Administered and supported report generation from SYFACT (SQL SSRS - SQL Server Reporting Services) to Excel. (SQL Server 2005/2008, SSRS, Windows).

Supported AML Business Intelligence tools and reports (Oracle, BusinessObjects XI, Crystal Reports, AIX, Windows).

Documented failure work around to minimize business impact (DB2 LUW 8x/9x, Teradata, Oracle, SQL Server, C, Korn shell, AIX, Solaris, Z/OS, Windows, SharePoint).

Analyzed and assessed impacts of databases upgrades and development projects on current processes.

Developed, administered and supported processes of Financial Intelligence Unit (FIU) databases (Linux, MySQL).

Re-designed FIU group MS Access databases to a web applications using Visual Basic and SQL Server and automated manual processes and reports and developed Audit Review Process to proactively identify and address audit potential pain points (Visual Basic, SQL Server, Windows, Ruby on Rails, MySQL).

Supervised tasks assigned to offshore team.

Event Detection Applications

AML (Anti-Money Laundering)

FACTS and Syfact (Transaction Profiling)

CAMPS (Anti-Money Laundering Compliance System)

Environment: DB2 LUW (8.2/9.5), DB2 for Z/OS, DB2 Connect 9, Oracle (9i/10g), SQL Server (2000/2005/2008), Teradata, MS Access, BusinessObjects XI, Crystal Reports, AIX 5, Korn Shell, SQL, PL/SQL, C, JCL, Visual Basic, Windows 2003, SDLC, ITIL MySQL, Ruby on Rails, agile.

Ciber 2004 – 2005

IT services consulting and an E-business end-to-end solutions provider.

Database Administrator

Analyzed and assessed impacts of databases development projects on current processes of Vantage Point - Fedex Call Centers scheduling, forecasting, and planning application (DB2, Oracle 9.2.0.6, Windows2003).

Environment: DB2, Oracle 9i, AIX, MVS, Windows 2000, Quest Central, Spotlight, TOAD, Oracle Enterprise Manager, SQL.

University of Sharjah 2002 – 2004

Sharjah Emirate higher education institution in United Arab Emirates

Database Administrator

Administered, monitored and tuned University databases (Oracle 8, 9).

Developed and implemented the databases Disaster Recovery plans.

Gathered requirements and developed the logical & physical data model for the new SIS, HR, and FIN databases.

Planned and implemented databases upgrade from Oracle 7.3.4 to Oracle 8i and from Oracle 8.1.7 to Oracle 9i

University Databases

SIS (Student Information System)

HR (Human Resources)

LIB (Library)

FIN (Finance & Payroll)

Environment: Oracle 7x/8x/9i, Windows 2000, Erwin.

Zurich Canada 1999 – 2002

Insurance services provider with a global network of subsidiaries and offices.

Database Administrator

Planned and implemented the databases migration from DB2 5x to 6x then to 7x (DB2 LUW, AIX).

Developed triggers and stored procedures for Data Warehouse databases (DB2 LUW, AIX, C).

Administered, Monitored and tuned Data Warehouse (DB2 LUW, Oracle, SQL Server, Sybase).

Designed and implemented automated Data (ETL) schedules & processes (DB2, AIX, Korn shell, MVS, Cobol, JCL, DB2 Connect).

Designed and implemented the data feed to Oracle, SQL Server and Sybase databases (Oracle, SQL Server, Sybase).

Built BusinessObjects Universes to support reporting and ad-hoc queries (DB2, Oracle, SQL Server, Sybase, BusinessObjects, DB2 Connect).

Created & supported various reports using Crystal Reports and supported Cognos reports. (Oracle, SQL Server, Sybase, Crystal Reports, Cognos)

Environment: DB2 5x/6x/7x, Oracle, SQL Server, Sybase, AIX, MVS, JCL, Cobol, Korn Shell, Informatica, Prism, BusinessObjects, Crystal Reports, Cognos, DB2 Connect, SQL, C, Erwin

AT&T Canada 1998 – 1999

The Canadian subsidiary (renamed to Allstream) of AT&T, the largest US telecommunication provider

Database & Business Intelligence Administrator

Worked with Database Architect team to create and modify databases to meet user requirements (Oracle, Teradata, Sybase).

Designed and implemented automated ETL processes (Cobol, MVS, JCL, Korn Shell).

Monitored and tuned Teradata database performance (Teradata).

Administrated and supported BI/Query models and queries to meet users requirements (BI/Query, SQL).

Environment: Oracle, Teradata, Sybase, BI/Query, SQL, UNIX SystemV Release 4, MVS, Cobol, JCL.

Professional Development

* Teradata Database physical design (NCR).

* Project Management (Applied Tools and Techniques)

* Teradata Database Administration (NCR).

* High Performance Project Teams Workshop.

* DB2 Universal Database Advanced Administration for experts

* Warehouse Executive 2.0 COBOL

* DB2 Universal Database Advanced Administration Workshop

* Warehouse Directory 3.5

* DB2 Universal Database Performance Tuning and Monitoring

* General Insurance Essentials, Part 1

The Insurance Institute of Canada

* DB2 Universal Database Administration for UNIX (IBM)

* General Insurance Essentials, Part 2

* AIX Version 4 Basics Plus (IBM).

* Introduction to Personal Lines course

Education

B.Sc. Mechanical Engineering, 1992.

Contact this candidate