Data Developer

Mukesh N

**********@*****.***

Ph: 515-***-****

7+ years of IT Experience as Oracle Developer for System Analysis, Designing, Testing, Development & Support of Oracle 8i, 9i, 10g & 11g Databases in Production, Staging, Development environments.

Summary:

Experience in financial, retail and telecom domains.

Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

Enforced data integrity using integrity constraint and database triggers.

Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS_PROFILER.

Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump.

Extensively used package like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP.

Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.

Extensively used Cubes & Rollups for making cross tabular reports.

Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.

Expertise in handling errors using Exceptions.

Making structural changes to the database objects.

Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP

Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).

Experience in working high-transacted OLTP systems.

Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.

Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.

Have worked in fast paced AGILE environment & attended daily scrum meeting.

Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Strong interpersonal and communication skills in dealing with customers.

Backend Oracle

11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server

Frontend Oracle Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, FORMS Builder 6i, REPORTS Builder 6i, XML,Oracle XE 10g/11g

Programming ORACLE

PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C,C++, JAVA, J2EE, Servlets, Java Script, Visual Basic, COBOL

RDBMS

Oracle 9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/2000/7.0/6.5

Third Party Tools

PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows, ERWin Operating System Windows 98/2000/XP/NT, UNIX (SunOS 5.7, Solaris 8, HP-UX), Redhat Linux 3.0/4.0

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Others

XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions

PROJECT EXPERIENCE:

John Deere, Moline, IL May 2014 – Till Date

Sr. PL/SQL Developer

Responsibilities:

Worked with the GUI interface team and provided them with necessary Stored Procedures and Packages.

Loaded data into different Oracle tables from flat files using SQL*Loader.

Modified existing shell scripts based upon the requirements.

Developed different PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

ARAG NORTH AMERICA, Des Moines, Iowa. Oct 2012 - Apr 2014

Lead Developer / Backup DBA

ARAG NORTH AMERICA is a legal insurance company, they are in the process of creating a Data Warehouse and Claims Data Mart involved loading all the claims related information in an Oracle Database.

Responsibilities:

Involved in SDLC gathering requirements from end users.

Developed views to facilitate easy interface implementation and enforce security on critical customer information.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.

Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.

Developed Database Triggers for audit and validation purpose.

Used pipelined functions for faster data accessibility.

Used PL/SQL to validate data and to populate billing tables.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Developed Installation scripts for all the deliverables.

Performed functional testing for the procedures and packages.

Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

Iowa Telecom, Newton IA April 2011 – Sep 2012

Lead Developer

Ticket maintenance system: This project involved designing and developing a web-based application for creating and maintaining service ticket information for technicians of Iowa Telecom.

Platform: Oracle 10g, Apache web Server, Crystal Reports, PL/SQL, APEX, Java Script, MS SQL Server, MS Access.

Responsibilities:

Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.

Created tables to capture errors and data that failed Validation Checks.

Re-validated corrected data from source and re-processed to get them loaded to the oracle target.

Re-worked on the BAD Files that were generated by SQL Loader.

Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.

Responsible to write scripts which identify the legacy data and the valid data.

Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.

Pro-actively participated in SQL tuning, Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.

Used SQL hints and Indexes as needed to improve SQL performance.

Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.

Wrote UNIX Shell scripts for performing development and DBA activities.

Tested the ETL process in testing environment and created test cases.

Wallenius Wilhelmsen Logistics, LA March 2010 – Feb 2011

Oracle PL/SQL Developer

Wallenius Wilhelmsen Logistics delivers innovative and sustainable global shipping and logistics solutions for manufacturers of cars, trucks, heavy equipment and specialized cargo.

Responsibilities:

Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.

Involved in Business Requirements, System analysis and Design of the Data warehouse application.

Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

Designed Physical and Logical Data model and Data flow diagrams.

Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning.

Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.

Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.

Filtered and Loaded data from different formats of data sources into Database Tables.

Extracted required data from the database tables and exported the data to different sources in different formats.

Worked with several tools to access and perform several operations on database.

Experience in Generating Reports.

Developed Data entry, query and reports request screens and tuned the SQL queries.

Used joins, indexes effectively in where clauses for Query optimization.

Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

State Street Bank, Boston Aug 2008- Feb 2010

Oracle PL/SQL Developer

State Street Global Advisors (SSgA) is an acknowledged leader in institutional investing with $1.4 trillion in assets under management. The world's largest institutional asset manager and leader in several other investment rankings, SSgA is also the investment management arm of State Street Corporation, the world's largest custodian. Leveraging these combined strengths permits us to focus single-mindedly on delivering competitive investment strategies and integrated solutions to our clients worldwide, across virtually every asset class, capitalization range, region, and style.

Responsibilities:

Development and maintenance of the Inventory Control and Client contract modules.

Interacted with the business users on a regular basis to collect business requirements and specifications.

Involved in Designing of Data Modeling, Design Specifications and to analyze Dependencies.

Tested new enhancements and bug fixes before deployment into the production environment.

Worked as part of a team to launch new application releases under strict time deadlines

Coded database Triggers, Package, Functions, and Procedures using PL/SQL; and maintained the scripts for various data feeds.

Optimized and tuned PL/SQL to reduce the loading process.

Created shell scripts to automate the acquisition and archiving of files.

Wrote KORN Shell Scripts to prepare files to be merged into the database

Developed UNIX scripts to create FTP Jobs.

Utilized SQL*Loader to perform bulk data loads into database tables from external data files.

Responsible for designing and maintaining fully integrated and multiple levels help system for the modules.

Involved in preparing functional specifications, release notes, training materials and other documentation.

Performance tuning of SQL queries for data warehouse consisting of many tables with large amount of data.

Optimized and tuned PL/SQL to reduce the loading process. Used SQL trace facility and Tkprof along with Explain Plan to accurately assess the efficiency of the SQL statements when the application runs.

Designed star schemas using dimensional modeling and created fact tables and dimensional tables.

Involved in writing complex scripts for Data Transformation and ETL process.

Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.

Contact this candidate