Intern Resume
4.00/5 (Submit Your Rating)
Indianapolis, IN
SUMMARY
- Data analyst, sharp - witted and energetic wif experience at turning data into information (ETL, reporting and visualization).
- Worked wif multiple clients and data sources, designed mappings, built expressions for data transformation, eliminated loading errors, created queries and reports, performed QA and platforms testing.
- Continuous learner of new technologies at data analysis and participant of IT professional groups and events (SQL Saturday conferences, Indy BI Pass group, Power BI group).
- Created mappings for loading product feed tables using Informatica PowerCenter 9.0 to teh target table at MS SQL Server 2012 for 35 clients;
- Created advanced expressions, filters, lookups and aggregate transformations to populate teh destination table;
- Provided troubleshooting and corrected loading errors;
- Performed data validation using SQL Server Management Studio (SSMS) 2012 and reported about teh loaded data by creating advanced queries;
- Assisted wif platform performance testing; worked wif 6 clients and ran 80 tests for each of them; among these tests I created 40 tests on my own for each client;
- Documented teh results and reported them to other team members using Jira, Confluence and Google Drive shared Excel documents;
- Participated at weekly team meetings and cooperated wif other departments;
TECHNICAL SKILLS
Data visualization: Data management
Programming: Project management
Independent developer: SQL, MS Excel, MS Access, Visual Basic projects; MS SQL Server 2012 projects (T - SQL, SSRS, SSIS, SSAS); Data transformation and visualization using SAS Enterprise Guide
PROFESSIONAL EXPERIENCE
Intern
Confidential, Indianapolis, IN
Responsibilities:
- Assisted in research, prepared documentation and made presentations using MS PowerPoint;
- Data analysis, validation and visualization using MS Excel (creating pivot tables, charts, diagrams);