SUMMARY:

• Over 9+ years of experience in field of IT and market research industry with skills in reporting, and business intelligence tools including 6+ years of development experience in Tableau 6.x/7.x/8.x/9.x and 3+ years of experience in SQL
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Server with data blending, filters, aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters
• Having experience in connecting to various sources like SQL server, Oracle, Google analytics, Google Big Query, excel, access, DB2, TeraData etc.
• Hands on Experience with Microsoft Word Alteryx Designer 10.1 where I have used this data engine for delivering demographic - based mapping.
• Strong experience in new application developments and enhancements of existing applications using SAS by following Software Development Life Cycle (SDLC) i.e. and knowledge of all phases of Agile, Scrum and the iterative Rational Unified Process (RUP). 
• Strong experience in Reporting and ETL (Extraction, Transformation and Loading) using BASE SAS and installed a licensed copy of SAS (ODBC) drive.
• Created offline, online maps and custom geo coding and WMS-server (Web Map Service) to build spatial visualizations of non-geographic data
• Accessed keys for the AWS account and grant permissions to create Amazon VPC networks and launched Amazon EC2
• Build a cloud and configured network and security.
• Create Custom Attribute views, Analytical Views & Calculation Views in SAP HANA. 
• Configuration of the SAP HR System and working with Business teams and peers for the analysis and requirement gathering.
• Include the Javascript API file from the Tableau server that hosts the visualizations.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization. 
• Implemented new security organized at folder level in Cognos
• Prepared the Estimation of Efforts for the Development of Cognos Reports. 
• Involved in Creating Package for report generation using Framework Manager Module in Cognos 8. As a part of Package development, created views, different query subjects, cardinalities. 
• Install the Cloudera(Hive), Amazon EMR ODBC driver from the Drivers page
• Experienced in requirement gathering, marketing/consumer analysis, design, development, testing, and production rollover of reporting and analysis projects. 
• Worked with Teradata utilities like BTEQ, Fast Load, Multi Load to export and load data to/from different source systems including flat files. 
• Loaded tables in hive to netezza through SAS and then used tableau for visualization.
• Creating trend lines and dynamic reference line. 
• Involved in installing the Tableau SDK by gathering the requirements, downloading the package, setting environment variables.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau. 
• Used Table calculations like running average, difference etc based on scenarios to get meaningful data. 
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop. 
• Used logical, string type and various functions in creating calculations. 
• Creating necessary filters and make sure the security features are enabled while publishing the dashboards. 
• Ability to use custom SQL for complex data pulls. 
• Efficient in designing Tableau workbooks and worksheets to make effective Dashboard/Reports. 
• Experience in writing complex SQL queries to perform End-to-End ETL validations and support Adhoc business requests. 
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches. 
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server 
• Coordinate with members of the QA team to create a QA test plan and resolve issues/bugs identified during testing. 
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

BI Tools: Tableau 6.x/7.x/8.x/9.x (Tableau  (Desktop & Server),Crystal Reports 2008 XI, Xcelsius, MicroStrategy 9.2.1, SAS EG

Databases: IBM DB2, Oracle 9i/10g, SQL Server 2012/2008/2005 , MS Access, MongoDB

Data Modeling: Dimensional Data Modeling, FACT and Dimensions Tables, Star Schema, Snowflake Schema, OLAP, OLTP Physical and Logical Data Modeling

Programming Languages: T-SQL, SQL,PL/SQL, C, C++,XML

Technologies: HTML, CSS, Bootstrap, JQuery, Angular.js, Javascript

Packages / Tools: MS Office, Toad, Putty, SQL Server Management studio, Microsoft Visual Studio, MS Excel, Informatica

Operating Systems: Windows XP, Windows, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Northbrook, IL

Sr. Tableau Developer

Responsibilities:

• Scope of the project was to enhance the Insurance App's systematic processes. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability to get better understanding of future enhancements. 
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Navigated Amazon VPC console and Launched Amazon EC2 instance and created a static IP address for the VPC
• Involved in the process of renaming the created extracts by Tableau SDK.
• Objects are cleaned up properly, especially in non-native execution environments by using Tableau SDK
• Hands on Experience with Microsoft Word Alteryx Designer 10.1 where in this project I have worked with unified spatial and non-spatial data environment.
• Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App's by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases. 
• Involved in project planning, scheduling for database module with project managers.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat. 
• Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes. 
• Create authentication, query process, cancellation cloudera.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau. 
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Reporting and retrieving 'reasonable' amounts of data using SAP BW.
• Created authentication and authorization and passed the credentials to the SAP BW USING tableau.
• CRM migration to HANA from SQL Server and windows. 
• Created dashboards on the Payroll areas (accounting areas) as per the enterprise using SAP HR needs and grouped together the personnel numbers that are to be processed & determined the Payroll periods.
• Defined and maintained date and period modifiers to change payment dates as per requirement
• Configured tax models as per the requirements. Created visualized reports based on Garnishments, Taxes, BSI Tax factory setup, updates & upgrades. Acted as turnaround specialist in addressing tax issues and reciprocity issues.
• Configured Unemployment tax rates and configured BSI tax factory.
• Migration optimization by table splitting, tune parameters, package splitting and Distmon. 
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Converted metric insight reports to tableau reports.
• Executes a query and pulls the data it need from Netezza to build a visual.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

ENVIRONMENT: Tableau Desktop 9.3/8.1, Oracle 10g, Excel, SQL, SQL Server 2008, SQL BI Suite, MS Office, Visual Studio 2010, WCF web service, Base SAS v9.2, SAS/Macros, SAP HR ECC 6.0, Netezza

Confidential, St. Paul, MN

Sr. Tableau Developer

- Responsibilities: 

• 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.  
• Studied and analyzed similar applications and brainstormed with business team to Gather Effective Requirements for the system along with dashboard development. 
• Handled Tableau admin activities like granting access, managing extracts, patches, upgrades and installations. 
• Created WEBI reports using combined queries, merging dimensions and complex calculations, filters to satisfy the end user requirement.
• Designed and maintained Universes and exported them to the repository.
• Developed WEBI reports on SAP BW Queries using BICS in Business Objects 4.0/4.1
• Design and development of Xcelsius dashboards as per the requirement.
• Extensively involved in creating database packages, procedure functions, cursors and triggers using PL/SQL.
• Created users, groups and domains from Active Directory and created different license levels for each user. 
• Creation of Attribute views, Analytic views and Calculation Views based on replication data using HANA modeler
• Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
• Took backup of the Tableau server on regular basis by using Tabadmin commands also developed restoration procedures to restore the server during system failures. 
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insight into large data sets. 
• Created various types of charts like Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization. 
• Worked in Migration project Tableau 7.0 to Tableau 8.0. Worked with the Tableau desktop users in migrating their local desktop workbooks to Tableau 8.0. 
• 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 trainings in Basic and Advanced Tableau Desktop. Participated and organized various super user symposiums to promote the usage of Tableau. 
• Business requirement analysis, technical architecture design, access and security specifications. 
• Interact with users and super users to gather requirements for reports and worked with the business intelligence team to develop business critical reports. 

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/Xcelsius, Scheduler, Crystal Reports 2008/2011, WEBI reports.

Confidential, Rockville, MD

Tableau Developer

Responsibilities: 

• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards 
• Administered user, user groups, and scheduled instances for reports in Tableau. 
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1 
• Resolved various performance issues and analyzed the best process distribution for different projects. 
• Created and assisted users in Tableau dashboard development 
• Optimized queries by looking at Execution Plan for better tuning of the database. 
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio 
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains. 
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports. 
• Developed business process and technical design documentation for each reporting service developed in this project. 
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic. 
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures. 
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment. 
• Perform UNIT testing and help the UAT testing team to performing various testing scenarios. Fix the JIRA tickets raised during the UAT testing. 
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data. 
• Participated in daily scrum calls, reviews, and user group discussions as well as communicating with stakeholders and business groups. 

ENVIRONMENT: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, SQL Server 2008, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service

Confidential, Pittsburgh, PA

Tableau Developer/ Cognos Developer

Responsibilities: 

• API data was extracted by DBA that was put into SQL Server or Flat File and I was plugging that data into Tableau from either flat file or SQL Server. 
• Involved in End-to-End Implementation and Enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos. 
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports
• Worked with DBA in creating aggregate tables to increase the performance and meet the requirements. 
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau. 
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's 
• Used Multiple Input Filters, Memory data sorter, Nested Reports, Sequential / Parallel Section, Use of Actuate Foundation Classes, Sub classing and customizing Frames and Data Controls 
• Created configuration files to include the libraries ROL in the Actuate reports. 
• Converting existing MS Access/ Spreadsheet Reports to Actuate e.reports 
• Defined best practices for Tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards. 
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems 
• Connected Tableau server with share-point portal and setup auto refresh feature 
• Developed, deployed and monitored SSIS Packages for new ETL Processes. 
• 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) 
• Coordinated database middleware issues with DBA's, system performance with System Architects. 
• Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop. 
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application. 

ENVIRONMENT: Tableau Server 6/7, Tableau Desktop 6/7, MS SQL Server 2008, Oracle 10g, Business Objects 3.1, Cognos 10, Cognos Series 8.3/7.4 (Power Play Transformer, Framework Manager, Dashboards), Informatica

Confidential, NYC, NY

SQL/ETL Informatica Developer

Responsibilities:

• Perform database consistency checks at regular intervals. 
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups. 
• Created and monitored Database maintenance plans for checking database integrity.
• Created and Tested Backup and Recovery Strategies.
• Accountable for Technical analysis and Design Specifications to meet Project expectations. Design, Development, Testing & Implementation using Industry leader in ETL tool, Informatica. 
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations 
• Created several valuable reports (i.e. Sales Summary, Auditing Reports, Matrix Style Sales Trending Report by Customers/Time/Region using Tabular data and Charts etc.) for Business users using SQL Reporting Services.
• Created Data Models using Erwin tool. 
• Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data. 
• Knowledge of Database Performance Monitoring tools. 
• Developed reports using complex formulas to query the database to generate different types of Ad-hoc reports using Crystal Reports. 
• Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment 
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.1. 
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings & Mapplets using various Transformations. 
• Extensively used Informatica Repository Manager and Workflow Monitor 
• Migration from SQL Server 7.0 to SQL Server 2008 
• Maintained and improved high availability and disaster recovery strategies for the database and fail-over methods. 
• Experience in debugging mappings; Identified bugs in existing mappings by analyzing the data flow and evaluating transformations 
• Managed user access and security tasks and created and managed new security accounts.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

ENVIRONMENT: SQL Server 2008 Enterprise Edition, T-SQL, Excel, Erwin, Windows 2008/XP, Visual Studio, Crystal Reports, Informatica 7.1/8.6.

Confidential, NYC, NY

SQL Developer

Responsibilities: 

• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA. 
• Supported the production team when issues rise in the packages. 
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers& maintaining Referential Integrity. 
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs. 
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security. 
• Designed and implemented several complex reports and administration modules. 
• Created DTS package to schedule the jobs for batch processing. 
• Designing & Development of Standard Reports, Sub Reports, Cross Tab Reports and Charts using crystal Reports. 
• Exported crystal/SSRS reports into various formats like PDF, HTML, Excel and Word for end users. 
• Involved in configuration of Report server and report manager scheduling, give permissions to different level of users in SSRS.
• Configured Reporting Services in SQL Server 2005. . 
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling. 
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects 
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc. 
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other. 
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.

ENVIRONMENT: SQL Server 2000, SQL Server 2005, T-SQL, Visual Studio 2005, MS Excel, Ms Office 2003/2007