Developer Sql Server

Indira Priyadarshini Palety

Phone: +1-631-***-****

Spotfire Developer

Email-ID: ***************@*****.***

SUMMARY:

Experience with the BI tools Tableau, and Tibco Spotfire Professional.

Experience in representing large amount of data in the form of Complex Tableau Visualizations and Spotfire Dashboards.

Good Experience in writing Complex SQL scripts and Stored Procedures, PL/SQL Procedures, Functions, Triggers in various databases like Oracle, DB2, Netezza, MS QL Server, Sybase and performance tuning.

Good Experience in Data analysis, data extraction using SQL.

Experience with creating Bar charts, Line charts, Combination charts, maps etc in Spotfire.

Expert in creating Information links using Information designer in Spotfire.

Knowledge in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.

Extensively worked on Relational Databases like Oracle 11g/10g/12C,, Teradata, MS SQL Server, Access,DB2 and database access tool TOAD, Rapid SQL and Aginity.

Domain Knowledge in Banking and Financial, Mortgage, Manufacturing and Utilities.

Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.

Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

Report the identified issues to development teams, train them over common vulnerabilities, prescribe remediation and follow up on the fixes.

Excellent code reviewing and programming skills on java, JavaScript, XML environments.

Had proven adeptness to assigned work with good analytical, interpersonal and problem-solving skills.

TECHNICAL SKILLS:

Business Intelligence Tools

Tableau 6.0, Tibco Spotfire Professional 3.2,3.3,4.0,5.5,6.5,7.0,7.6,7.7 Spotfire Web player,

Servers

Application Servers (WAS, Tomcat), Web Servers (IIS, HIS, Apache).

Operating Systems

Windows 7/VISTA/NT/ XP/ ME/ 2000/, UNIX.

Databases

IBMNetezza, SQLServer, Sybase, Oracle11g/10g, Teradata, SAP HANA, Hbase, Hive, MS Access and DB2.

Programming Languages

SAS, SQL

PROFESSIONAL EXPERIENCE:

Client: Gilead, Foster City, California Oct 2018 - Present

Position:Spotfire Developer

Domain: Biopharmaceuticals

Responsibilities:

Gathered Business requirements and perform data analysis and reporting.

Utilized property controls, calculations, filters schemes in Spotfire.

Created Bar Charts, Line Charts, Combination Charts, Pie Charts, Cross tables in Spotfire.

Experience in creating Bookmarks, Tags and Lists.

Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.

Created various complex Map Chart, Cross tab Reports and Chart Reports.

Experience in enhancing the visualizations using Custom expressions.

Knowledge on Information Designer and Creating Information Links.

Experience in using Filter schemes and Dynamic control properties in Spotfire.

Proficient in performance tuning, backup and recovery, security, patching, upgrades and high availability.

Experience with SQL DBA tasks and Performance tuning.

Experience in Installation and configuration of new SQL Servers.

Environment: Tibco Spotfire Client 7.7, Spotfire web player, Oracle 12C, Python, Microsoft SQL server, MS SQL server Studio, Toad.

EDUCATION:

Masters from Wilmington University Delawere,2016

Bachelors in Electrical and Electronics Engineering JNTU,2011

Contact this candidate