SURYA TEJA BHIMAVARAPU

Email: ad0wpc@r.postjobfree.com / Contact: 647-***-****

Scarborough, ON.

Diligent Data professional with 3 years of proven IT experience specializing in Database Design, Analysis, Report, Support of MS SQL Servers 2016/2014/2012 in Development, Testing and Production Environments with various business domains. Seeking an opportunity to leverage my diverse skills and experience and also furnish insights, analytics and business intelligence.

Technical Skills

Operating System: Windows, Unix.

Tools: Microsoft Office, SVN, Azure TFS, TFS, Octopus, Team City, Share point, MS Outlook, Tidal, Microsoft Service Now.

Reporting: SSRS, Power BI, Tableau.

Languages: HTML, T-SQL, PL/SQL, UNIX

SQL Server Tools: SQL Server Management Studio, SSIS, SSRS, SSAS

Database: MS SQL Server 2017, 2016, 2012, Oracle

•Working with the programming team, for optimal SQL Server behavior using query tuning and lock checking.

•Expertise in scripting T-SQL queries, Complex Stored Procedures, Functions, Database Triggers, using tools like SQL Profiler.

•Used Sub-Queries and Joins to simplify complex queries involving multiple tables.

•Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, constraints.

•Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.

•Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.

•Experience in designing, configuring, deploying SSIS packages and providing security for packages.

•Implemented incremental Load for many SSIS packages.

•Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.

•Design/Setup & support HADR environments using Clustering, Mirroring & AG technologies, creating scripts for DR Drills and performing POC for SQL Server 2016/2014/2012/2008 R2 environments.

•Consolidated 3 major business environments into one environment and implemented AlwaysOn Availability groups for HADR using SQL Server 2016/201/2012 Enterprise Edition.

•Implemented and designed compression/continuing compression strategy.

•Experience in Error handling, Debugging, error logging for production support in SSIS.

•Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

•Hands on experience in building queries to retrieve data into Tableau from SQL Server and Oracle server.

•Performed Logging and Deployment of various packages in SSIS.

•Experienced in enhancing and deploying the SSIS Packages from development server to production server.

•Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.

•Designed different visualizations in Power BI according to the requirements.

•Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.

•Expertise gathering functional specification requirements for the development of dashboards and reports.

•Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

•A team player with excellent interpersonal, communication and presentation skills.

Currently working with Intact Insurance May 2022 till date

Role: Business Intelligence

Responsibilities:

•Involved in implementation and designing of the compression/continuing compression strategy.

•Using query tuning and lock checking, collectively worked with the programming team for optimal SQL server behavior.

•Implemented design setup and also supported HADR environments by using clustering, mirroring & AG Technologies.

•Collected business requirements from users and translated them as technical specifications and design documents for development.

•Analyzed data and designed the logical and physical models for all projects.

•Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.

•Involved in script creation for DR drills and performing POC for SQL server 2016/2014/2012/2008, R2 environments.

•Accumulated 3 business environments into single environment, implemented Alwayson Availability groups for HADR using SQL server 2016/2014/2012 Enterprise edition.

•Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.

•Participated in the design and development of the Data Warehouse.

•Designed SSIS packages for Installment loan POS integration, HI score card, Footwear Restocking, Shopping Recap – IR labs Projects.

•Migrated store Promo Tracker SSRS Reports to Tableau.

•Collect requirements for different executive dashboards, analysis and model flows from various sources to integrate into Tableau Dashboard

•Provide drill down capabilities by setting up the hierarchies and Action filters in tableau to help the users to dig deeper.

•Experience in Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes.

•Removed Security Vulnerabilities from Multiples Machines on both On Premise and Azure by consistently applying patches and hot fixes

•Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.

•Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.

•Export tableau dashboards to server with group level and user level privileges.

•Automated existing store Promo Tracker stored procedures to SSIS Packages using different transformations and SQL Server Agent Jobs.

•Designed History tables to capture name changes, location changes for understanding user behavior and 1099 reporting.

•Created checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS Packages.

•Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.

•Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper Indexes using SQL Profiler and Database Tuning Advisor.

•Created SSRS reports such as tabular, matrix, charts, dash-board and sub-reports using SSRS R2.

•Developed stored procedures, cascading parameters and custom code for developing complex SSRS reports.

•Created SSRS dashboards using charts, gauges, indicators and data bars.

•Created standard and data driven subscriptions for weekly, monthly and daily reports.

•Participated in code-review sessions on existing SSRS report's performance and Dataset query tuning.

•Created script tasks and components with C# and VB.NET in SSIS as part of ETL load.

Environment: SQL Server, SQL Server Data Tools (SSIS/SSRS/SSAS), SharePoint, T-SQL, OLAP, Report Builder 3.0, Business Objects, Erwin 4.0

Vasco scientific Pvt Ltd, Hyderabad, India from June 2019 – Feb 2021

Role: Business Intelligence

Responsibilities:

•Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.

•Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

•Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

•Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.

•Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.

•Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

•Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.

•Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

•Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.

•Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.

•Integrated Custom Visuals based on business requirements using Power BI desktop.

•Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

•Deployed SSRS reports in native and SharePoint mode.

•Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.

•Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio, Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Power BI Desktop, Power BI Service.

•Assisted manager in helping healthcare facilities migrate to cloud backup program, increased data security

•Developed new IT request funnel, increased efficiency across departments.

•Developed and maintaining different kinds of reports like Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS.

•Developed complex calculated measures using Data Analysis Expression language (DAX).

•PG Diploma : In Mobile Solutions Development year 2021-2022 from Conestoga College, Waterloo,Canada.

•Bachelor’s Degree: B. Tech in Electronics and Communications Engineering from International Institute of Information Technology (IIIT)-AP 2015-2019.

Personal Information

First Name: Surya Teja

Last Name: Bhimavarapu

DOB: 20th September,1997.

Hobbies: Exploring new places, Hiking, Listening Music.

Current Address: 19 Centre Street, Scarborough ON M1J 3B4

Current status: Work Permit

Contact this candidate