Harika Meda

**** **** ***** **, *******, ***** CA (USA)

ac5ono@r.postjobfree.com

+1-408-***-****

SUMMARY

Over 3+ years of professional experience in Information Technology with a wide-spectrum of experience in BI, Design, Development and administration and technical/architectural oversight

Expert in Merchandise Finance Planning and Tableau BI product suite: Report Manager, OLAP Manager, Task Manager, Integration Manager, System Manager for versions 4.0 and 5.0

Extensively worked on creating and integrating complex BI reports, Intelligent cubes, Data visualization, Dashboards, Freeform SQL reports, DataMart reports and objects (Attributes, filters, Metrics, Facts, Mappings, Consolidations and Custom Groups)

Experience in creating Transformations and Mappings using ETLs to move data from multiple sources to Targets

Ownership of planning, gathering business and technical requirements, testing and post production support

Administered and supported BI planning production and development environments hosting more than 6 projects at a time

Expert in Databases, writing complex SQL queries, Excel and Documentation

Excellent communication, problem solving skills and a good team player

Adept in all phases and ability to grasp new concepts and tools quickly

Highly motivated, committed, customer-oriented and passionate about data analytics and visualization

WORK EXPERIENCE

Role: Business Intelligence Analyst Manager March 2016 – March 2017

Company: Zalando SE (e-commerce firm) - Berlin, Germany

Worked in Tableau environment to create and publish dashboards like weekly, monthly and daily reports with the business users

Experience in Tableau administration tool and suite

Skilled in Tableau for data visualization, Reporting and Analysis; Geographic Map, Pie Charts and Bar Charts, Scatter Plots, Page Trails and Density chart

Expert in creating calculations and server commands like synchronization and Tab cmd

Worked extensively with Advance analysis Actions, Parameters, Background images, Trend Lines, Statistics and Table Calculations

Provided production support to Tableau users and wrote complex SQL queries to support business requirements

Wrote UNIX shell scripts for file validations and scheduling jobs and for pre processing and post processing the files

Troubleshoot issues with failed ETL processes

Involved in SDLC of reporting projects, includes Requirements Gathering, Design, Development, Testing and Production rollover

Ensured highest data quality and constant accessibility of the BI planning servers and services

Direct contact with top management and supported them in the financial planning of future strategic projects by analyzing company-wide budgeting and planning processes

Role: Business Intelligence In-house consultant April 2015 – March 2016

Company: Zalando SE – Berlin, Germany

Created and published complex reports using JEDOX report studio, SAP BO and EXCEL services

Designed databases and OLAP cubes to store the data and created relationship between the tables

Implementation of DWH data into the planning tool and also data processes to supply the data

Worked extensively with data migration, dimensional modeling, data cleansing and implemented ETL process for current and historical data

Provided recommendations on ETL design by analyzing complex ETL concepts

Experience in designing techniques like Data normalization, Snowflake schemas, Star schema, Fact and Dimension tables

Worked with product managers and engineering teams to ensure the right data used to build KPIs

Generated ad-hoc reports and implemented KPI logic from season to season

Administrator for all Merchandise Finance Planning tool related activities and first point of contact for the BI Engineering team and stakeholders

Role: Business Intelligence Consultant March 2014 – Feb 2015

Company: Etica IT Consultants – Mannheim, Germany

Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation

Implemented Pentaho Data Integration/KETTLE and JEDOX to design all ETL processes to extract data from various sources including live system and external files, cleanse and then load the data into target data warehouse

Created reports and dashboards with Key Performance Indicators (KPI’s) using Jedox and Excel services which includes VBA and Macros, pivot tables, combo boxes, conditional formatting and Advanced formulas

Assisted business teams in defining, tracking and optimizing the reports for better planning and management of the business

Provided technical support for the end-users after every Go-Live phase

Worked independently and delivered best and quality results

Related Experience

Role: Intern June 2010 – Dec 2010

Company: VarnarSoftTech – Hyderabad, India

Built an excel based report and documented it for the hospital management system to track the OPD patients, records and their billings

Pulled the data from Cockpits and created Pivot tables using VLOOKUP and other Excel functions in MS EXCEL

EDUCATION

Masters in Business Informatics, Mannheim University (Germany) April 2012 – Feb 2014

Bachelors in Computer Science, ICFAI University (India) Aug 2007 – May 2011

LANGUAGES

English, Telugu, Hindi, German

TECHNICAL SKILLS

Business Intelligence Tool

Tableau, Jedox, SAP BO, Kettle, Excel

ETL Tool

Pentaho Data Integration/Kettle, Jedox

Languages

SQL, Python, Unix Scripting, Groovy

RDBMS

EXASOL

Methodologies

SDLC, Agile - Scrum, Waterfall

Management Tools

JIRA, New-Relic, Sales force, Asana

Platforms

Windows, Mac, Linux

PERSONAL

Served as Vice President for leadership committee through out my academic career for organizing industry seminars, cultural and sport events

Stood second among 20 competing teams for the technical project presentation at the Deutsche Bank, Frankfurt in Germany

Certified by JEDOX professionals

VISA STATUS

EAD (no sponsorship required)

Contact this candidate