Dinesh C.

Dinesh C.

SQL / Data Warehouse / SSRS / SSIS / PowerBI/SSAS Developer / Analyst

Atlanta , United States

Experience: 15 Years

Dinesh

Atlanta , United States

SQL / Data Warehouse / SSRS / SSIS / PowerBI/SSAS Developer / Analyst

72000 USD / Year

  • Immediate: Available

15 Years

Now you can Instantly Chat with Dinesh!

About Me

•    Agile Certified Scrum Master & Product Owner with 10+ years of experience in IT as Sr MS SQL Server Developer working in various domains such as Finance, Insurance and Healthcare in 2012/2008R2/2008/2005/2000 Windows Environment.
...

Show More

Portfolio Projects

Description

Scope of the project is to integrate data from various different systems such as ODS/DCS, SalesForce, Lawson financial, EOD and SnF Security into the Dataocean at the staging layer and further preparation for the reporting layer.

Environment

SQL Server 2014 hosted in AWS Cloud, Python for ETL, PowerBI, Tableau, Rudiment, Agile Scrum, Altassian JIRA, Confluence, Redgate Tools, AWS (Amazon Web Services), Micro Services.

Show More Show Less

Description

E&Y is a global leader in Assurance, Tax, Transaction and Advisory services providing insights and quality services to deliver help build trust and confidence in the capital markets and in economies the world over. I was responsible for delivering our core business solutions and participating on key architecture initiatives.

The Scope of the project is to develop a SQL Server based Global CostRate Application is solution developed to automate the calculation of hourly bill rates and cost rates which are required in the resource allocation process and ability to calculate and process direct and shared cost allocations as planned out to the countries/areas. The solution will help to plan certain elements in local currency which will convert to USD using current year planning rates.

Show More Show Less

Description

JPMorgan Chase is a premier Investment Banking and Financial company offering services for consumers, small business and commercial banking, financial transaction processing, asset management and private equity. The Global Technology Infrastructure (GTI) group serves as the central provider of technology infrastructure to JPMC. Distributed Technology Services unit is responsible for managing firm’s global server and storage portfolio across plan/build/operate functions.

Scope of the project is to improve and enhance the support of Oracle database technology on behalf of JPMC's various Lines of Business (LoB's). The project spans the areas of Insurance Claims, Deficiency Claims, Collateral Insurances, Property Agents and Investors information, Property and outstanding Loans.

Show More Show Less

Description

Express Scripts, Inc is the largest pharmacy benefit management organization in US. It processes pharmaceutical claims for members at network pharmacies and at their own mail order pharmacies. It provides integrated pharmacy benefit management services including network-pharmacy claims processing, home delivery services, specialty benefit management, benefit-design consultation, drug-utilization review, formulary management, and medical and drug data analysis services.

The goal of the project was to modify the existing packages and create new packages using SSIS to Extract, Transfer and Load data into Data Warehouse, analyze the metrics using cubes in SSAS 2008R2 and create reports using SSRS 2008R2 for reporting purpose and to increase the efficiency of the transaction (OLTP) system for 835/837 transactions.

Show More Show Less