Sql Data

NAGACHAITANYA

**** **** ***** *****, ******, New Jersey 08817, 551-***-****), *******************@*****.***

Authorized to work in the US for any employer

EXPERIENCE:

More than two years of experience in analysis, design, development and testing of software applications with two of years of experience as a SQL/PLSQL developer.

Good experience in SQL development.

Well experienced on SQL reporting, analytics and business intelligence.

Good understanding of SDLC and agile methodologies with experience in all phases of development including design, development, testing, system analysis, implementation and maintenance.

Ability to develop applications in a detail oriented environment.

Skilled in writing code, testing the reports, performing the code review and designing databases and ER Diagrams.

Conversant with T-SQL coding and creating stored procedures, triggers, functions and views.

Good knowledge in using UNIX commands.

Knowledge of SQL server analysis and object –oriented design.

Great experience in Oracle platform especially on SQL standards and Java.

Experience in operating SQL server suite of products like SSIS, SSRS and SSAS.

Tools and utilities

Toad, MS Office suite, SQL tools, SQL*PLUS, SQL-Loader, Oracle Virtual Box, Import and Export, Putty

SQL Server Tools

SSIS, SSRS, SSAS

Databases

MY SQL, MS SQL, MS Access, SQL Server, Oracle

Programming/Scripting

SQL, PLSQL, MY SQL, T-SQL, C, C++, C#, HTML, .NET, JAVA, Unix Shell Script

Operating Systems

Windows, Linux, MacOS, Unix

Data Modeling Tools

Erwin, MS Viso

RDBMS

Oracle 10g and 11g

Excellent grasp of data warehousing and such process as extracting, transforming and loading.

Ability to work individually and also enjoys working as part of success-driven team.

Excellent interpersonal and communication skills with problem solving abilities.

SKILLS:

EDUCATION:

Master of Science in Computer Science, Fairleigh Dickinson University, College of Science and Technology, New Jersey, US (2 Year Program- Jan 2016 with 3.4 GPA)

Bachelor of Technology, Jawaharlal Nehru Technological University, Hyderabad, Telangana, India (4 year Program- May2013 with 3.4 GPA)

PROFESSIONAL EXPERIENCE:

SQL/PL-SQL Developer- Human Logic Technologies India PVT LTD

August 2012 – July 2014

Job Responsibilities:

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Created and maintained SQL objects like Tables, Views, Indexes, Stored Procedures, User defined Functions and SQL Scripts, T-SQL for developer applications.

Involved in automation of administrative tasks like creating jobs, schedules, and alerts using SQL.

Develop and schedule multiple steps SQL jobs integrated with store procedures, SSIS, T-SQL scripts.

Worked on Ad-hoc requirements and various complex bug fixes.

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/SSRS using various features like data conversion etc.

Used SSIS to create ETL packages to validate, Extract, Transform, and load data to transaction and data warehouse.

Develop and maintain enterprise reporting (SSRS reporting services) based on specifications and business needs and modified existing reports as needed.

Handled the responsibility for the physical as well as logical design on the storage media.

Created and managed the database triggers and subprograms.

Extracting data from multiple operational sources, transforming, cleansing, filtering the data and finally loading the data into one or more target databases.

Worked on Erwin Data Modeler for mapping both user-defined and default data types and creating database design (physical and logical).

Created temporary tables and developed SQL*Loader control files to load legacy data into the temporary tables.

Worked with DBA team members in complete SDLC, which includes requirement gathering, analysis, design, development and implementation.

Hands on experience in installing, configuring, upgrading, and managing SQL server2008/2012 and upgrading service packs for multiple instances.

Environment: Oracle 11g, SQL*plus, MS-SQL server2008/2012, SSIS, SSRS, Toad, Erwin, Windows, Unix.

Intern at Tek and Company USA:

Jan 2016-June 2016

Job Responsibilities:

Developed database objects like tables, views, stored procedures, and indexes.

Tuned SQL statements using views and stored procedures.

Wrote store procedures for creating and granting access for logins and users.

Managing the payroll activities done in the company.

Provided database development support to the development team

Controlling and monitoring user access to the database.

Environment: Oracle 11g, SQL, MS-SQL, SSIS, SSRS, Windows, Linux.

References available on Request.

Contact this candidate