RAMESH VELAUTHEM

ac1wbm@r.postjobfree.com

201-***-****

SUMMARY

• Over 6 years of professional experience in ETL Administration Lead, Design Architect, Oracle Database Administration and Autosys Administrator of Data warehouse systems.

• 2+ Years Architect experience in ETL Environment setup standalone and clusters

• More than 6 years of primary experience in ETL Informatica (PC, PWX and IDQ) cluster installation, configurations including DR setup

• Good Experience in SFDC Real-time CDC using Informatica

• Very good Knowledge in Informatica PWX CDC for mainframe datasets

• Over 2 years of professional experience in DB Administration with RAC and Standalone setup.

• Good experience in oracle golden gate installation, configuration, extract, pump and replicating Oracle and MSSQL tables.

• Almost 3 years of experience in Autosys and its product installation and configuration.

• Good Knowledge in Red-Hat UNIX Platform OS Support.

• Having good knowledge (Just 1-year experience) in Google Could Management (Billing, GCS, Bigquery, Compute Engine, Networking and CloudSQL).

• Strong knowledge in ILM Installation and Configuration.

• Proficient of doing automation in Informatica, Oracle 12c and Autosys administration related activities.

• Unbeatable knowledge in UNIX Shell Script.

• Ultimate knowledge in Java for desktop & web related applications.

• Building own file transfer tools (Using Java and UNIX shell scripting) for organization level complex file transfer architectures and needs of business

• Good operating knowledge in Jira and Bitbucket tools

• Outstanding project managing power within multi-vendor engagement.

• Well organized power within the organization of various product licenses.

• Positive to learn and adapt to new technologies. Best example Google Cloud Platform implemented for our EDW solutions for our various projects recently. TECHNICAL SKILLS

Metrics Value

Technology Informatica, Oracle, Google Cloud, Autosys and Java Platforms UNIX Red-Hat 6.9 & 7.2, Windows Server 2012 & 2016 datacenter Edition, MAC OS X Captain and AIX 7

Databases Oracle, MS SQL Server and MYSQL

Query Languages SQL, PL/SQL

Tools VMWare, Bitbucket, HP ALM, SQL Server Management studio, Visio, Lucid chat and ServiceNow

Office Tools MS Office and Google Docs

Programming Languages Java and Python

Scripting/Client Languages SQL, PL/SQL, UNIX shell scripting, HTML, JQuery, AJAX and XML Data Modeling Tools Visio and Lucid chart

Certifications ü Oracle Certified Associate by Oracle Corporation ü Informatica certified developer by Informatica corporation ü Cognizant Certified professional in Informatica Powercenter Developer issued by Cognizant Technology solutions ü Cognizant Certified professional in DW issued by Cognizant Technology solutions

Awards ü Best Associate of the year (AOY) of 2013 across global Cognizant ü Rewards and Recognition (R&R) award for the years 2011, 2012, 2013, 2014 and 2015

ü Above & Beyond award at 2017

PROJECT OVERVIEW

PEARSON Sep 2015 – Till Date

Role: Team Lead, Senior ETL Administrator and ETL Architect Team Size: 5

Location: Onshore - United States of America

DESCRIPTION OF THE PROJECT:

Pearson is the world's largest education company, with more than 40,000 employees in more than 70 countries helping people of all ages to make measurable progress in their lives. They are providing a range of education products and services to institutions, governments and direct to individual learners that help people everywhere aim higher and fulfill their true potential

The ultimate aim of this project is to provide the ETL Informatica service and infrastructure across global Pearson network for various projects and centralize the ETL Informatica platforms as a single point to make it available for all ETL Informatica developers and business users across regions.

ROLES AND RESPONSIBILITIES:

§ Defining new architecture, infrastructure design for Informatica, Autosys and Oracle DB environments

§ ETL Informatica Admin related activities

§ New installation and configurations of Informatica 10.1 in Red-Hat Linux

§ Configure Informatica cluster

§ Create various services

§ Coordinate with F5 configuration to setup LB for IDQ web services.

§ Upgrade Informatica from 9.6.1 HF4 to 10.1

§ Upgrade Informatica from 9.1 to 9.6.1 HF4

§ Project level administration activities like folder create, assigning permission, deployments and connection creation

§ Backup repositories, domain and restore them

§ Purging old versions for the repositories which is enabled version.

§ Applying patches (SFDC, Powerexchange cloud connectors and EBF’s)

§ LDAP setup and synchronization for Informatica and Autosys

§ Oracle DBA activities (DEV, QA complete setup and maintenance of Oracle 12c with RAC. PROD coordinating with Global DBA)

§ Adding tablespace, backup DB, purging redo logs and restore DB

§ Red-Hat OS Monthly Patching

§ UNIX Admin Support

§ Coordinate with network team for the network related activities (Adding NIC Ethernet, VIP, Load balancing etc.)

§ Storage allocation for each project

§ Autosys (WAAE, EEM and WCC) Complete setup and Administration

§ Scheduling jobs

§ Supporting on demand job running for production control

§ Coordinating with CA technologies for any new upgrade, patches and bugs related to autosys and its products

§ Working with Oracle my support for any patches, bugs and technical issues

§ Working with Firewall team for any firewall request, either ETL, Autosys, Oracle ESB, SFTP and FTP (Both Internal and External) standard and non-standard ports

§ Complete administration of Google cloud (New project setup, Billing, New bucket creation, Assigning roles and responsibilities)

§ Google BigQuery related administration (New dataset creation, deployments, automation, security updates)

§ Installing Google Cloud, Bigquery related utilities on UNIX servers for ETL applications

§ ILM Administration

§ Talend ETL environment setup, administration and deployments

§ Oracle weblogic service setup and configuration

§ Managing various licenses Informatica (Powercenter, IDQ, Address doctor and PWX CDC), Oracle and Autosys

§ Coordinating with Informatica Support team to identify what are the license can be reused or for any improvement

§ Convert AIX utilities to Red-hat UNIX utilities for various projects (When we upgrade Informatica 9.1 to 9.6 the 9.1 was running under AIX so the conversion was needed)

§ Required DB client’s installation (Oracle, Sybase, DB2, Teradata clients for Native and ODBC setup)

Continues Improvement (Innovation and Cost savings for client)

§ Developed/Improving OWN file transfer (FTP over SSL, FTP, SFTP, CIFS, SMP) Utility for all projects

§ Complete setup and replication coding’s in Oracle Golden Gate.

§ Developed Java base solution for Extracting/Loading MYSQL data for RAG and TEP projects.

§ Developed common Scripting solutions for PGP Encryption/Decryption.

§ Filemaker DB (Apples subsidy) data extraction solution using Informatica.

§ Identified the MS Office subscription for each user and re-used the remaining licenses for Windows servers.

§ Built a 24 x 7 team covering all time zones across global. Environment: Informatica 10.1, 9.6.1 HF4, Oracle 12 GRID, Sybase IQ, SQL Server, MYSQL, Google Cloud, Bigquery, Service-Now, ILM, Talend, Oracle 12c Weblogic, Bitbucket and Jira Univision Communication Inc. Feb 2015 - Aug 2015

Role: ETL Administrator and SFDC CDC developer

Team Size: 7

Location: Offshore - India

DESCRIPTION OF THE PROJECT

Univision is an American Spanish language broadcast television network that is owned by Univision Communications. The network's programming is aimed at Hispanic Americans in the United States. Its programming includes telenovelas and other drama series, sports, sitcoms, reality and variety series, news programming, and imported Spanish-language feature films. It has the largest audience of Spanish-language television viewers in the world, according to Nielsen Media Research..

The objective of project is to generate Data Integration and Reporting sales metrics (# 13 Reports) such as core and non-core revenue at near real-time (depending on technical limitations).

Capture and report on sales metrics such as core and non-core revenue. Core Revenue represents expected recurring year-over-year revenue. Non-core revenue represents incremental revenue attributed to non-recurring events (e.g. World Cup, Gold Cup). Improve reporting performance, obtaining near real-time data (depending on technical limitations) The reporting solution is expected to be implemented as an EDW solution by leveraging Teradata, Informatica, and Business objects as the technology stack. ROLES AND RESPONSIBILITIES:

§ ETL Informatica environment setup of QA, UAT and PROD phases

§ Setup and Configured PowerExchange connector and connections for salesforce in real time

§ Code migration across various environments.

§ Involved with requirements gathering, design, development and testing phases

§ CDC for Real time capturing the data from Salesforce to Teradata staging

§ Hyper care support of Production for 4 weeks both administration and development support

Environment: Informatica 9.5 HF3, Teradata 14.0 & SFDC cloud winter 2015 Dun & Bradstreet June 2011 - Jan 2015

Role: ETL Admin

Team Size: 3

Location: Offshore - India

DESCRIPTION OF THE PROJECT

Dun & Bradstreet, Inc. is an American business services company headquartered in Short Hills, a community in Millburn, New Jersey that provides commercial data to businesses on credit history, business-to-business sales and marketing, counterparty risk exposure, supply chain management, lead scoring and social identity matching. Often referred to as D&B, the company’s database contains information on more than 235 million companies across 200 countries worldwide. Dun & Bradstreet has been listed on the Fortune 500 and was one of the first companies to be publicly traded on the New York Stock Exchange. DUNS is the common unique identification number for each business in the world. The ETL Administration and Standardization Team (EAST) defines, communicates and manages standards and governance of all D&B Informatica activity and provides a stable, reliable, shared and reusable environment. Support includes environment and licensing management; guidance to project teams on functionality and project feasibility; governance review from inception through design and deployment.

ROLES AND RESPONSIBILITIES:

§ Develop and schedule Informatica Jobs for ETL Admin Related Activities

§ Installation and configuration of Informatica Server / its related components (PC, PWX and HF’s)

§ Supporting to 19 ETL applications

§ Database Client Configuration for various databases such as Oracle, Teradata, MYSQL, Sybase etc.

§ Message Queue Configuration (JNDI & JMS)

§ PowerExchange configuration for Mainframe

§ SFTP / FTP Configuration in across UNIX Environment

§ SCP configuration across various Environments

§ User Management for Informatica Environment

§ Data Map Migration across Environment.

§ Data Map Creations

§ Providing Root Cause Analysis (RCA) for any Sev1/2 issue to business

§ Providing On call 24*7 support for Sev1/2 issue

§ Code Migration across various environments.

§ Automated Informatica Folder copy using Scripts

§ Automated Health Check for ETL servers using Scripts

§ Setup Maintenance Jobs for startup, shutdown, backup, purge, Space usage alert

§ Code Review for Production release

§ Interact with network, database, and UNIX administrators to implement Informatica infrastructure and troubleshoot issues

§ Mentored and groomed fresher for admin activity

§ License Management

§ Coordinating with Informatica for various Issues

§ Promote ETL Best practices and educate ETL developers on those practices

§ Have worked on POC’s like Custom transformation, Extracting Data from Social Media Websites, B2B Parser Transformation, Sybase isql editor Environment: Informatica 8.6.0 HF13, 9.5, UNIX Red-Hat 5.9, Oracle 11g, Git, Source Tree and Jira

EDUCATION

MCA (Master of Computer Applications), University of Madras, India.

Contact this candidate