Developer Sql

Naga Santhosh Varanasi

*** ********* **, *** ***, Devon PA, 19333 P: 732-***-**** E: ************.********@*****.***

Summary:

• Around 2 years of experience in Hyperion Essbase & Planning, SQL Server 2012, SSMS, SSIS

&SSRS 2012.

• Extensive experience in Java Programming.

• Experience in working in evironments using Agile and Test Driven development methodologies.

• Project experience in major domains: Finance, Healthcare, Insurance with focus on the Software

Development Life Cycle (SDLC), testing, deployment and support of large scale projects in controlled

development, test and production environments.

• Experienced in web development using HTML, DHTML, XHTML, CSS, JavaScript technologies.

• Good Knowledge of using IDE Tools like Eclipse,SQL Developer, Flyspeed, MS Visual Studio 2013.

• Strong foundation in designing and executing Transact-SQL (T-SQL) Query statements with

implementing experience in both syntax and logical structure such as: DDL/DML/DCL commands,

Joins, UDF (User-Defined Functions), Stored Procedures, Triggers, Views, Indexes using SSMS (SQL

Server Management Studio).

• Experience in using ANT for build automation.

• Experienced in using Operating Systems like Windows XP/7/8.1 and Linux.

• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and

leadership skills to develop creative solutions for challenging client needs.

• Strong inclination for finishing job before the project deadline.

Education:

Villanova University, Villanova, PA Aug 2013 – Present

M.S. in Computer Science GPA: 3.2

Jawaharlal Nehru Technological University, Hyderabad, AP, India Oct 2008 – May 2012

Bachelors in Information Technology GPA: 3.6

Technical Skills:

Programming Languages Java, PL/SQL, Swings

Web Development HTML, Bootstrap 3, CSS, Java Script, jQuery, AngularJS, Servlets, Ajax, PHP

XML/Web Services JSON

Databases Oracle 8i/9i/10g, SQL Server 2012.

IDEs Eclipse, NetBeans 8.0

Build Automation Apache ANT

MS Visual Studio 2013, Flyspeed, SQL Developer, MSBI Stack

Tools

(SSIS,SSAS,SSRS).

Operating Systems Windows XP/7/8 and Unix.

Cloud Computing Amazon Web Services

Technical Experience:

1 Independence Blue Cross, PA, USA. Fall 2014 –

Present

2 Software Developer Intern

3

Independence Blue Cross (IBC) is a health insurer based in Philadelphia, Pennsylvania in the United States.

IBC is the largest health insurer in the Philadelphia area, serving more than two million people in the region

and seven million nationwide.

• Used Agile methodologies for application development.

• Developed Apache Ant Scripts for complete automation of middleware builds.

• Developed reports under SSRS and PowerPivot.

• Developed Java files for pulling data from DB2 & SQL Server 2012 to local system.

• Developed complex T-SQL queries & scripts for Database backup & recovery.

Environment: JDK 1.6, Agile, PL/SQL, ANT, SQL Server 2012, SSRS 2012, MS Visual Studio, DB2, Eclipse,

PowePivot, Flyspeed, FileZilla.

Genpact, India April 2012 – August 2013

4 Drilling & Production Project Margin Review.

5 Technical Associate

Support

•Generating financial reports using Hyperion Essbase & Planning.

•Interacting with users for requirement gathering for creating Calculation Scripts and Business Rules.

•Resolving issues on client side on MS Excel and reports.

•Creating databases on Essbase and configuring them.

Maintenance

• Maintaining Source files in staging process of Oil & Gas Project.

• Worked on SQL Developer for running various procedures & Triggers of PL/SQL.

• Sending the processed source files to Informatica Team for updating the Databases.

Environment: Hyperion Essbase & Planning, SQL Developer, SmartView, Unix.

Academic Projects:

Hospital Management Systems (spring’14): Standalone application for hospitals for maintaining records of

doctors & patients.

Technologies Used: Oracle 10g, SQL, SQL Developer, Java Swings, NetBeans 8.0, SSH Client.

All About Cricket (fall’14): Website contains newsfeed from google and contains data about iconic players in

cricket history.

Technologies Used: HTML, CSS, JavaScript,JQUERY, SSH Client, Adobe DreamWeaver, PHP, XAMPP.

Social Activities:

• President at Villanova Indian Students Association (2013-2014).

Contact this candidate