Data Sales

SPOORTHI RAJENDRABABU

786-***-**** ********@***.*** www.linkedin.com/in/spoorthi-rajendrababu-a82922170/ 290 NW 109th AVE Miami,Florida-33172 EDUCATION

Master of Science in Information Systems(3.95/4) Oct’19 Florida International University Miami

Bachelor of Engineering in Electronics and Communication(3.8/4) Jun’14 Visveswaraya Technological University, India

TECHNICAL SKILL SET

• Data Management & Visualization • Statistical Analysis & Modeling • Data Mining, Data profiling

• BI Tools: Informatica, Tableau, Power BI,SSDT, Excel • Languages: SQL, R, Java, Python,pyspark • ITIL Certified, six sigma yellow belt certified WORK EXPERIENCE

Business Intelligence/Data Analyst intern, Data Mining - Ryder System, Inc, Miami, FL May’19-Current

● Data warehousing, ETL:

• Developed mappings, mapplets, sessions, workflows, worklets to load vehicle invoice fact & fleet dimensions data with SQ filter& look up transformations to target table using informatica power center designer, workflow manager.

• Interacted with Business for the request from Amazon customer & analyzed the shop data,vehicle repair data from multiple sources & fetched the data together to Datawarehouse through ETL Process using Informatica, SQL & created view. This reduced the time required to iterate the same process every day by 80%.

• Defined metric & data definitions created lineage tracking documents & staging tables for Project Unify financial transactional data and used WinSCP to monitor ETL Jobs.

• Wrote Python scripts for cleaning & transforming the used vehicle sales data, customer data using NumPy and Pandas library.

• Created SQL scripts, views(Netezza, Microsoft SQL Server,DB2) to perform data aggregation for vehicle warranty detail report.

• Provided analysis for observed trends in customer data for used vehicle sales through data Querying and by interacting with relevant business units for domain expertise and fixed ETL critical incidents and explained it to business.

● Data Mining: Microsoft azure databricks:

• Evaluated opportunities for used vehicle sales by analyzing market trends and did predictive lead scoring through data extraction & data modeling(logistic regression, recursive partitioning trees, neural networks) using R, Python & Co-ordinated with Marketing and IT teams to ensure campaign execution.

• Developed Fleet performance productivity data visualization dashboard using Power BI and Tableau. Teaching Assistant, Florida International University, Miami, FL Oct’18-April’19

● Core java programming, Java assignments grading, zoom training. Tata Consultancy Services, India

Business Intelligence Analyst: (1 year) Sep’17-Aug’18

• Data blending to combine CITI prepaid virtual card data coming from First data,physical card data from Fiserv using SQL.

• Created dependencies between workflows by raising an event in informatica workflow manager for ACH Payroll data jobs to avoid deadlock and discrepancies due to delay in file arrival.

• Wrote automation scripts to clean & transform Prepaid card DebitACH transactional file data & load to a data warehouse

• Analyzed informatica mappings & did process improvements on ACH Payroll data which reduced the job runtime to load. Production Support Analyst, Tata Consultancy Services, India (2 years) Aug ’15-Jul’17

• Wrote SQL scripts & java code using Selenium Webdriver to automate the frequently occurring incidents as a process improvement & created reports using SSRS. This reduced incidents and time & effort taken to resolve the incidents by 50%.

• Worked on ETL tickets using ServiceNow, JIRA & trouble shooting it using SQL. Also, wrote white paper on “wiki documents”

• Configured Active batch jobs and created dependencies between the jobs to run the batch file and load the data into SQL. ACEDEMIC PROJECTS: Florida International University Aug’18 – Oct’19 Data Warehousing, Data Modelling:

• Large wireless telecommunications company data, Washington Crime data: Created star schema (defining granularity and hierarchies) and performed ETL Process using tableau prep,SSDT and visualized the analysis in Tableau desktop and Power BI. Data Mining-Predictive Analysis/Data Analytics (R, Rapid Miner) :

• SellersFunding loan company data: Did Predictive analysis using Linear, logistic Regression, decision tree & applied k means clustering & predicted the default sellers & significant factors that could be considered while funding loan to the sellers.

• Falcon Farms Inc data: Analyzed data & added external twitter data & applied sentimental analysis and clustering techniques on extracted tweets and applied linear, logistic regression, correlations to forecast product category & quantity which could be sent across different regions using R & Python .Also developed ARIMA Model to predict sales.

• Pricing calculation: Descriptive statistical modelling with 95% confidence interval using Microsoft excel. Ecommerce Product Segmentation:

• Identified factors impacting revenue using linear regression & clustering algorithms for product segmentation & market basket analysis for electronic products recommendation of shop smart & displayed the highest revenue products from clusters.

• Used advertising-subscription revenue model & Commission based profit model & customer funnel model to acquire customer. Software system design :Restaurant use case: Developed class diagram, use case, sequence diagrams, UI Diagram and java programming.

• Developed an ER & relational representation design for the healthcare case & created SQL scripts to show data model in action.

Contact this candidate