SUMMARY:

• Over 6+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in using Oracle 12c/11g/10g/9i databases.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Extensively worked on Oracle backend Programming using PL/SQL - Stored Procedures, Functions, Packages, Tables, Ref cursors, Database triggers.
• Strong experience in using tools like TOAD, SQL Navigator and SQL Developer.
• Experience with various DDL functions like Creation of Indexes, Materialized Views, and Partitioning tables.
• Good Understanding of Data Warehousing Concepts likes Star schemas and Snowflake Schemas.
• Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them.
• Experienced in Tuning SQLStatements and Proceduresfor enhancing the load performance in various schemas across databases.
• Good understanding and knowledge on Bigdata technologies and Hadoop Ecosystem.
• Involved in extracting user's data from various data sources into Hadoop Distributed File Systems .
• Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Good experience in working alongside JAVA and Dot net projects.
• Experience in different phases of application implementation life cycle including Technical Design, Data Conversion, Oracle Forms development, and Oracle report development, Unit Testing, Integration Testing, End User Training, and Production Support.
• Automated all the jobs, for pulling data from FTP server to load data into Hive tables , using Oozie workflows.
• Ability to write UNIX shell scripts and SQL*Loader scripting to work with various file types. Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems (ODS, ADS and Data Marts).
• Good knowledge and experience Erwin Model Mart.
• Experience with both Waterfall and Agile Methodologies.
• Knowledge in Informatica transformations like Source Qualifier, Sorter, Aggregator, Sequence, update strategy, Lookup, Joiner etc.
• Involved in offshore team coordination. Working with them to provide necessary requirement documentation, validating the development work and bug tracking.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/ 9i, Vertica, MYSQL.

DB Dev. Tools: TOAD, SQL Developer, DB Visualizer, Toad Data Point, SQL*Plus, Informatica.

Tools/Utilities: CVS, SQL*Loader, Rally, JIRA, TDP, Win SQL, SQL Navigator.

Operating Systems: UNIX, LINUX, Windows XP/2000/98, Mac.

Languages/Web: SQL, PL/SQL, UNIX Shell Scripting, Core Java, Java Script, Perl, ASP.Net, XML and HTML.

Reporting / Scheduling Tools: Oracle Forms and Reports 10g/9i/6i, Crystal Reports, MS Access Reports, Control-M, Autosys.

Data Warehousing/ Data Modeling: OLAP, OLTP, ETL Informatica, Erwin, Data marts, Star Schema, Snowflake Schema, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Oracle Developer

Responsibilities:

• Worked on different databases like Oracle, Vertica and processed the HR data from HR database.
• Worked with Business analysts and DBAs to gather the requirements and move objects from one environment to other.
• Parameterized SQL scripts based on the business logic to move them into core tables.
• Performed table and schema backups.
• Created views, tables based on the business logic.
• Created JSON files to populate data into tables from corresponding views and closely worked with Java developers.
• Involved in creating packages, procedures and functions based on the requirement.
• Extensively worked on performance tuning to improve the performance of queries.
• Worked withSQL*loader to load different formats of data like CSV files, text files and spreadsheets into database.
• Widely used PL/SQL tables and BulkCollect for processing the load on tables and retrieving into oracle.
• Created JSON files for implementing and populating the data in to HUB tables.
• Worked on advanced concepts of PL/SQL such as Records, Collections and Dynamic SQL .
• Performed SQL and PLSQL tuning and Application tuning using several tools like EXPLAINPLAN , SQL *Trace and TKPROF .
• Created Autosys scripts in UNIX shell to run the jobs for the application.
• Created triggers, indexes on tables to audit the tables and to improve the performance respectively.

Environment:: Oracle Database 11g, Vertica Database, TOAD Data Point, DbVisualizer, SQL, PL/SQL, SQL*LOADER, Rally, Tortoise SVN, Agile methodology.

Confidential, Eden Prairie, MN

Oracle Developer

Responsibilities:

• Worked closely with the Business analysts for requirements gathering.
• Involved in creating database objects like tables, views, procedures, packages using Oracle tools like Toad, SQL*Plus.
• Worked with Java Developers to understand their requirements and provide solutions in PL/SQL.
• Worked on DDL, DML, Synonyms, Grants and Indexes scripts.
• Involved in writing stored procedures, Functions and packages as per the business logic.
• Performance tuning of existing SQL and PL SQL codes to improve the response time.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized scripts to monitor the database processes and performance.
• Partitioning tables by determining the suitable methodology to improve performance andmanageability.
• Used bulkcollect to extract and load large amounts of data.
• Experience in working with utilities like External Tables, Import and Export to extract and load large volume of data.
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data.
• Error checking & testing of the ETL procedures & programs using Informatica session log.
• Extensively used Oracle ETL process for address data cleansing.
• Used SQL*Loaders to load the data into database from the text files and spread sheets.
• Involved in supporting/fixing production defects and day to day business transaction issues.
• Conducted performance tuning of applications through tuning pack and SQL*Navigator, SQL*TRACE, TKPROF utilities.
• Management of schemas, objects partitioning the tables & indexes.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Developing Scripts and Auto sys Jobs to schedule a bundle (group of coordinators), which consists of various Hadoop Programs using Oozie. Work with the Database Specialist and Technical Architect on the design work of the application.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.

Environment:: Oracle Database 11g, TOAD, SQL Developer, SQL, PLSQL, SQL*Plus, SQL*LOADER, Rally, Agile methodology, HPFortify.

Confidential, Collegeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Preparing Functional and Technical Design documents.
• Created stored procedures for heavy pharmaceutical transaction by using procedural parameters & working with packages, blocks & exception handling.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Worked on IMS DDD (Drug Distribution Data) sales data and maintained data security by creating materialized views and views on the base tables.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Created Materialized views, Views and synonyms on base tables for data abstraction.
• Created DB links between test and production environments to move Meta data from prod to test based on certain conditions.
• Knowledge in Pharma AML compliance and regulatory practices.
• Participated in major deployments in production and fixed issues that occur during deployment by fixing the code based on the environment.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Staging.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Extensively used Oracle ETL process for address data cleansing.
• Good understanding in creating data marts for the business requirements
• Used SQL*Loaders to load the data into database from the text files and spread sheets.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Solving the complicated run time errors while running the process along with DBA team members.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.

Environment:: Oracle Database 11g/12c, TOAD, SQL Developer, SQL, PLSQL, UNIX, UNIX Shell Scripting, SQL*Plus, Autosys, SQL*LOADER, Informatica, DB2, Teradata, Agile methodology.

Confidential, Jefferson City, MO

Oracle Developer

Responsibilities:

• Fixed defects for existing code in production environment.
• Fixed code defects by replicating same errors from production in test and development environments.
• Employed Data Loader to read, extract, and load data from CSV files.
• Created scripts for future change in Missouri charge code and changed the existing code to accept new codes with change in format.
• Created functions, procedures, triggers and tables for packages for multiple applications.
• Worked extensively with cursors and jobs using DBMS JOB package for running batch jobs midnight every day.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the logical data model using Erwin .
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy SQL Server database system.
• Used SQL loader to load data from flat files to development database.
• Used UTL MAIL packages to automate the report delivery through Emails.
• Resolved tickets that are assigned in JIRA for severity 1 issues.
• Created table level backups using data pumps after running each extract while performing unit testing.
• Complete bulk imports of data using Data Loader.
• Coordination between development, testing and production teams and attending weekly standups.
• Created table level backups using data pumps after running each extract while performing unit testing.

Environment: Oracle Database 11g, UNIX, Forms Builder 10g/6i, Reports Builder 10g/6i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Force.com Platform (Sandbox & Production), UNIX Shell Scripting,Visual Studio, Toad, JIRA, data pump, Waterfall Methodology.