Business Intelligence Technical Support

Shilpa Khanna

Rockville, MD 240-***-**** **********@*****.***

Solutions-focused, innovative, and hands-on professional with extensive experience in administering web-based software and system development using MicroStrategy, Tableau, and Looker Studio as business intelligence tools. Skilled in data warehouse code development, testing, architectural deployment, and technical support, with a proven ability to collaborate across teams to deliver scalable reporting solutions and actionable business insights. Professional Experience

Softrams, LLC Leesburg,VA 09/2022 – Present

Senior Systems/Database Analyst

● Leading support for the GSA team as a federal contractor, specializing in developing complex, customized report dashboards, ensuring data quality, validating report prototypes, and providing advanced Tableau training. This expertise contributes to a 60% improvement in reporting efficiency and data accuracy.

● Contribute to the project using JIRA, centralizing data from multiple platforms into AWS RedShift SQL.

● Collaborate with cross-functional teams to successfully complete the development phase and create interactive data visualizations using Looker Studio, resulting in a 90% refinement in reporting efficiency and enhanced data insights to support business decisions.

● Integrated Snowflake with MSTR to enhance data processing and analytics capabilities.

● Designed and implemented ETL pipelines using SQL and Python to process large datasets for GSA.

● Implement data quality checks using R to verify data accuracy and consistency between Tableau reports and source SQL datasets.

● Developed a forecasting predictive model using MicroStrategy and Python to enhance business decision-making. Resulting in a 50% increase in forecast accuracy and enabling data-driven strategies.

● Applied time series analysis, regression, and machine learning algorithms to enhance forecasting accuracy. Karsun Solutions Herndon, VA 02/2019 – 08/2022 Systems/Database Analyst

● Optimized Business Dashboard processes under the GSA federal contract using MicroStrategy, enhancing efficiency and achieving an 80% improvement in response times for end users.

● Provided ongoing support to executives and upper management by conducting deep-dive analytics and delivering insights aligned with business expectations, enhancing the decision-making process.

● Developed and improved existing MS Excel reports using MicroStrategy while administering new and existing applications.

● Automated the reporting process to enable detailed analysis of expiring contracts, delivering forward-looking contract information that assists customers in the re-procurement decision-making process, resulting in improved efficiency and data accuracy.

● Performed latency testing for reports using UAT scripts, identifying and resolving performance issues, resulting in an 85% boost.

● Customized the dashboard for the Customer Service Director by leveraging Redshift to pull data for enhanced reporting accuracy. Utilized MicroStrategy to enable transaction services, allowing data-write back to the system and improving operational efficiency. Department of Housing & Urban Development (HUD) Washington, DC 03/2012–02/2019 MIS (Management Information Specialist)

● As a federal employee, contributed to a project at HUD utilizing Oracle APEX to create, validate, and test reports.

● Gained a deep understanding of data warehouse architecture and business rules while developing new and improved logic for the schema, resulting in enhanced data accuracy and streamlined business processes to support financial decision-making.

● Gather, Design and Develop reports using MicroStrategy BI tool and work closely with the technical and business team.

● Provide user support in response to report issues and other administrator related to MicroStrategy.

● Initiated user acceptance regression testing for automated test scripts using Jenkins, significantly reducing change requests and minimizing costs by improving testing accuracy and efficiency, resulting in a 50% enhancement in continuous integration.

Formerly Contractor Supporting HUD (various contracting companies)

● Delivered data analytics and business intelligence solutions to HUD as a federal contractor with Cloud Nine Technologies, Powertek Corporation, and Shiva Information Technology Services, Inc., providing technical support and expertise.

● Extensive experience in developing simple to complex Oracle SQL queries to extract, manipulate, and calculate data, fulfilling data and ad hoc reporting requirements. Skilled in identifying relevant tables and columns to support software application development and business needs.

● Participated in the system development life cycle, including analyzing business requirements, developing technical specifications, planning test implementations, and performing quality assurance to ensure alignment with business needs and system functionality.

● Efficiently administer data stores, data warehouses, and data marts using MicroStrategy by translating business requirements into technical specifications for design, configuration, and reporting solutions.

● Acted as primary liaison between the contractor and contracting officer to ensure proper coordination of communication and flow of information.

● Closely monitored the status of ongoing projects using JIRA, proactively identifying issues and providing the director with timely updates. Delivered recommended processes, software, and system solutions to address problems and align with business needs, resulting in optimized project outcomes and improved operational efficiency.

Additional Experiences:

Aquilent, Inc. Laurel, MD Business Consultant

● Led the Veterans Affairs project as a federal contractor, leveraging data warehousing and MicroStrategy for business intelligence reporting to enhance data accessibility, deliver accurate insights, and support informed decision-making.

● Administered and defined requirements to develop web-based reports using MicroStrategy BI tool, collaborating with stakeholders to deliver customized solutions that enhanced data accessibility and improved reporting performance and efficiency.

● Previously worked in business process improvement in the mortgage industry at Chevy Chase Bank, optimizing workflows and enhancing operational efficiency. Core Competencies

Data Analysis, Forecasting, Cross-functional with team, Team Building, Team Training, Client relations and presentations, Business Process Management

Technical Skills

Tableau, MicroStrategy, Looker Studio, SQL, Python, R, Oracle Apex, Microsoft Office, Qlik, Azure Education/Certifications

Bachelor of Science Information systems, University of Maryland SAFe 5 Practitioner, 2022

Contact this candidate