Nathan Rooks Email & Phone Number

Charlotte, Nc, Us

Member of the Life Cycle Services TeamUpdate all existing SSIS/DTSX packages with error handling, messaging notifications, and environment parameters.Build automation script for AutoSys and Package deployments.Database Architect for the BART Application where users scheduled the date and time for their hardware refresh.Facilitated other tasks and SSIS maintenance issues as requested.

Charlotte, Nc, Us

Developed skills to use .Net Core 3.1 for API, website and new application development using VS 2019 and VS Code. Use Horizon, Artifactory, Jira and Git to control source code and deployments.Working in Agile framework with Daily Stand Ups, story assignments and scrum calls.Built numerous DTSX packages pulling data from Oracle/Data Lakes to MSSQL.Maintained SharePoint site for System Admin Team using Java Script to customize.

Worked with business units to create stored procedures and SSRS reports for monitoring loan data maintained across multiple environments.Optimized queries for performance across multiple SQL servers.Created additional reports for mortgage teams.Rebuilt letter reports that were sent to customers detailing updates about loan modifications and actions being taken if approved or denied with detailed explanations.

New York, New York, Us

Provided management, oversight, and reporting of the Demand Side Governance between the GCT Lines of Business (LOBs)/Regions, and their preferred and niche Suppliers to ensure continued adherence towards the proper structure, controls, and reporting for the delivery of agreed services within the various Statements of Work (SOW). Responsible for providing monthly metrics and reporting, mitigating areas of risk, and for identifying optimization opportunities in order to mature the portfolio of work.

Northbrook, Il, Us

Responsible for building new Claims Automation Reports using Crystal Reports 2014.Maintain manual procedures until automation is completed and validated.Developed and deployed new stored procedures, analyze and create indexes where needed for better performing procedures.Assisted other team members in their daily operations.

Moon Township, Pa, Us

Responsible for maintaining existing Service Level Agreement Reports.Continued maintaining all existing automation scripts and business relationships.

Moon Township, Pa, Us

Consulted with users and clients to solve complex system issues/problems through in-depth evaluation of business processes, system and industry standards and recommended solutions.Interact effectively with all levels of management and end-users.Oversee the daily operations of the Product Automation Team and directly involved in the hiring and termination process.Used excellent customer service skills that build high levels of customer satisfaction for internal and external clients.

Moon Township, Pa, Us

Designed and coded custom programs and/or modifications, as required, to satisfy the requirements of approved assigned tasks for all automation scripts for Service Link Default Solutions.Managed full software development life-cycle for automation including requirements gathering, documentation, development, testing, and implementation.Identified complex problems and reviewed related information to develop and evaluate options and implement solutions.

Moon Township, Pa, Us

Created and ran recurring and ad hoc reports for various levels of management and end users.Analyzed report requirements and designed stored procedures that executed with-in designated thresholds established by DBA’s.Built up knowledge of mortgage banking with familiarity with foreclosure and bankruptcy processes.

Cologne, New Jersey, Us

• Created the Finisher Data Exchange using SonicWall, NAT Polices, MS SQL Users, Views, Stored Procedures, Roles and ODBC. This allowed remote vendors to provide Absecon with real-time information about our products stored in remote warehouses.• SQL Server Admin, responsible for managing the MS SQL Server and maintaining Data Normalization through Entity Relationship Modeling (ERM). Also created, modified or removed Tables, Views, Stored Procedures, Users, Roles and the Database Maintenance Plans as needed. • Streamlined manufacturing processes and improved Customer Service by using Six Sigma and Lean Manufacturing principles.• Responsible for defining problem areas, collecting data, establishing facts, drawing valid conclusions and turning those conclusions into business rules.• Saved the company an average of $150K per year by implementing rolling scales to verify length of fabrics after inspection. By using the serial port to communicate with the Cardinal Scale we were able to calculate what the length should be based off the weight.• Saved an average of $40K per year by introducing Sonic Welders for attaching serial numbers to fabrics.• Updated or re-wrote dozens of reports in Visual FoxPro 6.0 (VFP) and Crystal Reports and where applicable created Stored Procedures or Views in MS SQL to speed processing time. Most queries had to be re-written due to poor execution planes. Updated the Crystal Reports Data Dictionary when structural changes are made to MS SQL.• Created the Hot List by modifying VAM to include a new form, timer, T-SQL and SQL where users could receive critical information pertaining to customer’s orders. Employees were aware of problems with-in three minutes of the data update. Used C# to create a system try program using balloons to notify users of defects in production.

Mount Laurel, Nj, Us

• Assisted with replacing over forty-four hundred workstations.• Lead in building the Access Data Conversion Tool for converting fifty-five hundred plus Access databases. Worked with Network Administrators to run network scans using MS Access (SQL, T-SQL and tables) and Visual Basic Scripting (VBS) to search for all Access Databases needing conversion. • Documented all linked databases and the locations where those databases linked. Ran nightly tests on random databases for testing accuracy of the conversion to 2003.• Responsible for troubleshooting and resolving numerous issues and outages during upgrade from Windows NT environment to Server 2003 running Active Directory.• I was specifically requested to work the Accounting Building while the conversion was taking place to resolve any issues.

* Optimized queries in critical in-house applications to increase program efficiency.* Researched and resolved production application problems.* Designed, developed and integrated new programs and made enhancements to existing programs.

* Provided third level technical support for the stenographer software Eclipse under strict time constraints.* Mentored new technicians on the functions of the software.* Developed reports using Word and DDE to automate populating standard documents.

Spearheaded the development of change control procedures for all applications, utilizing Visual Source Safe. Designed and delivered technical training to Programmers on Visual Source Safe usage.·Championed the deployment of Quality Assurance testing environment to allow appropriate testing of current data and reduce software defects.·Successfully created new system to allow Repairs Department to generate estimates for the homeowners, reducing processing time by 6 hours.·Developed a system for the Permitting Desk to automate job permits management and tracking, reducing processing time by 6 hours.·Credited with developing the Sales Administration system, achieving annual costs savings of $30K.

Performed software support for the Computer Aided Transcription (C.A.T.) software named Eclipse, Total Eclipse and TeleView. TeleView is used for Internet Depositions and Webcasting.Trained Court Reporters in the step-by-step process of running Real Time, CIC and Closed Captioning.Worked on converting Reporters dictionaries from other CAT Systems to Eclipse. This required knowledge of serial ports and writing that data to text files using Hyper Terminal.Using Windows NetMeeting I would remotely access Reporters computers for a higher level of support.With my ability to resolve issues rapidly, I was specifically assigned to support Real-Time calls. Calls where the Court Reporter was in court and the court was waiting on the reporter to correct the issue. The issues ranged from incorrect configuration of the software, incorrect IRQ settings, other application locking ports, to warn cabling, and other hardware issues from the writer to disc drives.