Data Manager

Seeking challenging roles in Business Intelligence with emphasis on Big Data analytics and reporting using Microstrategy, Tableau and other BI tools

PROFESSIONAL SUMMARY

CERTIFIED MICROSTRATEGY ARCHITECT/DEVELOPER with 5 years of industry experience in design and development of reports and dashboards in Finance and Pharmaceutical Business areas

Pursuing Coursera specialization track on BIGDATA analytics and visualization

Used Excel, Teradata, MySQL, MicroStrategy, Tableau tools to analyze data, design visualizations, and transform business challenges into data questions

Extensively worked on MicroStrategy suite comprising intelligence server, architect, desktop, web, mobile and report services

Experience in developing schema objects like attributes,facts,tables,hierarchies and transformation.

Familiar with a broad range of data warehousing concepts like dimensional modeling, relational Database, star schemas, snowflake schemas, FACT and dimensional tables, logical and physical data modeling

Hands-on expertise in designing and integrating MicroStrategy reports, dashboards, scorecards and objects like filters, metrics and prompts

Proficient in catering BI solutions using Teradata, Oracle, db2, Netezza and MySQL

Possess good analytical and communication skills.

WORK EXPERIENCE

Cognizant Technology Solutions (Web Dashboard) APRIL 2014 - MAY 2015

Client:Astra Zeneca

Liaison with business analysts and managers to translate business needs into business and functional requirements

Define and create MicroStrategy objects like attributes, metrics, filters, nested filters, hierarchies and relationship, templates and prompts

Create ad-hoc reports using drill-up/drill-down methods across hierarchies

Translate data records from business units to multi-layered dynamic enterprise dashboards using flash widgets like micro charts, time series slider, gauge and grids/graphs using multiple datasets

Construct advanced dynamic dashboards using panel stacks, panels, selectors in flash mode

Perform conditional formatting on metric thresholds and restrict data access using security filters

Use VLDB properties for performance tuning and SQL optimization

Use intelligent cube datasets to improve performance of dashboards

Undertake and guide MicroStrategy object transfers across development, test, stage and production environments using MicroStrategy object

Cognizant Technology Solutions (Mobile Dashboard) APRIL 2013 - MAY 2014

Client: Astrazeneca

Design dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents

Employ various schema-modeling techniques to create compound attributes,

heterogeneous mapping and role attributes

Construct expression-based and table-based transformations

Create base formulas using facts that can be re-used to build any number of metrics

Configure mobile server for reports and visual insights analysis delivery for iPads and iPhones

Build and share In memory cubes to reduce the database load

Implementation of OLAP functionality (banding, dynamic aggregation, subtotal, derived element creation) using MicroStrategy

Use free form SQL editor to generate MicroStrategy static reports

Assume ownership in system testing and user acceptance Testing

Technology: MicroStrategy Suite 9.0.2, Netezza database

Syntel SEPT 2010 - APRIL 2013

Client: American Express

Monitor MicroStrategy applications and servers’ performance to ensure 24/7

availability

Address customer issues, perform root cause analysis, provide resolution and

recommendations for the customers

Experience in monitoring and trouble shooting, tuning Intelligence Server, Web Server and Narrowcast Server

Assume ownership on administrative tasks including tuning, caching, specifying query governing thresholds, and report optimization

Utilize enterprise manager to monitor server usage and user activity

Migrate objects between development and testing using object manager

Manage configuration and version control of production systems and inspect fault correction

Create new users, roles, privileges, shared folders and access controls lists

Administer I-servers and coordinate with MicroStrategy vendors for product related

defects and system upgrade

Technology: MicroStrategy Suite 9.0.2, SQL Server, DB2 V9.7 Regatta Database

COURSERA (DUKE University )

Managing Big Data with MySQL FEB 2016 – PRESENT

Use relational databases and ER diagrams to infer the data and transform them into meaningful business opportunities using MySQL, Teradata

Translate data analysis questions into SQL queries that accommodate the types of anomalies found in real data sets

Write queries and sort data from real MySQL and Teradata business databases that contain over 1 million records

Data Visualization using Tableau MAR 2016 – PRESENT

Combine data sources by joining multiple tables and using data blending

Design business dashboards with Tableau

Use line graphs and scatter plots to represent data

Create basic calculations including string manipulation, basic arithmetic calculation, custom aggregation, logic statement and quick table calculation.

Use Parameter, aggregate functions and filters.

Add dynamic, interactive hierarchies using Tableau

Technology: MySQL, Teradata, Jupyter Teradata Viewpoint, Tableau 9.0, Excel

TECHNICAL SKILLS

Domain Expertise: Banking and financial Services, EIM life science

Tools: Reporting tools: MicroStrategy, Webfocus, Tableau

Concepts: Business intelligence, Data warehouse

Database: Teradata, MySQL, DB2, SQL Server, Oracle, Netezza

EDUCATION

SASTRA University, India,(EEE) GPA (7.9) AUG 2005- MAY 2009

AWARDS AND HONOURS

Syntel best performance award for contributions to DC 2014 migration efforts

Syntel best performance award for stretching to excel in the team, 2013

Contact this candidate