SUMMARY

• Around 8 years of total IT industry experience analysis, design, testing, development covering areas of designing and development of Data warehousing and Business Intelligence applications.
• Functional knowledge on various domains like Finance and Telecom.
• Expert in design, development & administration of Tableau, QlikView for OLTP and OLAP Systems.
• Expert in creating reports using features like Drill down, hyper linking, ranking.
• Expertise in designing and modelling of data with complex multiple data sources (Oracle, SQL Server, Flat Files, Excel and Access, relational designs)
• Proficient in data loads, database integration/conversions, performance tuning and optimization.
• Proficient in creating data models, reports, interactive GUI and dashboard using different data sources like Oracle, Access, text files, excel documents etc. as per the user requirement.
• Good knowledge of Data Visualization, Data reporting, Data Warehousing Models, Data discovery, RDBMS concepts, SQL, PL SQL, Oracle and SQL Server.
• Expertise in Data Analysis, optimizing, Debugging and testing SQL queries.
• Excellent analytical, co - ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

TECHNICAL SKILLS

BI Tool: Tableau 7.0, 8.0 QlikView 8.2,9,10

Web Technology: Java Script, VB Script, XML

Languages: SQL, PL/SQL, C

Databases: Oracle (8i, 10g), SQL2000, MS SQL server 2008

Reporting Tools: Tableau, QlikView

Office Tools: MS Excel/Access/PowerPoint/MS Word

Operating System: Windows-XP, Windows 2003/2007, Unix.

PROFESSIONAL EXPERIENCE

Confidential, NY

BI Developer /Analyst

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc.
• For the client at a glance, also interact with data as necessary
• Created Dashboards and Reports for monitoring metrics related to Global Wealth Management Operations.
• Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily.
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Conducted User Training Sessions and prepared User Manual Document.

Environment: Tableau 7.0, 8.0, MS Excel, SQL Server, Alteryx.

Confidential, Atlanta, GA

BI Developer / Analyst

Responsibilities:

• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Met with users to understand existing reports and issues.
• Understanding what the client is expecting out of the reports, data cleaning to get to the right numbers for the weekly report.
• Analyzed and gained understanding of the underlying data. Enterprise Key Metric dashboard is sourced from multiple excel files.
• Designed dashboards for Project/Resource analysis application and Enterprise Key Metric application.
• These dashboards were utilized by higher management to do analysis, product development and their market share.
• Developed dashboards pertaining to Revenue and Sales monitoring using Tableau 7.0.
• Demo of dashboard to users to enhance their knowledge on all the key capabilities of application.
• Also developed a process in the company to generated tableau dashboards, which can be used for all the clients in the company by gathering the requirements.
• Performed UAT and successful production migrations and handover to production support to close the projects.

Environment: Tableau 7.0, Netezza, Oracle 10g, SQL Server, MS Access, Excel.

Confidential, GA

BI Developer /Analyst

Responsibilities:

• Developed Dashboards and Reports for monitoring metrics using QlikView 9.
• Participated in User discussions to understand the user requirements, layout and look and feel of the Dashboard.
• Gathering and documenting QlikView application requirement form the users.
• Designing the High Level Design document.
• Designing the Data models, extract & transforming the data from the heterogeneous data sources.
• Leveraged QlikView Software applications to create Reports & dashboards.
• Implemented incremental Load strategy.
• Implemented data level security using Section Access feature of QlikView.
• Job scheduling of QVW files for regular reload from server using Autosys.
• Performed UAT and successful deployment of the project.

Environment: QlikView 9.0, Oracle 10g, MS Access 2005, MS SQL Server 2005, MS Excel.

Confidential, TX

Business Intelligence Developer

Responsibilities:

• Developed Dashboards by analyzing business data as per client requirements.
• Developed different types of chart objects Bar charts, Line charts for Trend Analysis, Straight Tables, Pivot Tables, Pie charts etc.
• Developed Macros to provide custom functionality in the QlikView Application.
• Validation of QlikView application at base level against QVD’s and Excel test files.
• Participated in deployment activities of the QlikView Application.
• Extensive experience in using various QlikView Functions (Date and Time, Keep, Join, Mapping &String etc.) while creating Data Models.

Environment: QlikView 8.2, Excel, MS Access, Windows XP.

Confidential, NC

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 scribed 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 on 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, Windows NT, UNIX.