Senior Database Architect Resume
SUMMARY:
Senior Database Modeler with over 20 years of experience designing and implementing technology solutions. Able to lead projects with on and/or offshore resources and come in on time and on budget. Extensive experience moving from legacy systems to newer technologies. Able to manage across functional areas, seek common ground when there are differences, and get all internal and external parties to focus and execute on the tasks required to complete the project.
TECHNICAL SKILLS:
Databases: Oracle 11g / SQL Server 2014 / Redshift
Data Modeling Tools: Aqua Data Studio / ERWIN / TOAD
ETL Tools: SSIS / Data Stage
Analytics: SPSS
Programming Languages: Java
WORK EXPERIENCE:
Senior Database Architect
Confidential
Responsibilities:
- Worked with external vendors and the finance team to provide subject matter expertise and data modeling solutions for the financial forecasting software we now use to forecast our annual sales. The software is an SPSS model deployed on a C&DS server and integrates with TM1.
- Was the main contact for the ETL component and data funding of our Salesforce implementation.
- Worked with senior executives and external vendors to get data from our Mainframe to the Salesforce database.
- Lead the technical development for the transition from the legacy DB2 data warehouse to the new Oracle platform.
- Implemented data governance, ETL auditing as well as naming and coding standards for the new processes where previously none had existed.
- Designed the OLTP database, wrote the stored procedures for, and contributed to the front end coding of two of the main point of sale web sites.
- Databases were Oracle with the Java front end deployed on Apache/Tomcat
Managing Member
Confidential, Columbus, OH
Responsibilities:
- Managing member of 3 Real Estate Rental and Rehab companies simultaneously.
- Secured the financing, labor and project managed multiple housing rehab projects as well as maintained a portfolio of up to 28 rental units.
- Coordinated all tenant screening and leasing as well as all maintenance for the properties.
- These companies were run in congruence with my existing job at Safelite.
Skills: Project Management, Financial Modeling, Hiring and Personnel, Vendor Relations
Technical Manager
Confidential, Wilton, CT
Responsibilities:
- Managed the development of the critical sign up pages for the market research firm Confidential .
- Dealt with both local and offshore developers.
- Also did some database design.
Skills: Project Management, Project/team leadership
IT Consultant
Confidential, Columbus, OH
Responsibilities:
- Managed a full life cycle project which allowed the company to auto - provision its circuits, saving millions of dollars a year in costs and improving the 'turn-up' time on a T1 line by 7-10 days.
- The Java application used a 4-tier architecture with Oracle 8.1.5 as the database.
- This project was considered one of the most important company projects at the time.
- Worked with a team of 4 consultants to analyze and create a set of business and software requirements for the State's tax auditing software packages.
Skills: Java
Area Manager
Confidential, Philadelphia, PA
Responsibilities:
- Responsible for the entire US division of 4 offices and 100 employees.
- Revived the area from 4 consecutive years of financial and operational under performance.
- Doubled year over year sales.
- Took over an underperforming office with 2 managers and 12 staff.
- Increased office staff to 40 and reached new highs in productivity
- Realized an increase in revenues of 50% in the busiest month of the year while maintaining excellent customer relations.
District Manager
Confidential
Responsibilities:
- Stabilized the office and increased morale through and positive feedback.
- Increased office profit 600% in 6 months.
- Trained inventory clerks and new managers on proprietary software - both handheld and laptop.
- Conducted computerized inventory counts for clients.
