Jennifer Sandstrom Email & Phone Number

Mundelein, IL

Schaumburg, IL

• Lead a small team of developers to extract data and create complex reporting solutions for Wireless LAN (WLAN) customers in support of our global Managed Services business.
• Developed and support a custom solution using MySQL, SSIS and Oracle to consolidate and extract 30M+ records from third-party firewall system to meet customer reporting requirements.
• Collaborate with various functional teams within the organization to gather data and reporting requirements to develop enterprise reporting solutions.
• Analyze and extract data from various sources and platforms for use in customer reports.
• Develop and maintain complex monthly reports from a variety of data sources.
• Perform detailed data analysis to validate accuracy of data extracts and reports.

Schaumburg, IL

• Develop complex reporting solutions including ad-hoc data extracts, special requests to meet the needs of enterprise initiatives, and planned release development in support of the Food Service channel business.
• Knowledge (development and support) of the following reporting tools and platforms (includes current # of production reports): - Oracle Business Intelligence - 425 reports - Oracle BI Publisher - 46 reports - Business.
• Provide end-user support by handling questions on both IT maintained and ad-hoc user reports, performing user set up, scheduling changes and email configurations.
• Provide daily rotational production support of the reports and data feeds, by verifying production environment, by troubleshooting issues and deploying permanent solutions with Period Reporting Releases and by quickly.
• Create and execute test scripts using HP Quality Center.

Schaumburg, IL

• Technical and functional expert for the Microsoft Dynamics CRM (MS CRM) application (both server and Outlook Offline client), supporting the 275+ user base consisting of the field sales team and call center support.
• Extensive knowledge and experience in MS CRM customization including entities, forms & views, Java Script programming, callout development, accessing Web Services, developing custom workflows.
• Design, develop and customize CRM reports utilizing Visual Studio 2005 per business requirements.
• Designed and developed interface to auto-populate InfoPath forms with CRM data eliminating the need to perform duplicate data entry.
• Maintained integration of Customer Master Data to MS CRM utilizing Scribe Insight. Enhanced several interfaces to resolve logic issues which in turn reduced execution time in half.
• Created internal IT request system utilizing InfoPath and SharePoint functionality, replacing the tracking of application system requests via multiple Excel spreadsheets.

• Division: Business-to-Business (B2B) Information Technology Designed and implemented numerous web pages for the corporate global B2B extranet site ($4B+ Annual Sales Dollar Volume, 400K+ Sales Order Volume) utilizing.
• Recruited by management to work on special project responsible for gathering requirements, designing, coding, testing and implementing Help Desk systems, applications and web services to support the United States.
• Implemented a variety of web services consumed by both internal and external customers, including all interaction with a third-party Interactive Voice Response system.
• Created an assortment of VB.NET console applications to execute batch jobs in support of the B2B web application.
• Managed upgrade of the B2B web application environment (including migration of.NET Framework 1.1 to 2.0 and web server hardware, consisting of over 30 servers).
• Analyzed, designed, developed, tested, debugged, implemented, maintained and enhanced various complex elements of existing or new business systems and applications.

• Division: Commercial, Government and Industrial Solutions Sector Supported and enhanced the Global Technical Support (GTS) instance of Clarify utilizing ClearBasic, gaining in-depth knowledge of the ClearSupport.
• Sought out by management to participate in a special effort to implement additional critical business functionalities in the corporate B2B extranet site; eventually transitioned to this department as a lead developer.
• Led the effort to rewrite all of the Clarify functionality within the corporate B2B extranet site during the merge of two global instances of Clarify (CRM client/server application). The rewrite included converting all.
• Supported and maintained all data interfaces (PL/SQL) for the GTS Clarify system.
• Project manager for implementation of billing integration with GTS Clarify.
• Played a key role during several Clarify application upgrades.

• Division: Personal Communications Sector Developed and maintained multiple applications in Visual Basic, COBOL, and Dbase III/Clipper.
• Maintained applications related to the Motorola Key Account Support Services (MKASSSM) program; the first system in the industry to provide consolidated invoicing and management reporting on cellular data to over 380.
• Analyzed user-requirements to form logical and efficient applications in support of call center operations.
• Coordinated training and account set-up for 200+ sales reps on laptops and computer use for order placement via remote access.
• Assisted in data gathering and reporting for the sell-off of the business.

Education record

Ba, Computer Science

GPA: 3.88/4.0