Teradata,Informatica,Oracle

Location:

Tampa, FL

Posted:

May 13, 2021

Contact this candidate

Resume:

Satyanarayana Sheri

Senior Teradata and ETL Developer

408-***-**** *****.*****@*****.***

Address : **** *********** ****, **** # ****, Tampa, Florida, 33647

Professional Summary:

Software consultant with more than 14 years of experience in IT Industry, of which 10 Years’ Experience in Data Warehouse experience in managing and Delivering projects using Teradata, Informatica Cloud and Power Center, Hadoop in modules likes Billing, Quoting, Ordering and Bookings, Internet Solutions, Retail and Marketing.

Extensive Experience in Develop, execute, and manage projects within the defined scope, timeline

Proficient in understanding business processes/ Functional requirements and translating them into technical requirements.

Functional knowledge on Retail, Internet, Quoting and Ordering and Bookings.

Experienced in working with Teradata ETL utilities like Fast Load, Multi Load, Tpump and Fast Export. Also, worked extensively on Teradata Query Submitting and processing tools like BTEQ and Teradata SQL Assistant.

In-depth knowledge of the Informatica Power Center, IICS, Teradata, Oracle, Postgress

Hands on Experience in Usage of Hive queries.

Hands on experience in Designing and Developing Informatica ETLs (workflows, Pushdown Optimization techniques, Performance tuning)

Proven technical skill set that has been demonstrated in the development of enterprise data warehouse

Have exceptionally good experience in trouble-shooting techniques, tuning SQL statements, Query Optimization, Join Indexes.

Basic working experience and Knowledge on Unix

Having Experience in Version Tools like PVCS, SVN, Clear Case, GITHUB.

Having Experience in Scheduling Tools like Dollar, Tidal, WLM, UC4.

Strong time management skills and multitasking abilities

Extensively involved in Data Extraction, Transformation and Loading (ETL process) from source to target systems using Power center.

Extracted source data from legacy system of flat files and moved into Oracle staging area, then transferred to Oracle using ETL/ELT process with various business rules, mappings, mapplets and transformations.

A result-oriented approach with a good proven track record with excellent interpersonal and good communication skills with proactive attitude and leadership qualities

Exceptional ability to learn new technologies and to deliver outputs in short deadlines.

Excellent interpersonal skills, ability to work well with others, in both supervisory or development and worked in onshore and offshore model.

Educational Qualification

M.Sc. Computer Science, June 2000. Kavita P.G. College, Kakatiya University, Khammam with an aggregate of 67%.

Technical Expertise:

Proficient with a vast array of programming languages, concepts, and technologies,

TD Utilities: TD SQL Assistant, BTEQ, Tpump, Fastload, FastExport, MultiLoad

ETL Tools: Informatica Power Center 10x, Cloud and Big Data Edition

Languages: Teradata SQL Assistant, SQL, PL/SQL, Oracle Apps, HIVE

Reporting Tools: Crystal Reports 8.5

Web Development Technologies: HTML, JavaScript, ASP.Net, VB.Net

Database: Teradata 16 and Oracle 11g, Postgress

Operating Systems: Windows and Unix

Versioning Tools: PVCS, SVN, Clear Case, GITHUB

Scheduling Tools: DollarU, WLM, and UC4, GITHUB, SVN

Project Summary:

Client: Verizon, Temple Terrace, Florida Aug’20 – till date

Role: Teradata Developer

Project name: RTM (Real Time Marketing)

Technologies: Teradata Utilities (TPT, MLOAD, BTEQ), SQL SERVER, POSTGRES, UNIX, GITHUB.

Description:

Verizon is one of the leading Internet and Mobile Service operators in the world with concentrated presence in USA. Telecom pass is a comprehensive Customer Care and Billing system for Telecom service providers.

The business requirements are for Verizon business metrics providing detailed requirements from the perspective of dashboard reporting, Business rules and counting logic, data source, and issues and gaps for the implementation of Telecom Services business metrics dashboard through

Performance Management portal. The requirements are captured and understood through business owners over the series of interactions and the dashboard Finalized with their help. The dashboard functionalities and usability aspects have been understood and all the requirements are captured to be Implemented over different cycles of development.

Roles & Responsibilities:

Used Load utilities (BTEQ, Molad, Fast Load, TPT) to load the data into Teradata

Tuned SQL statements, Query Optimization, and analysis in query performance issues in Teradata

Ingesting data from different sources, SQL SERVER, POSTGRES into Teradata.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Unix Scripts to check the File Validations.

Requirements analysis, data assessment, business process reengineering.

Interacted with business-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.

Project Summary:

Client: WellCare, Temple Terrace, Florida Jan’20 – Aug’20

Role: Informatica/Teradata Developer

Project name: Health Risk Assessment

Technologies: Informatica, Teradata, Oracle, GreenPlum, UNIX.

Description:

WellCare Health Plans, Inc. is an American health insurance company that provides managed care services primarily through Medicaid, Medicare Advantage and Medicare Prescription Drug plans for the members across the country. The current module HRA(Health Risk Assessment) is to get the information gather by the WellCare and external vendors to get the members health status check by frequently doing the HRA surveys and finding the health status and providing adequate information to the member to identify the potential health problems might occur in future. Periodically checking with the members on the clinical questions and audits on those surveys will make the system work more effective ways.

Roles & Responsibilities:

Requirements analysis, data assessment, business process reengineering.

Actively involved in analyzing, designing and development of the project.

Used Load utilities (BTEQ, Molad, Fast Load, TPT) to load the data into Teradata

Tuned SQL statements, Query Optimization, and analysis in query performance issues in Teradata

Ingesting data from different sources, SQL SERVER, POSTGRES into Teradata.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Unix Scripts to check the File Validations.

Project Summary:

Client: Verizon, Temple Terrace, Florida Sep’19 – Jan’20

Role: Teradata Developer

Project name: RCM/VBM Billing System

Technologies: Teradata Utilities (TPT, MLOAD, BTEQ), SQL SERVER, POSTGRES, UNIX, GITHUB.

Description:

Roles & Responsibilities:

Used Load utilities (BTEQ, Mload, Fast Load, TPT) to load the data into Teradata

Tuned SQL statements, Query Optimization, and analysis in query performance issues in Teradata

Ingesting data from different sources, SQL SERVER, POSTGRES into Teradata.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Unix Scripts to check the File Validations.

Requirements analysis, data assessment, business process reengineering.

Client: Comcast, West Chester Pennsylvania May ’17 – Sep ’19

Role: Senior ETL Developer

Project name: Sales Compensation

Technologies: Teradata, Informatica Power center, IICS, Big Data, UNIX, GITHUB.

Description:

National Sales project consumes the data from different sources like Info Quest, Shopper track and manual files from internal Comcast other areas, which provides the Commission and transaction information. The transaction covers Point of Sales information, Products sold by each representative from the different channels, such Direct, Indirect, Inbound, Outbound, Techno’s, Care, Branded Partner, and Xfinity Stores.

The calculation of commission for each Salesrep based on the products sold through different channels are accounted on daily basis and will be Loaded in the Semantic tables which will be used in displaying in the Dashboards via Reporting Tools like Salesforce and Tableau.

Responsibilities:

Requirements analysis, data assessment, business process reengineering.

Actively involved in analyzing, designing and development of the project.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.

Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.

UC4 to setup the Job Schedules. GITHUB portal for version control.

Unix Scripts to check the File Validations.

Client: Apple, Sunnyvale, California May ’16 – May ’17

Role: Systems Analyst

Project name: Cerebro

Technologies: Teradata, UNIX, SVN.

Description:

Cerebro project is a reporting solution to monitor the At-Home-Advisor (AHA) environment. Reporting activities aim to track the reason behind non-Apple related downtime. Non-apple related downtime is costing of thousands of dollars to Apple.

Metrics to be reported will be around VPN Session data.

Cerebro project also deals with the IVR Messages, as customers sends SMS to AppleCare toll-free number, Toll free number accepts the SMS and transfers request to Apple. Chat Session is initiated with the customer. SMS open from any device, Apple or non-Apple.

Metrics to be reported on the interaction details.

Responsibilities:

Requirements analysis, data assessment, business process reengineering.

Actively involved in analyzing, designing and development of the project.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.

Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.

Autosys to setup the Job Schedules. SVN portal for version control.

Unix Scripts to check the File Validations.

Client: Anthem, Richmond, Virginia Dec ’15 – Apr ‘16

Role: Senior Systems Analyst

Project name: Zip Code Decom & GBD Revenue Facets

Technologies: Teradata, Informatica, UNIX, WLM, Clear Case.

Description:

As part of this project, Source system is providing the Zip Code information file from OHIO server on monthly basis, EDWard systems needs to access the file on incremental basis and load the active Zip Code information in EDWard Systems by retaining the existing records and tagging it as in-active .

GBD Revenue Facets, is to integrate the Facets Revenue into EDWard. There is currently a gap for Facets data that needs to be remedied. Rather than sourcing Facets revenue directly from Central, Med-D and GBD Facets as is done with other source systems, it was deemed expedient to source from FIS.

This project is prompted by the need for all GBD Facets Medicare Supplement migration revenue to be integrated into EDWard. The Medicare Supplement members currently on ISG Broker, CS90, ACES, Central Facets, VA Corp will be migrated to GBD Faces system. Revenue data for these members will flow from GBD Faces to FIS and then to EDWard.

Responsibilities:

Requirements analysis, data assessment, business process reengineering.

Actively involved in analyzing, designing and development of the project.

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.

Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.

WLM to setup the Job Schedules, Clear Case portal for version control, Unix Scripts to check the File Validations.

Client: Cisco Systems Inc, San Jose, California May ’12– Dec’ 15

Role: Technical Lead

Project name: NCR NRT Bookings

Technologies: Teradata, Informatica, UNIX, DollarU, SVN.

Description:

As part of NCR/NRT Bookings project we are building Net change reporting capability in Teradata. Earlier we used to have this capability in ERP which used to happen using triggering events. Now ERP is migrating to Oracle R12 and ERP team wants to takeout NCR part from ERP which is the main reason behind it to build it in Teradata. Now we take the Sales Order, Sales Order Line and Sales Credit assignment data directly from ERP Oracle to Teradata using golden gate and thereafter we put all the NCR logic and process it till Teradata NCR table. As part of Teradata NCR we capture any change on Sales Order, Sales Order Line and Sales Credit assignment for NCR related attributes and keep the latest snapshot in our NCR table because we maintain the changes on day granularity.

Development starts using Informatica and SQL technologies based on the BRD provided by client. We are responsible for Development and do the Integration testing and will make sure that we meet our SLA when our jobs get executed in Production Environment.

Responsibilities:

Requirements analysis, data assessment, business process reengineering.

Involved in complete SDLC (System Development Life Cycle).

Researched Sources and identified necessary Business Components for Analysis.

Actively involved in analyzing, designing and development of the project.

Tuned SQL statements, Query Optimization, and analysis in query performance issues in Teradata

Proficient in understands Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.

Used Load utilities (BTEQ, Mload, and Fast Load) to load the data into Teradata.

Designed and developed Informatica Mappings and Sessions, Workflows based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Developed and scheduled Workflows using workflow designer, in Workflow manager and monitored the results in Workflow monitor.

Designed, developed, and documented the ETL processes using Informatica for extracting the data and data transformations.

Created mappings and applied transformations on the tables and created sessions for running the processes in Informatica.

$U design and development, Kintana, PVCS

Client: Cisco Systems Inc, Hyderabad, India Jun ’09 – Apr’ 12

Role: Team Lead

Project name: Quoting and Ordering

Description:

This application provided Cisco customers with the ability to generate quotes for Cisco products and convert the quotes into orders.

It enables easy, consistent, and secure creation and management of quotes. It supports both internal and external users. It provides streamlined processes for new, upgrade and renewal services

Estimate: Estimate provides faster results regarding Price, helps to quickly identify whether the service is available or not at a location with limited validations.

Quote: Checks for more Data inputs and lot more validations are Performed. When the User orders a quote, it gets converted into Service Contract which is legal Document between Cisco and Customer

CSCC Quoting & Ordering Application Interaction

CSCC Quoting & Ordering application interacts with various Engines to perform Validations and get the pricing information and other details.