Praveenkumar Devaraj

Experienced Senior Software Engineer with 9+ years of work experience specialized in BI and Data warehousing concepts with domain expertise in Retail & Telecom. Collaborated with major clients like AT&T, Cisco, JCPenney, Tailored Brands and Giant Eagle Inc. Worked in all phases of SDLC including requirements gathering, Design, Development, Unit testing and Deployment. Has good experience in new age technologies like Snowflake cloud data warehouse, Python and AWS S3 & Azure blob. Also worked on RDBMS like Oracle, Teradata and MS-SQL. Team player with analytical and problem-solving skills.

Snowflake SnowPro Certified

• Achieved on the spot awards & client appreciations for contribution towards new initiatives.
• Team player award

Key Projects

#1 Project Name: AT&T – Martech Orion – Saved Cart

client: AT&T Services Inc.

 Project Description

• The scope of the project is to analyze the cart events data of ATT.com for efficient Marketing & campaign purpose.

Contribution

• As a team member, was responsible for
• Analyzing and designing the code for loading cart events data to snowflake database
• Prepare the business logic to analyze the cart events data for an abandoned cart.
• Prepare the campaign data and load into a table based on different campaign frequencies and compliances.
• Export the campaign data and share it with campaign team.
• Scheduling the jobs using ODP Scheduler.
• Unit testing the SQL code in Snowflake environment.
• Code management using Azure DevOps.

#2 Project Name: AT&T – PMOSS Teradata to Snowflake Migration

client: AT&T Services Inc.

Project Description

The scope of the project is to migrate from Teradata to Snowflake cloud SQL code for faster and efficient reporting analytics.

Contribution

As a team member, was responsible for

• Analyzing and designing the code for migrating Teradata SQL to snowflake database
• Prepare the metadata for loading files into snowflake tables using droid framework.
• Migrating the Teradata views to snowflake DB.
• Convert the Perl script logics to Snowflake views.
• Scheduling the jobs using droid.
• Unit testing the SQL code in Snowflake environment.

#3 Project Name: Cisco SBP - BREXIT

Client: Cisco Systems Inc.

Project Description

To Meet GDPR compliance in Cisco all the EU customer data should be migrated from US datacenter to new EU data center.

Contribution

As a team member, was responsible for

• Impact Analysis of EU customers PII data in existing US datacenter
• Design and Development of new EU datacenter
• New BI report developments for EU customers using SAP BO
• New Unix environment setup for BT partner file storage.
• Unit testing the code and trial run.
• Supporting the QA team by sharing scenarios to validate.

#4 Project Name: Cisco Supplier Risk Analytics

Client: Cisco Systems Inc.

Project Description

To create an Integrated Data model - supplier selection for Audit: Downstream systems like Ethics, CSEP, D&B Financial risk, GM -ATF, Prepayment, Onboard supplier risk and Spend data to be analyzed.

Contribution

As a team member, was responsible for

• Analyze the various source of data required for building an integrated data model.
• Automated data load from Smartsheet/excel to Snowflake using Python.
• Automated supplier name standardization using python.
• Automated the ETL part in snowflake cloud data warehouse using python.
• Scheduling the jobs using Control-M scheduler.

#5 Project Name: Tailored Brands Teradata to Snowflake migration

Client: Tailored Brands 

Project Description

The scope of the project is to migrate from Teradata Datawarehouse to Snowflake cloud data warehousing.

Contribution

As a team member, was responsible for

• Analyzing and designing architecture plan for migrating around 1500 tables under various subject areas in snowflake database.
• Automating Data load to snowflake using python load script.
• Automating the file transfer and data comparison using python script.
• Automating table/view metadata comparison between Teradata and snowflake using python script.
• Scheduling the jobs using UC4 scheduler.
• Unit testing the SQL code in Snowflake environment.

#7 Project Name: Giant Eagle SSRS migration

Client: Giant Eagle Inc. 

Project Description

Developing SSRS reports and Power BI Dashboards across various subjects like Sales, Supply chain, Known loss and Shipment areas. Migrating reports from other technologies like OBIEE, Cognos, ASP.NET to SSRS 2016.The scope of the project is to develop 900+ SSRS reports and attractive Power BI dashboards using sales, shipment and customer data.

Contribution

As a team member, was responsible for

• Interaction with client for gathering Business Requirements & Project Specifications.
• Developed detailed design plan for the many SSRS and Power BI reports.
• Created attractive Power BI dashboards and published using Power BI service.
• Designed and developed the high-level drill down, drill through kind of SSRS reports. Framing SQL, Oracle queries to get the required data for the respective report.
• Created possible test cases and completed Integration testing.
• Provided support for UAT.

H1B