JAGADESH SUBASH, Management IT Professional , Innovation scout

NAME: JAGADESH SUBASH

ADDRESS:

DOOR NO 18 GF1, BHUVANESH PLAZA

GOLDEN AVENUE, SECOND CROSS STREET,

VIJAYA NAGAR, VELACHERY 600 042

MOBILE PHONE: 9843466133

 Email ID: jagadesh.subash@yahoo.com

 

Notice Period: 1 Month

Location : Chennai

Max Total Team size handled: 60 (Direct, Indirect)

 

Website of Jagadesh Subash: https://jagadeshs.webnode.com/

LinkedIn: https://in.linkedin.com/in/jagadeshs

Summary of experience:

• A consummate experience of  almost 2 decades as a Technically Sophisticated J2EE, IBM – SOA, Data Warehousing & Enterprise Integration –  senior Management Professional involved in Analysis, Architecture, Design and Development of Internet / Intranet Based Enterprise and Client / Server Applications.
• He is a Project Management Institute certified Project Management Professional.
• He has 8 Years of copious experience as Program manager, Senior / Project Manager in J2EE, IBM SOA, Data Warehousing, and EAI Technologies.
• He has extensive expertise in P&L management and in business development strategy for the domain/segment. He is effective and efficient in planning and managing enterprise business unit operations.
• His experience includes Customer Management & Customer Relationship Building which includes focusing on increasing the revenue, managing issues and consulting on the requirements.
• He has provided focused leadership for the business unit – business development, P&L, program, project management, training, resource management and arrowheads development. He has demonstrated success in building and leading, dynamic high performance teams.
• He has 5 years of conspicuous Enterprise-level implementation expertise in the Software Development Life-Cycle (SDLC), including Business Analysis,  Design, Development and testing in Banking, Finance and Insurance Applications for leading BFSI customers like Citibank,Citigroup GMPS,HDFC Bank,Bank Dhofar, Fairbank, IDBI, JPMorgan Chase, Nordea Bank, and GE Global Consumer Finance.
• His credentials include Six Sigma Green Belt for executing Customer facing Six Sigma project for General Electric Global Consumer Finance in 2004
• He has mentored four Green Belt projects – for GE businesses and was targeted for Black belt.
• He had established Business Objects technical practice at Patni Chennai in 2001.

• His pioneering career reflects strong proficiency in Program Management coupled with technical qualifications in Microsoft, Data warehousing, Business Intelligence, Sun Java, J2EE, IBM SOA, and XML Technologies.
• He has Comprehensive Industry – Specific expertise in Design and Development of Applications for Banking, financial services, Manufacturing, Aviation, Health Care-Insurance, and Contract Management Domain. He has four and half years of immense experience as cardinal consultant for web based onsite solutions involving state of art technologies for global 500 companies in USA, UK, Luxembourg, Singapore, and Australia.

Professional Qualifications & Certifications:

• Certification in Developer 2000, Designer 2000 from STG, 1996
• Six Sigma Green Belt for executing Customer facing Six sigma project for General Electric Global Consumer Finance in 2004
• Team Award from Patni Computer systems in 2004 for GE India Projects
• Certified Internal Auditor for QMS in Patni Computer Systems during 2004
• Project Management Institute certified Project Management Professional in May 2005.
• Retail Banking - Introduction – Polaris Software Lab in 2007
• Training on Oracle Fusion Middleware – SOA,WS,BPEL,BAM  in 2007
• Agile methodologies with Scrum in 2008

Technical Skills:

HARDWARE : IBM HTTP Server, PC Pentium, HP-9000,AS/400
OPERATING SYSTEM : SVR 4.2, HP UNIX 10.02 / 9.x, Novell NetWare, Magnix 2.6, Hicix 2.7, Windows NT, Windows 95, Windows 98, Windows 2000,
LANGUAGES : PL/SQL 2.3, Pro *C, SQL *Loader, SQL *DBA, JAVA,
SOFTWARE: Java 2.0, IBM SOA, J2EE - Servlets 2.0, IBM Visual Age for Java, UML, Rational Rose 2000, APACHE-Struts, JSP 2.0, JSTL, Visual Basic 6.0, ADO, VB Script, DTS, COM, DCOM Java Script 1.3, ASP 2.0, XML, MQ Series-MQSI, Apache-Struts, Jdeveloper 9i, Netbeans 3.5 IDE , Cognos Reports, Business Objects, Informatica, and Micro strategy, IBM Mashup center.

WAP TECHNOLOGY : WML, WAP Enabled Mobile Cell Phone with the Micro browser Cellular Network, SAS WAP Gateway

APPLICATION SERVERS : J2EE application servers, IBM Web Sphere application Server ,IIS, IBM Web sphere Integration developer 6.1, IBM Web sphere Process server 6.1, Oracle Application Server (9.0.4)
DATABASE : MS SQL Server 7.0, Oracle 8.0 / 7.3, DB2,Oracle 9i, Oracle 10 g
 

Education:

• M.S in Management Systems from Birla Institute of Technology and Science, Pilani, India – collaborative program 2002-03 .
• Diploma in Business Management from Institute of Management and Technology, Ghaziabad – 2001 .
• Bachelor of Engineering in Computer Science and Engineering from Anna University, (1989 – 1993 Batch) @ 61%

PROJECTS PROFILE

Reflective Research, Software Consultant in Sennovate Pvt Ltd -  Period: April 2009 to till date

• Conducted training in Software Testing Fundamentals, Selenium 2 (Web Automation Testing Tool), Prepared course materials for Software Testing Fundamentals, Selenium 2 (Web Automation Testing Tool)
• Conducted training in Java SE 1.7 Certification 
• Prepared Analysis document for Hacienda project.
• Conducted Technical interviews for J2EE, Oracle Application frameworks.

• Prepared Web-based Software Development Business Plan for DhirajLal Gandhi Institute of Technology.

Reflective Research

•    Authored and self published management and Internet technology 7  eBooks in Createspace (Amazon)
•     Created, managed 5 different blogs regarding management and Internet technology in wordpress
•     Created, maintained knowledge for 5 communities of practices regarding management and Internet technology in     webnode.

 

ebooks

Performed reflective research in the ebooks subject areas.

The list of ebooks are

 1. Bio-Inspired Management processes and systems

 2. Spiral Guide to Meme

 3. Spiral Guide to Collective Intelligence

 4. Spiral Guide to Swarm Intelligence

 5. Spiral Guide to Syndromes in Teams and groups

 6. Maxims for Design Management

 7. Next Practices in Digital Marketing

Blogs :

Used as a hub to demonstrate expertise, sharing market information and trend information Selected highly poignant information from multiple sources and published as posts.

Monitored and documented intelligence information regarding the subject areas.

The list of blogs are

Blog for Bio-inspired Management : copib

Blog for Future studies in Management : Areete

Blog for Philosophy in business management : copip

Blog for Design Management : evangel

Blog for Next Practices in Digital Marketing : Digital Marketing Next practices

Communities of Practices:

Created shared repository of information; Effective listening and learning with productive participation

Cultivated various communities of practice and engaged as advocacy, collected on going advice and best practices  and published thru CoP

COPIB	Community of Practice of Bio-Inspired Process and systems
COPIP	Community of Practice for Philosophy in business management
AREETE	Community of practice for Future studies in Management and IT
EVANGEL	Community of practice in Design Management
COPDM	Community of practice for Digital Marketing

 

 

 

Please visit www.imanage.webnode.com for further details for the above activities

Customers: JP Morgan Chase, Nordea Bank, GBM-Bahrain Islamic Bank, Nexaweb, Kingdom of Bahrain – eGA, ING Vysya, AXA Tech.

Project: Business Unit -04

Period: June 2008 To Till Date

Organization : Torry Harris Business Solutions, Bangalore

Roles: IBM SOA - Project Manager

Project Synopsis:                    

Planning and managing enterprise business unit operations which include Business development, pre sales, program management, project management, Quality assurance and management, training and resource management.

Specific role/ Contribution:

• Prepared Training plan for Websphere Integration developer 6.1 and Websphere process server 6.1 for IBM SOA team.
• Project management activities for JP Morgan Chase Strategic Dimension management initiative, Prepared MS Project schedule for Phases 1,2,3.
• Drafted proposal for New York Power Authority Board Room Portal Service using Microsoft share point and IBM Technologies based technical solutions.
• Prepared Functional specifications for Nordea Bank Data Integration solution scenarios.
• Reviews of Test cases , Test plans for Nordea Bank Data Integration solution scenarios.
• Performance Objectives management – creation, assignment and evaluation of quarterly objectives to IBM SOA Team members.
• Preparation of Resource Requisition forms for various project resource requirements for the Business unit -04
• Prepared proposal for IBM based middleware solution for Bahrain Islamic Bank
• Drafted statement of work and work orders for various Nexaweb projects in Business unit -04
• Project management activities related to Time and material projects for ING Vysya, Dailmer – Mercedes benz and AXA Technologies.
• Preparation of IBM Mashup center – Brochure, Preparation of various case studies for Business unit 04 projects.
• Prepared proposal for e Government Authority – Kingdom of Bahrain – Design and development of e Services.
• Preparation of IBM SOA Migration approach methodology for Atradius symphony.
• Preparation of Guidelines and procedures for Cmmi – Organization process performance and Quantitative project management.

 

Customers: ST James Place, CitiGroup, HDFC Bank, Bank Dhofar, People United Bank,

Project: Data warehouse and Business Intelligence Technologies

Period: Sept 2006 To April 2008

Organization : Polaris Software Labs, Chennai

Roles: Data warehouse and Business Intelligence COE, Designation: Sr.Project Manager,

Project Synopsis:

Polaris EAI/MCI/BI Practice Objectives are to leverage Polaris rich and diverse Data Warehouse & BI experience and expertise to focus on emerging & niche technologies, and provide expert solutions thereby improving market presence and creating a satisfied & committed Customer-base. EAI/MCI/BI Practice is the COE for Data Warehousing, Business Intelligence, and related needs for Polaris in order to build a gamut of packaged and customized solutions that will be ‘Ready-to-cater’ and ‘As-of-day’s market’. Establish Polaris as a Data Warehouse & BI market leader in BFSI segment. EAI/MCI/BI Practice caters for all Data Warehouse /BI associates, technology, and consulting needs for Polaris’ clientele. BI/ Data Warehouse /MCI Practice provides customer services, which includes formulating business strategies, quantifying business benefits, identifying challenges and opportunities and implementing solutions that provide the best fit to address customer business requirements.

Specific role/ Contribution:

• Performed Reviews of SOW for ST JAMES Place Business Objects XI R2 Re creation project
• Creation of Ms Project Plan - Project Schedule ST JAMES Place BO Re creation project
• Drafted ETL, Data warehouse, OLAP Design Checklist and Guidelines for BI DWH Technology Practice
• Drafted ST James Place Oracle 8i To Oracle 10 G Database Migration, Application, Infrastructure Support Methodology.
• Preparation of Capability Documents, Case Studies, white papers as collaterals. -Informatica 8, BOXI R2, OWB 10G for BI DWH Technology Practice
• HDFC Bank – Drafted Project Approach document for Cost/Volume/Productivity - Branch Control Unit Analysis
• Initiation of Queries in response to RFP’s for different BFSI customers.
• Design, Drafting Data flow diagrams, Process flow diagrams, High Level System Context diagrams for technical solutions in Proposals related to Business Intelligence and Data warehouse technologies for BFSI customers.
• Implementation of Efforts Estimation techniques and Cost Estimation for multiple proposals of different BFSI customers related to Business Intelligence and Data warehouse technologies
• Providing technical support and project management methodology support for sales groups presentations for different BFSI customers related to Business Intelligence and Data warehouse technologies
• Identification and definition of the appropriate High level technical Approach for project proposals and production of RFI responses related to Business Intelligence and Data warehouse technologies for BFSI Customers
• To provide pre-sales technical support and Project management methodology support through the complete sales cycle (i.e. from Qualification through to Winning business) with regard to the different BFSI customers related to Business Intelligence and Data warehouse technologies
• Reviews of Business Intelligence Packaged Solution’s Technical Architecture Document
• Drafted Proposal for Web services Development for Bank Dhofar
• Drafted Executive Summary Proposal for People United Bank - BO Reports Migration, Development and Data conversion

 

Customer: Citibank India

Project : Citibanking India

Period: Mar 2006 to August 2006

Organization : Polaris Software Labs, Chennai

Roles: Sr.Project Manager

Project Synopsis: The Branch Banking system is used by GCB India – e OASIS Online Account Services and Information system and BASIS – Batch Account Services Information System. The e OASIS Application is for tracking Customer Accounts (Customer Transactions – Cash, Overdraft, Deposits & Investments) and branch accounts. The BASIS is used for tracking Bank Accounts.

Tools and technology used: Oracle 9.2

Specific role/ Contribution:

• Tracking Production Support related Reports – EOD Abort Reports, GCB Integrity Reports, GCB Deferred branch balances report, Repair Analysis Reports, Emergency Bug Fixes Reports, CCR Requests Reports & User Requests for New Requirements
• Worked on Initial Analysis and Requirements Definition for the Following Enhancements
  • GL/SL Account Opening Process.
  • CASA Provisions Changes.
  • Fast Track Ready Credit Functionality.

Customer: Road Transport Authority, Sydney, (RTA) NSW, Australia

Project : Contract Management System 21st Century

Period: Feb 2004 to Dec 2005

Organization : HCL Technologies, Chennai.

Roles: Project Manager (Onsite / Offshore)

Project Synopsis: The design and development of web based Contract Management System for RTA, Sydney. The project consists of development of Contract Management System in J2EE for managing construction and maintenance contracts.

Tools and technology used: Java, J2EE 1.4, Jdeveloper 10 g, Oracle 10 g, Struts 1.1, Visio Enterprise.

Specific role/ Contribution:

• Initial Planning and Initial Analysis of Business Requirements Document for CM21 Application.
• Involved multiple workshops for Initial Analysis of Business Requirements document of CM21 Application
• As a project Manager participated in the project team set up, Project planning, Project monitoring and execution for both onsite phases (SRS, HLD) and  offshore phases of the project (LLD, Development and Unit testing, Integration testing)
• Managed a peak size of 35 Team Members. Planned multiple intermediate deliverables and executed the phases for SRS and HLD.
• Engaged in on time and first time right delivery of the multiple deliverables of the project.
• Participated in the review and subsequent update of System Requirements Specifications and High-level design for Toll Incidents and Violation  System of RTA Sydney.
• Conducted Initial Evaluation of E toll Application for RTA Sydney
• Prepared the process flow for RTA Drives Realignment Project proposal

 

Customer: GE Businesses (GE Consumer Finance, GE India, GE Appliances, GE Capital Fleet services)

Project : GE India Annual Maintenance contract, e GDC applications, GE CFS Web Reporting Applications, e SLA Applications

Period: Sept 2001 – Jan 2004

Organization : Patni , Chennai

Roles: Project Manager

Project Synopsis: Managed and provided solutions to simultaneous multiple projects being executed for GE Businesses (GE Consumer Finance, GE India, GE Appliances, GE Capital Fleet services). Executed and managed multiple Data warehousing projects as a Project manager.

Tools and technology used: Java, J2EE, XML EJB, Netbeans 3.5-Sun one Application server, Jdeveloper 9i, Web logic and Apache Tomcat, Business Objects 5.0, Informatica, Cognos Reports and Microstrategy 7.0

Specific role/ Contribution:

• Set up, Organized and Managed Business Objects Practice at Patni Chennai. Responsible for architecting, modeling solutions using J2EE multi tiered distributed applications for the projects.
• Executed and managed multiple Data warehousing projects using tools - Cognos Reports, Business Objects 5.0, Informatica, and Microstrategy 7.0.
• Performed iterative business domain and process analysis and modeling to arrive at class and sequence diagrams for use cases and horizontal class infrastructure using design patterns and Rational Rose for UML modeling.
• Achieved the highest grade for projects, in customer satisfaction survey for GE India projects (GE India Annual Maintenance contract and e GDC applications, eSLA Application) for 5 consecutive quarters.
• As a Project Manager achieved Patni Annual team award for year 2002-03, for best Performance.
• Got certified as Green Belt by executing Customer facing six-sigma project for GE Consumer Finance.
• Mentored 4 Six sigma Green belt project, out of which 3 were Customer facing project, and was targeted to achieve six sigma Black belt.

 

Customer : FAIRBANK S.A, Luxembourg(onsite)

Project : FAirbank Payment factoring System (FAPS)

Period: March 2001 to August 2001

Organization : Hexaware Technologies, Luxembourg, Europe

Roles: Technical Architect and Project Leader (Onsite)

Project Synopsis: The FAPS, a payment factoring system, consists of three units, Rating boosters, WEB, ISRD (Integration obes Regbemenits biveurs). Rating boosters and ISRD are intranet-based systems for payment factoring of FAIRBANK S.A used by employees in Luxembourg and Geneva, Luxembourg. Web is a B2B application used by the subsidiaries and Customers of FAIRBANK. These modules are integrated with the legacy IFACTOR system in AS400. MQSI-MQSeries is used for MOM services.

Tools and technology used: IBM HTTP Server, PC Pentium, Windows NT Server 4.0, Windows 95 / 98, DB2, Java 2.0, Servlets 2.0, IBM Web Sphere Server 3.5, IBM Visual Age for Java – Enterprise Edition, Rational Rose 2000 Enterprise Edition, J2EE and JSP 2.0,AS/400, IBM MQSI-MQseries

Specific role/ Contribution:

•  Proposed a Unified Security Model with security policies and services provided by WebSphere Application Server.
•  Analyzed and prepared the functional specifications document for Rating boosters and ISRD.
•  Identified component implementation and deployment approach. Designed and developed system architecture for FAPS-Rating boosters and ISRD modules. Performed Integration testing for Rating Boosters module .

Customer: Hyundai Motors (Prototype)

Project : WEB BASED ORDER ENTRY SYSTEM (WOS) (Prototype)

Period: January 2001 - February 2001

Organization : Hexaware Technologies, chennai

Roles: Project Leader

Project Synopsis: This system (prototype) automates the vehicle and parts order entry process. This proposed system is used by the Dealers of Hyundai to enter the purchase order and payment information for vehicles and parts. This WOS used by Hyundai employees to place order for parts to their vendors.

Tools and technology used: IBM HTTP Server, PC Pentium, Windows NT Server 4.0, Windows 95 / 98, DB2, Java 2.0, Servlets 2.0, IBM Web Sphere Server 3.5, IBM Visual Age for Java – Enterprise Edition, Rational Rose 2000 Enterprise Edition, J2EE and JSP 2.0

Specific role/ Contribution:

• Designed and Drafted the Architecture of WOS, using the Model-View-Controller paradigm resulting to a very robust, easy-to-maintain multi-tier framework
• The WOS system reduces Average turnaround time involved in order placement and processing by 60 %.
• Requirement Analysis, Customer Requirements-Documentation.
• Prepared System Test Strategy documents and System Test Plans.
• Technical Review of Design Documents-OOAD.
• Develop program specifications for WOS Module.

 

Customer: IDBI BANK LTD

Project : Mobile Banking System.

Period: July 2000 – December 2000.

Organization : Hexaware Technologies, Chennai

Roles: Test Team Leader.

Project Synopsis:

Mobile Banking System is an application for Providing Banking services on mobile phone. Wireless Application Protocol (WAP) is open, global protocol that allows users of wireless devices to access Internet services and data instantly.This would enable easy and fast delivery of relevant information and services to mobile users. The presentation services developed using the WAP technology and through WML. Banking services are developed using ASP on IIS.The business rules and logic are implemented with COM components on Microsoft Transaction Server. The COM components are developed using Visual Basic.

The Mobile Banking System consists of Customer, Banking and System Administration Module
Tools and technology used: PC Pentium, Windows NT, MS SQL Server 7.0, IIS 4.0, UML - Rational Rose, WAP Technology - WML, WAP Enabled Mobile Cell Phone with the Micro browser Cellular Network, SAS WAP Gateway

Specific role/ Contribution:

• Performed an important role in the launch of the above solution termed 'Money Mobile' by IDBI Bank, which in technological association with Hexaware Technologies is one of the first bank in India to introduce a state-of-the-art service (both WAP and SMS technology) for its customers.
• As a Test Team Leader, for a group of 6 members, implemented a new testing methodology of having an independent test team in this project [Unit, Integration, Acceptance, and Functional].
• Preparation of Unit Test Plans and conducted the Independent testing for System Administration and WAP-Banking Module using Compuware 's QA run in a short span of 1 week.
• OOAD Design using Rational rose and Development of system administration module. [use case, class diagram, sequence diagrams] Generation of Logical Database Design.

 

Customer: Environmental Industries, Inc [EII], CA, US,

Project : WEB BASED INCENTIVE COMPENSATION SYSTEM

Period: April 2000 – June 2000

Organization : IT Solutions INC, San Roman, California, US

Roles: Onsite Project leader

Project Synopsis: Web Based Incentive Compensation System for Environmental Industries, Inc [EII], CA, US [Onsite]. Incentive compensation System, for EII, links Employee bonus directly to performance against scorecard targets, thus has an efficient Interface with the Balanced Scorecard System of EII. The Incentive Compensation system computes Metrics Bonus for all the employees in all job levels for all divisions of EII i.e., Environmental Care Inc., Environmental Golf Inc, Valley Crest, Valley Crest Tree and US Lawns based on EII Incentive compensation plan which links bonuses directly to performance against scorecard targets

Tools and technology used: PC Pentium, Windows NT, MS SQL Server 7.0, Visual Basic 6.0, ADO, VBScript, DTS Java Script 1.3, ASP 2.0 and IIS 4.0

Specific role/ Contribution:

• Was responsible for the following: Implemented the web based incentive compensation system for Environmental Industries, Inc., USA’s largest full-service site development, landscape and horticultural services contractor.
• The Web based incentive compensation system, reduced the cycle time for Incentive Comp Sheets generation from 3 weeks in the old process to 2 days
• Onsite Project leader for Web based Incentive compensation. Design of Incentive Compensation Templates for Job levels.
• Configuration reviews of SCIs. Design, Development of web based Incentive Compensation system.
• Preparation of Test Plans and Design Specifications.
• Onsite System Unit and Acceptance Testing of the Incentive Compensation System.OOAD. Design using Rational rose [UML].

Customer: ENVIRONMENTAL INDUSTRIES, INC, CA, US

Project : WEB BASED SCORE CARD SYSTEM

Period: August 1999 – March 2000

Organization : IT Solutions INC, San Roman, California, US

Roles: Onsite/Offshore Project Leader

Project Synopsis: The Scorecard system provides solution to document and archive the performance and activities of employees with respect the current business growth. The Scorecard metrics focus on Revenue Growth, Return on Investment, Cash Flow, Net Profit, Equipment Utilization, Customer Retention just to mention a few. Scorecard Metrics is linked to goal or target deployment metrics included for each manager's objectives.

Tools and technology used:. PC Pentium, Windows NT, MS SQL Server 7.0, Visual Basic 6.0, ADO, VB Script, DTS, Java Script 1.3 and Microsoft Visual Studio

Specific role/ Contribution:

• As a Project Leader, was responsible for the following: Incorporated new approach to management in Environmental Industries Inc, Calabasas, LA., CA,USA, Which was developed in the early 1990's by Drs. Robert Kaplan (Harvard Business School) and David Norton (Renaissance Solutions, Inc.), which resulted in the increase in the overall financial performance of EII by 19 % in 1999.
• Development of web based Scorecard system - Metrics computation. Software configuration management planning.
• Design and Development of Manual Metrics System. Preparation of Test Plans and Design Specifications for the Scorecard, Manual Metrics System. Detailed work item wise tracking of tasks and deliverables.
• Quality Assurance of Web Based Score Card System.
• Conducted System Testing and Drafted OOAD Design using Rational rose [UML].

 

Customer: Oxford Health Plans , Connecticut, US- Onsite

Project : ENTERPRISE ARCHITECTURE

Period: October 1998 - July 1999

Organization : Compunell Software, New Jersey, US

Roles: Object, Data, Process Modeler - Onsite

Project Synopsis: Worked in the Enterprise Architecture Division of Oxford Health plans. Involved in multiple Short Term Modeling Assignments for ongoing Projects (Development, Data Warehouse) in Oxford Health Plans.

Tools and technology used: PC Pentium, Windows NT, Designer 2000,

Object Data Base Designer 2.1, UML -
Rational Rose, Visio Enterprise, Business Objects, Java 2, BESIA Scripts,Java Script 1.3

Specific role/ Contribution:

• As an Object, Data, Process Modeler, was responsible for the following:
• Performed Object Modeling [State transition diagrams and Activity diagrams - UML] for Claims Re-Engineering project, was one of the major reasons for back to profit by Oxford Health plans, CT, USA [net earnings of $3.2 million, or $0.04 per common share, for the quarter ended March 31, 1999.] and NCQA Accreditation.
• Development of Real time Intranet Provider application [BESIA] with Java 1.2, JDK.
• Drafted Server Models Based on Subject Areas in 'Pulse' provider and Claims Application System.
• Generation of DDL scripts of the 'Pulse' - Provider and Claims Application.
• CASE Administration of Pulse Applications in Designer 2.1 .
• Defined the Data Model for Enterprise Data Warehouse based on the Best Practice Health care Data Model Perceived the Data, Process Model for all the External Interfaces for the Enterprise. (Oxford Health Plans)

Customer: Singapore Airlines SINGAPORE

Project : EXPORT HANDLING - CARGO OPEN SYSTEM

Period: September 1996 – October 1998

Organization : ASDC, SINGAPORE Airlines, Singapore

Roles: Systems Engineer – Onsite

Project Synopsis: The Cargo Open System was a Joint venture project between Singapore Airlines and Alitalia, the pioneers in Aviation industry to move from Amdahl Mainframe-TPF to opens systems. It has four core modules that are Acceptance, Ramp, Warehouse, Load Control and Additional Support Modules.

Tools and technology used: PC Pentium, HP-UX 10.02, Oracle 7.3, Designer 2000 1.3, Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL 2.3 and Pro C

Specific role/ Contribution:

As a Systems Engineer, was responsible for the following:

•  Design and Development of Export Warehouse Module Creation / Updates of Dead load Weight Statement for Flights (DLS)
•  Design and Development of Export Warehouse Module - Creation of Pre manifest for Outgoing Flights
•  Design and Development of Flight Schedule Generation - Generation of Operative Flight data from Schedule flight Legs.
•  Design and Development of Common Routines, which includes stored procedures and library routines.
• CASE Administration of CARGO OPEN SYSTEM APPLICATIONS in Designer 1.3
• Design and Development of Packages and Libraries PLL'S to interface with DLL's for print and CARGO EDI Functions using FFI .
• Managing system Resources creating user profiles and Roles .
• Maintaining integrity by Applying Server Enforced Integrity Rules.
• Application Tuning (SQLs) with TRACE EXPLAIN PLAN and TOAD.
• Database Design and Maintenance using Designer 2000 (ERD, Data Schema Diagrams-Logical and then Physical Schema Generation.) (Tools Entity    Relationship Diagrammer, Function hierarchy Diagrammer, Module Data Diagrammer, Module Logic Navigator)

 

Customer: TCS

Project : ORACLE 7.1 DATABASE FINE TUNING -Y2K PROJECTS

Period: June 1996 - August 1996

Organization : ASDC, Singapore Airlines

Roles: Systems Engineer

Project Synopsis: DBA Fine Tuning the Oracle 7.1 Database Maintenance, Generate output Text Data

Tools and technology used: PC Pentium, Unix, Oracle 7.1, PL/SQL, Developer 2000, SQL *Loader and SQL *DBA

Specific role/ Contribution:

As a Systems Engineer, was responsible for the following:

• Creation and maintenance of database
• Configuration of database parameters for tuning
• Back up and Recovery
• Reorganized the table spaces
• House Keeping - Importing Text Data into Oracle Tables
• Converting the data for Y2K standards

 

Customer: SESHASAYEE PAPER AND BOARDS

Project : COST ACCOUNTING MANAGEMENT INFORMATION SYSTEM [CAMIS]

Period: April 1995 – May 1996

Organization : HCL HP

Roles: Associate Consultant

Project Synopsis: CAMIS consists of Modules generating reports Related to Cost Accounting and MIS, Which includes Modules like Down time Analysis, Monthly Production Reports, Warehouse Stock Validation, Variance Analysis, Cost Audit Reports.

Tools and technology used: PC Pentium, HP UX 9.0, Oracle 7.0, PL/SQL, Developer 2000, SQL *Forms 3.0, SQL *Report Writer 2.3, Pro *C, ERWIN/ERX and Turbo Analyst

Specific role/ Contribution:

• CAMIS was one of the project assessed for ISO 9001 in HCL-Hewlett Packard, India
   
• Design and Development of Following Modules in Cost Accounting Management Information System
• Down Time Analysis - This gives the Stoppage details of all machines which are directly or indirectly involved in production of paper and boards.[ Boiler, Pulp Mill, Paper Machine, SODA recovery plant]
• Warehouse Stock Validation. - This determines the value of Stock of paper on given date in different types of Warehouse.
• Monthly Production reports This depicts the Production details of paper with respect Machine Production. Ash retention, Steam consumption, Power Consumption and talc quantity.
• Analysis and Development of Interfaces to CAMIS [ Planning and Production system, Management Information System, Marketing System
• Preparation of SRS, UTP, STP, SDD
• Implementation of QMS Methodology for PSO, HCL-Hewlett Packard in CAMIS Project.

 

Customer: IDPM INDIA

Project : PORT STATUS GENERATOR

Period: February 1994 – March 1995

Organization : BDPS IDPM

Roles: Systems Coordinator

Project Synopsis: This system depicts the current status of the shipping port. The status consists of various MIS Reports. The report consists of details of Import, Export, and Status of Ships proceeding In/Out, Details of shipping Companies.

Tools and technology used: PC Pentium, Oracle 6.0, PL/SQL, Developer 2000, SQL *Forms and SQL *Report Writer

Specific role/ Contribution:

As Systems Coordinator, was responsible for the following:

•     Design and Development of User Interface Module .
•     Tuning of SQL Statements .
•     Involved in writing stored procedures, packages and functions in PL/SQL .
•     Development of Program for input using SQL *Forms .
•     Providing MIS reports to the user through SQL query .
•     Project Coordination and tracking .

 

Customer: AST ENGINEERING

Project : PRODUCTION PLANNING AND CONTROL.

Period: June 1993 – January 1994 .

Roles: Systems Coordinator

Organization : BDPS IDPM

Project Synopsis: This system transforms resources as inputs (Raw Materials, Energy, Labor, Machines, IT) into an optimal solution. This coordinates production facilities in the process of Manufacturing Auto parts on schedule at optimum cost. The requirements are stabilized and production is controlled on requirements.

Tools and technology used: PC Pentium, Oracle 6.0, PL/SQL, Developer 2000, SQL *Forms and SQL *Report Writer

Specific role/ Contribution:

As Systems Coordinator, was responsible for the following:

• Development, Testing of Labor Schedule Module.
• Tuning of SQL Statements .
• Involved in writing stored procedures, packages and functions in PL/SQL .
• Development of Program for input using SQL *Forms .
• Providing MIS reports to the user through SQL query .
• Project Implementation.