PRASHANT PATTNAIK
Pune
Summary
15+ years of work experience in analysis, design and implementation in Data Engineering, Data Warehouse & BI solutions. Extensive experience in Talend Data Integration, DQ and MDM (Open Studio and Enterprise version), Stitch Data Loader, DBT, Design & Architecture, and implementation. Setup Talend TAC and Talend Cloud from scratch for enterprise projects. Successfully delivered business solutions with SQL Server, Snowflake Cloud Datawarehouse, ETL/ELT solutions with data cleansing and quality check, OLAP cube modeling, Dimensional Data Modeling, MDM, Dashboard reports. Exposure to source systems like Salesforce, Zuora, NetSuite, Global Service Desk, JIRA, Adobe Analytics, Eloqua, public FTP/APIs, Rest APIs, SOQL, Aqua API, Workday…etc. Delivered multiple data integration/migration projects. Complex SQL writing, Query Profiling, running custom Traces & Performance Tuning. Created dashboard and reports using various reporting tools e.g., SSRS, Power BI. Exposed to all phases of Software Development Life Cycle, Enterprise Reporting Life Cycle, Data Migrations, Problem Management, Escalation procedures and Agile development methodology. Having self-learning ability, quick learner, leadership quality and problem-solving skills. Managed and mentored a team of senior DWH/BI developers, Testers and DBA.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Senior Technical Lead
Avalara India Pvt. Ltd.
02.2016 - Current
- Company Overview: This is a data platform for Avalara’s internal business stakeholders and technology stacks
- As part of this project, we collected data from all our product lines, operational systems
- This project enabled our users to get single source of truth for all the corporate metrics
- Implemented the Data-lake and data warehouse on SQL Server and Snowflake Cloud Datawarehouse platform using various tools like Talend ETL, Stitch Data Loader, MDM, S3
- Mainly responsible for data architecture and design of our data platform
- POC on various ETL tools for evaluation of Stitch Loader, Snowflake, DBT
- Coordinate with stakeholders across globe regularly to understand the needs and implement the data points/metrics in EDW
- Worked on data quality and setup QA framework for team to improve user trust
- Managing and mentoring a team of DWH/BI Developers, DBAs
- Implemented change management process in team
- This is a data platform for Avalara’s internal business stakeholders and technology stacks
- As part of this project, we collected data from all our product lines, operational systems
- This project enabled our users to get single source of truth for all the corporate metrics
- Tools Used: SQL Server, Redshift, Snowflake Cloud DWH, Stitch Data Loader, Talend DI/DQ/MDM, SSIS, SSAS, SSRS, Power BI, REST API, Salesforce, Zuora, GitLab, DBeaver, JIRA, Confluence, DBT
Technical Lead
Synechron Technologies Pvt. Ltd.
02.2013 - 02.2016
- Company Overview: Japan Enterprise Data Intelligence (JEDI) is an enterprise data warehouse and BI platform for Asurion which handles day to day data loading from CRM, Axapta, Care systems, 3rd party vendor files and business decisions making process for Customer Care, SCM, Finance, Procurement, GA, Client Service and IT department
- Worked onsite in client Japan office as solution architect role, involved in effort estimation
- Talking to client BA for requirement and guide development team for the implementation
- Worked on Data quality improvement and setup frame work for team
- Successfully migrated from SQL Server 2008 R2 to SQL Server 2012
- Japan Enterprise Data Intelligence (JEDI) is an enterprise data warehouse and BI platform for Asurion which handles day to day data loading from CRM, Axapta, Care systems, 3rd party vendor files and business decisions making process for Customer Care, SCM, Finance, Procurement, GA, Client Service and IT department
- Tools Used: SQL Server, SSIS, SSAS, SSRS, Power Pivot, Power BI, Talend Open Studio
Associate Consultant
GlobalLogic India Pvt. Ltd.
09.2010 - 02.2013
- Company Overview: Data Integration Application (DIA) is warehouse application which extracts data from third party sources, internal departments and populates the app data mart to facilitate the dashboard and analytical reporting
- Created database schema and objects, stored procedures and ETL
- Developed stored procedures and SSRS reports with complex statistical calculations
- Interact with client to implement statistical calculations in stored procedures
- Data Integration Application (DIA) is warehouse application which extracts data from third party sources, internal departments and populates the app data mart to facilitate the dashboard and analytical reporting
- Tools Used: SQL Server 2008, BIDS 2008, SSIS, SQL Server 2005 / 2008, BIDS 2008
Database Developer
VirtualEmployee LLC
10.2009 - 09.2010
- Company Overview: This is a forecasting project, which integrates bookmaker odds of Pinnacle sports and score data feed of OnCourt for forecasting results of score in different Games, Sets and Final Result of a tennis match
- Created ETL to integrate odds data feed of OnCourt & Pinnacle Sports, SSAS cubes
- Coordinate with stats team implementing different statistical models to database
- This is a forecasting project, which integrates bookmaker odds of Pinnacle sports and score data feed of OnCourt for forecasting results of score in different Games, Sets and Final Result of a tennis match
- Tools Used: SQL Server, MySQL, SSIS, SSAS
Data Analyst
Keane Inc.
02.2008 - 10.2009
- Company Overview: This is a financial project which deals with reconciliation of commission from more than 70,000+ hotels and Travel Agents around the globe
- Worked on stored procedures UDF, Views, Shell Scripts, Perl Scripts and Complex SQL Queries for auto generation of various reports in a certain scheduled time
- Created new reports using Crystal Reports and SQL Server
- Created ETL to import external text / excel files to database
- This is a financial project which deals with reconciliation of commission from more than 70,000+ hotels and Travel Agents around the globe
Software Engineering Intern
CosmmoQuest Infocreations
06.2007 - 02.2008
- Company Overview: IOMS is an intranet based in-house application to integrate all the functions e.g
- HR, Finance, Admin and Engineering and avoid paper works of the organization
- IOMS is an intranet based in-house application to integrate all the functions e.g
- HR, Finance, Admin and Engineering and avoid paper works of the organization
Education
Post Graduate Diploma - Business Analytics
SCMHRD
Pune, India01.2014
Master in Computer Applications - Computer Applications
OUAT
Bhubaneshwar01.2007
B.Sc. - Computer Science
Berhampur University
Odisha01.2004
Skills
- Data Modelling
- Data Warehouse
- ETL Architecture
- SQL Server
- Snowflake
- SSIS
- SSRS
- SSAS
- SQL
- Power BI
- Talend Data Integration
- Talend Admin Center
- Talend Data Quality
- Talend MDM
- Talend Cloud
- MS Excel
- Zuora AQuA API
- Salesforce SOQL
- NetSuite
- Confluence
- REST API
- AWS EC2
- AWS S3
- Team Management
- SOX Compliance
Certification
- Talend Data Integration for Developers 6.0
- ITIL Foundation Certificate in IT Service Management
- Microsoft Certified Professional
- Step Up to Leadership, Dale Carnegie Training
Accomplishments
- Was able to save license cost for Talend by optimizing the usage.
- Data lake refresh time reduced to multiple times a day from existing once a day.
- Winner of Innovation team award at Avalara.
- Winner of Surpass Award for best performance in Q4 2013 in Synechron Technologies.
- Received Client Appreciation Award by Pegasus Solutions in 2009 in Kean Inc.
- Received Silver Certificate for best contribution to team in Q3-2008 in Keane Inc.
Skillsummary
- SQL Server
- Talend Data Integration
- SSIS
- MS Excel
- AWS S3
- Snowflake
- Talend Data Quality
- SSRS
- Zuora AQuA API
- JIRA
- Data Warehouse
- Talend MDM
- SSAS
- Salesforce SOQL
- Confluence
- ETL Architecture
- Talend Admin Center
- T-SQL
- REST API
- SOX Compliance
- Data Modelling
- Talend Cloud
- Power BI
- AWS EC2
- Team Management
Passport
Indian, Valid, B1/B2, 09/27
Personal Information
- Gender: Male
- Marital Status: Married
Locations
- Not Provided, Pune, Maharashtra, Not Provided
- Not Provided, Bhubaneswar, Odisha, Not Provided
- Not Provided, Berhampur, Odisha, Not Provided
Timeline
Senior Technical Lead
Avalara India Pvt. Ltd.
02.2016 - Current
Technical Lead
Synechron Technologies Pvt. Ltd.
02.2013 - 02.2016
Associate Consultant
GlobalLogic India Pvt. Ltd.
09.2010 - 02.2013
Database Developer
VirtualEmployee LLC
10.2009 - 09.2010
Data Analyst
Keane Inc.
02.2008 - 10.2009
Software Engineering Intern
CosmmoQuest Infocreations
06.2007 - 02.2008
Post Graduate Diploma - Business Analytics
SCMHRD
Master in Computer Applications - Computer Applications
OUAT
B.Sc. - Computer Science
Berhampur University
Similar Profiles
Rushikesh GulkotwarRushikesh Gulkotwar
Advanced Analyst at EY GDS India LLPAdvanced Analyst at EY GDS India LLP
Palak PandeyPalak Pandey
SDR at Avalara Technologies pvt. Ltd.SDR at Avalara Technologies pvt. Ltd.
Ankita DhootAnkita Dhoot
Team Lead at Avalara Technologies Pvt LtdTeam Lead at Avalara Technologies Pvt Ltd