SUMMARY:

• 7+ Years of IT Experience in Business Intelligence Tools and Database Design
• Over 5+ years of diverse progressive experience in Information Technology, with emphasis on Business Analysis using QlickView. A motivated, quick - learner, detail-oriented team player with excellent communication, analytical and interpersonal skills and an ability to effectively interact with technology as well as business counterparts
• Good exposure to the complete life cycle of Business Intelligence Qlikview Projects such as requirement analysis, High & Low Level design, development of reports/dashboards using QlikView, Testing, User Acceptance Testing, Go-Live, Support.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Knowledge on Data Warehousing concepts like, Star Schema, Snow-Flake, Fact and Dimension Tables, Master Data Management.
• Developed executive dashboards using QlikView 10.0/11.0 and delivered through the web.
• Good understanding ofQlikViewArchitecture. Extracting, Transforming and Loading data from different data source. Incremental loading is implemented.
• Design of QlikView applications using QlikView Data (QVD) files generated by ETL logic.
• Expertise in designing and modeling of QlikView with complex multiple data sources (SQL, Flat Files, Excel and Access, SAP) relational designs. Functioned as the Onsite / Offshore coordinator for a team.
• Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Excellent in writing QlikView Scripts, expressions, set analysis & macros.
• Working on Qlikview which connects to multiple data sources (via MS SQL Server, Oracle and MS Access)
• Experience in complete Project Life Cycle including documentation, analysis, development and testing
• Knowledge of Industry Best practices in both Business Management and Technology Domain
• Adept at solving complex problems through systematic approach that uses innovations and partnering combined with Project Management Principles to maximize ROI

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows Server 2003/2008, Unix; Solaris, AIX, and Linux

BI Tools: QlikView

Data Sources: SQL Server 2008, Oracle 10g/11g, SAP

Domains: Banking & Financial Services, Energy & Utilities, Retail

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. QlikView Developer

Responsibilities:

• Gathering functional requirements and reporting requirements from application stake holders.
• Coordinating and setting up Qlikview environment.
• Designing the data model in Qlikview to accommodate the application requirements.
• Working on writing complex Scripts to load Data in QlikView Applications.
• Developed SET ANALYSIS to provide custom functionality in QlikView Applications.
• Developing trend analysis reports using complex graphs for study of data quality patterns.
• Worked on large scale and data volume based applications. Worked on VBA Macros
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions
• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Dashboards were served to track services and service order information as well as to monitor various KPIs.
• Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Worked with QlikView, SQL Server, Oracle, SAP, Excel, flat files.
• There will 9 million records with 200,000/Month new records coming into system.
• Understanding Business objectives and accordingly developing reports that substantiates the data captured

Environment: SQL Server 2008 R2, Excel, Windows Server 2008, SAP, QlikView 11.20

Confidential, New York City, NY

QlikView Developer

Responsibilities:

• Collaborated with Business users and cross functional teams to develop Business Requirement Documents (BRD), define KPIs (Key Performance Indicators), and identify data sources.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track services and service order information as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Have knowledge in writing the Load scripts for QlikView.
• Worked extensively ontuning queries for QVD generation.
• Have good hands onQlikViewUI and service layer development experience.
• Assist in resolving the issues/cases raised by the users for this application.
• Assist in the creation of requirements and functional specifications.
• Defined site navigation and create interaction models for both internal and external clients.
• Experience in performance tuning, deployment, user .
• Participate in daily project meetings between Onsite & Offshore Teams
• Worked on large scale and data volume based applications.
• Involved in Extracting, Transforming and Loading data from different data source.
• Involved in Dashboard development & Unit Testing.
• Worked on writing complex SQL Scripts to load Data in QlikView Applications.
• Developed VBA Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.

Environment: Oracle 10 g, SQL Server, Excel, QlikView 10.0, Windows Server 2008 R2

Confidential, Columbus, OH

QlikView Developer

Responsibilities:

• Analyzed reporting requirements. Meeting with Sales General managers to define reporting requirements. Identified KPIs, designed report mockups and calculations.
• Extracted data residing on Oracle and loaded in the reporting schema using SSIS.
• Designed Framework manager models, QlikView reports, data storage using QVD and dashboards.
• Created reports & dashboards such as Sales trend, debtor’s ageing, contribution analysis, profitability analysis etc.
• User, mentoring of other developers.
• Set up the development, UAT & Production environment.
• Deployed the dashboards on the server
• System Tested the QlikView applications as per the test scripts.
• Facilitated the user acceptance testing
• License allocation & Server administration
• Created of the end user manual
• Conducted end-user

Environment: Oracle 10 g, SQL Server 2005 R2, Excel, XML, CSV, QlikView 9.0, Windows Server 2008

Confidential

Informatica Developer

Responsibilities:

• Installed and configured Informatica Power Center server and clients. Establish the ODBC and Native driver connections.
• Loaded data to the Interface tables from multiple data sources such as MS Access, SQL Server, DB2, Text files and Excel Spreadsheets using, SQL Loader Informatica.
• Analyzed data flow requirements and developed a scalable architecture for staging and loading data and Translated business rules and functionality requirements into ETL procedures.
• Expertise in Source definitions, Warehouse designing and modeling, Transformations, Mappings and Mapplets.
• Created and scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Server Manager.
• Worked with various active and passive transformations within Informatica Like expression, lookup, filter, rank, aggregate, update strategy, joiner etc…
• Major involvement in issues such as database space management, Application tuning Import and Export of database at regular intervals, to optimize I/O, SQL Tuning, Performance Monitoring, and using Data Import utility to transfer data from one database to another.
• Tuning of Applications using Explain Plan and SQL Trace.
• Developed test procedures to compare the aggregates of source and target databases.
• Involved in loading data from target to Essbase.
• Prepared, analyzed, and created all dimensions in Essbase outline and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions.
• Performed member loads and data loads successfully by using RUL file for various Cubes created.
• Maintained and developed Calculation Scripts and optimized it according to Essbase outline. Developed data load rules and reports.
• Provided technical guidance concerning business implications of reporting applications and running ADHOC queries that could be used in executive level presentations.

Environment: Informatica (Power Center/Power Mart), Oracle, SQL Server, Erwin, Perl, Essbase, SQL Server, Hyperion Reports, PL/SQL, Business Objects, SunOS, UNIX Shell Scripting, SQL*Loader, SQL*Plus