Swathi H*

Desired Job Title Business Analyst / Product Manager / Microstartegy / Talend / Product Owner
Desired Job Location Bengaluru+1
Last Update 1 year ago

Swathi H* swathi.******@*****.***

Mobile: +** **********

Summary

• 9+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone software application with major focus on Data Warehousing and Database Applications.

• 9 years of extensive experience as Microstrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using Microstrategy 8x, 9x and 10x, Narrowcast Server, Microstrategy Desktop,

Microstrategy Web, Office, Microstrategy Intelligence Server and Microstrategy Architect.

• Worked extensively on VLDB Properties for performance tuning.

• In‐depth knowledge of fundamental data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas. High proficiency in using Erwin for Dimensional Modeling (Star,

Snowflake schemas) and Entity‐Relationship Modeling.

• Installing and Configuring of Microstrategy suite including Microstrategy Desktop, Administrator, Intelligence

Server, Web

• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in‐group as well as independently.

• Strong experience in Talend Open studio

• Extensive knowledge of SQL, PL/SQL and worked on very large databases in PostgreSQL, Greenplum, Oracle

10g/9i/8i, and SQL Server 2008/2012, Teradata

• Expertise with the tools in Hadoop Ecosystem including Hive, Spark and Kafka

• Proficiency in Agile methodologies

• Served as a Business Analyst/Product Owner/Technical Manager – playing a “techno functional” role

Objective:

Looking for refreshing, open and rewarding work environment, where I can challenge myself constantly, discover my potential and enrich the growth. Looking for a career that provides the opportunity to contribute, build my skills tH*ough experience and utilize my experience, knowledge and education to best of the benefit of the company. I am a young, energetic and ambitious professional, with a desire to excel, who like to think "out of the box" and who are driven to overcome challenges.

Experience

Senior Data Engineer

Maersk Digital Centre

April 2018 ‐ Present (9 months)

• Gathered requirements from the on-site users by traveling overseas to client locations

• Architect the Microstrategy Projects which involves in creating the Attributes, Facts and Hierarchies

• Expertise on Data warehousing solutions using Teradata.

• Involved in the development of transformation to load the data in slowly changing dimensions.

• Done performance tuning of the mappings.

• Worked with collect statistics, join indexes etc.

• Deployment of the projects between the environments

• Development of VI (Visual Insight) Dashboards using MSTR version 9.5, 10.11

• Development of Dynamic Dashboards and Reports/Freeform SQL reports

• Expertise with the tools in Hadoop Ecosystem including Hive, Spark and Kafka

• Excellent knowledge on Hadoop Ecosystems such as HDFS, Name Node, Data Node and Map Reduce programming paradigm

Senior Software Engineer

Société Générale Global Solution Centre

April 2015 ‐ April 2018 (3 years 1 month)

• Interacting with stakeholders located at different locations, conduct user meetings, gathering the requirements and assigning, delegating and monitoring of sprint activities via JIRA. Work with cross-functional data and build data solutions.

• Served as a Business Analyst/Product Owner/Technical Manager – playing a “techno functional” role by being responsible of

➢ Creating a vision for developments

➢ Managing the product backlog & Prioritizing

➢ Management of implementation of new business and project initiatives - Change Management

➢ Evaluating at each stage of the development on the progress

➢ Breaking down high-level features into multiple user-stories, to enforce iterative product development

➢ Release planning

➢ Resolving cross-project interdependencies challenges

➢ Data modeling

➢ Gathering requirements

➢ Providing technical solutions

➢ Assessing technical feasibility

• Responsible of aligning organizational goals and business line goals with the backlog/tasks prioritization by designing the apt Road map.

• Successfully widened the scope of the team by fetching new projects by means of assertive negotiations.

• Driven various automation projects, upgrades and ownership transformation.

• Gathered requirements from the on-site users by traveling overseas to client locations.

• Delivered projects on Microstrategy 10x. Developed Visual Insight dashboards.

• Architecting the Microstrategy Projects which involved in creating the Attributes, Facts and Hierarchies.

• Also, managing a team of ten by delegating and coordinating tasks in Sprint while ensuring the best practices and process are followed. Accountable for all the escalations and SLA breaches on the release.

• Created projects pointing to associated database connection instance and built a semantic layer data model in

MicroStrategy which was consumed for complex dashboards and reports.

• Performance tuning with help of database tables/view design and MSTR VLDB properties.

• Deployment of the projects between the environments. Responsible for End to End Microstrategy Solution.

Senior Microstrategy Developer

Informatica Corp

October 2014 ‐ December 2014 (3 months)

• Worked on Remodeling the Sales project (Sales Analytics).

• Worked jointly with Business Analysts and ETL team for feasibility study and maintenance plan.

• Creation of schema objects – attributes, facts, hierarchies, transformations.

• Creation of application objects – filters. Prompts, metrics, reports with nested prompts, dashboards.

• Performance tuning with help of database tables/view design and MSTR VLDB properties.

• Deployment of the projects between the environments

• Training internal team members in MSTR.

Assistant Manager

GENPACT

January 2015 - March 2015 (3 months)

• Led a team of 4 developers to design and build project to answer financial, clinical and utilization

Requirements.

• Managed development cycle in on shore off shore model. • Conducted MSTR and Talend training's for both technical and business users.

• Responsible for gathering and refining business requirements from the Business users.

• Architecting the Microstrategy Projects which involved in creating the Attributes, Facts and Hierarchies

• Responsible for creating Metrics, Filters, Custom Groups, Prompts using Microstrategy Desktop

• Generated status reports after performing thorougH *esearch to discuss the issues related to

Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.

• Collected business requirements from users by understanding the Source System (OLTP) and interacting with the users

• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.

Senior Engineer

Symphony Teleca

December 2012 ‐ October 2014 (1 years 11 months)

• Worked for the US based Healthcare Company, Source

• Health Care Analytics (SHA) for Projects such as PHAST Intelligent Insight (PII), SOI PH2 Remodel SLx, PHAST

Global Audit Suite, etc.

• Created Transactional Service Reports and Dashboard to provide write back services to the end users

• Developed several dashboards to be delivered to an iPad for the business user

• Create Microstrategy reports with multi‐montH *etrospective deliverable

• Create User Friendly Dashboards across the Categories

• Analyze schema and client requirements and design data model for performance optimization of the deliverable.

• Work with schema objects, application objects, as well as re‐usable objects like prompts, filters etc., Security filters, VLDB properties, hierarchy prompts and level metrics.

• Performance Tuning and troubleshooting the defects

• Deployment of the project between the environments

Software Engineer

Stixis Technologies Pvt Ltd

Feb 2010 ‐ December 2012 (3 years)

• Create Microstrategy reports and dashboards using Slice and user‐defined aggregate functions, to implement complicated business requirements

• Create and Optimize ETL for large scale data warehouse by indexing

• Worked on Schema, Application and Configuration objects

• Working with Product/Technical Managers to translate requirements and use cases into technical solutions

• Working with Integration Architects to ensure seamless integration with other data tools

• Strong SQL experience (PL/SQL and/or PG/SQL)

• Ability to work with client, gather requirements technical and business Worked independently

• Created and defined attributes from fact tables in the appropriate fields under the Attribute definition section for each dimension

• Created Ad‐hoc reports by gathering specific requirements from the different users.

• Managed development cycle in on shore off shore model

Skills & Expertise

Tools & Technologies

✓ MicroStrategy: Microstrategy Web, Microstrategy Reporting, Microstrategy Object Manager,

Microstrategy Command Manager, Microstrategy Transaction services,

Microstrategy Mobile, Microstrategy Dashboard

✓ Talend ETL ✓ Power BI

Databases

✓ PgSQL ✓ PL/SQL ✓ Microsoft SQL Server ✓ Teradata

Concepts

✓ Business Intelligence ✓ Data Warehousing ✓ OLAP Services,

✓ SDLC ✓ Agile Methodologies ✓ Requirements Gathering

Honors and Awards

1st Runner up of Infocepts Global Microstrategy Contest 2016

Infocepts April 2016 Infocepts organized an annual Global Microstrategy Contest. The first round consisted of an online quiz on Microstrategy, where 26 participants were shortlisted. In the Next round, we had to take up a

Dashboard Development Challenge! Competing against the best of Microstrategy Professionals across India. It was to create a Visual Insights Dashboard to display various analytical views based on the data provided. Visual Insights dashboard should be built using MicroStrategy 10.x version. Attempt should be made to use all the different features offered by Visual Insights in the latest version of Microstrategy 10.x. We were expected to chalk out our own analytical use cases and business questions and then create an effective Dashboard for the same on

MicroStrategy platform

Education

Visvesvaraya Technological University

Bachelor of Engineering, Computer Science,

2004 ‐ 2008

Activities and Societies: Participated in the Entrepreneurship Awareness Camp, held by Entrepreneurship

Development Cell, VTU Belgaum

Ex‐Municipal Pre‐University College

Pre‐University Board, PCMB,

2002 ‐ 2004

St. Philomena's High School

1992 – 2002

Personal Information

Name: Swathi H.R

Date of Birth: 24/01/1987

Gender: Female

Marital Status: Married

Pan Number: AEXPH8064C

Current Location: Bangalore

Permanent Address: 781/10,1st floor, 9th main, 6th cross, Buvaneshwari nagar, BSK 3rd Stage ‐ 560085

Place: Bangalore Swathi H.R

The text is extracted from the uploaded resume. You can preview the original document in desktop view
Swathi H*
swathi.******@*****.***
Mobile: +** **********
Summary
9+ years of strong experience in Business Intelligence in designing and implementing Web based and Standalone
software application with major focus on Data Warehousing and Database Applications.
9 years of extensive experience as Microstrategy Developer, Architect & Administrator building projects and
creating reports and Dashboards using Microstrategy 8x, 9x and 10x, Narrowcast Server, Microstrategy Desktop,
Microstrategy Web, Office, Microstrategy Intelligence Server and Microstrategy Architect.
Worked extensively on VLDB Properties for performance tuning.
In‐depth knowledge of fundamental data warehousing concepts such as entity relational modeling, dimensional
modeling, star and snowflake schemas. High proficiency in using Erwin for Dimensional Modeling (Star,
Snowflake schemas) and Entity‐Relationship Modeling.
Installing and Configuring of Microstrategy suite including Microstrategy Desktop, Administrator, Intelligence
Server, Web
Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception
ability to quickly master new concepts and capable of working in‐group as well as independently.
Strong experience in Talend Open studio
Extensive knowledge of SQL, PL/SQL and worked on very large databases in PostgreSQL, Greenplum, Oracle
10g/9i/8i, and SQL Server 2008/2012, Teradata
Expertise with the tools in Hadoop Ecosystem including Hive, Spark and Kafka
Proficiency in Agile methodologies
Served as a Business Analyst/Product Owner/Technical Manager playing a “techno functional” role
Objective:
Looking for refreshing, open and rewarding work environment, where I can challenge myself constantly, discover
my potential and enrich the growth. Looking for a career that provides the opportunity to contribute, build my
skills tH*ough experience and utilize my experience, knowledge and education to best of the benefit of the
company. I am a young, energetic and ambitious professional, with a desire to excel, who like to think "out of the
box" and who are driven to overcome challenges.
Experience
Senior Data Engineer
Maersk Digital Centre
April 2018 ‐ Present (9 months)
Gathered requirements from the on-site users by traveling overseas to client locations
Architect the Microstrategy Projects which involves in creating the Attributes, Facts and Hierarchies
Expertise on Data warehousing solutions using Teradata.
Involved in the development of transformation to load the data in slowly changing dimensions.
Done performance tuning of the mappings.
Worked with collect statistics, join indexes etc.
Deployment of the projects between the environments
Development of VI (Visual Insight) Dashboards using MSTR version 9.5, 10.11
Development of Dynamic Dashboards and Reports/Freeform SQL reports
Expertise with the tools in Hadoop Ecosystem including Hive, Spark and Kafka
Excellent knowledge on Hadoop Ecosystems such as HDFS, Name Node, Data Node and Map Reduce
programming paradigm
Senior Software Engineer
Société Générale Global Solution Centre
April 2015 ‐ April 2018 (3 years 1 month)
Interacting with stakeholders located at different locations, conduct user meetings, gathering the requirements
and assigning, delegating and monitoring of sprint activities via JIRA. Work with cross-functional data and build
data solutions.
Served as a Business Analyst/Product Owner/Technical Manager playing a “techno functional” role by being
responsible of
Creating a vision for developments
Managing the product backlog & Prioritizing
Management of implementation of new business and project initiatives - Change Management
Evaluating at each stage of the development on the progress
Breaking down high-level features into multiple user-stories, to enforce iterative product development
Release planning
Resolving cross-project interdependencies challenges
Data modeling
Gathering requirements
Providing technical solutions
Assessing technical feasibility
Responsible of aligning organizational goals and business line goals with the backlog/tasks prioritization by
designing the apt Road map.
Successfully widened the scope of the team by fetching new projects by means of assertive negotiations.
Driven various automation projects, upgrades and ownership transformation.
Gathered requirements from the on-site users by traveling overseas to client locations.
Delivered projects on Microstrategy 10x. Developed Visual Insight dashboards.
Architecting the Microstrategy Projects which involved in creating the Attributes, Facts and Hierarchies.
Also, managing a team of ten by delegating and coordinating tasks in Sprint while ensuring the best practices
and process are followed. Accountable for all the escalations and SLA breaches on the release.
Created projects pointing to associated database connection instance and built a semantic layer data model in
MicroStrategy which was consumed for complex dashboards and reports.
Performance tuning with help of database tables/view design and MSTR VLDB properties.
Deployment of the projects between the environments. Responsible for End to End Microstrategy Solution.
Senior Microstrategy Developer
Informatica Corp
October 2014 ‐ December 2014 (3 months)
Worked on Remodeling the Sales project (Sales Analytics).
Worked jointly with Business Analysts and ETL team for feasibility study and maintenance plan.
Creation of schema objects attributes, facts, hierarchies, transformations.
Creation of application objects filters. Prompts, metrics, reports with nested prompts, dashboards.
Performance tuning with help of database tables/view design and MSTR VLDB properties.
Deployment of the projects between the environments
Training internal team members in MSTR.
Assistant Manager
GENPACT
January 2015 - March 2015 (3 months)
Led a team of 4 developers to design and build project to answer financial, clinical and utilization
Requirements.
Managed development cycle in on shore off shore model. • Conducted MSTR and Talend training's for both
technical and business users.
Responsible for gathering and refining business requirements from the Business users.
Architecting the Microstrategy Projects which involved in creating the Attributes, Facts and Hierarchies
Responsible for creating Metrics, Filters, Custom Groups, Prompts using Microstrategy Desktop
Generated status reports after performing thorougH *esearch to discuss the issues related to
Warehouse tables, Zeroes/Nulls, missing columns and naming conventions etc.
Collected business requirements from users by understanding the Source System (OLTP) and interacting with the
users
Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for
finding the Gap analysis.
Senior Engineer
Symphony Teleca
December 2012 ‐ October 2014 (1 years 11 months)
Worked for the US based Healthcare Company, Source
Health Care Analytics (SHA) for Projects such as PHAST Intelligent Insight (PII), SOI PH2 Remodel SLx, PHAST
Global Audit Suite, etc.
Created Transactional Service Reports and Dashboard to provide write back services to the end users
Developed several dashboards to be delivered to an iPad for the business user
Create Microstrategy reports with multi‐montH *etrospective deliverable
Create User Friendly Dashboards across the Categories
Analyze schema and client requirements and design data model for performance optimization of the deliverable.
Work with schema objects, application objects, as well as re‐usable objects like prompts, filters etc., Security
filters, VLDB properties, hierarchy prompts and level metrics.
Performance Tuning and troubleshooting the defects
Deployment of the project between the environments
Software Engineer
Stixis Technologies Pvt Ltd
Feb 2010 ‐ December 2012 (3 years)
Create Microstrategy reports and dashboards using Slice and user‐defined aggregate functions, to implement
complicated business requirements
Create and Optimize ETL for large scale data warehouse by indexing
Worked on Schema, Application and Configuration objects
Working with Product/Technical Managers to translate requirements and use cases into technical solutions
Working with Integration Architects to ensure seamless integration with other data tools
Strong SQL experience (PL/SQL and/or PG/SQL)
Ability to work with client, gather requirements technical and business Worked independently
Created and defined attributes from fact tables in the appropriate fields under the Attribute definition section
for each dimension
Created Ad‐hoc reports by gathering specific requirements from the different users.
Managed development cycle in on shore off shore model
Skills & Expertise
Tools & Technologies
MicroStrategy: Microstrategy Web, Microstrategy Reporting, Microstrategy Object Manager,
Microstrategy Command Manager, Microstrategy Transaction services,
Microstrategy Mobile, Microstrategy Dashboard
Talend ETL Power BI
Databases
PgSQL PL/SQL Microsoft SQL Server Teradata
Concepts
Business Intelligence Data Warehousing OLAP Services,
SDLC Agile Methodologies Requirements Gathering
Honors and Awards
1st Runner up of Infocepts Global Microstrategy Contest 2016
Infocepts April 2016 Infocepts organized an annual Global Microstrategy Contest. The first round consisted of an
online quiz on Microstrategy, where 26 participants were shortlisted. In the Next round, we had to take up a
Dashboard Development Challenge! Competing against the best of Microstrategy Professionals across India. It was
to create a Visual Insights Dashboard to display various analytical views based on the data provided. Visual Insights
dashboard should be built using MicroStrategy 10.x version. Attempt should be made to use all the different
features offered by Visual Insights in the latest version of Microstrategy 10.x. We were expected to chalk out our
own analytical use cases and business questions and then create an effective Dashboard for the same on
MicroStrategy platform
Education
Visvesvaraya Technological University
Bachelor of Engineering, Computer Science,
2004 ‐ 2008
Activities and Societies: Participated in the Entrepreneurship Awareness Camp, held by Entrepreneurship
Development Cell, VTU Belgaum
Ex‐Municipal Pre‐University College
Pre‐University Board, PCMB,
2002 ‐ 2004
St. Philomena's High School
1992 2002
Personal Information
Name: Swathi H.R
Date of Birth: 24/01/1987
Gender: Female
Marital Status: Married
Pan Number: AEXPH8064C
Current Location: Bangalore
Permanent Address: 781/10,1st floor, 9th main, 6th cross, Buvaneshwari nagar, BSK 3rd Stage ‐ 560085
Place: Bangalore Swathi H.R

Resume Details

Desired Job: Business Analyst, Product Manager, Microstartegy, Talend, Product Owner
Experience: 9 years
Job Type: Full-Time, Permanent
Availability to Start: Negotiable
Desired Job Location: Woking, UK  •  Bengaluru, Karnataka
Work Authorization: I am authorized to work
Relocation: I'm willing to relocate
Driver License: Yes
Last Updated: 1 year ago
Resume ID: #485485

Contact Information

Name: Swathi H*
Gender: Woman
Nationality: Indian
Age: 31
Phone Number: **********
Email: *********@gmail.com
Current Location: Bengaluru
Contact Details Price: USD 5.00
To view the contact details for this resume a payment is required.