• Created data-rich internet and intranet sites for clients. ASP.Net / AJAX front ends, and Oracle or SQL Server back-ends. Functionality included gathering sales forecasts, tracking manufacturing processes, customizable reporting of ERP data, client databases, and course registration sites. • Legal software – standalone limitations management software.• Community Association Membership Software - created "StreetBeat" software to help Community Associations manage and communicate with their membership.

• Leverage technical expertise, business acumen, and a passion for software development and architecture to significantly contribute to customer success. • Deliver live, classroom training to diverse companies, engaging in technical conversations to understand unique needs and enhance the value derived from their cloud investments. • Intertwine customer instruction with ongoing personal learning in cloud technologies and industry best practices. • Ensure positive impacts on students and their companies through continuous deepening of expertise, staying ahead of trends, and aligning with customer success goals.• Play a pivotal role in developing internal tools to boost productivity for select internal teams, adding an extra layer of value within the organization. • Maximize customer value and success in their AWS investments.

Worked on the data engineering and business intelligence team. Helped clients with their big data challenges.

• Provided consulting services to clients on big data implementations, specializing in MPP Columnar engines such as Vertica.• Designed and optimized cloud and on-premises architectures, developed databases, and implemented data modeling, loading, and ETL methods using technologies like Apache Kafka messaging and NiFi data flow.• Contributed to infrastructure design, high availability, disaster recovery, performance optimization, integration and migration assistance, and more.• Collaborated with clients like Machine Zone, Kiva.org, CB Technologies, Jazz Pharmaceuticals, and others, resulting in improved database performance and stability.

• Oversaw the design and implementation of a Threat Intelligence data warehouse for cloud security, utilizing Vertica, Pentaho ETL, Python, Jenkins, and MongoDB.• Developed, tested, and deployed solutions to identify security threats before they impacted customers.• Trained operations staff on Vertica cluster installation and maintenance.

• Led the design, development, and maintenance of data and analytics for threat intelligence, working with MySQL and Vertica databases.• Developed queries for data analysis, resulting in the automatic identification of malicious activity and internet traffic.• Oversaw the ingest of 1.5 TB of data per day into the Vertica database, improving customer security by identifying potential threats and scams.

Responsible for Data Warehouse operations, including infrastructure and data. Data Warehouse contains hundreds of terabytes of security intelligence data, collected from various Symantec security products and 3rd party sources.Key responsibilities:• Infrastructure – lead a team of professionals who are responsible for the design, deployment and maintenance of all physical and virtual servers, networking, storage, etc. Includes 24x7 on-call support. Ensure high-availability and disaster recovery.• Database development – lead a team of developers who are responsible for modeling, acquiring and storing data. Responsible for query development for both SQL Server and Vertica databases.• Database Administration – lead a team of DBAs who are responsible for administering SQL Server and Vertica clusters, including performance tuning, backups, and resource monitoring.• Budgets – manage multi-million dollar capital and operating budgets.• Staffing – responsible for recruiting, mentoring, and reviewing staff performance.• Project planning – work with the Director of Development to scope work, set priorities and allocate resources for upcoming projects.

Design and create data warehouse in Vertica columnar MPP database.Key projects:• Proof of Concept – work with Vertica on POC to determine suitability of Vertica as the data warehouse platform.• Data Modeling – convert existing RDBMS schema to columnar schema.• ETL – design and prototype custom ETL software for acquiring data from various sources via multiple delivery methods. Transform data from various data sources, systems and formats into a common format. Load hundreds of millions of rows per day of data into the warehouse.• Monitoring – design monitoring and tracking software for ensuring ETL success.• Query optimization – profile and optimize queries, tune database for optimal performance.• Query support – provide developers with query-writing support and coaching.

Managed, lead and mentored a team of software developers. Provided resource planning and technical guidance for software projects. • Worked with Program Management and Quality Assurance teams to ensure successful project delivery. Project timelines varied from a few months to spanning several quarters. Responsible for several projects that supported the back-end operation of Symantec’s consumer products. • Authored functional specification documents based on requirements-gathering from end users. • Responsible for staffing issues – recruitment, salary planning, promotions, and performance reviews.

• Senior database developer - developed data models, performed data transformations and migrations (ETL – manual/ad hoc as well as using DTS and SSIS), authored and optimized queries using advanced T-SQL, and troubleshooting of database performance for large scale production SQL Server databases (versions 2000/2005/2008) which exceeded 30 terabytes of data storage and which processed over 80 million transactions per day. Worked with infrastructure team to ensure high availability and maximum database performance. Identified new data sources and structures, worked with cross-functional teams to get the data delivered to our environment, developed an integration plan, and led the development and testing of the new solution.• Database administrator – responsible for setting up and maintaining development and test environments. This included monitoring storage, backing up and restoring data, maintaining replication, patching or upgrading servers, rebuilding indexes, performance tuning and setting up security.• Programmer – created and maintained n-tier interfaces and applications using .NET. Included web sites, web services, windows applications and windows services.• Troubleshooter - investigated and identified problems with .NET applications and services which interfaced with the data farm. • Mentor - coached co-workers about query optimization, best practices, and database standards. Ensured consistent definition of enterprise data and architectural standards.• Analyst – Reviewed transactional data, identified anomalies and/or trends. Ensured data consistency and accuracy. Provided meaningful reports to senior management. Monitored automated anomaly detection for false positives and adjusted the statistical model accordingly.

Database-driven web solutions for supply chain management.Key projects:• Created forecasting intranet site for sales-people to enter sales forecasts into a database, which waseasily queried by business analysts and sales managers. As a result, analysts were able to user theirtime analyzing the data instead of gathering the data. Statistical models were used to pre-populate theforecasts, which the sales-people could vet and modify where necessary.• Developed an on-line product configuration tool for sales people to configure technical products andgenerate a bill of materials for the sales order.