Shreyansh

WORK EXPERIENCE

May’23 -Present with Brillio, Hyderabad as Data Specialist (GCP)

Achievements/Task:

•        Working on Data Quality Checklist and auditing for tables in BigQuery.

•        Access Management using Terraform in Google BigQuery Dataset.

•        Did Structured Streaming using Pyspark& Apache Kafka.

Sep’21 -May’23 with Accenture, Hyderabad as GCP Technical Specialist

Achievements/Task:

•        Worked on Data migration from Mssql to Google cloud.

•        Developed Data ingestion pipelinesusing Apache Beam (Cloud Dataflow)/Cloud Data Fusion& Google Big Query.

•        Created Snowflake integration in GCP to load data in Snowflake from GCS bucket in various file format.

•        Automated SFTP operations using Apache Airflow (Cloud Composer)

•        Implemented Incremental load usingUpsert logic in BigQuery.

Feb’21 -Sep’21 with GlobalLogic, Hyderabad as Associate Consultant

Achievements/Task:

•        Managing Google’s top client marketing initiatives and developing client tools using Tableau and Data Studio dashboards with data source mainly on Google Big query for leadership and helping end user to achieve more customer acquisition and revenue growth by observing the performance patterns through great visualizations.

•        Created, loaded and query partitioned tables for daily time-series data &implement fine-grained access control using roles and authorized views.

Aug’19-Feb’21 with Sears Holdings Corporation, Hyderabad as Senior DataAnalyst

Achievements/Task:

•        Worked on Analytics project related to Customer and Seller Attrition behavior in Tableau.

•        Worked on project related to gathering data (Big Query) for New Customers added every month for EBAY client.

•        Maintain complex databases by performing appropriate database management functions (e.g., maintain space availability, rebuilds indexes, file cleanup, runs utilities to check database integrity) to ensure optimum capacity and application performance

Aug’18 – Aug’19 with Deloitte, Hyderabad as Data Analyst

Achievements/Task:

•        Data Analytics – Applied SQL and techniques to help management evaluate data quality in support of system implementations, data conversions.

•        Applied data analysis techniques increasing efficiency, enhancing productivity, and improving the accuracy of the data the company relies upon for key decision making and reporting.

•        Worked with JSON and array data type in Google BigQuery.

Jan’16 – July’18 with Accenture Solutions, Hyderabad as Application Development Analyst

Achievements/Task:

•        Cleansing and Analysis of Clients structured and unstructured large data sets to find the answers for the management questions.

•        Created and presented executive dashboards and scorecards to show the trends in the data in Tableau.

•        I did POC on creating Architecture Diagram for Google Cloud Platform.

•        Used advanced Microsoft Excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.