About Me
· Working in Agile methodologies and conducting standup meetings and collate deliverables.
· Experience in Business Intelligence, Banking, Sales & Marketing,
· Strong knowledge on SSIS/S...
· Strong knowledge on SSIS/SSRS
· Involved in Preparing POC in Power Bi.
· Extensive knowledge on Tableau installation, maintenance of Tableau Servers on distributed environments.
· Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation
· Creating Workbooks by Importing data, Defining Relationships.
· Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
· Created Bar Charts, water fall charts, Heat Maps, And Geographical Maps.
· Strong knowledge on software development life cycle (SDLC).
· Strong Experience OLAP and Reporting like Tableau.
· Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
· Created Derived Columns to fulfil the User Requirements.
· Created Parameters to reports be more User friendly to End Users.
· Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.
· Added Base lines, Trend Lines, Quick &Table Calculations, and Annotation’s.
· Connecting multiple data source with Data Blending technique.
· Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.
· Providing the Security while Publishing to the Tableau Server.
· Involved in design phase of BI projects.
· Strong business and application analysis skills with excellent communication and professional skills.
· Experience in analysis of source systems, defining underlying data sources and
transformation requirements, design suitable data model
· Experience in interacting and requirement gathering from IT division on client side.
· Experience in conducting knowledge sharing sessions within company environment.
· Involved in design phase of BI projects.
· Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.
· Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.
Show MoreSkills
Data & Analytics
Database
Programming Language
Others
Portfolio Projects
Company
DMS SALES
Contribute
Only one for entire Technology working whole for ETL & DASHBOARD DEVELOPMENT
Description
· Working in Agile methodologies and conducting standup meetings and collate deliverables.
· Experience in Business Intelligence, Banking, Sales & Marketing,
· Strong knowledge on SSIS/SSRS
· Involved in Preparing POC in Power Bi.
· Extensive knowledge on Tableau installation, maintenance of Tableau Servers on distributed environments.
· Worked on different phases of data visualization development lifecycle, from gathering requirements to testing and implementation
· Creating Workbooks by Importing data, Defining Relationships.
· Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
· Created Bar Charts, water fall charts, Heat Maps, And Geographical Maps.
· Strong knowledge on software development life cycle (SDLC).
· Strong Experience OLAP and Reporting like Tableau.
· Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
· Created Derived Columns to fulfil the User Requirements.
· Created Parameters to reports be more User friendly to End Users.
· Created Dynamic, Static Dashboards with Global Filters, Context Filters, Action Links.
· Added Base lines, Trend Lines, Quick &Table Calculations, and Annotation’s.
· Connecting multiple data source with Data Blending technique.
· Formatting the Data by using Legends, Marks, Colours, Sizes, and Shapes.
· Providing the Security while Publishing to the Tableau Server.
· Involved in design phase of BI projects.
· Strong business and application analysis skills with excellent communication and professional skills.
· Experience in analysis of source systems, defining underlying data sources and
transformation requirements, design suitable data model
· Experience in interacting and requirement gathering from IT division on client side.
· Experience in conducting knowledge sharing sessions within company environment.
· Involved in design phase of BI projects.
· Creating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.
· Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.
Show More Show LessSkills
SQLTools
MS SQL Server TableauCompany
Project Name: IPPM (Integrated Production Performance Management)
Role
Backend Developer
Contribute
Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS Solution design and implementation Working on Data Analytics Creation of ETL jobs Testing of ETL jobs
Description
Ø Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
Ø Solution design and implementation
Ø Working on Data Analytics
Ø Creation of ETL jobs
Ø Testing of ETL jobs
Ø Working on and creating ETL packages to load the data
Ø Designing and implementing of ETL Transformations with SSIS.
Ø Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution.
Ø Integration and Analysis of data.
Ø Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.
Ø The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
Ø Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.
Ø Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS
Ø Solution design and implementation
Ø Working on Data Analytics
Ø Creation of ETL jobs
Ø Testing of ETL jobs
Ø Working on and creating ETL packages to load the data
Ø Designing and implementing of ETL Transformations with SSIS.
Ø Review test scenarios for UT, SIT,UAT and Production and Support team on defect analysis and resolution.
Ø Integration and Analysis of data.
Ø Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transform and finally load into the Target Tables.
Ø The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
Ø Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.
Show More Show Less
Skills
SQLTools
TableauCompany
Project Name: CIT LOANHUB
Description
Ø Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Ø Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Ø Created action filters, parameters and calculated sets for preparing dashboards and Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
Ø Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
Ø Integration and Analysis of data.
Ø Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
Show More Show LessSkills
SQLTools
Tableau