Jignesh Pandya

Results-driven Data Architect with over [20+ years] of experience designing and implementing scalable, secure, and high-performance data solutions. Proven expertise in data modeling, database architecture, ETL development, and cloud-based platforms (AWS, Azure Databrics),. Strong collaborator with cross-functional teams to drive digital transformation, improve data governance master data management and enable advanced analytics.

Integration of ERP like ecc6.0 and s4hana through SAPBW and informatica. To grow professionally utilizing my experience in Data Modeling, Enterprise Data Warehouse Design, Operational Datastore Design and other innovative techniques to upgrade the standard of works. Implementation of AI/ML based flow and customer analytics real-time.

Statistics and predictive model analysis

Lead Solution Architect(General Manager) - Fairfax Asia Analytics (Paramount)

(2022-06)

• Designed and implemented an enterprise-wide cloud-based data warehouse, reducing reporting latency by 60% on power Bi with stack holder management and technical accelerating.
• Oversee the design and deployment of robust, automated ETL/ELT data pipelines, accelerating data availability. Collaborated with data engineers and analysts to define logical and physical data models.
• Established and enforced enterprise-wide data governance frameworks, standardizing Master Data Management (MDM) and data quality initiatives across all core business unit.
• Demonstration and Orchestration innovative design and business benefit to stakeholders and leadership.
• Design new BI Analytics platform iDMA.
• Led modernization of legacy data systems, migrating 25+ on-premise SQL Server/postgresql databases to Azure SQL and Data Lake.
• Migration of Legacy BI system to New platform of iDMA
• Provide prediction model for insurance Business for pricing.
• Design and implement Data Chatboat with Visualization
• Directed advanced AI/ML initiatives leveraging Azure ML, Vertex AI, and Databricks MLFlow to build predictive insight models that boosted business forecasting accuracy
• Managed complex partner and vendor ecosystems to ensure the timely, budget-compliant, and high-quality delivery of external analytical solutions.
• Mentor, build, and lead a high-performing team of 25 professionals across data engineering, BI, data science, and data governance, fostering a culture of innovation and continuous learning.
• Successfully developed and managed a modern lakehouse architecture, improving data processing efficiency and reducing infrastructure overhead.
• Implementing price and claim forecast predictive model.
• Implemented unstructured data processing for TPA solution.

Sr. Consultant - Manthan System

(2019-09 - 2022-06)

• Manage and develop Vendor Link modules like PO to Payment, SQ to SO, Reconciliation, TnA for manufacturing unit.
• SAP S4HANA integration and warehouse to create inbound and outbound for business aspeit’s.
• Streamline vendor procurement and sales order business process.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.
• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Created Reports using Charts, Gauges, Tables, matrix.
• Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
• Created Drill Down Reports, Drill Through Report by Region.
• Integrate complex Data model in POWER BI
• Optimize power BI query in query editor
• Implement complex business analytics using efficient DAX.
• AWS redshift and s3 bucket.
• MS Sql server management and backup

Asso. Principal Engineer - NFDIL

(2015-04 - 2019-08)

• Etl development on informatica and arcsync
• Informatica Version upgrade with load balancer and fail over.
• SAP HANA Migration of existing integration.
• VL support and requirement roll out.
• Server and database monitoring for VL.
• Informatica web service and Application integration through abap.
• S4hana integration
• Informatica difference source integration.
• Report and scoreboard deployment using schema object.
• AWS redshift and s3 bucket.
• SAP BW development.

LEAD ENGINEER - IGATE

(2014-12 - 2015-04)

• POC did for oracle datawarehouse and orange client.
• Install 11g oracle database on solaris platform.
• Confgure and monitor Rman backup and monitoring.
• Server and database monitoring.
• Space management for datawarehouse server.

Assistant Manager - FRL

(2010-04 - 2014-12)

• Developed various project on datawarehouse informatica and bi microstrategy reporting tool including design,development,testing and implementation.
• Datawarehouse and Bi mistmatch issue debug and resolution.
• Development and Imementation of manthan project various modules like MA, CA and VL on vectorvise database.
• Validation for MA and VL modules.
• Microstrategy server management cube and schedule job developement and implementation.
• Worked on transformation like Lookup, Joiner, Aggregator, Expression, Filter, Router, Sequence Generator and Update Strategy.
• Performed debugging and tuning of mapping and sessions.
• Debugging and resolution of mapping and maplet.
• Data loading support.
• Matrix and attribute creation and testing.
• Designing,develop, testing data mart and cube and complex report.
• Scheduling job.
• Loaded Dimension tables using SCD type 1 and SCD type 2.
• Data ware house migration from Greenplum to vectorwise DB on 9.5 from 9.1
• UNIX shell scripting.
• To create Development/Test databases, create schema, users, create database objects, maintenance and performance tuning of the database.
• Configure database parameters for database performance, tuning and monitor the growth of the database objects for capacity planning
• Set up the Cron tab job for refreshing the Snapshots.
• Create users and grant privileges according to the requirements
• Perform database, schema level refresh from one database to another basing on the requirement from the application team
• Test and implement procedures to detect the poor database performance, collect required information, and perform root cause analysis
• Tune and improve the performance of the Oracle databases
• Performed Backup and restoration of databases using RMAN and datapump.
• Co-ordination with application development team
• Using ETL Tool for data loading and outbound (informatica)
• Advance Report development and analytics dashboard development and automation
• User previleges, and security and backup policy design and implementation
• Object monitoring
• Cube deployment
• Report development,deployment and scheduling
• Environment: SQL, PL/SQL, Oracle 10g,11g RMAN, ETL(infromatica),BI, Apache, Microstrategy and Manthan

System Engineer - Elitecore Technologies Ltd.

(2008-02 - 2010-04)

Elitecore Technologies is a leading provider of Convergent Billing, Provisioning and Customer Acquisition Solutions and Internet Management Solutions in a TELECOME DOMAIN. Established in 1999 by Eclipse Micro Computer Inc., based in New York, Elitecore is a dynamic young player with a 75% growth rate since inception.

Working

As a SYS Engg. in ‘CRESTEL’ Project. CRESTEL Convergent Billing is a carrier-grade solution enabling next generation voice, video, data services over wire line / wireless networks, offering Convergent Billing, Policy Management, Real time Rating & Charging, & AAA

• Installation & Configuration of Oracle Software & Databases on various OS Platforms
• Configuring RAC in Linux.
• UNIX shell scripting.
• Applying latest Oracle patches for Oracle 9i database.
• To create Development/Test databases, create schema, users, create database objects, maintenance and performance tuning of the database.
• Migration from 8i to 9i10g using Exp/Imp.
• Configure database parameters for database performance, tuning and monitor the growth of the database objects for capacity planning
• Set up the Cron tab job for refreshing the Snapshots.
• Administering through Oracle Management Server (OEM).
• Generated and analyzed AWRRPT and ADDM Reports
• Create users and grant privileges according to the requirements
• Perform database, schema level refresh from one database to another basing on the requirement from the application team
• Test and implement procedures to detect the poor database performance, collect required information, and perform root cause analysis
• Tune and improve the performance of the Oracle databases
• Performed Backup and restoration of databases using RMAN.
• Co-ordination with application development team
• Implement and support Data guard configuration.
• Maintain server
• Schedule job and store procedure implementation
• Data guard config. And monitoring