Database Analyst

JULIAN RODRIGUEZ

**** **** ***** ****, ******, FL 33331

954-***-**** – 954-***-**** ****************@*****.***

EXPERIENCE

HR Soft Consulting (Colombia)

Database Development Consultant (01/2009-01/2010)

• Maintained SQL Scripts, tables, views, stored procedures, and triggers in SQL Server 2005.

• Set user privileges within the database environment.

• Performed tuning on Microsoft SQL Server scripts and did unit testing to make sure the data is correct.

• Designed, developed, deployed and maintained Microsoft Access Databases, client/server architecture MS Access/SQL Server.

• Designed and Developed Standard and Ad-hoc Reports. Followed architecture standards, ER Diagrams.

• Imported and converted data from multiple data sources into SQL Server and Microsoft Access tables.

• Maintained VB scripts and technical documentation related to the databases.

WORLD FUEL SERVICES CORPORATION (WFS and MODIS IT)

Report Developer (02/2005-10/2008) World Fuel Svcs, (07/2004-02/2005) MODIS IT)

• Designed, developed, deployed and maintained Oracle BI Discoverer reports 10g (EUL, Views).

• Did unit testing and moved views, reports, functions, tables and LOVs to WinCVS for version control.

• Facilitated UAT and user training where necessary.

• Designed, developed and implemented the Fuel Management Billing application to facilitate the processing of fueling information from customers and into-plane agents.

• Analyzed, designed, developed and maintain tailored client/server applications with Microsoft Access 2003 and 2007 with VBA; Oracle Database 10g, PL/SQL and Microsoft SQL Server 2005.

• Designed and maintained SQL queries, Microsoft Access tables, forms, reports, VBA scripts and macros.

• Assisted in the data conversion, followed migration standards, conducted quality assurance over programs before migration to production.

• Adhered to SOX guidelines or internal controls for documentation, deployment and testing.

• Interacted with users and BAs, created and updated existing programs and documentation as required.

• Develop database applications and automated data processes to gather data from multiple data sources.

SOUTH FLORIDA COURIER SYSTEMS

IT Manager – Software Developer (07/2001 - 06/2004)

• Designed, developed and implemented the Billing Application for a parcel and document shipment system. Application handles scheduled daily stops, regular deliveries, rushes and cargo. It also automatically sends dunning letters to delinquent customers and handles collections.

• Analyzed customer requirements and workflow to design and implement policies and procedures.

• Analyzed, designed and developed new tailored client/server applications using MS Access 2003 with VBA and Microsoft SQL Server 2000, full Software Development Life Cycle (SDLC).

• Created and maintained statistical reports with graphics to check the customer agents’ performance by using several indexes (pick -ups, complaints, and follow-ups).

• Developed, packaged and distributed of a MS Access application to customers for slips processing.

• Created and maintained database structures, such as tables, views, diagrams, users and roles.

• Administrated of user accounts on Windows 2000, SQL Server and Microsoft Access databases.

DHL WORLDWIDE EXPRESS

Software Analyst (08/1997 - 05/2001)

• Designed and developed applications with Visual Basic, SQL Server, Microsoft Access and VBA. Granted access to users on SQL Server and Windows NT. Designed database objects and ER models.

• Designed and developed Crystal Reports to meet client needs.

• Administrated emails, user accounts and printing spool on HP-UX and developed UNIX shell scripts.

• Documented policies, procedures, user and programmer manuals.

• Performed periodic software upgrades, updates, backups and security patches and services packs.

• Created trouble tickets and escalated them appropriately.

• Trouble-shoot, analyzed and created solutions for the International Americas region on customer applications through email and/or telephone bilingual support in English and Spanish.

• Tracked issues, found the solution, did upgrades and training.

EDUCATION

UNIVERSIDAD CATOLICA DE COLOMBIA (BOGOTA, COLOMBIA)

• Bachelor's Degree in Computer Science Engineering, July/2000

SEMINARS AND TRAININGS

MICROSOFT CORPORATION

• Visual Studio 2010 & Team Foundation Server 2010, Microsoft, Ft. Lauderdale, FL, Feb 2010

• SSIS and Best Practices with Brian Knight – DeVry University, Miramar, FL, Jan 2010

• Office 2010 Preview – Microsoft Access 2010 New Features, New Horizons, Plantation, FL, Jan 2010

• The MSDN Tiki Hut - Expression Blend 3.0 and Silverlight 4, Fort Lauderdale, FL, Dec 2009

• Visual Studio 2010 Overview at New Horizons, Plantation, FL, Nov 2009

• The New Efficiency Event - Windows 7 and Windows 2008 R2, Ft. Lauderdale, FL, Sep 2009

• Microsoft Across America Launch Event - Windows Vista and Office 2007, Ft. Lauderdale, FL, Feb 2007

• Overview of SQL Server 2005 and Visual Studio 2005, Miami FL, May 2004

• Office 2003 System and Visual Studio Tools, Davie FL, Oct 2003

• Windows Server 2003 and Visual Studio .NET 2003, Davie FL, May 2003

• Office 2003 Preview, Hollywood FL, Apr 2003

ORACLE CORPORATION

• Oracle Database 10g Best Practices Upgrade Workshop, Hollywood FL, Feb 2006

SKILLS:

RDBMS: SQL Server 2005/2000, Microsoft Access 2007, 2003, 2002, 2000, Oracle Database 10g and 9i.

ERP: Oracle E-Business Suite Applications 11i (AR, AP, OM, PO, GL and HRMS modules)

Development: Oracle SQL Plus, Oracle PL/SQL, Oracle Business Intelligence Discoverer 10g, Toad, SQL Navigator, Oracle SQL Developer, DML, DDL, Microsoft Access 2007 and MS Excel 2007 (VBA), MS Access 2003 Developer Extensions (MOD), Visual Basic, VB.NET, source code control systems (WinCVS, PCVS), Issue Tracking and Helpdesk Software (Heat Ticket, JIRA, Bugzilla), Sharepoint Services, Crystal Reports, ODBC, ADO, DAO, HTML, ActiveX, VBScript, XML, UNIX scripts (ksh, csh, bsh, awk and CRON), VI editor.

OS: Windows 7, Windows Vista, Windows XP Pro, 2003, 2000, NT, ME, 9x, and UNIX (HP-UX, SCO, AIX, LINUX).

WEB: Internet Explorer, Mozilla Firefox, Outlook, MS FrontPage, IIS.

Others: Microsoft Project, Microsoft Visio, Erwin, Remote Desktop Connection, FileZilla FTP, Telnet, DHCP, Adobe Photoshop CS4, Adobe Dreamweaver CS4, Corel Draw X3.

• Ability to translate business needs into data analysis and reporting solutions.

• Strong Relational database design and development.

• Able to work in a team and/or individual environment.

• Capable of handling multiple tasks simultaneously and prioritize.

• Strong analytic, problem solving and collaborative.

• Bilingual English/Spanish oral and written.

• Customer service, goal and detail oriented.

• Ability for quickly assimilate and dominate new programs and processes.

REFERENCES

Upon request

Contact this candidate