Shipra Sharma
Houston,TX
Summary
Detail-oriented data analyst with expertise in data visualization and modeling. Proficient in Power BI and Tableau for creating interactive dashboards. Strong analytical problem-solving skills combined with experience in cross-functional collaboration to deliver actionable insights that drive strategic business outcomes. Proven track record in analyzing large multi-source datasets and developing SQL-driven reports to identify utilization and cost trends.
Overview
1
1
Certification
6
6
years of professional experience
Work History
Power BI Developer
Verizon
Houston, Texas
01.2024 - Current
- Developed Power BI reports utilizing advanced analysis techniques, including filters, to support data-driven decision-making.
- Created visualization reports and dashboards using histograms, filled maps, bar charts, line charts, tree maps, and stacked bars to enhance data insights.
- Enabled drill options such as drill down, drill up, merged dimensions, filters, and bookmarks to improve user interaction and efficiency in dashboards.
- Used multiple data sources from excel, CSV, text files and built interactive dashboards.
- Developed and demonstrated the ease of use in working with Hierarchies in dashboard to end users and power users with effective usage of Drill up/Drill down options.
- Compiled reports on bookings and pipeline data for various Cisco products.
- Environment: Power BI, Microsoft SQL Server 2014, Microsoft Excel 2012, Microsoft office 2012.
Data Analyst
Waddell & Reid
Mission, KS
07.2021 - 11.2023
- Collaborated with Sungard's InvestOne team to extract data from mainframe to datalink XML files, identifying FOMI codes and calculations for ODS design.
- Designed and maintained Physical and Logical Data Models for Operational Data Store for Invest One using Erwin and SQL server and built different views for various business teams.
- Developed, published, and maintained data dictionary and metadata, supporting the establishment and adherence to data standards.
- Extensively used SQL for Data Analysis and to understand and document the data behavior.
- Reversed engineered existing databases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
- Retrieved data, reviewed, prepared/transformed and loaded client data from various sources and datalink xml files into Invest One ODS using ETL Informatica and SSIS.
- Conducted data profiling and analysis using Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ), ensuring accuracy of data utilized in ODS consumer reports and queries.
- Collected requirements for ETL developers and documented data processes by creating data mapping documents and T-SQL queries.
- Analyze existing mainframe programs to identify business rules and create specification and mapping documents for migration.
- Client: DXC Technology, India
- Role: Business Analyst – P& C Insurance
Business Analyst – P& C Insurance
01.2021 - 06.2021
- Produced functional and non-functional requirement documents by collaborating with business partners, project managers, legal counsel and other team members. Updated current documentation upon change analysis.
- Interacted with business and cross-functional users on a weekly basis to gather the requirements, followed the Agile software development cycle.
- Execute gap analysis, finalize and prioritize requirements creating product backlog to increase performance rate to 80%.
- Performed analysis and presented results using SQL and MS Excel.
- Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.
- Utilized advanced MS Excel using VLOOKUP, Pivot Tables, Formula Functions while managing the data provided by NCCI for rate implementation.
- Performed data validations to ensure the data quality standards are being met by 100% accuracy.
- Built test plans and test matrix to ensure delivery of a quality product.
- Conducted system testing, regression testing, integration testing, patch testing, release or deployment testing, and user acceptance testing of the system.
- Approved technical deliverables during user acceptance testing across multiple environments, ensuring alignment with business requirements.
- SME for the development team on product enhancements to Workers Compensation and Employers Liability Insurance products.
- Acted as Subject Matter Expert, updating management team on project status throughout development, quality assurance, and user acceptance testing phases.
Education
MBA - Human Resources Management
DAVV
Indore (M.P)Skills
- Data visualization tools
- Data visualization techniques
- Database management: T-SQL PostgreSQL MySQL Snowflake BigQueryData warehousing
- Programming languages: Python, R
- Data modeling
- Cloud platforms: Azure
- Data governance
- Agile methodologies
- Cross-functional collaboration
Certification
- Azure Fundamentals
Timeline
Power BI Developer
Verizon
01.2024 - Current
Data Analyst
Waddell & Reid
07.2021 - 11.2023
Business Analyst – P& C Insurance
01.2021 - 06.2021
MBA - Human Resources Management
DAVV