Aakriti Sharma
Business Intelligence Engineer II at Amazon
Sustainability at Amazon
• Skills: Business Intelligence, Data Analysis (Sales, Marketing, Finance Analytics), ETL, Reporting and Data Visualization
• Languages and Tools: SQL, R, Python, VBA, Google Analytics, Tableau, CRM Salesforce, Microsoft Suite
• Databases: PostgreSQL, AWS Redshift, Snowflake, Oracle, Microsoft SQL Server, Microsoft Access
Amazon
https://www.linkedin.com/company/amazon
WW ATS Sustainability
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 II
Pond5
https://www.linkedin.com/company/pond5
https://media-exp1.licdn.com/dms/image/C4E0BAQHYetDtbWS5gQ/company-logo_100_100/0/1562612227739?e=1655942400&v=beta&t=4mw3SnTiBaGdC3QTW7DQMauh11n_YsEL0txkdC4j040
Senior Data Analyst
Pond5
https://www.linkedin.com/company/pond5
•	Co-ordinated with executives and cross functional teams to create reporting solutions for their requirements
•	Designed ETL pipelines that ensure execution efficiency and data conformity with minimal redundancy
•	Developed visually impactful tableau dashboards, adhering to business KPIs increasing ecommerce sales
•	Created ad-hoc Excel analysis of various product performances by using SQL queries and complex Excel functions

Finance:
•	Formulated complex SQL queries to audit revenue to accomplish the financial reporting accuracy of 99%
•	Implemented fraudulent activity validation by automating customer data analysis, mitigating financial risk/loss

Sales:
•	Analyzed customer behavior and pushed the leads data into CRM Salesforce to generate prospects for sales team
•	Developed triggers, sequences in Outreach to sync with Salesforce that send and track sales email communications
•	Designed dashboards in Salesforce and Tableau for sales reps’ performance/target tracking and users spend

Marketing:
•	Calculated ROI for campaigns using Google Analytics to quantify the success and generated recommendations
•	Analyzed marketing channel to understand the drivers of their performance and help achieve growth target

Product:
•	Introduced and tracked user actions and events on site using Tag Manager to analyze and predict user behavior
•	Created a database of users’ sessions data that saved $150K, and used it to show sessions funnel data and alike

Tools and Languages Used:
SQL | R Programming | Tableau | Google Analytics | Salesforce
Greater New York City Area
https://media-exp1.licdn.com/dms/image/C4E0BAQHYetDtbWS5gQ/company-logo_100_100/0/1562612227739?e=1655942400&v=beta&t=4mw3SnTiBaGdC3QTW7DQMauh11n_YsEL0txkdC4j040
Data Analyst
O'Brien & Gere (OBG)
https://www.linkedin.com/company/o%27brien-&-gere
•	Part of a team accountable for a robust Enterprise Data Warehouse to provide actionable insights to stakeholders
•	Managed the strategic business requirement gathering, design, and development of a tailored BI framework
•	Developed SQL queries using stored procedures, views, triggers, functions and indexes for business operations
•	Designed SSIS ETL packages to extract, aggregate, and transform large datasets from different relational databases
•	Implemented ROLAP by creating meaningful fact and dimension tables in snowflake and star schema in SSIS
•	Created KPI-driven MOLAP cubes in SSAS for key business processes like employee and risk management dashboards
•	Built ad hoc customizable interactive dashboards and communicated insightful findings to business leaders

Tools Used:
SSIS | SSAS | Tableau | SQL Server
Syracuse, New York Area
https://media-exp1.licdn.com/dms/image/C560BAQGgSxtcByMxOA/company-logo_100_100/0/1519855960318?e=1655942400&v=beta&t=ld7ahGlO8V26vAYGNpY5kLRBLl1S4OjV9ykld0iqkI4
Business Intelligence Intern
J.P. Morgan
https://www.linkedin.com/company/jpmorgan
During my 2 years tenure at J.P. Morgan Chase & Co, I was working independently on a project where I was responsible for the following:

•	Involved as primary ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM DataStage
•	Actively participated in decision making and regularly interacted with the Business Analysts to gain a better understanding of the business process, requirements & design
•	Designed and developed DataStage Jobs to extract data from heterogeneous sources, applied transformation logics to extracted data and load it into Data Warehouse Databases (Oracle and Teradata)
•	Used the DataStage Director and its run-time engine to schedule DataStage Jobs runs, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis
•	Developed complex store procedures using input/output parameters, cursors, views, triggers and queries using temp tables and joins
•	Converted complex Job designs to different Job segments and executed through Job Sequencer for better performance and easy maintenance
•	Created shell script to run DataStage Jobs from UNIX and then schedule this script to run DataStage Jobs through Control-M scheduling tool
•	Coordinated with team members to administer all onsite and offshore work packages
•	Analyzed performance and monitored work with capacity planning
•	Performed performance tuning of the Jobs by interpreting performance statistics of the Jobs developed
•	Documented ETL test plans, test cases, test scripts, and validations based on design specifications
•	Conducting knowledge transfer session for on boarding team members, creating and maintaining documents like Data Model, Data Dictionary and Run book

Tools Used:
DataStage | PuTTY for Unix Scripting | Control – M | JIRA | ALM | WinSCP
Mumbai Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQEVXhQs3mC56Q/company-logo_100_100/0/1630056226107?e=1655942400&v=beta&t=QvD7BcNvpajYiaZNnBJXGLYTSSkGryHyoYhQWMQ95xA
Business Intelligence Analyst
Master’s Degree
Information Management
https://media-exp1.licdn.com/dms/image/C560BAQFAyZ5pXkHL9Q/company-logo_100_100/0/1597671966100?e=1655942400&v=beta&t=jIZwHEq4IOlt-akteEHG9msVudZCRBN5Wxkuz9qVzEs
Syracuse University
https://www.linkedin.com/school/syracuse-university/
Bachelor’s Degree
Information Technology
https://media-exp1.licdn.com/dms/image/C510BAQEWU9936lI35w/company-logo_100_100/0/1537856747032?e=1655942400&v=beta&t=DmKcYOmrnxkhWE-V_IJF-gu7QpdugtYvqt9RSrUpFgc
Ramrao Adik Institute of Technology
https://www.linkedin.com/school/ramraoadikinstituteoftechnology/
Syracuse Orange Bhangra
-
•Acted as graduate students’ representative at University level and worked towards resolving their problems
Graduate Student Organization at Syracuse University
GSO At-Large Senator
•Led a committee of ten students to promotes knowledge and respect for diversity in Syracuse University
•Reached out and provided support to diverse communities by helping them with issue resolution
Graduate Student Organization at Syracuse University
Chair of GSO Diversity committee
Advanced Information Analytics
IST 718
Applied Data Science
IST 687
Business Analytics
SCM 651
Information Systems Analysis
IST 654
Introduction to Information Management
IST 621
Management Principles for Information Professionals
IST 614
Managing Information Systems Projects
IST 645
Tools Used:
R Programming | Tableau | Excel

    ● Performed multiple independent value Linear Regression on Product Sales using R
       Programming to determine sales dependency on variables
    ● Conducted tests like Ramsey RESET to verify all regressions assumptions (linearity,
       multicollinearity, heteroscedasticity, serial correlation, outliners) are obeyed
    ● Applied corrections to data by performing Box-Cox, Box-Tidwell to meet linearity assumption
    ● Generated a 3D graph using regression plane to show independent and dependent variables
    ● Created 4 geographical representations of sales and demographic data using Tableau
Data Analytics: Product Sales Regression Model
Tools Used:
Hadoop | Python | Spark Apache | Jupyter

    ● Performed data cleaning and analysis of Skytrax customer rating data to perform regression and         classification analysis for prediction of recommendation
    ● Implemented regression analysis on data and found independent variables having most impact        on ratings
    ● Determined best fit regression model based on Mean Square Error of various test models
    ● Conducted sentimental analysis and created best fit model using elastic net regulation
    ● Executed random forest classification using decision tree
Data Analytics: Skytrax Customer Review Analysis
Tools Used:
R Programming

    ● Performed logit and probit analysis on variables to determine a customer’s loan acquisition               power
    ● Produced final regression model for main effects and interaction terms variables and provided        spreadsheet prediction for the same
    ● Implemented neural network analysis on significant variables determined from logit and probit
       analysis
    ● Created a prediction model of the neural network and used this model to perform sensitivity               analysis for the neural network
Data Analytics: Universal Bank Loan Analysis
Tools Used:
MS Visio | MS Word | MockPlus

    ● Performed in-depth investigation of a healthcare system and generated requirements                      through research 
    ● Overhauled requirement gathering from Business Owner and key stakeholders and created               Business Requirement Document(BRD) 
    ● Analyzed business system flow using different conceptual modeling techniques for system               analysis including Entity Relationship Diagrams (ERD), Data Flow Diagram (DFD) and Unified               Modeling Language (UML)
    ● Implemented requirement, regression, smoke, user-interface, and usability testing to validate         the system
System Analytics and Design: Conceptualize Information System to report on healthcare quality
Tools Used:
Google Analytics

    ● Determined peak time frame of pervious marketing campaigns and the dollars spent on each 
       campaign to analyze success of campaigns in the past
    ● Analyzed the effective of previous campaigns by evaluating factors like New users, Clicks, Cost        per Click, Sessions, Bounce Rate etc.
    ● Identified key words and geographic regions that will result in strong campaign impact 
    ● Established budget for impactful advertising campaign based on region and degree program
Data Analytics: Recruiting Advertising Strategy Prediction
Tools Used:
R programming

    ● Performed data profiling on a dataset of 1.7 M records of customer survey input, to provide               business insights 
    ● Executed association rules on dataset to understand the factors determining Net Promoter               Score (NPS)
    ● Evaluated and visualized dataset using various R Packages like ggplot and mathplotlib to               perform statistical analysis
    ● Applied machine learning techniques like Logistic Regression, Naïve Bayes, Random Forest, SVM,        and used different performance metrics to evaluate the NPS
    ● Built decision tree models to predict bad reviews and its category, to setup an advanced warning        system for proactive resolution of issues
Data Analytics: Predictive Analysis for Hyatt Hotels using Customer reviews
Tools Used:
MS Project

    ● Developed a project plan to stream line a preexisting data analytics process of finding social               media influencers 
    ● Interacted with all stakeholders to establish requirements and gather feedback throughout the        project life cycle 
    ● Created an issue tracker and change log, and defined metrics for measuring success of the               project 
    ● Recommended changes and provided a comprehensive document outlining scope and                      significant milestone
Project Manager: Project plan for Terakeet (Brand Management company)
Tools Used:
DataStage | VBA | Excel | Notepad++

    ● Created a customizable VBA script that parsed DataStage jobs (in XML format) to extract
       relevant details of job
    ● Automated the process of analyzing 1800 queries, saving 85% time approximately while                      eliminating manual work
    ● Conducted knowledge sharing sessions with team members leading to code reusability and               increased efficiency
Datastage Job Details Extraction Automation
Tools Used:
Putty | SVN Repository

    ● Developed a UNIX batch script for import and export of SVN repository jobs reducing
       execution time by 80%
    ● Streamlined the process to a single-window operation which resulted in 75% of reduced effort
     ● Modeled script to increase reusability across different teams and projects
SVN Import/Export Automation
Lynda.com
www.lynda.com
B30B3520E5B64E219F341B55A5D4DF46
Python for Data Science Essential Training
https://www.lynda.com/home/CertificateOfCompletion/PrintCertificate.aspx?lpk57=B30B3520E5B64E219F341B55A5D4DF46
PADI
PADI Open Water Diver
https://www.linkedin.com/in/mcpatil
Santa Clara, CA
Mohit Patil
SDE at Amazon
https://www.linkedin.com/in/shazmankhan
Seattle, WA
Shazman Khan ,PMI-CAPM®
Energy Data Program Manager | Worldwide Energy & Sustainability Operations| Amazon |
https://www.linkedin.com/in/akriti-singh-118489107
Seattle, WA
Akriti Singh
Software Engineer II at Amazon
https://www.linkedin.com/in/jadhavbhakti
Buffalo-Niagara Falls Area
Bhakti Jadhav
Software Developer
https://www.linkedin.com/in/kevin-berry-747432b1
Seattle, WA
Kevin Berry
Senior Program Manager, Sustainability at Amazon
https://www.linkedin.com/in/pschlosser
Seattle, WA
Peter Schlosser
Finance Manager at Amazon
https://www.linkedin.com/in/kunalmody
New York, NY
Kunal Mody
Senior Program Manager at Amazon
https://www.linkedin.com/in/andrew-rhodes-167ab748
Seattle, WA
Andrew Rhodes
Senior Sustainability Program Manager at Amazon
https://www.linkedin.com/in/robby-weaver-2026a577
Greater Seattle Area
Robby Weaver
North America Transportation Sustainability at Amazon
https://www.linkedin.com/in/udayvw
Seattle, WA
Uday Wadhone
Software Engineer at Splunk
https://www.linkedin.com/in/devendrabadhe
Bloomington, IN
Devendra Badhe
Data Engineer at Meta (Facebook)
https://www.linkedin.com/in/sonia-thekknedath-22519388
Atlanta, GA
Sonia Thekknedath
Data Analytics Specialist at McKinsey & Company
https://www.linkedin.com/in/schipperstephanie
Los Angeles Metropolitan Area
Stephanie Schipper
Marketing, Merchandising, Sustainability, eCommerce
https://in.linkedin.com/in/harisree-haridas-a9260a154
Kerala, India
Harisree Haridas
CSE
https://in.linkedin.com/in/rohit-kumar-323278218
Nandyal
Rohit Kumar
--
https://www.linkedin.com/in/apurva-talreja
New York, NY
Apurva Talreja
Media Analyst at Google
https://www.linkedin.com/in/lenasterley
Redmond, WA
Lena Sterley
Results oriented, people first, solution driver
https://www.linkedin.com/in/akriti-dahal-9b7531214
Grand Rapids, MI
Akriti Dahal
--
https://in.linkedin.com/in/saurabh-somani-66a731171
Bengaluru
Saurabh Somani
Software Developer at Philips
https://www.linkedin.com/in/patilsiddhesh
San Francisco, CA
Siddhesh Patil
Data Analytics Manager at WebMD, an Internet Brands company | Proficient in SQL, AB Testing, Tableau and Product Analytics
Sonia Thekknedath
      
          



            
              
        
              
  

    
        I have had the great pleasure of observing and working with Aakriti for a year in J.P. Morgan Chase & Co. I have witnessed her leadership, warmth and dedication in action.
Besides being a joy to work with, Aakriti is a take charge person who is able to think of innovative, out of the box solutions and was an invaluable asset to the organization during her tenure. 
Her determination to fix a problem was such that she would work untiringly for long hours at a stretch to locate a bug or find out the root cause in case of discrepancies in the results. With an eye for details and a devotion to logic, she willingly and confidently tackled all assignments with dedication and a smile. She also took on additional responsibilities without my asking as and when the need arose. She is totally dependable and was frequently entrusted with challenging assignments. Her strong verbal and written communication skills allowed her to convey information in a clear and coherent manner and she proved herself to an able mentor and teacher. She has consistently demonstrated an ability to rise to any challenge that she must face.
Aakriti is not only a good worker but is also personally delightful. She is an engaging, pleasant and humorous individual. She got along well with everyone from the junior most fresher to the Department head. Always with a smile and good word, she was ever ready to help other colleagues, both professionally and personally. After she left JPMC to pursue her Masters degree, I am pleased to maintain our mutually sustaining personal and professional relationship.

https://au.linkedin.com/in/aakriti-sharma-90821993
Melbourne, VI
Aakriti Sharma
Talent Acquisition Specialist at Servian
https://in.linkedin.com/in/aakriti-sharma-5043bba8
Noida
Aakriti Sharma
Actively looking for a Job Change - Assistant Manager at Infoedge India Ltd.,
https://in.linkedin.com/in/aakriti-sharma-a0aa3516b
Gurugram
Aakriti Sharma
Jungleworks | Ex-ICICI
https://in.linkedin.com/in/aakriti-sharma-15ab6bbb
Mumbai Metropolitan Region
Aakriti Sharma
Student
https://in.linkedin.com/in/aakriti-sharma-883953147
Thane
Aakriti Sharma
Environment + Energy Leader Network
https://media-exp1.licdn.com/dms/image/C4E07AQFOU0Igzt4C9w/group-logo_image-shrink_92x92/0/1631007970453?e=1647691200&v=beta&t=2VCA2lcb2T-0Rtpu3wVoct-EC3y74zZQ11q0OQKwFGE
https://www.linkedin.com/groups/4537381
Environmental, Green Energy & Conservation Network: Business, Jobs, Events & News
https://media-exp1.licdn.com/dms/image/C5607AQEAEdo03SsUrg/group-logo_image-shrink_92x92/0/1630997773385?e=1647691200&v=beta&t=k9PSu4HL_Uv7pb_J_4FOLzTCKimuXurfK_HYdV9JJ1c
https://www.linkedin.com/groups/3205497
Environmental Sustainability Professionals
https://media-exp1.licdn.com/dms/image/C5607AQGWokT6yRk4WQ/group-logo_image-shrink_200x200/0/1631402548310?e=1647691200&v=beta&t=-z3E6IfmYkcWNNXk_gWrgDtTXGVYIPPesQTLyS1KZSI
https://www.linkedin.com/groups/2901693
Energy Efficiency Professionals (IoT Technology, Policy, Deployment)
https://media-exp1.licdn.com/dms/image/C4E07AQFoWCTcNqJ9lw/group-logo_image-shrink_92x92/0/1631008574058?e=1647691200&v=beta&t=D3khmZNxg97gsMSjpVsXiGfiX29MTI9SDnEIlyPaz1U
https://www.linkedin.com/groups/3006223