Sumanta Kodali Phone: 847-***-****

Email: acu0oa@r.postjobfree.com

Mr. Sumanta Kodali is a. Software Consultant with TCG Digital Solutions Pvt. Ltd. having nearly 16 years of IT experience and has extensive experience in Technical knowledge, Domain knowledge as well as Business Implementation & Configuration of Project and Portfolio Management Tools (Microsoft Project Server and HP PPM), SharePoint, ETL Process and MS BI (SSIS, SSRS, SSAS). Sumanta’s technical expertise includes knowledge in C, C++, VC++, C#, Java languages; .Net framework, Web services, SQL-PL/SQL programming on Oracle and SQL Server; CORBA programming; Forward & Reverse Engineering using ER-Win Tool; Application development using D2K. Sumanta has extensive experience with design, development, data migration, implementation and managing all aspects of a project.

Technical Skill Set

Platforms

Unix AIX, HP UX, Linux, DOS, Windows, TPF, Main Frame

Databases

Oracle 7, 8i, 9i,10g; SQL Server 2005,2008,2010,2012; Empress

Software Languages

C, C++, VC++, C#, Java, JSP, HTML, XML, ASP .Net, SQL, PL/SQL, COBOL, Assembly Languages 8085,8086,s390

Application

Project Server 2013, SharePoint 2010, 2013, Project and portfolio Management Tool (HP PPM), ETL, MS BI, HP Executive Scorecard, CORBA (Borland Visibroker 7.0,IONA ORBacus 4.1.2), PSI, Web service, Oracle AQ, IBM MQ Series 5.2

Development Tools

SharePoint Designer, Workflows, InfoPath, SSRS, SSIS, SSAS, Excel services, Visual Studio, Project and portfolio Management Tool (PPM 6.0,7.1,7.5, 8.0,9.1) Workbench, Toad, SQL Developer, D2K, ER-Win, X-Window, Motif, Oracle BI, BO/Web Intelligence, Xcelsius, PVCS, VM/CMS and MVS, Rational Purify for IBM-AIX, Silverlight 4

Academic Qualifications

Bachelor of Engineering in Computer Science & Technology with 1st Class in 2000 from Bengal Engineering College (D.U.), Shibpur, Howrah-3, West Bengal, India.

Higher Secondary Education (10+2 Math/Physics/Chemistry/Biology) from WBCHSE with 1st* Class in 1996

Secondary Education (10th) from WBBSE with 1st* Class in 1994

Other Formal Training

Microsoft PPM & Project Server 2013 Sep 2013

Microsoft PPM & Project Server 2010 Mar 2012

Executive Scorecard and Xcelsius Oct 2010

Business Object and Web Intelligence Dec 2008

Project Management Training Jun 2007 – July 2007

Project And Portfolio Management (PPM) Tool Oct 2006 – Dec 2007

TPF Operating System and VIP Application (VISA) Mar 2004

Professional Experience

Period

Company

Role

Oct 2007 - Till Date

TCG Digital Solutions (erstwhile SkyTECH Solutions LLC), USA

Technical Lead

Jun 2004 - Oct 2007

SkyTECH Solutions Pvt. Ltd, India

Senior Software Engineer

Feb 2004 - Jun 2004

R.S Software (India) Pvt. Ltd, India

Senior Developer

Aug 2000 - Feb 2004

Data Core (India) Pvt. Ltd, India

Developer and Designer

Recognition Awards

Recognition for Above and Beyond Contribution from TCG Digital Solutions LLC (erstwhile SkyTECH)

United IT Recognition award from United Airlines on November 2013 for successful implementation of Project Server 2013.

Employee of the month recognition parking spot award from United Airlines on Successful upgrade of PPM from version 7.5 to 8.0.

United IT Recognition award from United Airlines on Successful Move of PPM from HP to UAL Data Center.

ISD Recognition award from United Airlines on Successful upgrade of PPM from version 6.0 to 7.1.

Major Projects

1.Project Server 2013 (IT Governance Tool)

Organization

TCG Digital Solutions (erstwhile SkyTECH Solutions LLC), USA

Client

United Airlines (UAL), USA

Description

Project Server 2013 (i.e. Microsoft PPM tool) is used to provide a single source of information for all proposals, projects, assets, programs, budget, resource, resource rate, skill, time spent by a resource, demand, and supply for the United IT division.

It helped United IT to build a robust, customized, automated, central IT governance application to govern the project and portfolio management in a more efficient and cost effective manner. This system provides better visibility, analytics, and management of projects, assets, budgets and resources for the entire IT division. Automating the processes also accelerates throughput, reducing the time to market for facilitates construction projects.

Technologies/

Environment

Platform: Windows Server 2012

Development Tools: Project Server 2013 Web App, SharePoint 2010,2013, SharePoint Designer, InfoPath, SSRS, SSIS, SSAS, Visual Studio, C#, .Net, PSI (API) Web Services, SQL, PL/SQL, Excel Services, Event Handlers, Web Parts, SharePoint Web services, JQuery, JavaScript

Backend: SQL Server 2010, 2012

Special Tools: Project Server 2013, SharePoint 2010,2013 and MS Project Professional

Role

Delivery Manager cum Technical Lead

Duration

3 Years 6 Months

Responsibility

Sumanta’s responsibilities are

Administration, support and maintenance of the Project Server 2013 and PMO SharePoint 2010 portal for production, development and stage environments.

Development/configuration of MS Project Server integration with other Enterprise tools and Applications to extract, transform and load the data across multiple systems and sending email notification using SSIS.

Build ETL solutions using SSIS to integrate data between Project Server, SharePoint and other systems including but not limited to project/portfolio management, Financial system, Field Glass Invoicing System, PeopleSoft, Active directory etc. And build OLAP Cube as well as SSRS reporting.

Extracted and loaded data from/to various sources/destination like SQL Server, Oracle, .CSV, Excel Flat file and Text file from Client Servers and through FTP

Worked on several SSIS Transformations, for example: Slowly changing dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Bulk Insert, Sort, Merge, Union All, Data Conversion etc.

Reviewed, Tested and Deployed SSIS packages through command line, SQL Server Agent and scheduled through Job Scheduler for nightly and weekly loads of data by creating the corresponding job tasks.

Create new and/or modify existing Project Server & SharePoint reports such as Complex drill down & drill through reports, Parameterized Reports, Sub reports, Charts, Tabular reports with Cascading parameters, Matrix reports etc. using SSRS and Tabular, Pivot reports using Excel Services.

Planning and designing SSAS Cubes and building attribute relationships for optimal MDX query and build/design Dimension, Measures, Star Schema, Snow flake, shared connection managers etc.

Configure standard Project Server 2013 SharePoint project sites, issues & risks and troubleshoot issues associated with the project sites,

Administration and Maintenance of Enterprise Global Template, Project Site Templates, Enterprise Project Types, Project Detail Pages (PDP), Resource Breakdown Structure (RBS), Security Groups & Categories, Custom fields, lookup tables, Formula, Resource, Timesheet Policies and Ms Project Server Views, OLAP cube, backup and restore of projects, custom fields, workflows, workflow stages and phases.

Development, Customization, and maintenance of PWA & SharePoint Views and Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views, user-defined functions and Adhoc queries using TSQL DDL/DML to support PMO business logic.

Created SharePoint Sites, Lists, Document Libraries based on custom site template and site definition. Created Master Pages, layout pages, and Web part pages in SharePoint 2010.

Worked on InfoPath form library in SharePoint that enables business users to submit proposals and developed workflow using SharePoint designer to go through several approval processes and notifications for project estimation and budget approval and create a formal project upon approvals

Build, Maintenance and enhancement of automated custom PWA solutions (Auto Timesheet Creation, uploads of project Budgets and Financial labor hours for employees, contractors and Fixed bid resources FTE hours) using Visual Studio .Net, C#, PSI (Project Server Interface Web service), Event Handlers, SSIS packages, SSRS,SSAS, Custom web parts, SharePoint Web services,CALM queries, JQuery, Javascript etc.

2.PPM (Project and Portfolio Management) Tool

Organization

SkyTECH Solutions Pvt. Ltd

Client

United Airlines (UAL), USA

Description

PPM (Project and Portfolio Management) application is a powerful IT Governance Tool for advancing IT’s goal to strategically support business. It is an advanced interactive web technology viewer that optimizes access to technical data and information to facilitate the governance of IT processes, functions and resources of United IT.

United’s PPM application was hosted by HP SaaS till Mar 2010 starting from Jun 2008 when the PPM was upgraded to version 7.1. Then it was hosted by United as PPM was successfully migrated to the United Data Center. United’s PPM application was then also upgraded to version 8.0 and 9.1 in order to keep more up to date on the functionality available with the tool and to integrate it with QC, Service Manager, Asset Manager and BI which are already hosted by United.

Technologies/

Environment

Platform: HP-Unix, Sun Solaris, Windows Server 2003

Development Tools: PPM Tool, JDBC, SQL, PL/SQL, JBoss Application Server, Web Service, JSP, Hibernate technology, Applet, J2EE Application Server, RMI, SRMI, Apache JServ Protocol version 1.3

Backend: Oracle 10.2.0.2 RAC

Special Tools: PPM Tool & Workbench (Version 6.0, 7.1, 7.5, 8.0, 9.1)

Role

Delivery Manager cum Technical Lead

Duration

6 Years

Responsibility

Sumanta’s responsibilities:

Maintain and Support the United IT PPM Application, keep it running, monitoring the activities and troubleshooting the application after it brought to In-House at United IT division.

Provide support for the application as an administrator of the tool during the business hours so that all users can use the tool for their daily business process.

Gather new business requirements of PPM System and translate the user requirements into detailed specifications and design the solution from the detailed specifications.

Co-ordination of activities to facilitate ease of day to day work for offshore team according to the design specification and clarify questions from offshore team.

Co-ordinate with HP (Maker of the Tool) for any breaks down of out of the box functionality of the tool and resolves the issue quickly so that users are not impacted.

Involve in configuration changes of the tool and execute daily and monthly process like Time sheet extract and budget upload to compare actual cost of the project vs. invoice raised by finance.

Design, development and implementation of any new PPM functionalities (Reports, Portlets, workflow, project/core support process/form, resource pool/staffing profile related changes etc.) using Oracle Package, Procedures, Triggers etc, Change requests and Bug fixes as requested by the users.

Develop Adhoc queries using SQL, PL/SQL during the business hours to fetch any urgent information from PPM which can’t be fetched using existing reports/Portlets.

Reviewing of code to validate whether they are working as per the requirement, ensure the technical quality, and assist in identifying all the technical tasks and standards that need to be followed using Skytech’s highly rigorous quality processes.

Provide expert knowledge in specific business and technical functionalities used in the PPM tool and clarify any doubt that users might be having while using the functionality of the tool being developed.

Packaging and deploying the objects in QA and Production for any fixes in the Tool or addition of new functionality.

Analysis and implementation of new Service Packs in PPM and add new licenses in PPM if required.

Design and Development of new UA/CO Integration related functionalities in PPM and support them.

Upgrading PPM to version 9.1 to enable and test new Portfolio hierarchy feature in PPM

Technical support of the different PPM instance used by CRE (“Corporate Real Estate”) division of United.

3.BCIA-CIIMS

Organization

SkyTECH Solutions Pvt. Ltd

Client

Unisys

Description

BCIA-CIIMS is an EAI solution, which provides a common integration platform for heterogeneous applications that are expected to connect and communicate with each other through BCIA-CIIMS. The project scope includes the development of the middleware as a CORBA application with Oracle AQ as back-end, APIs for different platforms, which can be used by other applications to communicate with BCIA-CIIMS and a GUI tool for configuring the system and monitoring the performance. It was developed for the messaging system of Beijing airport of China

Technologies/

Environment

Platform: IBM-AIX, HP-Unix v11, Linux, Sun Solaris, Windows 2000

Development Tools: C, C++, VC++ 7.1,Java 5.1, PL/SQL

Backend: Oracle AQ

Special Tools: PVCS, Rational Purify for IBM-AIX, Borland Visibroker 7.0

Role

Senior Developer and Technical Analyst

Duration

12 months

Responsibility

Sumanta’s responsibility was to

Develop the Server-side code for BCIA-CIIMS server

Develop the client side code for Software Development Kit (SDK) APIs that was used by different subsystems in different languages/OS (C, C++, VC++ in Windows/Unix/Linux).

Build the messaging queue using Oracle AQ and writing stored procedures and triggers in PL/SQL.

Installing Visibroker in different platform and testing different functionality

4.Lounge Automation

Organization

SkyTECH Solutions Pvt. Ltd

Client

United Airlines (UAL), USA

Description

Lounge Automation is an MS Windows based client server based application used for check-in, ticketing, baggage/ flight information tracking etc. The front end interacts with Apollo mainframe system and retrieves required information. The scope of work involves maintenance of the GUI part of the application

Technologies/

Environment

Platform: Windows 2000/XP

Development Tools: Visual Studio, VC++ 6.0

Backend: Apollo Mainframe System (CRS)

Special Tools: InfoConnect32

Role

Senior Developer and Technical Analyst

Duration

10 months

Responsibility

Sumanta’s responsibilities involved in Preparing Impact Analysis & UTP, Coding, Review of code, Unit testing and Delivery of Maintenance Request.

5.CIIMS

Organization

SkyTECH Solutions Pvt. Ltd

Client

Unisys

Description

Central Integrated Information Management System is the total middleware system under the scope of this project. CIIMS will provide a common integration framework for all the subsystems that are expected to connect and communicate. It was developed for the messaging system of Guangzhou airport of China.

Technologies/

Environment

Platform: HP-Unix v11

Development Tools: IONA ORBacus 4.1.2, and C, C++, Java

Backend: IBM MQSeries 5.2

Special Tools: PVCS

Role

Senior Developer and Technical Analyst

Duration

6 months

Responsibility

Sumanta’s responsibility was to

Develop/Maintain the Server-side code for CIIMS server

Develop/Maintain the client side code for Software Development Kit (SDK) APIs that was used by different subsystems in different languages/OS (C, C++, VC++ in Windows/Unix/Linux).

6.Maintenance and Enhancement of VISA INTEGRATED PAYMENT SYSTEM

Organization

R.S Software (India) Pvt. Ltd

Client

VISA INTERNATIONAL (USA)

Description

Base1 Support Questions (or B1SUPs). These questions range from queries about specific transaction processing to generalize questions about specific services provided by VIP. Task is to respond these queries within eight hours by analyzing it and do the necessary coding to solve the problem.

Technologies/

Environment

Platform: TPF, Main Frame

Development Tools: Assembler S/370, Assembler S/390

Backend: N/A

Special Tools: VM/CMS and MVS

Role

Senior Developer and Technical Analyst

Duration

3 months

Responsibility

Sumanta’s responsibility was to analyze the application related Questions initiated from Member Banks and VIP Customer support and identify the issues/bugs in the application. He was also responsible for analyzing and coding of tasks received from the client.

7.GTFS (Golden Trust Financial Services)

Organization

Data Core (India) Pvt. Ltd

Client

Golden Trust Financial Services (India)

Description

GTFS is in the business of acquiring Health, Life and other various types of insurances from the masses for Large Insuring Companies such as NIC, HDFC, and IFFCO-TOKIO etc. The solution contains the following integrated modules Policy Capture & Agent Commission, Claims, Inventory & Stock, Payroll & FA. Modules would be web enabled and they would be on 3 tire architecture (J2EE frame work), the middle tire being 9i As, the front end being JSP based and the data base being Oracle 9i. Some portion of payroll and FA is done on client server mode using oracle & D2k for HO

Technologies/

Environment

Platform: Linux 8.1, Windows 2000, Oracle9i AS

Development Tools: Java, Jsp, J2ee, Sql/Pl-Sql

Backend: Oracle 9i

Special Tools: D2k 6i,Html

Role

Designer and Developer

Duration

4 months

Responsibility

Sumanta’s responsibilities involved in designing and creating screens & reports of payroll module in client-server mode using oracle & D2k. He was also responsible for writing package, procedure, triggers and functions using PL/SQL.

8.Wells Fargo Encore Elimination (Cashbox Application)

Organization

Data Core (India) Pvt. Ltd

Client

Wells Fargo Bank (USA)

Description

Wells Fargo's primary goal is to replace the current cashbox system with a new cashbox application that is cheaper and easier to operate and maintain. Create the new system with C++ and X-Designer (motif), convert all existing functionality and in-progress functionality, Replace the TISAM flat file system with lightweight database ‘Empress’. It is a three-tiered architecture, separated into three fundamental layers Presentation layer, Business logic layer and communication & Data Servicing layer each having some number of subsystems.

Technologies/

Environment

Platform: Unix AIX

Development Tools: C++

Backend: Empress

Special Tools: X-Designer, CRT and Motif

Role

Designer and Developer

Duration

11 months

Responsibility

Sumanta’s responsibilities involved in coding transaction processes of the business logic layer. This business logic layer consists of a custom, lightweight transaction-processing engine that is designed specifically to meet Wells Fargo’s functional requirements and perform within tight performance and resource utilization tolerances. This layer will expose its functionality to the presentation layer using a set of well-defined OO interfaces.

9.Computerizations of Kolkata Dock System of KOLKATA PORT TRUST

Organization

Data Core (India) Pvt. Ltd

Client

Kolkata Port Trust (India)

Description

Total Process Flow Automation and complete Software solution of total existing manual system. It is a 38 man-year project, involving Computerization 14 departments of Kolkata Port Trust.

Technologies/

Environment

Platform: UNIX, Windows 98

Development Tools: SQL, PL/SQL

Backend: Oracle 8i

Special Tools: D2k 6i, ER-Win

Role

Designer and Developer

Duration

17 months

Responsibility

Sumanta’s responsibilities involved in Creating screens and reports of Traffic module which deals with the planning and monitoring of vessel movement, Cargo movement, Railways movement, various Licensing policy, claims and prosecution for stolen or missing cargo and different type of accidents. He was also involved in implementing the traffic module in the client side, interacting with the client, making change request, develop the client’s requirement by adding some functionality (in coding as well as rule), and deliver the project to them

10.Comprehensive computerization of WCL

Organization

Data Core (India) Pvt. Ltd

Client

WCL (Western Coal Fields Ltd.) a subsidiary of CIL (Coal India Limited)

Description

Western Coal Fields Limited, Nagpur is computerizing its Accounting, Sales & Management, Personnel, Establishment and MIS sections. The system is being developed to allow the staffs who are spread all over the district to have on-line access and update capabilities to the information that is stored centrally at the district headquarters. A fully GUI based application is being developed utilizing D2k & Oracle.

Technologies/

Environment

Platform: SCO UNIX, Windows 98

Development Tools: SQL, PL/SQL

Backend: Oracle 7

Special Tools: D2k 6,ER-Win

Role

Developer

Duration

11 months

Responsibility

Sumanta’s responsibilities involved in system study and preparation of SRS, DFD, and ER diagram. He was also involved in designing as well as developing the Forms, Menus and provides menu level security to each form using form builder and generating Reports using report builder. He was also involved in writing stored procedures, functions, triggers using PL/SQL

Contact this candidate