Advising, Architecting & Engineering Data Solutions, Cloud Adoption, Data as a product.

• Define Enterprise Conceptual Model and Data Architecture for Enterprise Data Platform.• Define and maintain Enterprise Data Modeling and Data Engineering standards.• Define and design common data platform frameworks.• Capture tactical and strategic goals to provide traceability through the organization.• Lead discussions with business leaders to identify technology capabilities informing current and future business objectives.• Engage with senior leadership (both technical and business) to influence decisions and the direction of strategy.

•Define the processes needed to achieve operational excellence in all areas, including project management and system reliability.•Build cross-functional relationships with Data Science, Product Management, Design and Software •Engineering leaderships to understand data needs and deliver on those needs.•Drive the design, building, and launching of new data models and data pipelines in production.•Drive data quality across the product vertical and related business areas.•Define and manage SLA’s for all data sets and processes running in production.•Develop and enforce agile software development practices

•Design Architectural solution for Enterprise Data Lake and cloud enablement.•Involved in architect responsibilities including roadmaps, leadership, planning, technical innovation, security, IT governance, etc.•Worked on Data migrations from On-premise to AWS Cloud•Responsible for building a data ingestion pipeline for on premise data to EDL layer using Informatica for net-change, Java API to convert to AVRO format and ingest data to enhance buckets using asynchronous file API for data consumption in EDL.•Defining datatypes and governance policies for ingested data for teams to consume •Developed spark logic to perform Net change operation and ensure latest data is available•Used py-spark Mathematical and statistical libraries and functions to handle complex business transformations•Designed and developed Automated testing framework and code coverage for Python Databricks using TOX for manually-invoked testing from the desktop, and continuous testing within continuous integration Jenkins frameworks. •Designed Continues integration and code deployment framework using Jenkins.•Building data quality Framework in AWS EDL on Data ingestion process using Lambda, kinesis data firehose, elastic search and Kibana.•Followed Agile methodologies and executed delivery in respective sprint

•Design Architectural solution for Single Enterprise layer of Information from heterogeneous data sources, for OM downstream reporting with integration of legacy and sources.•Data Provisioning and replicating data from source system to HANA Database using SLT.•Access the data from Non Sap systems using Smart Data Access, Informatica and Real time messaging.•Create Calculation Views, Analytical Views, Attribute Views, Star Join, Hierarchies by using Calculation Views, Decision Tables, Filters, Variables, If Else Calculated Formulas, Restricted Columns, Aggregations & Filter Expression, Calculation Attributes/Measures.•Export and Import of HANA views between different life-cycle systems through Developer mode as well as through Delivery Unit Activating HANA views.•Performance Optimizations - using Plan viz, Sql, Debug wrapper & In CV using Input Parameters to minimize the data read from Database Transaction Table.•Design ETL Batch Load using SAP BODS & Informatica for legacy data into HANA & Out to downstream application.•Performed activities such as: Feasibility analysis, Estimation, Requirement analysis, Impact analysis, Business Process analysis, Design review and Consultation.•Interfacing with internal team to ensure high quality deliverable's & was accountable for meeting Internal and external quality standards and process.

•Participate in business and system requirements sessions with client’s Business and IT team, and translation to technical specifications.•According to Business requirements, work on designing Architectural Blue Print.•Interact with clients to elicit architectural blue print and non-functional requirements like performance, scalability, reliability, availability, maintainability using three tire architecture SAP HANA as Back-end, Java as Middle-ware and UI5 as front-end.•Work with cross work streams, and determining solution design impacting the core frameworks and components•Design application/modules based on identified architecture and support implementation of design by resolving complex technical issues faced by the team members during development and deployment. •Design review and code reviewed for development done by team members.•Build Security privileges and access control logic in HANA.•Review of Models/Data services created by team member in HANA.•Support business process modeling, data modeling, security and integration modeling.•Preparation of test plan.•Review of test cases prepared by team members.

•Participate in business and system requirements sessions.•Requirements elicitation and translation to technical specifications•Analysis and design of the DataMart based on the requirement and the existing application and data warehouse.•Creation of fact and dimension table structure. Design and development of source and destination column mappings.•Design and development of the ETL scripts and SSIS packages for data loading.•Created Design and Requirement documents for the ETL mappings & SSIS packages.•Perform performance optimizations of the SQL scripts.•Design and development of SSAS cubes.•Preparation of Unit test case document and executing the same.

Engage with business users to understand their research request and refine research questions.Develop data infrastructure and data framework (using primarily SCOPE - SQL + C# Big DataPlatform, SSIS, SSAS and SSRS).Proactively track, manage and accommodate Data Extraction upstream/downstream systemchanges without any business impact.Work with marketing team or product management team to track research/analysis request.Provide regular status updates and report about Data Extraction work/projects to allstakeholders.

Designing & implementing various reports using SQL server 2005 and SSRS (SQL Server Reporting Services) for various Business needs. Managing and maintaining SQL server 2005, Reporting Services.Managing changepoint (Time sheet & Project Management tool).Creating and publishing Stack Rank for all employees on quarterly and early bases.