Veera

Summary of Experience and Qualifications

• Having around 8 years of IT experience in almost all stages of Software Development Cycle like Requirement Gathering, Analysis, Design, Development, Test case preparation, Unit Testing/Regression testing and issue handling.

• Experience in data analysis, creating data models and creating data warehouse system.

• Experience in creating Star Schema, Snowflake Schema and Galaxy Schema in data warehousing.

• Creating data models, schemas, datasets, Queries and segments on Adobe Experience Platform.

• Creating unified customer profile using offline and online data and activate personal experience through targeted channels like Facebook, Google etc..

• Experience in creating stored procedure, queries with dynamic input parameters, functions, and triggers. Make use of temporary tables and common table expressions to write complex queries. Good at using over by functions, joins and many sql advanced inbuilt functions depends on requirement

• Good experience in creating tables, views, indexes and migrating data from one environment to another environment

• using SQL server 2012 Management studio.

• Worked in designing and developing High performance ETL Solutions using Informatica Powercenter 10.x & SQL

• scripts. Has knowledge of UNIX/Shell Scripting.

• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable

• transformations.

• Experience in automating data loading into tables using Unix script

• Experience in monitoring daily jobs and responsible in handling all the performance related issues.

• Experience in creating power bi composite models and dashboards

• Experience in creating SSRS reports

• Experience in performance optimization of Power bi models and dashboards.