Ted Schaffer Email & Phone Number

Columbus, Oh, Us

Dublin, Ohio, Us

• Built partner and vendor integrations in SQL Server Integration Services (SSIS) and SQL logic• Worked closely with Data Analysts and Business Partners to ensure integration requirements were satisfied• Analyzed the source systems and built the transform rules to extract, transform, and load (ETL) the data from the source to the target systems• Created database tables, columns, keys, indexes, constraints, common table expressions, temporary tables, and PL/SQL stored procedures using SQL Server Management Studio (SSMS) • Production support of existing processes (analyze/tune SQL queries, analyze audit reports, debugging of ETL processes, implement performance enhancements)• Prepared the data mappings and configurations through setting up of metadata• Extensively used SSIS transformations such as lookup, derived column, data analysis expressions (DAX), data conversion, aggregate, conditional split, SQL task and script task• Experience in Microsoft Visual C# in script component of SSIS• Used GIT for source control

Dublin, Ohio, Us

• Enhanced and built Web API’s, through updating configurations, setting up security tokens, and building data models• Serialized data from objects to JSON strings and deserialized data from JSON strings to objects, using C#• Used Postman to test API functionality• Created and performed unit tests on data mappings and API endpoints• Developed SQL scripts for data migrations

Columbus, Ohio, Us

• Configured and customized the CRM (Customer Relationship Management) software solutions based on client requirements, including page structures, fields, dashboards, workflows, and templates• Migrated data into system from third-party systems in various formats, such as flat files, linked servers, and SSIS packages, using extract, transform, and load (ETL) processes• Mapped data using complex SQL queries through tables, fields, views, stored procedures, subqueries, and common tables expressions• Assessed data analytics in the software, making updates through SQL Server Analysis Services (SSAS) to meet requirements and solve data issues• Installed software and server configurations, such as ERP/API connections, server certificates, IIS web servers, and Outlook settings• Set security parameters to users by role to control system access• Performed testing on completed modules, functions, configurations, and enhancements to ensure high quality deliverables• Deployed configurations and customizations to test and production environments• Performed duties in conjunction with business analysts, software developers, support team, and leadership

Reynoldsburg, Ohio, Us

• Gained healthcare and insurance experience as employee of third party administrator• Strategized and led the entire software development lifecycle, using Agile and Lean methodologies, which included requirements gathering, analysis, design, development, testing, and implementation• Created detailed documentation for user specifications, user and administrator instructions, and technical procedure documents• Facilitated testing by communicating to testers the steps to take and expected results • Created SSIS packages with control flow tasks such as Execute SQL Task, File System Task, Script Task, and Execute Package Tasks, for data migration (ETL) and application tasks • Created stored procedures, triggers, to improve performance of the applications• Created databases, tables, columns, keys, constraints, and views in SQL Server• Created ad hoc and operational reports, determined characteristics such as report flow, format, data elements per specifications • Created complex SQL queries both for reports and applications. Included logic such as subqueries, joins, relational modeling, data conversions, filtering, calculations, groupings, aggregation• Accessed data using Object Relational Mapping of ADO.NET and Entity Framework• Implemented LINQ queries on SQL Server data source in .NET applications, using Lambda expressions and SQL syntax• Created new applications in .NET/C# and SQL Server, which were previously legacy applications written in Delphi• Created ASMX web services using SOAP API for integrating multiple data sources• Proficient in using Team Foundation Server for source control

Providence, Rhode Island, Us

• Extensive experience with Empower mortgage LOS (loan origination system), including business rules, products, pricing, workflows, field mappings, documents, document packages, and configurations, in conjunction with developing in C#/.NET, SQL and Delphi code• Participated in software development lifecycle, using Agile methodology, by working through time estimates and specifications, coding, design, testing, implementation and ongoing support• Collaborated with business line colleagues from areas such as Compliance, Operations, and Mortgage Lending• Led as subject matter expert for mortgage lending application processes, procedures, and configurations• Designed user interface for WinForms and implemented business logic• Created SQL statements for selection, insertion, manipulation, and deletion of records• Developed reports (designing, supporting, troubleshooting, sub-reporting, scheduling, distribution, export of data, creating users/groups/roles), using Crystal Reports and complex SQL queries