Ana Colta Email & Phone Number

Sunrise, FL

Doral FL

• Designed ETL processes, data extractions, cleansing, data integration, loading from different data sources between AHCA, Prestige Health Choice, and its providers
• Designed and created tools on the web (.NET) and sharepoint for internal staff (PCP Assignments, Ticketing system etc.)
• Automated the generation of Medicaid Provider Files for submission and registration with AHCA
• Organized meetings, gathered requirements from various departments and created SSRS reports
• … Show more
• Automated multiple manual processes involving uploading/ downloading and tracking membership, encounter files to and from the FL Medicaid system

Fort Lauderdale FL

• Migrated SSIS packages to SSRS using SQL query optimization techniques to eliminate staging tables, reduce data redundancy, and add the convenience of automated ad hoc reports.
• Managed new SSRS reports projects, from conducting meetings with inside organization clients to discuss new report requirements and business required documents (BRDs) to QA testing and final deployments

Miami FL

• Developed, successfully rolled out, and maintained company’s intranet on SQL Server 2008 Database.
• Designed inter-departmental automated workflows, which increased business process productivity, data tracking, optimized information distribution and eliminated inter departmental emails, communication issues and loss.
• Developed, maintained and improved tools with VBScripting and SQL (E.g. “Proposal Tool”, CRM Tools for… Show more
• Developed, maintained and improved tools with VBScripting and SQL (E.g. “Proposal Tool”, CRM Tools for Sales) which require minimum data entry, deliver full desired output and functionality automatically. Trained.
• Created, deployed and managed complex reports for all departments using SQL Server Reporting Services and Crystal Reports. These also include real time financial, productivity reports, metrics with thresholds, calls.
• Created department procedures and work instructions to accumulate processes knowledge and participated in integration of new companies. Show less

* Designed, maintained and optimized company's websites (including SEO) and website architecture with online products, services, payment options, accounts.* Participated in planning and creating new machine translation products.* Tested new software quality and instructed customers and potential customers on installing and configuring machine translation.

Designed and maintained website, data base and instruction programs

Bachelor Of Science In Business Administration, Management Information Systems

Activities and Societies: Beta Gamma Sigma Dean's honor roll.

Education record