Vikas K. Email & Phone Number

Los Angeles, California, United States

Los Angeles, California, United States

* Designed and developed the project of migrating Vertica to Google Big Query* Lead the project of installing, configuring, architecting, and developing Looker* Designed data pipelines to best suit the Retail Category Management, and Finance data* Developed for the data model to best stake holder's business needs* SME for Looker and AtScale

Los Angeles, California, United States

* Lead the project for building data pipelines data transfer between Airtable to Google Big Query* Designed Google Big Query project to best suit the Business needs

Los Angeles Metropolitan Area

* Lead the Business Intelligence project of SQL server to the Google Big Query migration.* Designed and architected the data model to best support the Retail data and business requirements.* Worked on design, development, and maintenance of the BI/reporting to best suit the Retail Industry Business requirements.* Managed offshore team for round-the-clock productivity

Pasadena Ca

Professional Accomplishments:• On-prem to Google Cloud migration of BI platform.• Migration of BI platform from using multiple sources of RDBMS to a single Cloud Database.• Worked on ETL for Google Big Query by utilizing the in-house SPARK framework.• Experience in working on API reporting platforms.Responsibilities:• Lead a project on upgrading and migrating the MicroStrategy platform from on prim to Google Cloud.• Worked on POC for building reports and dashboards using Google Data Studio/G sheets using Google Big Query.• Worked on SQL query tuning by analyzing the BQ query plan to fit timeout limitations best.• Contributed to the implementation of CICD for various data components using Jenkins and Spinnaker.• Worked on developing and testing the MicroStrategy project for Japanese language translation.• Worked on the designing and development of a reporting environment from using Vertica/Impala data warehouse to Snowflake (cloud) data warehouse. • Worked on developing schema and public objects for MicroStrategy project using Hive data source.• Developed freeform SQL reports/cubes from Hive to meet complex business requirements.• Good knowledge of building and maintaining the reports/dashboards in MicroStrategy with SDK integration.• Work with business partners to understand and deploy complex security-driven solutions for external users.• Built a usage analysis dashboard as a one-stop point, using Platform Analytics.• Worked on building and scheduling the System Manager automation workflows for deployments and tests.• Worked on QA automation for major projects using Java.Environment: Google Cloud Platform, Big Query, Snowflake, Vertica, Impala, Dataproc/ Kubernetes, Terraform, Apache Hive, MS SQL Server 2012, MicroStrategy 2020, JIRA.

Greater Boston Area

I worked as a MicroStrategy developer, involving in developing reports and dashboards. Worked on migration of reports from Power BI to MicroStrategy which is built on Data like (HDFS/HIVE)

Richmond, Virginia Area

Worked as a MicroStrategy developer, involving in developing reports and dashboards. Lead a role in schema re architecture for more scalability.