Post Job Free

Resume

Sign in

Information Technology Sql Server

Location:
South Windsor, CT
Posted:
December 14, 2023

Contact this candidate

Resume:

Srinivasa Chakravarty Chalikonda

US Citizen

EDUCATION:

Master’s in computer applications from Osmania University, 1994.

SUMMARY OF EXPERIENCE:

Over 26+ years of professional IT experience in Leading, managing, and supporting various software projects.

I have good knowledge and experience in the latest Microsoft Technologies, Oracle, and JAVA, including software development, server configuration, database administration, analytical processing, and complex report generation.

Extensive experience in all SDLC life cycle phases, including System Analysis, Design (architecture), Development, Implementation of Web-Based Applications, Server-side Applications, and Object-Oriented applications, Client/Server, Internet/Intranet, Windows, Web, stand-alone and Distributed applications.

DETAILED EXPERIENCE:

DEPT OF PUBLIC HEALTH, CT

INFORMATION TECHNOLOGY SUBJECT MATTER EXPERT

2/21 – PRESENT

TECHNOLOGIES USED: Windows Server 2016, .NET Framework 4.7, Visual Studio 2019, MVC6/5/4 with razor view engine, ASP.NET, ASP.NET Core, AJAX, C#.NET, JQuery1.8.x, SQL Server 2019, SSRS Reports, and SSIS.

RESPONSIBILITIES:

Certified Project Management Professional (PMP) from PMI.

Actively working with a team on DPH Project Excellence initiatives to modernize the DPH application development.

Coordinate and work with the PMO team to develop various projects.

Coordinated budget planning and project allocation at DPH.

Extensively worked with Vendors to coordinate multiple projects at DPH.

Led the team of DPH IT Analysts and consultants at DPH.

As a project manager, participated in developing architectural designs; recommended policies, procedures, and associated technical implementation standards in DPH applications.

Architected and implemented the secured registration, single sign-on, and self-service password setup DPH-facing portals.

Architected DPH public-facing electronic and web-based portal applications.

Architected and implemented the SSRS server.

Created and implemented a change control process at DPH.

Created and recommended DPH database environments and policies and procedures for the databases hosted at BEST servers.

Prepared network diagrams, application flow charts, and database design for a web portal hosted at BEST.

Assisted with escalated Tier III support issues open in the DPH Helpdesk and Track IT tickets; Resolved all the tickets on time.

Created and implemented the coding standard development process of the DPH applications hosted at BEST IIS Servers in Windows Server 2016.

Worked with BEST infrastructure, network, security, and database teams to set up the DPH public-facing portals.

Conduct weekly development team review meetings and update the weekly status updates to the management.

Train and assist IT analysts and consultants on Microsoft technology, including ASP.NET MVC, C#, and SQL Server.

Led a team that utilizes Microsoft Azure DevOps server or Microsoft (MS) Team Foundation Server.

I led a contact tracing project that utilizes Dynamics as software as a service.

DEPT OF PUBLIC HEALTH, CT

INFORMATION TECHNOLOGY ANALYST 3

3/20 – 2/21

TECHNOLOGIES USED: Windows Server 2016, .NET Framework 4.7, Visual Studio 2019, MVC6/5/4 with razor view engine, ASP.NET, ASP.NET Core, AJAX, C#.NET, JQuery1.8.x, SQL Server 2019, SSRS Reports, and SSIS.

RESPONSIBILITIES:

Involved in multiple COVID data collection, travel, and vaccination projects.

Involved in leading the team of IT Analysts and IT consultants. Managed multiple projects. IT budgeting, technology, vendor selection, project planning, and work allocation for various IT projects.

Extensively involved and worked on COVID data collection web and mobile portals and generated reporting data for hospitals, nursing homes, and schools. Also engaged in COVID travel-related and travel restriction projects.

I am involved in all phases (system analysis, requirement gathering, design, development, unit testing, and deployment) of the software development life cycle for the various Internet and client-server applications.

I acted as a SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

I am involved in the architecture of various browser-based applications.

I am Involved in policies and procedures and coding standards for various projects.

I am involved in setting up the SQL database server environments for development, staging, and production.

I am involved in redesigning and re-engineering old legacy applications from Excel, Access, and Oracle to SQL Server.

Involved in migrating the Access and Oracle databases into Microsoft SQL Server. Involved in database design of various applications.

I am involved in creating SQL Server Reporting Server (SSRS) for staging and production environments and developing Reports using SSRS.

I am involved in setting up and maintaining the TFS environment for DPH IT.

I am involved with DAS/BEST in deploying public-facing web applications and also engaged in TRB sessions for various projects.

I work with SOW and vendor selection processes for various projects.

I work with vendors in multiple DPH projects (Covid Reporting, Travel Forms, DPH Helpdesk ticketing, and FLIS Events Reporting portal).

DEPT OF SOCIAL SERVICES, CT

INFORMATION TECHNOLOGY ANALYST 3

10/18 – 3/20

TECHNOLOGIES USED: Windows Server 2012, .NET Framework 4.7, Visual Studio 2019, MVC6/5/4 with razor view engine, ASP.NET, AJAX, C#.NET, JQuery1.8.x, SQL Server 2017, SSRS Reports, and SSIS.

RESPONSIBILITIES:

I am involved in all phases (system analysis, requirement gathering, design, development, unit testing, and deployment) of the software development life cycle for the various Internet and client-server applications.

I am involved in the architecture of various browser-based applications.

I am Involved in policies and procedures and coding standards for various projects.

I am involved in setting up the SQL database server environments for development, staging, and production.

I am involved in creating SQL Server Reporting Server (SSRS) for staging and production environments and developing Reports using SSRS.

I am involved with DAS/BEST in deploying public-facing web applications.

I acted as a SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

Involved in maintaining the various internet and intranet applications PACS, CFI Tracking, FRDCO, MFP, CITS/NEMT, etc., using ASP.NET web forms

DEPT OF PUBLIC HEALTH, CT

INFORMATION TECHNOLOGY ANALYST 3

3/20 – PRESENT

TECHNOLOGIES USED: Windows Server 2016, .NET Framework 4.7, Visual Studio 2019, MVC6/5/4 with razor view engine, ASP.NET, ASP.NET Core, AJAX, C#.NET, JQuery1.8.x, SQL Server 2019, SSRS Reports, and SSIS.

RESPONSIBILITIES:

Involved in multiple COVID data collection, travel, and vaccination projects.

Involved in leading the team of IT Analysts and IT consultants. Managed multiple projects. IT budgeting, technology, vendor selection, project planning, and work allocation for various IT projects.

Extensively involved and worked on COVID data collection web and mobile portals and generated reporting data for hospitals, nursing homes, and schools. also involved in COVID travel-related and travel restriction projects.

I am involved in all phases (system analysis, requirement gathering, design, development, unit testing, and deployment) of the software development life cycle for the various Internet and client-server applications.

I acted as a SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

I am involved in the architecture of various browser-based applications.

I am Involved in policies and procedures and coding standards for various projects.

I am involved in setting up the SQL database server environments for development, staging, and production.

I am involved in redesigning and re-engineering old legacy applications from Excel, Access, and Oracle to SQL Server.

Involved in migrating the Access and Oracle databases into Microsoft SQL Server. Involved in database design of various applications.

I am involved in creating SQL Server Reporting Server (SSRS) for staging and production environments and developing Reports using SSRS.

I am involved in the setup and maintenance of the TFS environment for DPH IT.

I am involved with DAS/BEST in deploying public-facing web applications and also involved in TRB sessions for various projects.

I work with SOW and vendor selection processes for various projects.

I work with vendors in multiple DPH projects (Covid Reporting, Travel Forms, DPH Helpdesk ticketing, and FLIS Events Reporting portal).

DEPT OF SOCIAL SERVICES, CT

INFORMATION TECHNOLOGY ANALYST 3

10/18 – 3/20

TECHNOLOGIES USED: Windows Server 2012, .NET Framework 4.7, Visual Studio 2019, MVC6/5/4 with razor view engine, ASP.NET, AJAX, C#.NET, JQuery1.8.x, SQL Server 2017, SSRS Reports, and SSIS.

RESPONSIBILITIES:

I am involved in all phases (system analysis, requirement gathering, design, development, unit testing, and deployment) of the software development life cycle for the various Internet and client-server applications.

I am involved in the architecture of various browser-based applications.

I am Involved in policies and procedures and coding standards for various projects.

I am involved in setting up the SQL database server environments for development, staging, and production.

I am involved in creating SQL Server Reporting Server (SSRS) for staging and production environments and developing Reports using SSRS.

I am involved with DAS/BEST in deploying public-facing web applications.

I acted as a SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

Involved in maintaining the various internet and intranet applications PACS, CFI Tracking, FRDCO, MFP, CITS/NEMT, etc., using ASP.NET web forms

DEPT OF PUBLIC HEALTH/OHCA/OHS, CT

INFORMATION TECHNOLOGY ANALYST 3

10/12 – 10/18

TECHNOLOGIES USED: Windows Server 2012, .NET Framework 4.7, Visual Studio 2017, MVC6/5/4 with razor view engine, ASP.NET, AJAX, C#.NET, JQuery1.8.x, SQL Server 2017, SSRS Reports, and SSIS.

RESPONSIBILITIES:

Involved in leading the team of IT Analysts and IT consultants. Managed multiple projects. IT budgeting, technology, vendor selection, project planning, and work allocation for various IT projects.

I am involved in all phases (system analysis, requirement gathering, design, development, unit testing, and deployment) of the software development life cycle for the various Internet and client-server applications.

I acted as a SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

I am involved in the architecture of various browser-based applications.

I am Involved in policies and procedures and coding standards for various projects.

I am involved in setting up the SQL database server environments for development, staging, and production.

I am involved in redesigning and re-engineering old legacy applications from Excel, Access, and Oracle to SQL Server.

Involved in migrating the Access and Oracle databases into Microsoft SQL Server. Involved in database design of various applications.

I am involved in creating SQL Server Reporting Server (SSRS) for staging and production environments and developing Reports using SSRS.

I am involved in setting up and maintaining the TFS environment for DPH IT.

I am involved with DAS/BEST in deploying public-facing web applications and in TRB sessions for various projects.

I work with SOW and vendor selection processes for various projects.

I work with vendors in multiple DPH projects (Inpatient data collection, GIS web-based application, CTWIC, ConnVRS, and Hospital Reporting System).

SS&C TECHNOLOGY, CT

PROJECT LEAD

02/12 – 10/2012

TECHNOLOGIES USED: Windows Server 2008, .NET Framework 4.0, Visual Studio 2010, MVC4, ASP.NET, AJAX, C#.NET, JQuery, SQL Server 2008 R2, SSRS Reports and SSIS, Report Builder 3.0.

RESPONSIBILITIES:

Acting SQL Server DBA and Project coordinator for various web-based applications using Microsoft technologies.

Involved in the Agile software development process to develop and maintain the SSCDirect.com Web Reporting Portal.

Involved in all SDLC phases (requirement gathering, design, development, unit testing, and deployment) for developing the SSCDirect.com module development using MVC4 with razor view engine.

I am involved in developing the SSCDirect.com module front using C#, MVC4, AJAX, and JQuery1.7.x. Report Builder 3.0.

I am developing SOA Web services for WCF in IIS7.5.

Involved in developing Stored Procedures and Functions in SQL Server 2008.

I am involved in creating and Maintaining SSIS packages and scheduled jobs.

Involved in creating SSRS reports using Report Builder 3.0.

Involved in developing, Staging, and production report servers and deploying SSRS reports into the SSRS reporting Server in Windows Server 2008.

MCKESSON (MOORE MEDICAL, LLC), CT

PROJECT LEAD

07/11 – 01/12

TECHNOLOGIES USED: Windows Server 2008, BizTalk Server 2010, .NET Framework 4.0, Visual Studio 2010, MVC3, ASP.NET, AJAX, jQuery, C#.NET, DB2 database in AS 400, SQL SERVER 2008, BIDS, SSIS, SSRS Reporting Server, IIS, WCF, and SOA Architecture.

RESPONSIBILITIES:

Involved in Agile software development background and knowledge (Scrum framework for project management).

I am involved in all phases of SDLC for developing the New Quote tool project.

I am involved in developing the front Quotes and Order process using MVC with razor view engine, C#, LINQ, jQuery, and Entity Framework 4.3.

I am involved in developing SOA Web services using WCF for Pricing, Product Catalog Management, Quote Management, and Order Processing Management.

Involved in creating transactional, schedule, and monthly reports using SSRS.

DEPARTMENT OF LABOR, CT

INFORMATION TECHNOLOGY ANALYST 2

11/06 – 06/2011

TECHNOLOGIES USED: Windows Server, .NET Framework 1.1/2.0/3.5, ASP.NET, C#.NET, DB2, SQL Server 2000/2008, BIDS, SSIS, Reporting Server, and IIS

WCF (both Web Services and DOTNET Remoting) and CSLA Architecture,

Access Net (COM and VB6.0), Entity Framework 3.5

RESPONSIBILITIES:

Project Lead for DOL Web Intake Modernization project.

I am managing multiple Client-Server and Web applications.

oCall center application (Smart Client / Client-Server)

oTICS – Web claim processing and inquiry system

oEUC – Emergency unemployment compensation

oDirect Benefits

oPrevailing Wage Rates n-tier web application

o1099 Web application

oWage and Hour transcripts (Windows-based application) using the Microsoft Sync Framework.

As a workgroup member involved in project management, requirement gathering, and designing the Direct Benefit (Direct Deposit/Debit Cards) application.

Participated in and prepared the requirements gathering and Use case development for the Modernization project.

Gather the requirements, design, develop, Test, and implement the various client-server and web applications using ASP.NET and VB.NET, C#, DB2, and SQL Server as the back end.

Installing, managing, and maintaining VSS database for version control for various projects in CT DOL.

Involved and conducted Load balance test for high volume testing using VSTS for the Web Servers, Application Servers, and Database Servers.

Written Unit Test Cases and System Integration Test Cases.

I am involved in helping in the business users in the UAT.

PREMISE DEVELOPMENT CORP, HARTFORD, CT

SR. SOFTWARE ENGINEER

03/04 – 10/06

TECHNOLOGIES USED: Windows 2003, ASP.NET, and C#.NET, Oracle 9i, SQL Server 2000, IIS, Visual Studio 2003, DOTNET Framework 1.1

RESPONSIBILITIES:

Involved in Architecting Web applications using best practices and better design patterns.

Involved in gathering the requirements, Designing, Developing, Testing, and implementing the supply chain management using ASP.NET, Oracle 9i/SQL SERVER2000 as the back end.

Involved in developing the front Web GUI using the Web Forms, Web User Controls, using Flash 3rd party components like KPIs, Gauges, and Graphs to develop dashboards in web pages, using CSS for Look and feel formatting, using JavaScript for client-side validations.

I am involved in Designing and Developing a Configuration utility tool using ASP.NET & C#.

I am involved in Designing and Developing Dashboard pages using ASP.NET & C#.

PRATT AND WHITNEY - ADEM, EAST HARTFORD, CT, THRU INFOTECH TECHNOLOGIES

SR. PROGRAMMER ANALYST

12/02 – 03/04

TECHNOLOGIES USED: Windows 2000, Oracle 8.1.7, Toad, ERWIN, VISIO, ASP.NET 1.1 & C#, IIS application server.

RESPONSIBILITIES:

Involved in Developing, Testing, and Maintaining various Web applications using ASP.NET Webforms.

TEACHER’S RETIREMENT BOARD, HARTFORD, CT, THRU PARADIGM INFOTECH

SR. PROGRAMMER ANALYST

6/01 – 12/02

TECHNOLOGIES USED: Windows NT, ORACLE 8.1.7, ASP.NET, SQL Navigator, TOAD, and MS Project.

RESPONSIBILITIES:

Involved in Designing and Modeling the existing product to suit the customization requirements.

Involved in Data Modeling using ERWIN (Logical Data Modeling and Physical Data Modeling)

Involved in Designing databases, business logic, screens, and reports using Delphi and Crystal Reports.

I am involved in developing payroll, health, and tax extract modules using PL/SQL procedures/functions.

I am involved in developing various payroll and health reports using Oracle Forms.

I am involved in data conversion from Mainframe to Client/Server application using Front end ASP.NET Web Forms and backend Oracle database.

MERRILL LYNCH, NEW YORK, NY, THRU PARADIGM INFOTECH

PROGRAMMER ANALYST

6/00 – 5/01

TECHNOLOGIES USED: UNIX (Sun Solaris), Oracle 8.1.5, Oracle Forms 6i, Oracle Reports 6i, and Oracle Web application Server4.

RESPONSIBILITIES:

Involved in System Study and Requirements Analysis

Involved in Designing databases, business logic, screens, and reports

Involved in Data Modeling using ERWIN (Logical Data Modeling, Physical Data Modeling, Skeleton Reports)

Involved in front-end application development using Oracle Forms.

I am involved in generating reports using Oracle Reports.

AC NIELSEN, GREEN BAY, WI THRU PARADIGM INFOTECH

SOFTWARE PROGRAMMER

1/98 – 5/00

TECHNOLOGIES USED: Unix (Sun Solaris), Oracle 8.51, JAVA, JSP, Oracle Forms 6, Oracle Reports 6, and Oracle Web application server 3.1.

RESPONSIBILITIES:

Involved in the System Study and Requirements Analysis.

I am involved in Design, including databases, business logic, screens, and reports.

I am involved in Developing the front-end application using Oracle Forms6 and Oracle Reports6 and ORACLE as the back end.

I have been involved in the Tracking & Support of Web-Based applications.

TATA CONSULTING SERVICES, INDIA

CLIENT - TRINKUS UND BURKHARDT, GERMANY, THRU TATA CONSULTANCY SERVICES

SOFTWARE PROGRAMMER

6/96 – 12/97

TECHNOLOGIES USED: UNIX (Sun Solaris), Oracle 8.51, Oracle Forms 6 and Oracle Reports 6

RESPONSIBILITIES:

Involved in the development of the online screen using Oracle Forms 6.

I am involved in generating reports using Oracle Reports 6.

I am involved in maintaining and supporting the credit card application.

ELECTRONIC CORPORATION INDIA LIMITED - COMPUTER MAINTENANCE GROUP

SOFTWARE PROGRAMMER

4/94 – 5/96

TECHNOLOGIES USED: UNIX (Sun Solaris 2.6), Oracle 8, OWAS4, PL/SQL, SQL, and Developer 2000(Forms 4.5 & Report Writer 3.0), Pro*C, SQL Navigator 3, ERWIN and VB6.

RESPONSIBILITIES:

Involved in maintaining and supporting the application.

Involved in developing, testing, and implementation of online screens using Forms 5 and generating reports using Report Writer 3.0.

CONTACT NUMBER: 860-***-****

E-MAIL: ad1ype@r.postjobfree.com



Contact this candidate