Resume

Sign in

Database Developer/ETL developer

Location:
Columbus, Ohio, United States
Posted:
November 06, 2018

Contact this candidate

Resume:

SARANYA DEVI RAJENDRAN

Hayward, CA ***** 925-***-**** ac7mer@r.postjobfree.com

3+ years of experience in complete Software Development Lifecycle (SDLC) on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing and well versed with basic DBA activities.

Experience in writing Oracle, SQL and PL/SQL code for Stored Procedures, Functions, Triggers, Cursors, Constraints, Indexes, Views, Sequences and Synonyms.

Experience in creating triggers, packages and writing SQL queries for joining multiple tables.

Knowledge in utilizing Informatica for developing and implementing ETL Solutions.

Knowledge in basic shell scripting and Informatica tool for ETL/Data Integration.

Migrated Informatica mappings, sessions and workflows from development environment to QA environments.

Involved in data modelling with tools such as Visio, MS Visual Studio, Tableau and Toad.

Performed Validation, Regression and Smoke testing for data to check compliance with specified requirements in HP ALM testing tool.

Designed web pages using JavaScript, Angular 1.x, Bootstrap 3, HTML 5 and CSS 3.

Participated in Agile Scrum daily standings and meetups.

EDUCATION

Master of Science: Computer Science March 2018 California State University, East Bay, Hayward, California.

Bachelor of Engineering: Computer Science and Engineering March 2015 Rajalakshmi Institute of Technology, Tamil Nadu, India.

PROFESSIONAL EXPEREINCE

State Compensation Insurance Fund, Dublin, CA Sept 2017 – Aug 2018 QA Analyst/ Database support Developer Intern - Project SFO

Analyzed and designed relational databases for different insurance policyholders using SQL.

Created/modified SQL queries, sub-queries, joins and views to implement business rules.

Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes, subprograms and Views in Development and Production environment using SQL.

Basic understanding in developing functions, procedures and packages using PL/SQL.

Involved in requirements gathering and test cases writing based on those requirements.

Performed unit testing of applications to check compliance with specified requirements in HP Application Lifecycle Management Tool.

Logging Defects using JIRA Testing tool.

Performed testing of all available features with Jive Content System in UAT testing environment.

Involved in project go lives by performing smoke testing in production environment.

Actively participated in QA team meetings to discuss testing process.

Knowledge in extracting data from heterogeneous sources like text file, Excel sheets, and SQL tables.

Nationwide Mutual Insurance, Columbus, OH May 2017- Aug 2017 IT Applications/ETL Developer Intern, Retirement Plans - Project Momentum

Designed and developed web pages using Angular 1.x, Bootstrap 3, HTML 5 and CSS 3.

Used AngularJS as framework to create a single page application.

Created visibility features and components for Retirement Plans webpage using Angular directives and Material Design.

Basic knowledge in developing mappings that perform Extraction, Transformation and load of source data into flat files using various power center transformations like Source Qualifier, Aggregator, Filter, Sequence Generator, Look up, Joiner and Normalizer.

Knowledge in using ETL Informatica tool for creating mapping, executing workflows and to load data from source flat files to target tables.

Modified the existing Informatica mappings and workflows based on specifications.

Designed database objects such as tables, indexes, views, sequences, procedures, functions and Triggers in Development and Production environment using PL/SQL.

Knowledge in creating workbooks, dashboards, performance charts and reports using Tableau.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Experience working in agile environment.

NTT DATA GDS, Inc., India Aug 2014 – Mar 2016

Applications Developer - Project NLG

Developed custom Intranet web application that includes functionalities such as Custom Master pages, shared calendars, shared documents, Integrated Dashboards and customized reports using .NET MVC and SQL server.

Developed PL/SQL packages, Procedures and Functions, Views, Cursors and Triggers.

Prepared summary analysis reports using Oracle reports and SQL analytical functions based on business queries.

Designed and implemented stored procedures, views and other application database code objects to aid database mappings, conversions and transformations.

Knowledge in developing, unit testing and supporting various testing phases for the ETL (Extract, Transform and Load) processes using Informatica Power Center.

Transformed the data as per business requirements and loaded them into SQL server.

Exposure to performance tuning, data profiling, workflows and work-lets in Informatica.

Knowledge in developing modules to extract and transfer customer data using Teradata utilities.

Knowledge of Rational Unified Process and data modeling for creating logical and physical models using UML, Rational Rose, and Visio.

PUBLICATIONS

A Framework for Big Data Analytics in Evidence Based Medicine (Hadoop, MySQL), RIT, Chennai, India. (January 2015-March 2015)

Involved in gathering clinical data and used the Hadoop MapReduce technique for processing the medical information and prescribing the most effectual drug with the consent of a physician.

Used SQL Queries for querying clinical information and patient records.

Designed Use case diagrams for the various modules of the application and deployed the application on a local host.

Secure Group Key-Aggregate Encryption for shared cloud data (HTML, Java, Dropbox), CSUEB, Hayward, California. (September 2016-November 2016)

Identified the problems in security for storing group/shared data on cloud.

Developed an application that ensures flexible encryption and decryption of communications between data owner and group users.

Designed Use case diagrams for various modules of the application and deployed the application using Amazon AWS.

TECHNICAL SKILLS

Languages: C, C++, Java, JavaScript, Angular 1.x, XML, Unix Scripting.

Markup Languages: HTML, CSS.

Framework: Bootstrap, Hadoop MapReduce.

Databases: MS SQL, Oracle, PL/SQL, Teradata(fundamentals), Informatica Power Center.

Tools: Visual Studio, Oracle Forms(basics), Visio, Rational Rose, Toad, HP ALM, JIRA, Tableau, Jive.

Source Control Tool: GitHub.

SKILL HIGHLIGHTS

Observant

Attentive

Dependable

Learner

HONORS

Hackathon – Nationwide Mutual Insurance August 3-4, 2017.

Won the best team idea award amongst the ten teams participated.

Built an innovative idea to bridge Nationwide’s banking unit and the Mutual Funds Group.

Developed a prototype of the idea using HTML 5, Ninja Mock and Microsoft Azure.

Intern Test Lead – State Compensation Insurance Fund- Project Jive

Led a team of 3 interns for testing Jive applications in UAT testing environment.

Prepared Master Test Strategy report for the business team.

Participated in weekly standups and provided daily status reports.



Contact this candidate