Sitaram Pal

646-***-****

ad0y3k@r.postjobfree.com

LinkedIn:- https://www.linkedin.com/in/sitaram-pal-a8b05330/ SUMMARY

Results-driven and highly skilled Data Engineer with extensive experience in architecting, designing, and implementing enterprise-level data solutions. Proficient in handling complex data pipelines, optimizing database performance, and leveraging cloud technologies to drive efficient data management. Proven ability to collaborate with clients, stakeholders, and cross-functional teams to deliver successful data engineering projects. Azure and Duck Creek Certified. WORK EXPERIENCE

Slide

New Jersey

Enterprise Data Architect - May 2022 – Till Date

• Designing and implementing an Azure Data Factory pipeline to extract Policies meant for conversion from one policy system to another Policy system with data in XML and JSON format using Rest API. The data is then transformed and loaded into Azure Synapse Analytics for further analysis.

• Leveraging Azure Databricks with Python to perform big data analytics on large Claims datasets and stored in Synapse for reporting purposes using Power BI by Business.

• Migrating on-premises data warehouse solutions to Azure Synapse Analytics, taking advantage of its integrated analytics capabilities and seamless integration with other Azure services

• Implementing a data lake using Azure Data Lake Storage Gen2 to store raw and unstructured data. Data is ingested from various sources and organized using Azure Data Factory.

• Creating APIs and data integration solutions using Azure Logic Apps and Azure API Management to enable seamless data exchange between different systems and applications.

• Skills Used in the project: Azure Data Factory, Azure Data Bricks, Data Lake, Delta Lake, Pyspark, Azure Synapse, Azure Logic Apps, Azure API Management, Azure SQL, Azure Key Vault. Duck Creek Technologies

Basking Ridge, New Jersey

Sr Technical Solutions Architect - August 2016 – May 2022

● Designing and Developing Duck Creek Policy, Billing, claims product User Stories, and data pipelines.

● Managing, Monitoring, and Triaging Production and UAT issues from clients.

● Database Designing, Development of OLTP and OLAP systems.

● Development and deployment of Duck creek application to Azure cloud.

● Production support, researching issues and addressing performance problems for various Duck creek clients hosted in Azure leveraging Azure Paas Services and IaaS clients.

● Extensively involved in resolving Performance bottlenecks in databases hosted in Azure SQL.

● I am assisting the Client and SI partners customize the Duck creek low-code application through configuration.

● Participating in Production Outage calls, Severity 1 and 2 issues.

● Working with the Engineering team for improvements in Duck Creek Tool

● Conducting training and assisting team members in coming up to speed with duck creek Cumulus architecture.

● Implementing SSO solution using Azure B2C

● Skills Used in the project: - Duck Creek Suite Application, C#, SQL, Azure SQL, Azure Key Vault, Azure B2C, Azure web app, Azure APIM, Azure Data Factory, Azure Data Bricks, AKS Accenture

Murray Hill, New Jersey

Solutions Architect - Apr 2006 - October 2016

● Designing and Developing Duck Creek Policy, Billing, claims product User Stories.

● Managing Production tickets for Various Clients

o Assisting Team members with Triage tickets by providing technical support and removing their blockage.

o Resolving Critical and Complex issues and documenting them. o Ensuring Ticket Queue is low and SLA is met.

● Managing calls with Cloud vendors for hosting Problems.

● Participating in Production Outage Issues.

● Managing Team Schedules / Setting Objectives / Growth Plans

● Managing new release upgrades

● Training new team members.

● Database improvement plans with DBA

● Application Performance improvement plans with Arch / Dev

● Managing the application's performance.

● Meeting with Leadership for Status / Future.

● Fixing Performance defects

o SQL queries optimized

● Skills Used in the project: - Duck Creek Suite Application, C#, SQL IIFL

Mumbai, India

Senior Developer – Oct 2003- Oct 2006

● Developed web-based and Windows applications for a stock broking firm. EDUCATION & CERTIFICATIONS

Bachelors in science Major Subjects Math and Stats (2003) Madurai University, India. CERTIFICATIONS

Azure and Duck Creek Certified.

SKILLS & INTERESTS

Skills: Azure Data Bricks, Azure SQL, Azure Data Factory, Azure Synapse, Azure Key vault, Azure Data Lake Gen2, Datarbicks Lakehouse, Azure B2C, SQL On-Premises, Pyspark, C#, ASP.net, ASP, Data Engineering, SQL Performance Tuning, SSIS, SSRS, Azure DevOps, Azure API Management, Logic Apps, Function Apps

Interests: Sports, traveling.

Contact this candidate