We provide IT Staff Augmentation Services!

No Sql & Sql Data Modeler Resume

3.00/5 (Submit Your Rating)

WA

SUMMARY

  • No SQL & SQL Data Modeler a highly qualified individual over 5+ years of experience in data modelling and application development with technological forte in distributed NoSQL database technologies Cassandra and relational databases like Oracle, MySQL, MS SQL applications. An effective utilization of knowledge in performing activities with positive attitude and by demonstrating leadership skills and managing information security and confidentiality.
  • Expertize in designing and developing NoSQL Database Models in Cassandra and Relational Database Models in Oracle using ERWIN.
  • Good hands on experience in implementation of Data Management for Microservices Architecture.
  • Expertize in transforming Monolithic data models into highly scalable bounded context domain driven models.
  • Extensive experience in Application developing and Data Migration from RDBMS databases to NoSQL database Cassandra.
  • Proficient in using Cassandra Stress tool for the read write latencies and perform fine tuning to the cluster.
  • Expertized in Designing, Developing and Maintaining Big Data Solutions to the Supply Chain Management, Transport and E - Commerce Domains.
  • Created, Collected and maintained Metadata, Evaluate completeness and accuracy of Data models.
  • Proficient in developing and analyzing huge volumes of data and developing applications those meet client specific requirements.
  • Experience in consuming real time data using Informatica, shell scripting and SQL Loader.
  • Excellent knowledge in Big Data Analytics Cassandra, Spark, Solr.
  • Proficient in delivering multiple project by managing co-associates and establishing trustworthy relationships with clients.
  • Experience in Agile, Waterfall and Scrum methodologies.
  • Certified associate for Oracle SQL development and programming with PLSQL.

TECHNICAL SKILLS

Programming and Web: SQL, PLSQL, CQL, VB. Net, HTML5, CSS, XML, Shell Scripting, Java/J2EE, SOAP UI

Business Suite: Oracle E- Business Suite

Big Data Technologies: Apache Cassandra, Spark, Apache Solr

Middleware Tools: Oracle Service Oriented Architecture (SOA)

SQL and NoSQL Databases: Cassandra, Oracle, MySQL, SQLite, MS SQL Server 2008 / 2012, MS Access.

Methodologies: Agile, Waterfall

Operating systems: Windows OS, UNIX

PROFESSIONAL EXPERIENCE

No SQL & SQL Data Modeler

Confidential, WA

Responsibilities:

  • Retail Inventory Serialization is an application developed for retail inventory management For Confidential Stores using Digital Micro services Architecture.
  • Analyzed the legacy conceptual, logical and physical data base models using ER and ERR diagrams using ERWIN.
  • Performed Normalization and De-normalization techniques for achieving the required functionality.
  • Establishing connections with remote database systems by using object oriented programming.
  • Created Conceptual, Logical and Physical Data Models by analyzing the queries from application and represented as Chebotko diagrams.
  • Configuring, administering and monitoring multi node NoSQL Cassandra 3.0.11 clusters and Datastax Enterprise Edition 5.0.3 on a real-time environment issues.
  • Modified YAML scripts to set the configuration properties like node address, replication factor, memtable size and flush times.
  • Excellent knowledge in data modelling key spaces, partitioning, columns, tables, Partition key and created using CQLSH command line.
  • Responsible for adding, removing and upgrading nodes to a cluster and evaluating the performance using SPUNK tools.
  • Used appropriate Data partitioner, replication, and compaction strategy and consistency levels per the requirements of the project.
  • Experience in commissioning, decommissioning nodes and performing various operations like compaction, repairing nodes, changing configuration files and monitoring Cassandra and Solr log files.

Systems Engineer

Confidential

Responsibilities:

  • Worked on challenging work environments involving many third-party clients and vendors, Database integrations.
  • Responsible for requirements gathering, developing design documents, development and deployment and communicating information in detail with client.
  • Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN. Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
  • Responsible for data migration form Legacy system to New proposed system as a part of business process re-engineering.
  • Created Entity Relationships diagrams, data flow diagrams and implemented referential integrity using ERWIN.
  • Designed number of inbound and outbound interface between Oracle to various third party legacy systems.
  • Developed many Oracle PLSQL objects such as Packages, Functions, Procedures, triggers and performing SOX compliance on inbound and outbound using UNIX shell scripting.
  • Responsible for maintain defect containment logs and proposing possible solution in reducing the defect count.
  • Troubleshooting the existing components and proposing new feasible solutions for better outcomes.
  • Worked on Oracle Service Oriented architecture (SOA) and developed many web services involving WSDL, XSD, XSTL, XPATH, BPEL, Human Tasks and Mediators for extracting, transforming and loading (ETL) data between Oracle and Siebel databases.
  • Developed PLSQL packages for direct database to web service integrations using SOAP UI, XML functions and web service calls.
  • Worked on developing front end forms and reports using Oracle form and report builder tools.
  • Implementation of custom functionality on Oracle ERP modules like Oracle inventory, Retail, Financial modules and contracts.
  • Preparing test plans and executing test cases at various stages of project for defect free deployment.
  • Providing technical support for the deployed components and responsible for monitoring and resolving high priority issues in production support.

We'd love your feedback!