SUMMARY

• Around 7 years of diversified IT experience in analysis, design, development, testing, implementation and supporting of projects in the fields of Databases, Business Intelligence/Data Warehousing concepts.
• Proficient in Tableau 10.x/9.x/8.x/7.x (Desktop, Server, Public, Mobile).
• Experience in Oracle, SQL Server, Teradata with good programming knowledge in SQL, PL/SQL, and T - SQL.
• Proficient in design and development of 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.
• Experience in Developing Performance Dashboards, Score cards, Metrics, analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards in Tableau.
• Extensively used PL/SQL Packages, Stored Procedures, Functions and Triggers for data transformation and used System Calendar, Inner Joins, and Outer Joins to join multiple tables to retrieve requested data.
• Strong knowledge in Data Conversions, Extraction, Transformation and Loading (ETL) of data from multiple sources in Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Extensive Experience in designing Architecture documents for Production, Pre-production, Development, Testing, Break Fix and Training environments.
• Designed a Java application to synch data between tables in various databases at single click.
• Developing, Administration and Support for Ontrack (NICE Performance Management Tool).
• Good data analytics and problem-solving skills in business analysis.
• Expeditious at learning new concepts and work well under pressure.
• Worked as Lead in some projects.

TECHNICAL SKILLS:

TOOLS: Tableau, SOAP UI, JDeveloper, Toad, SQL*Loader, Visio, Enterprise data Architecture, Autosys 4.0, SQL Loader, Forms 6.0, Report 6.0, Crystal Reports, XML Spy, Groovy, Visual Studio.

DATABASES: Oracle 12c/ 11g/ 10g/9i/8i/7.x, MySQL, MS SQL Server 6.x/ 7.0/ 2000/2008, DB2, MS Access 97/ 2000.

OPERATING SYSTEMS: UNIX, HP-UX, Linux, OEL, Sun Solaris 2.x, Windows Server, Windows 7/XP

LANG/ TECH: SQL, PL/SQL, SQL*Plus, Unix Shell Scripts (Korn), Java, Visual Basic 5.0/ 6.0, HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Business Intelligence Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed Tableau dashboards based on the requirements.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Built complex calculations using advance functions such as ATTR, DATEDIFF, STR, Ifs, Nested Ifs, SUMIF, COUNTIF, LOOKUPs and Quick Table calculations in Tableau.
• Created Actions in Tableau Dashboards for interactivity, to compare & analyze data in different perspectives and to easily navigate through different dashboards enabling users to drill down to more detail data.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Worked in user management, group management and permission management for accessing Tableau dashboards based on security requirement.
• Extensively used PL/SQL Packages, Stored Procedures, Functions and Triggers for Data transformation and used System Calendar, Inner Joins, and Outer Joins to join multiple tables to retrieve requested data, create tables.
• Developed, modified, and executed SQL scripts to retrieve data from various databases on daily basis.
• Involved in optimization of SQL queries using Indexing, explain plan, Optimizer mode, PL/SQL Table, Dynamic Cursor etc.
• Involved in modifying the existing Cognos Reports based upon the change requested by the user.
• Developed List Reports, Cross Tab Reports, Charts, Drill-through Reports, Master Detail Conditional Formatting, Page-layout, Sections, Page Breaks, Drill-Down and Drill-Up Reports using Report Studio in Cognos.
• Analyze, troubleshoot and optimize tableau dashboard performance.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating New Schedule's and checking the task's daily on the Tableau server.
• Design and optimize data connections, data extracts, schedules for background tasks and incremental refresh for the weekly and monthly dashboard reports on Tableau Server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, line graphs, Gantt charts using show me functionality.
• Used Confidential / NICE ticketing system to resolve Ontrack issues for advisors.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Ensuring correct application of the business rules through data query after the data is loaded into the Database.

Environment: Tableau 10.1/9.x, Cognos 10.2.1, Ontrack, Oracle, PL/SQL, SQL* Loader, Autosys, UNIX, MS VISIO, TOAD, IEX, NICE Performance Management, XML, HTML.

Confidential, Detroit, MI

Tableau Developer/ Data Analyst

Responsibilities:

• Developed Tableau workbooks to perform YTD, QTD and MTD type of analysis and performed extensive GAP analysis in the project.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed visualizations using Sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Analyze, troubleshoot and optimize tableau dashboard performance.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Design and optimize data connections, data extracts, schedules for background tasks and incremental refresh for the weekly and monthly dashboard reports on Tableau Server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, line graphs, Gantt charts using show me functionality.
• Develop complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards and to provide drill down features for the detailed reports.
• Restricted data for particular users using Row level security and User filters.
• Worked on building queries to retrieve data into Tableau from SQL Server, Oracle and develop T-SQL statements for loading data into target database.
• Determined best practices for Tableau implementation using Tableau Desktop, Tableau Server and effectively used data blending feature in tableau.
• Worked with Business Analysts, Project Managers and subject matter experts to analyze and finalize the business requirements and technical details to create Architecture documentation for Data Center Transformation (DCT) initiative.
• Architecture documents include Storage surveys, Deployment strategy which are used by EMC architects to procure hardware/ software and Work Orders used by DBAs to build databases.
• Gathered requirements, planned and designed a software application using Java to synch data between various databases of VCS application.
• Performed research and analysis to create a POC (Proof of Concept) for Oracle Goldengate Veridata to perform data comparisons on heterogeneous databases.
• Created data for testing purposes, performed data loads; initiated data extracts; and clean up data by removing duplicates in various scenarios.
• Involved in optimization of SQL queries using Indexing, explain plan, Optimizer mode, PL/SQL Table, Dynamic Cursor etc.
• Created, modified and redesigned SOAP UI packages and jobs to load huge amounts of data to BRM.

Environment: Oracle Database 11g/12c, Mongo DB, UNIX, SQL Loader, TOAD, SOAP UI, XML, SQL, PLSQL, VisioEnterprise Data Architecture, Jdeveloper, Groovy, Veridata.

Confidential, Detroit, MI

Tableau Developer/ Data Analyst

Responsibilities:

• Interacted with end-users and functional analysts to identify and developed Business Requirement Documents (BRD) for developing Advanced Customer Analytics Platform (ACAP).
• Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM) for ACAP which helped in controlling numerous artifacts produced by the teams across the deliverables.
• Gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards.
• Used geographic view which clearly gives the performance of any desired location or state.
• Developed customized calculations when required.
• Use MS Excel, Word, Access, and Power Point to process data, create reports in Tableau, analyze metrics, implement verification procedures, and fulfill client requests for information.
• 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.

Confidential, WV

Informatica Developer

Responsibilities:

• Analyze the specifications and identify source data, which needs to be moved to data warehouse,
• Participated in the Design Team and user requirement gathering meetings.
• Implemented Slowly Changing Dimension type2 methodology for accessing the full history of accounts and transaction information.
• Worked on Power Center client tools like Source Analyser, Warehouse Designer, Mapping Designer,
• Mapplet Designer and Transformations Developer.
• Used Debugger to check the data flow in the mapping and made appropriate changes in the mappings to generate the required results.
• Developed mappings to load data in slowly changing dimensions.
• Created Sessions in workflow manager and monitored it using workflow monitor.

Environment: Informatica 9.1, IDQ, SQL, PL/SQL, MS SQL server 2005, Unix Scripting, Flat Files, Windows Xp/NT/2000.