PROFESSIONAL SUMMARY

• Analytics graduate wif 6 years of experience in data analysis. Passionate about handling huge datasets, adept in bringing useful insights from data for making better business decisions using Analytic & Big Data Technologies.
• A data visualization expert in designing dashboards and creating appealing graphics from complex data in order to gain insights
• Extensive experience working on working in Big Data Hadoop Ecosystem comprising Apache Spark 2.3, PySpark API, Docker, Map Reduce, Hive, Pig, Apache Oozie, Sqoop,Elasticsearch, Flume, HDFS, Apache Avro
• Excellent understanding of Hadoop architecture and Hadoop ecosystem such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and MapReduce programming paradigm
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to teh end user requirement.
• Visualization Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
• Excellent team member wif problem-solving and trouble-shooting capabilities, quick learner, result oriented and an enthusiastic team player.
• Extensive Experience in designing and developing in Spark using Python
• Excellent in Analytical /problem solving skills
• Solid noledge of Power BI and Tableau Desktop report performance optimization.
• Good team player wif excellent communication skills to work in a team and individual environment.
• Strong exposure to IT consulting, software project management, team leadership, design, development, implementation, maintenance/support and Integration of Enterprise Software Applications.
• Strong experience on both Development and Maintenance/Support projects.

TECHNICAL SKILLS

Big Data Technologies: Apache Spark 2.3, Python API for Spark Hadoop, HDFS, Map Reduce, Hive, Pig, Sqoop, Flume, Zookeeper, Oozie, Cassandra

Programming languages: Python, Java, VBA

Databases: Oracle, DB2,HBase, MySQL, Redshift

AWS: Lambda, EMR, Redshift, Data Pipeline, S3, API Gateway, Amazon Kinesis and DynamoDB No SQL DB.

NoSQL Database: DynamoDB

Operating Systems; Windows & Linux, UNIX, Shell Script

Visualization Tools: Tableau, Power BI, Excel

Other Tools/Utilities: TSO/ISPF, QMF, Changeman Defect

Tracking Tools; HP Quality Center

PROFESSIONAL EXPERIENCE

Data Developer

Confidential, Denton, TX

Responsibilities:

• Developed data model on SQL server for chain franchise to enhance business level integration and automated 10+ tasks
• Creation of database tables, synonyms, functions and query performance testing performed in SQL Server
• Performed data analysis techniques like cleaning, data manipulation and data wrangling using Python Pandas, NumPy
• Used Python Pandas APIs for extracting third party vendors data from shared servers
• Implemented visualization of teh processed data using Mat plot library plots and Tableau dashboard
• Designing data model from scratch to aid team in data collection to be used for Tableau visuals
• Processed data into HDFS by developing solutions, analyzed teh data using MapReduce, Pig, Hive and produce summary results from Hadoop to downstream systems
• Predicted customer loan default rate using machine learning models including Classification and Clustering on Python using Pandas, NumPy, Matplotlib
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop, Power BI and Excel to provide better data

Sr Data Analyst

Confidential

Responsibilities:

• Help formulate and facilitate teh engineering of multi-dimensional databases, data models, and visualizations to accomplish teh strategic goals of Business Intelligence and Analytics and help facilitate decision making by presenting complex data in a focused manner
• Experience in dimensional modelling using star and snowflake schemas. Very strong noledge on data warehouse and data base concepts
• Maintained teh database using Stored procedures, Functions, Cursors and Triggers
• Involved in analyzing teh source data coming from different data sources such as SQL, XML, CSV, and JSON
• Extensive experience working on working in Big Data Hadoop Ecosystem comprising Apache Spark 2.3, PySpark API, Docker, Map Reduce, Hive, Pig, Apache Oozie, Sqoop, Flume, HDFS, Apache Avro process improvement plans through identifying gaps and analyzing business processes- 9.2% revenue growth (2014-17)
• Worked wif CPO & COO of corporation on Cost optimization, Resource Optimization, Buffer Management and strategic initiatives & HR Analytics.
• Created dashboards to automate reporting and discussed Key Performance Metrics (KPIs) wif stakeholders in cross-functional teams to define goals and timelines- Achieved 99.91% Service Level Agreements (SLAs) in Q3 2014 from 95% in Q2 and Q2 2016
• Performed ETL data cleaning, Integration and Transformation using Pig, Handled data from disparate sources
• Involved in end to end development & enhancement project using Agile and SDLC methodologies
• Designed a data warehouse using Hive, created and managed Hive tables in Hadoop
• Experience in using NoSQL (MongoDB) data models document, key-value & wide column, or graph model.
• Built complex data visualization dashboards and reports based on teh business need; optimizing available tools (e.g., Tableau, Excel, Power BI ). This includes not only teh front-end design but also teh back-end data setup/configurationfa
• Analyze teh Business Requirements and come up wif Design/ Architecture identifying teh different components, flow diagrams and discuss wif teh team.
• Participate in teh end-to-end life cycle of teh project right from requirements, design, development and testing.

Data Analyst

Confidential

Responsibilities:

• Created SQL database maintenance logs and presenting any issues to teh database architects
• Worked on developing SQL database mining procedures for various department heads
• Involved in gathering Requirements, Design and Development by using Waterfall methodology in SDLC.
• Prepared design documents as per teh Software requirements
• Responsible for maintaining teh integrity of teh SQL database and reporting any issues to teh database architect
• Assisted in offering support to other personnel who were required to access and analyze teh SQL database
• Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.