PROJECT DESIGN, DEVELOPMENT, IMPLEMENTATION AND PRODUCTION SUPPORT & MAINTENANCE OF THE CORPORATE DATA-WAREHOUSING (CDW) PROJECT FOR TELSTRA, AUSTRALIA.
Team Size Project Team Size: 120; Module Team Size: 25
Period May 2004 – Till Date
Designation Systems Analyst (Team Lead)
Software Used Oracle 8i / 9i (PL/SQL), Java (Core Java & JDBC)
Responsibility Design, Development and Implementation and Support of different 20+ applications in CDW. Was posted in Melbourne (Australia) in the beginning for onsite work and client interactions before the development of different applications. Presently posted at Bangalore (India) for the same working in onsite-offshore mode. Primary responsibilities are as follows:
Design, Development and Implementation of different new applications of CDW.
Design, Development and Implementation of different enhancements related to functionality and performance of existing application of CDW.
Production Support & Maintenance of the different applications of CDW.
PROJECT DEVELOPING THE DATA MATCHING / DE-DUPE TOOL DATAGYM® VERSION 5 USED IN DATA WAREHOUSING
About DataGym® DataGym® is a set of data management software tools, which are usually deployed in processes designed to meet specific business objectives. For example, one-time clean up of data files, maintaining a database just right for your business, and enhancing your marketing activities over the Internet and other conventional channels. More details about this product can be found at [login to view URL].
Team Size 8
Period Jan 2001 – Nov 2001 (7 months)
Designation Software Engineer (Oracle & Java)
Software Used Oracle 8i (PL/SQL), Java (JFC & Swing and JDBC)
Responsibility - Developing User Interfaces using Java as per Design from the Design Team. The GUI was developed in Java – Swing and the Business Logic (BL) and DB Connectivity was developed using JDBC Thin Client.
- Developing Processing Logic in Oracle (PL/SQL) as per Design from the Design Team.
PROJECT IMPLEMENTING DATAGYM® VERSION 5 FOR AMERICAN EXPRESS, USA (PDB1)
Team Size 4
Period Dec 2001 – April 2002 (5 months)
Designation Sr. Software Developer (Implementation)
Software Used Oracle 8i (PL/SQL), Java (JFC & Swing and JDBC)
Responsibility - Building up of Prospect Database for American Express, USA for Brazil and Mexico Markets at our office premises at Dallas TX, USA for PDB1 (Prospect Data Base).
- Customizing some processes as per client need using Oracle (PL/SQL)
- Customizing certain GUIs as per client requirement using Java (JFC & Swing and JDBC).
- Fine tune Oracle (PL/SQL) programs for improving the performance of execution of different processes.
- Do some Database Tuning also for the need of improving the performance.
- Generating customized sample reports and QC reports for the execution of different files.
- Do custom development of some more programs as per client requirement. This I had to do using both Oracle (PL/SQL) and Java.
- In this period more than 30 million records for Brazil Market and another 20 million records for Mexico market were processed and the 1st PDB or initial settings up of data base for the 2 markets for American Express was done.
PROJECT REDESIGNING DATAGYM® VERSION 6
Team Size 3
Period May 2002 – Aug 2002 (4 months)
Designation Team Leader (Product Design & Architecture)
Responsibility - Redesigned DataGym® as version 6 for
o improving performance
o improving other technicalities
o giving more adaptability to plug in more features to DataGym® in near future
- Designed DataGym® version 6 with 3-tier architecture concept. In the previous version, the Product had 2-tier architecture and the processing was done at backend. In this version we designed the product processing is done in the Middle Tier.
- Designed a generic architecture in the Middle Tier that may interact with the Backend Database and Front End client of the product.
PROJECT IMPLEMENTING DATAGYM® VERSION 5 FOR AMERICAN EXPRESS, USA (PDB2 & PDB3)
Team Size 4
Period May 2002 – Oct 2002 (6 months)
Designation Team Leader (Product Design & Architecture)
Software Used Oracle 8i (PL/SQL), Java (JFC & Swing and JDBC)
Responsibility - With my experience of implementation the 1st PDB for American Express, I could assist the Implementation Team at Dallas TX, USA from here in the evening hours through late nights.
- 2nd and 3rd PDB was also build and implemented.
- Customize the programs as per client needs for PDB2 and PDB3.
- Reviewing codes thoroughly to tune them to get the best performance as the processes were running slower with days and with more data in the DB.
- Make necessary design changes and develop new programs for fasten up the processes and as per client’s need.
PROJECT DEVELOPING THE DATA MATCHING / DE-DUPE TOOL DATAGYM® VERSION 6 USED IN DATA WAREHOUSING
Team Size 12
Period Sep 2002 – Jan 2003 (5 months)
Designation Team Leader (Product Design & Architecture)
Software Used Oracle, Java (JFC & Swing, JDBC and RMI)
Responsibility Though a part of the design team, I had to take part in development work for speeding up the development process and also share my experience of coding with the development for proper development.
- Developed process logics at the Middle Tier for some of the processes using Java.
- Developed the generic classes (in Java) at the Middle tier that will interact with the Front End and also with the Back End Database Server. Design is based on Oracle 8i and Java (RMI & Swing).
- Developed GUIs the using Java.
- Guided the developers such that they may do the coding accordingly and they may be code a process specifically as per the logic designed.
PROJECT DESIGN & DEVELOPMENT OF SECURITY PROCESS & LICENSING FOR DATAGYM® VERSION 6
Team Size 2
Period June 2003 – August 2003
Designation Team Leader (Product Design & Architecture)
Software Used Oracle, Java
Responsibility - Designed the User Access Security for DataGym® version 6
- Designed the Encryption & Decryption Process to protect of code & data (those are required by DataGym® core processes) to protect the Intellectual Property (IP) of CIANT.
- Designed a process for protecting the License issued to a client based on the time period and as well as the volume of data processed.
- Developed the User Access Security for DataGym® version 6
- Developed the Encryption & Decryption process for DataGym® version 6.
- Developed the Licensing Process for the product DataGym® version 6.
PROJECT DESIGN OF DATA RESOLUTION & TABLE UPDATE PROCESSES FOR ENHANCEMENT OF DATAGYM® VERSION 6
Team Size 2
Period September 2003 – January 2004
Designation Team Leader (Product Design & Architecture)
Software Used Oracle, Java
Responsibility “Data Resolution” is a process to resolve the matched records into a single or synchronizing multiple records as per need. “Table Update” is a process to update the history tables of the database with that of the resolved records as done in “Data Resolution” process.
- Design the table structure and processing logic of different processes of Data Resolution module for DataGym® version 6
- Design the table structure and processing logic of different processes of Table Update module for DataGym® version 6
- Design the GUIs for these processes
PROJECT DEVELOPMENT & IMPLEMENTATION OF DATAGYM FOR ICICI PRUDENTIAL
Team Size 10
Period December 2003 – May 2004
Designation Team Leader (Product Design & Architecture)
Software Used Oracle (PL/SQL, Performance Tuning), Java (Core Java, JDBC & Swing)
Responsibility ICICI needs our tool for Data Cleanup & Parsing, Matching, Resolving, Updating and Extracting for their D/W application. There are different stages of implementation and all the stages will be over by May 2004.
- Designing different customized processes for ICICI that may be included as enhancements of DataGym® version 6.
- Designing different customized processes for ICICI that may be included as additional functionalities of DataGym® version 6 for ICICI.
- Developing the customized processes for ICICI in PL/SQL & Java (Core Java & JDBC)
- Developing the customized GUI for ICICI in Java (Swing)
- Code Review and Performance Tuning of different Processes. This happens to be major part of implementation.
PROJECT IMPLEMENTATION OF DATAGYM FOR DIFFERENT PILOT PROJECTS
Team Size 10
Period January 2004 – May 2004
Designation Team Leader (Product Design & Architecture)
Software Used Oracle (PL/SQL, Performance Tuning), Java (Core Java, JDBC & Swing)
Responsibility - Implementation of Pilot projects for different clients like Reader’s Digest (Mexico), PROCESSAR (Mexico), IDBI (India), Bank of Baroda (India), CITI Corp (India), AMEX (India), Taj Group of Hotels (India) etc. Many of these pilot projects include processing of more than 50 million data.
- Designing different processes for different clients as per their requirement that may be considered as enhancements of DataGym® version 6.
- Designing different customized processes for different clients that may be included as client specific customized solutions for DataGym® version 6.
- Developing the customized processes in PL/SQL & Java (Core Java & JDBC)
- Developing the customized GUI (as and when required) in Java (Swing)
- Code Review and Performance Tuning of different Processes. This happens to be major part of implementation.
Developed an "ERP Solution" [for MM Aqua Technologies (Gurgaon), Tega Industries, (Kolkata)] - Led the team in analysis, design & development of the system using Oracle 8i (PL/SQL), Developer/2000 & 6i. The system included the following modules: Marketing & Order Generation, Production Planning, Production, Plant Maintenance, Stores & Purchase, Invoicing & Despatch, and Accounts Receivable.
