SUMMARY:

• Around 8years’ experience working in IT Industry with SQL/ETL developer and Tableau report services document delivery.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go - live and Reconciliation.
• Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Implemented and designed dashboards using Qlikview, Qliksense.
• Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Using Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, Pmon/View Point, Data mover)
• Extensive experience as MicroStrategy Developer, Architect & Administrator building projects and creating reports and Dashboards using MicroStrategy 7.5/8.0, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server.
• Expertise in Desktop creating and integrating MicroStrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Created Tableau Scorecards, Dashboards, Heat maps using show me functionality.
• Proficient in design and development of various Dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and Global filters per the end user requirement.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience with MPP and columnar database like AWS Redshift.
• Experience with Big Data methods, topologies and tools, such as Map/Reduce (e.g. AWS EMR), Apache Spark, etc., preferred
• Extensive knowledge in Dimensional Data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 7.x, 8.x,9.x.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.
• Expertise in technologies like Data Warehouse (DWH), Data Visualization and Business Intelligence Concepts and BI Tools.
• Worked on Informatics tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager OBIEE,and Repository Manager.
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experienced in all aspects of Software Development Life-Cycle (SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.
• Expertise in Business Intelligence (BI)/ data warehouse (DWH) concepts, designs, SSRS/SSAS, and project implementations.
• Good knowledge of data warehouse (DWH) Models, RDBMS concepts, SQL, PL/SQL, Oracle and SQL Server.
• Hands on experience in developing reports and visualization against SAP HANA.
• Hands on installing, using and troubleshooting various software applications.
• Good knowledge on C, C++ programming language, DBMS, RDBMS and Visual basic concepts.
• Worked with Different Databases like DB2, Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spreadsheet etc.
• Hands on experience on Tableau Server administration including cloud based services.
• Able to work independently has a good interaction with team members.
• Good at understanding the client requirements and giving best solutions.

TECHNICAL SKILLS:

Tools: Tableau Desktop, Tableau Server, Tableau reader, Qlikview, Qliksense

ETL Tools: Alteryx, Informatica.

Web technologies: HTML, CSS, XML, Java Script/Jquery

Languages: Java, C, C++, TSQL, PL SQL, SQL, VB-Script

Operating System: Windows 2008, windows 2003, XP.

Database: Oracle 9i/11g, SQL Server 2008/2010, MS Access 2000, Teradata, Sybase, DB2.

Others: SQL management studio, Visual studio, SAP, BIDS, Microsoft Products MS Word, MS Excel, MS Access, MS Power Point, Apache Tomcat 5.0, Visual Basic 6.0,Jmeter, SSIS, SSRS,Cognos, Visio, SQL Developer, SQL Tools, Automate MS Office.

BI Tools: Business Objects 4.1, WebI, Crystal Reports XI/ 2008, Xcelsius, Toad 9.0, Tableau 9.0/8.x

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. Tableau Developer

Responsibilities:

• Developed effective dashboards according to the requirements of the clients by using Tableau Desktop.
• Experience on testing the dev and QA servers and used scrum methodologies in software development lifecycle.
• Understand the requirements to plan, define and clarify dashboard goals, objectives.
• Worked with cross functional team and business user to develop Business requirement document (BRD), define key performance indicators (KPIs) and identify data sources.
• Hands-on experience in setting up new task and troubleshooting existing task setup and other issues.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Ad-hoc ETL, Reports requirement runs.
• Required activities included planning, design and installation of RDBMS systems both locally and on the AWS cloud for both the application and the reporting project
• Involved in creating dashboards and reports to testing in Tableau and Maintainingserver activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards topresent to Senior Level.
• Working with various Teradata tools and utilities like Teradata Viewpoint, MultiLoad, ARC, Teradata Administrator, BTEQ and other Teradata Utilities.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Data mart for the Initial load and Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Prepared complex SQL/R scripts for ODBC and Teradata servers for analysis and modeling.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Used Python to place data into JSON files for testing Django Websites.
• Used Python scripts to update content in the database and manipulate files.
• Used the Django Framework to develop the application.
• Generated Python Django Forms to record data of online users.
• Used Django APIs for database access.
• Worked with Python OO Design code for manufacturing quality, monitoring, logging, and debugging code optimization.
• Wrote a Python module to connect and view the status of an Apache Cassandra instance.
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Used Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies.
• Used PROC compare to compare the data before and after editing
• Developed various SAS reports for Survey project and involved in code reviews for all the developed report
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created custom reports for our inventory tracking system using SAP Crystal Reports.
• Design, and develop SSIS packages, Tables, Stored Procedures, Triggers, and Indexes using Microsoft SQL Server. Design dimensional model for SSAS to de-normalize the OLTP database.
• Designed and developed BI Reporting solution enabling users to effectively utilize the tools to create Analytical Reports, Dashboards, and Scorecards, helping clients align KPIs performance metrics to strategic drivers and priorities.
• Created automatic schedulers to reload the data as per requirements.
• Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.
• Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.

Environment: Tableau Desktop 10.x/9.x, Tableau server/Administrator, OLAP, SSIS,SSRS, Oracle 10g, DB2, Informatica,Python, Teradata, AgileSQL Assistant, AWS BTEQ, AWS Redshift, SAS desktop, PLSQL Programming, Hadoop, Hive, PIG.Real-Time BI AnalysisAP Business Objects, Crystal Reports, Qliksense.

Confidential, San Francisco, CA

Tableau Developer/BI Developer

Responsibilities:

• Work with end users to gather requirements, overlaying an analytics perspective
• Create sustainable and efficient visualizations, emphasizing usability and good design practices
• Test and monitor the underlying data, assuring quality and optimizing the data view that dashboards use
• Understand the techniques used in visual reporting
• Assist management in incorporating Tableau into broad business intelligence and reporting strategies
• Oversee Tableau projects, including writing and managing task orders for external contracts
• Extracting the data from Hadoop and developed reports and dashboards.
• Promote the use and capacity of Tableau across program areas and within the organization, including holding educational sessions, trainings and fielding questions
• Train new users of Tableau and improve the skill of current Tableau users, including both content creators and report consumers
• Help analysts troubleshoot Tableau issues, working with Tableau tech support when needed
• Lead advanced utilization of Tableau server capabilities including public dashboard publishing, security, etc
• Liaise with the internal (IT) and external (sales rep, other county users) Tableau community
• Troubleshoot server technical issues as they arise
• Work with IT and database teams to ensure security
• Oversee the quality assurance process, and ensure some standardization/uniformity around all published dashboards
• Manage Desktop licenses and user access to the server
• Develops understanding of the organizations services and systems in order to facilitate internal data practices and promote the effective use of data for decision-making
• Provide guidance on the optimal data structure and system requirements to ensure that the data stored and retrieved from the system meet the research and operational needs of the organization
• Worked with team of developers on Python applications for RISK management.
• Developed Python/Django application for Google Analytics aggregation and reporting.
• Used Django configuration to manage URLs and application parameters.
• Generated Python Django Forms to record data of online users.
• Used Python and Django creating graphics, XML processing, data exchange and business logic implementation

Environment: Tableau(Desktop, Server), Oracle, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal,AWS,NoSQL, PowerBI, Python,Cognos, Informatica, QlikView.

Confidential, Chevy Chase, MD

BI Developer

Responsibilities:

• Designed the Conceptual and Physical Data Models, as well as the major components of the user.
• Installation and management of a standardized analysis, reporting and dashboard solution provided by "TIBCO' and BIG DATA from Hortonworks/AWS.
• Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Used SAS ODS to format reports.
• Optimized SAS code to reduce run time and make the process more efficient.
• Developed SAS code using Macros to run recurring jobs and optimized code.
• Creating SAS datasets by sub setting the production datasets according to the requirement from the business team.
• Extensively used Informats, formats and Indexes in creating the snapshot datasets.
• Developing SAS VA reports using VA data builder, VA Explorer, VA Designer, VA Viewer and creating custom reports in SAS VA.
• Created schema objects like tables, views, indexes. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Connected to Oracle using OLEDB and ODBC data sources connector and tables of SD, inventory, etc. to create and schedule reports by leveraging the basic components of Tableau.
• Used Teradata to handle the huge amount of data.
• Created Complex Reports using Cognos BI Report Studio and Ad-hoc web based reports usingCognos, BI Query Studio.
• Used CognosBI Framework Manager in building the Models and packages and published into Cognos connection Portal and implemented securities for the packages.
• D eveloped reports using MDX scripting, SQL and SQL Server Reporting Services (SSRS).
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler.
• Designed and developed scripts to support UI visualization, ETL processes, automation, and workflow and dashboard presentation framework.
• Performed Admin tasks such as monitoring DB services, BO Server running with optimal performance, monitoring licenses, monitoring user activity/sessions, consulting SAP to define bugs in patches etc.
• Migrated reports/universes from Dev to QA to Prod.
• Created Dashboards and visualizations using Tableau for several teams and delivered demo sessions to expand the tools reach in the IT environment.
• Developed engineering prototype and using POC to facilitate KPI Metrics dashboard design across different regions and business units according to business equipment’s.

Environment: Tableau Desktop\Server,SAS,Oracle, SQL Server, AWS,Teradata, SAP, Excel, CSV files, Enterprise Management Reporting Portal, NoSQL, DB2, Cognos, Informatica,Hyperion,QlikSense,Oracle 10g, Access, PowerBI, Sun one LDAP, Nprinting, SAP HRMS.

Confidential, Mt Laurel, NJ

SQL Developer/ETL developer

Responsibilities:

• Involved in Creation of Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Supported Tableau Dashboards whereas source is from different Data Sources like RDBMS/Hadoop.
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Used MySQL to handle the data, for the implemented OLTP operations.
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Developed data base tables and created SSIS packages.
• Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.
• Designed and development Data modeling, database design, and ETL in an Agile development environment.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Involved in designing, developing and deploying reports in Microsoft SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Resolved various performance issues by running DBCC command.
• Designed ETL processes to transform information from multiple sources
• Troubleshooting, monitoring and coordinating defect resolution related to ETL processing.
• Developed data warehouse models and prepared reports for all meta data integration into systems and draft ETL scripts and prepared required reports for all end users.
• Understand the specifications and build the ETL applications like Mappings on daily basis.

Environment: HTML, CSS, Jquery, SQL Server 2005/2008 Enterprise Edition,SSIS, SSRS, MS SQL Server management Studio, Erwin Data Modeler, NoSQL,PostgreSQL, Spotfire, MS PowerPoint, MS Excel, Tera data

Confidential

SQL Developer

Responsibilities:

• Worked with multiple platforms, architectures, and diverse technologies gathering requirements.
• Designed and maintained data integration and EDI applications using a SQL, data mapping tools, and web services in various formats and custom file layouts
• Create interfaces between application systems and various organizations.
• Developed web pages by using HTML, XML, JavaScript.
• Dashboards are created depending on the Business Intelligence based on the SRS reports.
• Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.
• Designed and deployed SSIS packages.
• Understanding ETL products, services, protocols, and standards in support of procurement and development efforts.
• Application is connected to database using JDBC.
• User executions permissions are provided using SQL.
• Created Entity Relationship (ER) Diagrams to the proposed database
• Created database objects such as tables, views, stored procedures, Triggers etc.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Developed PL\SQL queries to manipulate the data and structure of a database.
• Installed and configured a security and troubleshooting issues related to database.
• Experience on procedures, Packages and triggers in SQL.
• Implemented and developed ETL process using ORACLE functions.
• Created cubes in SQL Server Analysis Services (SSAS).
• Developed reports in SQL Server Reporting Services (SSRS).
• Designed, Developed and Deployed SSIS Packages.
• Understand the requirements and provide the back-end functionality for the applications.
• Participated in development and creation of Data warehouses.

Environment: Linux, Windows, Ajax, Java, JavaScript, oracle, JDBC, SAS,SSRS, SSIS, HTML, CSS, JQuery, XML, JBOSS.