Data Engineer

Solely managed the organization’s entire Salesforce CRM environment, including user management, security settings, data model customization, and ongoing system maintenance.

Designed and optimized Salesforce objects, fields, workflows, and validation rules to support business processes and improve data integrity.

Executed large-scale data migration from multiple CSV sources into Salesforce using Pentaho Data Integration (Kettle), ensuring accurate mapping, data cleansing, deduplication, and transformation prior to import.

Developed reusable ETL workflows and transformation jobs to automate recurring data integration processes.

Configured and integrated FormAssembly with Salesforce to automate the collection, validation, and routing of form submissions.

Built and customized form connectors so that captured data seamlessly populated Salesforce records, ensuring real-time updates and reducing manual data entry.

Integrated Salesforce with SendGrid for email communications by leveraging Zapier workflows and SMTP configurations.

Automated lead and contact updates from email campaigns back into Salesforce to maintain synchronized marketing and CRM data.

Designed end-to-end automated data flows between systems, minimizing manual intervention and improving operational efficiency.

Documented integration workflows, data mapping specifications, and process dependencies for maintainability.

Implemented data validation, deduplication, and cleansing rules to maintain high-quality datasets in Salesforce.

Collaborated with leadership to design Salesforce reports and dashboards for operational and strategic decision-making.

Responsible for implementing data migration from SQL Server to the SAAS platform named SODA, focusing on optimizing workflows to minimize data processing time through the use of complex stored procedures;

Independently manage sensitive payments and donor data using SQL Server Management Studio, ensuring data quality by conducting metrics analysis and creating key performance indicators (KPIs) within Tableau dashboards for analysis;

Track project progress, monitor deliverables, and manage ticket issues efficiently using Jira, ensuring timely project delivery and ongoing support;

Assist stakeholders in making budgeting, marketing, and campaigning decisions by developing and presenting consumer insights in interactive dashboards. These insights are derived from data sourced from various online marketing platforms and presented using Tableau;

Implement and manage Git repositories using Bitbucket for version control, collaborating with development teams to establish proper branching strategies and facilitate efficient code integration and review processes using Visual Studio Code;

Collaborate with DevOps engineers to configure and manage Git repositories and CI/CD pipelines using Jenkins, with a focus on optimizing project performance, scalability, and security to ensure efficient and reliable project delivery.

Streamlining data migration workflows by designing and implementing migration processes from SQL Server to different SaaS platforms using ETL. Leveraging complex stored procedures using SQL scripts and performance tuning techniques to reduce data flow processing times by improving overall system efficiency by 30%;

Ensuring optimal data quality by managing sensitive information in SQL Server Management Studio. Conducting metrics analysis and developing Tableau dashboards to visualize KPIs, enabling stakeholders to identify trends and make decisions ;

Implemented and managed data governance frameworks using Collibra, ensuring compliance with JPMorgan Chase’s enterprise data standards and regulatory requirements;

Developed and maintained metadata catalogs, business glossaries, and data lineage tracking in Collibra to enhance data discoverability and governance transparency;

Monitored data quality metrics and conducted periodic audits using Collibra to identify data inconsistencies and ensure adherence to data governance policies;

Monitoring and tracking project progress using Jira, proactively addressing ticket issues and ensuring on-time delivery along with providing ongoing support to enhance project performance while maintaining operational standards ;

Developing consumer insights dashboards in Tableau, sourcing data from online marketing platforms. Collaborating with stakeholders to guide budgeting, marketing, and campaign strategies, leading to a 20% improvement in decision-making ;

Implementing version control processes by managing Git repositories in Bitbucket. Collaborating with development teams to establish branching strategies and conducting seamless code integrations and reviews using Visual Studio Code ;

Optimizing CI/CD pipelines by partnering with DevOps engineers to configure and manage repositories using Jenkins. Enhancing performance, scalability, and security of deployments, ensuring efficient and reliable project delivery.

Responsible for acquiring, cleaning, and structuring COVID-related patient data from vaccination sites using SQL scripts, ensuring data accuracy and quality for further processing;

Developed and maintained ETL Data Pipelines using Pentaho and AWS architecture to facilitate seamless data migration to target applications such as Salesforce and AWS, optimizing data analysis across various infrastructures;

Independently scheduled vaccination dose appointments using bulk email marketing, leveraging SendGrid to manage and communicate with vaccine recipients efficiently;

Played a significant role in contributing to data model decisions for projects involving data integrations and migrations to different target applications, such as Salesforce, AWS, and SQL Server. Ensured data integrity was maintained between systems by building custom integrations using APIs;

Responsible for developing and maintaining ETL Data Pipelines, enabling the movement of large structured and unstructured data from sources including SQL Server, flat files, and APIs. This data was loaded into Amazon Redshift data warehouse and database clusters to facilitate efficient data analysis.

Responsible for acquiring, cleaning, and structuring COVID-related patient data from vaccination sites using SQL scripts, ensuring data accuracy and quality for further processing;

Developed and maintained ETL Data Pipelines using Pentaho and AWS architecture to facilitate seamless data migration to target applications such as Salesforce and AWS, optimizing data analysis across various infrastructures;

Independently scheduled vaccination dose appointments using bulk email marketing, leveraging SendGrid to manage and communicate with vaccine recipients efficiently;

Played a significant role in contributing to data model decisions for projects involving data integrations and migrations to different target applications, such as Salesforce, AWS, and SQL Server. Ensured data integrity was maintained between systems by building custom integrations using APIs;

Responsible for developing and maintaining ETL Data Pipelines, enabling the movement of large structured and unstructured data from sources including SQL Server, flat files, and APIs. This data was loaded into Amazon Redshift data warehouse and database clusters to facilitate efficient data analysis.

Diligently monitored and customized user accounts within Salesforce CRM, ensuring a seamless user experience;

Responsible for the generation of reports and dashboards in Salesforce CRM to provide valuable insights and support data-driven decision-making;

Analyzed and constructed detailed client profiles within Salesforce, contributing to the enhancement of CRM marketing strategies and troubleshooting any related issues;

Successfully collected and migrated business data from Excel worksheets to Salesforce through bulk uploads using data loader, ensuring data accuracy and consistency;

Managed and maintained the company's Salesforce.com portal website using Community Builder setup, ensuring a user-friendly and informative online presence;

Provided valuable recommendations to the Director by leveraging predictive sales and engagement data analysis, aiming to improve customer engagement and revenue;

Acted as the primary point of contact for various departments within the organization regarding data and report requests, retrieving necessary data from custom objects and APIs in Salesforce using SOQL queries via Salesforce Inspector;

They played a key role in integrating Salesforce CRM with third-party applications like Mailchimp and QuickBooks, streamlining processes and enhancing data synchronization between systems.

Diligently monitored and customized user accounts within Salesforce CRM, ensuring a seamless user experience;

Responsible for the generation of reports and dashboards in Salesforce CRM to provide valuable insights and support data-driven decision-making;

Analyzed and constructed detailed client profiles within Salesforce, contributing to the enhancement of CRM marketing strategies and troubleshooting any related issues;

Successfully collected and migrated business data from Excel worksheets to Salesforce through bulk uploads using data loader, ensuring data accuracy and consistency;

Managed and maintained the company's Salesforce.com portal website using Community Builder setup, ensuring a user-friendly and informative online presence;

Provided valuable recommendations to the Director by leveraging predictive sales and engagement data analysis, aiming to improve customer engagement and revenue;

Acted as the primary point of contact for various departments within the organization regarding data and report requests, retrieving necessary data from custom objects and APIs in Salesforce using SOQL queries via Salesforce Inspector;

They played a key role in integrating Salesforce CRM with third-party applications like Mailchimp and QuickBooks, streamlining processes and enhancing data synchronization between systems.

Responsible for acquiring, cleaning, and structuring business data from multiple sources, ensuring data quality and presentation met high standards;

Developed proficiency in analytical practices using Python, harnessing data to enhance decision-making processes within the organization;

Actively constructed reports and dashboards using Tableau, visually representing key insights that led to data-driven actions aimed at improving business performance;

Maintained, queried, and regularly reviewed databases using MS SQL Server, seeking opportunities to enhance business models and processes;

Created detailed Excel workbooks that incorporated sales, public, and demographic data, employing complex formulas and macros to facilitate data analysis;

Identified, communicated, and recommended resolutions for data-related issues by querying the databases within MS SQL Server;

Dedicated efforts to optimize and monitor business performance to achieve increased accuracy, gain better insights, and streamline processes for improved efficiency.

Responsible for acquiring, cleaning, and structuring business data from multiple sources, ensuring data quality and presentation met high standards;

Developed proficiency in analytical practices using Python, harnessing data to enhance decision-making processes within the organization;

Actively constructed reports and dashboards using Tableau, visually representing key insights that led to data-driven actions aimed at improving business performance;

Maintained, queried, and regularly reviewed databases using MS SQL Server, seeking opportunities to enhance business models and processes;

Created detailed Excel workbooks that incorporated sales, public, and demographic data, employing complex formulas and macros to facilitate data analysis;

Identified, communicated, and recommended resolutions for data-related issues by querying the databases within MS SQL Server;

Dedicated efforts to optimize and monitor business performance to achieve increased accuracy, gain better insights, and streamline processes for improved efficiency.