Harish N S

+91-895*-***-***

acq0j1@r.postjobfree.com

SUMMARY OF EXPERIENCE/SKILLS:

About 6+ years of experience in Financial and Telecom Industry providing technical consultant solutions.

About 2 years of experience in providing ETL design and development solutions for integrating operational data with Datawarehouse.

Over 2 years of rich experience in Middleware administration for Abinitio, providing design and management solutions to build Abinitio platforms for Operations.

About 2 years of experience as a technical L2 production support for Datawarehouse applications, involving jobs management and troubleshooting support.

Diversified skill set/experience covering Application support, development/L3, middleware administration, and also release-coordination and team management/co-ordination.

Excellent programming skills with ability to automate routine tasks using UNIX shell scripting and a good experience in SQL.

Expertise in all components in the GDE of Ab Initio for creating, executing, testing and maintaining graphs/plans in Ab Initio and also experience with Ab Initio Co-operating System in application tuning and debugging strategies.

Excellent team player with ability to perform independently with good analytical and problem solving skills and capable of delivering output within the timeline and with quality, in all circumstances.

Self-motivated and proactive leader with strong technical and communication skills. Exceptional ability to create, implement and improve IT standards, policies, and procedures.

TECHNICAL SKILLS:

Experience in Abinitio cop>2.15, 3.0 and above

Excellency in Batch processing, ConductIt, Parallel Processing, Performance tuning of graphs

Proficient in shell scripting (Korn, Bash), XML

RDBMS experience/knowledge, like Oracle/ Db2 /SQL Server/ Teradata, etc

Expertise on scheduling tools like Autosys, korn, Operational Console/Control Center

Strong understanding of Ab Initio EME/Version Control concepts

Knowledge of Ab Initio branching and merging strategies

Expertise in Abinitio administration and very strong grip on command-line interface to EME, Co>Op, ConductIt, etc

Strong debugging skills

Understanding of Data Modelling concepts and DWH/BI knowledge

Experience in Data Quality, Source Systems Analysis, Business Rules Validation

Unit & Integration Testing skills

TRAINING & CERTIFICATIONS:

In-house training on the below:

Business Objects, Informatica 9.x

CAREER SUMMARY:

1)Infosys Ltd – 03/Mar/2014 to till date

Projects Details and Experience

PROJECT/Team : Abinitio STE - GPA

CLIENT : Citi Group, US

DURATION : 1 year 2 month

TEAM SIZE : 30

JOB ROLE : Abinitio Consultant

TECHNOLOGY : Abinitio 3.x, UNIX, Autosys, Websphere, GDE, DB2, Sybase, Oracle, Perceiver, Talend, etc

DESCRIPTION:

The project is basically to provide Enterprise product support on production, Testing and development environments to ensure backend Business services developed on the middleware enterprise product (Abinitio) are up and running and services are available for business users and customers. Major roles & responsibilities are listed below.

RESPONSIBILITIES:

CO>Operating System installation and License keys management

Key activities like EME TR creation/upgrade, projects creation, grant users access to TRs, tagging, promotions, project-directories, application hub, multifile system setup, creation/mgmt of branches, repository backups, etc

Key server setup/mgmt, Users key procurement, troubleshooting GDE to EME connection issues

Planning and implementing COB tests

Installation/upgrade and configuration of Abinitio products like Operations Console/Control Center, ExpressIt(ACE+BRE), Metadata Hub, including bridge and reporter config, User access mgmt, ExpressIt license procurement, etc

Continuous monitoring of abinitio platforms to ensure there is no contention for resources like CPU, Memory, IO, disk space, etc

Mediating between applications team and Abinitio vendor support for various requirements like performance tuning of applications, troubleshooting BAU issues and challenges

Automating recurring tasks, training new members in the team, continuously strive to deliver value to the Client/Stakeholders

Incident management/reduction, Automation of BAU tasks, Implementation of Abinitio Workload Manager, DBC file configuration to various RDBMS, etc

2)Alchemy Solutions(contract to IBM) – 22/Nov/2013 to 02/02/2014

Projects Details and Experience

PROJECT/Team : Genesis – Enterprise Platform Services

CLIENT : Citi Group, US

LOCATION : Bangalore, India

DURATION : 22/Nov/2013 to 02/02/2014

TEAM SIZE : Onshore-9 and Offshore 18

JOB ROLE : Abinitio Consultant

TECHNOLOGY : Abinitio, UNIX, Oracle, Teradata, Websphere

DESCRIPTION:

Genesis Datawarehouse is a common pool of contracts, positions and Customer account balances across all of Citi for use of finance, Risk and Compliance and any other unit requirements such as

-Organized on an enterprise wide basis

-Common data model

-Based on Enterprise Data standards

-Anchored to financials for integrity and completeness

-Operated through shared services

Genesis base includes:–

-Finance

-Risk and compliance operation

-Consumers of Data Users

Like any other typical Datawarehouse it mainly focuses on Extract, Transform and Load strategy.

RESPONSIBILITIES:

CO>Operating System installation and upgradation and Computer keys administration

Performing activities like EME TR and Projects creation, tagging, promotions, MFS setup and project-directories creation, branches, etc.

GDE key management, troubleshooting GDE to EME TR connection issues

Installation and maintenance of Abinitio products like Operations Console, ACE, Metadata Hub, including bridge and reporter configurations

Managing user access to EME TR, Operations Console, ACE, BRE, Metadata Hub

Monitoring system performance of servers in terms of CPU, memory and IO to ensure that capacity is adequate so that Operations can deliver agreed level of Service

Troubleshooting incidents

3)Torry Harris Business Solutions (THBS) – 20/Sep/2006 to 12/Aug/2011

Projects Details and Experience

PROJECT/Team : ETL/Abinitio Middleware

CLIENT : Orange Telecom, United Kingdom

LOCATION : Bristol, United Kingdom

DURATION : Apr-2010 to Aug-2011 (1 year and 4 months)

TEAM SIZE : Onshore-3 and Offshore 6

JOB ROLE : Abinitio Consultant

DESCRIPTION:

ETL (Extract, Transform and Load) is predominantly seen within the realm of data warehousing and business intelligence domains in various huge customer base Organisations. Even the same is followed in Orange too.

The Orange ETL architecture has been constructed with the integration of disparate systems in mind. As a system in its own right, the ETL architecture can be used to ensure 2 external applications using differing interfaces so that they can correctly communicate with each other, thereby providing increased synergy and value to the business.

The ETL system is a major part of the Orange Enterprise Integration Architecture consisting of 35 major applications, 200+ interfaces, 1500 graphs, processing approximately 4 terabytes of data (45 billion records) per day. It is central to Orange’s integration architecture. These applications are developed and supported using Ab-Initio tool by ETL team.

RESPONSIBILITIES:

CO>Operating System installation and upgradation and Computer keys administration

Performing activities like EME TR and Projects creation, User access control, tagging, promotions, MFS setup and project-directories creation, etc

GDE key management, troubleshooting GDE to EME TR connection issues

Monitoring system performance of servers in terms of CPU, memory and IO to ensure that capacity is adequate so that Operations can deliver agreed level of Service

Troubleshooting incidents

PROJECT/Team : Integrating CSS with DWH

CLIENT : Orange Telecom, United Kingdom

DURATION : June-2009 to Mar-2010 (9 months)

TEAM SIZE : Onshore 4 and Offshore 6

ROLE : Abinitio Consultant

TECHNOLOGY : Abinitio 2.15, GDE 1.15, UNIX, Informix

DESCRIPTION:

CSS system is the heart of Orange’s business holding the information about all of its mobile and landline customers. Orange had about 11 million customers but the database used for holding this crucial information is a legacy hosted by Informix database tool, which cannot support Data mining and large scale data analysis. So this project launched with the objective of Integrating CSS system with Datawarehouse. Briefly, the idea was to provide a solution to migrate customer data to Datawarehouse as both and onetime activity and a permanent mechanism to push delta data on a daily basis.

Having known the requirement, the challenge was to deal with the mammoth data and device a mechanism to smoothly implement this integration solution within the stringent timeline, i.e. to analyze the entire CSS system which consisted of over 40 subject areas built upon over 200 tables.

RESPONSIBILITIES:

To study and analyze Business/Technical requirement and High level Design

Interaction with Design team and Project head for any additional requirements gathering

Preparation of Low level design documents for each deliverable

Development of applications as per design requirements

Integration of different modules of the project and performing Integration testing

Assisting QA testing with knowledge sharing for test cases preparation.

Fixing defects and providing Dev support for QA testing

Co-ordinate with Project release control head for Go Live

Knowledge sharing about the project with Production application support team

Providing standby support for the project post release to fix design flaws if any

PROJECT/Team : Data Integration and Translation – ETL (L3)

CLIENT : Orange Telecom, United Kingdom

DURATION : July-2008 to May-2009 (10 months)

TEAM SIZE : Onshore 1 and Offshore 2

ROLE : Abinitio Consultant

TECHNOLOGY : Abinitio 2.14, GDE 1.15, UNIX (Linux, Sun Solaris, HP-UX) Oracle 9i/10g, Informix

DESCRIPTION:

ETL (Extract, Transform and Load) is predominantly seen within the realm of data warehousing and business intelligence domains in various huge customer base Organisations. Even the same is followed in Orange too.

The Orange ETL architecture has been constructed with the integration of disparate systems in mind. As a system in its own right, the ETL architecture can be used to ensure 2 external applications using differing interfaces so that they can correctly communicate with each other, thereby providing increased synergy and value to the business.

The ETL system is a major part of the Orange Enterprise Integration Architecture consisting of 35 major applications, 200+ interfaces, 1500 graphs, processing approximately 4 terabytes of data (45 billion records) per day. It is central to Orange’s integration architecture. These applications are developed and supported using Ab-Initio tool by ETL teams.

Applications undergo frequent changes which may be a design change coming in as Work package or a bug fix coming as an STK. Value adds such as performance improvements form an integral part of work package in ETL team.

RESPONSIBILITIES:

Providing 3rd line support for Data Integration Support Team to provide code fixes to problem tickets raised and also help them investigate Incidents most efficiently and effectively.

Investigate Problem tickets and provide solutions and if necessary make changes to the code that do not affect design but help to improve performance to meet KPIs even more efficiently

Co-coordinating with release control to ensure ETL L3 team bug fixes are released along with the monthly scheduled releases for problems with workaround and arrange to release critical problems at the earliest not to impact business.

Conducting unit testing of code fixes as well as supporting QA testing on requirement basis.

Preparing Test exit reports for releasing to QA and helping QA testing to prepare test cases.

Assisting Development teams to understand any existing applications and to help them do Impact assessment flawless

Reviewing existing heavy applications to check if there is any scope to improve them without affecting their base design, which would help Operations to meet their SLAs better.

Updating/modifying design documents, in coordination with ETL design team, for the code fixes done by ETL L3 for proper tracking of the changes to Project design and development documents.

PROJECT/Team : Data warehouse

CLIENT : Orange Telecom, United Kingdom

DURATION : Sep-2006- June 2008(1 year and 8 months)

TEAM SIZE : Onshore-4 and Offshore-6

ROLE : Abinitio Consultant

TECHNOLOGY : Abinitio 2.14, UNIX (Sun Solaris, HP-UX, Linux), Netezza DBMS

DESCRIPTION:

In computing, a Datawarehouse (DWH) is a database used for reporting and data analysis. It is a central repository of data which is created by integrating data from one or more disparate sources. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

A typical ETL-based Datawarehouse involves three stages - Extract, Transform and Load. In the preliminary stage raw data is extract from various operational systems or the data may be made available by the third party jobs. In the later stages the extracted raw data is transformed as per the Business Rules into more clean and well-ordered for easy reporting by Data Users and then is loaded into the Datawarehouse. Though these activities look simple the time is the most important aspect here. It is the sole responsibility of the team to ensure that all these activities take place within their defined SLA(Service Level Agreement) and Database is up and running for Data Users for Business Reporting.

RESPONSIBILITIES:

Schedule, Monitor and Troubleshoot Jobs

Incident Queue and Problem Queue management

Developing scripts for maintenance activities, like archiving data files

Monitoring KPIs to ensure right capacity is available to ensure Jobs to meet their SLAs

Preparation, PreProd testing and planning to implement new project releases on to Production

Assisting L3 support team in debugging code related issues/problems

Ensuring Client and stakeholders are communicated about new releases, issues, and any other updates.

QUALIFICATION:

Bachelor of Engineering from Vishweshwaraiah Technological University, Belgaum, Karnataka, India

International Visas:

Possess H1B US Visa and is valid till Sep, 2017

Contact this candidate