Ranjan Patra

Application Development Specialist

Hyderabad, Telangana, India

Summary
Teradata SQL Optimizations Designs Reporting ETL Data Warehousing
Specialties: Big Data, Teradata, Data Stage (ETL Tool), Microstrategy, Oracle 9i, LINUX
Experience

Manager IT at GAP Inc

Dec 2017 - Present

Application Development Team Lead at Accenture

Aug 2015 - Nov 2017

Navistar is a leading manufacturer of commercial trucks, buses, defense vehicles and engines. Navistar International Corporation is an American holding company that owns the manufacturer of International brand commercial trucks, MaxxForce brand diesel engines, IC Bus school and commercial buses, Workhorse brand chassis for motor homes and step vans, and is a private label designer and manufacturer of diesel engines for the pickup truck, van, hoes and SUV markets. The company is also a provider of truck and diesel engine parts and service. Conflate provides the complete BI solution for Finance and Invoice management to the Corporation. Conflate process sale and order invoice data received from plants and dealers and provides decision making reports for the organization. Role and Responsibilities:As a BI Architect/Developer: Extensively work on planning for implementation of hdfs for bigdata. Migrated Legacy applications to Big Data technologies as POC. Applications running on SQL server and Informix data base converted to Bigdata using hdfs, Datastage and hive. Proposed and implemented Data as Service to allow user flexible data analysis. Successfully upgraded Datastage and Teradata tools without any post implementation failures. Leverage visualization experience to migrate reports on chart to more understandable format. Trimmed current application and Phased out applications to reduce infrastructure cost and improve productivity. Proactively used design thinking to make support highly valuable and growth oriented. Manage to reduce high severity incidents by 80% with help of automation. Automate current manual activities, and stream line process for better execution. Preparation of Audit and Process related architecture for providing efficient audit and logging capabilities. Initiative to asset creation made the project process dependent rather than person dependent.

Project Lead at iGate

Jan 2011 - Jun 2015

Involved in Initial requirement gathering phase, ETL Design work, Preparation of ETL High and Low Level Design and mapping documents. Involved in Logical design model & Physical design model meetings to understand type of data, different source systems, Report requirements, ad-hoc query frequencies. Preparation of Audit and Process related architecture for providing efficient audit and logging capabilities. Involved in the process for identifying and finalizing the various source file formats and frequencies from different source systems. Identifying dependencies among and across the system for setting the proper execution order and trigger time of Datastage Jobs. Coding of UNIX Shell scripts and Teradata BTEQs for the Audit Balance and Control process to allow efficient logging of process execution, encountered errors and to provide restart ability of the process. Understanding the business requirements of the systems. Achieved complex user requirements utilizing various stages of Datastage. Designing Datastage jobs to achieve maximum efficiency. Development of complex Datastage Sequencers for integration of different jobs and audit processes. Development of TERADATA BTEQ, MLOAD and FLOAD scripts to load data into the Data Warehouse. Implemented Multi source technology. Responsible for Problem Management. Job distribution among the team members. Single point of contact for any kind of ETL related query of testing team and support team.

Sr. Software Engineer at Patni Computer Systems

Jul 2009 - Apr 2011

Understanding the business requirements of the systems. Achieved complex user requirements utilizing various stages of Datastage. Designing Datastage jobs to achieve maximum efficiency. Development of complex Datastage Sequencers for integration of different jobs and audit processes. Development of TERADATA BTEQ, MLOAD and FLOAD scripts to load data into the Data Warehouse. Responsible for overseeing the Quality procedures.

Developer at Mahindra Satyam

Jul 2006 - Jul 2009

Develop new DataStage ETL jobs and update existing Jobs as per change requests given by clients. Development of DataStage ETL Parallel Jobs to extract data from heterogeneous source systems, cleansing/validating, transformations according to business rules and load in to the Data Warehouse. Update existing jobs for better performance by changing stages with more appropriate stages like replacing Teradata API stage with either Teradata EE stage or Teradata Mload stage based on the requirement. Develop UNIX shell scripts and Perl scripts for Process Control System and triggering Datastage jobs with proper indentation. Develop Teradata BTEQ, FastLoad and Mload scripts as per the business logic with proper indentation. Prepare documents like ETL Design documents, IAS documents, IR documents for change requests.

image/svg+xml
Push pixels...
Shovel coal into server...
Create mockups...
Defend the wall...
Draft storyboard...
Disrupt an industry...
Achieve profitability...
Become a unicorn...
Become Batman...