Cognizant

Big Data Analyst

Talent Path, a SkillStorm Company

Cognizant | AbbVie

●	Identified and resolved complex data quality issues, ensuring the utmost accuracy and integrity of the data.
●	Spearheaded the validation and verification process for weekly ETL processes, resulting in a significant enhancement in downstream data consumption and decision-making capabilities.
●	Provided extensive support for data refresh activities and conducted comprehensive analyses to optimize data efficiency.
●	Developed and implemented highly validated logic calculations, significantly improving the accuracy and reliability of KPI metrics.
●	Led the testing and validation efforts for KPI metrics enhancement, leading to consistently on-time deliveries and improved operational efficiency.

SkillStorm	February 2022 - Present 
●	Architected and executed a cutting-edge, fully automated event-driven ETL pipeline using AWS Lambda functions, EventBridge, CloudWatch, S3 buckets, and Glue Studio Jobs and Crawlers, seamlessly integrating API services from diverse sources.
●	Demonstrated expertise in database management by designing and maintaining Postgres databases, leveraging the power of sqlalchemy and Pandas libraries.
●	Conducted thorough exploratory data analysis (EDA) on a large-scale taxi's dataset, leveraging the power of Spark for efficient data processing and deriving valuable insights.

Data Engineer

Advance Auto Parts

As a Retail Parts Pro/Commercial Parts Pro I was part of the management team and in charge of making sure our customers leave with a smile on their face and with their problem solved or in the way of being solved. In my duty as a Retail Parts Pro I had:

•Contributed to a 15% increase in customer retention by achieving 120% of the target number of customer Speed Perks enrollment (10 customers per day).
•Demonstrated strong organizational and time management skills by leading high quality and before-time completion of more than 4 in-store merchandise distribution projects per month from June 2020 to January 2021.
•Contributed to 10% of store revenue by achieving a 130% dollar per transaction goal (more than 30 dollars per transaction) plus 120% transaction per hour (more than 4 per hour).

Retail Parts Professional

Thinkful

As part of this program, I've learned data analytics in-demand skills like statistical analysis, data visualization, presentation design, data cleaning, data discovery, data exploration. As well as being able to perform those operations in Excel, Tableau, Python, PowerPoint, PostgreSQL.

Recent Projects:

Michael Jordan's Performance - Python, Pandas, NumPy, Statistics
• Consolidated dataset from https://sports-statistics.com/ and created data frames with Pandas.
• Conducted exploratory data analysis to determine which variables address Michael Jordan's performance.
• Validated biases in the variables with A/A testing.
• Computed descriptive and inferential statistics.
• Formulated hypothesis to be tested.
• Designed data visualizations with Matplotlib and Seaborn.

Housing Prices - Excel, A/A testing, Statistics, Powerpoint
• Cleaned and analyzed the data provided for the housing prices in Ames, Iowa 2006-2010.
• Performed exploratory analysis to determine which variables to select.
• Computed the descriptive statistics and validated that the dataset was unbiased enough to perform inferential statistics.
• Calculated the inferential statistics and evaluated which factors presented significant statistical differences in Excel.
• Designed a presentation and explained the factors that drive house price sales with Powerpoint.


Lariat Rent a Car - Excel, Powerpoint
• Consolidated and analyzed the data provided by Lariat Rent a Car.
• Examined data trends and developed data models and strategies to increase revenue up to 35% using Excel.
• Developed easy-to-follow visualizations in Excel.
• Designed and directed a presentation using PowerPoint.

Data Analytics Student

As a meticulous data engineer with a strong command of SQL, Python, and Spark, I have had the privilege of supporting the data operations of esteemed companies like Cognizant and AbbVie in their data operations during my tenure at SkillStorm. With a solid foundation in customer service-related roles spanning over 4 years, I have honed my communication, problem-solving, and management skills to effectively handle challenges and deliver optimal results.

Taplio

Pedro M.'s Linkedin Analytics

Pedro M.

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Pedro M.'s Linkedin Analytics

Pedro M.

Want to drive more opportunities from LinkedIn?

Pedro M.'s Linkedin Analytics