TECHNOLOGY SKILLS:

OS/Servers:  Windows95/98/ME/2000/XP, Windows NT 4.0/2000/2003 , Internet Information Server 3.0, 4.0, 5.0

Database Servers:   SQL Server 7.0/2000/2005/2008 (including SSIS, SSAS, and SSRS), Oracle 9i/10g/11g

Software:  Informatica PowerCenter 7, Cognos DataManager 8.3/8.4.1, Tableau, SPSS, SAS, MS SharePoint Services, Information Builders (WebFOCUS, InfoAssist, Visual Discovery, Report Manager, Report Caster), MS Office Suite (Word, Excel, PowerPoint, Access), FoxPro, MS Visio, Crystal Reports, Qualtrics, Erwin

Programming:  SQL, T - SQL, PL/SQL, ASP.NET, ASP, HTML, Visual Basic, VBA, JavaScript, CSS, ODBC, OLE DB, FOCUS

PROFESSIONAL EXPERIENCE:

Data Warehouse Specialist

Confidential, Evanston, IL

• Lead designer and developer for faculty publications and citation indexes report suite and perational and managerial dashboards for admissions office.
• Design and build data warehouse for the Al iance of Chicago, which provides electronic medical record infrastructure and support and research and reporting functions to the community health care industry.
• Duties also include data profiling and quality functions, dimensional modeling, ETL development, and metadata management.
• Develop fuzzy matching procedure utilizing SSIS to find duplicates within and between data systems to produce a master patient index.
• Design, build, and maintain central data mart solutions that extract data from multiple source systems.
• Projects include work with the Office of Research Safety, Alumni
• Relations and Development, Human Resources/Faculty Publications, Student Enrol ment
• Services (student records, student financials, and admissions), and Institutional Research.
• Participate with university staff at a variety of levels (directors, managers, research personnel, and business analysts) in al phases of enterprise business intel igence/data warehouse projects including interviews and information gathering sessions to elicit and assess needs, project planning and presentation of design options/prototypes, training, and follow - up/troubleshooting/retrospectives; conducted initial data quality and validation source systems.
• Lead on projects to standardize best practices or develop new processes within the department, including project tracking, migration strategies, automate importing XML data sources via web services into SQL Server database, and management of data mart meta- data by business analysts.

Senior Data Warehouse Analyst

Confidential, Chicago, IL

• Conduct analysis of university business practices and needs, conduct requirements gathering and develop online dashboards for operational and analytical/strategic needs including col egiate academic performance in housing, class enrol ment trends, daily class enrol ment tracking, and housing check-in trends.
• Develop data model and ETL code to support dashboard front-ends.
• Part of Data Warehouse team assigned to work with consultant to build new data warehouse (DW) at Loyola.
• Revamped data extraction system for Institutional Research office from an on-demand process to a nightly ETL process, reducing runtime from 11 hours to 30 minutes.

Senior Applications Developer/Team Leader

Confidential, Chicago, IL

• Project manager and business analyst for inter-departmental data warehouse project that incorporated admission, student, and financial aid records.
• Perform user interviews, review existing systems and reports and maintain project timeline, data dictionary, and other project documents.
• Lead data architect, developing data model, source-to-target mappings, and metadata for data warehouse project. Create or supervise the creation of ETL routines, including testing, tuning, and scheduling.
• Create Oracle tables and indexes.
• Departmental representative in enterprise data warehousing efforts, including serving on cross-departmental Data Warehouse Governance Board.
• Team member on research into non-cognitive variables in undergraduate admissions.
• Conduct primary research into utilizing non-cognitive variables in admission decisions and subsequent academic performance. Conduct data gathering and analysis of scorers of non-cognitive variables to ensure reliability and validity of the process.
• Conduct analysis demonstrating the validity of using non-cognitive variables in admission decision making.
• Project manager for a variety of business intel igence and knowledge management systems.
• Work directly with al levels of end users (executives, managers, support staff, and academics) to analyze business functions and needs, compile and document system specifications, design and build desktop and web applications, and provide training.
• Managed team of part-time developers. Projects include lead developer and co- administrator for data visualization software, pivot table application to access current and longitudinal applicant data and financial aid data, online web survey and survey tracking system, state and national market analysis pivot tables and online reporting suite, content management system for departmental website, and online admission reporting suite.
• Analyze enrol ment patterns within the State of Il inois and develop interactive dashboard to highlight findings.
• Design and develop primary web-based surveys for numerous market-based research initiatives.
• Consultant for the implementation of new enrol ment management system, providing critical guidance to achieve on-time system go-live. Within four months, learned al new technologies in order to evaluate system capabilities and provide needed solutions to critical project requirements. Re-engineered data feed to external fulfil ment vendor from a 1-way manual process to a 2-way, automated process, increasing efficiency and data quality.
• Consolidated data marts regarding newly acquired Barat Col ege including admission, enrol ment, financial aid, faculty/staff data, extracting from numerous sources including 3rd party ERP, desktop databases, and flat files.
• Part of team that compiled and supplied required information and reports to the Ilinois Board of Higher Education and the National Center for Education Statistics.
• Member for Pay Equity Committee for Faculty and Staff which examined compensation patterns by gender and ethnic breakouts and recommended a series of actions to achieve compensation equality.
• Data mining project to improve survey response rates. Patterns indicated ideal approach was to develop survey based upon the make-up of the characteristics of the survey sample.

Assistant Director

Confidential, Chicago, IL

• Business analyst for data warehouse/business intel igence/knowledge management projects including user interviews, reviewing existing systems and reports and maintaining
• project timeline, data dictionary, and other project documents.
• Design, implement, and manage technical solutions that streamline data gathering and reporting procedures. Build and maintain database system to col ect, store, and deliver information to meet departmental research needs and reporting responsibilities.