Senior ETL Developer

• Jan 2022 - Present

Senior Database Developer

• Apr 2018 - Jan 2022

Established the connection between the legacy system and SQL Server Migrated data from the legacy system through SQL Server and completed 99% records mapping Formatted the report layout for the requirement of the end-users and deploy the developed reports on to the server for the end-users. Extensively investigated different data issues and communicated with clients to resolve the issues. Downloaded data from the FTP site, integrate data into a database and extract data for analysis. Obtained and analyzed the informational business requirements from various clients. Created database tables with various constraints including primary key, foreign key, etc. Loaded data from flat data files into SQL Server database tables using bulk insert, and table import; Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files Reformatted the data and inserted the reformatted data into the staging table, performed data cleansing and data type conversions and then loaded into the destination table Generated variety of business reports from SQL server using excel with a pivot table and pivot chart Created excel reports with pivot, drill-down and drill-through functions from Access Performing troubleshooting, diagnostics, customization, minor development, remote training. Setup, install, and testing existing developed databases as well as implemented, monitored, and maintained disaster recovery. Monitored and fine-tuned databases performance Use analytical skills to troubleshoot data problems surfaced through the reports as needed. Database support (SQL Server, MS Access) Developed database application using VBA Building stored procedures involving complex joins, subqueries, aggregate functions, User-defined functions using TSQL and advanced SQL for a variety of business requirements. Scheduled windows batch jobs and SQL jobs using SQL Server Job Agent. Handle tickets/issues affecting production and staging data on the web sites.

Sr. Manager Information Systems

• Aug 2017 - Mar 2018

Creating of master schedule for the implementation of the Campus Management System(CMS) along with the functionalities of ERP. Setting timelines for critical and non-critical activities and identifying them. Identifying the major bottlenecks and finding their solutions. Communication of the plan with the concerned departments and Senior Management. Creation of the MIS (Management Information Systems) department for being the custodian of the proposed new system. Identify the roles of each MIS team member. Training provision of all the involved person using the new system. Making sure the proper support is provided for the smooth implementation of the system. Proper selection of the hardware and procurement of the hardware which is in line with the new software being proposed. Making sure the proper list of reliable vendors for the procurement of the hardware is provided and vetted thoroughly. Making sure that the RFP has the complete details about the hardware specification, format, performance expectation, warranty, and service quality assurances. Making sure the HEC standards are met for Campus Management Smart Systems. Rigorous meetings with the vendors to find out what solutions being proposed. Ownership and understanding of the product being implemented. Identifying the change management requirements and making sure the system is reliable enough to handle any such required change. Software should be scale able.

IT Manager

• Jun 2010 - Dec 2014

* Creation of online Portal (Human Resource Management System) using ASP.NET and C#. * In house Web Server and SQL Server for handling the queries from different sites. * Detailed creation of a Web Portal for Equipment and Stock available at the store. * Complete Management Solution in accordance with the requirement of the Company. * Centralized Data base Management System creation. Tools Used : ASP.NET, SQL Server, VB * Creation of online Portal (Human Resource Management System) using ASP.NET and C#. * In house Web Server and SQL Server for handling the queries from different sites. * Detailed creation of a Web Portal for Equipment and Stock available at the store. * Complete Management Solution in accordance with the requirement of the Company. * Centralized Data base Management System creation. Tools Used : ASP.NET, SQL Server, VB

Business Intelligence Developer

• Sep 2009 - Feb 2010

Business Intelligence Developer using Microsoft technologies , Collection of data from a source database applying ETL Procedures to extract the relevant data. Cleansing it and bring it to more usable form for Marketing Intelligence Department. Creating relevant Marketing reports for Analysis and Forecasting. BI Architecture : MS SQL Server Database SQL Server Integration Services SQL Server Analysis Services SQL Server Reporting Services SSRS integration with MS SharePoint Dashboards and scorecards in MS Performance Point Query Optimization MySQL Data Analysis

Teacher

• Apr 2009 - Aug 2009

Subject of concern Information Systems to Bachelor students. Semester exams preparation Exams checking Lecture preparation Query Solving Subject of concern Information Systems to Bachelor students. Semester exams preparation Exams checking Lecture preparation Query Solving

Intern

• 2006 - 2006