Data Analyst Sales

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Market Data Analyst - Wipro Ltd, Apple Inc (Feb 2019 - Present)

● Market Research Analytics- Tableau Dashboard and Data Pipeline:

Responsible for maintaining the entire data pipeline from Qualtrics to Apple Database using ETL tools.

Created and maintained Apple’s Market research analytics Tableau dashboard for iPhone,Mac,iPad.

Constantly develop and enhance the dashboard every quarter based on Sales and Business requirements.

Collaborate with other analysts, marketing managers, and engineers on ad-hoc survey blasts,data versioning and ongoing data infrastructure enhancement projects.

■ Tools: Tableau, Keynote, Pandas, Python, Numpy, Jupyter Notebook, Unix, PostgreSql, Teradata

● Database Migration and Replication:

Lead & facilitated with cross functional engineering teams for planning, driving requirements and scheduling with Gantt charts

Extensively involved in technical design feasibility analysis to collaborate with solution delivery teams and bridge the gap between Technical and Business Teams

Analyze and provide solutions by developing documentation and demonstrating flowcharts, layouts, diagrams, charts, code comments and clear code

Active engagement in all the agile ceremonies like planning, pre-planning, backlog refinement, retrospective, affinity planning and record all the tasks using Apple Radar tool.

Data copy from primary to secondary env. in Teradata using export and load process. Running TPT load and Daemon jobs. Work with highly structured and semi structured data of more than 500 Tb in size.

■ Tools: AutoSys,SQL Workbench, ETL Framework, Metadata UI.

● Appstore Analytics:

Development of aggregates,writing stored procedures in Teradata for executive level Appstore Analytics that assists in Apple’s marketing trend analytics.

Building aggregates on Hadoop using Spark-Scala application.Loading historical data as well as incremental catchup activity. Solve performance issues in Teradata like collecting Stats on joining tables, creating smaller work tables throughout the procedure, using column compaction if possible.

■ Tools: Teradata, SQL Workbench, PL/SQL, Shell Scripting, AutoSys, Apple ETL Framework,HQL,Scala

● Daily Maintenance and Support:

Constant monitoring and maintenance of Apple TV transaction subscriptions.

Debug any errors/issues. troubleshooting production issues.

Create builds and deploy production changes.

Responsible for data induction and maintaining the entire data pipeline from Hadoop to Teradata.

Development of aggregates in Hive and Teradata that are required for iTunes marketing trends analysis.Impact analysis and production cutover.

■ Tools: AutoSys, ET Tools, Central Station Ticketing and Reporting Tool Business Development Analyst - Voltas Limited (Dec 2010 - Jan 2013)

● Responsible for managing project timeline, cost and execution

● Performed project cost analysis in MATLAB and Excel. Experimental Data Analyst - Mecon Limited (July 2009 - Nov 2010)

● In charge of raw data collection and cleaning from air quality sensors.

● Collected, monitored and analyzed waste water experimental results. Academic Projects

NAMRATABISWAS

716-***-**** adihiw@r.postjobfree.com Namrata Biswas LinkedIn Visualization Tools

Databases

Languages

Tableau, Power BI, Looker, Google Analytics

Teradata, MySQL, PostgreSQL, Data Warehousing, ETL Python, HTML5, CSS, JavaScript, Knockout JS, Bootstrap Machine Learning Tools

Other Software Tools

Hive, Scala, Pandas, Scikit, Numpy

AWS, Google Cloud, Git, Jira

● Data Analytics/ML

o L1 PCA Algorithm: Derived and wrote outlier resistant, robust L1 PCA algorithm overcoming the weakness of the most popular L2 norm PCA. Used for image restoration, image fusion and completion.

● Database/Tableau/Web Development

o Superstore Sales Analysis: Transformed data into actionable insights, used Tableau to build dashboards and perform ad-hoc analysis, suggested the company to do bundling programs to increase their sales. o Neighborhood Map: Developed a web app using FourSquare and Google APIs to show the location and description of restaurants.

EDUCATION

Master of Science, Software Engineering(GPA - 3.92) August 2017 - December 2018 International Technological University, San Jose

Bachelor of Technology, Biotechnology( GPA - 3.9) July 2005 - July 2009 West Bengal University of Technology, India

Data Science Workshop 2018

Stanford University

Nanodegree, Front-End Web Development 2016

Udacity

Contact this candidate