Professional Summary

• Experienced as Oracle developer in large production environments with database implementation on UNIX and Windows.
• 7 Years of experience in the Information Technology field with extensive experience in Database development, Shell Perl Scripting, Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support.
• Experienced in developing the UNIX Shell Scripts and PERL Scripts to execute the scripts and manipulate files and directory.
• Extensive knowledge of Oracle11g/10g/9i/8i/, SQL, PL/SQL procedures, packages, functions, database triggers
• Experience in working with Oracle Forms and Oracle Reports.
• Experienced in Developing PL/SQL Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Experience in loading data, troubleshooting, Debugging mappings, performance tuning of procedures and SQL queries.
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Experienced in writing SQL queries creating different kinds of reports from large scale database.
• Extensively involved in troubleshooting, debugging and fixing the codes/scripts.
• Experienced in migration of database from SQL Server 2000 to Oracle 10g
• Worked with various SQL Editors such as TOAD, SQL Plus, and PL/SQL Developer.
• Extensive Knowledge and Experience in ETL tools like SQL Loader to transfer the data between different databases.
• Extensive Knowledge and Experience in Data Analysis and managing data warehouse and data marts
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Skills in developing code to interact with databases with knowledge of Front End design in both windows and web application
• Experienced in providing technical production support.
• Extensive knowledge on Autosys Job Scheduling and JAWS Reporting tool for Autosys
• Exposure to J2EE / XML, Web Services and WebLogic tool
• Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents.
• Knowledge of the entire development process including specification, documentation, quality assurance and implementation SDLC
• Strong analytical, problem solving and communication skills with strong focus towards goals and work ethics

Technologies

Education Background

Bachelor of Computer Engineering B.E from Tribhuvan University, Kathmandu, NEPAL

Professional Experience

Confidential

Oracle Developer

Responsibilities

• Work closely with the sales, marketing, and finance teams to update rebate offers and the associated data within the database
• Design, develop and test new offers, clone existing offers, make changes, and creates new parameters within the database.
• Involve in preparing functional document, user document, process flow diagram and flow charts.
• Create the PL/SQL packages, procedures, functions, custom triggers applying the business logic
• Lead the effort to move all the Autosys files into JAWS.
• Lead the effort to revamp the Early Cancellation Fee ECF Functionality
• Create the test scripts and complex queries to test the application and to quality assurance of the data.
• Extensively involved in UNIX shell scripting and good knowledge of PERL scripting
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in creation/scheduling of Autosys Jobs JIL file generation
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Interactions with the SQA Teams on upcoming Projects and Requirements
• Extensively involved in sub version, creating release branches and integrating the older branches to main trunk
• Create and Maintain the release branch in SVN for each release and work together with various developer
• Coordinating with the Development team and helping integrate various moving parts for a Release
• Scheduling Emergency Releases by interacting with various Application Delivery Management teams
• Supporting the Production Deployment of Planned Releases from Development Lead perspective

Environments: Oracle 11g, PL/SQL, PL/SQL developer, TOAD, SQL developer, Putty, SQL Plus, SQL Loader, FTP, UNIX, MS Office, MS Visio, Ultra Edit, ALM, WinSCP, Perl Scripting

Confidential

Oracle Developer

Responsibilities:

• Involved in all the stages of Software Development Lifecycle SDLC design, development, analysis, testing and deployment of timesheet application.
• Gathered the Requirement from the business use and prepared the program specification and design document for the development of the Timesheet Application.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the database with employees' timesheet and to calculate payroll.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the UNIX shell scripts to create table, views, indexes and sequence.
• Created the custom tables to import the employee data and insert into the timesheet database.
• Developed the SQL Loader scripts to load data into the staging tables from the flat files.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Skill Sets/Environments: Oracle 11g, SQL Server, PL/SQL, SQL Plus, SQL Loader, TOAD, Visual, SourceSafe, FTP, DTS package, MS- Office, UNIX, Shell Scripts, MS Office, MS Visio.

Confidential

Oracle Developer

Responsibilities:

• Designed and developed distributed project management, Web-based tool to automate the tasks associated with the software development process.
• Involved in design, development, customization and integration of workflows, reports, and interfaces as per the business requirements. Involved in business process re-engineering and implementation of the support system.
• Responsible for code installation and maintenance of production systems as a Development lead
• Responsible for creating the UNIX scripts for the custom interfaces, reports and programs based on the business requirements.
• Extracting, cleansing, aggregating, transforming and validating the data to ensure accuracy and consistency
• Authored extensive SQL, PL/SQL stored procedures, oracle packages, ETL programs, partitioning, materialized views, functions and triggers, UNIX shell scripts and SQL Loader programs to perform data migration while preparing Source Staging, Migration Staging and Target environments.
• Used UNIX shell scripts to code scripts to execute various Oracle processes, stored procedures, SQL/DDL scripts etc and capture all errors related to the Server and Oracle.
• Coded reports in PL/SQL and returned the result sets to JSP using JDBC and ODBC.
• Developed Java Web Services by using existing PL/SQL procedures.
• Involved in Data modeling and design of data warehouse in star schema methodology with conformed and granular dimensions and FACT tables.
• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
• Logged all transactions and generated exhaustive reports to identify process performance ratio, errors prioritized, and percentage of success and failure reports etc in an understandable cross-matrix layout enabling Business Intelligence staff to perform gap analysis.
• Implementing the backup procedures like exporting the schemas, hot backups and cold backups.
• Involved in performance testing and unit testing.

Skill Sets/Environment: Oracle 9i/10g, SQL, PL/SQL, SQL Loader, UNIX, PL/SQL Developer, Toad, Erwin 4.0, Windows2000, Java, J2EE, XML, HTML.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyze, extract, transform, load, and integrate data into consumable formats, meeting all critical milestones using data warehouse techniques.
• Actively involved in design, analysis, developing, testing and performance tuning. Creating/coding reports that meet user requirements, validating reports, supporting data and technical requests, and supporting strategic data analysis.
• Experience in using OLAP/OLTP concepts for data stored in the data base.
• Involved in promoting the shell scripts, triggers, PL/SQL procedures, functions from Development to Test and Test to Production Environment
• Used SQL Loader to Bulk load the data from the flat files to database.
• Created shell scripts for tables, views, indexes, sequence for DBA.
• Extensively worked on Performance Tuning
• Extensively used Pl/SQL for creating packages, procedures and functions.
• Involved in constructing complex SQL queries with sub-queries, inline views as per the functional needs.
• Extensively used UNIX command and remote access methods like TELNET, SSH, FTP, VPN etc.
• Have experience using the DBLINK to use data from different databases.
• Executing, monitoring various UNIX shell scripts, escalating and bug fixing the related issues as required, providing solutions, implementing code logic as per functional, ad-hoc requirements.
• Alter Database objects storage parameters to accommodate changes in the Database Environment.
• Analyze objects and optimize using Query optimizer.
• Involved in Data modeling and design of data warehouse in star schema methodology.
• As a Development Lead worked Actively in ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: PL/SQL SQL SQL Plus Oracle 10g Oracle Forms 10g 10gAS Oracle Designer 10g Linux Windows XP TOAD Oracle Reports 10g