PROFESSIONAL PROFILE:

IT professional with over 20 years of experience providing effective solutions to businesses across different industries. Excellence across multiple functions from software development, implementation, analytics, and business intelligence. Provided superior technical leadership on real - time production systems, independently and as part of a team.

RELEVANT SKILLS:

• Perl SQL Server Hue Linux
• SQL Oracle Hive MySQL
• HTML XML JIRA EDI
• DB2 Agile PHP Python

EXPERIENCE:

Confidential, Rolling Meadows, IL

Business Analyst/Project Manager

Responsibilities:

• Successfully managed concurrent projects involving multiple resources with tight deadlines.
• Defined detailed requirements, analyzed business needs, and validated solutions with business stakeholders.
• Devised procedures which solved complex problems and served as a laison between technical resources and functional stakeholders.

Confidential, Oak Brook Terrace, IL

Business Intelligence Analyst

Responsibilities:

• Created source to target mappings which facilitated migration of data to the data warehouse and the Microsoft Azure data lake.
• Translated information into comprehensive requirements documentation and transferred that knowledge to the BI Development team to create highly efficient and highly scalable business intelligence solutions.
• Fulfilled business needs by creating functional design documents including acceptance criteria to outline how the operational data stores, data warehouse, reporting and dashboards were to be created.
• Facilitated productive meetings with business units to gather business analytics requirements and understand KPIs, key drivers, and other business requirements for analytics.

Confidential, Park Ridge, IL

Freelance Analyst

Responsibilities:

• Provided effective consultation regarding site traffic and funnel analytics for a lead generation website and conducted A/B testing.
• Developed operational business documents supporting the site.

Confidential, Hoffman Estates, IL

Business Analyst

Responsibilities:

• Conduct deep dive data analysis for merchants improving category performance which drove at least 10% sales increases year over year.
• Ensured year over year data alignment which allowed correct sales analysis by identifying anomalies and implementing corrections.
• In a compressed timeframe, successfully migrated data from DB2 to Hadoop for analytics continuity.
• Conducted and lead discussions between business stakeholders and off shore technical development teams.
• Created Visio diagrams detailing the data flow from source systems into the Marketplace reporting data warehouse. Wrote detailed business requirements listing migration stages and deliverables.

Confidential, Tinley Park, IL

Software Developer & EDI Analyst

Responsibilities:

• Developed and deployed an online report used by management to track resources. Analyzed results to highlight areas of improvement.
• Smoothly onboarded and maintained new and current EDI partners in compliance with ANSI X12 transaction protocols.

Confidential, Glenview, IL

Oracle Reporting Business Analyst

Responsibilities:

• Created a manpower usage report to provide management with insight on resource allocation.
• Developed a web based data collection and reporting system for polling store data.
• Designed and deployed a financial year over year trending report for all stores.
• Interfaced with business teams to develop an allocation system for stores.

Confidential, Hoffman Estates, IL

Mgr. E-Com Business Analytics

Responsibilities:

• Created or customized Business Objects and Microstrategy reports giving merchants and account managers improved visibility into operations.
• Improved reporting by increasing frequency and detail of reports for the Marketplace operations.
• Developed finance based reports for distribution throughout the business unit allowing much better insight for decisions.
• Designed and implemented custom database tables that improved response time for report generation and enhanced granularity.

Confidential, Rosemont, IL

Perl Application Developer

Responsibilities:

• Created a CGI interface for a language database that met the need for multi-lingual product development.
• Implemented patient chart locking of online screens that protected patient data integrity.
• Migrated several online screens to mod perl with html templating which improved code support and response time.
• Employed Agile development methodology to produce timely and regular service packs that met client needs and documented the procedure.

Confidential, Itasca, IL

Senior Programmer Analyst

Responsibilities:

• Developed and supported a Logistics Proof of Delivery system written in Perl on Sun Solaris with an Oracle database, enabling accurate order tracking and improved customer service.
• Developed a new interface in Perl and LWP to parse inbound XML delivery data.
• Developed and implemented a Perl based warehouse control system running on Linux Redhat platforms which greatly automated the order fulfillment process.
• Deployed and maintained PC hardware and handheld computers for Proof of Delivery system at 38 locations. Migrated the PC software from Win 95 to Win 2K and then Win XP to ensure maintainability.
• Implemented and supported new Win CE based handheld RF scanners which improved productivity and reduced fatigue.
• Developed and supported a web-based Executive Summary Report system, coded in Perl accessing an Oracle database.
• Achieved 99% uptime of production warehouse distribution systems at eight locations to ensure overnight delivery of customer orders.