SUMMARY

• Over 8 years of Database Design and Development Experience.
• Over 4 Years of Experience in MongoDB.
• Configure 24/7 available Sharded MongoDB clusters with multi - node primary and slave configuration.
• Create Data model and object model for MongoDB implementations.
• Architect end to end MongoDB implementation and migration
• MongoDB maintenance using MMS for cluster set-up and back-up process.
• Create MongoDB Development standards for the document design and application design
• Develop Restful APIs using Camel framework to interact with MongoDB.
• Develop Angular JS Web page to consume Restful API
• Experience in Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
• Configure Jenkins Continuous integration system and integrate projects to Jenkins.
• Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL*PLUS, TOAD, MongoDB, Robomongo and SQL Developer.
• Experience in using Informatica for ETL - Creating Source, Target, Mapping, Session & Workflow and executing the transformation
• Involved in Database Analysis, Design and Implementation of business applications.
• Effectively made use of Tables, Functions, Indexes, Table Partitioning, Collections, Analytical functions and Materialized Views
• Create Tables, Views, Constraints and Index (B Tree, Bitmap and Function Based).
• Develop complex database objects like Stored Procedures, Functions, Packages and Triggers in PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables, Ref Cursor, External Tables, Collections and Exception Handling
• Virtual Private Database implementation in Oracle 11g using context and DBMS RLS
• Created Shell Scripts for invoking SQL scripts.
• Experience in SQL performance tuning using Cost-Based Optimization
• Good noledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Develop Oracle Forms in Oracle Forms 10g/11g
• Develop Reports using SQR, Oracle Reports and Java.
• Develop automation scripts for repetitive tasks
• Extensive exposure in leading and managing team of developers as a Team Leader.
• Train new team members on MongoDB and Oracle Concepts
• Have strong communication, interpersonal and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows-NT/XP/Vista/7/8, UNIX & Linux

Languages: PL/SQL, Java, Oracle, J2EE

No SQL DBS: Mongo DB, Oracle, No SQL

Java Technologies: Java, JDBC, Java Web Services, Drools, Camel Frame work

Frameworks: Hibernate, Struts, spring

Web Services: Restful

RDBMS: Oracle 9i/10G/11G/12C, IBM DB2 V9.7.2

Tools: Toad, SQL plus, SQL, Developer, PLSQL Developer, IBM Data Studio, Oracle Dev suite, Guvnor, Robomongo

Scripting: UNIX Shell, Perl, JavaScript

Others: SVN, Eclipse, Apache, Maven, Apache Ant, Spring Tool Suite, Data warehouse, Informatica and ETL.

PROFESSIONAL EXPERIENCE

Confidential, Bristol, CT

Senior Oracle/MongoDB Application Developer

Responsibilities:

• Architect the MongoDB collections and documents for Oracle to MongoDB Migration.
• Extract data from Oracle as JSON file with PLSQL code
• Import the JSON file into MongoDB Collections using mongo import utility
• Create Oracle Forms for the changing needs of business
• Create reports in Oracle Reports 11g
• Tune oracle Database Environment for the performance needs
• Develop various PLSQL components to fulfill the java and forms gap

Confidential, Bloomfield, CT

Senior Oracle/MongoDB Consultant

Responsibilities:

• Responsible for handling various business components from the Design/ Analysis phase to the Development / Integration phase.
• Achieved Authorization, Autantication, Logging and Exception handling to design and developed core model.
• Suggested and developed Many POC Projects for client needs
• Configured zero data loss environment set-up through primary and multiple slaves in mongo DB.
• Involved in designing Mongo database set-up (Mongo DB) for high performance application development.
• Designed Collection structures and Data models for Mongo DB.
• Developed high performance application in java to migrate data from Oracle to Mongo DB.
• Used Mongo import utility for loading data into mongo DB.
• Used spring and Hibernate framework for the application development.
• Perform Migration from SQL Server to Oracle, Oracle to MongoDB and DB2 to MongoDB
• Create and modify UNIX shell Scripts according to changing needs of the project and automation requirement.
• Develop PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• ETL Process using PL/SQL and Informatica.
• Create Informatica Source, Target, Mapping, Session and Workflow to perform the necessary ETL Process.
• Involved in Logical & Physical Database Layout Design.
• Wrote Business rules using JBoss Drools in Guvnor.

Confidential

Senior Software Engineer

Responsibilities:

• Develop Generic Purchase Order form across the departments
• Implement the standard Purchase Order for all the departments
• Create PLSQL Modules for handling gaps
• Train New Team members in Oracle PLSQL and SQL Concepts and evaluate them

Confidential

Software Engineer

Responsibilities:

• Involved in complete software development life cycle i.e. requirement gathering, Use Case Analysis, Designing Object Models, Class Diagrams, Sequence Diagrams and Activity Diagrams and development &deployment of the application.
• Responsible for handling various business components from the Design/ Analysis phase to the Development / Integration phase including Unit Testing.
• Designed and developed the frameworks to achieve Electronic Check Service.
• Extensively worked on database tuning and PL/SQL (stored procedures, functions, cursors, triggers, SQL queries etc.) and participated in Oracle database schema design.
• Developed base classes by extending Struts Action and Struts Action form classes. Responsible for JSP and Struts based front end integration with the server side layer.
• Developed various Data transfer objects & Value Objects and defined relationship between them. Developed DAO framework for the persistent of data in oracle database.
• Designed and generated classes for various Use cases in Rational Rose and forward/reverse engineer these generated classes into Eclipse - IDE.
• Build and deploy application using Ant on JBoss 4.0
• Responsible for User acceptance Testing, Building, Packaging and Shipping of the application for the Development, Staging and Production environment.

Confidential

Implementation Engineer

Responsibilities:

• Extensively worked on database tuning and PL/SQL (stored procedures, functions, cursors, triggers, SQL queries etc.) and participated in Oracle database schema design for all customization needs.
• Configure the solutions for client needs for their billing, Mediation, transaction, pricing and customer care modules