We provide IT Staff Augmentation Services!

Sr. Bi Developer Resume

0/5 (Submit Your Rating)

Columbus, OhiO

SUMMARY

  • Over 7+ Years of extensive work experience in the field of Information Technology implementing Data warehousing, Decision Support Systems.
  • Extensively worked in developing DW applications using MicroStrategy Desktop, Web, Administrator, Narrowcast Server, and Intelligence Server.
  • Gathering requirements from business users and analysts.
  • Has worked on MicroStrategy 9.3 cloud and have down POC with 9.3.1.
  • Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
  • Decent Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers.
  • Very good experience in working with very large databases on Oracle, SQL Serverwith Micro strategy Suite. Strong SQL skills in SQL server Environment.
  • Exceptional analytical and problem solving skills. Self - motivated team player with the ability to communicate effectively at all levels of the development process.
  • Experience in integrating MicroStrategy with heterogeneous data sources and the implementation of dynamic-sourcing.
  • Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
  • Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties
  • Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
  • Experience in Data Modeling using ERWIN3.x/4.0, Data mart and OLAP for business analysis using star&snowflake schemas, for faster and effective querying.
  • Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
  • Experience in developing and deploying MicroStrategy mobile apps on Apple IOS/iPad and/or similar other devices.
  • Worked on SDK for few existing plugin change/update, got from MicroStrategy direct
  • Involved in Product Support on Call Support on rotation basis.
  • Having experience with all reporting phases such as MicroStrategy Installation (on Unix and Windows platform), creating project source and configurations, user group security setup, schema design and public object development including reports and dashboards, Intelligent Cubes, data Mart and SDK setup.
  • Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Java, CSS, HTML, XML, SVN

BI Tools: MicroStrategy v9.4.1, v9.3.1, v9.2.1, v9.1.0, v9.0.2, v8.1.1 (MicroStrategy Administrator, Desktop, Intelligence Server, Web, Narrowcast Server, OLAP Services, Architect, Distribution Services, Office), Narrowcast Server, Cognos, Business Objects

Data Modelling Tools: Erwin, Visio, SQL Data Modeler

Databases: Oracle 11g/ Oracle10g /9i, SQL Server 2000/2005, Teradata, DB2, Netezza

Operations Systems: UNIX, Linux, Windows 7/8.1/XP/2000/2003 Server

Application/Web Servers: Apache/Tomcat, IIS, Web Sphere, MS Office

ETL Tools: Informatica 8.x/7.x/6.x, SQL* Loader, Oracle Warehouse Builder10.2.

Languages: Java, C, C++, SQL, XML, HTML, DHTML, MQ-Series, UML, COBOL II, JCL, Visual Basic, PL/SQL, SQL*PLUS

Others: ER Data Modeling, Normalization Techniques

PROFESSIONAL EXPERIENCE

Confidential - Columbus, Ohio

Sr. BI Developer

Responsibilities:

  • Exclusively worked on Administration and Development part of Reporting and Project Development
  • Designed project Schema, all the project tables including dimension and fact tables with multisource option
  • Scheduled Administration jobs for live projects, executing reports and project reports through EM (Enterprise Manager) to understand the performance of the reports and user needs.
  • Developed dashboards with flash widgets which includes heat map, trend line, waterfall and some of the other customized dashboards as per clients requirements with security filters for law enforcement team
  • Developed Free-From SQL, multiple data sources reports for frequently changing business logic new technology and services are being introduced
  • Created geographical dashboard for Sales and Marketing to concentrate on Technology and Services and users on different technologies, Mobile Dashboards on Geographical Data and Voice Usage of the customers and leakage dashboards
  • Extensively used UI and UX design basics for dashboard development for Marketing and Sales team
  • Coordinated with Data Architects and Data Modelers to create new schemas and view in Netezza for to improve reports execution time, worked on creating optimized Data-Mart reports.
  • Worked extensively with IBM and Netezza Data base Modeler and Architect to create new data model in order to improve performance of the report using, fine-tuned MSTR VLDB settings in order to get optimal performance from the report where more than 500 users has access to reporting services
  • Migrating Project objects using Object Manager and comparing different environments using Integrity Manager of Microstrategy in the same version
  • Worked on Several ad-hoc queries through JIRA intake system for various business and technical users to analyze data and make decision to better serve the customers
  • Trained Business users to use Microstrategy as a Business Reporting Services and helped users to created their own ad-hoc reports and dashboards and documents using report services tools
  • Created dashboards using Tableau, Qlik Sense as a part of data analysis and data mining, tested reports in Pentaho Reporting as a part of reports migration for another business group to help them make decision for using efficient BI tool

Environment: Microstrategy 9.4.1, 9.0, Netezza 7 with Aginity Workbench 4.3, SQL Server 2012, (KPI, Sales Profit and Total Device Sold, Voice and Data Traffic Dashboards), Tableau Public 9.0, Qlik Sense Desktop, JIRA Intake System, DB2

Confidential - Dallas, Texas

Microstratergy Developer

Responsibilities:

  • Involved in requirements gathering by interacting with the Internet Business Users.
  • Created Metadata Repository, Statistical tables and Intelligence Server onMicroStrategy Desktop using the Configuration Wizard.
  • Experienced in troubleshooting Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
  • Worked on T-SQL to write complex queries involving multiple tables to generate a customized report and built ad-hoc reports using SSRS.
  • Created alerts via mail and mobile based on pre-defined events and created ad-hoc reports by drilling up, down and across Hierarchies.
  • Developed OLAP cubes and dimensions using SSAS and also worked on DTSX packages in SSIS.
  • Worked on OLAP/ROLAP Star schema and Snowflake modeling, Fact lookup and Dimensions tables using Erwin
  • Used Object Manager/ Project Merge to manage change management forMicroStrategy objects across different environments like DEV, QA, UAT and PROD.
  • Involved in customization of Grids and Graphs using SDK.
  • Set-up narrowcast environment as administrator to create services using subscription sets, schedules and Information objects.
  • Created complex custom groups using hierarchy to overcome the restriction ofMicroStrategy where total on columns and average on rows cannot be calculated at the same time.
  • Troubleshooting and Performance tuning of the SQL using VLDB properties.
  • Created several Custom tables, Views, Aggregations and Macros for developing reports used inMicroStrategy environment.

Environment: MicroStrategyDesktop 9,MicroStrategy Web,MicroStrategy Administration,MicroStrategy Intelligence Server,MicroStrategy Narrowcast Server, MS SQL Server 2005, Windows Server 2003.

Confidential - Rochester, MN

MicroStrategy Developer

Responsibilities:

  • Gathering requirements from business users and analysts.
  • Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
  • Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
  • Involved with ETL team in fixing complex data modeling issues like slowly changing dimensions and designing physical schema model.
  • Architected the Schema for the project by creating facts, attributes, and hierarchies.
  • Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
  • Created daily, monthly reports and dashboards for iPhone, iPad using MicroStrategy mobile.
  • Dashboard design--Utilized standard templates and added panels.
  • OLAP services & Intelligent cube design for advanced analytics and Trend analysis reporting.
  • Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
  • Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
  • Respond to business users inquires directly to provide technical support and best-practice report consulting.
  • Perform code review and unit, system, regression testing.
  • Involved in Performance tuning of SQL for long running reports.
  • Unit/System Testing & validation of reports using Complex SQL,PL/SQL scripts.
  • Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
  • Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.

Environment: MicroStrategy 9.3, Architect, Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, SSIS, Windows NT.

Confidential, Dallas, TX

MicroStrategy Developer

Responsibilities:

  • Worked as a MicroStrategy developer for the users to support various reporting needs for the business.
  • Involved in gathering business requirements and documenting specifications.
  • Created the Metadata & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Createddrill mapsfor end users to drill down and recover data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Responsible for various administration tasks like Tuning, Caching,specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Report Services), Oracle.

Confidential

Business Intelligence Analyst

Responsibilities:

  • Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
  • Involved in gathering business requirements and documenting specifications.
  • Created the Metadata & Statistic tables for MicroStrategy projects.
  • Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
  • Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
  • Extensively worked on Report Services to create performance dashboard reporting.
  • Createddrill mapsfor end users to drill down and recover data.
  • Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
  • (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
  • Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
  • Worked on Enterprise manager to generate reports in enterprise manager
  • Responsible for various administration tasks like Tuning, Caching,specifying Query Governing Thresholds, and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services).

We'd love your feedback!