SUMMARY

• Having8+ yearsof experience in Data Warehousing and Business Intelligence in analysis, design, development, testing and implementation of teh reporting and ETL components.
• Data Visualization expert wif QlikView and LOGI Analytics.
• Over 3+ years of experience in designing, developing and deploying of QlikView Applications.
• Implemented teh 3 - tier architecture (Data-Extract, Data-Modeling and Application Development) as recommended in QlikView best practices guide.
• Designed efficient Data-Models from Multiple Data sources and followed teh Best-Practices guide provided by QlikView.
• Proficient in design and development of various Dashboards, Reports utilizing QlikView Visualizations like bar graphs, scatter plots, pie-charts, Geographic’s and other making use of actions, local and global filters according to teh end user requirements.
• Experience in QlikView scripting, Data Modeling and ETL Process.
• Experience in gathering and writing detailed business requirement and translating them into Technical Specifications/ System Requirement Specifications (SRS).
• Expertise in customizing Dashboards/Reports using Java, JavaScript, jQuery APIs, Web Services and third party plugins.
• Extensive experience in Dimensional Data Modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.
• Extensive noledge of all phases of teh Software development life cycle (SDLC), Agile, Scrum and teh iterative Rational Unified Process (RUP).
• Experience in developing applications using Java, J2EE Technologies like JSP, Servlets, JDBC, JMS, JExcel API and frameworks like Struts, Spring and Hibernate.
• Experience in Oracle Applications, Oracle Alerts and Discoverer Reports.
• Strong Database development experience in writing functions, packages, procedures, triggers and views in PL/SQL.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all teh reports and dashboards generated from various database sources.
• Expertise in Teradata, Oracle, SQL Server, Netezza, SSIS, SSRS, UNIX, Toad.
• Strong understanding of teh principles ofData Warehousingusingfact tables,dimension tables andstar/snowflake schema modeling.
• Strong analytical and problem solving skills.
• Team leadership abilities to manage projects wif deadlines.

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence (BI), Software Management, SDLC and Data Collection.

Data Visualization and Reporting: QlikView, Tableau, LOGI Analytics, MicroStrategy, Business Objects, Cognos, SSRS

ETL: Informatica, IBM DataStage, Ab Initio

Databases: Oracle 8i/9i/10g/11g, My SQL, MS-SQL Server 2005/2008, Netezza, Teradata

Tools and Packages: Toad, Aginity, SQL Developer.

Operating Systems: Windows- 95/98/2000/NT/XP, UNIX

Java Technologies and frameworks: Core Java, Advanced java, C, C++, JavaScript, SQL, PLSQL, JQuery, Struts, Spring, Hibernate, Log4j, Tomcat, Web Logic, JBoss, Ant, Maven, Hudson, Hibernate, JPA

Development IDE’S: Eclipse, Oracle JDeveloper 10G, Netbeans

Version Control Tools: CVS, Tortoise SVN

Tools and Methodologies: Confluence, JIRA, HPQC, Waterfall, Agile and Scrum.

PROFESSIONAL EXPERIENCE

Sr. BI QlikView Consultant

Confidential

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Participated in Business Processes wif teh Business Analyst to understand teh requirement and reviewed High Level Design Documents, Functional Specifications documents wif teh Technical Manager.
• Hands-on experience in teh design, development of end user applications for teh data presentation and analytics, including dashboards, reports, monitors, and graphic presentation (Information Visualization & Analysis) using QlikView 11 BI platform.
• Involved in teh daily standup wif business analysts and data architect to resolve teh business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.
• Extracted information from different data sources like Teradata, SQL Server, MS Access and flat files by using different scripts like add, concatenate, resident, qualify, unqualified etc..
• Wrote SQL queries and created ad hoc queries to perform data validation and analysis.
• Created QVD files to hold data from data sources and updated teh QVD files on timely basis as teh source database updates.
• Developed various QlikView Data Models by extracting and using teh data from various sources like QVD files, MS SQL DB, Excel, and Flat Files.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized QlikMarts.
• Designed best suitable UI to achieve user requirement in simple and user-friendly interface of reports.
• Used QlikView Functions (Date and Time, Keep, Join, Mapping, String & Input Fields, etc.) for creating dashboards, and designing teh User Interface based on business/user requirements.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, Statistics Box, Multi Box and Calendar & Date Island. Also, installed and deployed them according to UI design.
• Adept in creating various QlikView reports and publishing them as per clients request.
• Used Section access and Sheet access to make teh application available to desired users.
• Created dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, currency selection box, buttons, charts, text objects, bookmarks, etc.
• Customized and tweaked teh scripts and necessary data transformation, created simple and complex expressions (using Set Analysis).

Environment: QlikView 11.x, Oracle 11g, TOAD, Netezza, SQL Server, Teradata, Tortoise SVN and UNIX.

Confidential

Sr. BI LOGI Analytics Developer

Responsibilities:

• Interacted wif Business Users, Analyst and project owners to gather teh requirements and documented teh reporting development work to meet business objectives.
• Developed Dashboard/Reporting for Metering, Settlement, Resettlement and Billing screens wif data and charts using LOGI Analytics, Java Script and JQuery plugins.
• Developed different tabs for each screen for rich User Interface.
• Developed Bookmark feature which saves teh user preferences to a file/DB and redirects to teh page last selected when logged in teh second time.
• Used Web Services for User Authentication.
• Created Java plugins to manipulate teh LOGI XML data to incorporate business needs.
• Used Caching mechanism to retrieve teh data instead of re-querying teh database.
• Implemented Export functionality to PDF, Excel and Email attachments.
• Created filters and Validations which refreshes teh report based on teh filter selections made.
• Used Hudson for build and deployment process.
• Integration wif other Java web applications.

Environment: LOGI Analytics, JavaScript, JQuery, WebLogic, HPQC, SQL/PLSQL, Netezza, Tortoise SVN, Log4j.

Confidential

Sr. BI/Data Analyst

Responsibilities:

• Interacted wif teh stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated wif Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Responsible for defining teh scope of teh project, gathering business requirements, doing gap analysis and documenting them textually or wifin models.
• Gathering and documenting teh requirements dat are critical to teh business mission and using those requirements to design application software.
• Used MS Visio for flow-charting, process model and architectural design of teh application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for teh stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives wif each other, resolve any issues and come to an agreement quickly.
• Worked wif Source system Subject Matter Expert (SME) to ensure dat teh extracts are properly mapped.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Responsible for teh design, development, testing and implementation of systems to load source data into Target databases using Ab Initio.
• Designed different BI Dashboardsfor teh Company Executives, through an efficient use of MicroStrategyReport Services.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Actively tracking schedule, clear and crisp communications wif key resources, stake holders and SMEs to keep everyone involved in teh project on teh same page, milestone tracking and avoiding scope creep issues.

Environment: Teradata, Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, Ab Initio, MicroStrategy, Autosys, UNIX, SQL Server, ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential

Oracle/Java Developer

Responsibilities:

• Involved in teh requirement analysis and design for teh current product.
• Involved in rewriting teh Application from version 1 to 2.
• Developed JSP pages, Servlets and Java Beans to implement Struts Framework.
• Used XML for validation and mapping and DOM for parsing teh data.
• Involved in teh designing of teh Database structure and Writing packages, creating tables in Oracle.
• Performed Unit and Integration testing using JUnit.
• Provided production support which TEMPhas Enhancements, ticket resolving, defects.

Environment: JAVA, J2EE, JSP, Struts, JavaScript, Servlets, XML, Oracle9i, Oracle Applications 11.5.10, Toad,jDeveloper 10g, Apache Tomcat, Windows NT, Log4j, JUnit, CVS.

Confidential

Responsibilities:

• Designed Oracle Alerts for different applications like GL, Purchasing, Inventory, Order Management and for payables.
• Designed teh reports using Oracle Discoverer4i.
• Created queries for Alerts and Reports in Oracle Application.
• Troubleshooting and configuring to Oracle.
• Involved in Regression testing.

Environment: Oracle Applications, Toad, Oracle Alerts, Oracle Discoverer Reports.

Confidential

Responsibilities:

• Implemented teh application design on J2EE platform using Struts framework.
• Developed teh application wif teh Model View Controller (MVC)
• Programmed views using JSP pages wif teh Struts tag library, Model is a combination of Java classes (Form and Action classes) and Controllers are Servlets. Teh controller uses XML mappings in struts to map teh request to teh server side functionality.
• Provided client side validations wif Java Script.
• Involved in teh designing of teh Database structure and creating tables, writing procedures in MYSQL.

Environment: Java, Servlets, JSP, HTML, Jdeveloper 10g, JBoss, JavaScript, MYSQL, JUnit, Windows NT, CVS, log4j.

Confidential

Intranet Purchase Management System

Responsibilities:

• Involved in designing of use case diagrams.
• Created Java classes and Java beans for accessing database using Java/J2EE.
• Created classes for JDBC connection wif database.
• Created tables and queries in Oracle.
• Unit testing wif JUnit.
• Deploying to tomcat.
• Environment: Java, J2EE, Oracle, JDBC, UML, JUnit.