| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLESummary: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, DataMarts 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 task 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 EnvironmentSkills 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.Strong analytical problem-solving skill and deliver the deliverable right on time.Works well with a team of professionals at various levels, & strong communication skills.Understanding of the entire SDLC process and knowledge.EducationUniversity of Detroit Mercy, Detroit, MI, USA 2004- 2005MSCIS (Master of Science Computer Information Systems).University of FaisalabadM.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.1Databases: Oracle 11g,10g, 9i/8i, MS-Access, SQL Server-2000, Teradata database, Dataiku, Alteryx and Power BIData Modeling: Oracle Designer 2000, Microsoft VisioLanguages: SQL, Java, Visual Basic and HTML.O/S: Microsoft Windows 95/98/2000/XP, UNIXProfessional Experience:Highmark Inc, Pittsburgh, PA March 2015 NowSenior Decision Support AnalystAd-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 OracleSQL report based on Tera Data SQL Assistant and Teradata Studio.Develop metadata for specific set of reports using data sets in CognosCreated Reports and modules in Dataiku, previously flow to migration.Developed the results based on Alteryx to create reports.Used Power BI to use data for reporting purposes..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 BIProfessional Experience:Cognizant Technology Solutions, Wilmington, DE Jan 2015 Mar 2015Senior Associates ProjectsDeveloped new reports according to requirements.Created enhancement in modeling using Framework ManagerCreated 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 users 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 reportsTesting of all reports 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 2014Software Engineer/Cognos DeveloperMaintaining 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 users 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 UsersScheduling 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 2012Sr. Cognos ConsultantCreated the presentation of all reports during the projectCreated 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 Clients 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 users 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 reportsAssisting other Cognos users 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 2011Sr. Cognos ConsultantCreated 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 clients 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 users 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 studioAssisting 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 ConnectionEnvironment: 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 2007DHS State of Pennsylvania, Allegheny County, PA May 07 Feb 09Sr. Cognos ConsultantCreated 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 easeCreated 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 TransformerCreated 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 studioCreated SOCI Reports for Allegheny County utilizing drill through to access more detailed reports.Created Standardized and Complex reports in Report StudioCreated 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 clients 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.0Run 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 reportsEnvironment: 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 ExcelJohnson & Johnson, Raynham, MA Oct 06 Apr 07Cognos ConsultantAnalyze 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, CatalogsDeveloped 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 IWRMigrated series 7 impromptu reports and catalog to ReportNet environmentCreated 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 ImpromptuDeveloped Ad-Hoc Reports in data warehouse by SQL loaderDesigned models by mapping business needs using PowerPlay Transformer and created multi dimensional cubes, cube groups and PowerPlay reportsPublished 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 SchedulesRun monthly Cycle reports and Mid months reports in Cognos ConnectionEnvironnent: 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 |
