Yashwanth Madarapu

***** ***** ****** ****, *** # 508 ac2aht@r.postjobfree.com

Houston, Texas, 77062 832-***-****

OBJECTIVE

Pursuing graduation from a highly ranked university in Management Information systems with professional experience in developing database repositories and analyzing the data using ETL tools. Seeking a challenging software development opportunity in a dynamic environment where innovation and education are valued and encouraged for self-growth as well as growth of organization.

EDUCATION

University of Houston Clear Lake, Houston, Texas

Master of Science in Management Information Systems GPA 3.9/4.0

GITAM University, Visakhapatnam, India April 2013

Bachelor of Technology in Electronics and Communication Engineering GPA 8.88/10

RELEVANT COURSES

Advanced Programming Languages

Enterprise Resource Planning

Data ware Housing and integration

Advanced Database Systems

Advance Internet Application Development

Advanced Computer Networks

Management Information Systems

TECHNICAL SKILLS

Programming Languages

: Java, C#, C, C++.

Web

: HTML, CSS, JavaScript.

Operating Systems

: Windows, UNIX.

Tools and Frameworks

: Informatica 9.5, ASP.NET, Entity Framework, Business Objects, Autosys, CPT.

Databases

: Oracle 11g, SQL Server 2013, LINQ.

Scripting Languages

: UNIX Shell Scripting.

IDE

: Toad for Oracle, Visual Studio 2015.

PROFESSIONAL EXPERIENCE

Tata Consultancy Services (TCS) Hyderabad, India

Systems Engineer July 2013 –December2015

PROJECTS INVOLVED IN AT TCS (Client: Bank of America)

Project on Event Measurement Analytical Repository October 2013 – December 2015

The project mainly deals with the events happening across Bank of America locations. The number of attendees and the respective guests’ information is stored in the database. Various reports are being maintained across LOB’s (Line of Business) in Bank of America.

Responsibilities

Interaction with clients to understand the business flow and functional requirements of the application.

Used Agile Methodology for the application development.

Involved in HLD and LLD designing with the Business Analysts.

Developed the entire Database schema using Oracle 11g which includes procedures, functions and packages.

Used JIRA for work and ticket tracking processes.

Involved in fixing the production issues.

Involved in scheduling the daily jobs and procedures using Autosys.

Project on Talent Bureau April 2014 – December 2015

The project deals with the speaker information for the particular event happening across Bank of America. It also involves the high profile category of the speaker, speaker fee and the topic of the speaker which he is responsible for. This is one of the marketing applications in Bank of America.

Responsibilities

Interaction with clients to understand the business flow and functional requirements of the application.

Used Agile Methodology for the application development.

Involved in HLD and LLD designing with the Business Analysts.

Developed the entire Database schema using Oracle 11g which includes procedures, functions and packages.

Used JIRA for work and ticket tracking processes.

Involved in fixing the production issues.

Involved in scheduling the daily jobs and procedures using Autosys.

Involved in writing the shell scripts using UNIX scripting for data retrieval and transformation.

Project on Marketing Events Measurement December 2013 – December 2015

The project deals with the marketing events and all the employees and the clients of Bank of America. The most important thing is to calculate ROI (Return On Investment) which is the key factor in all the marketing applications. The business of the client is enhanced by calculating ROI.

Responsibilities

Interaction with clients to understand the business flow and functional requirements of the application.

Used Agile Methodology for the application development.

Developed the entire Database schema using Oracle 11g which includes procedures, functions and packages.

Used JIRA for work and ticket tracking processes.

Developed all the ETL objects using Informatica 9.5 which includes all the mappings, transformations and workflows.

Effectively developed and tested Type 1 and Type 2 (Slowly Changing Dimension) mappings.

Involved in scheduling the daily jobs and procedures using Autosys.

Involved in writing the shell scripts using UNIX scripting for data retrieval and transformation.

Project on Return Goods Management (TCS Training Period) July 2013 – October 2013

The project deals with the management of the Return Goods in a retail store and also the reason for the return or the exchange. All the Key Performance indicators are being calculated based on the above so that the decision making capability of the company is greatly increased.

Responsibilities

Interaction with clients to understand the business flow and functional requirements of the application.

Developed the entire Database schema using Oracle 11g which includes procedures, functions and packages.

Used JIRA for work and ticket tracking processes.

Developed all the ETL objects using Informatica 9.5 which includes all the mappings, transformations and workflows.

Effectively developed and tested Type 1 and Type 2 (Slowly Changing Dimension) mappings.

ACADEMIC PROJECTS:

Victim Identification Using Labview and Biometrics (LABVIEW): Jan 2013 – April 2013

The objective of this project is to immediately identify the victims who met with an accident by their finger prints with the help of Biometrics and Labview technology.

Developed code to integrate the information of the person with the finger prints.

Developed code to scan and integrate the finger prints using Biometrics.

The generated outcome if implemented in the real time will reduce the injuries and deaths caused as a result of accidents.

Designing Network across University (Cisco Packet Tracer-IOS command line): Jan 2016 – April 2016

The objective of this project is to develop the network across the university and allocating address spaces for all the individual systems.

Used Cisco Packet Tracer a virtual interface for doing the above and routing process is also implemented across different departments in the university.

Development of Black Jack online website (LINQ and C#): Jan 2016 – April 2016

The objective of this project is to build an online website for Black Jack so that user can register and play the game.

Used Oracle 11g for building the database objects and UI development has been done in C#.

The project is being developed in Visual Studio 2015 IDE.

Development of Online Dating Website (Oracle and Java): Jan 2016 – April 2016

The objective of this project is to develop an Online Dating website where the users can register to the site and find their match accordingly.

Used Oracle 11g for building database objects and UI is developed in JAVA.

The project is developed in NetBeans IDE 8.2.

Development of Reports for Motor Vehicle Crashes across US (Microsoft SQL Server):

The objective of the project is to develop reports for Motor vehicle crashes across USA during the years 2014 – 2016.

The raw data is collected from the data.gov website and the reposts are developed from the raw data.

The data collected is cleansed and data model is developed in MS Access database.

Then the data is being loaded into the SQL Server database where the data is being processed and building of the cube is being done in SQL server.

Reports are built from the processed data using the pivot tables and key performance indicators are identified for the future decision making.

ACHIEVEMENTS

ORACLE certified PL/SQL Developer Associate.

MICROSOFT certified ASP.NET MVC Web Applications.

Certified in Risk Management (Domain Based Certification) in Banking and Financial services.

Also have key competencies which included (E3 in Oracle, E2 in Informatica, E2 in UNIX shell scripting, E2 in Data Modeling and Data ware Housing concepts).

Received Appreciation for Best Performance in the project for two consecutive years at TCS.

Contact this candidate