Hi,
I require H1 Sponsorship. I have 5 yrs experiance in Software development.
I am Currently in US.
Email id : tall_gs@yahoo.com
RESUME
Professional Summary
I am a matured Oracle Developer, having 5 years of IT experience in the areas of Application Software Development, Data Warehousing and Maintenance using Client Server and Web Architecture. My hands on experience in project life cycle includes Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation & Support.
My Focus is on Database Development, Application Development and DBA Solutions. I have implementation experience in the Complete System Development Life Cycle. Functional expertise in Trade, Finance, Transport and Manufacturing Industries.
Database: Oracle 7x/8i/9i, MS Access, Knowledge of Oracle 10g, FoxPro
Application Software: Oracle Developer 6i, Forms 6i, Reports 6i, Oracle, Procedure Builder
Tools & Utilities SQL*Plus, SQL Loader, Toad 7.0,PL/SQL Developer, SAS
Reporting Tools: Oracle Report 6i, Oracle Graphics Designer 6i
Domain: Consumer Finance, Consumer Trade, Transport and Manufacturing
Operating Systems Windows NT 4.0 / XP/2000,UNIX
Internet Technologies ASP 2.0, VB Script, HTML
Languages C, C++, Java
EDUCATIONAL QUALIFICATIONS
· Oracle Certification – OCA – Paper I (SQL 9i )
· MS in Information Technology, India.
· Diploma in Computer Applications, India.
· Training by TULEC(division of TATA) in Oracle, Oracle Developer.
· Training in Core Java.
Project Details
1. Project: Trade Role : Oracle Developer & Database Designer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, Java.
Contribution:
· Gathered the requirement from the client and translated the business details into Technical design.
· Used the technical document to design the database tables.
· Created database triggers for data security.
· Created Stored Procedures and Functions to be called by Java Demons.
· Created Packages to be called by Visual Basic modules.
· Optimize SQL queries for better performance.
· Used the functional document to design application logical and the physical design using PL/SQL and Oracle Developer 6i.
· Key mapping utility of Forms on Unix environment
· Written Korn Shell scripts for mounting database and create SQL*Plus session.
· Prepared Test Plans for various modules.
· Prepared user manual and technical support manual.
· Implementation support.
2. Project: Cash Role : Oracle Developer & Database Designer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, Java.
Contribution:
· Gathered the requirement from the client and translated the business details into Technical design.
· Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures and generated system test plans.
· Worked closely with the Administrator for proper backup and recovery plans.
· Fine Tuned the SQL queries using hints for maximum efficiency and performance.
· Created database triggers.
· Created Stored Procedures and functions to be used in oracle developer.
· Created multi-form application using Forms 6i and incorporated user exits in it.
· Installation and configuration of Forms 6i on Sun Solaris Server.
· Created executable files for generation and execution of Forms application on Sun Solaris.
· Created User Exits using PRO*C.
· Written Korn Shell scripts for mounting database to recover data.
3. Project Name: Trade+ Role : Oracle, PL/SQL Developer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, SQL Loader, SAS.
Contribution:
· Gathered the requirement by talking to the User group and translated user requirements into data flows, detail technical specifications and database requirement.
· Prepared a database design document based on the functional and technical specifications.
· Prepared the user interface document and technical document based on the Functional specifications and current system.
· Involved in design and development of database.
· Designed and Created database objects.
· Created database triggers.
· Written SAS Scripts for data extraction and transformation.
· Tested the ETL process in testing environment.
· Created Stored Procedures and Functions to call various oracle developer modules.
· Application development using Forms 6i.
· Written Korn Shell scripts for automating the process of data loading.
4. Project Name: Computerized Maintenance Role : Module Leader
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, SQL Loader.
Contribution:
• Prepared Functional and Program Specification Documents.
• Prepared schedules for various modules.
· Created database triggers.
· Created stored procedures and functions.
· Written SQL Loader Scripts for data extraction and transformation.
· Tested the ETL process in testing environment.
· Tested the ETL process in production environment.
· Created and managed users and roles.
· Monitor performance and changing performance requirements through application of Database tuning and performance optimization techniques.
5. Project : Transaction Processing and Account Maintenance
Role : Module Leader.
Environment: Oracle 8i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, SQL Loader.
Responsibilities:
· Technical assessment of modules.
· Preparing Functional and Program Specification Documents
· Coded Stored Procedures, functions and triggers at High level.
· Fine Tuned the SQL queries using hints for maximum efficiency and performance.
· User Acceptance Testing UAT
· Implemented project at client place.
· User Training and technical support.
· Prepared proper backup and recovery plans.
· DBA activities like creating users, roles and granting and revoking privileges.
6.Project : Online Service Desk Role : Oracle Developer
Environment: Oracle 8i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0.
Responsibilities:
· Performing System Study, System Analysis and Design
· Coding using PL/SQL.
· Creating Oracle Forms and Reports.
· Building Program Units in Forms.
· Design the layout of the report according to the client‘s need.
· Preparing test plans and testing Units based on test plans.
· Performing System Testing.
· Preparing Implementation Documentation and user support documents
7.Project: Integrated Sales and Marketing Role : Oracle Programmer
Environment : Oracle 7.3, Developer 2000 for Windows 95, Forms 4.5, Reports 2.5
Responsibilities:
· Performing System Study, System Analysis and Design
· Creating procedures and functions.
· Designing User interface Units in Forms and Reports.
· Design the layout of the report according to the client’s need.
· Preparing test plans and testing Units based on test plans.
· Preparing Implementation Documentation and user support documents.
8.Project: Online Training and Examination Role: Programmer
Environment: Windows 95 Oracle 7.3, Developer 2000 for Windows 95, Forms 4.5, Reports 2.5, Graphics 2.5
Role/Responsibilities:
· Performing requirement Study.
· Creating procedures and functions.
· Designing User interface Units in Forms, Reports, Graphics.
· Design the layout of the report.
· Preparing test plans and testing Units based on test plans.
· Preparing Implementation Documentation and user support documents
9.Project: Online Training and Examination Role: Programmer
Environment: Windows 95, Oracle 7.3, PL/SQL , SQL Loader, FoxPro
Role/Responsibilities:
· Coding using PL/SQL
· Data extraction and loading using SQL Loader.
· Preparing Documents
ADDITIONAL INFORMATION
Team Captain for Badminton in school
Winner for two consecutive years in Interschool Badminton match.
I require H1 Sponsorship. I have 5 yrs experiance in Software development.
I am Currently in US.
Email id : tall_gs@yahoo.com
RESUME
Professional Summary
I am a matured Oracle Developer, having 5 years of IT experience in the areas of Application Software Development, Data Warehousing and Maintenance using Client Server and Web Architecture. My hands on experience in project life cycle includes Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation & Support.
My Focus is on Database Development, Application Development and DBA Solutions. I have implementation experience in the Complete System Development Life Cycle. Functional expertise in Trade, Finance, Transport and Manufacturing Industries.
Database: Oracle 7x/8i/9i, MS Access, Knowledge of Oracle 10g, FoxPro
Application Software: Oracle Developer 6i, Forms 6i, Reports 6i, Oracle, Procedure Builder
Tools & Utilities SQL*Plus, SQL Loader, Toad 7.0,PL/SQL Developer, SAS
Reporting Tools: Oracle Report 6i, Oracle Graphics Designer 6i
Domain: Consumer Finance, Consumer Trade, Transport and Manufacturing
Operating Systems Windows NT 4.0 / XP/2000,UNIX
Internet Technologies ASP 2.0, VB Script, HTML
Languages C, C++, Java
EDUCATIONAL QUALIFICATIONS
· Oracle Certification – OCA – Paper I (SQL 9i )
· MS in Information Technology, India.
· Diploma in Computer Applications, India.
· Training by TULEC(division of TATA) in Oracle, Oracle Developer.
· Training in Core Java.
Project Details
1. Project: Trade Role : Oracle Developer & Database Designer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, Java.
Contribution:
· Gathered the requirement from the client and translated the business details into Technical design.
· Used the technical document to design the database tables.
· Created database triggers for data security.
· Created Stored Procedures and Functions to be called by Java Demons.
· Created Packages to be called by Visual Basic modules.
· Optimize SQL queries for better performance.
· Used the functional document to design application logical and the physical design using PL/SQL and Oracle Developer 6i.
· Key mapping utility of Forms on Unix environment
· Written Korn Shell scripts for mounting database and create SQL*Plus session.
· Prepared Test Plans for various modules.
· Prepared user manual and technical support manual.
· Implementation support.
2. Project: Cash Role : Oracle Developer & Database Designer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, Java.
Contribution:
· Gathered the requirement from the client and translated the business details into Technical design.
· Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures and generated system test plans.
· Worked closely with the Administrator for proper backup and recovery plans.
· Fine Tuned the SQL queries using hints for maximum efficiency and performance.
· Created database triggers.
· Created Stored Procedures and functions to be used in oracle developer.
· Created multi-form application using Forms 6i and incorporated user exits in it.
· Installation and configuration of Forms 6i on Sun Solaris Server.
· Created executable files for generation and execution of Forms application on Sun Solaris.
· Created User Exits using PRO*C.
· Written Korn Shell scripts for mounting database to recover data.
3. Project Name: Trade+ Role : Oracle, PL/SQL Developer
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, PRO*C, Korn Shell Scripts, SQL Loader, SAS.
Contribution:
· Gathered the requirement by talking to the User group and translated user requirements into data flows, detail technical specifications and database requirement.
· Prepared a database design document based on the functional and technical specifications.
· Prepared the user interface document and technical document based on the Functional specifications and current system.
· Involved in design and development of database.
· Designed and Created database objects.
· Created database triggers.
· Written SAS Scripts for data extraction and transformation.
· Tested the ETL process in testing environment.
· Created Stored Procedures and Functions to call various oracle developer modules.
· Application development using Forms 6i.
· Written Korn Shell scripts for automating the process of data loading.
4. Project Name: Computerized Maintenance Role : Module Leader
Environment: Oracle 9i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, SQL Loader.
Contribution:
• Prepared Functional and Program Specification Documents.
• Prepared schedules for various modules.
· Created database triggers.
· Created stored procedures and functions.
· Written SQL Loader Scripts for data extraction and transformation.
· Tested the ETL process in testing environment.
· Tested the ETL process in production environment.
· Created and managed users and roles.
· Monitor performance and changing performance requirements through application of Database tuning and performance optimization techniques.
5. Project : Transaction Processing and Account Maintenance
Role : Module Leader.
Environment: Oracle 8i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0, SQL Loader.
Responsibilities:
· Technical assessment of modules.
· Preparing Functional and Program Specification Documents
· Coded Stored Procedures, functions and triggers at High level.
· Fine Tuned the SQL queries using hints for maximum efficiency and performance.
· User Acceptance Testing UAT
· Implemented project at client place.
· User Training and technical support.
· Prepared proper backup and recovery plans.
· DBA activities like creating users, roles and granting and revoking privileges.
6.Project : Online Service Desk Role : Oracle Developer
Environment: Oracle 8i , Oracle Developer 6i, Forms 6i, Reports 6i , Toad 7.0.
Responsibilities:
· Performing System Study, System Analysis and Design
· Coding using PL/SQL.
· Creating Oracle Forms and Reports.
· Building Program Units in Forms.
· Design the layout of the report according to the client‘s need.
· Preparing test plans and testing Units based on test plans.
· Performing System Testing.
· Preparing Implementation Documentation and user support documents
7.Project: Integrated Sales and Marketing Role : Oracle Programmer
Environment : Oracle 7.3, Developer 2000 for Windows 95, Forms 4.5, Reports 2.5
Responsibilities:
· Performing System Study, System Analysis and Design
· Creating procedures and functions.
· Designing User interface Units in Forms and Reports.
· Design the layout of the report according to the client’s need.
· Preparing test plans and testing Units based on test plans.
· Preparing Implementation Documentation and user support documents.
8.Project: Online Training and Examination Role: Programmer
Environment: Windows 95 Oracle 7.3, Developer 2000 for Windows 95, Forms 4.5, Reports 2.5, Graphics 2.5
Role/Responsibilities:
· Performing requirement Study.
· Creating procedures and functions.
· Designing User interface Units in Forms, Reports, Graphics.
· Design the layout of the report.
· Preparing test plans and testing Units based on test plans.
· Preparing Implementation Documentation and user support documents
9.Project: Online Training and Examination Role: Programmer
Environment: Windows 95, Oracle 7.3, PL/SQL , SQL Loader, FoxPro
Role/Responsibilities:
· Coding using PL/SQL
· Data extraction and loading using SQL Loader.
· Preparing Documents
ADDITIONAL INFORMATION
Team Captain for Badminton in school
Winner for two consecutive years in Interschool Badminton match.