Armando Cabigting Email & Phone Number

Quakers Hill, Nsw, Au

Macquarie Park, Nsw 2113, Australia

Key Responsibilities:1. Provided automation solution for various reports and processes. Migrated Optus Business (OB) reports from legacy MS Excel and MS Access reporting into a segmented reporting platform in SQL database servers.2. Architect the reporting data warehouse for Optus Business Integrated Client Services (ICS). Designed and managed relational databases in SQL server for reporting need.3 .Implemented data mining / ETL processes to collect various data from different data sources and convert into meaningful data insights and reports.4. Designed and implemented key executive dashboards and operational reports in Tableau for the Optus Business in driving performance and governance improvements such as ICS Utilisation Dashboards, Timesheet Reports, Professional Services Performance Summary, Professional Services Scorecard / KPI Dashboard, Exception Dashboard, Resource Management Forecast Dashboard, Project Financials Dashboard, Consolidated Project Management Dashboard, annuity Run-Rate Dashboards.5. Developed over 100 of SSRS reports and Tableau dashboards in Professional Services space for Project Management, Internal Status, Finance Reports and Customer reporting.6. Optimised and automate various external customer reports which provide contractual reports.7. Author of ICS Central portal which provides centralised tools for OB Integrated Client Services. Developed various web applications and tools within the ICS Central such as: ICS Headcount Tracker, Online Project Change Requests (Online), Project Stage Gate tool, Project Audit tool, PS Scorecards, Exception Dashboard, Project Online License Allocation Tracker, ARK Knowledge Base (Online Reference Tool for Professional Service), Project Sizing Tool, etc.8. Developed various SharePoint forms, lists and Nintex workflows9. Mentored junior developers from our offshore team in Malaysia10. Participated in business requirements and convert it into functional and technical design specifications.

Manila, Philippines

Key Responsibilities:1. ETL Processes - Responsible in operational support, maintenance and development of enterprise wide ETLs processes that feed data warehouses using SQL Server Integrated Services (SSIS), Data Services of Business Objects (BOBJ) and custom ETL applications(.NET).2. Data Warehouse - Analyze, plan and implement business requirements for new data warehouse implementation. •Worked with database administrator with regards to database maintenance schedule, storage management, backup and recovery plan, and performance tuning such as indexing and partitioning.3. Reporting - Developed, implemented and maintained various Transact-SQL queries, stored procedures, functions and views for different Contact Centre requirements such as Call Volume reports, Sales and No Sale report, Operation Performance Indicator etc. Provided reporting solution using SQL Server Reporting Services and Crystal Report.4. .NET Development - Responsible in development and maintenance of custom web applications for data visualization, dimensional data administration in user interface, manual data upload using web tool.5. Data Analysis - Ensure the integrity of data within Transcom data warehouses.6. Management Tasks - Managed Data Management Services team consists of 7 .NET and BI developers. Attended meetings with the Business Support Team, Project Management and different stakeholders for business requirement gathering, project development status and User Acceptance Test. Converted business requirements into functional and technical design specification. Review and approve releases and deployment of the team before submitting it to Change Management team.Technical Skills:1. Database Servers - SQL Server 2000, 2005 & 2008, and Oracle 9i, 10g & 11g2. Business Intelligence Tools - SSIS, SSRS, SSAS, Bobj DS, Bobj WebI, Bobj Universe, Crystal Report3. Data Visualization ASP.NET C# and MVC, ASP Classic, VB6, VBA4. Source Code Management - TFS, SVN, SharePoint

Key Responsibilities1. Business Intelligence/Analytics - • Responsible in development and maintenance of SQL Server Reporting Services to provide efficient and trusted reporting data such Avaya/CMS data, Call volume stats, Disposition count, Agent performance and Product data, etc. to West clients. • Prepare and implement Report Definition Language (RDL), stored procedures and web application in the development environment or server and deploy these in the production server to be accessed by the client.Maintenance and support of DTS Packages and SQL Server Integrated packages that feed West Corporation SQL Servers. • Ensure the security and confidentiality of the data being transmitted to the clients such as credit card information, sales, bank account information, customer details by following the standard data feed process of the company.2. Front-end Developer• Responsible in developing and maintaining custom web applications for enterprise and operation use. • Automated several manual process in corporate and operation functions such as production reference tools, employee regularization notification, eLearking and online test.Technical Skills:1. Database Servers - SQL Server 2000/2005/20082. BI Tools - SSRS, SSIS, DTS, Advanced knowledge in MS Excel for data analysis3. Data Visualization - ASP.NET C#, ASP Classic, VB6, VBA4. Source Code Management - MS Share point