close
  • Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Consulting Application Engineer
Please provide a type of job or location to search!
SEARCH

Consulting Application Engineer Resume Example

Love this resume?Build Your Own Now
CONSULTING APPLICATION ENGINEER
Professional Summary

A natural leader with over 15 years of Data Analytics experience, Effectively engages and collaborates with multiple IT groups in architecting elegant and complete solutions. A clear understanding of enterprise data modeling and profiling, ETL processes, BI reporting, data governance frameworks, change management processes, master and reference data management, data auditing, and validation methods.

Skills
  • Data Governance
  • Enterprise Data Warehousing
  • Off Shore Model Management
  • Performance and Productivity Improvement
  • Data Quality Management
  • Data Analysis/Modeling
  • Mentorship
  • Lean Six Sigma Certified
Technology Profile

Data Management

Ataccama 12.3 – Data Quality Management, Reference Data Manager, Data Discover &Profiling

ETL Tools

DMExpress 7.1.0,DataStage 8.5, Informatica PowerCenter 8.6/7.1

Database

Impala, Hive,Teradata 16.20, Oracle 9i/10g, SQL Server 2012, Netezza

Modeling Tool

Power Designer 16.5

Scheduling Tools

Zeke, CA Autosys, Maestro

Language

SQL, PL/SQL, Shell Scripting, PowerShell

Version Control

CA Harvest Source Control, TFS, Github

Reporting Tool

Business Objects, Tableau

Work History
Consulting Application Engineer / / Hca - Pleasant View , TN / 05.2009 - Current

I got an opportunity to explore all the facets of data management in healthcare from ETL Datawarehousing, Data Modeling & architect, Data Quality/Governance frameworks. It plays a significant role in designing and implementing solutions with a quality-first mindset. Led a Green Belt Project “Syntel COE Improvement” which reduced the Production support hours and changed the dynamics of Development involving Offshore Partner. This project led to a cost avoidance of approximately $85,000 for the Data & Analytics group and created standard templates to control this process going forward.

Responsibilities:

■ Automated the alert process with proactive monitoring of HL7 Messages for data integrity between EDH Impala database & EDW Teradata.

■ Strong ability in developing advanced SQL Queries to validate and calculate to fulfill data/reporting requirements.

■ Provide Technical direction to sourcing partner on deliverables and assure through regular review sessions to meet the Business Timeline.

■ Streamlined the existing process for the Lean Abend reduction initiative which significantly reduced the production support hours of offshore development partner.

■ Designed work sessions with team to switch from ETL nightly batch process to more real time data ingestion through big data technologies involving Impala/Squoop.

■ Created Shell/Perl scripts for Meditech source files preparation for ETL ingestion.

■ Responsible for successful Design, Development and Delivery of projects involving ETL, Database and Business Intelligence

■ Completed Data Model for few Projects which led the efforts from Sourcing, Data Profiling through Data Mapping for ETL Team.

■ Initiate and led detail work sessions with Data Analyst/Architects in designing Database Objects and keyed inputs for maintaining Data Integrity after analyzing source data in Enterprise Data Warehouse (EDW).

■ Work closely with Clinical Analyst in resolving data issues & automated daily alerts with data variance of business-sensitive issues.

■ Created data quality Developer guide, Standards document, end-user training.

■ Managed and coached team members

Sr. ETL Informatica Consultant / / Nationwide Financials - City , STATE / 08.2008 - 03.2009

■ Involved in interacting with business in gathering requirements and identify the scope.

■ Managed Onsite/Offshore (Hybrid) Delivery Model, ensuring optimal distribution of work between the Client and the offshore development center.

■ Collaborated with the client management team to ensure delivery schedules adhered to budgets and timelines.

■ Managed the BI team by providing direct supervision and mentoring of project team members.

■ Responsible for the conceptualization, design, and implementation of sound technical architecture for the Financial Data Mart.

■ Implemented Slowly Changing Dimension (SCD type II) design for the Data Warehouse

■ Expertise in Performance Tuning by identifying the bottlenecks for process improvement.

■ Involved in Dimensional modeling using Erwin with Data Modeling team

ETL Informatica Consultant / / XL Capital - City , STATE / 08.2005 - 06.2008

■ Involved in interacting with business in gathering requirements and identify the scope.

■ Managed Onsite/Offshore (Hybrid) Delivery Model, ensuring optimal distribution of work between the Client and the offshore development center.

■ Collaborated with the client management team to ensure delivery schedules adhered to budgets and timelines.

■ Managed the BI team by providing direct supervision and mentoring of project team members.

■ Responsible for the conceptualization, design, and implementation of sound technical architecture for the Financial Data Mart.

■ Implemented Slowly Changing Dimension (SCD type II) design for the Data Warehouse

■ Expertise in Performance Tuning by identifying the bottlenecks for process improvement.

■ Involved in Dimensional modeling using Erwin with Data Modeling team

OIT Staff / / Western Michigan University - City , STATE / 11.2002 - 03.2005

■ Responsible for development and maintenance of a database which helped the team to make some decisions in improving the facilities of the computer center

■ Responsible for creating data feeds of alumni information to an annual fundraising program

■ Involved in Data Administration and Data Warehouse subcommittee (DADW) which promotes the importance of data as a valuable university resource

■ Responsible for data conversion from Access, Excel to MS SQL Server 2000.

■ Provided technical support to users of OIT computer labs on the university campus

Education
Western Michigan University - City, State / 04.2005Master of Science: Electrical, Electronics Engineering Technologies
VEC - City / 04.2001Bachelor of Science: Engineering
National Institute of Information Technology - CityDiploma: Software Engineering
Certifications

■ Completed Lean Six Sigma Green Belt Training

■ Completed Essentials of Leadership in iTrain

■ Diploma in Software Engineering, National Institute of Information Technology, INDIA

■ Certified in Data Warehousing Concepts, Global Infotech, INDIA

■ Certified in Big Data Concepts, Global Big Data Conference, Santa Clara, USA

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

90Good
Resume Strength
  • Completeness
  • Formatting
  • Word choice
  • Measurable results
  • Typos

Resume Overview

School Attended

  • Western Michigan University
  • VEC
  • National Institute of Information Technology

Job Titles Held:

  • Consulting Application Engineer
  • Sr. ETL Informatica Consultant
  • ETL Informatica Consultant
  • OIT Staff

Degrees

  • Master of Science : Electrical, Electronics Engineering Technologies
    Bachelor of Science : Engineering
    Diploma : Software Engineering

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Consulting-DB2-Systems-Programmer-resume-sample

Consulting DB2 Systems Programmer

Bank Of America Corporation

Goleta , CA

Director-Consulting-Expert-(-Cloud-Architect)-resume-sample

Director Consulting Expert ( Cloud Architect)

CGI Technologies And Solutions

City , STATE

Founder/Enterprise-Data-Architect-resume-sample

Founder/Enterprise Data Architect

Quasar Database Technologies, LLC

City , STATE

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.