Data Sql Server
Resume:
Srinivas Potla
Email: **************@*****.***
PROFESSIONAL SUMMARY
Having 7+ years of experience in Data Architecture, Business Analysis, System Analysis & Design, Development, testing and implementation of Data Warehousing and Business Intelligence applications in Media & Entertainment, Retail, Health care, Pharmaceutical, and Financial industries.
Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7.x/8.x./9.1.
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
Hands-on experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Tables, Physical and Logical Data Modeling.
Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Expert in working on Oracle, SQL server, Teradata, DB2.
Very good experience in Oracle database application development using Oracle 12c/11g/10g/9i/8i/x, SQL, PL/SQL,SQL*Loader. Strong experience in writing SQL, PL/SQL-Stored Procedures, Functions and Triggers.
Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.
In-depth knowledge in building/maintaining Repository, Universes and creating AdHoc reports.
Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
EDUCATION:
Bachelor of Technology, CS – JNTU.
TECHNICAL SKILLS:
BI Tools
Tableau desktop / Tableau Server, Business Objects, SSRS.
Database
Teradata V13/V12/V2R6, Oracle (9i/10g/11g/12c), SQL, 2005/2008/2012, DB2.
Programming
SAS, SQL, PL/SQL, TOAD, C#, HTML/XML, Shell Scripting, Java/J2EE.
SQL Tools
Teradata SQL Assistant, Toad, PL/SQL Developer, Rapid SQL, SSAS.
Operating Systems
Windows XP/ Net/2000/ Vista/7, UNIX, Linux.7
Methodologies
Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum
PROFESSIONAL EXPERIENCE:
La-Z-Boy, Monroe, MI July 2014 - Present
Sr. Tableau Developer/Admin
Responsibilities:
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Experience in migrating client’s reports from excel (static) based solution to an interactive service.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
Installed patches on the server and documented upgrade plan from Tableau 8.0 to 8.1
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
Access dashboards from any browser or tablet.
Created incremental refreshes for data sources on Tableau server.
Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
Coordinated database middleware issues with DBA's, system performance with System Architects.
Involved in license management SLA's with Tableau support.
Converted existing Cognos Reports into Tableau Dashboards.
Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
Defined and created procedures to install Tableau desktop in silent mode.
Worked on scheduling the extracts and setting up the permissions.
Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
Environment: Tableau Desktop 8.0/9.1, Tableau server / Administrator, Tableau drive, Cognos, SQL developer, SQL 2012,Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.
BCBS Illinois, Chicago, IL Jan 2013 – May 2014
Tableau Developer
Responsibilities:
Worked on Reports from requirement gathering to Universe & Report Development to migrating it to production.
Analyse PCRF production data like Total Number of requests, Errors, Transaction per Second (TPS), Latency of different components and provide feedback to Business, Product Management and Architect teams to improve business, capacity.
Developed database objects like tables, views, procedures, triggers, functions using TOAD /T-SQL to provide definition, structure and to maintain data efficiently.
Followed Agile Scrum process to streamline development process with iterative and incremental development.
Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs and Prepared Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application
Generate dashboards to provide trending of data using statistics and KPI’s.
Integrated Cognos and crystal reports to tableau.
Act as system administrator and is responsible for security, administration, release management, troubleshooting, performance tuning and general system maintenance.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.
Environment: Tableau Server 7.0/8.0, Tableau Desktop 7.0/8.0, SQL Developer, Oracle 11g, SQL plus, IBM Cognos, SAP Crystal Reports, IBM DB2.
Mind Tree, Bangalore, India Oct2010-Nov2012
SQL BI Developer
Responsibilities:
Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
Various ETL Transformation tools were used for Control Flow and Data Flow tasks.
Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008.
Designed and implemented Parameterized and cascading parameterized reports using SSRS
Created star schema in SSAS and developed SSRS reports based on the cube.
Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
Assist BAs in the team with appropriate documentation and domain knowledge.
Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
Involved in writing queries for stored procedures, clustered and non-clustered indexes.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Interaction and coordination with end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.
Environment: SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.
Divi Pharma Group, India June 2008-Oct2010
Oracle PL/SQL developer
Responsibilities:
Created Database objects including Tables, Indexes, Clusters, sequences, roles, and privileges.
Calculated and monitored size and space for tables, clusters and indexes.
Created separate table spaces for Users, Indexes, Rollback Segments and Temporary Segments. Renamed and resized redo log files, user data files, rollback files, index files and temporary files.
Created and maintained Triggers, Packages, Functions and Procedures.
Created and maintained roles and profiles for security and limited access of data.
Designed and implemented Backup & Recovery strategies.
Analysed the database for performance issues and conducted detailed tuning activities for improvement.
Debugged, performed system/application tuning by identifying long running reports.
Created users and established application security by creating roles.
Wrote procedures to meet adhoc requirements to replicate data from one table to another.
Environment: Oracle 9i, PL/SQL, Windows NT
References: Available Upon Request.
Contact this candidate