| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Harinder Singh Johal
EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLE
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
|
