In this Spain project we use Spark and Scala to perform ETL. Input non panel pharmacy data is loaded to Data Lake. Reference data is also loaded to Hive tables of Data Lake , from Input systems such as SQL server, Oracle & Exasol. Bridging process takes all these data and replaces manufacturer name, drug name, drug molecule and geographical region, it also adds panel data before producing output csv files into sftp location.
Quality check module was developed to validate input data, we used a configurable JSON file to list all the quality checks. JSON file facilitates adding a quality check on the fly in different environments. Error notifications are sent through email and logs are captured in Cloudera. Kibana logs are also used to help production teams to troubleshoot the application. Impala was also used to help production teams in getting data using SQL quickly.
All the modules are standalone applications which are then triggered by ESP scheduled tasks.
Contributions:
Role : Lead Developer
Technologies :
This project estimates late arrival data of Switzerland data centers, Statistical team developed a prototype of estimating later arrival data using SAS. We have analyzed this SAS programs and datasets. Converted them to SQL server stored procedures.
Contributions:
Role : Lead Developer
Technologies:
This is a framework which servers for multiple clients, This consists of 6 offerings(cube) which are used by more than 1000 clients. Involved in all the ETL packages of this offering.
Contributions:
Role : Senior Developer
Technologies:
This package loads a GB of data to tables by applying many business logics. We have implemented single configuration file for multiple child packages.
Contributions:
Role : Senior Developer
Technologies:
This is a windows application, which helps to calculate Medical representatives Incentives based on IMS data. Several pharmacy clients use this tool, every new client is introduced to this tool, we have to take up customization. We also supported this tool on change requests.
Contributions:
Role : Senior Developer
Technologies:
This project is part of the QMS automation. There are various reports at different levels & Ability to extract the data base in either word, excel or PDF format. The reports were deployed in SharePoint.
There were multiple roaster sheets which were uploaded to the database from different departments and all these upload were handled through SSIS.
Contributions:
Role : Senior Developer
Technologies:
This application seamlessly integrates Real Remit invoices with Dynamics (AX). The invoices data contract has header, summary and detail rows. SSIS splits these values and inserts them to different tables. SSIS runs in concurrency with AX batch. SSIS sends email on success or failure.
Similar to this we have developed many SSIS packages which interact with other Business units & Dynamics AX.
Contributions:
Role : Senior Developer
Technologies:
This is an upgraded application of an existing application. We are upgrading the current application by incorporating .net 3.5 features. This application monitors Bonds and Equity trading of a bank. Bonds and equity trading is handled by many windows services and Super Vision application tracks the information of these widows services along with displaying many log files. All the transactions to server are handled through wcf services.
Contributions:
Role : Senior Developer
Technologies:
This is a software product, which will be used by RV sellers to maintain customers (sales leads). It is having 3 users Sales Admin, Sales Manager & Sales Person.
The sales manager can create and manage protocols, which will be used by sales persons to handle sales leads (customers).
Contributions:
Role : Developer
Technologies:
eNcompass is a system upgrade project of Telecom companies based in Virginia, US. The primary goal of this Systems Project was to eliminate redundancy in telecom companies, thereby increasing efficiency. It established or enhanced integration with existing systems, enabled roles and responsibilities to be more easily managed, reduced operational errors and most importantly enhanced and improved service to the most important person for any business. - The Customer.
These goals were achieved by creating a system that integrated all applications so that the data was not initiated in more than one system.
BEL, BLL, DBL & PL architecture is followed in development.
Contributions:
Role : Senior Developer
Technologies:
This application tracks the quarterly performance of each employee of a company. The employee has to login with his credentials and submit his quarterly performance details. This submitted form would appear on, his reporting managers ICR/PLR forms list. Reporting manager can approve or reject the form. If any reporting or reviewing manager rejects the form, a mail will be sent to all the employees in the hierarchy. The application tracks the performance of all the employees of each branch. It has a feature of automatic performance rating calculation and printing reports.
Contributions:
Role : Trainee Engineer
Technologies:
