Jessica Ackerman
About Jessica Ackerman
Jessica Ackerman is an SQL Developer at SEI in Oaks, PA, with over 5 years of experience in SQL Development, Data Warehousing, ETL Development, Reporting, and Business Intelligence solutions.
Title
Jessica Ackerman holds the title of SQL Developer and is currently employed at SEI in Oaks, PA.
Education and Expertise
Jessica Ackerman completed her Bachelor of Science (B.S.) in Computer Science at Rutgers University from 2012 to 2016. She has over five years of experience in SQL Development, Data Warehousing, ETL Development, Reporting, and Business Intelligence solutions.
Technical Skills and Proficiencies
Jessica is proficient in various programming languages including SQL, C#, VB.NET, Java, and C. She is experienced with SQL Server Management Studio versions 2008R2, 2012, and 2019. Additionally, she is skilled in using tools such as Visual Studio, SSIS (2008R2, 2019), SSRS (2008R2, 2019), and Eclipse IDE.
Object-Oriented Design and Programming
Jessica utilizes Object Oriented Design (OOD) and Object Oriented Programming (OOP) methodologies in her development work. Her expertise extends to developing, deploying, and monitoring SSIS Packages that extract data from multiple sources including flat files, Excel files, BCP files, and OLEDB data sources using DFT and C# scripting solutions.
Project Involvement and Daily Responsibilities
Jessica has developed complex stored procedures to create various SSRS reporting deliverables and other ad hoc client service requests. She assists in daily production support of reporting, portfolio management, and actuarial systems. Jessica is adept at executing file transfers using FTP tasks and extracting data from WebAPI and REST API sources using DFT and C# scripting solutions. She transforms data into standardized, atomic structures for use in downstream systems.