Divya Doma Email and Phone Number
Phoenix, AZ, US
Divya Doma's Location
Phoenix, Arizona, United States, United States
Divya Doma's Contact Details
Divya Doma work email
- Valid
- Valid
- Valid
- Valid
Divya Doma personal email
n/a
Divya Doma phone numbers
About Divya Doma
Experienced Data Team Lead with a demonstrated history of working in the government administration industry. Skilled in Software Development Life Cycle (SDLC), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Extract, Transform, Load (ETL), and Web Development.
Divya Doma's Current Company Details
Hourglass Education Technology Solutions, Llc
View
Sr SQL and BI Developer
Phoenix, AZ, US
- Website:
- hourglassets.com
- Employees:
- 3
Divya Doma Work Experience Details
-
Sr Sql And Bi DeveloperHourglass Education Technology Solutions, LlcPhoenix, Az, Us
-
Sr Sql/Bi DeveloperHourglass Education Technology Solutions, Llc Nov 2018 - PresentPhoenix, Az, Us
-
Data LeadArizona Department Of Education Apr 2016 - Nov 2018Phoenix, Az, Us• Attended Technical requirements gathering meetings with stakeholders and translated business requirements into PBI’s and tasks for Data team.• Created and monitored day-to-day tasks of all the data developers.• Worked on creating and installing SQL server virtual machines on Azure services. Migrated code to create tables, views, stored procedures and indexes. • Developed packages to load data from on premise SQL servers to Azure SQL servers.• Installed and configured SSIS servers on Azure services. Fixed and Agent Xps errors and enabled the SQL server agent. • Created SSIS catalog and SSISDB. Deployed SSIS projects and configured the projects to use different environments on the same server. • Worked on setting up proxy accounts, credentials, principals and SQL logins to execute SSIS packages and jobs. • Installed and configured SSRS server and databases on Azure virtual machines. • Designed and developed a new database ‘Configurations’ to handle all the roles and permissions which authenticate the users logging in. • Designed and developed RDSS data mart which was used as the repository for data from many data points. • Developed ETL solutions using SQL Server Integration services (SSIS) to load a variety of data files form external vendors like Basis, PCG, and BFK. • Was responsible to complete all the code reviews submitted by developers before checking in the code in source control.• Acted as a point of contact for all data related inquiries from stakeholders across multiple projects. • Attended program review meetings and provided management with status updates of all the projects in the iteration.• Performed all the production deployment activities – Creating RFC’s, submitting the RFC ticket and getting approval from CAB, production deployment support, Post-production validation. • Performed requirements and impact analysis. -
Ssis DeveloperArizona Department Of Education Sep 2014 - Apr 2016Phoenix, Az, Us• Developed ETL solutions using SQL Server Integration services (SSIS) to load a variety of data files form external vendors like Basis, PCG, and BFK. • Developed packages to pivot and Un-pivot the data files received from vendors and loaded into the Educator Dashboard. • All the packages were developed according to the ETL framework (Checking connections, Error logging and records counts) followed by the department.• Developed packages to get data from an API web service and Upsert into the database.• Actively participated in data analysis of the files received back from ATI and BASIS. Provided day-to-day status counts of records received and analysis on the bad data.• Designed and developed a new database ‘Observations’ to support the in-house tool where the Teachers, Coaches and Leaders are evaluated. • Created audit functionality in the ‘Observations’ database, to support audit trial. • Developed new stored procedures and modified existing stored procedures to increase performance.• Developed various views and functions for QA and other teams in the organization.• Developed complex reports through SQL Server Reporting Services (SSRS).• Developed reports consisting of Bar charts, sub reports and different visibility conditions. • Developed adhoc production reports for project managers and created email subscriptions for day to day update.• Performed all the production deployment activities – Creating RFC’s, submitting the RFC ticket and getting approval from CAB, production deployment support, Post-production validation. • Performed requirements and impact analysis.• Assisted in documenting business and technical requirements• Participated in all phases of software development and maintenance lifecycle.• Supported defect analysis and resolution.• Work with senior management, customers, and other team members.• Performed all other duties as assigned.
-
Programmer AnalystCare Wisconsin Nov 2013 - Jun 2014• Worked extensively with SQL Server Integration Services (SSIS). • Developed SSIS packages from scratch to transfer claims data in a correct format to third party administrators like Trizetto and Pharmastar. • Developed template packages for error logging and event handling. These were used by users across IT while developing packages. • Developed jobs and packages to automate the process of transferring data to FTE site. • Developed packages using fuzzy grouping and fuzzy lookup transformations for pharmacists to evaluate drug names and map them to standard federal issued formulary files. • Mentored users and non-IT staff on SQL Server Integration Services. • Developed a variety of stored procedures using T-SQL to generate datasets for various reports (SSRS, Excel and Access).• Developed T-SQL code to generate results for adhoc requests and saved the deliverables in user folders. • Worked with performance tuning of already written SQL codes. • Developed a variety of reports for Provider services, Member demographics, Business Metrics and Care team tools using SQL Server Reporting Services (SSRS). • Worked on making changes to existing reports which ranged from changing the source data to formatting changes of the report output. • Worked on weekly loads which involves running a SQL server agent job and loading the output files into Trizetto solutions account and Qic link. • Documented all the projects assigned using Subversion (SVN) and track-it technician client.
-
Sql Server And Bi DeveloperAbb Sep 2012 - Nov 2013Zurich, Zh, Ch• Developed and designed reports using SSRS 2010 and SSRS 2008.• Implemented and maintained a reporting suite of over 70 reports while creating many reports to meet the individual user needs.• Converted Access and Excel based reports to MS SSRS 2010 reports.• Developed complex stored procedures using SQL Server for SSRS report datasets.• Trained the users on MS SSRS Report Manager and Report Builder to develop their own adhoc reports.• Performed data extraction, transformation and loading between SQL Server and other systems like SAPODS (SAP Database), Oracle, Excel and Access databases.• Worked with linking of Access and SQL Server databases to dynamically update the SQL tables.• Designed and developed multi-dimensional objects like cubes and dimensions using SQL Server Analysis Services. • Helped the rest of the group with network and desktop related issues. • Involved in development and application of software to respond to customer requirements and to cost-effectively provide a means of analysing, producing, distributing and storing information. -
Programmer AnalystWisconsin Department Of Public Instruction Sep 2011 - Sep 2012Madison, Wi, Us• Installed and supported the Microsoft BI tool set including SSRS and SSIS.• Created high level design and performed system analysis.• Administered and maintained the Report server.• Designed and developed Front-end/Back-end/Web-user interface using SQL Server technologies• Developed reports using SQL Server Reporting Services (SSRS).• Exported all the Info maker reports to SSRS.• Developed complex stored procedures using T-SQL for reports.• Established report templates.• Trained the DPI IT Staff on SQL Server and SQL Server Reporting Services.• Unit testing and documented the test results.• Supported user acceptance testing.• Deployed the created reports to Report manager.• Supported preproduction and post production activities (deployment, production shake out, production support etc)• Provided technical expertise in all phases of the software development life cycle.• Supported to stabilize the systems, install new software releases, perform system upgrades, evaluate and installs patches and resolve software related issues, made hardware configuration recommendations. -
Sql Server And Bi DeveloperMilwaukee County Sheriff'S Office Jul 2011 - Aug 2011• Assist in the creation of data access methods for system data sources to be included in comp stat and operational reports as part of the agency wide business intelligence solution.• Developed views, stored procedures, and ETL processes.• Developed SQL Queries using Dynamic SQL. • Worked with linked servers and wrote complex SQL to retrieve data.• Worked with built in functions developing custom functions, aggregating data, and combining multiple data sources.• Used OpenQuery and OpenRowset methods to retrieve data from native databases through OLE DB and ODBC.• Created SSIS packages for transferring data from various data sources like MS Access, Excel, *. Txt file, *.CSV files.• Used various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.• Worked closely with Information Builders report developers and county staff to ensure solutions meet business needs.• Worked with end users and analysts to assist in determining business needs and designing solutions to meet those needs.
-
Data Entry Specialist/ Office AssistantTexas A&M University-Kingsville Aug 2008 - Dec 2010Kingsville, Tx, Us• Updated records for customers and employees daily.• Managed complete data entry and customer support functions for the universities cafeteria.• Input hand written customer orders for catering, orders and outstanding invoices.• Entered data into designated database and forms.• Log phone messages into computer system and email to staff.• Purchased and managed office supplies for the office along with performing photocopy and runner duty.• Create shipping labels and schedule daily pickups.• Handled all payroll activities for 100+ employees and ensured posting of checks before end of the month. • Greeted visitors and determined to whom and when they could speak with specific individuals. • Maintained office files and folders.
Divya Doma Skills
Microsoft Sql Server
Ssis
Ssrs
Business Intelligence
Ssas 2008
Data Warehousing
Etl
Sdlc
Web Development
Pl/sql
Sql
Databases
Requirements Analysis
Microsoft Azure
Sql Azure
Divya Doma Education Details
-
Texas A&M UniversityEngineering
Frequently Asked Questions about Divya Doma
What company does Divya Doma work for?
Divya Doma works for Hourglass Education Technology Solutions, Llc
What is Divya Doma's role at the current company?
Divya Doma's current role is Sr SQL and BI Developer.
What is Divya Doma's email address?
Divya Doma's email address is di****@****zed.gov
What is Divya Doma's direct phone number?
Divya Doma's direct phone number is +160292*****
What schools did Divya Doma attend?
Divya Doma attended Texas A&m University.
What skills is Divya Doma known for?
Divya Doma has skills like Microsoft Sql Server, Ssis, Ssrs, Business Intelligence, Ssas 2008, Data Warehousing, Etl, Sdlc, Web Development, Pl/sql, Sql, Databases.
Who are Divya Doma's colleagues?
Divya Doma's colleagues are Rohit Vangore.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial