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

Ref : 121213H001
Photo de ********, Développeur INFORMATICA
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

D'autres freelances
Consultant INFORMATICA

Ces profils pourraient vous intéresser !
CV Consultant Sénior BI
Sidi Mohamed

Consultant Sénior BI

  • SEVRAN
SQL PL SQL INFORMATICA TRANSACT SQL SSIS ORACLE SQL SERVER INFORMATICA MDM HUB Azure Data Factory Snowflake
Disponible
CV Data Integration Expert
Mohamed

Data Integration Expert

  • PEYMEINADE
ORACLE ORACLE DATA INTEGRATOR INFORMATICA
Disponible
CV Consultant INFORMATICA +Power BI
Chaouki

Consultant INFORMATICA +Power BI

  • NEUILLY-SUR-MARNE
ORACLE TERADATA INFORMATICA Microsoft Power BI COGNOS BI
CV Consultant BI
Karim

Consultant BI

  • PARIS
SQL INFORMATICA SSAS ORACLE ODI TERADATA ORACLE SQL SQL SERVER MANAGEMENT STUDIO SQL SERVER ANALYSIS SERVICES
CV Consultant SAP BO, BODS
Axel

Consultant SAP BO, BODS

  • ALFORTVILLE
SAP BO BUSINESS OBJECTS SQL DECISIONNEL BODS BUSINESS OBJECTS DATA SERVICES DATAWAREHOUSE TALEND SSIS INFORMATICA
Disponible
CV Consultant Informatica
Sonia

Consultant Informatica

  • LA FRETTE-SUR-SEINE
INFORMATICA SQL SHELL UNIX DATAWAREHOUSE AGILE TALEND DI BI
CV Data Ingénieur, Expert ETL, Python
Arnold

Data Ingénieur, Expert ETL, Python

  • LYON
ODI ORACLE 11G SHELL UNIX PL SQL PYTHON INFORMATICA DOCKER UML MONGODB PRINCE II
CV Consultant BI
Chakib

Consultant BI

  • SAINT-GERMAIN-EN-LAYE
BI INFORMATICA TALEND ORACLE
Disponible
CV Administrateur système LINUX
Ivan

Administrateur système LINUX

  • LABASTIDE-CLERMONT
LINUX TABLEAU SOFTWARE INFORMATICA APACHE HADOOP SHELL UNIX SQL ANSIBLE
CV Chef de projet DATA
Malik

Chef de projet DATA

  • BOULOGNE-BILLANCOURT
DATA AGILE INFORMATICA AZURE