Microstrategy Consultant Resume
4.00/5 (Submit Your Rating)
Saint Louis, MO
SUMMARY:
- Data Warehousing and Business Intelligence Expert
- Managed Business Intelligence Projects with cross - functional teams for over 10 years
- Excellent track record in Implementations, Upgrades, & Rollouts
- Excellent applied knowledge of SDLC - Waterfall, Agile, & Iterative methodologies
- Expertise in SCRUM Agile methodology, Sprint metrics & Project Financials
- Good knowledge of Big data on Hadoop cluster(Cloudera Live) on Amazon Cloud(trial version) and adhoc tools(Hive, Impala, & Confidential )
- Excellent knowledge of Big Data architecture integration with traditional Datawarehouse
- Completed Confidential 9x boot camp (certified) offered by Confidential - May 2010
- Over 13 years of experience in designing and implementing Business Intelligence solutions using Business Objects & Confidential
- Experienced in all areas of Business Intelligence Life Cycle - Database Design, ETL Development and Report Development
- Participated in both OLTP & OLAP projects in various capacities - Project Manager, Project Coordinator, Technical Lead, Data Modeler, & Developer
- Developed and implemented standards, processes and policies for “Business Intelligence Center of Excellence” at Confidential
- Successfully managed projects that involved both onshore and offshore resources
TECHNICAL SKILLS:
- Business Intelligence Architecture
- Confidential Project Design
- Confidential Report Development
- Confidential Transaction Services
- Confidential Document & Dashboard Design
- Project Management - JIRA, Sharepoint & MS Project
- Confidential Installation, Configuration & Administration
- Business Objects XI R2
- SQL - Oracle, MS SqlServer, & Teradata
- Big Data-Cloudera Live on Amazon Cloud
- Data Warehousing & Kimball Methodology
- Finance, Insurance & Health Care Business Expertise
- SCRUM Framework & Sprint Metrics
- Wordpress Website Customization, Installation & Rollout
- Waterfall & Agile Development Methodology
PROFESSIONAL EXPERIENCE:
Microstrategy ConsultantConfidential, Saint Louis, MO
Responsibilities:
- Part of Ernst & Young(EY) Consulting Team to automate extracts for Center for Medicare & Medicaid Services(CMS)
- Developed more than 150 reports, documents & dashboards in total
- Developing over 80 MicroStrategyTransaction Services documents to insert/update data into Teradata database tables
- Developing operational metrics and executive dashboards to provide overall information with selector & drill through capabilities
- Rolled into production in April ' 17 and current ly in bug fix phase & enhancement phase
- Working on Enterprise Manager reports to provide user activity and performance analysis
Confidential, Plano, TX
Responsibilities:
- Excellent knowledge of Confidential 10x Developer, Architect, & the Web module
- Architected two projects - one based on OLAP Schema & other based on OLTP Schema
- Built joins, attributes & metrics to cover all aspects of reporting
- Showcased different features of Confidential including Intelligent Cubes & Datamarts
- Built Reports, Documents, & Dashboards showing multiple ways of displaying data
- Moved one project to UAT along with objects, reports, documents & dashboards
Consultant BI Project Manager
Confidential, Columbus, OH
Responsibilities:
- Managed a team of 10 people at client site using SCRUM Agile Methodology
- Project involved Netezza, Data Stage & Confidential
- Rolled out JIRA as Project Management Tool
- Defined project scope, listed issues, & grouped them by Sprints & Iterations
- Assigned issues to Analysts & Developers and managed deliverables
- Built iteration metrics, provided weekly statuses and attended bi-weekly Project Managers meeting
- Work interrupted to participate full time in Fidelity Investments Compensation Program
Owner/Creator
Confidential
Responsibilities:
- Developed a breakthrough methodology in the area of Transformation & Meditation
- Field tested with over 50 participants with almost 100% success rate
- Planning to build a web based network of coaches with capability for online and video coaching
- Developed a website in Wordpress with mobile capability
- Registered company and built an online presence
- Worked on coming up with web projects and did feasibility studies
- Installed, configured, & tested Hadoop cluster using Cloudera Live on Amazon Cloud (Cloudera trial version). Tutorial included
- Using Sqoop to move relational tables into Hadoop HDFS
- Using Hue, Hive, Impala, & Pig for adhoc querying
- Using Spark-on-Yarn for testing in-memory processing
- Using Morphline(Flume framework) to parse live log data, load into Solr, & indexing logs in real-time. Use Hue Search application to search indexes and build dashboards
- Develop reports in Confidential accessing Hadoop through Hive ODBC driver
Compensation Recipient
Confidential, Boston, MA
Responsibilities:
- Worked on a compensation with company exclusively during this period
Senior Consultant
Confidential, Vienna, VA
Responsibilities:
- Completed boot camp at Confidential that included Certifications in development (CMD), engineering (CME) and administration (CMA)
- Responsible for mapping current environment in Business Objects universe Demonstrated Confidential for specific functionalities for Client Demo helped in client to move forward with migration project Responsible for proof of concept of Confidential utility that helped in automating migration of Business Objects Universe Objects to Confidential Project Objects
Business Intelligence Lead
Confidential, Columbus, OH
Responsibilities:
- Lead member for a major Business Objects upgrade to version XIR2
- Project involved over 1000 reports
- High visibility project involving crucial deliverables for daily Asset Management Operations
- Project became the foundation for Business Intelligence Center of Excellence (BICOE)
- Lead architect for putting together processes, standards and guidelines for creating BICOE
- Centralized repository with distributed de-centralized universe and report development
- Enabled rolling out standards to keep all BI development in Asset Management consistent
- Enabled easy rollout of new projects based on Turnkey Architecture
- Hands on technical lead for major reporting projects including coordinating activities with offshore development resources
- Business Objects SDK project automating scheduling and publishing of reports
- Managing daily activity with off-shore developer to provide feedback & managing business expectations
- Worked on several Business Objects development projects as Technical Lead, Project Coordinator, & Developer
- Developed over 30 Web Intelligence reports for a JPMorgan group in Denver, CO
Senior Report Architect
Confidential, Cambridge, MA
Responsibilities:
- Managed several different roles - technical lead, project management, hands on development, and managing day to day operations
- Managed a major Business Intelligence upgrade project to Business Objects XIR2
- Project involved more than 1000 reports and used Business Objects migration tool
- Hands on Project Lead working with Project Manager in putting together technical project plan, coordinating resources, rolling out end-user training, and in project roll out
- Made sure rollout was smooth with minimal interruption to business
- Key player in a high-profile Financial Data Mart project involving Business Objects Consultants
- Played the role of Sql Server DBA & Business Objects Administrator
- Took over the project after project completion
- Managed changes to tables, stored procedures and Business Objects universe /reports subsequent to initial rollout
- Managed coordination of several small and big projects working with consultants to get work done
- Worked on projects that involved development on both Sql Server 2000 and business objects
- Worked on tables and stored procedures
- Developed Business Objects universe objects and reports
- Worked on a major server migration project that involved move to an offsite location
- Worked with Network Operations to manage the successful migration of Business Objects servers to Data Center
- Made sure daily operations were not interrupted during migration
Senior Data Analyst
Confidential, Boston, MA
Responsibilities:
- Worked as a data modeler using for a major database reengineering project (NETFLOW)
- Responsible for being the point person for PowerDesigner CASE tool. Coordinated activities between Management, Vendor and End-Users
- Built a FISC Data Model by merging individual data models using PowerDesigner Model Merge functionality
- Key player in project involving publishing of all Daily, Weekly, Monthly, & Yearly Business Objects reports to Web Portal
- Worked with VBA developer to convert postscript files to PDF files
- Put together design and implemented VBA code to run as part of Business Objects scheduler process
- Project won “above & beyond” award for the whole team
- Worked for 1 year at Fidelity London, UK office
- Developed two crucial reports and rolled out Business Objects to London Equity Trading Floor
- Reports used VBA code for report bursting
Data Analyst
Confidential, Temple, TX
Responsibilities:
- Worked on several small and medium sized projects as data modeler
- Learnt PowerDesigner as CASE Tool and used in Informix client-server project
- Worked as a business analyst for a major project to implement electronic data transfer system between McLane company and Southland Corporation
Geophysicist
Confidential, Hunt Valley, MD
Responsibilities:
- Worked as a geologist / geophysicist to map and identify contaminated Sites
- Worked at Eglin AFB, Fort Drum Army Base, & Philadelphia Naval Shipyard
