G

Gourav Sikka

VP of Engineering

India13 yrs 11 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in Google Cloud and SAS programming.
  • Proven track record in data analytics and reporting.
  • Strong leadership in managing complex projects.
Stackforce AI infers this person is a Data Analytics expert in Fintech and Healthcare sectors.

Contact

Skills

Core Skills

Data AnalyticsGoogle BigqueryData ManagementAnalyticsStatistical Analysis

Other Skills

Agile & Waterfall MethodologiesAgile MethodologiesAnalytical SkillsBig Data AnalyticsBusiness AnalysisBusiness ProcessBusiness RequirementsDBT SQLData AnalysisData StrategiesData WarehousingDatabasesDremioETL ToolsExtract, Transform, Load (ETL)

About

I am an accomplished data professional, proficient in a diverse array of tools and technologies, poised to drive transformative outcomes for organizations across various domains. With expertise spanning Google Cloud, SAS, SQL, Python, and more, I bring a wealth of experience and insight to every project. Google Cloud Expertise:Proficient in Google Cloud services such as Dataproc, Dataflow, Google BigQuery, SDK, and Databricks, enabling efficient data processing and analysis at scale. SAS and SQL Mastery:Advanced skills in SAS Programming, SAS/SQL, and SQL Server, empowering robust data manipulation, analysis, and reporting capabilities. Data Management Proficiency:Experienced in designing and implementing data warehouses, data marts, and data lakes, ensuring optimal storage. Visualization Skills:Proficient in visualization tools like Tableau, Power BI, and matplotlib, transforming complex datasets into insightful visualizations. Programming Prowess:Proficient in Python, PySpark, Unix commands, and Hadoop components. Domain Expertise:Specialized knowledge in banking, credit card, US healthcare, and insurance domains. • Engineering Professional having good experience in SAS Programming and Google Bigquery (GCP), python programming language , Pyspark,Statistical Analysis , Hive and sqoop. • In-depth knowledge of the Hadoop ecosystem, its various components, along with different tools including Hive and sqoop. Indepth understanding of Bigquery/Hive architecture, table partitioning, clustering, best practices, type of tables, best practices etc How to reduce BigQuery costs by reducing the amount of data processed by your queries In-depth knowledge of the Google cloud ecosystem, its various components, along with different tools including dataproc, SDK, compute engine, GCS, bigquery, databricks, Google composer. Able to speed up queries by using denormalized data structures, with or without nested repeated fields Exploring and Preparing data using ETL - BigQuery/Hive. Strong experience in Base SAS, SAS/data step, SAS EG, SAS/ODS and SAS/SQL. Responsible for the Extractions, Transformation and loading of data from multiple sources into data warehouse. Created and automated several reports using SAS and SQL. Good knowledge of Health care compliance Protocols like COBRA, HIPAA, Cost Protocols, Medicare, Medicaid, Self-Insured plans and Imputed Income. Skilled in Analytical Skills, Requirements Analysis, Agile Methodologies, and SAS Base. Assist & Manage Offshore/Onshore Interactions. Used git as a version control system

Experience

Wells fargo

VP Analytics(Lead Analytical consultant)

Nov 2021Present · 4 yrs 4 mos

  • Manage business requirement in a structured manner, keep stakeholders updated of progress & challenges and navigate through various stakeholder to deliver on work assigned.
  • Work closely with a range of stakeholders across organization, including business leads, data providers and technology colleagues to understand requirements, complete feasibility studies to create proposals and development requirements for implementing decisioning system functionality.
  • Be responsible for production and substantiation of a varied range of monthly and quarterly dashboards around credit and fraud.
  • Able to perform data analysis using technical tools e.g., SAS, Dremio, Google BigQuery, DBT SQL, Tableau, Power BI Python, MS-Suite.
  • Implement and maintain remediation solutions for risk reporting to ensure compliance to BCBS 239.
  • Provide relevant training for standard methodologies and tools to new team members
  • Good experience in Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.
  • Expertise in handling all Tableau products (Desktop, Public, Server, Online) along with deep Knowledge of SQL, Python.
  • Knowledge of USA Retail Banking ,Reporting.
  • Highly effective in narrating the analytical output to stake holders, draw agreement on business actions or formulate impact strategies.
  • Review and interpret ongoing business report requirements , suggest and design dashboards
  • Performing Data Modeling in Tableau Desktop.
  • Designing and developing of data models and writing complex SQL queries to extract, manipulate, and analyze data.
  • Analyze existing SQL queries for performance improvements
SASDremioGoogle BigQueryDBT SQLTableauPower BI+3

R systems

Project leader

Jan 2019Nov 2021 · 2 yrs 10 mos

  • Worked as a Project leader expertise in SAS programming|| GCP || Python programming || Google bigquery|| Certified Tableau developer|| Machine learning
  • Experience with skills in Data management, Analytics , Statistics in related field.
  • Good Experience in skills like AI/ML, Data Science, SAS, SQL, and Python. Familiarity with business intelligence tools like Tableau, Power BI, DBT, Google BigQuery, Google Cloud Alteryx etc
  • Worked on advanced analytical concepts to develop strategies across relevant domains.
  • Experience in developing analytical strategies across banking functions and Health insurance.
  • Good project managing skills. Be results-oriented with strong attention to detail and problem-solving skills.
  • Possess strong communication, interpersonal skills, and leadership potential
SASGCPPythonGoogle BigQueryTableauPower BI+2

Wipro

Lead Analyst

Oct 2018Jan 2019 · 3 mos

  • Worked as a lead program analyst, Lead SAS programmer and Tableau expert. Good understanding of US healthcare knowledge.
  • Performed thorough testing of SAS programs and functionalities to identify and resolve any issues or deviations .
  • Proficient in extracting data from Oracle Database into SAS data files using SQL Pass-through facility
  • Experience in SAS / BASE,SAS / SQL,SAS / MACROS,SAS / GRAPH,SAS / STAT and SAS /ODS .
  • SAS programming experience in generating Analysis Datasets
SASSQLTableauData Analytics

Xerox

2 roles

Implementation Team Lead

Promoted

Jun 2017Oct 2018 · 1 yr 4 mos

  • Manage all Statistical analysis and reporting of projects.
  •  Working as a lead programmer to design and specify the overall approach to a projects
  •  Create and maintain programming tracking documentation.
  •  Generate summary tables, data listing, graphs and derived datasets as specified in statistical analysis plan.
  •  Generate outputs and reports to support other departments.
  •  Transfer of deliverables.
  •  Responsible for development of statistical models like predictive, logistic regression.
  •  Coordination with clients and help in designing & implement analytic solutions.
  •  Responsible for project delivery.
  •  Structure analytical solution to address business objectives.
  •  Collaborate with project team members in writing prioritized business requirements documentation , including scope definition and statement of work.
  •  Ensure adherence to policies , procedures , standards and compliance.
Statistical analysisProgrammingStatistical Analysis

Senior Business Analyst

May 2012Jun 2017 · 5 yrs 1 mo

  • Strong experience in Base SAS, SAS/data step, and SAS EG, SAS/ODS and SAS/SQL in Windows Environment. Also familiar with basics of SAS in Unix Environment
  • Responsible for the Extractions, Transformation and loading of data from multiple sources into data warehouse.
  • Extensive knowledge in data management like merging, concatenating, interleaving and moving of SAS datasets.
  • Experience in predictive analytics using data mining tools, reporting Analytics and automation.
  • Optimized performance using Data Validation and Data cleansing on data using Statistical procedures like PROC FREQ, PROC MEANS.
  • Expertise in producing RTF, PDF, HTML files using SAS ODS facility.
  • Experience in extracting, manipulating data, and creating Data Sets and further reports from various sources like Excel, flat files, using PROC IMPORT techniques and SQL pass through facility.
  • Identify fraud detection in Claims and non payment of premium, risk analysis
  • Created and automated several reports using SAS and SQL.
  • Excellent communication, interpersonal skills. Quick learner, versatile, adaptable and process -oriented with high customer orientation
SASData ManagementData Analytics

Education

Maharshi Dayanand University

B.E — Computer science

Stackforce found 100+ more professionals with Data Analytics & Google Bigquery

Explore similar profiles based on matching skills and experience