Tim Goldenstein Email & Phone Number

Boca Raton, Fl, Us

Los Angeles, California, Us

Six weeks in and feeling good. Strong, diverse team with a good leader. Lots of work on everything from straight etl to R development to some classic dba stuff. In other words, a great fit for me 😃So the above was from early July 2016, which feels like several lifetimes ago. Since then, our primary DBA left for greener pastures, I took over the major portion of managing the transition from SQL 2005 and 2008 clusters to SQL 2014 Always On Availability Groups. Add to that day to day dba tasks for the first time in a few years, and I was a bit out of my comfort zone. All's well that ends well as our migration went live in mid October and we've brought back a very talented dba to the team recently. I still get to play with things like TDE and column level encryption, so my dba skills have progressed a great deal in the past six months. I'm looking forward to getting back into the BI side as we're planning to move to SQL 2016 with our SSRS and SSIS servers soon. I'm very happy to be part of a great team here. Update #3It's almost time for the celebrated rat to look for its shadow, and life is still pretty damn good for me. I'm doing a little more on the analytics side and starting to be part of projects that help get our finance teams out of Excel. Learning more and more everyday about the ins and outs of always on availability groups. Had a hiccup last weekend when two independent nodes decided to stop communicating with their respective domain controllers. Thankfully, their secondary nodes hadn't suffered a similar fate and a failover successfully mitigated any damage that would have occurred.

Coral Gables, Fl, Us

Performed POC for moving existing mutliple step SSIS package responsible for key overnight processing of entire loan business to Informatica. Also performed performance analysis and upgrades to current infrastructure, including SQL server performance upgrades.

Morris, Illinois, Us

It has been an interesting 14 months. Building and enhancing new and existing end-to-end data analytics solutions for a customized Dynamics AX 4.0 installation, pulling financial data from Enterovision hosted on Oracle, to pulling gas and oil prices from OPIS, Platts, CME, THEICE, and bank of Canada for an automated upload process into a Rich Gas Management System. In addition, I've created an automated process to use an Excel plugin called Uniformance to automate reporting from Honeywell products.

Us

• Documented ETL processes for SSIS packages and provided knowledge transfer for transition of client eligibility from Innoviant to OptumRx platform. • Maintained and enhanced legacy eligibility and member lookup web applications in both ASP.Net and ASP.• Transitioned non-secured Access 2003 application for rejected claims that the business previously supported. • Contributed primary support and development effort that allowed OptumRx to survive CMS audit for Rejected Claims. • SME for Medical Therapy Management process that utilizes Informatica for ETL and a DB2 data warehouse that provides extracts to PharmMD to comply with always changing CMS requirements. Improved performance for MTM from a 6 week process to a single week.• SME for rDUR (Drug Utilization Reporting) SSIS packages running on SQL Server 2012. These packages took paramaters from a PEGA front end application and passed them to DB2 data warehouse. The SSIS packages utilized multi-threading to load 1 million + record flat files from the DB2 warehouse, cleansed the data on a staging SQL Server 2012 database, and presented results to PEGA front end.

• Maintain and support 24/7/365 four tiered SQL Server 2005 environment (Production, staging, testing, and development) including multiple clustered production servers. • Responsible for 12m per quarter rebate process re-write and enhancement• Develop and maintain all transactional replication in all environments • Provided support for application testers and web developers while working closely with business operations and project management teams • Responsible for engineering and automating the gathering of statistical data from all environments’ servers to aid in Job monitoring, database growth and over all space consumption. • Responsible for daily SSIS packages that performed ETL on inbound and outbound claim history files, eligibility, benefit, and accumulator data.• Designed and implemented drug utilization SSIS for ETL from DB to Sql Server 2008 R2.• Interfaces with vendor technical architecture staff in discussions pertaining database design/architecture and technical requirements.• Maintained, managed and supported SQL Severs at Backup and Recovery Center.• Developed and Maintained Backup and recovery strategy• Led project to identify and convert claim and eligibility files from SXC RxClaim to OptumRx version of RxClaim• Provided leadership, mentoring, and supervision of junior staff• Provided code review and enhancement support to reporting team, including development support.• Maintained and extended classic ASP and ASP.NET intranet applications used for member and benefit lookups• Used SQL Profiler, query plans, and execution plans to troubleshoot slow/underperforming queries and data architecture as well as suggest indexes

• Maintain 50 SQL Servers around the world (India, China, South America, Mexico)• Create and maintain replication (merge, transactional, and snapshot) in many of these servers• Create and enhance SQL Server 2000 databases for home grown web applications• Create and enhance SSRS reports in both SQL Server 2000 and 2005• Significant SOX experience – created backend for web application that manages SOX documentation • Used SQL Profiler, query plans, and execution plans to troubleshoot slow/underperforming queries and data architecture as well as suggest indexes

• Provided maintenance and enhancements for all Windows and Web applications.• Managed several projects, including an upgrade of our embroidery department’s computer hardware and software that included incorporating software from two outside vendors (Veristitch and Wilcom) into our main order-entry database housed in SQL Server. • Used SQL Profiler, query plans, and execution plans to troubleshoot slow/underperforming queries and data architecture as well as suggest indexes• Provided enhancements and user training for above application• Responsible for day to day SQL Server 2000 maintenance and support. • Was primary point of contact for user community of over 100 rich client and close to 300 thin client users. Worked with customer service leads to provide enhancements and updates to allow for easier use of application within user base.• Led conversion from BCP import from VAN to use C# for downloading orders and importing into database• Worked with Microsoft to identify and resolve an issue with a third part vendor that was using the MemToLeave area for extended stored procedures. The app had a memory leak that was requiring us to shut down/restart our prod server once a week and eventually once a day. The vendor eventually addressed the issue and fixed the memory leak