SUMMARY

• Enthusiastic and Process oriented Data Engineer wif 5+ years of professional work experience.
• Proven experience in utilizing Statistics and Programming skills to interpret and analyze data for driving business solutions using Python, Tableau and SQL.
• Proficient in Data Engineering, Database design, ML/AI concepts, SPARK, Hadoop, programming languages.
• Excellent understanding and usage of tools for TEMPeffective data analysis, Database modelling and design, Analyses of data and ETL.
• Certified in AWS, Banking, finance and Insurance domains.
• Passionate about learning new and latest Technologies in the data space.
• Experienced in Data Collection, Extraction, Cleansing, Aggregation, Mining, Verification, Reporting and Data Warehousing
• Worked on data cleaning, wrangling, manipulation/transformation and visualization using Python, R, SQL, Tableau and Advance excel techniques
• Experienced in backend programming (Data modelling, Schema designs and creation), knowledge and hands on experience in advanced SQL - Functions, Triggers, Stored Procedures etc.
• Hands-on experience wif multiple ML/AI Algorithms such as Neural networks, Linear and Logistic Regression, Support Vector Machine, Decision Tree, Naive Bayes, Apriori, K means clustering, KNN classifier using R and Python libraries (Pandas, Beautifulsoup, NumPy, Matplotlib, Whoosh, Pyspark) to perform predictive Analytics on various datasets
• Worked wif BI/Reporting tools such as Tableau, Crystal Reports and Quick sight, having created various Visualizations using Bar/Line/Pie charts, Maps, Scatter Plots, Heat maps and client reports
• Proficient in setting up VPC, private/public subnets, security groups, EC2 instances, creating IAM roles and permissions, configuring redshift, using lambda functions, setting up AWS glue for ETL
• Knowledge of using Hadoop and Spark tools like HDFS, RDD, YARN and MapReduce
• Good understanding of RDBMS, ETL, Data Warehousing and Data lake concepts
• Specialized in Tools, Terms, Concepts and Programming languages used for Predictive Analytics, Machine Learning, Natural Language Processing and Data Visualization for developing Business Intelligence Applications
• Hands on experience in writing ETL script using Informatica, SSIS, Glue for database operations and other activities (involving extraction, transformation and loading)
• Familiar wif Agile (Scrum) and Waterfall methodologies for SDLC
• Well versed Terms and metrices used for Statistical and Financial analysis

TECHNICAL SKILLS

Bigdata and Databases: Hadoop, Map Reduce, Apache Spark, Yarn, MSBI (SIS, SSRS), Tableau, Quick sight, Informatica, SPARK SQL, MS SQL Server

Languages: Python, SQL, R, C#, C++, C, HTML, CSS, XML, JSON, NoSQL, PHP

Tools: Tableau, JMP SAS, OLAP, Axure RP, Rapid Miner, Autosys, Advance Excel (V-Lookup, Pivot Table), MS Office, Crystal Reports, GITHUB, JIRA

Machine Learning: Linear/Logistic Regression, SVM, Decision Tree, Random Forest, Naive Bayes, KNN, K means, A/B Testing, Neural Network, Apriori Model

Cloud Computing: S3, IAM, EC2, Glue, Redshift, CloudWatch, CloudTrail, Lambda, AWS EMR

PROFESSIONAL EXPERIENCE

Confidential, VA

Data Analyst

Responsibilities:

• Implemented Redshift based Data warehousing Solution
• Automated GLUE ETL jobs using S3 events and AWS lambda functions
• Pre-processed data for analysis by extracting data using complex SQL queries, joins, grouping and aggregation
• Worked on POC’s using Spark, Python to load and transform data using data frames
• Migrated historical data into AWS cloud and set up automated process in cloud for incoming Clickstream Data
• Worked on Modeling and designing Database for data warehouse workload and created the objects in redshift
• Well versed in data-preprocessing, to initialize the workflow and configure data cleaning process
• Implemented Custom data extraction using SQL scripts, SQL stored procedures, Functions, Views and Triggers
• Created and run jobs on AWS cloud to extract transform and load data into AWS Redshift using AWS Glue, S3 for data storage and AWS Lambda to trigger the jobs
• Connected to AWS Redshift through Tableau to analyze the data for ad-hoc requirements as well as canned reports.
• Build interactive dashboards in Tableau utilizing Parameters, Calculation fields and table calculations, Filters, Action filters and sets to handle views more efficiently
• Working knowledge of AWS services models IaaS, PaaS, SaaS and other upcoming services in Cloud
• Extensively used Agile methodology as the Organization Standard to implement

Environment: Python, Pyspark, Spark, SQL, Tableau, AWS Redshift, AWS Glue, AWS Lambda

Confidential

Analyst

Responsibilities:

• Developed visually sound and complex Tableau dashboards for the Engineering team to track overall energy savings/consumption of the FGB headquarters, Abu Dhabi
• Worked wif ETL tools such as Informatica, to extract, transform and load data from multiple data streams into Data warehouse
• Created daily, monthly and yearly excel reports to track performance, activity and rate of progress to efficiently manage completion of Al Fattan Project, Dubai
• Rebuilt existing Reports into Tableau Visualizations, implementing user and action filters
• Has worked wif business to understand their needs and insights, can understand creative needs of the Business, not just the execution e.g.: pie charts, graphs, and, thinking out of box on how to visualize to them
• Team player wif good logical reasoning ability, coordination and interpersonal skills
• Gained experience working in high pressure environment dealing wif critical deliverables
• Worked on four multimillion-dollar projects and gained valuable experience in team/resource management

Environment: Tableau, SQL Server, informatica, SSMS, SQL

Confidential

Programmer Analyst

Responsibilities:

• Worked wif ETL tools such as SSIS and Informatica, to extract, transform and load data from multiple data streams into Data warehouse for WellPoint (client)
• Worked on small and large-scale defect fixes on multiple websites for WellPoint
• Successfully completed Data migration as part of Micro Focus upgrade for Barclay’s (client) using Rapid miner, Autosys and SQL server.
• Received s on BFS and Insurance domains, and on technologies such as ASP.Net, ADO.Net, C# and SQL
• Gained Experience in resolving Database errors and performed timely backups and refreshes
• Developed Crystal reports for WellPoint, as part of the support team
• Gained experience wif Data modelling, Batch Processing, and Data Warehousing
• Gained Knowledge of various phases of SDLC - Requirement Analysis, Design, Development, Implementation, Maintenance, Planning and Testing
• Worked wif design and development of presentation and application layers for various web applications of WellPoint
• Responsible for debugging and troubleshooting the Client’s web application
• Developed Hotel Management website as part of using MVC framework, C#, ASP.net, ADO.net, SQL. Created separate views and controls for Guest, User, Manager and General Manager as per specifications

Environment: SQL Server, SSIS, SSRS, C#, ASP.NET, ADO.NET, ETL, Data Warehousing, Metadata, Data stage, SAS,SQLServer, Management Studio 2014, Oracle 10g.