Sandeep Nayak Email & Phone Number

Hyderabad, Telangana, India

Hyderabad Area, India

Dallas/Fort Worth Area

Responsibilities:• Design, create, alter, tune, troubleshoot SQL Server code and SSIS packages• Review and approve team’s database code• Establish best practices for database development and logging• Understand current business rules/technical workflows and provide recommendations for better design and performance• Identify bottlenecks in slow running processes and tune them for better user experience or faster batch jobs• Refactor the multi-platform ETL process and implement a dashboard that enables to monitor and assess the status of the complete data flow easilyKey accomplishments and recognition:• Tuned the database code behind a few front-end web pages used by the business team often. Reduced the response time from over a minute to less than three seconds• A few complex batch processes were taking 15 to 20 hours each to complete and impacting the daily schedule. Isolated the components which were running slower and tuned the related database code which reduced the processing time to about five times lesser

Phoenix, Arizona

• Migrated out of warranty SQL Server 2000/2005 databases into SQL Server 2012 within time frame and budget ensuring compliance and security of company's most critical student data• Reduced complexity with multi-system dependency by converting more than 20 DTS packages into SSIS jobs used for aggregating data from heterogeneous systems for analysis and decision-making• Re-engineered the program approval process for the University. Simplified the design used by application services and user interface• Improved system performance by converting legacy codes into optimized SQL and PL/SQL packages which in turn saved company costs associated with legacy system maintenance• End-to-end ownership of configuration, deployment, and support of a third-party product in all environments; automation of quarterly deployments and verification• Recognition by the management on handling relationship with the clients and the third-party product vendors

Phoenix, Arizona

• Complete automation of the functionality to bulk upload and download hotel contract data. This initiative had a positive impact on the revenue because it saved a tremendous amount of time and manual processing efforts by the business team• Played a vital role in upgrading the system of record for hotel and air contract data which was an outdated database system with SQL 2000 and MS Access to the latest version SQL Server 2008. As dozens of upstream and downstream systems connect to this data, I worked with other teams to ensure that the upgrade takes place without having any business impacts• Redesigned a suite of business travel applications for PNR processing and reporting to support from a single passenger to a multi-passenger system. This project helped our business team with better-invoicing capability and more accurate reports• Designed and developed a dashboard tool to monitor the health of the complete system and raise alerts in cases of critical errors• Designed custom utilities to Q-place the PNRs in the GDS that saved hundreds of hours of manual efforts• Played a key role in upgrading legacy applications with obsolete technology to the latest Microsoft suite using Dot NET, SSIS, and SSRS• Designed reusable components and error framework to integrate into several applications• Won STAR performer of the year award for SPEED in 2011• Appreciations from the business team for the depth of details covered during the requirements’ discussion, logical approach and technical expertise with the domain, data, and product knowledge