Steve Mallen Email & Phone Number

Naperville, Il, Us

Greater Chicago Area

Rosemont, Il

Responsible for the development of project portfolio data maintenance, integrity, collection processes, and presentation of summary reporting. This role is also responsible for articulating reporting conclusions. Contribute to corporate analytics and modeling to support the organization's data-driven project portfolio management decision needs. Work with Spotfire to enhance reporting to dashboards.• Converted 3 years of Excel based reporting into an Access Database. Linked the database to the PMO SharePoint site to pull weekly and monthly snapshots of the project portfolio.

Working in an agile environment to produce and support data solutions to internal and external customers. Create stored procedures, supporting tables, and views for current production reporting and future dimensional data warehouse. Work with business users, analyst, project managers, developers, and other decision makers to translate data into functional analytical tools, to show performance, analysis, auditing, decision making, and a clearer understanding of the production environment. • Perform hands-on development of reports and scorecards using appropriate visualizations.• Provide technical expertise and guidance to other developers insuring consistent and best practice use of the reporting guidelines & tools.• Work with system administrators in establishing effective delivery platforms for BI solutions.

Responsible for the design, development, and deployment of reporting and analysis in support of Sales and Operational Channels. Reduce expenses and increase productivity with reporting and report manager. Conversion of current reporting through Microsoft Access database to Reporting Services, which now has over 1,100 users accessing reporting nationwide. Converted old standard P and L reports into interactive SSRS web Reporting for all levels of sales. Developed standard tables to increase reporting and integration with established data-mart. Help build understanding of SQL and BI reporting with teammates. Assisted in hiring and training new employees. Used Hyperion BI for non standard reporting that had not be incorporated into the current data mart.Created pipeline management reporting for all Sales and Operation teams to track service level agreement statistics.Created internal reporting in Access for team to track from initial request to completion.

Working collaboratively with business partners to deliver information and knowledge required for decision making; indentify and implement technological solutions to improve internal processes; and support financial database and end users. Create solutions for information delivery that are cost effective, accurate and timely

Rosemont

2006-2009Managed SQL Server 2005 (CTB) data warehouse for all data integration and reporting with Reporting Services. Re-organized real estate portfolio data and reporting. Dimensionalized customer and account addresses. Implemented policies and procedures for specific application data integration. Retooled data load for CTB data warehouse. Integrated GL and transactional data into CTB data warehouse, creating new GL dimensions along with nightly SSIS load packages. Took over support of SQL databases for third party applications. Managed and maintained SaratogaCRM (Avenue) database. Updated and reorganized schema.dbd for SaratogaCRM. Utilized Sharepoint lists and reporting services to create real time reporting and statistical information, including versioning of data records. Mentored new employees regarding current bank technologies and business process. 2004-2006Expanded roll-out of integration services and data integration. Assumed responsibility for full support of CTB data warehouse. Administered FAST (Fiserv Account Teller and Sales) data consolidation and LQAS (Loan Quality Assurance System) data trending. Database and reporting lead on large projects including sales reporting and core relationship tracking. Managed data analysis for closing of Broadview branch. Created banking center referral tracking and reporting. Integrated ATM data for balancing and reporting. Utilized account analysis pricing tool. Conversion of old reports into MS reporting Services

Wheeling And Burbank

1999-2004Created cash management pricing model, calculating 6% charge increase in multiple regions. Mentored newer employees on current bank technologies and business process. Created ASP pages and database tables to track new loan customer information. Database lead on Saratoga avenue project, managing data integration from InformEnt data warehouse. Created Access database super alphakey relationship for data warehouse integration. Developed import tables for Market Line Associates (Customer profitability) with three monthly and two quarterly data files, converted and trended for 13 months. Recommended, implemented, and managed Foxtrot from Enablesoft. Created retail sales and incentive reporting for all branches. Implemented new Access databases for data entry and retail. Established master extract file for Y2K contingency planning. 1995-1999Managed new automated report request documentation and procedures. Created new hierarchies for deposit and loan products, SIC (Standard Industrial Classification) and NAICS (North American Industry Classification System). Spearheaded data analysis and reporting for service charge, savings migration, CD pricing and GL conversion. Integrated data from warehouse to OPS Sendero. Extracted and created database for M number security project. Tested and troubleshot InformEnt and output manager upgrade. Directed all data analysis and warehouse reporting

Prepared returns for over 2,100 company marketing service stations. Set up 64 rail car returns for company tax representatives. Managed returns for foam, chemical, fabrics and fibers. Gathered, reviewed, and processed tax notices for specific states. Provided requested information on assets and booked cost. Worked closely with mainframe, downloading company assets for implementation in personal property tax returns. Created and maintained various databases, accelerating and improving return process.

Provided prompt, courteous, and accurate service to customers and maintained working knowledge of bank products and services. Applied computer skills increasing service for customers and branch staff, resulting in improved productivity and savings of time and money. Utilized operation knowledge and skill in solving solve customer problems, contributing to higher customer retention.