ANAND PULAMATI SATHYANARAYANA

Email ID: adymh0@r.postjobfree.com Mobile: +91-994*******

•Having 16+ years of IT experience with reputed MNCs – CISCO SYSTEMS, ORACLE.

•Dynamic, competent and result-oriented professional with progressive development and implementation of Data warehousing/Integration, Data Migration, Modern Data Pipelines, Database and Analytics projects.

•Business expertise in Sales IT, Healthcare, Telecom and Supply Chain domains.

•Well versed with Cloud & Modern Data Pipelines – DBT, Airbyte, Airflow, Snowflake, AWS, GCP

•Hands on experience with Oracle - SQL, PL/SQL; ETL – Informatica, Pentaho, OWB, ODI; Reporting – SAP-BO and Tableau;

•Good exposure to Big Data & Cloud – Hadoop, HDFS, Hive, PySpark, Kafka, Airflow, Python

•Adept in analyzing business needs, evaluating end-user requirements, custom designing

solutions, troubleshooting for complex Information Systems Management.

•In depth expertise in all aspects of the SDLC including requirement analysis, design, development, testing, troubleshooting and debugging.

•Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.

•Communicating at all levels of management with experience in leading team, coordinating onsite/offshore meetings, various client meetings, presentations and group discussions.

Awards & Certifications:

•Certified SAFe Agilist

•Big Data Foundations

•RACE and Globalization IT Excellence Awards; CAP Awards, Cisco Stars & Sparks

Technical Skills

•ETL DBT, Airbyte, Talend, OWB, ODI, Informatica, Pentaho Kettle

•Reporting Tools Tableau, Metabase, Looker, SAP BO, OBIEE

•Database Tools/Modeling DBeaver. Oracle SQL Developer, TOAD, Erwin

•Cloud DWH Snowflake, BigQuery, Redshift

•Databases Oracle, MySQL, SQL Server, PostgreSQL, TERADATA

•Programming Languages SQL, PL/SQL, Python, Shell Scripting, Core Java

•Big Data PySpark, Kafka, Impala, Hadoop, HDFS, Hive, Cassandra, Airflow

•Cloud Environments OCI, GCP, AWS, Snowflake

Professional Experience:

Roles: Data Architect, Database/ETL Lead/Developer – My primary role is to develop and design technical architectures and solutions for modern data pipelines, data analytics, product applications. Developed and maintained system architectural solutions based on business requirements. Evaluating existing technical architecture and recommend improvements. Provide technical and functional guidance to data engineers, analysts and scientists. Involved in technical development of data & dimensional modeling, modern data pipelines and Cloud Data Warehouses.

Currently working with Solsten Data Consulting as a Data Architect – Since Nov – 2021 to till date

Worked as a IT Principal Consultant (Data/DWH Architect) with Oracle India – 2013 to 2021.

Worked as a Business Analyst with Cisco Systems India – 2006 to 2012.

Projects – Solsten Data Consulting - Nov 2021 to Till Date:

Demand Insights – Through Global Logic for client GHX, USA

Technologies – Snowflake, Oracle 19c, AWS – Redshift, S3 etc, DBT, AirByte, Airflow, Python, Looker

Currently, working as a Data Architect and proposed modern data pipeline to re-architecture existing design.

In Phase 1, designed and developed Alternate Data Partner – ADP Data Pipeline

Healthcare – Data & Analytics – Sutherland, USA(Client)

Technologies – Impala, Tableau, GCP – BigQuery, Cloud Storage, Data Transfer, Compute Engine, Python

Worked as a Data Architect, designed New Data Warehouse in BigQuery

Collective Services – Revenue Assurance & Analytics – DMC, Cambodia(Client)

Technologies – RedHat Linux, Oracle 19c, Python, SAP BO, Talend, Airflow, Kubernetes

Worked as a Data Architect, architected, designed and developed end to end data pipeline.

Projects - Oracle Corp – 2013 – 2021:

New ETL - iProjects Suite OCI; Custom Consulting Apps – OCI Migration; CCA Data Store

ODI Replications: OPR, PMW & DEALS, RCODE

WAR Writeback Reporting; BI Reporting – OPR, PMW and OM BI Reporting;

Fusion Feed Refresh – Data Integration from PaaS to Custom Consulting Apps;

CBR/Deals – iMpact Phase III Release; OPR – Oracle Projects Review Tracking; PMW Phase 2 Activities;

Items & Actions; UI Apex Interface & Web Service; OAL Message System; PMW Data Mappings;

Oracle Data Miner

Projects - Cisco Systems – 2006 to 2012

Technologies – Oracle (SQL, PL/SQL, APEX), BO, Informatica 8.6, Pentaho Kettle 4.2 and Tableau.

Roles – Database, ETL & BI Developer, Tech Lead, BI Analyst and Project Manager

Global Demonstration Services (GDS-DM) DataMart (San Jose);

Global Leading Indicator Dashboard; Weekly SR Dashboard;

Data Warehouse Job Manager; Automatic ETL Documentation; Cost & Capacity Model – CCM;

SOX Process; Black Box Integration - SHARE, STT, OMF and PDB (San Jose);

Marketing IT QW; Project California; Cisco’s Single Trading Company (STC);

CTT – Channels Territory Tool (San Jose);

PGTMV Localization – TIBCO;

L2O-Architecture Simplification;

Quick Wins

Summary

Contact this candidate