Junior Software Developer
Data Software Research Company (DSRC)
مجموع سنوات الخبرة :9 years, 10 أشهر
SQL development
•An in-depth grasp of SQL reporting, analytics and business intelligence
•Great expertise in processing data and flowcharting techniques
•Excellent understanding of database structures, principles, theories and practices.
•Great problem solving and analytical skills
•Good experience in creating complex stored procedures with dynamic SQL queries
•Proficient in enforcing business rules with triggers and user defined functions.
•Good in creating and monitoring SQL Server jobs and Auto Trigger Emails
•Good experience in all kinds database backup & restore strategies
•Good in creating user and logins with required permissions on both the server and Database
•Troubleshoot performance issues like Memory, Slow Running Queries, and Indexing etc.
•Good in asp .net using MVC
Indian Oil Corporation Limited
Student Intern -
Database - My SQL
Database - SQL Server 2012 / Oracle DB
Project Description:
This application to track the orders and the delivery person. Also to collect the information of the person like, How far in distance? Expected delivery time etc. Also generate automatic report for the concept Nightly process and monthly process with the help of hangfire.
Responsibilities:
•Retrieved and stored the customer data in SQL database table which returned by the API
•Compare the data even match partially and update the location details in the local SQL table
•Created a package in the customer Oracle DB to update the live data with return statements
•Created a stored procedure to generate the report by location, by date and by orders
•Maintain log’s for every data transaction
Database - SQL Server 2012
Technology - SSIS, SSAS, PowerBI
Project Description:
Organisations in residential, commercial, industrial waste collection and recycling, are re-positioning themselves in the growing, more circular economy. The application consists of Basic & Advanced Business Intelligence, Data Warehouse concepts on SQL Server Integration Services (SSIS). The application also has Analysis Services (SSAS) and reports using powerBI.
Responsibilities:
•Created SSIS packages to collect the data from different source database using Data Flow Task from control flow (ETL Process)
•Creating the source connection with the use of required data flow transformation
•Used some data flow transformation to change the records as per the user specification and load in the destination DB.
•Using the data viewer to check the data between any two transformation
•Created SSAS Cube with proper data source
•select the required fact table and dimension tables with the help of DSV
•Created Various Measures using DAX expression
•Exported SSAS cube to power BI, and generate reports in various dimensions with colorful and attractive designs
Database - SQL Server 2012
Project Description:
Learning Management System
Responsibilities:
•Analyzing different user requirements and coming up with specifications for the various database applications
•Planning and implementing capacity expansion in order to ensure that the company’s databases are scalable
•Identifying issues with the database and resolving them
•Diagnosing and resolving database access and checking on performance issues
•Monitored the performance of the database and checked on the execution time
•Developed various SQL servers and ensured that they were properly maintained and supported
•Ensured that the existing data warehouses, reporting systems and various tools were adequately supported
ASP .net using mvc
Database - SQL Server 2012
PROJECT DESCRIPTION:
It is a robust intranet application developed for managing the employee’s details in our organization. Every employee is provided with access to particular modules based on their role. The modules contain Info regarding Personal, Professional, Leave, Biometric attendance, Resource Mapping etc…
Responsibilities:
•Created and altered required tables.
•Created and Altered Stored Procedures.
•Involved in maintaining Back Ups.
•Created functionality for Auto Generated Mails and Templates.
•Designed Pages in MVC by use of HTML5 with Bootstrap CSS and jQuery
•Worked with various Modules such as Projects, Manage Employees, Utilities etc.,
PROJECT TITLE: Indian Oil Corporation In-house Project
ASP .net using ADO
Database - SQL Server 2008 r2
PROJECT DESCRIPTION:
Part of the Indian Oil IT division and worked on their ongoing various internal projects.
Responsibilities:
•Involved in design and development of 360-degree application (Tender Management Application).
•Involved in design and development & maintenance of Indian Oil Southern Region Intranet site.
•Involved in design and development of Sports Kid application (Intranet Sports management portal)
•Involved in design and development of Leave Management Intranet site.
First class