RON L. ROGERS

ac2ivm@r.postjobfree.com

**** ****-**** *******, *** 515, Silver Spring, MD, 20910

202-***-****

PROFESSIONAL EXPERIENCE

Aug’ 14 – Jul’ 17 Common Securitization Platform (CSP) Integration – Data Analyst, Freddie Mac (consultant Capco)

-Responsible for providing the business and data requirements for converting company’s legacy data and processes to conform to CSP’s interface

-Responsible for validating internal data dictionary matches CSP interface data definitions:

-Conducted a thorough data lineage exercise, documenting data mappings and related artifacts

-Enhanced internal Change Management process by proposing and implementing a third-party tool to automate the manual identification of changes across 45 CSP interfaces.

-Implementation freed up resources (3) to perform other value added analysis and reduced time to identify impact analysis from (2-3) days to (3) hours

-Worked closely with respective technology work streams to define and validate the data translation logic

-Worked closely with data stewards to design audit rules for data validation

Oct’ 13 – Jun’ 14 Enterprise Shared Services (ESS) – Infrastructure Project Manager, Fannie Mae (contractor Capco)

-Responsible for delivering IT infrastructure services against committed service level agreements to internal customers as part of the company’s Technical Change Mandate program

-Assisting project teams in SDLC deliverables during their Infrastructure certification

-Registered project with the Program Quality Office (PQO), managed and provided all deliverables for review and obtained sign-off from stakeholders within the planned milestones/timeline

-Managed and orchestrated activities related to the scheduling, staging and delivery physical and or virtual systems to the end-user.

-Mitigated and/or resolved any issues to ensure that the deployment schedule were met and fulfilled

-Document and updated all project deliverables in HP Enterprise Project Management tool

-Provided weekly and monthly status reports on project progress - delivered, issues and resolutions

-Represented project teams at the Change Management Review Board to ensure that deployment readiness procedures were adhered to

Mar’12 – Sep’13 Enterprise Service Bus (SOA) Platform – Business Analyst, Fannie Mae (contractor Capco)

-Conducted information gathering sessions and developed the business requirement of the thirteen (13) Operational Reports for the TIBCO Enterprise Service Bus (ESB) and other SDLC artifacts including; System Context Diagrams, Data Flow Diagrams, Requirements Traceability Matrix, Detailed and Summarized System and User Test Case results, Application Baseline

-Participated in the Joint Application Development (JAD) sessions with stakeholders (application developers, architects, technical support and managers), proposed a Date Data Mart to speed up query performance and reduce the number of required TIBCO jobs/processes.

-Based on requirements analysis I was able to detect/identify problems with the Solution Specifications so that corrective action could be taken

-Developed the Operational Report Layout and mapped to underlying Business Object Universe

-Developed the SQL Scripts for the reports and Unit Test scripts for reconciliation to the underlying database

-Worked closely with Testing CoE in reviewing System Test cases and resolving failed tests in Quality Center

-Investigated and determined root cause for discrepancies in operational data from TIBCO Hawk agents for different report types and frequencies – daily vs weekly vs monthly

Jul’11 – Mar’12 Rate Lock, Uniform Loan Delivery (ULDD) – Data Mart - BA, Fannie Mae (contractor Capco)

-Responsible for the business requirements in the design an audit Data Mart to capture the State Changes of the loans that enter the ULDD database system.

-Additionally, responsible for the business requirement for the redesign of the Rate Lock process workflow for all purchase or swap loans from loan sellers/brokers.

May’10 – Jun’11 Program Quality Office (PQO), Fannie Mae (contractor Capco)

-Provided coaching/advisory support regarding SDLC processes and methodology to project teams and application project managers

-Ensure projects met enterprise quality and risk requirements:

-Assessed project risks, ensured technology processes, controls and standards (Architecture, Legal, Security, and Data) are adhered to and that SDLC deliverables meet established quality criteria

-Documented any risk and quality findings in accordance with company compliance standards

-Managed multiple application review engagements and report on an ad-hoc or weekly basis to senior PQO management on project risks and in collaboration recommend production release authorization/denial to the production environment

-Work with application development teams in fulfilling the necessary change management pre-requisites (Remedy Tickets etc.) for production rollout

Jul’09 – Feb’10 Insider Navigator, Bethesda, MD

Business Analyst, VBA Developer, SQL Developer (Independent Contractor)

-Responsible for documentation, creation and daily execution ETL processes to extract data from the SEC web service using VBA and SSIS.

-Worked with Sales Reps to create requirements for new client reports.

-Responsible for researching gaps in requirements and existing Access and SQL database and finding solutions where a gap exists.

-Developed layout for HTML e-newsletter and excel formulas integrating data and html tags.

-Responsible for creating SQL scripts to ensure data integrity/data validation.

-Responsible for creating SQL scripts to create various client reports including daily insider trading activity, investor relations histories, screens based on metrics such as Market Cap, Sector/Industry, Director/Officer, Stock Trends.

Jan’09 – May’09 Commodity Futures Trading Commission, Washington, DC

Market Surveillance - Actimize Programmer (Contractor Volt Technical Services)

-Documented data and transactional flows in market surveillance model.

-Enhanced existing model and report to work on multiple commodity exchanges and accommodate future custom changes

-Worked closely with end users in the feasibility analysis for new surveillance models and performed data analysis to indentify existing gaps between existing data and model requirements.

-Identified and documented bottlenecks in model workflow that processed 3 million daily transactions leading to a 20% decrease in processing time.

-Performed installation, maintenance and administration of AIS 4.1 and Case Manager 4.0

Oct’08 – Nov’08 Aegis Mobile, Columbia, MD

Business Analyst /VBA Developer (Independent Contractor)

-Conducted informal end user interviews with testers and operational managers to document business requirements, workflows, testing logic, and GUI design.

-Documented Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.

-Designed and implemented a windows forms solution for Aegis mobile data testers from an existing MS Excel soln.

-Performed UAT

-Successfully converted requirements into a working winforms application and delivered the project 1 week ahead of schedule.

Sep’07 – Aug’08 Friedman Billings Ramsey, Rosslyn, VA

Fixed Income RMBS Research - SQL/.NET Developer (Employee)

-Worked closely with the stakeholders; managers, researchers and data modelers in the Fixed Income division to obtain the requirements to develop a Credit Surveillance dashboard to monitor the health of private label Mortgage Backed Securities

-Conducted data profiling of the data sources (Loan Performance and Intex) to determine which dashboard features (Over Collateralization, CPR, CDR, Tranche Composition, Risk Ratings, Servicer etc.) can be supported based on the completeness and consistency of the data

-Documented data lineage/traceability from source data components to dashboard components (tables, charts, fields) to assist in impact analysis when change request were submitted

-Mirrored the prepayment and default SAS models in Microsoft Excel and used as an independent framework to test output from Credit Surveillance dashboard developed in VB.NET

-This approach uncovered inadvertent flaws in the SAS model which was hidden due to SAS handling of certain calculations

-Integrated Bloomberg API into the dashboard to provide real-time data for Treasury curve calculation, Rating Agency (Moody’s, Fitch, S&P) Ratings and bond pricing information from Price Talk

-Integrated FusionCharts XML charts and maps to provide visualization of MBS Credit Quality time-series and the comparative geographic distribution of Credit Risk by Metropolitan Statistical Area (MSA)

-Developed an application/utility to the convert Loan Performance fixed width record fields into comma delimited fields to be staged for further ETL processing

Business Technical Services

- Responsible for ETL processes for Microsoft CRM in Development and UAT environments.

-Developed DTS processes using Scribe and other 3rd party Excel Addins in transitioning data from legacy systems

Aug’06 – Sep 07 Edgar-Online, Rockville, MD

Business Analyst /VBA Developer (Contractor Acsys)

-Performed functional analysis of beta and production XML data feeds.

- Created test cases and business processes to drive quality assurance of production data feeds.

- Documented Business Processes and New API specifications for additional functionality.

- Developed VBA applications to display XML output from API calls to significantly reduce QA cycles and unearth underlying technical and logical faults in the XML API Web Service calls.

- Work with Operations team, DBA and Programmers in creation of new stored procedures and successful execution of new releases.

- Developed Proof of Concept VBA application to automatically match electronically filed amended SEC Section 16 documents to their original filings with a 90% accuracy rate.

- Developed a proof of concept automated system for parsing all Edgar Form 4 filings for data anomalies, and provide automatic edits where possible and necessary to reduce manual labor cost (approx $90K) and increase data integrity.

- Assisted in developing new XBRL taxonomies under IFRS accounting to process international SEC filers.

- Converted 10K and 10Q SEC filings into XBRL documents using proprietary taxonomies.

May’06 –June’06 Aptus Capital Hedge Fund, Reston, VA

App Development -VBA Developer (Independent Contractor)

-Debugged any technical and logical issues from current tool.

- Created macros to integrate web data from Briefing.com into Portfolio Management Support Tool.

- Worked alongside Fund Managers to convert trading ideas into Excel Dashboards.

Sept’05 – May’06 Booz Allen Hamilton, Reston VA

Global Operational Team – Business Analyst (Contractor Affinity Networks)

-Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.

-Gathered and documented existing workflows, business processes, software and hardware through formal and informal meetings with the heads or points of contact of the various operational departments.

-Converted logs from software and hardware monitoring system into schematics using Visio as a baseline for the Data Center.

-Developed the GUI and proof of concept for the configuration management database

-Worked with Access developer to structure and prototype queries in Excel using V/HLOOKUPs, VBA macros, that was then developed in SQL

Global Applications Team – Quality Assurance Testing

-Performed Quality Assurance and Stress testing on internal applications.

-Augmented workflow in test scripts which improved throughput/testing time by 50%

Summer 2004 Lehman Brothers, Manhattan, New York

(Internship) Investment Banking Analyst -Global Technology Group

- Maintained Comp Set of 78 companies in Telecom Sector, and Equipment Manufacturing by analyzing company quarterly and yearly reports, which played a crucial role in the pricing of IPOs and M&A deals.

- Performed pro forma company analysis and created accretion dilution models for M&A pitches to prospective clients.

- Performed financial modeling and created Excel macros for scenario analysis.

-Worked alongside Associates and Managing Directors in developing Committee Memos, conducting client interviews and other procedures involved in the IPO process

- Compiled information for Public Information Books, and Pitch Books used in customer acquisition/business development

- Edited and distributed the Technology Weekly Update researching the latest news in technology from financing to merger and acquisitions using Bloomberg terminal.

Summer 2003 Sprint, Rockledge, M.D.

(Internship) Radio Frequency Engineering Intern – Radio Frequency Engineering Group

- Received training in Cellular Network Optimization: Introduction into System Optimization, Lucent CDMA 2000.

- Worked closely with RF engineers in developing networking optimization solutions in the roll out of 20 new cellular sites.

- Performed search scrubs, analyzed potential candidate sites, and worked with contractors on zoning issues concerning site acquisition.

- Troubleshooting Network problems using tools such as Neighbor List grooming and candidate analysis in Handoff failures, Propagation and Model tuning.

- Performed Drive Testing of the network and analyzed Drive Test data to ensure potential cellular site candidates met performance criteria.

- Performed Tilt Analysis and Link Budget-ERP Calculations

- Maintained databases of cellular site statistics for the Washington, Baltimore and Virginia region. Reports from which helped to determine how effective network optimization improved call quality.

EDUCATION:

Prince Georges Community College (CCNA) 2015 – 2016

Howard University, Washington D.C.

B.Sc. Electrical Engineering, May 2005

Magna Cum Laude (Honors): 3.7/4.0

Honors and Award: Deans List 2002-2005, Howard University Founders Scholarship, 2001

COMPUTER SKILLS:

Programming - Actimize, MS Office, Excel and VBA (Advanced), .NET, SQL, MySQL, SSIS, SharePoint, Crystal Reports

Engineering - Matlab, Mathematica, PSpice, Assembly language, C++, Map Info, IDAII, Bluerose, DBPlanner

Finance - PresBuilder, FactSet, Bloomberg terminal

Contact this candidate