PROFILE:

• I’m a Senior Solutions Architect with specialties in Strategic Planning, Corporate Performance Man - agement, Financial Planning, Credit Risk Analytics, Business Intelligence, Data Warehouse & Master Data Management.
• I have demonstrated a proven ability to effectively communicate with all levels of management and lead complete project life cycles.
• Throughout my IT architect career, I have led dozens of business intelligence & analytic projects for clients in the financial services industries.
• Building models for M&A, Real Estate, Credit, Financial & Operational Risk.
• I continue to be involved with every phase of the life cycle development, including managing, feasibility studies, design, and planning for large and medium business intelligence projects.
• I have an extensive Pre/Post technical sales back-ground and have used a Consultative Sales Approach to win opportunities.
• I am detail oriented and committed to delivering superior quality work.

EXPERIENCE:

Sr. COGNOS Business Intelligence Data Warehouse Architect \Admin Consultant

Confidential

Responsibilities:

• I have installed, configured, integrated, customized & supported Cognos Analytics BI 11.0.13 & Cognos Planning Analytics 2.0.6 TM1.
• This was in a multi-server enterprise environment & included Deltek Costpoint integration.

Sr. Business Intelligence Data Warehouse Architect \Admin.

Confidential, Coppell, TX

Responsibilities:

• I lead and mentor a group of 5 developers in the Business Intelligence Data Warehouse group:
• Implemented the Confidential Cognos TM1 Strategic Finance System.
• This enables users to evaluate their success in meeting goals over multiple years with a reliable consistent modeling tool with the following capabilities:
• Facilitates long-range strategic planning over a 10-year period, Evaluates the impact of multiple strategies.
• Allows for personalized comparison and analysis of what-if, evaluating internal or external growth opportunities, Enables merger and acquisition (M&A) planning, Provides an assessment of the current portfolio for analysis, and impact of divestitures, tax and credit rating impacts, consolidated financial statements with distinct views for base growth, acquisitions and divestitures, Integrated workflow and process management, Web-based deployment of models for data collection and consolidation, Functionality for strategic target setting, mergers/acquisitions/ restruc-tures, asset management, cashflow management, KPIs and financial/non-financial planning.
• Integrated with Confidential Cognos BI System for reporting & dashboards using quantitative & qualitative analysis.
• Defined the strategy & direction for implementing Cognos Confidential On-Prem & Cloud solutions.
• Administer & Support 100+ users of Confidential Planning Analytics 2.06 for the office of Finance.
• Administer & Support 250+ users of Confidential Cognos Business Analytics in an Enterprise Dis-tributed Environment.
• Design Cognos TM1 OLAP Cubes for Multidimensional Modeling.
• Design, develop, and implement Confidential Planning Analytics 2.06 Applications for Financial Planning and Budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from data-base tables and other data sources, for creating dimensions, hierarchies, and cubes. Utilizing Turbo Integrator to integrate business logic to load data into various cubes.
• Performed ETL from MS Dynamics NAV & Workday.
• Experience with MS SQL Server 2016 Tabular & Multidimensional implementation in On-Prem & Azure Cloud.
• Experience presenting to senior management how our corporate plans align with the budget & corporate strategy to achieve corporate objectives.
• Install, configure and manage the Cognos BI 10.2.2, 11. 0, TM1 10.2.2, PA TM 2.06 upgrade in Development, QA & Production using an Agile project management methodology with weekly Scrum meetings to deliver the project ahead of schedule.
• Extensive experience in analyzing various Client Side and Server-Side Metrics.
• Experienced in working both Agile and Waterfall models.
• Strong knowledge of Software Development Life Cycle SDLC Quality Assurance QA Me-thodologies, especially correlation, custom coding and load analysis.
• Architected Cognos BI, TM1, Tableau, Confidential InfoSphere BigInsights (Hadoop), DataStage, SPSS, Netezza & Cassandra integration.
• Implemented Hadoop data pipeline to identify customer behavioral patterns, improving UX on e-commerce website.
• Perform big data processing using Hadoop, MapReduce, Sqoop, Oozie, and Impala.
• Import data from MS SQL Server to HDFS, using Sqoop to load data.
• Developed and designed multi Hadoop cluster for sample data analysis.
• Regularly tune performance of Hive and Pig queries to improve data processing and retrieving.
• Run Hadoop streaming jobs to process terabytes of XML data.
• Designed visualizations and reports for management using Tableau.
• Helped design workshops for Confidential Cognos Planning Analytics for Excel & Workspace.
• Architected Star Schema Data Marts in Oracle 11g using Oracle Data Modeler.
• Worked with AWS & Azure Cloud Services.
• Worked with SPSS software for marketing analytics, data mining & fraud detection.
• Built dashboards in Cognos & Tableau for Business Intelligence, Performance Management, Predictive Analytics, Fraud Detection & Risk Management for Loan Origination \Servicing.
• Using Talend MDM suite of tools - design, develop, optimize and support MDM processes, including performance tuning of existing processes.
• Manage the partnership with Data Integration Hubs around data modeling, data mappings, data validation, hierarchy management and overall security. Provide continuous enhancement and review of MDM matching rules, data quality and validation processes.
• Define, configure and optimize various MDM processes and stages including data ingestion/acquisition, standardization/enrichment, harmonization and data provisioning using MDM tools.
• Made presentations to senior management for project approvals, milestone review and completion acceptance.
• Advise on licensing and worked with the Confidential License Metric Tool for lower costs and improved ROI.
• Experience with reporting, predictive modeling, forecasting, portfolio management, regulatory submissions utilizing: SQL, MDX, SPSS, R & Python.
• Analyzes market data to identify trends and develop insights related to opportunities for Confidential, and then translates these into strategic operational plans.
• Business experience with emphasis on risk management, modeling, & operations strategy.
• Experience with decision engines and risk technology, credit bureaus, and other data providers.
• Highly experienced with Excel, including using Excel as a tool for financial analysis and I have a good understanding of financial modeling.
• Worked with Credit Risk Analytics using R, Python, SPSS & Cognos BI for reporting.
• Delivered analytical KPI presentations to CxO’s on Mortgages, Marking Campaigns, CPM, CRM etc.
• Implemented Cognos Customer Profitability Analytics in Banking system.

Sr. Business Intelligence & Data Warehouse Consultant

Confidential, Dallas, TX

Responsibilities:

• Experience in leading and managing projects that deliver complex IT Strategy and initiatives with tangible results, working across organizational boundaries, and interfacing with Senior Executives.
• Install & troubleshoot Confidential Cognos TM1 9.5.1 & 10.2 Server, Perspectives and Web.
• Created TM1 OLAP cubes from Oracle 11g, SQL Server 2012, MS Dynamics GP for use in Finance, Customer Service, Sales & Marketing, etc. for Telecom. Data was loaded from MS SQL Server Analysis Services (SSAS) OLAP Cubes, Relational Tables & MS Excel csv text files.
• Installed configured & integrated Linux, Apache, MySQL\MariaDB, PHP (LAMP Stack) for web based open source applications in Financial Services, ERP, Data Warehouse, Business Intelligence & E-Commerce.
• Built Excel Models for M&A, Real Estate, Credit & Financial.
• Created Excel Dashboards & Reports from TM1 Cube Slices for Telecom Analytics.
• Worked with SQL Server Integration Services (SSIS) to ETL from OLTP tables.
• Used SQL Server Analysis Services to build OLAP Cubes from OLTP tables. Established & designed process to use in memory TM1 OLAP, SSAS OLAP, Star Schema DW, OLTP DB created roadmap for optimum performance reporting and query with “Best of Breed” application.
• Worked with T-SQL & MDX to facilitate ETL & queries for reporting.
• Interacted with business users to analyze the business process and requirements and then transformed requirements into documented deliverables.
• Worked with Cognos BI & Framework Manger 10.2.1 to create a package from Maximo 7.5 & Oracle 11g.
• Worked with Credit Risk Analytics using SAS & Cognos BI for reporting.
• Assisted in the development of forecasting tools/models that will be used for projecting performance metrics on credit loss exposure and Loan Loss Reserve adequacy process.
• Conducted JMeter Load Testing to determine the number of concurrent users the system could handle.
• Working in the office of Finance I have installed TM1 9.5.2 with Oracle 10g integration for a Planning, Budgeting & Forecasting application. Implemented “Best Practices”, document ted system architecture, code & business rules.
• Worked with users to address and resolve problems. Provided solutions for dealing with very large data system. Performed ETL from JD Edwards, MS Dynamics GP & Oracle 10g.

Principal Consultant Data Warehouse Business Intelligence

Confidential, Dallas, TX

Responsibilities:

• Expertise in full life cycle Business Intelligence implementations and have an under-standing of all aspects of an implementation project using Cognos, Oracle, DB2, SQL Server
• Designed architecture for “Best Practice” integration with Cognos BI, Confidential DB2 Analytics Accelerator z/OS and Confidential PureData for Analytics (Netezza) for high performance scenario-modeling.
• Designed & created the processes, methodologies, KPI's, systems, reports & dashboards needed to measure and manage the performance of vertical industries.
• Using Confidential InfoSphere Master Data Management (MDM) suite of tools - design, develop, optimize and support MDM processes, including performance tuning of existing processes.
• Integrated Cognos BI with SAS to filter, extract, analyze & report on data for vertical industries.
• Managed the installation, configuration & customization of the Confidential Cognos TM1 Integrated Financial Forecasting and Planning Performance Management system.
• This enables operations to focus on plans while affording finance and senior management the visibility to ensure that operational plans are in sync with corporate objectives.
• The system establishes the targets and metrics used to measure organizational success. Response to changing business conditions is usually expressed as an updated forecast.
• As the forecast’s changes, integrated financial statements can be instantly updated to see the effect on key financial objectives such as DSO, Earnings Per Share, Return on Assets, Cash Flow Per Share.
• Establish relationships between profit metrics and cash flow requirements. Synchronize operational plans with integrated financial statements to understand their impacts on the balance sheet and cash flow. Model alternative business scenarios quickly to make optimal investment decisions.
• Installed, configured & integrated Banking and Financial Services Cost Transparency Performance System used for:
• Gaining continuous visibility of the drivers of cost and consumption of technology re Sources.
• Strengthen the partnership between technology and the business
• Enable decisions that support growth, maximize return on investment and sustain rapid cost savings
• Designed & created the processes, methodologies, KPI's, systems, reports & dashboards needed to measure and manage the performance of a organization.
• Designed architecture and integrated Cognos 10.1 Enterprise with Netezza, InfoSphere BigInsights ( Hadoop). Depending on the requirements for Big Data (Structured/Unstruc-tured) or reducing search times and optimizing performance in the Data Warehouse.
• Designed and taught Confidential Cognos 8 BI Technical Specialist test preparation class. This resulted in 100 % pass rate among participants.‎
• Conducted SWOT analysis (Strengths, Weaknesses, Opportunities, Threats) to identify and evaluate product and segment strategies, using qualitative and quantitative research.
• Conducted technical sales presentations, demonstrations, recommend new offerings & up sell current Professional Services engagement.

Sr. Business INTELLIGENCE, Data Warehouse & Storage Consultant

Confidential, Dallas, TX

Responsibilities:

• Delivered technical sales presentations for NetApp NAS devices.
• Managed the installation of SAN & NAS storage devices in Windows NT/2000, Sun & HP UNIX environments.
• Managed migration of Oracle 9i on JBOD storage to 10g on NAS in Win2k environments.
• Implemented a Professional Service Practice that specializes in Disaster Recovery/Business Continuity, Oracle & Microsoft SQL Server/Exchange on Network Attached Storage, Data Warehouse /Business Intelligence, backup/Restore Optimization and Business Process Re-engineering.

IT Data Warehouse Manager

Confidential, Anaheim, CA

Responsibilities:

• PeopleSoft Enterprise Performance Management 8.3 is integrated with Cognos Series 7 using StrategyPlus for Cognos this allowed for timely reporting, analysis, and delivery of information.
• Designed & implemented Oracle 9i Data Warehouse using Erwin Data Modeler 3.5.2.
• Worked with all departments accounting, marketing, human resources, operations etc. in the company to consolidate Excel spreadsheets and extract data from Oracle 9i. I used PowerPlay Transformer to build OLAP Power Cubes in a SAN storage environment.

Sr. Technical Account Manager

Confidential, San Diego, CA

Responsibilities:

• Traveled with prospective clients to the Confidential Partner Center at the Microsoft Campus in Washington for tours and presentations on Confidential & Microsoft integration.
• Developed & trained partners and sales associates in sales lead process that analyzed 10k reports, employment classifieds, and news postings to uncover prospective companies and contacts for enterprise storage hardware & software.
• Developed financial cost justification presentation based on risk analysis, downtime costs, server consolidation, software licensing. Then I related it to Balance Sheet and Income Statement for each individual company.
• Analyzed leasing agreement terms & conditions, run rates, residuals values and current equipment operational costs for upgrade marketing initiative for sales associates.
• Managed integration of Informatica PowerCenter, Oracle & TimeFinder BCV’s/ Confidential Symmetrix for ETL Data Warehouse project at SAIC.
• My team was successful in winning competitive “Bakeoffs” against NetApp, IBM, Sun, and HP, with 3 million in revenue in the first year and 5 million in the second.
• Member of the Confidential NT Advisory Council that investigates user needs, requirements and Best Practices. I then work with engineering to deliver timely solutions for Microsoft Exchange, Microsoft Clustered Server, SQL Server, Veritas NetBackup, Oracle, storage management, etc. in a SAN environment.
• As the Sr. Technical Resource for Confidential with specialties in Oracle & Microsoft SQL Server I am frequently called upon to manage and close opportunities where the sale is dependent on Confidential 's ability to solve operational issues.
• This entails SAN/NAS trade-offs, Business Continuance, Backup/Restore, Revision Upgrades, High Availability/Reliability, VLDB performance, ETL, and Data Warehouse creation.

Sr. Solutions Architect Data Warehouse Practice

Confidential, Palo Alto, CA

Responsibilities:

• Created Business Intelligence presentation around “24 Ways To Impact Your Bottom Line in 90 Days”.
• Which allowed us to go from the conceptual aspects of Data Warehouse to concrete results.
• Designed & implemented Data Warehouses in Oracle & Sybase.
• Worked with the team that integrated PowerCenter with PeopleSoft Enterprise Warehouse.
• Worked at Macromedia Cop. to manage and train a group of consultants in Informatica PowerCenter for a web-based data warehouse.
• Created a multi-dimensional data model using the Ralph Kimball methodology, performing source-to-target mapping and building database schema in an Oracle 8 environment including creating scripts and procedures for production migration and ETL batch processes for Siebel migration from customer data mart for General Electric Capital.
• PeopleSoft ERP extract to Solaris/Oracle Data Mart for Qualcomm.