![]() Used log shipping for synchronization of databases.Monitored & modified Performance using execution plans and Index tuning.Expertise in SQL server reporting Services (SSRS) & SSAS (Building OLAP cubes). Rebuilding indexes at regular intervals for better performance.Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).Created the SSIS /DTS packages and scheduled them using SQL Server Agent.Worked on SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart, Pie Chart reports to analyze critical data in SSRS.Migration of databases from SQL Server 2008 R2 to SQL Server 2012for various environments.Produced custom, on demand BI reports for the Business Development and Content Acquisitions Team.Used advanced calculations, Custom Visuals and Groups Creation using MS Power BI Desktop.Creating calculated measures and columns with DAX in MS Power BI Desktop.Developing Power BI reports & effective dashboards after gathering and translating end user.Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.Created Rich Graphic visualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.Extensively created visualization dashboards for the claims.Created dashboard views from provider information data to members.Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.Created workbooks and Dashboards using calculated metrics for different visualization requirements.Understanding existing business model and customer's new requirements.Tableau Developer (SQL/SSRS/SSIS/BI/Tableau) Methodologies: Agile Methodology, Scrum Model, Waterfall Operating Systems: Windows XP/7/8/10, Macĭefect Tracking/Management: Quality Center, Test Director, Version Manager Programming Tools: Java, C, C++, SQL, TSQL, PL/SQL Web Server: Internet Information Server (IIS) Programming Languages: SQL, T-SQL, PL/SQL Developments Ms-office suite, MS Visio, Dream Viewer Tableau: Tableau 8.0/9.2, Tableau server 8.2/9.2, Tableau Reader 8.1/8.2, Tableau, Tableau Public 9.2ĭatabases: PostgreSQL, MS SQL Server, MS Access 2000, Oracle10g Reporting Tools: SQL Server Integration Services (SSIS), Crystal Reports. Good knowledge in Selenium IDE Experience on manual and automation testing and knowledge in QlikView.Experience in automated testing tools Mercury Interactive/HP QTP, Load Runner, and Quality center.Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.Improved Reports performance in Tableau using extracts and context filters. Expert in Tableau server commands like synchronization, TabCmd and Tableau server backup activity.Proficient in SSIS to develop Crystal Reports for extracting, cleaning, transforming and loading data into warehouse.Proficient working SQL databases with stored Procedures, Triggers, User-defined Functions, Views and Cursors using PL/SQL, T-SQL.Good knowledge in implementing ETL enterprise solutions with IBM DataStage.Thorough knowledge of Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.End to end experience in designing and deploying data visualizations using Tableau.Ability to design & deploy rich Graphic visualizations with drill-down & drop-down menu option and Parameterized using Tableau.In - depth knowledge of Tableau Desktop, Tableau Reader and Tableau Server.Good experience to translate the reports to web using HTML or JavaScript.Experience in creating solution driven dashboards, worksheets using calculations, parameters and then creating different types of chart in Tableau Desktop environment.Skilled in Tableau Desktop for data visualization, Reporting and Analysis generated various plots that is maps.Experience in Statistical Analysis Software (SAS) for developing and implementing various applications.Experience in Agile and Waterfall project management methodologies. ![]() Eight years of referable IT experience in Software development life cycle (SDLC) including Analysis, Design, Development, Integration, Implementation, Testing, Deployment and Maintenance with Business Intelligence Tools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |