Mary E Flores
*************@*****.***
SUMMARY
I have a strong working knowledge of database design and functionality with the ability to understand data relationships. I am highly motivated and eager to learn. I am extremely reliable and dependable with the ability to adapt to new situations with ease, and can work well independently and in a team environment. I am able to work with peers or in training peers to maximize productivity and able to work remotely and effectively while training or learning a new role.
EXPERIENCE
Dell Technologies - Software Dev Advisor, Enterprise Business Intelligence 2009 - 2016
Researched production ETL processes, developing and deploying the resolutions.
Worked with business teams to deploy critical production code in a timely manner.
Led code reviews to verify that it met production standards
Dell Technologies- Supply Chain Senior Analyst – Project Manager 2007 - 2009
Gathered requirements from business partners for reporting needs.
Created Business Requirements Document (BRD)
Created end to end reporting solutions.
Dell Technologies- Metrics and Reporting Analyst 2006 – 2007
Created custom application for managers and senior techs to audit customer calls.
Developed metric reporting on the Audit Tool which earned a BPI yellow belt IT Award.
Proficient in: Visual Studios, C#, MSSQL
DEVELOPMENT PROJECTS
Audit Tool – C#, ASP.NET, MSSQL
C#, .NET Project that gathered data on the call and provided custom reports
Created custom C# reports on MSSQL Server Database
Microsoft Server Migrations – MSSQL Server 2008 to 2012
Redesigned the VB code to solve compilation errors
Optimize existing code to improve server performance
Royalty Reporting Rewrite – Oracle(PL/SQL), Informatica, MSSQL
Identified the existing issues in the PL/SQL procedures
Analyzing the root cause of the issues and solution planning for the rewrite
Redesigned the PL/SQL procedures to solve data errors
Optimize existing code to improve server performance
CERTIFICATION & ACHIEVEMENTS
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Systems Engineer (2000)
Business Process Improvement (Yellow Belt)
Multiple Silver, Bronze and On the Spot awards at Dell
2 Customer Top Performer Awards at Dell
TECHNICAL SKILLS
Business Intelligence Tools
BusinessObjects, MSRS, Cognos, MSAS, SharePoint
ETL
Informatica, SSIS, Abinitio
Databases
Oracle, Microsoft SQL Server and Teradata
Operating Systems
Windows 10, Windows8, Windows7, WindowsXP
Languages
SQL, C#, ASP.net
Microsoft Office Products
Word, Excel, Power Point, Publisher, OneNote
Other Tools
Control-M, GoldenGate ER, Notepad ++, Compare IT, Toad, Citrix, SQL Assistant, Nexus