Summary

• About 8 years of experience in all the phases of Data Warehouse Life Cycle involving design, development and analysis and testing in various areas of Data Warehousing.
• Experienced in QlikView, MS - SQL Server Reporting / Analysis Services and SharePoint tools.
• Four years of experience in QlikView with data modeling, analysis, design, testing, development and implementation of client/server applications, administration of QlikView for OLTP and OLAP Systems.
• Worked in all phases of Business Intelligence Life Cycle and Software Development Life Cycle.
• Utilized Qlikview Scheduler to manage and maintain scheduled jobs for Qlikview application dashboards
• Utilized Qlikview Publisher for client application rollout to Qlikview AccessPoint and administered security using Active Directory technology
• Gathered fair understanding of Qlikview application administration encompassing Planning/ Implementing
• User, Resource and Password Management, Backup Recovery Strategies, Performance Tuning, Creation and Configuration of database on Oracle
• Proficient in creating QV data models, QV objects, reports, graphical interactive UI using various data sources like Oracle, SQL Server, Access, text files, Excel documents etc.
• Experience in setting up server, publisher configurations and security/authorization at different levels.
• Installed and configured QlikView versions 11 and 10 SR4.
• Expertise in ETL Data Extraction, Transformation Loading , Data modeling, Report designing and Performance Tuning using QlikView
• Generate QVD files created by ETL logic to feed QlikView applications
• Experience in Incremental Loading QlikView document Versioning.
• Strong understanding of Dimensional Modeling technique, Multi-dimensional database Schemas like Star
• Schema, Snow flake Schema, Fact and Dimensional tables, Section Access, Set Analysis in QlikView and
• DW concepts
• Created data models for power users to create their own ad-hoc queries
• Expertise in working with relational databases such as Oracle, SQL Server, DB2 8.0/7.0
• Team oriented individual with a results driven attitude, strong interpersonal and communication skills in effective information exchange and interaction with clients at all levels of management.
• Excellent communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure.
• Quality is never an accident. It is the result of planning, teamwork and a commitment to Excellence.

TECHNICAL SKILLS:

• Data Warehousing tools ETL Informatica Power Center 9.5.1/9.1.0/8.6.1/8.1.1/ 7.1/ 6.1, Informatica Data Quality 9.5.1 Developer, Analyst , Power Exchange, Power Connect,
• QlikView 11.2 sr6, QlikView Informatica Connector
• Dimensional Data Modeling Tools Erwin 7.x/4.5/4.1
• RDBMS Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000, DB2, MS Access
• Languages SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl
• Operating Systems UNIX IBM AIX/HP-UX/Sun Solaris , Win XP/ NT/ Vista/7
• DB Utilities TOAD, SQL Loader

Professional Experience:

Confidential

Qlikview Developer

Responsibilities:

• Conducted JAD sessions with End user Meetings and Responsible for gathering Requirements
• Responsible for converting Functional Requirements into Technical Specifications
• Actively participated in requirement gathering working closely with business users and stakeholders.
• Involved in full project life cycle implementation requirement gathering to production of QlikView
• Dash boards.
• Involved in designing the data models, extract transform the data from heterogeneous data sources like
• QVD files, Excel, SQL Server, Oracle, Informatica, binary QVW, Inline txt files in creating the QlikView
• Dash boards.
• Worked with QlikView functions, objects, Set Analysis, Variables to generate different kinds of charts.
• Generated QVD files by writing scripts in QlikView applications.
• Built several Dashboards with current year statistics and trending information with ability to toggle between different metrics and drill down sheets and report detail charts for further analysis.
• Worked with QlikView administrator to optimize QlikView performance.
• Worked on Publisher to Automate and scheduled daily/weekly/monthly data loads of QVW documents and error notifications by email to assigned users.
• Closely worked with the release management team to facilitate smooth deployments of QlikView documents in addition also helped with database administration and development.
• Installation of IE plugins and worked with business analysts to train the end users to use the reports effectively to build and customize their ad-hoc reports.
• Trained a team of Rackers on QlikView in terms of best developing and design practices and general how
• to procedures.

Environment: QlikView 11.2 sr6, QlikView Informatica Connector, Oracle 10g, DB2, MS SQL Server 2008,

Toad, Informatica 9.0, Windows 2008 R2, Excel, MS Access, Flat files

Confidential

Qlikview Developer

Responsibilities:

• Interviewed users to identify problems, reporting requirements and problems in existing systems design.
• Collaborated with Business Intelligence team to learn current processes and practices
• Identified the Sales metrics for various businesses by interacting with users and analyzing Business Objects Reports.
• Generated new QVD files from the EDW by writing scripts in Qlikview applications
• Applied metrics in the data via QlikView scripts and transformed QVDs to cater the business needs.
• Designed and Developed QlikView dashboards meeting the business requirements.
• Published Client application using Qlikview Publisher and rolled out to Access point and administered security using Active Directory technology/Access DB integration
• Scheduled and managed QlikView jobs using Qlikview Scheduler for Qlikview application dashboards.
• Monitor computer systems to minimize unscheduled downtimes and ensured availability of resources.
• Assisted the users during UAT and incorporated the changes mentioned by the users.

Environment: QlikView 11.2/11/10.0, SAP R/3, QlikView Informatica Connector, Oracle 10g, DB2, MS SQL

Server 2008, Toad, Informatica 9.0, Windows 2008 R2, Excel, MS Access, Flat files

Confidential

Sr. ETL Developer

Responsibilities:

• Analyze the system, meeting with end users and business units to define the requirements.
• Involved in design phase of logical and physical data model using ERwin 4.0.
• Involved in designing STAR Schema for the business processes.
• Extracted the data from Oracle, Flat files and loaded them into Data Warehouse.
• Wrote SQL Queries, Stored Procedures, Functions and Shell Scripts to apply and maintain the Business Rules.
• Translated business requirements into Informatica mappings/workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse/Data Marts.
• Developed Mappings that extract data form ODS Operaional Data Store to Data mart and Monitored the Daily and Weekly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle, MS SQL Server databases.
• Extensive work on Performance Tuning, determining bottlenecks from session, target, source, mapping and transformations.
• Migrated existing mappings to production environment from testing phase.

Environment: Informatica PowerCenter 8.6.1/8.1.1,OBIEE, Oracle 10g/9i, PL/SQL, MS SQL Server 2005, PL/SQL, ERwin 4.0,Windows NT, UNIX Shell Scripts

Confidential

Sr. ETL Developer

Responsibilities:

• Responsible for coordinating with the Business Analysts and users to understand business and functional requirements and implement the same into an ETL design document.
• Developed various Informatica Mappings Mapplets using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Update Strategy, Expression, Stored Procedure, Normalizer, Union, Custom and Sequence Generator to load the data into the target tables.
• Performance tuning in Informatica Sessions and Mappings by identifying the bottlenecks and Implemented effective transformation Logic.
• Created and Monitored Sessions and various other Tasks such as Decision, Email, Assignment, Command etc. using Informatica Workflow Manager.
• Expertise in Incremental Aggregation for Improving Performance in Mapping and Session level.
• Created Mappings for Populating data to dimensions and fact tables
• Performed Informatica administration activities such as code migration from Dev to Test to Production, Creating folders and users and assigning required privileges/permissions.
• Worked with DBA team to fix performance issues in ETL programs.
• Developed PL/SQL stored procedures and functions, Indexes to handle various activities outside of Informatica ETL process. Created PL/SQL Functions Procedures for the ETL process and for Data Validations between source and target tables
• Closely worked and assisted the QA team during the test cycles to resolve the issues and bug fixing.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.
• Worked on Tickets during production support and used Autosys tool for scheduling.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL Server 2005, SQL, PL/SQL, Flat tiles, TOAD and Windows

Confidential

ETL Developer

Responsibilities

• Extensively used Informatica Power Center Designer to create source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Involved in regular discussions with the data analysts to gather the requirements.
• Involved in a Data Warehousing project, which consolidated the company's data come from different operational source and then data is transformed and loaded into a centralized data warehouse various strategic business reports.
• Extensively used Informatica power center to load data from flat files into the target tables.
• Extensively used transformations like lookups connected and unconnected , Update Strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generator and others.
• Extensively worked on Mapping Variables, Mapping Parameters.
• Developed very complex mappings per business requirements.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Involved in Production support.

Environment: Informatica Power Center 7.1, Win NT, Oracle9i, and UNIX