Shine Thomas

Phone No: +1-408-***-****

Email: ac4kum@r.postjobfree.com

EXPERIENCE SUMMARY

• 7 years of experience in analysis, design and implementation of ETL Solutions, Business Applications, migrations, performance tuning using Oracle Relational Database Management System (RDBMS)

• Involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

• Good working experience in ETL, Data Migration, Data Modeling, Data Quality and Data warehousing projects

• Sound knowledge in Erwin data modeler for database designs

• Hands on experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling

• Knowledge in Dimensional modeling- Star schema and Snowflake schema

• Experience in ETL tool Oracle Warehouse Builder

• Sound knowledge in QlikView reporting tool

• Expertise in PL/SQL coding, Performance Tuning and UNIX shell scripting

• Effectively made use of External Tables, Ref Cursor, Bulk Collect, Indexes, Table Partitioning, Exchange Partition, Materialized Views, Data Pump Utilities and Transportable Table space

• Expertise in SQL Loader, Exception Handling, Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables, Daemon Process and UTL_FILE

• Good Experience in different Oracle database like 9i, 10g, 11g and Oracle Forms 11G

• Knowledge on Oracle Exadata and 12c

• Knowledge on Hadoop, HDFS, Pig, Hive, Spark and MongoDB

• Experience in direct interaction with clients (US & UK)

• Participated in Proposals and Project Estimations

• Extensive experience in domains like Financial Services, Energy & Utilities and Retail

EDUCATIONAL QUALIFICATIONS

B. Tech Cochin University of Science and Technology

TECHNICAL PROFICIENCY

Languages

SQL, PL/SQL, Unix Shell Script

Databases

Oracle 9i/10g/11g, SQL Server 2008R2, Knowledge on Oracle12c

Database Design

Erwin 9.0

Tools

Toad, SQL Developer, SQuirrel, Putty and WinSCP, IBM Rational Team Concert (RTC), SharePoint

ETL Tools

SQL Loader, OWB. Knowledge on Informatica Power center

Reporting Tools

QlikView

Configuration Tool

Tortoise SVN

Operating System

Windows and Unix/Linux

Scheduler

Autosys

PROJECT EXECUTION METHODS

• Waterfall Method

• Agile Method

WORK EXPERIENCE

State Street, Princeton, NJ Sep2016 - Till Date

Data Modeler, Data Analyst

Enterprise Service Platform (ESP)

Description: ESP is an in-house data management tool developed by State Street, which helps to design new Data Marts based on new set of input files the application receives. It provides the option to configure source files and schedule source file loads into Data Marts. Also, this tool provides the feature to design new reports using these Data Marts and schedule the same.

We used ESP to develop an income repatriation service where FX pricing occurs multiple times per day for applicable currencies based on clients timing and aggregation.

Responsibilities

• SCRUM/Agile Content Lead in cross-functional stand-ups, grooming and retrospectives (RTC)

• Analyzed all business requirements and created complex data model for this application

• This application contains 30 tables/categories and 100 Data Marts to implement complex functionalities like Currency blocking rules, Transactions rollup &Order creation and Sweep orders to StreetFx

• Analyzed transactions from different sources and prepared Source to Target Mapping (STM) for each source into common staging table

• Created Data Feeds to load the input files to ESP Staging Tables

• Designed new Data Marts for each functionality and transformation rules

• Designed new set of extracts to send data to different downstream systems

• Conducted Performance Review and SQL Query tuning

• Managed Data quality using OCF (Operational Control Framework) checks

• Scheduled inbound data feeds and outbound extracts using autosys jobs as per business requirements

• Implementing housekeeping and backup strategy of different tables

• Creating purge script to archive more than one-year old data

• Implementing ESP for different clients and customizing this application based on new requirements

Environment: Oracle 11g, ESP tool, IRD tool & QlikView for Reporting, Data Modeling, Autosys

RWE npower Mar2015–Aug2016

Technical Lead, Oracle PL/SQL Developer

Smart Metering Implementation Programme (SMIP), Onsite (UK) + Offshore

Description: Smart Metering Implementation Programme (SMIP) is a national programme to roll out Smart Meters across Great Britain. npower is an active player within the SMIP. This project is to enhance sales, pricing and registration business applications of npower, ensuring that they meet specific licensing

conditions to operate with DCC by September 2016.

Responsibilities

• Involved in full development cycle of analysis, design, development, testing and implementation

• Actively involved in project design phase, prepared Functional Design Documents and Technical Design Documents for two business critical applications: SPRITE and Value+

• Coordinated with front end design team to provide them with necessary stored procedures/packages and necessary insight into the data

• Created PL/SQL stored procedures, functions and packages to read/write data from oracle forms to the database

• Extensively used advanced features of PL/SQL like records, tables, object types and dynamic SQL

• Handled errors using exception handling extensively for the ease of debugging and displaying error messages in the application

• Implemented daemon process to call shell script from oracle PL/SQL procedures to invoke java web services

• Coordinated with offshore team and reviewed their tasks.

• Prepared release notes, deployment strategy and implementation plan for production go-live

• Provided Technical and Functional design documents walk-through to other team members and testing team

Environment: Oracle SQL, PL/SQL, Oracle Forms and Reports, SQL Server 2008R2, UNIX Shell Scripting

Wm Morrison Supermarkets plc Oct2014–Feb2015

Data Analyst, Offshore Team Lead

ORSIM Data Migration

Description: Sales-Based Ordering (SBO) Programme is engaged to deliver the functionality of Store Operations system - Oracle Retail Store Inventory Management (ORSIM) to cover Inventory Management and Planning Solution for Customer-Stores. Delivered effective Data Migration solution to load the foundation data from RMS to ORSIM. Also maintained the quality of data before migration.

Responsibilities

• Designed all Data Migration entities and technical approach

• Conducted Performance review and SQL Tuning

• Automated UNIX data quality framework that loads source data to DQ staging tables, apply business rules and extract DQ reports for each rule

Environment: Oracle SQL, PL/SQL, ETL, Data Migration, Data Quality, and UNIX Shell Scripting.

Wm Morrison Supermarkets plc Jan2014– Sep2014

Data Analyst, Offshore Team Lead

ORDF Data Migration

Description: Evolve release ER12A is engaged to deliver Oracle Retail Demand Forecasting (ORDF), a statistical and promotional forecasting solution that can process large amounts of data using modeling techniques to produce forecasts with reduced human intervention. Implemented initial data migration solution from Oracle RMS to RDF.

Responsibilities

• Migrated 2 years of historical data for daily sales and promotions from Oracle RMS/RPM and EDW into Oracle RDF using complex transformation logic

• Tuned all long running DM scripts and achieved better performance

• Generated store specific migration target data files for 1000 stores within 45 minutes using UTL_FILE and parallel processing

• As a pre-migration activity, identified all source data issues and cleansed incorrect data based on business rules

Environment: Oracle SQL, PL/SQL, ETL, Data Migration, Data Quality, and UNIX Shell Scripting.

Wm Morrison Supermarkets plc Jan2011– Dec2013

Senior Developer, Data Analyst

Morrison’s Retail Bulk Data Migration, Onsite (UK) + Offshore

Description: Evolve Release 8 is engaged to deliver the functionality of both Merchandise and Pricing systems (Oracle Retail Merchandising System/ Oracle Retail Price Management) in order to provide both multi-pricing and multi-promotions to the in-store execution system (Store line). The objective is to integrate Oracle retail system with Legacy Mainframe system for Trading Stores Product & Price (TSPP) and Trading & Finance Management Information (TFMI). Extracted source data from Legacy Mainframe systems, transformed bulk volume of data using ETL: Oracle Warehouse Builder, Oracle PL/SQL scripts and loaded transformed data into Oracle Retail systems: ORMS, ORPM & Episys (A third party system for signage).

Responsibilities

• Created Functional Design Documents and Technical Design Documents for all entities

• Developed scripts for pre-migration validation, data extraction & transformation, business & technical reconciliation

• Prepared test scripts and traceability matrix for unit testing

• Replaced long running/complex OWB mappings with custom PL/SQL scripts and achieved better performance

• With continuous system analysis and technical expertise, improved Data Migration performance using advanced oracle data loading concepts: External Tables, Exchange Partition, Data Pump Utilities and Transportable Table space

• Migrated 300 million records into 15 Oracle retail target tables within 2 hours of cutover window.

• Automated UNIX framework to execute Data Migration scripts, technical and business reconciliation scripts

• Automated Shell Scripts for invoking SQL scripts to dynamically capture the DDL of migration database objects and deploy them into higher environment

• Worked as an onsite Data Analyst, directly interacting with the client

• Supported business team in data quality analysis, identified data issues and prepared automated scripts to extract DQ reports in desired format.

• Performed data cleansing enrichment and mapping tasks

• Designed a four-way price comparison report to identify any price mismatch of items between four different systems, which is critical in retail supermarket business

• Developed one business reconciliation framework that extracts stock-on-hand report for 1000+ retail stores within 30 minutes. With multi-threading approach, the entire 1000 store specific reports extracted in parallel using UTL_FILE and Pro-C

Environment: Oracle SQL, PL/SQL, ETL, Oracle Warehouse Builder (OWB), Data Migration, Data Quality, and UNIX Shell Scripting.

Contact this candidate