TECHNICAL SKILLS

• Relational Database Management Systems (RDBMS):
• Oracle (RAC and Non RAC),
• Sybase (ASE)
• Microsoft SQL Server (2012, 2014, 2016)
• Database Clients:
• Windows: DBArtisian, TOAD, ASE Isql, Aqua Data,
• Windows: Oracle SQL Developer, Microsoft SQL Server Management Studio.
• Unix/Linux: SQLPLUS, ISQL, SQLCMD
• Data Extraction, Transformation and Load (ETL)Tools:
• Transact - SQL custom utilities
• PL/SQL custom utilities
• SQL Server Integration Services (SSIS)
• Bulk Loads
• Data Migration Tools: SQL Server Integration Services (SSIS)
• Data Modeling Tools: ERWIN, S (Power) Designer, Oracle SQL Developer Data Modeler.
• Data Reporting: SQL Server Reporting Server (SSRS)
• Data Analytics: SQL Server Analysis Services (SSAS) OLAP Tabular Model
• Data Visualization tools: Power BI, Tableau
• Programing: Unix/Linux Shell scripting, PL-SQL/Transact-SQL/ANSI SQL scripting
• Task Scheduling: Unix/Linux Crons, Oracle DBMS SCHEDULER, SQLAgent, Windows Task Scheduler
• Database Development: SQLPLUS, Transact-SQL, ANSI SQL
• Operating Systems: Windows, Unix, Linux
• Software Development Life Cycle (SDLC) Methodologies: Agile, Waterfall, Kanban
• Agile Tools: Version One, Scrumwise

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Warehouse Solution Architect

• Lead a data team to Design, Model, Architect and Implement an Enterprise Data Warehouse / BI solution to include - Dashboards, KPIs, Mobile Reports, and Self Service BI solutions using Microsoft BI tool set.
• Deliver reporting and analytical solutions to business stakeholders that provide insight into business performance.
• Collaborate with business stakeholders and data stewards to assess and prioritize business needs.
• Perform complex data analysis for an in-depth understanding of underlying data structures to ensure solutions meets all business requirements.
• Partner with business and IT stakeholders to define a Master Data Management Strategy.

Confidential

Data Architect/Engineering Manager

• Design, Document, Model and Architect an EDW solution.
• Identify, Develop and Implement all Extract Transform Load (ETL) rules.
• Design and Implement a Business Intelligence (BI) / Data Analytics dashboard using data visualization and reports.

Amtrak Sales Operational Data Store (SODS)

• Define Conceptual/Logical/Physical data models
• Identifying Extract Transform Load (ETL) rules for
• Data migration packages using Microsoft SQL Server Integration Services (SSIS)
• Real time data loads into SODS from XML on Messaging Queues
• Define Database partitioning strategies
• Perform Reservation/Ticket/Revenue data analysis, and SQL performance tuning and query optimization.

Confidential

Data Architect, Business Intelligence (BI) / Data Analytics

• Design and maintain Logical/Physical Entity Relationship Diagrams (ERD), Metadata, Master Data and Data Dictionary for Confidential ’s 13 Mission Critical Logical Provisioning On-Line Transactional Processing (OLTP) and On-Line Analytical Processing (OLAP) databases, with over $5 billion in revenue impact to Confidential .
• Partner with business users to define and develop Business KPI, Metrics, Dashboard, Roll-up and Drill down reports using SQL and Oracle Data Analytic functions on OLAP database.
• Design, Develop and implement ETL (Extract, Transform Load) PL/SQL and Transact SQL utilities to populate Data Warehouse (DW) and audit databases.
• Design, Develop, Implement and Optimize all database objects including tables, indexes, views, triggers, stored procedures, functions and other advanced data object in PL/SQL and Transact-SQL.
• Review, approve and implement DDL (Data Definition Language) / DML (Data Manipulation Language) scripts in development and QA/UAT databases.
• Develop data migration plans and decommission roadmaps to migrate disparate legacy MS-Access, Sybase, Oracle standalone databases and UNIX data files to Oracle-RAC databases in Confidential ’s private Cloud.
• Identify and resolved all SQL Performance issues by analyzing ORACLE AWR reports and Query Execution plans, as needed.
• Design, develop, implement and maintain UNIX/LINUX Shell scripts and database utilities, crons, data reports and data feeds.
• Partner with Enterprise Production Support (EPS)-DBA team to define and implement data (base) security and setup Disaster Recovery (DR) environments and participate in DR exercises.

Data Governance / Security Subject Matter Expert (SME)

• SME on the Dataconfidential, Metadata and Master Data Management (MDM) for the Logical Provisioning database suite.
• Implement data compliance and security initiatives like Communications Assistance for confidential-810.
• Identify and implement data masking for confidential based team members for all development and QA databases.

Confidential

Database Developer

• Maintained Data Warehouse, ETL scripts and OLTP database for confidential.
• Created and maintained C (Embedded) SQL UNIX shell scripts, and SQL programs for confidential transactions.

Confidential

Senior Data/Program Analyst

• Created technical specifications document, Entity-Relations diagrams, Database designs for multiple confidential projects.