AKHIL REDDY K
Enthusiastic professional with a graduate degree and experience as a Business/Data Analyst seeking full time positions in the field of Data Analytics/ Business Intelligence. Highly adaptable, proactive individual capable of completing tasks well within the stipulated time. Strong expertise in data analysis using SQL, R, Tableau, Excel and proficient in Business Analysis. Also, capable of delivering animated motivational presentation. Education
Master of Science in Information Systems
Northwest Missouri State University, Maryville, MO 3.54/4.00 Bachelor of Technology
GITAM University, Hyderabad, India 3.85/4.00
Documentation of Project Vision Document, User Stories, RTM, BRS, FRS, RMP, Test Case., Data management using SQL, Python., Data Analysis using R, MS-Excel, SAS, SDLC, Data Mining, Predictive Analytics, Rapid Miner Studio, Math, Business Statistics, Linear Regression, Logistic Regression, Statistical Modeling, Machine Learning, Time Series Analysis., Visualization using Tableau, MS-Visio, Excel., Prototyping using InVision and JustInMind. Graduate Assistant, User Centered System Design and Implementation JAN’17-JUL’ 17 Northwest Missouri State University, Maryville, MO, USA
Demonstrated field work techniques and assisted professor with lessons.
Learned and demonstrated peers with trending prototyping tools such as InVision and performed a job duty of acting as a client for five project teams.
Produced Wireframes, XHTML code and CSS that contributed to User Centered Design (UCD) efforts for Web page designing of Mozingo Lake Recreation Centre.
Managed usability testing for client landing pages in preparation for website redesign. Defined testing parameters, prepared prototypes, assigned users, facilitated tests and reported results.
Clarified requirements and segregated them into functional and non-functional categories.
Documented the discussions, concepts and the finalized scope. Environment: Mainframe system, XML, WSDL, SQL, Jira, SOAP UI, InVision, Moqups, Balsamiq, JustInMind, C++, JAVA, MS Visio, MS Excel, MS PowerPoint, MS Word
Business Analyst JUN’15-JUN’16
FLAWLESS SOLUTIONS PVT.LTD, Hyderabad, India
Assist business & functional teams in formulating strategies based on micro level data analytics, bench marking and industry.
Collect sales data of the past years to analyze and present findings and suggestion to the management.
Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
Created action filters, parameters, calculated sets and data blending techniques in Tableau.
Prepare high-quality & crisp presentations and creative visualizations explaining the company’s strategy, sales budget and business results.
Actively participated in design & implementation of business data.
Facilitated Joint Application Design (JAD) sessions between technical and regulatory teams for meeting business/data requirements as well as solving problems daily.
Gathered and translated requirements into functional, technical, and design specification documents, and authored detailed Business Requirement Document (BRD) using MS Office tools. Identified data sources and transformation rules required for populating and maintaining data warehouse content.
Created test plans and performed User Acceptance Testing before deploying application to production database.
Analyzed business requirements and worked closely with the various application and business teams to develop ETL procedures that are consistent across all applications and systems. Summary
Developed UML diagrams such as Use Cases for the application and prepared the detailed Work flow diagram such as sequence diagrams, activity diagrams, and ER diagrams based on the proposed enhancement for the system.
Performed GAP analysis to define as-is and to-be state and check the compatibility of the existing system infrastructure with the new business requirement.
Created reports for the BI team using Scoop to export data into HDFS and Hive.
Defined job flows within the Hadoop Environment.
Lead monthly meetings with clients and management to analyze spending and provide financial recommendations.
Performed test case by writing SQL Queries.
Work with Business Development Team and Research Division Heads to develop wireframes and sitemaps for web pages.
Performed wire framing and scribbles.
Conducted market and user experience research for web design Understanding look and feel User functionality of the website design that has been created by the team will reflect the client’s requirements and characteristics
Conducted demographic analysis on website traffic. Environment: SQL Server, MS Office (MS Word, MS PowerPoint, MS Excel, MS Access, MS Outlook, MS Visio) and Tableau
Assistant Recruitment Analyst AUG’14-APR’15
GITAM University, Hyderabad, India
Assisted students with placement activities; serving as a bridge between corporate companies and students.
Used excel to analyze data, generate significant insights through extensive use of data analysis packages, visualization.
Work with users to identify the most appropriate source of record and profile/validate the data required for service.
Performed data cleaning by eliminating noise from the data and generated descriptive statistics. Conducted Univariate, Bivariate analysis and visualized it in SAS 9.4/ R Studio. Also, conducted linear regression analysis as well as cluster analysis frequently.
Document the complete process flow to describe program development, logic, testing, and implementation.
Responsible in maintaining the Enterprise Metadata Library with any changes or updates
Generated customized reports in various formats (HTML, RTF, PDF etc.) using PROC REPORT, PROC SQL, PROC TABULATE. Documented and tested component programs efficiently and included them in the integrated reports.
Used MS- Excel to analyze data, generated significant insights through extensive use of data analysis packages, visualization, etc.
Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality
Remain knowledgeable in all areas of business operations to identify systems needs and requirements.
Migrated the data from Oracle 8i/8.0, Flat File to MS SQL Server 2000 using ETL tools.
Handled running of complex and high volume of ETL processes.
Experienced writing of numerous SQL queries and performing ADHOC analysis.
Involved in implementation of user logins, roles and profiles as a part of security policies for various categories of users.
Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and Head of Departments to review in Excel Sheet.
Maintain web portal using Google Analytics, Adobe Suite, HTML5
Gather google analytics data to maintain site standards regarding new development and user experience
Developed charts, tables, and presentations to display data for public use. Environment: Service Cloud, workflow & Approvals, Email Services, MS Word, MS Excel, TFS, Rapid Miner, Solver, analytical applications using SAS Enterprise Guide Organizations & Accomplishments
Introduction to User Experience – University of Michigan (UX501x), 2017 Edx, Inc. (MOOC platform) - Certificate Id: f87fec96a00c4122bde7fff7ec9d685b Aided by the skills needed for User Experience research and design. Also, to conduct a micro-usability test. Microsoft – DAT204x certified R programmer.
Udemy certified Tableau Associate. Certificate Code: UC-NLHDGB5L. Worked as a content writer for social welfare organization named “MAVURE.” 2017
Presented a paper on RED TACTON in 2
world conference on applied sciences. 2013