Daxesh Patel Email & Phone Number

Middletown, DE, US

New Haven, Connecticut, United States

• Working with YNHH. I was managing big project like (TOC) Transition of care, Provider Roster. Where I need to make whole process from manual to automated using the Integration services and created various Tableau.
• I was also involved in the performance optimization of the processes where I had to dig in the SQL, SSIS and Reports like SAP BOE Web Intelligent, Tableau, Slicer Dicer and Power BI find out where performance can be.

Columbia, MD

• Used Data Stage to load the files from various Rating Agency sources like Fitch, Moody’s and S&P to CDO database Writing many user defined functions, stored procedures and triggers to do relational Database development.
• Supported Classic ASP pages with new upgrades and wrote many complex SQL stored procedures and used them in the ASP instead of embedded SQL to prevent SQL Injection Attack
• Converted many FTP loads to SFTP for security purpose with closely working with networking teams and top-level management
• Very good understanding of data modeling OLTP as well as OLAP

Baltimore, Maryland, United States

• I was involved in creating brand new process that loads data from third party vendor system and loads them into staging periodically using SSIS and inbuilt FTP loader into staging environment. Cleaning those data.
• Was helping them to do migration from on premises SQL server to Azure cloud for POC in order to see the processing data time difference between those two systems.
• Spined new EC2 instance on AWS with correct security groups in IAM. So the various teams in fixed income IT can utilize them and be more productive.
• I’ve managed Barclays POINT to Bloomberg PORT conversion project to make sure everything will be lined up properly so our analytics team will not have any problems to make their decisions. For that I’ve created.
• Created various Risk and Attribution like Drill through, drilldown, sub-reports and parameterized reports using SSRS using Meta driven development.

Durham, NC

• I was part of the green field project. Where existing process were taking almost 7 to 10 hours of time to generate 2 files for business one is BTTC and another one is BNTC for call center so they use those files and do.
• To achieve that I started looking in to SSIS packages and remove all the blocking transformation that is used to slower the performance and tried to use as much as TSQL. Also I did performance tuning in TSQL that.

Iowa, United States

• Automated their process which manually sent files from users to DWH and then DWH team need to load their files and give them Error if there are some so they can aware of which data got loaded into DWH and which are.
• I was also involved in the process where they have existing SSAS multidimensional cube which are performing poorly so improved the performance by adding more partitions and change the model using data source view. And.

Reston, Virginia, United States

Freddie Mac involved nation's residential mortgage markets and expand opportunities for homeownership and affordable rental housing. The main project goal was to use T-SQL and SSIS to extract data from sources and push that data through staging into reporting layer as well as generating reports based on business requirement.

Bethesda, Maryland, United States

• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular sales type in given period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.Wrote T-SQL queries, created dynamic Stored.

Jacksonville, Florida, United States

• Fidelity National financial is nation’s largest provider of commercial and residential mortgage and diversified financial services as well as the insurance. The project dealt with managing the database regarding the.
• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified data source and data views for building the OLAP cube in SSAS.
• Defined measures, dimensions and attributes for building the cube in SSAS.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Created OLAP cubes using SSAS to analyze the business condition of the sales.