SUMMARY:

• IT professional with 11 plus years of experience from various industries like Finance, Tele Communications and Banking as an Application Developer with proficiency in Oracle PL SQL RDBMS programming Techniques and Data warehousing. Also have excellent analytical skills and problem solving capabilities. Open to take up challenging assignments and learn new technologies that project demands.
• Expertise in Client - Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Excellent technical and analytical skills with clear understanding of the design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Strong experience in applying Data warehouse concepts and experience with ETL tools.
• Good knowledge on logical and physical Data Modeling using normalization Techniques.
• Strong experience working on large scale database particularly on Oracle Exadata 12c.
• Experience in developing Complex database objects using Stored Procedures, Functions,Packages and Triggers in Oracle.
• Experience with creating Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based), Partitions, Materialized views.
• Worked extensively on Ref Cursor, External Tables, Collections, Dynamic SQL, Exception Handling, Records and PL/SQL Tables.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO),HINTS and other tuning techniques.
• Experience in Table partitioning using various partition strategies.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Experience doing the DBA tasks of expdp/impdp, generate AWR and ASH reports and perform daily DBA routines like maintaining table space and table partitioning.
• Created database programs to automatically drop table indexes and create indexes for the tables.
• Experience in Data warehousing techniques, loading Data into Oracle Tables using SQL Loader and ETL.
• Experience in UNIX Shell Scripting. Extensively created UNIX shell for file manipulations, validations and also invoking SQL scripts and scheduled them using crontab.
• Used Github for version control and JIRA boards for creating stories and creating sprints.

TECHNICAL SKILLS:

Languages:: Oracle PL/SQL, SQL, PRO*C, C, Unix-Shell Scripting, PERL, Java Script, HTML, DHTML.

Tools: TOAD 9.5/7.1, SQL*Loader, SQL Developer, Informatica 8.5, Erwin v7.x, Oracle Exadata 12c, Forms 9i, 6i, 6.0, 5.0, 4.5, Reports 9i, 6.i, 6.0, Designer 6i,Oracle 12c, 11g,10g,9i, 8i, 8, 7, VSS, Clear case, Tortoise SVN

Platform:: Unix, Windows and Linux

PROFESSIONAL EXPERIENCE:

Confidential,Weehawken,NJ

Sr.Oracle Developer/Architect

Responsibilities:

• Interact with customer to identify gaps/bottleneck in the business transactions and build interface to integrate/simplify business processes.
• As a Senior Consultant/Co-Data Architect, developed technical strategies to leverage the existing system for the growing business needs.
• Provide technical leadership in system analysis/design and development using Agile Scrum and Jira.
• Worked primarily on database design and development of major functionalities and organized meetings for requirement gathering and project status.
• Extensively used the advanced features of PL/SQL like Collections, Records, Tables, Object types, Ref Cursors, Bulk collect, Forall and Dynamic SQL. Involved in performance fine-tuning of the queries, reports and jobs.
• Worked on creating stored procedures, functions, cursors, triggers and packages.
• Worked on materialized views (fast and complete refresh) and table partitioning for the better performance on large database systems (TB Terabytes).
• Created B-tree, Bitmap and function-based indexes and also used oracle supplied hints.
• Dealt with deadlocks, solved concurrency issues using For Update with various options.
• Used Explain Plan and TKPROF, ASH and AWR Reports.
• Used single-row functions, aggregate functions, analytical functions, correlated sub-queries and nested sub-queries.
• Used features like Listagg, collect, virtual columns, pivot and unpivot data.
• Identified the queries performing the full table scan and considered them for the tuning purposes
• Used Oracle Enterprise manager heavily to look Confidential the session level statistics, blocking sessions, find the TOP activity sessions, SQL monitoring.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader, External Tables and PL/SQL procedures.
• Used Oracle 12c new features like invisible column, multiple indexes on same column and extensively used the json datatype in oracle.
• Unix Shell Scripting, Perl scripting, Production Support & User Acceptance Testing Support.
• Trouble shooting within & across projects.
• Environment: Oracle Exadata 12c, Oracle 11g/10g, UNIX, SVN, Jenkins, JIRA, Agile Scrum

Confidential - Warren,NJ

Sr. Software Developer

Responsibilities:

• Project: MCA system is a Master Control and Administration Risk tool built to send out financial data regarding Deposit, Loans and other important metrics to FED. Integral part of the project is to warehouse the data coming from upstream using ETL and generate reports using it.
• Modeled and Created a Data Warehouse to load up data from various upstream systems.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Interact with Users to identify gaps in the current business process and build interface to simplify business processes.
• Worked in an Agile Environment, organized meetings for requirement gathering from users and project status.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Developed data warehouse ETL routines with Oracle, PL/SQL to integrate data from OLTP source systems into ODS and OLAP schemas to facilitate BI.
• Used data modeling concepts for the Entity Relationship Diagram and also created Data Warehouse star and snowflake models.
• Loaded data using the ETL process by inserting data into raw tables using external tables transform data and then load data into FCT tables.
• Performed compression and collected stats for the billions of rows inserted.
• Created complex adhoc reports to serve time critical user requests.
• Used single-row functions, aggregate functions, analytical functions, correlated sub-queries and nested sub-queries.
• Involved in table partitioning and used DBMS STATS package for stats collection.
• Created B-tree, Bitmap and function-based indexes appropriately.
• Used Oracle-defined exceptions, Non-predefined oracle exceptions and created user-defined exceptions for error-trapping.
• Used Autonomous transactions and dealt with mutating table issues.
• Used AWR reports to identify wait events and resource intensive SQL statements.
• Created Pl/SQL packages integrating the related procedures and functions together for better performance.
• Loaded flat files into oracle database using conventional and direct load methods of the SQL*LOADER.
• Used external table for the loading data from flat files to staging tables.
• Direct path Loaded data into the partitioned fact tables and supported SCD Type 2 Dimensions.
• Created schema-related, database related, row and statement level triggers.
• Analyzed the table, obtained statistics, checked explain plan of the query and used oracle-supplied hints for better performance of the query.
• Used nested table and Bulk collect for faster performance.
• Used oracle data pump to export and import the tables, schemas, and databases.
• Worked with Java team to establish the DB connectivity to Java using JDBC and also used ref cursors to return set of data for the application.
• Worked closely with the DBA for the performance tuning and incorporated table-partitioning concepts to improve the performance.
• Used AWR reports to do the historical analysis of performance.
• Environment: Oracle 12c, 11g/10g/9i, Perl, TOAD 9.5/7.1, SQL +, Text Pad, SQL*Loader, UNIX shell Scripting, oracle data pump, Jenkins, JIRA, Agile Scrum

Confidential, New York

Sr. Oracle Developer

Responsibilities:

• Project: Worked on core investment banking projects namely OPERA and DAL. These applications process the inbound data and calculate Profit and Loss for the Journals by considering the user adjustments. The data is then used by many downstream systems like SYMPONY, PCW Data warehouse applications of the bank
• Requirement Analysis for new business requirements & major developments.
• Impact analysis of proposed changes in existing components.
• Team Management and Client interaction through meetings & presentations.
• Preparing Analysis Document, Design Document, Low Level Design & Unit Test Plan.
• Preparation of System Test Plan, Functional Specifications, User Manual, Data Model using the normalization process.
• Worked on creating stored procedures, functions, cursors, triggers and packages.
• Worked on materialized views (fast and complete refresh) and table partitioning for the better performance on large database systems (TB Terabytes).
• Created Flashback queries and set the undo retention parameters in the parameter file
• Used SQL * Loader, external tables to load large flat files in the database.
• Used Data pump utility for export and import of tables, schemas and database.
• Used built-in packages like DBMS OUTPUT, DBMS UTILITY and DBMS JOB.
• Used Execute Immediate for dynamic SQL instead of DBMS SQL.
• Worked on Nested Tables and bulk collect options to avoid context switching for the better performance.
• Compute the statistics Confidential regular intervals with DBMS STATS and used Dynamic sampling.
• Created SQL trace of the SQL statements and run against the TKPROF to find the CPU usage and information of repeated parsing as a part of performance tuning.
• Worked on UTL FILE package for interaction with the operating system files.
• Looked into Explain plans of the queries to identify the optimizer path for Full table Scan, index scan and other information of the complex joins.
• Worked with DBA to Increase the SHARED POOL SIZE as a task of performance tuning.
• Spool the data in the Production Environment before doing any DML.
• Worked on Talend to source the data from Teradata to oracle Database.
• Created source and target definitions, mappings, used various transformations, sessions and workflows, and monitored the workflows for the data warehouse.
• Used router, joiner and aggregator transformations extensively.
• Production support and version releases using VSS configuration management. Was available 24*7 to resolve production issue and debugged the existing codes.
• Environment: Oracle 11g/10g/9i, Forms 9i, Report 9i, TOAD 9.5, SQL +, Text Pad, SQL*Loader, UNIX shell Scripting, PERL, PRO*C and Windows NT

Confidential,Middletown NJ

Sr. Oracle Developer

Responsibilities:

• Projects: Worked on core telecom projects mainly dealing with application hosting and voice call high volume reporting data which consisted of loading, aggregating, displaying and generating reports for the customers. Worked on below applications: a) Voice Tone Reporting Platform: b) Service Express Platform:
• Requirement analysis for new business requirements & major developments.
• Impact analysis of proposed changes in existing components.
• Team Management and Client interaction through meetings & presentations.
• Worked on creating stored procedures, functions, cursors, triggers and packages.
• Worked on performance tuning using the execution plan and explain plan.
• Worked on materialized views (fast and complete refresh) and table partitioning for the better performance on large data systems.
• Created Flashback queries and set the undo retention parameters in the parameter file
• Used SQL * Loader, external tables to load large flat files in the database.
• Used data pump utility for export and import of tables, schemas and database.
• Used built-in packages like DBMS OUTPUT, DBMS UTILITY and DBMS JOB.
• Used Execute Immediate for dynamic SQL instead of DBMS SQL.
• Worked on Nested Tables and bulk collect options to avoid context switching for the better performance.
• Worked on Oracle supplied hints like index, parallel append to debug the performance of the query.
• Compute the statistics Confidential regular intervals with DBMS STATS and used Dynamic sampling.
• Used DBMS TRACE and DBMS PROFILER to identify performance bottlenecks.
• Regression testing by preparing test cases to map the actual result with the expected result along with the data validation.
• Unix Shell Scripting for file manipulations .Used commands like AWK and SED.
• Training, Business Induction of new members & preparation of Induction Manual.
• Troubleshooting within & across projects.
• Worked with ftp of files to get and put from one server to other.
• Production support and version releases using VSS configuration management. Was available 24*7 to resolve production issue and debugged the existing codes.
• Used Visio for the Flow diagrams.
• Used CVS for check in and check out of the database scripts.
• Environment: Oracle 10g/9i, TOAD 9.5, SQL +, Text Pad, SQL*Loader, UNIX shell Scripting, PERL, PRO*C,C and Windows NT, Perl

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Project: National Commodity and Derivative Exchange, NCSS System:
• Worked on creation and modification of all database objects. These include tables, indexes, procedures, packages, triggers, functions, etc.
• Used Data modeling concepts for the Entity Relationship Diagram and followed the normalization to design the database.
• Analyzed the statistics, explain plan of the query and used oracle-supplied hints for better performance of the query.
• Work closely with the DBA to resolve production issues and move objects from development to production.
• Worked on autonomous transactions and solved issues regarding mutating tables.
• Used Nested table and Bulk collect to improve the performance.
• Identified the queries performing the full table scan and considered them for the tuning purposes.
• Used Analytical functions in place of Aggregate functions for extensive functionality.
• Used Sql loader to load large amount of data with options like insert, append and replace.
• Worked on correlated sub queries and also used hierarchical tree structured query.
• Used Oracle-defined exceptions, Non-predefined oracle exceptions and created user-defined exceptions for error-trapping.
• Created Pl/SQL packages integrating the related procedures and functions together for better performance.
• Used import and export to load data from one database to other.
• Extensively worked on Triggers, Sequences, DBlink and Oracle jobs.
• Development, application testing and debugging and Maintenance of systems.
• Interacted with the User for the Business requirements and designed the layout for the reports.
• Used Data modeling concepts for the Entity Relationship Diagram (ERD) and followed the normalization concepts to design the database.