Sravani Punyamurthula


About Me

Hello! My name is Sravani and I am a graduate student(MS - Computer Science) at University of Missouri - Kansas City. My emphasis in my masters is Data Science and Software Engineering. I am graduating in December 2015 and am seeking a fulltime position in the following areas:

  • Big Data
  • Data Analysis
  • Software Engineering
  • Business Analyst

Education

Master of Science - Computer ScienceCurrent GPA: 3.95

University of Missouri - Kansas City
In Progress - Graduating in December 2015.


Bachelor of Technology - Electronics and CommunicationsPercentage Pts: 81%

Jawaharlal Nehru Technological University, Hyderabad - India
Graduation Date: May 2009

Experience

Graduate Teaching Assistant August 2015 - Current


School of Computing and Engineering, University of Missouri - Kansas City

I am currently working as a Teaching Assistant with Prof. Yugyung Lee. I help her teach Advanced Software Engineering. I teach the following topics and concepts:

  • Web application design: Wireframes, Mockups
  • Web application Development : Angular JS, JQuery
  • Unit Testing Javascript​: Karma, Jasmine
  • Android App development : Ionic , Android Studio
  • Rest Services development : C#, WCF
  • N-Unit Testing for .Net applications
  • Cloud deployment in IBM Bluemix, Microsoft Azure, Google App Engine
  • Agile project management tools: Scrum Do, Kanban

Database Administrator - Assistant January 2015 - August 2015

Internal Applications, University of Missouri - Kansas City

Projects and Responsibilites:

  • Worked on a Hadoop proof-of-concept to determine whether the implementation would be of value to the school.
  • Research cutting edge tools and processes to help streamline current DB environment at the university, determine feasibility and help with implementation.
  • Assisting with DB Maintenance activities and managing user access.
  • Configured transparent data encryption (TDE) in Oracle 12c servers to encrypt and redact highly confidential data.
  • Worked on a proof of concept on Oracle Rest data services (ORDS). ORDS accepts restful web service calls, executes corresponding SQL statements/Procedures and returns data to the application.
  • Integration of Oracle/SQL server databases with GitHub using red gate Source Control.
  • Configured and established heterogeneous connections to fetch data from MySQL, SQL server databases to Oracle.
  • Assisting developers in normalizing their data models and tuning complex SQL queries.
  • Explored SQL Developer Data Modeler and trained developers on designing and documenting data model using the tool.
  • Developed reports to track the databases on all the servers (Oracle, MySQL, SQL server).
  • Evaluated performance of Oracle and SQL Server on both local servers and Amazon virtual machines.

Principle Analyst August 2012-October 2013

Capital One Services, India

Projects and Responsibilites:

  • Client interaction, prioritizing projects, gathering requirements, preparing the formal and technical specifications, performing impact analysis, designing ETL process and leading project teams
  • Maintain contact center performance report for North America credit card section of HSBC Bank and Capital One. SME for employee, survey and inbound subject areas within CIM team
  • End to end design, development and deployment of branded book conversion project to integrate HSBC and Capital One accounts
  • Implemented change data capture logic using Oracle stored procedures and Datastage
  • Train on-shore and off-shore teams on technology and business functionality

Software Development AnalystJuly 2009-July 2012

Dell International Services, India

Projects and Responsibilites:

  • Started as a software developer in Data warehousing and Business Intelligence department and moved up to a Team Lead and Business System Analyst in 3 years.
  • SME (subject matter expert) for Infolease and Vision Plus for Dell Financial Services
  • Developed critical Dashboard reports for key performance indicators for Dell financial services
  • Designed ETL mappings in Informatica and Abinitio tools for multiple projects.
  • Worked on performance tuning of existing jobs and was able to reduce run times significantly.
  • Developed Teradata macros and worked on the loader utilities like Fastload, Multi Load and TPUMP
  • Developed Oracle PL/SQL procedures to encrypt highly restricted data like SSN in DFS tables.

Academic Projects

Working on my thesis on automated recovery of software architecture from open source code. This project involves analyzing open source code from repositories like GitHub and converting it into Resource Description Framework (RDF) model. The extracted code is stored in Apache Spark for analysis and the features in the code are identified using Machine learning algorithms. We are using OWL Ontology to add the features and develop the training data.

Developed YouRS(YouTube ranking system) web application in 3 days as part of UMKC Hackathon Spring 2015 using .Net MVC5 and deployed the application in Microsoft Azure. The primary goal of this application is to retrieve videos from YouTube using V3 data API and implement a ranking algorithm. This project was third prize winner at the Hackathon.

Created an application on IBM Bluemix platform that would analyze NFL tweets and perform Player, Team, Time, Location and Hashtag analysis. The tweets were collected through Twitter APIs using Python and the data was stored in a Hive engine for analysis.

Developed an Android app “Calorie2Grocery”. This app ties together grocery management and calorie intake. The app would allow the user to log groceries available at home, search/create recipes, import ingredients, get the calorie count per ingredient, generate a shopping list, and find nearby grocery stores. For database connectivity, we have built .Net rest services.

Ambulance Routing System: Developed a .Net application with a MySQL backend to assist ambulance diversion in real time. The application helps the ambulance driver to search for nearby hospitals and send request to them with the patient information. Hospitals can respond with their availability of the emergency department. This application helps in finding the right hospital in right time so that patient can be provided with appropriate medical care.

Awards

Bronze Award award for my contribution towards Dell Financial Services KPI reporting. The key performance indicators delinquency, loss and fee are very critical for DFS.

Outstanding Performer Award - My expertise in analyzing data & problem solving, helped me in identifying the ghost contracts, root cause for a critical issue which caused an alarming loss report of $1M. I was awarded with outstanding performer award for the same

Star Performer Award for quickly learning the new domain and accomplishing the Focus and Agents Stats projects in Capital One. Agent statistics show the performance and efficiency of call center personnel.

Quarterly Performance Award for driving the COF CCP Integration Project which is part of Branded book conversion and extending the CIM operations reporting to 25K capital one users.

Pratibha Award from Government of AP for achieving top rank (37 out of over 150,000 students) in the Eamcet state Board entrance exam for undergraduate program in India.

Recipient of Dean International Student Award at University of Missouri- Kansas City.

Winner at UMKC Hackathon 2015

Activities

Initiated Developer's Forum in Dell Hyderabad. This forum was focused on the future of Data Warehousing and Big Data technologies.

Presented on multiple domain specific and project deep dive topics in Optimus Quarterly Technical & Organization Meet in Dell EBI

Part of many initiatives like 'Things to Do', 'Development Special Project' to improve the coding standards and to set up the best practices and guidelines in Dell EBI

Worked on a proof of Concept on Dell Boomi an Open Source end to end cloud platform. I was nominated for Dell India Innovation 2011 awards for my presentation on Dell Boomi

Conducted multiple technical and functional trainings to CIM Operations team members at Capital One.

As a step towards improving organizational analytics, I have attended Business objects training in Dell and Advanced Excel, SAS trainings in Capital One.

Part of many organizational activities Go Green at Capital One and Make a Difference, WISE at Dell.

Assisted my professor in developing a software for a simple heart rate monitor in my undergraduate program.

Technical Skills

Programming Languages Java, .NET, Python, JavaScript,C, C#
ETL Tools Informatica , Abinitio , Dell Boomi , Datastage
BI Tools Business Objects, Excel
Big Data Hive, Cassandra, Spark
Frameworks Hadoop, IBM Biginsights, IBM Blue Mix
Web Technologies/ Frameworks Jquery, AngularJS, Bootstrap
Issue Tracking tools Quality Centre, TFS
Scheduling Control-M , Unix Crontab
RDBMS: Oracle, Teradata, SQL Server, MySQL
Version Control GIT , Subversion