About Me
I am Sr Technology consultant having more than 10 years of experience. I am having core experience in SQL Server,ETL Tool(SSIS),SSRS and SSAS. I also worked omn AWS Redshift, Athena,AWS Glue. Also worked on ADF(Azure Data Factory) . Worked on va...
Show MoreSkills
Database
Programming Language
Web Development
Others
Positions
Portfolio Projects
Company
DMR (Data Management and Reporting)
Role
Project Manager (Team Lead)
Description
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.
Tools
Visual Studio 2015 SQLSMSCompany
CRS Reporting for Dell Customers
Role
Project Manager (Team Lead)
Description
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)
Tools
SSDTCompany
Managed Print Services
Role
Project Manager (Team Lead)
Description
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.