Data Analyst

Naveen Gottumukkala

469-***-****; **************@*****.***

Summary

More than 4 years’ experience in tackling business problems using conceptual knowledge in data warehousing and business intelligence techniques

Proficient in various data analysis & visualization tools including SAS EM, WEKA, R, Excel, Business Objects and Tableau

Certified SAS programmer and expert in T-SQL Programming, query optimization and performance tuning.

Experience and proficiency on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation layer).

Experience in Software Development Life Cycle Phases like Analysis, Design, Development, Documentation, Deployment and System Support.

EDUCATION

The University of Texas at Dallas Masters., (BI-Statistics) GPA 3.55 May2016

Amrita School of Engineering, Bangalore B.Tech, Computer Science & Engineering May2012

TECHNICAL SKILLS

Analysis Tools: SAS, MS Excel, Tableau, Google Analytics, SSAS, SSRS, SSIS, Cognos

Programming: C, C++, JAVA, SQL, PL/SQL, HTML, R, VBA, Perl, C #

Certifications: SAS Certificate in Business Intelligence and Data Mining, Google Adwords, Google Analytics, Tableau Desktop Qualified Associate

BUSINESS EXPERIENCE

CVS Health., USA, Data Analyst (VBA, SharePoint, SAS, Oracle, Web Services) Sep’16 - Jan’18

Executed ad-hoc reports on Oracle for management to help with process improvements and quality control.

Automated the ad-hoc reports using VBA macros for users to refresh data on an as-needed basis.

Extracted and integrated data from various sources such as oracle database, Salesforce and SharePoint using VBA and web services such as XML, REST API, and SOAP

Developed dashboards to track the KPI’s and quality of the representatives working the Salesforce cases.

Designed SharePoint sites to track project Status, Clinical Authorization System Communication errors and for users to submit report requests

Developed SAS macros to automate and email reports of communication errors in the daily Book of Business

Alcon Inc., USA, Data Analyst (Excel, VBA, SharePoint, Tableau) Jun’ 15 – May’ 16

Designed Enhancements of Alcon Commercial Execution (ACE reporting) application to support the representatives, regional heads for planning/forecasting and execution of marketing the products by ranking, positioning, category, brand, weighted & un-weighted.

Designed and developed Ad-hoc reports and Generated tableau dashboards with combination charts for clear understanding with different Data Visualization Techniques

Cognizant, BI Developer (SQL,Business Objects, Cognos, ETL, SSIS, Excel VBA) May ‘12– Jun’14

Developed customized dashboards for executives as well as ad hoc reports using multiple data sources such as SQL Server, Crystal Reports and SAP business objects

Automated numerous excel reports using Excel macros saving personnel hours and resources.

Developed a VBA application to generate PDF’s summarizing data from multiple excel reports based on user selection and exporting them to a SharePoint location.

Developed and deployed the SSIS ETL package to create a data foundation and migrate excel reports to Cognos.

Created metadata models, used data extracted from multiple DBs, and created joins and cardinality

Developed imports/ exports to deploy reports and implemented security/access management.

Used Execution Plan, SQL Profiler to optimize queries and enhance the performance of database.

Generated various List Reports, Grouped Reports, Cross tab Reports, Drill-Down and Drill-Through Reports.

Contact this candidate