Project Management, It Service Management

PRASANNA (SONNY) MOOKERJIE

******@***.*** (***) *06 - 6355

EXPERTISE SUMMARY

Effective matrix/cross-functional skill set working in a team-based environment with Project Management, IT Service Management, Software Life Cycle Development, Database Management, System Administration, End User Training and Healthcare Informatics

Proven success leveraging previously acquired management, operations, technical and people skills with creative problem-solving abilities to benefit the organization

Certifications

PMP, ITIL, VB/ASP.NET, MCSA (Win2K), MCP, A+, Network+, CCSA(NG), CHDP

Programming Languages

C#.NET, ASP 5.0/.NET, Oracle PL/SQL, Visual Basic 4.0/5.0/6.0/.NET, VBScript 3.0/4.0, JavaScript 1.2, XML/XSL, ISAPI, T-SQL, ADO/DAO, CSS, HTML 3.2/4.0, DHTML, C/C++, PowerBuilder 8.0, Linux Bash scripting

RDBMS

Oracle 10g/11i, SQL Server 6.5/7.0/2000/2008/2010, PostGreSQL, RdB

Tools

Project Management, IT Service Management, MS Project, MS SharePoint, Visual Studio.NET 2008/2010, Informatica 6x/8x, PL/SQL Developer, ADO.NET, Windows/Web Forms, T-SQL/PL-SQL, Crystal Reports 8.5/9i/10.0, IIS 4.0/5.0, ActiveX/COM/COM+Visual InterDev 6.0, MS SourceSafe 6.0, MS FrontPage 98/2000, MS Office 97/2000/XP, MS PowerPoint 97/2000, sqlplus, TOAD, StarDesigner, StarTeam 4.0, MS Outlook 97/2000, Symantec Ghost 7.0, SQL Navigator 3.0/4.0,, ActivIdentity, Rational Clearcase, MS Infopath 14.x (Office 2010), Extensis Studio

EXPERIENCE

FREELANCE CONSULTANT (May 2024 to Present)

Working on multiple projects and customers. Some assignments:

-Cultivated a culture of continuous improvement, leading to the team’s ability to exceed delivery timelines.

-Formulated and executed targeted training for project team members, resulting in enhanced productivity and skill advancement across the team.

-Supervised vendor relationships to negotiate cost savings, reducing overall project expenditures without sacrificing quality.

-Leveraged advanced data analytics to refine project targeting, leading to increase in customer engagement post-rebrand.

-Secured future business by building robust post-project review processes, which identified key performance wins and areas for ongoing improvement.

INFORMATICS PROJECT LEAD / Northrop Grumman - Peraton - Acentia (February 2013 to April 2024)

Performed various project management tasks at a premier Federal Health institution, including conducting IT Project Management activities, Healthcare Informatics, Annual Operational Analyses of IT applications. Participated in IT application development and support including Database design, development and optimization, end user interaction, training and support.

Tools used: Project Management, IT Service Management, Custom Federal Methodologies, C#/ASP.NET 4.0, Visual Studio 2010, Windows 7/ XP/2003 Server, SQL Server 2008 R2, MS SharePoint, MS Project, MS Office

SPECIALIST SENIOR IT CONSULTANT / Deloitte (December 2010 to December 2012)

As part of the IAM PMO at a premier Federal Health institution, performed various project management tasks, designed / developed reference applications and facilitated training sessions to assist technical stewards with PK –enabling their applications for compliance with HSPD12 requirements. Served as SME on .NET IWA/Active Directory, SSL and Smart Card based authentication methodologies. Provided consultation services for securing financial and database applications. Participated in design and development of a custom Desktop Smart Card Certificate Renewal application. Provided support towards maintenance of the IAM PMO share point site.

Tools used: C#/ASP.NET, C++, Javascript, CSS, Windows 7/ XP/2003 Server, SQL Server 2008 R2, ActivIdentity, Rational Clearcase, MS Infopath 14.x (Office 2010), MS SharePoint, MS Project

SENIOR PROGRAMMER / United Parcel Services (November 2005 to October 2010)

Participated in complete Software Life Cycle Development from System Design and Documentation to assisting End-User with User Acceptance Testing and Release. Developed and supported Financial Reporting processes using ETL and PL/SQL programming. Responsibilities included System Administration, software installation and troubleshooting, coding C#/ASP.NET, JavaScript, XML/XSL, log analysis as well as creating and maintaining objects in Oracle 9i/10g/11i. Proficient in ETL and PL-SQL programming including use of complex Oracle Analytic Functions. Ported 250+ complex Informatica ETL processes to an in-house application written in C#.NET running Oracle PL/SQL code. Converted legacy C++ modules to Oracle functions and procedures, as well as redesigned database objects to confirm to new business rules. Converted a legacy financial reporting system consisting of 25+ reports from VB6 to ASP.NET and C#, with heavy use of XSL/XML to generate Excel reports. Steered/mentored up to 3 developers in performance of development and maintenance activities.

Tools used: Informatica 6.x/8.x, Oracle 9i/10g/11i, WinForms, Visual Studio 2005/2008, PL/SQL Developer, PVCS/Serena, C#.NET, ASP.NET, ADO.NET, C++, VB6, Javascript, XML/XSL, CSS, Windows XP/2000/2003 Server, Oracle OBI/Siebel

SOFTWARE CONSULTANT / Teletrack (April 2005 to October 2005)

Refactored, enhanced, unit-tested and supported two console-based .NET applications involving C#, Winforms and SQL Server 2000, used for backend financial/credit operations. Responsibilities included System Administration, software installation and troubleshooting, log analysis as well as creating and managing tables, views and stored procedures in SQLServer 2000. Worked extensively with Visual Basic 6 in enhancing and maintaining mission-critical applications. Developed and enhanced 95 to 100 Financial/Credit Reports using Crystal Reports 8.5 driven by SQLServer 2000 Stored Procedures. Extended expertise in Object-Oriented C#.NET programming, as well as various aspects of the Financial and Credit industry such as FDIC 90 day rule.

Tools used: C#.NET, Windows Forms, ADO.NET, SQLServer 2000, T-SQL, Crystal Reports 8.5, MS Visual Studio.NET 2003/2005, MS Visual SourceSafe 6.0, Windows XP/2003 Server

SOFTWARE DEVELOPER / Platinum Circle Technologies (Feburary 2005 to March 2005)

Developed and supported complex SQLServer 2000 Stored Procedures that were used in conjunction with C# applications to process logistical data from the web and other external sources.

Tools used: SQL Server 2000, TSQL, Windows 2000/XP/2003 Server, MS Visual Studio.NET 2003

PROGRAMMER ANALYST / VSoft Corp (July 2004 to January 2005)

Supervised, developed, unit-tested and supported a web-based banking reporting application for back-end financial and banking operations at CitiBank. Served client sites as Support Specialist/Installer to install upgrades and troubleshoot Web-based applications. Responsibilities included System Administration tasks such as working with RAID management and troubleshooting, Windows Registry, ODBC, Windows Services, Event Logs, creating/signing Security Certificates and Networking. Also worked with Oracle/PostGreSQL DBA functions such as configuring Database Client/Server systems, importing, exporting and backing up data/schema, and database configuration with associated tools (e.g., Toad, Oracle sqlplus and tnsnames.ora). Configured and installed Web and FTP Client/Servers. Acquired further expertise in Banking and Financial operations and procedures.

Tools used: C#.NET, Web Forms, ASP5.0/.NET, Oracle9i/10g, PLSQL, MS Visual Studio.NET, Crystal Reports 9.2/10.0, Windows 2000/XP/2003 Server, IIS5.0, MS Visual InterDev 6.0, Oracle 9i/10g, JavaScript, CSS 1.0, HTML, TOAD (Oracle Management tool), StarDesigner, StarTeam 4.0, C++

SOFTWARE DEVELOPER / Skylight Financial Inc. (July 2003 to March 2004)

Developed, supported, unit-tested and upgraded a complex Customer Identification Application used to verify credentials of potential customers per US Patriot Act requirements. Upgraded and Maintained corporate website using ASP 3.0, JavaScript, CSS 1.0, SQL Server 7.0, Oracle 8.0, IE 6.0 as an Online Banking Client-Server environment. Additional responsibilities included System Administration, maintenance and tuning of T-SQL Stored Procedures and Triggers. Participated in maintenance of Batch FTP applications dealing with ACH, CACM and other custom files and generation of documents and reports.

Tools used: VB 6.0, ASP 3.0, SQL Server 7.0, TSQL, Windows NT/2000, MS Visual InterDev 6.0, MS Visual Source Safe 6.0, Oracle 8.0, JavaScript, CSS 1.0, HTML, Crystal Reports 8x/9.0, SQL Navigator, MS Excel 2000

PROJECT AND SYSTEMS CONSULTANT / Technology Center Inc. (December 2001 to June 2003)

Participated in Windows System Administration and optimization with specialization in Win 2K Client-Server Technology involving up to 10 boxes serving 200 clients. Responsibilities included development and maintenance of ECommerce applications requiring C#, VB 6.0/.NET, ASP3/.NET/CSS and JavaScript 1.2 programming.

Tools used: C#, VB 6.0/.NET. ASP3.0/.NET, Windows/Web Forms, SQL Server 7.0/2000, DHTML, TSQL, CSS 1.0/2.0, True DBGrid, Active Reports, Windows NT/2000, MS Outlook 97/2000, Symantec Ghost 7.0, MS Office 97/2000, Crystal Reports 8x

PROJECT MANAGER / Federated Systems Group (February 2001 to November 2001)

Supervised, formulated and maintained applications with VB6, ASP3, JavaScript 1.2 and CSS2 Front Ends running on the Corporate Intranet on Internet Explorer5.0 and Netscape6.0, and served through ADO by SQL Server 7.0 and Oracle 7.0 databases residing on NT4 and UNIX platforms, respectively. Involved in Formulation of Business Rules and System Administration activities. Participated in SQLServer7.0 Database Server Administration, creation of Stored Procedures and Performance Tuning. Steered an offshore team of up to 7 programmers and mentored in-house (client) programmers.

Tools used: VB6, ASP 3.0, WinForms, DHTML, JavaScript, CSS 1.0, HTML, SQL Server 7.0, Oracle 8.0, MTS 2.0, TSQL/PLSQL, IIS 4.0, MS Project 2000, MS PowerPoint 97, MS Visual InterDev 6.0, Visual SourceSafe 6.0, FrontPage 98, Office 97

SENIOR SOFTWARE CONSULTANT / US Steel Seamless Pipe Mill (February 1996 to January 2001)

Developed, upgraded and maintained Process Tracking Systems from VAX/VMS front ends to the Corporate Intranet Interface on Internet Explorer/Netscape using Server-side VBScript/JavaScript/CSS/HTML, and communicating with a RdB Database Server residing on a VAX/VMS 6.1 Server, which in turn communicated with a NT 3.5/4.0 Web Server using VAX FORTRAN executables and COM files through PURVEYOR. Acquired profeciency in Networking using TCP/IP, ETHERNET, Pathworks and RS232 protocols.

Tools used: VB 3/4/5/6, WinForms, JavaScript 1.2, VBScript, CSS 1.0, HTML, SQL Server 6.5/7.0, TSQL, Access Reports, Crystal Reports, Visual InterDev 6.0, ActiveX, Visual SourceSafe 6.0, Office 97

PROGRAMMING LEAD / Delta Informatics, Mysore, INDIA (August 1993 to January 1996)

Upgraded the process software of an engineering firm. The system was implemented on an Oracle 7 server on a SCO UNIX Box with Windows 3.x clients. Programmed C++ and Oracle Forms4.0 on the client and on Oracle 7and C on the server. Set up Test Beds and Server Administration.

PROJECT ENGINEER / Lotus Energy Systems KSCST, INDIA (June 1986 to July 1993)

Worked on a number of consulting assignments to implement engineering projects throughout India. Acquired expertise in formulation and implementation of ISO 9000 procedures. Responsibilities included Project Management functions such as PERT and CPM. Involved in design, manufacturing and maintenance in the fields of AeroSpace, Power Plant Engineering, Acoustics, Thermal Engineering and Structural Engineering.

EDUCATION

Certifications: (US, 2015) – ITIL Foundation (IT Service Mgmt.); (US, 2013) – Project Management Professional ; (US, 2002-03) - VB/ASP.NET, Microsoft Certified System Administrator (Win2K), Microsoft Certified Professional, CompTIA A+, CompTIA Network+, CheckPoint Certified Security Administrator, Certified Help Desk Professional; (INDIA, 1995) - C, C++, ORACLE, Windows Programming, UNIX, Client Server Architecture

MS, Engineering Management (Mysore University, INDIA, 1996)

BS, Mechanical Engineering (Bangalore University, INDIA, 1986)

Contact this candidate