We provide IT Staff Augmentation Services!

Microstrategy Developer / Tableau Analyst, Developer Resume

Camden, NJ

PROFESSIONAL SUMMARY:

  • Results - driven Microstrategy, data warehousing, reporting and analytics professional with expertise in envisioning and leading business intelligence-based project initiatives.
  • Impressive career marked by peak-performing teams and of cross-functional business objectives with more than 8 years of experience.
  • Influenced stakeholders by coaching business leaders-including providing and presentations as well as creating quality practice documents on applications for existing and trending technologies.
  • Developer and Architect in MicroStrategy reporting solutions, ensuring that strategic planning is in alignment with retail, banking, corporate, IT and business strategy.
  • Extensive experience as MicroStrategy developer, building projects and creating reports and dashboards using Microstrategy 9.x/10.x, MicroStrategy Desktop, Mobile, Web, Intelligence Server and Architect.
  • Recognized as a trusted BI expert to business leaders - making them aware of technology implications relating to business plans and appropriate methods of business problem solving.
  • Expert on Enterprise Architecture for MicroStrategyand well-informed about market trends, emerging technologies, and the history and evolution in the area of business intelligence expertise including issues related to integration, interconnectivity and the potential impact on existing architecture.
  • Expert in optimizing queries and technology bottlenecks. Good experience in data modelling using snowflake and star schemas.
  • Worked with data architects and ETL developers in creating high efficiency reporting solutions using MicroStrategy.
  • Designed, developed, tested and maintained Tableau functional reports based on user requirements.

TECHNICAL SKILLS:

Reporting Tools: Microstrategy 9.x/10.x Developer, Administrator, Architect, Intelligence Server, Web, Object Manager, Freeform SQL, Mobile, Dashboards, Intelligent Cube, Transaction Services, Tableau Desktop

Databases: Oracle, Netezza, HP Vertica, SQL Server, Teradata, DB2

Languages: SQL, PL/SQL, JavaScript, ASP.NET, HTML

Tools: ERWIN, Microsoft VISIO, Vertabelo, Oracle SQL Developer, TOAD, JIRA, HP Quality CenterOperating Systems: Windows, AIX UNIX, SUSE/Redhat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Camden, NJ

Microstrategy Developer / Tableau Analyst, Developer

Responsibilities:

  • Designed, developed, tested and maintained Tableau functional reports based on user requirements.
  • Master the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parameters using Tableau.
  • Worked on designing schema, including attributes and metrics based on new data coming in from multiple data sources.
  • Involved in upgrades from 10.1 to 10.4, including smoke testing.
  • Worked with business users and business analyst in Work Item (events and scheduling), Contracts and Travel (Hotel, car rentals, airfare) subject areas in order to create requirements and reports.
  • Built scheduling dashboard which allowed event schedulers to locate available employees and resources who live near a given event.
  • Worked on a dashboard to track usages for limited-use contractors and companies.
  • Communicated with business users in order to log and fix report and object defects - ranging from changing default prompt answers based on requirement changes to adjusting schema in order to facilitate ad-hoc and canned reporting.
  • Involved in business users for ad-hoc reporting capabilities.
  • Wrote freeform SQL queries for one-off user requests, including specific requirements and document headers.
  • Worked with business analyst and architects in order to prioritize backlogged work and user requests.
  • Wrote and changed views according to business reporting needs.

Confidential, Atlanta, GA

MicroStrategy Developer/Architect

Responsibilities:

  • Partnered with engineering/architecture teams to design, implement and support enterprise, data warehouse and business intelligence programs and solutions. Developed and supported numerous MicroStrategy reporting suites for sustain Self Service Adhoc and heavy dashboard projects.
  • Built CFO dashboard that summarized information from multiple line of business by using heavy analytics, visualization and Intelligent Cubes for high performance. Delivered different MicroStrategy projects to address customer care and billing system using reporting and dashboards.
  • Worked with data architects to optimize data model for efficient MicroStrategy reporting. Designed, developed, and validated MicroStrategy objects such as grid reports, dashboards, KPIs and alerts. (Dashboards, Attributes, filters, metrics, facts, prompts, templates, Cube, consolidation custom groups, VLDB).
  • Integrated MicroStrategy applications with multiple data sources using multi-source options. Built interfaces using transaction services to provide quick solutions for data entry problems. Provided access to key information from business intelligence applications via user-centric, intuitive dashboards.
  • Built highly efficient Intelligent Cubes to support adhoc and mobile reporting solutions. Optimized database queries by applying various techniques on database and MicroStrategy options. Applied data security to the projects by using security filters and system prompts.
  • Worked closely with ETL team and provided level 4 supports for solving data quality issues. Implemented scheduling strategy to disperse hundreds of reports to field technicians without negatively impacting intelligence server and database.
  • Involved in upgrades from 8.x to 9.x. Conducted user to business users to ensure efficient usage of reporting systems. Worked with business groups to clearly understand and document requirements. Provide mock-ups and work flows to get business sign-offs.
  • Managed all change requests, validated all schedule impacts, obtain stakeholders' commitment, and communicated approved changes to all teams. 24/7 support of the MicroStrategy environment to ensure high availability, resilience, integrity, security, and performance.

Confidential, Richmond, VA

MicroStrategy Developer / Administrator

Responsibilities:

  • Determined which MicroStrategy components to use, and set them up based on reporting needs, user volume, and other requirements.
  • Designed, developed, validated MicroStrategy reports such as grid reports, dashboards, KPIs and alerts (Dashboards, Multidimensional cubes, Attributes, filters, metrics, facts, prompts, templates, consolidation and custom groups).
  • Upgraded from 9.0.0, 9.3.0 and 9.4.0. Enabled MicroStrategy users to access meaningful and timely data anytime, anywhere - via mobile internet access for Mobile Intelligence services.
  • Integrated MicroStrategy application with data sources, security systems, single sign-on systems, identity management systems and other third-party products.
  • Provided access to key information from your Business Intelligence applications via user-centric, intuitive dashboards.
  • Installed, designed and maintained MicroStrategy infrastructure in UNIX. Acting as Senior MicroStrategy administrator and MicroStrategy developer.
  • Worked with analytics and IT team on assessing/analyzing impact to reporting when new website functionality is implemented and make adjustments to reports on an as-needed basis. Work with QA team to ensure that changes are accurate.
  • Coordinate with business analyts to define requirements for new BI reporting initiative, analyze.

Confidential, Dallas, TX

Intern Reporting

Responsibilities:

  • Monitored, managed and facilitated communication and resolution of cross-team alignment to enterprise infrastructure for 120 projects as MicroStrategy administrator for the whole Confidential including Retail and Corporate data warehouse.
  • Upgraded from MicroStrategy 8.0.2 to 9.0.0. Involved in several large scale data and Systems Infrastructure process re-engineering, and technology initiatives. Strong understanding of Software Development Lifecycle (SDLC). Excellent knowledge and experience on conceptual, logical and physical data modeling.
  • Performed high value, functional knowledge of best practices and technological developments in the IT and publishing industry. Oversaw solution implementation from an architectural perspective. Participated on weekly Control Change Board meeting for change implementation and root cause analysis.
  • Diagnosed issues and provided appropriate data analysis and solution. Managed security and access list for all projects and licenses. Managed IS Memory contract manager to tune the memory utilization, manage priorities for jobs and use system resource management to optimize the application performance.
  • 24/7 Support of the MicroStrategy environment to ensure high availability, resilience, integrity, security, and performance. Created MicroStrategy projects to support new BI initiatives by defining schema. Tuned MicroStrategy reports for best SQL performance to run efficiently and work with Database developers to optimize report and data structure.
  • Continuously review and enhance logical and physical database designs as well as optimization for efficient reporting. Implemented comprehensive plan for distribution of reports via automation, scheduling and distribution services.

Hire Now