About Me
Ø Experience on SSIS 2012/2014, SSRS 2012/2014, MS SQL Server, Power BI
Ø Worked with various transformations (Lookup, Multicast, Conditional splits, Derived column, Aggregate, Merge, Balanced Data Distributer, Row Count, Sort, Union...
Ø Experience in writing, optimizing T-SQL Objects like stored procedures, Indexes, Views, CTE, Set Operators, Constraints, Functions, Joins.
Ø Experience on handling with different source like SQL Source, Excel, and Flat File.
Ø Hands on experience in creating, deploying, trouble shooting, scheduling and monitoring SSIS Packages.
Ø Creating the reports as per client’s requirements in the form of table, matrix, Chart and list.
Ø Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
Ø Expertise in designing, deploying scheduling and maintaining SSRS reports
Ø Interacting with clients and clarifying their issues.
Ø Excellent communication skills bridging Client Interaction and Team Management.
Ø Strong analytical, problem troubleshooting/solving skills, self-starter.
Ø Creation of SSIS packages with Analysis process tasks to process cubes.
Ø Creation of report subscriptions to send the reports by mails by scheduling the reports.
Ø Experienced in configuring with Error logging and Error handling to redirect error rows and fix the errors in SSIS.
Ø Expert in deploying both SSIS Packages and SSRS Reports.
Ø Good interpersonal communication and an excellent team player.
Ø Good Knowledge on Power BI.
Ø Expert in creating and developing Power BI Dashboards in to rich look
Ø Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
Show MoreSkills
Programming Language
Database
Web Development
Data & Analytics
Operating System
Development Tools
Others
Mobile Apps
Portfolio Projects
Company
Concerto Health Care Project
Role
Frontend Developer
Company
Sales Analysis System
Role
Software Architect
Description
Dillard’s inc. is one of the leading super markets in North America. The project includes zonal wise analysis of sales, margins and annual growth is to be compared in a period of time. The source data for this project comes from sales application system. The target is SQL Server database where the sales data will exists as an integrated data from different sources at enterprise level. Data is extracted from different OLTP source systems, cleansed, transformed and loaded into warehouse.
Show More Show Less