SUMMARY:

• Highly accomplished, innovative Technology Leader with 15+ years of conceptualizing, architecting and directing development of global enterprise solutions, enterprise data warehouse and business intelligence solutions, eCommerce and core business systems for companies such as Confidential .
• Excellent communicator, partners with C - level executives internally in setting strategic goals and leads global teams to achieve results. Outstanding background in team building, integration and in managing global IT teams and vendors while retaining knowledge and IP within company.
• Increased Gross Profit by ~4% and Revenue by 100% for DRI via business intelligence, analytics, automation and process innovation. Enterprise scale implementations on diverse technology platforms.
• Strategic Analysis, Planning and Solutions ROI-focused Evaluation and Implementations

TECHNICAL SKILLS:

Management: Microsoft Project Plan, Jira, Waterfall, Agile, Scrum, Kanban, SDLC, Use Cases

Databases: SQL Server 2016/2012/2008R2/2005, Oracle 11g/10g/9i/8i, MySQL 5.1, 5.0, IBM DB2

DBA tools: Server Manager, SSMS, Replication Monitor/Manager, Standby Database, SQL*Loader, Export/Import, TSQL/SQL*PLUS, PowerShell, SQLCMD, RMAN, RAC, Idera, Spotlight.

Languages: T-SQL, SQL*PLUS, PL/SQL, Shell Scripting, UNIX Scripting, Perl, C, C++, C#, Java, HQL

O/S: Windows Server 2008R2/2008/2003, MS-DOS, UNIX (Sun Solaris 2.8, 2.7, 2.6 &2.5), Sun Clusters, HP-Unix 9.2, 10.2&11.0, AIX 5.1/4.3.3, Linux Ubuntu

Data Modeling: ERwin, Rational Rose, Visio, Database Diagrams

ETL: SSIS, Informatica (Power Center 8.5/7.1.2/6.2/5.1), IBM Data Stage, SAP BODI

Big Data: SSIS, SSRS, SSAS, SQLCMD, Power Shell, DTA, Profiler, Toad, PALO, Business Objects Hadoop (CDH/HDP), MapReduce, HDFS, Hive, Pig, Sqoop, HBase, Zookeeper, Flume, Spark

PROFESSIONAL EXPERIENCE:

Confidential, LA

Responsibilities;

• Spearheaded Strategic IT initiatives for COO, CCO, Director of Finance, Director of Operations, Director of Surveillance and their teams.
• Acted as VOC for Farmers, BRD and managed scope in addition to creating and reviewing artifacts such as Prioritized Inventory Backlog, BPM, Data Dictionary, HLD, LLD, LDM, PDM, Test Strategy and Plan, Best Practice.
• Managed all phases of strategic deployment of FFS Data Remediation Project to replace legacy broker commissioning system with enterprise application database.
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Documented end to end Business Process Flow and conducted Value stream mapping analysis as part of process modernization effort.
• Aligned teams on purpose while operating in a multi-vendor environment.

Confidential, MO

Data Migration Lead/ IT Consultant

Responsibilities:

• Conducted data migration review and feasibility study for NDBH MDM systems to Facets.
• Created and presented Solution Vision document artifact clarifying scope of HCA Phase 1 implementation for different domains.
• Interviewed client and internal teams clarifying solutions, risks and opportunities.
• Created strategic questionnaires for Providers, Members, Authorizations, Accumulators, Fee Schedules and Claims.
• Developed various go-live strategies and clarified to team overall strategic objective.
• Conducted Data mapping and involved in crosswalk sessions.
• Involved in leading TZG Facets team in performing successful data migration.
• Prepared Data Conversion Questionnaire, Cutover Strategy & Data Migration Assessment artifact from group interview with client and internal team.

Confidential, FL

Project Manager/ Sr. Architect

Responsibilities:

• Designed and Built in record time Spend Analytics Data Marts for tracking and analyzing the cost (“spend”) of purchase orders across the organization for maintaining a healthy profit margin.
• Consumed data from Data Lake for 3 Regions (North America, EMEA, Asia) via External tables and ingested data into APS Spend Analysis Data Marts.
• Architected, Reviewed and Coordinated all aspects of APS code development and deployments.
• Client interfacing role and managed perception and client relationship.
• Managed and coordianted Hadoop and APS teams.
• Worked closely with teams in identifying data source, data format, data hygine and scheduling.
• Provided LDM, documentation and deployment kit to client as part of deliverable.

Confidential

Delivery Manager/ Sr. Architect

Responsibilities:

• Managed overall delivery and architecture of CIT data remediation initiative
• Prepare project roadmap, scope definition, project schedule, RFP responses, contract SOW, WBS, and RAID log for OWB’s FIS-BDM data warehouse program.
• Monitors and controls project schedule/budget, communication with stakeholders, and reporting project status to executive leadership both internally and externally
• Analyze current data architecture and recommend Enterprise Data Warehouse Implementation
• Mentored and trained the team on executing projects in Agile, Scrum, Kanban. Spanning projects distributed across the coasts.
• Designed Star and Snowflake Schema’s using Kimball methodology.

Confidential, Greensboro

Project Manager/ Sr. Architect

Responsibilities:

• Managed projects by developing implementation plans and timelines, providing weekly status reports, preparing technical documentation pertaining to various projects, exchanging relevant information with management and technical teams, and meeting timelines established.
• Analyze current data architecture and recommend Enterprise Data Warehouse Implementation for Paper Claims and Health Care Analytics team.
• Manage and streamline teams to increase productivity and align with Stakeholders and Vice President’s vision of final product.
• Identified suitable facts and dimensions for Confidential, maintained Confidential Enterprise Data Warehouse and Data Marts.
• Involved in Logical and Physical Data Modeling, designed Star and Snowflake Schema’s using Kimball methodology.

Confidential, Los Angeles, CA

Manager/ Database Administrator

Responsibilities:

• Monitor the performance of production databases, implement database mirroring, improve db clustering, and make tuning changes as necessary to ensure optimal performance
• Ensuring the data availability through backup and restore process, log shipping, replication and other available methodologies
• Responsible for reviewing designs and deployment of any data objects from development/staging to production
• Coordinating with offshore and near shore dba team, providing effective handover of tasks, effective communication among teams with details on changes made, information on activities, daily health check/alerts in Oracle Grid (OEM).

Confidential, Manhattan Beach, CA

Manager/ Data Warehouse Architect

Responsibilities:

• Directed and controled the activities related to data planning and development, and the establishment of policies and procedures pertaining to management, security, maintenance and utilization.
• Maintained Fedral Credit Union’s Enterprize Data Warehouse and Business Intelligence Solutions providing pilot initiative geared towards providing core business needs with accurate and concrete metrics.
• Provided Member segementation to Marketing team to leverage member investements portfolio with KFCU.
• Identified suitable dimensions and facts for Confidential .
• Created Star and Snowflake schemas for Federal Credit Union using Kimball methodology
• Maintained and administered ODS, Archival and Stageing environment.
• Managed projects by developing implementation plans and timelines, providing weekly status reports, preparing technical documentation pertaining to various projects, exchanging relevant information with management and technical teams, and meeting timelines established.

Confidential, Van Nuys, CA

Manager/ Data Warehouse Architect

Responsibilities:

• Architected and Managed Data Warehouse for companywide reporting needs.
• Developed Self Services BI Solution for Marketing, Production, and Sales departments providing visibility into systems with Strategic, Tactical and Operational metrics.
• Created Tracker db to track customer and visitor website usage.
• Provided Cohort Analysis and CLTR by Channel and Product Segmentation.
• Gathered end user requirements from CEO, COO, CTO, VP, Marketing Director, Product Manager, Marketing Managers, Shareholders, and Strategic Planning and Analysis Managers.
• Provided forecasting metrics including AOV by Channel and Product, Transactions, Conversion Ratio, Customer Engagement, Churn Rate, New vs. Returning customers, Monthly Sales Metrics,
• Provided Frequency, Recency, Monetary Value and Repeats metrics including Time Between Orders by Order Number, Time Between Orders by Order Date, Repeat Purchase Probability, Average time Between Orders, Big Spenders with no Orders Last Year, AOV by Order Number.
• Provided Quote and Samples metrics including Average Quote, All time Samples, All time Average Quote.
• Provided Cohort Analysis including Sales Cohort Analysis, Transacting Customers Cohort Analysis, LTR Cohort Analysis Annual, Orders Quarterly Cohort Analysis, Orders Monthly Cohort Analysis, and Average Sales Quarterly Cohort.
• Provided insight into Customer behavior and value; providing Reports on New Customer Accounts, New vs. Returning Transacting Customers, LTR by 1st Order Date, Order by New Customers, Top Spenders in past 12 Months, All Time Average LTR, Top Spenders All Time, New Customer Accounts, Transacting Customers, Time between Orders, top Spenders in the last month and Total Customer Accounts created.
• Delivered Product specific metrics measuring Sales by Product Category, Top 100 Categories by units sold, Unit sold trend, Top 100 categories by Sales, all time Sales by print Type, Units Sold by Selected Print types, Sales by selected Categories, and Sales by print Type.
• Provided SSAS Cubes via Http to end users and Dashboards, KPI's and Scorecards on SharePoint.
• Created Star and Snowflake schema for Digital Room Data Warehouse encompassing over 20 Websites.
• Developed Product Cross Selling functionality for Market Basket Analysis.

Confidential, Sacramento, CA

Sr. Database Administrator/Developer

Responsibilities:

• Performance tuning at various layers including Data Model, Query Tuning, Index creation and maintenance, Hardware and network layer.
• Provided 24x7 Production Support.

Confidential, Monroe, LA

Data Warehouse Architect/SQL Server Database Administrator

Responsibilities:

• Responsible for the centralized data warehouse solution to provide organization with one consistent data view for companywide reporting and analytical needs.

Confidential, Monroe, LA

Data Warehouse Architect/DBA/Developer

Responsibilities:

• Conceptualized and set up the reporting environment, Architected Reporting solution within very short deadline contributing to a successful Confidential .
• Received an Award from Confidential Insurance for the key contribution, exceptional commitment and value to the company’s successful Confidential on August 2010.

Confidential, Fort Worth, TX

Data Warehouse Architect/Database Administrator/Developer

Responsibilities:

• Identified suitable dimensions and facts for Confidential .
• Maintained Confidential Enterprise Data Warehousing and Data Mart Databases.
• Involved in Logical and Physical Data Modeling.
• Designed Star and Snowflake Schema’s using Kimball methodology.