DEBROOP SARKAR
Redmond,WA
Summary
Highly experienced Data and Business Intelligence Engineer interested in further growing in the field of Data Science.
Overview
15
15
years of professional experience
Work History
Senior Data and Business Intelligence Engineer
THE EVERETT CLINIC Optum UHG
09.2020 - 04.2023
- Developing and Enhancing ETL processes using SSIS for a wide variety of sources
- Ensuring data integrity and accuracy across multiple applications and environments
- Assisting in ad-hoc tasks including some in the area of producing SSRS reports
- Maintaining annual compliance on HIPAA/Privacy/Confidentiality/Non-Discrimination/Harassment/Integrity Statement and Signs Agreements
- Improving operational efficiency by implementing lean principles and practices for ETL and Data analytics
- Monitoring production processes on a rotational basis using Active Batch Admin
- Reporting to Director of Advanced Analytics in addressing all of the above-mentioned duties
- Assisting and providing knowledge base for teammates, when necessary, with their projects that incorporate my existing work
- Collaborating with team mates and seeking knowledge of the same to achieve task goals and sprint deadlines
- Successfully completing more than 75 major projects taking full ownership of them from start to finish.
Senior Data Analyst Contractor
MICROSOFT CORPORATION
04.2020 - 07.2020
- Developed and analyzed quality Net Promoter Score determination validation for xCloud
- Assisted in Next Generation Privacy tagging compliance
- Developed scripts for testing Net Promoter Score using Black box approach.
Analyst/Developer III Contractor
FRONTIER COMMUNICATIONS
09.2019 - 01.2020
- Feature Development: Developed deletion scripts to simulate ETL processes for data separation and associated control reports using SQL and T-SQL procedures for 7 different applications
- Used Git for version control
- Execution and Testing: Ensured that code is exercised in an automated way that ensures consistent quality
- DevOps Functions: Worked with the operations team to support our deployment process
- Mentoring: Provided code reviews, training, and paired programming to other members of the team.
Test Data Analyst/Manager Contractor
PACCAR
04.2019 - 08.2019
- Determined system data requirements by analyzing data models and ERDs
- Reverse engineered entity relationship diagrams based on inspection of deployed tables
- Proposed data model based on analysis of related spreadsheet data
- Drove ETL efforts from tables in SQL
- Wrote queries to retrieve data based on test criteria for test teams
- Supported and managed test data requests for two QA teams
- Developed user story-based table maps for efficient test data preparation
- Helped Business with technical understanding of data models
- Managed test data integrity for three different environments.
Software Test Engineer Analyst/UAT Contractor
T-MOBILE
04.2018 - 01.2019
- Tested and analyzed all the commissions to internal T-Mobile employees through their retail stores, customer care for existing customers, and business to business channels
- Designed scripts/ take requirements for testing
- Coordinated with EIT and business units.
SQL BI Software Developer Contractor
MICROSOFT CORPORATION
10.2017 - 01.2018
- Planned, designed: Development, Test, Maintenance systems and supported operations as related to line of business applications for enterprise products and services
- Delivered sprint work as defined by product backlog and prioritized by engineering leadership
- Carried out Code Reviews, Enhancements, and Maintenance, Testing and bug-fix activities on an on-going basis developing on SQL Server T-SQL, SSIS, and Analysis Services
- Utilized Azure Data Factory for pipeline development and maintained existing ones for the Azure Insights team.
ETL Developer II
PARK PLACE TECHNOLOGIES
04.2016 - 05.2017
- Interpreted requirements with the business
- Developed ETL packages
- Documented all of the design and development artifacts
- Designed, implemented and delivered reports based on business requirements
- QA tested all work completed on my own as well as other team members
- Contributed to existing in-house data portal by doing ad hoc development using C#HTML code
- Troubleshooted and supported all BI related production processing
- Identified, documented and implemented data validation rules
- Wrote scripts for automated testing of data in the target facts and dimensions
- Collaborated with the business users, other data services team members and other developers throughout the organization to help everyone understand issues that impact the data warehouse.
SSIS Developer Contractor
CVS CAREMARK/CVS HEALTH
06.2015 - 12.2015
- Designed, coded, tested, debugged and documented database solutions to business problems
- Researched and analyzed data to meet business needs
- Researched and formulated solutions to deal with production issues
- Researched how systems are used and looked at ways to improve use and efficiency
- Participated in project management related to development efforts
- Designed database solutions / technical requirements from business requirements
- Worked with IT and business to understand requirements
- Created databases, tables, views, triggers, indexes, constraints, stored procedures and SSIS packages from technical and business requirements
- Managed technical project resources and work resource workloads
- Ensured technical development meets timelines and communicates timely any delays
- Developed and maintained ETL package that handled Medicare enrollment system.
SQL BI Developer Contractor
THE GARLAND COMPANY
07.2014 - 11.2014
- Improved analytic capabilities of the team by enhancing the data warehouse/mart
- Used SSIS to automate processes in order to improve processes that enhanced data quality
- Reviewed current processes and advise on database design plans to support business needs
- Designed and employed ETL packages using SSIS to automate data feeds to data warehouse from an external API source using custom C# code.
Data Analyst/Programmer
THIEL COLLEGE
04.2013 - 05.2014
- Obtained data and developed reports for various administrative and academic departments
- Maintained data integrity for reports that aid in decision-making and outcomes assessment
- Wrote custom code when necessary to ensure processes and reports are accurate and reliable.
Embedded Systems/Development Engineer
CERVIS INCORPORATED
01.2008 - 01.2009
- Supported present development efforts in the areas of mining automation using CODESYS for developing ECU software
- Supported present development efforts in the areas of industrial wireless systems
- Assumed the role of lead design engineer in projects determined by Engineering Manager
- Assisted in the evaluation of possible opportunities for development.
Education
M.S. in Industrial Systems Engineering -
YOUNGSTOWN STATE UNIVERSITY
Youngstown, OH12.2007
B.S. in Electrical and Computer Engineering -
RAJIV GANDHI UNIVERSITY OF TECHNOLOGY
Bhopal, MP04.2003
Skills
- SQL
- T-SQL
- D-SQL
- KQL
- JSON
- C#
- HTML
- DAX
Leadership Experience
- Indian Society for Technical Education Conference on Information Technology, Designed the conference website; Led team of 10 + people for technical and logistics support.
- Indian Society for Technical Education Conference on Ergonomics, Designed the conference website; Led a team of 15+ people for technical and logistics support.
- Techfest 2002, Yantriki, IIT Mumbai, Led a team of 3 people for two robotics projects.
- Ideon 2003, Robotix, IIT Kharagpur, Led a team of 7 people for a robotics project.
Timeline
Senior Data and Business Intelligence Engineer
THE EVERETT CLINIC Optum UHG
09.2020 - 04.2023
Senior Data Analyst Contractor
MICROSOFT CORPORATION
04.2020 - 07.2020
Analyst/Developer III Contractor
FRONTIER COMMUNICATIONS
09.2019 - 01.2020
Test Data Analyst/Manager Contractor
PACCAR
04.2019 - 08.2019
Software Test Engineer Analyst/UAT Contractor
T-MOBILE
04.2018 - 01.2019
SQL BI Software Developer Contractor
MICROSOFT CORPORATION
10.2017 - 01.2018
ETL Developer II
PARK PLACE TECHNOLOGIES
04.2016 - 05.2017
SSIS Developer Contractor
CVS CAREMARK/CVS HEALTH
06.2015 - 12.2015
SQL BI Developer Contractor
THE GARLAND COMPANY
07.2014 - 11.2014
Data Analyst/Programmer
THIEL COLLEGE
04.2013 - 05.2014
Embedded Systems/Development Engineer
CERVIS INCORPORATED
01.2008 - 01.2009
M.S. in Industrial Systems Engineering -
YOUNGSTOWN STATE UNIVERSITY
B.S. in Electrical and Computer Engineering -
RAJIV GANDHI UNIVERSITY OF TECHNOLOGY