Juan Cabrera Email & Phone Number

Silver Spring, Maryland, Us

Silver Spring, Maryland, Us

Silver Spring, Maryland, Us

Altamonte Springs, Fl, Us

Silver Spring, Maryland, Us

Silver Spring, Maryland, Us

Mclean, Va, Us

Created SharePoint InforPath form as the go between for business partners and Data Change team. This tool replaced ClearQuest as the main ticketing process which saved over 700 man hours a year.Leverage advanced technical skill sets to develop and maintain end user computing tools and reports designed to identify data quality anomalies across our systems.Tracked, manage and resolved data quality issues in accordance to corporate standards. Supported business areas with ad-hoc data reporting. Provided metrics delivery of department metrics to senior level management, and assisted in the tracking of the process improvements. Identified data quality anomalies through the generation and analysis of customized and cyclical reporting processes as well as identifying trends and opportunities for improvement.Tracked, coordinated and communicated resolution of identified purchase edits issues.Provided senior level support in the development of various Single Family Operations Portfolio Surveillance analytics, using data mining, statistical, forecasting and modeling techniques.Executed and maintained complex data processes and controls for Data Quality unit.Leveraged data mining techniques to analyze and summarize data trends and patterns across multiple systems. Supported User Acceptance Testing (UAT) efforts for production system releases.

Mclean, Va, Us

• As lead analyst for the Primary Mortgage Insurance Reconciliation Project, developed an Access database for the analysis, archival and report of data received from the 9 mortgage insurance (MI) companies with which Freddie Mac (FM) has policies.• Owned communication between MI companies and internal partners to facilitate resolution on project issues and inquires. • Developed all process documents, procedures and reporting related to PMI Reconciliation • Provide data mining, analysis and process design expertise to resolve customer requests and promote efficiencies as needed.• Managed the Credit Enhancement Mailbox by answering all queries and requests delivered.• Tagged and Untagged Loans with Credit Enhancements upon requests.• Provide data research for internal and external business partners using SQL and SAS scripts.• Ran SQL queries as needed to analyze and research active and closed loans.• Created Post Fund Workflow database in Access, allowing analyst to query real time data in response to customer’s request on status of data changes.

Mclean, Va, Us

· Managed Data Quality Control for Master File Changes (MFC) that were submitted weekly from Performing Loans department for updating loans requested by the Servicers. · Updated the Business Plan Management Report (BPMR) monthly that included team stats and charts representing the time and manual changes that were input by the DQC team. · Created a new Excel matrix for PML 14, which included all the source codes from the Wall Street Journal and government websites that are needed to update monthly rates. · Directed all pool collapse changes on LASER System. · Overhauled automated processes producing less manual tasks and completion time.

· Reconciled WGES customer lists with local distribution company customer lists. Gathered data from multiple sources and compared against utility data in Access database. · Analyzed data to determine whether the queries were acceptable and reasonable. If data was problematic, determined reason, and devised and implemented a solution. · Facilitated with IT group to automate electric handbills, reducing completion time by four hours. · Analyzed and created SQL queries to retrieve data for customers not being billed. · Collaborated with utilities, WGES Business/Data Analysts, and call center personnel to review and revise business and data processes accommodating utility and other end-user requirements.

Washington, District Of Columbia, Us

· Developed and maintained monthly matrix reports for directors and manages to review monthly statistics and productivity in MS Excel. · Performed approved adjustments on individual loans in LASER in accordance with Exceptional Transactions Management procedures. · Customized and maintained Mortgage Backed Securities log to track approved adjustments. · Processed DB Mods and PBAs for bulk loan adjustments on LASER. · Reconciled difference findings on a monthly basis to balance the General Ledger.

Bethesda, Md, Us

· Administered MS Sharepoint website using FrontPage and Dreamweaver, executing Coldfusion, IIS website, SQL, and Firewall Servers. · Implemented LM Army ITES eCatalog and updated it monthly for inventory. Data mined Excel spreadsheets with Access and SQL queries. · Modified users in the sharepoint site, giving them the proper administrative permissions for their login to the site. Imported/exported data from Excel to Access and SQL. Implemented and updated the LMNETCENTS lite site for internal/external users to receive information packages from the site. Granted permissions for the right users to gain access for certain sites. · Reviewed RFP's and contracts to fit the LM format and standards. Planned and migrated

Overland Park, Kansas, Us

Instrumental in migration of Nextel and Sprint customer databases to support merger. Responsible for customer and sales data hygiene and integrity in Salesforce.comCreated SQL queries to extract account data; tested and certified reports to satisfy Salesforce.com requirementsAnalyzed data imported to Excel from legacy systems, purged duplicate informationExported workbooks from Excel into Access database and ran queries to populate reports requested by sales executivesCrafted and initialized process that automates updates to account data in Salesforce.com using Access database and Salesforce.com Data Loader

M. Div

B.S, Information Systems