SUMMARY:

• Microsoft and SAS certified, Highly - skilled data analyst bringing more than 5 years of expertise in Big Data Technology, Data Mining, Data Warehousing Data,Analysis, and Data Visualization .Thrive to use econometric, detail-oriented,and Statistical Analytics approaches to achievereal-time business stakeholder’s goals.
• Experience in transforming raw data into actionable strategic knowledge in order to gain insight into business using statistical analysis processes, and thereby guide and help businesses in their decision-making and run efficiently created data lake using Hadoop and HBase and Hive.
• Excellent Knowledge and experience in creating data mapping documents for Extracting, Transforming, and Loading (ETL) tasks.
• Extensive experience using R packages like (foreign, gretl, rattle, quantMode). Also familiarity with finance statistical analysis such as lme4,MASS,mice,mlogit,Rcmdr,survival,truncreg
• Robust user of Python packages for statistical analysis such asStatsmodels, Scikit-learn, Numpy, Pandas, NLTK
• Expertise in designing concise,pertinent visualizations using Tableau, Power BI,R Studio software and publishing and presenting dashboards on web and desktop platforms.
• Excellency in MS Excel with proficiency in Lookups, Pivot Tables and understanding of VBA Macros.
• Competent in Normalization/ De-Normalization techniques for optimal performance in relational and dimensional database environments and maintaining referential Integrity by using Triggers and Primary and Foreign Keys.
• Saved $300K/year operation cost of Global Database Administrator team, saved 267 days’ database team work.
• Extensive experience in in-depth data analysis on different data bases and structures. Strong knowledge in writing T-SQL and PL SQL Queries, Dynamic-queries, sub-queries, CTEs and complex joins.
• Strong experience in Data Profiling very large data sets using various statistical analysis methods such as Regression, Hypothesis test and Correlation.

TECHNICAL SKILLS:

Programming Languages: Java, PL/SQL, JCL, COBOL

Analytics Languages: R, Python, SQL, Scala, SAS

IDE: RStudio, Eclipse, Intellij, PyCharm, PySpark, Weka

AWS Technologies: S3, EC2, SQS, SNS, EMR

Databases: Mainframe, Oracle, NoSQL, MySQL, ETL

Web Development: Java Script, HTML, CSS

Big Data Technologies: MapReduce, Hive, Spark, HBase, Pig, Yarn, Apache Azure

Data Visualization: Tableau Desktop/Server, Weka,Power BI, Pivot Table, VBA, V-lookup

SAS Skills: SAS-BASE, GRAPH, MACRO, SQL, ODS, STAT, MINER

Competencies: Logistic and Linear Regression, Time Series Analysis, CHAID,Factor Analysis, CART, Survival Analysis

EXPERIENCE:

Confidential, Pittsburgh, PA

Big Data Analyst

Responsibilities:

• Worked with consumers and different teams to gain insights about the telematics data usage by their team and their target of cost saving through data usage planning analysis generated data lake using Hadoop to push raw data.
• Analyzed business data requirements, data plans requirements, data overage requirement specifications, and accountable for documenting data plan modification and usage monitoring creating data storage in Hadoop and run strong queries using Spark.
• Communicated with data vendor such as Vodafone, Verizon, Iridium and ORBCOMM to understand their business data plan strategies.
• Access Caterpillar telematics data plan information from multiple data provider’s portal in SQL, SAS,Oracle format and run data profiling, data cleaning and data analysis on raw data using R packages and advance SQL querying.
• Modelled advanced visual basic application macros on various vendor data reports to plan data usage structure with minimum overage cost using Excel and VBA.
• Employed time series algorithm on data usage to visualize future scope of data plan usage and overage estimation to generate cost saving successful data usage plan for teams.
• Created backdating data plan process to avoid non-required data overage cost for 5 teams by the help of VBA, Tableau and SQL query report generation
• Leveraged Statistical Analysis Azure Library to group multiple data plans into one group to create cushion capacity of 15 % to avoid overage for different vendor plans.

Confidential, Spicewood, TX

Data Analyst

Responsibilities:

• Analyzed, retrieved and aggregated data from multiple vehicles vendor to perform data mapping, to precisely append either incorrectly mapped or missing data storage and transfer using HDFS and HIVE query.
• Responsible for building and maintaining effective working relationships with business teams, as well as other external vendor and customer data management team
• Identified inconsistencies in data collected from different sources and worked with business owners/stakeholders to assess business and risk impact, provided solution to business owners.
• Performed data analysis and data profiling using complex SQL queries on various sources systems.
• Developed share point documentation template to support findings, project status and assign specific tasks.
• Involved with data profiling of multiple sources using SQL Management Studio and presented initial discovery in Excel tables and reports.
• Used project management tools such as Kanban and Share point to keep stakeholder updated about project.
• LeveragedSentiment analysis to established consumersfeedback systemby MapReduce and text mining in java.
• Developed and systematizedend-to-end statistical model on high-volume data sets by manipulating data using Hivequeries and Spark on Hadoop for faster results, and resolve issues of stakeholders under tight deadlines
• Carried out customer credit history data extraction on customer database and other sources using SAS, Python
• Summarizing raw dataset and performing data parsing using SAS procedures such as PROC SQL, PROC SUMMARY, PROC TRANSPOSE, PROC MEAN, PROC CONTENTS, PROC FREQ, PROC SORT and SAS data steps like ARRAY, MERGE
• Established correlation between the variables. Calculating KS, RMSE and AUC for model stability, discrimination power and accuracy
• Plotting frequency distributions of predicted probability of loan default histogram by PROC GPLOT, R-GGPLOT
• Designed the result and report to senior modeler by PROC TABULATE, PROC FORMAT and SAS/ODS
• Worked with Model Risk Management and Internal Audit teams to handle model risk management related tasks
• Looked for additional data to improve model performance
• Developed reports in various formats like HTML, RTF and PDF using SAS/ODS

Confidential, Sterling Heights, MI

Associate Data Analyst

Responsibilities:

• Collaborated extensively to Data Pre-Processing, Data Cleaning, and Data Gathering from client using python API.
• Business requirement gathering through one-to one and group meeting with Vendors, Order Management team and Supply Chain team. Presented initial developed KPI frameworks to gain line of sight project.
• Employed time series algorithm on parts sales to visualize future scope of part and vehicles requirement to estimate required availability of various parts of vehicle in inventory and generate cost saving successful inventory management plan for team.
• Extracted, compiled and tracked data, and analyzed data to generate reports in a variety of layoutsExcel, PDF, Tableau and SAS dashboard and Modelled data structures for multiple projects using Mainframe and Oracle
• Maintained the data integrity during extraction, ingestion, manipulation, processing, analysis and storage.
• Presented more than 15 impactful visualization time series dashboards and stories by employing Tableau desktop and server, Excel, pivot tables, Power BI, SAS and Visual Basic macros
• Presented more than 15 impactful visualization time series dashboards and stories by employing Tableau desktop and server, Excel, pivot tables, SQL queries, Power BI, SAS and Visual Basic macros
• Modelled basic analytical models using Python, R through an Spark R and API on 25 % threshold data