­­

SUMMARY:

• IT professional with 5 years of experience specializing in Data Analytics with strong proficiency in data manipulation, statistical analysis and business intelligence.
• Providing data - driven, action-oriented solutions to challenging business problems.
• Business-minded data scientist with a demonstrated ability to deliver valuable insights via data analytics and advanced data-driven methods.
• 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 server, MYSQL, Microsoft Access, Excel, 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.
• Experienced in developing Dashboards Reports in Cognos 8 and 10
• Involved in a data migration process between different versions of Cognos.
• Interacted with Customers for requirement gathering, effective analysis and to provide end-user training.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Coordination with Client, SME and offshore team by assigning and controlling tasks daily.
• Data Mining and Modeling: Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives.
• Dashboards: Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analysed data to identify key metrics and transform raw data into meaningful, actionable information.
• Developed algorithms based on deep-dive statistical analysis and predictive data modeling
• Analyzed and processed complex data sets using advanced querying, visualization and analytics tools.
• Identified, measured and recommended improvement strategies for KPIs across all business areas.
• Exceptional team player with outstanding communication skills both written and verbal.
• Experience in Agile Scrum and SDLC methodology.
• Experience in designing the test plans, test scenarios, functional test cases based on user stories and requirements.

TECHNICAL SKILLS:

Programming: SQL for data extraction and manipulation, R and Python for data mining and machine learning C/C++, VBA, ASP.Net, JSON.

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

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

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

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, Hive, Pig, Sqoop.

PROFESSIONAL EXPERIENCE:

Confidential

Business Data Analyst, Supply Chain Management

Responsibilities.

• Created UML Models such as wireframes, Use Case Diagrams, Activity Diagrams and Flow Diagrams using MS Visio and online UML tools
• Gathered and analyzed large amount of data from various sources for example ERP/SAP 6.0, 4.0, Quad.
• Depicted story behind data through visualization using Tableau, Qlik View and Qlik Sense, 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.
• 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.
• Used SQL, PowerPoint, Excel to generate various performance reports for analysis.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• Created dynamic and Interactive dashboards and reports based on the KPI metrics which were used by higher executives for decision making.
• 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.
• Act as a bridge between business stakeholders, Project Management and development team. Worked closely with Project Management to support determination of the project roadmap
• 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.
• Got experience in managing and reviewing Hadoop Log files.
• Worked with Sqoop to move (import/export) data from a relational database into Hadoop and used FLUME to collect data and populate Hadoop .
• Worked with HBase to conduct quick look ups (updates, inserts and deletes) in Hadoop .

Environment : Microsoft Excel, Microsoft Word, Microsoft Power Point, Microsoft SQL Server, Tableau10.4, Qlik View and Sense, Hadoop environment, Linux, MS Visio, MS Project, UML, MS Access, SQL Server, SAP.

Confidential

Drupal Developer

Responsibilities:

• Ability to perform in a fast-paced agile environments
• 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.

Environment : Microsoft Excel, Microsoft Word, Microsoft Power Point, Office 365, Drupal 7 framework, MYSQL, Google Cloud

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)

Environment: Microsoft Excel, Microsoft Word, SAP ABAP/4 Workbench, ERP Packages SAP R/3 ECC 6.0, Data dictionary, SAP Scripts and Forms.

Confidential, Rochester, MI

Business Data Analyst / SQL Developer

Responsibilities:

• Used Gradient boost and random forest algorithm for prediction on test data and Tableau for data visualization.
• Explored the area of web scraping dynamic pages using Python. Dive-in Python libraries such as Beautiful Soup 4, Scrapy, lxml etc.
• Scraped, imported large data sets to CSV files and applied feature engineering and aggregate statistics over the data subsets using packages in R to bring out the hidden story.
• Exploratory data analysis using python packages - PANDAS, NUMPY, MATPLOTLIB, SciPy
• Built classification models using R’s KNN, Decision Tree and Neural Networks
• Exposure to a wide variety of statistical techniques including regression (linear, logit), cluster analysis, data mining techniques including decision trees, random forests etc.
• Developed multiple MapReduce jobs in java for data cleaning and pre-processing.
• Moving data from HDFS to RDBMS and vice-versa using SQOOP.
• Collecting and aggregating enormous amounts of log data using Apache Flume and staging data in HDFS for further analysis
• Installed and configured Hadoop cluster in Test and Production environments
• Performed both major and minor upgrades to the existing CDH cluster
• Implemented Commissioning and Decommissioning of new nodes to existing cluster.
• Analysing/Transforming data with Hive and Pig.
• Data cleaning and pre-processing using Excel, JMP and python.
• Feature analysis to find the relationship between the process entities of health care.
• Descriptive statistics and frequencies were analyzed. Bivariate and multivariate techniques were used to reveal relationships between process delay and the other variables.
• Prepared the dashboard on Excel, Tableau and Power BI to show the reason behind the process delay of patient movement in SJMO.

Environment: Microsoft Excel, Microsoft Word, Microsoft Power Point, MYSQL, Tableau10.4, Qlik View and Sense, Hadoop environment, Linux, MS Visio, MS Project, UML, MS Access, SQL Server Management Studio, Visual Studio, Hadoop environment, JMP, Python 2.7.13, R version 3.4.3, Data Simulation, Solver, Power BI, Cognos 8.2