JOSE ANTONIO

Ortega

786-***-**** **** NW **th Ave., Suite 12-J, Miami FL 33016 ac3mgi@r.postjobfree.com

Career Summary

Highly self motivated and goal-oriented professional, committed to pursuing a long-term career in Database Analysis implementing Microsoft SQL, SSRS and Business Intelligence. Offer a 10-year track record in Software Development (Report Print Generator- RPG AS/400), demonstrating strong analytical and problem solving skills, and ability to follow through with organization projects from inception to completion.

Projects

Platform: SQL Server Reporting Services (SSRS) –MS Data Tool and Management Studio. Developed full-cycle reports from Datasets for a large corporation. Relational database to populate Tables. Generating reports with interactive queries for graphic data representation for managerial analysis. Modification of XML files to add new Parent Code Groups.

Platform: Microsoft Business Intelligence. MS Server Data Tool and Microsoft SQL Server Management Studio. Developed a full cycle project from a schema for a large corporation. Developed Data Mart Structure using SQL Management Studio. Create relational database and populate Tables using SSIS.

Skills

Business Intelligence – Data Mining

Microsoft SQL Implementation

Prog. Analyst - RPG III/IV AS/400

SQL Reporting Service (SSRS)

SQL Integration Services(SSIS)

SQL Analysis Services(SSAS)

VB.NET

Bilingual (Fluent in English/Spanish)

RPG III/IV AS/400

MS Access ( Pivot Tables), MS Excel

Work History

Consultant (01/2017 – 05/2017) Contract awarded to Mr. Elton Rodriguez (FIU IS Department) to develop a Full Cycle Database Environment. Developed reports on predefined templates implementing BI-SSRS for a third-party client.

Echo Graphics, Miami, FL (10/2016 – Present) Adobe Photoshop

Design and business cards, brochures, postcards, banner on a specific time frame. Direct Customer Service to existing and new accounts.

Ascendo Resources (IT Recruiting Firm) Miami, FL (Term Contract) 12/2015-09/2016

Data Testing and Validation through the migration phase from Phoenix to “Xperience” Banking Software System.

(BI-SSRS) Bar Chart Data Representation for age range purchase analysis on 401K(CD products). Programming with VB.NET expressions calculating values in a text box.

(BI-SSRS) Interactive Invoice Report; invoice header and detail information of active accounts, reflecting the invoice origin and the state of the accounts. Tools: Subreports in predefined business templates, and exported to PDF format.

Echo Graphics, Miami, FL (Nov/2003 –Oct/2015) Adobe Photoshop, Adobe Illustrator/ Gerber

High-impact graphic design projects including newsletters, logos, CD covers, stationery, retail packaging, and innovating vehicle graphics for small, medium and large corporations.

Design and manufacturing of business cards, brochures, postcards, banner on a specific time frame. Direct Customer Service to actual and new accounts to expand the business.

Riegel Staffing, Inc., Marlton, NJ. Programmer Analyst - RPG III/IV AS/400 (Contract)09/2002 – 10/2003

Design strategies for program conversion from MSQuery to RPGIII (IBM AS/400)

New developments to enhance operations from regional settings to nationwide implementations

Subfiles hosting search request from end-users.

Credomatic Of Florida, Miami, FL.(Dec/2000 – Aug/2002) Programmer Analyst–RPGIV IBM AS400(Contract).

Maintenance of Credit Card Report Summaries for South America clients.

SunglassHut International, Coral Gables, FL.(06/1997 – 08/2000) Programmer Analyst-RPG III/IV IBMAS/400

Application Conversion from MSSQL to full implemented RPGIV/AS400 programs.

Conversion and implementation of new 4R4 MMS/JDA software package for testing Y2K compliance. Data Processing for sales associates bonus program in Europe

New RPG IV programs to accommodate a Global Report Distribution System.

Business Analytics.

Create and design specifications as requested by Department Managers.

Liaise with development team and Department Managers (Accounting & Sales) to document software processes effectively.

Make contributions in the development of Test Plans and Test Scripts, and also perform test executions as required.

Assembles and documents all test results.

Develop and coordinate schedules for training in new software developments.

Document process as needed.

Collect, compiles and reports results of evaluation based on departmental SOP, attendance and training data.

Education

Miami Dade College, School of Engineering & Technology (En-Tec) 2017

College Credit Certificate in Database Management–Microsoft Business Intelligence Professional-Code 66038

Miami Dade College, School of Engineering & Technology (En-Tec) Expected graduation date: 2017

A.S. in Database Management – Microsoft Business Intelligence.

Projects:

SQL Server Management Studio 2012 – Create a Data Mart.

SQL Server Data Tool - Create a Data Mart

SSIS - Populate Data Mart

SSAS – Create the cubes, Dimensions, etc

SSRS – Charts, Front-End invoice reports, Representing data on a dashboard, maps and spatial Data Types

Miami Dade College, School of Engineering & Technology (En-Tec)(2011–2014)College Certificate in Programming/Web Development.(VB.NET, E-Commerce, ASP.NET). Programmer Analyst - RPG III/IV

Miami Dade College, School of Engineering & Technology (En-Tec), Graduated with A.S. in 1997.

A.S. in Computer Information Systems Analysis - Graduated in 1997

SSRS Reports – Business Needs

Create an email directory containing all billing contacts in alphabetical order, grouped by billing city, breaking to a new page when new city appears. Report can be drilled down from the customer level to view invoices.

Implement a Parameterized Invoice-Batch Number Report, adding parameter to the Query. Selections can be made from date range and drop down City selection list.

Maintenance Report - Showing the number of each type of repair required by each type of transport to enable management to decide which type of transport to be purchased in the near future.

Graphics to establish a correlation between deliveries and number of lost packages within a specific imeframe.HR Report - To calculate the amount of overtime incurred by job titles within a specific week up to specific day(drill down technique)

HR Report – Employee Time Report (drill down) by job title, name and number, work week, dates/hours worked, hours per day worked. Summary by location and job titles hours worked.

Customer Service Report –To check the status of deliveries for a customer. Management is able to select a customer and the service history.

SQL

Triggers (AFTER DML, INSTEAD OF DML)

Stored Procedures (Parameterized)

Scalar Functions

Nested SELECT statements

Table generation from CSV(.txt files)

User Defined Table Types

Contact this candidate