Karanpreet Singh
Lake Zurich
Summary
Dynamic and results-oriented professional specializing in Business Intelligence (BI) Analytics and data warehousing, with a strong focus on Business Objects. Extensive experience as a Data Warehouse Developer/Analyst, skilled in system analysis, data modeling, and database reporting. Proven track record in building complex Universes, utilizing various data retrieval methods, and creating insightful ad-hoc reports using Business Objects and Web Intelligence tools. Recognized for exceptional analytical abilities, leadership skills, and a commitment to enhancing organizational performance across diverse industries.
Overview
26
26
years of professional experience
1
1
Certification
Work History
Business Info Consultant
Carelon
08.2016 - Current
- Working as Business Info Consultant for creating and scheduling and supporting the Business Objects reports and providing the business solutions on the daily basis.
- Meet with clients, Get requirements, Work with ETL team, Create Data dimensions, Metrices, KPIs, Update universes.
- Accountable for delivering membership metrics across various dimensions for billing purposes. Managed metrices for 69M members.
- Worked on project for saving about $1.5M/month for cost of procedures for clients (Average savings of $1k/case),Worked with cross platform business units to create data visualization reports, Mentored colleagues on ongoing basis. Give Inputs on datawarehousing metrics.
- Liaised with customers, management, and Finance team to better understand customer needs and recommend appropriate solutions.
Sr Business Info Analyst
Wellpoint
06.2011 - 08.2016
- Worked as Sr Business Info Analyst for creating and scheduling and supporting various BI reports and providing the business solutions on the daily basis. Gather Report Requirements / convert to KPIs for Business needs.
- Developed effective improvement plans in alignment with goals and specifications.
- Created and managed project plans and timelines.
- Evaluated customer needs and feedback to drive reporting improvements.
Business Objects Developer/Analyst
American Imaging Management
05.2007 - 06.2011
- Worked as Business Objects Developer/Analyst for creating and scheduling and supporting the Business Objects reports and providing the business solutions on the daily basis.
- Environment: Business Objects XI r2 (Designer, WebI, Desktop Intelligence), SQL Server, Sybase, Microsoft Excel, Microsoft Access
Business Objects Developer
OfficeMax
09.2006 - 03.2007
- Worked in the inventory management team on Retrofit reporting Project as Business Objects Developer. During the process of merging the OfficeMax retail organization into existing Boise Cascade contract management business, the combined information data infrastructure supporting the two companies has failed to provide consistent source of timely and reliable data. There was need for reporting to be done which provides the end users the forecast accuracy, purchase order and vendor performance.
- Responsibilities:
- Interacted with end users to get the requirements for reports.
- The existing universe called retail ad-hoc universe, already developed in 1st phase of the project, was modified and new tables inserted to support reporting needs.
- New Objects and filters and prompts were added in the existing retail ad-hoc universe to support ad-hoc needs.
- Exported the universe for users to create ad-hoc reports.
- Created new reports and modified the existing reports, for which data was merged from two different universes, one in access and other in oracle.
- Unit tested the reports and provided support for UAT.
- Created the Vendor Scorecard universe which will support the current Vendor Scorecard application in use. For this logic behind the vendor scorecard application was applied in the universe design.
- The Vendor Scorecard universe was tested and then exported.
- The reports, already developed using Vendor Scorecard application, are recreated in WebI using the Business Objects Vendor Scorecard Application.
- Created the Design Brief Documentation for Business Objects universe and reports.
- Helped the existing staff with their ad-hoc reporting.
- Providing training in business objects for testing staff.
- Environment: Business Objects XI r2 (Designer, WebI, Desktop Intelligence), Oracle 9i, Toad, Excel, Access
Programmer Analyst/Business Objects Developer
Verinon Technology Solutions Ltd.
10.2004 - 03.2007
- Worked as Programmer Analyst/Business Objects developer for providing Business solutions to the following clients:
Business Objects Developer
Walgreens
06.2005 - 08.2006
- Walgreens Retrospective Drug Utilization (RDUR) program started by Walgreen aims at creating reports for RDUR pharmacists, medical providers, pharmacy providers and clients. For this universe was created which was queried to generate complex reports helping the users to create critical decisions.
- Interacting with the end users for business requirements and creating the reporting design brief.
- Analyzing the universe design through the design document and documenting the analysis procedure.
- Created multiple universes, one having summarized data and other that is more detailed one.
- Setting up the universe parameters.
- Created Classes, Measured Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic while creating the universe.
- Resolving the universe issues like loops to remove cyclic dependencies between the tables and traps through aliases and contexts
- Checking on the universe integrity and refreshing the universe on regular basis to keep it updated with the changes in the database.
- Designed, developed, tested and maintained highly complex reports.
- Created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), used complex SQL queries and joins for reporting purposes.
- Created the reports which were implemented in BO full client and in certain cases viewable over the web.
- Used various reporting functionalities such as sectioning, filtering, Alerters, Breaks, Sorting, Ranking, slice and dice panel to create the reports and organizing data in them.
- Created variables at reporter module for creating the reports
- Used Free Hand SQL for creating some ad-hoc reports.
- Unit testing the reports and checking and resolving on the data issues in the reports.
- Tuning of the SQL queries for performance issues in the reports.
- Exporting universe to the repository.
- Automated the document scheduling and distribution through Broadcast agent.
- Working Knowledge in Web I administration and Info View portal.
- Performed the UAT testing with end users and supported the system testing and provided client support as needed.
- Environment: Business Objects full client version 5.1.8/6.5/XI, Info View, WEBI, Broadcast Agent, Oracle 9i, SQL plus, Toad, Excel, Windows XP professional, Lotus Notes
Business Objects Developer
Walgreens
03.2005 - 05.2005
- Home Care Sales Commission project, PatientLogix, was built from three different sources: HAI, Dezine and Masteamed. Sales transactions created in PatientLogix and sales adjustments created in Pharmacy Accounts Receivable system (PARS) were to be captured for reporting. For this new DSS was created and this database was used to create universe in 1st phase , which further will be queried for reporting purposes. This project provided users with access to the sales transactions and adjustment data.
- Interacted with the end users for requirement gathering.
- Used Erwin tool for data modeling for creating logical database in star schema and further interacted with DBA for guiding him to develop physical data model.
- Used the above created database for creating the universe for 1st phase of the project.
- Created Classes, Measured Objects, Dimension Objects, Detail Objects and defined predefined conditions for universe creation.
- Solved the universe issues like fan and chasm traps through aliases and contexts.
- Data loaded in the tables of the universe and testing was done on the universe to check for the universe integrity.
- Exporting the universe to the repository.
- Documented the universe analysis and universe creation procedure.
- Created Migration Documentation and Process Flow for mappings and sessions.
- Knowledge transfer to the end user at the end of the project.
- Environment: Business Objects v 5.1.8(Designer, Reporter), Windows XP, MS Excel, Oracle 9i, Erwin, Lotus Notes
Business Object Developer
American Honda Company Inc.
02.2005 - 03.2005
- Company’s Ecare project was developed to enable corporate management staff to see the effectiveness in enabling the customers to set appointments at Honda and Acura dealership. Ecare’s On-line service scheduling enrollment and appointment reports for Honda or Acura by division, Zone and district level were developed by enhancing the Ecare universe.
- Responsibilities:
- Installing the Repository, set configuration, Create Multiple Domains, and set up User Security using supervisor module.
- Supervisor Module was used to create designer who can modify the universe to help create the new reports.
- Permission to grant access to export the universe to the repository was granted.
- Modified the existing universe to develop the reports at division, district and zone level.
- New fact tables and dimension tables were added in new contexts in the existing universe.
- New objects and pre-defined conditions were created at universe level for making the reports.
- Created custom Lov’s in the process of designing the universes based on the Business requirements.
- Created the joins and set cardinalities between various tables in the universe.
- Universe was exported to the repository to enable users to access it.
- Created the reports at division, zone and district level to help end users and customers analyze the data at various levels.
- Used cross tab functionality, filtering, alerters, multi cube function, breaks and prompts to create reports as per user requirements.
- Many report level variables and stored procedures were created to help make reports.
- The bar graphs, pie charts and line charts were created in the report from the data in the report.
- Performed SQL query tuning using TOAD to resolve performance issues successfully.
- Exported the reports to various formats like Excel, PDF and HTML formats.
- Migrated and tested few reports from BO v6.1b to 6.5.1
- The reports were published to the corporate documents to enable the end users see the reports using info view.
- Environment: Business objects (Supervisor, Designer and Reporter v6.1b/6.5.1), Broadcast Agent 6.1b, SQL server 2000, Windows 2000, MS excel.
Business Object Developer
Walgreens
01.2005 - 02.2005
- Walgreens’s STAR project was developed to help company make various decisions to improve performance issues. Many new reports were developed at chain level and division level to help company see performance issues at these levels and the existing dashboard report was modified according to company needs.
- Responsibilities:
- Maintained and updated the existing STAR 5.1B universe to make new reports.
- Created Aliases and joins and set cardinalities between tables in the universe.
- Created new conditions and objects at universe level for making new reports.
- Checked integrity function for universe
- Resolved the loops using aliases.
- Set the hierarchy level for drilling down to make new reports.
- Created various reports at chain level and division level and use drill down method to reach at store level.
- Extensively used various functionality such as sectioning, filtering, slice and dice panel to create the reports.
- Created cross tab and master detail reports and graphical reports including line graphs, pie chart, 2d and 3d charts
- Modified the existing Dashboard report according to the business requirements and company needs.
- Exported the universe to the repository and published the reports to corporate documents for end users to use and see.
- Used the scheduler to send reports at particular time to end users
- Environment: Business Objects Designer and Reporter 5.1.8, Oracle 9i, Broadcast agent, MS access, and Windows NT 2000 server.
Assistant Design Engineer
Punjab Micro Circuits Research Labs Pvt. Ltd.
07.2000 - 06.2001
- Worked as a design engineer. Responsibility includes designing and testing the digital systems using PSPICE software.
Education
MS - Computer Science
California State University
Fresno, CA05-2004
BE - Electronics and Electrical Communication
Punjab Technical University
Punjab, India05-2000
Skills
- BI Tools: Business Objects (Designer/ Desktop Intelligence/ Supervisor v518/61b/65/XIr2), InfoView, Web-Intelligence v272 /61/XIr2/31/40/41/42/43, Broad cast Agent, ZABO, Cognos (Impromptu, Power play, Report net), UDT/IDT, Crystal Reports, Tableau, Qliksense
- ETL Tools: Informatica (Power Center / Power mart and Power Connect, Power Channel 40/50/51/60), SQL Loader
- Database: Oracle 8i /9i, MS-SQL Server v70/2000, MS –Access, SQL Server Management Studio 19
- Data Modeling Tools: Platinum Erwin 35/352 & 40
- Languages: SQL, PL/SQL, ASP, C/C, HTML, DHTML, Java, PHP, VB 50, MS Project, MS-Office and Visio
- Operating Systems: Windows 95/98/2000 /NT/XP, HP Unix, Windows10/11
- Technical review
- Business presentation
Certification
- Programming using Unix and C++.
- Java Certified
- Certification on digital system design using PSPICE software.
HONORS AND ACHIEVEMENTS
Awarded All Round best student award in school., Among top 1% in Mathematics Olympiad at state level, School Sports Captain.
Timeline
Business Info Consultant
Carelon
08.2016 - Current
Sr Business Info Analyst
Wellpoint
06.2011 - 08.2016
Business Objects Developer/Analyst
American Imaging Management
05.2007 - 06.2011
Business Objects Developer
OfficeMax
09.2006 - 03.2007
Business Objects Developer
Walgreens
06.2005 - 08.2006
Business Objects Developer
Walgreens
03.2005 - 05.2005
Business Object Developer
American Honda Company Inc.
02.2005 - 03.2005
Business Object Developer
Walgreens
01.2005 - 02.2005
Programmer Analyst/Business Objects Developer
Verinon Technology Solutions Ltd.
10.2004 - 03.2007
Assistant Design Engineer
Punjab Micro Circuits Research Labs Pvt. Ltd.
07.2000 - 06.2001
BE - Electronics and Electrical Communication
Punjab Technical University
MS - Computer Science
California State University