Executive Assistant Data

Saqib Waheed

adkvcb@r.postjobfree.com • 847-***-****

EDUCATION UNIVERSITY OF ILLINOIS AT CHICAGO Chicago, IL

•Bachelor of Science in Information and Decision Science in 1994.

•Broad liberal arts education with emphasis on Management Information Systems.

TECHNICAL SKILLS SUMMARY

•Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.

•7 years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2014/2012/2008R2/2005/2000 in Production, Test, Development and Cluster Server Environments.

•Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000/2005/2008/2012/2014

•Experience in Disaster Recovery Planning, Execution and Testing at remote side.

•Experience in using SQL Server Tools like SSIS/DTS, Import/Export Wizard, SQL Server Management Studio/SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

•Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008 to MS SQL Server 2012/2014

•Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

•Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

•Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.

•Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2005/2008/2012/2014

•Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).

•Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008/2012/2014

•Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.

•Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

•Experience in designing/generating/using/deploying Visual Studio 2005/2008/2012/2014 Business Intelligence Reports, SQL Server 2005/2008/2012/2014 Reporting Services (SSRS), and Crystal Reports.

Sep 2015 - Dec 2020 1Source (NATIONAL REVENUE CENTER) Cincinnati, OH

Application Developer/Support

•Troubleshooting SQL Server including performance issue, manage users permissions

•Detailed knowledge of Microsoft SQL Server technology and how to Administer, create, upgrade, maintain, and customize manually and using SQL Queries

•Monitored SQL Server performance via SQL Profiler and the Windows System Monitor tool. Setup SSIS Packages to load data from Oracle Databases to SQL Server Databases, Scheduled jobs in SQL Servers to run SSIS Packages, loaded data from Excel to SQL Server

•Administered daily on-call server administration and support for production, internal Microsoft SQL Servers and other database systems, including maintenance and monitoring of Backup, recovery and performance

•Optimization strategies, profiling, disaster recovery planning, security, system status and etc., on a 24 hour, 7 days a week basis for efficient accessibility.

•Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.

•Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.

•Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

•Created/Modified/Support Microsoft Access Databases.

•Designed/Modified Forms/Tables/Queries/Macros/Modules/Reports in Microsoft Access Databases

•Created Queries/Modules to Upload Data Feeds every night to SQL Server Tables

•Created a Procedure to Export Data from MS Access Applications to other Systems

•Created a Procedure to Email Daily/Weekly/Monthly Reports to Managers

•Created Back-End SQL Server Databases for Microsoft Access Applications

•Created User’s Manual for all the Applications I Designed/Supported

•Created Software Version Description Documentation (SVD)

•Created Database Release Documentation

•Create/Register/Update a JIRA Ticket for Application/Database Changes

•Internal Revenue System Application Testing including writing Test Cases for System Testing

•Experience in analysis, design and development of client and server, web based and ntier application.

•Developed some web applications in Microsoft Visual Studio .Net IDE using .Net 2.0, 3.5, 4.0, 4.5, and SQL Server with T-SQL and stored procedures

•Working collaboratively within and across development and project teams in a fast-paced work environment, utilizing BI design.

•Experience in working with packages for data extraction and generating reports for business users.

•Ensuring the architectural goals are met on all development projects and participating in activities of development lifecycle including estimation, coding, unit testing, deployment, and maintenance.

•Participating in the development lifecycle activities, including estimation, coding, unit testing, deployment, and maintenance.

•Working with the principal developers to design, develop and deliver an entire application, i.e., interface, ETL, extract and BI application.

•Ensuring accuracy and integrity of data and applications through analysis, coding, profiling and problem resolution.

•Interacting with users and deliver the results up to their requirements.

•Creating member universe for the purpose of Ad hoc reporting against the data marts.

Nov 2010 – Aug 2015 BLUE RIBBON TAXI Chicago, IL

Independent Contractor

•Designed/Modified Data Entry Forms in Microsoft Access Databases and Modified Microsoft Access Databases.

•Setup SSIS Packages to load data from Oracle Databases to SQL Server Databases, Scheduled jobs in SQL Servers to run SSIS Packages, loaded data from Excel to SQL Server Databases.

•Administered daily on-call server administration and support for production, internal Microsoft SQL Servers and other database systems, including maintenance and monitoring of Backup, recovery and performance

•Optimization strategies, profiling, disaster recovery planning, security, system status and etc., on a 24 hour, 7 days a week basis for efficient accessibility.

Jan 2000 – Oct 2010 PROTECTIVE LIFE Elgin, IL

SQL Server DBA / Microsoft Access Developer

•Monitored SQL Server performance via SQL Profiler and the Windows System Monitor tool.

•Created and reevaluate indexing strategies and made needed modifications.

•Cleaned and maintained the database environment by archiving old data for better accessibility.

•Created various SSIS/DTS packages to assist with the Extraction, Transformation, and loading of data from existing legacy systems into SQL Server 2000/2005/2008.

•Importing Exporting Data between SQL Server 2000/2005/2008, distributed queries with MS Access 2000/2007 and Oracle Databases.

•Converted more than 300 Microsoft Access 97 databases to Microsoft Access XP, over 100 databases from Microsoft Access 2000 to Microsoft Access XP, dbase and Paradox databases to Microsoft Access 2000/XP and converted Microsoft Access 97/2000 databases to SQL Server 2000.

•11 years MS Access 97/2000/XP/2007 (design, development, and maintenance).

•3 year MS SQL Server 2005/2008 DBA (maintenance, tuning, troubleshooting,

•Backup/recovery strategy, security, failover clustering, transactional replications, log shipping, DTS, objects, logins, roles, rules, users and permissions, tables, relations, keys, indexes, constraints, and documentation).

•Upgraded databases from MS SQL Server 2000 and 2005 version to MS SQL Server 2008 version.

•Transferred SQL Server 2000 DTS Packages from SQL Server 2000 to SQL Server 2005 and Designed/Modified Integration Services Packages in SQL Server 2005.

•Provided daily reports Microsoft SQL error logs and event logs.

•Installed and configured SQL Server 2000 Enterprise Edition on the Windows 2000 Enterprise platform in a two node clustered environment

•Utilizing MS Clustering Services.

•Implemented Log Shipping and data Replication in order to maintain warm Stand-by locations and in order to off load processing to various reporting Databases.

•Designed and implemented appropriate backup and recovery procedures for Applications and SQL Server DBMS.

•Performed mission critical or point-in-time databases recovery whenever needed.

•Developed and periodically tested Disaster Recovery (DR) procedures and perform daily monitoring of transaction logs, growth, maintenance plan jobs, SQL and Agent service availability.

May 99 - Dec 99 NEW RESOURCES CORPORATION Rolling Meadows, IL

Technical Consultant

•Assisted Human Resources with the orientation program for new hires.

•Reviewed case studies to train new employees.

•Designed Entity Relationship, Data Flow, Process Flow and Decision Trees Diagrams for both systems.

•Prepared proposals and highlighting features of new system and the security System processes.

•Converted Lotus files to Excel and transferred the macros from Lotus to Excel.

Mar 99 - May 99 VERTEX AMERICA Chicago, IL

Executive Assistant

•Analyzed and modified the SQRs for Y2K compliance.

•Configured finance, payroll, and human resources application tables in client/server environment.

•Tested functionality of all interfaces, month end, quarterly, and year-end processing and developed test plans and test cases.

•Executed SQL statements in SQL Plus to develop test plans and modify existing SQRs to reflect the user request.

•Utilized Data Designer, Panel Designer, and Menu Designer to add/modify tables and panels according to corporate finance and human resources specifications.

Oct 98 - Jan 99 EAGLES INTERNATIONAL Dallas, TX

Reporting Analyst

•Designed an SQR which produces a fixed width data file and updated invoiced PS_PROJ_RESOURCES table.

•Supported the Common Billing Initiative (CBI) at CSC.

•Created an SQR reports based on criteria that enables calculations and counts the number of records.

•Programed LIS file to keep the SQR from returning a rerun code.

Apr 1995 – Sep 1998 FEDERAL RESERVE BANK OF CHICAGO Chicago, IL

MIS Specialist

•Experienced in financial, utilities, and manufacturing environment.

•Designed and Developed 27 Microsoft Access databases for various departments of Federal Reserve Bank.

•Utilized analytical tools (E-R Diagram, Data Flow Diagram) to design various database systems on Microsoft Access for Windows.

•Designed customized data entry forms and reports using Microsoft Access macros and modules and tested the prototype with actual data provided by the customer.

•Implemented system, prepared User’s Manual, and trained the staff personnel.

•Participated in project management requirement definition, conceptual system design, physical system design, system testing, and quality review.

•Proficient in People Tools including: Data Designer, Panel Designer, Menu Designer, Import Manager, Operator Security, Object Security, People Code, SQL/SQR, PS-Query, N-Vision, and Crystal Reports.

Jan 1995 – Mar 1995 LASALLE NATIONAL BANK Chicago, IL

Reorganization Assistant

•Filed claims on behalf of interested shareholders and compared checks received from corporations with claims and filled out deposit slips.

•Researched eligibility of shareholders to file claims by accessing mainframe, optical disk and micro fisher

Jan 1994 – May 1994 UNIVERSITY OF ILLINOIS AT CHICAGO Chicago, IL

Teacher’s Assistant (Information and Decision Department)

•Assistant for a Business Systems Design, an undergraduate course, lecturing and grading assignments.

•Participated in weekly collaborations to develop lecture methods and creative learning modules for students to participate with learning material.

References upon request

Contact this candidate