Sunil Kumar Gaurav

Project Manager

Bengaluru, Karnataka, India15 yrs 5 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 19+ years in data warehousing and analytics.
  • Expert in ETL processes and data integration.
  • Proven track record in project management and delivery.
Stackforce AI infers this person is a Data Warehousing and Business Intelligence expert in the Gaming and Healthcare sectors.

Contact

LinkedIn

Skills

Core Skills

Project ManagementData WarehousingBusiness Intelligence

Other Skills

BMC Control-MAmazon RedshiftEnterprise Business IntelligenceETL processesTeradataData IntegrationAnalyticsCloud-based solutionsRequirements AnalysisExtract, Transform, Load (ETL)IICSInformatica PowerCenterSQLPython (Programming Language)Active Batch

About

* 19+ years of experience in data warehousing projects in various roles such as developer, project Lead, data ware housing Technology lead , data modeling and User interface design. * SME in Gaming, HealthCare and sales data. * Experience in the business domain (Sales & Operations, Supply-Demand Management, Supply-chain operations, Product Master, Customer master, Channel Sales, etc.) * Extensive knowledge of Relational data warehousing , data analysis and data reporting concepts. * In-depth knowledge of SDLC processes. * Experience with SQL based reporting using Teradata/Oracle SQL in the Enterprise Data Warehouse. * Proficient in SQL data analysis ,database Designing and performance tuning. Current Responsibility : Responsibilities are overall project delivery,Reviews the BRD, attends requirement workshops and collaborates with the business to analyze the requirements and delivers Requirements Specification, Use Cases, Creates conceptual and logical data model,Develops design document,Develops functional test case documents and supports project manger with test strategy development, Applies right design, utilizes right technologies and frameworks defined by the platform team,Assigns work areas and tasks to the Developers and Performance and Framework Engineers. . Technical Skill set: * Databasess: AWS Redshift,Teradata, MYSQL ,MSSQL Server, Oracle, Salesforce SOQL, Splunk QL * ETL Data pipelines : Informatica Power Center ,Matillion , Python * Reporting: Tableau,Cognos * SQL Performance Tuning by using object oriented programming. * Source code control system: SVN , GIT * High quality ETL/ELT Designing by considering IT Infrastructure . * Data stewardship , Data Modeling , Schema Designing , Data Mining. * Operating Systems: UNIX,Linux, Windows , MAC OSX * Scripting: Unix Shell Scripting,Python * Job Scheduling: Control M,Autosys * Log processing through Splunk * Productivity tools: Microsoft office suite (Excel, Word,PowerPoint), Mac iWork suite (Keynote, Pages) , OmniPlan * Big data concepts: HDFS, Hbase, Map Reduce , Hive,Hive CBO , Pig ,Scala, Spark ,Sqoop,Flume,ZooKeeper, Storm,Yarn, Ambari * Understanding on Google BIG Query and Big Table * Business Analysis: Use Case & Activity diagrams, Business and Functional requirements (BRD & FRS), business process modeling, Technical Specifications.

Experience

15 yrs 5 mos
Total Experience
7 yrs 8 mos
Average Tenure
11 yrs 2 mos
Current Experience

Cognizant

Project Manager

Apr 2015 – Present · 11 yrs 2 mos · Bengaluru, Karnataka, India

BMC Control-MAmazon RedshiftProject ManagementData Warehousing

Penn national gaming

Senior Systems Analyst

Apr 2015 – Mar 2020 · 4 yrs 11 mos · Wyomissing, Pennsylvania, United States

  • About:
  • Penn National Gaming owns, operates or has ownership interests in gaming and racing facilities and video gaming terminal operations with a focus on slot machine entertainment. The Company operates 41 facilities in 19 jurisdictions. In total, Penn National Gaming’s facilities feature approximately 50,500 gaming machines, o1,300 table games and 8,800 hotel rooms. The Company also offers social online gaming through its Penn Interactive Ventures division and has leading customer loyalty programs with over five million active customers.
  • Roles And Responsibilities:
  • Design & development of Enterprise Business Intelligence systems & solutions.
  • Analysis of data across Enterprise business and Operational systems to gather & understand business requirements for design and creation of Interactive Analytics dashboards & Reports.
  • Design and develop Extract, Transform and Load(ETL) processes to populate the Enterprise Data Warehouse.
  • Platform management, administration and support of Terabyte scale Enterprise Datawarehouse with specialization in performance tuning, optimization and cost reduction.
  • Logical and physical database design of Enterprise data warehouse.
  • Provide Data Integration, Analytics & Information systems solutions using cloud and on-premise based hybrid architectures and technologies.
  • Migration of on premise data integration workflows to the cloud with focus on industry best practice standards and cost optimization.
  • Supporting Cloud based data lake & Datawarehouse solutions.
  • Maintaining or updating business intelligence tools, databases, dashboards, systems or methods.
  • Managing the timely flow of business intelligence information to business users.
Enterprise Business IntelligenceETL processesTeradataData IntegrationAnalyticsCloud-based solutions+2

Apple

System Analyst

Jun 2007 – Apr 2015 · 7 yrs 10 mos · Cupertino, California, United States

  • My responsibilities are overall project delivery,Reviews the BRD, attends requirement workshops and collaborates with the business to analyze the requirements and delivers Requirements Specification, Use Cases, UI mockups using GBI standard templates,Creates conceptual and logical data model,Develops design document,Develops functional test case documents and supports project manger with test strategy development, Applies right design, utilizes right technologies and frameworks defined by the platform team,Assigns work areas and tasks to the Developers and Performance and Framework Engineers.

Exilant technologies private limited

Programmer Analyst

Mar 2007 – Jun 2011 · 4 yrs 3 mos · Bhubaneshwar, Orissa, India

  • I have more than 5 years experience in software engineering. I have worked with Apple Inc in finance domain.

Education

KIIT University

BTech — Information Technology

Jan 2002 – Jan 2006

Stackforce found 100+ more professionals with Project Management & Data Warehousing

Explore similar profiles based on matching skills and experience

RS

Rahul Solanki

UPI Product Incharge

at National Payments Corporation Of India (NPCI)

Mumbai, India14 yrs 8 mos exp
Product ManagementProduct Strategy
Neet M.

Neet M.

Member of Technical Staff

at micro1

Dallas, United States8 yrs 6 mos exp
Frontend DevelopmentProject ManagementSales Management
Ipaz Paragas

Ipaz Paragas

Director

at Deutsche Bank

Metro Manila, Philippines36 yrs 8 mos exp
Data EngineeringBusiness Process DesignData Quality AnalysisProcess AutomationBusiness Intelligence
Sneha S

Sneha S

Senior Technical Recruiter

at PIT Solutions

Thiruvananthapuram, India4 yrs 6 mos exp
HiringIT Recruitment
KS

Karthik Shanmugasundaram

Senior Engineering Manager

at Adobe

Cupertino, United States22 yrs 5 mos exp
Engineering LeadershipLarge Language Models (LLM)Machine LearningArtificial Intelligence (AI)IoT
Aniket Rath

Aniket Rath

Site Reliability Engineer - 2

at Cohesity

Odisha, India1 yr 10 mos exp
LinuxDomain Name System (DNS)Virtualization
sanish chirayath

sanish chirayath

SDE 2

at Bruno

Bengaluru, India9 yrs 8 mos exp
API DevelopmentSoftware EngineeringWeb Development
Sumeet Jain

Sumeet Jain

Advisor

at Heeler

Newton Centre, United States19 yrs 2 mos exp
Information SecurityCybersecurity