SUMMARY

• Data Professional with 19+ years of experience in Data Engineering, Data Management, Data Architecture, Data Analyst, Software Design & Development.
• Proficient in Technology leadership, architecture, building great teams, strategy planning, project management, client/partner management and budget planning etc.
• Strong technical leadership skills with experience in managing customer, vendor, and teams.
• Experience in Data Warehouse and Confidential solutions on various data platforms.
• Experience in enhancing and maintaining Data Lake solutions over Big Data Platforms (Snowflake, Cassandra)
• Architect, design and develop Customer Data Platform (CDP) in Adobe Experience Platform (AEP) technology.
• Define and design Data Integration and Data Quality standards for Data Warehouse and Analytics solutions.
• Based on the concept of Site Reliability Engineering build data observability and reporting solution for various data flow processes in AWS and define Confidential for the same.
• Build generic ETL framework solution on SSIS for executing various SSIS jobs with logging and reporting capabilities.
• Knowledge on implementing Modern Data Warehouse solutions using Data Fabric and Data Mesh approach.
• Collaborate with cross - functional teams to drive data-driven decision making and improve business performance.
• Extensively used ETL methodology for supporting data extraction, transformation and loading process.
• Strong T-SQL skills. Experience in writing, debugging complex Stored Procedures.
• Experienced handling different file formats like (CSV, JSON, PARQUET, XML etc.).
• Experience in Web and Windows based Application design and development using Microsoft technologies (C#, .Net, ASP.Net)
• Experience in implementing web-based applications using a multi-tier architecture.
• Experience in optimizing database i.e., performance tuning for Stored Procedures and DB queries and setting up Indexes.
• Successfully managed and mentored teams of engineers, fostering a culture of innovation and continuous improvement.
• Do design and code reviews. Provide technical, business guidance and review outputs from junior team members.
• Experience in working with Agile based approach.
• Creating and maintaining Business and Technical documents with business flows and architecture blueprints.
• Excellent Analytical skills.
• Possess strong ability to quickly adapt to new applications, tools, platforms, and languages.
• Strong work ethic along with rock solid "Winning" attitude.

TECHNICAL SKILLS

Operating System: Windows NT, UNIX

Languages: SQL, C#, Python, VB.Net

Platform: AEP (Adobe Experience Platform), .Net, SSIS, SSRS, SSAS, MS Power BI

Web Technologies: ASP.NET, WCF, ASP, Java Script, VBScript, Silverlight 4.0.

Framework: .Net framework 4.0, 3.5, 2.0, 1.1

Databases: MS SQL Server 2012 and above, Snowflake, MongoDB, AWS Redshift, Cassandra, Sybase, Oracle

Tools: SSMS, Visual Studio, Talend, Jupyter, Dbeaver, JIRA, MS Visio

Orchestration: Autosys, Cron, Airflow

File System: HDFS

CI/CD: Jenkins, Maven, Stash, Git, Bitbucket

Cloud: AWS and Azure

Web Servers: IIS 5.0/6.0

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

• Design schema for various datasets within AEP as per AEP best practice (XDM format).
• Understand client data governance requirements and create design to implement the same in AEP.
• Coordinate with team to define data ingestion pipelines, review ingested data, apply data governance labels on datasets attributes.
• Defining schemas to handle customer consent attributes.
• Coordinate with offshore team members for data science model requirements from data perspective.
• Help team in joining various datasets and create custom datasets for their models.
• Facilitate discussions with client product teams, architects and other stake holders for questions, design reviews, update on project status and demo.
• Provide support for Production rollout.

Environment: Adobe Experience Platform (AEP), data modeling, SQL

Confidential

Functional & Data Architect

Responsibilities:

• Interact with key stakeholders in requirement workshops and help in driving and closing of the requirements.
• Facilitate discussions with various client product teams to explain EB framework for data observability and help them in implementing the same to improve operational efficiency.
• Develop understanding on existing client ETL process and define framework to implement new data quality guidelines.
• Lead a POC to implement new data quality guidelines without any sacrifice in overall performance.
• Coordinate with offshore team members for providing guidance in implementing new features.
• Develop and enhance various EB application dashboards in Grafana.
• Review and testing of new features.
• Create functional design and technical artifacts for various data flows and data quality framework.

Environment: AWS, T-SQL, Talend, Prometheus and Grafana, MongoDB, Microsoft SQL Server, Git

Confidential

Tech Data Analyst

Responsibilities:

• Interact with key stakeholders and help in driving and closing of the requirements.
• Create business requirements documents for on-boarding various data sets into Analytics platform.
• Guide Data Engineers to on-board various data sets into the Analytics platform. Help in defining logic for onboarding incremental data.
• Guide team in developing Data Catalog for the onboarded datasets in the Analytics platform.

Environment: Cassandra, Snowflake, Oracle, T-SQL, Jyputer Notebooks, Python

Confidential

Senior Architect

Responsibilities:

• Architecture and design review of the whole application.
• Recommend technical best practices when redesigning any module or functionality.
• Work closely with the requirement gathering group to close on the new requirements.
• Provide high level Tech design details for corresponding functional requirements to team in India.
• Review ETL jobs to validate the data flow as per business requirements.
• Coordinate/Facilitate discussions with onshore stakeholders and clients about functional requirements, tech design, estimates etc.

Environment: C#, .Net, REST Services, SSIS, SSRS, T-SQL, Microsoft SQL Server 2014, MS Power BI

Confidential

Senior Data Engineer

Responsibilities:

• Create Star schema-based Data Models in SQL 2016 with appropriate partition scheme.
• Develop SSIS based solutions for bringing Positions Data, Synthetic Positions data, pricing data etc.
• Implement data reconciliation to make sure we are not missing any data.
• Create Data lineage to trace end-to-end flow of data.
• Auditing to capture record counts for Inserted, Updated, Deleted and Error records at each logical step.
• Develop generic ETL framework solution on SSIS for executing various SSIS jobs with logging and reporting capabilities.
• Setup and monitor Autosys jobs to run the ETL process at defined frequency.
• Develop reports in SSRS for higher management.

Environment: SSIS, SSRS, T-SQL, Microsoft SQL Server 2016, Power BI

Confidential

Senior Developer

Responsibilities:

• Split one of their critical, complex, monolithic error prone nightly process to a more robust regional based process.
• This further helps in dividing the total volume into 3 processes, hence improving the overall efficiency.
• Because two processes now run in US hours hence, they can be supported better and reduce the dependency on the sole nightly cycle and completing it earlier.
• Setup and ramp-up an offshore team in India for Supercache.

Environment: C#, .Net, Web Services, T-SQL, Microsoft SQL Server 2012

Confidential

Senior Data Engineer

Responsibilities:

• Design and develop a generic SSIS based execution framework for integrating any external system with Confidential .
• Develop complex SSIS based ETL flows to bring calendar data, employee data and External Legal Entity data into Confidential .
• Setup ETL Process design in such a way so that lower environments can also be refreshed wit actual vendor data for testing.
• Setup and monitor Autosys jobs to run the ETL process at defined frequency.

Environment: SSIS, T-SQL, Microsoft SQL Server 2016