Data Ssis

Zahir

Email: adify8@r.postjobfree.com

Phone: 347-***-****

Over 8 years of working experience in MS SQL Server and Oracle PL/SQL in various domains like Finance, HealthCare and Insurance with expertise in MS SQL2016/2014/2012/2008, SSIS, SSRS, SSAS and Oracle 12c/11g/10g. Experienced in handling multiple tasks under strict deadline and capable of handling responsibilities independently as well as a proactive team member.

Professional Summary:

Highly proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.

Developed Advance PL/SQLpackages, procedures, triggers functions, Indexes and Collections to implement business logic using SQLNavigator.

Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.

Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions

Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL

Experienced in creating, validating and reviewing solutions and effort estimates for datacenter migrations to Azure Cloud environment.

Expert in Data conversion, Data modeling, Normalization and SQL Server Enterprise manager.

Expert in Migration of data from Oracle, Sybase and DB2 to SQL Server.

Involved creating ETL process, Data warehousing, Operations Data Store concepts data marts.

Expert in Creating, maintaining and Configuring SSIS packages.

Involved working with heterogeneous data source like Excel, Flat file, Oracle, and SQL Server.

Expert in Logging, Error handling and Custom Logging for SSIS Packages.

Involved creating operational reports in SSRS 2008/2008r2/2012 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports for various domains.

Expert in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Involved in Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.

Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.

Education:

Bachelors, Queens College (CUNY), New York.

Certifications:

Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance.

Business Skills / Technical Skills:

MS SQL Server2016/2014/ 2012//2008, Visual studio 2010/2008 (SSIS/SSRS/SSAS), Microsoft Access 2007/2003, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, Oracle 12c, 11g,10g,

and 9i, SQL Azure, MySQL, Tableau, Cognos report, Informatica, Windows Server, Microsoft SharePoint, Erwin, SSMA, MS Access, PHP, Java, C++, MS Office.

Projects Summary:

Cotiviti Healthcare, Blue Bell, PA July 2018 - Present

Sr.SQL Developer

Cotiviti Healthcare provides a comprehensive suite of solutions to meet the payment accuracy needs of payers across the U.S. healthcare landscape. Cotiviti leverages its technology platform, configurable analytics, proprietary information assets and expertise in healthcare reimbursement to help payers enhance their claims payment accuracy. The goal of the project is to improve the performance of the long running processes for all health care clients Using T-SQL. Also Improve the loading process from staging server to production server Using SSIS.

Responsibilities:

Extensively worked on improving performance of the slow running processes across all 47 healthcare clients using T-SQL.

Involved in identifying custom Process/codes for the clients and convert those codes as global codes (an enrichment process used for different policy holders) according to company requirement.

Used Beyond Compare for code review and made necessary changed for merging code.

Worked on various custom and global reports that used for monthly, Weekly, and Daily loads.

Implemented error handling and save all error info in audit table.

Improved performance of Data Load and Member Load for all client, especially for WellPoint data and make their processes global for all clients using Compiler.

Created Documentation for config process for all clients.

Involved creating process to identify invalid SSN and DOB.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

Successfully implemented indexes on tables for optimum performance.

Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Improved the SSIS packages that created for Data loads Claim loads and member loads for all clients.

Worked on performance tuning of legacy queries.

Configured and deployed SSIS packages in Dev and QA environment.

Implemented error handling and custom logging in SSIS.

Used SSIS package to execute stored procedures both in sequence and parallel.

Used FTP Task to extract file from FTP Server.

Applied ETL (SSIS) to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.

Used Teradata database with OLEDB source in SSIS and Informatica.

Tools &Technologies:

Windows Server 2012, MS SQL Server 2012/2016, SSIS, SSRS, SSAS,T-SQL, Oracle 12c,11g, Excel and Informetica, Power BI,GIT-HUB, TFS, JIRA(Safe), .Net, C++, VB, Powershell.

Bank of America, New York, NY October 2016 – June 2018

SQL BI/SSRS Developer

Bank of America is one of the biggest and most conveniently accessible bank having branches all across USA. Bank of America is active in many markets, economies and financial sectors. The project was to analyze bank accounts, to market additional products more effectively to the customers who have one or more accounts with the bank i.e. Business and personal account.

Responsibilities:

Interaction with clients while business requirements, design & implementation phases.

Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services.

Created and maintained existing dynamic SSIS packages to load data from and to MS SQL Server and Oracle, Excel files, and flat files.

Worked on SSMA for transferring data from Oracle to MS SQL Server.

Responsible for developing technical components for the following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, UPC Resolve, Scope Resolve, View/Subtotal Resolve, Hierarch Resolve.

Optimized the Oracle PL/SQL queries by Performance Tuning.

Worked on enhancement of existing pipelined functions and packages.

Design, develop & test the ETL processes according to industries best practices using SSIS.

Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Log Providers & import/export wizard while developing packages.

Used Script task for Data Flow and Error Handling in SSIS.

Worked with both T-SQLand PL/SQL to create database objects such as Tables, Views, Functions, Triggers and Stored Procedures.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Created and modified existing partition for optimize SSAS Cubes.

Used SQL profiler, and indexes for performance tuning & debugging issue whenever necessary.

Documented for all kinds of reports and SSIS packages.

Created reports such as Matrix Report, Drill-Down and Drill-Through Reports, Parameterize Reports, Dash Board Report, and Link report using SSRS and Cognos Reporting tool.

Writing and supporting data warehouse reports using Oracle and SQLServer.

Worked with MDX queries which retrieved data from SSAS Cubes to create optimized reports.

Tools &Technologies:

Windows Server 2012, MS SQL Server 2014, SSIS, SSRS, SSAS,T-SQL, Oracle 12c,11g, Excel and Cognos, Tableau,TFS, HPDMA.

Northwell Health (LIJ), Long Island, NY April 2015 - September 2016

SQL BI Developer

Northwell Health is a hospital network of 21 hospitals which provide health services in New York Metropolitan Area. The project mainly involved designing data source and data flows, developing and monitoring the SSIS packages. The project also required strong knowledge of T-SQL and PL/SQL to extract data from existing tables and also to create new tables with new and existing information.

Responsibilities:

Involved in redesigning and redefining data warehouse and provided necessary documentation.

Use SSIS packages to extract data from old Data Warehouse and push to into new Data Warehouse.

Used Tableau Desktop, Tableau Server and Tableau Reader in various versions.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, tables, Views, and Functions.

Tuning of PL/SQL Stored Procedures using HINTS in Explain Plan

Successfully implemented indexes on tables for optimum performance.

Created SSIS 2014/2008r2 Packages to integrate data coming from Text files and Excel files.

Optimized the Oracle PL/SQL queries by Performance Tuning.

Worked on performance tuning of legacy queries.

Involved in documentation of Azure process for company’s future use.

Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS 2014/2008r2.

Created reports using SSAS Cubes.

Responsible for implementation of data viewers, SSIS 2014/2008r2 Logging, error configurations for error handling the packages.

Responsible for the development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement

Identified the prospective issues in the Azure migration and suggesting feasible solutions to client.

Used Teradata database with OLEDB source in SSIS and Informatica.

Involved modifying existing Informatica Packages and execute it through batch file.

Use various SSIS transformations such as Conditional Split, Lookup for Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2014.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Tools & Technology:

MS SQL Server 2014/2008r2, T-SQL, SSSIS 2014, Microsoft visual studio 2014, Informatica,Tableau, Windows server 2012, SSRS 2014/2008r2, SQL Azure and Oracle 11g.10g.

River Stone Group, Manchester, NH January 2014 – March 2015

MS SQL BI / SSIS Developer

RiverStone is a global insurance industry leader specializing in the acquisition and management of insurance portfolios. RiverStone provides different specialized insurance program in the US and Europe. The main project goal was to use integration services to extract data from sources and push that data through staging and create package.

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

Successfully implemented indexes on tables for optimum performance.

Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.

Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Worked on Guidewire Claim Center to manage P&C claims.

Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.

Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.

Performed Documentation for all kind of SSIS packages.

Involved working on P&C Insurance billing system and other property related data.

Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS 2012/2008r2.

.

Tools &Technologies:

MS SQL Server 2012/2008r2, SSIS 2012/2008r2, T-SQL, Visual Studio, Windows XP, MS Office 2007/2010, MS Access and Guidewire.

Santander Bank, Boston, MA May 2012 - December 2013

MS SQL Server / SSIS/SSRS Developer

Santander bank is a Spanish banking group and is one of the largest bank in Eurozone and USA. Santander bank provides loan, mortgage, personal and corporate banking services. The main project goal was to use integration services to extract data from sources and push that data through staging and create package and generating various report such as drilldown, drill through, sub-report, linked-report and dashboard report using SSRS and COGNOS.

Responsibilities:

Involved in Planning, Defining and Designing data based on business requirements and provided documentation.

Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.

Successfully implemented indexes on tables for optimum performance.

Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.

Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.

Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.

Performed Documentation for all kind of SSIS packages.

Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS 2012/2008r2.

Involved in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS).

Experienced in implementing the JavaScript framework for processing the web server request client side rather than server side.

Used MS Ajax, JQuery, JavaScript to develop rich user interface with unobtrusive JavaScript.

Tools &Technologies:

MS SQL Server 2012/2008r2, SSIS 2012/2008r2, T-SQL, Visual Studio, Windows XP, MS Office 2007/2010, MS Access, .Net Framework 4.0.

Contact this candidate