Sr. Database Engineer Resume Profile
2.00/5 (Submit Your Rating)
Skills
- Proficient in SQL,PL/SQL, RDBMS, Stored Procedures, Star and Snowflake Schemas
- Accomplished in developing Data warehousing, ETL solutions, Business Intelligence reports
- 10 years' experience with SQL server
- 5 years' experience with Oracle
- Familiar with C , MS Access, VB, and ASP pages VBScript jScript
- Excellence in analysis and problem solving
- Talented in communication, both verbal and written
- Able t bridge the gap between tech speak and the layman terms
- Comfortable speaking both over the phone and t an in-person crowd
- Clear, engaging and entertaining during client presentations
Experience
CONFIDENTAIL
Title: Sr. Database Engineer
- Primary Role: Develop ETL extract, transform, and load solutions
- Creating data warehouses and cubes
- Producing automated analytical business intelligence reports
- Involving accepting data feeds from numerous 3rd party vendors per client as well as interdepartmental data
- Producing Data extracts out t 3rd party vendors t maintain client's compliance
- Spearheaded operational shift from flat files t SQL based solutions
- This lead t performance improvements that reduced processing time by up t 80 .
- Allowing us t offer our clients daily updates, where only weekly or monthly would have been possible
- Principal engineer of 4 Customer relationship management CRM databases in 4 years
- Involved from initial specifications development t full productionisation
- CRM DBs with customer bases ranging from 3.5 Million t 16 Million
- All involved clients have either renewed their contracts and/or rated our work as excellent in surveys
CONFIDENTAIL
Title: Data Analyst Temporary Hire
- Primary Role: Database Maintenance, Analysis, and Cleansing
- Maintained the statewide database of streets and their attributes using various sources of information including the Importing of data from non-normalized sources and other departments, Graphical Information System GIS , Legal records and municipal submissions
- Created a Public web reference portal
- Digitized and scanned historic and current reference maps. By uploading legal maps and having them organized graphically by region, eliminating hundreds of man-hours taken by servicing web requests
- Custom Report Generation
- Generated state, county, and local reports t fulfil the department's annual highway inventory.
- In previous years aggregations involved in these reports were manually computed, I automated this process
- Application Development VBA/Access
- Taking my own initiative, I developed a database for internal use t assist my team's workload.
- This database was later used t generate the annual report above, as well as adopted as an intermediary solution while a larger project was being developed in parallel by an outside firm
CONFIDENTAIL
Title: Database Manager/Designer
- Primary programmer in designing the company's web platform
- Streamlined setup from a manual intensive 6 month process t a rapid deployment model under a day when needed
- Developed a database that allowed real-time reporting and statistics of online campaigns
- Communicated directly with Clients
- Assisted the Client's IT departments in initial setup as well as the Marketing and Lobbyists with ongoing support
- Listening t the client's suggestions and ideas, and evaluating them for additional feature creation in subsequent versions.