VILAS MAMIDYALA

**** ********* ******, *** * 816-***-****

Kansas City, MO 64110 acz0tl@r.postjobfree.com

https://github.com/vilasmamidyala linkedin.com/in/vilas-mamidyala-31557b102 PROFESSIONAL SUMMARY:

• Student Assistant at UMKC Information services from June 2016

• ETL Developer at Cognizant Technology Solutions from Aug 2013 –Dec 2015

• 2.5 years of hands on experience in Informatica, Teradata, Data Stage, Tableau and Oracle

• Extensively Worked on SQL, PL/SQL Oracle, UNIX, Shell Script and Java

• Coursera Certified in “Introduction to Big Data” by University of California, San Diego. February 2017

• Received EIM-AVM INSPIRE Award for April 2014 and April 2015 at Cognizant

• Cognizant Certified Professional in Informatica, Data warehousing, SQL and PL/SQL ACADEMIC QUALIFICATION:

University of Missouri-Kansas City Expected May 2017 Master of Science in Computer Science GPA 3.7

Jawaharlal Nehru Technological University, Hyderabad May 2013 Bachelor of Technology in Computer Science Engineering GPA 3.8 TECHINICAL SKILLS:

• Informatica Power Centre, Data stage, Tableau, ESP Scheduler, MSBI-SSRS, SSIS

• Teradata, Oracle and SQL server, Toad, Mongo DB, Android Studio (SDK), IBM Blue mix

• Hadoop, Apache Spark, AWS Elastic Cloud, Putty-UNIX, HPSM, JCM

• C, C++, Java, Scala, Python, HTML, CSS, JavaScript, JSP, AngularJS, D3.js PROJECTS:

Academic:

Title: Shortest Path for Congested Network November 2016- December 2016 UMKC as part of course work for Design Analysis and Algorithms and Tools: Java, Eclipse Description: This project was to find the shortest path between all the nodes during Network congestion. We had used Floyd-Warshall algorithm for implementation and calculated the actual delay between all the nodes. Title: Review Point April 2016

IBM-UMKC as part of Hackathon contest and Tools: Scala and Intellij, Spark Framework, D3.js Description: In this project, Amazon reviews dataset provided by IBM used as the source of data. Further, developed the queries using Spark SQL to analyze the reviews. Used d3.js for the visualization of results. Business:

Title: Cognizant-Cigna Corporate Warehouse (CCW) April 2015- December 2015 Client: Cigna and Tools: ETL – Informatica and Data stage, UNIX, Teradata, HPSM, ESP Scheduler and Tableau Description: Design ETL jobs to load data in the data warehouse tables, Designing, developing and testing Different Mappings according to Requirements. Analyzing the logical model of the Databases and normalizing it. Title: Cognizant-Cigna Information Factory (CIF) – ODS, IHUB& OneSource March 2014-April 2015 Client: Cigna and Tools: ETL – Informatica, UNIX, Oracle, HPSM, ESP Scheduler and Tableau Description: Develop robust ETL designs (functional and technical) for the ETL solution. Extensively worked on designing Dashboards and Visualizations of data using Tableau. Tuned both ETL process as well as Databases. Title: Cognizant-United European Car Carriers August 2013- March 2014 Client: UECC and Tools: MSBI- SSRS and SSIS

Description: Develop, design, and deploy professional and polished reports using SSRS. Support legacy Java applications for bug fixes and minor enhancements. Demonstrate familiarity with relational database concepts and software development life cycles. Moderately experienced in SSIS development and deployment.