SUMMARY:

• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 6, 7, 8 and 9.0.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of projects.
• Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Recommend OS configuration to end-client and provided walk-through process on installing Win Server 2012 R2, Tableau Server, and SQL Server 2012 R2 during Business Intelligence road-map and proof of concept project.
• In depth knowledge of Software Development Life Cycle (SDLC).
• Ability to work independently with no/limited supervision along with working in tighter schedules and delivering result.
• Excellent communication skills in both written and oral along with ability to tell a story through data.

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau Desktop, Tableau Public, Tableau Reader, Tableau Online, Tableau Server, Cognos

Modeling Tools: MS Visio

Programming: SQL, JavaScript, HTML

Utilities: MS Office Suite, MS SharePoint, MS Project, MS FrontPage

Databases: Oracle 10g/11g, Oracle, Sybase, Teradata, MS SQL Server 2012 R2, MS Access, MS Excel

Platforms: Windows 7/8/2003/NT, Win Server 2008/2012 R2, Mac OS, DOS, UNIX, Linux, Ubuntu

EXPERIENCE:

Confidential, Ann Arbor, MI

Sr. Tableau Developer

Responsibilities:

• Scope of the project was to enhance the Mobile Banking App’s systematic processes which were associated with HSBC Personal Banking division. 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.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory

Confidential, Dearborn, MI

BI (Tableau) Developer

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• 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.
• 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, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active Directory

Confidential, Omaha, NE

BI Developer

Responsibilities:

• Interacted with different group of users for analysis of the system.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, etc.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files
• Involved to planning and designing SSAS Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Implemented logging and worked with package configuration variables
• Worked to improve the performance of SSIS packages
• Used the debugger to validate the Transformations by creating break points and analyzing the debug monitor.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Responsible to tune ETL procedures, STAR schemas optimizing, load and query performance.
• Involved in writing stored procedure and functions using PL/SQL.
• UNIX Shell scripts are used to automate the execution the workflows.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active Directory

Confidential, Baton Rouge, LA

ETL /BI Developer

Responsibilities:

• Worked with Agile Methodologies and Waterfall Methodologies for Software Development Life Cycle (SDLC).
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Created Stored Procedures, Views and User Defined Functions to facilitate the automation of data entry by a front end application.
• Worked on Spotfire to create reports, sales analysis and interactive dashboards by using various filters, parameters and calculated fields.
• Created database documentation for table and column dictionaries and other reference material.
• Implemented indexes on tables and views for optimum performing Tuning.
• Designed the ETL process using SQL server 2000 DTS packages as well as SQL server 2005 crystal packages which the data source include Flat files, MS Access and MS Excel.
• Involved in creation of scheduled jobs for Extracting, Transforming and Loading operations and database maintenance tasks like de-fragmentation, re-indexing and re-compiling.
• Created project schedules using MS Project and MS Excel in coordination with the Project Team and the Management.
• Participated in project, meetings, discussions and reviews with the Client and Vendors.

Environment: SSIS/SSRS, MS SQL Server Management Studio, MS SQL Server 2005/2008R2, MS Access and MS Office Suite.

Confidential, Grand Rapids, MI

BUSINESS/DATA ANALYST

Responsibilities:

• Evaluated annual credit reviews for a portion of CIT Bank’s portfolio and recommended analyzed data to Credit Committee for appropriate credit risk rating decisions.
• Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mock ups for reporting.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed and maintained reporting using in MS Excel queries and SQL. Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
• Created Test Cases, Activity Diagrams, and System Flow Charts.
• Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: MS Excel, Oracle SQL Server, UAT, BRD, FRD, SQL Queries, Flow Chart

Confidential

BUSINESS/DATA ANALYST

Responsibilities:

• Participated for the creation of Functional Requirement Document (FRD) and Business Process Workflow with Stakeholders.
• Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC.
• Involved throughout the business System Development Life Cycle (SDLC).
• Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Facilitated JAD sessions with model diagrams to elicit future state business requirements and to document Business Use Case To-Be artifacts.
• Created SQL scripts to validate the inputs.
• Worked with QA team to develop performance test cases based on projected user load.
• Involved in all stages of testing process - Development of Test scripts and Test cases based upon requirements for Functional Testing, Integration Testing and support for User Acceptance Testing.
• Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application.
• Worked with management to create and communicate critical information to the user community via email and discussion boards.

Environment: MS Office (Word, Excel, Power Point), RUP, Share Point, MS Visio, Microsoft Outlook