Jugal Patel Email and Phone Number

• Acted as a technical developer between internal BI-Vertical teams and the IT-P270 team.• Successfully developed and managed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Hadoop, Teradata, Oracle, Netezza, Snowflake and Flat files and loaded into Teradata/Snowflake files using DMExpress (Syncsort)/ Talend.• Collaborated with members of the Data Warehousing, Operations, and Research & Analytics teams in order to implement new processes and resolve issues by using BI tools like Teradata , SQL Server Reporting tool, IBM – Netezza , Micro Strategy, Tableau, Hadoop (Hive), and Snowflake.• Bulk loading from the external stage (AWS,S3) and internal stage to Snowflake Cloude using the COPY Command.• Designed and maintained large-scale Teradata databases, including creating physical and logical models, implementing data transformations.• Developed and maintained ETL scripts to load data from various sources into the data warehouse using Teradata utility.• Experience with BI tools like Tableau Desktop, Tableau Server and Micro Strategy front-end reporting and automation scheduling tool like Tidal and One automation .• Multiple rich dashboards were created using Tableau Desktop to showcase business status, strengths and weaknesses, and potential, with visual representations of profitability, products, and customers.• Performed research and enhancement to existing Ad-hoc requests by designing/developing/modifying tables, views,materialized view, stored procedures, packages and functions using Teradata, MS SQL/PL SQL, Micro Strategy (IVR Reporting) and IBM-Netezza.• Worked with SVN of Controlling versions for all files & Folders (Check-out, Check-in).• Performed SharePoint development with InfoPath and SharePoint Designer by creating custom lists, libraries, workflows and forms as well as performed admin work for security configuration and site templates/solutions.

This project encompasses development of new applications and maintain old applications using .Net and C#. Gained tremendous experience with SQL queries, store procedures, function and triggers. Also worked with SAS, Aspen related tools, SQL+ and SharePoint Admin .etc. • Responsible to create all new application using C# .NET and .NET Framework.• Developed some Applications using MVC 3 framework.• JavaScript, Ajax and XMLHttp, HTML, DHTML web client- Concentric skill sets. • Experience in data object models like Language-Integrated Query (LINQ) and Entity Data frame work. • Experience in database related work primarily creating complex stored procedure, SSIS, Views, Triggers, Functions, using PL/SQL, T-SQL.• Very good experience with Reporting Tools SQL Server Reporting Services (SSRS) and Crystal Reports.• Aspen IP 21 database development and administration.• Experience with Aspen process graphics, aspenCalc and Aspen excel Add-in.• Created new Aspen SQL plus querys as per plant requirement. • Responsible for the systems administration of the SharePoint Intranet.• Creating workflows using SharePoint designer and Microsoft InfoPath. • Design and establish a SharePoint application to support user requirement in company. • Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.• Extensively used Data _Null_ and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.• Generated high quality reports in the form of listing, TXT, HTML, RTF, EXCEL and PDF formats using SAS ODS.

• Implemented all the Core Java Concepts in implementing the project.• Designed and developed the Account Payment Grouping.• Designed and developed the user interface using JSP,HTML, AND Java Script• Developed the web application using Struts Framework.• Java Script used for Client side validations.• Developed persistence layer using custom Data Access Layer and JDBC as the persistence mechanism.• Developed state full session beans for implementing Business logic.• Developed SQL queries and used PL/SQL stored procedure in oracle database.• Developed Business Delegate classes for lose coupling between Presentation tier and Business tier.Environment:JSP, Struts 1.1, EJB, XML, HTML, JavaScript, CSS, JDBC, Oracle 8i, UML, Web Logic.

• Worked in a highly dynamic environment and adapted well to constant requirement changes.• Developed numerous .Net visual controls and Windows forms involving web service and multi-threaded calls• Integrated 3rd party .Net controls throughout the application• Wrote many business objects and data access using C# and T-SQLEnvironment:C#, Web services, VSS, SQL Server, ASP.Net, and Developer Express.