SUMMARY

• Around 8+ years of experience in Design Confidential Development Confidential Integration Confidential Implementation and Maintenance of Business Intelligence and Data Warehousing Platforms.
• In depth knowledge of SDLC phases such as Requirement analysis Confidential design Confidential development Confidential implementation Confidential deployment and maintenance with strong understanding of methodologies like Waterfall Confidential Iterative& Incremental Confidential Evolutionary prototyping and Agile.
• Extensive knowledge in dealing with Relational Database Management Systems Confidential including Normalization Confidential Stored Procedures Confidential Constraints Confidential Querying Confidential Joins Confidential Keys Confidential Indexes Confidential Data Import/Export Confidential Triggers Confidential Cursors.
• Experiences on Tableau 7.x Confidential 8.x Confidential 9.x Confidential 10.x tools include Tableau Desktop Confidential Tableau Reader Confidential Tableau Public Confidential and Tableau Server.
• Skilled Tableau front - end BI developer integrated with multiple back-end databases and other various data sources
• Proficient in design and development of various dashboards Confidential reports utilizing Tableau Visualizations such as bar graphs Confidential scatter plots Confidential pie-charts Confidential maps Confidential funnel charts Confidential lollypop charts Confidential donuts Confidential bubbles Confidential etc. making use of actions and other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects such as Dimensions Confidential Measures Confidential Hierarchies Confidential Filters Confidential Actions Confidential Calculated Fields Confidential Sets Confidential Groups Confidential Bins Confidential and Parameters etc.
• Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop Confidential Tableau Server and Tableau Reader
• Excellent understanding of Business Requirements Gathering Confidential Translating Requirements into Specifications and Application Design.
• Developed dash boards with rich Graphic visualizations Confidential Drill Down and Drop-down menu options Confidential parameterized using Tableau.
• Proficient in migrating workbooks between different environments in Tableau server using Tabcmd
• Experience in Tableau Projects (involved in the complete lifecycle from requirement gathering Confidential data modeling - scripting Confidential developing and testing dashboards using Tableau)
• Possess strong knowledge of database management in writing SQL queries using complex joins Confidential grouping Confidential aggregation Confidential nested sub queries Confidential and resolving key performance issues.
• Excellent interpersonal and customer relational skills. Proven communication Confidential presentation skills and leadership qualities.
• Ability to handle multiple tasks and work independently as well as in a team.
• Built data warehouse for Microsoft Adventure works 2012 database
• Created a Star Schema (Facts & Dimensions) using Extract Confidential Transform Confidential Load process (SSIS).
• Developed & loaded a dimensional model Data warehouse which is useful for OLAP purposes.
• Wrote complex SQL queries and generated different reports and graphs.

TECHNICAL SKILLS

Business Intelligence: Tableau 7.x Confidential 8.x Confidential 9.x Confidential 10.x Confidential Tableau Desktop Confidential Tableau Reader Confidential Tableau Server Confidential Informatica Confidential Alteryx Confidential Power BI

Languages: Python Confidential Oracle SQL Confidential R Confidential SAS Confidential Shell Scripting Confidential SQL-queries

Other ETL/Reporting Tools: SSIS Confidential DTS Confidential Asset Control BI Confidential Informatica Power Center Confidential R Studio Confidential Microsoft Azure ML Confidential JMP Confidential Minitab Confidential SQL Server Reporting Services (SSRS), Crystal Reports

Databases: Oracle 8i/9i/10g/11g Confidential SQL Server 2000/2005/2008 , DB2 Confidential MySQL

Operating Systems: Windows 98/XP/7 Confidential Windows NT/2000 Confidential Server 2003 Confidential Vista,7 Confidential Unix Confidential Linux

Tools: Toad Confidential SQL Plus Confidential SQL Developer Confidential SQL Server Management Studio Confidential SQL Workbench Confidential SAS/ES Confidential Anaconda Confidential Oracle Confidential SQL Server

FTP Tools: FileZilla Confidential CuteFTP Confidential Putty Confidential FTP Commander

Applications: Advanced MS Excel Confidential MS Visio Confidential MS Access Confidential Adobe Dreamweaver Confidential Apache Cordova Confidential Spyder 3

PROFESSIONAL EXPERIENCE

Confidential - Chicago-IL

Tableau Developer and Administrator

Responsibilities:

• Implement several projects in different capacities (BO report developer Confidential administrator and universe architect)
• Contribute in all aspects of software development lifecycle (SDLC) including architecture Confidential development Confidential migrations Confidential upgrades Confidential troubleshooting and maintenance of the Tableau platform.
• Work with enterprise wide business and IT senior management to understand reporting and data analysis needs.
• Optimize the performance of Tableau applications
• Conduct Business Objects tool Trainings to Business Users.
• Extensive experience in working within a Business Intelligence environment and knowledge of data warehouse dimension database design.
• Work as developer with in Business Intelligence team performing tasks like report development Confidential Model development of the Tableau Platform.
• User Management such as creation of new users and deletion of users and Modification of user roles as per requirement.
• Converted existing Excel Reports intoTableauDashboards.
• Worked on gathering and converting data over toTableauusing SQL/SAS/Excel data over totableau reports and Dashboards.
• Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.
• As a Tableau Analyst Confidential used Tableau for Data Analysis Confidential Digging the data for source Confidential systems analysis and deeply diving the data for Predictive findings and for various data Analysis. Also Confidential to slice and dice the data Confidential for analyzing the data of patterns Confidential trends and fashions of various KPIs Confidential Measures using various graphs Confidential charts Confidential indicators Confidential and gauges.
• Acted as Tableau Developer (for designing and developing Confidential proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts Confidential refreshing extracts Confidential Tableau Layout designing Confidential Tableau Work Sheet Actions Confidential Tableau Functions Confidential Tableau Connectors (Live and Extract), Dashboard color coding Confidential formatting and report operations (sorting Confidential filtering (Quick Filters Confidential Cascading filters Confidential context Filters), ranking Confidential Top-N Analysis Confidential hierarchies)
• Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
• Primary work involves migrating and administration of Tableau environments. Focus on administration Confidential architecture Confidential design of several Tableau projects.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Customizing Tableau reports using Java Script and HTML 5

Environment: Tableau Server Confidential Tableau 9.x Confidential Tableau 10.4 Confidential ETL Confidential SQL Server Confidential Oracle 10 Confidential Microsoft Office Suite (Word Confidential Excel Confidential Power Point)

Confidential Chicago Confidential IL

Tableau Developer

Responsibilities:

• Website Design/Development using WordPress
• Worked on a Project using Microsoft Access to create a Customer Tracking System to track customers Confidential their status and information.
• Requirements Gathering and Analysis for the Customer Tracking System.
• Gathered requirements from users and created requirement documents.
• Involved in the administration tasks of Tableau server like installations Confidential upgrades Confidential user Confidential user groups creation and setting up security features.
• Extensively gathered information by conducting walkthrough Confidential workshop Confidential brainstorming sessions and surveys. Identified the business requirements Confidential analyzed and prioritized these requirements that should be included in advantage.
• Worked with database connections Confidential joins Confidential cardinalities Confidential loops Confidential aliases Confidential views Confidential aggregate conditions Confidential parsing of objects and hierarchies.
• Extensively used various techniques like Multiple Breaks Confidential Sorting Confidential Ranking Confidential Report Filtering Confidential Query Filtering Confidential Alters and sections Confidential if conditions while developing and creating the report’s.
• Prepared technical documentation for the reports in the process of migrating from development to production Environment.
• Also worked on querying /pulling data extracts (using SQL Server / MS Access) during the Data Cleansing / Migration phase of the project.
• Developed advanced queries using SQL to deliver or improve; process automation Confidential data integrity Confidential and adherence to business rule requirements.
• Managed & worked on secured Access databases. Creation of Access Forms (using VBA code) to update Oracle database & to pull reports as per requirements.
• Creation of customized Excel reports using VBA code with Access & Oracle databases as the Data source

Environment: MS Access Confidential Tableau Confidential SQL Confidential Oracle Confidential WordPress Confidential MS Excel Confidential Tableau Desktop 10 Confidential Microsoft Office (Word Confidential Excel Confidential Power Point)

Business Intelligence Developer/Tableau Developer

Responsibilities:

• Interacting with business stakeholders to understand their decision-making parameters Confidential analyzing the available data to build Tableau Dashboards and managing the delivery
• Using Tableau Confidential created multiple rich dashboards visually telling stories of the business status Confidential strength & weakness Confidential potentials etc., also interact with data as necessary
• Provided BSC to the management analyzing KPI from Financial Confidential Customer Confidential Internal process.
• Embedded live Tableau dashboards on PowerPoint presentations Confidential keeping the slides always updated
• Delivered dashboards tracking viewership Confidential HUT and Advertising sales for a Media channel.
• Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily
• Participated in discussions for Tableau Server architecture design on Cloud Confidential enhancing performance Confidential scalability and high availability
• Participated in regular Technical Reviews Confidential Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Developed Stored Procedures Confidential Functions Confidential Packages and SQL Scripts using MS SQL.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created SSIS Packages/projects to move data from source to destination by using Visual Studio 2012
• Developed and reviewed custom SQL queries with use of joins clauses (inner Confidential left Confidential right Confidential full) in Tableau desktop to validate and reconcile data.
• Created various complex SQL Queries Confidential Stored Procedures Confidential CLR Procedures Confidential Views Confidential Cursors and User Defined Functions to implement the business logic.

Environment: Tableau 9.x Confidential Tableau Desktop Confidential Tableau Server Confidential Oracle DB Confidential MySQL Server Confidential Microsoft Office

Confidential

Business Intelligence (BI) Developer

Responsibilities:

• Worked with business analysis and product teams to create data mappings and rules
• Responsible for understanding requirements and designing/architecting data migration srategy/process
• Designed and developed multiple SSIS packages for migrating data from mainframe(VSAM) files Confidential DB2 tables to an Oracle database handling numerous business rules and transformations
• Assisted in creation of Business Requirements and Technical Design documents
• Created numerous tables Confidential views Confidential stored procedures Confidential functions in SQL Server and Oracle as needed based on design and drive re-usability
• Responsible for identifying and handling data anomalies prior to the migration of the data
• Fine-tuned queries and stored procedures as and when needed for faster data retrieval and data loading as needed achieving better performance
• Extensively used variables Confidential configurations Confidential conversions Confidential Conditional Split Confidential Lookup Confidential Aggregator Confidential Multicast Confidential Derived Column and script components across SSIS packages
• Created unit test cases Confidential validation scripts and involved in code reviews
• Created balancing reports using SSRS to support and validation of data migration process
• Worked through the project with multiple teams that include business Confidential product Confidential development Confidential quality and implementation with a headcount of 60

Environment: Business Intelligence (BI), Tableau Confidential Microsoft Office

Confidential

Software Developer/Analyst

Responsibilities:

• Worked on multiple Mobile applications Confidential games and simulations.
• Built Confidential Tested and Deployed high level client projects.
• Worked as part of the team for gathering and analyzing the requirements.
• Handled projects individually and independently.
• Involved in the complete lifecycle of projects from requirement gathering Confidential designing Confidential developing and testing the application.
• Experience adding various plugins Confidential ads etc., for the application.
• Performed optimization to improve speed Confidential size and efficiency of the application.
• Hands on knowledge in porting mobile application to different platforms (using Unity).
• Used C# and JavaScript within Unity to develop the application.
• Performed debugging and testing on several projects to meet the deadline and align with the firm’s need.
• Handled Game Play Programming to improve the design and game play of the application.
• Worked on multiple projects at the same time within the team and handled multiple tasks.
• Involved in the development of custom stored procedures Confidential functions.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Developed SSIS Packages for migrating data from different Staging Area.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Installed and administered Microsoft SQL Server Confidential SQL Server Integration Services Confidential SQL Server Reporting Services Confidential and Team Foundation Server.

Environment: Unity3D Confidential C#, JavaScript Confidential C++, Microsoft Visual Studio Confidential Notepad++, UDK Confidential Asset Control DW Solution Confidential Oracle DB Confidential MySQL DB Confidential Unix Confidential MS Excel Confidential Tableau