Praveen Kandalam Email: adi0zx@r.postjobfree.com
Lead Data Engineer – Development Phone : +1-412-***-****
Professional Summary
Over 14 years of IT experience in all phases of the software development life cycle using Data Warehouse, Business Intelligence and Big Data environments.
Around 4 Years of exclusive experience in Big data platforms as Azure Data Lake, Azure Blob Storage, Azure Data Factory, Azure Data bricks, Azure SQL, Azure Synapse Analytics, Snowflake Data warehouse, Cosmos DB, Hadoop, Python/Scala technologies.
Hands on experience
oSnowflake Data warehouse.
oWorked on complex SNOW SQL and Python in Snowflake
oWorked on Snowflake advanced concepts like setting up virtual warehouse sizing, query performance tuning, Data Sharing, UDF, Zero copy clone, Time travel and Data Pipelines (Streams and Tasks).
oAzure Data Lake, Data Factory, Data bricks, S3,EC2.
oGenerated/ Created SQL in Oracle and SQL Server to pull the data to snowflake.
oHadoop and its components like HDFS, Map Reduce, Hive and sqoop.
oShell scripting for large scale data ingestion.
oGood working knowledge with Python, Snow SQL and SCALA.
Good working knowledge on Python and Athena tables to generate excel reports.
Hands on experience
oDesign star and snowflake schemas.
oDesigning, developing & deploying SQL server integration services (SSIS) packages.
oCreating Reports using SQL Server Reporting Services (SSRS).
oGood exposer in Designing and Building the Dimensions and cubes with star schema and snow-flake schema using SQL Server Analysis Services (SSAS).
Experience in Writing SQL queries, Stored Procedure, functions using SQL Server 2008 R2
Experience in development processes Waterfall/Agile
Awarded “Microsoft Star performer” in the year 2012 from Microsoft.
Familiar with both on Agile and Water Falls methodologies as a Lead Developer.
Has strong hands on experience on ASP.NET1.1/2.0/3.5/4.0, C#.NET, ADO.NET, Entity Framework, LINQ, WCF, JavaScript, HTML/DHTML, MVC3, OOPS Concepts, TFS,VSS 6.0, Writing browser compatibility scripts, Visual Build, BizTalk Server, Writing complex queries on SQL Server 2000/2005, SQL agent jobs, Linked Server and DTS packages etc.,
Migrated databases\instances from SQL Server 2008 to SQL Server 2017 version.
Experience in working with multiple cross functional teams under strict deadlines. Efficient in creating joins and sub-queries for complex queries involving multiple tables.
Expertise in Power BI, Power BI Pro, Power BI Mobile.
Expert in creating and developing Power BI Dashboards in to rich look.
Expert in creating Drill Down and Drill Through, Ad Hoc, Parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS.
Technical Skills: -
Cloud Technologies
Snowflake, Azure (Database, Data warehouse, Data Lake,Data bricks, Blob Storage),HDFS, AWS (S3,EC2, EBS, Data Pipeline), Microsoft Power BI and Python, Azure DEV OPS.
Development Tools
SSMS, SQL Server Data Tools, BIDS, SQL Enterprise Manager, Query Analyzer, SQL Profiler, SQL Server Dashboard
Source Control
Azure DEV OPS, Git Hub, TFS.
Tools/ Utilities
Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, QlikView, SQL Server Management Studio (SSMS), Visual Studio, TOAD, Putty, Import/Export, SQL*LOADER, SQL Developer, CVS, DTS Package, UML, Erwin, Cognos, WinSCP, MS Excel, MS Project, MS Visio
Functional Expertise
Manufacturing, Insurance, Inventory, Retailer, Finance, Banking.
Languages
Python, Scala, SQL, T-SQL, PL/SQL, ASP.NET, C#.NET,VB.NET, HTML, UNIX shell script, Java Script.
Operating Systems
UNIX, Windows, Linux
Hitachi Consulting Experience
PPG
Data Engineer, Automotive Refinish Nov 2013 – Current
Understanding existing data warehouse and process and involved in data lake implementation.
Data Ingestion and process flow to Enterprise Snow flake Data warehouse.
Migrated PPG legacy data warehouse platform into Enterprise Snowflake Data warehouse for eTransfer system.
Implemented automated data transfer workflow from sqlserver to S3.
Created Delta tables to store the process results in a tabular format.
Migrating large reports and manager data analytic outputs using Microsoft Power BI.
Designed and Developed PPG financial data modeling.
End-to-end support to existing data analytic platform through data storage, dashboards, data ingestion, and reporting.
Work closely on servers, performance/tuning, security, capacities, and database support.
Plan, build, deploy, and maintain enterprise OLTP and OLAP based EDW platforms and services.
Translate business requirements and develop technical specifications.
Initial analysis for various support issues.
Creating Refinish financial reports.
Building various reports using Power BI, Qlick view and SSRS.
Development and maintenance of existing and new SSIS packages.
Creation of new tools and reports for Controllers and Traders using SQL server (t-sql).
Writing complex PL SQL packages and stored procedures for legacy PPG Refinish Data warehouse.
Creation of database objects such as Stored procedures and TSQL queries.
Writing functional and Technical specifications.
Technologies: Snow flake Data warehouse, Azure Data Lake, Azure Data Factory, Azure Data bricks, HDFS, Spark, Scala, Python, Microsoft Power BI, Cosmos DB, Microsoft SQL SERVER, SSIS, SSRS, SSAS, Oracle, Cognos, QlickView,ASP.NET, MVC4, VB.NET, C#.NET, Web API, Azure DEV Ops.
Microsoft
Business Intelligence Lead, MBSIT Oct 2011 – Oct 2013
The primary responsibility to help define and implement the best methodologies to release high quality products/services. Working closely with Program Management to drive quality through all stages of SDLC from design to implementation through deployment and beyond.
Working on developing ETL process (SSIS package) to transform source system data to target system for downstream reports.
Coordinating with Offshore team to make in time deliverable and collaborating with QA/Rest team to identify and troubleshoot issues in UAT and PROD.
Involved in documenting knowledge base article for all trouble shoot steps and resolutions for Operation support including value add tools and utilities.
Designing and developing Cubes.
Involved in writing functional and technical specification document including use cases with comparing with BRD document.
Involved in writing stored procedures, views, triggers and SQL scripts using SQL Server.
Involved in Estimations.
Creation of new process flow structures and applications to cater the same.
Creation of new tools and reports for Controllers and Traders using SQL server (t-sql).
Unit Testing.
Technologies: SSAS with MDX, SSIS, SSRS, SQLSERVER 2008 R2, ProClarity
Microsoft
MS Dynamics AX Boot Camp Aug 2011 – Sep 2011
Attended MS Dynamics AX training at Microsoft Fargo Campus.
Technologies: MS Dynamics AX.
Valassis
Senior Developer, Valassis DOX Aug 2010 – May 2011
Involved in data migration part from MS Sqlserver to Oracle 11g R2.
Coordinating with Offshore team to make in time deliverable and collaborating with QA/Rest team to identify and troubleshoot issues in UAT and PROD.
Worked in SQL Profiler and DTA (Database Tuning Advisor Wizard) to analysis the performance.
Developing Database objects like Stored Procedures, Functions and Triggers.
Create DTS package for bulk transformation of data, SQL jobs, Linked Servers and Performance Tuning on the databases using SQL Profiler.
Peer Code review.
Involved in Preparing Functional and Technical Specs.
Involved in Development.
Involved in Unit Testing.
Technologies: Asp.Net, C#.Net, Oracle 11g, Silver Light, WCF, MS SQL SERVER, SSIS, SSAS.
Prior Work History
Keane
Team Lead, NTS (New Ticketing Solution) Feb 2010 – Jul 2010
Interacting with Onsite Coordinator and gathering the requirements.
Offshore Development, Support for existing system.
Team management.
Involvement in requirements gathering and interact with client.
Preparing of Functional and Technical Specs.
Database design and development (Involved in DB design, query tuning, writing stored procedures).
Commended for delivering on time and partnering with stakeholders to finalize scope for different project milestones. Collaborate with Test team and Build Engineer Ops team to identify and troubleshoot issues in UAT and PROD.
Unit Testing.
Technologies: SQLDBA, SSIS, SSRS, SSAS, Replication, Mirroring, Clustering, Performance tuning, C#.NET, ASP.NET, MVC,VSTF, Silverlight, JavaScript, XML, SharePoint, Outlook
Keane/NTT Data Systems
Senior Software Engineer, SuperValu Jun 2008 – Jan 2010
Onsite Coordinator at client place (BOISE, USA).
Database design and development (Involved in DB design, query tuning, writing stored procedures).
Involvement in requirements gathering and interact with client.
Developing User Controls and web pages in ASP.NET 1.1.
Developing Database objects like Stored Procedures, Functions and Triggers.
Coding.
Peer Review.
Unit Testing.
Technologies: ASP.NET,SQLSERVER 2005,WCF
Keane/NTT Data Systems
Senior Software Engineer, Balboa Insurance Jun 2005 – May 2008
Involvement in requirements gathering and interact with client.
Interacting with Onsite Coordinator and gathering the requirements.
Preparing of Functional and Technical Specs.
Team management.
Database design and development (Involved in DB design, query tuning, writing stored procedures).
Unit Testing.
Technologies: SSIS,SSAS,WCF,ASP.NET,SQLSERVER 2005
PbSystems
FoxCSR (Customer Services Register Phase 1) Jun 2003 – May 2005
Designed and Coded for Material Order Module which involves Creation of Material Order with Contract, Material Order without Contract Material Order Search Screens.
Developed Reports For all the Modules Using Crystal Reports 9.0.
Implemented N-Tier architecture with Presentation Layer, Business Façade Layer, Business Rules Layer, Data Access Layer and Common Layer.
Writing Httphandlers for handling .paspx type of files.
Writing required stored procedures in SQL SERVER 2000.
Deployed the version’s on to staging.
Education and Certifications
Master’s degree in Computer Applications, Nagarjuna University, India.
Bachelor’s degree in Computer Science, Nagarjuna University, India.
Intermediate, Board of Intermediate, Hyderabad, India.
SSC, SSC Board, Hyderabad, India.