Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pinky Sharma

Bridgewater,NJ

Summary

Around 16 years of Software Development and Production Support experience in SSIS packages, Tableau reporting, Enterprise data lake, Hadoop, Big data technologies, Alteryx workflows, Database and Applications.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Technical Lead

TCS- Johnson & Johnson Client
01.2022 - 04.2024
  • The purpose Global Brand Protection is to further enable the Brand Protection professionals to develop a pro-active brand protection plan by establishing an enterprise-level illicit trade data science competency
  • Data science and data visualization concepts will be applied across a multitude of subject areas using Tableau and Starburst tool to drive the actions to mitigate the risk of illicit activities.
  • Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
  • Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
  • Evaluated and recommended new tools and technologies that resulted in increased development efficiency and up-to-date technical skillsets within the team.
  • Implemented continuous integration and deployment strategies for faster release cycles and improved application reliability.
  • Increased application stability by regularly monitoring performance metrics, addressing bottlenecks proactively to minimize downtime occurrences.
  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.

Technical Lead

TCS- Johnson & Johnson Client
08.2016 - 12.2021
  • Enterprise Data Lake Projects (EDL) and Tableau Reporting
  • Enterprise Data Lake integration for Atom reporting, Omega, PANGEA, ATLAS Marc, Global brand protection system involves importing data from different source systems or files into EDL and performing transformations and modelling for reporting purpose.
  • Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
  • Coordinated with cross-department teams like QA, DevOps, and Support to ensure seamless end-to-end software delivery process.
  • Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
  • Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
  • Increased application stability by regularly monitoring performance metrics, addressing bottlenecks proactively to minimize downtime occurrences.

ETL Developer

TCS- Johnson & Johnson Client
09.2013 - 07.2016
  • Insight reporting project involves with financial planning, budgeting, forecasting, and consolidating for MD&D, Consumer and Pharm segments.
  • Developed custom reports for business stakeholders, providing valuable insights into key performance metrics.
  • Mentored junior developers on best practices in ETL development, fostering culture of continuous learning within team.
  • Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
  • Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
  • Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
  • Contributed significantly towards meeting project deadlines by maintaining keen focus on task prioritization.
  • Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
  • Deployed scalable solutions capable of handling large volumes of data while maintaining high standards of reliability and performance.
  • Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
  • Supported various ad hoc requests from end-users by delivering accurate datasets as per their requirements.
  • Optimized resource allocation through effective workload balancing techniques, improving system performance during peak usage times.
  • Gathered, defined and refined requirements, led project design and oversaw implementation.
  • Developed and delivered business information solutions.
  • Established and secured enterprise-wide data analytics structures.

Web Developer

ConAgra Foods Inc.
06.2008 - 08.2013
  • Con Agra Foods is one of America's largest branded food companies, supplying the consumer and food service channels, as well as manufacturers, with trusted quality brands and services
  • In this Project, provided production support for various applications which includes resolving daily job failures, fixing bugs that are encountered FFG, GFG, RFG areas, Providing and terminating access of users, Execution of Change Requests projects.
  • Conducted root cause analysis on recurring incidents to identify opportunities for improvements in application design or support procedures.
  • Maintained strong relationships with stakeholders by providing exceptional service and communication throughout issue resolution process.
  • Analyzed and mapped data and wrote SQL scripts to extract data from SQL databases.
  • Provided 24/7 support for web- and client-based applications, file and data feeds and batch processes to prevent impact to business.
  • Optimized system performance through routine maintenance tasks such as database backups, log file reviews, and server health checks.
  • Collaborated with developers, analysts and project managers to expedite incident resolutions.
  • Managed incident tracking system, ensuring accurate records and timely follow-ups on outstanding issues.
  • Supported end-users in navigating complex applications, guiding them through features and functions while troubleshooting issues as needed.
  • Enhanced application performance by identifying and resolving technical issues in a timely manner.
  • Improved application stability through proactive monitoring, issue identification, and prompt resolution of incidents.
  • Participated in on-site requirements gathering sessions.
  • Developed diagrams to describe and lay out logical operational steps.

Education

Bachelor of Science - Computer Science

Kurukshetra University
Haryana,India
07.2007

Skills

  • Tableau 20101, Alteryx desktop 20231, Starburst Enterprise platform, SAP BPC, SSIS packages, Tidal, Control-M, putty, Hue
  • SQL, Python, Shell script
  • Systems Development Lifecycle Management
  • MySQL, Oracle, SQL Server, Enterprise data lake (Cloudera), Postgres, Redshift
  • Scrum Framework
  • Requirements Gathering and Analysis
  • Process Improvement
  • Configuration Management
  • Agile development methodologies
  • Software Development Tools: JIRA, Confluence
  • Functionality Implementation

Certification

Scrum master (PSM2) and Azure-900 fundamentals

Timeline

Technical Lead

TCS- Johnson & Johnson Client
01.2022 - 04.2024

Technical Lead

TCS- Johnson & Johnson Client
08.2016 - 12.2021

ETL Developer

TCS- Johnson & Johnson Client
09.2013 - 07.2016

Web Developer

ConAgra Foods Inc.
06.2008 - 08.2013

Bachelor of Science - Computer Science

Kurukshetra University
Scrum master (PSM2) and Azure-900 fundamentals
Pinky Sharma