We provide IT Staff Augmentation Services!

Sr. Software Engineer Resume

Charlotte, NC

SUMMARY

  • 10+ years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting, dashboard and Administration.
  • Professional experience in Design, Development, and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 10.4/10.2/9.5/9.4/9.3.1/9.2.1.
  • Certified MicroStrategy Developer (CPD)
  • Administered MicroStrategy environments and formulated end user group
  • Managed backup involving Metadata, Supervised statement delivery and proven project schemas
  • Experience with all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Dashboard, MicroStrategy Narrowcast Server, and MicroStrategy Desktop.
  • Experience in MSTR Application Testing.
  • Build MicroStrategy architect by using RDBMS database as project source.
  • Experienced in creating Ad - Hoc report by using Visual Insight.
  • Participated in the Full Life Cycle Development (FLCD) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
  • Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
  • Excellent problem-solving skills with a strong technical background and good interpersonal skills. Self-motivated and enjoy working in a technically Challenging environment. Quick learner and excellent team player with the ability to meet tight deadlines and work under pressure.
  • Strong knowledge of Relational Database Design, Data Warehouse/OLAP concepts, and methodologies.
  • Proven troubleshooting capabilities with MicroStrategy Desktop.
  • Worked extensively with Oracle, Teradata, and SQL Server with MicroStrategy Suite.
  • Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategy configuration, reports, and other output.
  • Excellent problem-solving skills with strong technical background and good interpersonal skills.
  • Quick learner and excellent team player, ability to meet deadlines and work under pressure.
  • Performed the role of team member/developer dedicatedly.

TECHNICAL SKILLS

Business Intelligence: MicroStrategy 10.4/10.2/9.4.1/9.3.1/9.2.1 , MicroStrategy Developer, Visual Insight, Mobile, Intelligence Server, Cubes, Object Manager, System Manager, Enterprise Manager, Report Services, Distribution Services, Tableau

RDBMS: Oracle 10g, Teradata, Sql Server

Operating Systems: Windows 98, XP, Unix/Linux, Mainframe

PROFESSIONAL EXPERIENCE

Sr. Software Engineer

Confidential, Charlotte, NC

Responsibilities:

  • Worked as a MicroStrategy Architect/ analyst for design and development.
  • Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support.
  • Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
  • Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
  • Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
  • Worked extensively with the End Users to finalize the dashboard layouts and worked on fine detail formatting for a desired look and feel.
  • Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Performing all the administration tasks like Monitoring, Performance Tuning and Analyzing the system usage and managing the projects. Moreover, using the Command Manager to purge the caches on database loads.
  • Involved in the troubleshooting and performance tuning of the report using VLDB properties.
  • Developed reports for MicroStrategy Web users.
  • Understanding the MicroStrategy Reporting environment of the organization.
  • Understanding the Data model and identifying the tables to be used for reports.
  • Developed Report Services dashboards, documented, and formatted the reports.
  • Responsible for monitoring schedules for the database triggers on daily bases

Environment: MicroStrategy 10.4/10.2/9.2 (Architect, Desktop, Object manager, Enterprise Manager, Dynamic Dashboard, Report Services), SQL Server

Project lead

Confidential, Nashville, TN

Responsibilities:

  • Interacting with customer on daily basis and providing valuable suggestions and freezing the requirements
  • Created Microstrategy Schema objects such as attributes, tables, Hierarchies and facts using Microstrategy Architect.
  • Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Grid form of reports.
  • Created Transformations (table based, formula based) for using in comparative reports like year to date and month to date.
  • Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
  • For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
  • Gone through various levels of dimensionalities to execute the reports with different result sets.
  • Implemented OLAP cubes functionality in Query performance.
  • Worked on Drill map editors, Hierarchy relations, and pass through functions for complex reports.
  • Performed the Administration tasks like tuning, caching, specifying Query Governing Thresholds and Report Optimizations.
  • Developed reports for MicroStrategy Web users.
  • Understanding the MicroStrategy Reporting environment of the organization.
  • Understanding the Data model and identifying the tables to be used for reports.
  • Developed Report Services dashboards, documented, and formatted the reports.
  • Responsible for monitoring schedules for the database triggers on daily bases.
  • Co-ordinate to off shore team and evaluate offshore work.
  • Unit testing of the created reports
  • Preparing the mapping document for dashboard and report
  • Create a template for the dashboard & auto style for report
  • Involved in MicroStrategy upgrade from 9.4.1. To 10.2.

Environment: MicroStrategy 10.2/10.2/9.4.1 , (Desktop, Web, Object Manager, Enterprise Manager, Distribution server, Office, Report Services), Windows XP, Teradata

Project lead

Confidential

Responsibilities:

  • Interacting with customer on daily basis and providing valuable suggestions and freezing the requirements
  • Created Microstrategy Schema objects such as attributes, tables, Hierarchies and facts using Microstartegy Architect.
  • Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Grid form of reports.
  • Created Transformations (table based, formula based) for using in comparative reports like year to date and month to date.
  • Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
  • For tuning Business Intelligence System used Object Manager, and Enterprise manager tools in MicroStrategy.
  • Gone through various levels of dimensionalities to execute the reports with different result sets.
  • Implemented OLAP cubes functionality in Query performance.
  • Worked on Drill map editors, Hierarchy relations, and pass through functions for complex reports.
  • Performed the Administration tasks like caching, specifying Query Governing Thresholds and Report Optimizations.
  • Developed reports for MicroStrategy Web users.
  • Understanding the MicroStrategy Reporting environment of the organization.
  • Understanding the Data model and identifying the tables to be used for reports.
  • Developed Report Services dashboards, documented, and formatted the reports.
  • Monitoring the schedules for the database triggers sometimes on daily bases.

Environment: MicroStrategy 9.0.2 (Desktop, Web, Object Manager, Enterprise Manager, Office, Report Services), Oracle 10g, Windows XP

Programmer analysist

Confidential

Responsibilities:

  • Gather report requirements and creating reports using Micro Strategy 9.0.2
  • Gather dashboard requirements and developing interactive dashboards using Micro Strategy
  • Co-ordination with the Business Analyst and understanding the Business requirements
  • Identifying different source tables and columns required to create a MicroStrategy project.
  • Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graph and Grid form of reports.
  • Involved in administrative works creating users, security filters, trigger database events and time-based events.
  • Preparing dashboard design document & create template for Dashboard
  • Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
  • Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
  • Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements
  • Designing and developing of Dashboard with the dataset created.
  • Creation of the mht file and Delivery of the Dashboard.
  • Creation of .rst, Implementing Layout concept in the Dashboard.
  • Implementing customized widget in the Dashboard
  • Created standard and ad-hoc reports.

Environment: MicroStrategy 9.0.2 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web), Oracle 10g, Win XP

Software developer

Confidential

Responsibilities:

  • Gather report requirements and create reports using MicroStrategy 8
  • Co-ordination with the Business Analyst and understanding the Business requirements
  • Identifying different source tables and columns required to create a MicroStrategy project.
  • Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graph and Grid form of reports.
  • Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
  • Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
  • Creating and modifying Schema Objects and Public Objects to enable reporting on new and changed data elements
  • Build and thoroughly test reporting changes and enhancements, understand data validation requirements as appropriate.
  • Perform all aspects of software quality assurance/testing applications.

Environment: MicroStrategy 8 (MicroStrategy Reporting Services, MicroStrategy Office, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web), Oracle 10g, Windows XP

Hire Now