Data Developer

VenkataBalaji Neelam Phone : 612-***-****

SQL BI Developer Email : *********@*****.***

Tata Consultancy Services Ltd

Minneapolis, MN

Having more than 7 years of IT experience as Team member and Module Lead in Application Development & Support using Oracle & Microsoft SQL, PL/SQL, UNIX, Microsoft BI Tools (SSIS, SSAS and SSRS), Tableau Desktop and Tableau Server

Experience in the IT industry with a strong background in analysis, design and development in the field of data warehousing, business intelligence, data modeling and implementation of Tableau Desktop 10.1,9.2, 9.1, 8.1, 8.0 and Tableau Server

Well versed in creating visually compelling worksheets and dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gantt charts

In-depth knowledge and experience in using Tableau Desktop to analyze and obtain insights into large data sets using groups, bins, hierarchies, sorts, sets and filters

Experience in creating interactive dashboards with appropriate dashboard level components such as action filters, quick filters, maps, parameters and used table level calculations to improve visualization of Tableau in terms of performance

Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).

Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.

Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.

Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL and Teradata, gathering and manipulating data from various sources.

Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, Joins, triggers, clustering, T-SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.

Involved in writing T-SQL stored procedures, views, triggers, cursors.

Created tables, views, users, logins, indexes (indices), check constraints, and business rules using T-SQL and maintained databases.

Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005, SQL 2008R2 and SQL 2012.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations

Strong experience in combining data sources, such as excel files, text files, Microsoft SQL Server, etc, by joining multiple tables and using data blending technique

Hands-on experience in creating and modifying worksheets and data visualization dashboards in Tableau

Knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in oracle.

Responsible for writing SQL Queries, Dynamic queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User defined Functions, Views and Cursors.

Experienced in Data Profiling, tuning long running SQL queries for better performance.

Excellent Analytical, interpersonal and communication skills. And ability to learn quickly to new technologies and methods in a short period

Work Experience

SQL & Tableau Developer

Client: CenturyLink Inc., Minneapolis, MN

Project: Cupic Applications January 2015 to Present

Description:

CenturyLink is the third largest telecommunications company in the United States. The company provides broadband, voice and wireless services to consumers and businesses across the country. It also offers advanced entertainment services under the CenturyLink™ Prism™ TV and DIRECTV brands. In addition, the company provides data, voice and managed services to business, government and wholesale customers in local, national and select international markets through its high-quality advanced fiber optic network and multiple data centers.

Responsibilities:

Interacted with business users to know their business requirements in developing and modifying reports

Created pie and bar charts and combining dashboards to demonstrate high health risk areas

Used components like action filters, quick filters, groups, bins, hierarchies, sorts, sets, maps, parameters and table level calculations to improve visualization

Improved performance in dashboards by implementing global, local and context filters

Created data extracts for better performance using custom SQLs

Created views with different axis like individual axis, blended axis and dual axis for to view members according to products and date

Provided dynamic selections of measures and dimensions in visualization by creating parameters and calculated fields

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard

Built Stories in Tableau with various data points to narrate the data to the end users

Designed and developed various analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop

Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes

Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau Desktop.

Created Aggregations, calculated fields, table calculations, totals, percentages using Key Performance Measures (KPI) and measure

Administered user, user groups, and scheduled instances for reports in Tableau

Created various SSIS packages for data migration which processes multiple flat files coming from utility server and loads into different database tables.

Used various transformations in SSIS packages to modify the data from the source.

Created reports with Selection Criteria, Grouping, Sub reports, Cross tabs, Standard and Summary.

Documented report parameters, fields, and logic used for developing of reports in a word document.

Created custom reports and data sets for reports using global variables, expressions and functions in SSRS.

Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.

Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.

Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2012.

Designed and implemented parameterized and cascading parameterized reports using SSRS.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Expert in Data Conversion, Add-hoc reporting, Data Analysis and validation.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Fine tune stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features to reduce the query execution times.

Developed back end procedures to show data in a Billing GUI based on the customer using Object Types and Ref Cursors.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

SQL BI Developer

Client: CenturyLink Inc., Chennai, Tamil Nadu, India

Project: NIC Layer 2/3 Data Cleanup Project April 2013 to December 2014

Network Reliability Operation Center (NROC) takes care of the provisioning and service activation also controls network element in the provisioning of the CenturyLink systems.

Network Inventory Consolidation (NIC) is a large multi-year program to bring Layer 1-3 inventories into an end-state of Trunk Integrated Record Keeping system - TIRKS (L1) and Cramer (L2/3) applications. The goal is to track at the highest level with key scope and objectives defined within the project.

Responsibilities:

•Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

•Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

•Performed Database backups (operating system, flat file backups & export/import). Tuned SQL statements (e.g.: - Using Indexes) and PL/SQL Procedures.

•Used Query Analyzer to optimize SQL Queries.

•Performed SQL code review on new procedures and report queries created by consulting team.

•Used performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.

•Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).

•Troubleshooted and resolved the issues with existing ETL process.

•Provided documentation for the new SSIS packages and procedures.

•Worked on Development and implementation of SSRS reports and ran them as per the requirement.

•Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements. .

•Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently

•Published Workbooks by creating user filters so that only appropriate teams can view it.

•Used Spread sheet, flat files, CSV files to generated Tableau adhoc reports.

•Generated context filters and used performance actions while handling huge volume of data.

•Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

•Developed donut charts for analyzing sales planning data.

•Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions

SQL BI Developer

Client: CenturyLink Inc., Chennai, Tamil Nadu, India

Project: ISYS Applications August 2011 to March 2013

Isys Application is used in provisioning of Digital Subscriber Line (DSL) / Internet Protocol Television (IPTV) Service in Telecommunications

Responsibilities:

Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Drill through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.

Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Worked on database procedures and scheduled them using shell scripts for business needs

Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.

Created and developed database objects such as tables, indexes, views, stored procedures, User Defined Functions (UDFs), triggers, and T-SQL code with proper grants to all the users and roles using SSMS 2008.

Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.

Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction

Prepared functional specifications for user requirements.

Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.

Developed and modified applications, authored database procedures and triggers for data processing

Created entry forms/reports for various modules.

Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.

Involved in creation of schema objects, roles and privileges, users.

Developed sample Insurance applications based on C#, ASP Technologies

As a learner involved in getting the Business and Domain Knowledge

Got knowledge of developing XML, CSS and JavaScript Applications

Developed sample Insurance applications based on C#, ASP Technologies

Involved in Trouble shooting and Performance improvement of SSRS Reports.

Created OLAP cubes and dimensions for the analysis using SSAS.

Created Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes

Education

Bapatla Engineering College

Bapatla, Guntur

Andhra Pradesh - 522100

India

B.Tech in Information Technology, 2007-2011

Certifications

Oracle PLSQL Developer

Technical Skills

Operating Systems: Windows 7/8/10, Windows Vista and UNIX

Languages: SQL, PL/SQL, Oracle forms, HTML, CSS, JavaScript and Basics of C#

Databases: Oracle MS SQL Server 2005, 2008 & 2012

Domain: Telecommunications

Tools & Utilities: Toad, SQL Developer, Oracle's SQL*Loader, SSDT, BIDS, SSMS, Tableau Desktop & Server

Immigration & Work Status

Work Visa Holder H1-B

United States

Valid up to August 2020

Contact this candidate