Bc - Software Developer - Nagarabhavi, Bangalore, Karnataka, India

Kiran Bc

Nagarabhavi, Bangalore, Karnataka, India

Services

Software Developer

Summary:

Teradata Utilities(BTEQ<MLOAD,FASTLOAD,FASTEXPORT), Datawarehouse, Mainframes,Unix

Work History

Project Engineer

Tesco HSC Bangalore

From June 2013

Project Name: ODS Migration (June 2013-Current)
Tools: Teradata SQL Assistant, Mainframes
Database: Teradata 14, Teradata 12
Role: Project Engineer

Project Summary:
The Information Services team aims to replace the current ODS with Simpler Integration framework. Simple Integration is a strategic programme run by Integration services team to simplify the integration by defining repeatable patterns through TIBCO & Abinitio toolset. The repeatable patterns defined through this program will be used in ODS Migration project to replace the current complex logic with simple repeatable patterns.

For the Data warehouse what this means is the complex logic that used to be done at the ODS layer will need to be coded at the DW end as Integration services will pass the data from NBS to DW layer without applying any logic. The ODS Migration project is planned to be done in two phases with Simple Product being the first phase and the second phase is aimed at modifying Price, Promotion &Mixed Products using Simple Integration framework.

Responsibilities:
• Converted XML's which were generated by TIBCO tool into relational data format using STYLUS STUDIO.
• Developed Teradata SQL's that are given as process to us, like mapping the sources, creating appropriate stating tables and collecting statistics.
• Done extensive Unit and Performance testing.
• Developed Mainframe scripts to handle BTEQ scripts appropriately.
• Converted requirements to Design.


2.

Project Engineer

Tesco HSC Bangalore

May 2013 - June 2013

Project Name: Over stock and low stock investigation (May 2013-June 2013)
Tools: Teradata SQL Assistant, Mainframes
Database: Teradata 14
Role: Project Engineer

Project Summary:
Data from the existing versions of OSI (stock and reason) is extracted and merged with the new OSI (capacity) and transferred to the Data Warehouse daily, where it is used to produce a range of reports. This would enable the reports to show a complete picture of OSI.

The overstock Investigation process has been introduced to reduce the level of back stock in stores. The process involves investigation of every item of stock which does not fit on shelves and identification of the root cause.

Responsibilities:
• Developed Teradata SQLs that are given as process to us, like mapping the sources, creating appropriate stating tables and collecting statistics.
• Done extensive Unit and Performance testing.
• Developed Mainframe scripts to handle BTEQ scripts appropriately.
• Converted requirements to Design.


3.

Project Engineer

Tesco HSC Bangalore

January 2013 - April 2013

Project Name: Space range and merchandising (Jan 2013-April 2013)
Tools: Teradata SQL Assistant, Mainframes
Database: Teradata 12
Role: Project Engineer

Project Summary:
The Source team would have developed a new planning system to determine how stores should be equipped and how this layout should change over time.

The project requires the new planning data to be loaded to data warehouse maintaining the layouts with appropriate versions and the reports to be based on that.

Responsibilities:
• Understand the requirement from the client and then explaining the same to sub-ordinates.
• Developed Teradata SQLs that are given as process to us, like mapping the sources, creating appropriate stating tables and collecting statistics.
• Done extensive Unit and Performance testing.
• Developed Mainframe scripts to handle BTEQ scripts appropriately.


4.

Project Engineer

Tesco HSC Bangalore

October 2012 - December 2012

Project Name: Resource reclaims (Oct 2012-Dec 2012)
Tools: Teradata SQL Assistant, Mainframes
Database: Teradata 12
Role: Project Engineer

Project Summary:
To reclaim resources on Teradata box by dropping or purging the tables and fine tuning some of the badly written queries.

Responsibilities:
• Unused and bigger tables are identified; the unused tables are dropped and the huge tables are purged by retaining required history in it.
• High CPU consuming queries are identified and are finely tuned.
• The tables with high Skew factors have been identified and the proper combination of primary index has been identified to reduce the skew ness.
• Compression of huge tables.


5.

Project Engineer

Tesco HSC Bangalore

June 2012 - September 2012

Project Name: Increasing area price codes (June 2012-Sep 2012)
Tools: Teradata SQL Assistant, Mainframes
Database: Teradata 12
Role: Project Engineer

Project Summary:
Earlier there were only six area price codes for all the stores; this project was to increase the area price codes from six to ninety nine.

Responsibilities:
• Understand the requirement from the client and then explaining the same to sub-ordinates.
• Developed Teradata SQLs that are given as process to us, like mapping the sources, creating appropriate stating tables and collecting statistics.
• Done extensive Unit and Performance testing.
• Developed Mainframe scripts to handle BTEQ scripts appropriately.

6.

Associate Project Engineer

Tesco HSC Bangalore

November 2011 - May 2012

Project Name: Unica Campaign Management (Nov 2011-May 2012)
Tools: Teradata SQL Assistant, Mainframes, UNIX
Database: Teradata 12
Role: Associate Project Engineer

Project Summary:
The Unica Campaign Management project will deploy a single campaign management system for use by both Tesco and dunnhumby to drive increased customer and business benefits.

The Unica solution will enhance the existing end-to-end campaign process across the Tesco Group, starting with Dotcom, who manage emails and dunnhumby (Clubcard/Local campaigns) who manage direct (paper to postal address) mails.

Responsibilities:
• Writing SQL Codes to get data
• Format them as per the requirements
• Organizing weekly meetings for improving the process
• Brainstorming with the onsite people to make the requirements clear

Qualifications & Certifications

BE

Sapthagiri College of Engineering

PUC

K.L.E PU college

Vijaya High School

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more


Are you sure that you want to leave?