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

• SQL, T-SQL, PostgreSQL, BTEQ, Informatica PowerCenter(8.6, 9.1, 9.6) ETL, Shell, C++, C, XML, Intel Assembly, UNIX Dec Assembly, XML, LEX, YACC, REGEX, AWK, Adage 3000 microcode, Aptec DIA/DIP microcode, VMS/DCL, Pascal, FORTRAN, and ALGOL.
• Teradata 15.1, IBM PureData (Netezza) 6.x and 7.x, Massively Parallel Processing(MPP) & RDBMS,
• Snowflake & Star Schemas
• Microsoft SQL Server and Analysis Services (SSAS) ROLAP & MOLAP, Oracle 10g, DB2(Linux),
• UNIX (RedHat Linux, HP, SUN, AIX, AT&T), SAP Business Objects, Panorama NovaView,
• Windows (3.1, 95, 98, NT, 2K, XP, 7, 10), Visual Studio, Informatica Analyst, Power Designer,
• Microsoft Office (Visio, Excel, Word, PowerPoint, Outlook, SharePoint)
• Teradata 2850, IBM PureData(Netezza TwinFin36), Intel ( x86 / Pentium, ActionMedia II,
• ProShare 200 ISDN & Video), PDP 11/70, VAX 11/780 & 11/785, AT&T 3B20S,
• AMD 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:

• 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.

Senior Software Developer / Software Architect

Confidential

Responsibilities:

• Lead the alarm integration, migrating ITXC alarms into the Teleglobe and then VSNL alarm environments as the company evolved though multiple mergers.
• Designed, developed, tested, deployed and supported production software to monitor the health of the network and its components. This included interfacing with vendors, NOC managers, Network Engineers, and Network Administrators to gather requirements and specifications of the devices to be monitored, and plan testing of alarm feasibility. Software included:
• Database-driven, high-capacity parallel pinging system to monitor a large number of endpoints for network quality.
• T-SQL processing of database call detailed records and raising alarms when anomalies where found.
• PL/SQL processing of data transactions
• Windows SNMP trap collectors, polling servers and system service agents to monitor server health.
• UNIX applications to receive and process SNMP traps and TL1 alarms from various hardware devices.
• Micromuse’s NetCool processes to receive and handle Syslog and SNMP alarms.
• Enhanced GUI applications for displaying and monitoring alarms.
• Enhancements to and integration of the companies reporting capabilities for the IP data traffic business. Integrated data from new hardware and data feeds into the data capture and reporting system stored in an Oracle DB.
• Automated the passing of the call provisioning data to the company’s routing engine. This improved the speed that new call routes became available by reducing manual steps required. Designed, developed, tested and deployed production software to pass messages between the provisioning and call routing systems from the merged company’s. Messages were passed via Vitria with logging and traceability.