Data Warehousing, Business Intelligence and Reporting Resume

SUMMARY:

Experienced Database professional with over 20 years combined experience and proficiencies in SQL Server databases (development and administration), T - SQL, Data warehouse, Data modeling, Business Intelligence development, ETL, IT Business Analysis, Scripting, Agile, SDLC, Change Management and Project Management.

TECHNICAL SKILLS:

Word, Excel, PowerPoint, Access, Outlook, Visio, Project, Planview data reporting, Test Director, Clearquest, Business Objects, Informatica, Insight Analytics, Crystal Reports, SharePoint, SQL, SDLC, VBA, Visual Basic.NET, database and reporting, Queries, HTML, CSS, JavaScript, MySQL, Business Analyst, Hardware, Software, LAN, Administrator, Server, SSAS,SSRS,SSIS, ASP.NET, Visual Studio, VBScript, BI Developers, Business Intelligence, Code, Developer, Engineer, SQL Server Analysis Services, SQL Server Integration Services, LEAN, Waterfall, SQL Server Reporting Services, ERWin. Tableau, MicroStrategy.

PROFESSIONAL EXPERIENCE:

Confidential

Data Warehousing, Business Intelligence and Reporting

Responsibilities:

MSSQL Server, Oracle, ERWin, Informatica, SSIS, SSRS, SSAS, Crystal Reports, Business Objects, Tableau, MicroStrategy, MS Office, Access, Excel VBA, ServiceNow Change Management, Planview, TestDirector, Rational Clearquest, Insight Analytics, SharePoint;

Confidential

Responsibilities:

Experienced as a Product Safety Test Engineer, evaluating and certifying consumer electronic products to UL and CE product safety standards.

Senior Database Administrator

Confidential, Century City, CA

Responsibilities:

Leveraged my skills to ensure the Bank’s Anti-Money Laundering (AML) system for Credit Cards was in compliance with government regulations as transaction types changed and/or as rules were fine-tuned.
Collaborated with Ernst & Young consultants to close previously identified gaps in the AML credit card transactions monitoring system and undertook a retroactive review of past transactions to validate compliance with new changes.
Managed the data warehouse databases as well as several banking transaction databases and ensured all were accessible and free from disruptions.
Devised structured processes to implement and document the wind-down and archiving of databases with minimal disruptions to active applications in the phased wind-down timelines set by the bank.
Updated existing IT Disaster Recovery plans and ensured compliance with established internal controls and procedures while assuring sustainability through periodic testing.
Provided technical support across multiple lines of business during Change Management implementations that ensured success of these efforts.
Supported monthly enterprise risk assessment reviews as well as routine audit and compliance investigations to ensure the bank was in compliance and to mitigate any risks.

Data Consultant III

Confidential, West Hills, CA

Responsibilities:

Identified and developed data and process efficiency paths to enable scaling to meet increased volume of mortgage loan modifications in the bank's home loan modification Program.
Designed a blueprint for automating the speedy evaluation of borrowers’ compliance with the loan program’s Trial Period Plan (TPP) requirement to show sufficient and consistent incomes to make modified monthly payments.
Performed data and comparative analysis and predictive analytics to provide data-driven insights into patterns that exists in borrower payment data.

Sr. Data Process Engineer

Confidential

Responsibilities:

Participated actively the design and implementation of a new Data Warehouse project for the company that enhanced reporting and analysis.
Identified several process gaps in IT project costing and implementation, and developed opportunities and tools to automate these processes resulting in significant saving in time and money.
Led the development of a “Rolling Planning Tool” and “Financial Impact Tool” that provided new custom reports and project tracking opportunities that enhanced project implementation timelines.
Received significant cash awards as appreciation for several of the process improvement tools I developed.
Developed dashboards with relevant metrics to support business teams with deeper analysis and valuable insights to unlock opportunities, track KPIs and drive informed business decisions.
Gathered technical requirements and participated in project design sessions on major projects.
Provided visibility on key metrics, performance, and opportunities for scale and growth in customer retention.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship