Shailendra Porwal — Data Engineer

• Total 15+ Year of competitive experience in the area of Database applications (Data modelling for EDW/Data Vault/Data Mart development), Business Intelligence (BI) applications and expertise in OLTP (Transactional) and OLAP (Dimensional) Data Modelling. • Exclusive hands-on experience on Big Data, Pyspark, Google Cloud Platform especially BIG Query data lake design and ETL framework to load data from on-prem to cloud Big Query. • I have exposure in overall SDLC life cycle and worked in Requirement Analysis and Data Modelling for Dimensional, Relational and Hybrid Environments. • I have facilitated data requirement meetings with business & technical stakeholders and resolved conflicts to drive decisions. • I had done impact analysis and developed data flow diagrams for ongoing and new business applications • I have worked primarily on logical & physical data modelling using E/R Studio, Erwin, Power Designer, Sparx and Oracle Designer. • I have involved in various projects related to Data Modelling, System/Data Analysis, BI and Data Quality/Profiling for OLTP & EDW (including Data Vault) environments • I have extensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, BI data architecture and worked multiple databases; Teradata, Oracle, SQL Server, Sybase IQ and DB2 with T SQL and PL/SQL. • I have strong understanding in the principles of Data Vault using HUB, LINK & SATELLITE tables, Bridge, Point-In-Time (PIT) & Reference tables, identification of Business Keys for HBUs, define SCD types for SATELLITE tables, foreign & surrogate key concepts and referential integrity. • I have strong understanding in DWH using Fact & Dimension Tables, star schema & snowflake schema modeling, slowly changing dimensions. • I have extensively worked on Banking, Insurance, Commodity Trading and Healthcare domain. • I have excellent interpersonal and communication skills.

Stackforce AI infers this person is a Data Engineering expert with extensive experience in Fintech and Business Intelligence.

Location: Melbourne, Victoria, Australia

Experience: 18 yrs

Skills

Big Data
Data Engineering
Data Analysis
Business Intelligence
Data Architecture
Data Modeling
Reporting

Career Highlights

15+ years of experience in database applications.
Expertise in Big Data and cloud data architecture.
Strong background in data modeling and business intelligence.

Work Experience

ANZ

Data Engineer (4 yrs 8 mos)

Data Analyst (2 yrs 7 mos)

Cognizant

Data Architect (2 yrs)

Technology Specialist (3 yrs 8 mos)

Sun Life Financial

Specialist Development (3 yrs 3 mos)

Conduent

Software Engineer (1 yr 1 mo)

Eka Software Solutions

Software Engineer (2 yrs 1 mo)

Education

Master of Science (MS) at Birla Institute of Technology and Science, Pilani

Bachelor of Engineer at University of Rajasthan

Shailendra Porwal

Data Engineer

Melbourne, Victoria, Australia18 yrs experience

Most Likely To SwitchHighly Stable

Key Highlights

15+ years of experience in database applications.
Expertise in Big Data and cloud data architecture.
Strong background in data modeling and business intelligence.

Stackforce AI infers this person is a Data Engineering expert with extensive experience in Fintech and Business Intelligence.

Contact

Skills

Core Skills

Big DataData EngineeringData AnalysisBusiness IntelligenceData ArchitectureData ModelingReporting

Other Skills

Business AnalysisBusiness Data AnalysisBusiness ObjectsCrystal ReportsData IntegrationData ManagementData MappingData MartsData ProfilingData QualityData Vault DesignData Vault ModelingData VisualizationData Warehouse ArchitectureData Warehousing

About

Experience

18 yrs

Total Experience

3 yrs 7 mos

Average Tenure

5 yrs 11 mos

Current Experience

Anz

2 roles

Data Engineer

Oct 2021 – Present · 4 yrs 8 mos · Melbourne, Victoria, Australia · On-site

Extensively working experience in business for remediation programs
Designing and uplifting Refund Calculator for remediation on pySpark for various retail business banking products
Contributing, helping and leading in tribe wide process improvements activity for simplification & generalization
Solution designing for squad level remediation scenarios
ETL the data for business specific requirements using pySpark
Business Data Analysis, Impact Analysis, System Testing on Big Data Hadoop using pySpark

Big DataPySparkETLBusiness Data AnalysisImpact AnalysisData Engineering

Data Analyst

Jul 2020 – Feb 2023 · 2 yrs 7 mos · Melbourne, Victoria, Australia · On-site

Lead the remediation scenario from start to end for Data Analysis activity
Contributing, helping and leading in tribe wide process improvements activity for simplification & generalization
Helping anf guding for Solution designing at tribe level for differnet squads remediation scenarios
Business Data Analysis, Impact Analysis, System Testing on Big Data Hadoop using pySpark, Teradata and Oracle database warehouses

Big DataPySparkData AnalysisImpact AnalysisBusiness Intelligence

Cognizant

2 roles

Data Architect

Promoted

Jul 2018 – Jul 2020 · 2 yrs · Greater Melbourne Area · On-site

Extensively worked for top 100 fortune companies during tenure in Cognizant with various domain knowledge including but not limited to Banking, Insurance, Financial, Real Estate, Amusement Park etc.
Lead team of data vault modelers from on-shore and provide training for new resources on data vault modeling at on-shore and off-shore
Designing conceptual & logical model and translate into one or more physical Databases model in Relational, Dimensional & Data Vault Modeling environment
Determine Data flow and Data mapping through the successive Stages
Discuss the business benefits and uplift value with the business users
Business development internal and external

Data Vault ModelingRelational ModelingDimensional ModelingData MappingData ArchitectureData Modeling

Technology Specialist

Oct 2014 – Jun 2018 · 3 yrs 8 mos · Greater Melbourne Area · On-site

Designing conceptual & logical model and translate into one or more physical Databases model in Relational & Dimensional Modeling environment
Interaction with business and end users, analyze client business processes, document business requirements, performing design analysis and developing design specifications
Improving performance tuning of exiting queries and store procedures in various environment queries
Discuss the business benefits and uplift value with the business users

Relational ModelingDimensional ModelingPerformance TuningData ArchitectureData Modeling

Sun life financial

Specialist Development

Jun 2011 – Sep 2014 · 3 yrs 3 mos · Gurugram, Haryana, India · On-site

Design, build and maintain various data models in Relational and Dimensional Modelling environment for various line of business
Lead team of data modelers from Off-shore centre and provide trainings for new resources on data modelling and architecture with Power Designer
Designing and development of various reports using different versions of Business Objects and Crystal Report in various line of business
Improve performance tuning of exiting queries and store procedures for reports
Writing, updating and maintaining the new SQL Queries and store procedures in SQL Server database, DB2 database and Oracle database to run various reports
Researching, consulting, analysing and evaluating various business report needs
Testing, debugging, diagnosing and correcting errors and faults in reports/store procedures within established testing protocols, guidelines and quality standards to ensure reports/store procedure perform to specification

Data ModelingBusiness ObjectsCrystal ReportsSQLBusiness Intelligence

Conduent

Software Engineer

Apr 2010 – May 2011 · 1 yr 1 mo · Bangalore, India · On-site

Formerly known as Affiliated Computer Services, A Xerox Company
Daily ad-hoc compliance reporting work using Business Objects and Crystal Report
Designing and development of various reports using different versions of Business Object and Crystal Report in LMS product software for multiple clients
Improve performance tuning of exiting queries and store procedures for reports
Writing, updating and maintaining the new SSIS packages, SQL Queries and store procedures in SQL Server database to run various compliance reports and ETL jobs
Researching, consulting, analysing and evaluating LMS system report needs
Testing, debugging, diagnosing and correcting errors and faults in reports/store procedures within established testing protocols, guidelines and quality standards to ensure reports/store procedure perform to specification

Business ObjectsCrystal ReportsSQLSSISReportingData Analysis

Eka software solutions

Software Engineer

Feb 2008 – Mar 2010 · 2 yrs 1 mo · Bangalore, India · On-site

Designing and development of various daily/monthly reports using various version of Crystal Report in CTRM product software for various clients
Researching, consulting, analysing and evaluating CTRM system report needs
Improve performance tuning of exiting queries and store procedures for reports and ETL
Writing, updating and maintaining the new packages/store procedures in Oracle database to run daily/monthly ETL jobs which calculates profit/loss and positions
Testing, debugging, diagnosing and correcting errors and faults in reports/store procedures within established testing protocols, guidelines and quality standards to ensure reports/store procedure perform to specification

Crystal ReportsETLOracleReportingData Analysis