SUMMARY

• 9+years of adept experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas.
• Extensive Business Intelligence and Data warehousing experience using QlikView, Tableau, SSRS, OBIEE 11g/10g/Siebel Analytics 7.x,, Informatica7.x/6.x
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.
• Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and Production support.
• Experience in HR and Financial analytics implementation.

TECHNICAL SKILLS

• QlikView 11, OBIEE 11, SSRS, OBIEE 10.1.3.4.1 , Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler, BI Publisher,
• Oracle 8.x/9i/10g/11g, MS - SQL, SQL Server.
• SQL*PLUS 8.x/9.x, PL/SQL
• Windows 95/98/NT/2000/XP, Vista and Windows 7, Sun Solaris, HP Unix, MS Access, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Louisville, CO

Sr. Qlikview Developer

Responsibilities:

• Worked closely with sales, marketing, and production business units to perform business and system analysis.
• Developed QlikView Dashboards using Chart (Drill down), List Box, Input Field, Table Box and Calendar & Date Island.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.
• Hands on retrieving of external data to QlikView Dashboard in terms of QVDs by making connection through ODBC.
• Experience in designing QlikView Document/User Setting, Layouts to make consistent and professional optimized look to clients.
• Experience with QlikView sheet objects including multiple charts types, Trends, KPI's, Bookmarks, Pivoting, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting and other KPI's.
• Created QVD's & updated on timely basis as database updates. Developed ETL Scripts while loading the data,resolved Circular Relationships, Synthetic Keys.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using QlikView.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Qlikview.
• Created QlikView Visualizations, Dashboards as per user requirement.
• Developed Dashboards/Reports using the QlikView requirement analysis.
• Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Involving in Unit Testing, Validating Reports and production support.
• Created ad-hoc reports to test dashboards, reports, to demonstrate the report functionality to the end-user.

Environment: Qlikview: QlikView Desktop 11, QlikView Server 11

Confidential, Beverly, MA

QlikView/BI developer

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Created highly interactive visual Reports using QlikView .
• Designed business intelligence dashboards using QlikView (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Gathered, documented requirement from the users and developed Complex Graphical User Interactive reports using various QlikView Objects.
• Strong Skills in Data Modeling & Loading data from multiple data sources. .
• Actively involved in deployment and post release support.
• Validated technical design created by developers against functional specifications.
• Created interactive dashboards using OBIEE 10g, created ibots.
• Lead OBIEE and QA teams to design test plan for user Acceptance Testing (UAT)
• Provided formal project presentations to the client, executive management and line staff as required
• Trained the users on how to use the Dashboards and Interactive Reports.

Environment: Dash boarding/Analytics QlikView 10, MS SharePoint

Confidential, Milwaukee, WI

Sr. BI Consultant

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Created Technical Requirement based on BRD functional document for (Order Management, Order Fulfillment and Inventory Etc)
• Explored QlikView desktop - the pioneered in-memory Dash boarding tool.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Involved in designing and development of building Physical Layer, Business model and presentation layer and report development.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BM and Presentation layer data models. Also created hierarchies and variables in the repository
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Modified many logical Metrics/Columns by duplicating as per the requirements.
• Involved in implementing the Security by creating the Users, Groups, Web Groups In RPD and Web Catalog using OBIEE.
• Created Complex Reports by using Pivot, Table, Chart, Column selector, View Selector and Union view for POS and Performance Reports/Dashboards.
• Enabled Usage Tracking and Dashboards to track performance by updating the NQSconfig.INI file.

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6.1, Siebel CRM, SQL Developer, Linux and Windows Server 2003, QlikView 8.x.

Confidential, Cupertino, CA 

BI/ETL Consultant

Responsibilities:

• Gathered user requirements from business representatives and convert them into functional and technical specifications
• Handled rapidly growing dimensions while maintaining the history of the data.
• Migrated packages from development server to production server using package configuration.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub - Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Implemented AD HOC reporting with the report builder for the end users.
• Generated reports using Expressions and Functions using SSRS.
• Analyzed the existing applications and identified redundant data sourced from the same data sources.
• Developed Proof of Concepts of consolidated applications and demonstrate to the Business users.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems
• Developed Mappings/Mapplets and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator)
• Designed and documented the validation rules, error handling and test strategy of the mapping
• Tuned the sessions for better performance by implementing the partitions
• Implemented Dimensional modeling in the database and created appropriate views along with DBA to acquire the Metadata for the given requirement.