SUMMARY

• 14+ years of IT experience with special emphasis on Development, Analysis and Design of OLTP, OLAP and Data ware housing projects.
• Experience in all the phases of SDLC, with emphasis on user interface design and n - tier distributed architecture design, development, testing, deployment and maintenance.
• Extensive programming experience using Oracle (PL/SQL).
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, System Testing.
• Familiarity in incorporation of various data sources like Oracle, MS SQL Server, DB2, Teradata, XML and Flat Files into the staging area.
• PERL, JAVA, PHP, C, C++, AWK, Java, JavaScript, Shell scripting, XML.
• Worked on UI and Back end development using Mod Perl and CGI.
• Had experience in designing, implementing and automation of testing for enterprise software like Ad management system.
• Has good Experience on AutoSys Job scheduling tool.
• Had Experience in Big data using Map Reduce, Hive, Sqoop, Crunch.
• Excellent experience in writing UNIX shell scripts.
• Competent knowledge of software design patterns and development methodologies.
• Used Configuration Management and Version Control (CVS), Win CVS and SVN for version control.
• Conversant with various quality models like CMM, ISO.
• Experienced in Test Driven and/or Agile Development (iterative) and in developing test suites accordingly.
• Flexible, self-motivated, self-believer and team player combined with can-do, will-learn attitude.Oracle Technology Expertise.
• Creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
• PLSQL Programming using packages, procedures, functions, Object Types, Collections, Cursors and Text API.
• Bulk Load techniques using Bulk Collect and FORALL.
• Oracle Import/Export Utilities and SQL*Loader, Data Pump and External tables
• Worked on autonomous transactions, Oracle Advanced Queuing and Oracle Parallel Queries.
• Generation of SQL*Plus Reports.
• Analyze and gather table statistics for query optimization, execution plans, sql trace files and creating performance benchmarks.
• Utilized new features of 10g/11g like conditional compilation, enhanced array processing with sparse collections, more robust debugging and error handling features.
• Knowledge and usage of SQL and PL/SQL best practices.

TECHNICAL SKILLS

Operating Systems: MS Windows 95/98/2000, LINUX, UNIX

Development Language: C, C++, Java

Web Technologies: Perl, PHP, Python, Java Script, HTML, XML, Ruby on Rails.

Database Systems Experience: Oracle, SQL Server, MySQL, PostgreSQL, Sybase, Teradata

Software configuration: CVS, SVN, Clear case

Modeling Tools: UML, MS VISIO

Other Skills: Shell Scripting, VC++, VB.NET, C#.net

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Senior Oracle Developer

Responsibilities:

• Worked with architects and business analysts to understand business requirement to reflect them into data model and involved with project development teams to convert the model into technical specifications and also provide knowledge to quality assurance analysts regarding the model.
• Performed normalization of the OLTP database to eliminate redundant data.
• Was involved in the migration from oracle database 10g to 11g.
• Developed PL/SQL Procedures, Functions, Cursors, Packages, Views, Materialized Views.
• Extensively used SQL Loader, external tables to load into oracle.
• Extensively worked on cursors, SQL joins (inner join, outer join, anti-join), views, packages, procedures, functions.
• Worked with Collections to reduce overhead involved with cursor looping. Bulk fetched the data from SQL engine into collection. Handled exceptions using SAVE EXCEPTIONS and %bulk exception.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Worked on application to write the file content to Message Queue (MQ) so that other Main frame applications can access the data.
• Used Oracle Advanced Queuing (AQ) for the selection of the loans to process in each batch.
• Worked on processing the XML files containing Credit reports for Deal Decision.
• Worked on various data quality and reconciliation process.
• Worked improving the performance of various oracle queries using the hints and indexes.
• Worked on the design and development of various tools to automate the build process.
• Worked on Scheduling jobs using Autosys.
• Involved in Production Support 24x7 for the CORE applications.

Environment: ORACLE PL/SQL, Data Stage, Perl, Java, Shell Scripting, PL/SQL, C++, AUTOSYS, Oracle 11g, Toad, Eclipse, Pac2000, AIX, UNIX, LINUX and APACHE

Confidential, Fort Mill SC

Senior ETL developer and Designer

Responsibilities:

• Designed Data Model for Model Execution Platform and Business rule viewer.
• Worked on Analyzing and loading the data dictionary for the business elements.
• Worked on huge account data load from 130 countries using Sqloader.
• Wrote the various scripts for automation of the deploy process.
• Worked on Scenario Manager data to be used by multiple systems.
• Worked with Map reduce and Hive for handling huge data volumes for Credit data.
• Worked on various epics and user stories for multiple sprint teams.

Environment: ORACLE PL/SQL, Erwin, Java, Shell Scripting, PL/SQL, AUTOSYS, Hadoop, Hive, Crunch, sqoop, Oracle 11g, Toad, Eclipse, LINUX, Agile Methodology.

Confidential, Minneapolis MN

Senior Oracle Developer

Responsibilities:

• Worked on design and rewrite of NPM (Network Performance Monitor) used to send notifications to various configured systems for internal and external generated events.
• Worked on ODE (On Demand Engine) which process the reads and meter control requests on Demand.
• Worked on various performance improvements for the UI API packages for search and display details.
• Worked on Real time DSE (Data Synchronization Engine). IEC-CIM messages are processed and loaded into core tables and displayed using Oracle API packages on UI.
• Worked on Various Adapters to load the data into core tables

Environment: ORACLE PL/SQL, Java, Shell Scripting, Perl, PL/SQL, Oracle 11g, Toad, Eclipse, UNIX, LINUX and Web sphere and Web logic.

Confidential

Senior Oracle Developer

Responsibilities:

• Worked on the query performance and query certification for all the major Application’s interacting with the CDR in MCIT.
• Worked with product managers to give work estimates and advised on design.
• Fixed, and implemented bug fixes and enhancements within tight deadlines.
• Analyzed the existing data model and involved in logical design of the database.
• Developed and modified complex stored Procedures, Functions, Triggers and Packages.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
• Worked as Production Support Developer to solve real time issues.
• Worked on various packages to move data between various environments.
• Performed PL/SQL code reviews for maintaining standards and to identify inefficient SQL statements.
• Worked on various extracts to send information to state and Federal agencies like MCIR (Michigan Care Improvement Registry)
• Worked on parsing the ADT, WBI and other HL7 messages.
• Used Bugzilla for the Bug and issue tracking.
• Involved in the production issues.
• Involved in both unit testing and integration testing.

Environment: Oracle 11g, Sql Server, Eclipse, JBOSS, Java, Informatica, Shell Scripting, AIX and Windows

Confidential, Minneapolis, MN

Senior Oracle Developer

Responsibilities:

• Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems.
• Involved in Report Tuning using the TKPROF Utility.
• Worked on the translation of various business parameters for RDH using Perl DBI for Oracle.
• Worked on the loan limits and market classification data processing.
• Worked on various data quality and reconciliation process.
• Created various Views for Data Stage jobs to process the data.
• Created Materialized views for quick processing of the reports.
• Worked improving the performance of various oracle queries using the hints and indexes.
• Worked on the design and development of various tools to automate the build process.
• Used SVN for configuration management.
• Involved in both unit testing and integration testing.
• Responsible for writing various SQL queries, PL/SQL code to retrieve the data from the Oracle Database.
• Worked on displaying various reports displaying loan information files using Perl and Html.
• Used JIRA for task and bug management.
• Worked on Scheduling jobs using Autosys.
• Involved in Production Support 24x7 for the CORE applications.

Environment: ORACLE PL/SQL, Data Stage, Java, Object Oriented PERL, Shell Scripting, PL/SQL, C++, AUTOSYS, Oracle 10g, Toad, Eclipse, Pac2000, AIX, UNIX, LINUX and APACHE

Confidential, Columbus OH

Oracle Developer

Responsibilities:

• Responsible for writing various SQL queries, PL/SQL code to retrieve the data from the Oracle Database.
• Used SQL* Loader and PL/SQL stored procedure for data conversion and interfaces processes.
• Designed and developed PL/SQL functions/ stored procedures/ cursors/ triggers/ packages.
• Involved in day-to-day duties of DBA work like taking backup and recovery of database environment.

Environment: ORACLE 10g, PERL, HTML, DHTML, XML, XSLT, CSS, JavaScript, Windows and linux

Confidential

Senior software Engineer

Responsibilities:

• Interact with customers to resolve any report related issues.
• Developed an apache Module for handling the video ads and checking the percentage of the video viewed by the user.
• Worked on reading and writing of the cookies from the apache Modules.
• Worked on Ad Rotator which is a high-level Ad management system which controls the Ads for the multiple Ad management providers.
• Worked on the Enhancements of various modules like Campaign Manager, Event Writer, and Impression Server.
• Used Pro*c to connect to oracle for fetching and inserting the data into database from various Modules.
• Worked on the enhancement of Impression server module for handling various parameters from the URL Request.
• Responsible for writing various SQL to retrieve the data from the Oracle database.

Environment: Oracle PL/SQL, PERL, C, AWK, PHP, Data Stage, LINUX and UNIX