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.• Created web service application to aid the automation of creating Clarify CRM tickets from the monitoring tool utilized by the Network Operations Center.• Perform QA testing of reports for the Global Services and Support portal. • Knowledge (development and support) of the following reporting and data transformation tools: o Microsoft SQL Server Integration Services (SSIS) o Microsoft SQL Server Reporting Services (SSRS)

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, including 2 major call centers utilizing Siebel CRM application.• 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 Objects (Crystal Reports) - 215 reports - Business Objects Central Management Console - Manual Data Extracts / Reports • 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 creating “monitoring” reports as workarounds until application or ETL fixes are implemented.• 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 staff.• 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.• Involved as a member of the IT team responsible for business and system integration execution associated with the PepsiCo bottler acquisition. Primary responsibilities included data migration for CRM systems and assisted with conversion of reports from Actuate to Oracle BI Publisher for Siebel CRM upgrade.

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 HTML, ASP, JavaScript, ASP.NET, COM.• 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 Postal Service Intelligent Mail Data Acquisition System program ($350M+ program).• 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.• Served as subject matter expert associated with content, process and procedures for multiple systems/applications.• Learned and executed web site build and deployment processes to provide backup support as needed.

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, ClearLogistics and ClearContracts system modules.• 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 web pages from ASP to ASP.NET and creation of reusable .NET class libraries for Clarify.• 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.• Analyzed, implemented, and supported business systems and tools. Acted as technical liaison to user community.• Participated in the effort to adopt and employ the processes as defined in SEI Level 2.

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 Fortune 500 companies, including Hewlett Packard, IBM and GM. • 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