Devang Bhalgama

Devang Bhalgama Email and Phone Number

Vice President | Principal Cloud Data Architect | Platform Modernization @ LPL Financial
Devang Bhalgama's Location
Charlotte, North Carolina, United States, United States
Devang Bhalgama's Contact Details

Devang Bhalgama work email

Devang Bhalgama personal email

About Devang Bhalgama

Over 16 years of diversified experience in the IT industry focused on Business Intelligence and Data Warehousing across Healthcare, Banking, Finance and Insurance domain.Expertise in Enterprise Data Architecture, Data Architecture Strategy, Data Warehousing, ETL Development, Dimensional Modeling, Data Quality Management, Reporting & Analytics.Specialist in Informatica PowerCenter and other Informatica products like Informatica Developer, Informatica Metadata Manager, and Informatica Data Quality.Application Development using Big Data technologies like Pig, Hive, Spark, Scala, Sqoop, AWS S3, EMR Cluster and RedshiftImplemented MetaData Driven Data Lake on AWS using Hive, Spark, Scala, Java and AWS services like S3, Cloud Watch, SQS, SNS, AWS Lambda, Cloud Formation Stack and EMR Cluster. Designed algorithm for Data Profiling & Cleansing in the development of Syntel’s own Data Quality & Master Data Management tool which is now patent pending by Syntel.Experience in conceptualization, architecture and productizing Data quality and domain solutions.Successfully architected and implemented Data Reconciliation framework using Informatica.Expertise in creating Stored Procedures, User Defined Functions, PL/SQL and T-SQL batch scripts to accommodate complex business specifications and performance tuning.Expertise to JAVA, J2EE, Ajax, JQuery, Unix Shell Script and exposure to Java Script, C# script and VB Script.SKILLS • Integration Tools: Informatica PowerCenter 10.x/9.x/8.x, SSIS 2012/2008 R2/2005, DMExpress• Big Data & AWS: Pig, Hive, Sqoop, Spark, AWS S3, EMR Cluster, Redshift• Reporting Tools: Tableau, SSRS, Jasper Reports• Database: Oracle 11g Teradata, SQL Server,DB2, MySQL• Data Quality Tools: Informatica Data Quality, SmartData• Scripting Language: JAVA, J2EE, Scala, Ajax, JQuery, Unix shell script, JavaScript, PL/SQL

Devang Bhalgama's Current Company Details
LPL Financial

Lpl Financial

View
Vice President | Principal Cloud Data Architect | Platform Modernization
Devang Bhalgama Work Experience Details
  • Lpl Financial
    Principal Cloud Data Architect
    Lpl Financial May 2023 - Present
    San Diego, Ca, Us
    View
  • Wells Fargo
    Vice President | Business Data Analytics & Reporting Leader
    Wells Fargo Mar 2022 - May 2023
    San Francisco, California, Us
    View
  • Wells Fargo
    Data Architect | Data Modeler
    Wells Fargo May 2019 - Mar 2022
    San Francisco, California, Us
    View
  • Bank Of America
    Data Quality | Big Data | Etl Lead Developer
    Bank Of America Feb 2018 - May 2019
    Charlotte, Nc, Us
    View
  • Syntel
    Etl Project Lead
    Syntel Apr 2010 - Aug 2017
    Troy, Michigan, Us
    • Designed, developed and executed several data warehouse projects in Insurance, Healthcare and Banking domain.• Developed Data Quality & MDM tool which includes Profiling, Cleansing, Validation, Enrichment and Data matching functionalities.• Specialist in Informatica PowerCenter and other Informatica products like Informatica Developer, Informatica Metadata Manager and Informatica Data Quality.• Experience In mentoring team members and building a teamCurrent Client: CDPHP (Leading health insurance company in New York Capital Region)Technologies : Sqoop, Hive, Spark, Scala, HDFS, Amazon S3, Informatica PowerCenter 10.x/9.x, Erwin,Oracle 11g, SQL Server 2008 R2, Flat File Sources, Informatica MetaData Manager and InformaticaDeveloperRoles and Responsibilities:• Architected Data Reconciliation framework for the ODS using Informatica. • Designed Data Model to do survey analytics on CDPHP’s Members & Providers and designed ETL strategy to integrate data from Survey vendors like The Myers Survey Group and DSS.• Integrated Medispan – Drug related reference data to ADW for fraud analytics on pharmacy claims, Doctor shopping and trend analysis on drug prices.• Successfully incorporated complex business rules using Informatica PowerCenter.• Worked on “Primary Care Rate Increase” which is part of Obama Care Reforms.• Architected ETL strategy to load Optum ImpactPro data into EDW for Risk assessment.
    View
  • Syntel
    Analyst Programmer
    Syntel Aug 2011 - Jun 2012
    Troy, Michigan, Us
    Technologies used: Pig, Hive , HDFS, J2EE, JSP, Servlet, Ajax, JQuery, Tomcat Web ServerRoles and Responsibilities:• Played a key role in the implementation of SMARTDATA – Data quality and MDM tool• Responsible for writing algorithms in JAVA for all the core modules Data Profiling, DataCleansing, Validation, Enrichment and Matching.• Designed, developed and integrated most of the User Interfaces using Java, JSP, JQuery, AJAX.• Integrated Informatica’s web services in the SMARTDATA.
    View
  • Group Health
    Senior Etl Developer
    Group Health Dec 2013 - Jun 2014
    Employer: Syntel IncTechnologies : Informatica 8.6, Teradata, SQL Server, Unix, Flat File Sources, XML Sources, Mainframe SourcesRoles and Responsibilities:• Worked on the Contact Preference Data Mart & EDW.• Integrated complex coverage & contract data using Informatica PowerCenter from different source systems into Teradata.• Integrated Pharmacy data from Medimpact & UCD into data warehouse using Informatica and Teradata FastLoad TPT.
  • American Express
    Data Management Engineer
    American Express Jul 2012 - Nov 2013
    Employer: Syntel IncTechnologies & Sources used: SSIS, SSRS, SQL Server, Oracle 10g, Teradata, Excel Source, XML Source, Flat file sources, fixed length sourcesRoles and Responsibilities:• Requirement gathering and understanding of each of the six source systems that support the existing platform of SQL Server, Oracle, Teradata and Excel files.• Designed strategy to load real time data warehouse and historical data warehouse needs.• Development, deployment & migration of SSIS packages• DTS to SSIS migration
  • Hca
    Etl Developer
    Hca Mar 2011 - Jul 2011
    Nashville, Tn, Us
    Employer: Syntel IncTechnologies used: SQL Server 2008, Teradata, SSIS, Informatica, DMExpress, VSS• Responsible for analyzing Informatica workflows and its functionality to prepare technical specification document.• Responsible for designing approach for converting Informatica workflows to SSIS packages.
    View
  • American Safety Insurance
    Etl Consultant
    American Safety Insurance May 2010 - Mar 2011
    Employer: Syntel Inc• Designed SQL and SSIS codes to read XML sources and generate relational system from it.• Developed codes to read generated relational tables and populate transformed data into ASI –EDW database which consists of 13 Dimensions and 4 Fact tables.
  • Experior Technologies
    Software Engineer
    Experior Technologies Apr 2009 - Apr 2010
    • Worked on Several J2EE Projects as well as on Swing Application. In addition to development responsibilities I have also performed a wide range of architectural responsibilities including creating logical architecture diagrams, UI prototyping and task estimation.• Developed and designed portal for Microfinance domain.• Executed the role of Data Modeler & Data Architect in the development of Water Supplymanagement system.
    View
  • I-Link Infosoft(G) Pvt Ltd
    Software Intern
    I-Link Infosoft(G) Pvt Ltd Nov 2008 - Apr 2009
    Ahmedabad, Gujarat, In
    • Part of the development team for the US Sales & Use tax web based system developed using Java J2EE to make e-filing easier and simple.
    View

Devang Bhalgama Skills

Data Warehousing Data Management Data Quality Etl Java J2ee Database Design Enterprise Application Development Eai Java Enterprise Edition Web Services Pl/sql Jquery Software Development Microsoft Sql Server C# Xml Agile Methodologies Unix Shell Scripting Core Java Jsp Shell Scripting Business Intelligence Javascript Ssis Sql Oracle Databases Mysql Informatica Ssrs Requirements Analysis Requirements Gathering Sdlc Oracle Sql Developer T Sql Data Migration Apache Spark Scala Big Data Hive Sqoop Apache Kafka Hdfs Apache Pig Oozie

Devang Bhalgama Education Details

  • Nirma University
    Nirma University
    Information Technology

Frequently Asked Questions about Devang Bhalgama

What company does Devang Bhalgama work for?

Devang Bhalgama works for Lpl Financial

What is Devang Bhalgama's role at the current company?

Devang Bhalgama's current role is Vice President | Principal Cloud Data Architect | Platform Modernization.

What is Devang Bhalgama's email address?

Devang Bhalgama's email address is de****@****ail.com

What schools did Devang Bhalgama attend?

Devang Bhalgama attended Nirma University.

What are some of Devang Bhalgama's interests?

Devang Bhalgama has interest in Children, Economic Empowerment, Civil Rights And Social Action, Politics, Education, Environment, Poverty Alleviation, Science And Technology, Disaster And Humanitarian Relief, Human Rights.

What skills is Devang Bhalgama known for?

Devang Bhalgama has skills like Data Warehousing, Data Management, Data Quality, Etl, Java, J2ee, Database Design, Enterprise Application Development, Eai, Java Enterprise Edition, Web Services, Pl/sql.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.