Data Analyst Software Development
Resume:
Kajal Sharma
Herndon, VA 20170-5889
+1-571-***-**** ***********@*****.***
linkedin.com/in/kajal-sharma-aa10741b0
Professional Summary:
3+ years of hands-on experience in Manual and Automation Testing, delivering high-quality software with a focus on precision and efficiency.
MS in Information and Technology from Washington University of Science and Technology, Virginia, specializing in data analysis and software development.
Expertise in Functional, UI, Integration, API, Database, and Exploratory Testing, ensuring comprehensive and reliable software releases.
Experienced data analyst with expertise in creating interactive dashboards and visualizations using Power BI and Tableau. Skilled in transforming complex data into actionable insights to support strategic business decisions. • Versatile testing experience across Desktop, Web, and Mobile Applications, enabling cross- platform test coverage and consistent quality assurance.
Proficient in Agile and Waterfall methodologies, collaborating with cross-functional teams to ensure timely project delivery.
Hands-on experience with Duck Creek Technologies and in-depth knowledge of P&C (Property & Casualty) Insurance applications.
Strong ability to analyze requirements and specifications, providing timely and actionable feedback to enhance test cases and scenarios.
Motivated and detail-oriented, with a growing interest in data analysis, including hands-on experience in data collection, cleaning, and basic analysis techniques.
Eager to leverage statistical methods and data visualization tools for future project work.
Excellent communication skills, fostering smooth collaboration with team members to achieve project objectives.
Technical Skills:
Testing Skills Functional/Manual, Database/ETL and API Testing. Programming Languages SQL, Python, C, C++, XML, HTML, Java Scrip Visualization Tools Power Bi, SSRS, Tableau
Microsoft Advance Excel, Access, Word, PowerPoint
DBMS SQL Server, Microsoft SQL Server Management Studio (SSMS). API Testing tools Postman, Swagger
Operating System Windows 10, Linux
Professional Experience:
XCEEDANCE
Quality Analyst L1
Spearheaded the transition from manual processes (including submission creation, financial uploads, and policy creation) to automated workflows using Duck Creek, streamlining operations and improving efficiency for underwriters.
Contributed to BERKSURE’s initiative to fully automate the insurance process, including insurer data selection, clearance checks, database integration, and submission creation via the Duck Creek API, reducing manual effort by 40%.
Led the planning and management of X product releases, ensuring 100% on-time delivery with high quality results and adherence to business requirements.
Provided ongoing production support, implementing system enhancements that led to a 20% improvement in overall process efficiency and business outcomes.
Successfully delivered multiple insurance projects to UAT and production, collaborating closely with cross-functional teams and stakeholders to ensure smooth transitions.
Proficient in database testing by crafting and executing complex SQL queries to validate data integrity and functionality across applications.
Highly experienced in Agile and Waterfall methodologies, driving project success through continuous collaboration and iterative testing.
Led weekly project demonstrations for clients, gathering valuable feedback to refine requirements and align product development with business needs.
Extensive experience in testing across Desktop, Web, and Mobile applications, ensuring consistent performance and functionality across platforms.
Actively participated in UAT testing, working with stakeholders to validate business scenarios and ensure product alignment with user expectations.
Client: Just Energy, Hyderabad
Directed end-to-end software development lifecycle (SDLC) across 10+ enterprise projects, overseeing requirements gathering, system analysis, design, coding, deployment, and user onboarding—resulting in a 25% reduction in project delivery time.
Managed user authentication, roles, and group permissions for over 500 users across Windows NT and MS SQL Server, ensuring 100% compliance with internal and external security audits.
Designed and implemented over 30 logical and physical data models using Erwin, streamlining database architecture and reducing data redundancy by 40%.
Developed and optimized SQL Server databases supporting mission-critical applications, reducing query response time by up to 60% through advanced indexing, stored procedures, and performance tuning.
Automated 50+ recurring processes by configuring SQL Server Agent Jobs and Alerts, improving operational efficiency and enabling 24/7 proactive monitoring.
Built and maintained Linked Server connections to 10+ external data sources using OLE DB, enabling seamless real-time data integration across departments.
Executed comprehensive performance tuning and backup strategies, achieving 99.99% database uptime and cutting restore time by 70% during disaster recovery drills.
Analyzed large-scale pharmaceutical datasets (10M+ records) using SQL Server Analysis Services (SSAS) to generate drug utilization and safety reports, contributing to FDA reporting accuracy.
Designed and deployed 100+ SSRS reports, including complex drill-down and parameterized reports, increasing executive reporting speed and accessibility by 50%. Client: KKEYDOS INFO TECH, Hyderabad, India
Contributed to the design and optimization of high-performance database schemas, supporting analytics for datasets exceeding 10M records. Developed detailed documentation for data models, reports, and ETL workflows, improving onboarding efficiency for new team members by 30%.
Developed and deployed 20+ robust SSIS packages using transformations like Conditional Split and Derived Columns to clean, validate, and stage data prior to warehouse loading—achieving a 95% improvement in data accuracy.
Configured automated alert systems for job monitoring, reducing issue detection time by 80% and ensuring real-time notification for failed executions or performance anomalies.
Generated performance and error diagnostics for SSIS packages, SQL Agent Jobs, stored procedures, and triggers, proactively identifying and resolving issues that improved system reliability by 40%.
Designed and delivered 75+ customized reports in SQL Server Reporting Services (SSRS), including sub-reports, drilldowns, summaries, and parameterized layouts—accelerating report delivery timelines by 50%.
Tuned complex T-SQL queries to enhance report and application performance, using tools such as SQL
Profiler, Index Tuning Wizard, and Query Analyzer, resulting in a 60% reduction in execution times.
Distributed mission-critical SSRS reports to clients, vendors, and senior stakeholders, enabling data driven decisions across finance, operations, and compliance departments.
Created reusable stored procedures and triggers to automate recurring tasks, decreasing manual workloads and reducing error rates by 35%.
Maintained optimal table performance through normalization and strategic indexing; enforced data integrity and security by applying best practices and detailed documentation protocols. Certifications:
Data Warehouse ETL Testing & Data Quality Management.
Selenium WebDriver certification
Manual/Functional QA Testing Certification from Q-Spiders.
International Software Testing Qualifications Board (ISTQB) Certified, 2022.
End to End API Testing.
The Complete SQL Bootcamp.
The Data Analyst- Complete Data Analyst Bootcamp Academic credentials:
MS- IT (Sep2023 to June2025)- 4 GPA
Washington University of Science and Technology, Virginia. B.Tech. - CSE (2018 – 2021)- 7.8 CGPA
State Institute of Engineering and Technology, Karnal, Haryana. [Kurukshetra University]
Contact this candidate