relevant Experience:

• An Assertive professional with over 7 plus years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL
• Expertise in Database Design, Development, and Enhancement and Maintaining using Oracle 11g/10g/9i/8i, Web deployment, PL/SQL Forms 10g/9i, Oracle SQL Loader in Windows and UNIX environments. Strong knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality
• Developed and Automated batch load process using SQL Loader, Shell scripts and Crontab
• Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views.

Tools: /Methods:

• Databases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access.
• Other Technologies: HP Project and Portfolio Management PPM, HP ALM/QC, Oracle E - Business Suite 12, Oracle Recovery Manager RMAN, Oracle Enterprise Manager OEM, Oracle Applications Manager OAM
• Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C /C, Perl, XML, HTML, VB.NET
• ETL Tools: IBM Infosphere DataStage, Informatica
• Data Warehousing: Star Snow-Flake schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI
• Tuning Tools: TKPROF, STATSPACK, ASH, AWR, ADDM
• Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, Xcode, Subversion SVN, CVS, ClearCase.
• Tools: TOAD, SQL PLUS, SQL Developer, SQL Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

SKILLS INVENTORY:

• Strong skills in Oracle server side programming which includes SQL, SQL Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming.
• Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL plus, TOAD, and SQL developer full suite of Oracle Tools including development and customization of Oracle Developer Reports Forms and Oracle discoverer.
• Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiling and Oracle Code Coverage Utilities.
• Experienced in Knowledge Management, Data Integration, Data Migration, Data Cleansing and Larg-Data Analysis
• Data mapping, dimensional Modeling, writing ETL Stored Procedures and Informatica.
• Experienced in XML, PL/SQL, SQL plus, workflow performance tuning.
• Experience in deploying forms and reports on the web.
• Experience in Bulk Data loading using Advance PL/SQL packages.
• Strong knowledge and experience in Software Development Life Cycle SDLC, involving Requirements Analysis, Design, Development, Implementation, Use-Case-driven development and Testing of Software Applications.
• Excellent problem-solving skills and ability to multi-task.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Experience with version control SVN, CVS, change management and defect tracking systems.
• Recognized by clients for exceptional performance and sustained excellence in service delivery
• Used client tools TOAD, SQL Navigator, PLSQL developer, Clear Case and FTP tools
• Excellent communication, coordination, organizational and follow-through skills. Efficient in the execution of all assignments, eager to take on new challenges.

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Confidential

Sr. Oracle Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Analysis and documentation of functional requirements for new development and enhancements
• Actively coordinated with offshore teams through requirements gathering, design, development and testing phases.
• Interaction with client / business teams for clarifications / updates.
• Developing Sql Loader to insert bulk data into staging tables from flat files.
• Involved in Extraction, Transformation and Loading of data and store the data into staging tables for further various analyses.
• Involved in database development by creating PL/SQL functions, procedures and packages
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity
• Developed Triggers for inserting/updating of tables
• Used inner joins, outer join, union, union all and sub queries for filtering the Data
• Created views to analyze complex queries
• Used Refcursor, implicit / explicit cursor in PL/SQL modules extensively
• Designed the table sizing and partitioning parameters
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in generating Web base Reports for Clients
• Tuned SQL queries using Explain plan and TKPROF
• Developed back end processing code in UNIX Shell scripting.
• Extensively worked on Data modeling using Visio
• Creating and maintaining run books for Daily Jobs in the Control M framework.
• Upgrading the inbound/outbound interfaces developed for clients of SEI for Subsequent new releases according to the client requirements.

Environment: Oracle 10g / 11g, SQL, PL/SQL, SQL PLUS, SQL Loader, TOAD, UNIX, Shell scripting, HP PPM, Subversion SVN, Perl.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved 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.
• Designed Conceptual Model as an architectural migration target for new LRT ODS model and redesigned the key structures of the Data Warehouse tables, MVs, Indexes .
• Developed Data Analysis for Erwin Logical and Physical model design, Oracle PL SQL packages, triggers development, UAT for Oracle objects Tables, MVs, Views .
• Performed normalization of the OLTP database to eliminate redundant data.
• Was involved in the migration from oracle database 10g to 11g.
• Experience with Health Plan Information Systems specially in Health payer industry
• Experienced in claims processing using QNXT enterprise application system
• Developed PL/SQL Views and Materialized Views with fast and incremental Refresh Rates.
• Extensively used SQL Loader, external tables to load into oracle.
• 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.
• Used SQL loader and Oracle Import/Export utilities to load data from regional Data stewards to generate monthly LRT data refresh.
• Troubleshoot of Performance Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Involved in Unit testing and Integration testing of forms and reports.
• Analyzed created a reference database using PERL to be used by DBA and Product Developers to train their statistical models.
• Created batch jobs in regular maintenance, production support to load the data using UNIX shell scripting and shell scripting.
• Developed technical infrastructure designs, data mappings, flows and report dissemination mechanisms by architecting Data Warehouses and Marts.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Designed and developed various custom packages triggers and forms.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively
• Used C, HTML, CSS, XML, FTP, and Batch scripting programming, in various projects.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer, UNIX, TOAD, Informatica, HTML, CSS, Perl.

Confidential Oracle Developer

Responsibilities:

• Actively coordinated with offshore teams through requirements gathering, design, development and testing phases.
• Worked with product managers to give work estimates and advised on design.
• Troubleshoot, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Analyzed the existing data model and involved in logical design of the database.
• Used Erwin relational tool for logical and physical model for target ODS model.
• Developed and modified complex stored Procedures, Functions, Triggers and Packages.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.Performance tuned the ODI interfaces.
• Performance tuned the existing modules to reduce the execution time using Bulk Collect and Global Temporary Tables etc.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Create various Data Mapping Repository documents as part of Metadata services EMR .
• Created the flow charts and data mapping tables indicating the input files, output datasets and capacity planning for the data flow to the downstream applications.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Performed PL/SQL code reviews for maintaining standards and to identify inefficient SQL statements.
• Customized Reports and Forms to meet user requirements mainly in financial modules AP, GL, and AR .
• Implemented features including materialized views for better performance of summary tables, autonomous transactions, coding dynamic SQL statements.

Environment: Oracle 10g, PL/SQL, UNIX, TOAD, Reports 9i, Forms 9i, ERwin, IBM Web Sphere DataStage, MKS Integrity, MS SQL Server

Confidential

Oracle Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Installed and configured OEM Grid control and intensively used Diagnostic tuning packs along with AWR ADDM reports.
• Optimized the performance using PL/SQL table types and record types.
• Did SQL and PL/SQL programming for ODI and oracle.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, Join types and operations and providing hints.
• Wrote SQL queries to developed test data for use during test execution.
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
• Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
• DataStage jobs were scheduled, monitored, performance of individual stages was analyzed and multiple instances of a job were run using DataStage Director.
• Created complicated reports using reporting tool Cognos.
• Used DS Erwin MetaBroker to import Erwin 4.x Metadata into DataStage Repository.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Created Deployed SSIS SQL Server Integration Services Projects, Schemas and Configured Report Server to generate reports through SSRS SQL Server.
• Involved in Unit testing and Integration testing of forms and reports.
• Coding of documents in XML for data transformation.
• Developed test procedures to Unit test the application.
• Worked on Oracle OLAP tool to produce analytic measures, including time-series calculations, forecasts.
• Implemented table and index partitioning of various tables with huge data.
• Wrote a Perl-based server to generate reports of trades, and tickets in PostScript and HTML formats.
• Developed scripts in Korn shell and Perl for network management
• Provided Post production Technical Support to the users.

Environment: SQL Server 2005/2008, Oracle 10g, IBM Web Sphere Data stage and Quality Stage, Cognos 8 BI, Sybase TOAD, Crystal Reports, Erwin, Forms and Reports, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• 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.
• Assisted in day-to-day duties of DBA work like taking backup and recovery of database environment.
• Performed several Automations written in Perl-DBI/DBD and UNIX Shell scripting in an Agile environment.
• Used Perl to implement reports and new features in the Web GUI.
• Involved in writing complex/ad-hoc queries to generate reports as per client request as a part of production support.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL Loader.
• Involved in fine tuning and optimization of different SQL queries to insure faster response time.
• Assisted in designing End User Layouts EUL's for Oracle Discoverer Reports based on the user/client requirements.
• Involved in Unit Testing and Performance Testing for reports.
• Used SQL Trace, Analyze, Explain Plan Utilities, and Hints to develop better SQL Queries.
• Worked as Production Support Developer to solve real time issues.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 9i/10g, Perl, UNIX, shell script, SQL LOADER, TOAD, SQL Loader, Toad.

Confidential

Oracle Developer

Responsibilities:

• Involved in various stages of the project life cycle mainly requirements, analysis, design, coding, testing, and implementation of the application.
• Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Modified several SQL Loader scripts to handle new feeds from different sources and load data into the database from several sources.
• Data was loaded into temporary table from a flat file and then into interface tables.
• Used TOAD and SQL Developer tool for application development.
• Support and modify existing code.
• Extensively used error and exception handling techniques.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified.
• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Performed database Normalization and de-normalization tasks.
• Involved in managing application user setup, defining responsibilities.

Environment: Oracle 9i, SQL Loader, SQL Plus, TOAD.