Gary Doroteo

IT Consultant

Taytay Rizal adgc27@r.postjobfree.com 917-***-**** www.linkedin.com/in/garydoroteo

Associate Project Manager Release Manager Team Lead Transition Lead

Methodical IT professional with 20+ years of experience in ITSM, Project management, full-cycle ETL management, data warehousing, and end-to-end delivery in diverse business sectors. Exceptional time management skills and interpersonal skills to collaborate with all levels of an organization. Seasoned technical acumen in ETL development and Service support.

Core Expertise:

Data Warehouse Design Service Level Agreement (SLA) User Interface Analysis & Design Project Scheduling

Service Management Technical Requirements Budget Management Client Negotiations

ETL Processes Software Development Policies Compliance Project Planning

PROJECT EXPERIENCE

Associace Manager L1/L2 Support William Sonoma WSI 11/2019 – 03/2020

Point of contact for any project related issue

Oversaw jobs by efficiently utilizing CDW, EDW, RDW, and Azure ETL jobs while assessing and implementing well-grounded innovations.

Initiated continuous process improvements and effectively coordinated solution implementation to various teams.

Analyzed of job updates and change requests and provisioned status reports to business performance.

Associate Manager ETL Developer SiriusXM Project SiriusXM 03/2018 – 11/2019

Using Agile Methodology

Developed technical design documentation and ETL process to ensure deployment from Dev to QA and production area.

Collaborated with multi-functional teams on daily tasks, capacity planning, and document management.

Carried out postproduction deployment and validation while participating in functional design creation.

Team Lead L2 Support and ETL Deployment Globe Project Globe Management Support 03/2017 – 02/2018

Handled Multiple position as Release Manager, Transition Lead, Team Lead for Data Integration process

Organized documentation of operation manuals, procedures, and other support documents and ensured SDA entries.

Captained the knowledge transfer team for the ETL process; utilized Talend, Hadoop, Windows, and UNIX platforms.

Governed deployment and execution of new ETL jobs in test plans and production environments.

Associate Manager L1 Support William Sonoma WSI 06/2015 – 03/2017

Point of Contact for any project related issue

Produced analysis of job updates and change requests and submitted status reports to business performance.

Supervised tasks by monitoring jobs in CDW, EDW, RDW, and MMS while evaluating and applying solutions innovation.

Overhauled process improvements and coordinated solution implementation to teams.

Associate Manager Data Modeler Mohegan Sun Halo, Avatar, ACSC 10/2014 – 02/2015

Point of Contact for any project related issue

Constructed databases that meet business needs by leveraging conceptual, logical, and physical data models.

Communicated technical ideas by utilizing interpersonal skills to collaborate with IT groups.

Leveraged in data modeling principles/methods to coordinate solutions on issues.

Trainer Teradata Tech Lead Program 02/2014 – 05/2014

Spearheaded 1062+ hours of web-based extensive training while carefully assisting in projects and strategic planning.

Carried out training initiatives of Informatica power center to technical lead participants.

Conceptualized training methodologies that adapted to each individual’s learning curve.

Team Lead ETL Developer WinCo Foods Winco Sales & Marketing Phase 1 11/2013 – 12/2013

Point of Contact for any project related issue

Composed SQL scripts, ETL development using Talend and improved overall performance.

Gathered reporting requirements to investigate, develop, and test Talend jobs and risk management.

Conducted test cases for phases of testing, integration, regression, and user data.

Associate Manager Offshore Overall Lead Loblaw Performance Tuning & Enhancement 05/2013 – 11/2013

Point of contact for the onshore team lead and project managers while leading coordination of deliverables.

Implemented project schedule plans according to established timelines and project metrics.

Identified business roadblocks and engineered long-term solutions.

Associate Manager Offshore Overall Lead Wind Mobile Telecommunication Data Warehousing Development 12/2011 – 04/2013

Point of Contact for any project related issue

Directed project schedule plans according to established timelines and project deliverables.

Officiated task allocation to offshore DI-ETL, DI-SIT, BI-ETL, BI-SIT, and Specs designer teams.

Determined challenge and business opportunities while developing logical results.

Senior Developer Pfizer Philippines Data Warehousing Development 03/2011 – 10/2011

Chaired as the subject matter expert for Informatica development and examined the core model process.

Created and configured mappings, sessions, and workflows while identifying GAPS from the CORE design.

Engineered technology roadmap to set the technical direction for the company.

Team Leader ACE Insurance Data Warehousing Development 04/2010 – 03/2011

Headed Informatica development while assessing specification requirements and provisioning estimates.

Carried out technical mappings, sessions, and workflows while delegating assigned deliverables.

Teamed-up with the onshore team to communicate strategic plans and implementation.

ETL Developer Wyeth Philippines Data Warehousing Development 11/2008 – 04/2010

Bolstered deployment of migration from development to production environment to support local ETL processes.

Captained interpersonal skills to converse with clients in gathering requirements or specifications.

Led development of the transformation logic that was used continuously Informatica mappings.

Senior Software Engineer Verizon CPE/International 04/2007 – 11/2008

Established the Siebel EIM process by utilizing Informatica/SSIS and analyzing business requirements.

Administered cost-effective technical design development while assisting with test phases.

Partnered with onshore/offshore counterparts to resolve underlying technical issues.

Software Engineer Optus Telecom Level 3 Support 03/2006 – 04/2007

Carried out Adhoc DTS processes while conducting known workarounds and possible interim and permanent fixes.

Generated reports through proficient usage of SQL queries on the backend for data analysis.

Defined production issues by employing root cause analysis and provisioned solutions technology integration.

Software Engineer Telecom Malaysia Siebel Development 01/2005 – 03/2006

Participated in knowledge transfer sessions and shadowed developers working on development configurations.

Performed assessment of existing configuration from release one and provisioned documentation to release two.

Assisted in concurrent software projects from design and prototyping through implementation and delivery.

CAREER EXPERIENCE

Associate Lead Tech Consultant Teradata Philippines 10/2011 – Present

Senior Consultant Info-Alchemy 11/2008 – 10/2011

Senior Software Engineer Accenture 09/2005 – 11/2008

Software Developer Health Vision Corporation 03/2001 – 09/2005

Junior Programmer Pacific Internet Development Group 03/2000 – 01/2001

Computer Instructor AMA Computer Learning Center 05/1998 – 03/2000

EDUCATION

Bachelor of Science (Computer Science), AMA Computer College 1998

TRAINING

Teradata PDI Teradata SQL Teradata Basic Access Layer Modeling Performance Optimization Through Workload Management Performance Optimization Through Physical Design Interest-Based Negotiation Leading Successful Teradata Presentation Skills Data Interrogation Introduction to Aster Hadoop Essentials Apache Hadoop 2.0 Talend Teradata Factory Informatica Factory ATS Siebel Core Developer & Technology Siebel Core Developer & Technology Siebel Technical Architecture Relational Principles SQL Programming ATS Peer MLA Delivery Centre Methods ATS Software Configuration Management ATS Metrics Overview ATS Defect Prevention ATS Continuous Improvement Participating In Project Teams Making Your Time Count Taking Control Of Your Workday Business Etiquette and Professionalism Effective Business Meetings Effective Listing Skills Effective Use Of Feedback For Business

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Linux

Development tools: Teradata, Informatica, Talend, Microsoft Azure, Data Stage, DTS, SSIS, Ab-Initio, Unix, Hadoop Big Data, Data Mover, Siebel CRM

Methodologies: Waterfall, Agile

RDBMS: Oracle, DB2, MS SQL Server, Teradata

Tools & Utilities: Autosys, Control-M, TOAD, UC4, Putty, TD SQL Assistant

Languages/Technologies/Platforms: Visual Basic, Siebel CRM, ColdFusion, ASP, PHP, Visual FoxPro

Contact this candidate