Sign in

Marketing Data

Chicago, IL
February 21, 2020

Contact this candidate


Leon B. Marasigan

**** ***** ******* ***** #***

Chicago, IL 60614

Cell ; 847-***-****



Expertise in bridging large enterprise application requirements between business groups and IT/ Engineering solutions. Using Agile methodology having hands-on experience in all stages of life cycle development while playing roles in requirements gathering, hands on development in database applications,infrastructure maintenance in (Master Data Maintenance), authored enterprise policy and procedures in user acceptance testing and had played roles in the administration and prioritization of required solutions and deliveries from the IT group.

Having accrued over ten years of experience in a Stock Exchange Regulatory group, 5 years experience in database marketing, and 10 years experience in large manufacturing settings while having supported development projects in business intelligence, data-warehousing, marketing and finance decision support, user acceptance testing, operations and process assessments. Excel at blending both technical and people skills to develop close working relationships in complex, high-pressure settings. Committed to pursuing clear and well defined understanding of objectives and purpose, solid preparations, and effective communications, leading to good teaming and cohesive direction in project development and implementation


CHICAGO STOCK EXCHANGE, Chicago, Illinois APR_2007 to DEC_2018

An organization (since 1882) and an integral part of the national equities trading system.

The exchange is a self-regulated organization, which operates under the oversight of the U.S. Securities and Exchange Commission (SEC). Recently acquired by the intercontinental Continental Exchange as the same holding company of the NYSE.

IT Liaison / Business System Analyst. Acts as the bridge between the Market Regulation Departments and Technical Support groups using Agile Methodology while at the same time fulfilling data mining and custom report requirements, and User Acceptance Testing.

Participated with senior management and technical groups in the development of regulatory -surveillance requirements and related software design considerations regarding the implementation of new functionalities that monitor exchange participant’s trading behavior while supporting SEC and Exchange rules.

Articulated all open technical requirements of all Regulatory Groups in the Exchange in a clear and well defined presentation while assigning initial priority values that provided support in periodic status assessments which facilitated the prioritization of on-going development projects as well as remedial requirements. Using Agile methodology Initially with Clear Quest with further customization.

Authored Regulatory Policy and Procedures regarding User Acceptance Testing. Developed Test Plans and Test Cases while conducting User Acceptance Testing using SQL /TOAD.

Filled in different levels of reporting requirements and statistical summaries that supported Market Regulation’s situational awareness, some of which are integral components of review protocol steps, while having to conduct training in new software release regarding ad hoc database applications .Using SQL/MS-Excel/HTML(as Menu Driven On-Demand Apps)

Provided coverage for specialized data mining and reporting that may lead to enforcement legal action involving complex data models subject to intense scrutiny.

Database infrastructure update and maintenance (Reference Table - Master Data Maintenance).

All requiring a deep understanding of equities trading data model which represents Order/Trade life cycles and Market Data

Leon Marasigan Page two


Consulting group that offers a broad range of Application, Infrastructure, and Business Process Outsourcing Services with 10,000 employees world wide since 1965

Senior Consultant/ Project Manager Abbott Lab. Diagnostics Device Division

Acted as the primary resource person in overseeing the development and maintenance of CMSLite enterprise application which was the systems of records that tracks maintenance activities on diagnostics equipment deployed in 104 countries, with consideration to a highly regulated environment with Food and Drug Administration(FDA) oversight.

Requirements gathering, project planning/scheduling using MS Project /Visio

Intensive interaction with outsourced software development groups translating business requirements into technical solutions.

Intensive interaction with user groups and regional technical leads world-wide .

Conducted User Acceptance Testing using Sharepoint and SQL/Excel

Coordinated the deployment of new version software release.

Performed data mining and adhoc custom reports Using TOAD SQL

WASHINGTON MUTUAL, Seattle, Wa FEB_2005 to JAN_2006

What was then the 5th largest bank in the U.S. and a leader in home mortgage sales and services.

Business Systems Analyst

Source –(ETL) and integrate data from disparate origins. Developed validation and staging processes to conform incoming data to business rules and design requirements,following strict project schedules and conducted code walk-thrus. Performed deep dives into systems processes to identify problems, formulate and implement solutions.

Member of a development team that designed and constructed Washington Mutual’s Marketing Campaign Reporting Infrastructure which was staged and conformed in an

ORACLE environment and ETL'd to an MS SQLServer database using DTS where the reporting layer resided.

Played a leading role in data acquisition, infrastructure development and data management. Used SQL Loader & PL/SQL stored procedures as the primary ETL tool, and developed SQL Plus -TSQL scripts for QA and data validation.

Developed marketing campaign direct mail response reports using ORACLE stored procedures to create aggregation tables referenced by MSAccess where screens were developed and passed over to Sharepoint for report distribution.

AAA CHICAGO MOTOR CLUB, Aurora, Illinois MAY_2000 to MAY_2004

An auto membership club part of a regional organization, with over 5 million members offering travel and insurance products.

Systems/Marketing Datawarehouse Analyst

Analyzed, evaluated, designed, implemented, and administered core business processes and systems. Acted as a resource person for business intelligence, direct marketing, adhoc reporting, and performance metrics development, responded to inquiries from all areas of the organization including Marketing, Finance, and Operations.

Leon Marasigan Page three

AAA CHICAGO MOTOR CLUB, Aurora, Illinois MAY_2000 to MAY_2004

An auto membership club part of a regional organization, with over 5 million members then while offering travel and insurance products.

Played a leading role in the development and implementation of the Marketing Datawarehouse into the Chicago club. Results provided significant contributions to Direct Marketing, cross-selling insurance and travel products into AAA’s membership base, and fulfilled many other production and data analysis functions.

Developed an intranet site, which was adopted as organization’s main reference for operational performance metrics in Membership Marketing.

Contributed to strategic organizational decisions by acting as a resource in performing data mining and analysis concerning issues in price restructuring and product reconfiguration.

Partnered with internal and external consultants and vendors to provide marketing systems support which developed and implemented tracking and response reports, process assessments, developed and produced extracts and prospect lists.

Collaborated with the marketing and executive teams in planning, execution, and administration of marketing campaigns that drove revenue and sales.


M.B.A. Finance; St Louis University; St Louis MO

BSBA Marketing; St Louis University; St Louis MO

AA in Applied Science Computer Information Systems; Greyslake IL


MS-SQLServer Administration –Micro Train-Chicago

Certified Crystal Reports Developer -MicroTrain-Chicago

Advanced PL/SQL Oracle University Schaumburg IL

Oracle Developer Suite –Report writer Oracle University Schaumburg IL

Agile -Scrum Master Certified

Expert: SQL, Data Modeling, MSaccess,MSExcel, Technical Writing, Agile -Scrum

Intermediate: PL/SQL,C,HTML-JavaScript, TOAD, MS SQL2000,

Beginner : Java,C, C++, Crystal Reports,DTS,,Python -Jupyter Notebook

Contact this candidate