Data Information Technology

Spandana Ganta

Email- ********.******@*****.*** PH No. 813-***-**** LinkedIn: https://www.linkedin.com/in/spandana-g-data-analysts

SUMMARY:

Experienced Data Analyst with a demonstrated history of working in the Information Technology and Services industry. Skilled in quantitative analysis and visualization, SQL Server Management Systems, Advanced Microsoft Office Suite, Data Visualization, Data Warehouse, Data Mining and Data Analysis. Strong information technology professional with a Master’s Degree focused in Engineering. Passionate about Data analytics, Number crunching and Product development.

SOFTWARE SKILLSET: Microsoft Office Suite (Word, Excel, Access, PowerPoint, Outlook, VLOOKUP, Macros, Pivot Tables), Relational databases, MapReduce, Hive, Hadoop, SQL, HTML, CSS, JavaScript, Salesforce, SPSS, SAS, SSIS, SSRS, SSAS, Tableau, Stata, R, Pandas, Python, VB Scripting, Linux/Unix.

CERTIFICATIONS: Certified Scrum Master (Scrum Alliance), ITIL Certified.

WORK EXPERIENCE:

QualComm San Diego, CA

Data Analyst Feb 2017 – Jul 2017

Collaborate with clients to extract and transform the confidential integration projects data for firm’s analytical engines utilization.

Automated the generation of data quality and trending reports using tableau, cutting down total analysis time by 75%.

Act as liaison between client, product and technical teams to ensure data precision and granularity.

Conduct data analysis to research root causes for data gaps, discrepancies and derive insights using longitudinal analysis.

Restructured data onboarding process making it dynamic and scalable decreasing overhead for the firm’s product integration with new clients.

Excellently used Salesforce for Nonprofits proficiency using Salesforce data uploads, Report creation, etc.

Used the Apache Hive data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL.

Nat Soft Corporation Somerset, NJ

Data Analyst Aug 2016 – Jan 2016

Performed data exploration and validation to separate genuine phenomena from artificial anomalies using SQL.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop and expert in analytical and quantitative problem solving.

Expert in Design, build and automate dashboards and custom reports.

Created SSIS packages to load data into Data Warehouse using tasks like Execute SQL Task, data flow task and expert in designing of ETL (Extract, Transform, and Load) flows.

Comfortably worked in a Unix Environment and very familiar with Relational databases and spreadsheets in building and disseminating.

Data Analyst Intern Jan 2016 – Mar 2016

Developed and Tested web pages and also used visualization for Graphs, Charts, etc.

Proficiently worked with SQL scripts, MapReduce, query optimization and operated with data schemas to manipulate data for data loads and extracts.

Effectively identified errors and issues involving data flow discrepancies, followed up with recommendations to improve daily operations.

Responsible for developing and publishing dashboard reports on the Tableau Server.

Infosys Limited Hyderabad, India Technology Specialist May 2014 – Apr 2015

Created a database of the most frequently faced issues and launched a step-by-step troubleshooting webpage, reducing problem tickets generated by 40%.

Proficiently worked with MS Office, including Excel (V-Lookup, Pivot Tables, Macros), PowerPoint, Salesforce to help the faculty and staff with updating the files and documenting various information logs of the department and also to automate, manipulate data and also Extracted, cleaned, and sampled company’s data with over a million records to perform quantitative analysis using Access, Excel.

Developed and managed web content such as images, links, structure, design and functionality for the department.

Phore Technologies Hyderabad, India Business Analyst Intern Feb 2014 – Apr 2014

Assisted the Head of Finance in designing and implementing an internal reporting system to consolidate the company’s accounting management, financial, financial reporting and accounting systems from multiple project sites.

Created executive dashboards to inform decisions around revenue projections.

Identified potential cost savings by analyzing the monthly expense reports and streamlining the reporting process.

EDUCATION

Master of Science - Electrical Engineering, California, USA. GPA - 3.99 Aug 2016

Relevant Coursework: Project Management, Systems Engineering, Wireless Communication, Operations Management, Software Quality Assurance and Testing, Software Development Process Management, UNIX/Linux Network Programming, Network Analysis, Appl. Specific Integrated Circuit Design, Design Verification with System Verilog.

Bachelor of Engineering - Electronics and Communication Engineering, Hyderabad, India. GPA – 4.00 May 2014

Contact this candidate