Soumya Thomas

• Championed a data-driven culture within the company, empowering employees at all levels to make better-informed decisions through the use of BI tools like QlikView ,Power BI and SSRS
• Took up additional responsibility of HIE/ EDWARD co-originator and facilitated HIE data loads and back ups.
• Good understanding oof all health care data including Clinical, Payroll and Finance.
• Conducted detailed root cause analyses to troubleshoot complex issues within the BI environment, resulting in swift resolutions of critical problems.
• Enhanced decision-making capabilities by designing and implementing advanced business intelligence reporting tools.

Roles and Responsibilities

• In the acting manager position, assist with technical solution design, day to day support as well as process improvement decisions.
• Building data warehouse and set up data feeds from various source systems.
• Analyze data and create useful visualization to help operations to take informed decisions.
• Requirements engineering, business process redesign and gap analysis
• Build up data warehousing solutions groud up for various data streams.
  
• Extract - Transform - Load data
  
• Create visualization in QlikView and SSRS.
  
• Design and develop automated data input systems when necessary.
• Translate stakeholder business needs into technical requirements for new reporting.
• Lead project teams and collaborated with other teams to determine and translate business requirements into technology and training solutions.
  
• Work with developers from other LHD on collaboations.
• Particiapte and contribute in state level forums.
• Support ethics approved data requests.

Roles and Responsibilities

• Responsible for Analyzing data flows and translating the Business requirements into High Level technical Design specifications.
• Demonstrated ability to analyze data and processes to see patterns and models for automation.
• Performed business process automation through requirements engineering, business process redesign and gap analysis
• Used SQL querying skills for data analysis
• Created mock ups to demonstrate the functionality.
• Incorporated requirements traceability through design, testing and user acceptance phases.

Roles and Responsibilities 

• Migrate a Legacy Application developed in VB 6.0 and SQL server 2000 to .Net 4.0 and SQL Server 2008 as a part of platform renovation.

• Involved in Full project life cycle (from requirements gathering to implementation phase).

• Responsible for translating the Business requirements into technical specifications.

• Reviewed and managed complex business process information and data scenarios, performed impact analysis and GAP analysis for new processes or changes to improve on the current methods.

• Applied analytical skills and provide strategic recommendations for review with the business partner.

• Demonstrated ability to see patterns, identify root causes and combine disparate ideas to maximize value. Highly focused on efficiency and process improvement.

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution.

This was a migration project from Dynamic DTS packages (DTS packages were generated and executed using VB.net) to SSIS. Due to unavailability of documents, this project needed extensive system study and code analysis.

Roles and Responsibilities 

• Analyze project scope as it was a migration project

• Code Analysis of existing application

• Work on SSIS Package for transferring data from different databases and files to SQL Server.

• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.

Roles and Responsibilities 

• Design/Build Extract Transform Load (ETL) process in SQL Server Integration Services.

• Migrate DTS packages to SSIS packages.

• SSIS performance tuning, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and C#.NET in SSIS.

• Create SSIS script task, look up transformations and data flow tasks using T- SQL and scripts.

• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures and optimize query performance.

• Involve in re-design, development, and deploy of new data pipelines using SSIS

Roles and Responsibilities 

• Developed application logic using C#.NET.

• Used Windows Communication Foundation (WCF) to coordinate with external applications.

• Developed SSRS (SQL Server Reporting Services) reports and integrated in Microsoft SharePoint Server.

• Assisting DBAs in SQL Queries and performance tuning of database.