SUMMARY:

• A highly motivated, organized and detail oriented professional with an analytical mindset and the versatility to resolve multifaceted issues despite the challenges of changing priorities, imminent deadlines and agendas.
• A professional characterized throughout employment as Team - player and self-starter; an individual committed to delivering solutions and possessing the ability to apply new IT technologies that translate business needs into a practical reality.
• A professional with works ethics that honors integrity, respect, relationships, performance, innovation and excellence to enhance company distinction.
• Proficient in T-SQL - PL SQL - MDX - DMX- C# -VB.net - ADO.net, VBA and extensive knowledge of data manipulation, data analysis, database modeling, data architecture, data retrieval, BI reporting, data visualization, database design from multiple OLTP and OLAP databases using: SQL Server Management studio 2016 - 2012 - 2008 R2 (SSMS), SQL Server Integration Services 2014 - 2012 - 2008 (SSIS), SQL Server Reporting Services 2012 - 2008 (SSRS), Visual Studio 2015 - 2012 - 2010 - 2008 (BIDS), Data tools, Teradata 15.10, Oracle 13C and software programs.
• Skilled and qualified, professional with more than 13 years’ experience as Data Architect - Database Administrator - Database Developer using Information Technology tools such as:
• Microsoft SQL Server Management Studio 2016- 2014 - 2012 - 2008 R2 (SSMS) Enterprise Edition
• Microsoft SQL Server Integration Services 2016-2012 - 2008 (SSIS)
• Microsoft SQL Server Reporting Services 2016-2012 - 2008 -2005 (SSRS) and Report Builder 3.0
• Microsoft SQL Server Analysis Services
• SQL Server Data tools 2012
• ORACLE 13C-11C
• Oracle SQL Developer Data Modeler 4.1 Oracle SQL Developer
• Visual Studio 2015 - 2012 - 2010 - 2008 - 2005 (BIDS) Professional Edition
• SQL Assistant Teradata Version 15.10
• Microsoft Visual Basic 2010 Express Edition
• Microsoft Access 2013- 2010 - 2007 - 2003
• IBM DB2
• MS DOS - Windows 7 Enterprise - Power Shell (Scripting) - Windows 8.1
• Programming Languages: T-SQL,MDX, DMX, SQL, XML,C#, VB.net, VBA, ADO.Net, PL/SQL
• Microsoft Excel - Power Pivot - Minitab
• BI Pyramid Analytical (Business Intelligence Tool), CPRS, VistA, BioXL, BioPoint
• Microsoft SharePoint Designer 2013 - 2010 - 2007 (Administration - Maintenance - Development)
• Visio 2013 (ER Diagrams)
• Microsoft Outlook - Microsoft Word - Microsoft PowerPoint - Note pad - Adobe Reader-WinSCP
• Great professional with organizational office skills with knowledge in the finance and accounting industries.
• Well balanced attitude with the ability to learn in a fast pace-environment new IT Software Technologies.
• The ability to effectively prioritize tasks and job assignments to balance customer needs with company goals.
• Experience in project management methodologies, including the ability to estimate, plan, manage, and communicate activities/deliverables of a mid-size project plan (i.e., a plan that affects a single system or product family and uses multiple resources).
• Effectively communicates with all levels of technical and non-technical personnel.
• Exceptional customer service, support and training to internal and external customers.
• Effective communication and team skills with an ability to cooperate present to and participate with peers/team members.

WORK EXPERIENCE:

Business Intelligence Data Architect

Confidential, Lake Mary, FL

Responsibilities:

• Developed, created and designed entity relationship (ER), database modeling, star schemas and snowflake schemas using Kimball Methodology to create the Full Call Stats Data Warehouse OLAP Database project. During the phase of modeling and design, we defined the granularity of the data and created the business matrix.
• Created, designed and developed many types of Dimensions such as type 0, 1, 2 with attributes such as: Location, Sites, Centers, Regions, Cities, VDNs, Split, Skills, Call Types, Job Function, Sub-Types, Types of collections and Fact Tables with measurements to counts for employee’s call details and dollars.
• The project involved the extraction, transformation and loading of multiple data sources into SQL Server 2016 Data warehouse and Teradata environments; the extraction sources are: SQL Server 2016, SQL Server 2012, Teradata Ver15.10, Oracle 12c, Flat Files, CSV Files, Excel Files, and Files from FTP sites. The ETL tools used for the project are SQL Server Integration Services (SSIS), Visual Studio 2014-2012-2010, SQL Server Management Studio, Teradata SQL Assistant and Oracle SQL Developer. Programming Languages used for development were T-SQL, PLSQL, C#, VB.net.
• Transforming and loading data (ETL) using Visual Studio 2012 and SSIS involved the use of: Data Flow Task, Execute SQL Task, Containers, control flow, data flow, use of variables, timers, constraints, use of multiple connection managers, cache transform, data conversion, derived columns, lookup, fuzzy look up, merge join, CDC Splitter, Parameters and expressions.
• Created, designed, developed, deployed, tested and scheduled more than 97 SSIS packages into SQL Server 2012 using the project model (environment variables), MSDB package model and deployed to Integration Services Catalogs. During the deployment of integration services packages Jobs were created and scheduled on daily basis using the Job Activity monitor. The SSIS packages deployment also were done to multiple production and development SQL Servers 2016 and SQL Server 2012. Some Jobs were scheduled to export and load data into Teradata Data Warehouse Ver15.10.
• While developing Data Warehouse OLAP database (Online Analytical Processing database) and staging database the following objects were created, implemented and developed: Tables, Views, Database Diagrams, Primary Keys, Surrogates Keys, Foreign Keys, Composites Keys, clustered and non-clustered indexes, constraints, Schemas, CTE, specified data types, Functions and Triggers. Those were created in order to improve database performance and optimization. For the above we also applied client statistics on queries and used the Database Engine Tuning Advisor in SQL Server Management Studio.
• Provide Database administration, Database Maintenance and Database security on servers by adding, altering, creating New Logins, assigned Server roles, add credentials for proxy accounts and provide access users to database objects and servers. Part of Database Administration included on call monitoring on holidays and weekends. Also includes troubleshoot and fix of SQL Server Integration Packages and SSIDB projects.
• Team-up, collaborate, coordinated and communicated with Financial Analysts, Financial Advisors, Business Managers, Accountants, Statisticians and other team members in order to gathered information for the construction of the Call Stats-LiveVox project and reporting. Team-work included the metadata development, data types, formulas verifications, financial formulas in order to provide accuracy of the data. Data Standardization among departments was an excellent effort and communication.
• Provide Customer Service Support to front-end users, analyst and business users by email, person to person, phone or email about the data validation of finance reporting in order to make sure to match the front-end applications, Operational data sources (ODS), flat files, Oracle databases, SQL Server databases, Teradata databases and Excel files.
• Developed, designed and implemented Error Handling process that consisted on SSIS packages that re-process errors of data back into Fact Tables; part of the error handling process consists on sending email alerts with attachments to business users, analysts and managers of the inconsistence of the data; later to be corrected for them; SQL Server Reporting Server have subscriptions SSRS reports that executes on daily basis. After End-users corrected the data, they send us a confirmation of data correction and the following SQL Server job scheduled time will re-process the data.
• Provide the following weekly training and mentoring Junior Developers and SQL Developers on Database Design, Database Modeling, Entity relationship(ER), Data Architecture, OLAP Concepts, OLTP Concepts, Data Warehouse principles, Star Schemas and Snowflake schemas.
• Ability to negotiate complex processes and issues with others. Contributes to the development, documentation and implementation of database standards or guidelines. Assigned to the most highly visible, sensitive and critical systems.
• Works with capacity planning, operations, application developers and other TSG teams on database performance and access issues.
• Database software installation, upgrade/patching, infrastructure management, and creation and support of application databases.
• Assists Jr. SQL developers on the development and implementation process for estimating work efforts, establishing target dates and communicating work status for projects.
• Provide communication on issues or complex information to a wide audience based on knowledge of as well as a strong understanding of interface points between departments within TSG and application teams.
• Assists in the development and implementation process for updating input mechanisms to support new products and enhancements.
• Personal commitment to stay current with latest technology concepts.
• Participates in resolution of database problems within appropriate timeframes and identifies and resolves less clearly defined problems using established procedures and/or protocols as guidelines.
• Participated as member of the database team in strategic planning and direction. Recommended and assisted in the selection, evaluation and implementation of new database technologies and software tools to assist in maintaining the database environment. Develops, documents and implements; standards, guidelines, direction and education on database process/procedures for application teams as well as database staff. Assigned to the most highly visible, sensitive and critical systems.
• Provided On-demand, BI Reports, statistical reports, status reports, forecast reports, to resource managers in a timely manner using SQL Server Data Tools.
• Created and modified the Standard Operating Procedures (SOP) for Data Warehouse Call Stats Project (OLAP)

Program Analyst

Confidential, Orlando, FL

Responsibilities:

• Re-design implemented and modified, PATS Microsoft Access database (Patient Advocacy Tracking System) Back-end and Front End. The PATS Database is a Customer Service database that keeps tracks the records and process of VA patient’s claims. The goal is to increase the excellence of customer service to VA patients. Migrated and re-designed PATS Microsoft Database to MS SQL Server 2012 (Back-end). 10 tables were migrated along with the recreation of views, triggers, stored procedures, and queries. Primary Keys, constraints and foreign Keys were built at the back end to support the front-end layer.
• 15 Reports were created and designed using SSRS, Report Builder and MS Access to meet Customer Service Department business needs some of the reporting involved the: Annual, Quarterly, Monthly counts of Patient’s encounters from many Veterans Affairs facilities such as: Lake Nona Campus, Lake Baldwin, Daytona, Viera. Other types of reports include the tracking of claims and encounters by Issue Type and Issue Code.
• Received on line training in the following BI tools: Pyramid Analytical (BI Office); learned how to create a Dashboard using Bio Point Dashboard and also how to create reports from Cubes using Bio XL. Reports were created from SSAS (SQL Server Analysis Services) Cubes using BI Office and with the technique of slice and dice then to be presented and published the reports in a SharePoint environment. Embedded and published reports on a Share Point to support VA internal customers.
• Created and developed reporting using MS Excel and Power Pivot (Add on BI tool) were able to link and extract data from cubes and published the reports on to Share Point site to support business decisions. Search and look for Patients records using VistA system and CPRS system to provide and meet standards.
• Received Customer Service Training in Patient Advocate Department on how to process patient’s claims and take the appropriate path to address the issue. The systems tools that we used to meet business needs were: CPRS, Vista and PATS Database. Conduct case entries into the PATS database.
• CPRS search patient records and generate application reports.
• Created, designed and developed the PATS Database and EER diagram Using Visio 2013 for database model and use for SQL Server Management Studio 2012 for the physical model.

Business Intelligence / ETL SQL Lead Developer

Confidential, Tampa, FL

Responsibilities:

• Designed, developed, deployed and maintained SQL Server Integration Services project (with multiple packages). The project is located on Production server and using ETL tool (SSIS 2008R2 - SQL Server Data tools) and C# Language; we extract the data from linked servers, flat files, excel files, FTP and thru the use of control flow and data flow (Pipeline); we transformed the data into desired format for then to be load into the staging databases and data warehouse. Some of the tasks and transformation includes: File system task, Data Flow Task, Execute SQL task, FTP Task, Sequence container, Expression task, For each loop container, Aggregate, Data conversion, Derived column, Copy column, Data conversion, Merge join, use of Variables.
• The administration and maintenance of SSIS Packages includes: administration of SQL Server Jobs by monitoring and setting up steps, schedules and alerts to be run on a daily and weekly basis.
• Created, developed, modified and maintained MS SQL Server 2008 R2 databases that are located on staging server; these databases are connected directly (linked) to production server. As a BI SQL Lead Developer my Daily, weekly and monthly tasks are: using Data Definition Language (DDL) and Data Manipulation Language (DML) statements to create and modify database objects in the database. We use the following T-SQL statements to create-alter-drop-truncate: databases, tables, local temporary tables, global temporary tables, views, triggers, functions, stored procedures, check constraints, primary key constraints, foreign keys constraints, unique constraints, table relationships, common table expressions (CTE), indexes, fields, data types, default constraints, computed columns, table valued functions, scalar valued functions.
• Manage databases statistics to identify integrity issues and databases stability by creating queries that include: actual execution plan, client statistics, estimated execution plan, DBCC CHECHDB.
• Created, developed, maintained, subscribed and deployed 45 Business Intelligence reports, utilization reports, on-demand Reports by using: Business Intelligence Development Studio (BIDS), SQL Server Data Tools and SQL Server Reporting Services (SSRS) that support about 25 end-users, managers and financial analysts. These Business Intelligence Reports gets their data from 47 Microsoft SQL Server 2008 r2 relational databases that live in a production server and thru the use of data sources and data sets (T-SQL, Views, and Stored procedures) are linked to the SQL Server back-end. All report server projects are deployed on a Microsoft Report Server were I conduct their daily maintenance for them to be link to Confidential Inc. SharePoint Website. (SharePoint 2013)
• Conducts SharePoint Administration and maintenance (SharePoint 2013) by creating folders, dashboards, publishing BI Reports, provide end-users administration, login, permissions and security, creates tab bar and menu bars.
• Provides IT training and lead juniors and intern developers; helping them how to optimize queries using SSMS 2012 - 2008R2 and also how to fix SQL Server Integration Services packages.
• Provides training to 7 Project Managers and Data Analysts on how to build Business Intelligence reports forecast reports and Ad-hoc reports using SQL Server Reporting Services, Visual Studio and BIDS.
• Support Finance and Accounting departments by providing BI Reporting and accurate information to Finance Analyst and Staff Accounts.
• Provides and disseminates status reports (written and/or verbal) that are detailed to the tasks and difficulties encountered - enables managers to initiate escalation if necessary and assess areas where changes or additional support may be warranted
• Provides implementation and maintenance of the physical OLTP databases on two servers.
• Follows and meets project timelines and deadlines.
• Enforces database standards and follows up on inconsistencies.
• Understands and applies database concepts such as database definitions, parameters, database component placement, reorganization, access methods and security definitions.
• Provides 24/7 support of production Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2 database environments.
• Performed production database activities to ensure error free maintenance.
• Participates in recovery of databases and assists with disaster recovery testing and documentation.
• Performs routine reviews of databases and systems to ensure acceptable levels of performance.
• Reports problem performance areas and recommendations for improvement.

Database Administrator

Confidential, Maitland, FL

Responsibilities:

• Praise for exceptional achievement on recent creation and deployment of the two new Microsoft SQL Server 2008 R2 relational databases which automated two manual process that were labor intensive and for collaborating with the corporate team on creating and deploying Business Intelligence Reports using Microsoft SQL Server Reporting Services (SSRS) . The new deployment of these Microsoft SQL Server Databases saves Confidential more than 7,000 man-hours and $ 450,000 USD annually by speeding the data process and presenting the information in real-time (Ad-hoc reporting).
• Created, developed, maintained, subscribed and deployed more than 250 Ad-hoc reports, Business Intelligence forecast reports, utilization reports, on-demand Reports by using: Business Intelligence Development Studio (BIDS), SQL Server Data Tools and SQL Server Reporting Services (SSRS) that support about 350 end-users, managers, financial analysts and executive personnel in the organization. These Business Intelligence Reports gets their data from twelve Microsoft SQL Server 2008 r2 relational databases that live in a production server and thru the use of data sources and data sets are linked to the SQL Server back-end. Generally all report server projects are deployed on a Microsoft Report Server were I conduct their daily maintenance for them to be link to an Confidential Corporate SharePoint Website. The creation Of Online Analytical Processing Reports that extracts information from OLAP Database (Cube-Plainview) saves Confidential more than $ 700,000 USD annually by helping project managers to manage and track their resources logged time and expenses.
• During a daily, weekly and monthly Report Server administration and maintenance the tasks were: subscribe reports to end -users, add -modify ODBC string connections on reports, test, modify-tuning the T-SQL queries, alter- modify-delete Business Intelligence reports, create-build-deploy report server projects, create matrix reports, create dashboards, add-modify calculated fields on Ad-hoc reports, add sub-reports on BI Reports, charts reports, list reports, predictive analytics reports, modifying parameters on BI reports, adding meters to BI reports, modify gauges on reports, add-modify indicators on BI reports, add-create-modify VBA functions (Visual Basic for Applications) on BI reports, add- modify MDX expressions (Multi-dimensional expressions)on BI reports, add- modify filters on BI reports, add-modify row groups, columns groups, parent groups child groups on BI reports, modify stored procedures on BI reports and create Pivot-tables, provide training to internal and external customers, end-users, financial analyst and resource managers on how to use-read forecast BI reports using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, BIDS, Query designer and Microsoft Excel.
• Provided On-demand, BI Reports, statistical reports, status reports, forecast reports, to managers in a timely manner using SQL Server Data Tools.
• Created, designed, modeled and modified the logical and physical architecture of Purchase Order Hardware relational database in MS SQL Server 2008 R2 using SQL Server Management Studio (SSMS). After completion 25 end-users were able to process the data quicker than before, saving the organization $230,000 USD. Annually.
• Created, designed, modeled and modified the logical and physical of FORMS Maintenance relational SQL database using SQL Server Management Studio (SSMS). After completion 15 end-users were able to access and process the data faster than before, database performance increase. Confidential saves $275,000 USD. Annually.
• Duties performed as Database Administrator were: Creating and implementing database objects, monitoring SQL server performance, maintaining and securing MS SQL Server databases, installing and configuring SQL Server 2008 and SQL Server 2012 and support data consumers by using Microsoft technologies such as: SQL Server Management Studio 2012 developer edition (SSMS), SQL Server Management Studio 2008 R2 developer edition (SSMS), SQL Server Management Studio 2005 developer edition (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power shell ISE, MS-DOS, SharePoint 2010, Visual Studio 2008, Visual Studio 2010 premium edition and Microsoft Office tools (MS Access 2010, MS Excel, MS Word, Visio and MS Power Point). Monitored, Implemented and maintained 12 Microsoft SQL Server databases that are located on production servers.
• As a Database Administrator my Daily, weekly and monthly tasks were: using Data Definition Language (DDL) statements to create and modify database objects in the database. We use the following T-SQL statements to create-alter-drop-truncate: databases, tables, local temporary tables, global temporary tables, views, triggers, functions, stored procedures, check constraints, primary key constraints, foreign keys constraints, unique constraints, table relationships, common table expressions (CTE), indexes, fields, data types, default constraints, computed columns, table valued functions, scalar valued functions.
• Moreover with the use of Data Manipulation Language (DML) .Used the following T-SQL statements: select, insert, update, delete, merge into, also these T-SQL queries are combined with:, joins, outer joins, left outer joins, right outer join, cross join composite joins, inner joins, aggregate functions in queries, calculated columns (alias), union, union all, intersect queries, except, sub-queries to retrieve, store, modify, delete, insert and update data in the databases.
• Managed databases statistics to identify integrity issues and databases stability by creating queries that include: actual execution plan, client statistics, estimated execution plan, DBCC CHECHDB.
• Provided SQL Server database security by using Data Control Language (DCL- grant, revoke, add new login ) to created roles, created users, granted permissions, add logins, drop logins, check expiration passwords, create windows authentication, create mixed mode authentication, SQL Server authentication, mapped database users and referential integrity on 12 MS SQL Server Databases.
• Migrated, moved, implemented and re-designed (7) MS SQL databases that were located on a remote server to our production server .
• Implemented, backup/recovery procedures to protect integrity of data in SQL Server database environment.
• Created, designed, developed, deployed and implemented four VB.net applications (Visual Basic): Request for Professional Services (RPS), Forms Maintenance, PO Hardware and FRC.
• Provided and trained 45 end-users and how to operate VB.net applications.
• Created, designed, implemented and maintain more than 25 SQL Server Integration Services Packages that loads 12 MS SQL Server databases (OLTP) into our production servers.
• Created, performed and implemented tasks such as: Import, Export, BCP, Bulk Insert, Copy, Import-Export Wizard, Data flow task, Execute SQL task, create common task, variables on tasks, script task, common transformations, Data viewer, transfer, Data Sources, data transformation, variables, expressions, change data types, joining data, merge data and package deployment. Extract, transform, load data and files such as: xls, mdb, OLE DB source, ODBC Source, flat files, mdf, raw file source, ADO.Net sources, CSV using SQL Server Integration Services (SSIS) and Visual Studio 2010 into MS SQL Server databases.
• Other tasks as a Database Administrator: Assisted application groups with design development that meet current and future business requirements.
• Provided database support services to application teams and Technology Services Group (TSG) operations teams including the Network Operations Center.
• Advised and recommend the director of business intelligence on support reporting software and projects.
• Met commitments and provided excellent customer service at all times with internal and external clients.
• Participated in logical design process of strategic projects and responsible for the physical design/implementation SQL Server Databases, MS Access databases and VB.net applications.
• Provided, specific direction on infrastructure design to support applications.
• Created database objectives following established standards and processes employed by database team.
• As primary Database Administrator, provides on call support as needed for on-call issues with SQL database environments and provides follow up and permanent resolution for reoccurring issues.
• Provided support and maintenance of VB.net applications.

Database Analyst -Developer

Confidential, Fort Bragg, NC

Responsibilities:

• As a Database Analyst, my daily duties were the management, implementation and administration of MS SQL Server database and MS Access database, these duties involved events such as: alter, add, drop, update, insert, delete, select, import, export, group, and order records from the databases, also involved the modification of: tables, views, queries, sub-queries, constraints, joins, keys and indexes by using SQL Server management studio, SQL, T-SQL, VBA and GUI Tools. After the information was collected and analyzed we exported it into a MS Excel workbook, Crystal Reports and MS Word, where this information was reorganized in order to be presented in a business method. When working with MS Excel workbook, we were exposed to the creation of: pivot tables, macros, charts, graphs, filters, sorts, validations, reports and statistics formulas. Then the workbooks were exporting into MS Power Point for better presentation and later on to be display in conference meetings. Also one of my duties was to suggest and assist superior officers and how to maximize the use of information.
• Team-up, worked and supported Database Administrators by implementing, configuring, copying, backing up, restoring, moving and maintaining databases that were installed in local server.
• Lead, prepared and conducted classes to groups of 25 students. The training includes some Microsoft software training and visual software such as: MS Access, MS Excel, MS Power point, Visio, MS DOS and Defense Finance and Accounting System
• Created, designed and implemented a MS Access Training Database for the Confidential, which stores, manage, and maintain Confidential Soldiers’ personal training records of more than 540 Confidential soldiers that work in the company.
• The development, implementation and design of the Confidential Soldiers’ Training Records Database involved the creation and modification of database objects such as: Tables, fields, forms, views, constraints, relationships, primary keys, foreign keys, unique keys, clustered and non-clustered indexes, UDT by using Data Definition Language (DDL), SQL, and GUI tools. More tasks involved the use of Data Manipulation Language (DML) and queries like: Select statements, update rows, insert rows and delete rows. Also we were exposed to a Data Control Language (DCL) by granting permissions and roles to users.
• When database was completed and running on local server, it was able to stores information about Soldiers’ weapons certifications, heavy equipment licenses, pre-deployment training, schools records, physical fitness test, safety training and events. The records were entered, updated, deleted on daily basis into the database by using forms, and then these records were extracted with views using SQL and GUI Tools. After those records were extracted, we exported, altered and modified into a MS Excel workbooks, Crystal Reports and MS Power point presentations to be displayed to a Base Commander.
• This Database saves more than 14,000 man-hours annually, by speeding the process and presenting the information in a real-time. The result of this database saves the Confidential $700,000 annually and ends with recognition and a commendation medal for “the job well done”.

Junior Database Analyst

Confidential

Responsibilities:

• Created, Designed and Implemented a MS Access Database that storage the information of personnel that access to 270 Confidential ’s Ammunition Bunkers. This database stores the records of 250 local nationals, technicians, inspectors and personnel who have the access to enter to the ammunition bunkers in daily basis and during the weekends. The development of this database helped the Confidential to save 5,000 man-hours annually by speeding the process of registering the keys in a real time and saved $500,000. After, completion of my contract in this base over Germany was recognized with a commendation medal for an excellent job.
• Trained, guided and supported 75 US Soldiers by conducting Database classes in Microsoft Access on how to input, update, insert, delete, register information, extract, prepare reports, import, export data and how to use Key Control Log Database.