SUMMARY

• 7.6 years of IT Experience in Design, Development and Administration of database applications using Oracle 12c/11g/10g/9i, SQL, PL/SQL, MSSQL, and MySQL.
• Good understanding of Data flow diagrams, Oracle database architecture, Data dictionary, RDBMS and Normalization techniques.
• Designed database schemas using ER diagrams in MS Visio/Erwin/Toad/Oracle developer/MySQL Workbench.
• Expertise in Objects creation such as Tables, Views, User Data Types, Indexes, Stored Procedures, Cursors, Triggers, Functions, Packages and more..
• Expertise Debugging Stored Procedures, Triggers, Cursors and SQL coding
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types and Analytical Functions.
• Experienced in Bulk Collections, PL/SQL Collections and Exception handling
• Created PL/SQL, SQL*Loader and UNIX/Perl scripts as a part of data load process to load external data into Oracle database tables.
• Experience in Query optimization, Performance Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Extensive experience working with DBLinks and creating materialized views, bitmap indexes, Index Organized table, external tables etc.
• Experience in migration of data from excel, flat file, and others using BCP, TalenD, Toad, Oracle Data Integrator and SSIS
• Experience in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures
• Experience in creating database users, roles, users. Database monitoring, job Scheduling, backups and Recovery using UNIX/LINUX Shell scripts
• Experience in Java/J2EE, Hibernate, Spring arch, Html, JSP, .NET
• Experienced in writing UNIX Shell Scripts and monitor Cron jobs for day - to-day operations
• Knowledge on AWS services like EC2, S3 Buckets, RDS, IAM, Cloud Migration
• Extensive experience in developing applications using Java and related technologies using WATERFALL and AGILE (SCRUM) methodologies.
• Extensive experience with all phases of the Software Development Life Cycle
• Including analysis, Resource Planning, code development, testing, implementing and maintenance.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12C, SQL Server 2012/2016, MySQL 5.X.

Programming languages: SQL, PLSQL, T-SQL, MySQL, C, C++, Java/J2EE, UNIX/LINUX Shell Scripting, HTML, Java Script, XML

ETL: SSIS, TalenD, SQL *PLUS, SQL*Loader, ODI.

Reports : Crystal, SSRS.

Others: AWS EC2,IAM, Cloud Migration, S3 Buckets, AWS Databases

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

PLSQL Developer

Responsibilities:

• Responsibilities included taking the ownership of the project and function as the lead, worked closely with the business group to understand their requirement, and make recommendations as required.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created, debugged, and modified stored procedures, triggers, tables, views, user-defined functions.
• Experience in developing SSIS packages to transfer data from OLTP to OLAP Databases with different types of control flow tasks, data flow transformations and deploying the packages to Production server.
• Created SSIS Packages to extract data from Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Implemented Triggers, Views, Synonyms, Hints, Partitioning of Tables, Clustered and Non-clustered indexing. Extensive work on the performance tuning of Oracle ETL process.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the data.
• Created relevant staging tables to load data, identified the business validation rules. Created SQL Loader scripts using Unix shell scripting and PL/SQL
• Improved performance of PL SQL program units by using Bulk collect and Bulk bind (ForAll) and other advanced tuning performance techniques.
• Performed Oracle DBA activities - Database creation, importing of data, Performing Backup on regular basis
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Developed Unix Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

Environment: Oracle 11G/10G, SQL, PL/SQL, Toad, TFS, SQL Loader, MSSQL,SSIS,SSRS,SSAS, Data Modeling & Unix Shell scripting Windows XP.

Confidential, Cleveland, OH

Responsibilities:

• Involved in designing and developing and implementing relational database management systems as backend of Confidential ' CPR application in an Oracle, Unix/Linux/Solaris environment within a multi-tier environment utilizing Oracle 11g database.
• Involved to determine business/technical requirements, analyzing business process and workflows and suggest improvements.
• Involved to set up automated processes for data loading, Tracking, monitoring and error reporting and messaging in middleware environment utilizing Unix Shell scripting; scheduling daily/weekly/monthly processes utilizing CRON script.
• Involved in logical and physical design and partitioning the database tables; writing SQL queries, advanced PLSQL artifacts; coding of stored procedures, triggers, packages, functions and complex queries at an advanced level; SQL loading using SQL Loader, external tables.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Involved in performance tuning of databases and applications by optimizing database code utilizing
• SQL Optimizer, mapping objects to the relational database; design and develop applications to generate customized reports utilizing Crystal /Mobius reports; analyze, code and test application
• Understanding legacy systems data and building designing target DB schema.
• Used SQL loader to load data from flat files (CSV) to development database.
• Worked on writing queries for data analysis, data validation and generating reports, developed data modification scripts to implement business requirements.
• Worked on PL/SQL collections, Bulk collections and Exception handling.
• Extensively worked on PL/SQL features like Triggers, Data blocks, Report Layout, Report Triggers.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Along with Code development worked on impact analysis of fix, unit test case preparation and unit testing.

Environment: Oracle 11g, HTML, TOAD, Sql developer, Shell scripting, Crystal reports, SQL Loader, FileZilla, JIRA, GITLab, Agile environment

Confidential, Mountain View, CA

Oracle Developer

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Interacted extensively with business users, Business Systems Analyst for requirements gathering and analysis
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes, materialized views and Collections to implement business logic. Generated server side PL/SQL scripts for data manipulation and validation.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked on Database Application Development, Query Optimization, Performance Tuning and DBA solutions
• Performance tuning of PL/SQL code of a stored procedure which migrates data from source table with multi-million records to destination table.
• Improved the performance of the slow SQL queries by implementing indexes, using FORALL, BULK COLLECT, HINTS, and developed various procedures, functions and packages to implement the new business.
• Performed SQL and PLSQL tuning and Application tuning using various concepts like EXPLAINPLAN, SQL*Trace and TKPROF.
• Worked on Oracle upgradation from oracle 10g to Oracle 12c
• Designed and developed ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Developed UNIX shell scripts with embedded SQL*Loader, expdp/impdp calls and PL SQL statements to extract data in the form of flat files for data loading, Data Conversions and migration.

Environment: Oracle Database 10g/12c, UNIX, TOAD,SQL Developer, PLSQL Developer, Java, XML, JavaScript, Crystal reports, Erwin, ODI..

Confidential

Software Engineer

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.
• Designed Physical, Logical Data model, and Data flow diagrams.
• Created database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Experience in writing Materialized views and Data transfer processing - extracting data from mainframe and ETL to SQL servers and Oracle servers.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Created SSIS / DTS packages to pull data from Oracle, Access and Flat Files.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Experience with Oracle 11g new features such as parallel query and table sub-partitioning
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database. Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Worked with several tools to access and perform several operations on database.
• Developed Data entry, query and reports request screens and tuned the SQL queries.

Environment: Oracle 10G, SQL, PL/SQL, UNIX, XML, ETL, SQL*Loader, Sql Server SSIS, SSRS,SVN

Confidential

SQL Analyst

Responsibilities:

• Creation of Database Objects: Tables, Stored Procedure, Views, Triggers, Index, and Function.
• Expertise in SQL Queries writing and taken part in Database design for different modules.
• Configured, tuned, Upgraded and maintained database servers.
• Experience with PLSQL and MySQL on Linux, Ubuntu and Windows.
• Experience in migrating databases from Windows to Linux, Sun Solaris to IBM.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables
• Database monitoring, job Scheduling, backups and Recovery
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Ensured 24x7 database availability, reliability and security while in a production environment.

Environment: Oracle 10G, SQL, PL/SQL, Java, Erwin, Linux, MySQL, Toad, MySQL,JAVA,HTML,JavaScript, Apache tomcat server.