Summary of Qualifications

Confidential is a Senior/Lead Business Intelligence Solution Architect with over 15 plus years of experience in the Information Technology IT industry in helping clients to align IT strategies with corporate strategic objectives across all departments, divisions, and locations. Confidential has demonstrated and/or proven ability to effectively communicate with all levels of management and lead complete project life cycles, from initial planning and needs determination to final testing and deployment of financial reporting systems using technologies such as SAP Business Objects, Cognos, and Oracle Hyperion Essbase in a client/server architecture and network environment. Throughout his IT consulting career, Confidential has led and managed a team of five or more resources on several business intelligence projects for clients in the financial services, insurance, automotive services, energy/commodity, retail, and telecommunication industries in tracking and analyzing company's financial performance, risk and exposure, operating expenses, capital and operating metrics against all developed business plans. Confidential continues to be involved with every phase of the life cycle development, including feasibility studies, design, and coding for large to medium business intelligence projects. He has acquired over the years a comprehensive understanding of database design and methodology from multiple perspectives user, designer, and developer and has hands-on experience in designing, developing, and implementing data integration ETL strategies and/or techniques on multiple database platforms and operating system environments using today's cutting edge technology such as Oracle Data Integrator, SQL Server 2008 SSIS, and Informatica. Confidential is detail oriented and committed to delivering superior quality work.

Technical Skills

Professional Experience

Confidential Senior Business Intelligence Solution Architect /Independent Consultant

• Worked closely with clients as team leader on various data warehouse/business intelligence projects in understanding their data processing and business requirements in providing highly available technical solutions.
• Gathered and translated business requirements into technical specifications using structure techniques and data warehousing methodology.
• Developed detailed technical blueprints for the integration of business intelligence solutions performed tools evaluation and selection for various client projects.
• Created RFP respond and client presentations prepared and communicated status, issues and opportunities to business executives.
• Planned, designed, and implemented database Oracle applications exceeding Terabyte in size in both Unix and Windows environment.
• Designed data warehousing data storage/techniques ODS, MOLAP, ROLAP, etc. .
• Performed RDBMS installation, configuration, and tuning.
• Designed and implemented backup and recovery strategies in both Unix and Windows environment.
• Resolved technical issues and provided best practices for the monitoring, supporting, and maintaining of an Oracle and/or MS SQL Server 2000 database applications.
• Developed Extraction, Transformation, and Loading ETL procedures using programming languages such as Vbscript, Perl, Proc C, Oracle PL/QL, and SQL Server procedures and ETL tools including Oracle Data Integrator 10g formerly known as Sunopsis , Informatica, MS SQL Server 2000 DTS, MS SQL Server 2008 SSIS, and Transformation Server for MS Windows NT.
• Created presentation quality reports into zero-client application with Cognos and Business Object Reports.

Confidential

• Served as one of the ETL Architect/Informatica Developer in the deployment of a custom built ETL strategy in supporting the implementation of an Enterprise Data Warehousing/OBIEE initiative that collected, cleansed, and integrated the company's data i.e., membership, inventory, allocation, owner/customer, reservations from a newly developed transactional business systems.
• Worked closely with other team members and business users in understanding the business requirements and the source operational systems
• Performed detail data analysis of both data elements requested by the business and transactional source systems
• Estimated ETL project tasks and helped project manager defining scope
• Documented data source definition and ETL specification a.k.a., logical source-to-target mapping for each environment i.e., staging, central repository, data mart .
• Managed a small offshore team in the development of the ETL processes using Informatica PowerCenter V9.1 in a Linux/Oracle11g environment, which included weekly code reviews to ensure standards and best development and design practices
• Created, executed, and maintained QA test plans for each environment i.e., staging, central repository, data mart

Confidential

• Served as one of the Lead ETL/DB2 Developer in the enhancement of an existing custom ETL framework that collected, cleansed, and integrated the company's performance data i.e., cash-flows, liquidity positions from various operational source systems. The enhancements were part of an overall initiative in improving an internal custom built Liquidity Risk Management System LRMS that supported and provided Bank of America Corporate Treasury executives, senior managers, and business analyst with analytical reporting capability on the company's liquidity position, sources and uses of cash, forecasting of cash flows and stress test modeling, funding counterparties, and developing fund plan as needed.
• Architected and developed an ETL component using DB2 native procedure language that dynamically constructed in real time the SQL to load over 100 source feeds into the Liquidity Position fact table using a Meta Data approach and/or strategy developed a data dictionary for the ETL Meta Data Rule component.
• Developed DB2 objects such as tables, views, indexes, triggers, procedures, and functions to support the ETL Meta Data Rule component.
• Designed and developed an ETL process that mapped custom products and/or services hierarchical relationship with the company's general ledger products for reporting purposes.
• Performed detail data analysis of both data elements requested by the business and data sources and documented data source definition, source-to-target mapping, and logical structures to support the ETL Meta Data Rule component.
• Provided additional support, guidance, and training in the deployment of the solution in various environments such as integration, QA, and production created Spotfire reports to allow the users access and/or view source reference data

Confidential

• Served as the Lead ETL Developer/Data Architect in the development of the agency Auction Securities Data Warehouse in order to make easier access of auction securities data, provide analytics, trending and comparisons, reporting and exporting capabilities that support the business needs, but most of all, increase data utilization, and improve customer services and productivity.
• Installed and created an Oracle 11g database which included the development of objects such as tables, views, indexes, procedures, and functions
• Architected and developed a customer ETL framework that consisted of over 144 processes using Oracle native language PL/SQL to load the agency Auction Securities Data Warehouse
• Performed detail data analysis of both data elements requested by the business and data sources and documented data source definition, source-to-target mapping, and logical structures for the Auction Securities Data Warehouse.
• Provided additional support and guidance in the development of the Business Objects 3.1 solution trained and guided other junior PL/SQL Developers on the ETL framework.

Confidential

• Served as a Senior Oracle Data Integrator ODI Developer in the development of the company's budget, forecast, and capital planning reporting system in order to improve the cycle time of the current planning process, reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Installed and configured the Oracle Data Integrator software tool in a three-tier environment, which included performing periodic upgrades.
• Performed source-to-target mappings, storage capacity planning, and developed ETL processes for the initial load and incremental updates using the Oracle Data Integrator 10g tool formerly called Sunopsis.
• Developed ETL processes to update the Hyperion Planning and several Hyperion Essbase 11g applications, which included updates to Meta data for various dimensions and loading of raw data also created load rules and calc scripts to clear the Hyperion Essbase applications.
• Created MS SQL Server 2008 SQL scripts and database objects in order to establish various environments such as development, test, and production.
• Developed several MAXL scripts to facilitate the ETL processes of loading and/or clearing of Hyperion Essbase applications.
• Created and/or developed Smart Views in order to test and validate the loading of raw data into the Hyperion Essbase application.

Confidential

• Served as a Senior MS SQL Server Database/SSIS Developer in the development of a reporting datamart that capture information such as client positions, taxlots, accounts, transactions, securities, and margin.
• Performed source-to-target mappings, developed database objects i.e., Tables, Views, Procedures , and ETL processes to establish daily extraction from source systems.
• Developed Control-M jobs to ensure daily refresh of data.

Confidential

• Served as a Senior Business Intelligence Solution Architect on two separate projects, corporate loans and investment services
• Conducted interviews with various business users in identifying and capturing business requirements defined and developed project scope/plan.
• Created and developed two separate multi-dimensional data model using the Ralph Kimball methodology performed source-to-target mapping and deployed both data models in an Oracle8i environment including scripts and procedures for production migration added several subject areas to the initial warehouse after several years
• Constructed two separate ETL batch processes using MS SQL Server 2000 Data Transformation Services DTS which also included ActiveX Script and Oracle PL/SQL development converted existing DTS packages to SSIS 2008
• Initially created and developed a custom analytical application using MS SQL Server 2000 Analysis Services for the investment services and after a year migrated solution to Business Objects Enterprise BOE XI R2 reporting platform create migration procedure for installing and configuring BOE in a production environment performed BOE software upgrade and patch installation in the development environment
• Created and developed BOE Web Intelligence reports trained business users in how to navigate through BOE Info View and creating and accessing reports

Confidential

• Served as a Data Warehouse Architect in the enhancement and development of an SAP Business Warehouse application.
• Conducted interviews with business owners, SMEs, and technical staff in capturing and understanding business requirements, and defining project scope.
• Performed detail data analysis of both data elements requested by the business and data sources IMS and SAP R3 , and documented data source definition, source-to-target mapping, and logical structures for the data warehouse/mart.
• Translated business requirements into a multi-dimensional data model to support the Billing/Invoice Data Mart using the Erwin tool.
• Communicated and/or provided knowledge transfer to consultants SAP BW Developers , both on and offshore, in the development and support of the project SAP BW .

Confidential

• Served as the Lead Business Intelligence Architect in the enhancement and development of an enterprise business intelligence application for the automotive services.
• Designed and developed multi-dimensional data models star schemas created scripts and database objects in a MS SQL Server 2000 and Oracle8i environment.
• Performed source-to-target mappings, storage capacity planning, and developed ETL processes for the initial load and incremental updates using the Oracle Data Integrator tool formerly called Sunopsis.
• Provided additional support and maintenance of the Cognos EP Series 7 reporting environment, which included catalog changes and enhancements, report creation, and publishing of reports over the Intranet.

Confidential Senior Data Warehouse Architect EMPLOYEE

• Served as Senior Data Warehouse Architect in the development of a custom analytical application for the trading and risk management in the energy/commodity marketplace.
• Developed the multi-dimensional data model star schema that integrated various subject matter data cubes Profit Loss, MTM, Exposure, Cash Flows, Impacts, etc. from an Endur application.
• Created databases in both Oracle8i and MS SQL Server 2000 developed the ETL processes using MS SQL Server 2000 DTS and Oracle PL/SQL.
• Built several cubes under MS SQL Server 2000 Analysis Services developed the web application using FrontPage 2000 and MS Office Web Components.

Confidential Data Warehouse/Database Manager EMPLOYEE

• In addition to the Database Manager role, served as a Project Lead and Business Intelligence Architect in the implementation of a web-based Enterprise Customer Relationship Management eCRM reporting application which integrated customer data from various enterprise channels web clickstream, catalog, retail, etc. in providing various executives from key business area with a consistent view of the customer enterprise data most importantly, the planning, execution, and measurement of the effectiveness of marketing campaigns and website navigation.
• Conducted requirement analysis with key business analyst in developing requirements and solution definition created project plan and managed up to three resources to successfully meet delivery milestones designed and developed the dimensional data model star schema created the logical and physical structures of an Oracle8i database in a Sun Solaris environment developed the ETL processes using Oracle PL/SQL, Perl, and Informatica.
• Provided additional support and maintenance for several Essbase applications, including the creation of new outlines, load rules, and calc scripts, and supervised three resources in the daily operation of several corporate Oracle applications.

Confidential

• Served as a Decision Support Analyst in the deployment of a web-based enterprise business intelligence application.
• Installed and configured the Cognos software, including Cognos Impromptu and Powerplay Web Reports, and MS IIS under MS Windows NT environment designed and developed various impromptu and powerplay reports performance, status, and Ad Hoc setup security LDAP and automation the reporting environment.

Confidential

• Served as the Lead Decision Support Analyst and Oracle Developer in the deployment of an enterprise business intelligence application to support the business processes Order Management, End User Billing Detail, Carrier Services, and Products of CGTI.
• Analyze and documented business data reporting needs created and developed a conceptual system blueprint assisted in the development of user training materials.
• Developed a multi-dimensional data model created database objects and data extraction scripts using Oracle8i native language PL/SQL , Pro C, Cshell, and SQL Plus performed database tuning.
• Installed and configured the Cognos software on a MS Windows NT environment created and developed the catalog, impromptu and powerplay reports.

Confidential Data Warehouse Technical Architect EMPLOYEE/CONSULTANT

• Successfully led a team of five members in the gathering of requirements, design, development, and implementation of a data warehouse/business intelligence solution for a client in the sports recreation industry.
• Assisted sales teams in responding to RFP, drafting technical solutions and presentations
• Developed and/or prepared conceptual system blueprint in delivering enterprise data warehouse architecture resource and capacity planning evaluation and selection of technical components
• Worked closely with various project managers in defining project tasks and/or activities, including resource coordination, status tracking, and communication of project progress and issues.
• Installed, configured, and implemented an Oracle Optimal Flexible Architecture OFA compliance database to support the Profitability Reporting Facility PRF application in a Sun Solaris environment for a client in the financial industry determined initial table size and aggregation, partitioning, indexing, backup and recovery strategies.
• Directed and guided a team of three members in the architecture and implementation of an Oracle database exceeding a Terabytes in size on a Sun Solaris and EMC environment established various development, test, and production environment performed software and patch updates Implemented standard naming convention for database objects and version control.
• Designed and developed multi-dimensional data models star schema using Erwin and Powerdesigner to support various key business activities sales, marketing, inventory, procurement, accounting of an organization.
• Modeled and built multi-dimensional applications using Cognos and Business Object products.
• Provided additional project support and maintenance of an Electronic Order Entry EOE web-based application on MS IIS using MS Site Server and SQL Server for a client in the consumer product industry enhanced and developed HTML, JavaScript, and Vbscript source code using MS Developer Studio97.

Confidential Data Mart Architect/Database Developer EMPLOYEE/CONSULTANT

• Designed, developed, and implemented a three-tier client/server application that consisted of a Decision Support System DSS for a client in the computer hardware industry printing imaging equipment .
• Assisted the project manager in defining project tasks and/or activities, including resource coordination, status tracking, and communication of project progress and issues.
• Performed detail data analysis source-to-target and developed a multi-dimensional data model using ERWIN translated the multi-dimensional data model into physical table structures in Oracle, which included script creation.
• Installed, configured, and implemented Oracle Optimal Flexible Architecture OFA compliance databases in a Unix environment determined initial aggregation, partitioning, indexing, backup and recovery strategies.
• Constructed and automated the extract, transformation, and load processes from the source-to-target using Oracle native language PL/SQL , ODBC, Pro C, Cshell, and SQL Plus.
• Installed and configured the Essbase software in both development and production environment
• Built several Essbase applications to store client's financial data development included building multi-dimensional database outlines, rules for loading data, scripts to calculate data, scripts to generate reports, and a comprehensive user group security strategy.
• Provided additional support in the integration of various components of the development of a C application, evaluation and acquiring of new installation software for productivity enhancements, and functional and/or technical support of an MS Inter-application Visual Basic, Excel, and Access .

Lead OLAP Developer

• Architect and developed a Decision Support System DSS in a two-tier client/server environment that integrated data from various databases MS SQL Server, AS/400 and OS platforms OS/2, Windows NT, IBM 3090, and OS/400 for a client in the health care product industry Improved product performance and reliability, reduced data duplication through increased sharing, and flexible architecture for scalability.
• Designed and developed several Essbase applications to store client's financial, marketing, and sales data development included building multi-dimensional database outlines, rules for loading data, scripts to calculate data, scripts to generate reports, and a comprehensive user group security strategy.
• Built a menu driven Graphical User Interface GUI using Commander Builder EIS for end-users analysis in a Windows environment.
• Provided additional support in the installation and configuration of package software for up to 50 end-users trained end-users on the navigation and operation of the GUI, and created a How-To document for end-user references.

Lead Application Developer

• Developed, tested, and implemented a batch application using Borland C/C in a windows environment that calculated the required reserve for all customer policies for a client in the insurance industry provided a cost saving to the client in the amount of 30K a month.
• Built an OWL application interface from scratch using Borland C/C that allowed various client personnel to view insurance premium in an easy-to-use presentation.
• Provided additional support in the design and development of reports using EasyTrieve Plus and Cobol II, and retrieval of customer data from an IMS/VS database development was done under ISPF MVS/ESA environment using Panvalet as an editor and XPEDITOR for the debugging of all Cobol II applications.

Confidential Application Developer EMPLOYEE/CONSULTANT

• Designed, tested, and implemented several distributed processing programs using Advance Program-to-Program Communication APPC for a client in the utility industry. The distributed processing programs allowed customer service orders to be sent and received from a Mobil Telecommunication application, thus allowing Field Personnel to view customer service order on their PC Radio laptops .
• Programs were created using Cobol CICS, Microsoft C, and Vermont Views in a IBM 3090, IBM OS/2, and MS/DOS platform environment.
• Provided additional support in the enhancement and development of the Mobil Telecommunication application using Turbo C/C in a MS/DOS environment.

Confidential Lead Application Developer CONSULTANT

• Coordinated and implemented an Information Delivery System IDS for the technical support department. The IDS allowed field technicians remote access to data from a portable terminal.
• Conducted requirement analysis with various department managers and field technicians developed and administered a DB2/2 database application under an OS/2 environment.
• Developed the programs using RF Communication, EHLLAPI, and IBM C Set/2.

Confidential Programmer/Analyst CONSULTANT

• Designed, developed, and implemented an inventory and automation tracking system under a Wang 100 system
• Interviewed and documented user requirements documented How-to user guide and trained end-users.
• Constructed the logical and physical layout of the database coded programs to load the database and developed the graphical user interface.
• Programmer/Analyst
• Designed, developed, and implemented a recovery application using COBOL under TSO/ISPF and using PANVALET for an editor recovery application ran on an IBM 4381 MVS/XA .