Uploaded File
add photo
Akhila
akhilavarma1411@gmail.com
425-273-8693
212 Hidden Valley Dr.
Edison, NJ 08817
425-247-1439
SQL Server BI Developer
12 years experience W2
1
Recommendation
Average rating
134
Profile views
Summary

Experience
SQL Server BI Developer
Information Technology
May 2016 - present
Westfield Center, OH
  • Developed SQL Server 2014 Databases objects i.e., Schemas, Tables, Indexes, Stored procedures and Views.
  • Written complex SQL statements using joins, sub queries and correlated sub queries and Query expression
  • Extracted data from various sources like SQL Server 2014, Oracle 11g, IBM DB2, Flat files, XML and Web services from Client servers and through FTP.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column and developed packages in SSIS with error handling.
  • Created Package Configurations to deploy packages from development to production server.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Involved in daily code drops and archives on the production databases during maintenance windows.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
  • Designed OLAP model based on Dimension and Fact tables for efficient loads of data which were based on Star Schema structure.
  • Developed Tablix Reports, Tabular Reports, Matrix Reports, drill down Reports, matrix and drill through reports and Charts using SQL Server Reporting Services (SSRS).
  • Provided support to database Servers in Production, QA and Development.
  • 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.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Environment: MS SQL Server 2016/2014, SQL Server Data tools (SSIS, SSRS), T-SQL, C#, Share Point Portal Server, TFS (2012), Oracle 11g, IBM DB2 9.5.1, Visual Studio 2012.
C# SQL XML Visual Studio Stored Procedure DB2 SQL Server Oracle ETL SSIS Database Backups T-SQL MS TFS WebServices Tableau BI Developer Quality Assurance Tableau Desktop Tableau Server Database Design MS SharePoint Windows FTP
Remove Skill
References
Average Rating

1 recommendation
SQL Server Business Intelligence (BI) Developer
Information Technology
Feb 2015 - Apr 2016
  • Involved in Full Development Life Cycle starting from requirements gathering & impact analysis to proper functional and technical testing of the reports and user sign offs and maintaining technical design documents, traceability Matrix and assisting users in developing new reports.
  • Involved in Data Analysis in consideration with Business Logic.
  • Created and scheduled reports / dashboards.
  • Involved in Developing 35+ Enterprise SSRS reports for various Business functionalities.
  • Configured and Deployed+ the Reports (RDL) across various SDLC environments.
  • Involved in collecting requirements from the User Community, Scope out work and Timelines and development of Reports accordingly.
  • Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
  • Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Good at interpreting and discovering patterns in data using visualization tools such as Tableau and python's matplotlib.
  • Knowledge of Tableau JavaScript API to customize designs, interactions, behaviours.
  • Created Cubes on SQL Server Analysis Services as an alternative prototype to an existing relational data mart.
  • Thorough understanding of Data Warehousing / Multi-Dimensional Analysis concepts like Star Schema, Snow Flake Schema, OLAP.
  • Worked with various Reports involving Data driven Subscriptions, Scorecards, KPIs and Dashboards.
  • Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports.
  • Involved in various Transformations in SSIS Dataflow, Control Flow using For Loop Containers etc.
  • Implemented Event Handlers & Error Handling in SSIS packages & notified process results to various user communities.
  • Environment: Windows Server 2012, MSSQLServer2012, SQL Server Analysis Services (SSAS), Tableau, Reporting Services (SSRS 2012/2008), Microsoft Visual Studio 2010, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), .Net, Visual Source Safe (VSS), Web Services, WSDL, MDX
.NET Python SQL Visual Studio Data Analysis Data Warehousing SQL Server SDLC JavaScript SSIS SSRS Business Intelligence Data Visualization Requirements Gathering WebServices Tableau Tableau Desktop Data Marts Ruby on Rails WSDL Windows Server Database Design Windows
Remove Skill
SQL Server BI Developer
Information Technology
Oct 2013 - Jan 2015
  • Worked at conceptual/logical/physical data model level using Erwin per requirements.
  • Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
  • Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
  • Designed Data flows, workflows and jobs to load data from source to target.
  • Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
  • Developed Aggregations, Partitions and calculated members for Cube as per Business requirements.
  • Extensively used T-SQL in constructing User Defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
  • Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
  • Supported system development efforts including database analysis, design, performance tuning and migrations.
  • Built enterprise wide ETL solution using Informatica & SSIS.
  • Used System Tables, System stored procedure, DBCC commands for Database Maintenance.
  • Worked with Technical Architects and Database analysts for Design of summary tables required for efficient design.
  • Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
  • Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
  • Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Informatica, XML, SYBASE, MS Visual Source Safe, DB2 and Windows Server 2003/2008/2012.
SQL XML Informatica Data Analysis Stored Procedure DB2 SQL Server Erwin Data Modler Data Mapping ETL SSIS SSAS T-SQL Business Intelligence Windows Server Data Governance BI Developer Project Management Data Integrity Data Mining Data Dictionary Database Design DBA OLTP Performance Tuning Windows
Remove Skill
BI Developer
Information Technology
Mar 2012 - Sep 2013
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and data integrity.
  • Developed TSQL Code, including use of complicated joins and cursor loops.
  • Involved in managing data sources from other sources to SQL Server.
  • Designed and deployed various complex reports using MS Reporting Services.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS).
  • Created and generated reports to display data.
  • Used Query Profiler to optimize SQL queries.
  • Managed Clustered environment databases and involved in debugging and resolving issues.
  • Involved in execution and creation of SSIS packages using Business Intelligence Development Studio.
  • Involved in Deployment and Administration on SSIS packages.
  • Performed ETL operations to support the data loads and transformations.
  • Developed and designed DTS packages for importing the data from MS Access and MS Excel.
  • Developed and executed several optimized queries in SQL.
  • Setup and installation of databases including test, development environments.
  • Involved in DBA activities such as Backup, Recovery, Performance tuning and User administration.
  • Developed highly scalable report automation system utilizing SSIS, T-SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
  • Handled Change Requests and provided estimations for change requests.
  • Fine tuning of database objects and server to ensure efficient data retrieval.
  • Involved in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
  • Extensive experience in analyzing business requirements and created Technical Specification document.
  • Understanding the requirements from Technical Specification Design and provided the impact analysis for existing modules enhancement.
  • Created High Level Design documents and Solution Specific Design documents for multiple projects.
  • Design and Developed code as per business requirements and executed unit test cases.
  • Coordinated with project team to analyze the problems reported and to determine the corrective action by discussing with QA / product management group.
  • Documented issues reported in various phases of testing and proactively worked on code fix to avoid repeated issues in higher environments.
  • Environment: COBOL JCL, VSAM, DB2, REXX, Change man, Control-M, File Manager.
SQL Stored Procedure DB2 SQL Server ETL SSIS SSAS T-SQL Business Intelligence BI Developer Project Management Data Mining Product Management
Remove Skill
BI Developer
Information Technology
Aug 2009 - Feb 2012
  • Designed Database Models, Entity Relationship diagrams using Toad data modeler.
  • Involved in Normalization & De-normalization of database.
  • Created and modified database objects like Table, Views, Store Procedure, Triggers and Functions using T-SQL.
  • Involved in performance Testing and Performance Tuning.
  • Created complex queries by using Joins and Sub Queries.
  • Involved in improving the performance of query by using Query Optimization Techniques.
  • Worked on Clustered and Non-Clustered index to improve the access of data within the database.
  • Maintained the physical database by monitoring Performance, Integrity and Optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
  • Implemented Error Handling in several existing Stored Procedures using Try Catch blocks.
  • Deployed database objects from Development/Testing environment to Production environment.
  • Created Ad-Hoc reports as per client requirement using stored procedure.
  • Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
  • Involved in handling parameterized reports and drilldown reports in SSRS 2008.
  • Involved in designing visual report solutions, including dashboards using SSRS and/or other data visualization/dashboard tools.
  • Worked with Flat Files, OLE DB Source, and Excel Source loading.
  • Developed reports using efficient data retrieval techniques.
  • Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
  • Environment: MS SQL Server 2008, T-SQL, OLAP Service, SQL Server Profiler, SSIS, SSRS, Team Foundation Server (TFS).
SQL TOAD Stored Procedure SQL Server SSIS SSRS T-SQL Data Visualization Triggers BI Developer Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
ETL Developer
2017
1
Stored Procedures
2017
1
SQL
2021
9
SQL Server
2021
9
SSIS
2021
9
BI Developer
2021
7
Stored Procedure
2021
7
T-SQL
2021
7
Windows
2021
7
MDX
2017
1
Database Design
2021
6
Project Management
2015
6
DB2
2021
5
ETL
2021
5
FTP
2021
4
MS SharePoint
2021
4
Tableau Desktop
2021
4
Business Intelligence
2016
3
Data Mining
2015
3
Data Visualization
2016
3
Quality Assurance
2021
3
SSRS
2016
3
Tableau
2021
3
Tableau Server
2021
3
Visual Studio
2021
3
WebServices
2021
3
XML
2021
3
C#
2021
2
Data Analysis
2016
2
Data Dictionary
2015
2
Data Integrity
2015
2
Database Backups
2021
2
DBA
2015
2
MS TFS
2021
2
OLTP
2015
2
Oracle
2021
2
Performance Tuning
2015
2
SSAS
2015
2
TOAD
2012
2
Triggers
2012
2
Windows Server
2016
2
.NET
2016
1
Data Governance
2015
1
Data Mapping
2015
1
Data Marts
2016
1
Data Warehousing
2016
1
Erwin Data Modler
2015
1
Informatica
2015
1
JavaScript
2016
1
Product Management
2013
1
Python
2016
1
Requirements Gathering
2016
1
Ruby on Rails
2016
1
SDLC
2016
1
WSDL
2016
1