Involved in Cube Design and MDX queries in SSAS
 Processing and Deployment of Cube
 Adding New dimensions in the existing Cube
 Creating Different User Defined Hierarchy in the Cube and involved in Optimization.
 Involved in the ongoing DW activities regarding addition of Dimensions and Facts depending
upon the requirement.
 Worked as Data Analyst in the Managed Print Services to get insight of the data using SQL
 Managed the Data resulting from Analysis to get shared with the management for
 Worked with Onsite team for various Day to Day DW activities.
 Worked on Dashboards for Manage Printing Services for different Geographical Locations for
various measures.

Involved in the automation of Reports for Dell Customers and Resellers.
• Highly involved in SSIS and SSRS for automation of reports
• Involved in creation of SQL jobs
• Worked on Data Analysis for different regions
• Creation of Customer Quality Review Report for Dell
• Creation of SQL Stored Procedures
• Optimization of SQL Stored Procedures
• Creation of new SSRS Reports based on Client Requirement
• Involved in Teradata(Nexus)Query which is used for automation process.
• Client interaction on Daily basis
• Giving production support as well of existing products (SSIS and SSRS)

created customwer quality service project for dell customers using ssis.

Liaise with business subject matter experts in analyzing business requirements and translating them
into detailed conceptual data models, process models, logical models, physical models and schema
development in the database.
 24x7 Support for Cassandra related issues.
 Map source system data elements to target system and develop, test, and support extraction,
transformation and load processes.
 Based on business rules, load Insurance related data, develop SSIS Packages using best performance
techniques to load into DW.
 Defines and captures metadata and rules associated with ETL processes.
 Creating SSRS Reports (Medium and complex) and SSRS (MDX Reports)as well. Creating SSIS
Jobs(Packages) and Scheduling.
 Assigning Roles in SSAS Cube
 Monitoring Jobs in SQL Server.

Worked on Data Conversion Project using Python and MySQL.. Used Docker to run the containers containing the Python Code and efficiently used Git for Repositories for Data Transformation and Data Conversion tools used in the Project backed by AWS.

Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc. Maintaining archive data on appropriate storage devices. Tracing, troubleshooting with database performance and tuning issues. Export/Import of oracle databases. Automated hot backups using a combination of incremental, differential and full RMAN backup. Transportation of Data from OLTP to Datawarehouse Making Reports using SSRS 2005 Creating Stored Procedures, Indexes on Datawarehouse Tables Normalized the Tables Extensively used the ETL Design skills for aggregations, lookups, transformations and expressions. Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services 2005/2008(SSIS). Remarkable experience in designing ETL processes and developing source to target mappings Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

Involved in requirement gathering for Sales Data Mart Mainly Involved in ETL developing. Source data analysis – SQL server, Oracle and Flat Files. Extracting data from Different sources and loading into the staging table. I extensively worked with source analyzer, target designer, transformation developer and mapping and mapplet designer Created Mappings using various transformations Performed unit testing at various levels of the ETL. Involved in Creating sessions and workflows, and scheduling to load the data into the targets. Experience on handling slowly changing dimensions to maintain complete history.