- Designed Data Models for complex relational data sources such as Veeva CRM, Adobe Web Analytics, social media, and Marketing data for global pharmaceutical domain businesses.- Responsible for developing Reporting System that helps users to make business decisions. - Create Complex SQL queries on business data to generate reports or to develop data warehousing solutions following ETL. - Create a thorough suite of test cases to expose bugs and rectify them- Understand business rules and KPIs and create a dashboard for sales and marketing users to make business decisions and analysis purposes

• Followed SLDC process and agile methodologies. Involved in different phases starting from requirement gathering, design, development, testing, deployment, and production support.• Handled change Requests and Incidents efficiently within the stipulated time.• Integration of business data from multiple sources like SAP, RDBMS, JD Edwards, and flat files into a single data hub.• Apply business rules on data using Informatica Power Center transformations to meet business standards.• Perform Data validation and Reconciliation of data with Legacy systems.• Apply data warehousing concepts such as Snowflake Schemas, and SCD2 using the Kalido DIW tool.• Creating stored procedures, and SQL views using Oracle to automate the data flow from multiple sources to target as per business standards.