Newzy Sharma
Recent university graduate with Information Systems majors. A Solution-driven analyst with experience in leading cross-functional teams in the development. Ready to use my earned skills and knowledge to build scalable and scientific solutions at your company. TECHNICAL SKILLS
• MySQL • Tableau • Google Sheet • Google Analytics
• Oracle • PowerBI • Talend • AWS
• PostgreSQL • Python • Alteryx • Machine Learning
• MS SQL Server • Git • Hadoop • PyTorch
• Microsoft Excel • UNIX • Reporting • CUDA
• Macros and Access • JIRA • SSMS • A/B Testing
CERTIFICATION
Google Analytics Individual Qualification June 2020 AWS Certified Solution Architect – Associate 2020 July 2020 PROFESSIONAL EXPERIENCE
Perch E Commerce Data Analysis Engineer, Retail Operations Jan. 2020 – June 2020
• Replicated Chrome Extension within Amazon’s Seller Central, resulting in an increase of outbound customer emails by 300%
• Conducted an exploratory analysis of 2-year product trends for 5K SKUs of Amazon FBA products to detect potential trends and in-demand FMCG to boost revenue by 41M a quarter
• Used Excel pivot charts and Tableau to analyze the customer behavior and products sold data affecting our brand’s ratings
• Streamlined the Acquisition Integration process for FBA businesses using 2 newly acquired companies to test and scale new processes, resulting in a cleaner and less financially risky transition process
• Developed scalable dynamic dashboards for business in Google Sheets using pivot tables and VLOOKUP via Google App Script
• Built python scripts to pull data daily from MWS API to generate reports that reduced the human effort by 20%
• Recommended brand page re-design plan using A/B & Multivariate Testing, thereby increasing the conversion rate by 150%
• Scraped more than 5,000 ASIN numbers of our Amazon product’s with python to determine key influencing factors. Infosys Ltd, India Data Analytics Engineer Nov. 2015–Aug. 2018
• Generated reports and designed dashboards using Power BI, SQL, SSRS to analyze the customer behaviors
• Developed a deep understanding of the business objectives of internal and external stakeholders; evangelized the product vision and built trust by maintaining an accurate and achievable roadmap
• Optimized data collection SPs using performance tuning techniques resulting in increase in report runtime by 50%
• Created data models using Toad data modeler resulting in increased deployment of scripts by 30%
• Automated Office of Foreign Assets Control list used in payment screening of customer using SQL and Detica AU tool ACADEMIC PROJECTS
Pneumonia Classification -Image Detection with GPU computing (Python, PyTorch, CUDA, GPU, ResNet50) Nov. 2020- Dec. 2020
• Set up a CUDA environment, assigned 5 GPU’s on 3 Nodes to compute 5800+ images to analyze the code accuracy
• Pretrained ResNet50 architecture with data parallelism, and was used for training on the training set to build a model Designing Data Architecture Business Intelligence(SSMS, Talend, Alteryx, Tableau, SQL Server) Oct. 2019- Dec. 2019
• Successfully handled 5 years of data for Retail company using Talend and performed analysis using PowerBI and Tableau and loaded the target database using Oracle, MSSQL, PostgreSQL, MySQL; Prepared data and created workflows using Alteryx
• Designed and developed the most suitable User Interface Dashboards, Story, multiple charts, Trends using Tableau, PowerBI Hyperparameter Tuning of the Database (Python,H2O, AWS) Feb. 2019-Apr. 2019
• Pre-Processed data, performed Feature Selection, Dimensionality reduction, Handled Missing values and Imbalanced data
• Tuned and optimized the hyperparameters using Random Grid, Random Forest, and Grid Search which resulted in achieving the important and best parameters for our dataset and accuracy of 89% which was the third highest in the class Airline Management System(Tableau, MySQL, Workbench, ER Studio) Dec. 2018
• Created database using ER, EER diagrams, normalized where users were created and performed Analysis on Tableau
• Developed and deployed Indexes, Views, Triggers, Cursors, Procedures, Functions to improve the efficiency of database EDUCATION
Master’s in Information Systems Northeastern University Sep. 2018 - Dec. 2020 Graduate Teaching Assistant
• Conducted code reviews to enforce efficient querying skills, organized office hours, workshops to resolve queries for students, assisted professor to prepare assignments and quizzes for a class of 70 students Bachelor’s in Computer Science Chitkara University Aug. 2011 – July 2015
• Vice-President of Organizing Committee : Organized events, trips for the college during the fests and technical programs
• Conducted workshops for the students to resolve their doubts and helped professor to monitor the classes Email
Boston, MA
GitHub
My Portfolio