OBJECTIVE

• To provide effective IT services/solutions and to ensure business continuity, utilizing my analytical and technical expertise. To explore new challenges and technologies and constantly upgrade my skill sets.

SUMMARY

• Core experience in Administration part of ETL tools like Ab - Initio (10.7 years) & Informatica (2.5 years). dis involves various tasks like server software installations/version upgrade, creating project structures, configure & manage various environments, managing AbInitio server & user licenses, Technical Repository operational management - maintenance and backup of EME/Informatica Repository & restore, starting/shutting down Bridge/Reporter/Web Services/EME/Informatica Services, creating multi-file systems & data areas, creating services in Informatica admin console, capacity planning, HA/DR planning, code promotion, Integrate various AbInitio products with Authorization Gateway and in turn with LDAP/AD, co-ordinate with A>me/Informatica support for debugging issues, troubleshooting issues faced by DEV/Test or Support teams, etc.
• Experience in full life cycle Data warehousing Projects which include Requirement gathering, Analysis, Design, Development, Unit testing, UA testing, Release, Implementation and Support.
• Creating & managing Informatica Repository Service and configuring various Informatica services in admin console like - Power Exchange, Rule Point, B2B, Information Lifecycle Management (ILM), Informatica Data Quality (IDQ), Metadata Manager (MM), etc.
• Providing enterprise wise solution for HA/DR and capacity planning for entire ETL estate (Ab-Initio + Informatica).
• Create the MPP/SMP architecture, review with client and recommend the best solution.
• Extensive experience in interaction with business users for gathering the business requirements and functional specifications.
• Excellent communication and analytical skills and expertise in Domain knowledge.
• Has been extensively trained in Ab-Initio Administration, Informatica Administration, product development methodologies-Development models, High Level Design (HLD) development processes and SDLC implementation procedures.
• Has worked extensively in Administration, Development and Enhancement Projects of data warehousing environment - Project implementation life cycle, troubleshooting, root cause analysis and issue resolution, automation, enhancements, upgrades, migration, problem management and maintenance of Data Warehousing applications and tools.
• Has worked in both OLAP and OLTP environments.
• Conversant with ISO 9001 quality procedures.
• Experienced in Mentoring and grooming resources for work force creation.
• Strong Analytical, problem solving and organizational skills.

TECHNICAL SKILLS

Operating System: Unix, Linux, Windows.

Tools: Ab-Initio, Informatica, Oracle SQL-Developer, Toad, TWS (Tivoli), Autosys, Service Now.

Database: Oracle 10g, SQL Server, DB2.

Internet Tools: Basic HTML

Languages: Unix Shell Scripting, PL/SQL Programming.

Other: Service Now, Rally.

PROFESSIONAL EXPERIENCE

Confidential

Lead administrator

Responsibilities:

• Installation of Ab-Initio software on all the ETL servers.
• Involved in deciding the EME Project structures for New Projects.
• Create and maintain the EME and the branches in EME.
• Create the new project structures in the EME and new application setup on ETL servers.
• Request/Apply and maintain the Ab-Initio Key for GDE/Express>IT and ETL servers.
• EME operational management (starting/ shutting down EME's, EME backup).
• Create the data areas (Serial and MFS) for the projects.
• Centralized capacity planning for the Ab-Initio infrastructure, server resources and SAN storage.
• Providing operational metrics for the environment.
• Provide the CPU/SAN uplift requirements on a server for the projects depending on the volume and scale of the project.
• Live proving the workloads/servers after any reboot or maintenance activity done by UNIX/LINUX admin team from Ab-Initio perspective.
• Help developers in resolving Ab Initio configuration issues; if required contact AbInitio Support and get the issues resolved.
• Communicating environment outages.
• Guiding development team on best practices & Development standards as per AbInitio CoE standards.
• Highlighting issues that might come in production and getting them fixed by concerned teams.
• Lead and mentor a team of 4 ETL Administrators (3 offshore/1 onshore).

Confidential

Lead administrator

Responsibilities:

• Create & Design AbInitio Architecture and review with Infrastructure team.
• Capacity planning & providing the server specs for TUCO ETL servers.
• Install & configure Ab Initio product suite (Co-ops, App-Hub, Express>IT, Control Center, Authorization Gateway etc.) to all servers.
• Create Technical Repository (EME) for version control of Ab Initio code and create Project structure in it.
• Co-ordinate with Chicago & Colombia Infrastructure/Network teams to accomplish various infrastructure related tasks, open ports and allow access through firewalls.
• Configuration and Integration of various Ab Initio Products like Control Center, Express>IT & Authorization Gateway with LDAP/Active Directory (AD) to integrate user autantication process.
• Interacting with client for gathering the business requirements and functional specifications.
• Requirement Analysis and lead ETL Development team using Ab Initio Data Management Framework (DMF) with GDE & Express>IT.
• UNIX Shell Scripting and Ab Initio code defect fixing.
• Internal code review and provide solutions to optimize performance of code.
• Supervising and Mentoring a Team of 5 Associates at Offshore and Technical up skilling of the team members.
• Process documentation and resource forecasting.
• Control Center job creation for scheduling the jobs in different environment.
• ETL Process improvement planning, Process optimization and re-engineering.

Confidential

Lead administrator

Responsibilities:

• Create import feed in Metadata Hub for extracting the data in the required formats.
• Import the data from various data warehouse tables in Metadata Hub.
• Create Data Quality rules to check following dimensions:
• Completeness.
• Uniqueness.
• Timeliness.
• Validity.
• Accuracy.
• Consistency.
• Write & Execute the DQ rules in Express>IT (BRE) to analyse the data quality.
• Inform development team to correct the existing data issues in the data warehouse & retest it after the fix is applied.
• Create & send the DQ report to Data Quality lead to analyse.

Confidential

Project Lead

Responsibilities:

• Interacting with client for gathering the business requirements and functional specifications.
• Requirement Analysis and ETL Development using AbInitio.
• UNIX Shell Scripting and Ab-Initio code defect fixing.
• Code Review and provide solutions to optimize performance of code.
• Supervising and Mentoring a Team of 5 Associates at Offshore and Technical up skilling of team members.
• Process documentation and resource forecasting.
• Autosys job creation for scheduling the jobs in different environment.
• ETL Process improvement planning, Process optimization and re-engineering.
• Creating Technical POC for new applications.

Confidential

Project Lead

Responsibilities:

• Interacting with client for gathering the business requirements and functional specifications.
• Requirement Analysis and ETL Development using AbInitio.
• UNIX Shell Scripting and Ab-Initio code defect fixing.
• Provide Emergency break fix for ETL code in Production.
• Supervising and Mentoring a Team of 7 Associates and Technical up skilling of the team members.
• Process documentation and resource forecasting.
• Tivoli job creation for scheduling the production jobs.
• Code Review, ETL Process improvement planning, Process optimization and re-engineering.
• Creating Technical POC for new applications.

Confidential

Ab-Initio Administrator

Responsibilities:

• Installation of Ab-Initio software on all the ETL servers.
• Involved in deciding the EME Project structures for New Projects.
• Create and maintain the EME and the branches in EME.
• Create the new project structures in the EME and new application setup on ETL servers.
• Request/Apply and maintain the Ab-Initio Key from Ab-Initio Corporation for GDE and ETL servers.
• EME User Security (control permissions for developers and testers on Ab-Initio based applications).
• EME operational management (starting/ shutting down EME's, EME backup/restore.
• Create the data areas (Serial and MFS) for the projects.
• Owning and setting up groups, IDs and permissions of EME and file system.
• Setting up remote connectivity between two workloads/servers for reading/publishing files on/from remote server.
• Centralized capacity planning for the Ab-Initio software, server resources and SAN storage.
• Providing operational metrics for the environment.
• Plan and coordinate code migration to higher environments.
• Provide the CPU/SAN uplift requirements on a server for the projects depending on the volume and scale of the project.
• Live proving the workloads/servers after any reboot or maintenance activity done by UNIX/LINUX admin team from Ab-Initio perspective.
• Help developers in resolving Ab Initio configuration issues; if required contact AbInitio Support and get the issues resolved.
• Communicating environment outages.
• Guiding development team on best practices & Development standards as per AbInitio CoE standards.
• Highlighting issues that might come in production and getting them fixed by concerned teams.

Confidential

ETL (Ab Initio and Informatica) Administrator

Responsibilities:

• Installation of Ab-Initio/Informatica software on all the ETL servers.
• Request/Apply and maintain the Ab-Initio and Informatica licences.
• Create users and groups for Ab Initio and Informatica and assign roles and privileges to it.
• Create and manage project level and individual folders in EME and Informatica Repository service manager.
• Communicating environment outages.
• Install/Upgrade/Configure/Maintain Informatica Power Center 9.1.0 HF4/HF6 and 9.5.1 multiple instances on Linux servers.
• Install/Configure/support various software like Power Exchange for JMS/Web-Services/Mainframe/Oracle, Informatica Data Quality (IDQ), Information Lifecycle Management (ILM), B2B DT/DX, ISC, Rulepoint, Metadata Manager and others as required.
• Has implemented High Availability (HA)/Failover/Grid and DR configuration and has good understanding of these concepts.
• Configure Database connections and ODBC connectivity to various source/target databases.
• Interact with UNIX and DBA teams to create and maintain Power Center instance.
• Provide Informatica Infrastructure support including security administration and patching, etc.
• Understand and manage capacity planning for entire ETL estate.
• Manage and administer system performance including on-going optimization and tuning of Informatica environment.
• Interact with end users to resolve/halp in issues with Informatica Power Center/related database/servers/storage.
• Perform code deployment between different environments and debug any deployment issues.
• Setup the environment and Deploy new Informatica projects on the Shared Platform.
• Perform complex troubleshooting, root-cause analysis and solution design.
• Work with Business Analyst and users to clarify requirements and translate the requirement into technical specifications.
• Create various Informatica services in Admin console.
• Helping Development teams to migrate their code from Ab-Initio to Informatica.
• Preparation of process documents and user guidelines for Informatica.
• Preparation of Informatica FAQ’s, Development standards and request FAQ’s.

Confidential

Responsibilities:

• Creating Ab Initio graphs & Unix Scripts for execution.
• Interacting with client for gathering the business requirements and functional specifications through the SAS codes, requirement documents provided by the business users and by arranging calls with the client specific team.
• Understand the design requirements, create the Test Plan, Test Cases, defect logging and tracking.
• Coordinating inter and intra department team (development, infrastructure, change management, testing & support teams).
• Managing Tasks related to Change management activities.
• Autosys job creation for scheduling the jobs in different environment.
• Review of PDG, Implementation and Design Documents.
• Responsible for Technical implementation.