Microstrategy Developer Resume
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