Professional Summary
Around 2 1/2 years of IT experience in analysis, design, development, implementation and testing of applications in data warehousing and client/server environment. Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator. Experience in developing, testing and implementation of Packages, Stored Procedures and Functions at Database level using PL/SQL Familiar with SQL*Loader to load data from external source like flat files into database tables. Involved in unit testing, systems integration testing and documented the same. Excellent problem solving skills with a strong technical background. Creative, adaptive, and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team’s success. Possess good communication and inter-personal skills, able to adapt quickly to new technologies and environments. Got trained in PL/SQL and IBM information server 8.1 and Ascential Datastage 7.5/7.1 Education:
Masters in Software Engineering (M.S) (GPA: 3.89/4.0)
Bachelor of Engineering in Computers (B.S) (GPA: 3.4/4.0)
Certifications:
Oracle PL/SQL Developer Certified Associate
SKILL SET
Oracle
Oracle 10g/9i/8i
Other Databases
MS Access, MySQL
Programming
SQL, PL/SQL, Unix Shell Scripting, SQL*Loader, SQL*Plus, C, C++, Java, HTML
Data Warehousing
IBM Information Server (Datastage 8.1), Ascential DataStage 7.5.1/7.1, ETL, OLAP, OLTP, Autosys, Control M.
Data Modeling
Erwin, MS Visio.
Environment
UNIX, Sun Solaris 2.6, Sun OS, Windows 95/98/2000, Windows NT 4.0, IBM compatibles, Red Hat Linux, AIX.
Languages
C, C++, CORE JAVA, oracle pl/sql, VBA
Tools
CVS, SVN, Mercury Quality Center, JIRA
Others
Possess knowledge in Computer Networking Concepts
Employment Details:
Company
From
Till
Address
First Tek Technologies
March 2010
Present
Piscataway, NJ 08854, USA
Professional Experience
Confidential,
USA Mar’10- Present
Oracle Developer
First Tek Technologies is one of the fastest growing technology companies in the IT sector and a recognized service provider for wide array of industries. It offers a full range of comprehensive IT services, including technology deployment and support services.
Responsibilities:
Got trained in PL/SQL and Oracle Database. Got trained in IBM information server 8.1 and Ascential Datastage 7.5/7.1. Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers. Wrote SQL for BPC, TMS and HRC products. Written SQL code to extract data from oracle tables for data analysis. Developed user defined functions based on requirements. Created PL/SQL procedures and packages which are invoked by Java applications. Tested all new and modified program units and documented the same. Verification of functional specifications and review of deliverables Used CVS for version control. Environment: Oracle 9i, SQL Plus, PL/SQL and Windows XP, Shell Scripting, UNIX.
MS Academic Projects:
Confidential,
VA, USA Nov’09- Feb 10
Developer
Online Jobs Posting application helps to post jobs from business groups to Human Resources Group. The Application was developed using HTML, Java Script, Servlets, JSP, for front-end and Servlets to handle all forms sent to the back end residing on Oracle.
Responsibilities:
Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages which are invoked by Java applications. Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing. Environment: Oracle 9i, SQL Plus, PL/SQL and Windows XP, UNIX, Java, JSP, HTML.
BS Academic Projects:
Confidential,
INDIA Dec’05- May’06
Developer
The application was designed to provide greater efficiency to all aspects of customer services like Billing, Payments, Financial analysis and premium accounting. This system contains 8 subsystems, which include Order, Account Receivables, Account Payables, Purchase management system, Billing, Auditing, Cash value and Estimates. GUI screens are developed using Java and Backend is Oracle database.
Responsibilities:
Worked with SQL Loader to load data from flat files into various Oracle tables. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing. Environment: Oracle 8i, SQL Plus, SQL Loader, PL/SQL and Windows XP, UNIX.