Noopur Varshney
West Windsor,US
Summary
Principal Data Engineer with 15+ years of extensive experience in developing comprehensive data solutions, including ETL/ELT, reporting, and analytics. Expertise in constructing data pipelines, data modeling, and data architecture, complemented by strong SQL proficiency. Proven ability to design scalable data solutions that improve analytics capabilities. Skilled in leading cross-functional teams and mentoring professionals to drive impactful data-driven decision-making. Specialize in SQL optimization, data modeling, and cloud-based database management systems. Excel in problem-solving, teamwork, and adaptability, ensuring smooth collaboration and innovative solutions in fast-paced environments.
Overview
17
17
years of professional experience
1
1
Certificate
Work History
Principal Database Engineer/Technical Lead
International SOS
Blue Bell, US
01.2025 - Current
- Design scalable, reliable data solutions that transform raw data into actionable insights.
- Collaborate with cross-functional teams to build end-to-end data platforms that support reporting, analytics, and business decision-making.
- Lead the project for Data Purge including the responsibilities like Design, Document and Lead the team for a user friendly robust Solution.
- Delivered pipeline to load data from Pendo, decrypt PII data, and load into data warehouse for generating meaningful insights.
- Developed data pipelines, data models, and architecture for travel and profile-related data at International SOS, enhancing analytics capabilities.
- AI driven development using Cursor and Copilot for 2x productivity.
- Lead and mentor Onsite and Offshore team.
- Technologies: AWS Technologies, Glue Job, Lambda, DynamoDB, Redshift, QuickSuite, PostgreSQL, SQL Server, PySpark, Python, Power BI, Microsoft Fabric, SSIS, JIRA, Confluence, PowerShell, Microsoft Office Suite, Mercurial Hg, SourceTree, Visual Studio, Roundhouse.
Consultant
Kforce Inc.
Tampa, US
04.2019 - 12.2024
- Software Development including Database and Application design / database modeling following Best Practices and Patterns.
- Data Analysis and Visualization for various projects currently involved in.
- Mentoring and training other team members and managing resources to support client’s business needs.
- Supported iterative improvements to code base and applications, aligning with evolving business requirements to enhance functionality.
- Oversaw release management and code repository administration, facilitating timely deployment of software updates to ensure system reliability.
- Reviewing changes and working with the team to follow good design patterns and best practices.
- Performed ETL tasks using SSIS Control Flow, Data Flow and various Sources and Transformations to use the information on reporting.
- Performance Tuning of Stored Procedures, Functions and Scripts in SQL using SQL Server Profiler, estimated and Actual Execution plans for enhancing the Report Performance.
- Troubleshooting and resolution of database, ETL and Reporting problems.
- Interacted with relevant business stakeholders to clarify changes and new implementations.
- Conducted performance tuning using SQL Server Profiler, Performance Monitor, and Database Tuning Advisor, optimizing database efficiency for improved application performance.
- Performed optimization of Transact SQL queries and oversaw index management to enhance database efficiency.
- Application development using Microsoft .Net/C# Technologies.
- Performing Unit Testing, Regression Testing and involvement in User Acceptance testing.
- Implementation of Data Science technologies on different projects.
- Technologies: Same as International SOS
Database Engineer
NeoTech Solutions
South Plainfield, US
10.2014 - 07.2018
- Delivered database consulting services to clients.
- To manage the T-SQL database objects, including Tables, Procedures, Functions, Views, etc. Process includes managing DVCS repositories, reviewing changes and working with the team to follow good design patterns and best practices.
- Tune Overall System Performance as well as Database Performance and to monitor database performance in production and through regular application testing using a variety of tools. The results are reviewed and any potential issues diagnosed, tested and repaired before the next release.
- SSIS Package Development and performance tuning.
- Managed and created database indexes to optimize query performance.
- Creation and management of schema objects such as Tables, Views, Clustered & Non Clustered Indexes and Triggers to support the front end application and reports.
- Coordinated with development, DBA, and service desk teams to resolve critical and major issues promptly.
- Executed and monitored standards for data warehouse design, development, and documentation to ensure data integrity and accessibility.
- Mentoring and providing training to other resources on new technology features.
- Performed Unit Testing, Regression & System Integration Testing & supported during User Acceptance testing.
- Using Distributed Version Control system for code sharing and deployment like Mercurial hg, Source Tree.
- Technologies: SQL Server 2008 R2, 2014, SSMS, SSIS 2014, VBA, VBScript, JIRA, SAP Business Objects, SharePoint, Confluence, PowerShell, Microsoft Office Suite, Access, Excel and Agile Central, Mercurial Hg, Source Tree, Roundhouse.
Software Engineer/SQL Developer
United Health Group (UHG)
Noida, India
09.2012 - 11.2013
- Analysis and collection of requirements, direct interaction with prospective clients to gather their analytical and visual requirements and to help them to finalize the requirements.
- Used Package Variables for dynamic configurations and also involved in Error tracing.
- Created fact and dimension tables, populating data from Active Directory to support reporting needs.
- Created and altered Stored Procedures, Functions, and Scripts to facilitate the reporting needs of the Optum users using advanced TSQL features.
- Design, development, testing of complex & custom reports created using Drill Down, Parameters, Formula Fields, Selection Formulas, Charts, Grouping, Summarizing, Sorting & Pivoting in Crystal Reports XI and SSRS.
- Created Excel reports using VBA forms and macros to meet user business requirements.
- Customized reports for output in PDF, Word, and Excel formats to enhance usability for Optum users.
- Handled deployment, scheduling, administration of reports and user management tasks for authenticating and adding users of GCS application using Central Management Console (CMC) and Infoview.
- Facilitated communication between onsite and offshore teams to ensure alignment on database and reporting tasks.
- Created documentation of automation processes and BO server configurations to enhance team understanding.
- Worked as Knowledge Champion, responsible for the Audit of Analytical reporting Project and served as the point of contact for Quality team of UHG.
- Technologies: SQL Server 2008 R2, SSIS, SSRS, SSAS Business Objects Enterprise XI, 3.1, Crystal Reports, CMS, CMC, InfoView, Sharepoint,.Net, Visio, MS Excel, Word, HPSM, Visual Studio, TFS, VSS, SAS,VBA.
Tech Analysis Sr. Associate
Dell Services
Noida, India
03.2010 - 08.2012
- Development, testing and tuning of SSIS packages for various ETL processes to transform data into meaningful decision making information for higher financial authority of Tenet.
- Created SSRS reports and developed ASP.Net interface for user-defined report viewing.
- Performance tuning of queries used to fetch reports on the application.
- Writing Stored procedures, views, functions and various scripts using TSQL advanced features, using User Defined Functions (UDF), Table Valued Functions, CTEs, Table variables, Temp Tables.
- Analyzed and resolved issues in real-time, ensuring no impact on application data.
- Implemented database modifications in response to service requests, enhancing system functionality.
- Requirement analysis and documentation.
- Used looping (For Each, For Each Loop, Sequence), logging and error flow redirection to iterate control flow to fetch data from several data files or sources.
- Creation of a utility developed using C#.Net for automating the process of checking daily files coming from mainframe systems.
- Provided production support and managed incidents effectively.
- Executed timely escalations of the issues so as to minimize the downtime of the application.
- Technologies: SQL Server 2008 R2, SSIS, SSRS, Visual Studio 2008/2010, C#, ASP.Net, Argent Job Scheduler, MS Excel, Word, HPSM, TFS, VSS, VB Script.
Trainee and Developer
PC Solutions Pvt. Ltd.
New Delhi, India
06.2009 - 03.2010
- Completed a year as a Trainee and advanced to Developer.
- Developed and designed various modules of VTS using ASP.Net and JavaScript.
- Documented VTS modules and reviewed peer documents to ensure accuracy and completeness before release.
- Requirement gathering and presenting demos to the client at Initial Stage.
- Designed Data Flow diagrams using VISIO to show the flow of the application.
- Developed MDI and child forms for both web and desktop versions of the VTS application.
- Designed and implemented CSS stylesheets to ensure uniformity across all three modules of the application.
- Creation of SQL Stored Procedures, Views, Functions and Scripts for various tasks of VTS application.
- Performed performance tuning to enhance code efficiency and application responsiveness.
- Technologies: SQL Server 2005/2008, C#.Net, JavaScript, Visual Studio 2005/2008, Java, Visio, Excel.
Education
Bachelor of Technology - Computer Science & Engineering
Uttar Pradesh Technical University
UP, India06-2009
Skills
- SQL, T-SQL, and PostgreSQL
- AWS cloud technologies and DynamoDB
- Redshift and data warehousing
- Data modeling and architecture
- Power BI, Microsoft Fabric, and MSBI
- Pendo Analytics
- Tableau and Business Objects
- Crystal Reports and reporting tools
- C#, ASPNET, and Java
- VBA and Python programming
- Visio and Visual Studio
- SourceTree, TFS, and VSS
- JIRA for project management
- Data documentation and maintenance
- Application support and troubleshooting
- Medical insurance knowledge
- Data governance strategies
- ETL processes and big data analytics
Certification
- Microsoft Certified Technology Specialist- Microsoft SQL Server 2008, Database Development
- Microsoft Certified Professional- Microsoft .NET Framework Application Development Foundation
- ITIL (Information Technology Infrastructure Library) V3 certified
- Up & Running with Tableau
Timeline
Principal Database Engineer/Technical Lead
International SOS
01.2025 - Current
Consultant
Kforce Inc.
04.2019 - 12.2024
Database Engineer
NeoTech Solutions
10.2014 - 07.2018
Software Engineer/SQL Developer
United Health Group (UHG)
09.2012 - 11.2013
Tech Analysis Sr. Associate
Dell Services
03.2010 - 08.2012
Trainee and Developer
PC Solutions Pvt. Ltd.
06.2009 - 03.2010
Bachelor of Technology - Computer Science & Engineering
Uttar Pradesh Technical University
Awards
- Worked on automation tasks and appreciated by various Clients for facilitating data analysis needs and sending in time proactive notifications of issues.
- Received accolades for coordination and helping orchestrate the timely delivery of various critical projects.
- Received appreciation for being the Knowledge Champion and getting highest Compliance Score in Audit for the project Analytical Reporting across the vertical in UHG.
- Organized STRIVE the Quality Event at organizational level with Quality Control Team of UnitedHealth Group.
- Organized and Anchored many events and programs including Corporate Social Responsibility program, UCARE in UnitedHealth Group.
- Received Dell’s Shining Star 2010 award for optimizing a SQL Script by removing Cursors, applying CTE, Table Variables and reducing execution time from 3 hours to few seconds.
- Received Dell’s On the Spot Award for receiving appreciation from client and for automating the process.
- Rewarded First prize by Dell Services Delivery Winning Culture Team in a Team Engagement Program.