Junior Data Analyst Resume Example

Roles and Responsibilities:           

• Responsible for gathering requirements from Business Analysts andOperational Analysts and identifying the data sources required for the requests.         Designed and developed various SQL scripts as part of automation of manual monthly reporting to third party consumer. ·    
• Worked on data profiling, data analysis and validating the reports sent to third party.     
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.  
• Extracted, Analyzed and Presented Data in a Graphical Format using Microsoft Excel, such a way that helped project manager to make Business Decisions
• Proficient in importing/exporting large amounts of data from Excel files to Teradata and vice versa.
• Used VBA Macro to create Weekly reports.    
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.  
•  Experienced in using OLAP functions like sum, count, csum and etc. ·         Proficient in working on Set, Multiset, Derived, Volatile Temporary tables. ·        
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.    
• Experience in Power Point Presentation (Financial Data, Charts).  
• Expertise in generating graphs using MS Excel Pivot tables. Extracted data from existing data source, Developing and executing departmental reports for  performance and response purposes by using  SQL, MS Excel.    
• Environment: Teradata V2R6, VBA, Putty, Tableau, Teradata SQL Assistant ,SQL,Windows XP,