Clint Aniceto A. Cabbo

Contact Information

Email Address: adfi7c@r.postjobfree.com

Mobile No: +63-916-******* (Globe) / +63-998-***-**** (Smart)

Land Line: +63-46-484****

Career Level: Senior Database Developer

Summary

Graduate of Bachelor of Science in Computer Science.

Certified AWS Developer - Associate – Aug 2018

Certified Microsoft Professional for 70-433: Microsoft SQL Server 2008, Database Development

Certified Scrum Trainer.

Certified Agile Professional. 2-years’ experience with Agile SDLC Approach using Scrum

Methodology using IBM’s Rational Team Concert (RTC) tool.

With over 10-years involvement in Software Development Life Cycle (SDLC), system analysis,

requirement definition, system design, database design, implementation, integration and testing,

software development and customization and maintenance as Senior Software Developer / Senior

Database Developer.

Over 3 years of hands-on experience with SQL Server Integration Services, SQL Server

Management Studio, and SQL Server Reporting Services. Create or modify Data Integration (dtsx)

files using Microsoft Visual Studio.

With 4 years of experience in designing and writing applications using MS Access in VB language.

3 years as a Software Development - Team Lead role for Application Development (AD) or Change-the-Bank (CTB) Team.

Over 15 years in developing complex MS SQL Transact SQL Stored Procedures, Functions, Triggers, Views and other Database Object scripts.

Installation of Microsoft SQL Server Reporting Services. Create, modify, and deploy ad hoc report.

Create or modify database model for the new or existing database schema or structure.

Goal-oriented individual with leadership abilities and Project Management skills.

Technical Skills

Skill

Proficiency

Experience Age

Year Last Used

(Indicate unit if less than a year)

Amazon Web Services

P1 – Novice

2 Years

2020

Microsoft SQL Server Integration Services

P2 - Proficient

3 Years

2019

Scrum Master

P2 - Proficient

2 Year

2019

T-SQL

P3 - Advanced

15 Years

2019

IBM Rational Team Concert

P2 - Proficient

2 Years

2017

Microsoft SQL Server

P3 - Advanced

15 Years

2015

Visual Basic for Applications (VBA)

P3 - Advanced

5 Years

2015

Work Experience

SynchronoSure Services Inc.

Proprietary technology allows us to quote most risks in a matter of minutes rather than days. We underwrite by blending the state- of-the-art use of data and information, artificial intelligence, and capable, experienced underwriters.

Company: SynchronoSure, Inc

Project Name: IRPM Worksheet / Cancellation and Payment Installation Reports / Data Load to data Warehouse

Role: Senior Database Developer

Duration: May 2020 - Present

Role and Responsibilities

Trainings:

Business Insurance Concepts

Commercial Property Coverage

Commercial General Liability Coverage

Projects:

OFAC XML Data upload (15 May)

Created a template script to read an XML data formatted file to be available for uploading to Datawarehouse

SQL Mail (21 May)

Prepared the SQL script to configure the SQL Mail in preparation for the Service Notifications when activity is completed within the SQL Server Database

IRPM Worksheet Template (6 June)

Prepared/provided the workflow (MS Visio format) used by Marketing Team as a Web page template.

Created and implemented the Database table schema and Stored Procedures for the data CRUD and report generation scripts.

Datawarehouse Layout (8 Jun)

Initially created the scripts to implement the Development Datawarehouse Schema structure based from the Excel Data Warehouse from the Data Architect

File Import and Export (23 Jul)

Created Table schema and Stored Procedure to store converted file into Binary format field column

SQL Database Schema Comparison (23 Jun)

Utilized the Visual Studio 2017 to compare Database Schema from Brent's .BAK file against the Team's Database Schema.

To better understand the Schemas created and difference based from team's understanding from the Excel Data Warehouse from the Data Architect

AWS EC2 SQL Server 2016 downgrade from SQL Server 2017 (26 Jun)

Initiated the conversion of SQL Database from version 2017 to version 2016 due to conflict when Restoring the .BAK file coming from SQL Server 2017 version.

Performed the testing and confirmation on the MS SQL Server 2016 version in the EC2 DB Server instance

Cancellation Report (9 Jul)

Completed the script for the Database Table and the Stored Procedure script for the Report

Installation Payment (9 Jul)

Created the Data layout template for the Payment and Payment Detail tables

Created the Stored Procedure for the Installation Payment Report

SQL DB Backup Maintenance (9 Jul)

Created a Stored procedure in preparation for the Database Maintenance in creating Database Full Backup and Differential Backup files

Dynamic Data Query (28 Jul)

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

Agent/Agency Portal Registration (30 Jul)

Completed and created the Agent and Agency DB tables to hold the information of the Agency and Agents per Agency Portal data.

Nightly Batch Job (3 Aug)

Created the Stored procedure to read JSON file formats and set data into PIVOT or into columnar data, ready for Data Uploading to appropriate Database tables

Created Main (1) Stored Procedure, (9) individual Stored Procedures to load data, 1 Scalar Function to complete the process of 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

CITCO International Support Services Limited – Phil. ROHQ

As a highly-respected name in the industry, the Citco Group of Companies is known as both a high-quality service provider and forward-thinking partner. The founding family still runs Citco and continues to provide a broad range of financial services to our clients worldwide. True to our founding principles, we tailor

solutions to clients’ exact needs, continually investing in our network to deliver the highest-quality solutions.

Company: Citco

Project Name: Aexeo Crystal Reporter (ACR) and Xceptor – Project Migrations to Amazon Web Services (AWS)

Role: Application Developer – SQL / Scum Master

Duration: Apr 2018 – Apr 2020

Role and Responsibilities

ACR Project

Strong analytical and technical skills to carry out detailed technical work (development and support)

Skills in 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

Xceptor Project

Facilitate Scum team using Agile methodology performing daily scrum call meeting. Mitigation of team impediments. Logging product backlogs and sprint tasks via Jira.

Sprint Review or demo presentation to Business users with sprint releases.

Facilitate WebEx meeting with technical and business resources for Project coordination and confirmations.

Review development team’s AWS CloudFormation scripts.

Technologies Used:

MS SQL Server 2016

Oracle SQL Developer

AWS

Postgres SQL

MS Visual Studio 2012

ACCENTURE, Inc.

Accenture 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. With deep industry and business process expertise, broad global resources and a proven track record, Accenture can mobilize the right people, skills, and technologies to help clients improve their performance.

Company: Accenture, Inc.

Project Name: Norton Rose Fulbright (NRF)

Role: SQL Server Database Application Lead

Duration: Aug 2017 – Oct 2017 (3 month)

Role and Responsibilities

Prepare knowledge Transfer (KT) documentations in MS SQL Server Database maintenance for the transition from third party to Accenture team.

Prepare MS SQL Server Database Monitoring Tools including Management Studio, Profiler, DB Engine Tuning Advisor, System Admin/Computer Management tools.

Technologies Used

MS SQL Server 2014

Company: Accenture, Inc.

Project Name: Avanade – Bench

Role: Associate Manager

Duration: Jul 2017 (2 weeks)

Role and Responsibilities

Actively gain training and knowledge enhancements using Robotics Process Automation (RPA) using Blu Prism tool.

Technologies Used

Blu Prism/MS SQL Server 2014

Company: Accenture, Inc.

Project Name: Google Analytics – DDN – ETO

Role: Project Manager

Duration: May 2017 – Jul 2017 (3 months)

Role and Responsibilities

Manage team members to perform required development task and guidance to meeting deadline.

Manage team capacity and development work distribution to properly manage deliverables.

Experienced in handling and guiding Team members.

Must have advanced Microsoft SQL Transact-SQL scripting skills.

Software Development Life Cycle (SDLC) until implementation and support.

Can communicate well with clients on requirements to be interpreted into technical aspect to be delivered.

Must have experience with Analytics and/or reporting tools to create Dashboards or Ad Hoc reports.

Provides user requirements/stories

Overall management of the project

Technologies Used

Google Plx

Company: Accenture, Inc.

Project Name: MICHAELS Holding LLC

Role: Associate Manager

Duration: March 2017 – May 2017 (3 months)

Team Size: 5

Role and Responsibilities

Provided Agile Training to team members to orient and provide knowledge or terminologies of Agile and Scrum development life cycle.

Prepares Proof of Concept (POC) for Archive database from Store DB to Store DB as a new DB instance and flag CORP DB instances using Visual Studio BI solution.

Proposed to implement the Agile Tool - Rational Team Concert (RTC) with the team to create work items on User Stories, Acceptance Criteria, and other artifacts related to Agile.

Prepares SQL Reference documentation for Support team to utilize MS SQL T-SQL scripting and backend monitoring support.

Technologies Used

SQL Server 2007

Visual Studio 2012

Company: Accenture, Inc.

Project Name: Tech for Ops – GPH and OpsNav

Role: Scrum Master/Functional Architect

Duration: May 2015 – March 2017 (1 year and 10 months)

GPH (Global Productivity Hub) - is a lightweight, modular, system compliment tool enabling the business

to increase agent’s engagement, utilization and productivity. This is the Global standard tool for Accenture

Operations. It provides near real-time intraday dashboards and up to date reporting capabilities.

Team Size: varies per project

Role and Responsibilities

Understands specific business needs and overall business strategy of the business customer through the Outsourcing Account Team

Acts as the application(s) functional expert: provide functional expertise & drive the definition of the technology solution

Works collaboratively with the customer to develop Business Requirements

Provides detailed definition on how the applications will support business requirements

Conducts impact analyses of business requirements on the system

Gathers, interpret, analyze and document system requirements, and translate into design functional specifications

Produces business process designs, functional designs, and configuration designs, for standard processes and any client-specific needs

Develops business scenario test conditions and expected results based upon the application requirements

Supports Sales efforts as needed, providing functional expertise regarding our standard offerings and client requirements

Technologies Used

SQL Server 2008

RTC – Rational Team Concert

TFS – Team Foundation Server 2010

Company: Accenture, Inc.

Project Name: DBWIA – DKS

Role: Team Lead/Associate Manager

Duration: October 2011 – May 2015 (3 years and 7 month)

dbWIA (DB Workflow Interim Application) is a tactical P&L Workflow application currently being used by Global Market Equities for Global Equity Derivatives and Equity Proprietary Trading businesses across the globe to cleanse, analyze and report financials and attribution P&L to Middle and Front Office.

Team Size: 5

Role and Responsibilities

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.

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

Management Transition Document that provide detailed information on key implementation details.

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 September 2012 to October 2014.

Provided Root Cause Analysis (RCA) and Impact Analysis documentation for the resolution on any issues.

Non Project

Assigned as primary coordinator for the team's Information Security Management System (ISMS) implementation to 100% completion.

Facilitated representative for the Project’s representative on the 2014 External Audit of ISO27001:2005 – Information technology – Security techniques – Information Security Management

Systems for Accenture Philippines without any major audit findings.

Performed as career counselor to 3 senior software engineers, 1 software engineer, and 3 junior software engineer for their career development plan.

Awarded as MVP for the 2nd quarter of FY2013 and nominated for the overall Accenture Gantimpala

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.

With awards during the Financial Services FY 2014 - Year-Ender Ceremony.

Technologies Used

SQL Server 2008

MS Transact-SQL Script

MS Access

SSIS Packages

Tortoise SVN

VB Script

Company: SGS Gulf Ltd. – ROHQ

Project Name: Electronic Audit Package Management System – (ePAC) System

Role: Senior Database Developer

Duration: Oct 2007 – September 2011 (4 years 11 months)

ePAC System is an online web application that provides audit approval process covering auditor’s set of

questionnaires, evidence documentation, and stages of approval process. Application development tool utilized includes C#.Net, ADO.Net, Visual Studio Team Foundation, and SQL Server.

Team Size: 12

Role and Responsibilities

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 resolutions, including System Test, UAT and Production defect resolution.

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 Production.

Worked on mentoring junior member of the team in processes within the team and in working with SQL Server database solutions.

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

Education

•Philippine Christian University - Taft, Manila, Philippines - BS Computer Science (March 1995)

Contact this candidate