SUMMARY:

• 6 years of experience in Information Technology in designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments. Core focus on Data Warehousing OLAP tools, BI and PL/SQL.
• Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Extensive experience in working with Tableau 8.0 Workbooks, OBIEE Answers and Intelligent Dashboards.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Used Tableau Desktop for creating different interactive views and Dashboards.
• Expertise in Tableau v8.x/7.x/6.x.
• Expertise in OBIEE 11.1.1.5/10.1.3. x and Informatica 8.6.1
• Involved in Tableau Server installation, configuration, creating Users, Groups, Projects and assign Privileges etc.,
• Experience in IBM Cognos, creating complex reports using Report studio and dashboards using Cognos workspace with the use of prompts, filters, parameters and variables.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema, Snowflakes modeling, fact and dimension tables modeling of data.
• Expertise in design and development of three layers (Physical, Business model and Presentation) of an OBI Metadata Repository using Oracle BI Administration tool.
• Hands on experience in gathering business requirements and creating functional and technical requirement specification documents.
• Involved in setting up IBots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Experienced in configuring the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication.
• Developed the OBIEE Metadata repository (.rpd) model with for Sales & Marketing subject areas that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies & time series functions, Presentation layer with catalogs & folders using Oracle BI Administration tool
• Expert in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model& mapping layer.
• Experience in Data Warehousing development and ETL methodology using Informatica Power Center 8.6.1.
• ETL experience using Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer - data transformation and mapping issues, Mapplets, Transformations).
• Experience in Oracle 11g/10g/9i/8i, SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.

TECHNICAL SKILLS:

Operating Systems: Windows NT/98, XP, 2000,7, UNIX, LINUX,SOLARIS

Application Software: MS Office - MS Word, MS Excel, MS PowerPoint, OPEN OFFICE

Databases: SQL Server, Oracle, DB2

Web Technologies: HTML, XML, JSP, Ruby Weblogic, Apache Tomcat, Apache Camel, Apache CXF, Websphere, GIT ECLIPSE

Methodologies: RUP, Waterfall, SCRUM, AGILE, Liquidity, Risk management

Requirements Management Tools: Rational Requisite Pro, MS Visio and MS Office, JIRA, Confluence

Testing Tools: Quality Center, Test Director, WinRunner, LoadRunner

Process Modeling: MS Visio, Balsamiq Mockup and Rational Rose

Documents & Processes: SRS, BRD, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modeling, Project Planning & tracking

Reporting Tools: MS SQL Server Management Studio

Languages: C/C++/C#, Java, Sql Server 2008, Oracle, RDBMS, UNIX, Web (PHP, Laravel, Html, MySQL, Java ScriptTools: Tableau 7.0,8.0,8.1,8.2,9.0,9.1 Eclipse, MyEclipse, NetBeans, Adobe Dreamweaver, Fantaculous, RVSiteBuilder, Cpanel, Whm panel, NodeJS, GIT Hub for eclipse

EXPERIENCE:

Confidential

Sr. Tableau Developer

Responsibilities:

• Involved in gathering Requirements.
• Creating Tableau Reports and Dashboards related to Billing for different fragments.
• Configure and optimizeTableauServer per specified requirements and timelines.
• Working on different types of reports like Bar, Line, Geographic, Pie and Text tables.
• Involved in creating Calculations, Filters, Parameters, Sets, Actions and Formats..etc.
• Involved in Blending the axis and Data blending from various data sources.
• Experience on KPI (key performance Indicators) in profits area wise and year wise
• Creating Customized and Interactive dashboards using data sources and custom objects.
• Attending the weakly Status call with Offshore and onsite teams.
• Installation and configuration of Tableau Server Cluster(Primary, Worker, Backup Primary) and its processes (SQL Server, Application Server, Data Server, Data Engine, Background Tasks, and Repository). Configured SMTP, SSL and Windows AD.
• Handled Tableau admin activities like granting access, managing extracts, patches, upgrades and installations.
• Created users, groups and domains from Active Directory and created different license levels for each user.
• Took backup of the Tableau server on regular basis by using Tabcmd, Tabadmin commands also developed restoration procedures to restore the server during system failures.
• Created adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau adhoc reports.
• Generated Tableau dashboards with combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields within Tableau reports to facilitate automated data visualizations.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.
• Involved in requirement gathering, reviewing requirements and data sources for design, development, and testing and production rollover of reporting and data visualization projects using Tableau
• Performed super user s in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote the usage of Tableau.

Environment: Tableau Desktop 7.x/8.x, Tableau Server 7.x/8.x, Tableau Reader 7.x/8.x, SQL Server 2005/2008/2012, Designer, BI, Dashboard/ Crystal Reports 2008/2011, SQL.

Confidential, Salt Lake City, UT

Tableau Developer/ Data Analyst

Responsibilities:

• Used Tableau Desktop for blending databases and create interactive views and dashboards
• Created multiple scorecards and dashboards
• Performed data analysis on daily, weekly and monthly basis to ensure that the developed dashboards are up to date live and sent those into production
• Actively involved in new KPI generation for tableau Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Identified new metrics and enhance the existing KPI's.
• Worked extensively using Excel to validate the data and use as the source data files.
• Converted existing Excel reports in to Tableau reports
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Developed efficient & custom SQL statements for report and analyzed data to identify for data inconsistencies and fix.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with Teradata database and pull data to work on BI requirement.
• Provided Ongoing support to BI application running in production & troubleshoot.

Environment: Tableau (Desktop), Teradata, SQL, Teradata SQL Assistant, Teradata Administrator, Microsoft Office Suite (Word, Excel, Power Point, Visio, Outlook).

Confidential, Wilmington, NC

Cognos Developer

Responsibilities:

• Generated catalogs by connecting to different databases.
• Developed reports from multiple queries using Impromptu and Power Play, and published them for end-users in Upfront.
• Created various types of reports such as List, Grouped List, Crosstab, Nested Crosstab, Drill through, and Standard List
• Created cascading prompts and worked with various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
• Customized Power Play Reports by using Slice and Dice, Drill through, Ranking, Conditional formatting, and Sorting options.
• Worked with the join functionality to create various reports.
• Experienced Cognos 8.4 BI Studio, Cognos 8.4 Framework Manager, Cognos 8 Administration.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management.
• Generated reports for comparative analysis based on the Projected v/s Actual.
• Used Cognos Scheduler to update a report for specific or recurring times and dates
• Designed Multi-Dimensional Cubes using Transformer and Optimized Cube performance to improve report run time.
• Installed Cognos v8.x on Windows environment with Oracle 10g as a backend database
• Deployed cube security to give only specific users the access to specific hierarchies.
• Designed and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked on Informatica for master data management, data migration
• Experienced with TM1Executive Viewer for pivoting, drilling, charting and conditional formatting.
• Successful implementations of the Analyst, Manager, and Contributor applications within Cognos 8 Planning
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)

Environment: Cognos 8.4/8.2/10.1, Planning, Impromptu, Impromptu Web Reports (IWR) 6.6, Power Play 6.6, Power Play Transformer 6.6, Upfront, Access Manager, and SQL Server

Confidential

SQL Server Developer/BI Developer

Responsibilities:

• Involved in the full life cycle of this enhancement (Analysis, Development, Implementation and Testing).
• Unit, System, Integration and Regression testing of the procedures.
• Tuning and optimization of the stored procedures.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Created SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented stored procedures and triggers for automating tasks.
• Performance tuning and optimization of procedures and queries.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio (SSMS), T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent, IBM Cognos 8.4/8.2