More Related Content
What's hot (20)
Viewers also liked (7)
Similar to Karl Umaguing: Resume (20)
Karl Umaguing: Resume
- 1. Karl Umaguing<br />1115 W Rowland Ave<br />West Covina, CA 91790<br />Home 626 939 5062 Mobile 626 824 5062<br />karl@aspminc.com<br />Summary<br />IT professional with over 20 years experience as a lead on application development projects. Proven project management and systems analysis skills applied in creating information technology solutions to solve business problems and to meet organizational objectives.<br />Technical Skills<br />Microsoft TechnologiesSQL Server 2008 Integration Services (SSIS), SQL Server 2008 Analysis Services (SSAS), SQL Server 2008 Reporting Services (SSRS), Microsoft Office SharePoint Server 2007 (MOSS), Microsoft Performance Point Server 2007<br />Oracle Technologies<br />Business Intelligence Solution - Essbase Analytic Services (EAS), Hyperion Reporting, Essbase Integration Services (EIS)<br />DatabasesMS SQL Server 2008, MS Access, Oracle Database<br />Software<br />SQL Server Business Intelligence Studio, SQL Server Management Studio, SQL*Plus, SQL Developer, Crystal Reports<br />Query Language<br />T-SQL, MDX, PL/SQL, Essbase Scripting<br />SetFocus, LLCWest Covina, CA10/2010 1/2011<br />Business Intelligence Masters Program <br />The SetFocus Business Intelligence Masters Program is an intensive, handson, project oriented program where participants add knowledge of and valuable experience putting the Business Intelligence skill set to use in a simulated work environment.<br />Implemented a Labor Analysis Business Intelligence solution for a national construction company.<br />Existing data from diverse data sources were consolidated into a uniform SQL Server 2008 database. ETL capabilities of SSIS were used to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails. <br />Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements. <br />Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.<br />Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership. <br />Created score cards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a construction company extracting data from SQL Server 2008 OLAP data source and deployed to SharePoint sites.油The dashboards also contain pages to view performance by employee, by region, and by quarter enabling end-users to make filter selections.<br />Key product areas utilized also include data modeling, SSRS report subscriptions and data driven subscriptions, SSAS analysis services processing tasks, cube processing options and roles.<br />Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios, such as multiple hierarchies, data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions.
- 2. Possess solid knowledge of writing, tuning and optimizing T-SQL queries.Professional Experience<br />Chase BankChatsworth, CA2000 2009<br />Senior Software Developer<br />Design and Development - Automated the budget and capital planning process of a major financial organization by merging financial reporting systems from several legacy systems. Coordinated and facilitated reports integration activity with several departments using disparate financial systems which was consolidated into one reporting system. The outcome was an integrated corporate-wide expense versus budget-capital budget forecasting model, resulting in cost savings equivalent to 6 FTEs and reduced forecast/plan preparation time by two weeks, despite the plan doubling in size over a two-year period.
- 3. SharePoint Administration Responsible for managing content, troubleshooting, controlling site access, administering search and indexing, approving and publishing reports for a multi-departmental SharePoint site with interfaces to executive financial reporting systems. The site also functioned as a corporate wide intranet supporting more than 700 users.
- 4. Database Administration - Responsible for the design, integration, implementation and maintenance of corporate-wide financial data marts that supported the Corporate Planning and Accounting organizations with a user community of more than 700 users.
- 5. Decision Support - Provided decision support metrics and analysis with Essbase as the OLAP engine to Corporate Accounting and Corporate Forecasting & Planning areas of a multi-billion dollar banking conglomerate facilitating strategic business decisions and meeting cost savings initiatives.
- 6. SOX compliance As part of an internal audit action plan, audited and automated workflow processes to provide audit reports on user security, database access and reports usage on a weekly basis in a timely manner in order to maintain compliance. This automation saved an estimated 50 man-hours per month.
- 7. Technical Support - Provided first- and second-tier technical support for all applications of the Financial Planning and Corporate Accounting with 700+ users. Supported month-end, quarter-end and year-end accounting close and corporate-wide decision-support metrics as a member of Financial Reporting and Analysis technology team.
- 8. Merger/Acquisition Support Assisted in all transition activities for existing reports and databases to be merged with external company computer systems.SriSoft CorporationDiamond Bar, CA1997 2000<br />Systems Analyst<br />P. Murphy & AssociatesBurbank, CA1994 1997<br />Consultant<br />Rockwell InternationalSeal Beach, CA1989 1994<br />Programmer Analyst<br />Electronic Data SystemsAnaheim, CA1985 1989<br />Systems Engineer<br />Education<br />MicroAge Computer <br /> Education CenterDiamond Bar, CA 4/2000 5/2000<br />Oracle SQL Programming and Database Administration<br />The SQL Programming course enabled delegates to develop complex queries in Oracle SQL, to employ the procedural capabilities of PL/SQL including the use of transactions and to manage data structures. The Database Administration course provided the delegates with the essentials of being an Oracle Database Administrator.<br />California State Polytechnic UniversityPomona, CA1978 1983<br />Bachelor of Science, Microbiology<br />