Sohan Kumar Yennu

949-***-**** **** Oak Plaza, Apt #512 Omaha, NE 68106 acy9vf@r.postjobfree.com

EDUCATION

Masters of Science in Management Information Systems December 2016

University of Nebraska at Omaha, Omaha, NE GPA: 3.87/4.0

Bachelor's in Technology in Electronics and Communication June 2009

Jawaharlal Nehru Technology University, Hyderabad GPA: 3.5 /4.0

TECHNICAL SKILLS

Programming & MVC frameworks: C, C#, ASP.net, ADO.net, SQL/TSQL, Core Java, PHP, CSS3, HTML5, Bootstrap, JavaScript, JQuery, Angular JavaScript, Laravel Framework, CakePHP, Erwin

Database and Tools: MS SQL Server 2008/2012, Oracle, PostgreSQL, MySQL WorkBench

BI/Analytical Tools: MongoDB, Cassandra, Hive, Impala, Redis, Hadoop MapReduce, Weka, Apache Spark, Neo4J, Tableau, SSRS, SSIS, SSAS

Utilities: MSOffice suite, SQL Server Management Studio, Eclipse, Net Beans, GitHub, SQL Data Loader, PHPStorm, Wamp, Openshift, Bit Bucket, Cake PHP, Force.com, Salesforce SE, SourceTree

WORK EXPERIENCE:

Data Analyst, StrategicHealthSolutions, LLC, Omaha January 2017 - Present

Environment: MS SQL Server 2008/2012, SSIS, SMRT Tool

Analyzing and evaluating healthcare data from a variety of sources including Medicare and Medicaid to identify the billing patterns and trends of claims

Performing data analysis related to physicians, facilities, managed care organizations, and other types of healthcare providers

Analyzing healthcare data to detect aberrant patterns, trends, and vulnerabilities.

Conducting research and providing reports on identified issues.

Testing and monitoring data for quality and integrity

Interacting with subject matter experts to define analytical requirements and expected outcomes

Identifying opportunities for new analytical approaches and areas of focus.

Presenting data and research findings to staff, management, and customers through reports or presentations

Making recommendations based on research findings

Information Technology Analyst, Jenpro InfoTech Pvt Ltd, Hyderabad June 2009 - May 2014

Environment: Erwin, Oracle Data Modeler, ASP.NET, C#, MS SQL Server 2008/2012, SSAS, SSIS

Experienced in SDLC life cycle and Agile methodology

Analyzed business requirements and translated them into requirement specification documents

Developed data model requirements, designed schemas, logical and physical data models

Developed tables, triggers, indexes, sequences, constraints, functions and procedures

Developed cubes, created MDX queries, dimensions for multidimensional analysis using SSAS

Created workflows with dataflow task, script task, execute SQL task and containers

Software Developer

Developed BI Ad-Hoc Reports using Microsoft Business Intelligence (Reporting Services)

Updated, maintained and troubleshoot ETL packages at Ops level, rendering issues and cube availability

Hands on experience in Creating Stored Procedures, Functions, Triggers, Indexes, Views and CTE

ACADEMIC PROJECTS Jan 2015 - Dec 2016

Capstone: Workflow/Inventory Management System for Defense POW/MIA Accounting Agency

Environment: PostGreSQL, MySQL, Laravel MVC Framework, PHP, Heroku, Yodiz, GitHub, SourceTree

Elicited data model requirements/design from stakeholders

Designed schemas, database objects, logical and physical data models for proposed database

Created an import seed class for various data set so that the data can be used in the application

Imported main inventory and its associated data into database as per the requirements

Created audit tables used to track changes against User, Roles and Permissions table

Created CRUD functionality for various admin screens to be used in the system

Developed screen validation to reduce data entry errors to improve efficiency

Data Mining with R - Marketing Campaign of a Portuguese Banking Institution

Scrubbed data for mining and performed an exploratory data analysis

Predicted marketing campaign efficiency of the banking institution through improved data analytics

Contact this candidate