Resume

Sign in

Sql Server Software Developer

Location:
Springfield, Massachusetts, United States
Salary:
80000
Posted:
April 08, 2018

Contact this candidate

Resume:

*** ******** ******,

Enfiled, CT, *****

DEEPIKA MANJUSHA MAKINENI

813-***-****

ac42o3@r.postjobfree.com

Objective:

I am a versatile software developer with 3 years of experience in database administration with expertise PL/SQL and Microsoft SQL Server Management Studio. Also, proficient in C, C++, HTML5, CSS3, Bootstrap, JavaScript and jQuery. Have good understanding and experience in Agile Development methodologies and Object-Oriented Programming.

Career Summary:

Expertized in SQL complex queries, PL/SQL -- Stored procedures, Indexes, Clustering, Triggers, Views, Pivoting, CTE, Set joins and User-Defined Functions.

Strongly skilled in Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) in PL/SQL with Import/Export Data.

Handled Transporting and Loading Data in Microsoft SQL and Oracle.

Skilled in requirement gathering, data analysis, data modelling, development, testing, performance tuning and functional consulting.

Ability to work effectively on Query Optimization, Client/Server connectivity, Performance Tuning, table partitioning and indexing.

Handled advanced query design, RDBMS principles, database design and normalization.

Experienced as Technical Consultant in Onsite-Offshore model involving all stages of Software development life cycles.

Developed User Interface for a mobile application using HTML/HTML5, Bootstrap and CSS/CSS3.

Education:

Master in Management Information Systems CGPA : 3.83/4 University of South Florida, Tampa FL Graduated : August 2017

Bachelor of Technology, Computer Science CGPA : 8.06/10

GITAM University, Vizag, India Graduated : April 2014

Technical Skills:

Languages : C, C++, JAVA, AngularJS

Databases : PL/SQL, Microsoft SQL Server Management Studio, SSIS, Oracle, Hive

Front End : HTML5, CSS3, Bootstrap, JavaScript, jQuery, AJAX, XML

Framework : .NET/C#, ASP.NET, MVC, Eclipse, J2EE, Microsoft Office Suite, Excel skills

Operating Systems : Windows, Android

Analytical : SAS Enterprise Miner, WEKA, Tableau.

Relevant Coursework:

Data Mining Advanced Database Administration

Big Data Object-Oriented Programming

Data Warehousing Data Visualization

Professional Experience

Matrix IFS, Tampa, Florida, US Since August 2017

Role: SQL Developer Full time

Matrix-IFS offers a broad range of advisory and technology services to assist Financial Institutions in implementing effective AML programs and achieving their compliance, IT, and operational objectives. We have extensive experience in offering a range of services covering the end-to-end activities required for the design and implementation of an effective monitoring program.

Generation of PL/SQL script with mapping and validation to insert / update data from one instance to other SQL Instance base tables using Threads.

Experience in Configuring and Managing Linked Servers, data transfer between SQL/PLSQL and another heterogeneous relational database such as Oracle, Sybase and DB2 Experience in implementing SQL/PLSQL Security and managing permission to the Database through Database roles, Creating Users and Logins.

Using SQL Server Integration Services (SSIS) tool of SQL server to populate data from various data sources, creating packages for different data loading operations for ETL applications.

Worked on high availability solutions, including Log shipping, Mirroring and PL/SQL clustering.

Support of weekend and Monthly Maintenance Window database deployments and configuration changes.

Experience in importing data from various legacy systems into Oracle Applications using PL/SQL, SQL*Loader, SQL Plus, UTL_FILE and other tools.

Used JIRA tool for bug tracking, issue tracking.

Capable of handling responsibilities independently as well as a proactive team member

Strong analytical, problem solving and communication skills.

Revenue Management Solutions, Tampa, Florida, US May 2017-August 2017

Role: MS SQL BI Developer Intern

Maintenance and administration of SSRS by creating Job schedule and SQL Mail Agent Packages.

Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers and package configurations.

Expertized in Data Extraction, Transforming and Loading (ETL) from various data sources to destinations Data using Connections provided by SSIS.

Creation of Dashboards in Tableau.

Good work ethics with excellent communication and interpersonal skills with a strong attitude towards technologies quickly supporting the project requirements.

NTT Data Global Delivery Services Private Limited, Hyderabad, India May 2015 – July 2016

Project 2:

Role: Application Software Developer in Chaucer Insurance Project

NTT DATA Services partners with clients to navigate and simplify the modern complexities of business and technology, delivering the insights, solutions and outcomes that matter most. We deliver tangible business results by combining deep industry expertise with applied innovations in digital, cloud and automation across a comprehensive portfolio of consulting, application, infrastructure and business process outsourcing services.

Developed PL/SQL stored procedures involving Triggers and Cursors for complex business units.

Handled front end of the project through .NET and develop modules in Windows Forms using C#.

Responsible for the analysis, design, documentation, development, unit testing, and support of database objects development for software applications

Trained to design, develop, test, tune, and implement database objects and any supporting SQL scripts using PL/SQL Server.

Developed advanced database driven websites using PL/SQL and dealt with SSIS packages.

Created technical design documentation which includes current and future functionality, database objects affected, specifications, and flows/diagrams to detail the proposed implementation.

Participated in developing application scope and objectives and preparing functional and/or technical specifications.

Provide status updates on all assigned tasks using the department’s service request tracking tool and TFS project tracking.

Project 1:

Role: Application Software Developer in Web Application Development Project May 2014 – April 2015

Worked on designing UI / UX screens for the mobile application using HTML5, CSS3 and Bootstrap.

Connected interface to the server for the data storage using jQuery and Eclipse.

Handled backend using SQL Server 2012 to retrieve the fed data of user registration whenever logged in again.

Implementation of visual elements that users interact with including websites, WordPress theme customizations and the UI design of web applications.

Academic Projects:

Creation of an Ecommerce Website Sept 2016 – Dec 2016

Language: Java Framework: Eclipse

Analyzing a dataset to find patterns and Rules Sept 2016 – Dec 2016

Tool 1: SAS Enterprise Miner Tool 2: Weka

E - Store online retail store handling framework Sept 2016 – Dec 2016

Language: SQL Database: Oracle

Telephony and file transfer over Bluetooth (Bachelors Major Project) Jan 2014 – Apr 2014

Language: Java Framework: Eclipse

Certifications:

Microsoft certification in Software Development Fundamentals.

Microsoft certification in DOT NET FUNDAMENTALS.

Leadership Experience:

Event Organizer and Coordinator with Microsoft User group, Techny’ 13, Vizag March 2013

Organized an event that involved developers from Microsoft, Infosys and Thomson Reuters to interact with students from several colleges and explaining the trends in technology.

Hands on Microsoft Kinect, Information Auditing and Application Development in ASP.Net.



Contact this candidate