SUMMARY:

• 12 years of experience in Information Technology which includes experience in Business Requirement Gatherings, GAP Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE, Informatics 9.x/8.x/7.x, Pentaho Data Integration, Talend Data Integration, Spotfire Reporting.
• Experienced in using Talend Data Fabrictools (Talend Data Integration, Big Data, MDM, Data Catalog, Data Quality, Data Preparation, TAC).
• Open to learn and implement new technologies.
• Experience in dimensional modeling, designing data marts,star and snowflake schemas.
• Experience in providing end - to-end business intelligence solution.
• Hands-on experience in Business Intelligence Platform.
• Hands-on experience in ETL/Data Warehouse development, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse using various ETL platforms like Informatica, Pentaho Data Integration(PDI), Talend.

SKILL:

Sources Applications: Oracle EBS, Siebel, Salesforce, Anaplan, Revpro.

Application Tools: OBIEE, Spotfire, Informatica Power center, Talend Studio, Talend Data Catalog, MDM,TAC, Pentaho Data Integrator.

Databases & Tools: Oracle, TOAD, SQL*PLUS, Snowflake, Amazon Redshift, Kafka, AWS S3.

Languages: Python, SQL, PL/SQL, JAVA.

WORK EXPERIENCE:

Confidential, Palo Alto, CA

Lead Developer / Architect (Talend ETL)

Responsibilities:

• Responsible for design and develop a scalable data integration solution based on the business requirement.
• Responsible for Data Integrations from multiple sources.
• Responsible for design and develop the ETL data integration flow process to Integrate the data into Salesforce system from Legacy systems as part of acquisition merges.
• ETL Product Owner, Responsible for handling ETL code Repository.
• Responsible for Talend ETL upgrade setup and configuration.
• Responsible to maintain the ETL code repository in Nexus.
• In depth understanding of the back end Talend architecture.
• Responsible to extract and hosting the data into cloud environments using API’s.
• Developed complex mappings using tRESTClient and other Talend components like tJavaRow, tMap etc.. to extract the data from API’s to load into the target data base.
• Responsible in designing and built automated data flow process from file transfer protocol FTP to Target system.
• Worked hands on conversion of Informatica ETL/ Legacy system ETL process toTalend ETL process.
• Hands-on experience on source systems like Salesforce, Oracle EBS, Anaplan, Revpro.
• Developed complexETL jobs to migrate the data from flat files to database.
• Migrated of data from on-Premises oracle DB to Snowflake environment.
• Responsible for Data migration from MySql Server to Snowflake environment.
• Created bucket in Amazon S3 and automated the data flow into this bucket using Talend Studio.
• Created Snowpipe for continuous data load, Ingestion of data into snowflake from Amazon S3 buckets.
• Used Talend data catalog to search the metadata repository for associated terms, definitions and to review semantic flow diagram.
• Reviewed the objects data flow to understand the full lineage of the table attributes tracing the objects back to its source.
• Optimize and fine tune the SQL queries and increase the performance of business reports.
• Guide ETL developers.

Environment: Salesforce CRM, Oracle Applications R12, Informatica 9.5.1, Talend Open Studio 7.3.1, Talend Data Catalog,Data Profiling, TAC, Spotfire, Anaplan, RevPro, SQL Server, Nexus Repository, Snowflake, Amazon S3, Amazon Redshift, TOAD,SQL Developer, Apache Kafka.

Confidential, Santa Clara, CA

ETL/ BI Lead

Responsibilities:

• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Responsible for end to end design, develop, Data Integration and BI solution.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes usingTalend.
• Worked extensively on the Oracle EBS R12, salesforce (SFDC) and Siebel source system to integrated the data from this sources into Datawarehouse.
• Worked on the Salesforce API’s to identify the fields required for data warehouse and business reporting.
• Designed, Develop and integrated the Quotes and Orders flow from both the Siebel and salesforce.com (SFDC) into the data warehouse.
• Worked hands on Informatica 9.5 ETL migration toTalendStudio ETL process.
• Design and Developed repository (.rpd) that consist of Physical Layer / Logical Layer/ Presentation Layer.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Created joblets inTalendfor the processes which can be used in most of the jobs in a project like to Start job and Commit job.
• CreatedTalendjobs to copy the files from one server to another and utilizedTalendFTP.
• Developed custom mappings, workflows, sessions and Registered in DAC.
• Responsible from development to deployment of Dev environment to Production environment.

Environment: Salesforce (SFDC), Siebel, Oracle Applications R12, Informatica 9.5.1, Talend Open Studio 6.0, Pentaho Data Integration 7.1, OBIEE 11.1.1.7.1 , DAC 10.1.3.4, BI Apps 7.9.6.4, Oracle (Financial, Supply Chain Managements (SCM), Order Management and Procurement & Spend Analytics), Oracle 11g.

Confidential, Atlanta, GA

ETL / OBIA / OBIEE Lead

Responsibilities:

• Responsible for Gathering the requirement, completed the proof of concept, Designed, Developed and Testing ETL, Physical, Business and Presentation Layer of OBIEE.
• Responsible for the End to End design and development of ETL, RPD and OBIEE reports as per the business requirement.
• Designed and developed Schema using Fact, Dimensions, Alias and Extension tables.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to Data Warehouse (OLAP) system.
• Designed and developed the Informatica ETL and automated the process to load the data from the Budget and Net sales deductions flat file into the data warehouse tables.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Responsible for providing BI solutions.
• Responsible for the End to End design and development of ETL process, RPD and OBIEE reports as per the business requirement.
• Designed and developed Schema using Fact, Dimensions, Alias and Extension tables.

Environment: OBIEE 11.1.1.7.1 , Oracle Applications R12, Informatica 9.1, Talend Open Studio, DAC 10.1.3.4, BI Apps 7.9.6.4, Oracle (Financial, Supply Chain Managements (SCM), Order Management and Procurement & Spend Analytics), Oracle 11g.

Confidential, Addison, IL

Sr. ETL / BI Consultant

Responsibilities:

• Responsible for providing BI solutions.
• Hands on ETL and Datawarehouse development.
• Responsible for report development.
• Designed and Developed Informatica Sessions and Workflows.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Adding new Tables, Tasks and rebuilding the subject areas in DAC based on the changes done to the Informatica repository.
• Configured new customized mappings and work flows in DAC for new customized subject area.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard and AR balance, invoice details in Receivables dashboard.
• Enhanced and customized the out of the box (OOB) Dashboards, facts and dimensions for financial and Procurement & Spend Analytics modules.

Environment: OBIEE, Oracle Applications R12, Informatica 9.0.1, OBI Apps 7.9.6.4, DAC, Supply chain, Order Management, Oracle 11g, Data Modeling, Cognos, TOAD.

Confidential, Denver, Colorado

Sr. OBIEE/OBIA Consultant

Responsibilities:

• Involved in the Implementation of Financial Analytics and Procurement and Spend Analytics.
• Responsible for documenting the implementation steps for Procurement and Spend Analytics.
• Worked on Configuring the Informatica Source, Lookup and Domain CSV files.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Responsible for providing BI solutions.
• Designed and developed mapping to load the employee details and roles to create requisition into new table from W EMPLOYEE D.
• Customized Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Hands on ETL and Datawarehouse development.

Environment: OBIEE, Informatica 9.1, BI Apps 7.9.6.4, DAC 10.1.3.4, Oracle EBS, Reports 10g, Oracle 11g, SQL Developer.

Confidential, Columbus, IN

Sr. OBIEE/OBIA Consultant / OBIEE Trainer

Responsibilities:

• Responsible to provide professional training to business users on the OBIEE BI tool.
• Hands on ETL and Datawarehouse development.
• Responsible to Conduct and lead the OBIEE 11g training to large business groups across the enterprise.
• Responsible to Created OBIEE 11g Training Material on various level right from basic to Advance levels and training the End Users globally.
• Responsible for the End User Support and demonstrated the technique, New features available in OBIEE 11g Like Conditions, Selection Steps, Funnels and Gauges.
• Designed and Developed the Dashboards from scratch for various internal client projects.
• Developed Ad-hoc and standard Reports/Dashboards pages with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Graphs, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE suite.

Environment: OBIEE 11.1, Informatica 9.1, DAC, BI Apps 7.9.6.1, Oracle (Financial Analytics, Supply Chain Managements (SCM), Order Management).

Confidential, Schaumburg, IL

Sr. OBIEE /OBIA Consultant

Responsibilities:

• Responsible for providing BI solutions.
• Handled regular deployment issues across Dev, Prod and Test environments.
• Installed and configured OBIEE 11.1.1.5.0 on windows environments.
• Responsible for Conducting OBIEE Knowledge sharing sessions for business community and training Business users on day to day bases and demonstrated the technique creating their own Ad-Hoc Reports.
• Responsible to Develop and maintain Analytics.
• Created executive level Reports and Dashboards catering to provide insight into the sales / marketing / financial data.
• Responsible for converting large number of reports from scratch, Informatica Power Analyzer 5 to OBIEE 10.1.3.4.
• Responsible to migrate complex reports from SAP BW environment to OBIEE 11.1.1.5.0.
• Hands on ETL and DBI report development.

Environment: OBIEE 11.1.1.5/10.1.3.4 , Informatica Power Analyzer 5, SAP BW, BI Apps 7.9.6.1, Oracle (Financial Analytics), Oracle 11g, Informatica 8.x, TOAD, windows 7, SQL Developer.

Confidential, Seattle, WA

OBIA /ETL Consultant

Responsibilities:

• Responsible for ETL solution.
• Responsible ETL and dart mart development.
• Performed Requirement Gathering, Gap Analysis, Data Model Design.
• Understand the customers’ requirements and analyze and show them how self-service reporting would be helpful.
• Created an end to end datamart involving all the payroll data across all the countries.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Created PL SQL Packages/stored procedures to load data and create different tables based on requirements.
• Used the OBIEE Administration tool to develop and enhance Data Model. Configured and created OBIEE Repository (rpd), Involved in modifications of physical, and business and presentation layers of metadata repository using OBI EE Administration Tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository

Environment: OBIEE 11.1.1.3/10.1.3.4 , BI Apps 7.9.6.1, Oracle EBS, Oracle 11g, DB2 9.x, Informatica 8.x, TOAD.