SUMMARY

• Solutions - focused professional with 10+ years of experience in Data Warehousing & Analytics with an emphasis on performance, process, and consistency.
• Involved with both startups and established companies through multiple corporate mergers requiring integration of existing systems with minimal downtime.
• Function as a key architecture and implementation resource; able to handle new technologies, concurrent projects, collaboration across departments, and translation of complex problems into simple, straightforward solutions.
• Certified Scrum Master with deep understanding of Agile development methodologies.
• Eager to face new challenges and contribute to ever-changing environments.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PostgreSQL, BTEQ, Informatica PowerCenter(8.6, 9.1, 9.6) ETL, Shell, C++, C, XMLIntel Assembly, UNIX Dec Assembly, XML, LEX, YACC, REGEX, AWK, Adage 3000 microcodeAptec DIA/DIP microcode, VMS/DCL, Pascal, FORTRAN, and ALGOL.

Environment: s Utilized: Teradata 15.1, IBM PureData (Netezza) 6.x and 7.x, Massively Parallel Processing(MPP) & RDBMSSnowflake & Star SchemasMicrosoft SQL Server and Analysis Services (SSAS) ROLAP & MOLAP, Oracle 10g, DB2(Linux)UNIX (RedHat Linux, HP, SUN, AIX, AT&T), SAP Business Objects, Panorama NovaViewWindows (3.1, 95, 98, NT, 2K, XP, 7, 10), Visual Studio, Informatica Analyst, Power DesignerMicrosoft Office (Visio, Excel, Word, PowerPoint, Outlook, SharePoint)

Hardware utilized: Teradata 2850, IBM PureData(Netezza TwinFin36), Intel ( x86 / Pentium, ActionMedia IIProShare 200 ISDN & Video), PDP 11/70, VAX 11/780 & 11/785, AT&T 3B20SAMD 2901, 2903, 2910, & 2911, Adage 3000 programmable graphics workstation, Aptec 2400 I/O computer, Ibis 1400 programmable disk drive, Sony BVH-2500 & BVU-820 video recorders and Sun Workstations .

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Data analysis for product penetration within Confidential Xfinity Communities. Included the identification of source system data from MELD, NSD, and Rosetta along with quality issues and data model development
• Analysis of Data flows for how the Xfinity data moves through the various data systems and layers in order to identify optimal extraction points.
• Define and document data transformation rules
• Team training in the understanding of Agile Scrum methodology
• Work with Enterprise Data team to align with organization's data standards

Confidential

Principal Architect / Senior Manager

Responsibilities:

• Lead the contracted ETL offshore development teams with architectural plans / HLAs, performance tuning, along with design and code reviews to company standards.
• Responsible for hardware selection Proof of Concepts evaluating Teradata Appliance platform, IBM PureData and Oracle ExaData resulting in the purchase of two 12 Node Teradata 2850 Appliance database systems for dual site redundancy.
• Architected distributed processing and dual site model to allow data loading so that if a site is down (i.e. hurricane or other major reason) data could be loaded at the alternate site. This also allows Users to access data at the site they are closest too. This utilized Teradata databases, Teradata Data Mover, Informatica, Oracle repositories and GoldenGate.
• Implemented the data synchronization as ETL sessions for consistency and ease of operations.
• Architected automatically updating foreign keys that could not be resolved during initial data loading due to latency issues.
• Integral member of delivery team; worked with the other members to manage and guide contractor teams in implementing the Extract Transformation and Loading (i.e. ETL) of the source system data into the Teradata Data Warehouse (i.e. DWH / CDW) with Informatica PowerCenter & BTEQ.
• Source Data changes tracked using SCD Type 2.
• Implementation was done using the Agile Methodology; guided scrum master and advised less-experienced, contracted scrum masters, and scrum developers.
• To date the system is loading from 30 source systems into 175 tables with more organizations wanting to report their data via the Data Warehouse.
• Managed the contractor team assigned port the Confidential from the IBM PureData to the Teradata platform. The IBM PureData platform had reached the end of IBM Support.

Software Architect / Manager

Confidential

Responsibilities:

• Lead contracted ETL offshore development team with architectural plans / HLAs, along with detail design and code reviews to company standards. Guided team through company transition from Waterfall to Agile development. Gathered requirements from users and interfaced with operational teams and vendors when issues arose.
• Responsible for hardware Proof of Concepts evaluating IBM PureData, Teradata Appliance platform and Oracle ExaData resulting in the purchase of an IBM PureData database for the Voice Line of business. Lead the data migration from the former DB2 platform to the new IBM PureData.
• The new Data Warehouse loaded 150 Million records/day of voice call detail records providing the users with Near Real Time (4 hrs or less latency SLA) reporting and analytics.
• Architected the infrastructure for high availability/fault tolerance providing the users consistent access.
• Source data pulled from Oracle, MS SQL Server, My SQL and Flat files.
• Success of the Confidential lead to the creation of Data Marts and the Corporate Data Warehouse. Other organizations wanted the reporting and analytics that the voice business had.
• Wrote system performance analytics and applied them to capacity monitoring and performance tuning. This improved the performance SLAs for both users and data loading simultaneously. Drove the organizational adoption of the process.
• Designed extensions to the Data Warehouse in support of a new business models including the ability for Confidential ’s Partners to use the data warehouse and see only appropriate data the partners and Confidential alike.
• Architected and implemented a distributed low-latency ROLAP cube allowing users to see the same results via the cube or the data warehouse at any time. The cube used Panorama’s NovaView and Microsoft SQL Server Analysis Services to the IBM PureData Database.
• Developed C semaphore code to allow single update from parallel Shell processes.
• Managed the inclusion of new data along with keeping processes in sync source system changes for existing data.