Vijay M.

Vijay M.

Senior Consultant

KAULALUMPUR , India

Experience: 7 Years

Vijay

KAULALUMPUR , India

Senior Consultant

102857 USD / Year

  • Immediate: Available

7 Years

Now you can Instantly Chat with Vijay!

About Me

Having 7 years of Professional experience in IT industry, Involved in working on Tableau and in MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS). Working i...

Show More

Portfolio Projects

Description

Working with DMS Systems for the data reconciliation and migrating the data from different others systems to SQL Servers by using ETLs and working with Tableau server for the creation of Dashboards and helping on Maintenance of Data. Working on the daily jobs. Working around with direct Stake holders and gathering the requirements and developing the Tableau Dashboards and ETLs the will be efficient in retrieving the data and scheduling the jobs to acquire the data for the systems and publish the dashboards of tableau and scheduling the tableau dashboards refresh once after the data refresh is done in the source systems.

Show More Show Less

DATABASE & ETL & DASHBOARD DEVELOPER

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 Less

PETRONAS, short for Petroliam Nasional Berhad (National Petroleum, Limited)

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

Description

PETRONAS, short for Petroliam Nasional Berhad (National Petroleum, Limited), is a Malaysian oil and gas company. Im Working on the Project named IPPM (INTEGRATED PRODUCTION PERFORMANCE MANAGEMENT) which integrates the production data to the current data and forecast the future production of oil and gas and will be working on the data retrieving from other systems handling through ETL processing through below roles.

Show More Show Less

 Building, publishing customized interactive reports and dashboards, report sch

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 Less

Description

Commercial Investment Trust and went by the initials of C.I.T. By that time, the company provided financing for wholesale suppliers and producers of consumer goods. The company added automobile financing to its product line in 1916, through an agreement with Studebaker, the first of its kind in the auto industry. During World War I, CIT financed the manufacture of 150 submarine chasers. It also added consumer financing of radios through an agreement with Thomas Edison, Inc. During the Roaring 20s following the war, consumer spending rose dramatically and CIT prospered in its consumer appliance, furniture, and automobile financing groups. In 1924, CIT incorporated in Delaware and listed its stock on the New York Stock Exchange. CIT entered the field of factoring in 1928 and expanded operations into Europe in 1929.

Show More Show Less

Description

Best Buy formed Redline Entertainment, an independent music label and action-sports video distributor. The Project will able to provide the information of business of the client. The system helps in improving the sales of the business of an audio-video, electronic goods all over the geographic locations by providing information of customer details according to sales and the report will be generated and supplied accordingly.

Show More Show Less

Description

TGP for BPO is the internal Client of Accenture Which handles most of all the Bpo clients of Accenture. This project are handled by Avanade which works for all Microsoft technologies in Accenture.

Show More Show Less

Description

The Project will able to provide the information of business of the client. The system helps in improving the sales of the business by providing information of customer details according to the location. As the business of our client is expanding, he wanted to understand better about the business and also to analyze the trend. It enables to perform risk analysis by providing detailed information of the products history.

Show More Show Less