We provide IT Staff Augmentation Services!

Senior Programmer Engineer / Dba Resume

Atlanta, GA

SUMMARY:

  • Software Professional with over 15 YEARS of experience in IT industry.
  • Excellent experience in the software development life cycle that involves Analysis, Design, Development, Testing and Implementation.
  • Excellent experience in Oracle Database Administration and Production Support activities.
  • Excellent programming experience in RDBMS like ORACLE 11g/10g/9i/8i/8.0/7x using SQL, SQL*PLUS, PL/SQL script, SQL*LOADER, PRO*C on UNIX as well as Windows platform.
  • Very strong experience in ORACLE DEVELOPER 2000 using Forms 4.5 and Reports 2.5/3.0.
  • Very strong experience in DBA activities that involved applications like Oracle Enterprise Manager.
  • Good experience in ORACLE FINANCIALS release 10.7/11.0 using General Ledger module.
  • Experienced in Web Development in ORACLE WEB SERVER environment using HTML.
  • Excellent programming experience in UNIX shell scripting that include utilities like PERL, AWK and SED.
  • Very strong programming experience in technologies like SAS, C, Informix 4GL, FOXPRO, CLIPPER, FORTRAN, COBAL, BASIC.
  • Experienced in scheduling utilities like AUTOSYS, MAESTRO, TWS and Cron.
  • Hands on experience in .NET using ASP.NET and VB.NET.
  • Hands on experience in Crystal Reports, Actuate and Jenkins.
  • Hands on experience on Mongo Databse.

EXPERTISE AREA:

  • Insurance System
  • Asset Management System
  • Credit Card Transaction Processing System
  • Child Care Management Systems
  • Medical & Medical transcription Systems
  • Banking, Financial & Accounting Systems
  • Inventory System
  • Telecommunication System
  • Training System
  • Transportation System
  • Distribution System

COMPUTER SKILLS:

Operating Systems: UNIX, MS Windows 98, Windows 2000, Windows XP Professional, DOSVista.

Database: ORACLE 7x/8.0/8i/9i/10g/11g.

Development Tools: ORACLE Enterprise Manager, ORACLE Forms 4.5, ORACLE ReportsSQL*LOADER ORCLE INANCIALS Release 10.7/11.0 (General Ledger)Crystal Reports, Actuate Report Scheduler, Informatica, Jenkins.

Languages: ORACLE PL/SQL, SQL, SQL*PLUS, UNIX Shell script, PERL, SAS, CHTML, VB .NET, FoxPro, Informix 4GL, Clipper, Fortran, Cobol, Basic.

WORK EXPERIENCE:

Confidential, Atlanta, GA

Senior Programmer Engineer / DBA

Responsibilities:

  • Extensively involved in Database maintenance activities like synchronizing various development and QA databases with respect to database objects and data, required by various development teams for their development purposes .
  • Extensively involved in monitoring database performance using Oracle Enterprise Manager.
  • Extensively involved in the automation and development of Unix shell scripts and Oracles PLSQL scripts to keep the QA databases current with respect to Production data, for testing purposes.
  • Extensively worked on trouble shooting Oracle SQL queries that were used in Crystal reports, for better performance of the reports. Optimization features like running EXPLAIN PLAN and AUTOTRACE were used to study the execution plan of the SQL statements.
  • Extensively involved in development activities like creating Oracle Packages, Procedures and Functions to process data from staging tables and insert into OLTP and Data warehouse tables, that were used for reporting and financial purposes.
  • Extensively worked on UNIX Shell scripting using AWK utilities to process text files, from distribution centers, before loading them into Oracle Table using SQLLDR utility.

Environment: Oracle 11g, PL/SQL, SQL, SQL Developer, UNIX.

Confidential, Atlanta, GA

Senior Programmer Engineer / DBA

Responsibilities:

  • Extensively involved in DBA activities like creating and dropping Oracle Users, creating Roles, assigning Privileges, creating and extending Table spaces, creating Database Links, Synonyms, Gathering Statistics, Compressing Tables, designing Database Schemas that involved objects like Tables, Global Temporary Tables, Indexes, Views, Materialized Views etc.
  • Extensively involved in monitoring database performance using Oracle Enterprise Manager.
  • Extensively worked on trouble shooting application performances using utilities like TKPROF.
  • Extensively worked on Exporting and Importing Tables across Schemas, and Schemas across Databases using EXPDP and IMPDP utilities.
  • Extensively worked on scripts to represent data in the XML format using XMLDOM package.
  • Heavily involved in OPTIMIZATION methods that involved tuning of Oracle SQL and PL/SQL objects. Optimization features like running EXPLAIN PLAN and AUTOTRACE were used to study the execution plan of the SQL statements.
  • Extensively involved in Development activities like creating Packages, Procedures and Functions to process Insurance Claims data for Confidential Clients.
  • Extensively worked on UNIX Shell scripting using AWK utilities to process complicated files, from clients, before loading them into Oracle Table using SQLLDR utility.

Environment: Oracle 11g, Oracle Enterprise Manager, PL/SQL, SQL, PLSQL Developer, UNIX.

Confidential, Atlanta, GA

Senior Programmer Analyst

Responsibilities:

  • Worked on an application module called Confidential that determines the health of an energy asset, using technologies like Oracle and a Confidential proprietary front end development tool called Focal Point.
  • Extensively worked on data warehouse functionality using Oracle CUBE, ROLLUP and GROUPING aggregate functions that helped customers view Asset Health Readings based on different asset entities.
  • Worked on generating front end client screens in the form of Dashboards and Web parts that supports the drill down features to access and interpret the cubing results in a meaningful pictorial representation, using the Focal Point frontend tool.
  • Worked on the ETL processes to extract, transform and load customer data into the Focal Point system using the proprietary tool called FP - ETL.
  • Extensively worked on reengineering the Confidential Release installation kit that included processes to drop all the schemas, re-create all schemas, re-create all the objects like tables, constraints, privileges, procedures, functions, packages, views, materialized views, synonyms etc.
  • Worked on OPTIMIZATION of the entire system that involved tuning of Oracle SQL and PL/SQL objects. Optimization features like running EXPLAIN PLAN and AUTOTRACE were used to study the execution plan of the SQL statements and Procedures. This included Gathering STATISTICS on database objects like tables and also schemas.

Environment: Oracle 11g, PL/SQL, SQL, Toad, Focal Point, Focal Point ETL.

Confidential, Atlanta, GA

Senior Programmer Analyst

Responsibilities:

  • Involved in planning, designing and developing a process to transfer huge data from one Database to another Database using Oracle Streams/CDC Technology using Oracle 10g.
  • Involved in scheduling oracle jobs using DBMS SCHEDULER package.
  • Involved in reengineering an existing file generating engine using Oracle stored packages, stored procedures and functions. This engine would carry out a series of processes starting from scheduling time based jobs and ending in FTP process of the generated data files to appropriate destinations.
  • Involved in writing Oracle packages to generate flat text files that consists of non-monitory data, for Global customers.
  • Deeply involved in scheduling jobs using Oracle and Jenkins software to perform tasks on a different servers.
  • Involved in debugging and modifying PERL script that is used to implement releases and patches in Confidential .
  • Deeply involved in supporting production activities that leads to processing of customer transaction data and supply the customers with necessary monitory and non-monitory information. These activities also include implementation of duties like monitoring scheduled system jobs, troubleshooting job failures, regeneration of data, in the form of flat files, on customer’s request, etc.

Environment: Oracle 10g, PL/SQL, SQL, PL/SQL Developer, Jenkins, Perl.

Confidential, Atlanta, GA

Production Support and Integration specialist

Responsibilities:

  • As a production support specialist, involved in monitoring daily, weekly and monthly run jobs.
  • Involved in creating various types of work plans like compensation, pay, post etc. using a Confidential developed tool called Truecom.
  • Involved in scheduling jobs using UNIX Crontab utility. Involved in validating production data after the jobs have run on a daily basis.
  • As an integration specialist, responsible for integrating different modules into one application before migrating to production.
  • Involved in re-designing and re-engineering UNIX and Oracle Scripts for various existing jobs for better performance.

Environment: UNIX, Oracle9i, PL/SQL, SQL, Toad, Actuate, Informatica, Truecom.

Confidential

Programmer Analyst, Philadelphia, PA

Responsibilities:

  • Involved in the conversion of one of the sister company’s computer application system to Confidential application system.
  • Deeply involved in creating database structure that includes tables, global temporary tables, Indexes and synonyms.
  • Involved in creating database roles and granting privileges.
  • Deeply involved in developing programs for data migration between the above systems using Oracle PL/SQL technology.
  • Data Migration was done based on complicated business rules and criteria defined by Confidential for the purpose of converting one application to another application system.

Environment: Oracle9i, PL/SQL.

Hire Now