We provide IT Staff Augmentation Services!

Junior Consultant Resume

SUMMARY:

  • Having 4+ years of Professional experience in business intelligence and Data warehousing in that 2+ on Informatica and 2 years of experience in MSBI. Worked on MSBI projects with extensive usage of ETL tools SQL Server Integration Services (SSIS) and reporting using data visualization tools like Power BI .
  • Very Good Understanding and Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Experienced in creating in creating Databases, Tables and Stored Procedures using T - SQL.
  • Excellent knowledge and proficient in using SQL Server Integration Services (SSIS) to build Data Integration Solutions, Extract, Transform and Load (ETL) solutions for Data base applications
  • Worked with Control Flow items- Dataflow Task, Execute SQL Task, Script Task, File System Task, And Containers - For Each Loop and Sequence containers.
  • Worked with different types of dataflow transformations like Derived Column, Data Conversion, Lookup and Conditional Split, Aggregate etc.
  • Experience in deployment and scheduling of SSIS package through SQL jobs in SQL Server SQL Server 2008R2, 2017.
  • Proficiency in data warehousing concepts, design and implementation.
  • Good Knowledge in developing OLAP Cubes using SSAS, Ability to create cubes using dimensions and fact tables, Good knowledge in creating calculations, KPIs and Partitions using SSAS, Ability to generating reports using MDX Queries from Cubes, Good knowledge in creating data sources and data source views and dimensions in SSAS, Implemented Cube Security by Using Roles and Dimension.
  • Experience in Power Bi dashboard reports and creating different types of SSRS reports like table, matrix, Chart and list, Drill Down Reports
  • Involved and worked on projects using Power BI
  • Involved in projects with Tableau, Looker and Microstrategy reporting.
  • Imported Different formats of data (flat files) from input Source Systems to Source Analyzer and analyzed their Meta Data to find out Master Tables and Child tables.
  • Constructed different types of reusable complex transformations like Expression and Aggregator, Joiner, etc using Transformation developer.
  • Designed ETL logic for Dimension Tables using SCD type-1 and Type-2.
  • I have developed mappings to do incremental aggregation

TECHNICAL SKILLS:

Operating Systems: Windows XP/2k3, 7, 10

RDBMS : Oracle 10/11g, MS SQL Server

Languages: SQL, C# .Net

ETL: Informatica Power Center 8.x, 9.X, 10,SSIS

Report Tools: SSAS,SSRS, Power BI,Tableau,Looker,Microstrategy

Db Tools: SQL Developer, SSMS

Other Utilities: MS Office products - Excel, Word.

PROFESSIONAL EXPERIENCE:

Confidential

Junior consultant

Environment: SSIS, SQL Server, SSRS

Responsibilities:

  • Involved in data understanding and Requirement gathering.
  • Built the database design and modelled it for fact and dimension tables(Star Schema)
  • Created the staging area and extracted all the required data from Excel source to staging
  • Extracted, transformed and loaded the data from staging to DataMart using SSIS
  • Involved in data modelling using confidential
  • Developed SSRS tabular reports

Confidential

Junior consultant

Environment: Excel, SSIS, SQL Server, Power Bi

Responsibilities:

  • Involved in data understanding and Requirement gathering.
  • Built the database design and modelled it for fact and dimension tables(Star Schema)
  • Created the staging area and extracted all the required data from Excel source to staging
  • Extracted, transformed and loaded the data from staging to DataMart using SSIS
  • Involved in metrics gathering for the reports
  • Involved in data modelling in Power BI for developing the reports
  • Developed Power Bi reports and dashboards
  • Designed Power BI data visualization utilizing donut charts, pie and bar

Confidential

Junior Consultant

Environment: SSIS, SQL Server, Power Bi

Responsibilities:

  • Involved in data understanding and Requirement gathering.
  • Built the database design and modelled it for fact and dimension tables(Star Schema)
  • Created the staging area and extracted all the required data from source tables to staging
  • Extracted, transformed and loaded the data from staging to DataMart using SSIS
  • Created and loaded aggregated tables
  • Deployed the SSIS packages and scheduled them on Sql Server.
  • Involved in metrics gathering for the reports
  • Involved in data modelling in Power BI for developing the reports
  • Developed Power Bi reports and dashboards
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie and bar

Confidential

Junior Developer

Environment: Excel, SSIS, SQL Server, Power Bi

Responsibilities:

  • Extract the data from excel.
  • Transform and load into different Dimensions and Fact tables using SSIS and SQL server
  • Involve in SSAS Tabular cube development.
  • Design Power Bi model
  • Design and build the dashboard

Confidential

Junior Developer

Environment: Excel, Power Bi

Responsibilities:

  • Study the data received in excel.
  • Extract the data to brought into power BI from Excel.
  • Performed basic ETL to transform the data in Power BI.
  • Created the data model in Power Bi.
  • Built dashboards to display the performance of the company in different areas.
  • Used Pie charts, Bar, Column and line graphs.
  • Made use of Slicers to display filters.

Confidential

Junior Developer

Environment: Excel, Power Bi, SSIS, Oracle 11g

Responsibilities:

  • Study the data for Sales, Incentives, Invoice and Reimbursement.
  • Load the data from excels to Oracle using SSIS.
  • Involved in Cube building using SSAS.
  • Document the KPI’s.
  • Involve in dashboards development.

Confidential

Junior Developer

Environment: Informatica Power Center 10.1,Oracle 12C

Responsibilities:

  • Involved in unit testing of all the CRIS mappings using confidential.
  • Debug and resolve data issues that occurred due to the upgrade.
  • Involved in debugging and defect fixing during the SIT phase. validation of mappings
  • Provide support for ANZ Test cycles
  • Provide Fixes for Validations other than source and destination related fix and re-validated
  • Compared Data extracts from both environments and handled defect remediation in Development environment and re-tested the workflows.

Hire Now