Bharathi Ramamoorthy

*** ******** ****, *** *** Personal Phone: 980-***-****

Charlotte, NC 28217 Email:ac8t72@r.postjobfree.com

Professional Summary

Database Developer and Tester with passion for innovation, learning and technology.

Expertise in writing complex SQL’s to solve the business requirements.

Expertise in writing test cases to validate the Data warehousing solution.

Knowledge on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.

Very good experience in reverse engineering the existing system and document the process in form of Metadata and mapping documentation.

Expertise in converting test cases to test scripts by writing advanced SQL’s.

Have good knowledge in dimensional modeling and Entity relationship modeling. Worked with Star and Snowflake Schemas.

Excellent communication skills including day to day written and verbal interaction with Technology/Business Team and senior management.

Have good problem solving and troubleshooting skills.

Fast learner and highly adaptable with ability to work both in teams and independently. Ability to mentor team members.

Worked extensively with slowly changing dimensions.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Technical Skills:

ETL Tools: Microsoft SSIS

Database: Oracle 12c/11g/10g, SQL Server 2008(R2)

Reporting Tools: PowerBI

DB Tools: Oracle SQL Developer, TOAD, Microsoft SQL Server Management Studio

Environment: Microsoft WINDOWS, UNIX

Languages: SQL, PL/SQL, UNIX

Designing Tools: Microsoft Visio

Professional Highlights

Employer: Superior Innovative Technologies Pvt Ltd

Project: Enterprise Data Ware House

Role: ETL Developer and Database Tester

Duration: Jun 2015 to July 2018

The Enterprise Data Warehouse is a multi-year project which is dedicated to build a centralized data warehouse that is scalable, balanced, and flexible enough to meet existing and future needs. The objective of the project is to build independent data marts that serves specific line of business (LOB) which includes Customer relationship management, Programming, Property and Equipment’s and Inventory. Depending on the business purpose and requirements some Datamarts were designed using Entity relationship modeling and others using Dimensional Modeling. The project aims at standardizing the data across the departments there by ensuring data quality and uniformity. Legacy data will be transformed and migrated into the new model.

Responsibilities:

Participated in meetings with Business partners to understand the requirements and performance expectations.

Performed extensive analysis, research on the existing system and interviewed application Subject Matter Experts (SME’s) to understand the current architecture and its functionality. Compiled business and technical findings into ready reference documentation for each subject area.

Reverse engineered existing legacy system and developed detailed metadata documentation for the existing Datamart. Derived the business name, business description, code values and other critical information for each entity and attribute in the data model.

Reverse engineered the existing ETL Scripts to develop mapping document to establish data lineage between the source and the target. The underlying business rules and ETL Derivations are captured and documented as part of the Data Mapping documentation.

Developed Test Plan and overall Test Strategy for the Application.

Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.

Validated accurate processing of ETL generated fields For example, surrogate keys.

Validated the data types within the warehouse are the same as was specified in the data model or design.

Verified that the foreign primary key relations are preserved during the ETL.

Validated the source and target table structure against the mapping document.

Validated whether the attributes defined to be unique as per the business requirements are having any duplicate values.

Validated the data transformations, data completion and data integrity throughout the ETL process.

Employer: Bank of Baroda,India

Role: Assistant Manager

Duration: Jun 2014 to Jun 2015

Responsibilities:

Preparation of detailed credit proposal relating to different sectors so as to help the higher management in taking informed decisions.

Carry out performance monitoring of existing clients, assess credit ratings, conduct inspection/ site visits and ensure compliance with bank’s internal guidelines, Reserve Bank of India guidelines and other credit monitoring issues.

Disbursement of sanctioned cases including documentation, security creation and setting up of limit

Improved business performance in area such as deposit and government schemes

Generated and developed leads to acquire new clients

Converting non-performing assets accounts to regular accounts by giving proper guidance to clients

Conducting training sessions on Finacle,a core banking software application to senior management

Hosting business meetings with other staff and senior management

Education:

Bachelors of Engineering, Coimbatore, India

Contact this candidate