Manager Sql Server
Resume:
Swetha
**********@*****.***
Summary:
Over 3 years of experience in Analysis, Design, Development, Testing and Implementation of Business Applications and Client/Server applications.
Strong expertise in using Tableau software as applied to BI data analytics, Reporting and Dashboard projects.
Strategic expertise in design of experiments, Data Collection, Analysis and Visualization.
MS EXCEL: Experience in validating and Analyzing data in worksheets using Sorting, Filtering, Vlookup, creating PIVOT tables, Charts.
Expertise in working with all the modules of Business Objects like Supervisor, Designer, BO User, BO Reporter, Web Intelligence, Desktop Intelligence, Info view, Data Integrator, Broadcast Agent,Auditor, EPM, Zero Admin BO(ZABO),Import Wizard, Report Conversion, Report Bursting, Migration from 6.5.1 to BOXI R2, Crystal Xcelsius, Live Office. CMC and Crystal Reports XI .Expertise in Development, Maintenance, Upgrade, Integration, Production Support and Re-engineering Projects.
Extensively worked on Reporting and Designing module.
Proficient in creating web reports through report template in Web Application Designer.
Well versed with Dimensional techniques – Star & Snow-flake Schemas.
Strong understanding of full Software Development Life Cycle (SDLC) and excellent experience in Data Warehousing building Data Marts, generating OLAP reports.
Worked on various databases including Oracle, SQL Server, and MS-Access.
Proficient in writing functions, Stored Procedures and Packages using PL/SQL.
Have strong programming skills in writing/maintaining SQL and PL/SQL for Oracle database backend.
Experience in executing UNIX Shell scripts for running batch jobs.
Experience in leading the teams, mentoring the team members of the projects.
Experience with Offshore/Onsite model.
Team player with excellent interpersonal, verbal and written communications skills.
Proven ability to work in Stressful Situations, independently or as part of a Team.
Technical Skills:
OLAP/DSS Tools
Tableau, SSRS, SSMS, SSAS, BusinessObjectsBI4.1, SAP BW,XI3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x,SDK,CrystalReports XI,SIA,Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Performance Manager, Deployment Tool, Auditor, Crystal Report Explorer, Dashboard Manager, Scorecards, Tomcat 4.0.6,Oracle Warehouse Builder, Apache 1.3.x, Business Objects JAVA SDK, CMC, CMS, Crystal Reports XI,
GUI
Oracle Developer 2000, Visual Basic 5.0/6.0,Power Builder
Programming
Languages
C, C++, JAVA, SQL and PL/SQL.
Web Technologies
HTML, XML, JavaScript, VBScript and JSP
RDBMS
Oracle 11,10G/9.x/8.x/7.x/5.x, DB2/400, SQL Server 2000/2005, MS Access 2000
Operating System
MSDOS, Windows, Unix, HP- UNIX, Sun Solaris
Utility Tools
Erwin, TOAD, SQL*Navigator, Developer 2000, SQL*Loader
.
EXPERIENCE
Source Pulse LLC, Austin Oct’14 – Till Date
Tableau Developer
Responsibilities:
Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
Corporate departments: finance, sponsorship, marketing, vendors.
Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
Performed Data blending implemented on SQL Server Database to generate interactive dashboards
Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
Write and execute SQL scripts, Stored Procedures to develop reports and perform data/report validation.
Generated dashboards with Quick filters, Parameters and sets to handle views more efficiently.
Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability. Created visually compelling and actionable interactive reports and dashboards.
Performed ETL operations using Informatica to load the denormalized form of data to get the facts and dimensions in the dashboard.
Perform testing of dashboards by comparing the data of dashboards to various SQL queries.
Created Tableau visualizations using line charts, bar charts, dual axis charts.
Handled Tableau admin activities generating access, managing extracts and installations
Created advanced charts like Waterfall chart and Pareto Chart.
Working knowledge of dimensional modelling, ETL, SQL query rewriting and optimization using Oracle, SQL Server databases.
MS EXCEL: Experience in validating and Analyzing data in worksheets using sorting, filtering, Vlookup, creating PIVOT tables, charts.
Worked in agile, iterative team setting and experience with other BI tools like SAP Business Objects, SSAS/SSRS.
Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
Used commands in Tabcmd and Tabadmin utility tool.
Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
Environment: Tableau 8.1/ 8.2, Tableau Server, SQL Server 2012, SSAS, SSRS, SSIS, Import/Export tools, SQL Server Agent, Microsoft office, Informatica
Education:
Bachelors Degree – India
Contact this candidate