Resume

Sign in

Sql Server Data

Location:
Seattle, Washington, 98101, United States
Salary:
55
Posted:
January 21, 2019

Contact this candidate

Resume:

Krupa Akula

ac789j@r.postjobfree.com

208-***-****

About 6+ years of Industry experience as a SQL BI developer, SQL Server DBA, MSBI developer (SSIS/SSRS/SSAS).

Experience in designing Relational Database models and implementations as per business requirements.

Experience in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using constraints.

Experience in creating databases, tables, complex queries using SQL joins, stored procedures, CTE’s, views and indexes.

Strong knowledge in identifying various dimensions and facts to implement data warehouse architecture.

Experience with Dimensional modeling, like Star Schema, Snowflake Schema.

Created SSIS Packages to Extract, Transform and Load data from various data sources using various SSIS components and various data transformations.

Designed and implemented OLAP cubes and Tabular Models using SSAS and PowerPivot.

Good experience in generating Tabular, Matrix, Drill Through, Parameterized reports and Drill Down reports using SQL Server reporting Services (SSRS) and Crystal Reports

Worked with subscriptions and managing various content using Report Manager

Experience in creating Power BI dashboards/reports

Knowledge of publishing reports to and managing various content from the Power BI Service

Hands on knowledge in creating interactive and dynamics visualizations for dashboards and Stories in Tableau

Knowledge in Cosmos and C#

Knowledge of Azure Data Factory, Azure Data Lake

Knowledge of the Agile Software Development process.

TECHNICAL SKILLS:

Operating System : Windows XP, Windows7, Windows 10

Databases : MS SQL SERVER 2016, MS SQL Server 2014, MS SQL Server 2008R2, MS SQL Server 2008, Oracle 8i, 9i, 10g

GUI Tools/IDE : Toad 8.6, 9.0,SSMS,BIDS, SSDT

Reporting : SQL Server Reporting Services(SSRS), Power BI, Excel 2010,

Excel 2016, Tableau 9.3,10.3, Crystal Reports 9.0/10.0/XI.

Languages : T-SQL, PL/SQL, MDX, DAX,R, Python

Version Control : Visual SourceSafe(VSS)

Scripting : PowerShell, 2.0/3.0/5.0,VB Script, C#.

EDUCATIONAL QUALIFICATIONS:

Bachelor’s Degree in business administration (BBA)

GNIIT Computer Engineering Degree from NIIT-2003

Certificate in Data Science from University of Washington 2017 - 2018

Training:

About 3 months of training experience in Power BI – Nov 2017

Received Training-Upgrade to Microsoft Windows Server 2016- (MCSA)-Mar 2017

Completed MS Premier Workshop Training in Advanced SQL Server Performance Tuning and optimization techniques – 2016

PowerShell Training from MS Premier Workshop -2015

PROFESSIONAL EXPERIENCE

Client: WA State Employment Security Department (ESD)

Enterprise MS SQL Server DBA/BI Consultant Dec 13 – Oct 14

Responsibilities:

Performed daily backups and developed recovery procedures for all the Enterprise Systems at ESD including Go2WS Site,

Creation of new database, planning the location of data, index, and transaction log files on the disks

Migrated the data across different databases and different servers using SSIS, BCP and Import/export tools.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Created and managing Users, Roles and Groups and handling database security.

Performing routine tasks such as disk space check, Consistency checks, looking for slow/long running queries, hung jobs etc

Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also, set up notifications for failure of jobs etc.

Handled the database components of application releases.

Troubleshooted issues with log file full and database size increasing beyond threshold.

Creating a logical & physical diagram of application / database using data modeling tool like Erwin.

Implemented Secure Operation like Backup Policy, Strong Passwords, cross database ownership changing, disabling XP_CMDSHELL etc.

Involved in Capacity Planning, data modeling and Logical/Physical database Design

Provided support to the application developers on the application databases

Developed and deployed stored procedures, created triggers and audits.

Creating and administrating all SQL database objects, logins, users and permissions.

Creating new SQL Server Azure Cloud Services subscriptions.

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

Created and Managed different website setup for ESD Website and JSL Web Site setup, migration, troubleshooting complex issues including SSL certificate management.

Created a new Development & Test environment on Oracle 9i/10g base.

Good Knowledge on RDBMS and Data Warehouse Concepts, OLTP, OLAP.

Worked with other team members to define, test, and implement database security procedures, secure data access methods, and Stored Procedures.

Assisting developers to create and publish reports.

Experience in handling in large (VLDB) including T-SQL coding, Full-text indexing, stored procedures.

Setting up Database Mail profile(s) and configuring database mail to send notifications after job step completion.

Respond quickly and effectively to production & System Test issues and taking responsibility for seeing those issues through resolution

Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.

Providing 24/7 on call support.

Client: Pro Innovation Inc, WA. Mar 12 - Nov 13

MS SQL Server BI Developer

Responsibilities:

Installing, configuring and managing SQL Server 2008 R2 Databases.

Created documentation about the databases.

Involved in Functional, Regression testing.

Created new login and assigned roles and permissions.

Working knowledge in Active directory user & groups.

Resolved blocking and locking issues in production databases.

Monitored several database’s using SQL Server Spot light tool.

Client: Harper College, IL.

SQL Server DBA /Crystal Reports Developer Sep 10 – Sep 11

Worked on SQL Server 2008 migration from SQL Server 2005

Performed Backup and Recovery for various environments.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Trouble shooting Problems by using SQL server profiler and tuning them if required.

Automated administrative tasks designed and modified Data Transformation Services (DTS/SSIS) packages.

Client: CAPs, IL Sep 09 - Aug 10

SQL Server Developer

Responsibilities:

Migrated Access2000 data to SQL Server using SQL Server Migration Assistant (SSMA) for SQL Server.

Designed Data Flow Diagrams and Entity Relationship Diagrams using Erwin

Worked with business stakeholders, application production teams across functional Units to identify business needs and discuss solution options.

Using the Erwin data modeling tool, reverse engineer a physical ERD from a Production database.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Perform quality assurance and testing of SQL server environment. Designed and developed Access database objects (Forms, Queries, Reports, and VBA code in Access2000 as a client application.

Created SSIS Packages to transfer data (ETL) from various sources like Excel, Access to SQL Modifying reports generated by application on Monthly, and Quarterly & Yearly Data from Caps Databases.

Client: Murphy Oil, AR. Mar 08 – Aug 09 SQL Server DBA

Responsibilities:

Provided SQL Server support to development, test, QA and production environments.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Migrated DTS packages to SSIS packages.

Created SSIS Packages to transfer data (ETL) from various sources like Text Files, XML Files, SQL Server, Excel, Access to SQL Server.

Administered high-traffic web hosting and SQL Server customer database for Fortune 1000 retailer.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.



Contact this candidate