Srinivas Bandaru Email & Phone Number

Seattle, Washington, United States

Seattle, Washington, United States

- Led the team by providing support to high-priority customers experiencing technical issues.- Reported progress goals suggestions and all issues to management.- Ensured team members stayed up to date by providing frequent training.- Collaborated with other departmental leaders.- Held weekly team meetings and involved staff in planning and decision making.- Identified problem areas and implemented all necessary training.- Provided quality troubleshooting with patient step-by-step instructions to resolve problems.Partner ManagementChange Management Incident ManagementRisk Management Training ManagementRelationship Management

Greater Seattle Area

• Technical Support for various clinical applications in the organization. • Identifying the risks and analyzing the problems in deep and helping product teams to improve the quality of the product• Escalating the bugs and enhancement requests to the product owner. • Product stabilization by identifying the design loopholes and bugs. • Data correction/ providing quick fixes to minimize the impact of the downtime. • Extensive API Integration support collaborating with partners like EPIC, Cerner, All scripts • Creating the knowledge base and maintenance of the KB’s • Complex incident/case resolution, high priority case handling and collaboration with development teams and sysops • Fast customer response with excellent telephone etiquette • SQL query preparation while in a call with customers and data correction on-demand basis. • Excellent troubleshooting skills with IIS, SQL and very efficient in using tools like Perfmon, Fiddler, browser developer tools, profiler. • 24/7 on call customer support

Mountlake Terrace, Wa

Expedia, Inc. (Contractor) Jun 2013 – Jan 2014 Location: Bellevue,WA. Design and maintain Financial Back Office database applications using SQL Server followingthe Client Software Development Lifecycle.. Collaborate with other groups (Business Partners, Developers, Testers and production supportengineers) in implementation of analytical and technical solutions.. Create unit test cases and technical documentation, perform detailed code reviews, and createautomated build and deployment scripts.. Maintain a high level of code quality and consistency by adhering to and helping to develop thegroup’s coding standards, design methodology and programming practices.Premera Blue Cross (Contractor) Nov 2012 – Jun 2013 Location: Mountlake Terrace, WA. Manage and resolve client application issues.. Manage the complex code base and make changes to the bug reports by customer.. Participating in design and develop meetings.. Performing the data massaging and clean up.. Managing the ETL loads into data warehouse systems.

Hyderabad Area, India & Redmond, Wa

• Worked for Microsoft, Below are the Groups & Projects that I involvedo GFS (Global Patching Application Tool [June-2011 to Nov 2012] , Microsoft Operation Center (MOC) [May-2010 to June -2011])o Windows 7 (Win7 CC [Apr-2009 to May 2010])o TWC (Cyclops Tool [Dec 2007 to March 2009])• Lead end-to-end efforts to design, development and implement data integration processes • Translated business requirements into data needs.• Interface closely with engineering teams to build and extend a cross platform ETL framework• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements. • Maintained the database schema in source code control • Involved in XML Development and XML File Parsing in SSIS and SSRS. • Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS. • Created automated stored procedures for day end operations using SQL Server agent. • Coordinated with front-end for implementing logic in stored procedures and functions. • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS. • Implemented failure alerts using email in SSIS. • Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling). • Snapshot Replication was been used to synchronize the data between their Different Stores. • Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS. • Involved in SQL Server Mirroring and Database optimization. • Data migration (import & export – BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.

Bangalore, India

• Responsible for Data Modeling based on the client requirements. • Prepared the Technical and Function specifications based on the project requirements. • Responsible for data analysis, loading data from Data feed to Data Warehouse tables. • Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages. • The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop. • Set package configuration in SSIS to redirect path from test environment to production environment. • Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS). • Modified stored procedures to meet current design and used them in SQL Server. • Developed queries in Data Warehouse in OLTP/OLAP environment. • Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources. • Modified web pages to do database inserts, deletes, modify.