We provide IT Staff Augmentation Services!

Data Engineer Resume

RedmonD

SUMMARY:

Over 13 years’ experience in Data warehouse and Business intelligence, with extensive background Architecting and Designing of ETL Reports and Analytics.Proven technical ability in development, modeling, Reporting & Multidimensional analytics, Database & Data marts design, application design & development, process automation, Data Profiling, Data quality analysis and Master Data Management. Self - driven coupled with business acumen to help solve complex problems with robust implementation.

TECHNICAL SKILLS:

  • ETL
  • BI
  • OLAP
  • Data bases
  • MPP/Cloud
  • Data Management
  • SSIS
  • Data stage
  • Cognos
  • SSRS
  • Power View
  • Power Query
  • Power Pivot
  • Power BI
  • Business Objects
  • Performance Point server
  • Excel reports
  • Tableau
  • SSAS
  • Cognos Cubes
  • Tabular Models
  • MDX
  • DAX
  • Oracle
  • SQL server
  • Access
  • SQL
  • PLSQL
  • TSQL
  • PIG
  • HIVE
  • Azure SQL
  • SQLServer PDW
  • Teradata
  • USQL
  • Azure DW
  • HDINSIGHT
  • AZURE Data lake
  • AZURE
  • MS Master Data management
  • Data Quality
  • Data profiling
  • Data Discovery
  • Data Lineage
  • Data modeling with ER Studio
  • Unix shell script
  • VBA
  • Java
  • R
  • PYTHON
  • Azure machine Learning

PROFESSIONAL EXPERIENCE:

Data Engineer

Confidential, Redmond

Responsibilities:

  • As a Data Engineer, I worked with Project manager to build Compliance Data Mart. Landed and Integrated 10 source systems and created power BI dashboard and Drill downs with 10 KPIs. I modelled, designed and Developed ETL in SSIS & TSQL
  • I Designed and Developed Proof of delivery data mart which consists of share point file share system for project status reports. Data loaded directly from share point database to landing database and then merged to main data mart to integrate it with rest of the data mart. Reporting systems consists of SSRS Reports, excel VBA dashboards, Compliance Tracking and defaulter’s notifications.
  • Worked with Director to create forecasting and Goals setting frontend application for various BU leads. Created EXCEL Based application connecting to SQL server back to store the goals set to by various metric owners and Geo owners.

Data Analyst-MDM

Confidential, San Antonio, TX

Responsibilities:

  • As a data analyst, I reported to director data Analysis helped him design and develop Master data management process.
  • My role involves developing Source to target data mappings, develop ETL using SSIS, data modelling, Reference data management, Train and support data stewards on Confidential Master data services, automate excel data interfaces to Confidential Crowd service application (Mechanical Turk).
  • Created data lineate application and maintain meta data of the data warehouse.
  • Worked on Power BI dashboards providing mastering success into various stages.

MSBI Developer

Confidential, Oakland, CA

Responsibilities:

  • As a lead developer, I worked along with a ASP.net application team and helped them integrate SSRS reports into their sales planning application. I designed and developed real time data flow process using TSQL and SSIS, created multi-level aggregation views to support the reporting expectation.
  • Worked on designing and developing 230+ real time Metrics based on application provided input values such as sales process per distribute or retailer.
  • Worked on segregating the project into Real time, Near Real time and daily update metrics.

Cognos and Data Stage Developer

Confidential, Sunnyvale, CA

Responsibilities:

  • As a lead developer, I worked with Data architect to create Sales data mart which eventually enhanced to finance and services DataMart. I created Cognos report net dashboards for various levels of executive leader ship which includes Area\region and district level heads. I also created supported ETL using IBM data stage and PLSQL. worked on sun Solaris to administer Cognos server and maintained the server sustainability. Worked on Cognos and Data stage version upgrades.

Hire Now