MicroStrategy Developer Resume

SUMMARY

2 years of IT experience with MicroStrategy product suite namely MicroStrategy desktop, MicroStrategy intelligence server, MicroStrategy web, MicroStrategy dashboards.
Knowledge on creating intelligent cubes, visual Insights, schema and application objects etc.
Knowledge in data warehousing concepts and star - schema architecture.
Knowledge of dimensional data modeling, star schema, snow-flake schema, fact and dimension tables.
Defining drill hierarchies and creating relationship between attributes.
Experience in developing application objects (filters, prompts, metrics, custom groups, consolidations, drill maps, templates, and searches) developed reports, documents and dashboards.
Experience with revamping existing dashboards to mobile and creating new mobile dashboards.
Knowledge in using pass-through expressions like apply simple and apply comparison to develop complex filters and transformations.
Knowledge on ETL concepts.
Experience in MicroStrategyconnectivity with various databases such as oracle, Teradata, MS Access, and SQL server.
Excellent interpersonal communication, documentation skills and experience coordinating with project managers, business analysts, architects, DBAs anddevelopers.
Pro-active involvement in continuous performance improvement of existing systems.
Strong experience with full software development life cycle (SDLC) which includes requirement analysis, design, development, implementation, testing, deployment, production support and maintenance build and release management.
Self-motivated, dedicated and team player with excellent communication skills and curiosity to learn new technologies and can work with minimal supervision. At ease in interacting with people at all levels, able to work under pressure.

TECHNICAL SKILLS

Database: Oracle, Teradata, SQL Server, T-SQL, MS Access

Programming Languages: SQL, HTML, T-SQL

BI/Reporting tools: MicroStrategy (8.x,9.x), MS Excel

Operating Systems: Windows and UNIX, Linux Red Hat

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Developer

Responsibilities:

Performed requirements analysis to collect various business measures and attributes to develop a reliable start schema and required facts and attributes.
Created attributes, consolidations and derived metrics on the reports from intelligent cubes.
Developed customized and ad-hoc reports using templates, metrics and filters for business analysis usingMicroStrategyagent with features of drilling options drill up, drill down and drill anywhere .
Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
Used pass-through functions (apply simple and apply comp) in attributes and filters definitions
Created Dynamic sourcing reports using intelligent cubes to boost the Performance.
Developed prompts to give end users a choice of different filtering criteria each time they run the report.
Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements.
ConfiguredMicroStrategymobile and modified existing dashboards to work on iPad and iPhones.
Documented entire work accomplished for future reference and maintenance purposes.
Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
Build and thoroughly test reporting changes and enhancements, understand data validation requirements as appropriate.
Write and execute queries usingSQLto identify data of interest to drive Testing scenarios.
Work closely with DBA and ETLdevelopersto in corporate additional business data to data warehouse for BI reporting and make changes to the views in the database to correct the reports. Troubleshoot and resolved high-priority and critical defect issues in production and put reports back to production within the deadline.
Communicates effectively with technical and non-technical audiences, both written and verbally. Able to present and discuss information at the appropriate level of detail and drive towards a consensus of opinion.

Environment: MicroStrategy 9.4.1 Administrator, Desktop, Architect, Web, Intelligence Server, Teradata, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboards.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship