Business Intelligence Sql Server
Resume:
Raja Hamid Nawaz Khan
**********@*****.***
Summary:
Extensive experience in the field of business Intelligence (BI), data ware housing and building Data Marts.
Cognos BI Suite: Cognos 10.2.1/10.1/8.4/ 8.3/8.2/8.1.2 MR2 (Analysis Studio, Report Studio, Query studio, Event studio, metric studio) Cognos ReportNet 1.1 Cognos Connection, Query Studio, Report studio, framework manager, Cognos configuration.
Experience with Cognos Series 7 (Cognos impromptu, Cognos IWR, Cognos Transformer, Cognos PowerPlay, Cognos PowerPlay Enterprise Server, Cognos Server Administration, Access Manager, Cognos upfront.)
Strong experience in designing, working with and development of Star/Snowflake Schema Design, DataMart and Dimensional Models.
Using Cognos Report Studio and Report Net 1.0/1.1x. Expertise in building and publishing packages using Framework Manager, metadata modeling tool.
Expertise in creating users, maintaining user profile, administrative tasks like deployment from one environment to another.
Created PowerPlay Cubes using Power play transformer, created cubes using IQD from framework Manager.
Published reports on upfront from impromptu and power play using Impromptu web reports (IWR) and PowerPlay Enterprise Server (PPES).
Knowledge of ETL and OLAP tools. Responsible for development of various reports using Cognos Impromptu, Cognos Transformer, Cognos Power Play.
Expertise in migration of Impromptu catalogs and reports to ReportNet environment by using Cognos Migration Utility.
Expertise in deployment of Packages and Reports from Test to Development and Production Environment
Skills in database design and development using MS SQL Server, Oracle, and MS Access.
Created reports using SSRS, Report Builder. Created Stored Procedure to use in reports.
Expertise in Migration of SharePoint from one environment to another.
Extensively worked in interacting with Business Users to collect User Requirements.
Good understanding in Data Warehousing concepts and good understanding of Cognos Architecture/ Data Architecture.
Strong analytical problem-solving skills and deliverables right on time.
Works well with a team of professionals at various levels, & strong communication skills.
Experience leading a team of analytics professionals for providing data from different models
Understanding of the entire SDLC process and knowledge of Data governance techniques.
Involved with the team Migration of data to GCP.
Creating Reports & Dashboards in Power BI Using SQL Server.
Education
University of Detroit Mercy, Detroit, MI, USA 2004- 2005
MSCIS (Master of Science Computer Information Systems).
University of Faisalabad
M.Sc. (Hons)
Technical Skills:
BI Tools: Cognos 10.02/8.4/ 8.3/8.2/8.1 Framework manager, Report Builder, SSRS, Share Point 2013/2007, SQL Server Management Studio, PLSQL Developer. Tableau 9.3, Alteryx 22022.1.1, Dataiku and Power BI Desktop.
Databases: Oracle 11g,10g, 9i/8i, MS-Access, SQL Server-2000, Teradata database
Data Modeling: Oracle Designer 2000, Microsoft Visio, Cognos Models, Packages/Data Sets
Languages: SQL, Java, Visual Basic, HTML and DAX
O/S: Microsoft Windows 95/98/2000/XP, UNIX
Professional Experience:
Highmark Inc, Pittsburgh, PA March 2015 – July 2024
Senior Decision Support Analyst
Ad-Hoc Reports based on new requirements for pharmacy and medical data.
Created Packages using Metadata Models, Packages to the Cognos Connection.
Developed Alteryx Flows to provide specific data mart and to provide reports.
Scheduled report and use run jobs for number of reports to send on schedule.
Designed report models in Framework Manager to be Publish as Packages for clients reporting needs.
Working in Alteryx for different databases to develop reports or provide extract for reports.
Tableau Dashboard Creation and a few reports coming out of Tableau, Data analysis and Chats representation.
Most of work on Cognos Reports, SQL Navigator using Oracle
SQL report based on Tera Data SQL Assistant and Teradata Studio.
Create business intelligence, dashboards, visualizations using advanced Analytics reporting techniques.
Develop metadata for specific set of reports using data sets in Cognos
Created Reports and modules in Dataiku, previously flow to migration.
Developed the results based on Alteryx to create reports.
Create Dashboards and Interactive visual reports using Power BI.
Extracting the views from Data Warehouse to Power BI for report development.
Designed, developed and implemented Power Bi Business Intelligence Reports.
Created reports with drill down and drill through reports.
Creating Reports and dashboards using Slicer, bookmarks and buttons.
.
Environment: IBM Cognos 10.2.1(Framework Manager, Query Studio, Report Studio, Analysis Studio), PL/SQL, Teradata, Developer 8.04 for Oracle 11g, Windows XP-2007, Data Warehouse, Microsoft Office Professional Plus 2010, SQL Server Management Studio 2012, Microsoft Office SharePoint Designer 2013/ 2007, Microsoft SQL Server 2008/ 2012. Teradata SQL Assistant 14.10.0.07, Tableau 9.3, Dataiku, Alteryx, Power BI Desktop, Power BI Services
Professional Experience:
Cognizant Technology Solutions, Wilmington, DE Jan 2015 – Mar 2015
Senior Associates Projects
Developed new reports according to requirements.
Created enhancement in modeling using Framework Manager
Created Standardized and Complex reports in Report Studio.
Analysis of data in the short time period with full understanding.
Used TOAD for checking the data. Created SQL based Ad-hoc reports upon user’s request.
Managing offshore team for daily work and updating the status of project.
Helping Associates for developing reports, testing reports and pixel level formatting.
Getting the requirements from the client and sharing the knowledge with team.
Maintaining the existing report and developed new reports
Testing of all report’s functionality and pixel level formatting in all standardized templates.
.
Environment: IBM Cognos 10.2.1(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos BI 10.2.1, TOAD 12.1 8.for Oracle 11g, Data Warehouse, Microsoft Office Professional Plus 2010, Redmine.
Professional Experience:
UPMC (University of Pittsburgh Medical Center), Pittsburgh, PA Feb 2012 – Dec 2014
Software Engineer/Cognos Developer
Maintaining the existing report and developing new reports according to requirements.
Created Packages using Metadata Models, Packages to the Cognos Connection.
Created Metadata Model using Framework Manager for the ease of data manipulation.
Created Drill through Reports with more complexity.
Created Standardized and Complex reports in Report Studio.
Designed report models in Framework Manager to be Publish as Packages for clients reporting needs.
Analysis of data in the short time period with full understanding.
Used PL/SQL Developer for checking the data. Created SQL based Ad-hoc reports upon user’s request.
Created Complex security filters within Cognos Packages and reports using Cognos administration tools.
Reports testing in database, packages testing, and test the framework for the packages errors.
Highly proficient at creating prompt-based reports for ease of data navigation.
Used conditional formatting for exceptional data highlighting in report studio.
Created Reports in Report Builder using Microsoft SSRS.
Creating and Testing sites in SharePoint 2007 and 2013.
Migrating SharePoint to higher Version around 400 sites.
Assisting User for Technical and Analytical Support for SharePoint Users
Scheduling and subscription of reports in SSRS and deploying of reports in Dev and UET environment for Cognos.
Used Conditional formatting for exceptional data to highlight in report studio
.
Environment: IBM Cognos 10.1(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos BI 10.1 Powerplay and Transformer, PL/SQL Developer 8.04 for Oracle 11g, Windows XP-2007, Data Warehouse, Microsoft Office Professional Plus 2010, SQL Server Management Studio 2012, Report Builder 3.0, Microsoft Office SharePoint Designer 2013/ 2007, Microsoft SQL Server 2008/ 2012.
ABBOTT (Abbott Laboratories), Columbus OH Nov 2011 - Jan 2012
Sr. Cognos Consultant
Created the presentation of all reports during the project
Created Reports Specifications and check the reports which have been created both in Cognos and application.
Regression Testing of 21 reports in application and Cognos reports.
Created Standardized and Complex reports in Report Studio.
Creating prompt-based reports for ease of data navigation.
Implemented conditional formatting for exceptional data highlighting in report studio.
Designed report models in Framework Manager to be published as packages for Client’s reporting needs.
Used Cognos Connection for the organization, scheduling and distribution of reports.
Run reports in Cognos Connection for different user as a PDF and .xml format.
Created SQL Based Ad-hoc reports based on user’s request.
Analysis of data in the short time period with full understanding.
Used Toad Developer for checking the data.
Used Conditional formatting highlighting data and created multiple pages reports
Assisting other Cognos user’s developers for their reports and understanding of data in application.
Environment: IBM Cognos 8.4(Framework Manager, Query Studio, Report Studio, Analysis Studio), Toad for Oracle 10.2, Windows XP 2002, Data Warehouse, Microsoft Office 2007.
UPMC (University of Pittsburgh Medical Center), Pittsburgh, PA Apr 2011- Jul 2011
Sr. Cognos Consultant
Created Packages using Metadata Models, Published packages to the Cognos Connection.
Created Metadata Model using Framework Manager DMR for the ease of data manipulation.
Created Drill up and Drill down reports out of the package using the functionality of DMR.
Created Standardized and Complex reports in Report Studio.
Designed report models in Framework Manager to be published as packages for client’s reporting needs.
Analysis of data in the short time period with full understanding.
Analysis Studio for the retrieval of DMR data for reporting purposes.
Used PL/SQL Developer for checking the data.
Created SQL based Ad-hoc reports upon user’s request.
Created Complex security filters within Cognos packages and reports using Cognos administration tools.
Reports testing in database, packages testing, and test the framework for the packages errors.
Highly proficient with creating prompt-based reports for ease of data navigation.
Used conditional formatting for exceptional data highlighting in report studio
Assisting User for Technical and Analytical support. Used Cognos Connection for the organization, securitization, scheduling and distribution of reports.
Created and scheduled report execution with additional run options such as and output formats using Cognos Connection
Environment: IBM Cognos 8.4.27 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos BI 8.3 PowerPlay and Transformer, PL/SQL Developer 8.04 for Oracle 10.2g, Windows XP-2002, Data Warehouse, Microsoft office 2007
DHS State of Pennsylvania, Allegheny County, PA May 07 – Feb 09
Sr. Cognos Consultant
Created Metadata Models using Framework Manager. Published packages onto the Cognos Connection. Extensively worked on Framework Manager during the project by developing models of different applications.
Extensively working in installation, upgrading, configuration and performance tuning of Cognos software components and servers.
Created Users, Maintain user profile, working with scheduling of batch jobs during the project.
Run monthly Cycle reports and Mid months reports in Cognos Connection.
Deployed packages and reports from dev to test and UAT to Production for the need of the project requirements and end users ease
Created Metadata Models using Star Schema dealing with more then 260 tables.
Created IQDs from Framework Manager and used them to build cubes.
Experience with Cognos 8.4/8.3 BI PowerPlay and Transformer
Created different reports in Cognos by Developing OLAP Cubes in Cognos Transformer 8 and analyzed the data using Analysis Studio.
Creating prompt-based reports for ease of data navigation.
Implemented conditional formatting for exceptional data highlighting in report studio
Created SOCI Reports for Allegheny County utilizing drill through to access more detailed reports.
Created Standardized and Complex reports in Report Studio
Created and scheduled report execution with additional run options such as bursting and output formats using Cognos Connection.
Designed report models in Framework Manager to be published as packages for client’s reporting needs.
Created full three big Models, Using Framework Manager for different reports.
Used Cognos Connection for the organization, securitization, scheduling and distribution of reports.
Developed system and package wide templates, Master Detail Reports and Multi-Lingual reports using Report Studio.
Developed Ad-Hoc Reports in data warehouse 1 and Data warehouse 2.0
Run reports in Cognos connection for different user as a PDF and .xml format.
Performed most of the jobs at the same time as a Cognos administrator.
Created Complex security filters within Cognos packages and reports using Cognos administration tools.
Assisting User for Technical and Analytical support, also Created SQL based Ad-hoc reports
Environment: Cognos 8.4 /8.3 BI (Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos BI 8.3 PowerPlay and Transformer, Impromptu, ReportNet 1.1 MR, MS SQL Server 2000, TOAD 8.6 QUEST SOFTWARE for Oracle 10g, Windows XP-2000, Data Warehouse 2.0 Microsoft Visio, Microsoft Access, Microsoft Excel
Johnson & Johnson, Raynham, MA Oct 06 – Apr 07
Cognos Consultant
Analyze the request received from the user and prepare the specifications.
Met with user groups and other support teams to understand business requirements and develop model plans.
Assigned development priority based on business criticality.
Develop Cognos Impromptu, IWR, Catalogs
Developed Impromptu reports, Created HotFile (.ims) files per requests, also use Query Optimization.
Reports with sub reports, Created drill through reports, sub reports, list reports etc.
Created catalogs from multiple databases with the help of HotFile (.ims) files.
Created Impromptu Catalogs and used them for reporting purposes in Cognos Impromptu.
Published impromptu reports by using IWR
Migrated series 7 impromptu reports and catalog to ReportNet environment
Created reports utilizing filters, calculations, prompts and conditions.
Created List Reports, Sub Reports, Cross Tab and Drill through reports, Created Standard Templates.
Developed 35 different detail and summary reports using Impromptu
Developed Ad-Hoc Reports in data warehouse by SQL loader
Designed models by mapping business needs using PowerPlay Transformer and created multi dimensional cubes, cube groups and PowerPlay reports
Published PowerPlay cubes, PowerPlay reports, on the portal using Cognos PPES administration, PowerPlay Enterprise Server.
Migrated PowerPlay cubes to Cognos ReportNet, also Creating and Managing Jobs and Schedules
Run monthly Cycle reports and Mid months reports in Cognos Connection
Environnent: Cognos ReportNet 1.1, Cognos Connection, Report Studio Cognos Impromptu Series 7 Version 3, PowerPlay Transformer, PowerPlay, PPES (PowerPlay Enterprise Server), Access Manager, Upfront, Microsoft Access, Microsoft Excel, Oracle 10 g, TOAD 6 MS SQL Server 2000, Microsoft XP Professional., Microsoft Word
Contact this candidate