SUMMARY

• 6 plus years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Experience covers areas of designing and development of Data warehousing and Business Intelligence applications.
• Good experience in design, development & administration of Tableau, QlikView
• Expert in creating reports using features like Drill down, hyper linking, ranking, breaks andmerged dimensions.
• Expertise in designing data models from multiple data sources and developing custom dashboards/reports.
• Strong business analysis and requirement gathering background.
• Comfortable building complex visualizations and analyzing trends using Tableau.
• Experience in optimizing existing QlikView reports with a focus on usability, performance, flexibility, testability, and standardization.
• Involved extensively in creating Report Requirement Templates, High Level Documents and Low Level Documents.
• Strong understanding of Data warehousing concepts such as Star Schema, Snowflake Schemas, and Multi - Dimensional Modeling.
• Experienced in writing SQL queries to debug data and to analyze query
• Ability to synthesize substantial volumes of information.
• Ability to work both independently and in a team.
• Versatile team player with strong analytical and problem solving skills and excellent inter personal skills.
• Reliable, Driven, Respectful, Friendly and Innovative.
• Comfortable working with key stakeholders of various business units in multiple projects simultaneously.

TECHNICAL SKILLS

BI tools: Tableau 7, QlikView 8.5/9.0/10, Business Objects.

Databases: Oracle 10g/9i, SQL Server 2005/2008, MS Access 2000/97

Data Modeling: Erwin 3.5.2/4.0

Languages: C, C++, Unix shell script, T-SQL, PL/SQL., MDX.

Operating systems: Windows XP/2002/2003/Windows 7, UNIX.

Other tools: SQL* Plus, Putty, SQL Developer, Toad, SQL Server Management Studio, Informatica.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Development of COMPASS pilot dashboard using Tableau desktop version 7.0.
• Gathered requirements from business users and transformed them into specification documents
• Created several compound layouts in reports with different views using View Selector, Column Selector, Narrative with HTML, Static with HTML, Views involving presentation variables, Charts, Pivot Tables with and without Charts, Hyperlinks and Column/data level guided navigation/hyperlinks.
• Was responsible for creating multiple dashboards involving multiple pages, guided navigation from one page to another, hyperlinks to navigate from Summary reports to Details report and to Ad-hoc/stand-alone reports.
• Migration of dashboard and sheets to multiple environments.
• Performed Unit Testing and data integrity testing for the reports/dashboards developed.
• Was responsible for generating Usage Reports, Performance Statistic reports to high level management daily / weekly using Tableau Server.
• Participated in knowledge transfer sessions to testers, Analysts and business Users.

Environment: Tableau Desktop 7.0, Tableau Server, Oracle, MS Office 2007/2010, Windows 7, TOAD.

Confidential, Jersey City, NJ

Tableau Consultant

Responsibilities:

• Facilitated interview sessions to identify Business rules and Requirements and then documented in a format that can be reviewed and understood by the whole team.
• Provided mock up visuals to speed up requirements visualization.
• Built Pilot project and demonstrated to business users on the capabilities of Tableau Visualizations.
• Conducted various discussions with Management in order to tweak and finalize target visualizations.
• Designed and deployed reports with Drill Down and Drop down menu option and Parameterized and Linked reports using Tableau.
• Developed various database objects like Tables, Views and Stored Procedures, Functions, Packages by using SQL*Plus, PL/SQL in Oracle.

Environment: Tableau 6.1.4, Windows 7, Oracle 10g, SQL, PL/SQL, MS-Office

Confidential, NYC, NY

QlikView developer

Responsibilities:

• Participating in business requirements and design review sessions.
• Imported data from multiple data sources including Web Services, MS SQL Server and MS Excel through modeling data as per user requirements.
• Creating complex data models without synthetic tables and circular loops.
• Create and manage ETL script generation using QlikView Script Builder Application.
• Developed QlikView applications creating expressions using set analysis.
• Created and scheduled Complex reports by leveraging the basic components of QlikView.
• Performed different tasks like repeat tasks, reload tasks and distribution tasks using the QlikView publisher.
• Optimizing existing data models including changing load scripts to load data in optimised way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure
• Providing support analyst when internal teams have enquiries.
• Research and troubleshoot technical problems.

Environment: QlikView 8.5/9, SQL Server, ASP, HTML, VB Script.

Confidential, Charlotte, NC

BI Developer

Responsibilities:

• Direct and independent interaction with stack holders and clients on daily basis, requirement gathering, requirement analysis, work estimations, design, developed, testing and production support of QlikView reports.
• Implemented Security & involved in Deployment of QlikView Applications.
• Developed extensively Alerts, Variables, Input boxes, calendar & Macros.
• Developed Concatenation and solved the loops issues.
• Loaded data into QlikView from various data sources optimization using incremental load (Insert, update and delete) and field trimming.
• Used to solve the issues related to the end users.
• Implemented advanced SET Analysis for aggregation calculations so that set of records can be defined in an expression.
• Identified bugs in existing mappings by analyzing the data flow, and fixing the bugs.
• Responsible for the performance and tuning of the application.
• Coordinated with Team Members in development process to integrate with the Test and Production Servers and helped creating use cases.
• Involved in Production Support for QlikView applications & Server.

Environment: QlikView 8.5, SQL Server, Oracle Database, Microsoft Access, Windows 2003.

Confidential

Database Developer

Responsibilities:

• Documented requirements gathered from the business users and customers.
• Wrote Oracle, SQL and PL/SQL code to implement the technical design.
• Interacted with the business and IT to understand the business process, business needs and how they relate to IT.
• Actively Participated in JAD session and described the requirements.
• Developed BRDs in close coordination with the Marketing Group. Decided, on visual and functional aspects required for the developed reports.
• Supported with analytics and BI implementation to the Marketing Division of the personal credit group.
• Provided necessary Analysis to enable campaign list pulls and validation of lists.
• Assisted users on useful business cases to display the reports. Developed a thorough understanding of the business process while doing so.
• Responsible for Report design, and supporting modification of existing reports. Reports dealt with user related KPIs based credit scores.
• Helped end users to design test cases and worked through multiple UAT cycles.

Environment: Oracle 8i, PL/SQL, SQL*Loader, ODBC, Informatica, Windows XP, UNIX.