SUMMARY

• Over 7 Years of diversified experience as Administrator/Developer in Exadata PLSQL, PRO*C, Oracle performance improvement and Informatica with Warehouse Management System area of retail domain.
• Certified in Oracle and Trained and Certified by 10gen in M102 (MongoDB DBA) and M101P (MongoDB for Python Developer.
• Complete understanding of Software Development Lifecycle and Core area of experience in to validate end - to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in MongoDB and Oracle Administration, PL/SQL, Python, Django, EXADATA, PRO*C, MongoDB and Oracle Performance tuning, Informatica in Banking, Manufacturing, Retail Domain Applications in Warehouse Management area.
• Committed to team environment dynamics with the ability to contribute expertise and follow leadership.
• Strong Interpersonal, organizational skills and ability to interact effectively and efficiently with Project Managers, Confidential Managers and stake holders to complete the job in time.

TECHNICAL SUMMARY

• Trained and Certified by 10gen in M102 (MongoDB DBA) and M101P (MongoDB for Python Developer).
• CRUD : Creating, Reading and Updating Data in MongoDB.
• Advanced queries : Query conditionals and aggregation framework.
• Availability : Configuring and monitoring replica sets in MongoDB.
• Performance : Optimizing, monitoring, and understanding of MongoDB.
• Scalability : Sharding setup, sharding monitoring, shard key selection, inserting large amounts of data in MongoDB.
• Backup and recovery in MongoDB.
• Experience in development of Python and Django using MongoDB as database.
• Extensive experience in Confidential /Server technology area with Oracle Database and PL/SQL for the back end development of Packages, Stored Procedures, Functions and Triggers .
• Worked on all kinds of dynamic SQL formats, Connectivity and exception handling in PRO*C programming.
• Worked on Performance improvement of SQL, PLSQL programming and Database.
• Co-Ordinated with Oracle team for getting bugs fixed in Exadata.
• Conducted POCs on SMART SCAN, HYBRID COLUMNAR COMPRESSION, FLASH CACHE, INCREMENTAL STATISTICS COLLECTION, STORAGE INDEXES in Exadata.
• Develop PRO*C programs using dynamic SQL logics for legacy systems .
• Experience in Retail, Financial and Manufacturing Domains .
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
• Experience in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema, which are used in relational, dimensional and multidimensional modeling.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Oracle Scripts and SQL*Loade r.
• Extensive knowledge on project management methodologies, software development life cycle methodologies.
• Involved in Life cycle of projects such as requirements analysis, Design, Testing and Implementation Phases.
• Strong technical skills in Oracle, SQL, PL/SQL .
• Experience in UNIX shell scripting.
• Excellent Team player and can work on both development and maintenance phases of the project.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Operating Systems: Windows 95 / 98 / NT / 2000/XP, UNIX

Languages: PYTHON, DJANGO,C, C++, PL/SQL, PRO*C, HTML, DHTML, Java

ETL Tool: Informatica 8.6, Information Server 8.0/8/.1/8.5

Databases: MongoDB 2.0/2.2,Oracle 8i/9i/10g/11g, SQL Server 2000, Exadata

Scripting Languages: VBScript, Java script

Packages: MS Office

Versioning Tools: Harvest, IBM Rational Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

MongoDB Developer / DBA

Responsibilities:

• Replica set and Sharded network setup and maintenance with high availability.
• Backup & Recovery, Database optimization and Security maintenance.
• Preparing user interfaces for the application
• Getting thoroughly involved in the programming of web based applications using pymongo.
• Ensuring that the applications being developed can be used by non technical personnel
• Guiding the team of 3 python programmers
• Making the necessary changes in the developed application or software as suggested by the testing department.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Performed Unit Data Testing.

Environment: MongoDB 2.0/2.2, Python 2.7/3.0, Django 1.3/1.5, Bottle 0.11.6, Pymongo, Pycharm, Emacs, IDLE.

Confidential,Cleveland, OH

Oracle Administrator/ Developer,

Responsibilities:

• Worked on backup / disaster recovery.
• Implemented ASM and DataGuard.
• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Responsible for Oracle Performance improvement activities.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Query Optimization for improving the performance of the data warehouse.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Created PRO*C programs for Handling Data which comes in flat file and for handling data loads from Windows/Unix environment.
• Designed the ETL processes using Informatica to load data from Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Data Mart.
• Identifies, researches, and resolves PLSQL/ PRO*C/ ETL root cause of production issues or system problems.
• Involved in Production support activities like Deployment, Jobs handling of PLSQL/PRO*C/ETL codes.
• Designing the projects as per Business needs.
• Designed documents as HLD based on the requirement gathered from Business users.
• Handled offshore team of 5 people.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Involved in performance tuning of the mappings, sessions and workflows.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Created documentation on mapping designs and ETL processes.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Documented PLSQL/PRO*C/ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Understand the requirements from the Functional specifications.
• Closely interacted with the Confidential and Functional consultant as creation of Technical Design Document.
• Analyzed the source data coming from Oracle database and Mainframe flat file and developed ETL specs with data architect and business users.
• Developed Informatica Mappings, reusable Mapplets and Transformations.
• Developed Informatica mapping to auto generated parameter file. An Informatica workflow data mart was developed for integrated control management.
• Created reusable Sessions, reusable Worklets, tasks and workflows.
• Worked extensively on SQL and PL/SQL.
• Performed Unit Data Testing.

Environment: PowerCenter 8.6, PRO*C, PLSQL, Oracle 10g/11g, Exadata, UNIX, Win XP Pro, PLSQL Developer, Toad, Winscp.

Confidential: 

Oracle Performance Engineer/PLSQL/PRO*C developer

Responsibilities:

• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Responsible for Oracle Performance improvement activities.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Query Optimization for improving the performance of the data warehouse.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Created PRO*C programs for Handling Data which comes in flat file and for handling data loads from Windows/Unix environment.
• Worked with various stored procedures to populate data to summary tables.
• Created the transformation routines to transform and load the Incremental Aggregation data.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Modified bunch of SQL stored procedures that perform income calculations.
• Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Involved in generating UNIX scripts to create reports to be sent to ESI Business
• Developed PL/SQL scripts for Data loading and Data extraction.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Responsible for preparing developed Test Plan, Test Procedures and Test Cases.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.

Environment : TOAD for Oracle, Oracle10g/9i, PL/SQL, UNIX, Sun Solaris 8.0, Shell Scripting.

Confidential,

PLSQL/PRO*C developer

Responsibilities:

• Created PL/SQL Stored procedures, packages, functions for data upload, bulk loading, Incremental loading.
• Created Triggers to capture the Data manipulation transactions on the Fact tables and Fact history tables.
• Responsible for Oracle Performance improvement activities.
• Implemented the best practices of SQL usage within the project to improve the performance of the SQL.
• Query Optimization for improving the performance of the data warehouse.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Created PRO*C programs for Handling Data which comes in flat file and for handling data loads from Windows/Unix environment.
• Worked with various stored procedures to populate data to summary tables.
• Created the transformation routines to transform and load the Incremental Aggregation data.
• Extensively used TOAD, PLSQL developer to create target tables, PLSQL programs and access data.
• Modified bunch of SQL stored procedures that perform income calculations.
• Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Involved in generating UNIX scripts to create reports to be sent to ESI Business
• Developed PL/SQL scripts for Data loading and Data extraction.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Responsible for preparing developed Test Plan, Test Procedures and Test Cases.
• Developed Test Plans and written Test Cases to cover overall quality assurance testing.