際際滷

際際滷Share a Scribd company logo

DIPEN AMIT MISTRY Resumea

Atul Sharma
Atul Sharma

Dipen Mistry is seeking a challenging career in the IT industry to utilize his skills and enhance his knowledge on new technologies. He has over 2 years of experience as a Software Engineer and Process Facilitator at L&T InfoTech, where he has developed web and desktop applications. He holds a Bachelor of Technology degree in Electrical and Electronic Engineering from the National Institute of Technology, Goa. His skills include C#.NET, SQL Server, HTML, CSS, and AngularJS. Notable projects include a commissions and deductions system using Access and SQL Server, a ticketing system using C# and SQL Server, and a content management system using AnyDoc, Oracle, and Apex.

1 of 5
Download to read offline
DIPEN A. MISTRY PERSONAL DETAILS Address : 202, Swapna Appt., Zanda Chowck, Silvassa, U.T of Dadra & Nagar Haveli 396230. India. Contact Number : +91-8275386222 Email : damistry10090@gmail.com Date of Birth : 25th March 1993 Nationality : Indian Languages Known : English, Hindi and Gujarati CAREER OBJECTIVE I am looking forward to join a progressive organisation to acquire a challenging career in IT Industry, in order to utilise my skills and enhance my knowledge on new technologies. I have a high level of personal morals and integrity. I am a strong and cooperative team member with excellent communication. I am goal orientated, self-motivated and committed to my work and have excellent analytical and problem solving skills. SYNOPSIS Over 2 years of experience in the IT industry; currently working for Larsen and Toubro (L&T) InfoTech as a Software Engineer, and Process and Quality Facilitator. Experience in developing Web applications, dashboards, Console applications and migrating database from Microsoft Access to Microsoft SQL Server. Gained a Bachelor of Technology in Electrical and Electronic Engineering from the National Institute of Technology, Goa. SKILLS SKILL AREA SKILL LEVEL Business Applications MS Word PowerPoint Excel Access Outlook Intermediate Intermediate Intermediate Advanced Advanced
Data Management MS SQL Server Oracle Advanced Basic Languages HTML CSS T-SQL PL-SQL C#.Net VB.Net JavaScript Angular JS MVC Intermediate Intermediate Advanced Basic Advanced Intermediate Intermediate Intermediate Basic Software/Tools Visual Studios 2010 AnyDoc SSRS Advanced Intermediate Intermediate Operating Systems Windows NT Intermediate PROJECTS Whitecap Commissions and Legal Deductions System L&T InfoTech Role: Development Lead Tools: Microsoft Access, Microsoft SQL Server 2012, MS Excel Macros, SQL Server Reporting Services (SSRS) Details This is a MS Access based application that acquires the sales obtained, Invoice details and purchase details for a given vendor in the previous months and calculates the deductions to be paid to the employee. This application also calculates the Commissions to be paid by the employer, which is calculated on the basis of the sales done for the particular month. The Front end for this application was MS Access with SQL Server as the back end. The project included the following : o Project Analysis and Requirement gathering. o Development of Stored Procedures in the SQL server DB to perform all the logics required to produce the commission details. o Creating Macros in MS access to fetch the data from linked Excel sheets into the SQL Server.
o Optimizing the Macros and Stored Procedures for quicker results. o Developing Forms in MS Access front end application and using VBA code to interact with the SQL Server. o Generating Complex reports consisting the sales, Commissions and Legal Deductions paid for the previous months using SQL Server Reporting Services (SSRS). MDB Ticketing System L&T InfoTech Role: Application and Database Developer Tools C#.Net, SQL Server 2012, SSRS, SSIS Details MDB is a Ticketing System built using C#.NET and SQL Server. This system is used to keep a track of the day to day efforts spent by the team member. These efforts are then used to prepare the project metrics, monthly reports and graphs to analyze the productivity and deliverables of the team. The system also regularly sends reminder mails to the team and continuously checks for the efforts recorded in the system. The Application included the following key contributions: o Requirement Gathering, analyzing the structure and design of the application. o Designing the Database, developing the DB Structure and maintaining it. o Developing Stored Procedures and Query Optimization. o Configuring SQL Jobs to send reminder mails and follow-up mails to the user using SQL Server. o Developing major Modules in the Website using C#.Net. o Designing UI using angular JS, CSS and HTML. o Generating different project reports using SSRS and storing them into the shared folder using SSIS. Content Management System L&T InfoTech Role: AnyDoc Template and Web application Developer Tools: Oracle 10g Express Edition, AnyDoc and Apex Details: Content Management System is a team that develops Templates in AnyDoc (Optical Character Recognition Tool), which OCRs the Information from the Scanned Invoices and inputs the data in to the Oracle DB.
Once this data is available in the DB, it is then verified by the users using an Apex front End application. The Key Role and contribution in the Project Includes: o Creating Templates in AnyDoc to filter the Invoices depending upon the Line of Business, Location and Vendors and sending the fetched data to DB. o Developing Dashboard to Project the Sales done by different departments for each Day, using C#.Net. Creating Packages in Oracle DB using PL-SQL, to interact with the Dashboard. o Building a Console application using C#.Net to fetch mails from a production Email account and process them. The mails consists of Scanned Invoices (.pdf format) and the application would store the pdf file into a shared location, from where AnyDoc would pick it up and process further.. The path for the location was determined on the basis of the information present in the Subject for every mail. o Developing console application using C#.Net to fetch the scanned Invoice from a SharePoint library. This Document is then stored into a shared location depending upon the information present in the metadata of the document. o Monitoring AnyDoc Servers and maintaining the Jobs present. o Troubleshooting the errors obtained in the execution of the PL-SQL packages and fixing them. EDUCATION National Institute of Technology Goa, India July-2010 May 2014 Bachelor of Technology CGPA: 8.29/10 Electrical & Electronics Eng. Fr. Agnelo High School, Silvassa , India March-2010 Higher Secondary Examination Marks: 71.4% GSEB Board Fr. Agnelo High School, Silvassa, India March-2008 Higher Secondary Examination Marks: 81.54% GSEB Board B Tech Project Undertaken Major Project: Fuzzy Logic Controller based Shunt active filters for power quality improvements. Internship Project: Exact reconstruction in 2D dynamic CT: Compensation of uniform scaling and translational deformation. B Tech Internship, Training & Research Paper Summer Internship on Medical Imaging at Dept. of Electronics & Communication Engineering, National Institute of Technology Karnataka (NITK), Surathkal and a journal paper on the same has been accepted in the Open Journal of Medical Imaging (OJMI) Published a Journal paper on the major project in WASET Journal Power Quality Improvement Using PI Controller and Fuzzy Logic Controllers Based Shunt Active Filters.
Published a Journal paper on the major project in WASET Journal Adaptive Hysteresis Based SHAF Using PI and FLC Controller for Current Harmonics Mitigation. Extra-Curricular Activities & Hobbies I like to work out in gym and maintain a healthy life. I am very fond of listening to music and dancing once in a while. I love spending time with family and going out on short trips, just to have some family time. I like to compete with friends in solving aptitude tests and playing chess.

More Related Content

DIPEN AMIT MISTRY Resumea

  • 1. DIPEN A. MISTRY PERSONAL DETAILS Address : 202, Swapna Appt., Zanda Chowck, Silvassa, U.T of Dadra & Nagar Haveli 396230. India. Contact Number : +91-8275386222 Email : damistry10090@gmail.com Date of Birth : 25th March 1993 Nationality : Indian Languages Known : English, Hindi and Gujarati CAREER OBJECTIVE I am looking forward to join a progressive organisation to acquire a challenging career in IT Industry, in order to utilise my skills and enhance my knowledge on new technologies. I have a high level of personal morals and integrity. I am a strong and cooperative team member with excellent communication. I am goal orientated, self-motivated and committed to my work and have excellent analytical and problem solving skills. SYNOPSIS Over 2 years of experience in the IT industry; currently working for Larsen and Toubro (L&T) InfoTech as a Software Engineer, and Process and Quality Facilitator. Experience in developing Web applications, dashboards, Console applications and migrating database from Microsoft Access to Microsoft SQL Server. Gained a Bachelor of Technology in Electrical and Electronic Engineering from the National Institute of Technology, Goa. SKILLS SKILL AREA SKILL LEVEL Business Applications MS Word PowerPoint Excel Access Outlook Intermediate Intermediate Intermediate Advanced Advanced
  • 2. Data Management MS SQL Server Oracle Advanced Basic Languages HTML CSS T-SQL PL-SQL C#.Net VB.Net JavaScript Angular JS MVC Intermediate Intermediate Advanced Basic Advanced Intermediate Intermediate Intermediate Basic Software/Tools Visual Studios 2010 AnyDoc SSRS Advanced Intermediate Intermediate Operating Systems Windows NT Intermediate PROJECTS Whitecap Commissions and Legal Deductions System L&T InfoTech Role: Development Lead Tools: Microsoft Access, Microsoft SQL Server 2012, MS Excel Macros, SQL Server Reporting Services (SSRS) Details This is a MS Access based application that acquires the sales obtained, Invoice details and purchase details for a given vendor in the previous months and calculates the deductions to be paid to the employee. This application also calculates the Commissions to be paid by the employer, which is calculated on the basis of the sales done for the particular month. The Front end for this application was MS Access with SQL Server as the back end. The project included the following : o Project Analysis and Requirement gathering. o Development of Stored Procedures in the SQL server DB to perform all the logics required to produce the commission details. o Creating Macros in MS access to fetch the data from linked Excel sheets into the SQL Server.
  • 3. o Optimizing the Macros and Stored Procedures for quicker results. o Developing Forms in MS Access front end application and using VBA code to interact with the SQL Server. o Generating Complex reports consisting the sales, Commissions and Legal Deductions paid for the previous months using SQL Server Reporting Services (SSRS). MDB Ticketing System L&T InfoTech Role: Application and Database Developer Tools C#.Net, SQL Server 2012, SSRS, SSIS Details MDB is a Ticketing System built using C#.NET and SQL Server. This system is used to keep a track of the day to day efforts spent by the team member. These efforts are then used to prepare the project metrics, monthly reports and graphs to analyze the productivity and deliverables of the team. The system also regularly sends reminder mails to the team and continuously checks for the efforts recorded in the system. The Application included the following key contributions: o Requirement Gathering, analyzing the structure and design of the application. o Designing the Database, developing the DB Structure and maintaining it. o Developing Stored Procedures and Query Optimization. o Configuring SQL Jobs to send reminder mails and follow-up mails to the user using SQL Server. o Developing major Modules in the Website using C#.Net. o Designing UI using angular JS, CSS and HTML. o Generating different project reports using SSRS and storing them into the shared folder using SSIS. Content Management System L&T InfoTech Role: AnyDoc Template and Web application Developer Tools: Oracle 10g Express Edition, AnyDoc and Apex Details: Content Management System is a team that develops Templates in AnyDoc (Optical Character Recognition Tool), which OCRs the Information from the Scanned Invoices and inputs the data in to the Oracle DB.
  • 4. Once this data is available in the DB, it is then verified by the users using an Apex front End application. The Key Role and contribution in the Project Includes: o Creating Templates in AnyDoc to filter the Invoices depending upon the Line of Business, Location and Vendors and sending the fetched data to DB. o Developing Dashboard to Project the Sales done by different departments for each Day, using C#.Net. Creating Packages in Oracle DB using PL-SQL, to interact with the Dashboard. o Building a Console application using C#.Net to fetch mails from a production Email account and process them. The mails consists of Scanned Invoices (.pdf format) and the application would store the pdf file into a shared location, from where AnyDoc would pick it up and process further.. The path for the location was determined on the basis of the information present in the Subject for every mail. o Developing console application using C#.Net to fetch the scanned Invoice from a SharePoint library. This Document is then stored into a shared location depending upon the information present in the metadata of the document. o Monitoring AnyDoc Servers and maintaining the Jobs present. o Troubleshooting the errors obtained in the execution of the PL-SQL packages and fixing them. EDUCATION National Institute of Technology Goa, India July-2010 May 2014 Bachelor of Technology CGPA: 8.29/10 Electrical & Electronics Eng. Fr. Agnelo High School, Silvassa , India March-2010 Higher Secondary Examination Marks: 71.4% GSEB Board Fr. Agnelo High School, Silvassa, India March-2008 Higher Secondary Examination Marks: 81.54% GSEB Board B Tech Project Undertaken Major Project: Fuzzy Logic Controller based Shunt active filters for power quality improvements. Internship Project: Exact reconstruction in 2D dynamic CT: Compensation of uniform scaling and translational deformation. B Tech Internship, Training & Research Paper Summer Internship on Medical Imaging at Dept. of Electronics & Communication Engineering, National Institute of Technology Karnataka (NITK), Surathkal and a journal paper on the same has been accepted in the Open Journal of Medical Imaging (OJMI) Published a Journal paper on the major project in WASET Journal Power Quality Improvement Using PI Controller and Fuzzy Logic Controllers Based Shunt Active Filters.
  • 5. Published a Journal paper on the major project in WASET Journal Adaptive Hysteresis Based SHAF Using PI and FLC Controller for Current Harmonics Mitigation. Extra-Curricular Activities & Hobbies I like to work out in gym and maintain a healthy life. I am very fond of listening to music and dancing once in a while. I love spending time with family and going out on short trips, just to have some family time. I like to compete with friends in solving aptitude tests and playing chess.