Mongo Db Developer Resume
Santa Clara, CA
SUMMARY
- Over 7 years of experience in Software Development with expertise in design, development, Analysis and Testing of various technologies
- Technical expertise in Python, Mongo DB, ETL Testing, Informatica, ORACLE, SQL, JavaScript
- Expertise in NoSQL database MongoDB
- Excellent understanding and working knowledge of Python
- Working knowledge of Unix at system level
- Install, Configure and monitor numerous MongoDB and NoSQL instances
- Study the database needs of our applications and optimize them using MongoDB and NoSQL
- Strong knowledge of relational and NoSQL databases
- Understanding of Database Architecture
- Experience in using Version Control Systems like GIT
- Thorough understanding of Sharding, Query analysis and DB Schema design
- Strong knowledge in MongoDB concepts - CRUD operations and aggregation framework
- Experience in the design of Mongo DB database - Indexing and Sharding
- Expertise in Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Documentation which includes Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Software Requirement Specification (SRS)
- Excellent understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Test Methodologies
- Expert proficiency in SQL Scripting
- Involved in all phases of testing such as Unit Testing, Regression Testing, Integration Testing, System Testing and User Acceptance Testing
- Strong knowledge in Object Oriented programming making code more flexible, maintainable analyzing various performance or run-time complexities
- Extensive experience in developing Test Cases, Test Plans, Test Metrics, Test Summary and Defect Reports
- Excellent communication skills, interpersonal skills, self-motivated, quick learner & team player
TECHNICAL SKILLS
Databases: MongoDB, Oracle 11g, SQL, DB2, PL/SQL
ETL: Informatica Power Center 8.6, Power Mart, Data mart, ETL, OLTP, OLAP, Star Schema, Snowflake Schema, WS FTP PRO, SQL Developer, UNIX Shell Scripting
Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.0/3.5.2/2. x
Languages: Python, C
Environment: Windows, UNIX, MS-DOS
Scripting Languages: Python 2.7, Unix shell scripting
PROFESSIONAL EXPERIENCE
Confidential, Santa Clara, CA
Mongo DB Developer
Responsibilities:
- Conducted requirement and impact analysis received from the business team
- Designed migration procedures and Created applications in Python to do the data migration from Oracle to MongoDB
- Developed Python scripts using multithreading module
- Defined collections to store data in MongoDB
- Wrote aggregation functions to perform different types of calculations
- Expertise in MongoDB Schema Design using DB Ref, Manual Ref
- Used the mongo import command to load the huge data into the Database
- Developed the code with CRUD operations and aggregation framework to interact with the database
- Performed Unit and end-to-end Integration testing
Confidential, San Francisco, CA
SQL Developer/ETL Tester
Responsibilities:
- Analyzed the business requirement document and the system requirement document to arrive at a detailed Test Plan
- Executed test cases for complex mappings that involved Expression, Filter, Aggregate, Join, Lookup, Router, Sequence, Update Transformations (business rules) procedures for new functionality
- Involved in creating test cases based on the requirement and review with the client
- Performed all phases of testing: System, Integration, and Regression testing
- Executed shell scripts to refresh the QA DB in order to reflect the changes made to the mapping workflows
- Generated defect reports for project status meetings as necessary. Involved in Quality Center activities and used Quality Center for executing test cases, JIRA for logging defects, creating data warehouse test plan and handling test lab activities
- Interacted with the Business Users for user acceptance testing
- Interacted and worked with the development teams to resolve issues observed during test execution
- Participated in test case review and walkthrough meetings
- Maintained warehouse metadata, naming standards and warehouse standards for future application development
Confidential
SQL Developer/ETL Tester
Responsibilities:
- Preparation of Test Cases based on Business Specification Document
- Executed the developed Test Cases and Test Plans
- Involved in Unit testing and integration testing Functional testing, System testing, Regression testing and Back end testing
- Worked with Requirement Analysts, Developers, and other testers to resolve issues with requirements
- Involved in Unix script testing for efficiency improvement of loading process
- Validating the data files from source to make sure correct data has been captured to be loaded to target tables
- Extensively used SQL queries for data validation and backend testing