PRAVINKUMAR GHETIYA

Business Intelligence Developer & Solution Architect

SUMMARY

@ ad0xw2@r.postjobfree.com

Arlington, TX

Business Intelligence solution architect with 28+ years of experience in manufacturing industries. Technical Lead for multiple Engagements from the kickoff to handover project phases like Discover, Prepare, Explore, Realize and Deploy & Run

Expertise in all three areas of data analytics project lifecycle - Data Acquisition, Data Engineering, and Visualization. Specialized in Performance Tuning using data engineering expertise like optimize routine code, AMDP, Aggregates, Roll-up and Cube Compression, Partition etc.

SAP BW Data Management and Data Visualization with the process-oriented skills to communicate with higher management and internal clients. Highly experienced in SAP BW & BW on HANA, SAP BI Tools, HANA modeling, SAC Oracle DB, SQL and Python Scripting.

Certification

Reporting / Modeling and Data Acquisition with SAP BW/4HANA. SAP HANA 2.0 SPS06

SUMMARY OF PROJECT ROLES

• Solution Architect / Technical Lead in SAP HANA Data Modeling and Visualization (2+ Years).

• Technical Lead in SAP BW, BW on HANA, and Visualization (8+ Years).

• Developer / Lead Developer in Oracle DB, SQL Scripting, Pro*C, HTML (22 Years).

• Tableau dashboard (6 Months)

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Gujarat Alkalies and Chemical Limited

02/2001 - Present Baroda, Gujarat, India

Gujarat Alkalies and Chemicals Limited is an Indian chemical substance manufacturing company, promoted by the Government of Gujarat. With a revenue of $490 million.

• Deployed over 75 analytics projects for all departments

• Developed custom data warehouse utilizing Linux Server, SAP frameworks and Oracle database to provide high-quality data analytics for over 450K ton per annum of main product and other 33 products

• Served as the SAP BI Transformation Project Lead, overseeing and driving successful implementation of business intelligence initiatives. Head Of IT

Narmada Cement Co. Ltd. ( A subsidiary of L & T )

12/1994 – 02/2001 Jafarabad, Gujarat, India

Formerly Narmada Cement, now merged with Ultratech Cement and L&T is a leading cement manufacturer known for superior-quality products, sustainability, and innovation.

• Served as the IT In-Charge, responsible for overseeing and managing internal projects across multiple departments. Improving the efficiency by 50% within a year.

• Led the enhancement and development of existing applications using FoxPro within the NOVELL Environment. Collaborated on Finance Accounting, MIS, Production, Quality, Costing, Budgeting, Inventory Control, and Sales Accounting modules to optimize operational efficiency and effectiveness.

SKILLS

Programming Skills

SAP BW HANA modeling Data Modeling Web Intelligence BEx Query Designer & Analyzer SQL Scripting ABAP Data Validation Data Analysis BW on HANA BW/4 HANA Oracle SQL SAC CDS View SAP HANA SAP Data Services (ETL) Pro*C Power BI HTML Python Performance Tuning Support & Maintenance Requirements gathering Gap Analysis Design Development Troubleshooting

Soft Skills

Team Handling Mentoring Leadership Critical Thinking Communication Problem Solving

+1-817-***-****

No Sponsorship Required

Permanent Residence (GC)

PROJECTS

SAP HANA

iCost/xCost project

• iCost/xCost involves calculation of price difference of various products and consists developments such as BOM Variance, SRP BOM, Quote Approval History, Costed BOM development for internal and external partners.

• It consists of creation of FS by interacting with Business, DFDs, Data Model development using Table Function, Stored Procedure as well as Graphical HANA Modeling

• Other HANA developments like CReST reporting, Poly Interface development etc.

• Successfully delivered the iCost/xCost project, ensuring accurate price analysis and providing valuable insights to support strategic decision-making.

SAP HANA

Quantum project

• As a part of HANA modeling, we have worked on Quantum project (Agile-MDG-ECC-Agile).

• It involves development of Graphical CVs based on Legacy MDG system to calculate the Change Order timeline and various workflow approval process in particular order in MDG system using SDI virtual tables. SAP BW on HANA (BW to BW on HANA Migration)

Played a key role in the BW on HANA migration project, closely monitoring migration activities alongside the technical team. Participated in post-migration validation to ensure smooth functioning of all BW objects in respective environments.

• Contributed to production activities such as queue clearance and manual data loading from data sources prior to HANA migration.

• Accountable for optimizing existing data flows in SAP BW on HANA environment, involving conversion of ABAP code to AMDP and transforming standard DSOs, InfoCubes, and MultiProviders into HANA-optimized objects like aDSOs and HANA Composite Providers.

• Actively involved in building new data flows within the BW on HANA system.

• Implemented process chain optimization by removing obsolete data types and introducing new process types like Data Merge to enhance efficiency.

GACL SAP Implementation (BI Project Lead)

Responsibilities for BI Transformation Project:

• Organized workshops to discuss KPIs with departments and SAP functional team during requirement gathering.

• Developed and obtained sign-off on wireframes for Reports/Dashboards from various departments.

• Activated and installed master data objects such as 0MATERIAL, 0CUSTOMER, 0VENDOR, 0COMP_CODE.

• Activated and enhanced transactional data sources (e.g., 0FI_GL_4/AR/AP from Finance, 2LIS_02_HDR and 2LIS_02_ITM from MM, 2LIS_11_VAITM, 2LIS_13_VDITM from SD, 2LIS_05_Q0NOTIF and 2LIS_05_QE1 from QM).

• Built generic data sources using custom tables and function modules for lookup purposes in SAP BW data flows.

• Created custom InfoProviders for daily performance, monthly and yearly budgeted and actual comparisons, vehicle movement status for finished goods and raw materials, five-year sales comparison, etc.

• Developed BEx queries with exit variables incorporating cascading filtering based on reporting requirements.

• Conducted data validation and unit testing.

• Managed cutover activities and provided post go-live support.

• Established FS/TS (Functional Specification/Technical Specification) and Naming Convention templates.

• Utilized WebI for data visualization purposes.

GACL – Inhouse Development

• Developed applications in Payroll, HR, and Finance using Oracle, PRO*C, and JSP.

• Migrated finance and payroll systems from Oracle 7 to Oracle 10g, JSP, and updated reporting from PRO*C

• Served as IT in-charge, overseeing internal projects for multiple departments.

• Identified IT-ERP infrastructure requirements, allocated job roles, and provided suitable solutions.

• Defined IT policies, managed IT assets, and ensured compliance with auditor's guidelines.

• Implemented audit recommendations and documented system arrangements accordingly. EDUCATION

B.E. Computer Science (B.S.)

Amravati University

07/1988 – 02/1993 Maharastra, India

B.Sc. Mathematics (B.S.)

Sardar Patel University

06/1985 – 05/1988 Gujarat, India

Contact this candidate