Senior Operations Analyst (Database Administration)
Accenture
Total years of experience :14 years, 9 Months
Provide database administration support to business operations handling low cost airline industry
In charged to lead a team to provide optimum service during work shift.
In charged to ensure databases are up and running at all times
Troubleshoot and resolved database related incidents in a timely manner to reduce customer downtime
Proactively monitor and improved process to prevent potential issue
Generate report for database performance analysis, and top alerts that require long term solutions.
Automate task and create tools to help improve daily tasks and activities such patching, upgrade, and refresh.
Recommend database solutions, design, maintenance and administration align to business needs to save cost
Analog Devices, Inc., Gen. Trias, Philippines May 2004 - Present
Experience Applications Analyst/Developer for this world leader in high performance signal processing technology with more than 9000 employees in 23 countries and 60000 customers in more than 10 industries.
Key Responsibility
• Daily monitor and every automated jobs from the server to ensure with successful execution otherwise perform out of action plan as interim solutions to proceed the desired result.
• Work with script modification and system reload as required to all existing QlikView application to reflect and get the most significant updated information from the data source model.
• Engage in data gathering, analyzing user requirements and specification before translating into detailed process flow for possible system improvement and modifications.
• Provide Adhoc reports and data extraction from QlikView dashboard into excel for immediate supporting document and to easily dissemination of information via email as needed.
• Served as the primary user technical support in the team for software bugs and computer hardware issues before escalating and elevating to system technical support group
• Attend daily and weekly meetings to discuss project updates, milestone, changes, and modifications and still by ensuring to deliver within the time frame.
• Closely work with team to coordinate concerns, issues, recommendations, improvement, and working to provide long term action solutions.
• Maintain file server remote access, shared drive, security, permissions, and accessibility to all authorized user and integrated software applications or data input/output files.
• Hands on doing the FTP of reports to US counter parts and ensure to deliver in a timely manner.
Accomplishments
• Created QlikView BI report using Combo Chart with set analysis and coded expressions using OLE-DB Jet database engine as data source, map, concatenate, and improve table structure design for "Resource Utilization KPI" project.
• Implemented High Level Traffic Light Data BI Dashboard project with extensive calculated dimensions and expressions definitions of pivot chart and straight table objects using built functions in QlikView to reload and display comprehensive and intelligence view.
• Designed a highly associative QlikView dashboard reporting tool for Weekly Auto Analysis Resource with interactive layout of charts, tables, sheets, list box, and other objects that allow user experience with structured SQL Server tables and queries as OLE DB database source for data modeling.
• Established web custom application with user interface using C#.Net and SQL Server and Integrate constructed dashboard with table and charts using QlikView that serve as reporting tool to help improve decision and analysis for monthly rough cut capacity planning forecast.
• Successfully completed the migration of operational SQL Scripts and Batch Scripts use for automated jobs process from single server to another server machine efficiently.
• Reduced 30% of staging inventory upon completely implementing Window base tailored desktop application using MS Access RDMBS complex action queries functions, tables, advance macros, and mix input file formats specifications and requirements.
• Assisted in upgrading the custom web base application for Planning Demand Update Tool with direct hands on user support in troubleshooting their experience during parallel and live testing.
• Increased data consistency with implemented MS SQL Server maintenance backup and recovery plan method, including performance tuning, indexes, normalization, and database optimization.
• Created comprehensive user reference documentation of several task and report being initiated daily and weekly basis for flexible task ownership during absence of default responsible person.
Moses Print Shop, Dasmarinas City, Philippines June 2001 - October 2003
Graphic Artist/Web Page Designer for specializing in Printing Services Digital trading Multimedia Designs and Consultancy.
Develop various print and electronic graphic designs for various software programs such as campaigns, advertising materials and newsletters with help of all internal and external available resources.
• Develop web design and layout based on client needs and business specifications
• Coordinate with the marketing team and project team adhering the best practices
• Design various advertising campaigns across various publications.
• Assist to design all brochures and flyers for various promotions and trades shows.
• Prepare billboards and banners to promote organization products and services.
Computer Software/Hardware Support for one of the leading educational institutions in the vast growing locality of Dasmariñas, Cavite and in CALABARZON, Philippines.
In charged handling the several computer laboratories in maintaining local area network LAN, large number of workstations, switch hub, file server backups, installation, configuration, security, and software and hardware upgrades.
• Create multiple user accounts and provide level of access point, security, and permissions
• Provide hands on technical support and troubleshooting on each workstation end user
• Assemble and dis assemble hardware peripheral parts need to replace and upgrades
• Setup and install different software application that might user require and needs
• Secure all workstations with anti-malware, anti-virus, and protected internet fire wall
• Monitor and ensure performance and functionality of all setup computers
With special awards -best multimedia exhibit showcase -3rd place web page designer
With certifications and special awards. -best thesis in modern communications -best in microcomputer troubleshooting