SUMMARY:

­

• Overall 8+ years of experience in Design, Analysis, Development and implementation of several applications using BI tools (TABLEAU, ORACLE BI).
• Experience in data warehousing and business intelligence in various domains
• Micro Strategy Professional with extensive experience in BI project implementation, architecture, development and administration.
• Expertise in creating EPICS/user stories for the Design, Development and implementation (DD&I) in BI tools like Power BI, Tableau, QlikView.
• Expertise in using Micro Strategy product suite which includes Micro Strategy Intelligence Server, Micro Strategy Desktop/Developer, Narrowcast Server, Micro Strategy Architect, Administrator, Micro Strategy Office, Web, Visual Insight, Micro Strategy Object Manager
• Understanding and Implementing the security principles and applying them on the health (HHS) domain using ADA standards.
• Good hands on experience in implementing dashboards, Visualization and analytics using Tableau Desktop and server for the performance data metrics and Visualization in the BI environment.
• Created Tableau scorecards, Dashboards using stack bars, Bar Graphs, Scattered plots, Geographical maps using functionalities.
• Good experience on dashboards Designing with large data volumes from various data sources (Teradata, Sqlserver etc.,)
• Experienced in Analyzing the BI needs, interpreting business user requirements and translating them into reports.
• Strong experience in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS/MACRO.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Proficient experience in different Databases like Oracle, SQL Server
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Created new programs using SAS macro variables to improve speed of modification as well as consistency of results.
• Experience & skills in Predictive Modeling for Insurance and Direct Marketing. This includes planning & executing Analytical Projects.
• Experience in Software Development Life Cycle (SDLC) using JIRA that include roles in providing documentation on design, testing and migration from development to production.
• Good interaction with clients in terms of understanding Business Applications, Business Data Flow and data relations.
• Good at understanding of technical trends, architecture and highly motivated to know about latest technology, new software and products.
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Experienced in Scrum, Rapid, Iterative, JIRA, Waterfall methodologies.
• Good at handling multiple tasks concurrently and meet the deadlines.
• Highly results oriented, self - starter looking for challenges, ability to rapidly learn and apply new technologies and great interpersonal skills.

TECHNICAL SKILLS:

Data/Business Analytics: SAS 9.2 SAS/Base, SAS/SQL, SAS/STAT, SAS/ODS, SAS/Graph

Statistical Programming: SAS, R

Databases: Teradata, Oracle 10g, MS SQL Server

BI and Reporting: Tableau 9.1/8.3/8.2/8.1/8.0/7.0 , MS Excel, OBIEE

ETL Tools: Informatica, Microsoft SQL server Integrated Services.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL
• Server for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing a business user to understand where we have most users vs. least users.
• Worked closely with business power users to create reports/dashboards using Tableau desktop.
• Created Trend Lines and changed the formatting of the dashboard.
• Created Bar charts and Tableau Reports as per the business Requirement and created the own template by pulling the table or view from vector wise
• Gave permissions to specified Business users to access the Reports
• Replace the data sources by adding the flat table for improving the performance on Tableau side
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization like Purchasing, Sales etc.
• Defined best practices for Tableau report development.
• We strictly use ADA standards with accessibility guidelines which are issued by the Department of Justice.
• Involved in the gathering of business requirements and translating them to the report specifications for the MicroStrategy platform.
• Effectively used data blending feature in tableau to get data from SAP BW & Sybase using JIRA.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created Custom Hierarchies to meet Business requirement in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and data before publishing Dashboard.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created Dual Axis, side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Used Group functionality to group all small products and named as other for Business flexibility.
• Consistently attended meetings with the Client subject matter experts to acquire functional business
• Requirements to build data and relation that would be used in dashboards to satisfy the business needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.1
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Responsible for developing provisioning reports for various groups and upper management.
• Experience on writing SQL Queries.
• Strong verbal and written communication skills, ability to work effectively with user departments.
• Worked towards the goals of quality, time and budget.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, Business Objects, SQL Server 2008/2012SQL, PL/ SQL, Crystal Reports, Xcelsius, Web Intelligence, Info view, MS Project.

Confidential, Nashville, TN

Tableau Developer

Responsibilities:

• Solicited business requirements from various departments like Accounting, Human Resource through surveys, interviews and JAD sessions.
• Involved in Data analysis and data profiling to generate information about clients and their attributes like institution, site, and buildings. This data was structured and were pushed into requisite Tables in Tableau for clear understanding.
• Developed complex T-SQL code for data retrieval and designed the entire Portal Database using ER Diagrams.
• Designed, developed and deployed DTS packages to retrieve data from various departmental systems into the Employee Portal database.
• Developed Reports using Cognos Report Studio including conditional blocks, conditional formatting and Static Variables.
• Created complex Dashboard reports using multiple queries in Tableau / Cognos Report Studio targeting different Business units, for strategic reporting.
• Responsible for data retrieval by extensive use of multiple joins normalization and views to create visualizations in Tableau.
• Extensively used OLEDB, Text Box, Command Button, List Box, Combo Box, Data Grid and all other components of Visual Basic.
• Created Hierarchies to meet Business requirement in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tabular reports in SSAS, Cross Tabs, Drill down, Charts, Functions and Maps
• Provided effective work independently from specifications and with a diverse group of developers and end users to analyze business needs and translated that need into deliverables.
• Responsible for developing processes for automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Understand SQL server cost-based optimizer (parse and binding to SQL execution) to a great degree, which helps tune queries. That covers all the physical operators like nested loops/merge/hash and exchange operators and threads in the plan and Index approaches.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Involved in Performance tuning, query-inventory, analysis and optimization.
• Generated reports using “Tableau”
• Created and managed database users, login Ids and security.
• Responsible for performing complete back up and restoration, database maintenance Service pack updates on server and client.
• Created canned reports and hosted it in the web Portal for the users.

Environment: SQL Server 2008 R2, SAS, SQL, Tableau Desktop 8.0.

Confidential

SQL Server Developer

Responsibilities:

• Installation, Configuration and Maintenance of MS SQL Server 2005.
• Extensively involved in architecture of Customer Database.
• Created & managed the Database Users, Login Ids and Security.
• Created the Backup and Recovery policy for the databases.
• Performed data transfer/migration using Export/Import and Data Transformation Services.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Created and running DTS Packages for Import and Export of Heterogeneous Data.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Validated Backup Integrity as part of disaster recovery plan.
• Created database administrative job of Security, Backup/recovery, ODBC connections etc.,
• Provided support to the Application developers on the application databases.
• Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.
• Created the SSIS packages to import partner flat files into the OLTP.
• Created complex Stored Procedures, Triggers and User Defined Functions.

Environment: SQL Server 2005, Oracle 8i