SUMMARY:

• Over 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 4 years of extensive Tableau Experience in Tableau v6.x/7.x/8.x/9.x/10.x (Desktop, Server, Reader, Mobile, Online, public) as a Developer and Analyst
• Competent in Software Development Life Cycle methodology (SDLC) and Software Testing Life Cycle (STLC), which includes RUP, Agile, and Waterfall Methodology.
• Extensive experience in various DB/DW/BI technologies including Tableau, OBIEE, MicroStrategy, SSRS, Unica, Google Analytics, Alteryx, Informatica, SSIS, Teradata.
• Strong knowledge of Business/Process Data flow in organizations and experienced in data modeling concepts.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Prepared Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies,
• Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), SQL Server MS Access and client/server applications.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, MicroStrategy, SSRS, Informatica and Alteryx.
• Experience in using SAS for data entry, retrieval and management thereby performing statistical and mathematical analysis.
• Experience with SAS BASE, SAS MACRO, SAS ETL, SAS OLAP, SAS EG.
• Proficiency on various SAS procedures like Proc PRINT, Proc REPORT, Proc SQL, Proc Sort, Proc Means, Proc Univariate, Proc Freq and Proc Summary, Proc TABULATE, Proc COMPARE.
• Extensive experience with SAP BW such as Info cubes, BEx Query designer, BEx Analyzer, Data Modeling.
• Experience in SAP BW connectivity with Universe Designer and Business Objects Info view.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations. (Automate the SSIS Packages and Import, Export).
• Exposure to Big Data Hadoop environment and its components HDFS, Apache, Pig, Hive, Sqoop, MapReduce, HBase, Zookeeper, Flume.
• Good understanding in AWS solutions like EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups and Big Data architecture like Hadoop (Azure, Hortonworks, Cloudera) distributed system, MongoDB, NoSQL.
• Experience in Business Intelligence solutions using SAP Business Objects XI R2/R3 and SAP Business Objects 4.1.
• Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Extensively used Crystal Reports, Business Objects, SSRS, Informatica Power Center, SSIS, SQL Server, Oracle, Teradata and Hadoop Hive.
• Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
• Experience with Alteryx to collect the required data from large complex databases.
• Experienced in tuning long running SQL queries for better performance.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

BI / Reporting Tools: Tableau Desktop v10.x/9.x/8.x/7.x/6.x, Tableau Server v10.x/9.x/8.x/7.x/6.x, Tableau Online, Tableau Reader, Tableau Mobile, Tableau Public, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence, SAP BO, MicroStrategy, SSRS, Unica, Google Analytics (Adobe Site Catalyst).

Databases: Teradata, MySQL, MS SQL Server, Hive, ORACLE, IBM DB2, MS Access, Amazon Redshift, SAP BW, SAP BO

Big Data: Hadoop, Spark, Hive, Impala

ETL Tools: Informatica, SSIS, DataStage, Alteryx

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, OpenProj, JIRA

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, SAS, ASP.net, JavaScript, CSS, XML.

Document Management: Documentum, SharePoint, Ultra Edit

Versioning Tools: CVS, Tortoise SVN, GIT

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Data Modeling: Power Designer, MS Visio, Erwin, ER Studio

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Sr. Tableau Developer / Data Analyst

• Gather and analyze the business requirements and then translate them to technical specifications.
• Perform Tableau Server admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Gathered SSRS reports requirements and created in Tableau.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in Tableau.
• Prepared and published customized reports/dashboards.
• Converted SSRS and MicroStrategy reports into Tableau.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy Desktop.
• Created different Action filters, Parameters and calculated fields to create most complicated Dashboards.
• Worked with Tableau administrator in managing Production, Test and Development Environments.
• Used data blending feature in tableau and defined best practices for Tableau report development.
• Analyzed business requirements, translated it into SAS and SQL. Coded and tested complex SAS reports.
• Created and manipulating large datasets using SAS and have worked on business forecasting and decision support.
• Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Created report on Cloud based environment using Amazon Redshift and published on Tableau Online.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau
• Worked with Master Data Management architects to develop data models.
• Desktop to validate static and dynamic data for data validation.
• Provided technical assistance in laying out Tableau Data extracts for transaction data residing on SAP BW.
• Resolved issues with Tableau workbooks connecting to SAP BW and Sharing/ Publishing BW source based workbooks.
• Embedded tableau views in to SharePoint and handled tableau admin activities granting access and hanging extracts and installations.
• Created SharePoint site to store all tableau workbooks and data source.
• Published Packaged workbooks.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked on evaluation and analysis of Hadoop cluster and different big data analytic tools including Hive, HBase database and Sqoop.
• Improved the Performance of data extracts created from Hadoop using contexts and Action filters instead of quick filters.
• Created ad-hoc reports to users in Tableau by connecting various data sources like Oracle, T-SQL, Hadoop and Teradata.
• Involved in the development of the Hive/Impala scripts for extraction, transformation and loading of data into other data warehouses.
• Converted Pearl Script Query in to SQL Query for ETL.
• Created reports in Tableau using SSRS SQL Queries and Stored procedures.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Writing complex queries using Teradata SQL.
• Used Erwin for relational database and dimensional data warehouse designs.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL mappings in Informatica.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with Stakeholders and business groups.

Environment:: Tableau 9.x/10.x, Tableau Server 9.x/10.x, Amazon Redshift, Microsoft SQL Server 2013, Hadoop, Alteryx, Teradata, SAS, SQL, ERWIN r8, MDM, Toad, SSRS 2013, SAP BW, Informatica, Oracle, Salesforce, SharePoint.

Confidential, Houston,TX

Sr. Tableau Developer/ Data Analyst

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Utilize Big Data and Hadoop File System (HDFS); create Hive tables; load and analyze data using impala queries.
• Worked on designing and implementing complete end-to-end Hadoop Cycle integrating to tableau and writing complex calculations.
• Developed dashboard using Cognos Analytics and Tableau to the Hadoop Hive environment.
• Worked on creating Map Reduce scripts for processing the data.
• Identified data modeling issues with BW content and assisted in correcting the same on BW front.
• Helped customer in understanding BW extract limitations and finding a work-around for achieving desired solution.
• Converted Legacy SAP BO Reports to Tableau dashboards connecting to SQL server.
• Identified all Sales metrics reports/Dashboards on SAP BO and recreated the measures on Tableau 9.x.
• Created reports using BO Functionalities like Section, Alerters, fold and unfold, and query level filters.
• Created the SAS Datasets from raw data using PL/SQL and joins. Deployed the same to production.
• Created SAS datasets by sub-setting production datasets according to the requirement from the modeling team.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• 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.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Created SharePoint site to share project related documents.

Environment:: Tableau 9.x, Teradata, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW Query Designer, Hadoop, Analyzer, SAP BW, SAP BO, Teradata SQL Assistant, Teradata Administrator, SAS, SQL BI Suite (SSRS / SSAS) 2012, SharePoint

Confidential, Rochester, MN

Sr. Tableau Developer / Sr. Data Analyst

• Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop those were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive, parameterized dashboards by extracting data from various sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics.
• Developed different reports and dashboards using SAS Enterprise Guide.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time.
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Validated the reports before publishing reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment:: Tableau (Desktop /Server), Oracle, SAS, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, North Brook, IL

Sr. Data Analyst / Data Modeler

• Conducted one-on-one sessions with business users to Gather Data Warehouse Requirements.
• Updated existing models to integrate new functionality into an existing application.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system.
• Created Dimensional Model for the reporting system by identifying required dimensions and facts using Erwin.
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement.
• Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN.
• Created and maintained Metadata, including table, column definitions.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Responsible for Defining the Naming Standards for data warehouse.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Eliminated errors in Erwin models through the implementation of Model Mart (a companion tool to Erwin that controls the versioning of models).
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.

Environment: Windows XP/NT/2000, SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE.

Confidential, Palm Beach, FL

Data Analyst / Business Systems Analyst

• Analysed the business requirements of the project by studying the Business Requirement Specification document.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
• Created a logical design and physical design in Erwin.
• Maintained security and data integrity of the database
• Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Entity relationship diagrams (ERD), Function relationship diagrams (FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the New programs.
• Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations

Environment:: Oracle 8i, SQL, PL/SQL, Erwin, SQL*Loader, Perl, TOAD and UNIX

Confidential

MS SQL Server Developer/BI Developer

• Extracted and reviewed data from heterogeneous sources like ( Excel, CSV, Oracle, flat file, Text Format Data ) using SQL Server Integration Services (SSIS) from OLTP to OLAP .
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
• Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS

Environment:: MS SQL Server 2005, MS Visual Studio 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.