SUMMARY:

• Enthusiastic and Process oriented Data Engineer with 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 effective 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 with 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 with 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 with 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

• 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 the data Models.

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

Confidential, Dubai, UAE

Analyst

• Developed visually sound and complex Tableau dashboards for the Engineering team to track overall energy savings/consumption of the FGB headquarters, Abu Dhabi
• Worked with 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
• Have worked with 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 with good logical reasoning ability, coordination and interpersonal skills
• Gained experience working in high pressure environment dealing with 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

• Worked with 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 certifications 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 with Data modelling, Batch Processing, and Data Warehousing
• Gained Knowledge of various phases of SDLC - Requirement Analysis, Design, Development, Implementation, Maintenance, Planning and Testing
• Worked with 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 training certification 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, SQL Server, Management Studio 2014, Oracle 10g.