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 dashboard reports so they can run those reports on demand and see how their number looks like.● 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 improved and make change and do the deliverables. So business have their decision making process on demand.

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 using TSQL. Gather requirements from the business and built reports for their clients using SSRS, QlikView and SAP Crystal Report● 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 properly and finally load them into data warehouse so quantitative research people access them using reports that I’ve built some in SSRS and few of them in QlikView. ● 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 parallel process that loads data into SQL server and created reports in QlikView so we can do comparisons in numbers between both systems.● 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 their operation daily. Some time it takes long so operation has to wait and that was impacting a business a lot. In order to improve the process I’ve got assigned to focus on the SQL objects and SSIS packages to see how much performance I can Gain to reduce time lines. ● 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 gained 50 % improvement in time and that reduce our process time from 7-10 hours to 2-4 hours.

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 not. So I automated that process with SSIS and SSRS. So user need to put their files into folder and run the SSRS report that SSRS report triggers SSIS and load them into DWH if there are any data issue it tells in SSRS what the issues 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 then also wrote the MDX to report that cube data. We also had some tabular cube where we had to make some model change for the business. SO I’ve used some DAX to add new measure in existing tabular model.

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 Procedures by using input values

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 insurance policies, defined Fact relationship in SSAS, writing drill down reports, creating SSIS packages for transferring data from sources to SQL server, creating cubes to analyze the business conditions regarding the sales.● 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.● Wrote complex queries for the drill down reports and used conditional formatting using SSRS.● Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation. ● Created Parameterized, matrix and drill down reports using SSRS 2008.● Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008.