About Me
Experienced in ETL – Extract Transform and Load experience using DTS & SSIS (SQL Server Integration Services) in SQL Server 2005, 2008 and 2012. Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel ...
Full life cycle development of new systems - from requirement gathering, to coding the application, to testing and through to implementation and handover ▪ Development & coding of new functionality and enhancements to existing custom built systems ▪ Provide support for existing applications and escalations support for help desk queries ▪ Provide input and ideas into the design and development of business applications ▪ Hands on experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments. • Experienced in ETL – Extract Transform and Load experience using DTS & SSIS (SQL Server Integration Services) in SQL Server 2005, 2008 and 2012. ▪ Experienced in SDLC life cycle for Design, Development and Staging phases of the projects which is developed in Microsoft Technologies. ▪ Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View. • Extensive experience in implementing BI solutions using SSIS, SSRS. • Proficient in implementing business logic and procedure in backend using stored procedures and user defined functions. • Experience in creating Dashboards/KPI’s, Scorecards, Gauges, Reports, pivot tables for analysis in SSRS and MS Excel. ▪ Working knowledge of .Net Framework 2.0-4.5 (VB.NET and C#.NET), IIS Web Server. ▪ Highly Experienced in development of Manufacturing Application and CRM.
Show MoreSkills
Development Tools
Web Development
Programming Language
Database
Software Engineering
Others
Positions
Portfolio Projects
Company
Cloud based Vehicle Management & Tracking
Role
Project Manager (Team Lead)
Description
This application is used to manage the complete fleets and the tracking of vehicle is working through transfer of vehicle’s location from GPS devices fitted on vehicle to data server in the format of Latitude and Longitude. It has developed to support various verticals like Logistics, Staff Transportation, Education Institutes and Call Taxis.
Show More Show LessSkills
PHP 5 MySQL MS SQL Server 2008 Power BITools
Visual Studio (Win) Power BICompany
Foundry Execution System
Role
Backend Developer
Description
Foundry Execution System (FES) is a multi-user Client/Server Application, which automates the Total flow of a typical manufacturing Industry. This Application is designed in such a way that it is capable of computing the Information of multiple companies in a single system. This system includes the following main Modules.
Enquiry & Engineering:
The Functioning of this system begins from a Customer’s Enquiry. This module contains the Enquiry, Follow-up, Acknowledgement and Quotation transactions. The Enquiry is in turn analyzed by the Engineering/Sales Department by making a Technical/Commercial Review. The Result is produced as Bill of Material (BOM) for the Product.
Production:
This Production Schedule is processed and completely carried out by the various Work Centres. Production Planning made on each day depending on the Schedule provided. The Production Plan is submitted as a work-order to the Work Centres which also submits the Raw Material Request needed for the Production.
Stores & Purchase:
The Raw Material Indent for the Schedule is processed by the Stores Department, which updates the Stocks needed through Purchase/Sales. After Request, The Supplier’s response in the form of GRIN (Purchase Bill) is accepted and a Purchase Schedule is made and it contains the Purchase Order, Schedule Transactions and Supplier, Material Master Creation.
Sales & Sub-Contract:
The Customer’s response in the form of Customer Purchase Order (PO) is accepted and a Production Schedule, Indent to Raw Materials is made by here. This module contains the transactions are Customer Purchase Order, Letter of Credit, Schedule, Invoices, Lorry Receipt against Invoice, and Transport bill against Lorry Receipt. Sub-Contract module controls the entire process of Job-Work related transactions like Subcontractor Challan, Rejection Settings and Subcontractor Bill generation and Part Payment.
Accounts:
In this module user can made the cash and bank entries. Others like Purchase, Sales and Journal entries are automatically posted from the related modules. This module contains the transactions like Cheque Issue against Purchase and Subcontractor Bills, Cheque Receive against Invoices, Advance from/to Supplier/Customer and Agent Sales Commission. Trial Balance, Profit and Loss a/c, Balance Sheet and Bank Reconciliation Statement are the important reports in this module.
Company
PolicyPLUS
Description
PolicyPLUS is an medical and healthcare compliance and policy management software whose benefits include:
• Policy, procedure, and document management for healthcare organizations and medical practices.
• Credentialing, Quality, Contracts and Performance management.
• Easy distribution of new documents and changes across multiple locations and organizational units.
• Automatic email notification of upcoming document expirations.
• Automatic email notifications and reminders sent to employees with pending assignments due.
• Tracking and archiving of policy changes.
• Tracking of Insurance provider’s credentials.
• Email alerts warning of upcoming credential and credentialing cycle expirations.
• Reduction of risk and liability exposure.
• Tracking of your organizational and provider key performance indicators (KPIs), work plans, patient complaints, and incidents.
Skills
Web Forms SQL Server 2014Company
Saas Based Parcel Booking Management
Description
Parcel Booking management supports the logistic company to book their cargo (parcel) and movement(outward) of each and every cargo to other branches. Also, provides option to maintain the inward from other branches. Operates the Modules from Customer & Vehicle Management, Parcel Booking, Movement of Outward, Inward and Delivery of Cargo and Finance. Other modules includes Accounts and Vehicle Managemenr and Role based User Control,
Show More Show LessTools
Visual Studio 2017/2015