Priyabrata Patnaik

Business Intelligence and Data Engineering Architect at Amazon

Bengaluru Area, India

snapdeal Big Data Fundamentals Business Intelligence Projects E commerce SQL Big data Pentaho Big Data Analytics Entrepreneurship Start-up Business Consulting Data Warehouse Architecture MySQL database design Data Integration Amazon EC2 Tableau AWS E-commerce Solutions Amazon Web Services Data Warehousing Database Design Amazon Amazon Web Services (AWS) E-commerce Consulting MySQL
Following are the key skills and major experience that I have

* Amazon Redshift and Mysql for Data Management and OLAP - Star schema Data warehouse.
* MachineLearning Models and Automated AI solutions Design.
* Advanced BigData Solutions and new-in industry tools and processes.
* Large Data Set Processing and generate Insights from the data as required
* Analytical Reasoning and Data Modeling
* Business Analytics and Business Intelligence using Excel , Tableau, Pentaho , SQL, etc
* Unix/scripting to be used for fast and efficient programming.
* DWH,ETL/Dashobards/Reporting/Server Management/Scripting/BI Tools

My Motto in life is: Work for Enjoyment, Do what you like always.

Business Intelligence and Bigdata Professional-(DataEngineer-III Level6) at Amazon

Sep 2015 - Present

Business Intelligence and Data Engineering Aspects of Business for Complete Amazon Prime Business. End to end Development and Answering day to day business questions related to the business model and Building self service analytic solutions for all business leaders and top management. Complete AWS Product suite usage and Tableau for Business intelligence and Adhoc Analytics. Embedding Intelligence to the worlds largest subscription system and making people benefited.

Sr. Business Analytics and Business Intelligence Professional at Myntra

May 2014 - Jul 2015

Built the complete Analytics Platform for Myntra and managed all the Analytics and Business requirements by CXOs and top management. Projects: • Data warehouse design and implementation on AWS – Redshift and s3 files storage • Hive Interface for analyzing large datasets and adhoc analysis. • POC on distributed ETL using Pig and Hive to increase the performance of regular DW-Etls and streamline it. • Trained the whole team on limited Pig programming and related stack for faster development. • Business Reporting for Strategy team and finance team and enhanced them to take proper business decisions as needed. Tools used: pentaho-data-integration, AWS Redshift, amazon s3 file system, mysql, hive, pig.

Sr. S/W Analyst at Snapdeal

Mar 2012 - May 2014

Analyse the business, Trends, Customers behavior, Company’s Performance and formulate strategies according to the analysis and give suggestion to higher management regarding the outcomes of specific analysis.  Create new processes and functionality to analyse huge incoming data and fetch required information as per need.  Maintain previous performance analysis information and accordingly match with current trends.  Analyze the current trend of people’s purchasing and create product scoping to meet the right customer.  Big Data Stack used includes Pig,mahoot,sqoop,hive,mongoDB.  Use Business Intelligence tools , Pentaho BI, for tracking the data and create appropriate information as required by the type of analysis.  DataWarehousing for efficient reporting and storage.  Creation of Interactive Dashboards to showcase company's Growth pattern and provide Insights to other growth opportunities.  Formulate new Ideas to make the current working process more smoother and streamlined.  ETL processes to transform OLTP system data to OLAP system data.  Technologies used includes : Hadoop,Pig,Hive,Oozie,sqoop,Mahoot,Pentaho BI Suite,shell scripting,Linux and Ubuntu server Management,Community Dashboard Editor and javascript,,svn,mysql,sql queries,dwh,etl,crontab and many more.

CSM Developer at Amdocs

Jun 2010 - Mar 2014

Work in a team to develop CSM product and upgrade it as per the requirements of client. CSM (developed in Power Builder) along with the business logic implemented in Tuxedos and database backend to be Oracle is a complete telecom solution product of AMDOCS. Clients use CSM for performing all the activities (e.g. Creating new customer, providing details about usage or current bill, Creating Charges, etc.) that will be used in for the billing activities and Telecom lifecycle initiation.


BE(Hons.) Computer Science at BPUT

Aug 2006 - May 2010

Computer Science Graduate

Push pixels...
Shovel coal into server...
Create mockups...
Defend the wall...
Draft storyboard...
Disrupt an industry...
Achieve profitability...
Become a unicorn...
Become Batman...