Ram Pramod Tuptewar

*** ******* ******, ****** ****, New Jersey 07306

Cell: 816-***-**** Email: ac45rl@r.postjobfree.com Linked in Profile https://www.linkedin.com/in/ram-2018/ Summary

• Graduated from University of Central Missouri done my master’s with Data Science Specialization, Seeking Full time position available to join immediately.

• Result-oriented professional having 3.3 years of Experience on data warehousing in analysis, design, development and providing support for software applications using Informatica Designer 8.6 and 9.5.1, ORACLE (10g,11g), UNIX, Tableau.

• Monitored and scheduled daily, weekly and monthly batch jobs through Autosys in UNIX environment.

• Good knowledge on data warehousing tools – Informatica & Tableau.

• Knowledgeable in UNIX, Autosys, HP Service Manager, Oracle(10g,11g), SQL, PL/SQL.

• Knowledgeable in BO and OBIEE reporting tool.

• Good Knowledge on Big Data, Machine Learning, R.

• Working to improve my skills on Python, Hadoop and Data Science related technologies. Technical Skills

Informatica SQL, PL/SQL Business Objects XI R Business Intelligence ETL Unix OBIEE Python SQL Developer

Data Warehousing Shell Scripting Tableau Hadoop MapReduce Toad Autosys Big Data Data Science Business Analytics Oracle (10g,11g) HP Service Manager Machine Learning Excel Data Analytics Education

Master of Science in Computer Science with Data Science Specialisation (Graduated) University of Central Missouri, USA, 2017

• Having 3.6/4.0 GPA, graduated in December 2017.

• Done Specialization in Data Science Opted R, Machine Learning, Big Data, Data Mining, Adv. Database subjects.

• Working on Statistical Learning techniques, Python, Hadoop and Data Science related skills and tools.

• Worked on two R Projects WhatsApp Sentiment Analysis and Performance Analysis of KNN, K-Means and Fuzzy K-means algorithms on IRIS Data set.

Bachelors’ in Computer Science

SRTM University, Nanded, India, 2013

Professional Experience

Database Developer – Intern at Rudra Infotech from January 2013 to February 2014(1-year 2 Month). Project: Fuel SMS a student search engine project

Technology: Oracle 11g, SQL and Front-end technologies Worked on Fuel SMS a student search engine project. Was part of a development team, provided back end support and worked on Database Design and Development part of the project. Senior Software Engineer at IGATE Global Solutions Limited from March 2014 to March 2016(2 years 1 Month). Role: Informatica Developer

Client: MUFG Union Bank, USA

Technology: Informatica 9.5, Oracle 11g, Unix, Autosys, HP Service Manager, PL/SQL, Tableau PROFESSIONAL SUMMARY

Project #1: OFSAA (Oracle Financial Services Analytical Application) for MUFG OFSAA (Oracle Financial Services Analytical Application) basically has the following modules: Funds Transfer Pricing, Profitability Management, Assets and Liability Management and Balance Sheet Planning. The old application was running in OFSA 4.5 which only captured reports for westwards data (Union Bank of California). But after merger of Union bank with Mitsubishi Tokyo Bank, the combined entity was known as MUFG group. Mitsubishi Tokyo Group contains eastwards data. So, the objective of the project was to combine both East & west data & generate end user reports. The scope of the work was to load pre-staging tables from different data marts. Sources for pre-staging tables were CDW, EDW, Green Plum, flat files & Sql loader scripts. Pre-staging tables load was followed by staging tables & then processing tables which was loaded by OFSAA application. Project #2: Returns Manager for Union Bank of California Returns Manager was a project based on loans returns calculation. The loans were categorized into Commercial Banking, Business Banking Group & Retail Banking. The functionality of the spreadsheet was being transformed to front end application apex which was built on PL/SQL code in the backend. There were ETLs built to source the customer, organization, employee, & contractor data on daily basis. The main objective of the project was to provide a report based tool which can be used by corporate bankers. Roles & Responsibilities:

• Designed and developed ETL mappings, extensively used various transformations to load warehouse data.

• Extensively worked on data extraction, transformation and loading data from various sources like Oracle, Greenplum SQL loader and Flat files.

• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.

• Used workflow manager to create task and used workflow monitor to monitor and analyse the loading statistics.

• Created reports using Tableau reporting tool as per client requirements of deliverables.

• Created shell scripts for triggering workflow & updating parameter files used in workflow.

• Involved in creating metadata tables containing the statistics of load timing, workflow status & audit information.

• Evaluated all functional requirements and map documents and performed troubleshoot on all development processes.

• Experience in database programming in PL/SQL (Stored Procedures, Functions and Packages), SQL and Oracle.

• Analysed the flow of data and created analysis document for defects.

• Involved in defect fixing which were found in System Integration Testing and UAT environment & ensured streamline flow of deliverables to production.

Certifications

• Microsoft IT Academy .Net Certification.

• Oracle Database Certification.