SUMMARY:

• 17+ years of corporate IT Data Systems experience, all in USA
• 13+ years in Enterprise Data Warehouse and Business Intelligence environments
• 4+ years as Data Warehouse Manager
• Expert hands - on Data Warehouse Architect and back-end systems Administrator
• Extensive work in large-volume disparate enterprise-wide systems of up-to 34 terabytes
• Seasoned working in Oracle and in Netezza Data Warehouse appliance environments
• Wide gamut of industries’ experience: Construction, Healthcare, Telecommunication, Retail and Service
• Strong advanced engineering background with multiple end-to-end SDLC and products’ experience
• Blend of expertise in traditional Databases (RDBMS), Data Warehouse appliances (MPP), and trained in emerging technologies of Big Data (Hadoop)
• Proven ability working with technical teams and business stakeholders

SKILLS:

• Building, maintaining and administering large-volume EDW/BI environments
• Data Modeling, Data Architecture, Database Designing, and building Data Marts
• Enterprise Information Integration, ETL setup and management
• Leveraging SQL expertise for Data analysis, movement, processing and transformations
• Netezza Administration (Netezza aka IBM PureData System for Analytics)
• Using UNIX tools and Shell scripting
• Working with multiple RDBMSes, ETL-DW-BI tools and ancillary products
• Visionary, with deep problem solving skills to conduct root-cause-analysis

SYSTEMS:

Databases and DW: Oracle, Netezza, TeraData, SQL Server and Informix

ETL and BI Tools: SQL, SAP Business Objects, IBM DataStage, and Cognos

OS and Platforms: UNIX/LINUX/AIX; IBM, HP, Siemens-Pyramid and VMware

Others: Toad, ERwin, Hadoop ecosystem, JDE data, Impala, Hive, Aginity, Tableau, Nagios, Ganglia, EPIC/Clarity data, ER/Studio, Cognos Report Writer, Perl, Version Controls, Schedulers, DB2, JIRA, Visio and MS-Office products

EXPERIENCE:

DATA WAREHOUSE ARCHITECT

Confidential, Raleigh, NC

Responsibilities:

• Played a pivotal role of a traditional Data Warehouse Architect in the BI-team, to create from scratch, an Enterprise Data Warehouse platform (Oracle 12c) based on Kimball’s Dimensional Modeling principles. Major activities included: analysis of data from multiple sources (primary: JDE, the ERP system), Data Modeling (ERwin 9.4), Bus Matrix, Source-To-Target mappings, Data Integration, Conformed Dimensions, considerations for Master Data and Meta Data, creating Data Stores and Data Marts, defining Data policies, ETL guidelines, capacity planning and Database Design and Implementation
• Performed typical Oracle DBA support tasks for the ETL and Reporting teams, all working towards department key objective to enable business users with new standardized reporting, self service ad-hoc capabilities (Cognos 10) and Dashboards/Visualization (Tableau 9.3) of their data of various subject areas like: Sales, Finance, Accounts Receivable, Ready-Mix Plant Operations, Safety, Inventory and the like
• Designed and Developed PL/SQL scripts and Oracle stored procedures to ETL/populate production data from source to the Star-Schema in Facts and Dimensions for the POC-Data Marts, prior to full scale ETL development
• Provided insights, options and recommendation to upper management, to assist with architectural decision making for the new Enterprise Data Warehouse Platform using: (a) pre-existing Hadoop (Cloudera 5) infrastructure and (b) traditional Oracle RDBMS and SuperCluster possibilities. This effort entailed analysis and inter-team discussions reflecting against factors like: existing tools, resource and products costs, volume and nature of expected data, life of the data from absorption to delivery, feasibility of daily ETL data ingestion and performance, and to fit in the overall goal to build a robust corporate platform, the right way
• Additionally, conducted several interviews (Data Modeler, DataStage, Cognos, Tableau) and regularly interacted with management at various levels for planning sessions for short-term and long-term objectives. Interacted with business users specific to their subject-areas, and did presentations and interfaced with wider user group in workshop and demo-format

DATA WAREHOUSE SOLUTIONS CONSULTANT

Confidential, Dayton, OH

Responsibilities:

• Assisted in decommissioning efforts for the client’s Netezza (6.0) and Cognos (10.2) environment, focusing on (a) data migration from Netezza to TeraData, and (b) analyzing data models and SQL queries for a set of BI-Cognos reports

DATA WAREHOUSE SOLUTIONS CONSULTANT

Confidential, Winston Salem, NC

Responsibilities:

• Performance evaluation and tuning of the client’s Netezza (7.1) EDW/BI environment comprising of two appliances (N1001 TwinFins).
• Assessed, recommended and made changes for improvements related to SQL query performances, database designs, security, database tuning, system monitoring, Confidential -strategy, BI-Cognos user issues and Netezza best practices
• Designed, developed and deployed processes using korn shell scripts, Netezza SQL and utilities on LINUX platform, for database migration processes and overall system administration for environment hosting 30+ Netezza databases with 5+Tera Bytes of EPIC / Clarity healthcare data

DATA WAREHOUSE (Netezza) ADMINISTRATOR

Confidential, Ridgeland, MS

Responsibilities:

• Enterprise Data Warehouse support and Netezza administration to maintain a dynamic and complex large volume data feed environment on multi-platform Netezza appliances comprising of N2001 Striper and N1001 TwinFin configurations. Maintained environment of 200+ databases totaling 34 terabytes handling tables of up-to 70 billion rows using Netezza (NPS 6.x, 7.x) SQL and tools, UNIX shell scripts (ksh, bash), SAP Business Objects Data Designer (3.1, 4.2) and Oracle (10g, 11g) PL/SQL. Managed databases, users, backup-restores, troubleshoot issues, interacted with IBM-Support and various cross-functional teams, performance tune, upgrade, and other DBA matters at SQL, database and server level
• Analyzed, designed, developed and maintained ETL processes using SAP Business Objects Data Designer, Netezza and Oracle SQL and shell scripts. Worked closely with key clients like Analytics, Marketing and Reporting teams and supported them for processing and data extracts (including Call-Data-Records) from DW, with delivery for their initiatives involving Customer Insights, Churn Propensity, Campaigns, CRM projects, Centralized Reporting, Dashboards and Predictive Analytics
• Spear headed planning, analysis, design, development and execution of a major production Data Migration IT project, for 8+ terabytes of 20+ data store and data warehouse databases, from Netezza TwinFin to Striper platform. Coordinated with all the stakeholders: business, technical and application teams for execution of the project, balancing between the necessary outages and the re-defined SLA’s
• In 2014, C Spire was ranked 35th in the nation by InformationWeek Elite100, in its work in developing and implementing an innovative customer-analytics product called PULSE. Key team members for Master Data Management (MDM) and part of the core-team from ground-up in creating the Single Customer View, for this highly visible near real-time product, used in Decision Support System interfacing customers
• Mentored within and across teams with database matters and worked with off-shore resources for processes maintenance and issues resolutions

Sr. BUSINESS INTELLIGENCE ADMINISTRATOR

Confidential, Jackson, MS

Responsibilities:

• Designed, developed and maintained TeraData ( Confidential ) SQL processes to handle company wide transactional Sales and Financial data into multiple backend databases of size 500+ gigabytes
• Developed and maintained multiple Cognos (8.4,8.2) Data Models and Reports, using BI tools: Framework Manager, Report Studio, Query Studio interfacing with backend databases in TeraData, Oracle, SQL Server and DB2, servicing 1,000+ reports for hundreds of users
• As part of a major performance tuning objective, redesigned and de-normalized TeraData tables and reengineered batch SQL processes, which resulted in reducing run time for a set of complex end user Cognos reports from 1 to 2 minutes, to 10 to 15 seconds
• Briefly assisted ETL-team with deciphering a set of IBM DataStage (Enterprise edition) jobs and UNIX shell scripts, which handled nightly data integration and parallel loading of transactional data from Oracle source systems into TeraData

DATA WAREHOUSE MANAGER

Confidential, Memphis, TN

Responsibilities:

• Managed a DW/BI-team to maintain and support primarily a SQL Server (2005, 2000)-Windows based environment: its databases, products, tools and overall technical matters
• A hands-on-SQL-intensive Managers role, interacting with millions of rows of data spread in multiple databases of size up-to 500 gigabytes in OLAP SQL Server/Windows, and accessing OLTP in Informix/UNIX environments. Managed multiple projects, from planning to development and deployments, including defining information flow and designing database schemas with Relational and Star-schema implementations
• Led the data architecture, analysis, design, development and maintenance of backend-tailored extraction processes (ETL) to pull ongoing enterprise-wide data from disparate sources to coalesce in a hybrid-data-model for reporting and analytical purposes touching SQL Server and Informix (10)/UNIX environments
• Led the analysis, design, development and maintenance of BI-Data Mart for data from multiple enterprise clients like: Revenue-Analysis, Market Research, Business-Travel/Sales, Brand Performance, and Distribution. System implemented using e.Piphany, a Star-schema based BI product. Partnered with multiple teams and external Third party vendors for information sharing and Proof-of-Concepts. This was the first such BI-product at Hilton using customer profiles and CRM transactional data
• Following a corporate merger, analyzed and consolidated the master data between the two disparate data systems to form a common MDM for the unified brands. The project included deciphering the underlying different flavors of data and eventually collapsing the Guest profiles and attributes, Brand Data, Employees information and Business Accounts, using tailored scripts and modifying surviving production ETL processes
• Over the years extracted and analyzed numerous business case studies like Customer Segmentation, Customer Behavior, ROI, Service Recovery, RFM, Market-Basket Analysis, Survey Studies, KPI, Trends/Volume, Same-Store Sales, etc. using rudimentary to advanced techniques
• Played a central role in re-engineering reporting for Business-Travel/Sales department that simplified and improved volume tracking and reporting. This cost-effective highly visible internal IT-solution led to an improved alliance between IT and business-community
• Compiled training sessions for developers, architects and leads within department.

INFORMIX DBA

Confidential, Memphis, TN

Responsibilities:

• Played a versatile role of DBA and systems analyst for this mostly batch-processing legacy CRM and Marketing system in Informix (7)/UNIX on Siemens-Pyramid hardware, running hundreds of reports
• Supported and managed Informix products, table and index maintenance, database space, capacity planning, code reviews, code migration, designed and developed scripts, coordinated with operations team, system administrators and other cross-functional teams for environment/product support, provided technical leadership to developers and analysts, and involved in multiple projects of data integration, systems coalescing and decommissioning