SUMMARY

• Around 9 Plus years of experience as Oracle Developer with Extensive knowledge and work Experience in SDLC including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Strong experience in systems Analysis, design and development of complex software systems inBanking and Telecom Domain.
• Strong Experience in front - end and back-end development usingForms11g/10g, SQL, PL/SQL,Oracle 11g/10gandOracle Designer10gfor Data modelling.
• 1years of experience as and Big Data like (Cassandra, Scala and Spark).
• Experience with Data flow diagrams, Database normalisation techniques, Entity relation modeling and design techniques.
• Experience is cross-platform data replication methodology.
• Rich experience in writingSQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developingData Conversions/Data Migration from Legacy System of various sources flat files, excel, Oracle, Non-Oracle to Oracle system UsingSQL Loader, UTL FILE by masking the confidential data using data masking techniques.
• Developed Materialized views for data replication in distributed environments.
• Experience in using several built-in database packages such as DBMS JOB, DBMS OUTPUT, UTL FILE, DBMS SCHEDULER and DBMS SQL to name a few.
• Experience in query optimization, performance and tuning (PL/SQL) usingSQL Trace, Explain Plan, Indexing, Bulk Collect, AWR and table partitioning.
• Good understanding ofNoSQL Databases and hands-on work experience in writing applications on No SQL databases in ApacheCassandra, Scala and Spark.
• Experience in writing queries UsingCassandra CQLto create, alter, insert and delete elements
• Migrating parts of data from Oracle DB to Casandra schema.
• Good knowledge in querying data fromCassandrafor searching grouping and sorting.

TECHNICAL SKILLS

• Oracle Database
• PLSQL
• Oracle Replication
• Oracle Forms/ Designer
• Oracle Weblogic
• Unix / Linux
• Apache Cassandra
• Apache Scala
• Apache Spark
• DatastaxTool
• MS Visio
• PUTTY
• Duplica
• Control-M
• Visual Team Foundation

PROFESSIONAL EXPERIENCE

Confidential

Sr. Developer

Responsibilities:

• Designed complex forms using both oracle forms and java beans.
• Converting Oracle forms, .net screens to oracle Apex.
• Extensively used the advanced features of PL/SQL likeDynamic SQL to avoid SQL injection on the web application.
• Created PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic and generate visual reports.
• Extensively usedPragma Autonomous Transaction and Compound triggersto avoid the mutating problem in database.
• Implement NoSQL Database Apache Cassandra for user’s dashboard and Product Catalogue.
• Migrating parts of data from Oracle DB to Casandra schema.
• Deployment and Support of Cassandra in Multi-Data Center.
• Application development using Cassandra as data storage.
• Wrote queries UsingCassandra CQLto create, alter, insert and delete elements

Environment: IBM AIX server P8, Linux Enterprise server 6, Oracle Database 11.2.0.4, PL/SQL developer, Apache Cassandra, Spark, Scala and IBM Control-M.

Confidential - New York

Sr. Developer

Responsibilities:

• Involved in data modeling team in analysing the tables and relations between them to replicate and migrate the data from web-based application to Oracle JD Edwards 9.1.
• Creating Data model & Data Design for Conversion, Replications and Migration.
• Designed the transition of data from web based Applications Order Point Replacement / Item Pricing into Oracle JD Edwards 9.1
• Created conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• DevelopedSQL scriptsfor Referential Integrity check, which checks the validity of incoming data with master tables in the database.
• Worked on performance issues and usedEXPLAIN PLANfor tuning the queries.
• Implementing data encryption, data masking, Fine Grained auditingwhile processing the data from web-based application - ERP application on a non-production.
• Extensively used the advanced features of PL/SQL likeDynamic SQL to avoid SQL injection on the web application.
• Trained in Apache Cassandra.
• Performed POC for other data replication tools like Apache Cassandra and Golden gate.

Environment: Unix Server, Oracle JD Edwards E1, Oracle Database 11.2.0.4, Duplica, PL/SQL Developer, Toad and Visual Team Foundation.

Confidential

Technical Consultant

Responsibilities:

• Worked on FormsTriggers, Alerts, Data Blocks, LOVs, Parameters, and Program unitsby using PL/SQL procedures and functions.
• Developed forms based on views, tables and procedures in tabular and form layouts.
• Involved in data replication and high availability design scenarios with Oracle Streams.
• Worked onSQL*Loaderto load data from flat files obtained from the various system.
• Used, standard packages likeUTL FILE, DMBS SQL, PL/SQLCollections writing database procedures, functions and packages for Front End Module.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Creatingindexeson tables to improve the performance by eliminating the full table scans.

Environment: Linux, Oracle Database 11.1.0.7, Oracle Forms Developer 10.1.2.0.2 , Oracle WebLogic server 12.1.1, PL/SQL developer, Toad, Cognos and Application decontrol.

Confidential

Technical Consultant

Responsibilities:

• CreatedDatabase Objectslike Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types and functions.
• Created PL/SQL tables and global variables and also usingINandOUTparameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Worked as Application DBA.
• CreatedSQL*Loadercontrol files for moving the data from flat files to staging area tables
• Created a web based system using PL/SQL to track the real-time network polling on NHS servers.
• Generating web-based reports using PL/SQL using the real-time Data.
• Managed data for the Sarbanes-Oxley for the auditing purpose.

Environment: Unix, Oracle database 10.1.0.2, Oracle Http server 10.1.3.3, PL/SQL Developer.

Confidential

Consultant

Responsibilities:

• Creation of database objects liketables, views, synonyms, materialised views, procedures, packages using oracle tools likeSQL* plus.
• Created a web based system using PL/SQL htp.
• Generated XML file using PL/SQL default packages.
• Worked as Application DBA.
• Design and Developed data validation, load processes usingPL/SQL Stored Procedures, Functions,andTriggersusing Oracle 10g.
• Managed data for the Sarbanes-Oxley for the auditing purpose.

Environment: Window 2003 Server, Oracle database 10.1.0.2, Oracle Http server 10.1.3.3, Apache, IIS and PL/SQL Developer.