aanchal datta
Business Intelligence Engineer at Amazon
business intelligence engineer amazon
Amazon
https://www.linkedin.com/company/amazon
Seattle, Washington, United States
https://media-exp1.licdn.com/dms/image/C560BAQHTvZwCx4p2Qg/company-logo_100_100/0/1612205615891?e=1655942400&v=beta&t=AVKhS-aqZ8h_yaf-McQWAc1jIlHiawZrjoadhfnNFOM
Business Intelligence Engineer
Walmart
https://www.linkedin.com/company/walmart
Bentonville, Arkansas, United States
https://media-exp1.licdn.com/dms/image/C560BAQHXJ3GqjqY2yg/company-logo_100_100/0/1625156541828?e=1655942400&v=beta&t=SNxG9zIqKylUMc8Z0ClTgdb4xnFtE60qqbQpC9dSf8g
Manager ll Systems Management
Essilor
https://www.linkedin.com/company/essilor
 Responsible for analyzing metadata and business process information to provide insight and recommendations into the standardization of data definitions from a business and technical perspective.
 Provide functional support and subject matter expertise while partnering with operational areas, data stewards and management (e.g. Marketing, Sales Operations, Finance, Supply Chain, Labs, etc.) to help resolve issues and answer Master Data related inquiries; appropriately escalating issues to ensure timely resolution.
 Interface with Business and Lab teams, members of various IT teams, and project delivery groups to improve synergies in existing MDM solutions and business processes, minimize recurring data/product bugs and data related issues, maintain & improve data accuracy and mappings of customer & product, expand reporting and communication, and continuously strive for service improvements, performance tuning, and support reduction.
 Provided MDM related subject matter guidance (data, processed, tools, best practices, standards, SOPs, etc.) to IT MDM Development team and participate in projects, upgrades and releases, including integration testing planning from various sources to target systems.
 Assisted with development of data standards for the capture, creation, storage and usage of operational and analytic data models. Standards may include but are not limited to naming conventions, derivation and transformation rules, specific quality measures, etc.
 Monitored processes and dashboards used for the proactively monitoring of the health and performance of MDM applications and their associated services to increase business performance and continuity.
 Communicated to management on issues, risks and status of the MDM platforms and data management processes.
Dallas-Fort Worth Metroplex
https://media-exp1.licdn.com/dms/image/C4D0BAQEn3bvcEw_xWw/company-logo_100_100/0/1580480062767?e=1655942400&v=beta&t=JqcIlB82XniiL9sg7AQr_tfNK3IlUY6iM9h-syQU9ec
Data Management - Engineer
Essilor
https://www.linkedin.com/company/essilor
•	Facilitated the reporting process by mapping unstructured data to the correct attributes which corrected the discrepancy in sales figures of about $1 million
•	Created a tool that automates the address cleansing process thus reducing manual effort by 97% and hence improving data quality
•	Carried out product obsolescence by the method of forecasting and analysis based on previous year’s sales figures and customers
•	Identified data conflicts in relationship to master data definitions and standards across business units using Excel and SQL
•	Worked closely with stakeholders to resolve data conflicts, and brought standardization and accuracy
•	Carried out the role of a business analyst in creating the Essilor Vision Foundation portal , managed the requirements and changes, and coordinated with the offshore team
Dallas/Fort Worth Area
https://media-exp1.licdn.com/dms/image/C4D0BAQEn3bvcEw_xWw/company-logo_100_100/0/1580480062767?e=1655942400&v=beta&t=JqcIlB82XniiL9sg7AQr_tfNK3IlUY6iM9h-syQU9ec
Master Data Governance- IT Analyst
Essilor
https://www.linkedin.com/company/essilor
•	Facilitated the reporting process by mapping unstructured data to the correct attributes which corrected the discrepancy in sales figures of about $1 million
•	Carried out product obsolescence by the method of forecasting and analysis based on previous year’s sales figures and customers
•	Identified data conflicts in relationship to master data definitions and standards across business units using Excel and SQL
•	Worked closely with stakeholders to resolve data conflicts, and brought standardization and accuracy
•	Carried out the role of a business analyst in creating the Essilor Vision Foundation portal , managed the requirements and changes, and coordinated with the offshore team
Dallas/Fort Worth Area
https://media-exp1.licdn.com/dms/image/C4D0BAQEn3bvcEw_xWw/company-logo_100_100/0/1580480062767?e=1655942400&v=beta&t=JqcIlB82XniiL9sg7AQr_tfNK3IlUY6iM9h-syQU9ec
Data Management and Analytics Intern
The University of Texas at Dallas
https://www.linkedin.com/company/university-of-texas-at-dallas
•	Played the role of a student worker at the university recreation center
•	Facilitated and supervised student activities at all times
•	Maintained and analyzed the user data for creating business strategies for the university
•	Carried out customer service and helped boost the marketing strategies for customers based on demographics
Dallas/Fort Worth Area
https://media-exp1.licdn.com/dms/image/C4E0BAQEBYU4_oEvArQ/company-logo_100_100/0/1601995944632?e=1655942400&v=beta&t=AnRV7ij_akzXcvgdMZPP4Q-b1r7Jm9AZckJIW0bMGxs
Student Employee-University Recreation
Cognizant
https://www.linkedin.com/company/cognizant
At Cognizant Technology Solutions I worked on a number of projects where I worked closely with the client on the requirements and made sure that the timelines for all the tasks allotted to me were met. My main responsibilities included 
*Requirement gathering
*Maintaining Client relationship
*Enhancing the business workflow
*Reporting

My main concentration during my tenure at cognizant was Data. I developed my skills to play around with data and get the best out of it to make sure the requirements were met and results were achieved.

I achieved the below in the process:
Performed data cleaning on the data acquired from primary and secondary sources
 Performed ETL(Export , Transform , Load ) techniques for system support and quality assurance.
 Performed regression techniques on data sets to evaluate issues in the data
 Maintained the database system and mapped data between source systems(Unix) and database systems
 Created reports and strategically analyzed the same to provide techniques of improvement
 Increased performance by 48% in the data load phase by implementing direct path extract method
Pune Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQEoboJe0-DUPg/company-logo_100_100/0/1625144835174?e=1655942400&v=beta&t=x1B2367XWXYzCTQBUn_0Go0XXlJxlYXiOjUdbNsEzWQ
Programmer analyst
T.I.F.R.
https://www.linkedin.com/company/t.i.f.r.
During my term at the TATA Institute of fundamental Research as a Junior Research Fellow I Installed a device which would separate the solar spectrum into individual wavelengths which could be used for optical analysis of fabricated samples and spectroscopy.
As a part of this project I published a paper on the research gate forum:
https://www.researchgate.net/publication/260423233_Microstepping_Drive_for_a_Bipolar_Stepper_Motor
Mumbai Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQGL_BttDCTEkA/company-logo_100_100/0/1519875508346?e=1655942400&v=beta&t=JbHlHct-01rNcvtwM44INU5AuDw6olENgDCrtFo6vlE
Research Assistant
Technophilia
https://www.linkedin.com/company/technophilia
An on campus internship program organized by CRESE , a Carnegie Mellon university certified course.
We implemented and made a working robot model during this internship program.
Pune Area, India
Intern
Tata Teleservices Ltd
https://www.linkedin.com/company/ttbs
This was a 3 month internship program where I worked on the telecom system. In the process, I achieved the following tasks:
 Maintained the telecom system and measured signal strengths at various locations to increase efficiency by 35.7%
 Evaluated data processing proposals to assess project feasibility and requirements
Pune Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQFxwUWlJzC4hg/company-logo_100_100/0/1645097456661?e=1655942400&v=beta&t=-i_pTzIcbp2XFZle92JYtzOedd04LjIeR64tiTSnNHo
Summer Internship
Master of Science (M.S.)
Enrolled in the Information Technology management program at the university with my concentration in Business Intelligence and Analytics.
Management Information Systems, General
https://media-exp1.licdn.com/dms/image/C4E0BAQHkXEd556X81g/company-logo_100_100/0/1570575585691?e=1655942400&v=beta&t=t8TvG_C81WE8A4yJe9pRHU1vOtYreqe0V7JD4GS0fVg
University of Texas at Dallas - Naveen Jindal School of Management
https://www.linkedin.com/school/university-of-texas-at-dallas---naveen-jindal-school-of-management/
Bachelor of Technology (BTech)
Graduated with a bachelors degree in Electronics and Telecommunication as a university rank holder.
Electronics and telecommunucation
https://media-exp1.licdn.com/dms/image/C4E0BAQGltV9wRWpIjg/company-logo_100_100/0/1519898416589?e=1655942400&v=beta&t=Z3pFDfGkBLYYVvPIStXwL3Pklu3BEMyRZw6G8UdDndw
Vishwakarma Institute Of Technology
https://www.linkedin.com/school/vishwakarma-institute-of-technology-pune/
The ability of a stepping motor to translate switched excitation into precisely defined increments of rotor position makes it one of the most famous motors used in today’s world with a large array of applications. This paper deals with the design and implementation of a Micro-stepping drive based on dedicated Integrated circuits and H-bridge coupled by MOS-Gate driver logic providing optimized drive sequences. The generation of digital phase signals and their amplification by the drive circuitry before being applied to the motor is the core idea of this paper. The Micro-step mode of operation is not only characterized by smoother performance but also higher speed capability and efficiency.
Micro-stepping Drive for a bipolar stepper Motor
Research Gate Forum
https://www.researchgate.net/publication/260423233_Microstepping_Drive_for_a_Bipolar_Stepper_Motor
Business Intelligence and Analysis using SAS
-
Data Management
-
Quantitative Analysis for risk and uncertainty in business
-
Communication Theory
-
Computer network
-
Computer organization and Architecture
-
Control Systems
-
Data structures
-
Digital Image Processing
-
Digital Logic Design
-
Electromagnetic Theory
-
Electronic Circuits and devices
-
Industrial Management
-
Integrated Circuits Application
-
Joint Time Frequency Analysis
-
Micro controllers
-
Network Analysis
-
Network Synthesis and Filter Design
-
Optical fiber communication
-
Signals and Systems
-
Soft Computing
-
System Programming and Operating Systems
-
VLSI Design and Technology
-
New coders’ Survey Data: Used to gain insights from the demographic and
functional data for new coders and provide recommendations to organizations for groups of people they could target.
Business Analytics and Intelligence using SAS
To accommodate for the expansion of the business and to solve the problem(s) of managing the
records, and consolidating the records in a single database, a new data base for an insurance company was created
Data base Management
Designed a reliable and affordable method of aligning a solar module with the sun in order to maximize its energy output
• Calculated the amount of energy that is saved by use of solar power.
Solar power battery charger with auto tracking system
The ability of a stepping motor to translate switched excitation into precisely defined increments of rotor position makes it one of the most famous motors used in today’s world with a large array of applications. This paper deals with the design and implementation of a Micro-stepping drive based on dedicated Integrated circuits and H-bridge coupled by MOS-Gate driver logic providing optimized drive sequences. The generation of digital phase signals and their amplification by the drive circuitry before being applied to the motor is the core idea of this paper. The Micro-step mode of operation is not only characterized by smoother performance but also higher speed capability and efficiency.
Micro-stepping Drive for a bipolar stepper Motor
https://www.researchgate.net/publication/260423233_Microstepping_Drive_for_a_Bipolar_Stepper_Motor
Formulated a device to perform basic arithmetic operations and display output on the LCD using micro controller 8051
Arithmetic Operations Implementation
LinkedIn
www.linkedin.com
Advanced SQL: Logical Query Processing, Part 2
https://www.linkedin.com/learning/advanced-sql-logical-query-processing-part-2
Udemy
udemy-certificate.s3.amazonaws.com
UC-b28261c2-b0b0-4f79-8107-c929b282610e
MICROSOFT POWER BI DESKTOP FOR BUSINESS INTELLIGENCE
https://udemy-certificate.s3.amazonaws.com/pdf/UC-b28261c2-b0b0-4f79-8107-c929b282610e.pdf
LinkedIn
www.linkedin.com
SQL Server Integration Services
https://www.linkedin.com/learning/sql-server-integration-services-2
LinkedIn
www.linkedin.com
Advanced SQL: Logical Query Processing, Part 1
https://www.linkedin.com/learning/advanced-sql-logical-query-processing-part-1
LinkedIn
www.linkedin.com
Statistics Foundations: 2
https://www.linkedin.com/learning/statistics-foundations-2
LinkedIn
www.linkedin.com
Statistics Foundations: Probability
https://www.linkedin.com/learning/statistics-foundations-probability
LinkedIn
www.linkedin.com
Statistics Foundations: The Basics
https://www.linkedin.com/learning/statistics-foundations-the-basics
LinkedIn
www.linkedin.com
Advanced SQL for Query Tuning and Performance Optimization
https://www.linkedin.com/learning/advanced-sql-for-query-tuning-and-performance-optimization
LinkedIn
www.linkedin.com
Using Python for Automation
https://www.linkedin.com/learning/using-python-for-automation
LinkedIn
www.linkedin.com
Power BI Essential Training (2019)
http://www.linkedin.com/learning/power-bi-essential-training-2019
LinkedIn
www.linkedin.com
Advanced Microsoft Power BI
http://www.linkedin.com/learning/advanced-microsoft-power-bi
LinkedIn
www.linkedin.com
Artificial Intelligence Foundations: Machine Learning
http://www.linkedin.com/learning/artificial-intelligence-foundations-machine-learning
LinkedIn
www.linkedin.com
Python for Data Visualization
http://www.linkedin.com/learning/python-for-data-visualization
Udemy
udemy-certificate.s3.amazonaws.com
UC-PAHF5IIE
Salesforce Admin.
https://udemy-certificate.s3.amazonaws.com/pdf/UC-PAHF5IIE.pdf
LinkedIn
www.linkedin.com
People Analytics
http://www.linkedin.com/learning/people-analytics
LinkedIn
www.linkedin.com
SQL Server: Triggers Stored Procedures and Functions
http://www.linkedin.com/learning/sql-server-triggers-stored-procedures-and-functions
Udemy
ude.my
UC-6ZCYZJT7
Big Data and Hadoop framework
http://ude.my/UC-6ZCYZJT7
LinkedIn
www.linkedin.com
Data Science Foundations: Data Engineering
http://www.linkedin.com/learning/data-science-foundations-data-engineering
LinkedIn
www.linkedin.com
Learning Data Governance
http://www.linkedin.com/learning/learning-data-governance
Udemy
ude.my
UC-CU1JTJNQ
AWS SQL Server RDS BootCamp
http://ude.my/UC-CU1JTJNQ
Udemy
ude.my
UC-L8ZJIT47
ETL Using SSIS
http://ude.my/UC-L8ZJIT47
Udemy
ude.my
UC-DO3MY3DP
Advanced Databases and SQL Querying
http://ude.my/UC-DO3MY3DP
Udemy
ude.my
UC-7EYK18BH
Apache Hadoop EcoSystem- Hive
http://ude.my/UC-7EYK18BH
Udemy
ude.my
UC-4UKZQWO0
Data Science Using Python
http://ude.my/UC-4UKZQWO0
Udemy
ude.my
UC-DNYA51EB
Hadoop
http://ude.my/UC-DNYA51EB
Udemy
ude.my
UC-R2SSRVP8
Power BI - The Ultimate Orientation
http://ude.my/UC-R2SSRVP8
Udemy
ude.my
UC-HXRT7MJC
Introduction to Salesforce
http://ude.my/UC-HXRT7MJC
Sunny Yarrish
      
          



            
              
        
              
  

    
        Aanchal is a key member to enable the successful launch of Essilor's enterprise loyalty program and provide the ongoing data support to operate the program. She knows the data system inside and out and has excellent business judgement. I'm extremely impressed by her results focused attitude and strong partnership with business units. Bob Callahan, MBA,  MSEE, PMP, CSM
      
          



            
              
        
              
  

    
        I had the pleasure of working with Aanchal on a quite challenging data analysis and cleansing program.  During this time, I was continually impressed with her exceptionally sharp technical skills and for her uncommonly good interpersonal capabilities.

As I got to know Aanchal better, I found her to be extremely insightful, have an outstanding work ethic, great sense of humor and excellent communication skills. 

Through numerous challenges, I always knew she was committed to our mission and was dependable beyond reproach. Similarly, I admired her ability to collaborate cross functionally building credible relationships with team members as well as senior leadership. 
Liked by Aanchal Datta
https://www.linkedin.com/signup/cold-join
This week I embarked on an exciting new step in my career journey. I’m thrilled to join Myriad Genetics, a world-class organization with the mission…
Liked by Aanchal Datta
https://www.linkedin.com/signup/cold-join
So proud to see that our alum Aditi Katare has been selected in the Indian Air Force as a Flying Officer.#alumnispotlight #proud #aviation…
Liked by Aanchal Datta
https://www.linkedin.com/signup/cold-join
This is absolutely amazing! It's great to see this tribute to the defenders of our country. The women of power, courage, and resilience. This…
https://in.linkedin.com/in/aanchal-datta-1221651b7
Lucknow
Aanchal Datta
Student at SGPGI LUCKNOW
Data Scientists
https://media-exp1.licdn.com/dms/image/C5607AQH-zLkZ0CI57Q/group-logo_image-shrink_92x92/0/1631010696123?e=1647694800&v=beta&t=FZmjwqeLYnxP-5JaZ87XVzeiarJUlo8GYF5vtTRz84k
https://www.linkedin.com/groups/2013423
Microsoft University Recruiting Team
https://media-exp1.licdn.com/dms/image/C5607AQFO-fto2EJ1cg/group-logo_image-shrink_92x92/0/1631008161791?e=1647694800&v=beta&t=uJyGZGi0emtwg3yyTIS2KcAHkCbWktUT3zy8l_CVDt0
https://www.linkedin.com/groups/12125564
Data Warehouse - Big Data - Business Intelligence - Cloud - Data Science - ETL
https://media-exp1.licdn.com/dms/image/C4E07AQF3lo6vMMn1Cw/group-logo_image-shrink_92x92/0/1551381119207?e=1647694800&v=beta&t=TiYFq372svJuV48tCTxf7tVCLUGufB-oj5gfZ8I-GfY
https://www.linkedin.com/groups/1824590
Artificial Intelligence and Business Analytics (AIBA) Group
https://media-exp1.licdn.com/dms/image/C4E07AQHsCFbktnq6FA/group-logo_image-shrink_92x92/0/1631000142355?e=1647694800&v=beta&t=RnTsJjuBKiOYNCLra0rbq-tnhHHbM2nYsb_0JNxWXG4
https://www.linkedin.com/groups/62438
Data and Analytics Group
https://media-exp1.licdn.com/dms/image/C4D07AQH79PSgjREdwg/group-logo_image-shrink_200x200/0/1631357442134?e=1647694800&v=beta&t=TcN1LI5QZOqZYJEnv0StrHlhgp5feJBLS6mRiharM5c
https://www.linkedin.com/groups/4098676
Big Data, Analytics, Business Intelligence & Visualization Experts Community
https://media-exp1.licdn.com/dms/image/C4D07AQH2q7TKmljeSw/group-logo_image-shrink_200x200/0/1631354674766?e=1647694800&v=beta&t=cMcZyUXETzunRhYBhMGcR3UkcMo6zTn-IoYbEU2t9XU
https://www.linkedin.com/groups/23006
Big Data and Analytics
https://media-exp1.licdn.com/dms/image/C4D07AQFNPg4NMiT96Q/group-logo_image-shrink_200x200/0/1630999429915?e=1647694800&v=beta&t=ilcl9RAq73KJdf9jTWLJTsZRoJF7Bmi9muPPkHWd6zs
https://www.linkedin.com/groups/4332669