| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Dayton, OH Street Address
EMAIL AVAILABLE http://LINKEDIN LINK AVAILABLEPHONE NUMBER AVAILABLE U.S. Citizen skype id:Candidate's Name .skypeFinancial/Economic Analyst, Systems Architect/Developer, Independent ConsultantI use sas, c++, and python for data processing and analysis.these languages are universally applicable to information invirtually any database packages and other sources.Am very experienced in:oanalytic system design and rapid developmentooptimizationoautomationHave designed and built a number of high profile financial analyticssystems for:oattomckinseyofannie maeointernational planning and researchPossess an exceptional software library of mathematical optimization and process automationroutines. Am also heavily involved in acute financial analysis of marketing andadvertising operations within a comprehensive, integrated revenue and cost framework.Candidate's Name
Dayton, OH 45409EMAIL AVAILABLE http://LINKEDIN LINK AVAILABLEPHONE NUMBER AVAILABLE U.S. Citizen skype id:Candidate's Name .skypeA professional with unique Financial/Economic/Business Analysis and Business Intelligence Systems skills with experience in Forecasting, Business Operations, Marketing, and Strategic Pricing/Marketing. A result oriented and analytical individual who stresses Data Integrity, innovative true optimization algorithms, and automation systems to improve corporate performance on time and under budget.EXPERIENCEWells Fargo, Charlotte, NC 11/2022 currentFinancial Crimes and Anti-Money Laundering AnalystPerforming deep diving investigation and analysis and process automation in the financial crimes space for Wells and a consortium of other banks.Skills Used: SAS, SAS Macro, Teradata SQL,Process Design/Automation, Meta-Programming, System Design, DDE, Python, JiraCritical Decision Systems, Jacksonville, FL 01/1996 10/2022Financial/Economic Analyst & Systems Architect/Systems Developer, Independent Consultant:Performing extensive economic and financial analysis on all phases of business operations related to marketing via the mail channel. Applied fruits of research to design and develop software optimization system to maximize total value of contents of a mail piece. Software embodies sophisticated integer programming algorithm to optimize the value of a mail piece on a customer specific basis with optionally includable business rules relating to managerial priorities, messaging limits, positive and negative synergy constraints, etc. Offer prices are computed through innovative analysis of parameter estimates derived from response modeling. Computational software written in C++, GUI front end written in Visual C++, integrated database written with MS Access. Granted a number of patent protections in 2006 - more pending.Skills Used: SAS, SAS Macro, SQL (Access),Process Design/Automation, Meta-Programming, System Design, Testing, Visual C++, Advanced Integer Programming & Profit Optimization, Predictive Modeling, Response Modeling, Linear Regression, Logistic Regression, Direct Marketing, Data Analysis, Financial Analysis, Optimization Research (improving convergence speed of LP Algorithms), Database Design, Mortgage Analysis, SAS to C/C++ Conversion, OLAP, Excel DDE, Distributed Iterative Parallel Processing Optimization Algorithms, Python, Cluster Analysis, some Neural NetworkJP Morgan Chase, New York, NY 08/2013 05/2014AML (Anti-Money Laundering) Analyst & Systems Architect/Systems Developer: Re-engineered, streamlined, and standardized a large set of non-Mantas SAS AML analytical applications. Developed SAS "standard instance" shell program to provide labor saving capabilities to SAS applications such as monthly/daily directory creation, access to common and specialized macro code libraries, automated emailing with attachments, and constructing a pop-up calendar based utility to "trick" applications to behave as if they were running on a different date than the system date without code changes.Participated in a number of ways for an initial implementation of Oracle Mantas AML applications: personally responsible for development of an AML analytical application, served as a mentor for more junior team members for complex SQL queries and analytical issues, and provided limited standardization for all Phase I initial AML Oracle applications.Developed a metadata based production file monitoring system. System automatically searched for directories and files (with correct date tags as offsets to system date) listed in the metadata for existence and emailed results to responsible stakeholders.Skills Used: SAS, SAS Macro, SQL (Oracle, Access), Process Design/Automation, Meta-Programming, System Design, Data Analysis, Database Design, ETL frameworks, Spotfire, Oracle MANTAS, ReportingFannie Mae, Dallas, TX 10/2010 08/2012Systems Architect/Systems Developer, Reporting Specialist: Sole responsibility for the design, development, and implementation of the analytical framework and processing systems needed to drive the STAR (Servicer Total Achievement and Rewards) program. STAR analytics provides an evaluation of a mortgage servicer's internal business practices, such as borrower outreach, timeline management, and loss mitigation and measures their effectiveness on a scorecard. The goal of the generated business intelligence is to provide concise metrics (both absolute and relative to peers) and rankings of key aspects of mortgage servicer operations in scorecard form for the purpose of incentivizing servicers to improve the quality of their mortgage servicing.Skills Used: SAS, SAS Macro, SQL (Oracle, Access), Process Design/Automation, Meta-Programming, System Design, Data Analysis, Mortgage Analysis, ETL frameworks, Testing, some Data Modeling (Embarcadero), some UML, ReportingInternational Planning and Research, Maynard, MA 01/2009 12/2010Systems Architect/Systems Developer: (intermittent) developed wide ranging organizational and innovative software solutions to enhance, extend, and automate complex analytical procedures and reporting functions. Primary aim to provide users with powerful, detailed code change free control of analytical processing through manipulation of meta-data in databases. Metadata driven, large volume analytic/forecasting system used to monitor ~80 international product and service markets potentially affected by ~6,000 series on a monthly basis for significant changes. Key drivers of monitored markets are analyzed under a variety of user defined data transformations (none, log, dlog, percent changes, PDL), model specifications, and error term arima models.Skills Used: SAS, SAS Macro, SQL (Oracle, Access), Process Design/Automation, Meta-Programming, System Design, General Statistical Analysis, ETL frameworks, ReportingJP Morgan Chase, Columbus, OH 04/2010 - 09/2010Systems Architect/Systems Developer: automation/rewriting of SAS based forecasting models, developed powerful difference reporting systems for sas datasets with flexible, user defined reporting categories, externalization/standardization of spline processingSkills Used: SAS, SAS Macro, Process Design/Automation, Meta-Programming, System Design, Analysis, ETL Frameworks, Unix Shell Scripting, Subversion Source Control, Mortgage Analysis, Splines, ReportingWells Fargo, West Des Moines, IA 10/2009 - 01/2010Systems Architect/Systems Developer: Performing review, upgrades, and process automation at WF of analytical forecasting processes related to mortgage probability of default and loss given default models. Insuring model consistency for same models written in two languages (SAS and C/C++).Skills Used: SAS, SAS Macro, SQL (Access), ODS, Process Design/Automation, Meta-Programming, System Design, Predictive Modeling, Regression, Mortgage Analysis, Unix Shell ScriptingThe Selling Source, Las Vegas, NV 10/2007 03/2009Financial/Economic Analyst & Reporting Systems Developer: Performing wide ranging financial and behavioral analysis on all phases of business operations related to online payday/sub-prime lending industry. Designed, developed, and automated analytical and reporting systems to commoditize both internal business studies and external client portfolio management functions with information and KPI from diverse and isolated information sources. Performing acute agent behavior studies (online borrowers and lead generators) predicated on ability to access, assimilate, and analyze large bodies of transactional data from unconnected information sources. Developed automated and/or scheduled monitoring systems that collect data, analyze the data, detect conditions of interest, launch conditional processing, and issue automated emails containing data dependent verbiage to responsible individuals (with supporting file attachments where necessary). Performed predictive modeling using application data as determinants of defaults and loan ROI. Numerous deep diving business intelligence studies requiring cross server/cross platform data acquisition, and analysisSkills Used: SAS, SAS Macro, SQL, Process Design/Automation, Meta-Programming, System Design, Predictive Modeling, Financial Analysis, Microsoft Office with ODBC extensions, Pivot Tables, Sampling, MySQL, SQL Server, Fraud Detection, Large Volume Data Processing, Mentoring, Database Design, Data Warehousing, XML Parsing, ETL, Cash Flow Analysis, Analysis of Business to Business internet transactions (100+ million records), OLAPPeoples Bank, Bridgeport, CT 01/2005 07/2005Business Analyst & Systems Developer: Brought clients Customer Information Management System (CIMS) project to life and mentored junior SAS developers. Project integrated daily data feeds from isolated information systems to provide comprehensive view of its customer base by mapping accounts to individuals and mapping of individuals to households. Project objective was to provide bank the strategically important ability to coalesce disparate account information as portfolio elements of the principal decision making units (households) for its services for marketing and customer relationship objectives. Developed standardization routines to make all account data sources appear as if they were daily when often they were not.Skills Used: SAS 8.1, SAS Macro, SQL, Sybase, System Design, Windows NT, Mentoring, ERWIN, ETL, Data IntegrationMcKinsey & Company, New York, NY 02/2004 06/2004Financial/Economic Analyst & Systems Architect/Developer: Developed a comprehensive analytical system to sanitize, normalize, and analyze Financial Statement and Balance Sheet reporting history (since 1950) of Standard & Poors companies. Basic system extracted necessary information for user defined sets of companies, then generated standard set of statistics (mean, quartiles, variance, kurtosis, minimum, maximum, etc.) for the time series of user requested sets of computed metrics (typically variations of earnings metrics such as EBITA, EBITDA, etc. and variations of ROI metrics over differing time spans such as 3 years, 5 years, 7 years, etc). SAS system would then output computations into dynamically created Excel workbooks and worksheets through DDE for analyst consumption. Oracle database of Standard & Poors history could not be queried directly via standard SQL since the database employed was an amalgamation of a number of data vendor's information. Developed the necessary "wrappers" and interfaces to make the database appear normalized. Installed SAS products.Skills Used: SAS 9.1, SAS Macro, SQL, Oracle, System Design, Windows XP, DDE with Excel, Data Analysis, Financial Analysis, ETL, Process Design/AutomationSAS Institute/U.S. Department of Commerce, Gaithersburg, MD 01/2004 04/2004Business Analyst & Systems Developer: Maintained and performed minor modifications to the DOC Consolidated Reporting System (CRS) developed by SAS Institute. The CRS generated wide-ranging reports on numerous areas of DOC operations for distribution over the Internet.Skills Used: SAS, SAS Macro, SQL, Business Analysis, System Design, Windows XP, Visual C++, limited JSP, TestingPfizer, New York, NY 08/2000 08/2001Business Analyst & Systems Architect/Developer: Integrated the Medical Inquiry reporting systems of two pharmaceutical companies. Pfizer acquired a pharmaceutical firm via corporate merger with inferior reporting/analysis systems but superior data collection systems. Integration project required data standardization (lengths, formats, etc.) and development of mapping tables to make acquired information collection systems produce raw data consistent with Pfizer historical norms. Expanded and upgraded reporting and analysis through web distributed OLAP based reporting tools (SAS WebEIS, SAS Cubes, Proc mddb) which replaced COGNOS cubes.Skills Used: SAS, SAS Macro, SQL, Oracle, Business Analysis, Process Design/Automation, Meta-Programming, System Design, NT, SAS Data Warehouse Administrator, OLAP, ETL, Web Analytics, Process Design/Automation, Dashboard, SAS EGPeoples Bank, Bridgeport, CT 08/1999 06/2000Business Analyst & Systems Architect/Developer: Decommissioned unsupportable custom written SAS batch job scheduling system and designed an IBM Maestro/Tivoli scheduling replacement system. Developed back-end SAS analytical engine for Data Quality Reporting Project. SAS analytical engine, with minimal setup, automatically extracted data from specified data warehouse database (table by table, column by column), developed data type summary statistics (mean, median, mode, missing values, minimum & maximum values etc.), and produced final form HTML pages. HTML summary pages were thus accessible bank wide through a web based front end to provide analysts with a means to assess quickly the quality and content of a particular data warehouse column. Provided mentoring and served as troubleshooting resource for community of approximately 60 SAS developers. Handled SAS migration issues caused by switch of bank credit card processing vendors.Skills Used: SAS, SAS Macro, SQL, Oracle, Sybase, Business Analysis, Process Design/Automation, Meta-Programming, System Design, Testing, NT, MentoringPfizer, Groton, CT 10/1998 06/1999Y2K Project Lead: Engaged in Y2K coordination and compliance activities for major Pharmaceutical Company. Developed production system involving mass code scanning techniques to identify and disseminate Y2K readiness assessments of SAS usage for 7 organizations (156 SAS developers - ~35,000 SAS programs). Participated in/or responsible for remediation and testing of major systems in Y2K test lab.Skills Used: SAS, Process Automation, Meta-Programming, System Design, Testing, NT, UNIX, VMSDun & Bradstreet, Parsippany, NJ 04/1998 10/1998Y2K Systems Analyst: Engaged in Y2K compliance analysis for major Information Services Company. Client has requested comprehensive review of large number of interrelated systems whose output/analyses are essentially being commercially marketed.Skills Used: SAS, Process Automation, Meta-Programming, System Design, Testing, MVS/TSO, SAS AFSears, Hoffman Estates, IL 11/1997 04/1998Financial/Economic Analyst: Engaged in analyzing the effectiveness of Marketing and Pricing activities for Major Retailer. Client has requested comprehensive review of Marketing Operations. Client operates stores, which house organizationally distinct Product Groups. Product Managers are tasked with improving performance by using limited budgets to fund two main activities: buying print advertising space and "covering" price reductions, i.e. using budget to make up difference between regular prices and discount prices.Skills Used: SAS, Process Automation, Meta-Programming, Predictive Modeling, Linear Regression, UNIX/ NT, Data Analysis, Financial Analysis, ETL, Large Volume Data ProcessingMBNA, Wilmington, DE 01/1997 08/1997Business Analyst & Database Modeler: Engaged in Marketing Analysis and Business Operations Analysis for Credit Card Firm. Client typically engaged in joint Marketing arrangements with various third party organizations possessing member lists. Client Managers were tasked with increasing desirable cardholder base by target marketing these lists. Duties involved processing large data sets to merge member lists with Client information sources and developing predictive models to rank order or "score" list members with probabilities for response and qualification. Additionally, used dynamic programming techniques to develop scheduling algorithm to reduce billing related operating expenses by $900K annually.Skills Used: SAS, C, Process Automation, Meta-Programming, Predictive Modeling Linear Regression, Logistic Regression,Large Volume Data Processing, Customer Acquisition, Response Modeling, UNIX/NT/TSOYellow Freight, Overland Park, KS 08/1996 01/1997Business Analyst: Engaged in wide ranging analysis of business operations for a major Trucking Firm in conjunction with major accounting firm. Used code generation techniques to quickly develop reporting and analysis tools. Employed statistical techniques to assist in identifying determinants of poor profitability.Skills Used: SAS, Process Automation, Meta-Programming, Data Analysis, Linear Regression, NT/TSO, ETLInnovex, Lenexa, KS 01/1996 07/1996Business Analyst & Systems Architect/Developer: Participated in business process reengineering project to upgrade and standardize reporting capabilities for a medical Clinical Research Organization. Client typically received raw data from major Pharmaceutical firms on the results of initial tests of new drugs. Client's responsibilities were to write customized reports using the data. Developed Custom Report Writer, using code generation techniques, to reduce significantly the need for code development and maintenance, and to provide capabilities unavailable from commercial report writers.Skills Used: SAS, Process Automation, Meta-Programming, NTEntrepreneurial Venture, Overland Park, KS 1994 - 1995Financial/Economic Analyst & Systems Architect/Developer:Designed and developed Energy Saving College Course Scheduler.Designed and developed Optimal Planning Tool (OPT). OPT is a business case tool designed to develop optimal integrated Pricing and Marketing Strategies in furtherance of Corporate Objectives.Skills Used: C/C++, Simulation & Optimization, Parametric Functions, NT/Win95Summit Analytics, Overland Park, KS 1989 - 1994Vice President/Market Analyst: Developed and sold market analyses and consulting services to major players in Telecommunications Industry.Skills Used: SAS, Linear Regression, Data Analysis, Process Automation, Meta-Programming, DOS/Windows/CMS/TSO, APL, SAS AFUS Sprint, Overland Park, KS 1987 - 1989Business Analyst & Senior Planner/Network Modeler: Developed Network Sampling System. System sampled and stored Call Detail Records created by switches. System was designed to provide quick and reliable answers to ad hoc questions and compact data source for trend analysis.Skills Used: SAS, Process Automation, Meta-Programming, Data Analysis, VMS/DOS/CMS/TSOAT&T, Bedminster, NJ 1983 - 1987Market Analysis and Forecaster:Staff Manager: Responsible for coordination and consistency of all demand analysis for FCC filings. Overall responsibility for forecasting rate change effects for MTS, WATS, and 800 interstate revenues ($24B dollar a year market). Testified before FCC for AT&T in support of 1986 Filing.Manager: Direct responsibility for rate impact forecasts for MTS ($16B year market). Developed MTS Rate Change Forecasting System.Skills Used: Predictive Modeling, Linear Regression, Non-Linear Regression, Revenue Forecasting, SAS, RAMIS, Simulation, Process Automation, Meta-Programming, Data Analysis, DOS/CMS/TSOEDUCATIONState University of New York at Stony Brook: BA (1978), MA(1980), ABD(1982) EconomicsFields: Advanced Microeconomics, Advanced EconometricsMISCELLANEOUSComputer Languages: SAS (very strong), C (strong), C++ (strong), VC++ (strong),VB (some), MS Office, SQL, Various PC & Mainframe Database Packages, PythonOperating Systems: various Windows O/S, DOS, UNIX, LINUX, CMS, MVS/TSO (JCL), Open VMS6+ years military service in Intelligence as Cryptanalyst and Vietnamese LinguistCommended to White House for Linguistic work at Fort Chaffee Refugee Center |
