******** - Développeur INFORMATICA

Ref : 121213H001

Profil

Consultant, Développeur (45 ans)
Domicile

566082 BANGALORE (Inde)

Compétences

Informatica

Oracle Business Intelligence Enterprise Edition

Expériences professionnelles

Role : Senior Developer.

Client : Cox Communications
aujourd'hui
ASSIGNMENT#1
Project : Star Reporting
Description:
STAR is an Oracle Incentive and Compensation (OIC) processing program, and provides our markets with a standardized application for tracking sales and calculating variable pay for our sales representatives.

STAR aims to develop and deploy standardized OBIEE reports to be used across the enterprise. It will replace existing reports (Combine Reports, JSP Reports) and eliminate the need for custom reporting at each market.

Responsibilities:
 Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups.
 Designed ETL processes using Informatica to Extract, transform & load data from oracle 11G to the target Oracle 11G Data Warehouse
 Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator
 Created sessions and workflow for designed mappings
 Extensively worked in the performance tuning of ETL Mappings.
 Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency
 Used workflow Monitor to monitor the performance of the Jobs
 Created and scheduled workflows using Workflow Manager
 Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department
 Extensively worked on performance tuning of the programs, ETL Procedures and processes
 Created DDL scripts for the various schemas.
 Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
 Worked extensively on OBIEE Answers to create the reports as per the business requirements.
 Creating hierarchy, formula, measures etc in Business Model and Mapping layer.
 Creating reports/prompts in Answers and dashboard/links for the reports
 Involved with the Testing team to resolve, fixing and testing problems found during the systems integration test, UAT phases.
Environment : Informatica Power Center 9, Oracle, OBIEE
Role : Senior Developer.

Client : Bristol-Myers Squibb
aujourd'hui
ASSIGNMENT#2
Project : BMS Analytics
Description:
Bristol-Myers Squibb is a global BioPharma company firmly focused on its Mission to discover, develop and deliver innovation medicines that help patients prevail over serious diseases.

BMS Analytics can be used to provide clear business intelligence to drive portfolio decisions and reduce the risks inherent in conducting a clinical research program. Whether making decisions for adaptive clinical trials based on predetermined milestones or comparing financial, safety, efficacy and progress information on a clinical program with comparator and outcomes data.

Oracle Life Sciences Data Hub provides the infrastructure and tools to support informed decision-making.

Responsibilities:
 Prepare the Data Mapping Sheet based on functional document.
 Prepare the ETL Design Document & Unit test case documents.
 Identify the data sources that must be transported into the new system
 Validate the source data like duplicates, orphan records, mandatory columns and volume of the data.
 Design the Mappings, Session and workflows by using Informatica and Integrating with LSH.
 Configure the LSH jobs with Informatica.
 Creating reports/prompts in Answers and dashboard/links for the reports
 Integrating ETL/OBIEE objects in the LSH.
 Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
 Worked extensively on OBIEE Answers to create the reports as per the business requirements.
Environment : Informatica power center 8.6, Oracle, Siebel, OBIEE
Role : Senior Developer.

Client : Dell
aujourd'hui
ASSIGNMENT#3
Project : Delta Analytics
Description:
Delta Analytics project is reporting mainly on Service analytics. Reporting is mainly done on entities like Service requests, activities, accounts, contacts and assets.

The Daily ETL jobs refresh analytics DB everyday to bring all the Delta CRM data. The NRT ETL jobs run continuously to refresh analytics DB so that all the SR’s and activities are in sync with CRM.

Responsibilities:
 Prepare the Design Document based on the functional requirements.
 Design the Mappings, Session and workflows by using Informatica based on the requirements.
 Prepare the unit test case documents for ETL as well as OBIEE.
 Perform the Unit testing based on the test data for ETL as well as OBIEE.
 Schedule the jobs by using DAC.
 Update the RPD/Catalogs based on the report requirement.
 Designed Created and Tested Report in the Dashboard and created the adhoc report according to the client needs.
 Migrate the ETL/OBIEE code to SIT and Production Environments.
 Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
 Creating hierarchy, formula, measures etc in Business Model and Mapping layer.
 Creating reports/prompts in Answers and dashboard/links for the reports.
Environment : Informatica power center 8.1.1, Oracle, Siebel, OBIEE
Role : Senior Developer.

Client : Finnair
aujourd'hui
ASSIGNMENT#4
Project : CFS
Description:
Finnair receives feed back from customers for reasons both good and bad. Finnair values these feedbacks as a highly valuable input since only one of every 1000 passengers responds to their service provider (Rough estimate).

These valuable feedbacks provided has to be studied and analyzed to avoid recurrence and also to provide the best of services, for this reason a negative feedback received is more valuable compared to the positive feedback because if helps the airline improve their service quality and also in their planning.

In order to analyze these feedbacks, Finnair plans to introduce a reporting tool by which they can study and analyze the cause and effects of these feedbacks.

The purpose of this project is to load data from Siebel systems by cleansing and arranging data in proper manner in to DB2 CFS Datamart Dimention & Fact tables which can be used to take further decision to improve the business.

Responsibilities:
 Designed ETL processes using Informatica to Extract, transform & load data from DB2 to the target DB2 Data Warehouse
 Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Sequence Generator
 Created sessions and workflow for designed mappings
 Redesigned some of the existing mappings in the system to meet new functionality
 Extensively worked in the performance tuning of the programs, ETL processes
 Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency
 Used workflow Monitor to monitor the performance of the Jobs
 Created and scheduled workflows using Workflow Manager
 Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department
 Extensively worked on performance tuning of the programs, ETL Procedures and processes
 Created DDL scripts for the various schemas
Environment : Informatica power center 8.1.1, DB2, Siebel.
Role : Senior Developer.

Client : Finnair
aujourd'hui
ASSIGNMENT#5
Project : Finnair Sales
Description:
Finnair Sales force spans across the globe, targeting various customers which includes end users like company and corporate customers, government units clubs and distribution channel management - IATA and Non IATA travel agents, tour operators.

To be ahead of the competitors Finnair need to constantly monitor and analyze the performances of the sales team, the sales target and also their customer, end users and distribution channel behavior. To study these trends Finnair need to generate various reports with multiple dimensions and time variants.

The purpose of this project is to enhance the existing structure of SIEBEL DATA WAREHOUSE DATA MODEL and build customize mappings based on the requirement.

Responsibilities:
 Understand the prebuilt mappings and design the new mapping based on the existing standards if required.
 Enhance the business logic in the prebuilt mappings.
 Involved in gathering requirements and created design documents and mapping documents.
 Made adjustments in Data Model and SQL scripts to create and alter tables.
 Developed Informatica objects - Mappings, sessions, workflows based on the prepared low level design documents.
 Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
 Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
 Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings
 Experience with DAC Configuration
 Good exposure in Oracle BI environment
Environment : Informatica power center 8.1.1, DB2, Siebel.
Role : Developer.

Client : George P. Johnson, US
aujourd'hui
ASSIGNMENT#6
Project : Portfolio Analyzer.
Description:
GPJ is the world's premier experience marketing agency, working with leading companies who are looking for innovative marketing solutions that motivate their audiences and activate their brands through live experiences.

GPJ offers an integrated service suite of four disciplines: Program Strategy, Creative, Technology and Delivery. The optimal mix of these services enables clients to innovate their marketing programs and insures both high performance and cost-effectiveness. This model is extremely flexible, allowing the client to evolve the program over time in response to changing needs, marketplace or business issue.

The aim of this project is to load data from SQL Server and flat files by cleansing and arranging data in proper manner in to Oracle 10G tables which can be used to take further decision to improve the business.

Responsibilities:
 Coordinating the extraction and retrieval of data from the Portfolio legacy Sqlserver database and falt files.
 Conducting all process and procedures required to migrate legacy data into the ORACLE 10G database schema.
 Creation of ETL design specifications and unit test case documents.
 Design and Develop Informatica mappings, Sessions, Transformations and workflows for extracting the data from sqlserver to oracle 10G.
 Performed Unit Testing.
 Dealing with Constraints, Querying, Joins, Keys, Indexes.
 Verification and validation of data loads.
 Authoring of custom SQL scripts, as needed, to meet the requirements of non-standard data migrations.
Environment : Informatica power center 8.1, SQL Server & Oracle 10G.
Role : Developer

Client : HP
aujourd'hui
ASSIGNMENT#7
Project Name : IPG Middleware and DCC.
Project Description:
Our Client Hewlett Packard is a leading global provider of products, Technologies, Solutions and services to individual consumers, small and medium sized Businesses and large enterprises. HP offerings different kind of services like Enterprise storage and servers, Multi-vendor services, including technology support and maintenance, Consulting and integration and managed services, Personal computing and other access devices, and Imaging and printing-related products and services.

The main objective of this project is to provide Informatica Infrastructures support (24x7) As well as Informatica application enhancement. Actually for better decision support System HP maintains around 140 applications in different data marts & our team is Responsible to provide (24x7) Informatica Infrastructures support as well as application Support for daily, weekly & monthly data refresh.

Responsibilities:
 Solve the issues those come up in Informatica environment.
 Installing Informatica on UNIX.
 Upgrading Version6 to Version7.
 Involved in Informatica application enhancement process
 Creating Users and Provide the Privileges.
 Informatica Engine or Informatica Servers Startup/Shutdown
 Password Management (UNIX accounts which are used for Informatica)
 Crontab Entries in UNIX environnent.
 Informatica Infrastructure support relating to DEV,INT,PRD
 Server Monitoring (Space availbilty).
 Moving to developed mapping to Production & MTX / RTX
 Involved Optimizing in transformations and mappings.
 Monitoring the Jobs.
 Sending of the weekly and monthly progress report

• Having 5.6 years of overall IT experience in Building Data Warehousing, Data Migration, ETL, Informatica Development , Administration, RDBMS and OBIEE Reporting,OBIA.

• Experience with Finnair client in Finland.

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.

• Involved in the analysis, design and development of all the interfaces using Informatica Power Center tools in interface team and interfaced with all the other tracks for business related issues.

• Worked on PowerCenter Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer

• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.

• Used DAC (Data Warehouse Administration Console) to configure, administer, load and monitor modular data warehouse applications.

• Proficient in understanding business processes / requirements and translating them into technical requirements.

• Experience as Administrator in handling servers, repositories, users, deployment from development to testing and testing to production environments, installation and migration of repositories.

• Extensively worked in Oracle SQL Query performance, Created DDL scripts, Created database objects like Tables, Indexes and Sequences etc

• Experience in writing entry level UNIX shell scripts needed for running Informatica mappings

• Able to work independently as well as in a team environment.

• Capable of quickly learning and delivering solutions as an individual and as part of a team.

• Possess good analytical, problem solving skills, ability to meet deadlines, and work on multiple projects.
Environment : Informatica 7x, Oracle 9i,HP- UNIX, Toad, OVSD, Tidal, Putty

Études et formations

Masters in Computer Science, Nagarjuna

University, India.

Autres compétences

Experience Summary:-
Working in Capgemini as Senior Consultant from May-2010 to Till Date

Worked for ITC Infotech as Associate IT consultant from Dec-07 to Mar-2010.

Worked for KPIT Cummins Info systems Pvt ltd since Dec -06 to Nov- 07

Technical Skills
ETL Tools : Informatica Power Center 8.x/7.x
Reporting Tool : OBIEE 10G
Databases : Oracle 9i /10G/11G, DB2, Sql Server 2005.
Tools & Utilities : TOAD, SQL Developer, Squirrel, DAC, LSH, MS Office
Operating Systems : MS-DOS, Windows 98/00/ME/XP, HP- UNIX, AIX

Recommandations reçues

Recommander ********

******** n'a pas encore reçu de recommandations.

D'autres freelances
Consultant Informatica

Ces profils pourraient vous intéresser !

Technicien système et réseau

MARSEILLE

SharePoint Windows IPBX SharePoint Online Informatica Active Directory Active Directory Domain Services

Disponible

Consultante Sénior MS BI

ÉVRY

Microsoft Power BI SQL Server SSIS SSAS SSRS SharePoint Excel Informatica QlikView

Disponible

Consultant Business Intelligence

BANSAT

Informatica OBIEE SQL Talend MicroStrategy

Data Engineer INFORMATICA

JUZIERS

Informatica

Consultante SAP BO

ANTONY

SAP BO Informatica SQL Tableau Oracle Linux Agile Dataiku

Consultant ORACLE

MONTIGNY-LE-BRETONNEUX

SQL Oracle Applications Sunopsis PL/SQL BI ODI OBIEE Informatica SAS Oracle

Consultant INFORMATICA

MONTIGNY-LE-BRETONNEUX

Informatica Oracle SQL SQL Server SQL Unix Big Data Python Google Cloud Platform BigQuery Amazon AWS

Consultant Data

LYON

SQL Azure Data Factory Talend Business Objects Stambia ODI BODS Microsoft Power BI Informatica Tableau Software

Consultant EPM/BI

SAINT-OUEN

Essbase SQL EPM Informatica Oracle EPM Hyperion Snowflake

Consultant Boomi / Informatica

PARIS

Boomi Informatica SQL API RESTful SOAP Data EAI ESB Oracle SQL Server Control-M

Mme

Prénom ^*

Nom ^*

Email ^*

Téléphone ^*

Ville ^*

Avez-vous trouvé une mission ? ^*

J'accepte d'être contacté par nos partenaires, experts en portage salarial et j'accepte la politique de confidentialité du site www.freelance-informatique.fr

Domaines d'expertise liés

CV en rapport

******** - Développeur INFORMATICA

Consultant, Développeur (45 ans)

566082 BANGALORE (Inde)

Role : Senior Developer.

Role : Senior Developer.

Role : Senior Developer.

Role : Senior Developer.

Role : Senior Developer.

Role : Developer.

Role : Developer

Masters in Computer Science, Nagarjuna

D'autres freelances Consultant Informatica

Technicien système et réseau

Consultante Sénior MS BI

Consultant Business Intelligence

Data Engineer INFORMATICA

Consultante SAP BO

Consultant ORACLE

Consultant INFORMATICA

Consultant Data

Consultant EPM/BI

Consultant Boomi / Informatica

D'autres freelances
Consultant Informatica