Tousif Imran

Contact #201-***-****

Email: adljev@r.postjobfree.com

Summary:

About 8 years of experience in design, development and implementation of MS Office / VBA based Applications.

Proven background translating cell formulas in Excel into VBA code.

Experience in creating Dashboards & UserForm in Excel/Access.

Created Macros & Reporting Tools for Business Development.

Expertise in Data Remediation, Root Cause Analysis and performs corrective action and processes the problems.

Create, maintain and provide production support to MS Access Databases and Excel Tools using VBA extensively.

Automate, modify, and optimize Reports in Excel & Access.

Experience in the development of financial applications using Excel and Access/VBA.

Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel & Access 2007 / 2010/ 2013/2016.

Experience in Advanced Excel and its features like Pivot Tables, Charts, Function etc. and transform a flat file/report to a PDF through VBA.

Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.

Experience in SQL statements, stored procedures using SQL server.

Experience in extracting, transforming and exporting data between different RDBMS using SSIS.

Used MS Excel/Access VBA & SQL to send system generated e-mails, manage and report embedded Excel documents.

Experience in generating reports using Access, SSRS & Crystal Reports.

Good experience in the implementation of all phases of SDLC from requirements gathering through implementation.

Prepared program level and user level documentation.

Excellent team co-ordinational, organizational and interpersonal skills with result-oriented approach.

Professional Skills:

Operating systems : Windows10, Windows7, Windows XP, Dos

Languages : T-SQL, Python, PL/SQL, VB 6.0, C#, Fox pro 6.0

VBA : MS Excel & MS Access 2007/2010/2013/2016

Management Tools : MS Project 2013, MS Visio 2013

Databases : MS Access, SQL Server, MySQL, Oracle

Reporting Tools : MS Access Reports, Crystal Reports, SSRS

Professional Experience:

Spectrum (Charter Comms.) - Stamford, CT Oct 2020 to Present

VBA Developer/Data Analytics & Reporting

Responsibilities:

Designed automated Reporting tools querying SQL database and other data sources utilizing MS Access VBA & SQL for the Sales Dept.

Designed Dashboards & Models to compare Weekly/Monthly Sales Reports.

Develop Excel based application to move / format data between sheets based on selection criteria using the Excel Object Model, VBA, Events & Combo boxes.

Enhanced an existing Excel application consisting of several VBA programs and macros.

Developed VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries; and linked the based module to enable automatic updates for excel workbooks.

Streamlined the existing MS Access system/reports for the Accounts departments by Normalized all Databases & Created data dictionary and created new reports as needed.

Prepared complex SQL query and download result of queries to Excel and Access for addition data analysis.

Maintained external database in SQL server and created automated update programs in Python

Created Tables, Relate tables, Queries, Forms and Reports in Access from scratch.

Developed database queries to fetch data from different Sources files.

Analyze chunk data and massage before importing to the Access database.

Used Excel VBA/Macros, MS Access and SQL queries to make reports in different styles and then distributed them as PowerPoint slides to various level of management.

Performed requirement gathering, testing, maintenance, debugging and documentation for every process.

Environment: Windows 10, VBA, MS Office 2016, MS Project, SQL Server 2012, Skype for Business, SAP, MicroStrategy, Tableau,

Danone, White Plains, NY Mar 2016 – July 2020

Sr. Data Analyst

Responsibilities:

Designed & developed several Reporting Tools for the Finance Department (Manufacturing) using extensive VBA & SQL Scripts.

Develop several Data Entry files for the users with automatic Links Update, Year to Date, Year to Go, 3 Month to Date & Full Year Calculations for a given dynamic time.

Developed the tool with KPIs comparison between Actual vs Budget, Actual vs Prior Year, Budget vs Prior Year, GPS/RF from 2014 to 2021.

Designed & Developed the NORAM Dashboards to Compare around 150 KPIs for 12 Factories.

Developed a User-Friendly Dashboard for users to enter the Line Operations Data for several Plants with Dynamic ranges and automate its consolidation with YTD & FY results and reflect the Column Bar Chart with Max to Min numbers.

Linked 90 different files from the Livelink to the Excel Tools for Prior and Future Years data and provided a functionality to update the links of individual years files based on selection. Later, migrated it from Livelink to Network drive.

Created Data Flow Diagram and documented the current data flow data elements.

Assist with the data transformations using SSIS including importing data from files, moving data from one database platform to another.

Provided Budget and Latest Estimate data of several Plants to analyze and trends tons of important KPIs with side by side Plants visualization & performance.

Linked data lineage to data quality and performed data remediation by organizing, cleaning and sorting the valuable data.

Create functionality to calculate Cost related KPIs and display the numbers in Euro Currency for the Consolidated Files consisting of different local currencies.

Developed automated Waterfall Charts to display Productivity variances.

Developed different customized charts using VBA Coding for visualizing KPIs for past 15 months from a dynamic time.

Extensively used Excel formulas including V-Lookups, H-Lookups, SumProduct, YTD, YTG, 3MTD etc. for manipulating and comparing data and importing and exporting tables between Excel and other Databases.

Provided Quarterly and Year Over Year Evolution for all the Executive KPIs.

Environment: Windows 10, IBM Notes, Livelink, SAP, MicroStrategy, VBA, MS Office 2016, SQL Server 2012, WorkChart, OneDrive, DanDock, SharePoint, WorkPlace

NYCHA, NYC Sept 2015 – Jan 2016

Access Developer

Responsibilities:

Design MS Access Application to provide Reasonable Accommodation for People with Disabilities.

Test Plan/Script/testing and UAT for the RAPD Application.

Fix the corrupted existing MS Access Application and Cleaned, Organized and Migrated the Data from 2003 to 2013 Database.

Gather requirement/information through meetings with Director and end users and structure the Project Plan in MS Excel Gantt Chart.

Standardize the complex database and developed a user-friendly Data Entry Application for Processing Reasonable Accommodation using VBA.

Create tables, assign indexed and create relationship between the tables.

Develop a dashboard to search a record with multiple options to find.

Create complex queries using multiple queries and tables to achieve the business goal.

Advanced used of SQL statements including transform to convert the data of particular rows into a column.

Extensively used SQL Queries to fetch and populate the data.

Provides assistance with ETL standards and design for future supportability and ease of enhancements with SSIS.

Provide functionality for attaching the current record on the screen to the Outlook email with the option of PDF or Excel Format.

Provide functionality for exporting only a bunch of related records as per user selection into PDF or Excel.

Populate a record to the data entry form based on user selection from the Data Grid - Subform.

Automate the time consuming existing manual report system.

Create a Snapshot Dashboard of the open and closed Cases of the Current& Previous Month, Current & Previous Quarter and Current & Previous Year.

Extensively used Excel formulas including V-Lookups for manipulating and comparing data and importing and exporting tables between Excel and Access.

Provide Classroom training to the users using PowerPoint Slides presentation and documentation for newcomer’s & future reference.

Environment: Windows 7, VBA, MS Office 2013, Siebel, MS Visio, SQL Server 2012, SharePoint

Beaumont Health System, Royal Oak, MI Apr 2015 – Aug 2015

Database Engineer

Responsibilities:

Design an Application for Tracking and Processing Physician Contracts in Access Database.

Gather business requirement by frequent session’s and one to one meeting with the management and the users.

Used Data Remediation to analyze and interpret the data.

Create MS Access User Login application with user access authentication.

Normalize complex database and automate the application using VBA.

Proposed new table structure for the application to the management.

Create tables, map the fields and build relationship.

Develop user friendly dashboard/home page for the application.

Create data entry forms for Physician Contracts with advance functionality.

Discussed the Data model, data flow and data mapping with the Management team.

Provided options from the frontend to send/attach a report as a PDF through outlook email.

Develop reports for tracking and processing the Physician contracts.

Enhance existing reports and automate manual reporting system.

Create reports to compare the Physician contracts between Oracle ERP system and MS Access Database.

Create reports to compare/cross check the Physician contracts between MSOW application and the MS Access Database.

Extensively used SQL Queries for manipulating and populating the data.

Created ETL Packages using SSIS to extract data from staging tables& performed tuning.

Used advance Excel for V-Lookups and importing and exporting tables between Excel and Access.

Provide necessary information and guidance of the application to the Heisenberg Application Team for future acquisition.

Environment: Windows 7, MS Office 2013, MS Visio, VBA, SQL Server 2012, MSOW, SharePoint

Fastpath Learning, Arlington, TX Jun 2013 – Mar 2015

MS Excel/VBA Developer

Responsibilities:

Developed Excel VBA application that communicates with DB using ADO Objects and SQL.

Developed macros to verify and compare data.

Developed and maintained Access Application for data retrieval. Previous method was taking Excel workbooks, translating to MS Access database, then exporting to SQL database.

Developed a simple and easy mechanism of database application for users to enter data without having to enter data into numerous delivered screens using Microsoft Access/VBA.

Developed macros for accounting and financial purpose.

Implemented several built-in excel functions and formulas.

Built macros/wizards for updating customer orders in MS Excel Application.

Implemented pivot tables and charts in Excel for summarizing data.

Imported data into excel from flat files.

Define reporting requirements and gather data, using Access and create management reports, also export data from MS access to MS Excel to create Pivot table for management do more data analysis.

Created Access database from scratch.

Assist in Migrating MS Office applications 2007 to 2013.

Prepared program-level and user-level documentation.

Environment: Windows 7, Visual Basic, MS Access, MS Excel, MS Project, VBA,VB.Net, SQL Server 2012, SharePoint

Education:

Master of Business Administration (MBA)

XXX-XXX

Contact this candidate