| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Heritage Drive 101Hoffman Estates, IL Street Address
PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEStatus in USA: US CitizenProfessional Summary10+ 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+ years 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 SkillsDatabase DevelopmentSQL Server 2005/2008/2012/2016Oracle 11gDB2MS Access/VBA, FoxPro 2.6 /dBase-4SalesforceProgramming Languages/SQL ServerVBA, T-SQL, Stored Procedures, SQL Server 2005/2008/2012/2016Postgre SQLCOBOL under UNIX using VI editorCOBOL, SQL, DB2, JCL on IBM Mainframe platformFORTRAN on IBM MainframePythonStatistical Analysis, Publishing, and Reporting ToolsPower BI, Cognos, Tableau, QlikView, and Crystal ReportsSSAS, SSRSSharePointSPSS, SAS Base, DemprojData AnalysisETL Job Design for Data WarehouseUsed SSIS and Infosphere DataStage V8.0 to develop and run ETL jobs for fact and dimension tables under a Data Warehouse environment.Control-M and SQL Server Agent used for job scheduling.CertificationOn-Line Course attended for IBM InfoSphere DataStage V8.0.Certification in IBM InfoSphere DataStage V8.0 from USA.TrainingAttended AS/400 System Facilities training organized by IBM from Dec 16 -20, 1990 Pakistan.Business AnalysisRequirement 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 & EditingData 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 AssuranceData cleaning and Quality Assurance by designing and developing edit checks.Project ManagementDeveloping projects plans and KPIsMonitoring different projects according to defined timelines.Operating SystemsUNIXWindowsDOSEditor(s) UsedVI Editor (Extensive)Windows based editors (Extensive)Professional ExperienceMay, 2022 To PresentRadiological Society of North America (RSNA)820 Jorie Blvd # 200, Oak Brook, IL 60523Sr.ETL/SQL DeveloperTesting 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 using MSBI.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 with DAX, SSRS under MSBI 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.).Performed data analysis using SQL scripts for SSRS reports.Used Python code to upload files from source to destination.Used SQL, PL/SQL and Postgre SQL for scripts writing.Jul, 2019 Apr, 2022The Bradford Group World Headquarters - Chicago9333 N. Milwaukee Avenue, Niles, IL 60714Sr.ETL DeveloperWorked 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 under MSBI.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 data analysis 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.Used Python code to check data %age available in columns.Used SQL, PL/SQL and Postgre SQL for scripts writing.Performed Linear Regression test under Azure Databricks using REGR_SLOPE, REGR_INTERCEPT, MIN(StartTime), MAX(StartTime) and CORR to get the result as Interpolation or Extrapolation.Developed reports using Power BI with DAX and SSRS after creating data models.Nov, 2018 Jun, 2019Sysmex America,577 Aptakisic Rd, Lincolnshire, IL 60069Sr.SQL/ETL DeveloperDeveloped 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 with DAX.Deployed SSIS packages to Integration Services Catalog SSISDB under MSBI.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.Used SQL and Postgre SQL for scripts writing.Performed Linear Regression test under Azure Databricks using REGR_SLOPE.Jul, 2018 Oct, 2018Baxter International Inc.,25212 IL-120, Round Lake, IL 60073Sr.ETL/DB DeveloperDeveloped 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 Infosphere 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 (PL/SQL) and Postgre SQL.Developed packages under Oracle (PL/SQL) to improve performance for those packages which are running slow developed under DataStage 11.3.Updated stored procedures to improve query performance.Used Control-M for job scheduling.Jan, 2018 - Jun, 2018Associated BankMilwaukee, WISr.ETL Developer/Systems AnalystDevelopment 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 under MSBI.Performed yearly data analysis using SQL scripts.Developed stored procedures to merge data from stage table to target table.Mar, 2017 - Dec, 2017National Marine Manufacturers Association,Chicago, ILSr.ETL Developer/SQL Programming AnalystDevelopment 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 with DAX under MSBI.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, 2017WPS Health Solutions Madison, WISr.ETL DeveloperDevelopment 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 with DAX 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.Performed Linear Regression test under Azure Databricks using REGR_SLOPE.Jan, 2015 - Jan, 2016Health Care Service CorporationChicago, ILDatabase Developer/SQL ProgrammerDeveloped 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/Informatica.Dashboards and reports were developed for various departments using Power BI with DAX under MSBI.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, 2015Baxter HealthcareDeerfield, ILDatabase Analyst/DeveloperDeveloped 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/Informatica.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, 2014New York State Department of HealthEmpire State Plaza, Albany, NY 12201ProgrammerConverting 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, 2013Discover Financial ServicesRiverwoods, ILMS Access/SQL Server Database DeveloperAnalyzing 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, 2013NestleGlendale, CAMS Access / SQL Server Database DeveloperDesigned 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, 2010Hewlett PackardMount Laurel, NJMS Access /SQL Server Database DeveloperDeveloped 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, 2008Worked for GovernmentOutside USAProgrammer/Application DeveloperDatabase development in MS Access/VBA, FoxPro 2.6, COBOL, DB2, Oracle (PL/SQL) and SQL Server 2005.Designing queries, searches and reports using different platforms including MS Access/VBA, SQL, Oracle, COBOL, CICS with DB2 and JCL.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 Infosphere DataStage V8.0.Used Control-M for job scheduling.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, CICS, 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.EducationBS (Computer Science) 1984 from Quaid-i-Azam University, Islamabad, Pakistan. |
