Summary
Overview
Work History
Education
Skills
Mailing Address
Personal Email
Personal Information
Timeline
Generic

Srinivas Gadde

Senior Consultant
Rajahmundry

Summary

Having 18+ Years of experience in IT industry of which 9 years in the area of data warehousing as an Informatica/ Cognos/DataStage/Tableau/Pentaho/Alteryx/AWS-Glue Administrator and 3 years in the area of Informatica Development. Develop best practices for developing and deploying ETL applications and assist the team to manage compliance to the standards Automations worked: Repository/Domain backup, Purge Process, Audit, Upgrade Process, Installation along with Post build tasks, Operational Resiliency, Disaster recovery for High Availability of at least one single node to avoid application impact, Annual Password reset on principle account, Deployment tasks are also automated. Participated in multiple Informatica (IPC, IDQ, PWX) Cognos, DataStage, Pentaho POC to evaluate different architectures, tools and vendor products. Writing batch scripts for Cognos services restarts Using Informatica scheduler including 3rd party scheduler like Control M. Installations and upgrades including Hotfixes and EBF’s on Informatica, Cognos, DataStage, Pentaho, Tableau Analysis and troubleshooting on long running jobs and issues Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player. Received CIO and Employee of the Month Awards from Client and also many spot awards from current organization for outstanding performance in Deliverables/Automation initiatives.

Overview

17
17
years of professional experience
2000
2000
years of post-secondary education

Work History

Senior Consultant

Atos Syntel Inc
01.2011 - Current
  • Company Overview: Syntel is a multinational provider of integrated technology and business services, specializing in IT services and consulting
  • Educating the team on what the requirement is and making sure all access is available for them to start work
  • Involved in Management work for Technical Reports, Monthly Report, Governance Reports
  • Worked on upgrading Informatica, DataStage, Cognos, Pentaho and performed all the testing required for a smooth repository flow
  • Communicating with the customer team if we have any issue at hand that needs to be fixed immediately
  • Always on call if any tables fail and no one is available to help get the issue resolved before it gets escalated to another level
  • Working with the Informatica, Cognos, Tableau, Pentaho, DataStage Administration to provide access to users to do their daily projects
  • Working on repositories that break down, doing a refresh of the current data and doing a 'start and stop' of the repository
  • Tickets are sent by a system called ServiceNow for proper documentation of all work done for each group so as to charge the client appropriately
  • UNIX log-in using the 'super user'(SU) to log-in and work on servers and do refresh and migrations needed for continuous improvement
  • Installation and environment build in Informatica, Cognos, DataStage, Tableau & Pentaho
  • Syntel is a multinational provider of integrated technology and business services, specializing in IT services and consulting
  • Installation, Build, Health Monitoring, Deployments, troubleshooting, Patching, EBF setup and vulnerability management
  • Automation with shell scripting and Ansible Playbooks
  • Managing all the SOPS and KEDBs in Confluence
  • Cataloging DB2 database in ETL Servers
  • Clean scratch disks
  • Connection creation
  • Copy file/dataset from one Linux server location to another Linux server location
  • DataStage User - Daily Termination Report Check and Update
  • Deleting Dataset after confirmation
  • Disabling/Enabling DataStage/Informatica Web Services & Stopping/Starting ratings Job in BFM Environment
  • Execute ETL Job and/or Linux shell scripts from respective DataStage Linux Server in sequence provided by DEV team
  • Folder/Project creation
  • Provide the requested Logs/Files to the User
  • Purge ETL Job log file (from TCL prompt)
  • Troubleshooting user issues arising in Informatica/DataStage tools in server & client
  • Unlocking user session/s in a server
  • Setup Environmental Variables, User defined variables
  • Upgrade Sybase Interfaces file
  • Modify apt file
  • Environment Build and Support

Analyst Programmer (DataStage Infra Support)

American Express
01.2010 - 01.2011
  • Company Overview: American Express Company (AmEx), is a diversified global financial services company headquartered in New York City
  • Founded in 1850, company is best known for its credit card, charge card, and traveler's cheque businesses
  • Administering Projects, Roles, user, privileges across all 3 Environments across on all three products(Data stage/IA/BG)
  • Monitoring DS Engine Performance across all 3 Environments and taking necessary actions in case of File system /Permission issues
  • Addressing Individual / Group requests from all 4 Application Teams, across all Three Environments (7 Engine Servers & 6 Citrix Servers)
  • DataStage code Migration Requests across E1, E2, E3 Environments
  • File/Dataset Migration requests across the Environments
  • Resolving individual adhoc requests (with respect to Job aborts/Scripts)
  • Addressing issues/requests from Application teams with answers for queries
  • Frequent (DataStage/Unix) health checkups across E1/E2/E3 Environments
  • Resolving IMR’S(Incident Management Record) transferred from various Application Teams related to CITRIX and DataStage Environment slow down
  • Coordinating with all Different groups in case of any issue with respect to DOMAIN/ENGINES and X-META
  • Performing Incremental Code backup across all DataStage projects on E1 Environments and weekly backups of all DataStage Projects across all 3 environments
  • Execution of Application jobs as part of the Soft launch(pre-production)
  • Coordinating with Onsite team in case of patch/versions upgrade activities across Environments
  • Guiding/supporting application team in terms of implementation of DataStage Best practices while code development process by being proactive
  • Involved in unit, performance, Regression and integration testing of data stage jobs and prepared Documentation
  • Resolved issues occurred during regular testing
  • Shell Scripts to run data stage jobs
  • Developing Shell scripts to automate file manipulation and data loading procedures
  • American Express Company (AmEx), is a diversified global financial services company headquartered in New York City
  • Founded in 1850, company is best known for its credit card, charge card, and traveler's cheque businesses

DataStage Developer and Infra Support

Limited Brands
01.2009 - 01.2010
  • Company Overview: Limited Brands considered one of the 'World’s Most Admired Companies' in the retail industry
  • The Insight project integrates data from multiple operational platforms into a single Enterprise Warehouse
  • Administering Projects, Roles, user, privileges across all Environments across on Data stage
  • Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement
  • Used Data Stage as an ETL tool to extract data from sources systems, aggregate the data and load into the DB2 database
  • Implemented multi and fast load methods for loading of data
  • Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements
  • Implemented table partitions for parallel load processing
  • Involved in defining technical and functional specifications for ETL process
  • Used both Pipeline and Partition Parallelism for improving performance
  • Extensive use of Control M for job scheduling
  • Used lookup stage with reference to Oracle tables for insert/update strategy and updating of slowly changing dimensions
  • Involved in performance tuning of the ETL process and performed the data warehouse testing
  • Limited Brands considered one of the 'World’s Most Admired Companies' in the retail industry
  • The Insight project integrates data from multiple operational platforms into a single Enterprise Warehouse

Data Stage Developer

Merrill Lynch
01.2008 - 01.2009
  • Company Overview: Merrill Lynch is one of the world's leading financial management and advisory companies, with offices in 36 countries and private client assets of approximately $1.1 trillion
  • Involved in creating entity relational and dimensional relational data models using Data modeling tool
  • Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage
  • Mapping Data Items from Source Systems to the Target System
  • Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
  • Worked on programs for scheduling Data loading and transformations using Data Stage
  • Designing and Developing PL/SQL Procedures, functions, and packages to create Summary tables
  • Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions
  • Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
  • Developing Shell Scripts to automate file manipulation and data loading procedures
  • Merrill Lynch is one of the world's leading financial management and advisory companies, with offices in 36 countries and private client assets of approximately $1.1 trillion

Education

Bachelor of Engineering - Electronics & Instrumentation

Vijayanagara Engineering College

Skills

  • Informatica IPC

  • Informatica IDQ

  • Informatica PWX

  • DataStage

  • Alteryx

  • Pentaho

  • AWS Glue

  • Cognos

  • Tableau Server

Mailing Address

D.no:6-76, Thorredu, Rajanagaram, Andhra Pradesh, 500029, India

Personal Email

gadde999@gmail.com

Personal Information

  • Passport Number: H9065025
  • Date of Birth: 02/28/77
  • Gender: Male
  • Nationality: Indian

Timeline

Senior Consultant

Atos Syntel Inc
01.2011 - Current

Analyst Programmer (DataStage Infra Support)

American Express
01.2010 - 01.2011

DataStage Developer and Infra Support

Limited Brands
01.2009 - 01.2010

Data Stage Developer

Merrill Lynch
01.2008 - 01.2009

Bachelor of Engineering - Electronics & Instrumentation

Vijayanagara Engineering College

Similar Profiles

CREATE PROFILE
Srinivas GaddeSenior Consultant