Debra Bender Email & Phone Number

New Berlin, WI, US

• In charge of all SQL database and business intelligence related work:
• Within a few months, streamlined SQL bottlenecks of a critical production supply application, rescuing it from almost daily issues. Learned some Python in order to handle even more changes in its code.
• Consolidated SQL databases and processes from nine production SQL Servers down to four.
• Proficient in handling SQL Server Replication, utilized for our reporting and integration processes.
• Integrated Dynamics NAV ERP data with Trade Promotion Management systems (MEI/AFS, BlackSmith, & Exceedra), using SSIS & SQL Agent Jobs, ensuring proper security. Worked closely with Finance to ensure specifications.
• Built a data-warehouse and cubes in Jet Data Manager (JDM). Evolved the Dimensions & Fact Tables, combining with other queries through On-Premises Data Gateway & SharePoint documents for Power BI reports and providing.

• Using the MS BI stack of tools (SSMS, SSAS, SSRS, SSIS, Power BI, Excel), designed, implemented, & maintained a data-warehouse merging Marketing costs, student inquiries, contacts & progression to admissions from.
• Acting DBA for data-warehousing and reporting on SQL Servers: Installing SQL Server (and components: SSIS/AS/RS/MS), patching, backups, and index & other maintenance.
• Built extracts of vital da ta using SSIS to extract from various sources (flat files, FTP, REST API calls, etc.) and used SQL Server Agent jobs to schedule and ensure timely notification of any issues.
• Collected requirements from various business levels within the organization, utilizing the Agile method of iterations to ensure the project results were truly resulting in effective data.
• Designed and built the data warehouse using BIEF to design & populate dimensions & fact tables and SSAS & SSAS Tabular to build data “cubes”. Using the base star-schema data, and other data sources, built reports using.

Utilizing SSIS, T-SQL, Stored Procedures, SSRS, & SpotFire, designed SSIS packages and reports to support BuySeasons’ database needs for online retail sales and warehouse management.► Implemented a single SSIS package and robust Stored Procedures (T-SQL) which could import many types of files thus synchronizing import methodologies, history of files.

► Performed Business Analyst, Systems Analyst, Software Engineer, Data Architect, Quality Assurance Specialist, and other positions in designing, programming, implementing, and supporting all software for MJ Care’s School Based Billing business.► Helped support department scanner and offsite client hardware.► My primary responsibility was the department’s.

► Designed, programmed, implemented, and supported the Voice Response Unit (VRU/IVR BriteConnect system) for 401(k) participant account access: account balances, loan information, mutual fund trading, loan requests, and other account changes. This included design and programming of tables and stored procedures in Sybase, our database system.► Using Visual.

► Visual FoxPro Programming assignments involving creation of relational databases, utilizing ODBC data sources, object oriented design, GUI interfaces, and large database manipulation.► Data Warehouse design on an AS/400 server using ShowCase Strategy tools: Essbase (multidimensional) database design, relational design of data storage, and documentation.►.

General operations for AS/400 systems and Novell networks:► Backup and general maintenance/operations/troubleshooting on the AS/400 systems.► Installation of terminals, printers, operating systems, and PTFs on the AS/400 systems.► Installation of PCs, software, and upgrades on the networks.► In charge of Scanning System involving programming of interface.

Consultation in Novell networks and stand-alone PCs:► Projects have ranged from installing software, building and upgrading PCs, trouble-shooting hardware and software problems, and helping users understand the computer products.► Incorporated Internet email into GroupWise (an interoffice email package).