EXPERIENCE SUMMARY:

• 11.5 years of IT experience specializing in Data warehousing and Business Intelligence which includes 4 years of Onsite experience in USA
• Proficient in Informatica 9.x Administration and Development
• Good Working knowledge on the Integration tools like SnapLogic, Oracle Warehouse Builder
• Built SnapLogic Pipelines to ingest data from variety of sources such as Oracle, S3 & SFTP etc.
• Have Good Experience in Enterprise Data Lake (EDL) Big Data Integration Projects using SnapLogic
• Knowledge on Hadoop ecosystems like HDFS, MapReduce, YARN, Hive, Impala etc.
• 4 years of Experience in Data Center Migration Projects (Informatica & Oracle Warehouse Builder)
• Sound Knowledge SQL, PL/SQL, Oracle Performance Tuning and Oracle 10g Architecture
• Has wide range of experience in AVM, Development, Data Center migration and Platform Upgrade projects.
• Completed certifications in Cloudera Hadoop, Oracle 9i & Informatica PowerCenter
• Experience in domains like Discovery, Drug Development, Financial Management, Supply Chain Management etc.
• Excellent analytical, debugging and problem solving skills with ability to work efficiently in both independent and team environments

TECHNICAL SKILLS:

Hardware / Platforms: Red Hat Enterprise Linux, AIX, Windows XP/2000, Sun Solaris

Technology: SnapLogic, Informatica Power Center 8x&9x, SQL, Oracle Warehouse Builder, Unix Shell Scripting, Cloudera Hadoop Concepts, HDFS, MapReduce, YARN

Programming Languages: PL/SQL

Databases: Apache Hive, Impala, Oracle 10g RAC, Netezza Performance Server

Scripting Languages: Unix Shell Scripting

Version Control Systems: Borland StarTeam

PROFESSIONAL EXPERIENCE:

Confidential

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

SnapLogic Architect

Role and Responsibilities:

• SnapLogic Architect for the Confidential&Confidential to EDL Integration Project
• Participate in Design and Architecture review sessions with Amgen Data Architects
• Create User stories of the Sprints and review with Product Owners
• Review requirements and seek clarity as required, work with Amgen Architect to make any design improvements and refinements as needed
• Work with EDL & SnapLogic admins to setup environments in SnapLogic & EDL
• Design re - usable SnapLogic Pipelines to ingest data from Oracle DB and, SFTP filesystems
• Develop SnapLogic Pipelines to ingest 100 Million Plus records from Oracle Database
• Conduct Sprint Review & Demo sessions with clients
• Develop Pipelines based on Shrading mechanism to ingest big tables from Oracle
• Use SnapLogic best practices to tweak the performance of PipeLines
• Effectively use Snaps Like “Hive Execute”, “Pipeline Execute” within Pipelines to call child pipelines (Code re-usability)

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

Architect

Role and Responsibilities:

• Attend Data Center Migration Deep dive meetings and provide solution architecture and guidance on the Informatica Migration standards to the clients and other stakeholders
• Perform Informatica Technical Impact assessment on the ETL Applications that will be migrated from existing data center (Confidential, Confidential etc.) to the USLV data center.
• Responsible for Informatica Platform related tasks of all categories of Data center optimization project viz. Application upgrade, Technical upgrade, Meets standards and Decommission.
• Install Informatica software in USLV servers and resolve any issues encountered during Installation.
• Perform the Migration pre-requisites like Unix folder creation, connectivity check, folder contents copy, SFTP setup, Relation connection creation/update, Integration service creation, ODBC configuration file update etc. in USLV Informatica platform prior to the migration.
• Migrate the Informatica objects from USTO/USWA data center to USLV data center during the migration window.
• Responsible for resolving Informatica Platform issues encountered during migration and guide the application team if code remediation is required.
• Lead the migration activities related to Informatica.
• Strictly adhere to the Amgen Change Management Process for the activities related to Informatica platform.
• Co-ordinate with UNIX System Admin, Oracle DBA, Storage team and Informatica Vendor as required.
• Setup Informatica DR environment using technologies like Zerto Virtual Replication, Snap Mirror & Data Guard by working cohesively with various infrastructure teams
• Effectively communicate the status to DCO project managers, system owner and other stake holders during all stages of the migration.

Confidential

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

 Architect

Role and Responsibilities:

• Responsible for analyzing 100+ files (Excel/Flat files) from over 10 different source systems across 3 sectors and converting it in to standard Format that can be loaded by Informatica
• Developed Informatica components (Mappings & Workflows) to load 100+ source files in to Teradata.
• Loaded the 100+ source files successfully into Teradata without any rejections
• Responsible for normalizing and harmonizing the transactional and master data
• Created and Mapped five Views in Teradata for the analysis of five KPIs namely Backorder, Customer orders, Forecast & Demand, Inventory and Plan Attainment
• Worked closely with Business Team to identify and resolve the data gaps/issues.

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

 Architect

Role and Responsibilities:

• Responsible for performing detailed impact assessment of FinD and OPAL suite of applications
• Involved in planning phase of Migration, which comprised of 34 servers with a mixture operating system like AIX, Windows, and Linux etc and formulated the optimal migration plan for each server.
• Responsible for key migration project deliverables like Migration approach, Risk assessment, Migration checklist, test approach and cutover document.
• Provided technical consultation on installation and configuring applications (Informatica, BO and OWB) in new data center
• Co-ordinate with various suppliers and teams which ensured smooth migration with minimal downtime
• Provided well organized “cutover” plan with granular level of tasks which in turn ensured smooth switch over to new environment.
• Involved in creating effective test strategy documents to test the applications post migration.

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

Architect

Role and Responsibilities;

• Involved in analysis, design and implementation phase of OPAL Datawarehouse
• Interacted with the business users on regular basis to consolidate and analyze the requirements and present them the design results.
• Involved in reviewing OPAL DWH solution blueprint along with AstraZeneca architects
• Provided technical consultation on installation and configuration of Informatica PowerCenter on multiple nodes
• Responsible for the preparation of Installation document, Deployment Document System Operating Procedure Manual and Support document
• Streamlined and fine tuned Finance related ETL jobs by implementing advanced features like Oracle Analytical functions, partition exchange loading and optimizer hints.
• Designed and implemented inventive utilities (ETL job monitoring, job failure alerts) for easing PowerCenter maintenance.

Confidential

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

Architect

Role and Responsibilities:

• Confidential Appadurai was responsible for performing detailed and exhaustive evaluation of PowerCenter Platform in order to finalize the best and optimal upgrade path.
• He also shouldered overall responsibilities to setup upgrade project plan, plan the outage periods, co-ordinate and communicate with multiple stake holders involved in the engagement. He effectively led and managed a group of team to perform various administration activities like installation, configuration and migration of PowerCenter software on multiple servers.
• He was also involved in creating effective test strategy documents and effectively executed the test cases after the upgrade.
• He developed a level of competency, which help to anticipate issues and solve them in advance.
• He was also responsible for reviewing and validating the Informatica mappings, UNIX shell scripts, Oracle PLSQL procedures created by team members and make sure that they adhere to business requirements and also ensuring that they follow best practices.

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

Technical Lead

Role and Responsibilities:

• Confidential Appadurai was responsible to perform the analysis for various enhancements, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• He was also involved in middleware administration, Application development and maintenance space.
• He was responsible for Preparation of Low Level Design documentation. He was responsible for Designing and developing Informatica Mappings and Unix Shell Scripts as per business requirements.
• He has also worked Informatica global support in order to resolve the product bugs and failures. He is also responsible for Informatica PowerCenter platform maintenance and management.
• He was involved in preparation of System Operating Procedure Manual, Deployment Document and Support document preparation. He was responsible for Imparting domain and technical knowledge to the new entrants and also fellow team members.
• He was responsible for ensuring top quality deliverables from Cognizant to client and collection of project metrics. He was involved in Production Implementation of the code. He was responsible for Post Release Support and Coordinating with the onsite team.

Confidential

Tools :Oracle 10g RAC, Informatica PowerCenter 8.5.1, Oracle Warehouse Builder 10gR2, Business Objects, Spotfire

Team Member

Role and Responsibilities:

• Confidential Appadurai was a part of ETL core team. His primary responsibilities were
• Resolving tickets and ad-hoc requests raised by business users.
• He has also worked on Change requests/Enhancements for new business requirements.
• He was involved in preparation of System Operating Procedure Manual, Deployment Document and Support document preparation.
• He was responsible for developing mappings, creating unit test cases, conducting unit tests. He was involved in resolving Application errors which are encountered in daily batch jobs.
• He was responsible for optimizing the worst performing OWB Mappings and re-designing the poorly performing OWB mappings.
• He was also responsible for ensuring top quality deliverables from Cognizant to client and collection of project metrics. His responsibilities include onsite/client coordination.