Satheesh Adupa

Satheesh Adupa

Etl Developer

Followers of Satheesh Adupa118 followers
location of Satheesh AdupaBengaluru, Karnataka, India

Connect with Satheesh Adupa to Send Message

Connect

Connect with Satheesh Adupa to Send Message

Connect
  • Timeline

  • About me

    ETL DataStage Certified Solution Developer having 3.9 Years of experience with MCA currently living in Bengaluru

  • Education

    • Osmania University

      2007 - 2010
      Master’s Degree Master of Computer Applications 72
  • Experience

    • Infinite Computer Solutions

      Dec 2011 - Aug 2014
      Etl Developer

       Interact with client in order to understand the functionality and provide technical solutions.  Develop new job designs based on technical specifications provided by the client using DataStage 8.7 and DB2 9.7  Co-ordinate with QA and provide inputs in Integration Testing.  Used DataStage Designer to design DataStage jobs to extract, transform and load the data from source to target  Used DataStage Manager to export, import the Metadata of tables and DataStage jobs.  Used DataStage Director to run and monitor the jobs.  Designed various Job Sequences for the set of jobs developed.  Developed and executed the Unit Test Cases.  Scheduling ETL job flow in DataStage Director.  Prepared the ETL Specifications, ETL Manual Operations and Data Dictionary documents in implementing the changes. Show less

    • IBM India Private Limited

      Sept 2014 - now
      ETL Developer

      Working with the development team to build the change requests, from the business, on top of existing application.  Understood the client requirements by reviewing by the functional documents.  Analyze the Hyperion Interactive Reporting (Brio) files and converted the Hyperion Brio logic's to ETL.  Using Data Stage Designer to design Data Stage jobs to extract, transform and load the data from source to target.  Using Data Stage Designer to Export, Import the Data Stage Jobs and Metadata of tables.  Used the various Stages like copy, Modify, Lookup, Transformer, Sort, Funnel, Row/Column Generator, Join, Dataset, Merge, Aggregator, Sequential file, Remove duplicates and Surrogate Key Generator.  Using Data Stage Director to run and monitor the jobs.  Designed various Job Sequences for the set of jobs developed to send out email notifications to the team members.  Scheduled ETL jobs through Data Stage Director to run on Monthly basis.  Developed both parallel & server ETL jobs as per the requirements and automated them.  Read the unstructured data (Excel) with the implementation of new stage called Unstructured File stage in Data Stage Parallel jobs.  Implemented performance tuning options like Sparse Look-up, partition technique, and sorted data to joins, removing unnecessary columns and handling the nulls.  Error tracking and Error Monitoring using DS director.  Co-ordinate with QA and provide inputs in Integration Testing.  Develop and execute the Unit Test Cases.  Prepare the ETL Specifications, ETL Manual Operations and Data Dictionary documents while implementing the changes. Show less

  • Licenses & Certifications

    • IBM Certified Solution Developer InfoSphere DataStage v8.5

      IBM
      Oct 2012
  • Honors & Awards

    • Awarded to Satheesh Adupa
      IBM Manager's Choice Award 2015 - Put the Client First IBM India Private Limited Mar 2015 Put the Client First - IBM Manager's Choice Award 2015 - IBM Recognition for demonstrating IBM 1-3-9 practices
    • Awarded to Satheesh Adupa
      IBM Manager's Choice Award 2015 - Unite to Get it Done Now IBM Inida Private Limited Mar 2015 Unite to Get it Done Now - IBM Manager's Choice Award 2015 - IBM Recognition for demonstrating IBM 1-3-9 practices
    • Awarded to Satheesh Adupa
      Best Employee awards from IBM for managing project related activities IBM India Private Limited Oct 2014 Holds the distinction of receiving Best Employee awards from IBM for managing project related activities in 2014