TECHNICAL SKILLS:

Cognos 10.x (Framework Manager, Report Studio, Query Studio, Workspace Advanced, PowerPlay), QlikView, SQL, SAS (EG and Mainframe), Python, PySpark, Hive, Informatica, VBA, XML, ASP.NET, VB.NET, ASP, Visual Basic, Microsoft SQL Server, VB COM Objects, Microsoft Transaction Server, Visual InterDev, IIS, JavaScript, VBScript, HTML, DHTML, Oracle, Sybase, Microsoft Access, PowerBuilder, Microsoft Office, Chili Reports, ErWin

EMPLOYMENT:

Confidential

Bank Technical Analyst, Bloomington, IL

Responsibilities:

• Built over forty SAS jobs on the mainframe to merge data from two lending systems, ACAPS and CMSI.
• This effort allows for analytics and reporting to run smoothly as Confidential transitions from one Vehicle Lending system to another.
• Performed dozens of Bank Data Requests using SAS Enterprise Guide. These requests were in response to regulatory or analytical requirements.
• Streamlined SQL in Cognos reports to improve performance and cease generating high cost queries.
• Altered data packages in Cognos Framework Manager to meet changing business partner requirements.
• Gained exposure to Python, PySpark, and Hive.

Confidential

Actuarial Systems Analyst, Bloomington, IL

Responsibilities:

• Established the Cognos and QlikView environments for the Property & Casualty (P&C) Actuarial Department. Liaised with Cognos and QlikView Support teams as well as IT Security. Served as Subject Matter Expert on these tools for the department.
• Gained extensive experience with Cognos 10 tools, including Framework Manager, Report Studio, Query Studio, Event Studio, and Workspace Advanced.
• Led a team of four that converted over two hundred Business Objects reports to Cognos reports and QlikView dashboards. Personally converted over 125 reports.
• Developed and led QlikView training sessions for business partners, as well as Cognos and QlikView training courses for other developers in P&C Actuarial.
• Designed Cognos reports to support department EOM efforts. Built numerous other reports supporting application development efforts, including Rate History, CLEP/CLWP, Rate Revision in Progress, and Model Monitoring.
• VB.NET developer for the Rate & Factor and Guidelines systems.

Confidential

Investment Systems Analyst, Bloomington, IL

Responsibilities:

• Supported PAM (Portfolio Asset Management) for Securities and PAM for Mortgages investment accounting systems.
• Designed and enhanced numerous interfaces to help automate data entry into PAM.
• Developed and supported Access databases to provide additional data entry and reporting functionality for the Mortgages unit. Incorporated data extraction from PAM using XML.
• Lead developer for a project converting Impromptu reports to Cognos 8. Personally converted over seventy - five reports.
• Provided primary support for the ReconNet asset reconciliation system.

Confidential

Owner/Publisher, Peoria, IL

Responsibilities:

• Owned the Peoria rights for Coffee News, a free weekly publication distributed primarily to restaurants and coffee shops.
• Solicited advertisements, invoiced clients, and established distribution points. Subcontracted with a graphic designer and printer.
• Customized HTML on the website and designed interactive email and contest entry forms using ASP with a Microsoft Access database.

Confidential

Middle Office Analyst, Warrenville, IL

Responsibilities:

• Provided Profit and Loss and Risk data to traders on the Gasoline Components desk. Performed month-end reconciliation of books.
• Designed tools using VBA for Excel that automated labor-intensive tasks. These programs saved one hour of labor each morning.

Confidential

Programmer/Business Analyst, Chicago, IL

Responsibilities:

• Developed numerous applications for Confidential ’s Liquid Products Derivatives trading businesses. These applications reconciled financial data from disparate systems and were used worldwide. Developed other applications that facilitated tracking of operational errors and checking of trades to ensure accurate entries in the risk and confirmations systems.
• Active participant in all phases of projects, including gathering user requirements, database development, front end GUI development, and ongoing enhancements and support. Completed many applications individually and as a member of a team.
• Technologies used included ASP.NET, ASP, IIS, SQL Server 2000, Visual Basic, and VBA for Excel and Access.

Confidential

Software Engineer, Chicago, IL

Responsibilities:

• Lead developer of several modules for a school management system.
• These modules tracked student grades, medical records, and student fees.
• Responsible for maintenance of several other parts of the system.
• Created and maintained numerous Active Server Pages and VB COM Objects. Built and maintained SQL Server tables, stored procedures, and triggers.
• Technologies used included ASP, IIS, VB COM Objects, SQL Server 7.0 and 2000, and Microsoft Transaction Server.

Confidential

Consultant, Oak Brook, IL

Responsibilities:

• Developed an Intranet application using Microsoft Visual InterDev, ASP, JavaScript, and VBScript to help a manufacturing firm produce data for OSHA. Created and modified Intranet reports using Visual InterDev, ASP, VBA, Oracle, SQL Server, and Chili Reports.
• Designed reports using Access/VBA to aid an electric utility in tracking software defects in a deregulation project.

Confidential

Consultant, Chicago, IL

Responsibilities:

• Designed an internal job listing application using Visual InterDev and ASP.
• Created reports in Microsoft Access to help USN Communications identify sources of $300,000 per month in lost revenue.
• Modified and enhanced a PowerBuilder interface that helped Amtrak track labor costs.

Confidential

Consultant, Atlanta, GA

Responsibilities:

• Responsible for the implementation of the PowerTax utility tax software system at several major electric and gas utilities.
• Benchmarked financial data to ensure continuity between clients’ prior systems and PowerTax.
• Provided ongoing tax and technical support necessary to aid utilities in filing Federal and State income tax returns and preparing budgets.
• Designed interfaces to clients’ plant accounting systems for processing of transactions.
• Created graphical user interfaces to convert company tax data into PowerTax system.
• Designed customized PowerBuilder reports querying Oracle and SQL Server databases.