PROFESSIONAL SUMMARY:

• Around 8years’ experience working in IT Industry with 4years’ experience as SQL/ETL developer 4+ years of experience in Tableau report services document delivery.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensive experience of 4+ years in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x,8.x,7.x.
• 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 a plus
• 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.
• Expertise in extraction data and creating reports for data from various Data Sources like Excel Files (.xls), CSV Files(.csv), XML Files(.xml), MDB Files(.mdb, .accdb), Oracle 11g, SQL Server 2005/2008, DB2 9.7 Database and other Databases.
• Developed business intelligence solution using dashboards, alerts, queries and reports.
• Proficient in Software Development Lifecycle (SDLC).
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Expertise in creating reports in tableau.
• 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.
• Application is connected to database using JDBC.
• Experience in data visualization in Tableau and Qliksense.
• Developed a security code by using SMTP protocol and servlets.
• 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.
• Experience in using all Microsoft Office Tools like MS Excel, MS Word, and MS PowerPoint.
• 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. BI 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.
• Data visualization is performed by using Qliksense.
• 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.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server with high volume data
• 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.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, IPhone, and other smart mobile phones.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps per deliverable specifications.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Developed dashboards by extracting data from Hadoop.
• Generate statistical reports for consistency, data quality and data integrity
• 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.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• 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.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Good knowledge on JavaScript API and integration of Tableau with web applications
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Handled the team and managed the work as per the business requirements.
• Designed and developed dashboards in Qliksense
• SAP business objects are used to develop the crystal reports.
• 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.
• To handle the large amount of data we use Tera data.
• 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, SAS,SQL developer, SSIS,SSRS, Oracle 10g, DB2, MS Office, Terradata.OBIEE, Informatica,Python,Teradata,AgileSQL Assistant, AWS BTEQ, AWS Redshift, SAS desktop, SAS EG and Putty, Erwin r9.6, Informatica Power Center, Teradata, Oracle 12c, PowerBI, SVN tool, R, BTEQs, Mload, Fast Load, UNIX scripting, PLSQL Programming, Hadoop, Hive, PIG.Real-Time BI Analysis, Microsoft SQL Server, SSIS, SSRS, Oracle Database, SAP 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:

• Evaluated functional requirements and map the documents.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Interacted professionally with a diverse group including executives, managers.
• 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.
• Developed ETL from relational sources to SAS LASR server.
• Design LASR reporting base tables and develop insightful visualizations using SAS VA
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Created dashboard using Qlikview and Qliksense depending on business requirements.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Data visualization and created stories by using Qliksense and Tableau Desktop.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Built complex formulas in Tableau for various business calculations.
• Identify new metrics and enhance the existing KPI's.
• Created and assisted users in Tableau dashboard development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Designed dashboards in tableau by importing the data from the different types of data sources.
• Understand the business requirements and developed the business requirement documentation.
• Generate the dashboards according to the business requirement documentation.
• Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting (includingthe bursting of reports globally) using Cognos.
• Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio.
• 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 using Cognos, 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.
• Created score cards with advanced set of dashboards using MS Office Performance Point Server Dashboard Designer that feature executive summary measures.
• Created the mappings, sessions and Workflows as per requirement of business logic.
• Created a mapping document based on High level design document
• Designed and developed scripts to support UI visualization, ETL processes, automation, and workflow and dashboard presentation framework.
• Created complex Webi reports with multiple queries, custom sql, complex functions, merge dimensions, drill down/up/across/through, complex filters etc.
• 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.
• Integrate Microsoft SharePoint Web Parts with Business Objects to display dashboards on SharePoint.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Extracted the data from various sources like relational and flat file sources of OLTP systems.

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.
• Back end Oracle data base is used to store data, each output from the lab is stored and then integrated to the java program to retrieve the data from the database and connect to the doctor system.
• 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.