Bernardo Ramirez Email & Phone Number

United States

Senior Manager, Fraud, Identity & Onboarding Contols

Greater Los Angeles Area

• Designed a custom Access database application for tracking and billing delivery orders.
• Created a Visual Basic integration application to automatically transfer billing data from the Delivery Orders database in Access to the QuickBooks accounting software.
• Greatly reduced monthly data entry labor hours and lead time required for billing.
• Administer small network of Windows XP and Vista workstations.
• Produce and analyze financial reports to aid in reducing costs and improving margins.

• Administered a network of Windows 2000 servers running SQL Server as well as other integrated applications which made up a mission-critical automated account-based calling services platform.
• Managed a SQL Server database upgrade project to a Windows 2003 clustered server environment to maximize service availability.
• Configured real-time replication of the of the live SQL Server database to offload reporting and analysis services to an offline server and reduce the main server load.
• Improved Prepaid Card product profitability by at least 25% by providing real and accurate visibility into Key Performance Indicators, by reconciling vendor invoices against system data, and by recommending and.
• Increased and maintained the accuracy and integrity of the underlying platform data.
• Installed and implemented a Business Objects business intelligence reporting platform.

• Planned, engineered, managed, and supported all critical aspects of the voice infrastructure.
• Responsible for ensuring the reliability and availability of the company’s voice services.
• Managed the implementation of an Intelligent Routing System.
• Integrated a high density Cisco Voice over IP platform into the existing SS7 infrastructure.
• Upgraded the call detail record collection and mediation system and streamlined the departmental reporting procedures that rely on that system’s data.
• Administered a Business Objects business intelligence data warehouse environment and developed various ad-hoc and automated management and operations reports.

• Designed and built proprietary software system for collecting, rating, billing, and reporting switch call detail records using modern development tools and relational database technologies.
• Oversaw the further development and improvement of the system by analyzing user requirements, defining business rules, and writing technical specifications for the development team.
• Designed and oversaw the development and implementation of user interface applications for the Carrier Services back office to update and maintain data in the supporting database and to generate billing, auditing, and.
• Saved the company over $100,000 in supply costs through vendor invoice auditing and extensive call detail analysis.
• Developed a Least Cost Routing system that resulted in additional significant cost savings and increased revenues.

• Managed a team consisting of five Information Technology professionals.
• Implemented a help desk application and a bar-coded computer equipment inventory tracking system.
• Implemented a corporate Virtual Private Network across three sites in Miami, Los Angeles, and New York.
• Received certification and experience as a NACT STX Switch Technician.
• Installed and provisioned an STX switch as well as its related client/server application, the NTS 2000.

• Designed, wrote, and implemented a telecommunications carrier rating and billing application for three nationwide telephony switches using Visual FoxPro and SQL Server. The application was responsible for rating and.
• Enhanced the functionality of the carrier rating and billing application to easily and efficiently perform vendor invoice auditing, resulting in a savings of $100,000 to $150,000 a year due to erroneous charges.
• Developed a telecommunications application in UNIX that performed real-time processing of prepaid calling cards calls.

Bachelor Of Science, Electrical Engineering

Activities and Societies: Senior Design Project September 2010 - June 2011 Validation of Tropospheric Delay Models for GPS - Project.

Electrical Engineering