TECHNICAL SKILLS:

• Proficient in Microsoft Excel, Word, PowerPoint, Access, SQL, VBA.
• Proficient with HP Extreme/Campaign Manager.
• Fluent in Spanish.

PROFESSIONAL EXPERIENCE:

Confidential, Elk Grove Village, IL

Issues Reporting Manager

Responsibilities:

• Report issues from the system of record and SharePoint tracker for Front and Back Office.
• Create monthly executive reporting of issues for the Operational Risk Management teams.
• Developed an issue Trend Analysis for Operational Risk Management to view areas of focus.
• Update the issue Operational loss report to view the loss in dollars and impact in accounts per issue.
• Built a rapport relationship with Operations & Technology, Brands, and Compliance reporting teams.
• Create and automate SQL queries in the Business Objects tool for Compliance, and ORM.
• Enhance SharePoint site by building, maintaining, and securing sub sites for our teams.
• Create template automation using Pivot tables and macros for monthly and biweekly reports.
• AD hoc reporting as needed.

Confidential, Elk Grove Village, IL

Business Analyst

Responsibilities:

• Created SQL queries with Enterprise Manager to extract data from various databases.
• Analyzed key words from incident tickets that were closed in Virtual Tech.
• Scheduled meetings with cross functional teams to gather functional requirements.
• Manipulated data extracted from the Database with pivot tables and VLOOKUP’s.
• Built strong relationships with Project and Functional managers.
• Analyzed user acceptance test results to verify data accuracy.
• Gathered information from database analysts to adjust SQL queries for reporting purposes.
• Translated incident tickets that are in Spanish and were opened in Latin America.

Confidential, Schaumburg, IL

Data Analyst

Responsibilities:

• Created databases with information supplied by third party vendors.
• Extracted and transformed data to be loaded in to the Data Warehouse.
• Analyzed Data trends and suggested performance improvement measures.
• Automated Data testing by recording Macros on Excel and Access to verify for accuracy.
• Manipulated data by using Pivot Tables for PowerPoint presentations.
• Maintained Access database for the monthly Data uploads.
• Requested documentation from our clients to clean Data attributes.
• Reconciled all data that was on the Risk Bordereaux against Account Current.
• Generated Write off reports and wrote off small quantities in the accounting system.
• Cleaned Risk Bordereaux and Account Current for Data upload.

Confidential, Elk Grove Village, IL

Analyst

Responsibilities:

• Created campaigns in HP Extreme for Consumer and Commercial credit card statements.
• Created a monthly matrix with all RPC marketing and legal programs for production validation.
• Generated daily production reports to validate campaigns are running as expected.
• Researched any issues prior to monthly production implementation.
• Created a SharePoint site to share information with Stakeholders across functional teams.
• Analyzed user acceptance test results to verify statement coding accuracy for both monthly campaigns and statement projects.
• Gathered information from Client Managers to create marketing segmentation for programs such as Points reward program, Birthday Points, and Cross marketing.
• Personalized THD marketing onserts in Campaign Manager (HP Extreme) with accountholders name, address, birthday, etc…
• Developed and documented product development requirements based on client needs.
• Created a monthly trending impact analysis for program initiatives on excel.
• Built a strong relationship with Client Managers, RPC Statement Development Team, WebView Development, and Transaction Services.
• Validated Spanish messages and onserts in RPC and THD Statements to ensure accuracy.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Cleaned data attributes by cross referencing attributes against old legacy systems.
• Maintained Data Integrity for SAP implementation.
• Developed and generated Ad - Hoc reports for Product Development Managers.
• Documented and resolved all issues for Product Development and the Sales Department.
• Analyzed User Acceptance Testing to verify that data was accurate for the Database.
• Compared data to ensure accuracy by running SQL queries from two Database Systems.
• Corrected and resolved day to day requests from business users.
• Extracted and transformed data to be loaded in to the Data Warehouse.
• Developed, gathered, and documented business requirements based on client needs.
• Prepared methodology and updated written procedures to keep up to date documentation.
• Analyzed data with Excel by using HLOOKUP, VLOOKUP, and Pivot tables.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Provided analytical support for Product Development teams by performing due diligence.
• Determined mutual fund’s asset allocation by running a Returns Based Style analysis.
• Considered criteria such as style, consistency, risk/return and correlation to benchmarks.
• Performed a qualitative analysis by sending out a questionnaire to Portfolio managers.
• Managed overnight Data upload for the Automated Portfolio Constructor.
• Performed analytical review of data to ensure accuracy and validity.
• Recommended solutions and changes to Product Development teams.
• Participated in the development, evaluation, and enhancement of data products.
• Delivered data in Access format for proper implementation on to the server.
• Extracted and transformed data to be loaded in to the Data Warehouse.