Cristian Rodriguez Email and Phone Number

Anylitical and fast pace ad-hoc reporting!

Managed Long Term Care - Business Information Analyst I Successfully designed, developed, and integrated multiple databases from multiple data sources to create new reports that helps the enrollment, clinical, and quality teams to accurately monitor the membership load and increased the department performance.Responsibilities- Implementations, Reporting and Analysis:- New: Daily MAXIMUS Enrollments, Terminations / Dis-enrollments, Rejections Reports: Codes and translation description- New: Members weekly CPSUI report: Telephone Consumer Protection Act of 1991 (TCPA)- New: Members research and monitoring.- New: Monthly Reassessments report.- New: Monthly Care Manager Compliance report.- New: Dis-enrollment outreaching report.- New: Daily UAS Assessments / Reassessments Report: Most recent and previous Level of care score- Monthly PCW services report- Monthly Re-certification report- Quarterly Quality LTSS performance report.- Annual Quality LTSS State report.- Surplus members update and monitoring.Tools / Resources:- Database Developer (SQL Server 2016, Access)- File integration (MAXIMUS, Excel, UAS Data exchange)- Automation (Access, Excel, Outlook)

Created a software application using advanced development and coding techniques. Manage all phases of application design from coding and prototyping through system testing, integration and deployment. RAD Tool: DelphiDBMS: PostgreSQLWeb: PHP, JavaScript, Apache Results:Created an Administrative application for the credit repair process, helping the company to be more productive and up to date by using the most advance techniques and technology, Intelligent reminders, employee-customer chat interaction. Tuning up the quality and speed of all operations by extracting and loading the credit report information reducing the work preparation, personalized automated messages-reminders by phone texts and emails to the customers, which end up building a closer relationship with customer whom are always updated with their fixing credit processes.Developed an web site using PHP that allow the customers to check their account balance, upload documents, and check their status any time.Developing, enhancing, maintaining the Database. Utilizing the best and lower cost procedures to ensure the safety and Integrity of the company data. Helping every day by finding better solutions and practices for the company.wallstreetc.sytes.net - Web module

Development and implementation of a personal accounting software.RAD Tool: DelphiDBMS: PostgreSQLResults:A very friendly and useful application in which the user can:Load bank statement batches for analysis and reporting.Maintain an up-to-date expectation between the incomes and expenses.Analysis graphic charts and comparison date to date Work as database Administrator in charge of maintain the good performance of the data, create, modify, and maintain the database and its structure.Save and restore the data utilizing the best practices.

-Automatic database backup, SQL’s, PL/pgSQL Functions, DML’s, DDL's, data restoring and updates.-Upload large MS Excel files, with thousands of telephones records into the system for the creation of reports for payments, distribution and organization of the telephone numbers by date, type of plan or payment. -Analysis for possible reclamation, and creation of the reclamation reports; Telephone number history and report.-Data merging and upload of information of different Excel and Text files to the PostgreSQL databases and creation of reports.-Online support for the oBusiness Manager application and database with updates, database troubleshooting, data backup and restore of corrupted database and files, using windows remote desktop and third party applications such as teamviewer, vnc, showmypc and ammyy.

-Assisted in preparing contracts and sales proposals for customers.-Online and onsite helpdesk support and PostgreSQL database troubleshooting.-Deleting, creating and updating data; Migration of data from foxpro, SQL Server, Access and Excel to PostgreSQL database to use it with the INFOPLUS PLATINUM point of sales and accounting system.-.ASP User interface programmer for the new version of INFOPLUS PLATINUM