NARESH GUDLA
(Teradata Technical Lead - 9+ Years’ Experience)
Flat No# 502, Shivam’s Mansarovar Apt, Madinaguda, Hyderabad...
PROFESSIONAL EXPERIENCE
Organization: Infosys Technologies Limited
Role: Technology Lead
Duration: Dec 2005 to date. (9+ Y...
Responsibilities
• Interact with Business analyst and translate the business requirements into technical
Specification doc...
Responsibilities
• Provided production support by monitoring the processes running daily.
• Conversion of manual reports t...
of 4

Naresh_Final

Published on: Mar 3, 2016
Source: www.slideshare.net


Transcripts - Naresh_Final

  • 1. NARESH GUDLA (Teradata Technical Lead - 9+ Years’ Experience) Flat No# 502, Shivam’s Mansarovar Apt, Madinaguda, Hyderabad-500049 Contact: +91-7093001757, E-Mail: nareshg635@gmail.com PROFILE 9+ years of experience in IT at various locations like United States and India in multiple roles such as Data Warehouse Consultant and Programmer/Application Analyst.  Well experienced professional in analysis, developing and maintaining OLTP and OLAP applications based on DB2, Oracle and Teradata with Retail domain of Logistics and CPG.  Core Competency in Database query tuning, Performance tuning of Reports.  Proficient in team management, project management methodologies, SDLC.  Effective interpersonal communication with customers at client locations (USA), peers and management at all levels in and outside the organization.  A dedicated, diligent, confident team player capable of handling multiple assignments simultaneously.  Good ability to anticipate issues and formulate remedial actions. CORE COMPETENCIES Requirement Analysis ~ Development ~Team Management~ Delivery Management ~ Review ~Client Coordination ~ SDLC TECHNICAL SKILLS Database Oracle, Teradata Database 13i, DB2, Informix, MySQL, SQL Server 2008/2005, MS-Access2000 Languages COBOL’s, PL/SQL, SQL, JCL, CICS Tools/Utilities/IDE Cognos, Mload, Bteq, Fast load, Fast export, Explain, Plan, Runstats Scheduler CA7, Autosys Design, Data Modeling MS Visio Operating systems DOS, Windows NT/XP/Vista, UNIX, MVS Bug trackers HP Quality Center Version control systems VSS
  • 2. PROFESSIONAL EXPERIENCE Organization: Infosys Technologies Limited Role: Technology Lead Duration: Dec 2005 to date. (9+ Years) Location: Hyderabad, Bentonville/Portland (USA) EDUCATION Bachelor of Engineering in Mechanical Engineering Utkal University/Bhubaneswar PROJECTS Project Name Global Footwear/Supply Planning Client Nike, Inc. Role in Project Technology Lead Duration of Project Nov-2013 to till date Project Description NIKE, Inc. is the world’s leading innovator in athletic footwear, apparel, equipment and accessories. The project work involves development/maintenance/supporting of PL/SQL jobs .User acceptance testing and Post Production Support. Responsibilities • Gathered Requirements and coordinated with various departments to assure satisfactory data content, quality, data integrity and receipt of desired information. • Identified and documented business requirements, prepared Functional Specs. by working with members of the business and IT teams • QA testing, Writing Test cases and Conducted UAT (User acceptance testing) • Ensure all the planning systems are running properly. • Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, DB links and privileges. • Carry out Defect Analysis and fixing of bugs raised by the Users Project Name Data Warehousing and Data Administration Client Wal-Mart Stores, Inc. Duration of Project Jan-2009 to Oct-2013 Role in Project Technology Analyst and Technology Lead Project Description Wal-Mart Stores, Inc. (NYSE: WMT) is an American public corporation, and is currently the world's largest retailer and the largest corporation. The project work involves Development of new JCL’s, Copybooks, SQL Modules to extract the data files from UNIX and load to Teradata Tables, Creation of new ETL Jobs. Unit, System and Integration Testing of Mainframe and ETL Jobs to ensure loading of data into Teradata Tables. User acceptance testing and Post Production Support.
  • 3. Responsibilities • Interact with Business analyst and translate the business requirements into technical Specification document • Managed and Deployed a Data Warehousing. • Created ETL process flow Scripts and work with Developers to automate data extraction. • QA testing, Writing Test cases and Conducted UAT (User acceptance testing) • Well experienced in data migration of Teradata boxes and other data conversion • Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse • Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities. Project Name RWT (Replenishment Workload Tool) Client Target Technology Services Role in Project Senior Software Engineer Duration of Project Aug-08 to Dec-08 Project Description The Replenishment Workload Tool (RWT) is the logistics reporting application. The reports like Auto fill Workload Summary, System Generated CAF Summary, and Price Change Management reports, and new goal reports for grocery trailers will be available through RWT. The goal calculations and database updates are done in MF which will be shown to the user using the Java reports. Responsibilities • Supervised, monitored and participated in the development, maintenance and implementation of reports. • Managed and lead a small team to ensure that assignments are delivered with high quality and within the stipulated timeline. • Modified COBOL programs to support goal calculations and database updates for the java reports. • Proficient in writing Stored Procedures using PLSQL and providing • Created an online inventory Tool using REXX for all the Applications in the mainframe. • Created an Excel macro which will create automatic Balancing reports and send to the business user. Project Name TMCI (Target Multi channel integration) Client Target Technology Services Role in Project Senior Software Engineer Duration of Project Feb-08 to July-08 Project Description TMCI is a project which includes providing accurate, similar information to the team member or guest related to any item sold at Target stores or on web at any point of time. TMCI enables target team members or guests to search for the item related information like price, location in the store, availability in this store else in closest 10 stores, availability on target.com etc.
  • 4. Responsibilities • Provided production support by monitoring the processes running daily. • Conversion of manual reports to automated documents. • Walked through the Logical Data Models of all source systems for data quality analysis • Performed data analysis of the source data coming from legacy systems. • Participated in the audits for security roles and access. • Contributed in Project Requirement Analysis meetings with the onsite team. Coordinated with the testing team for QA testing. Project Name DFD (Dedicated Food Distribution) Client Target Technology Services Role in Project Software Engineer Duration of Project Dec-06 to Jan-08 Project Description This project involves enhancements and additions to a Food Online Order Guide application, which will be used to request food from a wholesaler or regional distribution center. This project enables the stores to get better information about the items they need to order resulting in better orders, locate items in a store, and pull items from warehouse. Responsibilities • Analyze, code, unit, system, integration and regression test a variety of application programs developed for the project. • Assist with Developing test scripts for system and integration testing. • Good experience with relational databases DB2 to compute the calculations involved by writing DB2 store procedures. • Coordinated with the client team during production moves and supported. • Coordinated with the testing team for QA testing. Project Name FOCUS – Freight Online Control and Update System Client DHL International. Role in Project Software Engineer Duration of Project Dec-05 to Nov-06 Project Description DHL had acquired Airborne in U.S.A and Infosys was entrusted with the enhancement, maintenance and support for the airborne group of applications. The applications were a performance intensive real time data capture system with millions of transactions per day. Responsibilities • Coordinated with the testing team for QA testing. • Analysis and development of enhancement requests. • Worked on Production fixes. • Created test cases and recorded test results for new/enhanced requests. • Prepared the HLD and LLDs for all the functional requirements. • Worked on new requests that involved new online programs that coordinates with front end and retrieves data from DB2.

Related Documents