SUMMARY:

• Over 10 years of Database Design and Development Experience.
• Over 4 Years of Experience in Mongo DB.
• Over 5 years of Team Lead and Architect Experience
• Configure 24/7 available Sharded Mongo DB clusters with multi - node primary and slave configuration.
• Create Data model and object model for Mongo DB implementations.
• Architect end to end Mongo DB implementation and migration
• Mongo DB maintenance using MMS for cluster set-up and back-up process.
• Create Mongo DB Development standards for the document design and application design
• Develop Restful APIs using Camel framework to interact with Mongo DB.
• 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, Mongo DB, 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 knowledge 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 Mongo DB and Oracle Concepts
• Have strong communication, interpersonal and problem solving skills.

Domain Experience:

• Billing (Banking, Retail, Insurance, Telecommunication, Fleet)
• Insurance (Member, Provider, Accounts, Claims)
• Multimedia

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

Oracle/Mongo DB Developer/Architect

• Architect the Mongo DB collections and documents for Oracle to Mongo DB Migration.
• Develop REST APIs to perform read write operations to Mongo DB
• Develop EXT JS web pages to consume Mongo DB APIs
• Extract data from Oracle as JSON file with PLSQL code
• Import the JSON file into Mongo DB 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

Technologies & Tools: ETL, Mongo DB, Oracle 11g Forms and Reports, UNIX Shell Scripts, PL/SQL.

Confidential, Bloomfield, CT

Oracle/Mongo DB Application Developer/Architect

• Achieved Authorization, Authentication, Logging and Exception handling to design and developed core model.
• Suggested and developed Many POC Projects for client needs
• Team lead for the Entire project. Performed Architect, Design and Development.
• 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 Mongo DB and DB2 to Mongo DB
• Develop REST API using Spring & Camel Framework to read and write data to and fro in Mongo DB
• Develop Angular JS Webpages to consume the Mongo DB APIs.
• 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.

Technologies & Tools: Mongo DB, DB2, Oracle 10g & 11g, SQL Server, Java, Informatica 9.5.x, Spring 2.x, Hibernate 3.x, Unix Shell Scripts, PL/SQL, JDBC, XML, WSDL, XSD, Apache Maven 2.0.x, Eclipse 3.x, JBoss Drools.

Confidential

Senior Software Engineer

• 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

Technologies & Tools: Oracle E-Business Suite 11 R2 Purchasing Module, Oracle 11g, UNIX Shell Scripts, PL/SQL.

Confidential

Software Engineer

• 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

Technologies & Tools: Oracle 9i/10g, Java, XML, UNIX / Sun Solaris.

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