Albert E. Gustafson1130 Dickens Road, Lilburn, GA 30047 Phone: 770-638-1602 -- Email: matrixchief@yahoo.com Summary --
Powerful results oriented Program Manager and Financial Analyst. Design, deployment and utilization of Data Warehouses (DW), Business Intelligence (BI), Data Mining (DM), Corporate Performance Management (CPM), Marketing & Financial Analysis and strategic & tactical planning. Deployment configuration and utilization of Oracle E-Business Suite, SAP r/3 ERP (FI, CO, SD, MM, HR, PP, BW). Hands On Experience with these technologies: SAP r/3 (FI, CO, HR, MM, SD, PP, PM, SD, BW), Oracle Financials & e-business suite, Oracle 8i/9i/10g DBMS, Oracle Discoverer, Oracle DW Builder, Informatica, Hyperion, Cognos, Business Objects, MicroStrategy, Microsoft SQL Server2005 & MS BI, Proclarity, BEA WebLogic, Oracle Jdeveloper, Microsoft Excel, Word, Power Point, Access, Windows 2000 / XP, Sun Solaris 10, Red Hat Linux. Education B.A. (psychology) Kansas Wesleyan University 1966 (gpa 3.5) M.B.A. – Operations Research University of Missouri at KC 1972 (gpa 3.8)B.S. Accounting Major (no degree, only courses) Memphis State University 1978 Masters Accounting Florida International University 1986 (gpa 3.8) M.S. Finance Florida International University 1988 (gpa 3.5) M.S. MIS Florida International University 1990 (gpa 3.5) Juris Doctorate Memphis State University 1984 (gpa 83) LL.M Tax Emory University 1984 (gpa 83) Doctor of Science - Computer Science Belford University 2006 (gpa 3.6) -- SAP Certifications (FI, CO, HR, BW, SD, MM, SM, PP, PM)-- APC Data Center University Certification for data center design and operations Addition Education and Certifications – SAP Certification (FI, CO, HR, BW, SD, MM, SM, PP, PM) – Over 400 courses taken.– Continuing Education Seminars: More than 400 seminars have been taken related to Information Technology, SOA, security, telecommunications, business intelligence, data warehouses and financial analysis. – Data Warehouse and Business Intelligence (18 seminars) from Kimball University, Informatica, Business Objects, Microstrategy, SAS, Hyperion, Brio, Cognos, and Oracle that provided in-depth technical training on OLAP, DW Life-cycle, Dimensional Modeling, ETL Architecture, Integration Strategy, DW Architecture Design, DW Business Requirements, Leveraging Metadata, DW Best Practices, SAS BI. – APC Data Center University Certification - Data Center Power, Cooling, Racks, Cabling, Fire Protection, Management, Physical Security Availability, Reliability, High Density Blade Servers, Generators, Design, Telephony, NCPI, Operations, and infrastructure - 38 courses,. – Councils of Advisors - Top 20 Percent Scholar – consulting to investment banking & capital asset managers -- Beta Gamma Sigma Academic honor for high achievement in finance and accounting
Significant Personal Attributes · Expansive out-of-the box thinker with proven skills in using BI, analysis and strategic planning for increasing revenue and reducing operating expenses and improving customer satisfaction.· Exceptional results-oriented leadership and unique executive team working strength.· Outstanding dynamic, clear and persuasive communications and interpersonal skills.· Broad in-depth hands-on understanding and application of many technologies that enable more effective utilization of resources, reduction of operating expenses, increasing revenue and profitability.
Professional ExperienceChief Business Intelligence & Financial Analysis Officer / Program Manager (for ITS Group – VISMEG subsidiary)VISMEG Holding Company (www.vismeg.com) May 1987 – PresentCore Business: Telecommunication and television service provider, Professional Services, Outsourcing. Primary Responsibilities.. Analysis and Planning Functional Responsibilities for VISMEG –ITS Group· Responsible for addressing these issues: why does the business need to spend this money; where can it spend it with the best returns; what should it be spending it on precisely; when is the best time to invest.· Responsible for program management over BI / DW / DM / analysis / reporting – for deployment and utilization for the Enterprise and Professional Services engagements to its clients. Multiple technologies are used to address specific issues for analysis, reporting and business processes.· Technical leadership, organization management, strategic & tactical planning, capital & operations budgeting, business intelligence, corporate performance management, financial analysis & corporate governance over global Enterprise IT & telecommunications infra-structure & Professional Services unit.· Business Intelligence (BI) & Data Warehouse (DW) applications and design (Star Schema, SnowFlake) using various BI, DW, DM and SOA technologies.· Financial Analysis & Marketing Analysis for VISMEG, its operating companies and its Clients.· Marketing Research, Product Management and New Business Development.· Technology Consulting to enterprises and capital asset management and investment banking firms.· Leadership and management over the Enterprise’s Professional Services Unit consisting of a staff of 120 professionals for Data Warehouses, Business Intelligence, Corporate Performance Management, Marketing & Financial Analysis & Strategic Planning. MicroStrategy Data Warehouse (DW), Business Intelligence (BI), Data Mining (DM) Manager· Created MicroStrategy DW / BI / DM applications, provided analysis and reporting for business users.· MicroStrategy componese used extensively: Intelligent Server, Report Services, Web, OLAP Services, Narrowcast Server, Meetadata Object creation, Administrator.· MicoStrategy Office and Desktop - used for reporting and analysis to Microsoft Excel and Worl\d.· MicroStrategy Architect – use to create metadata objects that map physical to logical database structure.· MicoStrategy BIDeveloper Kit used to create and deploy business applications for finance, marketing, human resources, sales, customer and web analysis.· MicroStrategy Administrator Command Manager, Enterprise Manager, and Object Manager - used to monitor and manage users, security · MicroStrategy SDK – used a the primary development environment for integrating MicroStrategy functions with SAP BW, Hyperion, Cognos, SAS, Business Objects, Teradata and other DW / BI/ DM technologies.· MicroStrategy Transactor – used as the workflow server to complement design, execution and monitoring closed loop BI applications.· Complex Analysis – MicroStrategy analytical functions were used for multiple marketing, finance, HR and logistic applications across the enterprise that were mission critical for strategic and tactical planning, executive scorecards, dashboards for corporate performance management, and Customer Relationship Management (CRM) systems that required data from multiple data sources.· Netezza - Microstrategy deployed over Netezza resulted in vast improved performance over previously used Sun servers.- Data Warehouse (DW), SAP BW, Business Intelligence (BI) and Data Mining (DM) · 15 Years experience in design, deployment & utilization of BI, DW, DM for marketing & financial analysis.· Technologies deployed and utilized: Teradata, Hyperion, Cognos, SAS, MicroStrategy, Business Objects, MS SQL Server, Proclarity, SAP BW, Oracle DW & Discoverer & BI Suite, SPSS, Informatica· Program Management for Professional Services unit related to BI, DW, SAP BW, DM for clients engagements.Utilization of DW, BI, DM for creating quantitative models, operations research, strategic and tactical planning and decision making and Corporate Performance management.
Business Intelligence & Data Warehouse results oriented performance Business Intelligence and Data Warehouse significant capabilities demonstrated as a Program Manager or Project Manager over 12 large scale BI and DW deployments and their utilization for marketing and financial analysis, strategic & tactical planning and decision making and Corporate Performance Management (CPM). · Demonstrated exceptionally strong quantitative analysis capabilities in utilization of BI & DW for marketing, logistics and financial analysis, corporate performance management, operations research, tactical & strategic planning, building models and decision making that has resulted in large reductions of operating expenses. Increased revenue and increased customer satisfaction. · Team Leadership over BI, DW & BW developers to provide day-to-day support to the Business units and manage the requirements for Projects. Team leadership, system design and programming over 12 full-life cycle SAP BW, DW & BI implementation projects. · Designed, developed, tested, implemented and utilized complex enterprise BI, DW and BW and provided technical support to team and users for the DW, BI and BW· Development, transport and testing of DW, BI & BW (Info Objects, Data and Info Sources, ODS, Info Cubes, Info sets, APDs) Objects and data extractors.· Quality Assurance over the teams to ensure that all development adheres to standards defined (i.e. appropriate level of testing is completed and documented, development standards were used, impact analysis on existing programs, and general feedback for performance enhancements). · Program Management and Leadership over production environments. · Problem resolution, training and general supports. · Documentation & maintenance with respect to Information Technology standards. · Ensured all systems & applications have defined & tested backup & recovery procedures for critical data. · Achieved outstanding client satisfaction as a strong technical manager with exceptional inter-personal skills. · Successfully delivered on multiple projects and priorities simultaneously. · Served as a mentor to team members. · Exceptionally strong data analysis, validation, and testing experience. · Comprehensive system design & applications design & deployment. · Extensive deployments of Enterprise Data Warehouse models for a variety of industry segments. · MicroStrategy and SAP BW implementations include ETL (custom extractors, ODS, cubes, multiproviders, APDs, infosets, info spokes, process chains, etc.) & reporting (query development, BEX, WAD, structures, variables, CKFs, RKFs, customer exits). · Designed and defined data warehouse / data mart / Business Intelligence concepts, ETL processes, metadata management, star schema & dimensional data modeling. · Utilization of Service Oriented Architecture (SOA), such as SAP Net Weaver, BEA Web Logic, Oracle Jdeveloer, Sun Net Beans, Jboss and IBM Web Sphere for customized business solutions used with DW and BI. · Deployment and Utilization of multiple DW (Star Schema, Snowflake), BI and Database technologies, including Hyperion, Cognos, Business Objects, SAS, MicroStrategy, Information Builder WebFocus, Microsoft SQL Server and Proclarity BI, Informatica, SAP BW, Oracle Discoverer, Oracle 10g, 9i, 8i and Microsoft SQL Server, and IBM DB2 databases.
U.S. Security and Exchange Commission May 1985 – May 1987 Staff Attorney · Enforcement of US security laws and regulations. Federal Express Corporation Jun 1978 – May 1985 Operations Research Analyst / Financial Analyst / Project Manager · Developed operations research models for new projects and strategic planning and decision making.· Participated in strategic planning and provided financial analysis for all mission critical projects that enabled FedEx to increase package volume from under 20,000 to over 500,000 package per night and achieve annual revenue growth from under $30 million to over $3.7 billion.· Cross functional responsibilities in finance, information technology, business intelligence, operations research and logistics enabled business managers to reduce operating expenses and utilize resources more effectively to substantially increase revenue.· Created Enterprise Data Warehouse and utilized it for formulating business intelligence, corporate performance management, marketing/financial analysis for strategic planning, alignment, governance and decision making.· Examples of Projects where major contributions were made: SuperHub, Package Tracking System, Enterprise Operations Budgeting, Enterprise Capital Budgeting for Fleet, Mergers and Acquisitions, International Growth, Fuel Management System, Expansion into new USA markets, Logistic improvement, Forecasting and more.· Participated significantly in the new product research, analysis and development for several new FedEx products and new business opportunities, such as Overnight Letter. Pepperidge Farm, Inc May 1976 – Jun 1978Core Business: Package goods food processor Product Manager · Profit/Loss Responsibility for a $40 million division.· Formulated and implemented strategic and tactical market planning that increased revenue 24% per year.· Full lifecycle development of new products and their rollout that added $12 M revenue to division.· Identified consumer market segment and created brand positioning.· Participated actively with sales to increase distribution channels.· Preparation and administration of operations budgeting and capital budgeting.· Worked closely with advertising agency to create very effective advertising campaigns.· Provided financial analysis, forecasting that enabled profitability to increase 8% to achieve 21% net profits. Interpublic Group of Companies Jan 1973 – May 1976 Core Business: Worldwide Advertising AgencyDirector Marketing/Advertising Research, Analysis and Strategic Planning · Designed and performed marketing and advertising research studies/analysis for rollout of new products.· Created marketing, media and advertising models for strategic planning and decision making.· Formulated product positioning and execution strategy for account executives and clients.· Created advertising campaigns for new package goods products, such as Miller Lite Beer, Sprite, Tab.· Media Planning Models developed enabled optimal targeting of media to target segments.· Identified market segments and created product positioning that significantly increased revenue growth.· Created marketing/advertising plans for new business development that generated over $25 Mil revenue. U.S.A.F. Nov 1967 – Feb 1972 Captain
Cross Functional Responsibilities Service Oriented Architecture (SOA) project management· Chief Database Architect and Service Oriented Architecture (SOA) program manager.· SOA & Integration and application development using C/C++, Visual Basic, SOA Technology for creating mission critical apps & Web Services: BEA WebLogic, Oracle Jdeveloper, IBM WebSphere, Sun NetBeans, .NET · Data Center (DC) Design & Infrastructure - planning, analysis, design, deployment of DC & infrastructure.· Market and Financial Research, Analysis and Product Management· Designed and implemented market research studies and used quantitative and statistical techniques for analysis that enabled the enterprise to identify new business opportunities and new products and take action.· Deployed and extensively utilized business intelligence technologies, such as Cognos, Hyperior, SAS, Business Objects, MicroStrategy, Oracle Discoverer, for market and financial research and analysis. BI is used extensively to create quantitative models used to increase revenue and reduced operating expenses. Business Analysis · Team leadership in developing project specifications, functional designs specifications, documentation, system testing, and web portlets, and provided ongoing support for the web-portals that were created using SOA BEA WebLogic 8.1, Oracle 9i, XML and JAVA. · Formulated the business analysis for 33 large mission critical systems and project management over deployment over full lifecycle. ERP and Financial Systems· Oracle Principle Functional Project Manager for Oracle 11i e-Business Suite (General Ledger, AR, AP, Assets, Cash Management, Treasury, Assets, Inventory, Purchase Orders, Enterprise Planning & Budgeting).· SAP Program Manager for SAP ERP deployment (FI, CO, SD, HR, MM, PP, BW)· New Business Development – Instrumental in developing more than $20 million of new business through meeting and interacting with senior management to enable them to understand the benefits and ROI that will result from deploying business intelligence solutions that will address fundamental business issues focused on increasing revenue, reduction of operating expenses and improving customer satisfaction. · Program & Functional Project Manager for VISMEG & ITS Group & Professional Services Unit.· Functional Project Manager for deployment of Oracle Financials for VISMEG and its operating companies.· Oracle Financials Program/Project Manager over Oracle E-Business Suite Financials, Marketing, Supply Chain Management, Human Resources.· SAP Program/Project Manager for deployment of SAP ERP for ITS Group clients through the Professional Services unit.· BI / DW / CPM Program Manager for design and deployment of SAP BW, Data Warehouse (DW), Business Intelligence (BI), Corporate Performance Management (CPM) and Data Mining (DM) solutions· Financial Analysis, Operations Research, Reporting, Strategic Planning, Technology Consulting.· Oracle DBA for 8i, 9i, 10g, and 11i e-Business Suite. SAP and Oracle ERP and Financial Professional Services Engagements.· Oracle Program & Functional Project Manager for 12 Oracle 11i E-Business Financial Suite deployments.· SAP Program Manager for 9 large-scale SAP ERP (FI, CO, SD, HR, MM, PP, BW) deployments.SAP BW lead BI architect – Formulated design specifications, data models, data store objectives, Info Objects, Master Data, InfoCubes and project management over 8 SAP BW deployments.
Routine finance analysis responsibilities· Financial analysis and budget planning for international enterprise using Cognos, Hyperion, SAS, MicroStrategy, Business Objects, Oracle 11i business suite and SAP r/3 ERP applications.· Financial analysis for global strategic planning, reduction of operating expenses and increasing revenue for all Enterprise business segments.· Prepared consolidated financial reporting to understand the financial conditions of programs and budgets. · Implementation, compliance, coordination for project change control policies and procedures · Prepared executive summary finance analysis and reports for operations and corporate management.· Prepared quarterly finance analysis and reports (including forecasts, targets, actual expenditures, budget variances, ROI, and accruals) for operations focused on program finance functions for all business segments.· Prepared capital budgets for international Enterprise and wholly owned subsidiaries.· Prepared project estimates and mapped projects to available budgets· Formulated finance analysis, forecasting and models for actual and budgeted expenditures, and advised corporate management of the impact of new activities and changes to program requests.· Formulated finance analysis and created directives for corporate management for release and transfer of funds between corporate and wholly owned subsidiaries operating in international areas.· Telecommunications Revenue Analysis – routine analysis on revenue from telecom operating companies. · Identifying issues and analysis for corrective actions to be taken that have an impact on telecommunications revenue business segments and creation of reports for finance.· Root cause analysis, impact analysis, and problem resolution financial analysis.· Order Reconciliation· Sales to Cash flow processes analysis, billing and provisioning analysis and revenue assurance analysis for the Enterprise Internal Auditing.· Ad-hoc analysis and creation of SQL queries and BI cubes for revenue and expense analysis. · Marketing and Financial Analysis.· Chief Database architect and project manager over 13 enterprise marketing and finance data warehouse design and deployments with star schema and snowflake data model design.· Informatica – utilized extensively for ETL development and processes.· Database and OLAP solution technologies utilized for DW/BI projects include: Hyperion Essbase, Cognos, Oracle 8i, 9i, 10g, Oracle Discoverer, Microstrategy, Teradata, MS SQL Server, Proclarity UI.· Business Intelligence Technologies utilized extensively over 12 years: Hyperion 9, Cognos 8, SAS, Business Objects XI, MicroStrategy, Oracle Discoverer, Microsoft SQL Server 2005 OLAP & Proclarity BI, SPSS.· Financial Modeling, Budgeting, Corporate Performance Management, Financial analysis and planning resulting in substantial reduction of operating expenses.· Marketing analysis, research, modeling and strategic planning resulting in increased revenue growth.· Created the dimensional framework for enterprise financial analysis and strategic planning.· Created business performance management, six sigma and balanced scorecards to identify cause and effect relationships, improve business processes, align tactical responsibilities with performance.· Created and implemented one-to-one marketing strategy that enabled customer service agents to substantially increase cross-selling and up-selling contributing to an 8% increase in ITS Group revenue.· Product Management with Profit/Loss responsibility over the Enterprise’s VoIP business segment._________________________________________________________________________________________
Business Intelligence, Data Warehouse and Financial AnalysisTechnologies deployed and extensively used at VISMEG CognosCognos 8– Over 9 years experience deploying and using Cognos and 2 years experience with Cognos 8.· Financial Analysis and Marketing Analysis with Cognos - Deployed and used Cognos products for strategic planning, budgeting and analysis to improve and support the Enterprise’s telecom operations:· Cognos Planning was used to create strategic plans and budgeting that connected finance and operations and real-time feedback to the teams engaged in planning, analysis and reporting process.· Cognos Finance with its multi-source data collection and integration capability was used to create collaborative workflow corporate finance management and streamline Enterprise budgeting, forecasting, consolidation and financial reporting processes and current information on key performance indicators. · Cognos Controller was used to consolidate multiple diverse international ledgers for the Enterprise’s 18 wholly owned subsidiaries and business segments accurately manage processes of consolidation. Dimensions were defined to support collection and reporting of multiple levels for cost centers, products, and customers to provide the core for operational and strategic decisions.· Cognos Customer Analytics was used to determine the top revenue generating customers, most profitable customers, highest ROI for marketing and advertising. · Customers were identified for high demand products, cross-selling opportunities which substantially increased sales by identifying purchase patterns and trends across various market segments.· Cognos Business Intelligence (BI) – used for financial analyze and marketing planning / analysis.· Cognos ReportNet was used for creating business intelligence reports across the Enterprise through web services-based architecture to provide for integration and adaptive authoring.· Cognos PowerPlay was used for OLAP over the Web to analyze large amounts of data through scalable cubes and create models to determine the “why” behind actions so that steps to address problems.· Cognos Visualizer was deployed to create dash-boards to visualize data and present a real-time view of marketing, sales, finance, HR, logistics and provide a complete view of profitability and support critical strategic initiatives of Six Sigma and Total Quality Management. Results: Diverse data from ERP, CRM, RDBMS, OLAP cubes and flat files were integrated into one place to provide one version of the truth.· Cognos DecsionStream was deployed to be used with Enterprise Dimensional Data Warehouse and Data Marts to unite disparate data into an integrated BI and provide the foundation for conforming key business dimensions, such as time, product, and customers for reporting across business segments. · Flexibility, dimensional framework, server based ETL engine and graphical interface improved financial analysis and strategic planning by delivering current BI and dimensional data.· Cognos Business Performance Management, Six Sigma and Balanced Scorecards - · Cognos Metrics Manager was used to substantially improve Enterprise performance by aligning tactics with strategy for more effective use of resources and assign responsibilities for each performance metric. · Cascading scorecards were developed to ensure consistent focus across subsidiaries and integrate collaboration for better decision making. Balanced Scorecards were used to communicate strategic goals, identify key processes and cause-and-effect relationships between business processes and metrics.· Cognos NoticeCast was used for Business Activity Monitoring (BAM) to provide real-time alert information sent through email about critical events, and enable managers to take immediate action to address issues with corrective actions by using SQL agents for guided analysis and event management SAS · Over 20 years experience in using SAS for marketing, financial analysis & statistical & Quantitative models· SAS Master - Designed SAS programs & applications to solve real world problems, statistical econometric models to analyze marketing, finance, logistics, operations and forecast trends and customer behavior using regression and time series methods from data warehouses I designed. Modules deployed and used: SAS9, SAS integration, SAS/Connect, SAS OLAP Server, SAS Data Surveyor, SAS/Access, SAS Map Studio, SAS BI.· Created SAS programs to deploy systematic improvements across the Enterprise for statistics analysis, business economics, strategy, and change management.· SAS9 for data mining applications for BI & analytical intelligence issues using Enterprise data warehouses.· SAS integration technologies were used to gather, analyze and create integrated global enterprise BI.· SAS/Connect was implemented to reduce the time to process large, complex SAS programs for disparate systems across the global Enterprise. · SAS OLAP Server was deployed and used extensively as a multidimensional data store to utilize metadata from the data warehouses, strategic planning, and critical decision-making and reporting.· SAS ETL Studio was deployed to reduce the time to had code batch ETL jobs and access to its library of pre-built data transformation. · SAP Data Surveyor for SAP, Oracle Applications and Siebel were deployed and used extensively to interact data from Enterprise ERP and CRM applications.· SAS/Access was deployed to transparently access data in the Oracle and SQL2000 databases. Hyperion Hyperion 9 - applications used for financial analysis and business performance management –· Extensive use and deployment of Hyperion products for financial and marketing analysis for over 9 years.· Hyperion EssBase multidimensional database server that is used for planning, analysis and. reporting has been installed and configured 21 times in client engagements. Hyperion EssBase is use extensively for Enterprise financial and marketing analysis and strategic planning to view data on demand.· Hyperion EssBase APIs have been used with Microsoft Visual Basic, Visual C++, PowerBuilder and other applications developed to provide extended functionality for specific projects.· Hyperion Scorecards and Dashboards were deployed to analyze and monitor Key Performance Indicators (KPI), pinpoint business issues and take fast corrective action. Results: empowering managers to define successful performance measures and monitor KPIs aligned Employees performance with Enterprise strategy and objectives.· Hyperion Intelligence and Dashboards were deployed for Enterprise customer call centers to enable agents to be able to identify and capitalize on opportunities for improved performance and much better customer satisfaction.· Hyperion Pillar was used to creating and managing budgets, planning, forecasting and analysis for the global Enterprise. Activity-based budgeting and analysis was especially good for improving performance for field technicians. Replication technology allowed distributed users in different geographical areas to work independently and submit their budgets for consolidation.· Hyperion Enterprise was used for Enterprise financial consolidation, reporting and analysis. Excel add-in was deployed for direct linkage to Hyperion Enterprise for input and reporting.· Hyperion Strategic Finance used to create financial models analysis for developing strategic planning.· Hyperion Business Modeling was use to create interactive profitability modeling over the Web and test assumptions used in the modeling process, and determine optimization of resources.· Hyperion Planning, Budgeting and Forecasting was used for adaptive planning and creation of dynamic budgets, forecasts and plans to needed to drive profitability across the global enterprise.· Hyperion Financial Management was used for the Enterprise’s global financial consolidation and reporting for 18 subsidiaries to substantially improved the financial and closing process.· Brio - Brio products extensively used included: Brio Intelligence (Hyperion Intelligence), Brio Metrics Builder (Hyperion Metrics Builder), Brio SQR (Hyperion SQR), and Brio Performance Suite 8 (Hyperion Performance Suite) to extract information for business intelligence from the Enterprise data warehouse. InformaticaInformatica – Over 9 years experience using Infomatica ETL for data warehouses· Extensive utilization of Informatica ETL development and ETL processes for implementation of data warehouses and data marts. Business Objects XI Release 2· Crystal Reports – created reports for marketing & finance used to drive business strategies and objectives.· Business Ojbects Enterprise – used to identify where changes must be made to drill down to using marketing resources more effectively to increase sales revenue.· Used as the primary BI support system for decision making, tracking, managing and delivering information.· Enterprise Information Management (EIM) – used to integrate data from various sources throughout the enterprise for analysis, reporting, planning and decision making for better insight into business processes and effectiveness of marketing and sales plans.· Enterprise Performance Management (EPM) – used to successfully align business actions with strategic planning and enable accountability to those involved in various business units.· Analysis and Queries - provided to finance and market were used for strategic and tactical planning and decision making resulting in reducing operating expenses and increasing sales revenue.· Tracking Enterprise Performance – created enterprise applications, user interfaces, reports and dashboard to track various areas of enterprise performance.· Business Drivers – identified and used business drivers for reporting, query and analysis for reducing operating expenses and increasing revenue through more effective marketing planning and decision making.· Infoview – was used as the enterprise BI portal to provide the web interface for interacting with diverse BI information, reports, analysis, dashboards, scorecard, & strategic maps.· Voyager – used for analysis of multi-dimensional data and creating quantitative marketing and finance models by accessing multiple OLAP cubes from various sources.· Encyclopedia – used extensively to create reference guides for BI content and provide visual maps describing relationships between data content.· Data Integrator – used as the ETL, for data validation, for auditing data quality during the ETL process and for performing impact analysis for Crystal Reports.· Central Management Console (CMC) – used for Business Intelligence Administration for managing, deploying and configuring the enterprise BI infrastructure, such as for authentication, user interfaces, object rights, processing, security, clusters, services configuration, universes and data connections. SAP SAP Program Manager for (FI, CO, HR, SD, MM, PP, PS, BW) – Over 14 years SAP project experience· Principle Consultant and Functional Lead SAP ERP Program/Project Manager for 9 full life cycle SAP for large-scale configurations and deployments for SAP FI, CO, HR, MM, SD, PP and BW for a variety of business segments, including Telecommunications, Technology, Manufacturing, Government, Pharmaceuticals, Transportation,, Retail, Financial Services.· Lead SAP BW BI Architect for ITS Group Professional Services - Developed and designed requirements to be implemented for SAP BW 8 SAP BW projects. Served as project manager over SAP BW and BI deployment. Formulated data models, data store objective, Info Objects, Master Data and Info Cube. SAP BW career experience· Eight years of hands-on management experience in deploying and using SAP BW for the VISMEG –ITS Group enterprise and its clients during professional services engagements.· Deployed and configured SAP FI, CO, HR, MM, SD and PP modules and used them for building SAP BW for the Enterprise.· Utilized Netweaver to integrate SAP BW with business processes and other BI technologies, such as Hyperion for Budgeting, Forecasting, and building financial quantitative models. - Extensive use of other BI technologies with SAP BW, including Business Objects XI Release 2, Cognos 8, Hyperion 9 and SAS.
SAP BW Technical and functional responsibilities:· Built InfoObjects to describe business processes and information needed by line of business personnel · Created Operational Data Store (ODS) objects by merging data from different data marts within various operational units within the Enterprise. These ODS were flat, transparent database tables that were instrumental in creating reports and for quality assurance.· Created DataSources for extracting and staging data from various data mart within different enterprise subsidiaries.· Created InfoSources containing transactional data from online SAP and Oracle transactional processes (OLAP) and master data databases.· Created InfoCubes based on enhanced star schema design for reporting and analysis of data. These multi-dimensional data storage containers of data such as products, geographical regions, types of sales channels, customers and other key figures and characteristics were used to analyze data from different business perspectives for marketing and financial strategic and tactical planning · Created routine queries from InfoProviders (i.e., SAP BW data objects) for routine reporting and analysis used by finance, marketing and operations managers. - Utilized SAP InfoPackages for loading SAP BW data extracted from source systems. These applications enabled were used to take objects at the DBMS levels and associate them with application level entities. These InfoPackages were also used to identify problems encountered through each stage of extraction and load for transporting data into InfoCubes, ODS and Master Data files.
SAP BW architecture responsibilities:· Extraction, Loading and Transformation (ETL) for the staging area and loading data into the SAP BW after assuring quality of the data.· Storage services· Analysis of information stored in SAP BW· SAP BW Administrative services through utilization of the SAP Administration Workbench (AWB)· Metadata services and modeling using the SAP Metadata Manager for handling requests for retrieving, adding, changing and deleting metadata. This metadata modeling provided the Metadata Repository for stored MetaData.· Created SAP BW queries using ABAP/4 for routine reports used by finance, marketing and operations management.· Created Excel workbooks from SAP BW for financial analysis. MicroStrategy 8· BI analysis, monitoring and reporting – Project Manager for MicroStrategy deployment in 8 large-scale OLAP BI projects. · Data Mining – MicroStrategy is utilized extensively for data mining for finance, marketing, strategic planning and decision-making. · Direct Access to SAP ERP operational and BW applications – MicroStrategy has been deployed 8 times and utilized extensively for analysis, data mining, monitoring and reporting from data SAP sources. Other BI Technologies deployed and used during Professional Services engagement TeradataMicrosoft SQL Server OLAPProclarity BIOracle Discoverer & Oracle Data Warehouse Builder & Oracle BI Suite & Oracle Data Mining.Information Builders Web Focus Oracle Oracle Data Warehouse (DW), Business Intelligence (BI), and Data Mining (DM) · Over 8 years experience for Oracle BI and DW solutions including: Oracle Discoverer, Oracle Data Warehouse Builder, Oracle BI Suite Enterprise Edition, Oracle Data Mining, Oracle OLAP, Oracle Partitioning, Oracle Activity Monitoring, Oracle Data Integrator, Oracle Business Process Management, Oracle Financial Analytics, Oracle HR Analytics, Oracle Order Managemen, Oracle Fulfillment Analytics, Oracle Sales Analytics, Oracle Service Analytics, Oracle Jdeveloper, Oracle SOA, Oracle Business Process Management (BPM).· Hyperion solutions deployed and utilized extensively for over 8 years, including Hyperion EssBase, Hyperion Data Relationship Management, Hyperion Financial Management System 9, Hyperion Planning –System 9, Hyperion Performance Scorecard – System 9, Hyperion Strategic Finance, Hyperion Capital Expense Planning, Hyperion Workforce Planning, Hyperion Financial Data Quality Management. Oracle Database Administration (DBA) · Over 12 years experience for Oracle DBA. · Responsible for DBA functions over mission critical Oracle 8i, 9i, 10g DBMS and 11i e-business suite. · Logical database design and physical implementation of mission critical business systems.· Change management (i.e. enforce procedures for change management regarding all database object, jobs, scripts and one time data modifications).· Backup, recovery, disaster planning and recovery strategies and deployment· Security planning and policies for databases, applications, systems, and networks.· Configuration management (i.e., maintain multiple related database and ERP/CRM applications environments for production, reporting, staging and performance testing). · Mentoring & project management over systems architects & applications for design & integration.· Performance Verification (i.e. enforce procedures for validating performance characteristics of new or modified procedures, jobs and scripts).· Proactive and Reactive Monitoring (i.e. establish proactive monitoring plan for long term trend analysis and created baselines against which to compare problem events.)· Capacity Planning (i.e., planning for current and future capacity requirements). · Database Configuration-tuned database configuration to achieve availability/performance goals.· Database Security (i.e., established and enforced database security guidelines)· Oracle Enterprise Manager – used extensively for DBA functions· PL/SQL programs, SQL+ and Unix scripts Chief Oracle Systems, Database Architect & Oracle E-Business Suite functional deployment. · Over 12 years design and deployment of Oracle applications. · Oracle 11i e-Business Suite Application Server DBA – Modules configured and deployed include, Business Intelligence, Contracts, Customers, Discrete Manufacturing, e-Commerce. Finance, HRMS, Interaction Center, Internal Procurement, Internet Procurement, Marketing, Oracle Services, Order Management, Projects, Sales, Supply Chain.· Oracle RDBMS 8i, 9i, 10g – Deployment of Oracle 10g Grid DB resulted in ROI of 85%· Oracle J Developer – used to develop web services and portals J2EE/Java/XML and Service-Oriented Architecture mission critical applications.· |
