SUMMARY

• Track record reveals proficiency in numerous programming and software applications.
• Expert in database development MsSQL server and Microsoft products, SSIS,SSRS,SSAS and Power BI.
• Experienced in development of client server, desktop and web application using SDLC steps of design, code reviews, prototyping and multi - level testing
• Operational knowledge of managing full software development life cycle involving: Web development, SQL Azure, API/Web services integration, .Net framework, Architectural Design and good knowledge of statistics.
• Expert in programming .NET, C#, VB, PICK programming (jBase, Universe and Unidata in Windows and Unix)
• Highly motivated and creative, wif strong analytical skills.
• Enthusiastic contributor wif a collaborative spirit, a strong work ethic, and a passion for new challenges and experiences.
• Team task minded, productive and well organized.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville

IT Director/SQL Developer

Responsibilities:

• Created automated management reporting system using SQL Server Reporting Services (SSRS), SharePoint.
• Designed, developed, implemented and maintained data models to be used by Power BI and SSRS and data discovery tools.
• Created automated process to create ACH files CCD and CTX format to send transactions wif detail about each record.
• Designed new BCP to ensure business continuity and reliability of the system wif less risk of loosing data.
• Managed ticketing system for end user and IT team to improve productivity of the team and user’s satisfaction.
• Improved Integration of collection software wif Livevox dialer and faster data transaction and accuracy of files selection is provided.
• Customized credit bureau reporting to apply state restriction and also statute of limitation be considered to mitigate the company’s risk.
• Implemented new integration wif collection software wif Transunion TLO for scrubbing and monitoring of the accounts.
• Developed SSAS Multidimensional and Tabular databases using MDX and DAX. Created smaller tabular based models for targeted reporting solutions.
• Managed developers to use SSIS for faster and more reliable ETL process.
• Designed and implemented new browser for auto population of data into the required fields to be submitted to EOscar site.
• Worked closely wif data scientists to develop scoring model for the accounts.
• Designed customized report for operation manager to show agent’s performance monthly, weekly. daily and hourly.

Confidential, Jacksonville

IT Director/SQL Developer

Responsibilities:

• Created automated management reporting system using SQL Server Reporting Services (SSRS) and SharePoint.
• Establish the use of Power BI for executive leadership reporting and created standard data models to facilitate development and adoption.
• Designed database based on client's needs for loading data (ETL using SSIS and BCP) and creating reports.
• Maintained development and test reporting SQL Server 2008 databases.
• Created business requirements and developed applications using MS SQL Server, Crystal Reports, VBA, and Excel.
• Developed .Net application to use web application and retrieve xml data from property management sites: Yardi, One Site (Real Page) and Property Boss
• Developed ETL program to load data from clients such as GE, Synchrony Bank, Citi Bank, Bank Of America, Aimco, Point2, Arrow Financial, GM Financial,..
• Architectured, designed and implemented integration between Latitude system wif Livevox auto dialer and also Dial Connection to send the request files and load the result files in the optimum time interval.
• Maintained and tuned MsSQL database for best performance.
• Developing OLAP cubes using SSAS 2008 and calculated the metrics dat could evaluate the performance of the agents, dialer, letters, credit reporting and other items.
• Managed IT department of the company wif 4 branches.
• Conducted upgrade of the network domain from Active Directory .
• Migrated MsSQL server database of the main application to the new server.
• Managed steps to maintain IT security compliance certificates of ISO, SSAE16 and PCI, including documentation and applied required process.

Confidential, Denver

Senior System Analyst/DBA

Responsibilities:

• Managed data conversion from Cubs and Facs system to MsSQL server.
• Developed pre process C# programs for Latitude application for data validation and accuracy of client’s data.
• Developed post process stored procedures for auto posting payments, duplicate handling and client confirmation.
• Developed data scoring model in MsSQL server to improve company performance and saving cost.
• Programmed scheduled tasks in Latitude software for automatic report creating, auto closure of the accounts, auto posting adjustments based on the client needs..
• Managed and configured Infor application as Enterprise Asset Management for the company.
• Developed Latitude Exchange interfaces for many clients for new business loading, maintenance and direct payment imports as well as export reports for client reporting.
• Developed ETL system to transfer data from clients’ back-end system. The client list includes Direct TV, Direct Energy (Collect Link), ADT, Nextel/Sprint, Verizon Wireless, AT&T, Cingular, BMG, State Of Colorado, West Texas Gas, NICOR, Arrow Financial, NCO, Hilco, Galaxy and Arrow Global. The software system is modular and flexible. The architecture includes special designed ETL module for each clients’ data format and also customized reports and statements.
• Developed programs to facilitate Latitude data transactions and get Latitude certificate for the company. Programs include 9 sections for importing AIM data from client (Placement, Medical, Payment, Recall, Demographic, Miscellaneous, Notes, Bankruptcy and Deceased files) and also 8 sections for exporting reports to the client ( Payment, Close & Return, Recall Objection, Reconciliation, Demographic, bankruptcy, Deceased and Status reports)
• Managed migration of CUBS from MvEnterprise to Universe in AIX environment.
• Redeveloped existing program in Universe to prepare for migration from MvEnterprise to Universe.
• Developed auto post system to extract data from client files and post them automatically into CUBS.
• Extended Auto posting system to use spreadsheet posting for some client dat need priority of payments (Principal, Interest, Miscellaneous fee, ...)
• Programmed custom subroutine to stamp the original payment information for NSF payments in TRANS file. This was used to report the original payment date for some clients.
• Developed application to facilitate integration between CUBS and dialers. It includes creating input file for the dialer and also importing dialer result into cubs and create report for the dialer manger. me worked wif different dialers including Noble, Davox, Livevox and CT-Center.
• Worked on converting data from FACS (Ontario system) to CUBS.
• Programmed “Day End” automated script using Accuterm scripting to be ran by windows scheduler.
• Programmed customizable parts of posting and collector screen to change status, close or reactivated accounts based on custom needs.
• Worked wif outsource letter company to send them data files and also load the NCOA (National Change Of Address) data into cubs.
• Developed Cost report for the company to monitor total time spent on each individual account by every collector and also total number of letter sent for each account.

Confidential

Pick programmer/IT Manager

Responsibilities:

• Maintained CUBS application for 150 workstations, responsible for database optimization (more than 20 million records), adding new features and customizing existed functionality based on complex business logic.
• Direct communication wif clients and end-users to investigate, coordinate and process project request and create user friendly reporting systems to satisfy client needs.
• Developed automated system to transfer data from clients’ back-end system. The client list includes CIBC, Royal Bank, TD Canada Trust, Ford Credit, Hydro One, AMEX, Enbridge and City of Brampton. The software system is modular and flexible. The architecture includes special designed ETL module for each clients’ data format.
• Programmed data conversion software in J-Base to load clients data into PICK Database
• Implemented a Secured Business Intelligent Portal application for daily and weekly reporting to clients (Major Canadian Banks and Financial institutes).
• Researched business condition and designed data analysis reports and charts for management team to has complete feedback of recovery rate.
• Maintain & support predictive dialer through CUBS (CU CONVERS dialer)
• As a technical leader, managed team of three included business analyst, developer and network specialist in maintaining and upgrading network, servers, support user requests and handle the day-to-day technical issues and maintenance.
• Installed, configured and supported CUBS Application (client/server) on server and configured users desktop dat provides connection to PICK database.
• Designed backups strategy, maintenance plans, performance tuning, index planning for Microsoft SQL Server databases
• Developed Transact-SQL stored procedures, views, jobs, triggers, DTS packages for SQL Server 2000/2005.
• Implemented and Administrated Windows 2003 Active Directory network. Supported Windows XP/NT/2000/98/95 operating systems and communication services for up to 90 users.
• Implemented and maintained Exchange Server to automate reporting.
• Implemented VPN Server by using Windows 2000 advanced server. Configured VPN connection between Toronto and Montreal branch office. Helped clients’ IT team to access to Collect Com’s VPN network.
• Implemented a Network Firewall system and proxy server by using ISA Server 2006. Developed efficient firewall rules and performed regular precise firewall report and log inspection.
• Developed contingency plan including backup and disaster recovery solutions
• Maintain telephone system and supervise maintenance (NORSTAR PRI and analog system)

Confidential

Network Administrator/DBA

Responsibilities:

• Resolved problems provided technical support and system administration for Windows NT operating systems and communication services for users.
• Installed, configured and supported Windows 95/98/2000 Pro and NT 4 workstations.
• Implemented new T1 connection for company's Internet access. Installed and tested new router wif T1 link wif ISP. Migrated new link overnight. This resulted in a smooth transition to a faster connection to the Net and increased company productivity.
• Working wif the Vice President, created new Internet policy for employees abusing Internet use during company time. Developed/identified software to monitor sites and users to reduce abuse dat impacted productivity. Reduced bandwidth use from 70% to 55% during peak hours.
• Maintained and supported IIS 4.0/5.0, Exchange Server 5.5/2000 and RAS Server.
• Installed and supported SQL Server 7.0 and set up different access level for users and databases.
• Provided system security, fault tolerance system, data backup and disaster recovery solutions, which reduced company downtime losses.
• Configured and performed NT servers configuration and tuning including driver updates, patches and system tools.
• Installed and maintained Norton A.V Server to obtain and improve computer system integrity.
• Responsible of market research and the purchasing of new servers, workstations, software and other necessarily components.
• Identified operational problems and recommended solutions to senior management.

Environment: DOS6.0,Windows3.1, Windows NT, Windows 9X,Fortran90/95, Visual Basic, DBII, FoxPro, Clipper, VBScript, Visual Basic, Visual C++, MFC, ASP, JavaScript, HTML/DHTML, MS SQL Server, MS ACCESS, Visual Interdev, Lotus Notes, FrontPage, Power Builder.