With cloud project we are providing DaaS platform to school integration data server. This can save money as well as time for the districts to prepare data through their online platforms.

Delivering continous data using cloud data lake platform. Data as a service profile created using snowflake & Oracle integration. Tasks created in snowflake to perform the data transformation (T in ELT).

New design and architecture created for Datawarehouse schema terminology (Snowflake schema) to get the maximum performance of datawarehouse platform. Integrating a application to access the always available data from snowflake.

PS SIS is a single sign on application for both Web and Mobile. This application is providing support to public schools of district in US. This application is multi-functional application for students, teachers, school admin and district Education Departments. Compliance R&D support is providing help for school to federal rule complained. The platform is providing enhancement to application and compliance reports.

Live Server Data migration along with Schema (Procedure, function, Triggers) redesign from MS SQL to MySQL. Have worked from scratch to final. Migration Road Map, strategy, test runs and implementation on production is derived.

Oraganization's matrix dashboard to analyse and understand the organization's performance on each key matrix. KPI we created was individual KPI for each dashboard including diversity, attrition, headcount etc.

Health Care Data comes in different ways including HL7 feeds and XML transcript. We built the ETLs to handle live feeds,Row data and Transcript to transform in business value data. We written ETLs, SQL Procedures to handle the data issues, data cleansing.

ETL created to take Payroll HR data from Microsoft Dynamics and push it to Salesforce. First i created Crystal Reports and then SSRS in Salesforce platform. Later we converted the reports to Salesforce views. Full lifecycle involvement to get the data, transform it to get business values and creating reports using crystal report/SSRS.

This Dashboard is designed for analyzing organizational resources, monitor attrition rate, verify resource activities and performance and managing projects. The complete dashboard has then integrated with ASP.Net to utilize the services of web-based application. Using forecasting, trending, What-If Analysis – analyzed the scope of performance enhancement.

It is a monthly metrics used for analyzing project performance using performance keys i.e. Attrition, Diversity, Chargeability/utilization% etc. We started design from scratch and provided best analytics dashboard using different graph representation. Based on client requirements and scope provided ad-hoc changes in tableau dashboard.

ETL process for Hospital Claim data transformation to company data warehouse. Web Services feeds, Text files to Architectural DB. Creating packages with advanced tech - handle multiple clients text data. Fixing client data bugs, maintaining product releases, deploying data through PowerShell script, SQLCMD etc. Working on upgrade to 2012.

Creating SQL ETL Packages to run Step-by-step process communicate to the bank system via FTP server from Excel input data to printable checks.

An N-tier system based on MS Dynamics GP and Salesforce.com. The client Web based Sales force CRM system requires information from ERP database and generating report with the CRM data. We have built flow for updating CRM database and managing report with the requirement.

A connectionless client-server system. We have to build architecture to transfer data via email with strongly encrypted files. The client users make the receipts and then transfer it to make invoices in database. File will be imported to the ERP server on remote location.

To provide maintenance to the software created by vendor. It is a VB 6.0 program requiring Microsoft SQL Server as back end and read the images application files provided from our insurance client. Software developed with the team of NewGen software and then update by us as our clients requirement.

The policy information received in DB2 files and due to software limitation we have to preprocess the data in text format and then load the file. Some additional business logics were written in VB6. The tool has converted the data in printable format and then the password protected files send to the customers. A printable document is also sent for proofing.