SUDHIR PANDIT

**** ******** **. ****, ** *****

Email: adxkpn@r.postjobfree.com

Home: 248-***-****

Cell: 713-***-****

SUMMARY

●More than twenty-nine (29+) years of experience in (SDLC) Design, Development, Testing and Implementation of business applications in Client-Server/3-tier Distributed architecture, Web Based Application and Mainframe Application.

●Strong Experience in Azure SQL database, SQL Server 2012 (SP1), Oracle 11g/10g/9i/8i/8.0/7.3, PL/SQL, Stored Procedures, Triggers (using Embedded SQL), SQL Server 7.0/6.5, Sybase 10, DB2 (7.0), Windows 2000 MTS Server

●Strong skills in PowerBuilder 12.6/12.5/11.5/9.1/8.3/8.0/7.0/6.5/5.0/4.0, PFC.

●Excellent experience in Data Modeling using ERWin and S-Designer.

●Extensively used Inheritance, Encapsulation, Polymorphism, Visual and Non-Visual User Objects (Object Oriented Programming - OOP).

●Good experience in Crystal Reports, SQL-Windows 5.0/SQLBase 6.0, FoxPro 2.6.

●Good knowledge on Jaguar 3.6.

●Good knowledge and hands-on experience in Java 1.3/ Weblogic 7.0.

EDUCATION

Bachelor of Science, Physics, University of Mumbai, India.

Attended C# training at New Horizons Learning Centers (Troy-MI)-2015.

Certificate Course in Software Application from NIIT, Mumbai, India.

Certificate Course on JAVA Script, Java Beans, JSP and XML from Abcom, Mumbai, India.

EMPLOYMENT STATUS

US Citizen

TECHNICAL PROFILE

Database: Azure SQL Database, SQL Server 2012 (SP1), Oracle 9i/8.0/7.3, Sybase 10, SQL Anywhere, DB2 (7.0), SQL Base 6.0.

GUI Tools: C#, .Net Framework 4.5, PowerBuilder 12.5/11.5/9.0/8.0/7.0/6.5/5.0/4.0, Jaguar 3.6, SQL Windows 5.0,Crystal Reports, Cold Fusion.

Languages: PL-SQL, T-SQL, C, Java 1.3, COBOL, SAS 8.2.

Version Control Tools : Github, Visual Studio 2013, Merant Version Manager (8.3), PVCS (6.0), Visual Source safe, Object Cycle Manager Clear Case 5.2/5.0.

OS: Windows XP/NT/2000/95, UNIX, Dos, Sun Solaris 2.8.

Case Tools: ERWin 6.0/3.5/2.1, S-Designer, Visio 6.0.

X- Base : Foxpro 2.6, Clipper 5.0.

Technologies/Tools: Weblogic Server 7.0, XML SPY 5.2, XML, HTML, VoiceXML, Tellme Studio 2.0.

Other Tools: PC-Span, Lotus Notes 5.08.

Rational Product: Rational Requisite Pro 7.0, Rational Clear Quest 5.2.

PROJECT EXPERIENCE

Full Stack Software Developer - Solxsys365

Employer: Solxsys, Troy, MI Aug19 – May 23

Solxsys365 application is used by several clients located across the US. The system maintains banking, contribution, health care, pension, loan and vacation information for various participants. This system also associates participants with their designated employer. This application is developed using C#. Telerik report designer is used to generate various reports. Azure SQL database is used for storing data. GIT hub is used for version control. I was responsible for

●Created a new database when a new client gets added to our system.

●Performed ETL task to add the new client’s data to Solxsys’ tables.

●Created reports as requested by the business owner.

●Modified stored procedure to produce the required results.

●Updated data as requested by the business owner.

●Take monthly backup of client databases.

●Restore database when requested by the business owner.

●Used Visual Studio to compare/sync. databases.

●Performed code check in to Git hub.

Environment: Azure SQL database, C#, Telerik report designer 14.1,Github,Microsoft Visual Studio 2022

Senior Software Developer - Dental Vision (DV) /Trinity

Employer: Great Expression Dental Center (GEDC), Southfield, MI Mar 14 - July 19

DV is Dental health care software used to register and maintain new/existing patients. The software is used to schedule patient appointments, refer patients to another clinic, create treatment plans for the patient, create monthly billing statements and much more. The software is also used to maintain Provider and Insurance information.

DV was rewritten to Trinity by GEDC – IT development team, using C# .net framework 4.75 and SQL Server2012

●Extensively used MVP development pattern.

●Developed Referral and Ortho Contract forms using Windows Form.

●Used LINQ/Lambda expressions as per development standards.

●Abstract, Partial, Sealed and Static classes were used based on requirement and standards.

●Variable boxing/unboxing, arrays, Interfaces were also used.

●Performed ETL task to convert data from legacy system (DV) to modern system (Trinity).

●Involved in converting DV data to Trinity data using Stored Procedure.

●Converting data to XML and Jason format.

●Used TFS for version control.

●Used MVC design pattern for a proof-of-concept demo application.

●Used JavaScript to do calculations on the fly for the demo application.

●Used HTML tags for the demo application.

Environment: C#, .Net Framework 4.5, SQL Server 2012 (SP1), Visual Studio 2013, Team Foundation Server (TFS), Windows 10, PowerBuilder 12.6/12.5,

Senior Application Developer - Motrac Sep12 – Feb 14

Employer: Flagstar Bank, Troy, MI

Motrac is a mortgage support application used to register, process and close loans. This application has various modules. Some modules at a high level are.

ï Mortgage Application Registration: This is the initial stage where the request for the Mortgage application is accepted. All the available information is collected in this process, which includes the information related to the borrower, property and the customer’s choice of the Mortgage Product and the related terms and conditions are selected and agreed upon.

ï Underwriting: This module supports the Underwriter to determine customer's loan eligibility criteria. It verifies and finalizes all the documentation's that was submitted to support the loan application. Documents include employment history, Income statement, liability, property appraisal etc. This module has an interface with an external system (Fraud Guard) for confirming the borrower’s credit score. Document Management System (DMS) stores all the scanned documents submitted in this process.

ï Closing: All mortgage closing related activities like preparing the loan for the Wire or Check transaction are done here.

ï Post Closing: At the final stage when the loans are closed all the documents are stored in DMS.

Responsibility Includes

●Maintained Underwriter module and various sub-modules under it.

●Developed screen/functionality to capture Fannie Mae Originator ID.

●Used I-32 Forms Design to enhance various. UFF forms.

●Used WinCVS to do code check-in/ code merge for various database stored functions, triggers, package and procedures.

●Called Web services to update database.

●Tested monthly application production release which happens every second Sunday of each month.

●Prepared database scripts for product/miscellaneous release. These scripts were tested in production which happens each Thursday at EOB.

●Attended bi-weekly stand-up meetings. Monthly sprint grooming sessions etc.

Environment: Windows XP, PowerBuilder 11.5, Oracle 11g/PL-SQL, Toad 11.6, WinCVS 2.0, I-32 Forms Design 5.1, HP-ALM Quality Center 11.0, Compuware Changepoint15.0

Employer: Prince Technology Solution

TMS (Transportation Management System) Oct 03- Sep12

MDOT (Michigan Department of Transportation), Lansing, MI

TMS is an integrated system, providing information access and analytics to support a collaborative decision-making process. It is a single integrated transportation management system, composed of six sub-systems. These six sub-systems are broken into two categories, Asset Management and Performance Management Systems. The Pavement, Bridge and Public Transportation Management Systems belong to the area of asset management, whereas Congestion, Safety and Intermodal Management system fall into performance management category.

●SMS (Safety Management System): SMS does comprehensive collection, maintenance and dissemination of traffic safety-related data. Safety data is used for highway planning, design, maintenance and operations. The goal of this system is to improve traffic safety on all Michigan roads through coordinated engineering, enforcement and emergency services, which focus on the elements relating to roadway, vehicle and users.

●CMS (Congestion Management System): CMS identifies congested areas and those areas where congestion is likely to occur in the future. Congestion can be identified at three levels: goods movement, people movement, and vehicle movement. There may be recurring and non recurring congestion.

●DMS (Dictionary Management System): DMS is designed to impose development standard for new and existing table/columns. It’s an open system, which can be used by any Mdot/Mdit user to browse tables and columns. This system maintains a centralized registry of metadata.

Responsibility Includes

●Designed, developed and maintained various complex screens/reports in SMS/CMS/DMS.

●Used PB/PFC/TMS Framework-Toolkit objects to develop and maintain SMS/CMS/DMS screens/reports.

●Integrated CRIS report with TMS.

●Used SQL *Loader to load various CMS tables (Census and Remi)

●Wrote complex stored procedures, triggers, and functions in Oracle DB.

●Did data analysis and optimization in various screens to bring up the efficiency.

●Resolved UD-10 issues whenever occurred at user’s machine.

●Migrated TMS application from PowerBuider9.0 to PowerBuilder11.5.

●Used and tested dynamic segmentation in SMS windows.

●Coordinated BMS (Bridge Management System) report development along with BMS developer.

●Always tested the new functions with the business users before the release.

●Periodical meeting and discussion with the business users to discuss their needs.

●Used DST (Development Support Tool) to capture and document the user’s needs.

●Provide technical assistance to the team whenever required.

●Demonstrate the use of DMS to the end users whenever requested.

Environment: Windows XP, PowerBuilder 11.5/9.0/PFC, Oracle 11g/PL-SQL, SQL *Loader 9.2, Toad 8.0, SQL Navigator 4.0, Merant Version Manager 8.3, Exceed 9.0

Employer: Prince Technology Solution

UFS (Unified Freight System) June 03- Oct 03

Kintetsu Global Express (KWE), Dallas, TX

Employer: Prince Technology Solution

Oasis System Jan 03 – June 03

Verizon Communications, MD

Employer: Prince Technology Solution

Voice Portal Interface System Sep 02 – Dec 02

Verizon Communications, MD

Employer: Prince Technology Solution

THERMS (Trading Hedging Risk Management System) Jun 01 – Sep 02

ELPASO, TX

Employer: Ved Software Services

Medical Review and Adjustment System Feb 00 - Jun 01

Michigan Peer Review Organization (MPRO), MI

Employer: Ved Software Services

People Mover System Jan 00 - Feb 00

People Mover, CA

Employer: Ved Software Services

CMS (Customer Management System) May 99 - Dec 99

Lockheed Martin, PA

Indian Oil Corporation Ltd, India Dec 98 - May 99

Hoechst Marison Russel Ltd, India Nov 97 - Nov 98

Princeton Software Exports Pvt. Ltd, India Jun 97 - Nov 97

ICICI Bank, India Mar 96 - Jun 97

Siemens Ltd, India Sep 95 - Mar 96

Albright Morarji and Pandit Ltd, India Jun 95 - Sep 95

Nanalal Pandya Engg Co. Pvt. Ltd, India Jun 94 - Jun 95

Contact this candidate