Data Analyst Intern Resume
3.00/5 (Submit Your Rating)
TECHNICAL SKILLS
Programming: SQL, PL - SQL, SAS, Java, HTML
Databases: Oracle, Microsoft SQL Server, MySQL, MS Access
Tools: QlikSense, SAS Enterprise Miner, Tableau, QlikView, Proficient MS Excel (Pivot, VLookup, Macros, VBA), MS Word, Google AdWords, SAP Business Objects, SAP ERP, Rational Rose, CA Erwin, IBM InfoSphere Datastage
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst Intern
Responsibilities:
- Analyzed financial management needs of senior leadership, including CEO, identified gaps in existing data systems and conducted industry evaluation to recommend data analytics solution across organisation for 24X7 decision-making
- Designed new data model, executed ETL of ~1B records and collaborated with IT manager to deliver seamless integration of Hyperion Financial Management system with ‘Qlik Sense’, saving company
- Strategic conversion of complex data into inclusive QlikSense dashboards for quick data discovery and insights, digitally transforming traditional reporting into self-service BI with several dashboards encompassing 15+ key performing indicators
- Contributed in creating work plan, use cases and business requirement documents to define project goals and ensure traceability
Confidential
Software Engineer
Responsibilities:
- Collaborated with internal/external vendors and partners to manage data logistics for digital marketing firm which contributed to 40% of campaign data associated with end client, leading multinational bank
- Worked with consultants to create ETL solutions of 500M+ records, for multichannel database using ‘InfoSphere Datastage’, ensuring 10% processing cost reduction for client
- Liaised with client and developers to automate frequently performed tasks, reducing daily user work time by ~12.5%
- Assisted in compiling multiple functional documents that were referred by client-side power-users and end users