Professional Summary

• Over 13 years of experience in the field of Information Technology with emphasis on Project Development, Business Requirements and System Analysis, Architecture and Operations Support projects of enterprise N-tier web and windows applications.
• Industry experience as a Project Manager and Technical Lead/Architect in diverse domains such as Automobile, Banking Payroll, Shipping and Terminal/Port Operation domains.
• Facilitated Change Management and Release Management across entire process from project conceptualization to testing through project delivery, Software Development Implementation Management in diverse business technical environments.
• Interface with clients from Operations, Marketing, Business, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Proficient in Technical and Business Writing, Business Process Flow, Client Meetings and Communication, Business Process Modeling, Business Analysis, preparing Work Breakdown Structure WBS and testing various methodologies.
• Experience in Analysis, Database Design, Development and Management, Business Analysis, Client Server, Web application systems using Oracle.
• Experience in handling multiple vendors, a collaborative mode to achieve a common goal for the projects.
• Experience in Data Modeling, creating Entity Relationship Diagrams.
• Detail-oriented Project Manager, Project Planner, Architect and Analyst devising innovative and tailored solutions to meet ever changing business requirements.
• Strong Programming skills in RDBMS in creating Tables, Procedures, Functions and Packages.
• Proficiency in Data warehousing concepts and designs, Oracle Forms and Reports, Power Builder, Web Focus, .Net C sharp , Information Builders Developer Studio 76.
• Implemented Agile Methodologies in the software development and developing Use Cases, Process flow diagrams and Sequence Diagrams.
• Multiple Testing tools development using Shell Programming, CRON jobs and Autosys.
• Conducted Joint Application Development JAD sessions and worked with business executives, developers, and end-users to define the exact requirements needed by a software solution.
• Used Share Point portal for document management, REMEDY for problem and release management and Source control systems like Clear Case, SCCS.
• Excellent Team leader and player having work in conjunction with testers, developers and team members in validation and testing complex projects and in the maintenance of Quality Standards in Projects.
• Experience with Object Oriented Analysis and Design OOAD , Rational Unified Process RUP , SDLC and Waterfall Methodology.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Experience working independently as well as in a team.
• Experience working with the on-shore/off-shore models.

Application Development tools and Technical Skills

Work Experience

Accomplishments

• By Reverse Engineering, migrated required functionality of existing legacy application across all locations 6 in all across the globe from non-supported platform to the state-of-the-art technology being the one of its kind in the whole organization. Vigorously worked on current business model, advising client on the approach designed and planned. Even with challenging timeline, the project was implemented successfully surpassing the expectations of the business. With this implementation, the organization was able to improve the productivity by 58 thus saving approx. 0.55 million per year.
• Analyzed and evaluated Real Time Locating System activities leading to labor savings, enabling decoupling of several sub systems from each other, thus reducing overall complexity, increasing flexibility to modify existing services or add a new service and reduce dependency on multiple applications.
• Automating the manual process improved the operation's efficiency by 300 thus saving around 20,000 man hours per year.
• Very less dependency on the GUI all business rules/functionality has been handled in database , thus if in future GUI needs to be changed/replaced it can be done with minimum effort requirements, estimated savings around 100,000 man hours per year.
• Participated in RFXs worth 6.2 million in 5 years of client facing at Oakland/ Scottsdale, USA
• Having most of the process within minimum variation in technology helps in building good team and better coordination among the process.
• Designing the products taking into consideration the goals of the organization thus eliminating the traditional products which can be replaced/re-designed and developing with new frameworks in order to reduce the support and maintenance overhead.
• Designed enterprise wide work visibility template which helped in refining the active work lists with business users and SME resulted in 65 reduction of open workload and increased visibility to current and future workload.

Role: Solutions Architect/Project Manager

• Order Management System OMT Order Management System is to onboard the New Product Master from MDM into Enterprise Data warehouse EDW to integrate visibility to software transactions and associated attributes not previously available in EDW by introducing the new product master hierarchy in EDW eventually to encompass all HP products greatly enhancing software business engagement, sales opportunity and management visibility.
• Develop a preliminary Enterprise Data Warehouse Data Architecture Design for HP Software Product Master, Hierarchy, Characteristics . The proposed design included an initial Business Analyses of the underlying subject area under consideration for the build-out of the Data Warehouse, a three-tiered Warehouse Extract, Transform and Load Architecture and a Reporting Layer that provided Analytical capabilities for Actual, Budget and Forecasted comparison of Financial Data across Business Units as well as consolidated Company-Wide Financial Reporting.

Responsibilities

• Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications.
• Provide expertise to translate the systems requirements into software design documentation.
• Plan, design and shape the new product master using technologies SeaQuest/Erwin/Informatica/SQL Server/Oracle/QlikView/Informix for the Enterprise Data Warehouse EDW and Business Data Repository BDR .
• Govern the development of the formalized solution to integrate it with the existing indigenous reporting and database tools.
• Conduct regular meetings with team and track progress of each project. Breakdown and distribution of task items.
• Help out on functional and technical issues to the team members. Train new resources on business as well as tools and technologies.
• Design, develop and monitor the logical / physical data marts, data base objects like fact tables, dimensions, packages, tables etc.
• Guide and perform data analysis via SQLs, data cleansing and implement data quality procedures.
• Design and present various dashboards, ad-hoc reports, KPI Metrics, trending reports, historical reports with slice/dice across various categories, etc. in order to substantiate the idea of new generation reporting platform to the business users and key decision makers.

Environment: NeoView, SeaQuest, Qlikview, Informatica, SQL Server 2008, SSIS/SSAS/SSRS, SharePoint, Dial, Tidal, Microsoft Office Suite, ERWIN.

Confidential Role: Project Manager

• Confidential Replace the current legacy application with a new state of in-house product keeping in view the current business functionalities, improving process with huge space and CPU savings, thus increasing the efficiency and reducing the data translation and transmission turnaround time for several data flows.
• Spearheaded the database planning and development of Terminal Management System TMS in C .NET and Oracle 11g, converting the existing modules into a new framework design.

Responsibilities

• Solutions Architect, Project Lead for all database related enhancements and projects. Analyze, design and reengineer current applications into in-house products. Handle multiple modules simultaneously. Business Requirements gathering and documentation. Preparation of Work Breakdown Structure WSP document for project. Preparation of Technical Solution Proposal TSP document for project. Preparation of Proposed Migration Approach document for project. Preparation of Project Approval Paper PAP document for project and discussion with client managers about the dynamics of the project.
• Prepared the FSD for the new technology for the existing forms to minimize the maintenance cost and improve functionality.
• Prepared the project plan using Primavera and implement the new tool in a phased manner.
• Plan for resource management, skill details and efficiency distribution across various modules for the resources, this helped in reducing the re-work cost, allocation cost, transition cost.
• Allocate work to resources as per project plan.
• Bi-weekly/weekly schedule and discuss with team about their progress, issues being faced and come up with alternate solutions.
• Develop programs for the forms and reports. Preparing weekly status reports, Task Prioritization and Scheduling. Reviewing the code changes and testing the enhancements.

Confidential Role: Project Manager

Joliet Terminal System Setup a new inland terminal at Joliet near Chicago. The whole terminal process Booking, Manifest, Releases, Train Information was developed and provided to Tideworks who take the data to process and use at the terminal operation.

Responsibilities

• Discuss with the business and the vendor about the project requirements to identify the critical business rules, functionality requirements.
• Design and Develop the AIFF format for the processes to be developed 301, 310, 404, 315, 322 to capture all data based on business rules, define their position for processing.
• Discuss the new process with the application team, explain the new design to the interacting applications support team to remove any bottlenecks between the 2 applications data flow .
• Prepared the Functional Specification Diagram for the new system, designed the process flow diagrams to minimize the maintenance cost and improve functionality.
• Prepared the project plan using Primavera and guide the team to develop the code PL/SQL Procedures, Unix Shell script, Functions based on the design.
• Develop programs for the forms and reports.
• Seamlessly merging application across UNIX and windows based systems.
• Prepared UAT documents, code review, integration testing.
• Implementation, post implementation support, transition to support team.

Confidential Role: Project Manager

Confidential Mainframe Client Services CLI System was developed in the 1980's to enable handling of Alliance-Partner and Terminal-Client containers, operated terminals NAM and ASIA Terminals . It was built to handle Client's bookings, containers, manifests and releases in conjunction with Mainframe Integrated-Terminal-Service-System ITSS and Equipment Tracking Control ETC system. Since EXPRESS system's inception, client data from CLI system is fed to EXPRESS system via mainframe platform. This CLI route/process caused some issues with regards to EDI not being posted successfully in CLI or if there is a network/mainframe issues. CLI in mainframe was eliminated and replaced by a new platform which send's client EDI data directly to application.

Responsibilities

• Analyze the current process and note down the changes required in the current process to identify the process changes and the effort required for those changes.
• Prepared the design document for new process to eradicate any functional points for new process.
• Prepared UAT document and review the UAT, test results for each form/module.
• Designed and developed the new process in C program and make the exe file to be run from the shell script, test the changes in a phased manner.
• Ensured that all the artifacts are in compliance with corporate SDLC Policies and guidelines,
• Seamlessly merging process into the current system.

Confidential Role: Project Manager

Customs M1 project Customs send the release and hold information for the import containers for terminals. The files are received through MQ process, validated and processed in the terminal system. The current process put holds or releases the holds based on the B/L. Customs modified their process the holds and releases at container level and not at B/L level. The purpose of the project was to avoid situations that might possibly result in penalties if manifests are not submitted on time with the accurate and complete information, likewise, the systems do not get reflected with accurate response and status information from customs.

Responsibilities

Analysis of Current State Architect

• Analysis of performance on ETL load process and work flow
• Prepare the Technical Approach Solution TAS for the new process.
• Review stored procedure process vs ETL capabilities for the new functionality.
• Prepare project plan using Primavera, Design and develop the new process in oracle create new Package and do changes in C program and make the exe file to be run from the shell script, test the changes in a phased manner.
• Recommended changes to process flow and scheduling.
• Perform UAT with the business users and get their sign off.
• Seamlessly merge the new process into the existing process.

Confidential Role: Project Manager

FMCSA FMCSA Project - Federal Motor Carrier Safety Administration FMCSA required carriers to maintain information about damaged chassis inside and outside the terminals. If a chassis gets damaged the information should be updated by the carrier in the system so that damaged chassis which may be potential to accidents should not go out of terminal without getting repaired. Once the damaged chassis enters the terminal, the M R department will take care of the chassis, repair the chassis and make it ready, so that it can run on road again.

Responsibilities

• Analyze the business requirement based on Business Requirement Document BRD and then prepare the functional specification document FSD based on the BRD document.
• Prepare project plan using Primavera, conduct weekly status meetings, update the project plan and present the project status to top management.
• Understand the complete flow of project, applications involved, their roles and how the data will be transmitted through all applications.
• Design the layout as per the understanding and requirements, develop the code based on design specifications.
• Prepare UAT documents, create PL/SQL Procedures, Packages and functions for the new functionalities, and create new triggers on the tables call the procedures through this trigger. Design and develop new oracle database tables for the process, create UNIX shell scripts, test the forms.
• Coordinate with EDI team for the data flow to cyclone through Mercator.
• Integrate with other application and inform business for their testing UAT and approval.
• Implement the changes along with other applications so that all are in sync with each other and be ready for post production support for any issues. This helps in quick resolution, to resolve any unknown issues which might have been overlooked during UAT.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.
• Identified the business risks associated with the new system and formulated a Mitigation Plan to reduce the effect of critical risk factors.

Confidential Role: Project Manager

The United States Department of Transportation USDOT regulations required carriers to maintain dangerous goods records. Additionally the dangerous goods elements must be passed to intermodal partners. To remain compliant, avoid fines, and continue to conduct business with intermodal vendors new dangerous goods elements were created within ETC, CCMS, EXPRESS, EDI systems.

Responsibilities

• Analyze the business requirement based on Business Requirement Document BRD and then prepare the functional specification document FSD based on the BRD document.
• Discuss the issues/modifications to be done, optimal solution with business.
• Prepare UAT documents, create PL/SQL Procedures, Packages and functions for the new functionalities, modify the Proc C code to add new elements for the process compile the file, test the process, integrate after successful testing and send to QA for final testing and approval.
• Inform business about the implementation, run scripts to move the files/programs to production.
• Post production support for any issues.

Confidential Role: Project Manager

The chassis tag and the confidential data is captured at Ingate to validate and store the information. Based on the OCR data the chassis and container grade is calculated. The OCR data is checked and validated at Outgate operation. Spearheaded the planning and development of OCR data capture and process it in Express application.

Responsibilities

• Analyze the business requirements and prepare BRD document to identify the critical, medium and simple activities and entity relationship for each process.
• Prepare the project plan and implement the new business flow in a phased manner.
• Create a business flow document of the existing process and modify the flow to prepare the technical solution paper.
• Design the new system based on the FSD to minimize the maintenance cost and improve functionality.
• Seamlessly merging the new process in the existing gate activities.
• Helped the business to articulate and prioritize their ideas, while using the Rational Unified Process RUP and writing UML-based feasibility studies and Use Case Models to communicate those ideas to the developers.
• Prepare UAT documents, develop the code, test the code, integrate after successful testing and send to QA for final testing.

Confidential Role: Project Manager

Confidentialis an oracle based application which provides bookings, container and vessel information to the customer sales representatives CSR's so that they can plan for the bookings in advance and commit the bookings to the preferred consignee. Convey provides commitment and booked information of bookings to bookrack application. This information is helpful to the users to analyze the booked counts and book the future bookings accordingly. The existing flow was modified to provide the data at vessel voyage level instead of week level.

Responsibilities

• Understand and analyze the business requirements and document the current flow.
• Design the scope of the project to integrate the requirements within current process based on the facts present and available, helps identify KPI and avoid redundant processes.
• Develop the new process by creating oracle PL/SQL procedures and Oracle UTIL process and test the new process based on the test cases.
• Implement in production and monitor the effectiveness, helped to improve the productivity/efficiency of the vessels by 140 .

Confidential Role: Project Manager

Confidential has a format, which establishes the data contents of the Vessel Schedule and Itinerary Ocean Transaction Set 323 for use within the context of an Electronic Data Interchange EDI environment. The transaction set can be used to provide all the information necessary for an ocean carrier to communicate the schedule and itinerary of an ocean vessel to interested parties. SRS is the source to capture all the data for OD pairs. E-schedules take this as an input, process it and provide EDI with the final draft to be processed for JCP. Due to processing of data in e-schedules some important OD pair combination for JCP is missed out. So we developed a process to extract the OD pair and vessel voyage data based on the that and process the data through EDI to be sent to JCP.

Responsibilities

• Analyze the business requirements and prepare the functional specification document.
• Prepare detail design document and Technical approach document.
• Develop the new process as per the design document and prepare the test plan and update test results based on the test cases.
• Implement in production and post production support.
• Transition to maintenance and support team.

Confidential Role: Project Manager

• During the time of recession, there was an increase in the number of bookings that are cancelled just a few days prior to the vessel departures, leading to vessels sailing under capacity and hence lower profitability. The trades would analyze the reasons for such fall-in cargo using the reason codes for booking cancellation. To facilitate this analysis a system generated analytical report is needed.
• The goal is to provide users a report that will provide the details of the cancelled bookings along with the reason codes for each customer. The report will be generated as a summary report that can be drilled down to get details at booking level.

Responsibilities

• Understand and analyze the business requirements and do a feasibility study.
• Understand the current process, design the new process based on the facts present and available, helps identify KPI and the loop holes in the system.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
• Develop the new process by creating PL/SQL Procedures, functions, Oracle UTIL process for the new functionality. Design and develop UNIX shell script to run the new process and test the new process based on the test cases.
• Implement in production and monitor the effectiveness to improve the productivity/efficiency of the vessels by 80 .

Confidential Role: Project Lead

Confidential is a Datawarehousing reporting tool which uses a bunch of OLAP and ad-hoc reporting features to build multi dimensional reports for analysis, forecasting and planning for proper utilization of equipments and to see the cargo movement details. Developed and supported the flagship Holos applications for equipment tracking, optimizing their utilization and balancing cargo loads with the allocations on vessels. Holos reports are no longer supported which increases the risk in case of application/tool failure.

Responsibilities

• Study, Analyze and document the existing forms/reports.
• This helps in understanding the current architecture, business of the form which in turn helps in designing the new process properly.
• Prepare Technical Solution Proposal TSP and Proposed Migration Approach for project, helps in designing the new architecture in an efficient way and understand the advantages/disadvantages of various approaches.
• Prepare of Project Approval Paper PAP for project and discussion with business, client managers about the dynamics of the project.
• Plan for resource management and work allocation across various modules for the resources, this helped in reducing the re-work cost. Help to reduce dependency on Holos tool as it is no longer supported.
• Design and develop the system using oracle PL/SQL Procedures, Packages and functions for the new process, create new global temporary tables, add triggers on the existing tables call the procedures through these triggers. Develop the forms using Web Focus reporting tool, perform unit test and then integration test in stage environment, the new tool/application reduced processing time by 100 .
• Implement and support post production.
• Improved the productivity of the users by 60 .

Confidential Role: Application/Module Support Lead

• Confidential is a reporting tool which using data warehousing concepts to build the reports. These are a bunch of OLAP and ad-hoc reporting applications for equipment tracking, optimizing their utilization and balancing cargo loads with the allocations on vessels. Equipment activity and vessel schedule data from the transaction database IDMS , which forms the basis of reporting flows in to the oracle data warehouses through MQ, routine nightly batch loads and mainframe triggers calling pro- Cobol and pro c programs.
• Further business rules of data transformation and aggregation are applied and data is loaded onto the data warehouse tables, which serve as repository for the customized data for reporting purpose. The key users of the applications are:
• Equipment analyst who forecast, plan and track utilization by setting KPIs.
• Cargo Controllers and allocation analysts who do freight load forecasting and vessel allocations
• Equipment leasing and subleasing personnel
• Cargo management details for all outbound and inbound vessels.
• Container Balance Analysis for better movement, allocation, planning and forecasting of the containers.
• Provides the complete details of the activities and event for each vessel for each leg and trip.
• Provides the complete inventory details with various combinations like disposition, aging, lessor code, location etc.
• Provides multi-dimensional over view and picture about the containers, chassis and gensets.
• Helps in forecasting and showing a clear picture for future predictions and analysis.
• Can be used from any windows enabled desktop within the network or through VPN outside the network.

Responsibilities

• Project lead and onsite contact point for all applications.
• Work onsite to understand the as-is processes, identify gaps provide to-be process solutions.
• Handle multiple projects for Holos reports simultaneously.
• Communicate and liaise clearly with business partners located both locally and globally.
• Business Requirements gathering and documentation.
• Preparation of FSD/TSP documents for projects.
• Develop new forms using the data warehouse concepts preparation of cube, hash structure, taking care of facts and deriavatives .
• Perform Data Mining for the issues raised by the business users,
• Preparing plan for allocation of work, assignments to resources as required.
• Preparing and reviewing estimates for the enhancements/mini projects.
• Preparing weekly status reports.
• Application support for all the OLAP reporting and DW Data Warehousing applications.
• Milestone submissions and preparing weekly, monthly/quarterly status report.
• End user support and clarifications.

Confidential

Role: Project leader

Confidential a collaborative development environment, designed retirement benefits systems for Standard Chartered Employees the system provides complete solution for Standard Chartered Bank employees regarding their retirement benefit schemes. Engineered customized features and modules for the new application, devised enhancements, had a lot of discussions with client representative director . Prepared work plan for each team member for proper implementation and to resolve system issues whenever raised. Written system and design documentation.

Responsibilities

• Interact with client managers understand business requirements.
• Designed the Proposed System based on the information from the business users.
• Understand retirement benefits scheme of Standard Chartered bank for various countries.
• Designed and developed the system by creating a new database having Oracle Tables, PL/SQL Procedures, Packages, functions, Triggers for the new system.
• Used Power builder tool for the GUI interface for forms and reports design.
• Design and developed workflow process for the Retirement Benefits process for the Standard Chartered employees.
• Eliminated the manual effort of handling retirement related documents and processes, thus improving the performance by 250 and reducing the effort to maintain multiple processes documents for different countries.

Environment: PL/SQL Oracle 10g , Java Shell Script, Power Builder 8, Informatica Version 6.

Confidential

Role: Team Leader Confidential the pioneer of 3-wheeler goods transportation in India, is today the no. 1 in its class. By setting global standards in vehicle performance and customer service, it has revolutionized the 3 wheeler cargo segment in India. Today the company offers a range of passenger and cargo vehicles for many customized applications.

Responsibilities

• Team Lead and a key member in developing, launching and enhancing a customized ERP process for Piaggio Vehicles Private Limited.
• Developed the forms GUI for the exports module, PPC module and sales module.
• Successfully completed the coding, testing which helped in integrating with other modules Manufacturing, Purchase modules of IIS.
• Created important interfaces like quotation, pro forma invoice, goods receipt note GRN , raising quotation, material issue note, preparing packing list, sales invoice for sales and exports.
• The whole system was developed using PL/SQL Procedures, functions, using UTIL files for the new functionalities. Design and develop new oracle database tables for the process, create UNIX shell scripts

Environment: PL/SQL Oracle 8i , C, C , Shell Script, Oracle Forms 6i, Oracle Reports 6i.