SHASHI EMANI

• Designed, developed, and performed various ETL operations using Talend and Alteryx's ETL functionalities to convert source data into desired target data and load into Oracle tables for the downstream applications to consume.
• Role is to build integrations to get data from commerce REST APIs to Oracle tables
• Involved in fine tuning the existing jobs to improve performance and implement best practices recommended by Talend and Alteryx product teams.
• Facilitate rapid development and deployments in multiple environments using tools such as Git, Nexus, SVN
• Experience in processing JSON and XML files
• Collaborate with offshore and cross functional team members to ensure the overall developments are in sync.

Environment: Talend 7.2.1, TAC, Alteryx Designer 2023.2.1, Oracle, SQL Server

• Worked as a Datawarehouse and BI consultant
• Using Talend as the primary tool for ETL needs
• Utilizing Talend studio and Talend management console
• Creating data marts based on individual needs of the respective departments
• Created and automated workflows to fetch data from APIs, FTP locations and other source systems to downstream applications

Environment: Talend 7.3.1, Talend Management Console, Oracle 11g, SQL Server

• Workied as Talend data engineer in Test Data Management team
• Used Talend as the primary tool for Data engineering needs
• Work with business to understand and execute the data needs
• Worked with multiple databases like Oracle, MySQL, Mongo DB and utilized multiple file systems like xml, json, csv
• Working knowledge with TAC for scheduling and monitoring purposes
• Worked on Health care file (EDI, X12) files which include 834 and 837 files

Environment: Talend7.2, TAC, SQL Server, Oracle, JSON

• Created ETL flows in Talend to facilitate the data needs related to specific teams and departments
• Created ETL flows to retrieve data from REST and SOAP APIs
• Developed various data marts specific to Census, financial aid as per the request from the specific departments
• Fine-tuned existing jobs in the data warehouse to improve the performance
• Created jobs to fetch data from heterogeneous systems, which includes flat files
• Created and implemented slowly changing Dimensions
• Used dynamic schema feature to migrate multiple tables from database to other
• Experience in processing JSON and XML files
• Retrieved data from REST API
• Utilized bulk load to load and process large volumes of data, which improves performance drastically
• Promoting jobs between the environments using Talend Integration Cloud (TIC)
• Created promotion pipelines in TIC and created execution plans based on the requirement

Environment: Talend 7.x,6.x Talend Management Console, Oracle 11g, SQL Server.

• Designed, developed, and performed various ETL operations using Talend's ETL functionalities to convert source data into desired target data and load into Snowflake, Flat files for the downstream applications to consume
• Developed DDL scripts to create tables on Data Lake environment on Snowflake database to load the source data from Oracle EBS, flat files, and MY SQL databases
• Created Talend jobs using dynamic schema feature to handle the incoming data from source files, which keep changing frequently
• Implemented multi thread execution, which enables the sub-jobs to run in parallel, which increases the performance of the jobs
• Experience working with Snowflake database
• Created databases, schemas, and tables in Snowflake database, which is a cloud database, hosted on AWS

Environment: Talend 6.5, 7.1.1, Talend Management Console, Snowflake, Oracle 11g, MY SQL.

• Used Talend Studio to develop various jobs to extract, cleansing, transforming, integrating, and loading data in to target databases
• Extracted data using Talend from Various relational sources like oracle, MY SQL, and flat files like csv, excel etc
• Developed Talend jobs to read data from log files generated from Servers which are located on a network drive and load it to target tables in warehouse
• Created and executed Talend jobs in debug mode which is one of the efficient ways to debug and fix the errors
• Configured interactive dashboards with drill-down and drill-through capabilities, guided navigation, narrative views, master-drill reports, column selector, view selector etc
• Re-Created various Discoverer Reports in OBIEE and aligned them in various Dashboard Pages as per the business requirements

Environment: Talend 6.5, Oracle EBS R12.1.1 (General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), OBIEE, Oracle 11i.

• Interacted with analysts and business users for gathering the requirements for business requirements and performed the necessary GAP analysis, translated them into technical design documents and closely worked with the team members and made recommendations to close the GAP
• Developed and modified ETL mappings using informatica from scratch to load the data from source system (EBS) to staging system (SDE mappings) and to the target Analytics Warehouse
• Customized Out of the Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics

Environment: Oracle EBS R12.1.1 (General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), Inventory (INV), Purchase Order PO), OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.1, DAC 11g.

• Developed Solution Designs and delivered to Development team after reviewing the solutions with Business
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the Data Warehouse
• Implemented and Configured the Domain Value Lookup files for ETL interfaces related to HR analytics
• Integrated data from HR, Finance and other enterprise systems and transformed data using Informatica (ETL)
• Designed and developed custom mappings and Workflows in Informatica to bring the data from other data source systems and integrated using Universal Adapters in DAC
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc

Environment: Oracle EBS R12.1.1, OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.1, DAC 11g.

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Worked on creating ad-hoc OBIEE reports based on requirements.