Resume

Sign in

Sql Server Data

Location:
Danville, CA
Salary:
90000
Posted:
October 12, 2018

Contact this candidate

Resume:

BHANU AITHEPALLI

PROFESSIONAL SUMMARY:

More than 5 years of experience in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.

Excellent command with MS SQL SERVER 2008 R2/2012/2014.

In-depth knowledge of SQL, SSRS, SSIS, BI suite, Reporting, and Analytics.

Hands on experience with Data Warehousing Concepts.

Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse.

Experience in Database design, Development, Data Modeling, ETL packages using SSIS, SSAS, SSRS, and Stored Procedures using MS SQL Server 2008/2012.

Proficient in implementing all transformations available on the SSIS toolbox.

Excellent in High-Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Flat File, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Implemented and maintained Log Shipping using Clustering as part of Disaster Recovery (DR) program.

Extracted the data from SFDC and loaded to SQL Server.

Experience with the integration of SFDC and Birst.

Creating Clustered and Non-Clustered Indexes to improve the performance of databases.

Expertise in setting up Active/Passive and Active/Active Clusters for High Availability.

Possess extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report authoring, report management, report delivery and report security.

Experience in Database backup and disaster recovery procedures.

Configured Transactional replication on the migrated server.

Well experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer.

Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using tools like SSIS import and export, SSIS packages, and DTS package.

Acted as a Bridge between the IT and the Business team.

Worked with the Business Team to know the potential requirements of the customers.

Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.

Can work in a fast-paced environment, Good team player and can work independently.

Provide 24/7 production support for mission critical systems.

Performance tuning of databases by windows performance monitor and SQL Profiler.

TECHNICAL SKILLS:

SQL Server Tools & Packages: SQL Server Management Studio, Business Intelligent Studio, Query Analyzer, Database Tuning Wizard, SQL Server Agent.

Reporting Tools: SSRS

ETL Tools: SQL Server Integration Services (SSIS)

RDBMS: MSSQL Server 2012/2014/2016, MS Access, MS Excel

BI Tools: MSBI, Power BI and Birst.

PROFESSIONAL EXPERIENCE:

Aruba Networks a Hewlett Packard Enterpsrise, Santa Clara, USA May 2018 to Present

Programmer Analyst

Responsibilities:

Creating user profiles with their relevant security access to the Birst BI Tool.

Granting access to Birst for the Business Team across the Globe to generate reports.

Checking the query log for possible errors when users are unable to generate reports or generated reports do not have the relevant and required data.

Extracted the physical queries from the query logs to SQL Server to check for possible errors, correcting them, and resolving the issues on the back-end side of the BI Tool.

Acted as a Bridge between the IT and the Business team.

Worked with the Business Team to know the potential requirements of the customers.

Worked with the IT Team to provide the requirements of Business Team for better sales.

Extracted the data from SFDC and loaded to SQL Server.

Experience with the integration of SFDC and Birst.

Created Fact and Dimension Tables for viewing the sales forecast for multiple financial years.

Using SQL queries to pull data relevant for customers marketing campaigns.

Building and maintaining SQL scripts, indexes, and complex queries for analysis and extraction.

Preparing data to be loaded into system.

Working on multiple projects at a time.

Restoration Hardware, Corte Madera, CA July 2016 to May 2018

SQL Developer/DBA

Responsibilities:

Understanding the functional specifications and preparing technical specifications.

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Used SSIS jobs for importing data from the flat files that bring the data to the application tables.

Involved in loading data from various file formats (Flat file, Excel) using Oracle loader and SQL Loader.

Strong experience with T-SQL (DDL & DML) in Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models and Creating & Updating tables.

Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

Created various SSIS packages for the ETL functionality of the data and importing data from various tables to the roll-up tables.

Responsible for ETL operation using SQL Server Integration Services and Worked with users in training and support and have experience in incremental data loading.

Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Performed Data Analysis and Reporting by using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, merge, and union all.

Worked on deploying and scheduling Reports using SSRS as well as triggers to generate all daily, weekly, monthly and quarterly Reports.

Working with project team to identify, define, document and communicate the data migration requirements

Proactively monitor the Production Server and optimize stored procedures for better performance, resolving locking conflicts and resource utilization.

Writing T-SQL Scripts for database backup jobs for daily/weekly jobs.

Preparing data migration plans including migration risk, milestones, and quality assurance.

Developing best practices, processes, and standards for effectively carrying out data migration activities.

Monitoring SQL Server performance using a profiler to the performance and deadlock issues.

Expertise in setting up Active/Passive and Active/Active Clusters for High Availability.

Experience in Troubleshooting and documenting root cause analysis.

Capacity planning of databases according to client requirements.

Implemented in-memory OLTP feature in SQL Server 2014.

Yatna Engineering Solutions, India October 2012 to March 2015

SQL Developer

Responsibilities:

Performing various validations to improve the quality of the data.

Involved in the installation of SQL Server 2012 with the latest service packs.

Worked on database capacity planning and space forecasting.

Created tables, indexes, and design constraints.

Created and Maintained Database Maintenance Plans.

Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Migrated Database from SQL Server 2008R2 to 2012 by using side-by-side migration.

Wrote stored procedures for report generation in SQL Server 2008.

Managed and Administered the SQL Server 2008R2/2012 Production and Non-production servers.

Compiled and validated data reinforced and maintained compliance with corporate standards

Creating and modifying Stored Procedures and T-SQL Queries for efficient data retrieval and consumption into the systems.

Worked on very large and complex databases and in a highly transactional environment.

Installation of SQL Server 2012/2008R2 and service packs on Windows Server Clustered environment.

Prepared maintained and modified SQL server installation and configuration documents.



Contact this candidate