PROFESSIONAL SUMMARY:

• Around 8+ years of IT experience in developing software applications using Oracle 12c/11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Telecommunication applications.
• Solid experience working on Oracle 12c/11g/10g/9i, PL/SQL, UNIX and Discoverer.
• Certified in AWS services like EC2, S3, VPC, DynamoDB etc.,
• Strong experience in Data Warehousing ETL experience of using Informatica 8.6.1/8.5/8.1 PowerCenter Client tools.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi - tier and client/server architectures.
• Good experience working in Agile Scrum Methodology, offline code review and Test-Driven Development ensuring high quality of work is delivered.
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams& database normalization principles.
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Supported advance PL/SQL using Cursors, REF Cursors, and Dynamic SQL.
• Developed complex PLSQL Triggers for data integrity and enforcing business rules.
• Experienced with SQL performance tuning and optimization using execution plans.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading in a corporate-wide-ETL Solution using Oracle.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind features with Collections instead of using cursors and FOR loops.
• Ability, willingness, and passion to learn new technologies and acclimatize to diverse work cultures.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/9i, MS ACCESS 2010

Languages: SQL, PL/SQL, Java 1.6/1.7, Python 2.7

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g, SQL*Loader, Oracle Forms and Reports 10g/9i, SourceTree

ETL Tools: Informatica Power Center 8.6/8.5/8.1(Designer, Workflow Manager, Workflow Monitor, Repository Manager and Informatica Server)

Data Modeling Tools: Erwin, MS Visio, SQL Developer Data Modeler 17.0

Internet Technology: HTML 5.0, JavaScript, XML, CSS 3, DHTML.

Scripting: Unix Shell Scripting

Task Management: JIRA

SCM: Clearcase, TortoiseSVN, GitHub, BitBucket

PROFESSIONAL EXPERIENCE:

Confidential, Farmington Hills, MI

Sr. Software Engineer

Environment: Oracle Database 12c/11g, SQL Developer, SQL Developer Data Modeler, AWS, UNIX, PL/SQL, PUTTY, FileZilla, Appworx, GitHub, SourceTree, BitBucket Server.

Responsibilities:

• Working on Mazda and Ford OEM projects in Agile Environment.
• Created and Implemented ER models and dimensional models (star schemas) and generated SQL scripts.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Scripting and automate weekly chains using Appworx application in the UNIX environment for Mazda and Ford for the automation tasks.
• Working on Service Reminders, LiveRamp and Recall projects.
• Update and modify PL/SQL procedures for Service requests, CIF (Customer Information) and DIF (Dealer Information) data based on Mazda business requirements.
• Maintenance and Enhancement Support. (Cloning, patching, Backup, Invalids, RM etc.).
• Plan and implement the DCC along with support to legacy databases.
• Modify Unix Shell scripts which will get executed while Automation Chain is invoking the shell script from the remote server location.
• Implementing PL/SQL procedure for automation where email processing records are processed and sent automatically based on the schedule.
• Create new scripts for Data Extracts, Apply Process and Suppression Process chains.
• Helped in upgrading from Oracle 11g to Oracle 12c.
• Used SourceTree for accessing GitHub projects from BitBucket Server for source code management which includes commit, push and pull changes from/to different branches.
• Involved in new project requirements and design implementation for both Mazda and USA accounts.
• Involved in migrating applications to the new release versions.
• Based on production data issues, analyze and locate the issue in the packages and procedures. Make modifications if required to proceed the weekly production process.
• Deploy data files to the vendors using SFTP as part of the weekly chain outputs and ensure the file data is right using data automation.

Confidential, Ann Arbor, MI

Sr. Database Developer

Environment: Informatica Power center 8.6.1, Workflow Manager, Workflow Monitor, Oracle Database 10g, SQL Developer, UNIX, ClearCase, WINSCP, SQL, PL/SQL, Python 2.7, PUTTY, MS Office, Windows 7

Responsibilities:

• Creating Stored Program Units in the form of Packages, Functions and procedures for implementing the complex database intensive business rules.
• Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Parsed high - level design specification to simple ETL coding and mapping standards.
• Used various transformation like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and union to develop mappings in the Informatica Designer.
• Understand business requirements and design logical and physical data models
• Developed many batch jobs in Unix/Perl Shell Scripts for batch processing and to load bulk data files into database and generate outbound files
• Tracking the entire request from the central tick tracking system.
• Maintain high availability of all the databases.
• Move the database to the centralized data center and co-ordinate with the Siebel application team for configuration during this we had used standard export import strategy for transfer.
• Designed and developed EAA subprograms to move the data from legacy systems.
• Used Cursors to implement the Bulk Load and improve performance
• Extensively worked on Table Partitions, Materialized Views for speeding up the response of SQL queries.
• Developed SQL Loader programs to load data from flat files.
• Extensively worked on SQL and PL/SQL performance tuning, improved performance of many application queries and batch processing jobs.
• Involved in Code Reviews and preparing Unit test cases.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Defining and reviewing the coding standards besides reviewing the code.
• Submitted Quarterly review data from 2013 to FERC (Federal Energy Regulation Commissions) using Python scripts.
• Developed shell scripts for batch processing and database transactions.

Confidential, Minneapolis, MN

Database Developer

Environment: Oracle Database 10g, TOAD, Informatica PowerCenter Designer 8.6/8.1, Informatica Repository Manager, Erwin, TOAD, PL/SQL.

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Using Informatica PowerCenter Designer analyzed the source data to Extract and Transform from various source systems (Oracle 10g and flat files) by incorporating the business rules by using different objects and functions that support tools.
• Using Informatica PowerCenter created mappings and mapplets to transform data according to business rules.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Created extensions to existing forms using Forms Builder as per client business requirement.
• Highly involved in high level database design, defining table structures, laying out ER-Diagrams, helped in building the physical data model using Erwin and identified key features for scalability of the application.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Separated Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS for tuning various SQL and PLSQL objects.
• Used Bulk Binds and Bulk Collect.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Extensively worked on version control software for migrating codes to different application instances.

Confidential, Kansas City, MO

Oracle PL/SQL Developer

Environment: Oracle 9i/10g, PL/SQL Developer, UNIX, PUTTY, Quality Center, CVS Version Control, Microsoft Visual Studio, Erwin Data Modeler r7, Informatica Power Center 7.1.2, Windows XP, AIX.

Responsibilities:

• Designed and Authored Technical Specifications from Functional Specification (Detail Design) documents.
• Used SQL*Loader to load data from various sources into an Oracle database. Created automated scripts for handling multiple files and emailing the status of individual data loads.
• Created various PLSQL blocks to validate data using functions and procedures and used dynamic SQL to identify client specific requirements and loading into Oracle core tables form staging.
• Wrote PLSQL programs required for retrieving data from the Data repository using Cursors, UTL File I/O.
• Wrote various PL/SQL Packages, Functions and Procedures to implement the Business Logic for the specified client application.
• Created various database triggers for implementing data security across multiple financial sensitive tables.
• Involved in developing materialized views, views, synonyms and dblinks to access data across schemas, indexes to gain performance.
• Proficiently developed test cases in Quality Center.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Applied Performance Tuning logic to optimize session performance.
• Examined, reviewed, and/or changed code to adapt to changes in requirements.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Confidential

PL/SQL Developer

Environment: Oracle 8i/10g, SQL, PL/SQL, Developer 2000 (Forms 6i, Reports 6i), HP UNIX, Secure Shell, TOAD, XML, TML 4, Windows XP, SQL*Loader, SQL*Plus

Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web-based Forms and Reports using Oracle Developer 6i.
• Defined Editors and created List of Values and Record Groups in Oracle Forms 9i.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers and Shell Scripts to load the staging table data into Analysis Data Mart System.
• Developed Stored Procedures to maintain details of the vendors and maintained them in Packages.
• Designed database tables using various Normalization techniques and database rules.
• Developed reports as per the requirements collected from the users using Oracle Reports 10g.
• Good Experience working on TOAD, PL/SQL Development for database access.
• Generate and maintain Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
• Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands.
• Involved in migrating applications to the new release versions.
• Performed Data validations and mappings at staging table level.
• Created Complex Dynamic / Static / Parameterized Reports and Charts using Report 6i.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF