UTHRA MAHENDRAN

Email: adgq8q@r.postjobfree.com

Ph: +1-682-***-****

PROFILE OVERVIEW:

5.5 Years of overall experience in industry and as a researcher focusing on data analysis.

Extensive experience in reviewing and analyzing Business Requirements.

Expertise in Analysis, Design, Development, Testing, and Support for Data Warehouse applications.

Experienced in writing SQL queries for back-end testing and validation of data in Database.

Experienced in working with high volume datasets from sources like Oracle, flat files, SQL server.

Well versed in relational and dimensional modeling techniques like star schema.

Experience with debugging data flow, query optimization, SCD management Type 1,2, source-target mapping and performance optimization.

Skilled in various dimensions of development including extraction, transformation and loading of data using Informatica.

Extensive DB experience working with Oracle, MySQL and MS SQL.

Worked on numerous Data Science, Data Mining and Data Warehouse projects using tools like SAS E-Miner and SAP BW.

Strong knowledge of Data Warehouse Development Life Cycle.

Knowledge of Big Data with understanding of the Hadoop Distributed File System Eco System.

Capable of handling stringent deadlines, taking ownership of tasks and multi-tasking.

TECHNICAL SKILLS:

Programming languages: Python, C++

Tools & Software: SAS Enterprise Miner, MATLAB, SAP BW, Tableau, SQL Server 2012, Oracle SQL 10g, ETL (Informatica PowerCenter 9.6,9.5), Erwin 4.0

ML Framework: Scikit-learn

Database language: Oracle SQL, MySQL, Maria DB.

Development Process: Waterfall methodology, Agile methodology

EDUCATION AND QUALIFICATIONS:

Master of Science in Information Systems

University of Texas at Arlington (Graduated: May 2020) GPA: 4.0

Bachelor of Technology in Electronics & Communication

Amrita University, India (Graduated: May 2012) GPA: 8.9

WORK EXPERIENCE:

Intern, STM Inc, Coppell July 2018 - Dec 2018

Project: Worked on a digital audio product project to perform product analysis and testing in support of innovative product introduction, qualification, yield enhancement and customer quality grievances. The procedure enabled scanning of data to perform characterization and analysis so that products can be evaluated based on certain metrics and standards. This enabled the management to efficiently detect patterns and develop strategies to mitigate product issues, act based on evolving market demands by perceiving customer requirements and ensure meeting the target financial performance.

Worked with the team to gather & understand the requirements.

Created understanding document and acceptance test plan for functional & application testing.

Created bench test setup by interfacing equipment with software to conduct functional & application tests.

Performed scan test for advanced digital audio products

Created failure analysis reports to share with the stakeholders.

Developed & documented work instructions for functional & application test setup for peer to use as a manual.

Graduate Research Assistant, UT – Arlington

January 2015- May 2018

Project: To support Institutional analytics and decision making through data analysis, interpretation and reporting to provide insights for institutional action.

Communicate with Business analysts and clients to understand business requirements and reporting requirements.

Extract, analyze, interpret, validate and test university data using SQL, SAS and Excel.

Work on design, development and reporting of data models to support Business Affairs.

Evaluate and respond to data requests generated from within and outside the institution.

Experience in a data analysis, data driven research and/or predictive analysis role.

Experience with utilizing analytical tools such as SAS Data Integration Studio, SAS Enterprise Guide, SAS Visual Analytics, SAS Programming and tools like PeopleSoft Campus Solutions

Collaborated internally with the data sources to improve accuracy of data entered and stored in the centralized database and communicate any data issues.

Evaluate and enhance data models for accuracy & performance.

Worked with other reporting teams within the institution to establish design and data quality standards.

Prepare and present detailed data analysis and Ad Hoc reports in formats like charts and SAS dashboards.

Organize and present clearly and effectively research-based information, analysis, results, and interpretations.

Ability to communicate and collaborate with people at all levels of the organization.

Software Engineer, Accenture – Chennai

May 2012- December 2013

Project: Worked on project involving design, development and testing of data warehouse for a financial services client.

Worked with business analysts to identify appropriate sources for data warehouse and prepared Business Release Documents.

Experienced in requirement analysis, preparation of test scenarios and documentation of test scripts.

Documented business rules and worked on functional and technical designs, test cases, and user guides.

Developed Informatica mappings/mapplets, sessions, Workflows for data loads.

Involved in end to end testing of business rules on the Web based application.

Transformed data from the staging area and loaded to the target on Oracle using Informatica tool.

Extensively used transformations like Filter, Aggregator, Joiner, Expression, Lookup, Router, Rank and Update Strategy.

Created and executed scripts for Functional, Regression, Performance testing.

Used SQL tools to run SQL queries and perform data validation, query tuning to validate the data in warehouse and mart.

Experience with Optimizing/Tuning mappings for better performance and efficiency.

Experience with SQL query optimization, SCD Management including Type 1, 2, Cleansing, Conversion, Aggregation, and Performance Optimization.

Experience with design of Source to Target maps, Code Migration, Version control, scheduling tools, Auditing & data movement.

ACADEMIC PROJECTS:

Datawarehouse Project: Visualize & explore bike company data and derive business insights through analysis using SAP.

Worked on creation of info cube that contained comprehensive sales data after extraction, transformation & loading.

Explored data through querying & discovering critical business information that is used for decision making using SAP Business Explorer software.

Performed data visualization and analysis using SAP Business Object Analysis software.

Data mining project: Visualized & transformed play store apps data in SAS E-Miner and employed mining models to predict which among the free apps could be monetized by converting them into a paid app. Also provided recommendations & implementation ideas based on predictive model results to increase profit.

Machine learning Project: Pre-processed Titanic passenger data and performed feature engineering on the data. Best model was selected & evaluated to predict which passengers survived the shipwreck through hyper-parameter tuning various supervised & unsupervised models. The model had to identify which group of people were more likely to survive than others using passenger data.

Web data Scraping project: Project involved extracting data on all the current rankings for songs, albums etc., listed on the site from the Apple iTunes charts and presenting the information to the user based on their choice of category and ranking using python.

Worked on multiple projects to pre-process, visualize and analyze the data using Python, SAS E- Miner and SAP.

Experience presenting research at technical conferences.

Served as teaching assistant with over 100 students; guiding them with their projects.

Contact this candidate