We provide IT Staff Augmentation Services!

Sr. Microstrategy Developer Resume

Durham, NC

SUMMARY:

  • Senior Microstrategy developer with over fifteen (15) years of experience in implementation of distributed, multi - tier, data modeling, data warehousing/OLAP and Confidential applications
  • Worked on huge reporting and data analysis projects for organizations like Confidential, CISCO, AT&T, BT and HT
  • Expertise working with the MicroStrategy suite of products: Developer, Architect, Web, Mobile, Enterprise manager, System Manager, Transaction Services, Object Manager, Command Manager, Narrowcast Server, Distribution Services and Administration
  • Proficient with MicroStrategy Confidential
  • Involved in planning and implementation of major environmental migrations and upgrades
  • Expertise in SQL Server and good working knowledge of SSIS
  • Comprehensive knowledge of business intelligence and data warehousing architecture
  • Good understanding of RDBMS and Dimensional Modeling, star and snow flake schemas
  • Working knowledge of the Confidential ecosystem and associated components, Hadoop, Sqoop, Pig and Hive
  • Excellent communication, interpersonal and customer handling skills

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008/2008 R2/2014

Operating Systems: Windows Server 2008/2003/2000/ NT and Windows XP.

Design Tools: MS Visio 2007/2003

Reporting Tools: MicroStrategy, Actuate, SSRS and Tableau

ETL Tools: SQL Server Integration Services (SSIS)

Confidential Tools: Hadoop, Hive, PIG and Sqoop

PROFESSIONAL EXPERIENCE:

Sr. Microstrategy Developer

Confidential, Durham, NC

Responsibilities:

  • Worked closely with the business users to understand the functionality and the requirements
  • Analyzed data models, data warehouse (SQL Server 2014) to implement the reporting in MicroStrategy
  • Identified and created the health care data domain artifacts needed for the analytics
  • Created various Microstrategy objects and relevant KPIs which revealed the provider’s contract information, patient turnover, claims processing, utilization, authorizations and emergency department activities etc.
  • Managed the business intelligence reporting needs of end users
  • Designed, created and implemented the reports, and query capability in MicroStrategy for the business users
  • Coordinated with different team members throughout the project life cycle for seamless deliveries
  • Trained team members/business users on an as needed basis
  • Created visualizations in Visual Insight and enabled the users for self-service BI

Environment: MicroStrategy 10.2 product suite and SQL Server 2014

Sr. Microstrategy Developer

Confidential

Responsibilities:

  • Worked on design and implementation of Microstrategy dashboards (financial reporting, sales and invoice reporting) for various businesses under Confidential
  • Developed several executive dashboards with navigation and user interface created in MicroStrategy
  • Created SQL scripts to perform data integration from variety of sources into the DWH.
  • Involved in creating MicroStrategy logical model by creating relevant objects as needed
  • Proficient in debugging the SQL passes of datasets
  • Proficient in writing SQL scripts for several Free Form SQL reports
  • Worked extensively on creating and configuring the intelligent cubes and developed Visual Insight dashboards
  • Created schedules for publishing the intelligent cubes as per the workflow in System Manager
  • Worked on configuring mobile servers and realizing dashboards on iPads, also created homepage for iPad dashboards
  • Created report subscriptions in Narrowcast server as per the user needs
  • Worked on end-to-end delivery process methodology
  • Implemented user grouping and created users as per the user privileges
  • Implemented transaction services to facilitate users to interact with dashboards to write back to DB dynamically
  • Involved in MicroStrategy upgrades from 9.0.1m 9.2.1 9.3.1 9.4.1

Environment: Big Data Hadoop ecosystem, MicroStrategy 9.4.1 product suite, SQL Server 2008 and MS SSIS

Sr. Microstrategy Developer

Confidential, Fort Lauderdale, FL

Responsibilities:

  • Gathered requirements from stakeholders and converted them to technical specifications
  • Involved in planning of tool migration from Actuate to MicroStrategy
  • Created MicroStrategy objects needed for reporting
  • Designed and created datasets and dashboards using MicroStrategy.
  • Configured the MicroStrategy web server
  • Involved in Sprint management calls (agile development methodology)
  • Studied the source OLTP sources to understand the data
  • Interacted with the data modeling architects for advanced schema and project optimization
  • Involved in designing a variety of KPIs required for managed network service activity
  • Developed and implemented security roles, user groups, privileges and object security
  • Involved in troubleshooting Microstrategy Web reports optimizing the SQL using Confidential properties
  • Involved in preparing POC for Network traffic reports for Confidential

Environment: Microstrategy 8.1.1 product suite, Actuate eRDPro 8.0 Oracle 11g, Informatica Power Center 8.6.1, Solaris and Windows XP

Actuate Consultant

Confidential

Responsibilities:

  • Designed and developed several sectional/parallel/group reports which depicted the network and utilization statistics of various BT products
  • Coordinated with the global user community of Confidential to solve any technical issues
  • Implemented several enhancements for various reports
  • Conducted code reviews
  • Implemented various performance improvement activities for the applications
  • Key resource for planning and implementation of migrating Actuate 5 to Actuate 8
  • Evaluated migration of reporting solutions from Actuate to MicroStrategy

Environment: Actuate 8/5, Oracle 9i, VisualBasic 6.0, MS IIS 6.0, HTML with ASPs, Unix, Citrix Server, PVCS, HPOpenView and Windows 2003 Server

Actuate Developer

Confidential

Responsibilities:

  • Designed and developed spreadsheet reports using Actuate Suite
  • Designed and created functionality in reports for generating CVS and XML files at runtime
  • Modified a few JSPs to fix the issues reported in the portal using ActivePortal for JSP
  • Modified the reports according to the new requirements
  • Modified the libraries for the reports to get affected accordingly

Environment: Actuate 8.0, Oracle 9i, JSP and Windows NT/2000

Actuate Developer

Confidential

Responsibilities:

  • Modified JSPs to fix the issues reported in the portal using ActivePortal
  • Involved in creating the data model
  • Responsible for design and implementation of complex reports
  • Involved in the Actuate server administration including deploying reports, user roles and privileges
  • Involved in the reviews, technical design and client discussions for enhancements

Environment: Actuate 8.0, Oracle 9i, JSP and Windows NT/2000

Actuate Developer

Confidential

Responsibilities:

  • Responsible for design and implementation of reporting application
  • Assigned issues to the team members raised by the client according to the priority
  • Designed and created Ad-Hoc reports
  • Responsible for designing data model for the reports
  • Tested the reports and prepared the documentation for the report specifications and results.
  • Responsible for scheduling the reports on the Actuate server
  • Provided page level security for the reports
  • Responsible for guiding stress testing the reports and prepared the documentation
  • Actively involved in trouble-shooting and training users on Actuate usage

Environment: Actuate 6, SQL Server 2000, Forté Confidential, Visual SourceSafe, RationalRose and Windows NT/2000

Hire Now