Manager Data
Resume:
Harika Meda
**** **** ***** **, *******, ***** CA (USA)
*************@*****.***
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