Data Analyst Intelligence

FAROOQUE AKHTAR

Boston, MA **************@*****.*** +1-617-***-**** Linkedin Github Viz_1 SUMMARY

• 2 yrs of experience in Business Intelligence Analysis, development and implementation of the reporting and ETL components

• Proficiency in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and Power BI

• Experience with Data analysis and SQL querying with database integrations

• Highly creative, innovative, committed, intellectually curious with good communication and interpersonal skills EDUCATION

Northeastern University Boston Dec‘20

MS Data Analytics Engineering GPA: 3.5

Coursework: Big Data System Engineering in Scala Data Mining Data Warehousing & Business Intelligence Data Management & Design Probability & Statistics Data Visualization Operations Research Advanced Statistical Methods VIT University India Jun‘13 - Aug‘17

BS Electrical & Electronics Engineering

TECHNICAL SKILLS

Programming Languages: Python R SQL Scala (Functional Programming) C Statistical Analysis: A/B testing SPSS Minitab Hypothesis testing ANOVA Bayesian statistics Database Technologies: MS SQL Server RDBMS Oracle 11g PostgreSQL MongoDB MySQL AWS [Redshift,EC2] Machine Learning: Regression Predictive Analytics Clustering Classification Tools and Frameworks: Python [Numpy-Pandas-Scikit learn-Matplotlib-Plotly] R Pyspark BERT ETL and Visualization: Tableau Power BI Looker SSIS SSAS SSRS SAP Business Object [BO] IntelliJ Idea Certification: AWS Certified Cloud Practitioner

PROFESSIONAL EXPERIENCE

Data Analyst Capscanada, Fort Lauderdale, FL Apr’21 - Present

• Developed data pipeline to build end-to-end Reporting Solution using Tableau, Easy Insights

• Built Lead Generation for Sales team, and developed the marketing strategy Data solution

• Built and developed Salesforce forms, monitor existing forms, resolved bugs from existing webpages using HTML

• Built SQL Views, and developed queries, to pull data from databases, built SOPs for entire IT process Business Intelligence Analyst iBasis, Lexington, MA Jul‘19 – Dec‘19

• Created a Universe in Oracle (Data-Warehouse) which increased the efficiency of creating Dashboards & Reports by 50%

• Developed customized features inside DataMart which enabled creating automated reports, reducing processing time 30%

• Modified SQL queries regularly to update the dashboard content, to reflect changing customer needs

• Gathered and created requirement specification document to ensure that client needs are consistently achieved

• Designed analytical dashboards using SAP BO to transform sales & CDRs data into easily understandable reports to provide actionable insights to business stakeholders

• Monitored over 500 monthly, quarterly, ad-hoc reports and ensured their on-time delivery to senior management Seller Support Associate Amazon, India Jan’18 – Jun’18

• Formulate quarterly global sales action planning and reporting through Salesforce.com; coordinate sales action planning for new product launches and report on results

• Monitors ticket aging daily and update ticket aging report biweekly which is used to monitor tickets from inception to reporting

• Extracted, analyzed data and provided technical support to amazon sellers while identifying KPI’s ACADEMIC PROJECTS

COVID-19 - Live Twitter Sentiment Analysis Big Data Project Sep’20 – Dec’20

• Examined general public sentiment of public about vaccine by building End to end datapipeline using Apache Spark

• Designed comprehensive ML models such as Naive Bayes, SVM in Apache Spark using Scala

• Implemented NLP for Sentiment Analysis using Sentence Embedding like BERT and USE in Databricks Data Warehousing of Chronic Conditions Data Warehouse Project Nov’19 - Dec’19

• Designed Star-Schema in Toad Data Model using Fact and Dimension table

• Migrated and staged 8 Gb data to SQL Server by creating SSIS packages and built SSAS cubes using Visual Studio

• Devised SSIS with proper control and dataflow task applying validation, lookups, aggregation, T-SQL, audit to load data into database, and used SSAS to generate pivot tables to show OLAP component for analysis in Tableau

Contact this candidate