We provide IT Staff Augmentation Services!

Sr. Microstrategy Architect/developer Resume

Phoenix, AZ

SUMMARY:

  • Over 7 years of experience, with four full development life cycle process, including business requirement gathering, design, development, testing, and implementation of Data Warehousing /Business Intelligence and data visualization tools with Specialization on Microstrategy and Tableau
  • Over 6 years of experience using SQL with a relational database and in depth experience with client server applications and architectures and Microstrategy tool Suite (Intelligence Server, Architect, Desktop, Web, Administration, Narrowcast Server).
  • 3+ years of experience working with Tableau Desktop and Server.
  • Solid understanding and implementation of Data Modeling (including recursive, ragged hierarchies and slow changing dimensions) Data warehouse, Data mining and reporting techniques.
  • Responsible for architecting, developing and implementing a scalable MicroStrategy Self - Service Platform.
  • Designing, Developing, maintaining and integrating complex microstrategy reports, intelligent cubes, dashboards, scorecards, freeform sql reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) using microstrategy and also development of microstrategy applications for Iphone & Ipad.
  • System Optimization, performance monitoring, configuring and tuning experience in Microstrategy Business Intelligence tool suite (Intelligence server, Web).
  • End to end experience in designing and deploying data visualizations using Tableau.
  • Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and making use of actions, other local and global filters according to the end user requirement.
  • Setting up of user accounts and privileges, migration of objects between environments, and performance monitoring.
  • Experience with revamping existing dashboards to Mobile and creating new Mobile dashboards
  • Providing support to the business regarding business analytics, use of microstrategy tool, identification and resolution of data discrepancies.
  • Strong expertise in using various features of tableau - data blending, Row Level Security, Data Extracts, Scheduling of reports, drill down using actions - Filter/URL, Filters, parameters, creating dashboards.
  • Collaborating with other team members in creating optimal, maintainable, and scalable architecture and following enterprise standards and guidelines during all phases of development lifecycle.
  • Translating business requirements received from customers into developer-level technical documentation
  • Pro-active involvement in continuous performance improvement of existing systems.
  • Ability to work in multiple projects simultaneously and independently as well as in a team environment.
  • Excellent analytical, programming, written and verbal communication skills. Aptitude for problem solving and making critical decisions on a short time frame.

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 8.x/9.x/10 (Desktop, Web, Narrowcast Server, Object manager, Command Manager, Enterprise Manager, Report Services), Tableau 9.0/10.0

ETL Tools: Oracle Warehouse Builder, Informatica

Languages: C, C++, Java, HTML, DHTML, XML, XSL, ASP, SQL, PL/SQL, PHP

Operating Systems: UNIX (AIX, Solaris, SCO-UX, HP-UX), Windows 7, XP, NT//98/2000.

RDBMS: Oracle 10g/9i/8.x, Teradata V12.X, SQL Server, Netezza, Hive

GUI: Visual Basic 5.0/6.0, Visual Cafe.

Utilities: TOAD 8.x, Oracle forms 6i, reports 6i, Tivoli, Test Director, CA Service Desk

Others: SAP FI/CO 4.7, MS Office, MS Project, MS Visio, MS SharePoint and Dream weave

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr. MicroStrategy Architect/Developer

Responsibilities:

  • Enterprise Reporting Continuous Development (ERCD)
  • Digital Reporting Continuous Development (DRCD)
  • Assessing and cultivating long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
  • Worked with the Services department BI users and SME’s to deliver a services dashboard and Pets Hotel Dashboard in ERCD project to analyze KPI and help drive sales and customer retention for the services department
  • Assisting in the design of databases and data warehouses to ensure interoperability with MSTR solutions for New Digital Reporting project to capture Online transactions across the company
  • Created and streamlined process of capturing development work on the confluence web pages to provide ease of access to metric definitions and MicroStrategy objects for the business users
  • Performance tuning of the reports by reducing SQL passes, using VLDB properties, case statements, collecting statistics on the database tables, analyzing explain plans and creating indexes if required.
  • Worked with MicroStrategy Transaction services to update the links on the Ipad dashboard home page to provide access to various subject area reports and used an application to change the table prefixes
  • Design and creation of reports and development of dynamic DHTML and Flash dashboards involving huge amounts of data by developing different MicroStrategy Objects
  • Writing SQL scripts to populate the data in the tables and also to create tables.
  • Responsible for Narrowcast service creation (static and dynamic subscription sets), schedules, and other tasks related to Narrowcast.
  • Created IPad dashboards and configured links to navigate from home PAW home page to newly created dashboards and provide ease of access to the reports
  • Automation of MicroStrategy subscriptions using Windows batch files and DataMart triggering to schedule narrowcast and distribution services
  • Converted the previously created web flash dashboards to IPad dashboards with swipe and tap functionality using MicroStrategy Mobile Server.
  • Creating Enterprise Manager Reports & dashboards to analyze customer usage of the reports and average run time of the reports.
  • Creating Packages to move MicroStrategy objects between different environments and promoting to the Production
  • Troubleshooting report and data issues and supporting the users in problem resolution.

Environment: MicroStrategy 10.4, Netezza, Oracle 11g, SQL Server, DB2, Mobile applications, MS Office, SQL Assistant, Work bench, Informatica, Java, DHTML, XML, Windows 7, NT 2000, MS Office, Jira, Confluence, Zephyr

Confidential, Boca Raton, FL

Sr. BI Architect/Developer

Responsibilities:

  • FBS Quarterly Reporting Dashboard
  • Project Server Reporting of Timesheet Management
  • Automation of MicroStrategy Subscriptions
  • Mobile Dashboards for Executive Summaries
  • Footprints Reporting for Monitoring Tickets activity
  • Assessing and cultivating long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
  • Assisting in the design of databases and data warehouses to ensure interoperability with MSTR solutions.
  • Analyze user requirements and, based on findings, design functional and technical specifications for MSTR.
  • Performance tuning of the reports by reducing SQL passes, using VLDB properties, case statements, collecting statistics on the database tables, analyzing explain plans and creating indexes if required.
  • Worked on a Proof of concept for testing MicroStrategy Transaction services to build an Audit app on IPad
  • Architecting framework for security, adhoc report creation and event based scheduling for report caching
  • Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
  • Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Worked closely on project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server.
  • Design and creation of reports and development of dynamic DHTML and Flash dashboards involving huge amounts of data by developing different MicroStrategy Objects
  • Involved in MSTR upgrade activities from 9.0.2 to 9.4.1 and upgrade from 9.4.1 to 10.3
  • Writing SQL scripts to populate the data in the tables and also to create tables.
  • Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
  • Worked on the development of Dashboard reports for Key Performance Indicators for the top management
  • Rebuild existing Reports into Tableau Visualizations with user and action filters
  • Automation of MicroStrategy subscriptions using Windows batch files and triggering by Informatica Loads
  • Converted the previously created web flash dashboards to IPad dashboards with swipe and tap functionality using MicroStrategy Mobile Server.
  • Creating Enterprise Manager reports & dashboards to analyze customer usage of the reports and average run time of the reports.
  • Created data connections both standalone and multiple data sources on Tableau using data blending.
  • Create and Scheduled Data Extracts for better performance of dashboards on Tableau with multiple worksheets.
  • Used Object manager to deploy MicroStrategy objects from development in to test and production environments. Performed the role of a backup administrator.
  • Converted existing Narrowcast Executive summaries subscription to Mobile dashboards
  • Troubleshooting report and data issues and supporting the users in problem resolution.
  • Worked with DBA’s to tune SQL generated by MicroStrategy reports and to collect DB statistics and in creation of additional indexes if necessary
  • Performed administrative activities like invalidating the report cache, loading and unloading the projects, merging & duplicating projects
  • Involved extensively in troubleshooting, support and resolving all outstanding issues and fixes

Environment: MicroStrategy 9.x/10.3, Tableau Desktop 10.1/9.2,Oracle 11g, SQL Server, DB2, Mobile applications, MS Office 2003/2007, Quality Center, SQL Assistant, Informatica, Java, DHTML, XML, Windows 7, NT 2000, MS Office, MS Project, MS SharePoint, Footprints

Confidential, San Francisco, CA

Sr. MicroStrategy Developer/Consultant

Responsibilities:

  • Customer Campaign Analysis
  • Hispanic Group Customer Survey Reporting
  • Organize and the integration efforts for merging BI platforms with enterprise systems and applications.
  • Design and creation of reports and intelligent cubes by developing attributes, facts, templates, transformations, custom groups, consolidations, filters, prompts and metrics.
  • Implemented Proof of concepts and design for dashboards based on the requirements.
  • Conducted data validation testing to ensure data quality. Provided remote and onsite support to the applications.
  • Worked with business users to identify Key reports and develop a Mobile Dashboard POC
  • Worked with ETL Team for getting Data related to Different Customer Campaign and Hispanic Group of Customers for reporting on requirements specific to Campaign Analysis.
  • Created Views in Teradata from the Company Data mart to support the needs of the MicroStrategy Schema.
  • Created Auto Scripts to load on a monthly basis or when new data was available into the Views Created.
  • Design and development of dynamic DHTML and Flash dashboards involving huge amounts of data.
  • Involved in MSTR upgrade activities to version 9.2
  • Attended weekly project and team meetings and provided status on the assigned tasks
  • Created transformational metrics (Sales, Sales Target, Market Share, Profit and Growth) to compare monthly, quarterly and annual sales.
  • Developed different kinds of Reports like Simple Reports, Prompted Reports and Ad-hoc Analysis for business users and vendors with the drill down methodology depending on the requirements. Deployed and administrated reports on web.
  • Played a key role in User Acceptance Testing of the reports.
  • Developed Auto prompts to support end users by giving choice of different filtering criteria when they run the report every time.

Environment: MicroStrategy 9.x, Oracle 10g, Teradata V12.X, UNIX (AIX, Solaris), HP Quality Center, MS Office, MS Project, MS Share point

Confidential, Washington DC

Sr. MicroStrategy Developer/Consultant

Responsibilities:

  • FICO Analysis Reporting
  • Mortgage Recovery Dashboard
  • Design and creation of reports and intelligent cubes by developing attributes, facts, templates, transformations, custom groups, consolidations, filters, prompts and metrics.
  • Design and development of dynamic DHTML and Flash dashboards involving huge amounts of data.
  • Worked heavily on Performance tuning to reduce the run time of MicroStrategy reports drastically by changing the VLDB properties, reducing the number of SQL passes, additional index creation etc.,
  • Worked closely with the MicroStrategy Admin teams during the project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server.
  • Implementing effective caching strategy using linked templates and filters.
  • Conducted data validation testing to ensure data quality. Provided remote and onsite support to the applications.
  • Worked with ETL Team for addressing project issues, enhancements and provided Production Support.
  • Analyze user requirements and, based on findings, design functional and technical specifications for MSTR
  • Developed different kinds of Reports like Simple Reports, Prompted Reports and Ad-hoc Analysis. Deployed and administrated reports on web.
  • Used widgets such as Microcharts, Bubble Grid, Fish Eye Selector and also implemented Widgets as Selectors.
  • Tested all the reports by running queries against the warehouse
  • Identified the areas for scope of improvement and worked with the respective teams on Guidelines/Enterprise Standards and Best Practices.

Environment: MicroStrategy 9.x, Oracle Warehouse Builder, SQL, Windows 7, XP, Oracle 10g, Oracle forms 6i, Tivoli, MS Office, MS Project, MS Share point

Confidential, Minneapolis, MN

MicroStrategy Developer/Consultant

Responsibilities:

  • Wendy’s Survey Dashboard
  • Arby’s Ratings Project
  • Involved in gathering information from business users for finalizing system and report requirements.
  • Involved in Data Modeling and presented Data Model recommendations based upon the reporting requirements.
  • Created numerous Reports in MicroStrategy Desktop for business users and vendors with the drill down methodology depending on the requirements.
  • Implemented MicroStrategy reports by creating Facts, Attributes and Hierarchies.
  • Developed different kinds of Reports like Simple Reports, Prompted Reports and Ad-hoc Analysis.
  • Designed dashboards in DHTML and Flash mode.
  • Implemented Drilldown through grids in Dynamic Dashboards.
  • Implemented Document Drilldown using Hyperlinks.
  • Used widgets such as Microcharts, Bubble Grid, Fish Eye Selector and also implemented Widgets as Selectors.
  • Created and customized complex Graphs.
  • Tested all the reports by running queries against the warehouse-using Teradata SQL Assistant.
  • Played a key role in User Acceptance Testing of the reports.
  • Implemented Document performance optimizations and Troubleshooting Dashboard Performance.
  • Created Datasets based on Intelligent Cubes, Derived Metrics and View filters using OLAP services.
  • Involved in and provided solutions for complex Time Dimension related issues and analysis.
  • Extensively worked and developed Metrics, filters and prompts to enable decision-makers to choose the condition for reports as well as to view reports in different perspectives.
  • Created complex metrics forcing dimensionality and conditionality.
  • Used free-form SQL editor for complex report development.
  • Involved in deploying the reports in Narrowcast server by creating services on time based schedule.

Environment: MicroStrategy 9.x, Oracle Warehouse Builder, SQL, Windows 7, XP, Oracle 10g, Oracle forms 6i, Tivoli, MS Office, MS Project, MS Share point

Confidential, Hoffmann Estates, IL

MicroStrategy Developer

Responsibilities:

  • Store Points Dashboard
  • Play On Project
  • Worked closely with the Architects, ETL developers, DBAs and consumers of data to develop and implement the BI solutions using MicroStrategy.
  • Performance tuning of the reports by reducing SQL passes, using VLDB properties, case statements, collecting statistics on the database tables, analyzing explain plans and creating indexes if required.
  • Part of the team to Handle the conversion of MicroStrategy from Oracle to Teradata database.
  • Successfully implemented Mobile Quick strike projects by designing the prototypes for IPhone and IPad and development of apps.
  • Worked closely with the MicroStrategy Admin teams during the project migrations and fixing the metadata issues and also in configuring the governing settings at the project level and on Intelligence server.
  • Design and creation of reports and intelligent cubes by developing attributes, facts, templates, transformations, custom groups, consolidations, filters, prompts and metrics.
  • Design and development of dynamic DHTML and Flash dashboards involving huge amounts of data.
  • Identified the areas for scope of improvement and worked with the respective teams on Guidelines/Enterprise Standards and Best Practices.
  • Participated in review, sign-off and communication of all changes or modifications to reports.
  • Attended weekly project and team meetings and provided status on the assigned tasks
  • Writing SQL scripts to populate the data in the tables and also to create tables.
  • Responsible for Narrowcast service creation (static and dynamic subscription sets), schedules, and other tasks related to Narrowcast.
  • Troubleshooting report and data issues and supporting the users in problem resolution.
  • Leading the teams in fork lifting the MicroStrategy projects from Oracle to Teradata environments.

Environment: MicroStrategy 9.x, Oracle Warehouse Builder, SQL, Windows 7, XP, Oracle 10g, Oracle forms 6i, Tivoli, MS Office, MS Project, MS Share point

Hire Now