SUMMARY

• Around 16 years of Leadership, Architecture, Design and Development of IT experience.
• Expertise on Pharmaceutical Commercial data, Retail Product Hierarchy, Capital Market, Insurance domain .
• Skilled Data Solution Architect who transforms business requirement into workable solutions by leading JAD session with Business.
• Extensive experience on Data Integration, Data Lake. Data Governance and BI Architect.
• Experience in leading cloud implementation of Data Engineering projects technologies (Azure Technologies and Snowflake) by collaborating with data engineers.
• Extensive experience in Agile based environment.
• Expertise in implementing End - End Data Governance - Data Lineage, Data Quality, Data profiling.
• Participate & lead in Data model, integration mapping & code review.
• Skilled in designing optimized enterprise process across business segments using robust data handling processes. Architect solutions that are reusable, maintainable.
• Experienced Technical Delivery architect with a demonstrated ability to forge trusted partnerships with clients, understand their Business & Strategy, and craft win-win proposals by mapping their requirements to the right technology and services.
• Responsible for leading data integration competency and build frameworks and Artifacts for DI competency, RFP solution and Assessment.
• Well versed with various types pf performance & parallelism techniques using Data, Component and Pipeline parallelism.
• Experience in defining data security standards such encryption, masking in data driven projects
• Expertise in designing generic config driven solutions for data integration platform which minimizes the development efforts,
• Experience in defining/designing non-functional requirements for data integration projects such as Error handling, Data movement controls, Data Quality & Audit controls,
• Providing expertise, mentorship, and solution reviews to multiple groups of ETL developers and provide standards, procedures, and best practices for data integration as per industry standards.
• Effective Leadership skills, communication skills, interpersonal skills, self-motivated, quick learner and good team player.

TECHNICAL SKILLS

Cloud Technology: ADLS2, Azure Data Factory, Azure Data Bricks. Azure data Explorer, Azure SQL DB. Snowflake

ETL Tool: SSIS,ADF Data Modelling SQL Developer

RDBMS: SQL Server, Snowflake, Oracle

Scripting: C# programming.

Project lifecycle Tools: JIRA

Tools: SSMS,TOAD, SQL Developer

Environment: Agile

PROFESSIONAL EXPERIENCE

Confidential

Data Solution Architect

Responsibilities:

• Responsible for end-end data engineering solution delivery and design.
• Architecture and design data solution for Creating Product taxonomy from different sources.
• Design Product taxonomy solution to apply recommendation as per analytical algorithm.
• Design and build Marketing cloud API and data distribution access layer for product taxonomy for downstream applications,
• Work closely with Data modeler and Business Analysis to come with Data model and business Rule’s solution for product taxonomy.
• Convert business requirement to technical solution to build product taxonomy.

Environment: Snowflake, ADLS2, Azure Data Factory, data bricks, Spark, Python, Azure Devops .

Confidential

Data Architect

Responsibilities:

• Responsible for lead and deliver end-end Cloud Data lake Framework development for Consumer Care Data Ware house integration .
• Architect and Design Configuration driven framework for ingestion, unification and curation
• Architect and design Event Audit Framework for ingestion, unification and curation.
• Architect and design for Hierarchical data pattern (Xml/Json) ingestion.
• Design and build DEP architecture to be cloud technology independent to have plug and play in any cloud environment with minimal changes.
• Architect & design data movement controls, Data Quality in motion for DEP Framework.

Environment: Microsoft Azure, ADLS2, Azure Data Factory, data Bricks, Azure SQL

Confidential, Charlotte, NC

Data Integration Lead

Responsibilities:

• Architect and design distribution framework to distribute data to consumers.
• Responsible for Co-ordination with different Source teams and analysis on Source data.
• Define standards, procedures, and best practices for data integration as per industry standards.
• Participates in overall data integration testing.
• Develops new documentation, participates in the development of department technical procedures and designs user guides.

Environment: SSIS, Oracle, MS SQL Server

Confidential, Princeton, NJ

Lead Designer

Responsibilities:

• Working as Lead Solution designer for CDR Datawarehouse.
• Integration of different source( External Sources as well as Internal ).
• Lead Data Quality and Express IT Upgrade and integration.
• Lead and Co-ordination on End -End testing of all the modules
• Implementation and Support all Data Quality Technical Issue.
• Analysis of Data profiling results, Co-ordination with business team decision making on all data decision.
• Responsible for defining data strategy for Historical Data so that a balance can be maintained between Space and speed.
• ETL Code review of SSIS Pipelines.
• Creation of High level and Low-level design documents for ETL.

Environment: SSIS 2012, SQL Server 2012,Microstrategy,Snowflake