Description
Executive Summary
· Data integration specialist with around 4 years of experience in working on data migration projects to support in-house reporting.
· Experience in Analysis, Design, Development, Testing and Production Support in various applications.
· Experience in data warehousing technology like ETL and reporting tools.
· Experience in UNIX shell scripting.
· Experience in using Version Control systems like Clearcase.
· Experience in writing PL/SQL Queries (DDL, DML and DCL), PL/SQL Procedures, Triggers for Oracle and MySQL databases.
· Experience in using tools like Putty, WinSCP, Oracle Developer, PL/SQL Developer, TOAD, SQL PLUS and HPSA.
· Involved in solving production issues and quick remedies at the client-site environment.
· Excellent interpersonal and communication skills with people of diverse cultural backgrounds.
· Highly keen on identifying customer needs and providing solutions to achieve customer satisfaction.
TECHNICAL SKILLSET
Technologies: Informatica, Oracle/PL SQL, Teradata and UNIX
Database: Oracle 10g/11g, MySQL and SQL Server, Teradata
Tools: Informatica (8 & 9), HPSA, Putty, WinSCP, Oracle Developer, PL/SQL Developer, TOAD, SQL PLUS, Teradata.
Version Control Tools: Clear Case
Operating Systems: Windows 10/7/XP
PROFESSIONAL EXPERIENCE
Company : Tata Consultancy Service
Duration : Oct 2014 – Jan 2015
Client : Royal Bank Of Scotland
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Oct 2014 – Jan 2015
DMIS of Retail IM: The Asset Protection Scheme was a part of support that RBS received from the UK Government following the refinancing of the bank. Its approval plan was subjected to RBS group taking number of steps to mitigate the distortion to competition in the UK banking sector as a result of Government support. The key step is to:
– The RBS branch network in England & Wales along with Natwest Branch network in Scotland & its proportion of its small business, commercial customers, direct customer base will be moved to new owner. This process of moving is called Project Rainbow.
– As part of it, the Retail MI applications must be cloned to new target side which involves replicating system’s code, scheduling information, Data Base’s with its components, Shell scripts and PL/SQL.
– Also requires the creation of new data warehouse on the target side as a single store of enterprise wide data.
Responsibility:
· Involved in generation of Scripts for triggering the ETL code to perform the data extraction.
· Involved in the development & migration activities of the components to newer target system.
· Evolved in Unit and System Testing phases of the code.
Environment:
PL SQL (DDL, DML and DCL), UNIX scripts, Oracle 11g, Informatica 9.1
Company : Tata Consultancy Service
Duration : Oct 2014 – Jan 2015
Client : Royal Bank Of Scotland
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Oct 2014 – Jan 2015
FIRST DTP (Strategic Development): FIRST DTP is intended to deliver operational and financial benefits to finance, treasury, Risk and Associated support functions of the bank. Data Transformation solution compromises an operational data cache (ODC) which is fed with raw data from source systems. DTP is to present downstream consumer applications in First with data sourced from ODC’s which is standardized, Traceable, Reconcile, Validated, Enriched and understood. Under DTP data extracts process will be implemented in production to create extracts and to transfer to business servers.
It was required by the business to automate and productionise the manual extracts of data from various source systems.
Responsibilities:
· Presented the Small change process document (SCPD) to the business and technical team.
· Involved in all the Development & Testing phases of Software Development Life Cycle (SDLC).
· Worked in creating the Oracle Stored Procedures since mostly the business logic lies in it.
· Ensured proper versioning of the code using the clearcase.
· Evolved in Unit and System Testing phases of the code.
Environment:
PL SQL (DDL, DML and DCL), UNIX scripts, Oracle 11g
Company : Tata Consultancy Service
Duration : Oct 2014 – Jan 2015
Client : Royal Bank Of Scotland
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Oct 2014 – Jan 2015
FIRST DTP (Interim solutions): DTP is to present downstream consumer applications in First with data sourced from ODC’s which is standardized, Traceable, Reconciled, Validated, Enriched and understood. Currently through Interim solutions one-off initial extracts of data from various source systems have been provided to business. The extracts are further profiled and analyzed by the business and data analysts.
Responsibilities:
· Based on the requests raised by Business, the data must be extracted from various source systems by developing new SQL scripts
· Scripts are tested and CRON tab will be scheduled to run the scripts before Business hours to pull in data.
· The output Data files created will be Connect directed to mainframe.
Environment:
PL SQL (DDL, DML and DCL), UNIX scripts, Oracle 11g
Company : Tata Consultancy Service
Duration : Mar 2013 – Jul 2013
Client : Royal Bank Of Scotland
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Mar 2013 – Jul 2013
CORNHILL: Financial planning uses a wide and diverse range of legacy systems to provide various business areas with MI and incentive data. Some are no longer fully supported and rely on manual intervention to keep the system operational. As the business had a conceptual obligation to migrate data from AVIVA to RBS there is an opportunity to simplify what data have been used.
It includes:
– Data migration (Preprocessing, Stage tables loading, Tactical tables loading, Postprocessing)
– ETL Flow (Data in flat files area loaded to Teradata tables)
– Error tables for reconciliation purpose.
Responsibilities:
· Developed ETL code for performing the Data migration and reconciliation.
· The Preprocessing code will fetch the Source files from AVIVA and place them in UNIX box.
· The data is then loaded into stage tables by performing all the required transformations.
· The tactical tables are loaded through Push Down Optimization Process.
· The Post processing is responsible for archiving the data files.
Environment:
ETL – Informatica 9.1, Teradata, UNIX
Company : Tata Consultancy Service
Duration : Sep 2012 – Feb 2013
Client : Cummins Inc
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Sep 2012 – Feb 2013
Business Intelligence Application Development: BI Application development team is responsible for developing application components for various source systems such as GOMS, NGMES, FAMTRACK, EPA etc.,
Responsibilities:
· Developed code for extracting, Transforming and loading data from Web applications to databases.
· Created UNIX scripts to trigger the ETL code in production.
Environment:
ETL – Informatica 9.1, Oracle, UNIX
Company : Tata Consultancy Service
Duration : Dec 2011 – Aug 2012
Client : Cummins Inc
Location : Chennai, Tamil Nadu, India
Position Held : Developer
Project Duration : Dec 2011 – Aug 2012
Business Intelligence Application Production Support: BI Application support was responsible for Monitoring various applications in production environment. Jobs will be triggered for loading data from front end web application into various databases after processing them into the business required formats. Data will be presented to business in the form of charts & reports. Issues that are raised by business regarding data and application unavailability will be solved within stipulated time periods.
Responsibilities:
· Supported as the primary resource for the applications Extended Coverage Warranty (ECW) & Forecast Analysis Monitoring & Tracking (FAMTrac)
· Supported critical application regarding Global Order Management System (GOMS) and Next Generation – Manufacturing Execution System (NGMES)
· Issues that are logged in by business were resolved immediately with best practices.
Environment:
ETL – Informatica 9.1, Oracle, UNIX, Business Objects, OBIEE
Company : Tata Consultancy Services
Duration : Aug 2011 – Nov 2011
Client : Tata Consultancy Services
Location : Chennai, Tamil Nadu, India
Position Held : Assistant System Engineer – Trainee
Project Duration : Aug 2011 – Nov 2011
Initial Learning Program (ILP): Joined Tata Consultancy Services as Assistant System Engineer – Trainee in 2011.
Responsibilities:
· Received training in Business Intelligence.
· Had hands on experience in ETL Tool – Informatica
· Learned Business Objects tool – BO & OBIEE
· Had Exposure to Oracle Database and schema.
Environment:
ETL – Informatica 9.1, Oracle, Business Objects, OBIEE
Education
· Bachelor of Science in Computer Science, Bharathiar University, India.
· Master of Science in Computer Science, Bharathiar University, India.