Harinder Singh Johal

abtzwj@r.postjobfree.com Mobile: 516-***-****

Business Intelligence Consultant

Technology Analyst with experience in analysis, design and development of custodial applications with

specialization in RDBMS, Data warehouse and client Server primarily using SQL, Crystal

Reports, Business Objects Web Intelligence, Java Infoview and IBM Cognos report studio. Analyzed data

to create functional specs as per end user requirements. Also Involved in implementation of BI projects

and have through understanding of data warehouse conceptual knowledge. Experience in Healthcare

environment. Areas of Expertise:

? Excellent problem-solving abilities ? Fostering teamwork

? Strong analytical skills ? Vendor/Client relations

? Hands-on and Proactive ? Strong collaborative skills

? Proficient in Structure query language (SQL) ? Requirements Analysis

? Quality communication ? Document management

? Quality and Productivity Improvement ? Software Development Life

Cycle management

Technical Skills

QAAWS, Crystal Reports R1/R2, Live Office R2/R3, Familiarity

SAP Business Objects 4.0/XI R2/R3 (Web intelligence XI R2/R3, Designer XI

R2/R3, Central Management Console, Infoview), Xcelsius 2008, SQL Server

Data Warehousing Tools Reporting Services (SSRS), SQL Server Integration Services (SSIS), Cognos

10 ( Report studio, Insight, Event Studio, & Framework), QlikView

(Enterprise Edition Server & Publisher), Spotfire, and Tableau (Desktop &

Server Edition)

Databases SQL Server 2005/2008, Oracle 10g/9i, MySQL, IBM DB2

Languages SQL, T-SQL, PL/SQL, PYTHON

Dimension/Data Modeling Star Schema Modeling, Snow Flake Modeling, Fact and Dimension Tables

Application Servers Tomcat 5.5, IBM Web sphere 6.1

Platforms Windows NT/ 2000/XP

Education

Nassau College

Computer Science A.S., Major

Computer Information Systems A.S., Minor

Stony Brook University

Computer Science, B.S major

Business Management, B.S., minor

Professional Experience

Enhanced Care Initiative Shelton, CT June 2010 to Present

Role: Junior Reports Analyst

Easy Care/ Quality of Life Care deliver comprehensive clinical and social services directly to

medically complex patients and their caregivers, including family and/or friends and family with

serious types of cancers. Easy Care is a community-based hands-on, nursing and nurse

practitioner driven intervention program that functions at all levels of the care continuum.

Responsibilities:

Business Object And Xcelsius Duties:

? Created Business objects reports using Universe, Custom SQL and derived tables.

? Created Webi reports using Business Objects functionalities like variables, @Functions, Cross

Tab, Master/Detail and Formulas etc.

? Created Prompts, conditions and Filters to improve the report generation, also used Data

tracking to improve the readability of the report.

? Created complex reports using advance function variables, multiple breaks, sorts, cascading

prompts, decode objects and extensively used breaks for white spaces and sections for better

navigability.

?Extensively used Calculations, Break points, Drill down, Slice and Dice, Formulas and,Filters ; Alerters for creating Complex Web Intelligence reports.

?Design, and developed complex Xcelsius dashboards for management.

? Provided technical assistance/support to analysts, business community and responded to

inquiries regarding errors, problems, or questions with programs/interfaces

?Applied security features of Business Objects like row level, report level and object level security

in the universe so as to make the sensitive data secure.

Sql Programming, Reporting and Migration Duties:

? Based on business requirement, developed SQL queries with Joins and T-SQL, Stored

procedure, Views, Trigger to implementing the business rules and transformations.

? Data Analysis and Designed the logical and physical model architecture for database.

? Interacted directly with the various SME (Subject Matter Expert) for gathering the business

requirements.

? Involved in Design DW of Star Schema (Dimensional model and Fact tables) based on business.

? Convert data from Legacy system to SQL Database.

? Data Migration from Flat files, CSV, MS-Access, Excel and OLE DB to SQL Database.

? Generated XML files from Database tables.

? Collected data from Various Heterogeneous database/files like MS SQL, DB2, ORACLE, Flat

...File, Access, Sybase, EXCEL sheets, CSV format and used complex data conversion to

...target.

? Involved in Query optimization, performance tuning and index creation.

? Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

? Used SSRS to create reports, customized Reports, on-demand reports.

? Database Backup and restoring the database.

? Validating and testing of the Database data, SQL codes and application

Environment: SQL Server 2008/2005/, SSIS, SSRS, Business Objects XIR2 (Designer, Web Intelligence,

Desktop Intelligence, Info View; CMC) MS-Access, DB2/UDB, WIN2000/XP.

References

Available upon request

Contact this candidate