DEEPAK M PANDIYAN

Dynamic Software Developer with a proven track record at Redcloud Soft Solutions Pvt. Ltd, adept at enhancing software applications and driving Agile processes. Proficient in SQL and Power BI, I excel in analyzing user needs and delivering impactful solutions, showcasing strong problem-solving and collaboration skills to achieve project goals. Innovative professional in software development, known for productivity and efficiency in completing projects. Possess strong skills in algorithm design, system architecture, and code optimization. Excel in problem-solving, communication, and teamwork, ensuring successful collaboration on complex projects.

Project Title #1: Lowe's Store, Retail Domain, USA

Description: Lowe's Companies, Inc. is an American retail company specializing in home improvement Headquartered in Mooresville, North Carolina, Lowe's operates a chain of retail stores across the United States and Canada. As one of the largest home improvement retailers in the world, Lowe's offers a wide range of products for home construction, maintenance, repair, and remodeling. The company provides items such as appliances, tools, hardware, lumber, building materials, and paint. With over 1,700 stores, Lowe's is committed to helping homeowners and professionals alike complete projects efficiently and effectively.

Roles and Responsibilities:

• Build automated data pipelines to replace manual Excel processes.

• Use tools like Input Data, Select, Filter, Formula, Join, Union, Multi-Row Formula, Multi-Field Formula

• Perform data validation and quality checks.

• Perform statistical analysis, predictive modeling, or spatial analytics when needed.

• Follow naming standards, folder structure, and version control.

• Designing and creating dashboards with interactive reports for better analysis,

• Fetching data from different kinds of source systems into Power BI Desktop,

• Creating calculated measures and columns with DAX in Microsoft Power BI Desktop,

• Worked on On-Premises Gateway to refresh the data sources and create a live connection

• Responsible for Managing workspaces

• Schedule automated jobs using Alteryx Scheduler or Alteryx Server.

• Publish workflows to Alteryx Gallery for user execution

Project Title #2: L Brands, Retail Domain

Description: Bath and Body Works (formerly known as L Brands) Duration: August 2021 to June 2022 L Brands, formerly known as Limited Brands, Inc., based in Columbus, Ohio

Its flagship brands include Victoria's Secret and Bath & Body Works. In March 2021, L Brands announced it will split Victoria's Secret and Bath & Body Works into two stand-alone publicly traded companies named Victoria's Secret & Co and Bath & Body Works.

Roles And Responsibilities:

• Explored data in a variety of ways and across multiple visualizations using Power BI,

•       Developed Power BI reports and dashboards from multiple data sources using data blending

•       Integrated custom visuals based on the business requirements using Power BI Desktop.

•       Debug errors, handle exceptions, and resolve data inconsistencies.

•       Improve memory usage with selective data sampling, caching, and efficient tool selection.

• Implement data blending, aggregation, sorting, parsing, pivot/unpivot operations.
• Perform statistical analysis, predictive modeling, or spatial analytics when needed.