Project Title : : Microsoft Marketplace

Client : Microsoft(Redmond U.S.)

Products Used : SSMS, SSIS, ADF v2(Azure Data Factories), Azure platform, Spark, PowerBI

Database Used : SQL Server2016, AzureDB, Hive

Languages Used : SQL, T-SQL, Scala, DAX, HQL, Scala

Project Description :

Microsoft Marketplace is a well known Microsoft product. On client requirement, we migrated complete system that was developed in SQL Server(legacy) to Hadoop and for client visibility then we pushed data into AzureDB(PAAS). Considering the data volume that Hadoop can handle, it was chosen for warehousing and data processing. For pipelines creation highly advanced tools like ADF v2(Azure Data Factory), SSIS, for transformation logic Spark-Scala, T-SQL, for warehousing Hive, for Blobs Parquet,ORC formats, were used respectively. QA dashboards were created using PowerBI, where we show our different KPI/QA results

Roles and Responsibilities -

• Understanding the Business requirements and extracting the mechanism to implementBusiness strategy.
• For ETL/ELT created pipelines using Azure Data Factories(ADF v2), SSIS
• Created different Pipelines to extract data based on different logics written logics written in Spark-Scala or SQL StoredProcedure, and pushed them in form of Blobs in HDFS
• Performed indexing, performance tuning , query/code optimization for different jobs.
• Responsible for creating different reports as per the business requirement created using PowerBI.
• Automated different ETL processes and reports to avoid manual intervention.
• Preparing documents prior to development phase such as estimation sheet, query log, low-level design document(LLD).

Project Description :

Perkins and Bojangles are the TMM Clients that used to take complete Pricing/Financial recommendations done viaFishbowl. These clients used to provide data in the form of different zip files, .csv files. We used to load data from these files into the database then process that data into different POS and Fact tables, that analytics team used to do their analysis and in the end recommends customer the pricing of their products and other different services.

Roles and Responsibilities -

• Understanding the Business requirements and extracting the mechanism to implementBusiness strategy.
• Performing daily ETL tasks and implementing complex SSIS packages such as reading the data from zip files and processing them as per the business requirements.
• Developed different database jobs to import data from different sources.
• Performed indexing, tuning , query optimization for different jobs.
• Responsible for creating different reports as per the business requirement.
• Created different SSRS(SQL Server Reporting Services) reports to check the data quality and make sure that information is consistent..
• Automated different ETL processes and reports to avoid manual intervention.
• Preparing documents prior to development phase such as estimation sheet, query log, low-level design document(LLD).

Project Description :

UNO – One System belongs to Insurance Domain. MLI has 18 different systems such as MyMoney, Omnidocs, MyFlow etc. that they wanted to be integrated with each other and their business flows needs to be automated . CRMNext product acted as a one roof , that helped in integration of these 18 system. As a result , all the manual and asynchronous work replaced with different real time and Batch integrations, which leads to greatincrease in their business and cost saving by increasing the throughput.

Roles and Responsibilities -

• Understanding the Business requirements and extracting the mechanism to implementBusiness strategy.
• Performing real time and batch integration with different systems.
• Developed different database jobs to import policy, customer, agent data into the system.
• Performed indexing, tuning , query optimization for different jobs.
• Preparing documents prior to development phase such as estimation sheet, query log, low-level design document(LLD).
• Responsible for creating different reports as per the business requirement
• Provided onsite support to MLI after delivery.
• Created different ETL packages to successfully import bootup/incremental data from different systems.

Dedicated team carries out the end to end activities for the Barclays Local Business solution of UK. Development, Maintenance & support are carried out by the team to process the day-to-day activities of the bank. The Experian Product Transact system acts as the flow builder agent and Strategy Design Studio for credit scoring for Bank customers applying for the products such as Loan, Credit cards, Overdraft etc. With the latest feeds, these decision agents have various internal modules that turn around a credit request very efficiently, assessing the risk and accordingly minimizing the risk to the Bank. This keeps the Customer acquisition and Origination robust in the competitive market.

Task was to develop credit scoring to the customer, implementing business logic, developing interface pack and purging the accounts from database having high risks. For creating the Business logic and flow Decision Analytics tool like Transact, for credit scoring and decision making Strategy Design Studio, for interfacing the bureau a further interface was required which was developed using the newly introduced Experian tool Power Curve and for purging the accounts having high risk SQL Server 2008 R2 was used in which by using T-SQL, procedures and functions were created to identify and purge the accounts having high risks.

ASP website for planning tours in various parts of the country and also providing assistance with various transport medias and currently running online and can be accessed by using link www.adyatravels.com .

It is an implementation of Infrastructure as a service (IaaS) of Cloud Computing. Here main objective is to use more than one OPERATING SYSTEM on a single PC along with existing operating system and implement VIRTUALIZATION a maximum Hardware resource usage.

It basically deals with practical implementation of an Insurance System , i.e. Policy creation, updating users information, deleting based on requirements . The main objective was to expose various concepts of COBOL such as Dynamic Cursor positioning, Unstring , Exception Handling etc . and implementing various IBM coding standards .