Mathew George Email and Phone Number

• Cuna Mutual Group delivers insurance and investment solutions to help credit unions. The scope of the project is to develop Data warehouse schemas for different credit unions. It involved analysed, designed, and gathered business requirements.• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.• Expert level skills in testing the Enterprise Data Warehouses SSIS ETL tools.• Implemented complex business logic into database design and maintained the referential integrity via constraints.• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.• Experienced in Analysing Execution Plan and managing indexes and troubleshooting deadlocks.• Very Strong skill in building and using CTE's Common table Expressions for building recursive queries.• Created SSIS reusable packages to extract data from multi formatted flat files and excel files into SQL Database.• Used version control (GIT/VSTS) for code sync.• Scheduled and monitored different jobs using SQL Server agent.• Involved in checking and validating jobs and notify on failures.• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components• Hands on experience in writing SSIS script/script component task using C# for customized data manipulation of complex SSIS packages.• Created slowly changing dimensions ( SCD )• Created python application for running SQL.• Displayed and proved capability to learn any new technology and work on it.• Hands-on experience in writing and reviewing requirements, architecture documents, test plans, design and

• Mediavest | Spark is a full-service media agency that offers the best of both worlds – a startup spirit backed by a powerhouse soul. It is a member of the Publicis Media network. The scope of the project is to develop complex SSIS Packages/T SQL code based on the business requirement involves requirement gathering from non-technical people.• Analyzed, designed, and gathered business requirements.• Created SSIS reusable packages to extract data from multi formatted flat files and excel files into SQL Database.• Scheduled and monitored different jobs using SQL Server agent.• Involved in checking and validating jobs and notify on failures (Monitoring and debugging of daily job failures).• Designed SSIS jobs and create reusable components to support the data exchange with our clients. Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.• Interacted with Business Analysts and Developers in identifying the requirements, designing, and implementing the Database Schema.• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.• Worked on several transformations in Data Flow including Derived-Column, for each loop, Script task, Data Conversion, Conditional-Split and many more.• Wrote T-SQL queries, Store Procedures, used them to build packages, and handled slowly changing dimensions to maintain the history of the data.• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.• Used version control (TFS) for specific client.• Worked after hours for production issues and support as part of the on call duty.• Using python code for to download files from Amazon Web Service (AWS).• Loading files in to DataRama Dash board.

• Seterus is one of the nation's leading specialty loan servicing companies. The scope of project is to develop and extract data from different servers and SQL database using Informatica and creating Stored Procedures and views according to the Business requirement.• Optimized Stored Procedures and Views using performance tuning.• Performed unit testing on Interfaces at ETL level, with Testers as per testing standards and UAT with Users.• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.• Developed packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.• Created data pull procedure, SSIS packages and data or evidence documentation involve with different work stream.• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.• Used TFS while creating ETL packages .• Migrated packages from development server to production server using package configuration.• Created Informatica objects- Sources/Targets/Reusable Transformations, Mapplets, Mappings, Sessions, worklets, Workflow and Folders.• Scheduled jobs using Autosys.• Creation of ETL’s as per requirements. Deployed ETL Interfaces between Development, Test and Production Repositories.• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.