For the given job description <<Job Title: Data architectData analyst Location: Juno Beach, FLJob description:We are looking to get a Data ArchitectData analyst that has strong database data warehouse experience with multiple services including relational database (designdevelopment), integration services, analysis services and reporting services.The person need to have strong Oracle RDBMS and Microsoft SSISSSASSSRS background, with commanding organizational skills including crisp communication.
>> the resume: <<Experience10/2019to06/2019Data AnalystAngi Homeservices Inc.–Rockledge,FL,Built an end to end analytics-based solution for animal shelters to verify optimality of current capacity, with a vision to deliver recommendations to improve animal outcomes and health in the future.Created a cloud-based (AWS/Flask/HTML) UI to source animal shelter data & present optimal solution.Utilized Delphi method to generate synthetic data (for missing values) using information from animal experts.Leveraged SQL/Python to pre-process and optimize animal shelter data.Dealt with a tricky client, with unclear outcomes (and impacted by COVID-19 times) - yet delivered a complete, extendable analytics/ UI solution.Predicted the outcome of animals with 73% accuracy, based on characteristics of the animals at the time of intake.01/2019to06/2019AnalystAmeresco–Half Moon Bay,,INDTraders of import export licenses in India, Operationalized and negotiated the prices/rate of various MEIS/SEIS by predicting the price of the MEIS/SEIS licenses using Time-series analysis and supervised machine learning model, resulting in savings of INR 1,000,000.Created a new billing system from scratch to increase efficiency and reduce time spent in creating bills using Excel, VLOOKUP, HLOOKUP and Formulas, which resulted in time spent in creating bills reducing by 50.06/2018to09/2018Analyst InternSpencer Stuart–Chicago,,INDAlthough junior, quickly earned responsibility for creation of data architecture & automation for BSE's Mutual Funds.Processed 1 million+ weekly transactions to enable audits, executive reporting - Presented to CXOs weekly.
EducationExpected inJuly 2018totoBachelor of Engineering:Information TechnologyUniversity of Mumbai, Vidyalankar Institute of Technology-Mumbai,GPA:Expected inJunetotoMaster of Science:Business AnalyticsUniversity of California-San Francisco,CAGPA:
SummaryA motivated data enthusiast with 5+ years of SQL and data analysis experience, 3+ years of Object-Oriented Programming experience and 2+ years of Python and R experience. Self-taught Machine Learning and Big Data and applied to various settings by taking 3 Coursera Courses, 3 Udacity Courses, 2 Udemy Courses and am an AWS Certified Cloud Practitioner. Motivated to make a difference and hence currently analyzing publicly available animal shelter data.
HighlightsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, DashboardsAutomationBilling systemClientData AnalysisData MiningData VisualizationDatabase ManagementDelphiFundsHTMLMachine LearningExcelModelingMongoDBPythonReportingSQLStatistical AnalysisTableauVision
SkillsTools: SQL, Python, Jupyter Notebook, Flask, R, Tableau, Spark, MongoDB, Excel, HTML, MapReduceSkills: A/B Testing, Data Analysis, Database Management, Data Mining, Data Visualization, Hypothesis Testing, Modeling, Machine Learning, Statistical Analysis, Dashboards,Automation, billing system, client, Data Analysis, Data Mining, Data Visualization, Database Management, Delphi, Funds, HTML, Machine Learning, Excel, Modeling, MongoDB, Python, reporting, SQL, Statistical Analysis, Tableau, vision>>. The result is, 

Fit assessment: No Fit