Nitin Patel Email & Phone Number

Irvine, California

• Responsible for importing datasets such Niche School, SMR Commercial, Traffic Data from Kalibrate, Hanley Wood Refine Values, Census data from Precisely, ICSC Commercial data, SiteX Mortgage and Public Records data and AARP Annual updates.• Responsible for creating/maintaining 400 SSRS Reports• Worked very closely with Performance Tuning the Stored Procedures• Developed SSIS packages to import data from vendors• Responsible for Daily Jobs Status Reports

Brea, California, United States

• Worked extensively with MS Master Data Services (MDS) to create and maintain Business Related entities.• Worked very closely with Business Analysts to develop complex SSRS reports for Capitation and Eligibility• Developed SSIS packages to consolidate data from various data sources• Responsible for troubleshooting SQL Stored Procedures for Performance

Sana Ana, California

• Revamped a legacy ETL process due to a migration from legacy source system to SQL Server.• Converted forty-five Excel legacy reports to SSRS using VS 2015.• Troubleshoot DataTree and DataTrace Billing applications written in C#.• Created and maintained documentation of the existing ETL processes embedded in DataTrace application.• Worked on creating new dashboards in PowerBI with SSAS backend.• Added new reports to reporting platform hosted on SharePoint.

Aliso Viejo, Ca

• Work closely with management and end-users to create and evaluate business requirements to support the delivery of effective data solutions• Design, develop, optimize, maintain and support ETL processes using Stored Procedures, SQL scripts, Visual Studio (BIDS)and data integration tools such as Microsoft SSIS• Create technical designs and functional specifications for back-end and front-end information systems• Participate in the development and testing of database scripts and back-end processes to support system integration and ETL (data extracts and imports) to facilitate the creation and population of staging databases, operational data stores (ODS), data marts, and other data integration solutions• Design, develop and deploy solutions to support integration with enterprise applications. Implement user access controls and data security measures where appropriate• Create and maintain documentation of processes, databases, applications, and procedures as per department policy• Support the design, planning, implementation, administration and maintenance of the database and ETL platform• Mentor and support the training of peers and business users in the proper use of the database and end-user software tools• Maintain ETL process jobs and respond to critical data load issues

• Responsible for Creating, and Maintaining SSIS packages to bring the Data from various Sources• Responsible for Creating, and Maintaining SSRS Reports• Created SSIS packages to load data in Data Warehouse • Responsible for Publishing SSRS Reports on the SharePoint site• Created new/Modified existing Functions, Stored Procedures based on the requirements for SSIS packages and data load• Directly involved with business users on gathering requirements and answering any questions/concerns• Currently working on Building Data Warehouse using Star Schema• Deployed the code and packages to development. Involved in development testing process and made sure everything is good before promoting to QA.

• Designed and Developed SSIS packages which loads the data from various data sources such as AS400,SQL Server, Flat Files to SQL Server 2008. • Responsible for Converting Secondary Marketing Application Highest Hit Funds (HHF) to Information Technology• Responsible for Migration of databases from SQL Server 2008 to SQL Server 2008R2• Developed T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.• Worked on different environments and a key resource for deployment of modified objects to production environments• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity• Lead Team of 4 Developers for creating 54 SSIS packages• Responsible for creating Business Requirements Document (BRD), High Level Design Document (HLD), Low Level Design Document (LLD) for HHF• Responsible for Creating Job Schedule for 357 Jobs using AutoSys• Attended meetings with the Upper Level Managers regarding HHF transition to IT• Troubleshot SSIS complex SSIS packages for Data Imports and Data Transformations• Coordinated Production Releases with the Build Team• Created stored procedure and function for automatic creation of jobs based on tables data which runs on specified cycle.• Followed SDLC life cycle throughout the project.

• Responsible for creating SSIS packages for Applications• Responsible for Troubleshooting, Maintaining SSIS packages• Created ETL packages to extract data from Oracle 9i Databases and Text Files• Created/Maintained Stored Procedures on Sql Server 2008

• Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction company.• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. SQL Server Integration Services was used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails. • Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries according to business requirements. • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services. • Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership. • Created score cards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures for sales, sales trends, and book return rates for a fictitious book publisher deriving data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites . The dashboards also contain drill-down capabilities to view book sales by book category and customer, through summary reports and sales trend charts.• Created score cards with advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a fictitious construction company extracting data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites.

• Created VB.NET, VBA and C# Applications to import flat file and XML data into SQL Server 2005• Responsible for troubleshooting existing VB.NET applications for PhoneCaller utility and PhoneCallRules utility.• Responsible for troubleshooting and enhancing C++ Application to validate data going into Navigation units in Toyota and GM cars.• Created Documentation and Flow Charts for Applications developed.

• Maintained proprietary code and systems, using C++, VB.NET and VB6.0 to enhance and find defects in existing code, using internal procedures to identify, document defects, the code to fix and time management.• Responsible for troubleshooting issues identified in Helpdesk tickets.• Successfully implemented application releases.• Successfully implemented Application releases using SOX packages.• Very familiar with entire cycle of SDLC.• Frequently interacted with Business Analysts during Functional/Technical design phase.• Used Rational ClearCase, BMC Service Desk Express, and TestDirector.• Modified SQL Server 2000/2005 Stored Procedure to find policies.

• Modified SQL Server 2000/2005 Stored Procedure to find policies.• Worked closely with DBAs.• Used Rational ClearCase, BMC Service Desk Express, and TestDirector.• Very familiar with entire cycle of SDLC.• Frequently interacted with Business Analysts during Functional/Technical design phase.• Maintained proprietary code and systems, using C++, VB.NET and VB6.0 to enhance and find defects in existing code, using internal procedures to identify, document defects, the code to fix and time management.• Responsible for troubleshooting issues identified in Helpdesk tickets.• Successfully implemented application releases.• Successfully implemented Application releases using SOX packages.

• Assisted with supporting a proprietary system developed with Visual Basic 6.0.• Developed SQL Server 2000 Stored Procedures, Views, Triggers and Functions.• Interacted with users to find solutions to issues.• Created Design and Testing documents for the development of new projects.• Responsible for Maintaining Crystal Reports and Access Reports.

• Created Engineering Applications using Visual Basic 6.0, Access 2000, SQL Server 2000, ASP 3.0, C, Active X Components and Lisp.• Responsible for Designing, Maintaining, Debugging, and Testing Engineering Document Management (EDM) program. • EDM offered Engineering Change Order, Viewing and Printing drawings, searching Part Numbers and Drawing Markup Management capabilities.• Wrote Stored Procedures using SQL Server 2000.• Responsible for Time Tracker Program using DAO 3.6 to keep track of employees' time on the projects.• TimeTracker generated custom reports for the management.• Created Conveyor Quote Program to generate a quote by extracting Bill of Material information from drawings.• Conveyor Quote Program created a spreadsheet in Excel 2000 format.

Bachelor'S Degree In Computer Science, Computer Science

Masters Of Business Intelligence, Business Intelligence

Bsme, Mechanical Engineering

Bachelors, Engineering