Business Intelligence Software Development
Resume:
Maheswar Gouni
MicroStrategy Developer
********@*****.***
Summary
Analytics Developer with over 9 years of professional experience working with a diverse set of tools and technologies. Proven expertise in agile methodologies throughout the software development lifecycle, including analysis, design, development, testing, implementation, and post-implementation support, along with Test-Driven Development (TDD) practices. Highly skilled in MicroStrategy (with strong UI/UX skills for data storytelling), Tableau, and Power BI, with a strong focus on delivering impactful and user-centric dashboards and reports to support data-driven decision-making.
Over 9+ years of Data Warehousing experience in MicroStrategy, Tableau,
Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Mobile Development, MicroStrategy Administration, MicroStrategy Narrowcast Server, Transaction Services and OLAP Services Environment.
Working familiarity with full Software Development Life Cycle (SDLC) of Data Warehousing and Business Intelligence projects using various development methodologies like Agile/ Scrum and Waterfall.
Experience in Data Warehousing and Business Intelligence area in various domains.
Hands on experience in implementing dashboards, data visualizations and analytics using Tableau Desktop and Server.
Dedicated team player with strong analytical, presentation, training and project management skills along with excellent communication and interpersonal skills.
Extensive experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
Working closely with the business to gather, review, validate and document the business requirements.
Extensive experience in designing, creating and modifying different Reports.
Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, etc.) from data warehouses including Teradata, Sybase and SQL Server
Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non - geographic data. .Implement ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
Conducted thorough analysis of business requirements to identify key operational needs and recommend improvements.
Gathered and documented functional requirements from stakeholders, ensuring alignment with business goals.
Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Performing Tableau admin activities including user and content management, upgrading the server, performance
Monitoring, and automating activities like backup, restoring contents etc.
Manage end to end complex data migration, conversion, and data modeling (using Alteryx, SQL), and create visualization using tableau to develop high quality dashboards.
Designing the Reports and Dashboards as per client requirement and created the reports using Excel files and different data sources.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and
Tableau desktop report.
Involved in Installation, Configuration, and administration of Tableau Server in a multi-server and multi-tier
environment.
Modified the existing reports and dashboards.
Worked on Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.
Having good experience in Data Modelling and ETL Process.
TECHNICAL SKILLS:
BI Tools: MicroStrategy, Business objects.Tableau (Desktop/ Server/ Reader), Power BI
Data Base: Oracle,SQL Server, Teradata SQL, Excel.
Documentation: SharePoint, Confluence.
ITSM: Jira, ServiceNow
Operating systems Windows, Unix/LINUX
EDUCATION:
Bachelors in Computer Science and Engineering.
Client:
HFS(Health care and family services) Illinois March 2024 – Till date
Role: Data Analyst/Microstrategy
Responsibilities:
Designed and developed Cubes, reports and interactive dashboards to satisfy the users’ functional and performance requirements. Created Level Metrics and Derived Metrics to perform complicated calculations and logic tests using data from multiple database.
Utilized MicroStrategy multisource options to design and develop Cubes and reports to perform complicated data retrieving job from multiple transactional databases. Utilized MicroStrategy data blending features to join data at dashboard level to achieve desired performance and scheduling requirements.
Optimized Cube publishing performance and Dashboard performance to meet the performance requirements by changing the VLDB settings and restructuring the Cubes used for the dashboards.
Assisted in designing and developing MicroStrategy Logic Views as backbones to help retrieving data effectively from multiple transactional databases.
Designed and developed visually compelling MicroStrategy dashboards incorporating UX best practices, resulting in a 30% increase in stakeholder engagement and faster decision-making.
Collaborated with business users to gather requirements and translated them into interactive, user-friendly reports using MicroStrategy's visualizations and guided data storytelling.
Applied UI/UX design principles such as layout optimization, intuitive navigation, and color theory to enhance the usability and aesthetic appeal of MicroStrategy dashboards.
Developed custom widgets and visualizations in MicroStrategy using HTML5, CSS, and JavaScript, tailoring dashboards for improved user experience and storytelling clarity.
Optimized the freeform SQL Codes used to create MicroStrategy Logic Views, and effectively improved the performance by more than 80% in some cases.
Participated in system conversion discovery and conversion implementation schedule
Created complex T-SQL based data extracts for the following GE Centricity Enterprise and Allscripts Touchworks subject areas - Patient (encounters, active problems, histories (medical, social history, smoking), procedures, lab annotations, orders and results, point of care results, transcriptions, referrals, diagnosis, and appointments).
Documented a process used to load the raw database, transform the data, populate the staging database, and transmit the Hl7 data from the Mirth Connect HL7 interface engine to the Epic Bridges HL7 interface engine.
Assisted in the creation of the Raw and Staging Databases.
USED T-SQL and SSIS to extract source system data and populate the raw and staging databases.
Performed HL7 error troubleshooting
Created validation scripts used to verify patient records for both small scale (30-50 records), and large scale ( records) testing.
Created data element translation mappings from source system to Epic target systems.
Responsible for analyzing and evaluating the criticality of issues and making decisions as to the appropriate level of escalation.
Organized Functional Design Documents (FDD) handoff meetings with the Business and technical team, explaining them the requirements, review the Functional Designs and getting a formal signoff.
Assured standardization of policies, procedures, workflows, in accordance with the organization's approved EHR practices.
Knowledge of medical terminology, and procedure codes, pricing, and provider contracts
Experience working with transactional databases and data warehouses.
Environment: Teradata Sql, Oracle sql.
Client: Citibank (Tampa, Florida)
Role: MicroStrategy Developer / Tableau October 2017- Feb 2024
Responsibilities:
Served as Primary Micro Strategy developer for the full lifecycle of the data warehousing project from requirement gathering from business analysts to rollout.
Designed and developed Dashboards using MicroStrategy Report Service Documents for various products and services in Insurance Service Group.
As per business requirement, Designed developed and maintained MicroStrategy based reports.
Created Enterprise Manager Reports for various analyses.
Administration of ASKIG project including maintenance and User Management.
Configuration of Narrowcast server and Involved in various Narrowcast tasks like creating Documents, service designs, subscription, administration and scheduling.
Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
Manipulated attribute and attribute forms properties to enforce right table joins.
Experience on UI and UX skills
Solid UI and UX skills, with experience building web and/or mobile interfaces for displaying interactive visual insights
Using Object Manager to move the reports from Development Project to QA/Production Project.
Created ad-hoc reports by drilling up, down, within and across Hierarchies.
Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics
Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
Environment: MicroStrategy 9.0.1/8.x (Desktop, Architect, Report Services Document, Web, Narrowcast Server), DTS, SQL Server 2000, Teradata, Windows.\
Built, mapped and deployed various objects like facts, metrics, filters, prompts and searches. Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
Worked on complex data models like Many to Many relationship mappings and maintaining Sparse data population as well.
Managed projects through entire systems development life cycle, including creating timely thorough status reports and leading status meetings.
Worked extensively with the users explaining them the mere differences between the web developed dashboards and mobile dashboards and acquiring the requirements accordingly with respect to the mobile development
Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
Involved in conducting training to users on interacting, filtering, sort and customize views on an existing visualization generated thru Tableau desktop.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
Created Tableau scorecards, dashboards, Heat maps using show me functionality.
Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
Published Reports, workbooks & data source to server and exporting the reports in different Formats.
Experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
Client: Yotta Systems( Nutley, New Jersy) May 2015 – Sep 2017
Role: MicroStrategy Developer
Responsibilities:
Performed reverse engineering to decode QlikView reports into hand-crafted SQL code by
Analyzing each report and documenting the specifications
Accountable for all phases of development process—analysis, design, development, testing and
implementation.
Involved in creating/replicating reports in MicroStrategy based on existing QlikView Reports.
Worked with data modelers and DBAs to ensure functional and non-functional requirements,
implemented properly.
Created MicroStrategy schema and public objects: metrics, filters, prompts, consolidations,
custom groups, facts, attributes, transformations, and hierarchies.
Developed standard reports, Freeform SQL reports and Ad-Hoc Reports (Visual Insights Analysis)
using MicroStrategy Developer/Web.
Created advanced Dashboards with panel stacks, selectors, information windows, complicated.
grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash
and Interactive modes.
Created Transaction Services enabled documents to write back to source data based on analysis.
by business users.
Involved in creating migration packages and deploying them into other environments like UAT
and PROD using object manager.
Performed various admin related tasks using tools like Object Manager, Integrity Manager, and
Command Manager.
Created configuration objects like Security Roles, Database Instances, Schedules and
Subscriptions.
Analyzed and developed partitioning and indexing strategies for performance tuning of
MicroStrategy reports and used intelligent cubes for faster query performance using memory.
cache.
Used Command Manager to automate the whole MicroStrategy administrative tasks including,
purge cache, user management, and trigger reports according to event load.
Troubleshooting MicroStrategy issues by analyzing DSS Error log files.
Involved in various back end ETL development tasks, UAT testing and Production Support.
Environment: MicroStrategy 9.4.1 (Developer, Administrator, Web, Enterprise Manager, Command
Manager, Object Manager), Oracle, Sybase, QlikView
Contact this candidate