SUMMARY

• 7+ years of IT experience in analysis, design, development, implementation and testing of Applications in data warehousing and client/server environments.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Programming Skills in designing and implementation of multi - tier applications using Java, J2EE, JDBC, JSP, HTML, Spring Boot, JavaScript, Servlets, JavaBeans, CSS, EJB, JAXB.
• Familiar with SQL*Loader to load data from external sources like flat files into Database tables.
• Experience in Oracle SQL and PL/SQL including all database objects:Stored procedures, stored functions, Packages, TYPE Objects, Triggers, cursors,REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing, systems integration testing and documented the same.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader.
• Possess good communication and interpersonal skills, able to adapt quickly to new technologies and environments.
• Experience in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Translated the T-SQL procedure, function and views into Oracle's PL/SQL Packages, Procedure, Function and Views.
• Extensive Knowledge and Experience in ETL tools like SQL Loader, SSIS, Informatica and DTS packages to transfer the data between different databases.
• Experience in Data Analysis and managing data warehouse and data marts.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques. Oracle data loading into Oracle database from flat files using SQL loader.
• Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 11g/10g/9i/8i systems. Created new databases and users: set up backups, export and other monitoring scripts.
• Excellent problem-solving skills with a strong technical background. Creative, adaptive and result-oriented professional with avidness to learn. Proficient at working as a team player with an aim of contributing towards the team's success.
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE.
• Expertise in Database Administration operations like Backup, Recovery, Replication, monitoring and tuning the SQL server database performance using tools like SQL Profiler, Index tuning wizard and database engine tuning advisor.
• Used GitHub and SVN as code repositories, Maven for application dependency and artifact management, Jenkins to implement CI/CD, Open Deploy to automate deployment management.

TECHNICAL SKILLS

Databases: Oracle 7.x/8i/9i/10g/11g/12c (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access.

ETL Tools: Informatica (Power Center 5.1/6.2/7.1/8.6.1/9.1.0 , Power Mart 5.1, Power Connect/Powerexchange for SAP R/3, MainFrame and Oracle Change Data Capture (CDC), SSIS, SQL*Loader.

Reporting Tools: Business Objects, Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos ReportNet 1.1MR2, Crystal Reports, Oracle Reports 2.5,SSRS.

Operating Systems: UNIX(Sun Solaris, LINUX, HP UNIX, AIX), Windows NT/2000 & Windows XP.

Data Modeling: Erwin 3.5.2, 4.0

Version control: SVN, GIT

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, C#.net, XML, C, C++ and Cobol.

PROFESSIONAL EXPERIENCE

Confidential, CA

PL/SQL & ETL Developer

Responsibilities:

• Actively involved in gathering business requirements from business users and turned it into functional and technical specification.
• Developed end to end process by retrieving data from OLTP systems, Flat files, and process to Data warehouse.
• Effective monitoring and reaction to problems, challenge, and opportunities.
• Involved in multi-tier Java and J2EE based applications support, responsible for writing business logic using core Java, SQL queries for the backend RDBMS.
• Developed PL/SQL Packages, Procedures and Functions in accordance with Business Requirements for loading data into database tables.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL.
• Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like toad and PL/SQL developer.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created Materialized Views and partitioning tables for performance reasons.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Involved in handling the changes in compiling scripts according to the database changes.
• Develops Extraction, Transformation and Loading (ETL) processes to acquire & load data from internal and external sources using SSIS, SSAS and SSRS for visualization.
• Developed strategies for ETL process, Report implementation, data acquisition, data quality and archive recovery.
• Created SSIS DB Catalog and Deployed SSIS packages to catalog using Project deployment model.
• Used GitHub and SVN as code repositories, Maven for application dependency and artifact management, Jenkins to implement CI/CD, Open Deploy to automate deployment management.

Confidential

Data Migration Developer

Responsibilities:

• Involved in all phases of the SDLC for Designing & giving recommended approaches to satisfy the goals, scope, and activities of the project.
• Develop DTS script to migrate data from SQL*Server database to Oracle database.
• Develop Procedure and Function using SQL*Server database to migrate data to Oracle database.
• Used Informatica power exchange to extract the data from Mainframe.
• Involved in Preparing Source-Target Mappings documents to provide the logic for Informatica mappings development.
• Extracted data from various sources such as Flat Files, Mainframe, DB2UBD, SAP and Oracle using Informatica Power Exchange.
• Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Created database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling of data.
• Coded complex SQL queries to retrieve data from the database depending on the need.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
• Prepared test data files using Linux Shell scripts, Perl script as per the business requirements.
• Written and edited shell scripts to automate the execution of the procedures and report the results through email.
• Used Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.
• Created indexes for faster retrieval and improved query performance.
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance.
• Support for the development, test and the production databases.
• Used SQL plus and TOAD to develop database applications.

Confidential

PL/SQL Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on a daily basis like renaming the file, extracting data from the file, unzipping the file and removing the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed 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.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• 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.