Venkanna G.

Venkanna G.

SQL , MSBI, Oracle, PostGreSQL, SQL Server, Power BI

Hyderabad , India

Experience: 8 Years

Venkanna

Hyderabad , India

SQL , MSBI, Oracle, PostGreSQL, SQL Server, Power BI

30000 USD / Year

  • Immediate: Available

8 Years

Now you can Instantly Chat with Venkanna!

About Me

Professional Summary:

  • 8.5 Years of experience in IT as a motivated and result-driven BI Lead Developer with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data analytics...
  • Have very good experience in both Agile and Waterfall project development models.
  • Have excellent skills in Data Warehouse, Relational (SQL Server, PostgreSQL, Oracle and MySQL) and Multi-Dimensional database, Data Migration, System & Data Integration, Reporting, Analysis and Data Management.
  • Experienced in developing, implementing, documenting, monitoring and maintain the data warehouse extracts, Transformations and ETL process in various industries like Insurance, Finance, Health Care and Banking etc.
  • Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment.
  • Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data Source and Data Source Views and Star and Snow Flake schema) using SQL Server 2008 and 2012 Analysis Services (SSAS).
  • Experience in SQL Server Analysis Services (SSAS) development. Expert level skills in designing, processing and partitioning cubes, Aggregations, KPI’s, Measures, Calculations, Actions, Translations and Perspectives
  • Experience in creating hierarchy on dimensions and having experience in creating new dynamic calculated members, key columns, name columns and value columns.
  • Worked extensively in designing, deploying and maintaining cubes in the data warehouse.
  • Experience in Performance tuning, SQL Profiler, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
  • Experience in MS-SQL Server Development and Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing, backup/recovery strategies and Performance tuning.
  • Excellent backend skills in Creating Objects like Table, Stored Procedure, Packages, Views, Materialized views, Indexes, Triggers, Temporary Tables, CTE and Functions T-SQL and PL/SQL.
  • Highly experienced in performance tuning for both SQL server and Oracle RDBMS by understanding Code, Database and server level internals.
  • Worked on the Power BI reports & dashboards with Heterogeneous Sources.
  • Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
  • Published/shared the reports by creating Content Pack/Sharing the pbix file.
  • Effective communication skills and ability to work in a team and individually.

Show More

Skills

Portfolio Projects

NextGen Project Estimate Engine

Company

NextGen Project Estimate Engine

Role

Backend Developer

Description

  • Coordinating with functional team and business analysts to discuss on application flows.
  • Examine and identify database structural necessities by evaluating operations, applications
  • Design and implement effective database solutions and models to store and retrieve Project data.
  • Prepare accurate database design and architecture reports for Leadership and executive teams.
  • Educate team members through training and individual support.

 

Show More Show Less

Tools

Power BI

Altus GTS Inc

Company

Altus GTS Inc

Role

Backend Developer

Description

  • Model staging and pre-sync tables
  • Perform data cleansing and consolidation activities on the staged data
  • Integrate source to destination mapping in the packages based on the BRD
  • Created data workflow patterns for both full and delta loads.
  • Unit test the workflows on the DEV and provide support for QA and UAT phases

Show More Show Less

AmeriHealth

Company

AmeriHealth

Role

Backend Developer

Description

  • Assess BRD and provide estimation on the tasks to deliver.
  • Design the SSIS framework for extracting data from multiple source like (csv, xml, Oracle, SQL Server).
  • Create complex stored procedures to load data in to Dimensions and Fact tables in Data mart.
  • Manage all indexing, debugging, optimization and performance tuning using T-SQL.
  • Deploy and configure the SSIS flows in to various servers and documenting the process.
  • Schedule the SSIS packages and stored procedures to perform delta load in Dimension and fact tables by creating a Job using SQL Agent in SSMS.

Show More Show Less

DIAmonde Data Mart

Company

DIAmonde Data Mart

Role

Backend Developer

Description

  • Gathering all requirements from Business Analysts and documented entire process of Data Flow and Data Analysis process from all the source systems.
  • Created SQL server objects like Tables, Stored Procedure, Views, and Indexes to facilitate efficient data manipulation and data consistency.
  • Managed all indexing, debugging, optimization and performance tuning using T-SQL.
  • Created SSIS Packages to transfer data from various Sources like SQL Server, Text File, and Excel using SSDT 2012/2014.
  • Created Centralized Data Mart and developed De-Normalized Structure based on requirement.
  • Created ETL design Specifications, Performed Unit Testing, Data Validation and Integration testing.
  • Worked with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Loop Containers, Execute SQL Task and lot more using SSIS.
  • Deploying SSIS Packages On respective Server and effectively using configuration files.
  • Created custom loggings and package configurations to change connection strings and variables dynamically. Used all types of Containers in SSIS.
  • Designed, processed and partitioned cubes using SSAS. Pleasant experience in designing aggregations and Calculations.  Experience in deploying SSAS objects using deployment wizard.
  • Created and maintained Measures, Actions, KPI's, Perspectives and MDX Queries.
  • Adding new dimensions, Calculating members, roles and KPI's to existing Cubes.
  • Created Windows Schedule tasks to run SSIS Packages on different time intervals by using Power Shell Scripts.
  • Involved in fixing Bugs in the Data Mart and ETL.
  • Involved in documenting the project steps and presenting to the team members.

Show More Show Less