Sql Server Management

SWATHI NARRA 312-***-****

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

SUMMARY:

Around 4 years of experience in the field of Information Technology with skills and knowledge in T-SQL, PL/SQL.

Conversant with all phases of software development life cycle (SDLC) involving System Analysis, Design, Development, Implementation, Documentation, and Deployment.

Good knowledge and experience in dealing with relational database management systems, including Stored Procedures, Joins, Keys and Views.

Experience and knowledge in Data Extraction, Transforming and Loading (ETL) using SQL tools like INFORMATICA POWER CENTER, SSIS (SQL Server Integration Services).

Knowledge in UNIX shell scripting, PL/SQL and SQL

Knowledge with Data Warehousing-dimension modeling (Star-schema, Snowflakes).

Strong knowledge with C++, SQL, T-SQL, PL/SQL, JAVA, JAVASCRIPT

Excellent Communication and inter-personal skills to understand business requirements in various domains and ability to interact with team.

EDUCATION:

Masters in Sciences, Computer Science Engineering,

Purdue University Calumet, Hammond, Indiana. (GPA - 3.65).

Bachelors in Computer Science

JNTU Hyderabad, INDIA. (GPA - 3.8).

ACADEMIC PROJECTS:

SDLC (Software development life cycle) of designing an airlines website with all the functionalities.

Technologies: HTML, CSS, JavaScript, JQuery, Java, MySQL, Apache Tomcat.

E-Cards Description: An E-Card is similar to a postcard or greeting card, with the primary difference being that it is created using digital media instead of paper or other traditional materials. Technologies: Android, JAVA, Eclipse IDE.

Purdue Food Services Website Description: We have developed a website which contains the details of all the food courts in Purdue University. The details include, location, hours of operation and the menu card of each of the food court. Whenever there is a new item in the menu or a deal, a notification is sent to the subscribed users of the website. Technologies: HTML, CSS, Java Script, My SQL, AWS.

Survey Web Page Description: This web page allows student to take a survey. The survey consists of feedback about the faculty and facilities provided by the university. The information of the student along with the feedback gets stored in the database to make the required changes. Technologies: HTML, CSS, Java Script, AJAX, JSON, JQuery/JQuery UI, JavaBeans, JSP, Servlets, Struts.

TRAINING/CERTIFICATIONS:

Well Trained in Oracle SQL

Knowledge in Ruby on Rails and Python from online training.

Completed 1-month Training Program on Android Applications.

Gained practical knowledge about various technologies.

SKILL SET:

SQL tuning in an Oracle environment.

Database Management: SQL Server 2014, Oracle (10g, 11i), MS-EXCEL 2007/2013.

System Programming: C, C++, SQL, T-SQL, JAVA, XML, PL/SQL, HTML, JavaScript, PHP, AJAX, JSON,

JQuery/JQuery UI, JavaBeans, JSP.

Tools: SQL Server Management Studio, SSIS, Toad, INFORMATICA Power Center 9.5.1, JIRA,

PPM.

IDE: Visual Studio, Eclipse, Spring framework, Dreamweaver.

Operating Systems: MS-Windows XP, Windows Advanced Server, Windows 7&8, Windows 10,

Linux, UNIX.

PROFESSIONAL EXPERIENCE:

Tracfone Wireless Oct 2016 – Present

QA Analyst

Tracfone Wireless, Inc. is a prepaid wireless service provider in the United States, Puerto Rico, and the US Virgin Islands. Tracfone Wireless is a subsidiary of Mexico's largest telecommunications company America and offers products and services under multiple brands which include Tracfone, NET10 Wireless, Total Wireless, Straight Talk, SafeLink Wireless, Telcel America, Simple Mobile, and Page Plus Cellular.

Responsibilities:

Understanding the requirements by going through the technical specifications and wireframes.

Participated in meetings and walk through meetings with Development, Business and other QA Teams.

Developed test plans, test data, test cases, test scenarios and test strategy documents for the One Traffic and One Suite Applications as per the approved business requirements.

Experience in Agile, Scrum methodologies.

Participated in Sprint Planning meeting, Daily Standup meetings, and Sprint Demo and Retrospective meetings.

Implementation of QA methodologies as per SOP (V-Model and Agile Methodology).

Manage the SIT (System Integration Testing) and UAT (User Acceptance Testing).

Developed the test requirements, test plans, test strategy and test cases for the Patient Management system as per the approved business requirements.

Prepared the acceptance test plans, which includes the acceptance criteria along with the end-user responsibilities.

Written SQL queries for testing purpose.

Peer review is done for the prepared test cases in order to maintain the quality of the process.

Managed and documented the testing efforts and issues.

Coordinating with the UAT and development teams to help them in testing the application.

Environment: Java, SOAP UI, Oracle 11g, Web sphere, SQL, Excel, Autosys, Win XP.

USG (United States of Gypsum) Mar 2016 –Aug 2016

SQL Developer:

USG is North America's leading producer and distributor of gypsum wallboard, joint compound and a vast array of related products for the construction and remodeling industries. Building the environments in which we live, work and play through ground breaking research. Design Studio is the website that displays all the construction materials to build better structures. Products provides creative building solutions that set new standards for productivity and efficiency, helping contractors and architects deliver high quality and innovative designs.

Responsibilities:

Created database objects like tables, views in SQL based upon the functional specifications.

Used Excel and Access for analyzing and resolving data inconsistencies.

Involved in creating functional and technical specification documents after gathering requirements from business users and used agile methodology while development.

Closely worked with Business Analysts and Marketing team to analyze the requirements.

Good Understanding of AGILE and Waterfall development approach.

Modifications and optimization of the existing code.

Good knowledge and experience in dealing with relational database management systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Views, Triggers and Cursors.

Extracted data from different sources including flat files, Excel.

Worked with UI developers and Business to create front end and explaining the database design to them.

Part of Master page creations and CSS stylesheets.

Performed unit and system testing, troubleshooting and bug fixing development.

Environment: MS SQL SERVER 2014, T-SQL, SQL, SQL Server Management Studio, SSIS, Autosys, PPM.

CME Group (Chicago Mercantile Exchange) May 2015 – August 2015

Software Engineer (Intern)

CME is an American futures company that owns and operates large derivatives and futures exchanges as well as online trading platforms.

Clearing IT (Clearing Data Provisioning Services):

CDPS system is responsible for providing operational data to multiple clearing systems for daily reporting to CME clearing and its business partners. It is also responsible for providing clearing data for multiple downstream and upstream systems. The systems developed and maintained by clearing technology provide services including trade management, allocation management, position management, variation margin, cash flow calculation, financial settlement and deliveries management for all CME cleared futures, forwards, swaps and options.

Responsibilities

Create SQL Scripts to validate and correct inconsistent data in the staging database before loading into database.

Worked on SQL tools like TOAD to run SQL queries to validate the data.

Knowledge in PL\SQL procedures.

Modifications and alterations in the existing code.

Worked on all the INFORMATICA Power center tools such as Designer, Repository Manager, Work Flow Manager, Work Flow monitor, Metadata Reporter).

Good knowledge in Designing, developing and Implementing the complex mappings in INFORMATICA to load the data from various sources using different transformations like Expression, Look up, Aggregate, Update Strategy,

Worked on various tasks and transformations like Slowly Changing Dimensions Type1 and type2, lookup, merge while loading the data into Destination.

Worked with Java team for data integrity and collection.

Knowledge in Designing Packages, Procedures, Functions and Triggers.

Coordinated with the team in trouble-shooting and various issues.

Environment: TOAD, Oracle, PL/SQL, INFORMATICA, UC4, PUTTY, JIRA, GIT.

United India Insurance Company: Nov 2013– 2014 May

SQL Developer (intern)

UI is a leading general insurance company. It has more than three decades of experience and is head quartered in Chennai, India. Optimization of existing SQL queries to improve the performance of the system and creation of new stored procedures, indexes and triggers for further enhancements.

Responsibilities:

Code development in T-SQL using SQL Server management Studio.

Modifications in the stored procedures to meet the requirements based on the packages in the SSIS.

Created Indexes, Constraints and rules on database objects.

Developed Triggers and Views to populate data in tables.

Extracted data from different sources including flat files, Oracle10g to SQL Server 2008 by using SSIS.

Training on SSRS and basic Data Ware House concepts.

Environment: MS SQL SERVER 2008, T-SQL, Query Analyzer, SSIS.

Contact this candidate