Full360 cv
Full 360 Major Projects Link to heading
Shortlist
| Customer | What I Did | What Was Delivered |
|---|---|---|
| 3Com: Santa Clara, CA | Salesforce Automation – Trial Weekly worldwide product sales analysis. SFA for 1200 users worldwide. Multiple front-ends design – Excel, Lotus, Analyzer, Avantgo Server /Palm integration using Hyperion Spiderman. Extended POC management and design win over 2 competitors | Won 8 week trial for $1.5 million deal. |
| SLC Construction | Design & development of cash-sensitive planning & reporting model for construction & real-estate contractor. Solomon integration. Large number of driver based metrics and KPIs | Reverse engineered Solomon ERP |
| Cingular Wireless: Alpharetta, GA | Store Level P&L – Multiple ERP Built Store & Channel profitability on 5000- member COA. Integrated store attribute dimensions. Sourced from Oracle Financials - One World. Oracle - Teradata backends. Extensive scripting and automation of replicated partition maintenance. | Implemented in record time, < 6 weeks. |
| Cleveland, OH | Large Scale Migration – Systems Inventory High level coordination of large upgrade to System 9 and migration of 100- Essbase databases. Custom scripting for transfer of native security to multiple LDAP external authentications via Hyperion Shared Services CLI tools. | Rubric Based Mgmt |
| I2 Technologies Las Colinas, TX | Supply Chain Analytics – Custom Models Custom data integration with Rhythm suite for SCM analytics product prototype. Reading of supply chain BOM. Investigation of CORBA interfaces. | API Level analysis, PhD customers |
| Men’s Wearhouse Houston TX | System Performance Review – Strategic Technology Extensive assessment for strategic upgrade & cross-platform migration of 25- Essbase databases and associated reporting systems. Established use case and produced weighted recommendations for performance & reliability. | All analysis, end to end. Systems review. |
| Boeing Federal Way, WA | Global Project Planning – Massive Scale Global engineering project-based cost management system. Custom built Essbase designs for 64bit Superdome application with full .NET smart client custom design. RFP winning design over 15 competitors. Designed for 5000 concurrent users on 17,000 financial models. Extended POC coordinated with multiple partners including HP Cupertino & Applied OLAP. | Las Vegas Presentation, Applied OLAP |
| Nissan: Los Angeles, CA | North American Regional DW Planning – ETL Coordination Total 34 Essbase databases, 17 under Hyperion Planning Near realtime asynchronous DW ETL interface for multiple Essbase datamarts. Five timezones. P/L , B/S, others independent. Intercube data transfer plus rerouting of Essbase data back to DW. IBM Regatta / DB2 UDB plus Informatica backend with custom ksh & perl integration with MAXL. | Complex SLA, workflow |
| Qantas: Sydney AUS | Flight Operations - Transaction Re-engineering Ingested legacy transaction & VLDB systems to support generation of complex metrics associated with fuel consumption, pilot fatigue. Regulatory compliance with work-rules design established in the new system. Columnar DB, AWS data migration. Near realtime processes. | Realtime & Wide data, |
| Coca Cola: Atlanta GA | High Dimensionality – Customer Sampling 16 Dimensional model on consumer buying and consumption pattens. | Deep analytics |
| Rockwell Rocketdyne: Canoga Park, CA | BOM Inventory – Custom built hierarchical model for ISS launch package inventory. Weight calculations for all subsystems. | Space Shuttle |
| Hot Topic: Industry, CA | Retail Loyalty – VB Integration Built integrated POS reporting system distributed daily from all store locations to managers. | Custom VB API |
| Qantas: Sydney | FRMS – Waypoint Navigation | |
| Toyota: Los Angeles, CA | Essbase - OracleDB Integration OLAP - DW drilldown integration. Spec’d ODS for Olap drillthrough Added new security for DW detail. Resolved timeout issues across network & queries. | Network timeout troubleshooting, security limitations, ODS Optimization |
| BCBS: Providence, RI | Capitation Analytics Essbase datamart design to track diagnosis, doctor, prescription. | First such system in BCBS |
| Hines: Houston, TX | REIT - Rescued broken database missing backups. Reorganized functional staff procedures. Implemented new backup & security procedures. | Excel-based spaghetti, no security. |
| Guess: Los Angeles, CA | Cluster Availability Increased reliability adding Raft-based service discovery service mesh. Instrumented observability, Performed database optimization, load metrics. Rid NFS backup. | Five Vertica clusters, US - Japan. |
| Teva Pharma NYC | Database Performance & Migration Performed all DBA functions for multi-schema datamodel including Veeva, S3 based customer submissions, query performance monitoring & tuning, QA -> PROD, daily multistage ingestion & transformation, salesforce integration. | Massive complexity |