Syed A Zaidi

*** ******** ***** ***

Hoffman Estates, IL 60169

630-***-****

Email: ad3o1m@r.postjobfree.com

Status in USA: US Citizen

Professional Summary

10+ years’ experience in ETL, database development using SQL Server 2005/2008/2012/2016, SSMS, MS Access/VBA, Oracle 11g, DB2, FoxPro and dBase.

9+ years’ experience in using T-SQL, Stored Procedures, Reporting using SSRS, Data Integration using SSIS, Data Analysis using SSAS under SQL Server 2005/2008/2012/2016.

10+ years programming / database development experience in COBOL, SQL Server, DB2, JCL under UNIX using VI editor. Trouble shooting batch programs under mainframe environment.

IBM Certified Solution Developer (InfoSphere DataStage V8.0)

10+ year’s excellent experience in financial data analysis, budget and expenditures.

10+ years’ experience in conducting family planning / health surveys, questionnaire designing, data analysis and programming. Experience in Population Projections using DEMPROJ.

10+ years’ experience in data collection, cleaning and quality assurance.

10+ years’ experience in data analysis / programming using SPSS, SAS Base and Excel using pivot tables.

10+ years’ experience in information gathering, discussing systems, and placing under technical environment.

Developed dashboards and reports under Cognos, Tableau, Crystal Reports, and QlikView using dimensions and measures/fact tables.

Worked under Salesforce environment and created custom objects, fields, reports, dashboards, formulas, and merged duplicate records.

Excellent in using SharePoint, MS Excel, Word, PowerPoint, MS Office Project and other software.

Technical Skills

Database Development

SQL Server 2005/2008/2012/2016

Oracle 11g

DB2

MS Access/VBA, FoxPro 2.6 /dBase-4

Salesforce

Programming Languages/SQL Server

VBA, T-SQL, Stored Procedures, SQL Server 2005/2008/2012/2016.

COBOL under UNIX using VI editor

COBOL, SQL, DB2, JCL on IBM Mainframe platform

FORTRAN on IBM Mainframe

Statistical Analysis, Publishing, and Reporting Tools

Power BI, Cognos, Tableau, QlikView, and Crystal Reports

SSAS, SSRS

SharePoint

SPSS, SAS Base, Demproj

ETL Job Design for Data Warehouse

Used SSIS and DataStage V8.0 to develop and run ETL jobs for fact and dimension tables under a Data Warehouse environment.

Certification

On-Line Course attended for IBM InfoSphere DataStage V8.0.

Certification in IBM InfoSphere DataStage V8.0 from USA.

Training

Attended AS/400 System Facilities training organized by IBM from Dec 16 -20, 1990 Pakistan.

Business Analysis

Requirement Gathering.

Translating Business requirements to functional and technical language with the help of existing and previous cases.

Target setting keeping in view the previous business response.

Providing analysis and business perspectives on many financial and operational issues.

Data Collection & Editing

Data collection using questionnaire during national surveys.

Data collection on regular forms.

Data collection on web enabled forms.

Editing data and managing data collected through surveys or regular forms.

Quality Assurance

Data cleaning and Quality Assurance by designing and developing edit checks.

Project Management

Developing projects plans and KPIs

Monitoring different projects according to defined timelines.

Operating Systems

UNIX

Windows

DOS

Editor(s) Used

VI Editor (Extensive)

Windows based editors (Extensive)

Professional Experience

May, 2022 – To Present

Radiological Society of North America (RSNA)

820 Jorie Blvd # 200, Oak Brook, IL 60523

Sr.ETL/SQL Developer

Testing of APIs in Postman for ETL jobs.

Export the project from Integration Services Catalogs\SSISDB as .ispac file and imported in Visual Studio 2017 and re-deployed the same project for TargetServerVersion 2019.

Used JSON source (REST API or File) to load data to the destination table in SQL Server database.

Used ZappySys ZS Upsert Destination (Insert, Update, and Delete) for the target table in SQL Server database using Visual Studio 2017.

Used JSON Parser Transform to parse data to SQL Server tables.

Used ZS Amazon S3 Storage task to get data from source connection\path\path variable to target path\path variable mostly using the Overwrite option.

Handling of Null fields from staging area to target tables.

Created standard environment variables for ETL deployment.

Created staging tables and target tables using DDL.

Created unique index and Non-unique, Non-clustered indexes for the tables.

Used Kanban board to check the status of tickets assigned.

Upgrade to Visual Studio 2017 with ZappySys for SQL Server 2019.

Integrated data using SSIS packages from source to staging and from staging to target table.

Developed reports using Power BI, SSRS and Crystal Reports.

Completed a crash course in ElasticSearch and Kibana and applied queries to filter, search and delete data by applying (_search, _delete_by_query, _cluster/health, _nodes/stats etc.).

Jul, 2019 – Apr, 2022

The Bradford Group World Headquarters - Chicago

9333 N. Milwaukee Avenue, Niles, IL 60714

Sr.ETL Developer

Worked for different projects and data mart to develop SSIS packages under ETL framework using SSIS and SQL code.

Created staging tables and target tables using DDL.

Created unique index and Non-unique, Non-clustered indexes for the tables.

Created ODBC connections to load data from source to staging tables.

Developed SSIS packages to integrate data from source to staging and from staging to target table.

Developed stored procedures using SQL to merge data from staging table to the target table using batch size. The company uses standards to develop stored procedures while merging from staging to target table.

Tested stored procedures to remove errors in case of broken logic.

Developed data mart by creating fact and dimension tables.

Performed quality assurance of data from source to target by matching total number of records and sum of integer/decimal columns at both ends.

Handled errors related to unique index violation, duplicate records, violation of primary key constraint, cannot insert NULL value in column, connectivity error and others.

Deployed SSIS projects to Integration Services Catalogs\SSISDB using Visual Studio 2015 under Dev, Test and Production environments.

Nov, 2018 – Jun, 2019

Sysmex America,

577 Aptakisic Rd, Lincolnshire, IL 60069

Sr.SQL/ETL Developer

Developed packages for data profiling using SSIS to analyze each column frequency using column counts and column nulls. This helped in dropping the columns having most of the data as NULL.

Designed data model using filtered data having higher %age frequency.

Created schemas to load/populate data in staging and production.

Merged SSIS packages in containers for a sequence run.

Developed packages to read data from multiple excel sheets and populated the data to SQL Server tables.

Created fact and dimension tables by joining multiple tables and used these for report development in Power BI.

Deployed SSIS packages to Integration Services Catalog SSISDB.

Created job schedule under SQL Server Agent and added error notifications for each job failure at a particular step.

Created dynamic connections for SSIS packages to run in Dev/Test/Prod environments.

Developed SSIS package to load data from local drive to SFTP server using script.

Developed complex SQL code, stored procedures, and views according to the requirements.

Jul, 2018 – Oct, 2018

Baxter International Inc.,

25212 IL-120, Round Lake, IL 60073

Sr.ETL/DB Developer

Developed packages for Baxter local environment using SQL Server 2014 and SSIS as an ETL tool. Applied SQL Server code to extract data from linked database(s).

Developed ETL packages for Baxter global environment under DataStage Ver 11.3 to perform Insert/Update/Delete operations by extracting data from multiple sources like Oracle, DB2, flat files and others.

Applied stages like Lookup, Merge, Join, Transformer, Aggregator, Funnel, Remove Duplicates, Change Capture, Slowly Changing Dimensions, Filter, Copy, Sort and others under DataStage 11.3. Created sequence jobs for multiple environments to run in a sequence. Created parameter sets to access data and Servers by using username and password. Extracted data by initially creating views for given criterion using Oracle.

Developed packages under Oracle to improve performance for those packages which are running slow developed under DataStage 11.3.

Updated stored procedures to improve query performance.

Jan, 2018 - Jun, 2018

Associated Bank

Milwaukee, WI

Sr.ETL Developer/Systems Analyst

Development of ETL packages using SSIS 2014.

Created job sequence to run multiple jobs according to a given sequence.

Extract data by applying SQL code in SSIS package.

Conversion of data according to BAI format.

Unit testing of data using SQL code.

Loaded data from source to stage table using SSIS.

Developed stored procedures to merge data from stage table to target table.

Mar, 2017 - Dec, 2017

National Marine Manufacturers Association,

Chicago, IL

Sr.ETL Developer/SQL Programming Analyst

Development of ETL packages under SSIS to extract data from multiple sources and integrate the same for data warehouse.

Perform testing of the packages under development and production environments.

Package and Report deployment on SSIS/SSRS Server.

Writing SQL code to join tables and perform filtering on data according to the given conditions. Develop T-SQL, stored procedures, views, UDFs, and triggers.

Create ad-hoc reports using Crystal Reports or SSRS/Power BI.

Performed data analysis using SAS Base and developed statistical reports under Tableau.

Linked SQL Server tables and Excel sheets with MS Access 2010 using VBA and generated reports by integrating multiple platform tables.

Feb, 2016 - Feb, 2017

WPS Health Solutions Madison, WI

Sr.ETL Developer

Development of ETL packages for health projects using SSIS and SQL Server 2008/2012.

Extract data using facets tables as source and OLE DB as target.

Generated dashboards parameterized/drill through/drilldown and linked reports under SSRS/Power BI and Tableau.

Promoted packages to dev, test, and prod environment using GIT.

Created package level and task level variables and integrated SQL commands within variables.

Created master packages by including child packages.

Created links using expressions to make the package more adaptable in changing environments like dev, test and prod.

Developed packages for Inserts, Updates, Deletes and Reactivates processes.

Configured package using Package Configurations.

Submitted packages to run on-demand or per schedule using Control-M and IS Service portal.

Linked SQL Server tables and Excel sheets with MS Access 2010 using VBA and generated reports by integrating multiple platform tables.

Jan, 2015 - Jan, 2016

Health Care Service Corporation

Chicago, IL

Database Developer/SQL Programmer

Developed database for HCSC using standard operating procedures given in documentation.

Designed and developed T-SQL, views, UDFs, triggers, and stored procedures to extract data from different files and wrote to the destination tables.

Designed tables under SQL Server and created all the referential integrity.

Performed standard ETL operations using SSIS.

Dashboards and reports were developed for various departments using Power BI.

Developed searches and created reports using SSRS.

Financial reports developed under Tableau and performed data analysis under SAS Base.

Linked Excel data and SQL Server tables at back end using VBA code with MS Access database.

Apr, 2014 - Jan, 2015

Baxter Healthcare

Deerfield, IL

Database Analyst/Developer

Developed stored procedures to match required variables from different tables by converting existing data to SQL Server using SSIS, T-SQL, Triggers and Constraints.

Designed Value Stream Mapping (VSM) to make data processing more efficient.

Analyzed the structure of different countries regarding “Global Tenders Data” to design ETL procedures for extraction of specific data using SSIS.

Managed fact and dimension tables placed under data warehouse using T-SQL and SSIS.

Used Apex Data Loader to perform ETL operations under Salesforce Sandbox environment for Bio360 Compliance Integration (BCI) project.

Developed reports using SSRS and created data cubes using SSAS.

Used MS Access and VBA code as front-end and SQL Server 2012 as back-end for converted database.

Jan, 2014 - Mar, 2014

New York State Department of Health

Empire State Plaza, Albany, NY 12201

Programmer

Converting the existing database from Access to SQL Server.

Designed the system for ‘Extramural Grants Administration’ based on Access as front-end and SQL Server as back-end.

Transferred all the records from Access to SQL Server and removed errors occurred during this process.

Developed the relationship among tables which was available in the previous system.

Re-designed the forms based on SQL Server for data entry, editing and deletion of records.

Analyzed the existing database and develop more comprehensive procedures.

Developed macros for buttons like Save, Update, Delete, Search and others.

Designed views and reports using T-SQL, SSIS, SSRS, SSAS, and Stored Procedures under SQL Server 2012, Access/Excel, Macros, and VBA.

Used SSIS to design ETL procedures for data warehouse.

Uploaded grants data/reports for internal usage using SharePoint.

Jul, 2013 - Dec, 2013

Discover Financial Services

Riverwoods, IL

MS Access/SQL Server Database Developer

Analyzing the existing database and develop more comprehensive procedures.

Developed VBA procedure to upload data from Excel sheets into Access tables.

Designed controlled forms using VBA code.

Developed dashboards for selection of different criterions to run queries/reports using SSRS.

Designed and developed database for ISSUES and ACTIONS using Access.

Developed Test Plan forms and make it auto populated in Testing forms using VBA and Access database.

Performed ETL operations using SSIS for data warehouse fact and dimension tables.

Designed searches, views, queries, and reports using T-SQL, SSIS, SSRS, SSAS, and Stored Procedures under SQL Server 2012, Access/Excel and VBA.

Discussed existing system and included fields in new tables for better system designing and data handling.

Requirement gathering, business analysis, and adding the data in system flow.

Used SharePoint to publish Issues/Actions reports for internal usage.

Jan, 2011 – Jun, 2013

Nestle

Glendale, CA

MS Access / SQL Server Database Developer

Designed tables and created relationship among them.

Developed forms using dependent and independent fields.

Developed queries using multi-sort order.

Wrote VBA procedure to upload data from multiple excel data sheets.

Handled null values while reading data from excel and writing to access tables.

Designed text search and other searches using input from forms and searching the required data in tables.

Developed dashboard for different queries and reports using VBA code and QlikView.

Extracted data from different tables and incorporated the same into excel for analytical purpose.

Developed ETL processes for data integration and performed conditional split on source data using SSIS.

Designed ad-hoc queries, views and reports for immediate data analysis using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2012.

Designed and developed database for items and orders using Access/VBA from scratch.

Collected information for system designing and discussed each field in detail with the manager.

Business analysis, information collection using different sources, and converting information into technical documentation.

Prepared reports using Access/Excel.

Used Lotus Notes for email, meetings and scheduling.

Published sales reports for different components using SharePoint.

Jan, 2009 – Dec, 2010

Hewlett Packard

Mount Laurel, NJ

MS Access /SQL Server Database Developer

Developed VBA code to import data from different input sources.

Designed tables to incorporate imported data into Access tables.

Designed input and searchable edit forms using a key field.

Designed controlled forms in Access using VBA code.

Developed database for items received, sold, pricing, and invoices.

Designed multi-level sorted queries, views and reports using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2008.

Developed ETL processes for data integration using SSIS for sources like flat files, Excel Sheets, and Access data.

Developed searches by selecting any item to see the re-order level.

Performed mathematical calculations in queries and reports.

Discussing systems, managing information and placing under technical requirements.

Jan, 1985 – Dec, 2008

Worked for Government

Outside USA

Programmer/Application Developer

Database development in MS Access/VBA, FoxPro 2.6, COBOL, DB2, Oracle and SQL Server 2005.

Designing queries, searches and reports using different platforms including MS Access/VBA, Oracle, COBOL with DB2, and SQL.

Created database(s) and developed views, queries, searches and reports using T-SQL, Stored Procedures, SSIS, SSRS and SSAS under SQL Server 2005.

Designed ETL jobs using DataStage V8.0.

Population projections using DEMPROJ.

Used Cognos to develop different reports for Sales and Marketing Meta Data placed under data warehouse.

Trouble shooting COBOL batch program code.

Programming in COBOL, DB2, SQL, and JCL under UNIX environment.

Shell scripting in UNIX using VI editor.

Analyzing the business needs and incorporating under technical environment.

Data Analysis and programming using SPSS 10.0 and SAS Base 9.2.

Maintenance of official website.

Developed and managed national level IT projects in public sector.

Education

BS (Computer Science) – 1984 from Quaid-i-Azam University, Islamabad, Pakistan.

Contact this candidate