SUMMARY

• Around 8 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables, Cursor management, Exception handling etc.
• Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch in data loading process.
• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
• Strong understanding of end - to-end project management, SDLC methodologies of Waterfall and Agile.
• Performed tuning of an application using Explain Plan.
• Expert in Client-Server application development using Oracle 12i/11g, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Developed Test Scripts, Test Cases and SQL QA Scripts to perform Unit Testing, System and Load Testing.
• Solid understanding of relational databases.
• Experience with data migration using BULK COLLECT.
• Strong SQL Server DDL, DML skills with expertise in writing efficient queries and troubleshooting complex queries.
• Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.
• Knowledge in the design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.
• Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.
• Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.
• Knowledge in Designing & Formatting Dashboards using Tableau.
• Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

Web Technologies: HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, XSLT, Java, JavaScript, AJAX, jQuery, JSON, Apache, PHP, Responsive Design

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming, Java

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Development Tools: Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing (spring tool suite)

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Databases: Oracle 12c/11g/10g, PL/SQL (oracle), MySQL, MSSQL2008/2012

Operating Systems: Windows XP/Vista/7/8, MAC OS X, Linux

PROFESSIONAL EXPERIENCE

Sr. Oracle Developer

Confidential

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• 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.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Coordinated and delegated work to Offshore team.
• Reviewed the deliverables from offshore and communicated changes to developers.
• Actively participated in Clarification Meetings with the Clients.
• Design and develop PL/SQL packages.
• Prepared application logic; Developed PL/SQL Packages and procedure; and also provided Target Load Order Dependencies.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Used PLSQL Stored Procedures, Packages, Database Triggers, SQL and Oracle Utilities in this development process time.
• Expertise in tuning, designing and developing ETL informatica Mapping, sessions and workflow using Informatica 7.1, 8.1, 8.6, 8.6.1 and 9.6.1

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Oracle Pro*C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, PL/SQL, CVS, XML.

Sr. Oracle PL/SQL Developer

Confidential

Responsibilities:

• Worked on the bulk uploading of huge amounts of statistical data to the database.
• Wrote Loader scripts using SQL Loader/External tables to load large tables.
• Designed and developed the classes using core Java for thread safety in money transactions using Multithreading.
• Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.
• Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.
• Actively involved in troubleshooting database issues.
• Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.
• Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.
• Worked with Dynamic SQL, Global Temporary Tables.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Worked in Oracle reports and forms version 6i and 10g.
• Worked on Pro*C programs and PL/SQL Scripts to generate full extracts of large tables.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Developed Reports and forms using Oracle Designer.
• Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.
• Worked on developing/supporting Oracle APEX applications.
• Our group supports numerous Oracle APEX applications.
• Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.
• They will also be asked to perform risk assessments and add needed controls to close any control gaps.
• Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.

Environment: Oracle 11g, SQL, PL/SQL, ETL, SQL Developer, Toad, SQL*Loader, Shell Scripts

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• 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.
• 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.
• Involved in the continuous enhancements and fixing of production problems.
• Coordinated and delegated work to Offshore team.
• Reviewed the deliverables from offshore and communicated changes to developers.
• Actively participated in Clarification Meetings with the Clients.
• Design and develop PL/SQL packages.
• Prepared application logic; Developed PL/SQL Packages and procedure and provided Target Load Order Dependencies.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Used PLSQL Stored Procedures, Packages, Database Triggers, SQL and Oracle Utilities in this development process time.
• Developed Unix Shell Scripts for scheduling the jobs and created pre and post session commands.

Environment: Oracle 11g, UNIX, Informatica Power Center 9.1

Jr. Database Developer

Confidential

Responsibilities:

• Interacted with architects and business analysts to understand business requirements
• Involved with project development teams to convert the model into technical specifications and also provide knowledge transfer to quality assurance analysts.
• Made use of explain plan to find the access path taken when the query is executed.
• Used Analytical functions like RANK and DENSE RANK to assign to components having maximum portion.
• Performed normalization of the OLTP database to eliminate redundant data.
• Implemented data mappings, flows and report dissemination mechanisms by architecting Data Marts.
• Developed PL/SQL Procedures, Functions, Cursors, Packages, views and Materialized views.
• Created dynamic SQL queries using Execute Immediate statements.
• Worked with data dictionary views to query the required information.
• Worked on debugging the code and creating the exceptions to handle bad data and send them to error log files.
• Error handling using system defined exceptions and user defined exceptions.

Environment: Oracle 11g, SQL Server, PL/SQL, SQL Server 2005, Data Modeling, Data migration, SQL Navigator, Toad, Unix Shell Scripting, Version Control Software CVS.