Data Sql Server
Resume:
Satya Durvasula
*********.*******@*****.***
SUMMARY
Experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
In depth knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with strong understanding of methodologies like Waterfall, Iterative& Incremental, Evolutionary prototyping and Agile.
Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005, SQL 2008R2 and SQL 2012.
Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
Expertise in Writing SQL Queries and Stored Procedures to validate the data
Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, DTS and SSIS services.
Hands on Experience in Migrating SSIS packages in SQL Server 2008/2012/2014.
Experiences on Tableau tools include Tableau Desktop, Tableau Reader, Tableau Public, and Tableau Server.
Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc.
Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8 and Tableau 9.
Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design.
Expertise in various visualization tools Tableau, SSRS for producing attractive rich graphical parameterized visuals/dashboards to convey the story inside the data
Developed dash boards with rich Graphic visualizations, Drill Down and Drop down menu options, parameterized using Tableau.
Worked on Tableau desktop for some of the reports replicating the SSRS reports
Involved in Trouble Shooting, Performance tuning of reports and resolving various issues.
Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2012.
Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports in SSRS 2012.
Inspected the reports and fixed bugs in stored procedures and also tuned Reports.
Published Tableau Dashboards in Tableau Server, Tableau public.
Involved in Tableau Server configuration, creating Users, Groups, Projects and assign Privileges etc.
Experience in Tableau Projects (involved in the complete lifecycle from requirement gathering, data modeling - scripting, developing and testing dashboards using Tableau)
Applied different filters like normal filters, quick filters, context filters, sharing filters, and use as filters, user filters.
Accessed various data sources across the enterprise to pull data for reporting and analysis.
Installation of Tableau Desktop and Tableau Server.
Involved in admin activities like publishing, creation of subscriptions etc.
Possess strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, nested sub queries, and resolving key performance issues.
Extensive experience in implementing SSIS, SSRS, SSAS using Microsoft Business Intelligence development studio MSBI and SQL Server data tools SSDT.
Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
TECHNICAL SKILLS
BI Tools
SSRS 2012,2016, Tableau 10(Desktop, Reader, Public, Online), Crystal Reports
ETL TOOL
Informatica Power Center 9/8, SSIS, SSAS
Language
SQL, PL/SQL, TSQL, Python(Numpy, Pandas)
RDBMS
Oracle 9i, 10g,11g
Database
Oracle, MS SQL Server, MS Access, DB2.
Development Tools
Microsoft Visual Studio .NET 2005/2008/2010
Operating Systems
Windows 7, 8, 10/NT/2000/XP/2003
Programming Languages
VB, .Net, Java, Python, C++, Scala, Matlab
UX design tools
Sketch, Zeplin
Data Modeling Tools
ERwin r7.1/7.2/7.3/8.0
Networking
Ethernet, TCP/IP, VPN, LAN/WAN
EDUCATION
Bachelor of Technology, Computer Science, GITAM University, India.
PROFESSIONAL EXPERIENCE
Harland Clarke Holdings Corp, TX
Role: Tableau developer Jan 2017- Present
Harland Clarke Holdings is a portfolio of companies focused on optimizing client relationships through multiple channels by enabling them to acquire, retain and grow their customer base. Its major business units, Harland Clarke, RetailMeNot, Scantron and Valassis are recognized as leading providers of marketing and transaction solutions, incentive advertising, education solutions and intelligent media delivery that creates millions of customer touch points annually for their clients.
Responsibilities:
Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
Implemented security at the data and object levels as per the business user requirement.
Used appropriate filters, column filters, prompts, dashboard prompts and calculations in tableau reports.
Mastered the ability to design and deploy rich Graphic Visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop and publish them to server
Involved in Data Filtering and Data Cleaning
Scrapped data using Python-Pandas, NumPy libraries for geospatial data from text files and excel sheetsConducted data analysis, handled missing and duplicates value and performed data analysis and visualization using Python (Numpy, Pandas, Matplotlib, Seaborn)
Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
Migrated Tableau server from 10 to 10.5
Administered user, groups and scheduled instances for reports in Tableau server.
Developed Stored Procedures, Functions, Packages and SQL Scripts using MS SQL.
Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
Built complex calculations using advance functions such as LOD, DATE functions, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, CASE WHEN, Table calculations and WINDOWS functions.
Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012
Created Actions in Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
Deployed Tableau dashboards in production after user acceptance test clearance.’
Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
Effectively used data blending feature in Tableau.
Creating users, groups, projects, Data connections, settings as tableau administrator.
Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
Good Experience in using URL’s, hyperlinks and filters for developing complex dashboards.
Created multiple automated reports and dashboards sourced from data warehouse using Tableau/SSRS
Scheduled data refresh on Tableau for Daily and Weekly increments based on business change to ensure that the views and dashboards displaying the changed data accurately.
Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Followed Agile Methodology, Adherence to the Agile Scrum Methodology and following up on work on items Rally
Performance tuning of workbooks, data sources, and providing best practices for user community.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data
Experience in Tableau Installation (Desktop as well as Server)
Administered user, user groups, and scheduled instances for reports in Tableau.
Monitored and maintained incremental refreshes for data sources on Tableau server.
Worked on both system administrators and site administrators with the correct permissions to add users from the Users page.
Interacted with the Business Admin and gather the requirements and analyzed.
Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.
Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
Environment: Tableau server/Administration, MS-SQL Server 2014/2012, MS SQL Server Integration Services, Crystal Reports, MS Visual Studio 2012, Tableau Desktop 10,9, Tableau Server, Rally
Axon Communications, MA
Role: Tableau developer Dec 2015 – Dec 2016
Axon Communications is at highest position of any healthcare communications agency. AXON, a global healthcare consulting firm, harnesses the diverse expertise of our talented team to help our clients create science-based strategies and drive stakeholder activation. AXON serves the healthcare communications needs of clients in the pharmaceutical, medical devices and health services areas, from offices in the UK, US.
Responsibilities:
Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
Converted SSRS and MicroStrategy reports into Tableau.
Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
Analyzed existing report requirements with end user and converted them for reporting using Tableau.
Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
Worked with Tableau administrator in managing Production, Test and Development environments.
Used data blending feature in tableau and defined best practices for Tableau report development.
Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
Prepared and published customized reports/dashboards.
Created different type of charts.
Created worksheets and dashboards by using custom queries and multiple tables.
Created data visualizations using various visual objects and Published reports and dashboards to the Power BI service through the Office 365 integration.
Implemented row level security by restricting the users for the data access.
Applied various types filters like Data source filters, Quick filters and Context Filters, Cascade Filters and Global Filters.
Developed reports using Microsoft Power BI
Deployed reports and configured security and subscriptions for the reports Created User Defined Tables UDT s and used for the creation of stored procedures.
Created table calculations, calculated fields and parameters.
Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
Created reports using Custom SQL for complex report views.
Executed and tested required queries and reports before publishing.
Developed Geo Maps to show details on customer distribution across United States.
Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
Make use of data modeling techniques in designing the data marts project.
Created Custom Hierarchies to meet the Business requirement in Tableau.
Created reports in Tableau using SSRS SQL Queries and Stored procedures.
Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
Provided support for Tableau developed objects and understand tool administration.
Executed and tested required queries and reports before publishing.
Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
Environment: Power Bi, Tableau 7.x (Desktop/ Server), MicroStrategy (Desktop/Web), SSRS, Oracle, Microsoft SQL Server, Toad, Microsoft Office Suite (Word, Excel, PowerPoint, Visio).
InvestoPresto Ltd, Hyderabad, India
BI Tableau / SQL Developer March 2013 - Nov 2015
Responsibilities:
Worked as part of a team for gathering and analyzing Business Requirements.
Participated actively in designing the system database structure.
Handled Tableau admin activities granting access managing extracts and Installations.
Responsible for MS SQL Server 2012, SQL2008 R2, 2005 Installation, Configuration and Tuning.
Performed performance tuning of stored procedures using SQL Server Profiler.
Involved in the development of custom stored procedures, functions.
Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Developed SSIS Packages for migrating data from Staging Area of SQL Server 2005 to SQL Server 2008.
Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
Handled Full load and refresh load via staging tables in the ETL Layer.
Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
Built Reports in SSRS for errors generated in SSIS Packages.
Designed, coded and implemented ad hoc reports using existing report models in SSRS.
Created & managed schema objects such as Tables, Views, Indexes & referential integrity depending on user requirements.
Developed various T-SQL stored procedures, triggers based on the requirement.
Defined Check constraints, Business Rules, Indexes and Views.
Involved in tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Generated Reports using Data Source Views in Visual Studio.
Developed Reports Using SSRS on statistical data during migration of data.
Created Drill Down, Drill through, linked and sub reports using SSRS.
Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
Environment: SQL Server 2005/2008/2012, T-SQL, Windows XP, Visual Studio, Report Builder, SQL Profiler, SSIS, SSRS, JIRA
Contact this candidate