Denodo Developer
Suresh

Professional Summary

More than 9 years of experience, primarily in the field of Data Warehousing for Designing, Development, Administration and Support of various systems for Business Intelligence. As part of my career, I was involving in Requirement Analysis, Designing, Quality Reviews and Testing along with Production Support. I also have good experience in the Agile Methodology and effective communication and mentoring skills.

  • 8+ years of experience primary in Data Warehousing/Integration using ETL Tool Informatica PowerCenter 8.x/9.x.
  • Extensive hands-on expertise in administering Oracle database and Informatica PowerCenter
  • Expertise in Informatica ETL development using SQL Server, Oracle and Teradata Databases.
  • Expertise in Data Virtualization using Denodo, designing and developing OLTP system and GUI.
  • Good knowledge of Data warehousing Concepts.
  • Experience in UNIX and data modeling.
  • Expertise in PL/SQL and hands on using BTEQ and Utilities for Teradata.
  • Good knowledge in Software Development Life Cycle Process and Agile Methodology.
  • Possesses excellent interpersonal communication skills, functional and technical documentation skills.

Technical Skills

ETL Tools
Informatica PowerCenter 9.5/9.1/9.0/8.6/8.1, Power Exchange 9.0.0 Informatica MDM
Database
SQL Server 2008/2005, Oracle 11g/10g/9i, Teradata
Development Tools
SQL Developer, Workbench, Toad, Teradata SQL Assistant
Languages
SQL, PL/SQL , VB.Net, VB, C#
Web Technologies
ASP.Net, Web Services
Reporting Tools
Cognos, Microstrategy
Other Tools & Technologies
salesforce.com, ER/Studio, Denodo 5/4.7, Teradata Utilities, Visual Studio, Visual Source Safe, Quality Center, JIRA, Version One

Education

  • MS in Computer Applications

Professional Experience

American Automobile Association NCNU, US
Project
AAA CLUB - ETL/DW/MDM
Duration
January 2014 - till date
Role
Team Lead, Secondary Administrator
Responsibilities
AAA Northern California, Nevada and Utah (AAA NCNU), formerly known as the California State Automobile Association (CSAA), is one of the largest motor clubs in the American Automobile Association (AAA) National Federation and serves members in Northern California, Nevada, and Utah.

The project is to design, develop and maintain the systems required for integrated data store for operational and Business requirements.

  • Interacting with client to understand the requirements and distributing the work to offshore team.
  • Participate in Scrum meetings and the actively involved in all activities including deployment and initial code support.
  • High level ETL design, Review the low level design, Unit Testing Strategy etc.
  • Supporting the SIT and UAT activities.
  • Extensively used Informatica 8x ETL tool for data transfers from Legacy systems to Oracle warehouse.
  • Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).
  • Worked closely with project management and assisted in ensuring timely and effective implementation.
  • Created the test cases and assisted in UAT testing.
  • Actively participated in code reviewing and assists to ensure developers follow the IHA standards. Provide quality reviews for the work of other team members when required.
  • Work with other team members to transition application technical knowledge for cross-training.
  • Communicate and coordinate vendor and third-party consultant interactions.
  • Identify opportunities to improve processes and cost effectiveness.
Tools
Informatica PowerCenter 9.5.1, Denodo 5/4.7, Oracle 11g, SQL Server 2008, salesforce.com, ER/Studio
Pfizer, New Jersey
Project
Decision Support System
Duration
March 2011 - Dec 2014
Role
Project Lead, Technical Architect
Responsibilities
DSS is pharmaceutical company has remained dedicated to discovering and developing new, and better, ways to prevent and treat disease and improve the health and quality of life for people around the world. From the miracle of penicillin to patient assistance programs like MAINTAIN that help people without prescription coverage have access to important medications, we focus on meeting the world’s diverse health needs. DSS used to provide reporting on inventory stock out and other supply chain information by using the process of phases Manual Global supply chain and Automated supply chain. Data from various source systems are loaded using Informatica Tool. Reporting is done through Micro strategy.

  • Coordinating with Onsite PM and understanding the requirements and distributing the work to offshore team
  • Designing the ETL Architecture and load strategy
  • Review the ETL Design, Unit Testing Strategy etc.
  • Supporting the SIT and UAT activities
Tools
Informatica 9.0, Oracle, Power Exchange 9.0.0
Cisco Systems, US
Project
Global Site Information Management
Duration
March 2009 – March 2011
Role
Senior ETL Developer & Administrator
Responsibilities
Global Site Information Management (GSIM) is a crucial tool for safety and security department which maintains the security devices of Cisco campuses all over the world and also provides features to plan for upcoming sites. GSIM Provides access to Site contact information, Lenel Devices information (AttD), live video and CAD drawings.

WPR's vision is to create innovative work & risk solutions enabling Cisco to protect, optimize and grow its resources and respect the environment. These solutions increase productivity, improve employee satisfaction, and showcase Cisco technology. WPR's global functions include acquisition & disposition of real estate, employee services, global workplace planning & construction. DIAD, SIM, AST, PICTURE CHECKER, VRT, PDMT, RAART, ePAF, MyWpr Expenses, SH, EDT, Allocations are some of the important applications of WPR project.

  • Understanding the client requirements and prepare understanding and design documents
  • Reviewing the understanding and design document with DA and finalise the design.
  • Coding and Unit testing.
  • Interact with onsite counterpart and plan activities
  • Manage and allocate tasks for the team members
  • Document and upload the various artifacts required for process related audits.
Tools
Informatica 8.6, Oracle, VSS, Quality Center
Cisco Systems, US.
Project
Bedrock
Duration
April 2008 – March 2009
Role
Module Lead
Responsibilities
The client for the project is Cisco Systems Inc., one of the Global market Leaders in manufacturing of network equipments. Cisco maintains its own data warehouse. The source system for Expense track is undergoing changes and this project is to address those changes in EDW data warehouse. There will be few structural changes and changes in data and the whole history data needs to be reloaded to the tables. We are writing PL/SQL procedures to re-load all history data with the changed ERP structure in Oracle. We are also creating BTEQ scripts and Informatica ETLs for loading history data in Teradata. Similar changes are also being done to the incremental ETLs.

  • Understanding the changes and design documents and developing the code based on it.
  • Gathering requirements and functional knowledge from Onsite and updating the work status.
  • Developing ETL objects, Database objects.
  • Maintaining design documents, Business Requirement documents and uploading to Cisco's Live link for easy sharing and maintenance
  • Adherence to Quality procedures as per Cisco's IT standards
  • Prepare the Test cases for the Unit testing.
  • Conducting impact analysis for the changes suggested by the clients
  • Coding based on the Specifications provided by the Client and according to the checklist.
  • Testing application (includes the Unit Testing and Pre Integration Testing).
  • Reviewing the work done
  • Reconciling the data and identifying any data-issues including Known Issues and fixing it.
Tools
Informatica 8.1.1, Toad, $Universe, Oracle, Teradata, Bteq
Cisco Systems, US
Project
EDW2B
Duration
March 2007 – April 2008
Role
Track Lead
Responsibilities
The client for the project is Cisco Systems Inc., one of the Global market Leaders in manufacturing of network equipments. Cisco maintains its own data warehouse. The project is EDW2B CQA Support, which involves the Testing and Quality Assurance for the migration of current data warehouse from Oracle to Teradata. It is a pre-production activity involving testing the code and data of the subject areas that come under EDW (Enterprise Data Warehouse) like Bookings, Revenue, Expense, Customer Services etc. Main activities are writing and executing the test cases for each and every mapping, table and the column that related to the project or CR. Testing includes Functional testing, Load testing, Performance testing, data quality assurance and support for User / Business Acceptance Testing. Testing also includes scheduling and executing the jobs using scheduling tool called Dollar Universe.

  • Planning the offshore activities, timelines, daily deliverables etc.
  • Interacting with client regarding requirements and attend LDM/PDM review meetings.
  • Analyzing and understanding the functional, data and other testing requirements.
  • Coordinating the work with offshore counterparts.
  • Code reviews for production fixes
  • Supporting IT / Business team for User / Business Acceptance Testing.
Tools
Informatica 8.1.1, Toad, Teradata Manager, Teradata SQL Assistant, Quality Centre, Kintana, Dollar Universe, Oracle 9i, Teradata, Business Objects
Cisco Systems, US
Project
EDW2B
Duration
June 2006 – March 2007
Role
Team Member
Responsibilities
The client for the project is Cisco Systems Inc., one of the Global market Leaders in manufacturing of network equipments. Cisco maintains its own data warehouse. The project is EDW2B CQA Support, which involves the Testing and Quality Assurance for the migration of current data warehouse from Oracle to Teradata. It is a pre-production activity involving testing the code and data of the subject areas that come under EDW (Enterprise Data Warehouse) like Bookings, Revenue, Expense, Customer Services etc. Main activities are writing and executing the test cases for each and every mapping, table and the column that related to the project or CR. Testing includes Functional testing, Load testing, Performance testing, data quality. Testing also includes scheduling and executing the jobs using scheduling tool called Dollar Universe.

  • Understanding Business requirement and various product line installations.
  • Understanding Installation, Configuration and Administration of Informatica PowerCenter
  • Involved Migration of Informatica version
  • Developing Informatica mappings and writing queries and BTEQ scripts in Teradata.
  • Scheduling, running the jobs, monitoring and checking the data and logs.
  • Interacting and coordinating with Onsite counterpart.
  • Doing code reviews for the code changes
  • Creating design and other related documents
  • Taking care of all In-cycle and Out of cycle Change Requests.
  • Performance testing.
Tools
Informatica 8.1.1, Toad, Teradata Manager, Teradata SQL Assistant, Quality Centre, Kintana, Dollar Universe, Oracle 9i, Teradata