Zach Nichter Email & Phone Number

United States

Oslo, No

Doing my part on a highly skilled service delivery team of technology professionals. We deliver innovative and scalable, cloud-based, Data and AI solutions, as well as, building modern cloud applications from the ground up.

Dallas, Texas, Us

• Developed data validation reporting and predictive analytics on data import error rates. This dashboard and research tool reduced the average issue research time, from ~25 minutes per issue to ~1.5 minutes per issue.• Developed new ETL practices leading to ~70% improvement in error rates for client 3rd party database imports.• Through automation of data transform tasks, reduced client go-live and cutover event duration by 60%.• Improved client implementation project efficiency by identifying project timeline risks, decoupling task activities, and moving components forward in the project timeline. This generated float that created a 50% reduction in the time required for the go live cutover period. • Architect and later the product manager for a serverless cloud data import tool. This tool is used by implementation teams to perform consistent, rapid integration and data migration of new clients into a SaaS accounting system.• Developed internal sync processes that would extract and later ingest accounting transaction data after data processing at SaaS Blackline (Blackline - SaaS for finance and bank transaction matching).

Reading, Pennsylvania, Us

• Provided consulting services on application, database, and system performance of logistics processing systems.• Presented and implemented solution around performance optimization of EMC storage for database systems, database index and partitioning, as well as system configurations.

New York, New York, Us

• Managed multiple teams within the newly formed and integrated Global ICG Database operations team. Managed 45 DBA’s across three teams globally.• Through IT sector merger and realignment, led the transformation of operations DBMS teams to a plan/build/run operating model within 12 months. • Led teams responsible for the database systems in the Transaction Services sector. These Transaction Service systems were responsible for processing $2.3T in transactions per hour. • By creating and leading a collaborative forum it became possible to lead the adoption of automated database system builds for all Citi database management teams, spanning 4 business sectors.• Successfully built, staffed, and managed an 18-member global request management team. • Tasked with building a global database build and patch management team. The responsibility of this team is a team providing consistent, standard database platform builds, patch cycles and implementation plans for all SQL Server, Oracle, Sybase and UDB DB2 RDBMS platforms.• Built and managed a new global service delivery model and team. Defined standards, processes, KPI’s, quality measurement, efficiencies, and successful execution of application projects where database team is to architect, build and provide operational support. • Identified proper staffing levels based on location, workload, work volume by the varying types of relational database management systems through the targeted development of proper reporting and data mining.• Led initiative for a combined 24x7 follow the sun support model between 2 merging business sectors and 6 database management production support teams.• Led reduction of incident ticket count by 45% from problem management practices and root cause resolution.

Westlake, Texas, Us

• Identified and bridged operational process and procedure gaps between multiple database management and systems engineering teams.• Led database team in adoption and roll out of Big Data initiatives using MongoDB and Hadoop to discover and develop an automated system health response framework.

San Francisco, California, Us

• Database team lead of 14 DBA’s.• Built and implemented strategic plans and road maps for database technologies, database management and tools license and contract management, patching strategies, service offerings, disaster recovery, license recovery cost savings, and system use efficiencies.• Worked to identify and remove performance bottlenecks in production SAP 5+ TB databases, RedPrairie, Raymark POS database environments, as well as other major applications.• Identified efficiencies and developed automated maintenance and build tools, allowing for 2,500+ databases to be managed by a DBA operational support staff reduced to 3 full time DBA’s and 2 part time resources.• Reduced time to delivery of new database management system builds from 10 days to .5 days (95% productivity save) through development of automated builds, system standardization and reducing management and maintenance configuration time and DR documentation.• Architected and implemented what was the world’s largest SAP BI implementation on SQL Server.• Member of SAP integrations team designing architecture and integrations for SAP application replacement program. Worked to replace functions of over 80 internally developed applications. Focusing on integration points and data feed workflows up and downstream.• Set team KPI’s for team support and performance of systems. • Created and deployed procedures, policies, and technologies to drive efficiency into repetitive activities. • Identified and implemented improvements in standards, processes, and procedures for SQL DBA’s.• Designed, coded, documented, trained, and implemented an automated installation and automated maintenance for all SQL Server database systems, additional tools for application support teams, automated, self-managing maintenance (written in T-SQL, powershell, C#).

Rochester, Ny, Us

• Monitoring performance and maintenance of SQL Server systems.• Optimize SQL Server environments for scalability and performance.• SQL Server and T-SQL performance tuning for multi-terabyte databases.• Physical and logical database design optimization including file, filegroup, index, table layouts and data loading processes.• T-SQL performance optimization.• Identifying and resolving low level SQL Server bottlenecks.• Performing architecture design reviews of SQL Server systems and applications.• Database Migrations

Dallas, Us

Manager of SQL Server 6 development database team members.Responsible for... - Budgeting - Coaching - Strategic RDBMS planning - Technology Roadmaps - Policies, procedures, standards - Team KPI's - Technical Education Provided policies and procedures for development, QA, and staging SQL Server environments.Provided multiple internal seminars for development DBA team and other DBA teams.Taught development groups T-SQL performance optimization tactics.Reviewed existing development reporting environments for optimizing long running queries and implementation of coding policies.

Dallas, Tx, Us

Worked high profile client engagements focusing on highly complex optimization issue.Sub-Contracted by companies like Microsoft, HP, Dell and others.Consulted at companies such as MySpace, HP, Microsoft, DR Horton, Broadlane and others.Developed internal process for performance evaluation and optimization.Worked to optimize client environments for scalability and performance.SQL Server and T-SQL performance optimization for multi-terabyte databases.Physical and logical database design optimization including file, filegroup, partitioning, index, table layouts and data loading processes.T-SQL performance development and optimization.Identifying and resolving low level SQL Server bottlenecks.Performed architecture design reviews of SQL Server systems and applications.Database Migrations

Scottsdale, Az, Us

Mathematics And Computer Science

Education record