SUMMARY

• Well experienced in IT industry wif good understanding of Business intelligence applications, Database development, Data warehousing, Data marts.
• Extensive experience wif Qlikview BI in planning, designing, implementation, maintenance, expertise in designing Qlikview applications and building BI dashboard and analytics reporting solutions/reports wif graphs and analysis, utilizing BI tools (qlikview, BO, SSIS/SSRS/DTS), Databases(oracle, DB2, Microsoft SQL, IBM netezza), data analytics and dashboard visualization skills including ETL and reporting lifecycle reloads automation and management using Qlikview also creating qvd extracts and report reloads, reporting BI needs and enterprise reporting architecture
• Experience in scripting language Macro,VBScript,JavaScript,AJAX, PDF reporting, Qlikview enterpriser and publisher,Qlikview developer,Section Access writing,security Entitle model
• Strong background in database designing and creating Database objects such as tables, views, stored procedures, functions, database programming, data modeling, business process analysis, application development, implementation of the triggers, Procedures, functions at Database level and form level using PL/SQL.
• Experience in installing and configuring Qlikview Desktop, Qlikview Server, Qlikview publisher,Qlikview document Security wif section access.
• Strong Experience in Qlikview sheet objects, Pivot list, Multi box, Multiple chart types using complex multiple data sources like SQL, Flat files, Excel and access for deigning and modeling of Qlikview
• Highly proficient in creating dynamic packages for incremental loads and Data cleaning in Data Warehousing, maintaining Batch logging, Error logging, wif Event handlers and configuring and connection managers.
• Good Knowledge in Dimensional Data Modelling, Star Schema,Snow Flake Schema, Fact and Dimensional tables
• Expertise in performance tuning, logging, error handling of SSIS packages and deploying from development server to production server
• Authoritatively documented reports using SSRS from RDBMS, OLAP cubes,
• Involved in gathering requirements, developing Test Plans & Test Cases using specifications and design documents.
• Knowledge of complete software project development life cycle.
• Interacted wif Business users regarding Business Requirements.
• Possess problem - solving skills, ability to follow industry standards and procedures.
• Working noledge of RDBMS in ORACLE 8i/9i/10g and SQL SERVER 2000/2005.
• Proficient in SQL and PL/SQL Programming for reporting database integrity.
• Ability to work in a team environment. Strong communication and interpersonal skills, creation and implementation of KPI’s, deliveries as per SLA’s
• Ability to interact wif customers wif ease and professionalism.

TECHNICAL SKILLS

BI Tools: Qlikview 11/10/9, Hyperion reporting and analysis 9.x/11.x, SAP business objects,Crystal Reports, SAS

Tools: TOAD, SQL developer

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

ETL Tools: Informatica Power Mart 4.5.2, 4.7.3 and 5.1.1Power Center 1.7 and 5.1.2

Data Analysis and Reports: Business Objects v 5.1, Erwin data modeller

Web Applications: HTML, DHTML, XML 1.0, XSL, IIS 4.0, JSP, ASP 2.0

DBMS: Oracle 8.x, MS SQL Server, MS Access.

Servers: WebSphere 5.1, WebLogic 5.3

Languages: TSL, VB Script, Java Script, JDK 2.0, Java 1.2, SQL, PL/SQL, C, Shell, python

ERP Packages: Peoplesoft version 6.0. (People Tools, People Code & HRMS Module)

Packages: AutoCAD R -13, 14, MS Office 2000/XP.

Internet Tools: VB Script, Java Script, Active Server Pages 2.0, and HTML.

Job Scheduling: CONTROL-M & AnthillPro

PROFESSIONAL EXPERIENCE

Confidential, New York

Qlikview Developer

Responsibilities:

• Reviewed user requirements and expectations, providing end to end reporting solutions
• Created dashboards by extracting data from multiple databases, sorting into QVD files, write load scripts
• Executed existing data models and optimizing them including load scripts to load data.
• Design the data model, constructed data model, implementation of Star schema for QV better optimization
• Created Dashboards using chart boards such as Bar Chart,Pie chart, straight table and Pivot table
• Created Variables and to enhance the functionality of qlikview.
• Performed different tasks such as repeat tasks, reload tasks and distribution tasks using the Qlikview publisher
• Conducted testing of dashboards for functionality, data, performance, look and heel
• Managed schedules and reloading of qlikview data model QVds and QVWs through qlikview QEMC
• Developed Qlikview data warehouse enterprise framework
• Used exceptional handling for handling errors of programs, Scripts and procedures
• Participated in creating stored procedures to generate various Drill through reports and functions to support efficient data storage and manipulation
• Converted business requirements into technical specification and designed for reporting Database/data mart and Adhoc/standard reports using Qlikview
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar meeting the business requirements
• Generated new QVD files from the EDW by writing scripts in QlikView applications. Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys
• Developed forecast models and created 3 year forecast model implemented in Qlikview
• Extensively worked on QlikView Set Analysis
• Eliminated synthetic keys using QVD concatenation and/or Qualify based on the nature of synthetic keys
• Experience in scripting QlikView Set Analysis and Macros
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.Responsible for doing all the functional testing of the application
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Involved in defect tracking, reporting and coordination wif various groups from initial finding of defects to final resolution.

Environment: Qlikview 10/11, Oracle,SAP BW, SQL Server, Tera Data, SAP, Excel, CSV files, Enterprise Management Reporting Portal, DB2, QlikView Enterprise Server, QlikView Server and Publisher

Confidential, Livonia, Michigan

Qlikview Developer

Responsibilities:

• Gathering Business requirements and created technical and functional specs and worked wif business clients to confirm and clarify requirements and business logics
• Extracted information from different data sources like Teradata, Sql Server, MS access and flat files etc by using different scripts like add, concatenate, resident, qualify, unqualify
• Developed Dashboard size of layouts using different sheet boxes like list boxes, Multi boxes,slider, current selections box, bookmarks etc.
• Upgraded QlikView Server from QlikView 9.0 SR3 to QlikView 10.0 SR3
• Wrote scripts and created batch files for automatic running of Qlikview scripts and was also responsible for batch scheduling
• Automated and scheduled daily /weekly /monthly data loads of QVW documents using Qlikview publisher
• Conducted different tasks like repeat tasks, reload tasks, and distribution tasks using the qlikview publisher
• Maintained and administrated source documents, source document sets, user profiles and executed resource management services like access point resources, distribution folders and email servers.
• Optimizing existing data models including changing load scripts to load data in optimized way to achieve reduction in loading time, simplifying complex issues in the front end, improving layout structure.
• Involved in design and development of Qlikview platform integrated and expandable databases.
• Created complex data models wifout synthetic tables and circular loops
• Involved in writing shell scripts.
• Validated Architectural conceptual documentation and Technical specification documentation
• Tested the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Verified schedules and monitoring sessions using Informatica Server Manager
• Verified very often, the Source to Target Field Mapping Report, dis contained transformations, expressions and descriptions in a mapping for documentation.
• Prepare log file from test environment UNIX box on periodical basis to allow space.
• Coordinated wif the developers to fix the problem and enhancing the application delivery process.

Environment: Windows 2000 Server, Qlikview 11.0, Oracle 11g, SQL Server 2005, MS Office.

Confidential

Data Analyst

Responsibilities:

• Worked directly wif end users to gather Business requirements,
• Design and develop a front application in VB 5.0.
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0.
• Analyzed the source data coordinated wif data warehouse team in developing relational model.
• Used ETL for the design of the Warehouse
• Used the Oracle Client, TOAD to run SQL queries. Written advanced SQL queries to test the database backend.
• Responsible for classifying the attributes and entities as part of Entity Relationship Modeling
• Involved in Data Mapping for given set of requirements, Queried the Database using Complex SQL Queries as part of Data Mining and performed analysis, design and Data Modeling
• Involved extensively in the Logical, Physical, Transformational and Conceptual stages of Data Modeling, during the Database Design Life Cycle (DDLC)
• Used MS Excel to create Tables and Charts
• Extensively used Erwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Worked wif disaster management policies to manage slippage, budget problems and conflicting schedules.
• Work wif stakeholders and developers to ensure adequate level of detail in milestone and issue reporting
• Used Microsoft Project to create visual representations of Program Plan for reporting to Senior and Executive level managers and update them regularly
• Created new wikis/information portals for the various groups wifin engineering (Apache Web server and eTouch/SamePage wiki), including: audience analysis, wireframes, blueprints and functional prototypes.
• Developed Project Concept and Defined Project Scope wif the assistance of team lead.
• Created Work Breakdown Structures (WBS), Project Timelines and Project Schedules using MS Project.
• Perform data manipulations and scrubbing. Unix, BTEQ and KSH scripting
• Designed the database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Manipulated and updated the tables as per specifications and extensively used stored procedures.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Came up wif methods to improve functionality and TEMPeffectiveness of the code by brainstorming wif other team members during team meetings and discussions.
• Assisted the DBA wif scheduling jobs, running various scripts related to space management
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues
• Automating reports using MS Excel wif ODBC Connection.
• Scheduling SQL Job to run at night times.
• Designed and developed a metadata driven automated reporting system

Environment: Visual Basics 6.0 MS Access, Word, Excel, Windows