Sql Server Developer

Satish Orugunta

***** ** **** **, ********, WA **007

Phone : 425-***-**** Email : ******.********@*******.***

SUMMARY

Over 13 years of experience (Close to 8 years of SDET experience (Functional, Performance and Lead SDET) and 4 years as a web developer) in Information Technology throughout the entire Software Development Life Cycle which includes Analysis, Design, Estimation, Development, Testing and Deployment of Client/Server, Web based Internet/Intranet applications and desktop applications.

Good experience of coordinating with geographically dispersed teams, leading the test team, delegating the work and handling the teams.

Extensive experience in Functional Automation, Performance Automation of the Web services, Web Applications using Java, C#, TestNg, .NET Framework, Unit Testing Framework, WCF, HP Test Suite, Load Runner, Jmeter, MsTest, VSTT, JavaScript, NUnit and SQL Server.

Extensive experience in the UI automation using Selenium, CodedUI, TAEF (Test Authoring and Execution Framework), KAF (Automation Framework) and MitaSpy for web and windows apps.

IT expertise in design, development, testing and implementation of Enterprise applications using J2EE technologies. Worked on J2EE (JSP, Servlets, Struts), Web Services (SOAP, WSDL), Tomcat, WebSphere, JDBC, XML, and well versed with Oracle.

Experience with designing, developing test automation Framework and testing large scale service systems.

Experience working with different groups and projects including Office 365, Windows Phone Services, Zune (ZEST), Windows 8 Apps, MSN, ECO, MSIT and GFS (MSG) at Microsoft Corporation.

Extensive experience in development of web applications, Web Services, tools using ASP.NET Web forms, Azure, WCF, ASMX, JavaScript, jQuery, JSON, HTML, XHTML, CSS, JavaScript.

Extensive experience designing and developing applications on Front End, Middle tier and Backend.

Extensive Performance, Stress, Scalability, Capacity, functional, white box, security testing experience with strong Web Application Development experience.

Extensive experience in troubleshooting Performance Issues, Memory leaks, Timeout issues and Deadlocks using ETW, Perfmon, Soap UI, CLR Profiler, Windbg, DebugDialog, Xperf, SQl profiler, Fiddler, LoadRunner, HttpWatch, Splunk, Opnet and Visual Studio Test Tool.

Experience in determining the performance bottlenecks of the servers by observing various performance parameters like Tests/Sec, Request execution Time, Requests/Sec, SQL Dead Locks etc. and other parameters using Visual Studio, LoadRunner, Perfmonitor and various other tools.

Experience in writing & debugging SQL Server Stored Procedures, Triggers & SQL Scripts, Views, Indexes, Temp tables, SQL Jobs and running SQL Profiler traces for debugging and optimize queries.

Good command of various programming languages (C#, Java, VB.NET) and experience on best practices and idioms of these languages.

Experience working with automated build, test and continuous integration systems and conducting code reviews.

Expertise in designing and developing test strategies, analyzing business specification documents. Writing test plans and product quality assurance documentation.

Experience in Performance, Capacity, Scalability, Stress, Validation, Acceptance, Compatibility, Functional, Unit, Integration, Regression, GUI, Back-end, Smoke Testing, White box testing and Black box testing.

Experience in implementing SDLC methodologies including Waterfall Model, Iterative and Agile methodology. Experience developing and testing applications built on SOA architecture.

Technical Skills:

Languages : Java, C#, VB.NET, Java, VB 6.0, C++, C, COBOL

Technologies : J2EE (JSP, Servlets, Struts), Tomcat, JDBC, ASP.NET, ADO.NET, WCF, Azure,

Rest API, Entity Framework, Silverlight, .Net Framework, MVC, ASP, SharePoint,

AJAX, XML, XSD, JavaScript, HTML, DHTML, Hive, Nova, XHTML, CSS,

COM/DCOM, COM+, ActiveX, ADO, Win32 API, ODATA, BigData

Development Tools : Eclipse, Visual Studio 2010/2012/2013, SQL Server 2008/2014, TOAD, Bedrock,

Virtual File, PowerShell

Testing Tools : Junit, Visual Studio Team Test (VSTT), Nunit, VS Unit Test Framework,

Selenium, HP Test Suite, Load Runner, Jmeter, MSTEST, TAEF Framework), VS

Coded UI Test builder, WTT, MTM (TestManager), ETCM, KAF, VRTA, Fiddler,

HTTPWatch, MSNPIE, Debug Dialog, WinDbg, Nunit, Lab Center, Magellan,

Azure CC, Autopilot, Octopus, Jira

Databases : MS SQL Server 2008/2012, Oracle 8i/9i

Concepts : Design Patterns, Functional Points, OOPS and Cloud Computing

Version Control : Team Foundation Server (TFS), Source Depot, Visual Source Safe (VSS),

Accurev

Industry Experience:

Over 13 Years of experience which includes Close to 8 years of SDET experience (Functional, Performance and Lead SDET) and 4 years as a web developer.

Employment Details:

Currently working as a Software Engineer with my current employer HireItPeople LLC (Dec 2013 – current Date).

As an IT Consultant at 3iInfotech, Virgo (Apr 2013 – Dec 2013).

HCL Experience(8 years):

oAs a Senior Technical Lead at HCL America, Bellevue, WA, USA

(Sep 2012- April 2013).

oAs a Test Lead at HCL America, Bellevue, WA, USA

(Mar 2007 – Jun 2012).

oAs a Lead Engineer (developer) in HCL Technologies, Noida, India

(Aug 2005 – Mar 2007).

oAs a Software Engineer (developer) in HCL Technologies, Hong Kong

(Sep 2004 – July 2005).

As a software executive (developer) at Pyxis Technology Solutions Ltd, Visakhapatnam, India (Dec 2002 – Jun 2004).

Education:

Masters In Computer Applications(MCA) (1999-2002)

Bachelor of Science (B.Sc. Computer Science, Mathematics and Statistics) (1996-1999).

Certification:

Microsoft certified Application developer (MCAD)- 2006

Microsoft certified Professional (MCP)- 2006

Achievements:

Secured University first rank in Statistics during the bachelors.

PROFESSIONAL EXPERIENCE:

Client: VISA Duration: (Feb 2015 – Current date)

Vendor SDET Lead Performance/Capacity Testing and Automation

Projects: PII Security, Team-x, Account Updater, Transact and CustomerProfileManagement, Active-Active

Technology Used:

Java

Junit, J2EE (JSP, Servlets, Struts), Eclipse, Web Services (SOAP, WSDL), Tomcat, JDBC, XML, and Oracle

.Net Stack:

SQL Server 2008 R2/2014, HP Load Runner, Vugen, Visual Studio .NET 2010, Fiddler, LINQ, WCF Services, Windows Server 2008/2012, and Selenium.

Responsibilities:

1.As a member of the Performance team handled the performance of different applications at Visa. Some of the applications are using Java and others are in .Net stack.

2.Responsible for End-End Capacity Analysis and execution by analyzing the data from different sources for the capacity testing and identified the major bottleneck for the peak load in Production environment, saving millions of dollars to the company.

3.Involved in automation and troubleshooting of web applications, Web Services, Windows Services developed with C#, ASP.Net, J2EE (JSP, Servlets, Struts), Eclipse, Web Services (SOAP, WSDL), Tomcat, WebSphere, JDBC, XML, and Oracle, SQL Server 2008 using Junit, Nunit, Selenium, Coded Ui, .Net Testing Framework and other tools.

4.Responsible for creating the Perf test Framework.

5.Responsible for defining the workload.

6.Responsible for finding/troubleshooting Performance Issues, Memory leaks, Timeout issues and Deadlocks using HP Load Runner, Vugen, Visual Studio .NET 2010, Fiddler, LINQ, WCF Services, Perfmon, SQl profiler, Visual Studio, HP LoadRunner, Vugen, SQL Server, RiverBed Appinternals(Opnet), Windebug, DebugDialog, Splunk, Wireshark, other tools including Fiddler.

7..Responsible for identifying SQL blocking at the DB, during the deployment and identified the root causes for the blocking.

8.Responsible for identifying various Perf issues in different applications by analyzing various counters, SQL Logs, application logs, execution plans, Opnet and discussing the same with the respective team members and the leads.

9.Provide Performance reports to different teams across VISA and the Perf status reports to the management.

10.Responsible for training the offshore team about the different applications and the technologies being used.

11.Responsible for delegating and sharing the work with the team in India.

12.Responsible for identifying memory leaks in different applications.

13.Reproduced issues identified in the production and analyzed the root cause of the issues.

14.Responsible for getting the base response time and identifying any regressions in performances for different applications at Visa.

15.Responsible for generating the Perf data by automating different web service calls and web tests.

16.Determined the performance bottlenecks of the web servers, application servers and sql boxes by observing different performance parameters.

17.Execute the performance tests for the different applications and verifying whether the results are meeting the requirements.

Previous Experience at Microsoft

Client: Microsoft, WA Duration: (Jun 2007 – Dec 2014)

Technology Used: C#, ODATA, REST, WCF, SQL Server, .Net Framework, Unit Testing Framework, SQL Server 2000/2008 R2/2012, LINQ, Nova, Hive SQl, BigData, Coded UI, Selenium, TAEF, MITA, Visual Studio .NET 2010/2012, WTT, Azure, Httpwatch, Fiddler, Azure CC, ATE (Azure Test Environment), JQuery, Flash, JavaScript, VSTT, VRTA, Windows Server 2008/2012.

AS a Functional SDET:

Responsibilities:

1.Involved in the functional automation for the web application, ASMX/WCF Web Services (SOAP, Rest), using .Net Framework and C#.

2.Responsible for executing the test cases and debugging the failures.

3.Involved in the functional testing and security testing of the App.

4.Involved in the UI Automation using Selenium, Coded UI .

5.Involved in adding the LFM (Logical Function Model) and POM (Physical Object Model) for the app.

6.Developed a windows App for testing the WCF Services.

7.Involved in the deployment of the applications in Test, Performance and Business Assessment environments using octopus.

8.Involved in helping the operation team during the environment configuration and during the deployment.

9.Involved in helping the business by creating the test scripts required to start the UAT.

10.Involved in troubleshooting the WCF services connectivity issues and discussing with the partner teams for the issues identified during the testing.

11.Involved in helping the UAT team for fixing the UAT issues identified.

12.Added automated tests using C# in different test suites to accommodate the new changes for the Mango release (R2).

13.Created different capability XAPs (test Apps using Silverlight) which is used across different teams.

14.Executed the end-end testing for the market place scenarios starting from developer app upload to the end user purchasing an app.

15.Involved in the security testing of the websites.

As a Functional Lead:

Responsibilities:

1.Developed tools which are used by different teams to keep track of their application performance and for reporting.

2.Worked as test lead for different size teams from 2 to 13 members and reviewed the work done by the teams.

3.Worked as a test anchor for Kitchen Cookoff, ASUS Intel and GE campaigns.

4.Authoring the test plans for different projects at Microsoft.

5.Proactively escalate any scheduling conflicts or potential timeline risks across all projects to management.

6.Coordinating test effort with the offshore team and guiding the team.

7.Responsible for driving the daily triages.

As a Performance SDET:

Responsibilities:

1.Responsible for automating the Performance automation scripts, executing the test cases, analyzing and providing the load/performance results of the application using C#.

2.Automated the deployment, execution and analysis process of the Capacity runs using PowerShell,

C#, SQL Server, other tools including Fiddler and HTTPWatch.

3.Responsible for defining the new benchmark based on the historical data.

4.An active member for v- team created for the Server performance and helping different partners to onboard the test framework created by us for the execution and analysis.

5.Develop and maintain various performance tools.

6.Troubleshoot the performance issues in cold servers, application restarts, IIS restarts and cause of the rejected requests based on the IIS logs and other event logs.

7.Execute the Capacity Runs for different benchmarks and for different releases and monitor the performance of the product by analyzing the performance trending reports.

8.Determining the performance bottlenecks of the servers by observing performance parameters like Tests/Sec, Throughput, Request execution Time, Requests/Sec, % Processor Time, SQL Batch Requests/Sec, SQL Dead Locks etc.

9.Reproducing some of the issues identified in the production and analyzing the root cause of the issues.

10.Worked with the SQA Manager and Technical Architecture Team to understand project architecture to execute a performance test strategy.

11.Prepared the SQL script for manipulating the performance data for RP Security authorization.

12.Analyzed the overhead of adding the Auth module by calling the WCF Service with and without auth module.

13.Investigated the memory leaks while running the load.

14.Worked with the SQA Manager and Technical Architecture Team to understand project architecture and business requirements to execute a performance test strategy.

15.Analyzed the overhead of adding the EPP Auth module while calling a WCF service by running the EPP authorization scenarios.

As a SDE:

Responsibilities:

1.Developed tools for IP management using C#, ODATA, LINQ, Men & Mice (SOAP APIs), REST, WCF and SQL Server.

2.Involved in developing reports by querying the big data using Nova and Hive SQl.

3.Responsible for the functional automation using Visual Studio Test framework and C#.

Projects at Microsoft:

Client: Microsoft, WA Duration: (Oct 2013 – Dec 2014)

SDE (Dev)

Project: IP Management (MSG/GFS)

Client: SDE/SDET Duration: (May 2013 – Sep 2013)

SDET (Functional and Performance Automation)

Project: ECO

Client: Microsoft, WA Duration: (Sep 2012 – Apr 2013)

SDET Server Performance, Scalability and Capacity

Project: Office 365 (BOX)

Client: Microsoft, WA Duration: (May 2012 – Aug 2012)

SDET Functional Testing and UI Automation

Project: Knowledge Storage Engine (KSE- Knowledge Management systems)

Client: Microsoft, WA Duration: (Feb 2012 – May 2012)

SDET Functional Testing and UI Automation

Project: Windows8 Application Experience (Appex)

Client: Microsoft, WA Duration: (August 2011 – Jan 2012)

SDET Functional Lead

Project: MSN (SET- Solution Engineering Team

Client: Microsoft, WA Duration: (Mar 2011 – July 2011)

SDET Functional Testing and API Automation

Project: Windows Phone Services (WPS

Client: Microsoft, WA Duration: (Sep 2010 – Feb 2011)

SDET-- Performance Testing and Automation

Project: Zune Enterprise Services Team (ZEST)

Client: Microsoft, WA Duration: (Sep 2008 – Aug 2010)

SDET Test Lead, Functional Testing, Automation and Deployment

Project: TEC (Technical Experts Connection--MVP)

Client: Microsoft, WA Duration: (Jun 2007 – Aug 2008)

SDET --Performance Testing and Automation

Project: EPP (Enterprise Portal Platform)

HCL Technologies:

Technology Used:

ASP.NET, C#, VB.NET, Oracle 9i, Data Reports, XML, XSLT and XSD, ASP.NET, SQL Server2000, VB 6.0, Oracle 8i, UNIX, Windows Server 2003

As a Developer & Sr. Dev

Responsibilities:

Java:

1.Designed Struts Components like Formbeans, Action Classes, JavaBeans.

2.Implemented several JSP pages for displaying account information, Loan applications, Loan fulfillments etc.

3.Implemented several Javascript validations for the JSP pages. Also created Cascading Style sheets, XSLT transformations in the presentation tier.

4.Implemented several Custom Tags for JSP pages.

5.Designed and developed XML services utilized for multiple end Clients.

6.Implemented JUnit automation for testing Java classes’ functionality.

.Net Stack:

1.Designed and developed web pages for the application using ASP.Net, C# and VB.NET.

2.Involved in writing some web services for the application.

3.Created Master Pages, Used Themes and Skins apply that style information to pages or controls in site.

4.Implemented .NET form-based authentication that handles user login authorization

5.Involved in writing the complex stored procedures and involved in the database design

6.Involved in the Internationalization and localization, delivery of multilingual site.

7.Extensively involved in developing server side Class Libraries for Business Layer, Data Layer using C#.

8.Written the data base T-SQL, Triggers, User-Defined functions, and stored procedures in ORACLE and packages in ORACLE.

Projects at HCL Technologies Ltd:

Client: Aristocrat Inc, Las Vegas Duration: (Mar 2007 to May 2007)

Functional Analyst

Project: OASIS (PITBOSS)

Client: Pearson, Chicago Duration: (Mar 2006 – Feb 2007)

Senior Developer:

Java, J2EE (JSP, Servlets, Struts), Web Services (SOAP, WSDL), Tomcat, JDBC and Oracle

Project: Online Recruitment System

Client: Compass, Canada Duration: (Sep 2005 – Feb 2006)

Senior Developer ASP.NET, C#, SQL Server

Project: Compass Invoice Matching System

Client: AEON Credit Services, Hong Kong Duration: (Jan 2005- Aug 2005)

Developer VB 6.0, Oracle 8i

Project: AEON Judgment System

Client: AEON Credit Services, Hong Kong Duration: (Sep 2004 – Dec 2004)

Developer ASP, VB Script, SQL Server

Project: AEON out Door Visit

Pyxis Technology Solutions Ltd.

Technology Used: ASP 3.0, VB Script, SQL Server 2000, HTML, Java script, IIS 5.0, Data Reports, PHP

As a Developer

Responsibilities:

1.Involved in the development of bidding module for SteelExchange.com.

2.Involved in UI Design, Development of processing bugs flow using ASP, VB Script and SQL Server.

3.Worked with client and testing team (third party) for resolution of bugs and errors.

4.Created Database Tables, Triggers, Indexes, Views and Stored Procedures using SQL Server.

5.Developed stored procedures using SQL server 2000.

Client: Visakhapatnam SEZ, India Duration: (Jun 2003 – Jun 2004)

Developer ASP, VBScript, SQL server

Project: VEPZONLINE.COM (IBASE)

Client: Govt. Of India Duration: (Feb 2003 - May 2003)

Developer ASP, VBScript, SQL Server 2000

Project: Steelexchangeindia.com

Client: Pyxis Technology Solutions Ltd, India Duration: (Dec 2002 - Jan 2003)

Developer ASP, SQL Server 2000

Project: Client Addressing System

Contact this candidate