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