Created Stored Procedures and performed Index Analysis for slow performing SSRS reports to bring down the report rendering time from 15 mins to 30 seconds.Įnvironment: Oracle 10g/11g, PL/SQL Developer, SQL* Loader, SQL Developer, Oracle Enterprise Manager, Windows 2000, ETL Tool, SSIS, SSRS, TABLEAU 8.0, UNIX.Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.Worked on data validation using VLOOKUP functions and table formulas in MS EXCEL. Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.Developed Ad-Hoc report model and charts using SQL Server Reporting Services (SSRS) based on requirements.Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008 R2/2012 Analysis Services (SSAS) and Reporting service (SSRS).Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.Used SSIS and Confidential -SQLstored procedures to transfer data from OLTP databases to staging area and clean data and store in Centralized SQL Database.Developed complex calculated measures using Data Analysis Expression language(DAX).Worked with other functional teams within IT and the Business to identify opportunities for process improvement and assist in the implementation of those agreed.Operating Systems: MS Windows 10/8/7/XP, UNIX Tools: SSIS, SSRS, SSAS, Tableau, Power BI, Informatica, Power Pivot, DataStage, QlikView, Cognos, JIRA. Microsoft Office Suite: MS WORD, MS EXCEL, MS VISIO, POWERPOINT, OUTLOOK. Web Technologies: HTML5, HTML4, CSS3, XML, Java Script.ĭesign& Simulation Tools: SQL Server Management studio, Oracle Designer, Erwin Modeler, TOAD Modeler, Visual studio, Oracle SQL Developer, PL/SQL Developer, B.I.D.S for DTS Strong analytical and problem-solving skills coupled with excellent written, verbal and soft skills.Experience working in Agile and Waterfall model working methodologies.Experience in creating reports by using Dashboards Strategy Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8.2, 8.1, 8.0, Tableau 7 and Tableau 6.Good knowledge of SSRS Architecture and Hands on experience in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.Good Knowledge in Analyzing, designing, building &, testing of OLAP cubes withSSAS and in adding calculations using MDX.Experience in Dimensional Modelling and Data Visualization using SSAS, Microsoft Power BI, Power Pivot and Database design using RDBMS.Excellent Confidential -SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and running Database Consistency Checks using DBCC Utilities.Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.Experience in designing conceptual, logical and physical database models using Erwin.Experience in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data).
Tableau reader 8.2 download software#
Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery, requirements gathering, functional gap analysis, module setup script generation testing and production support.
Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools like Informatica, DataStage and worked on OLAP, OLTP and Data Warehouse Reports using Business Objects and Crystal Reports.
7 yearsof experience as a BI developer/Analyst in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) and SQL server.
0 kommentar(er)
