Description

VAMSIDHAR REDDY KONATHAM

Address: Bangalore, India

Mobile: +91 9963314431/+91 9581421298 | Email: vamsi.sql0989@gmail.com

LinkedIn URL: https://www.linkedin.com/in/vamsidhar-reddy-konatham-175219192/

Date of Birth: 24th May, 1987

Nationality: Indian | Gender: Male

PERSONAL STATEMENT

Competent Engineer with over four years of experience in the Software engineering industry, with a key focus on planning, executing and implementing Database Solutions, Data Modeling, Design, Development of Database systems using MS SQL 2000/2005/2008 for both OLTP (Batch Processing and Online Processing)
Widespread experience in different phases of project life cycle such as Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications, Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, and Complex joins
Hands-on experience in performance tuning in stored procedures, Queries using tools like¬†SQL Profiler, Executing Plans and DMV’s, Forward / Reverse Engineering Data Models between Erwin and MS SQL Server
Demonstrated excellence in project execution and monitoring, preparing documents, and communicating with clients
Proven track record of making best use of available resources and techniques to provide high quality service while coordinating with key stakeholders to meet objectives of the project
Skillful at managing and owning the projects entirely with the ability to maintain delivery timelines and other quality parameters across various stages of projects
In-depth Knowledge in ER modeling, Dimensional modeling building tables, MS SQL Server 2012, and implementing new features like Change Data Capture (CDC)
Successfully finished projects in timely manner with 15% under budget with desirable results
SKILL SET

Project Management & Planning
Change Management
Application Management
Team Leadership & Supervision
Database Management
Risk Management
Strategic Planning
Quality Control & Assurance
Client Relationship Management
Resolution Management
Application Designing
Critical Thinking
EDUCATION

Bachelor of Technology in Electrical and Electronics Engineering from Jawaharlal Nehru Technological University (JNTU), Hyderabad, India. 2008
WORK EXPERIENCE

Organization
Designation
Duration
Intelenet Bangalore, India
Senior Software Engineer
Jul 2017 ‚Äď Till Date
Software Engineer
Jan 2015 ‚Äď Jun 2017
KEY DELIVERABLES

 

Dynamically leading development of 10 database projects for client and designing 3 onsite databases and maintaining a group of 25 databases through automation and improved efficiency of 15%
Actively involved in integrating SQL Server Reporting Services with Microsoft Office Share Point Server, working with data models, data flows and data dictionaries, logical & physical data, modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems
Keenly involved in huge data migrations & transfers, ETL processes using SSIS, DTS for Data warehouse implementation projects involving conversion of data from heterogeneous sources like DB2, and Oracle
Dexterously involved in database programming in writing T-SQL Stored procedures, User Defined Data types ,Triggers, Indexes and Batch Scripts using various DDL and DML commands, Views, Cursors
Executing software development systems in the organization and involved in designing and development of various projects
Participating in the complete range of project activities, starting from conceptualization, testing and maintenance of the project and maintaining the User Documents of various projects
Effectively executing programming T-SQL stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement business logic
Managing usage of multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all
Effectively providing authentication and authorization of database, and creating incidence for query performance and permissions
Assisting in SQL Server optimization including indexing and query optimization
Formed Partition function and scheme, multiple file groups and files to host the table data for Data partitioning

End of Resume