SUMMARY

• Over 9+ years of experience in field of IT and market research industry wif skills in reporting, and business intelligence tools including 6+ years of development experience in Tableau 7.0/8.1/8.2/9.2/9.3 and 3+ years of experience in SQL
• Worked wif database administrators to plan and implement use of database resources.
• Involved in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Server wif 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, MongoDB etc.
• Familiar wif MongoDB clusters, performance tuning, backup and recovery.
• Hands on Experience wif Microsoft Word Alteryx Designer 10.1 where me has used this data engine for delivering demographic - based mapping.
• Worked as Tableau SME in standardizing Tableau for shared service deployment.
• Strong experience in new application developments and enhancements of existing applications using SAS by following Software Development Life Cycle (SDLC) me.e. and noledge 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.
• Installed a licensed copy of SAS (ODBC) drive.
• Used the R functionality in workbooks.
• 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.
• Expertise in designing and creating various analytical reports and Dashboards to halp 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.
• Extensive experience wif all areas of MicroStrategy including Dashboard development, Administration, Web and Intelligence Server monitoring/diagnostic and resource optimization
• Worked wif Teradata utilities like BTEQ, Fast Load, Multi Load to export and load datato/from different source systems including flat files.
• Creating trend lines and dynamic reference line.
• Used Hibernate as the object relational mapping tool for persisting Java objects.
• Mastered the ability to design and deploy rich Graphic visualizations wif 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 TEMPeffective 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 wif members of the QA team to create a QA test plan and resolve issues/bugs identified during testing.
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

BI Tools: Tableau 7.0/8.1/8.2/9.2/9.3 (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.
• Gatheird business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction wif the data warehouse architect on the development of logical data models using ERWIN.
• Navigated Amazon VPC console and Launched Amazon EC2 instance
• Created a static IP address for the VPC
• Studied and analyzed similar applications and brainstormed wif business team to gather TEMPeffective requirements for the system along wif dashboard development.
• Hands on Experience wif Microsoft Word Alteryx Designer 10.1 where in this project me has worked wif 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 wif Oracle SQL Server Databases.
• Passed a set of four functions to pass R expressions to an Rserve server
• Configured Tableau Server to has its own Rserve connection.
• Writing Microstrategy Command Manager Scripts for creating security filters and applying security filters.
• Implementation of MongoDB security mechanism wif various Authentications.
• Applied patches and upgraded from 2.4 to 2.6 and 3.0. Worked wif multiple storage engines in MongoDB
• Created a signing panel for signers and notaries. It had a videoconferencing module coded in Adobe Flex; a signature pad; a jQuery Ajax interface for adding, modifying, deleting signatures, notes, seals, verifying user identities and documents, navigating between document pages.
• Involved in project planning, scheduling for database module wif project managers.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Worked wif SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.
• 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.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps
• TEMPEffectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• 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 dat allowed end users to understand the data on the fly wif the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure dat the views and dashboards were displaying the changed data accurately.
• Converted metric insight reports to tableau reports.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop.
• See a comprehensive view of you're sales pipeline and results.
• Access dashboards from any browser or tablet
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Data analysis and Adhoc workbook creation using Filtering Measures and Dimensions.
• Designed staging tables as per the requirement and used for the report creation.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created Connection Pools in Weblogic and configured as needed.

Environment: Tableau Desktop 9.2/9.3, MYSQL Server, Rscript, MS SQL Server 2008, Oracle 10g, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite, Oracle 11g, Micro Strategy 9.2.1,Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service, MongoDB, Base SAS v9.2, SAS/Macros

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 wif business team to Gather TEMPEffective Requirements for the system along wif 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.
• Tested reports wif R versions 3.1 and 3.2 and wif Rserver version 0.6-8
• Worked extensively wif SME's including heads in areas of Credit risk, Processing, Closing and expertise in understanding, extracting, refining and documenting the User and Business Requirement Specifications in the BRD and FRD.
• 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 wif 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 wif combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields wifin Tableau reports to facilitate automated data visualizations.
• Developed and reviewed custom SQL queries wif 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 wif users and super users to gather requirements for reports and worked wif 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, Rscript, Designer, BI, Dashboard/Xcelsius, Scheduler, Crystal Reports 2008/2011.

Confidential, Rockville, MD

Tableau Developer

Responsibilities:

• Created Data Connections, published on Tableau Server for usage wif 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 halp 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 their were any changes in underlying data.
• Participated in daily scrum calls, reviews, and user group discussions as well as communicating wif stakeholders and business groups.

Environment: Tableau Server, Tableau Desktop, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, Oracle 11g, Toad, 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 dat was put into SQL Server or Flat File and me was plugging dat data into Tableau from either flat file or SQL Server.
• Scope of the project was to enhance the Mobile Banking App's systematic process and developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
• 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 wif Global Drill- through Definitions to drill through from analysis studio reports to report studio reports
• Worked wif 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 wif 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 wif business and technology stakeholders on data modeling, integration, and configuration for data warehouse wif automated and manual field data collection systems
• Connected Tableau server wif share-point portal and setup auto refresh feature
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Developed ETL packages wif 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 wif DBA's, system performance wif 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 dat 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 wif 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 wif 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 (me.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 me.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 wif 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 wif 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