Sql Server Software Engineer
Resume:
Deepthi Padavala
+1-210-***-**** / ***************@*****.***
PROFESSIONAL SUMMARY:
Over twelve years of experience in System Analysis, Design, Development, Testing and implementation of software applications.
Experience on developing applications with Tridion CMS.
Extensive design and programming multi-tier web applications and web services using C#, VB.NET, ASP.NET, .NET Core, Type script and MVC frameworks.
Building web applications with ASP.NET MVC, AngularJS, jQuery, JSON, Tridion, HTML, XHTML, and CSS.
Domain knowledge in Entertainment, Manufacturing, Financial, Banking, Insurance and Healthcare industries.
Experience in working with Visual Studio Tools for Office (VSTO), WCF, AJAX, jQuery, Microsoft Test Manager and Enterprise Library.
Extensive experience in Microsoft SQL Server, Microsoft Access and Oracle database Design and implementation with SQL Server 2003/2008/2014.
Having database experience writing Stored Procedures, Functions, Exception Handling, Constraints, Triggers, Index and Views.
Implemented a Continuous Delivery with Jenkins, GitHub, Confluence and JIRA.
Participates in a regular on-call support rotation.
Strong knowledge in SOAP, WSDL and Classic ASP applications
Hands-on experience in Crystal reports development.
Experience on object-oriented development using agile development, design patterns and tiered architecture.
Proficient at grasping new technical concepts quickly and utilize the same in a productive manner.
Extensive use of tools like Visual SourceSafe, TFS for Unit testing, logging and event tracking.
Good Experience in leading a team and mentoring the team members.
Implemented projects using Agile/Scrum methodologies in application development.
Used Telerik and other third-party controls for the effective presentation layer.
Microsoft certified Application Developer in .Net
EDUCATIONAL BACKGROUND
Bachelor of Technology in Computer Science & Engineering
Nagarjuna University, AP, India
TECHNICAL SKILLS
Languages: C#.NET (including 4.X features), Visual Basic.Net, VB Script, AJAX, HTML, JavaScript, Type script SQL/TSQL and PL/SQL.
Technologies: .NET Framework, ASP.NET, MVC, ASP, Windows Services, .NET XML Web Services, Web API, WCF, AJAX, SOAP, Angular JS, WSDL, ADO.NET, UML, XML, XSLT, WCF, SharePoint, Micro services, Silverlight, LINQ, Internet Information Services (IIS), Crystal Reports, COM, ODBC, OLEDB.
CMS: SDL Tridion
RDBMS: Microsoft SQL Server 2000 / 2005 / 2008/2014, Oracle, MS-Access, IBM DB2.
Tools: Microsoft Visual Studio, VSTS 2005, Visual Studio Team Foundation Server (TFS), Enterprise Library, Telerik, Visual SourceSafe, Visio, Rational Rose, MS Project, Adobe PDF, Photoshop, Rally, JIRA, Akamai, GIT, Confluence, Jenkins, Kibana
PROFESSIONAL EXPERIENCE
Senior Programmer Analyst - Universal Studios, Orlando USA 11/12 – Till Date
Universal Orlando Intranet websites: These applications include entrance count for parks, ride counts, lost & found website, Incident reporting, auditions, Park hour’s tool.
Environment: ASP.NET, MVC, C#, .NET, .NET Core Web API, TFS, SQL Server 2014, jQuery, AJAX, XML, Type script, Entity Framework, Node JS, VS 2003 – 2017, Bootstrap
Universal Orlando External websites: These applications include main website for Universal Studios, Sales sites, Media sites and Travel agent websites.
Environment: Tridion 2011/2013, ASP.NET, Type Script, C#, TFS, SQL Server 2008, jQuery, AJAX, XML, Entity Framework, VS 2013, IBM Web Sphere Commerce, GIT
System analysis including gathering and analyzing business requirements and the ability to identify
problems or opportunities and recommend improvement or alternative approach.
Worked as part of an application development and 3rd line support team, contributing to team
projects and developing applications and services
Understand and contribute to a service-oriented architecture, focusing at all times on innovation,
reusability and driving down the costs and time taken to deliver, maintain and support applications. Be
able to manage your own time and workload, and make informed decisions based on available facts
Be able to contribute to, and work from technical design documents, plan and estimate work allocation
and work in an agile development environment
Written functionality, Business rules, validations in .NET.
Maintenance of the existing sites and upcoming changes.
Working on the production issues by identifying issues and bug fixes quickly.
Implemented jQuery and Ajax components to improve performance of the web page.
Performed unit testing for all the development activities.
Involved in deploying the application.
Used content management in Tridion to maintain content and to support quick website changes.
Understand and implement agile methodologies
Identify and resolve problems, working closely with the business and support teams
Consume and produce data from a variety of sources, outputting where necessary to downstream
applications, or updating the source
Developed views and stored procedures using T-SQL.
Involved in content delivery managed in .NET.
Documented the detail functionalities of the software.
Mentoring junior developers and conducting code reviews.
Good communication and problem-solving skills.
Developed web application front-end screens in ASP.NET MVC, JavaScript, Angular.js, bootstrap, CSS3,
HTML5.
Software Engineer - Infosys Technologies Limited, Chennai, India
PAM Application (Policy Approval Manager) 6/08 – 8/11
Client: Microsoft Corporation, USA
Environment: ASP.Net, C#.Net, SQL Server 2008, WCF, Java Script, AJAX, ADO.NET, SQL profiler
This project involved development of an application for the policy approving managers for framing questions for product release checklist. It consists of 2 modules, Admin and Assessment. Primary responsibility includes coding and unit testing. Other major work included owning of two modules within the application.
Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#
Writing SQL to pull data using TSQL accordance with Business Requirements
Involved in Developing and handling the Stored Procedures, Functions.
Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
Written use cases, test cases, class and sequence diagrams in Visio.
Development and designing Web forms in Visual Studio and C#.
Involvement in all phases of life cycle including design, development, testing and deployment.
Involved in debugging, testing and release.
Documenting the Technical and functional features developed.
Deployment of Application on Test and Production Server.
Handled many production issues and enhancement to the existing live portals
SRS (Sponsorship Reservation System)
Client: Microsoft Corporation, USA
Environment: ASP.Net, C#.Net, HTML, XML, SQL Server 2008, WCF, Java Script, AJAX, VSTO
This project will allow easier reservation, management and tracking of Sponsorship sales. Provide a Single, Integrated, Simple to use tool that Shows availability of all Sponsorship.
Writing SQL to pull data using different factors.
Implemented 3-tier architecture including Presentation, Business and Data access Layers.
Written use cases, test cases, class and sequence diagrams in Visio.
Development and designing Web forms in Visual Studio and C#.
Created Stored Procedures in T-SQL.
Experience in using performance monitor/SQL Profiler to resolve long running queries thereby
optimizing query execution plan.
Involved in debugging, testing and release.
Documenting the Technical and functional features developed.
Written functionality, Business rules, validations and WCF service.
Software Engineer - Inspira Technologies Limited, Hyderabad, India 06/05– 05/08
ADCAPS (Automated Document Control & Publishing System)
Client: Analog Devices Inc, USA
Environment: ASP.Net, C#.Net, VB.Net, SQL Server 2000, DHTML, JavaScript, AJAX
ADI is a world-leading semiconductor company. It publishes various technical documents about its products. The application has a customizable work flow engine, user personalization, customizable reminder service and E-Mail alerts. The application integrates with the existing Chipset & Documents website, CTG website and MS Exchange server.
Writing SQL to pull data using different factors.
Implemented 3-tier architecture including Presentation, Business and Data access Layers.
Written use cases, test cases, class and sequence diagrams in Visio.
Development and designing Web forms in Visual Studio and C#.
Performed SQL query optimization using SQL profiler.
Involved in debugging, testing and release.
Documenting the Technical and functional features developed.
Written functionality, Business rules, validations and WCF service.
VBS (Voluntary Benefits Solutions)
Client: VBS Healthcare, U.S.A
Environment: ASP.Net, VB#.Net, SQL Server 2000, Java Script
Insurance based application contains generation of Proposals, enrollment into Policies for Individuals who are working in different companies in USA. This application calculates Premiums from Policies offered by carriers in USA.
Written use cases, class and sequence diagrams in UML.
Development and designing Windows forms in Visual Studio and C#.
Created DTS package for moving the data from Access database to SQL Server.
Evaluating various products for filling and printing pdf from C#.Net including Acrobat.
Uploading the reports to various formats and to FTP site.
Written functionality to be able to look up and reprint previous reports
Documenting the Technical and functional features developed.
Written functionality, validations in the presentation layer.
Extensively used master pages and Cascading style sheets.
Performed Unit testing for the modules developed.
Created Tables, Stored Procedures, Views in T-sql and PL/SQL.
Swagger Website (www.swagger.com)
Environment: ASP.Net, C#, ADO.Net, SQL Server 2000
Swagger provides full-service marketing, promotions, and production services for urban mobile content programs, including contests and live applications, through its mobile community. Swagger helps create and deliver successful mobile applications - including ring tones, wallpapers, screensavers, MP3 files, and videogames.
Development and designing Web forms in Visual Studio and C# and in VB.
Involved in testing of application at module level, system level and User Acceptance level for quality of the software (UAT).
Documenting the Technical and functional features developed.
Written functionality, validations in the presentation layer.
Extensively used master pages and Cascading style sheets.
Performed Unit testing for the modules developed.
Performed validation using Java script.
Website Development
Environment: Windows 2000, ASP.NET with C#, SQL SERVER 2000.
This is a web-based application including of twenty-one different modules. Services like Matrimonial, Classifieds, Networks, News, Forums, Jobs, Message Center, yellow pages are among the important in the application.
Coordinated with COX team for gathering the requirements of the project.
Writing Functional technical specification documents.
Back-End Database Design and Implementation using SQL Server 2000.
Developed Tables, Stored Procedures, Triggers, Functions, Views and Cursors.
Used SQL Profiler and other optimization techniques on SQL scripts.
Implemented SQL Server DTS Packages for extracting the Oracle database details to SQL Server on a timely basis.
Developed Business Objects and components to implement complex business rules without degrading the system performance.
Developed Data Access Layer using Enterprise Library written in C#.NET and VB.Net for seamless connection with the SQL Database.
Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis.
Preformed code reviews for the code developed by the team members
Involved in Deployment of applications with the COX Team
CERTIFICATIONS
MCAD – Microsoft Certified Application Developer.
https://mcp.microsoft.com/authenticate/validatemcp.aspx
Transcript ID: 783910
Access Code: deepthip
Contact this candidate