Data Software Engineer

Soumya Tejas Location: Texas, ***** Phone: +1-716-***-**** Email: ******.*****@*******.***

A PL/SQL Oracle database developer, with 3+ years of relevant experience – stored procedures, procedures, functions, triggers, cursors, packages, performance tuning, explain plan, indexes, partitions, database modeling – logical, physical.

EDUCATION

Master of Science - Management Information Systems

Bachelor of Engineering in Electronics and Communication

University at Buffalo SUNY, June 2017 – 3.6 GPA

Anna University, June 2009 – First class

SKILLS

Databases: Oracle 10g, Oracle 11g, MS SQL Server 2005, Oracle 11g architecture

Languages: PL/SQL, SQL, Unix shell scripting, Java (basic)

Database Tools: TOAD, SQL*Plus, SQL*Loader, ErWin Data Modeler, EXPLAIN PLAN, Data pump, Informatica (basic)

Other Tools: Visio, Putty, WinSCP, SAS Base, SAS E-Miner, Excel, IBM Rational Clearcase, Clearquest, MS Project

Methodologies: SDLC, Agile, ITIL, ITSM, Kimball approach, CMMI, Lean Six Sigma, and DMAIC

EXPERIENCE

IBM (via Dyn Pro India Private Limited), Analyst, Feb 2016 – Jun 2016 India

Loaded csv flat files from different systems, into the SQL Server database

Performed data cleanup, transformations using SQL, tested ETL output against specified business requirements for transformations

HCL Technologies, Oracle – Software Engineer, Apr 2010 – Jan 2013 India, Sweden

Traveled to client location, Sweden, to lead complex database changes – accommodating change in source and format of 24 incoming data streams to a critical application, and database migration from Oracle 10g to Oracle 11g

Designed HLD, LLD for database change requests on Oracle 10g and Oracle 11g

Designed new, and modified existing, normalized logical model, physical model for two application’s databases

Created stored procedures – procedures, functions, packages, triggers and used dynamic SQL, cursors, DML to implement business logics and process bulk data – OLTP database

Created, maintained – views, materialized views, REFRESH – FAST, FORCED, COMPLETE

Recovered data in case of data loss or corruption using AS OF TIMESTAMP feature in Oracle database

Loaded data from flat files of various formats, to Oracle database using SQL Loader

Acted as key database specialist for critical application – troubleshooting, root cause analysis issues/incidents/errors

Tuned SQL queries for reports, optimized read/write operations using EXPLAIN PLAN, indexes, partitions, hints – 30% improvement in report performance

Lead as single point of contact for a critical application during a recurrent enterprise-level data deployment activity – planning, backup scripts, training team members, validating data quality, developing strategy to forward bulk data to other systems, communicating with client, senior managers, other teams – 40% decrease in time for completion

Coded in unix shell script along with SQL query and identifiers, to exchange data between two relational databases

Earned numerous award and appraisals – Star Performer 2011, O2 League 2012, and Live Wire Performer Q1 2012

Not-for-profits, Freelancer, Mar 2013 – Jan 2015 India

ACADEMIC PROJECTS

AUTOMATED ORDER SYSTEM FOR HOSPITAL, 09/2016 – 12/2016

Inventory control – demand forecast, re-order point calculation with lead-time, safety stock, and forecast values. Logical, physical model on ErWin. Developed 26 tables, 4 functions, 4 procedures, 2 triggers to implement solution – Oracle 11g

CRIME DATA ANALYTICS, 09/2016 – 12/2016

Data warehouse modeling - star-schema, ETL – loading excel and csv source files into Oracle 11g database, performed cleanup and transformations in SQL

ACTIVITIES

GENDER AND LGBT RIGHTS ACTIVIST, 2012 - 2015

Contact this candidate