Candidate Information Title Technical lead, TSA, database admin/analyst Target Location US-WA-Seattle	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

ProfileExtensive 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 SkillsDatabase 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/2012R2Backup, 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: UnicaLanguages: SQL, C, Ksh.Professional ExperienceGoldman Sachs (Infosys client) Jul. 2020  PresentThe leading global investment banking, securities and investment management firm that provides a wide range of financial servicesTechnical LeadMarket Data Services (MDS)Work with Onshore/Offshore teams to coordinate, prioritize and track workload for MDS ProcessesGather 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 processesMonitor, 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 ticketsSupport and monitor current MDS processes to finish within SLARegulatory OperationsWork 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 RunbooksManage the breaking points in current processes.Provide support for manual ticketsSupport 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 & ValuationWork with Onshore/Offshore teams to coordinate, prioritize and track workload for Margin & Valuation ProcessesGather 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 processesMonitor, 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 ticketsSupport and monitor current Margin & Valuation processes to finish within SLAApplications:MarginValuationRegulatory OperationMarket Data Services (MDS)Environment: DB2, Sybase, SQL Server, Oracle, PostgreSQL, Linux, Autosys, Linux, Confluence, KeystoneApple (Infosys client) Jan. 2020  Jun. 2020The global technology leader that design, develop, and sell consumer electronics, computer software, and online service.Technical LeadApplication 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 RadarMonitored and resolved end to end Campaign ETL processes and alerts.Applications:Campaign Management System (CMS)Environment: Teradata, Oracle, Unica, Linux, Autosys, Radar, Espressointel (Infosys client) Nov. 2018  Dec. 2019The global leader in semiconductor chip manufacturing and the inventor of the x86 series of microprocessors.Technical LeadSupport 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 & ForecastNGRP-BRDFinanceEnvironment: Teradata, MSSQL, Autosys, Linux, Confluence, JiraApple (Infosys client) May. 2018  Oct. 2018The global technology leader that design, develop, and sell consumer electronics, computer software, and online service.Technical LeadApplication support of AppleCare processes (Oracle, Unica, Teradata, OL, Bash)Created and resolved incident tickets using JiraMonitored and resolved end to end AppleCare ETL processes and alerts.Applications:AppleCareEnvironment: Oracle, Unica, Teradata, Linux, Autosys, Espresso, RadarDDB Dec. 2016  May. 2017One 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/DeveloperGathered business requirements for CRM Database of the new account of a multinational conglomerateDesigned 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:CustomersBatch CampaignTriggered EmailsHousehold IdentifiersEnvironment: SQL Server 2014/2016, Windows PowerShell, Jira.Lotlinx May 2015  Dec. 2016A 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/DeveloperDocumented 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. 2015Canada largest Food Retailer and wholesaler, also provides personal banking and insurance productsTeam Lead - Senior SpecialistSupported 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 applicationOracle to Teradata daily and weekly data loadingIPFR (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. 2011Canada largest bank provide personal & commercial banking, wealth management, insurance, corporate & investment banking and transaction processing services on a global basis.Senior Technical Systems AnalystAdministered, 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 ApplicationsAML (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  2005IT services consulting and an E-business end-to-end solutions provider.Database AdministratorAnalyzed 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  2004Sharjah Emirate higher education institution in United Arab EmiratesDatabase AdministratorAdministered, 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 9iUniversity DatabasesSIS (Student Information System)HR (Human Resources)LIB (Library)FIN (Finance & Payroll)Environment: Oracle 7x/8x/9i, Windows 2000, Erwin.Zurich Canada 1999  2002Insurance services provider with a global network of subsidiaries and offices.Database AdministratorPlanned 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, ErwinAT&T Canada 1998  1999The Canadian subsidiary (renamed to Allstream) of AT&T, the largest US telecommunication providerDatabase & Business Intelligence AdministratorWorked 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 1The 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 courseEducationB.Sc. Mechanical Engineering, 1992.