Sql Server, T-SQL
Resume:
Work Experience
Associate Software Database Engineer
*****.*****@*****.***
https://www.linkedin.com/in/clint-aniceto-cabbo
Bacoor City, Cavite, 4102, Philippines
Over 20 years developing and optimizing complex MS SQL T-SQL object scripts. Experienced in an agile mythologies and ceremonies, 5 years hands-on experience in handling tech people and creating project documentations. Goal-oriented individual with leadership abilities and Project Management skills. Clint Aniceto A. Cabbo
Associate Software Database Engineer
Willis Towers Watson Global Business Services Inc. 23/F W City Center. 30 th Street corner 7 th Avenue, Bonifacio Global City, Taguig City, M. Ala
-
At WTW, we provide data-driven, insight-led solutions in the areas of people, risk and capital that make your organization more resilient, motivate your workforce, and maximize performance. Optimization of slow performing MS SQL Stored Procedures from existing EMBARK application. Check-in and deploy Database objects via AzDo and Git Hub source code repository, creation of PRs and monitor CI/CD deployment.
Implemented new data ingestion of EMBARK Telemetry to EMBARK Analytics via Azure Data Factory and DataBricks Provided knowledge transfer session to Software Engioneers for the MS SQL best practice and techniques in coding T-SQL scripts.
Technologies Used: MS SQL Server 2019 - T-SQL; Visual Studio 2022; GitHub, RedGate SQL Change Automation, DataBricks; MS Azure, Azure Data Flow; JIRA; Confluence Jan 2023
Present
Senior Supervisor
Bigcat Software Solutions Inc. 18/F PBCOM Tower, 6795 Ayala Avenue corner V.A. Rufino St., Salcedo Village, Makati City
-
Is a government registered enterprise which provides technical and customer support services such as information technology services to our foreign and offshore clients who are primarily engaged in interactive gaming. Write T-SQL script using MS SQL Server 2019 and Visual Studio 2019 tools to perform Schema and Data Comparison for database development requirements.
Commit SourceCodes or T-SQL Scripts or DB Objects to Git hub for Source Code Versioning. Design and create table schema for the Agile Development Cycle for every sprit development. Perform Agile Ceremonies as part of the Sprint or Agile Development Cycle. Attend and perform Database Development on Data Models provided by FE developers. Prepare Database Deployment package per Sprint Cycle from Lower Environments to QA/Test Env, Support the deployment to UAT/Pre-Prod Environment Provide support on any issues encountered per deployed Environment. Technologies Used: MS SQL Server 2019 - T-SQL; MS Visual Studio 2019; Git Hub; MS Teams, MS OneNote; NotePad++ Sep 2021 Oct
2022
ETL Developer
77 Global Services Inc. Orient Square Building, Emerald Avenue, Ortigas Center Pasig City
-
A team of experts, coming together, presenting a Worldwide solution to your logistical dilemma. We offer reliability, transparency, quick and secure solution, while our seasoned specialist monitors your shipment for the beginning till the end. Write T-SQL script using DBeaver and/or HUE tools to extract data for Promos, Leads, and Reports based from Business or requestor requirements.
Mar 2021 Sep 2021
Design and create table schema for the Acquisition Promo Dashboard for existing and upcoming promos to be implemented on a BI Dashboard.
Creare adhoc reporting and data extract using T-SQL scripts. Technologies Used: Hue/Dbeaver/MDM/Informatica; MS SQL 2019 T-SQL Senior Database Developer
SynchronoSure, Inc 28/F The Enterprise Center, Tower 2, 6766 Ayala Avenue, Legaspi Village, San Lorenzo, Makati City
-
The company's platform uses artificial intelligence from underwriting information regarding a particular account for the world wide web, enabling clients to streamline the entire insurance process. Created and implemented the Database table schema and Stored Procedures for the data CRUD and report generation scripts.
Created Table schema and Stored Procedure to store converted file into Binary format field column SQL Utilized the Visual Studio 2017 to compare Database Schema from Brent's BAK file against the Created the Stored Procedure for the Installation Payment Report Created a Stored procedure in preparation for the Database Maintenance in creating Database Full Backup and Differential Backup files
Prepared the script including the DB Table and Stored Procedure the approach on the Dynamic Data Query by ordinary users and be able to perform query and return data from the Datawarehouse Created the Stored procedure to read JSON file formats and set data into PIVOT or into columnar data, ready for Data Uploading Created Stored Procedures, Functions to load data for the data dump and nightly job to the Datawarehouse from JSON files.
Technologies Used MS SQL Server 2016/2017; MS T-SQL; MS Visual Studio 2017 May 2020 Sep
2020
Application Developer - SQL/Scum Master
CITCO International Support Services Limited – Phil. ROHQ 15/F One Ayala Ave. Corporate Center, Tower 1 EDSA cor. Ayala Avenue Brgy. San Lorenzo Makati City
-
In 1948, we began serving private clients and multinationals. This business was the genesis of today‘s fund administration sector. We evolve to ensure that our people, our technology, and our bespoke solutions meet our clients needs and exceed their expectations.
Designing Data model design and TSQL
Modify or update and deploy SSIS Package on new business requirements to be migrate to AWS cloud Modify or update and deploy SQL Stored Procedures related to the reports to be migrated to AWS cloud to connect to Oracle and Postgres Databases.
Support Post Prod issues from ACR clients or business users Facilitate Scum team using Agile methodology performing daily scrum call meeting. Mitigation of team impediments. Logging product backlogs and sprint tasks via Jira.
Performed Sprint Review or demo presentation to Business users with sprint releases. Facilitate WebEx meeting with technical and business resources for Project coordination and confirmations. Technologies Used: • MS SQL Server 2016; Oracle SQL Developer; AWS; Postgres SQL; MS Visual Studio 2012 MS SQL Server 2016; Oracle SQL Developer; AWS Postgres SQL; MS Visual Studio 2012 Apr 2018
Apr 2020
Team Lead/Associate Manager
ACCENTURE, Inc 19/F Uptown Tower 3, 11th Avenue, Bonifacio Global City, Manila
-
Is a global management consulting, technology services and outsourcing company. Committed to delivering innovation, Accenture collaborates with its clients to help them become high-performance businesses and governments. Conducted code reviews to ensure that the code satisfies the design specifications and complies with company standards, translated business concepts to technical design.
Supervised work of team members, allocating tasks to effectively leverage available skills and resources, give performance feedback, and create status reports.
Sep 2011 Oct 2017
Awards
Certificates
Coordinated directly with the client as well as on-shore business analyst, concerning execution and implementation/roll out of enhancements.
Performed analysis, code modification and database design as required meeting the change requests from the end users. Delivered system documentation such as Technical Design Document, Project Work Plan, and Project Generated estimate for project enhancement proposals and change request made by the client. Participated in the user requirement gathering and consulting with the project stakeholders Supported the deployment of the system to the production servers. Acted as the Project Manager for the team on 6 major deployment releases to the client from Awardee for the contribution to the QA Team to maximize their test scripts. Awarded as the Maharlika - The Ultimate Leader for the Financial Services for FY 2013. Technologies Used: • SQL Server 2008; MS Transact-SQL Script; MS Access; SSIS Packages; Tortoise SVN; VB Script Senior Database Developer
SGS Gulf Ltd. - ROHQ 3/F Alegria Bldg., 2229 Chino Roces Avenue, 1231, Makati City
-
We are the world's leading testing, inspection and certification company. Participated actively in the analysis and detailed design of the solution's technical requirements. Coordinated directly with the delivery team, based on Geneva, Switzerland as well as other on - shore/global business analyst, concerning execution and implementation of the system. Facilitated review discussions on technical issue resolution's, including System Test, UAT and Provided on-site technical assistance and support during UAT and Production. Executed onsite system testing, defect logging, fixes monitoring and verification. Deployed and configured the application on System Test, Unit Test and Production environments. Conducted knowledge transfer and training sessions to the production/operations team. Acted as the first line of defense for SQL Database related issues for systems support on UAT and Worked on mentoring junior member of the team in processes within the team and in working with SQL Server database solution's.
Worked on support for the application, especially for Database related issues. Technologies Used: MS SQL Server 2000; MS Transact-SQL; MS Visual Studio Team Suite Edition; MS Visual SourceSafe SourceSafe
Oct 2007 Sep 2011
Core Skills
DataBricks / Azure Data Factory, T-SQL, Microsoft SQL Server 2019, Microsoft SQL Server Integration Services, Scrum Master, Azure, DataDog, Azure Data Flow, Git Hub, Jira and Confluence, AzDo Education
Philippine Christian University
Bachelor of Science Computer Science
Mar 1995
Awarded as MVP for the 2nd quarter of FY2013
Accenture, Inc.
Jun 2013
Maharlika - The Ultimate Leader
Accenture, Inc - Financial Services
Dec 2013
Certified AWS Developer - Associate
AWS
Aug 2018
Certified Microsoft Professional for 70-433: Microsoft SQL Server 2008, Database Development Microsoft
Jun 2001
Contact this candidate