Business Intelligence Data Analyst

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

Results-driven Data Analyst and Business Intelligence (BI) Developer with 14+ years of experience in data analysis, ETL development, and enterprise BI solutions. Proven expertise in designing, developing, and deploying interactive data visualizations using Tableau, MicroStrategy, and Looker Studio. Adept at supporting large scale BI/ETL initiatives, participating in requirements gathering, and translating business needs into scalable technical solutions. Proficient in Python, SQL, and RStudio scripting, with a strong background in data warehousing and performance optimization within various data environments. Professional Experience

Softrams, LLC Leesburg,VA 09/2022 – 04/2025

Senior Systems/Database Analyst

● Supported GSA by integrating Python scripts with SQL stored procedures to automate recurring reports and minimize manual effort.

● Imported, transformed, and validated employee feedback datasets in Tableau to ensure data accuracy and integrity for executive level dashboards.

● Built interactive dashboards in Looker Studio and Tableau to visualize program performance and citizen developer productivity, increasing engagement by 90%.

● Extracted data from AWS using SQL scripting, functions, and procedure development, then loaded it into Tableau for visualization.

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

● Maintained project repositories on GitHub, ensuring version control and consistent documentation throughout the software development lifecycle.

● Experience in process improvement using Agile and Kanban at GSA to manage workflows and track progress for the Customer 360 project, providing regular updates in sprint meetings.

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

● Developed and scheduled Python scripts via cron jobs to automate data workflows. 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.

● Utilized AWS SQL to conduct deep-dive analytics, providing ongoing support to executives and upper management with insights that aligned with business expectations and enhanced their decision-making.

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

● Customized the dashboard for the Customer Service Director by leveraging AWS SQL 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 10/2017–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.

● Gathered, Designed and Developed reports using MicroStrategy BI tool and worked closely with the technical and business team.

● 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) 03/2012-09/2017

● 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 administered data stores, data warehouses, and data marts using MicroStrategy by translating business requirements into technical specifications for design, configuration, and reporting solutions.

● Closely monitored the status of ongoing projects using JIRA, proactively identifying issues and providing the director with timely updates.

Additional Experiences 06/2009-02/2012

Aquilent, Inc. Laurel, MD Business Consultant

● Expertly managed the Veteran Affairs Electronic Contract Management System project, encompassing data warehousing and business intelligence reporting using MicroStrategy to deliver accurate insights, enhance data accessibility, and support informed decision-making. Chevy Chase Bank Bethesda, MD Business Process Improvement

● Served as the primary liaison to the Commercial Department group, collaborating to define new reporting requirements and perform data validation, resulting in improved reporting accuracy, streamlined processes, and enhanced decision-making to support business objectives. 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, AWS SQL, Python, R, Oracle Apex, Microsoft Office, SharePoint, GitHub, JIRA

Education/Certifications

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

Contact this candidate