We provide IT Staff Augmentation Services!

Microstrategy Developer Resume

0/5 (Submit Your Rating)

CA

SUMMARY

  • 10+ years of IT experience in Software Development, Designing and Implementing with major focus on Business Intelligence tools and Database Applications.
  • Extensive experience in Data ware housing technologies with hands on Experience in Microstrategy, Tableau, Crystal Reports, Informatica, Oracle, SAP BW & SQL Server.
  • Exposure to Big Data applications such as HDFS, Hive etc
  • Involved in statistical programming R - Analytics using R-studio tool
  • Experience in Design, Developing, Testing, Distributing, Maintaining and Performance Tuning of Reports.
  • Extensively worked on Dimensional modeling and have developed interactive Dashboards.
  • Have worked on MicroStrategy Administration tools such as Command Manager, Object Manager, License Manager, Integrity Manager, Narrowcast, Enterprise manager and Distribution Services.
  • Expertise in configuring Distribution Services to enable Subscriptions to be delivered to file/e-mail.
  • Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse using Informatica.
  • Hand on experience in developing stored procedures/packages, Database Triggers, Cursors using SQL.
  • In-depth understanding of Data Warehousing Concepts.
  • Possess Excellent Communication and Interpersonal skills.
  • Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Business Intelligence: Microstrategy,Tableau & Crystal Reports, SAP BW

Analytical Tool: R Analytics

Big Data: Hive, HDFS & Cassandra

ETL Tools: Informatica

RDBMS: Oracle, SQL Server

Operating Systems: Windows 2003/2008 Server and UNIX.

Programming Languages: VB 6.0, Visual Basic .Net (C# & VB)

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Sr. Microstrategy Developer

Responsibilities:

  • Working as an Architect in building new schema objects for new Venues & Attractions within the Universal Theme Parks.
  • Extensively using Narrowcast services in delivering reports to multiple users
  • Create reports & dashboards extracting data from multiple data sources such as Teradata & Sql Server
  • Responsible for complete administration tasks using Object Manager, Command manager, Enterprise manager etc.
  • Apply technical skills using Microtrategy and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests.
  • Involved in the documentation of technical specifications of the Universal Parks & Resorts
  • Involved in a POC in developing reports and dashboards using Tableau reporting tool.

Environment: Microstrategy, Tableau, Teradata & Sql Server.

Confidential, Cupertino CA

Microstrategy Architect

Responsibilities:

  • Study the Confidential ’s advertising business process and gather the requirements interacting with Users and Business Analysts to know their Business views in developing Reports, Documents and Dashboards
  • Created reports & dashboards extracting data from multiple data sources such as Hive & Oracle DB
  • Extensively worked on OLAP cubes for various reporting needs
  • Used VLDB properties in fine tuning the sql intensive reports using Hive
  • Performed complex ad-hoc Sql queries in creating microstrategy reports from Hive & Oracle DB
  • Contributed to build business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue and profit margin
  • Worked on R-code enhancements using R-Analytics tool
  • Good experience in creating visualizations using different types of widgets & graphs
  • Involved in CoE by creating visual insight report pulling data from No Sql DB’s such as Cassandra DB
  • Have good understanding of Microstrategy Architect & Administration.
  • Extensively used Object Manager in migrating ojects from different environments.
  • Good understanding in using Command Manager scripts for automating MicroStrategy admin tasks
  • Worked on Enterprise Manager Reports for providing User/Report /Project etc statistics

Environment: Microstrategy,OLAP, Tableau, Hive, Oracle, Unix.

Confidential

Sr. BI Developer

Responsibilities:

  • Managed a team of IT professionals in the areas of gathering, analysis and documentation of business requirements using ALM tool
  • Responsible for designing the data model schema working with DBA.
  • Responsible for creation of reports, Metrics with Public and Schema Objects
  • Worked on Narrowcast Server especially using Scheduling, Subscription and Event Base Alert Services.
  • Join in daily standup meetings with project manager, business analyst, ETL team, data modelers, testing team to discuss the user requirements and status updates.
  • Supporting the project team in SIT and UAT testing.
  • Worked in a Agile process with two week iterations delivering documents/report at each iteration.
  • Working closely with ETL team for collecting data and testing team for resolving defects.
  • Created Freeform Reports for complex reporting scenarios.
  • Involved in Query optimizations using VLDB properties.
  • Troubleshoot and Debugging Reports and Documents for the web users.
  • Working with MicroStrategy technical support for critical issue resolution.

Environment: Microstrategy 9.3.1, Sql Server 2005 & Unix

Confidential

MicroStrategy Developer

Responsibilities:

  • Report/Dashboard development
  • Object Migration as well as MDX cubes migration using packages using Object Manager Tool
  • Applied MSTR Patches/HotFixes to the Dev/Test/Prod environments
  • Involved in complete MicroStrategy Installations on UNIX and Linux environments
  • Good understanding in using Command Manager scripts for automating MicroStrategy admin tasks
  • Worked on Enterprise Manager Reports for providing User/Report /Project etc statistics
  • Use License Manager for activating/updating licenses for Client and at the Unix level
  • Good understanding of Integrity Manager and Distribution Services
  • User and User Group creations
  • Enabling Traces/logs at the I-server for reproducing the errors to fix the MSTR issues
  • Making project/Server configuration changes
  • Ability to work on VLDB settings
  • Weekly meetings with MicroStrategy consultants and work on MSTR Cases to resolve core issues
  • Discussions with MSTR consultants on applying the Settings at Project/I-Server level for performance improvement of the projects.

Environment: MicroStrategy 9.2.1, Oracle 10g, Unix

Confidential

ETL & Reporting

Responsibilities:

  • Provide Production support/ Development using Informatica powercenter tool 8.6.1.
  • Involved in modifying mappings, analyzing the transformations, monitoring the workflows etc.
  • Involved in monitoring, fixing invalid mapping data validation errors as well as removing the logical errors using session logs.
  • Monitoring and triggering the workflows or Tasks.
  • Was involved in creating MicroStrategy Public objects such as Metrics, filters, reports and dashboards.
  • Created user and user groups using Microstrategy Developer tool.
  • Used Actuate Reports to check the feeds, server statuses, schedule and generate reports, bringing down/up the applications servers etc.
  • Support the Middle Office/Front Office; deliver the Risk and PNL to the teams adhering to SLA's.
  • Monitoring autosys UNIX jobs so that client reports/feeds are generated and sent across within the given SLA.

Environment: Informatica, Microstrategy, Actuate, UNIX, Oracle, Sql Server

Confidential

Senior Software Programmer

Responsibilities:

  • Analysis of the specifications provided by the client
  • Develop web-based applications using HTML, ASP.Net, and C #. Net.
  • Create stored procedures, functions and several other queries in Sql Server 2000 for reporting purposes
  • Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Selection Criteria, grouping,sub reports etc
  • Design and development of Data Base tables, Stored Procedures and Functions using Sql Server 2000
  • Analysis, Design, Coding, Testing phases of Software Development
  • Independently recognize, isolate, and resolve technical problems while minimizing customer stress levels.

Environment: Visual Studio.Net, Sql Server and Crystal reports 10

Confidential

Junior Programmer

Responsibilities:

  • Developed and maintained applications such as Sales, Inventory, Finance and Payroll.
  • Create stored procedures, functions and several other queries in Sql server 2000 for reporting purposes.
  • Created reports using Crystal Reports with Standard, Summary, Cross Tabs, Drill Down, SQL, Selection
  • Criteria, grouping, sub reports etc.
  • Create Crystal Reports using formulas, parameters, selection criteria, sub reports etc.
  • Scheduling the reports to run on daily/weekly/monthly basis and email the results to the users

Environment: VB6.0, Sql Server 2000 and Crystal reports 8.0

We'd love your feedback!