Zoheb Syed Email & Phone Number

Phoenix, Arizona Area

Phoenix, Arizona Area

Responsibilities: • Worked in AZEDS, Assessment, Accountability and ODS team in Arizona Department of Education.• Was involved in the Implementation of AZEDS model which helped the integrity to run every night which intern saved the organization 40 million dollars.• Designed multilevel, high volume data handling stored procedures to translate raw data to Data warehouse model.• We received files for Arizona English Language Learner Assessment (AZELLA), Multi-State Alternate Assessment (MSAA), AIMS and AzMERIT and all other sources and applied Business Intelligence and generated end user reports.• Have developed more than 150 complex stored procedures, triggers and functions in SQL Server 2017.• Have developed more than 70 Complex SSIS packages in Visual Studio 2017.• Have designed as audit system for Packages where auto mated email system.• Load data in Data ware House by using Slowly Changing Dimension• Responsible for the whole ETL process of these projects and developed more than 70 Complex SSIS packages in this period• Have done a lot of performance tuning on Stored procedures and SSIS packages to reduce the ETL load time significantly.• Have used C# code in script task to perform complex task in SSIS package.• Have upgraded the Database architecture from old De normalized to snow flake schema Normalized architecture.• Have worked in multiple projects with ability to work in a fast-phased environment.• Supported the database architecture of the organization through database design, modeling and implementation• Support the organizational data warehouse through appropriate utilization of ETL tools• Use SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.• Involve in the Migration of Databases from SQL Server 2012 to Azure.• Involve in the Migration of SSRS Report Server 2012 to Azure. • Automate SQL Scripts Deployment to DEV, QA, Staging and Production Databases with TFS Database Management.

Phoenix, Arizona Area

Responsibilities: • Working in SQL Upgrade Project here in Blue Cross Blue Shield of Arizona (BCBSAZ).• Involved in analyzing business requirements and creation of mapping and design documentation.• Involved in grouping the SSIS Packages and Databases to Application level.• Involved in developing SSIS Packages in 2015 by using Microsoft Visual Studio 2015.• Modified the SSIS Packages in 2005 script task with File System Task to simply the Complexity of packages.• Upgrading 200 SSIS packages from 2000 and 205 to SSIS 2016.• Upgrading 450 databases from 2005 to 2016 SQL server management studio.• Creation of clustered Column store indexes in 2016 SQL Server and reduced total size of Database from 1,055.5 GB, to 425 GB.• Have formed processes for Data Quality filter and Data Standards so that all the data is coming in through some standard.• Developed new SSIS Packages in 2015 for DTS packages used inside SSIS 2005 packages.• Developed new SSIS packages 2015 to avoid Linked server used by stored procedures consumed in 2005 SSIS Packages.• Created Script tasks using C# code. • Load data in Data ware House by using Slowly Changing Dimension.• Designed Active Batch 10 scheduler to trigger the SQL agent jobs at application level.• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time. • Have used agile methodology in this project. There was a lot of interaction between team members, everything that was developed was documented simultaneously and end users were always involved in decision making.

Phoenix, Arizona

Responsibilities: o Working in Clinical Quality Repository (CQR) project here in Dignity Health.o Developed multilevel, high volume data handling stored procedures to translate raw data to Data warehouse model.o Responsible for the whole ETL process of the project and developed more than 60 SSIS packages in this period.o Have created more than 200 complex stored procedures, triggers and functions in SQL.o Built an enterprise ETL to handle multiple Big Data source data sources.o Developed Entity attributes to handle dynamic key performance indicators here in Dignity Health.o Created SFTP Data pipe between vendor and internal data ware house system to automate weekly data feedo Integrated Master Data service(MDS) , Operational data source (ODS) and Data Warehouse (DW) to o We got provider data from Midas, All Scripts, Cerner and all other sources and applied Business Intelligence and generated end user reports.o Responsible for the whole ETL process of the project and developed more than 60 packages in this period.o Have formed processes for Data Quality filter and Data Standards so that all the data is coming in through some standard.o Have created a pipeline to connect to EDW (Enterprise Data Warehouse) through SQoop. Also have used HIVE to connect to Big Data.o Have designed a systemic process for Data translation into Data Vault.o Have designed Risk Reporting, was actively involved in dashboard, drilldown and drill thru reporting.o Deployed cube on SSAS server and Created partitions on cubes.o Load data in Data ware House by using Slowly Changing Dimension.o Have created more than 200 complex stored procedures.o Applying logic to De-identity the data as per HIPPA rules in development data ware house.Environment: MS SQL Server 2014, SQL Server Integration Services 2014, SSIS, SSRS, SSAS, MS Access 2003/2000, Enterprise Management Studio, MS Query Analyzer, XML, SQL profiler, SSIS, COGNOS,PIG, Scoop, SSRS, Hadoop, Hive, SQoop, .net and Putty.

Phoenix, Arizona Area

Responsibilities: • Have migrated 2008 SSIS packages to 2012 SSIS.• Have developed 60 SSIS 2012 packages in last 6 months.• Have worked on performance tuning of the existing ETL packages and saved 4 hours in ETL load time.• Have designed the data ware house and Empowerment Scholarship (ESA) team. They had their database in access so have migrated there system to SQL. SIIS packages for them and UI front end so that it is easier for the ESA team.• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time. • Created Profiling, Cleansing and auditing plans with SSIS Packages.• Have worked in SIS migration where Student information is in sometime access or excel or sometimes even in paper to SQL and then to SYNERYGY front end. This made a huge difference in Students life.Environment: MS SQL Server 2005/2008,2012 SQL Server Integration Services, MS Access 2003/200, Enterprise Management Studio, MS Query Analyzer, XML, SQL profiler, SSIS, COGNOS,PIG, Scoop, SSRS, Hadoop and Putty.

Phoenix, Arizona Area

Responsibilities: • Have created nearly 250 SSIS packages where they get the data from all sources and process it apply different business logic and load it in Dim and Fact tables.• When we first started with 500 GB data to 3 Terra bytes of data.• Have done GPRO (Group Practice Reporting Option) where we used to get XML from government and we had to processes and report is back to the government in the form of XML.• Have crated Meaningful Use reports for the doctors on SSRS as well as COGNOS..• Changed the load processes from truncate and load to incremental for all the tables which saved lot of time.• Load data in Data ware House by using Slowly Changing Dimension (SCD – Type 1, 2, 3)• Have used agile methodology in this project. There was a lot of interaction between team members, everything that was developed was documented simultaneously and end users were always involved in decision making. • To achieve business requirements, used for-Each Loop Container, Sequence Container, VB Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.• Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.• Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches.• Use Package Configuration to Migrate SSIS package from one environment to other.• Communicated with doctors no how they wanted the reports to look and what information they wanted in their reports.• Have created parent and child relationship with packages where 3 parent packages used to call 250 child packagesEnvironment: MS SQL Server 2005/2008,2012 SQL Server Integration Services, MS Access 2003/200, Enterprise Management Studio, MS Query Analyzer, XML, SQL profiler, SSIS, COGNOS,PIG, Scoop, SSRS, Hadoop and Putty.

Hyderābād Area, India

Responsibilities: • Create and maintain databases after logical and physical database design in SQL Server 2005.• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.• Migrate Database from SQL Server 2000 to SQL Server 2005• Set database access privileges for different users and user groups in SQL Server 2005.• Maintenance of clustered and non-clustered indexes in 2005.• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.• Develop SSIS (ETL, DTS Packages) in SQL Server 2005.• Develop backup & restore scripts for SQL Server as needed. • Extensively used XML to send the required data to off shore team.• Monitor server space usage and generate reports using Reporting Services in SQL Server 2005.• Design and implementation of database maintenance plan and Data conversion.• Tuning and optimizing queries and indexes.• Managed MDX Cubes and partitioning of cubes.• Job, Scheduling, batch, alert and E-mail notification setting.• Responsible for gathering/refining requirements from the customer for developing reports.• Identified the Data Source and defining them to build the Data Source Views. • Responsible for transferring the data using SSIS packages.• Looked at the reports and fixed bugs in stored procedures.• Implemented different types of constraints on tables.• Managed index, statistics and optimizing queries by using execution plan for tuning the database.• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.• Worked with users in training and support.Environment: MS SQL Server 2005, T-SQL, SSRS, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services, MS SQL Server Analysis Services 2005 Windows Server 2003.

Master'S Degree, Engineering

Bachelor'S Degree, Engineering

Bachelors of Engineering

High School/Secondary Diplomas And Certificates

Master Of Business Administration (Mba), Engineering