Sekhar S. Chitta Phone: 704-***-****

E-mail: adjkl3@r.postjobfree.com 980-***-****

HIGHLIGHTS

Seasoned IT professional with over 25 years involvement in the design and development of large and mid size projects in Healthcare, Banking, SACWIS, State Government projects

Involved in various stages of SDLC including requirement gathering, analysis, design, develop, post Go-Live support, maintenance, end-user training documentation

Handled Clinical applications of Paragon HIS Suite

Maintained Compensation application in Banking industry

Staging Android devices to install Mobile Specimen Collection Application

Translate Business Requirements to Data model and Database objects

Creation of Statistical Reports to help analyze data for Programme funds allocation

Demonstrated strong analytical and problem solving skills and excellent team player

Handled multiple tasks well, detail oriented and effectively managed multiple priorities

Unit, Integration testing and assist Support analyzing defects

Development in Waterfall and also Agile

Coordinating with off-shore development teams and reviewing the work

Training and Mentoring new team members and timely status update to the management

Skills Summary

Extensive knowledge in developing Powerbuilder, Oracle, Sybase, MS SQL Server Apps

Good knowledge in .Net/C# skills

Working knowledge in Snowflake, Python, HTML, CSS

Focused on utilizing Object Oriented Programming concepts (OOPs)

Analyze build breaks and rectify immediately

Worked on multiple databases like Oracle, Sybase, MS SQL Server, Informix, MS Access

Fine tuning of SQL queries to improve performance

Handled multiple product releases in multiple environments very well

Assist Support analyzing defects so that only real defects are created

Knowledge in web development with Visual Studio .Net

Rest APIs creation using C# on Data Access Layer (DAL)

Creation of Android packages and Staging of Zebra Android devices using StageNow

Familiarity with AWS S3, Azure DevOps, Postman, Fiddler & TFS Source Control

Co-ordinate with off-shore teams during Analysis, Design and Code Review

Working knowledge of Snowflake WH Concepts, File formats, Clustering Keys, Zero-copy Cloning, Time Travel, Data Staging, Transform & Load Nested Data, Data sharing, Reader accounts, Marketplace, Data Exchanges, Resource Monitors, Snowpipe Data Ingestion.

WORK EXPERIENCE

Allscripts/McKesson Charlotte, NC – Expert Software Engineer (March 2009 to Present)

Paragon® is McKesson's Community HIS solution. The Paragon HIS is a fully integrated hospital information system that offers clinical and financial functionality as a single solution. Paragon consists of complete suite of integrated applications that improves patient safety, financial and revenue cycle management, regulatory and HIPAA compliance and more.

From 2016 June, 75% Powerbuilder development and 25% Web development (.Net/C#)

Develop/Enhance Powerbuilder Clinical applications of Paragon Suite

Develop programs using OOPs and OLE featues, Debug and Fine tune the SQLs

Documenting the changes, Perform Unit and Integration Testing

Prepare test plans for the Audit group to validate the code

Design and develop database objects like Tables, Indexes, Stored Procs, Triggers, Views, etc

MS Word Automation to display/modify Radiology Transcriptions

Modify SQL code to be in consistent with higher SQL Server releases support

Develop Powerbuilder programs to launch to PACS – Siemens Syngo, GE Muse, Sectra, etc.

Restful Web service (API) creation using C# on Data Access Layer (DAL) to convert Word documents to Adobe Pdf

Enhance/Maintain Mobile Specimen application using Asp.Net/C# MVC Design pattern, HTML, CSS, jQuery

Upgrading Mobile Specimen application to be SSL compliant due to change in Transport Layer Security from TLS 1.1 to TLS1.2

Exception handling, Testing and Debugging of Mobile Specimen Application

Prepare data conversion SQL scripts when Functional modules are developed/ modified

Co-ordinate changes in multiple environments and confirming to release schedules.

Resolve the Service Orders logged by the hospitals after performing data corrections.

Assist the Support in analyzing defects so that only real defects are created.

Instrumental in reducing the call ticket backlog and update status to Management

Co-ordinate with the IC team to resolve issues during Go-Live

Analyze build breaks and rectify immediately

Co-ordinate with off-shore development teams in the design and development

Staging of Android devices using StageNow

Co-ordinate with Mobile Handheld vendors to resolve any Technical issues arising during MSC application integration with Handhelds

Environment: PowerBuilder 10.0, 11.5, 12.5, 17.0, Source Safe, TFS, SQL Server 2008, SQL Server 2012, SQL Server 2014, Visual Studio 2012, Visual Studio 2015, .Net 4.0, .Net 4.5, Net 4.7.2, MVC, C#, Android, Zebra EHS

Bank of America Charlotte, NC - Analyst/ Programmer (December 2005 – March 2009)

Compensation (COMP) is a client-server application in the Consumer Real Estate (CRE) with data inflows from the mainframe systems and provides data outflow to the Payroll system. COMP calculates the incentives and commissions based on predefined compensation plans for each group of Associates for their respective loan activity and also provides the users the ability to make overrides and to maintain compensation plans.

Senior member of the technical team for developing and implementing various modules

Prepare the technical specifications and prepare preliminary test cases

Design the specifications for the team to develop Powerbuilder and Sybase programs.

Assist the team in debugging problems and fine tune application programs and reports

Develop mapping specifications, Source to target mappings and ETL development

Develop BCP programs for ETL and schedule jobs (imports/exports) b/n various sources

Design and develop complicated reports with the use of stored procedures on database.

Prepare the user acceptance (UAT) environment for SIT, UAT, and Regression testing

Assist the change management team in planning the monthly production releases

Configure MS Visual Source Safe (VSS) for Powerbuilder & Sybase objects

Prepare release notes and documentation for end-users

Build the executable and distribute to the users

Assist in analyzing the system to re-write in VS .Net (C#) and MS SQL Server 2005

Communicate status update to the technical lead/business analyst

Co-ordinate changes in multiple environments and the delivery of applications.

Co-ordinate with the Off-shore teams during development/maintenance

Work with the DBA and Implementation team to resolve any issues during Go-Live

Environment: PB 6.5, PFC, Sybase 12.5, TSQL, MS Source Safe, ETL, BCP, FTP, SQL Server 2005, SSIS

CDI Corporation Charleston, WV – Analyst/Programmer (April 2001 to December 2005)

FACTS is a SACWIS for West Virginia state and is a comprehensive case management system for social workers to strengthen the case activity documentation for the families and children served by the DHHR. The system improves the organization's capacity for program compliance and planning, information collection & analysis for state and federal reporting.

Gathered requirements and identify different functional areas and interfaces

Developed algorithm that identifies and merges the duplicate clients entered in FACTS

Designed and developed various PowerBuilder objects such as UO, NVO using OOPs.

Designed and developed various database objects like Tables, Indexes, and Views

Converted the existing user entered MS word forms to DDE

Document the steps to reproduce issues found during Unit and Integration testing

Configured PVCS for Powerbuilder objects, Oracle objects

Developed reports in Crystal Reports to assist the management in allocating proper resources

Migrated the application from Powerbuilder 7.0 to Powerbuilder 10.0 in phases

Remove references to obsolete functions during migration to higher Powerbuilder releases

Document all the changes made related to the development / maintenance

Assist in building and distribution of the executable for the application

Communicate status report to the technical lead & Mentor Junior staff

Assist in preparing end-user training document

Work with the DBA in data modeling using ERWin

Environment: Powerbuilder 7.0/8.0/9.0/10.0, Oracle 7.3/8.0/9i, Crystal reports 6.0, 8.5, ERWin

Deloitte Consulting Boston, MA – Consultant (February 1998 to April 2001)

As a Deloitte consultant, worked on several public sector projects. Designed and developed the FACTS application for state of West Virginia, maintenance of FAMILIYNET and BASCOT applications for the state of Massachusetts. FACTS and FAMILYNET are Statewide Automated Child Welfare Systems (SACWIS). BASCOT is Judicial Trial Courts application that maintains the Criminal, Land court, Probation, Small Claims records for the state of Massachusetts.

Interacted with the business in collecting the business requirements

Developed block diagrams, logic flow charts and data modeling using ERWin

Extensively used menus, tabs, user objects, windows for front-end programs and reports

Assisted in the design of the framework based on Object-Oriented features

Prepare data conversion SQL scripts when Functional modules are developed/ modified

Designed and developed various database objects like Tables, Indexes, and Views, Stored Procedures, Triggers and Packages

Provide technical direction to programmers to ensure program deadlines are met

Develop and enforce the standards throughout the applications

Test, debug, and fine tune the applications

Prepare the required program level and user level documentation

Assist in building and distribution of the executable.

Peer code review and communicate status report to the Project manager

Co-ordinate with the DBA and Build in-charge to resolve any issues during Go-Live

Co-ordinate with the Implementation team to resolve issues during software implementation

Environment: Powerbuilder 5.0, 6.5, Oracle 7.3, ERWin, Oracle 7.2, 7.3, 8.0, Informix

VJ Infosystems India – Systems Executive (April 1996 - November 1996)

Designed and developed the Recruitment Management System (RMS). RMS assists the employers in matching the candidates for the vacant jobs. The match can be done on a range of criteria such as multiple skills, education, location, special knowledge, etc. In addition to matching the candidates for the required skills, the system also keeps track of all the activities undergone on a particular candidate such as interview scheduling, results, offers made, offers accepted, etc.

Developed the ancestors for windows and menus

Designed the navigation and error handling

Data modeling using ERWin

Used Object-Oriented features of PowerBuilder while performing the design

Migration of the application from Powerbuilder 4.0 to 5.0

Prepare the required program level and user level documentation

Assist in building and distribution of the executable.

Environment: Powerbuilder 4.0, 5.0, Oracle 7.2, ERWin

SSI India – Software Executive (May 1995 to April 1996)

Developed the export sales module for the Pharmaceutical Operations Management System (POMS). The export module integrates with the sales module to obtain the export orders and creates all the required documentation such as the invoices, FOB records. The module is designed for different units for the metrics and currency. Weekly and Monthly reports that track the progress of sales are generated in different presentation styles for the easy reading.

Developed the flow charts to represent the functional activities

Built the screens using Inheritance to maintain consistency with the other modules of POMS

Built the reports in graphic presentation styles

Unit testing the module and also involved in the UAT testing

Document all the changes to the modules

Environment: Powerbuilder 4.0, Sybase

Maritec Consultants India – Mechanical Engineer (February 1992 to May 1995)

Involved in the design of pumping stations, piping systems and refrigeration systems for large projects. Used FORTRAN IV to calculate the frictional losses to ensure optimal equipment sizes are suitably selected.

EDUCATION

B.Tech in Mechanical Engineering. (1988 to 1992) Extensively used 3 GL programming languages like FORTRAN, PASCAL for the project aimed at using LPG in the IC engines.

Accounting 101 course to understand the Financial Accounting Principles

SKILLS

McKesson Paragon Radiology Expert

McKesson Paragon Order Management Expert

McKesson Paragon Laboratory Expert

Powerbuilder Expert

MS SQL Server Expert

Oracle Expert

Informix Expert

Crystal Reports Expert

Visual Studio, .Net Intermediate

C# Intermediate

Snowflake Beginner

Python Beginner

Contact this candidate