Darshana Pandit

Charlotte, NC 704-***-**** ad4nze@r.postjobfree.com linkedin.com/in/darshanapandit

IT Tech Lead

IT Lead with 15+ years of extensive experience in a Fortune 500 healthcare company and others in the travel, financial services, department store, and shipping industries. Expertise in leading a team of engineers spread across onshore and offshore locations. Extensive experience in database design, SQL, PL/SQL, ETL processes, C#.Net, Web services, APIs and hands-on development of cloud-based applications. Known for timely resolution of production incidents, ensuring 24-hour business continuity, and streamlining critical business processes to achieve performance gains. Expert in risk mitigation, root cause analysis, effort estimates and timelines, requirement gathering, design & development, code reviews, UAT, dealing with non- technical stakeholders, Agile methodology, drive daily standup meetings. Adaptability and clear communication are my key to creating a cohesive and high performing team.

Areas of Expertise

Databases ETL Data warehousing Queries Reporting Azure Cloud Solutions Scripting Web technologies Agile Mentoring Scope, Schedule and Resource management

Technical Skills

Oracle SQL server SQL PL/SQL SSIS Salesforce CRM Salesforce Data Loader Workbench Informatica Power Center Power BI Azure Data Factory Azure Databricks Azure Data lake Azure DevOps Azure Synapse Data Analytics Azure Stream Analytics Python PySpark Java JAMS workload automation SSAS SSRS Crystal Reports SQL Server Agent IBM Cognos TOAD SQL*Plus Netezza MS Access DB2 Teradata C# VB.NET ASP.Net Visual Basic XML Unix shell scripts Windows PowerShell Rest API Web Services Angular JS MVC XML HTML SOAP CSS JavaScript Pearl JSON ServiceNow Bitbucket Jenkins GitHub JIRA TFS Windows Linux

Professional Experience

Cencora (AmerisourceBergen)

IT Tech Lead, Sep 2016 – Nov 2023

As an IT tech lead of “Patient Services & Data Management” team, collaborated with cross-functional teams including Data Engineers, Data Scientists, Quality, Change Management, Business Analysts, Product Owners, Operations, Delivery managers, Scrum masters, DBAs, System admins, clients, and vendors. Worked closely with Release & Deploy team for configuring and maintaining CI/CD pipelines.

Responsibilities & Achievements:

•SPOC for Data Governance approval, for production server maintenance, patching, reboot and change deployment process.

•Escalation Point of Contact for data discrepancies in Salesforce CRM and downstream Oracle database.

•Conducted sprint meetings, wrote Features and User Stories and stamped approvals on UAT.

•Led team of 10-12 developers onsite and offshore.

•Designed, developed, and maintained Web API, Web services using ASP.NET and C#.

•Developed stored procedures, functions, views, triggers, and packages in Oracle databases and SQL Server.

•Re-designed and maintained critical downstream SCD process, to capture incremental/full updates from Salesforce to Oracle, through Informatica ETL process.

•Streamlined critical long running business process, by fine tuning queries and purging more than 300M unconnected records, achieving a 40% performance gain.

•Designed data masking of patient PHI info ensuring adherence to CCPA privacy law using Python.

•Re-designed slow running processes, to improve performance of parsing inbound EDI files, using python scripts to update Salesforce CRM data on time.

Darshana Pandit

Charlotte, NC 704-***-**** ad4nze@r.postjobfree.com linkedin.com/in/darshanapandit

•Hands on experience developing pipelines and processing data using Microsoft Azure Data Factory, Azure Synapse Analytics and Azure Databricks.

•Moved legacy data and log files to Azure Blob storage using shell script and Azure Storage explorer.

•Analyzed and implemented code changes resulting from Oracle upgrade from 12c to 19c and SQL Server 2008R2 to SQL server 2016 and upgraded 200+ SSIS packages.

•Upgraded .NET applications to higher framework to support TLS protocol 1.2.

•Experienced in star schema in SSAS for reporting purposes.

•Designed process to generate Opsgenie alert to report long running critical processes.

•Developed Power BI reports, as a one stop shop, for operations and Leadership, to track data feed status real-time.

•Mentored cross functional team in using PBI reports to automate manual work.

HRG North America (Amex Global Business Travel)

Project Lead Development, Oct 2011 – Sep 2016

As a Project lead development, Tuned SQL server databases for performance. Wrote complex stored procedures and functions.

•Lead a team of developers onsite.

•Worked closely with stakeholders, DBAs and Release and deployment team.

•Gathered business requirements, created proof of concepts, technical specifications, and data flows.

•Designed and developed SSRS reports, SSIS packages and maintained SSAS cubes.

•Designed and developed C#.NET web applications and Web Services.

Tata Consultancy Services,

Project Lead Development, Jun 2006 to Sep 2011

Clients: Bank of America, Charlotte, NC, Humana Healthcare, Lancaster, SC, JCPenney, Plano, TX, NYK Line, Secaucus, NJ.

InteleCorp Software Private Limited

Senior Software Engineer, Sep 2003 – Jun 2006

Education and Professional Development

India

Bachelor’s, Computer Science and Engineering

IBM-ICE, Web programming and Advance Java.

Trainings and Certifications

Microsoft certified Technical Specialist, Microsoft SQL Server 2005 Business Intelligence Development and Maintenance.

Six Sigma

Salesforce Administrator, CRT101.

Microsoft Azure, AZ-900, DP-900 and DP-203.

PMP – Currently attending bootcamp to pursue PMP certification.

Contact this candidate