We provide IT Staff Augmentation Services!

Database And Data Warehouse Engineer Resume

Boston, MA

PROFESSIONAL SUMMARY:

Seasoned professional with vast experience in information technology (IT) and many years of SQL Server and Oracle experience utilizing metadata and data warehouses. Exceptional success in driving business value and mitigating business risks on or below budget. Experience includes design specifications, development, testing, Q/A testing, implementation, and support. Extensive experience includes SQL, ORACLE, TOAD, POWERBI.

TECHNICAL SKILLS:

Software/Tools: AWS, CLOUD, ABINITIO, HADOOP, POLYBASE, COGNOS, SSRS, SSIS, SSAS, XML REPORTS, ORACLE REPORTS, ORACLE 11g/12c, ETL, SQL/SERVER 2012/2014/2016/2018 , PL/SQL DEVELOPER, HYPERION BRIO, UNIX/LINUX, MSOFFICE, TIVOLI, JSP, TOAD, VMWARE, SILVERLIGHT, HUMMINGBIRD, FTP/CLIENT, TLPE/CLIENT, INFORMATICA, SQL SERVER MANAGEMENT STUDIO, SHAREPOINT, TEAM FOUNDATION SERVER, MS VISUAL STUDIO 2012/2015/2017 , BIDS/SSDT, DATABASE MONITORING,OBIEE, ODI, TABLEAU, TIBCO/SPOTFIRE, CONTROL - M, JIRA, CONFLUENCE/ATLASSIAN, QLIK, GIT, GITHUB, GITFLOW.

WORK EXPERIENCE:

Confidential, Boston, MA

Database and Data Warehouse Engineer

Responsibilities:

  • Designed, developed, tested and implemented numerous SSIS packages that backfill CVS data with resume data.
  • Database Administrator support. Backup, restore databases and create new ones utilizing Database and Service MasterKey elements.
  • Production support of nightly SQL jobs. Fix/upgrade SQL Server jobs so they complete without issues. 50% of jobs needed tuning.
  • Data modeling and UML experience redesigning new databases for TalentAI application. Analysis of fuel report from Bullhorn data utilizing COGNOS.

Confidential, Nashua, NH

Sr. SSIS Consultant

Responsibilities:

  • Designed, developed, tested and implemented numerous SSIS packages that load Oracle data to the MSBI platform.
  • Data modeling includes building facts and dimension tables for the data warehouse. The packages are developed on
  • Microsoft PDW and are full load packages. Working with users to produce dashboards in PowerBI. Designed data
  • Warehouse schema fact and dimensions tables from OLTP databases.
  • Working within .NET environment encompassing Visual Studio and TFS.
  • Extensive TSQL experience in SSMS including dynamic SQL and stored procedures.

Confidential, Boston, MA

Sr. SSIS Consultant

Responsibilities:

  • Designed, developed, tested and implemented numerous SSIS packages that replicate the ETL loads that were previously done by Abinitio ETL loads.
  • Reverse engineered the process, designed and architected the flowstested with the users and provided demos to staff. The staging data is now stored in Hadoop with a Polybase front end. Data mining activities in Hadoop/Polybase include data exploration into BIG DATA and predictive analysis.
  • Coded nested complex ternary stacked derived columns which include switch case expressions.
  • The reporting end will continue to exist on SQL Server 2014/2016 servers.
  • Utilized metadata to develop/debug packages.
  • Participated in setup of Hadoop/Polybase cloud databases.
  • Extensive experience in TSQL queries and stored procedures.

Confidential, Boston, MA

Sr. Data Warehouse Consultant and DBA

Responsibilities:

  • Architecting, designing, developing a brand new EDW comprised of data from EPIC/Clarity, Oracle PeopleSoft and our own data to be utilized by all non IT departments across the organization. The packages are being developed in SSIS with SQL Server Stored Procedures and SSRS reports.
  • Utilized metadata to develop/debug packages.
  • Developed Full and incremental loads for ETL sourced data.
  • Created indexes on EPIC sourced tables.
  • Developing adhoc reports utilizing SQL Server 2012, Stored Procedures, and model templates.
  • Redesigning the reporting structure for the clients to standardize reporting across the platform.
  • Reverse engineering the data base and rearchitected it to standardize the platform.
  • Analysis of SQL Server databases for performance improvements.

Confidential, Southboro, MA

Sr. Data Warehouse Developer

Responsibilities:

  • Gateway and SSRS Reporting responsibilities. Migration to ODS environment which included rewriting reports.
  • Maintained, supported and enhanced Data Warehouse denormalized tables built from normalized Oracle/SQL Server tables and views.
  • The packages in PL/SQL include extracting the data from the Gateway, loading them into Oracle staging, creating additional views, inner and outer joins, and merge/insert data into the applicable fact/dimension tables. (ETL)
  • The data warehouse is incrementally loaded daily then the SSRS reports pull the data from the warehouse utilizing Oracle PL/SQL packages, dynamic SQL and generate the reports and files from the Star Schema.
  • Experience in assisting SQL Server DBA setting up new clients, backups and restores and setting up replication.
  • Experience utilizing Agile/Scrum methodologies.
  • Experience in JIRA/Confluence to create/modify/delete and change workflow of assigned tickets.

Confidential, Westwood, MA

Sr. Database/Implementation Consultant

Responsibilities:

  • Responsible for code reviews, implementations, testing and coordinating the applications into the various environments.
  • Investigate and resolve problems/issues in DEV and UAT as part of development process.
  • Build/deploy C#, ASP.Net code to test, prod environments. Analysis of explain plans and database monitoring.
  • Extensive utilization of Oracle Schema, SQL Compare and TOAD and COGNOS Reporting.
  • Developed implementation and execution project plans acting as project leader/team lead
  • In a global and matrixed environment, partnered closely with colleagues to craft solutions and gain key stakeholder support (including Executives) thru online meetings and in person visits to the individual campuses.

Confidential, Ashland, MA

Software Engineer Consultant

Responsibilities:

  • Developed SSIS, SSAS, SSRS packages to resolve customer issues that include enhancements, fixing bugs and creating new packages for new customers as the organization was growing rapidly.
  • Developed complex stored procedures, package variables, reports, functions, triggers and TSQL scripts in SQL Server 2008 R2 environment. Converted COGNOS reports to SSRS reports.
  • Experience includes architecting and implementing complex BI solutions.
  • Developed and designed SSAS cubes to store KPI’s, aggregated amounts and other dashboard information.
  • Created the star schema design that was utilized by identifying the facts and dimensions sourced from the database

Confidential, Boston, MA

Database Administrator Developer Consultant

Responsibilities:

  • Backup and restore of databases, creating indexes, foreign, alternate keys, provide authorization to users.
  • Created SSIS packages that take flat excel files transform the data and load the data to the database.
  • Developed and designed SSAS packages to store KPI’s and aggregated amounts on cube from transactional database so legal assistants could slice and dice their data in Excel for senior management dashboards.
  • Design and implementation of dimensional data models along with analysis of requirements and production of specifications for business intelligence functionality with ETL and reporting components.

Confidential, Manchester, NH

Business Intelligence Consultant

Responsibilities:

  • Developed SSIS packages utilizing Configuration Manager.
  • Created Actuarial ITD Paid Loss reports from SQL server tables which included creating the queries, subtotal by treaty and risk state, then produce a grand total for the entire report.
  • Developed SSRS packages that extract loss run information from reporting databases, produce monthly detail and quarterly summary reports. Created scripts in C# for SSIS that passed values to the UI during error processing.
  • Designed control flow and data flow components in SSIS which included stored procedures, transformations, conditional splits, derived columns, fact and dimension tables.

Hire Now