*

MANIDEEP DYAVANAPALLI

*** ****** ******, #**, **********, OH 45220.

E: adbdtw@r.postjobfree.com T: 402-***-**** www.linkedin.com/in/manideep-dyavanapalli/ SUMMARY

3+ years of experience in programming and BI development with extensive knowledge in banking and finance industry. Pursuing Master's in Computer Science from the University of Cincinnati. WORK EXPERIENCE

BizAcuity Solutions Pvt Ltd, Hyderabad, India

BI Developer Mar 2017 – Jul 2019

• Developed Advanced SQL queries and stored procedures to generate data reports. Dug into the database details to ensure appropriate data filters,randomization and stratifications are applied based on business requirements. Have successfully delivered 12 high-level reports in the two quarters.

• Created alerts for successful or unsuccessful completion of scheduled jobs thereby reducing POS failures by 90%.

• Implemented Sales performance, KPI’s, Incentive, delinquency and other essential reports for the financial and banking operations.

• Collated data from multiple sources (SQL server, flat-files, xml and excels). Connected data sources by business intelligence tools (SSIS, R-studio and excel VBA), Linked database objects (linked server, database link etc.), and inline queries

• Implemented SQL query performance tuning by creating/modifying indexes, setting transaction isolation levels, and changing query structures .Successfully reduced queries duration time by 50% - 300%.

• Automated the process of cash-orders,fraud alerts, cash usage reports through excel VBA for efficiency and standardized handling of repetitive tasks.

• Forecasted a year/quarter/month’s revenue, cash-flows and transactions with statistical and model prediction algorithms on R-studio.

• Utilized Weighted moving average in excel and Holtz winters in R for monthly cash usage predictions at store.

• Implemented Mid-shift algorithm to allocated daily labor hours in stores reducing the budgets on workforce by over 30%.

• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

• Managed a team of four. Assigned tasks, held team meetings and prioritized work tasks.

• Oversaw the operational tasks, maintenance and ad-hoc requests of over 150+ stored procedures, set requirements review meetings, and ensured timely hand-over of the tasks. ETL developer Dec 2016- Mar 2017

• Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.

• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems and then to the Data Marts. Computer Science Corporation, Hyderabad, India

Junior Software Developer Oct 2016 – Dec 2016

• Experience with Java Server Page (JSP), designing and developing client-side graphical user interfaces using HTML, JavaScript, jQuery and CSS.

2

EDUCATION

Master’s, Computer Science (3.83 GPA) Dec 2020

University of Cincinnati, College of Engineering and Applied Sciences, Cincinnati, Ohio Course Work: Cloud Computing, Machine Learning, Advance Algorithms, Database theory, Op Systems, Large Scale SW Eng.

B. Tech, Information Technology (3.75 GPA) Jun 2016 Jawaharlal Nehru Technological University, Hyderabad, India Course Work: DBMS, Data Warehousing and Mining, Java, SDLC,c/c++,operating systems, scripting languages, web technologies, database theory, entrepreneurship. TECHNICAL SKILLS

Programming Language: MS SQL, R,VB script,python, Linux shell and Java Database: MySQL, SQL Server and Oracle 10g

Servers: SQL and Apache Tomcat

Reporting tools: Tableau, Power BI, Jasper Soft & Excel. Distributed Computing Tools: SQL Management Studio, Unix, Docker, Kubernetes, Hadoop, HDFS, Spark, Map Reduces

LICENCES & CERTIFICATIONS

Developing Microsoft SQL Server 2016 Databases LinkedIn Nov 2019 Advanced SQL for Query Tuning and Performance Optimization LinkedIn Nov 2019 Programming Foundations: Object-Oriented Design LinkedIn Dec 2019 Learning Python LinkedIn Jan 2020

AFFILIATIONS AND SERVICES

• Served as the Vice-president of entrepreneurship club ‘Anthar-Prerana’ at SNIST.

• Nominated for the corporate award Biz-Fresher for the year 2017-18.

• Teaching Assistant for the undergrad students in programming fundamentals.

• Blogger at BizBlock.wordpress.com

Contact this candidate