Viraj Chaudhari

043*******, adcpes@r.postjobfree.com

Australian Citizen / https://www.linkedin.com/in/viraj-c-7a269a4/ 1

Summary

Proficient in implementing DATA/ETL/EDA projects for on-premise as well cloud-based applications. Adaptable team-player demonstrated ability to assess agile projects and trouble shoot complex issues with root cause analysis. Core Competencies

• Requirement elicitation

• Converting paper requirement into solution

• Bridge technical and non-technical data gaps

• Software development life cycle

• RDBMS, Data Modelling, Data Lineage

• SQL, ETL, ELT processes

• Star Schema - Kimball Methodology

• Data Visualisation, BI Reporting

Technical Expertise

• SQL, DB: MS SQL Server, Oracle, Teradata

• Tools: SAP Data Services (BODS), SAP Information Steward, SAP Business Objects 4.x, SAP ABAP, SAP BI, Tableau Technical Education

• AWS ecosystem, Sqoop, HiveQL, HBase, Spark SQL

• SAP BOBJ 4x

• MCDBA

Academic Qualification

• Postgraduate degree in BIG Data Analytics, BITS Pilani, India (June 2019- March 2020)

• Advanced diploma in IT Project Management, SWSI-TAFE Australia

• Postgraduate degree in Computer Applications, Gujarat Vidhyapith India

• Bachelor of Commerce (Accountancy and Statistics), Gujarat University India Key Projects (5 Years)

4 Commonwealth Bank Australia

CBA Fenergo project to migrate institutional banking customers data from StreetSmart to Fenergo application. Actively involved with CBA “Custos – complex product” project team and multiple CBA stakeholders – SAP/CRD/MOB/FO/WSS/MUREX to carry out data remediation project to fix data gaps and uplift the data in multiple source systems for customers actively trading on Wall Street and Murex platforms for last 18 months.

• Weekly data extracts for SAP, StreetSmart, FXTG, Murex, Wall Street data in Teradata staging, data profiling/analysis to find out the data gaps according to Fenergo data migration business rules and data preparation for data migration.

• Written/maintained complex SQLs in Teradata to get data sets based on missing Murex and WSS product accounts linkages between SAP and StreetSmart systems, missing mandatory regulatory data in StreetSmart, aligning mandatory data in customer wise multiple records in StreetSmart and providing excel-based reports to data remediation team.

• Provided ad-hoc reports to project team and data migration files for trial conversions and Go-Live. Worked closely with data remediation and data migration team. Maintained documentation on confluence. 3 Fonterra

Fonterra Canpac project to migrate RENCS system data to SAP.

• Successfully migrated procurement data in production environment within six hours window time for SAP objects: Open purchase order with history, Accounts payable, Inventory stock with batch creation for number of customized characteristics and handling unit with reconciliation report for business.

• Define/Built BODS ETL Jobs and SAP LSMW objects, data validation and migration for multiple trial conversions with prompt defects fix, UAT with functional consultant, reconciliation reports for business

• Object wise documentation with data lineage, ETL processes, LSMW objects and test scripts SAP Data Capability (Data Remediation) project for SAP ECC systems (CORP, ANZ, FARMSOURCE, SOPROLE) for 500+ business rules. Attended SAP Information Steward (IS) training at SAP Melbourne. Viraj Chaudhari

043*******, adcpes@r.postjobfree.com

Australian Citizen / https://www.linkedin.com/in/viraj-c-7a269a4/ 2

• Demonstrated IS development route and built IS score card visualization for business approval. For “timed out” IS view issue, business agrees to access data through ETL batch jobs, also utilization of SAP standard reports for complex data like SAP BOM.

• Delivered 50+ reports based on Materials, Customers, Vendors, Assets and BOM. Set benchmark for report development. Supported data steward to fix on-going change request in running reports as well how to apply best SAP practices in report development.

SAP ARIBA (cloud application) Data Migration project to migrate initial 3 years history data loads followed by regular quarterly delta loads for 7 systems 4 SAP: CORP, ANZ, FARM-SOURCE, SOPROLE and 2 non-sap: JD Edwards, RENCS.

• Attended requirement gathering workshop with SAP Australia and Fonterra business analyst, involved in finalizing source wise data lineage documents.

• Built source wise BODS ETL jobs with performance tuning, data validation and migration for eleven masters (Company Site, Account, Contract, Cost Center, Cost Center Mgmt, ERP Commodity, Part, Supplier, User, Currency Map, UOM Map) and two transactional (Purchase Order, Invoice) data for initial load, UAT with business and performed Go-Live activities. Project KT to BAU team with support guide.

Order Booking Management (OBM) reporting project to replace manual driven BI solution with auto driven ETL tool.

• OBM reports accessed by Supply Chain Coordinators to monitor order statuses, escalations and workloads. Manual extracts replaced by BODS ETL batch job.

• Define/Built BODS ETL Job to extract SAP masters, Domestic & Export sales orders and Warehouse Replenishment data from SAP ECC system with 3 times execution in a day with error-handling. UAT with business. Worked closely with Tableau developers and involved in reports UAT with stakeholders.

• ETL job scheduling in production environment and Project KT to BAU team with support guide. 2 SingTel Optus

SuccessFactors (cloud application) Data Migration Project. Involved in SAP SuccessFactors and SAP Payroll data migration for 30k+ SingTel, Optus and NCS employees.

• Define/Built BODS ETL jobs to migrate legacy data to SAP SuccessFactors for Employee Central (Foundation, Core and Profile) 19 objects and built SAP LSMW for SAP Payroll 14 objects with data validation, data migration for multiple trial conversions with reconciliation reports. Performed production activities with team of two members. GEMS Project: Responsible to build/deliver “Global Employee Management System – GEMS” interface. Datamart built on Oracle for SuccessFactors data. Numerous downstream systems across Optus, SingTel and NCS access GEMS data as source information.

• Participated in GEMS requirement workshops, define/demonstrated GEMS development strategy to business. Involved in data modelling process to map source structure with target requirement.

• Raised SAP ticket for seamless SF O data connection for SAP Data Services Webservice REST API.

• Built weekly Alpha & daily Delta scheduled BODS ETL batch jobs with error handling and staging wise email notifications. Applied workflow controls, extracting 41 SuccessFactors tables including Background*, Cust* EMP*, FO*, Per*, Picklist* and Position in Oracle staging area, transforming by applying business rules & uploading records in 29 target tables.

• Demonstrated Impact and linage analysis to project team along with how to create ad-hoc reports in SuccessFactors. Project hand-over and Knowledge Transfer to BAU Team with support guide. 1 Toll Express

BI data warehousing (EDW) built on MS SQL Server from multiple legacy systems (Bookings, Orders, Consignments, Manifest, Accounting, Budget, Payroll and Drivers). Source systems including Oracle, SQL Server, Flat files, XML data and GPS data from myfleet.com. Delivered 45+ Reports with trend/comparison Graphs and KPI dashboarding. Applied Kimball methodology to design star schema. Solution provided using SAP BOBJ 4.x tools with team of three members.

• Involved in writing data lineage document for EDW as well finalized report formats with business analyst, Data modelling to store three stages ETL data and Maintained EDW in MS SQL Server in Dev/QA/Prod environment.

• Built/maintained weekly Alpha and daily Delta BODS batch Jobs with error handling and staging wise email notification. Maintained three stages data population - Data extraction staging, transferring primary data into star schema staging and building dimension and fact tables with surrogate keys.

• Maintained star schema in Information Design Tool (IDT). Worked closely with Web Intelligence report developers and involved in reports UAT with Business.

• Project hand over with DW/BIBO Knowledge Transfer to TOLL Team with support guide. Viraj Chaudhari

043*******, adcpes@r.postjobfree.com

Australian Citizen / https://www.linkedin.com/in/viraj-c-7a269a4/ 3

Work Experience

Duration Company Position Client

Sept’14-tilldate HCL Technologies, Sydney Managing Consultant CBA (2019-tilldate) Fonterra (2016-2018)

SingTel Optus (2015-2016)

Toll Express (2014-2015)

May’14 – Sep’14 NSW DEC Audit Directorate, Sydney Sr. Data Analyst Apr’12 – Nov’12 Accenture, Sydney SAP Data Migration Consultant NSW DEC LMBR project Sep’11 – Feb’12 Oxygen Business Solutions, Sydney SAP ABAP Consultant Trility, Adelaide Legal Aid, Sydney

Apr’11 – Jul’11 Tata Consultancy Services, Sydney SAP ABAP Consultant Coca Cola Amatil Sep’10 – Mar’11 NSW DEC, Sydney Sr. SAP Analyst

Jun’04 – May’10 Meghmani Organics Ltd, India SAP Data and Reporting Lead ABAP programmer

Software Developer

Contact this candidate