Data Analyst Sales

Sakthi Saranya Siva Kozhundhu

720-***-**** (F) ******.*************@********.*** 3257, S Parker road, Denver, CO 80014

OBJECTIVE

Seeking Internship opportunities in an organization wherein I can utilize the concepts learnt and skills that would contribute to the growth of the organization and would help me to master the cutting-edge technologies.

EDUCATION

University of Colorado, Denver May 2019

Master of Science Information Systems – Business intelligence GPA: 3.9/4.0 Courses: Database Management systems, Data warehousing, Business Intelligence and Analytics, IT Project Management, Business Intelligence and Financial Modelling

Anna University, Chennai, India June 2015

Bachelor of Engineering Electronics and Communication Engineering GPA: 8.9/10 Courses: Object Oriented Programming and Data structures, Computer Networks, Computer Architecture and Organization, Operating systems, Wireless Networks, High Speed Networks, Digital Communication, Digital signal Processing, Control Systems.

TECHNICAL EXPERTISE

Languages/Frameworks : R, IBM DB2, Oracle SQL Developer, C, C++, JAVA, COBOL, JCL

Operating systems : Windows, Mac OS, Mainframe Z/OS

Databases : Microsoft Access, Microsoft Excel, Oracle 12c, MYSQL, IBM DB2, IMS DB, Sybase

Tools Used : Pentaho and Informatica ETL, Sybase Power Builder, SOAPUI, Tableau, SAS, Micro strategy, Project Libre, MS Access, MS Office, Microsoft Visio

BI Tools : Tableau, SAS, Microstrategy

PROFESSIONAL EXPERIENCE

System Engineer – Production Support Data Analyst/Tester Jun 2015 - Jun 2017

Have 2 years of experience in IT, As Data Analyst working with PL/SQL, Oracle Scripts and IBM DB2 Database Support and Error handling in Mainframe, Informatica ETL, Oracle SQL DB and Sybase DB interfaced applications

Had been a COBOL, JCL, IBM DB2 Production Support Data Analyst in Gen Re (Berkshire Hathaway group) and handled projects for primary insurance, Reinsurance, and Aviation insurance

Had provided support for Maintenance/Debugging of IBM DB2 Database and CICS Production environment, Resolved live business Transaction errors for the same

Had been a Special point-of-contact for the daily Service Level Agreement tracker in the project and responsible for internal documentation quality process and audit documentation using MS Office

Had been in Manual System Integration, Automation and Testing Team for Vodafone UK Telecom usage/non-usage services and worked with tools like HP ALM, Humming bird macro generator, REXX and SOAPUI

ACADEMIC PROJECTS

Database Framework for a local School – University of Colorado Denver Fall 2017

Designed and developed a back-end framework for a Local School in India using MS-Access as back end and forms, Reports as front end. Created a Database Model and Normalized it for data integrity and redundancy

Tools/Technologies used: MS Access, MS Excel, ERD plus, Oracle SQL, Microsoft Visio

Analysis of Key Performance Indicators using Microstrategy BI – University of Colorado Denver Fall 2017 Modified inputs with Wrangling scripts and Developed a dashboard to monitor the key performance indicators (Monthly Sales Target, Number of Orders, Health Inspection Scores) of three restaurants in a popular food chain in New York to identify the variance in performance using Microstrategy

Report design and use of Data Visualization techniques – University of Colorado, Denver

Designed a Business report with dashboards using SAS to benefit the Business team to understand the given data better and get few insights which will help them to provide solutions for the existing problems in the organization.

Datawarehouse creation, aggregation and ETL operations like data cleansing – University of Colorado, Denver Spring 2018 Designed an inventory database for a Retail Store, Integrating Data from multiple Database platforms like MS Access, MS Excel and Oracle DB using Pentaho Data integration. And performed data cleaning and ETL operations on the stream data before integration. Created Revenue and Sales Analysis reports for various regions using Subtotal operators in Oracle SQL

Tools/Technologies used: MS Access, MS Excel, Microsoft Visio, Oracle SQL, Pentaho

Creation of Financial Data Models using MS Excel and Microstrategy – University of Colorado, Denver Spring 2018

Developed Financial Models for Strategic decision making on the purchase of new switches or upgradation of existing switches for Telecommunication Market expansion expected by Century Link. Used Forecast functions, Variance Analysis, IRR calculations and NPV analysis. And reported the expected results in MicroStrategy

Tools/Technologies used: MS Excel, Microstrategy

Contact this candidate