Sign in

Sql Server Data

Lake Mary, Florida, 32746, United States
November 28, 2017

Contact this candidate


**** ** ***** ******** ******, Port Saint Lucie, FL 34953

H: (817)-***-**** C: (817)-***-****


Over 16 years of Mortgage Banking Reports, Business Analyst and Operations Management Experience. More Recent Special Pharmacy experience. Experienced Business Intelligence and well versed Developer with over 10 years of Relational Database programming. SQL 2005, 2008, 2008 R2, 2012, 2014, SQL Stored Procedures, Functions, Views, T-SQL and SSRS Reporting. 5 years responsible for Data Warehousing and creating Scheduled daily, Weekly, and Monthly ETL’s across Multiple Data Servers and Database Platforms.

Manage Project Design and Intent, Database Development, Test, Build, Deploy, Maintain, Monitor, and Backup Activities, and Archiving of Data.

Includes Sharepoint, AS400 iSERIES, Teradata. MS Access, and Crystal Reports migrations.

Demonstrated Problem-Solver and Reporting Metrics using SSRS, BI using SSIS

Tracking Deliverables and Project Milestones in Sharepoint. Track Issues Logging and Time Management efforts in JIRA. Provide Documentation to Manage Reporting and BI Development Requirements Expectations. Develop Process Flows to Properly Manage Expectations, Minimize Redundancies and Improve efficiencies.


Requirements Gathering For Reporting and KPI Dashboard Metrics

Data Scrubbing and Data Warehouse Testing.

ETL Testing and Data Migration

Created Metrics Reporting for Management Service Release and Mosaic Projects. Largest Service Release of Pooled Mortgage Loans in Mortgage Banking History.

Developed Software metrics and Reporting for MHA (Making Home Affordable Act).

Successful Migration of Database Servers between companies during Acquisitions.

SSRS Metrics and Inventory Reporting for Clinical Department of Special Pharmacy and Assessment Reporting.


Experience in the Software Development Life Cycle. Waterfall and Agile Methodologies.

SQL 2005, 2008, 2008 R2, 2012, 2014. Stored Procedures, T-SQL, Views, Functions.

SSRS, SSIS (DTS Packages and Automation), SSAS (Cube Maintenance), Data Mining, QA Software Testing, JIRA, Sharepoint, AS400 iSeries, Microsoft Office, MS Access, MS Visio, MS Project.


Contractor-Disney Corp 03/2017 to 05/2017

Technical Analyst

Business Requirements Gathering For Parks and Resorts.

Engage Business and Host Meetings to Develop Business Rules for Reporting Metrics and Standards.

Develop Project Schedule and Process Flows for Visualization and expectation of Milestones.

Data Mapping and Creating Relationships between External Databases for Internal Data Migration.

Contractor-Axium Special Pharmacy (Kroger Co) 04/2016 to 12/2016

SQL Developer-BI SQL Server, SSIS, SSRS Lake Mary, FL

Develop Business Intelligence for CPR Application, Data Extracts For Specialty Pharmacy Client Aggregators, Referrals, and Shipments for Drug Manufacturers.

Develop Reporting For Operations Clinical Assessments, Forecasting and Dashboard Reporting.

Develop Documentation, Process Flows, Liaison and Consulting for Business Operations and Standardize processes for Technology and Business. Schedule FTP tasks for data imports.

Write code, Stored Procedures T-SQL, Views, Functions, DTS Packages using Business Requirements documentation and updates.

Migrated Stored Procedures, SSIS’s and dependencies onto Axium Servers and Platforms to Kroger Platform compatibilities.

Bank of America 06/2012 to 3/2016

Officer, BI SQL Server, SSAS, SSIS, SSRS Project Analyst II Stuart, FL

Create Loan Boarding Reports, Service Release Reporting, Develop Code, & Program Report Automation using SQL, SSIS, SSRS Data Management Government Portfolio Reporting GNMA, FNMA, FHLMC, VA Project Mosaic & Federal Compliance Reporting ETL/Data Warehousing, Data Governance, Data Mining Produce Forecast

Reporting For Service Releases Mortgage Portfolio. Reporting Requirements Documentation

Manage Quality Assurance, Quality Control and User Acceptance Testing.

Highly proficient in operating MS SQL Server 2012/2008 R2/2008 suite of products like SSIS, SSRS and SSAS.

Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.

Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse for developing accurate DTS packages, creating jobs and linked servers for MS SQL Server databases.

Proficient in Creating, Configuring and Optimizing MS SQL Server Integration Services (SSIS).

Internal & External Client Relationship Management.

Activity Based Costing & Cost Benefit Analysis Marketing for MHA Federal Programs.

Bank of America Tax Services 04/2009 to 05/2012

BI SQL Server, SSIS, SSRS/ Operations Project Consultant Plano, TX

Manage Non-Impound Tax Portfolio to ensure penalties are not assessed Technology Liaison for Vendor Management

Produce Forecast Reporting

Conduct Quality Assurance and User Acceptance Testing

Develop Comprehensive Cross-Functional Flowcharts and Analysis as needed Trending Analysis, OLAP & KPI

Modified Existing SSIS Packages and added more audits and alerts for optimized Error Handling.

Generated SSRS, SSAS, Report through SSIS Package using script component as per business requirement.

Involved in scheduling job using SQL Server Agent for SSIS, SSRS DTS Packages and Store Procedure as per requirement.

Created parameterized, Drill down and Drill through reports in MS SQL environment using SSRS.

Maintenance of business applications using SQL Server and Visual Studio tools.

Bank of America Portfolio Communications 08/2007 to 08/2008

Systems Analyst II / BI SQL Server, SSIS, SSRS Fort Worth, TX

Conducted Portfolio Analysis

Responsible for Year End Statements Reconciliation

Project Management

Cost Benefit Analysis

Managed Production Operations Trending and Forecasting Conducted Quality Assurance.

Involved in designing new complex mappings and workflows.

Responsible for designing Stored Procedures. Writing complex queries and Triggers for data source validations.

Countrywide Bank 01/2005 to 06/2007

Recon Trust - Business Analyst Simi Valley, CA

Conducted daily reporting for Mortgage Servicing, Default and Foreclosure

Created and ran daily, weekly, monthly and quarterly production reports

Conducted some SQL code development and DTS packages Financial Reports.

Scorecard Reporting Trending Analysis, OLAP & KPI Reporting Ad-Hoc queries Prepared Strategic Planning Presentations Software and Database Development Facilitated and led meetings

Generated Production Reports. Trending and Forecasting

Conducted Security Audits, Quality Assurance Testing and Analysis.

SOX Compliance Testing.

Responsible for developing Policies & Procedures for Compliance and Business Unit Servicing

Troubleshooting of PC Software and Applications Faster Silver-Gold Certified - Six Sigma Black Belt Equivalency.

Countrywide Title Company- Reconveyance 05/1999 to 12/2004

Team Leader / IT & Business Solutions Liaison Simi Valley, CA

Responsible for managing a mail operations team of 15 Full Time employees/20 Temp Employees.

Approved Time Cards

Completed and delivered PDPs

Managed daily operations to ensure departmental goals were met

Mentored employees

Handled executive requests and escalations

Assisted with career pathing by identifying top talent and preparing employees for next level Software Testing

Assisted with Desktop Support, BETA & UAT Testing, Drive mapping issues, and Peripheral problems

Developed code and Business Requirements for Access and SQL databases.


Completed Courses: Software Testing & Development

Los Angeles Pierce College-PACE; Simi Valley, CA

Quality Assurance

Software Development Life Cycle

Project Scheduling

Budgeting and Forecasting

SOX Compliance Standardization

FASTER Gold-Six Sigma Black Belt Equivalent

Analyst Resource University (2005)

Simi Valley, CA, 93065

Software Development Life Cycle

Process Improvement Analysis

Business Requirements Development

Functional Specifications

Data Analysis & Metrics Development

Scorecard Development

Cross-Functional Mapping & Analysis

Budgeting & Forecasting

Project Scheduling & Resource Management

Coursework in Business Communications and Management Information Systems

Managerial Statistics and Management Communication coursework

Course work in Information Technology


Bank Officer For Business Technology Compliance & Federal Compliance Standards

FASTER Gold Certified-Project Management/CPI -(Six Sigma Black Belt Equivalent)

MS SQL Server 2008 Reporting Services

MCSE Certification

Certified CA Notary Public CA- Loan Doc Signing Specialist

LANGUAGES: Bilingual English/Spanish; Fluent reading/writing Spanish


Activity Based Costing

Reporting and Automation

Develop Business Solutions

Data Mining

Data Modeling

DTS Packages SQL/T-SQL

Database Development

Data Warehousing


Financial Reports


Government Portfolio Management (VA, GNMA, FNMA, FHLMC Programs)

Contact this candidate