Ramdhani Yadav

Experienced AWS Solution Architect and Data Engineering Manager having 22+years of expertise in Software development, ETL development and data analytics. Worked on various tool and technologies like AWS Glue, Snowflake, Redshift, SQL, Alteryx, Starburst, SSIS, Athena, Pyspark, Python and Oracle Apex and VBA. Worked on Data modeling, Data cataloging and Legacy Platform Modernization. Skilled in Architecting, designing and implementation of cloud-based data solutions, modernizing legacy data systems, and leading teams of data engineers and developers.

• Account Receivable and Account Payable anomaly detection (AWS Glue, S3 and AI)
• Service now Account receivable sentiment analyses (S3 Athena view and AI)
• Projects: Debtors Ledger (Transactions) : AWS GLUE, S3, Snowflake, Athena, Lambda, Event Bridge
• Global daily sales report (GDSR) : AWS Glue, Snowflake, S3
• Sales Transactions (Data Mesh): Mosaic, Starburst
• Risk and Opportunity : Oracle Apex, Oracle DB, Power BI
• PVM : Oracle Apex, Oracle DB, Snowflake
• PNS EB Home : Oracle Apex, Oracle DB, Power BI
• Monthly pricing : Oracle Apex, Oracle DB, Power BI

• Project and Data Lead
• Technology being used: AWS Glue, Python, Py-spark, Athena, Redshift, Alteryx, PowerBI
• Short Summary of Project completed at Accenture: Novartis – Worked on Snowflake DB to create data model, Alteryx Workflows, reporting, automations & data quality improvements
• NCR Analytics –Worked on SSIS, SQL server 2019 and SFTP and did End to End automation and created approx. 45 ETL packages and stored procedure, reports.
• Flyerops - Worked on Alteryx and Redshift and created many workflows and did scheduling the workflow in Alteryx Gallery for schedule run.
• GSK (GlaxoSmithKline Pharmaceuticals)– Worked with GSK on Databricks, py-spark and crated many transformations in pyspark and crated data tables and reports.

• Design, Development, Documentation, Deployment and Unit testing
• Technology being used: SQL 2008/2014, SSIS, SSRS, Crystal Report, MS Excel & Access Macro
• Projects: FACETS (UAFC Reporting and Support Project) Facets is TriZetto's enterprise-wide software solution for health Insurance administration. Facets helps organization support the consumer-directed products demanded by today's retail healthcare market and deliver advanced care management capabilities.
• Facets MA OCC Reporting Requirement gathering, ETL Developing using SSIS, Writing SQL Code for reporting.
• Development of Data modal, Data warehouse, Stakeholder Management, Team Management.

• ASP, VB, HTML, SQL 2000
• Projects: Noc@Saaz Noc@Saaz (Network-Operations-Centre – System Analysis and Administration by Zenith) is web-based networking application. The basic purpose of this system is to handle ticketing and task activities.

• Analysis, Program specification, Coding, Developer Testing
• Technology being used: ASP.Net, C#.net, SQL 2000, VB6
• Projects: Datacomp web tech is web-based application for datacomp customers. The main purpose is this site is to provide online facilities to customers like online purchase, online download, free down load, version history, hot fixes, channel partners, online payment, industry news and articles etc
• ECRM application for insurance intermediary channels. This application is designed for the clients of LIC agents to get a 360 degree view of their insurance portfolio.
• Broker Magic This project was developed for Insurance Brokers to maintain the insurance transactions for life and as well as non life. App has features like Client creation, policy creation, premium posting, quotation creation, Reconciliation, keeping track on Commission Receivable from insurance companies and Incentive payable to the executives and reports like portfolio, reconciliation, premium due, incentive receivable reports etc.

• Analysis, Design, Coding.
• Technology being used: Visual Basic, SQL Server, Oracle, , Informix, DB2
• Projects: Table Create Application Project was to create Table and constraints in Informix, SQL 7.0, Oracle and DB2 databases without having knowledge of sql syntax. User can define or alter the primary or composite key of the existing table or on the new table. User can define the scale and precision on the existing table or on new table.
• Cyber Portals (Global Inventory System) Project was related to supply chain management system. In this system client can give the orders and according to order we create receipts. The two strong modules in this project are Orders and Receipts.

• Analysis, Program specification, Design, Coding. Developer Testing
• Technology being used: VB 6, SQL Server 7.0 and Crystal Report
• Projects: SMART Investment Consultant (SMARTIC) Attendance System Technology being used: VB 6 and MS Access 97 Role: Development.