Post Job Free

Resume

Sign in

.NET SQL Developer, C# ASP.NET, VB.NET, SQL Server, SSIS, Ssrs

Location:
San Ramon, CA
Posted:
April 05, 2023

Contact this candidate

Resume:

CONTACT DETAILS

Pleasanton, CA - *****

adwdd6@r.postjobfree.com

925-***-****

TECHNICAL SKILLS

Application development using C#, ASP.net, and VB.net MS SQL Server as Data Base

JavaScript.

SSIS - SQL Server Integration Services, including DTS to SSIS

SSRS – SQL Server Reporting Services

WCF Web Service development and testing

Application upgrade and Migration, IIS configuration

sFTP – Secure File Transfer configuration.

Azure Fundamentals

EDUCATION

Bachelor of Engineering, BE in Computer Science from Visvesvaraya Technological University, India

Sindhu Dattatreya

BACKGROUND

As .Net Developer, responsible for management of project in all stages of SDLC.

10 years of experience in Application Development and maintenance in web-based with Object oriented, N-tier Visual Studio.Net Applications - C#.net, VB.net, ADO.Net, Ajax toolkit, Telerik controls, JavaScript

MS SQL Server - Database design, maintenance, developing performant SQL queries, Stored Procedures, functions, Views and Packages- SSIS

Excellent analytical skills with Proficiency in debugging and Problem Solving.

Project estimation, proposing solution, preparing project milestones, successful at managing a project team, resource planning, reporting progress to client, driving progress towards project delivery with quality.

Good Documentation skills – Design, Release, Server Build books, Run books

Reporting using SQL Server Reporting Services – SSRS and Crystal reports.

Experience in development of WCF web services, deployment, testing and consumption of the same in the application

Worked on migration of application, upgrade of application, upgrade of DTS to SSIS package, FTP to sFTP and complete configuration of application

Good working knowledge on source control systems like SVN, Visual studio team foundation, Bit Bucket

Manual testing - test plan and test cases for web applications

WORK EXPERIENCE

CGI Information Systems and Management consultants Pvt. Ltd., Bangalore, India

PROJECT: .Net Projects - Overall, Customer – Bell (Aug 2010 to Apr 2021)

Applications enhancements, asp.net and VB.net, gathering requirements from client, providing the project estimate by performing analysis of the requirements and application source code.

Worked on design, development of enhancements, including development of new jobs, new application features, defect fixes and supporting the existing applications.

Changes to application UI, changes to complex stored procedures and implementation of two factor authentication for application. JavaScript for client-side operations. Worked on MVC to build a mobile version of the existing application.

Creation and modification of SSIS packages for processing data and generating various reports in excel format and sending via email. Creation and modification of new SSRS reports, changes to existing reports and upgrading the reports.

Unit testing of application, creation of test plan and test cases.

Documentation – Design document, test plan, test cases, DB build book, DB Run book.

Technical Environment:

C#, ASP.net, VB.net, MS SQL Server 2000 to 2017, SSIS, SSRS, JavaScript, Ajax toolkit, Telerik Rad controls, MVC

PROJECT: Merlin Upgrade, Customer – Bell (Jul 2018 to May 2019)

Application Migration, Management of project in all stages of SDLC – Waterfall. Performed project milestones planning, resource planning, progress reporting to clients and on time delivery of project. Worked on upgrade of application framework, Windows feature installation and Server IIS configuration.

Performed upgrade of FTP to sFTP to 5 interfaces, sFTP configuration, including MS SQL DB connectivity to different interface DB like oracle and Ingress by ODBC configuration.

Upgrade of SSIS packages and SSRS reports. Modification of stored procedures and views to remove the depreciated features of MS SQL Server.

Technical Environment:

C#, Asp.net, MS SQL Server 2005 - 2016, VS 2010, SSIS, SSRS

PROJECT: Network Request, Customer – Bell (Apr 2017 to Dec 2019)

Worked on various enhancements of project. Worked on test cases for unit testing and SIT.

Created a WCF web service, addition of new web methods to enable external application to perform a set of operations. Enable the Web service to call the existing COM method and enhance reusability. Usage of SOAP UI for testing the web service. Changes to Visual Basic 6 application and asp pages

Technical Environment:

Visual studio 2012, WCF, MS SQL Server 2012, VB6, Classic ASP, COM components, Registry edits

PROJECT: Focus Reporting System, Customer – Bell (May 2020 to Jan 2021)

Application Migration, Management of project in all stages of SDLC – Waterfall. Performed project milestones planning, resource planning, progress reporting to clients and on time delivery of project.

Performed POC successfully for replacement of obsolete report scheduling software – info desktop. Worked on the upgrade of DTS packages to SSIS packages include rewriting of certain obsolete tasks.

Upgrade of crystal reports using SAP Crystal reports 2016 and scheduling of the reports was done using SAP Crystal server 2016, using this the reports could be extracted in different formats and sent via sFTP or email. Also, worked on creation of test plan and test cases for unit testing and SIT.

Technical Environment:

MS SQL Server 2000, 2019, DTS to SSIS package, Oracle 12c Driver configuration, Crystal reports –Crystal Reports 2016 and Crystal Server 2016 – SAP Business Intelligence

EDUCATION

Bachelor of Engineering, BE in Computer Science from Visvesvaraya Technological University, India

VISA Status:

H4 EAD valid until June 2024

CERTIFICATION:

Microsoft Certified: Azure Fundamentals.



Contact this candidate