Database Analyst, Report Writer, Programmer, Engineer
I have more than 13 years experience programming in Visual Basic for Application using Excel and Access. I've also programmed using windows and unix scripting languages, HTML, ASP .NET, Vb Script, C# etc.
Career Summary and Skills
Experienced and expert in data warehousing, data mining, root cause analysis, process improvement, tool development, report automation and problem solving.
13 years programming experience using Visual Basic for Application (VBA) both in MS Excel and MS Access.
13 years data and root cause analysis, report automation and development experience.
8 years SQL queries, stored procedure and user defined functions programming experience using MS SQL Server 2000/2005/2008/2012 and MS Access 2000/2003/2007/2010.
4 years ASP .NET 2 and C# .NET programming.
5 years Unix\Linux scripting and shell programming.
Knowledge and with some experience with SSRS, SSIS, SSAS, Big Data, Data Science, Hadoop, HDFS Architecture, MapReduce Architecture, VB6, VB .NET, VBScript, Auto IT, PHP, FTP, C++, Java, Windows and Unix shell scripting, PowerShell, Virtualization, and assembly language.
5 years team management and leadership experience.
Good communication and interpersonal skills, interdependent, self-starter, self-motivated, requires less supervision, fast learner, technical person, value integrity, self-learner, team player, can stay cool and focus under pressure, have a good problem solving and analytical skills, and can lead and manage a team.
Received a certificate of recognition for excellent performance and lasting contribution on Sept 10, 2012 from the Sykes Executive Vice President and CIO.
Developed database and automation for Backup Exec Tape Backup Media Rotation. It updates the database for the status of media and then automates the process of media selection for pull out and loading to a backup library and media for long term storage.
Developed Configuration Management (CMDB) report and update automation. – The automation extracts data from different application console files and database, analyses the data, compare data from the database, perform audits, generate and send reports to the CMDB team and keep the database up to date.
Transformed and developed Sykes Service Desk Incident and Helpdesk auto reports from basic and simple reports to a more advance and complicated reports. New metrics for each Sykes Clients and Centers have been developed like the Mean time to Repair and First Touch Success. Developed also new Director level dashboard reports for each of Sykes Centers.
Developed more than120 programs - alert systems, automation tools and reports using Visual Basic for Application and macros for Excel, Access and Outlook, MS SQL Server T-SQL queries, stored procedures, UDFs and VB scripts. Saved a lot of manager’s time in generating the reports they need. Makes the manager more effective in handling Service level agreement, in managing tickets and task and in manpower allocation.
Developed online query tool that helps the end user to generate ad hoc reports. Saves a lot of time requesting reports and gives more time for the report writer to focus on more important tasks. Developed also online real-time monitoring tool. This helps Global Service Associates to commit fewer errors and monitor their productivity in real time.
First Fujitsu Engineer trained for Hard disk Drive Test Schedule Development in Yamagata Japan. A new team was formed and led by me for test schedule development in the Philippines.