Data Information Technology

Kalyan Dasari

469-***-****; **************@*****.***; https://www.linkedin.com/in/kalyan-dasari-28a094a0

EDUCATION

The University of Texas at Dallas - M.S., Information Technology & Management Aug 2017

Sathyabama University, Chennai - B.E., Electrical and Electronics Engineering Apr 2013

CERTIFICATIONS & TECHNICAL SKILLS

Certifications : Oracle 11g Database Associate, Google Analytics

Programming : C, C++, Oracle SQL & PL/SQL, Java, Base SAS, Python, XML

Tools : Toad, ERWIN Data Modelling, SAS Enterprise Miner, Python, Tableau, Crystal Reports

WORK EXPERIENCE

Wipro Technologies

Project Engineer Jun 2013 – Apr 2015

Implemented ECM (Enterprise Content Management) system to Oracle EBS through Web Services (SOAP)

Involved in many enhancements in areas like SQL, PL SQL and OAF in Procurement, Finance and custom module Travel

Identified and resolved SQL, PL SQL and OAF issues in the ECM project during SIT, UAT and Go-Live project phases

Enhanced existing Form pages through Personalization, Reports and have good knowledge in AOL objects

Responsible for developing test cases to lighten the load on QA to expedite the Quality check

Furnished support team to counter issues after the project went live

Business Analyst Apr 2015 – Dec 2015

Developed database in projects with large, diverse, client data source files.

Used historical data to analyze and projected a plan to efficiently use available funds.

Played a key role in developing, debugging and validating the SAS programs to generate derived output.

Used PROC REPORT and PROC GPLOT to generate tables, listings and graphs.

Created and used existing macros to develop SAS programs.

ACADEMICS

Business Data Warehousing and Visualization Jan 2016 – Apr 2016

Used SAP NetWeaver BW to connect with source system and extracted data to persistent table

Created Info Object Catalog, key figures, characteristics info objects, Info Areas, Info Objects, DSO, Info Packages, Application Component, Info Cubes and built multi-dimensional OLAP cubes to aggregate the data

Developed calculate key figures very specific to a query to analyze data for better understanding

Used BEx Query Designer and Analyzer to analyze the OLAP data

Created reports using Tableau, SAP Lumira, Crystal Reports to analyze and understand the patterns of data

High Performance Analytics – Death Analysis US 2014 May 2016 – Aug 2016

Created a Semantic Layer for the SQLLITE database of death records in the USA, using QlikView

Refined the data model by resolving the circular references and synthetic keys issues

Designed a QlikView application for the exploration and analysis of the data using visualizations such as list box, selection box, pivot tables, pie chart, bar chart, trend chart, stacked bar chart etc.,

Created interactive dashboard reporting for better and easy understanding of the data

Advance Business Analytics with SAS Jan 2017 – Apr 2017

Used SAS Procedures for data preprocessing, cleansing and extracting statistical information

Efficiently modified data by creating new variables and removing redundant data to enhance the model

Modeled Count data using Poisson-Gamma (NBD model) and Logistic Regressions SAS Procedures

Used macros in SAS procedures to overcome reusability of variables and useful in logical expressions & filtering data

Used PROC REG, GLM, Logistics, GENMOD, MI, NLMIXED, Syslin and more effectively as a part of Statistical analysis

Contact this candidate