Resume

Sign in

Project Manager Sql Server

Location:
Katy, Texas, United States
Posted:
January 29, 2018

Contact this candidate

NAGA SANTOSH

Email: ac38va@r.postjobfree.com Cell: (832) ***-****

PROFESSIONAL SUMMARY:

* ***** ** ********** ** analysis, object oriented design, development and implementation of client/server and web based applications using the latest technologies.

Expertise in Microsoft .Net technologies C#, ASP.NET, ADO.NET, VB.NET, .NET Web Services and Windows Presentation Foundation (WPF), Win Forms, WCF, WebAPI, Silverlight 5.0/4.0.

Experience with the .net frameworks version 3.5 or Greater, C#, GUI client application developer.

Experience with Web Forms, CSS, ASP.NET AJAX, and JavaScript, UI design and development, consuming and manipulating data using ADO. NET. Proficient with .NET Web Services using WSDL, SOAP and UDDI.

Have a good understanding of TFS 2010.

Thorough understanding of web technologies like HTML, XHTML, DHTML, XML, XSLT JavaScript, AngularJS, JQuery and Bootstrap.

Thorough knowledge of design patterns like MVP, MVC, MVVM Patterns and Singleton Patterns.

Experienced in LINQ (Language Integrated Query Language), LINQ to SQL, LINQ to Objects, Entity Framework.

Ability to work under strict deadlines and worked as an active team member

Experienced in understanding the design, performing in-depth application analysis, modify. Having excellent documentation skills and Ability to write Test cases and Scenarios from requirements.

Used Advanced C# Concepts like Multi-Threading for making Application Time efficient during the Refactoring the applications.

Designed and Developed Crystal Reports such as List Reports, Parametrized, Mail Label, Cross tab Reports using the base Tables, Views, Commands, involving Formulas, SubTotals, Running totals and Sub Reports.

Expertise in implementation of Crystal Enterprise report publishing and scheduling in info view.

Involved in development of projects using SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS).

Strong Trouble-shooting, Problem solving, Analytical & Design Skills.

Worked as a part of team in 24x7 environment and provided on-call and day-to-day support.

Expertise in Design and Development of User Interfaces, User Controls and Custom Controls using ASP.NET and C#.

Good work experience in MS SQL Server 2000/2005/2008, Oracle 9i, Oracle 10g and Oracle 11g. Knowledge in developing stored procedures functions and triggers using T-SQL and PL/SQL.

Worked on .NET Security features such as Authentication & Authorization, Forms-based Authentication, Authorizing Users, Roles and User Account Impersonation.

Experienced in writing SQL Queries, Stored Procedures, UDFs, Functions, Triggers, Indexes, Views in SQL Server 2000/2005 and Oracle 9i/10G./11G

Strong knowledge of Object Oriented Design Methodologies.

Experience in Software Development Patterns like “Agile software development”, “MVC/ MVP (Model-View-Controller) Architecture and Three-tier.

Willingness to work in a highly dynamic environment and ready to take up challenges.

TECHNICAL SUMMARY:

.NET Technologies

.NET Framework 4.0/3.5/3.0/2.0, ASP.NET MVC 4.5/3/1, ADO.NET, Web Services, WCF, WPF, XSLT, XSD, LINQ, UDDI, WSDL, AJAX, Silverlight 4.0, IIS 7/6, SharePoint 2010 / 2007.

Programming Languages

C, C++, C#, VB.NET, VB 6.0, SQL

Web Technologies

HTML, DHTML, CSS, XML, ASP, ASP.NET

Databases

MS SQL Server 2008/2005/2002, Oracle 11g/10g/9i/8i, MS ACCESS

GUI / CUI / IDE

Microsoft Visual Studio 2012/2010/2008/2005/2003/6.0, Eclipse IDE

Reporting Tools

SSRS 2008/2005, Crystal Reports 11.0/10.0, SSIS

Testing Tools

Nunit, TestNG, Q unit, Karma

Operating Systems

Windows Server 2008/2003, Windows 7/Vista/ XP

Scripting

JavaScript, VB Script, PHP, JQuery, AngularJS, TypeScript

Development Tools

Microsoft Visual Studio 2010/2008/2005/2003, Edit Plus, Photoshop 2010, Dream Weaver, Jasmine, MS Visio, SQL Server Management Studio 2008 / 2005

Protocols

HTTP, TCP, FTP, SMTP, SOAP

Others

Team Foundation Server, Tortoise Sub Version, Jenkins, Visual Source Safe 2008, SSIS

PROFESSIONAL EXPERIENCE:

Client Name: Cardinal Health Systems Sep 2016 – Till Date

Houston, TX

Role: Sr. .Net Developer

Description: Worked on IDS TechRefresh Project where enhancement and Migration of ASP applications and ASP.NET Web Applications’ is performed. Functionalities of the Applications’ are Revised and Migrated.

Responsibilities:-

Analyzing and reviewing the Code Functionality, business requirements, design document and functional requirements document.

Analyze, Maintain, Migrate Legacy VB Script/ASP Classic & ASP.NET applications and Websites.

New Development and Maintenance Enhancements of ASP.Net applications featuring C#

Design, develop and maintain SQL Server/Entity Framework based applications. Stored Procedures and User Define Functions development.

Participated in the architecture remodeling of ASP Application to MVC framework.

Maintaining the Version Control of the Project in Team Foundation Server (TFS) by merging the module developed with latest version in TFS.

Implemented Server Side and Client Side Validation modules using Validation Controls and JavaScript.

Responsible for Creating Crystal Reports datasets from simple to very complex, Ad-Hoc reports, stored procedures, views, functions.

Deployed Crystal Reports in BO Servers, Migrated Crystal Reports to newer Crystal Report Versions (SAP Business Objects).

Refactored the existing applications, Converted the Synchronous processes to Asynchronous using Multi-Threading.

Reduced the Load and other Flow of Control time using Multi-Threading.

Committed the Source Code of Applications into SVN using Tortoise SVN.

Writing Stored Procedures in SQL Server 2012 R2 and investigating the bug fixes in database.

Performed changes to some applications involving Classic ASP.

Used JavaScript libraries like JQuery for client side validations.

Used JavaScript libraries for Client side validations and Ajax calls.

Created WCF services to fetch data from SQL Server 2012.

Created stored procedures and indexes to improve data performance.

Performed Unit testing and Integration Testing using Mock Framework.

Used TFS for source control, and tracking work items for the sprints.

Implemented Agile Methodologies such as Scrum, and Test Driven Development (TDD).

Participated in various Client meetings with the team and the Project manager to discuss improvements amendments in the development of the application.

Environment: C#, ASP.NET, Classic ASP, ASP.NET MVC, Visual Studio 2005, 2010, 2015, .NET Framework 2.0, 4.5, SQL Server 2012 R2, JavaScript, JQuery, HTML 5, Jenkins, Tortoise SVN, AJAX, C#,WCF, ADO.NET, Stored Procedures, SSIS, SSRS, Crystal Reports.

Client Name: Bank of America, NC May 2015 – Aug 2016

Charlotte, NC

Role: Sr. .Net Developer

Description: Worked on Web Application where we maintain all customer accounts data. The data would be maintained and stored by our team for usage of rest of the teams for several purposes like offers tracking, credit score tracking, customer personal information and Customer Relation Management.

Responsibilities:

Analyzing and reviewing the business requirements, design document, use cases and functional requirements document.

Developed web pages using Kendo UI controls and JavaScript libraries Knockout.js.

Developed Model Web Pages using partial views in Iframes.

Understanding and implementing Typescript formatting with knockout JS.

Used JavaScript libraries, AngularJS and JQuery for client side validations.

Used JavaScript libraries for Client side validations and Ajax calls.

Created WCF services to fetch data from SQL Server 2010.

Implemented Data Annotations on View Models.

Vehement participation in change control Management.

Created stored procedures and indexes to improve data performance.

Created reports using Component One reports.

Performed Unit testing and Integration Testing using Mock Framework.

Automate Unit Testing Jasmine to ensure code quality before pushing to production.

Used TFS for source control, and tracking work items for the sprints.

Implemented Agile Methodologies such as Scrum, and Test Driven Development (TDD).

Participated in various Client meetings with the team and the Project manager to discuss improvements amendments in the development of the application.

Environment: Visual Studio 2013, .NET Framework 4.5,SQL Server 2010, JQuery, JavaScript, AngularJS Libraries, Jasmine, AJAX, Typescript, Kendo UI Controls, MVC 4, C#,WCF, ADO.NET, Jenkins, Tortoise SVN.

Client: Boeing Jan 2014 – March 2015

Long Beach, CA

Role: .Net Developer

Customized Budget Management (CBM) is a web application to manage the bills submitted by employees to their managers within the company. Using CBM bills are classified, Queued processed and passed to respective managers. The owner of bill is facilitated by CBM to track the status of submitted bill anytime.

Responsibilities:

Worked with the Architect to drive out requirements of the project and design the application.

Participated in the architecture designing of asp.net application to MVC framework.

Involved in requirement gathering, database design, n-Tier Application development, User Interface, Business Layer, Rules Engine, Data Layer, Reports, XML Wrappers to manage and pass XML across modules, Web Services, Workflow Development, system integration and Build process.

Created DTS Packages using MS SQL. Implemented DBMS concepts in this project.

Designed the database, wrote stored procedures, functions, views and triggers in SQL Server 2005.

Extensively used XML for data passing between modules and applications.

Designed and developed dynamic ASPX web pages using C#, ASP.Net, XML, HTML, Java Script and JQuery.

Designed user interface w eb forms using ASP.NET / Javascript libraries and implemented business logic using C#.

Designed and developed various abstract classes, interfaces, classes to construct the business and data tier using C#, ADO.NET.

Used ASP.NET 3.5 User Controls and Rich Controls (Multi Views, Wizards) to create forms for submitting and modifying events and forms. Involved in creating the logic for several modules.

Used Cookies, Session and Application objects for State Management at client side and server side.

Worked With ASP.NET Web Parts, Navigation Control and Master Pages and developed Cascading style sheets (CSS) for consistent look and feel of the website.

Used Data Contract as the standard mechanism in the WCF for serializing .NET object types into XML.

Used Ajax, JavaScript for validations and post-backs, CSS controls for enhanced interfaces in the UI.

Using Expression Blend, I created a SilverLight banner XAML UI’s.

Developed Web Services using Windows Communication Foundation (WCF) for integration with other systems.

Created and consumed services using WCF, C# to generate and e-mail those reports to the requested user.

Developed Custom User and Web Controls (Validation, Status Bar, Grid Control).

Used Factory Design Patterns to ease the development and make the system modular.

Used Enterprise library for Logging, Caching, Database and Exception handling, Application handling blocks.

Used Qunit Framework for testing JavaScript Code.

Managed Build process from Development, testing till staging.

Used Web Services, SOAP protocols and WSDL to publish the metadata information to clients.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Modal Popup Extender within some web pages.

Planned, managed and executed the project from planning to delivery Utilizing Agile Scrum Methodologies.

Written SQL Scripts, Stored Procedures, and Triggers, Defining roles, creating database users and Assigning Roles to users in SQL Server 2008 using T-SQL.

Used Team Foundation Server (TFS) for all the source code maintenance needs.

Used N - unit to implement Unit, Integration and Regression Testing.

Environment:.NET Framework 3.5, Visual Studio 2008, WCF, WPF, MVC, ASP.NET 3.5, C#, DBMS, Web Services, AJAX, Qunit, JQuery, XML, XAML, SilverLight, XSLT, SSRS, JavaScript, SQL Server 2005, SQL Server 2008, T-SQL, TFS, IIS

Client: NIKE Feb 2013 – Dec 2013

Portland, Oregon

Role: .Net Developer

Description: NIKE Erudition System is a web application developed for making various customized or relevant courses available for employees, conduct exams for employees and evaluate their performances.

Responsibilities:

Analyzing and reviewing the business requirements, design document, use cases and functional requirements document.

Developed UI using WPF UI elements and MVC framework.

Created web services to fetch data from ITRAC Oracle database.

Application is built using ASP.Net, C#, .Net Framework 3.5

Implemented abstract, sealed classes, interfaces and classes to construct the business and data tier using C# and Entity Framework.

Used DevExpress XAML Controls to modify Grids.

Implemented DBMS concepts in this project.

Created XAML dialogs/Views to work with MVVM pattern to create new functionality and fix existing code.

Used JavaScript libraries and JQuery for client side validations.

Developed and deployed the application on a Windows 2008 Web Server.

Performed thorough testing using NUnit.

Have taken the ownership and maintenance of the application from the requirements phase to post deployment support.

Scheduled Oracle jobs to stage the data from the main server to the Applications Server.

Created stored procedures and indexes to improve data performance.

Created reports using Component One reports.

Employed the Agile/Scrum methodology to implement the application.

Used Tortoise Subversion for source control, data collection, reporting and project tracking.

Participated in various Client meetings with the team and the Project manager to discuss improvements amendments in the development of the application.

Created some crystal Reports

Environment: Visual Studio 2010, .NET Framework 3.5, MVVM, WPF, XAML, DevExpress, Oracle 10g, JQuery, JavaScript Libraries, AngularJS, Web API

Client: IBM-Telstra, Chennai, India Sept 2010 - Oct 2012

Role: Dot.Net Developer

Project Name: Mobiles Helpdesk

Description: Mobiles Helpdesk is a Front End Application Used by the CSR (Customer service representative) i.e., call center personnel’s, of Telstra in Australia. It is the largest VB application with over 180 screens. Each screen presents to the CSR the details of the Customer holding a particular account.

Responsibilities:

Interact with the Business users to collect the requirements and developed a Prototype for the application.

Developed and maintained the application in vb6 for some time.

Initiated the migration into ASP.Net and actively participated in the designing of the architectural framework of the asp.net application.

Designed and implemented the Business Layer/assemblies and strongly typed dataset to support the business logic for the GUI User Controls process Using ASP.NET.

Developed the application using VS 2003, Net 1.0, C#.net, MS Access, Fujitsu COBOL, and SQL Server.

Extensively used User Controls, Validation Controls and applied Object Oriented methodology to create Three Tier Application.

Worked extensively on the database Design, creating tables, writing stored procedures in SQL.

Created the stored procedures to apply various business rules on the data.

Migrated the application from classic asp to asp.net

Interpreted the COBOL procedures and data objects from asp to asp.net.

Involved in the enhancements, modifications and unit testing for the existing applications.

Train and mentor members of project groups and involve in peer code review.

Participated in end to end White box testing

Participated in various client meetings throughout the SDLC of the application.

Environment: VS 2003,C#.NET, VB.Net, MS Access, COBOL, Sheridian Data Widgets, VB6.0,Third Party Controls, SharePoint, Eclipse

EDUCATION:

Bachelor of Technology (B.Tech) in Computer Science Engineering, JNTU, India



Contact this candidate