Anushri Das

ETL Architect (Informatica)

e-mail:ady44j@r.postjobfree.com: +669-***-****

Professional Summary

As a versatile and solution focused ETL Engineer and architect, offer a long-standing and successful career in architecting, developing and maintaining ETL solutions, Datawarehouse and business intelligence. Carry a wealth of knowledge and experience surrounding modern ETL architecture and development of best practices. Leadership skills combined with communication abilities promote positive collaboration among multidisciplinary teams and fosters strong relationships with key stakeholders.

Accomplishments:

.

• Currenly working as a Senior ETL Engineer in ICON PLC ( Full time) .Leading multiple datawarehousing /data integration project,Informatica PowerCenter to IICS conversion on IICS, PL/SQL, shell script, CA Automic scheduler .

• Currently working as a product owner of MDM tool in the EDW Space .

• Extensive knowledge on SQL, T-SQL, PL/SQL on complex and analytical queries .

• Worked as a ETL Architect for Infosys and leading the Informatica ETL development and operations in EDW for a large hi-tech organization through Infosys.

• Managed the Infosys EDW team - a team of 15 professionals including ETL engineers, BI engineers spreading in US and India for a large Hi-Tech organization.

• Delivered critical assignments in data warehousing involving solution design, data modeling, ETL design, and code development using Informatica PowerCenter.

• Experience in data integration through Informatica PowerCenter, Informatica PowerExchange and Informatica cloud (IICS) with SAP, Salesforce, relational DBs (SQL Server, Oracle, MySQL DB, Postgres), flat files, service Central, Jira etc.

• Developed integration with Salesforce and third-party apps using Informatica cloud process using RESTv2 and SOAP.

• In-depth knowledge on data flow and data model on application systems like SAP, Salesforce, Jira, MS-CRM etc.

• Have worked successfully as an Informatica Solution Expert and delivered critical BI solution including data modeling, ETL architecture and design for a major Health insurance client in North America.

• Led a team of 60 in capacity of project manager Successfully developed and implemented EDW for a major telecom client in UK which involved solution design, ETL development using Oracle Warehouse Builder, design of DataMart, and development of dashboards and report using Oracle Business Intelligence. Skills

Tools: Informatica cloud (IICS) - Cloud Data Integration ( CDI) and Cloud Application Integration ( CAI), Informatica PowerCenter 10.2, Informatica PowerCenter 9.6, Informatica PowerExchange (10.2), Informatica Administration, OBIA, Knime.

Database: Microsoft SQL server V 16, Oracle 19c/9i/10g/11g, MySQL, Postgress Language: PL/SQL, SQL, T-SQL

Cloud Platform: Microsoft Azure, exposure to Snowflake. Applications: Familiarity with application and data model of SAP (ECC, CRM, HCM, APO, BPO, BW modules), SAP HANA, Salesforce, Jira, MS-CRM, Service-Central Domain: Finance, HR (workforce management, performance management etc.), Sales (Order Management, Forecast), supply chain, Engineering (data sets for new products, simulation test results from Jira) Scheduling Tool : Control-M, CA Automic, SAP Redwood ( RunmyJobs) Repository : Github

Qualification

Education: Bachelor of Technology in Computer Science Certifications/Training:

Oracle Certified in OBIA for ERP (IZO-525) and OBIEE10g Foundation Essentials. Trainings: Agile methodology

Solution Design Program

Oracle Warehouse Builder (OWB R2)

Oracle Business Intelligence (OBI),

Professional Experience

Senior ETL Engineerin ICON PLC, USA from Jun 2021 till date Project :

• Working as an ETL engineering and technical lead in EDW space and delivered critical projects along with team member located globally .

• Lead various projects on Informatica PowerCenter to IICS conversion. Migrated Informatica PowerCenter mapping,sessions, workflows to IICS mapping, mapping tasks and taskflows.

• Wrote PL/SQL/SQL views, functions, procedures to cater analytical and reporting needs .

• working on ingetration projects with Salesforce to EDW, Oracle EBS to EDW using IICS.

• working as a product owner of Master Dara Management ( MDM) and stewardship application in EDW space.

• Worked on data migration project from Oracle to Snowflake - migration of IICS mappings to load data to snowflake instead of existing Oracle data warehouse . Responsibilities:

• Leads various Data warehousing projects,data integration with different source system, enhancement of datamarts with a global team .

• Works as product owner for MDM and stewardship application of EDW - working as a lead engineer to integrate data to these applications from various internal and data sources. PREVIOUS EMPLOYMENT HISTORY – Infosys Ltd.

ETL architect and technical Lead in EDW for Advanced Micro Devices (AMD) through Infosys, USA from Jun 2013 till Jun 2021.

Project:

• Worked as an ETL engineering and technical lead in EDW space and delivered critical projects.

• Have delivered critical projects related to salesforce integration (using SOAP) with EDW using informatica cloud (IICS). The data is kept as daily snapshots in EDW and published to users using SSAS cubes enabling analytics related to sales forecasting to top leadership team(CXO level). The project also included master data push from EDW to SFDC using IICS.

• Have worked on integration of SAP modules with EDW using Informatica PowerExchange to acquire critical billing, revenue, backlog datasets in EDW and build BI solutions on top of it to enable integrated view of these datasets. Data is published to user using MS cube and reports.

• Have delivered Workforce Analytics by acquiring workforce data sets from SAP HRM and performance data from SuccessFactor and build Datawarehouse and BI solution for HR business group - includes weekly snapshot of workforce data, employee status change, global headcount summary, weekly recruitment snapshot, employee performance reports .

• Have worked in 3rd party (timesheet data) tool application integration with EDW using Informatica cloud

(IICS) using REST API. Data project also included integration of employee information data to be pushed from EDW to the 3rd party tool.

• Worked on near real-time Integration of SAP HANA with EDW using Informatica 10.2 in finance subject area.

• Extensively worked on SQL and T-SQL to write view and stored procedure in SQL Server

• Worked on xml and xquery to read and parse xml data as part of application integration and ETL Responsibilities:

• End to end delivery and operations responsibility of all EDW projects and enhancements

• Lead EDW operations – projects, enhancements, daily production support, EDW Data integrity, Informatica and database health check and improve performance

• Managing the Infosys EDW team- a team of 15 professionals including ETL engineers, BI engineers.

• Informatica Administrator: Informatica Services health check, periodic purging logs, solve critical issues related to Informatica infrastructure issues.

• In-Depth knowledge of different ERP systems,developed data acquisition using Informatica: SAP ECC, CRM, HRM, APO, BPC, BW module, SAP HANA, salesforce, SuccessFactor, JIRA, Agile PLM, Service Central.

PREVIOUS EMPLOYMENT HISTORY – Tata Consultancy Services (TCS)

• Enterprise Solutions OBI Apps COE Lead for Tata Consultancy Services: Kolkata, India from Aril 2011 to Oct 2012

Worked as OBIA and Informatica consultant and solutions expert in Oracle Center of Excellence, enterprise Solutions, TCS.

Responsibilities:

• Provide consultation and delivery support to various business critical projects ran in Oracle BI Applications

(OBIA) and Informatica set of tools (Informatica PowerCenter, Informatica Data quality) as a COE expert to ensure smooth project delivery.

• Lead design and delivery of OBIA implementation projects.

• Product analysis and create re-usable assets to be used by project teams

• Training and development of new resources in OBIA.

• Arranged various workshops, demos with the customers in the field of OBIA space. This in later created high value opportunities for TCS.

• Provided unsolicited proposals and value propositions after understanding customer pains and driving these proposals for realization.

• Leading initiatives in new accounts acquisition.

• Solution Architect, Humana INC., Louisville, USA from Jan 2009 to March 2011 through TCS Project:

The project was a mandatory audit requirement from National Committee for Quality Assurance (NCQA) to measure health insurance Company’s yearly on important dimensions of care and service. HEDIS consists of 71 measures across 8 domains of care. Customer needed to provide member, member enrollment, provider, and claims information for last years to a third-party vendor in the form of extract to generate the measures on yearly basis. The project was executed in Informatica PowerCenter 8.6.1. Responsibilities:

• Solution Architect for the major compliance project - Requirement Analysis, Data Analysis, ETL design and development.

• Responsible for setting up informatica infrastructure for the client

• Support on setting up the Informatica development, test, and production environment for the customer.

• Support and consultation on setting up Informatica Repository, Integration Service, Folder structures.

• Deployment and code migration strategy from Informatica development, test, and production

• Scheduling strategy for Informatica projects: Modified the existing homegrown scheduling tool to run the Informatica workflows.

• Informatica mapping performance tuning.

• Consultation on naming convention on Informatica objects, shared TCS best practices on the same.

• Various ETL Engineer and developer Roles with-in USA and International through TCS: Ethicon Endo Surgery (A J & J Co.): Oct 2008 to Dec 2008 British Telecom: June 2007 to Oct 2008

Qwest (now CenturyLink): Oct 2004 to Jan 2006

United Utilities Oct 2003 to Sept 2004

TCS Product Re-Engineering(Ex): Oct 2000 to Oct 2003

Contact this candidate