Resoluting Management production, profit maximisation and cost minimisation, effective resource allocation and transportation problems.

• eNotam (Note to Airman): (Customer: Jeppesen)
  • Architect and design the data integration for geospatial plotting, integrated web services
  • Java Spring, SOAP services, Oracle. Team size 6. Project executed in Agile methodology.

Proj. Desc: Automate parsing eNotam pdf files and extract specific Notam information to plot coordinates and deliver to airman.I have,PI: Identified resources and end users. Gathered requirements.

PP:Requirement analysis, Created activity list, prioritize activity, estimate activity duration and assigned tasks to team members. PE: Directed teams and collaborated with customers for clarification and integrated systems.
M&C: Monitored work performance data. Tracked the status of work accomplishment.
PC: Wrote project completion report & Tool demo.

• To implement common business process and practices in all the projects and to track present project performance metrics. Created process flow and a common metric standard and Implemented the process in different teams.

• To implement common business process to all the projects to track and present project performance metrics. Project requirements, tasks, efforts, priority captured in Jira.

  I collaborated with multiple project teams and Identify agile projects to include in Jira. Created process flow to create a common metric standard and Implemented the process in different teams. Presented weekly status report and performance metrics dashboard for multiple projects from Jira. Created a process implementation document and project closure report.

• Architect, Design, Development of end to end an automated conversion tool that exports out of XPP to XML S1000D Issue 4.0.1.
• Core Java, Java Swing, PostgreSQL. Team size 6. Project executed in Agile Framework.

Auto conversion tool to parse the XPP source data and build S1000D standard xml tags which satisfy S1000D Issue4.1 schema. PI: Identified resources, Gathered requirements.

PP: I have done architecture the tool, Requirement study and analysis, Schedule estimation and get senior manager approval, created tasks assigned to resources.

PE: Brainstorm to resolute the functionality issues. Drive team to accomplish the tasks. Collaborated with customers. M&C: Change control and produce work status report.
PC: Tool demo and Deploy tool at customer end.

• Project Description: Develop a dashboard to display the status of data package delivery and signaling the servers and web services involved in data package transfer are alive or down.

  PI: Identified resources, Gathered requirements
  PP: Schedule estimation, Requirement analysis, Creating tasks in Jira and assigned tasks to team members.

  PE: Directed teams to accomplish the tasks and collaborated with customers for clarification. M&C: Monitor and tracked the status of work accomplishment.

  PC: Final deployment and wrote project completion report.

• Navigate to customer specific production data, view System Health, view production Metrics.
• Java Spring, SOAP services, PostgreSQL. Team size 6. Project executed in Scrum Agile framework.
• Reduced 75% of timeconsuming manual work into automation.

• Providing production database support for core and ERP applications support, patching, cloning, migration, upgrade, performance tuning, monitoring and maintenance support.
• Oracle Apex application deployments and user administration support
• PostgreSQL Database support on migration, replication, database design and maintenance

The Jeppesen data center with hundreds of databases and ERP systems to support its various products like electronic chart, online flight planning, electronic data production systems. IT – DBA were responsible for availability of databases. I was contributing to: Performing database and applications patching, code deployment Providing production database support for core and ERP applications patching, cloning, migration, upgrade, performance tuning, monitoring and maintenance. Performing data modeling (Logical and Physical) and architecture Oracle Applications 12.1.2 troubleshooting and maintenance Database growth collection and capacity planning Load Balancing Concurrent Managers and debugging concurrent manager issues. Cloning Applications databases to non-production environments. Setting up test environment. Primary support for resolving tickets per SLA to ERP applications Users, Service Engieers, Developers and server alerts. Health care, Troubleshoot, Configuration, upgrade, data update the third party services like Vertex and Paymentech, Credit card. Applying data encoding. Data masking using Mentis. Apex Applications administration and deployment. Weblogic and Tomcat administration. Health check and trouble shoot to SOA services. Oracle Apex application deployments and user administration support. PostgresSQL database design and maintenance. Administering middleware servers.

The Boeing Maintenance Performance Toolbox (MPT) is a suite of web applications, and supporting back-end applications and processes, targeted at delivering airplane maintenance data to airline end-users, most typically mechanics and engineers. The application suite also allows airlines to modify the maintenance data to fit their particular maintenance processes and procedures. It is the result of many years of planning and is slated to be a 15 year program that is currently in its 5th year. There were multiple previous Boeing and subsidiary maintenance products that were the inspiration for and have been supplanted by Toolbox

• • developed pl/sql packages, procedures and functions
  • Databasedesign,DB Backup and Recovery, SQL server databaseAdministration for dev and staging servers.
  • Support various databases in Oracle 11g, SQL Server 2008 and Versant, modeling IATP Database migration.
  • Activateddatabase mailing system for IATP in SQL server.

Supporting various databases in Oracle 11g, SQL Server 2008, Versant database for various projects such as International Airlines Technical Pool (IATP), Secure on Demand (SOnD), Quill, Data Renaissance Suite(DRS), Wiring Illuminator Web (WI).

The Hazardous Material Control System (HMCS) is a global system, which is used for tracking information of all hazardous materials used throughout General Motors Corporation in order to protect the employees and the environment as well as to meet legal requirements. GM personnel can use HMCS to obtain available Product data in order to safely manage chemicals for: material use, safe handling, regulatory reporting, and disposal. HMCS is handling Material Safety Data Sheet (MSDS) and chemical related data as well as Safe Use Instructions, Inventory, Regulations, etc. The HMCS Enhancement project aims to make multiple changes to the existing HMCS application to ensure that new business requirements are met; these include legal requirements, system performance issues, localization, and remediation of non-standard components within the application

The main objective of this project is to Upgrade iDESK from Oracle 9i to 10G and its constituent applications with a view to enhancing overall system quality, enabling simultaneous development and deployment of new functionality, reducing frequency of maintenance downtimes, and most importantly, eliminating the limitation on development capacity imposed by current iDESKs architecture. iDESK is intranet application at IFC and is main source of information for IFCs day-to-day activities. iDesk is a suite of applications like FMS, IPS, Products and TRIPS.

Facilitate easy tracking and reporting of all ISP sites, ISP exceptions, and archived sites on the external web and intranet. External web includes extranet sites and ISP partnership sites. The directory should be accessible for viewing and updating via a web interface. As much as possible, data fields for the directory should be automatically filled in (eg reduce manual updating as much as possible). Maintenance of the data will be centralized and managed by the Web Services team, though most of the data will be automatically updated.

Rabin Worldwide is a Integrated auction system allows online bidders and onsite bidders to bid a lot or individual items real time. The project is e-enabling its workflow process for conducting Auctions using Lotus Notes collaborative strategy. It has different consoles like Clerk, Floor, Auctioneer and Bidder consoles interconnected through Socket Server.

In Visteon Software Operations, each department is using different timesheet tool (VB Timesheet, Access Timesheet, Excel timesheet) to capture efforts. Also the metrics collection out of the timesheet varies with each department. To alter the current scenario the web based timesheet has been developed in such a way to cover the inconsistencies.

To establish a way of communication & transportation between the dealers and logistic operators, this whole module has been developed. By using these modules, all the payments for the parts, which has the warranty, will be delivered to the dealers. All the claims, which are genuine, are going to be paid by using this whole module. Audit Observation: Auditing for claims, one of the module in Warranty of ashok leyland, is handled by Service Engineer, RSE and HQEs. PL/SQL packages are implemented for auto audit claim selection.

• A tool to find a parts from unstructured big data. The data from Boeing parts databases, Boing IPC, AMM PDFs, all other sources of data from Boeing subsidiary databases excludingimages. Developed in Hadoop map reduce and HDFS, Talend.

supported Production and Development Databases of SDM and Target boxes; and solutions for P-tickets

•Instance in UNIX and Windows servers; imported/Exported dump using Data Pump, Import/export utilities

Analysis of the specifications, fixed bugs, coded with C#, ASP.net; database management and integration testing; delivering the Database Script, DLL, EXE and ASPX

Developed with PL/SQL package; created packages, procedures and functions for Visteon Reports in SQL Server

Quality Management Systems

Managing Quality Management System Quarterly Conducting AS91000D audit. Responsible to Identify organisation processes to include in QMS audit. Coordinated with QMS manager and process owners and created of quarterly audit plan. Assigned processes to auditors to audit. Conduct audits and follow-up audits per plan. Collect audit report. Resolute audit conflicts. Ensured that the quality management system confirms to the requirements of AS9100D. Reporting audit progress to management. And Conduct audit closure and feedback session.

North American Order Workbench (NAOWB) application defines the requirements for the order workbench project. It is a GM Northstar complaint global component with the oracle Configuration as its core. The primary function of the component is to allow applications or other components to configure GM vehicles. NAOWB has been created by Global Vehicle Configurator (GVC). GVC is continually being enhanced for various existing and new global applications. This process is being done by OVC.