SUMMARY

• 5 months of work experience in supporting partners integrated with Reserve with Google and Onboard new partners to Reserve with Google Platform
• Expertise in resolving technical issues faced by partners with a minimal turn - around time
• Provided assistance for new End-to-End integration and Starter integration partners to onboard Reserve with Google Platform by guiding through each step and assisting with the blockages in their process of integration
• Played vital role in setting up and training the team in India
• Assisted management in effectively calculating the metrics
• Created the documentation on Training Modules and resolving common issues in Partner Support process
• Excellent inter-personal and communication skills with flexibility to learn emerging/latest technologies
• 4 years of expertise in DataStage with special emphasis on Design, Development, documentation and implementation of Data Warehousing / Client-Server solutions in Banking
• Worked extensively in analysis, design and development of various applications using DataStage, Oracle, DB2 and UNIX environments
• Expertise in DataStage Administration activities like installations on server, user creations, permissions, assigning roles, DataStage health check activities, migrations and maintenance of DataStage environments.
• Strong analytical, presentation, problem solving and Team Player with effective communication
• Extensive documentation and reporting skills
• Experience in Database programming, creating data warehouses using IBM DataStage versions 11.7/11.5/11.3/8.7/8.5 using components like Administrator, Designer & Director
• Coded Shell Scripts for performing DataStage upgrade activities and automation on various flavors of UNIX
• Expertise in ETL - Extracting, Transforming of data from multiple sources & Loading data into a Data Warehouse
• Involved in identification of Facts, Measures and Dimensions
• Worked on HA Cluster mechanism and GRID topology.
• Strong Knowledge on DataStage Administrational activities like installations on server and user creations, permissions, assigning roles, DataStage health check activities.
• Maintenance of all the DataStage environments. (Development to Production Servers)
• Involved in Performance tuning of DataStage Server.
• Tuning Workload Manager Queues (9.1.2V, 11.7V), which improves DataStage Performance.
• Part of Performance & Capacity team which looks after CPU Utilization and workload of DataStage Server.
• Successfully completed fix-pack upgrade & enhancement of 100+ DataStage projects to Infosphere 9.1 to 11.5.0.2.
• Basic knowledge and experience in Hadoop Architecture and various daemons such as Name Node, Data Node, Secondary Name Node, Resource Manager, Node Manager and High Availability.
• Implemented automation techniques/scripts for smooth functioning on Infosphere 11.5 Platform.
• Experience in UDeploy for DataStage projects deployment automation in higher environments.
• Team player with effective communication and interpersonal skills.
• Experience on Job Scheduling tool - Autosys, Crontab entries

TECHNICAL SKILLS

Programming Language: SQL, PL/SQL, PLX, UNIX shell scripting, C, C++, Java, HTML

ETL Tools: DataStage v 11.7/11.5/11.3/8.7/8.5

RDBMS Tools: TOAD 8.5/ 8.0, SQL*Plus

Databases: DB2 LUW 11.1/10.5, Oracle 11g/10g, SQL Server

Operating Systems: Windows 10, Windows 7, Windows XP, Windows 2000, UNIX(CentOS, Debian)

Documentation: Microsoft Office Suite, GSuite Tools

PROFESSIONAL EXPERIENCE

Confidential

Engineer - Product Support

Responsibilities:

• Supporting more than 100 partners hosted on Reserve with Google Platform
• Resolving the technical issues associated with Reserve a Table/Schedule Appointment/Buy Tickets on merchants' Google page
• Ensuring Partners' integration is healthy and assisting them in lowering the error rates
• Ensuring all the partners abide by the vertical specific policies outlined by Reserve with Google
• Expanding/Launching partners to new countries by evaluating the merchants
• Supporting partners to upgrade their integration from V0, V2 to V3
• Evaluate upcoming partners' eligibility to integrate with Reserve with Google
• Update and create documentation accordingly
• Setup the account for new partners implementing End-to-End integration or Starter Integration on Reserve with Google
• Monitor partner's integration health(using Google's tools) and guide through the steps to onboard
• Perform Bi-Weekly check-in for partner's progress and moving through the integration by sending the detailed steps at every stage
• Resolve the issues faced by partner in the process of integration
• Evaluate the merchants provided by partner
• Test the functionality of partner's integration in Sandbox environment
• Validate integration in Production environment
• Launch the partner and monitor partner's health before handing over to Partner Support
• Update and create documentation as and when process is changed/new process is created
• Effectively communicate with various teams for smooth onboarding of partners

Emvironment: Google specific internal tools: Tomo, Buganizer, Critique, QASA, Cider, Partner Portal, MadData, MadOps, Indigestion, Alkali Console and Xenon, Unix, SQL

Confidential, Charlotte NC

ETL DataStage Developer & Admin

Responsibilities:

• Supporting 6 platforms which has around 300+ servers and 1000+ projects
• Project Creation in all environments from Development to Production
• Having experience in GRID technology, which uses LSF & LL as load levelling concepts
• Users creation and assigning required roles in all environments
• Configuration of different Database connections like Oracle, SQL, Netezza, Teradata
• DataStage Server Stopping & Starting, along with WAS Services
• Debugging and resolving all DataStage related issues like login, permission & Project Corruption etc.
• Clearing all locks in DataStage & UNIX/LINUX, as well Clearing Zombie/Defunct Processes
• Code deployments to higher environments using Client tool, istool utility and through Jenkins tool
• Experience in platform upgrade process from V9.1 to V11.5. Worked on migrating the entire project code from DataStage v9.1 to DataStage v11.3 and v11.5.
• Health Check activities on different environments
• Filesystem monitoring and maintenance
• Patch & Drivers Installation
• Maintaining 300+ DataStage Servers
• Experience in Incident Management, Problem Management & Change Management through Remedy
• Assisting the Developers/ Production Support Team in DataStage issues
• Troubleshooting the Issues in Data Stage Environment with housekeeping and cleanup of dumps to improve performance
• Experience in connecting with Vendor and providing required logs(IBM, for raising Case and Oracle, for raising SR)
• Efficiently handle documentation and reporting(graphs)