Post Job Free
Sign in

SQL Developer

Location:
DeKalb, IL
Salary:
70000
Posted:
October 20, 2020

Contact this candidate

Resume:

Yaswanth Ankamreddi

815-***-****

******************@*****.***

T-SQL development professional with strong verbal and written communication skills and solid analytical skills for writing relational database solutions for businesses. A self-starter who is able to work independently or lead a team to a collaborative solution. EXPERIENCE

• Genpact (03/2014 - 06/2016)

• Integra Technologies LLC (06/2018- 10/2018)

• Von Maur (10/2018 – Present)

PROJECTS PROFILE

Role – Data Analyst

Oct 2018 – Present

Company: - Von Maur

• Created Various Promotions by extracting Data (SKU list) from Excel. Created stored procedures, transformed the data into required columns with regards to the Stored Proc and Load the data into a temp table and execute the proc to upload the Promotions.

• Created a few automation scripts for the Human Resource Department (Tess which had saved a considerable amount of time spent on employee payroll.

• Created Password encryption for the User data in the Database using HASHBYTES function with SHA2_512 algorithm & Salt function.

• Modified the Categories & Subcategories names in the webpages and assigned the parent and child categories as per requirement using SQL scripts in the database.

• Created Production databases copies in Development & QA Servers. Monitored MS-SQL database instances including scheduled maintenance, backup and recovery and overall database performance.

• Experienced in Database Performance, Maintenance and Development to perform the following:

Database management including backups, recovery, and maintenance.

Monitoring and resolving data lock issues

Checked all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes

Created indexes to achieve critical dataset response time for time sensitive reports.

• Worked with software developers to design and modify database schemas including creating tables, defining proper indexes and primary keys based on their entities, normalization rules, expected volume and distribution of data.

• Troubleshooted and fixed the jobs scheduled in SQL Server Agent. Used sp_Blitz scripts (Free SQL Server Health Check Script) for weekly maintenance checks and fixed the issues.

• Troubleshooted the stored procedures errors in web pages using SQL Profiler trace logs. In-depth Experience in Transact-SQL (DDL, DML, DCL), and in Design and normalization of the database tables.

• Proficient in writing, modifying, and implementing Stored Procedures, Functions, Views, Triggers and SSIS Export & Import.

• In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics. 2

Role – Database Developer

Jun 2018 – Oct 2018

Company: - Integra Technologies LLC

• Creates and/ or modifies programs to adapt to changes in needs and requirements, with supervision.

• Read, understand, and troubleshoot coded computer instructions and how that translates into data

• Reviews test results with users, creates program documentation, and obtains approval for changes

• Test coded database program routines and revises eliminate errors in processing

• Validate data generated from data packages and routines to ensure data accuracy

• Analyzes issues and reports to lead team members to assist in decision making process

• Assist in gathering and refining business, data, and system specifications from business users and translate to database developers and analyst

• Develop a basic understanding of systems and technology used within the company

• Develop a basic understanding of the content of policies written by the company

• Develop a basic understanding of the insurance industry and the organizational relationships of the company

• Develop a basic understanding of the functions of other departments as needed or when appropriate

Project Name: GE Corporate Shared Oracle DBA Team

Mar 2014 – June 2016

Role – Oracle Database Administrator (Technical Associate) Company: - Genpact

Responsibilities

• Supporting 2000+ Oracle Databases in GE Corporate which includes development and stage and Production targets

• Responsible for installing, configuring, managing, and supporting all Production, Development environments of Oracle Version 10g and 11g databases on Linux and

• Configured RMAN Catalog database and registered target databases with catalog.

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

• Configured and maintained RMAN hot and cold backups.

• Responsible for database sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.

• Configured ASM (Automatic Storage Management) which includes creating disks, disk groups for the RAC environment.

• Responsible for creating roles, assign system /object level privileges to the roles and assign users to these roles.

• Performed Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

• Worked on designing, installing & maintaining RAC and Data guard components of Oracle.

• Extensively involved in upgrading database to Oracle 11g from Oracle 10g.

• Applied regular Security Patching on Oracle products and interim patches for various bug fixes on database products.

• Monitored the table growth, database growth, current users, and system resource usage and so on.

• Gathered statistics, rebuilt indexes, and updated statistics on tables to improve performance.

• Schedule and Implement Backup & Recovery procedures. Implemented hot, cold, and Logical backup plans.

• Analyzed explain plans, stat packs, monitored alert logs and system performance. 3

ACADEMIC RECORDS

School, College or University Dates attended Degree or certificate received/Field of Study: Vijnana Vihara residential school 06/1999 - 04/2007 Central Board of Secondary Education Sasi Junior College 06/2007 – 05/2009

Higher Secondary Certificate (Mathematics, Physics & Chemistry)

GMR Institute of Technology 09/15/2009 – 04/31/2009 The Bachelor of Technology (Electronics and

Communication Engineering)

Northern Illinois University 08/15/2016 – 05/12/2018 Master’s in Science (Operations Management and

Information Systems)

TECHINICAL SKILLS

ERP, BI & RDMS Tools: Oracle11g/12c, MS SQL Server, MySQL, R Studios, Management Studio, Visual Studio,

Enterprise Manager, Query Analyzer, SQL

Profiler, Data Transformation Services, SSIS,

SSAS

Data Discovery Tools: Tableau, Business Intelligence tools, Data and statistical analysis, Microsoft Office, VMware,

Data Modelling, Data Architecture, Pivot Tables

Systems: Windows, UNIX, Linux

Languages SQL, T-SQL, PL/SQL, VB.NET

Oracle DBA Tools SQL*Plus, Grid Control, SQL*Loader, RMAN, AWR, Scheduler, Data Pump, Expdp/Impdp,

SQLTRACE, DBCA, ADDM Reports, Oracle

Golden Gate, Oracle Multitenant Architecture,

Oracle Key Vault

Project management Wireframing, Mockups (Balsamic, MS Visio), Web Development, SDLC Tools

EDUCATION

MAY,2018

MS IN OPERATIONS MANAGEMENT & INFORMATION SYSTEMS, Northern Illinois University

• Solved real time business problems using statistical modelling and statistical data analytics

• Proposed and implemented enterprise-level IT-based solutions to facilitate new business processes and organizational structures using SAS, SPSS, and R

• Leveraged external credit firm’s data to enable customer segmentation, predictive modelling and strategize marketing

• Measured lifts and gains of binary logistic regression and decision tree models to choose best model

• Analyzed and presented analytical results to non-technical audience through various visualization methods

4

• Used SQL statements (SQL Server) to identify useful business insights and designed dimensional model and developed ETL on source system data to enable reporting

• Created executive dashboards on the Power BI service by selecting the appropriate reports

• Performed ETL using SSIS to extract data from the source data, cleanse and transform the data and load it to SQL Server Management Studio

• Developed SSAS project, which includes creating OLAP cubes (Star and Snowflake schemas) and multi-dimensional modelling

• Created SSRS reports from the SSAS cubes which included tabular and matrix reports and different reports like cascaded reports, drill down reports, sub reports by passing parameters

3.5 GPA

ACADEMIC PROJECTS

Chicago Airline Database & Website

• The project deals with solve a business problem* using a web-based application that allows an end user to interact with a database through an interface. The site must also allow for the administration of information through an administration page. Must be able to Create, Read, Update, and Delete information.

• Created a SQL database to centrally handle the information of all the customers who are trying to book flight tickets and to provide access to this information with an easy to use web-based interface that can be accessed by any device with basic html rendering capabilities.

• Each web-form performed certain operations like user registration, flight booking & user feedback, confirmation email and most of them must interact with your database.

• We used our course knowledge from Business Applications of Database Management Systems & Internet Computing Applications

• Site URL: - http://omisapps.niu.edu/z1804271/Final/Home Manufacturing Company Datawarehouse Data Analysis

• Gathered detailing prerequisites from clients and business experts and investigating necessities.

• Generated reports utilizing SSRS that could be utilized to send data to various Primary sellers, customers, and supervisors.

• Designed and executed put away methodology and triggers for computerizing assignments.

• Involved in making SSRS Reports, which are, exceed expectations well-disposed to perform different activities like rotate.

• Created SSIS Packages for Import/Export information to/from SQL Server.

• Developed Operational reports to help complex client necessities utilizing SSRS.

• Worked on SSIS execution tuning utilizing counters, mistake dealing with, occasion taking care of, re- running of fizzled SSIS bundles utilizing checkpoints.

• Generated server-side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances. Experience in using T-SQL for creating stored procedures, indexes, cursors, and functions.

• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.

• Created SSIS DB catalog with SQL Server 2012 to support SSIS package deployments in SSMS with Environment variables respective to each environment. Used Batch Files to Import Data from other Data Base.

• Created Tableau scorecards, dashboards utilizing stack bars, structured presentations, scattered plots, land maps, Gantt graphs utilizing show me usefulness.

• Creating Database objects – tables, perspectives, and capacities and creating methods for executing application usefulness at the database side for execution change. Performing question designs and ensuring every single inquiry is utilizing fitting valuable lists.

• Involved in taking care of live site creation issues. Giving a hot fix to the issue.

• Create distinctive SSRS Reports in view of the client's necessity. Different sorts like specially appointed reports.



Contact this candidate