SUMMARY:

• Functioning as a Data Analyst in Safety vehicle domain, responsible for maintaining the quality of data, preparing interactive dashboards for investigation team, Data transformation from Teradata to Hadoop HDFS file system, Weekly tables update in Teradata.
• Experienced at data regression models, using predictive data modeling and analyzing data mining algorithm to deliver insights and implement action - oriented solutions to complex business problems.
• Research different kind of data like customer complaint, engineering, incident, crash, OnStar and research data to support data scientists in identifying emerging vehicle safety issues.
• Have worked in support and enhancements Projects and doing end to end deliverables from requirement capturing to delivering the code to production and post live support
• IT professional with 5 plus years of experience specializing in Data Analytics with strong proficiency in data manipulation, statistical analysis and business intelligence.
• Have worked in Supply Chain Management domain, predict the future profit and expenditure based on KPI metrics and historical data.
• Automated, aggregated and reported resource consumption data on Alteryx and Tableau reducing the budget by 20%
• In-depth knowledge of data extraction, cleansing and constructing structured datasets through SQL/ BI and visualization tools such as Tableau Qlik View/Qlik Sense, and data mining through R & Python.
• Expertise in identifying data driven insight that drive profit, enhance operational efficiency, and understand customer behavior.
• Proficient in Big data, Hadoop, SQL, Microsoft suite, R, Python, Tableau, power BI, Teradata, problem solving, multivariate regression, predictive and market mix modelling, clustering, optimization, reporting and dashboarding.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Good understanding on ABAP language and SAP ERP system.
• Experience of working directly with clients & their vendors, at client location in New Jersey, USA as Onsite coordinator and Technology Specialist
• Coordinated with offshore teams, delegating work & handled change request and defects deliveries to the client
• Exceptional team player with outstanding communication skills both written and verbal

TECHNICAL SKILLS:

Programming: SQL, R and Python, C/C++, VBA, ASP.Net

Data Visualization & Analytics tools: Tableau/Power BI, Qlik View/Sense, Excel, Power Point, Solver, JMP, Excel, PowerPivot, Power Query, Pivot Tables, SSRS, SSIS, SSAS, Alteryx, Informatica

ERP: Hands-on in SAP/Advanced Business Application Programming.

Database skills: MS Access 2013, SQL Server 2012, Hadoop, MySQL.

Data Science Concepts: Data Wrangling and Advance Analytics, Data Mining, Business Intelligence, Statistics, RDBMS

Operating Systems: UNIX, Windows, MAC OS X, Linux

Business Domain:: Data Analytics, Information Technology and Supply Chain

Big Data Ecosystem: Hadoop, MapReduce, HDFS, HiveQL, PySpark, Pig, Sqoop

PROFESSIONAL EXPERIENCE:

Confidential, Warren, Michigan

Data Analyst / Statistical Modeler

Responsibilities:

• Maintaining and updating Teradata tables weekly and provide the solutions to IT team for any fallback.
• Pulling data for investigation team and supporting data scientist in the investigation.
• Develop interactive data visualizations dashboards using Tableau and Power BI.
• Automated, aggregated and reported resource consumption data on Alteryx and Tableau reducing the budget by 20%
• Analyzed and processed complex data using advanced querying, visualization and analytical tools.
• Oversaw data management activities such as collection, cleansing, standardization and mining
• Identified, measured and recommended improvement strategies for future vehicles.
• Profile EDW data sources, document and present to data scientists and management.
• Perform big data processing and transformation using Hadoop, HiveQL, PySpark.
• Leveraged Sqoop to import data from Teradata into HDFS
• Developed ETL framework using Python and Hive (including daily runs, error handling, and logging) to glean useful data and investigate vehicle safety issues.
• Create data requirements and complete user acceptance testing in test and production environments.
• Working to become a subject matter expert in customer complaint, engineering, crash, telematics, survey, and research data to support data scientists in identifying emerging vehicle safety issues.
• Created data queries and reports using QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Testing Cognos 11 reports and providing feedback to IT team and giving to users.
• Data transformation from Teradata to Hadoop HDFS file system.

Confidential, Pontiac, Michigan

Data Analyst (Intern)

Responsibilities:

• Data cleaning and mining using Excel, JMP, python and R
• Feature analysis to find the relationship between the process entities of health care through linear regression, logistic Regression, Association Rules
• Descriptive statistics and frequencies were analyzed. Bivariate and multivariate techniques were used to reveal relationships between process delay and the other variables.
• Conducted a data regression analysis of the relationship between number of patient and other factors, achieving to find the root cause of delay with providing action-oriented solution.
• Prepared the dashboard on Excel, Tableau and Power BI to show the reason behind the process delay of patient movement in SJMO.

Confidential, Troy, Michigan

System Data Analyst

Responsibilities:

• Gathered and analyzed large amount of data from various sources for example ERP/SAP 6.0, 4.0, Quad to analyze supplier and vendor information and related investment across the world and give a better insight into the future expenditures and profit margin.
• Developed interactive dashboards and data transformation by creating custom queries/ reports using MS Access, SAP and Hive
• Created dynamic and Interactive dashboards and reports based on the KPI metrics which were used by higher executives for decision making through visualization using Tableau, Qlik View/Sense, Power BI, Excel on weekly and monthly basis.
• Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
• Used SQL, PowerPoint, Excel to generate various performance reports for analysis.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• Comprehensive knowledge of VBA in a business environment
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Utilized Microsoft SPSS statistical software to track and analyse data.
• Successfully interpreted data to identify key metrics and draw conclusions.
• Proposed solutions to improve system efficiencies, leading to a 15% reduction in operating costs.
• Experience in analyzing data using HiveQL, Pig Latin and custom Map Reduce programs in python.
• Worked with Sqoop to move (import/export) data from a relational database into Hadoop and used FLUME to collect data and populate Hadoop.

Confidential, Sterling Heights, MI

Drupal Developer

Responsibilities:

• Understand the functional requirements
• Test the Front-End applications for each of the objects like Contacts, Account, Leads, Opportunities, verifying if every stage is working correctly
• Interacting with developers and clients to understand the implementation and functionality expected from Application
• Ability to perform in a fast-paced agile environment s
• Profound knowledge of high-level development on the Drupal platform
• Developed and maintained enterprise class websites and applications based on PHP and Drupal
• Performed MYSQL database development and implementation activities.
• Enabled required data extract, transform, and load procedures and packages.
• Worked on Google Cloud for managing and updating MYSQL database.

Confidential

SAP/ABAP Developer

Responsibilities:

• Worked on Classical and Interactive reports, Logical Databases, Dialog programming, Module pool programming and SAP Scripts to provide data.
• Demonstrated excellent working knowledge of ABAP components such as dictation, table control, screen painter, menu painter ABAP Query and ALV.
• Demonstrated knowledge of Software Development Life Cycle (SDLC).
• Maintained Data Dictionary Maintenance: Tables, Structures, Domain, Data element, Views, Lock object, Match-codes.
• Responsible for application development of various objects such as Reports, Interface programs as per technical specs and project standards.
• Developed the Sap Script according to user’s requirement with their corresponding Driver program and printing the Invoice in PDF format.
• Created Report consistence to calculate and display data based on the customer requirement.
• Worked on a report in which immense amount of data displayed from tables needed to be downloaded to the files on server and also on local system.
• Worked on BDC and Module pool programming.
• Worked on Scripts & Smart forms.
• Extensive knowledge in Classical, Interactive and ALV reports.
• Basic knowledge on Web Dynpro.
• Experience in Enhancement Techniques (BADI’s, Exits)