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
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.
Companies Worked For:
School Attended
Job Titles Held:
Degrees
