Summary |
Database expert with extensive experience developing, manipulating, testing and supporting multi-user databases. I engineer solutions and new processes while designing supporting documentation for project management and establish functional relationships between IT and business users. |
Computer skills |
- Languages and Software Oracle, SQL, PLSQL, Quickbase API, HTML, CSS, PHP, JavaScript, .NET and Visual Basic Database: Oracle EBS R-12, Microsoft SQL Server, PLSQL, Quickbase, Microsoft Access, SharePoint, Microsoft Project, Toad for Data Analysts , DB Visualizer, HP Quality Center
- Platforms: Windows, Linux, Ubuntu, OSX, Android and Chromium
|
Experience |
Software Developer/Technical Lead |
Confidential - Performed data analysis daily, providing the team with defect reports and test cases for clients.
- Created Business requirement and training documents. Conducted UAT and performed post production validation to ensure the data matches the source systems.
- Routine maintenance, isolation of problem areas, bug tracking/fixing, troubleshooting database and server problems and further development on existing web applications.
- Managed all aspects of the software development life cycle working with various business groups and developers ensuring all deadlines and milestones were met.
- Also responsible for the project scope, maintaining budget, and bridging any gaps between developers and the clients. Conducted training on the developed software and created project documentation supporting all aspects of the project.
- I worked exclusively for our Global Fortune 50 enterprise clients managing and developing cloud based software solutions. Including: Wal-Mart International, Intuit, and Merck. I aided in the development of large scale IT solutions and projects that achieved process improvement in CRM, Logistics, and other major business functions for our clients.
|
Oracle EBS System/Data Analyst |
Confidential - Responsible for the testing of ERP configuration and code migrations into new environments in Oracle.
- Involved in database conversion, data cleansing, and validation. Providing defect and bug tracking for both development and production environments to developers and business users.
- SQL and PLSQL queries in Toad for Data Analysis and Bug tracking through HP Quality Center. Ran test scripts through OBIEE and Informatica development environments. Use of SQL for data matching and mapping.
- Analyzed how the data would be consumed, distributed and determined changes to the data related processes. BI reporting on configuration changes, migration test logs and test plans.
- Participated in JAD sessions with business users, ERP process teams, and developers to brainstorm, explore and elicit the informational needs for the analytical system and to provide feedback on overall data quality and business rules. This created a close working relationship between IT and different groups of stakeholders.
- Reviewed and validated logical data models. Formatting, transforming, and consolidating of source data slated for conversion according to the specifications created by ERP process teams.
- Working with off shore conversion developers, process teams, and legacy extract developers to resolve data quality and/or design issues and generating, formatting, and distributing data validation checklists and reports, and collecting data sign off from business users and process teams.
- Strived to find inconsistencies and problem areas in the database. Gap Analysis and research was an everyday function of my role.
|
Operating Partner/Systems Administrator |
Confidential - Responsible for all web development, data analysis, data validation, website creation and technical/training documentation. Also headed the design and creation of all marketing/advertising literature and negotiation of advertising costs.
- Development and Management of a multi-company relational database. Responsible for the administration, maintenance, QA and Quality Control. Development of data quality reports and designed dashboards for management users.
- Created requirements and technical documentation. Created and recording use and test cases for all issues that I found pertinent for other users.
- Maintained communication with customers and clients to ensure service was excellent. Trained employees on customer service standards and conducted reviews based on comment cards that were mailed and emails received through service website.
- Other Responsibilities:
- Responsible for at least half of all business functions and decisions day to day. Maintained the upkeep and maintenance of all technology for the three companies. Lead the IT planning process, cost analysis and tracking of all IT spending. Planned IT initiatives based on available budget
|
Database Manager |
Confidential - Responsible for data analysis, legacy data migrations, manipulation and validation of data.
- Data Management of millions of Tenant, Building, and Service Provider contracts for Fortune 500 enterprise clients, including Bank of New York Mellon, Motorola, Boston Scientific, Intuit, NCR, Novartis and Charles Schwab.
- Data analysis and the development of web application solutions and reports for our clients. Responsible for gap analysis and database debugging daily. Use of Microsoft SharePoint for bug tracking and storing all project documents and Crystal for all reporting to go back to clients.
- Oversight of my team's professional growth, schedules, duties and department leadership meetings. I also assisted in leading these individuals into higher level positions in various departments within the company. Managing at least 7-15 projects simultaneously. Acted as liaison between IT and business users.
- Responsible for training employees, Property Managers, Engineers, and Admins on advancements in their web applications and reporting sites, while also writing technical guides and feedback surveys to distribute after training.
|