Consulting Application Engineer Resume Example
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.
|
|
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
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
■ 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
■ 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
■ 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
■ 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
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:
- 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
Similar Resumes
