Description
Summary: * Around 12 years of in-depth and comprehensive experience in design, development, Testing, Security and Support for Data Warehousing, and Client/Server projects. * Worked on Cognos Upgrade from Cognos BI/Planning 8.4 BI to Cognos BI 10.2 and Cognos Planning 10.1.1 FP2 * Has good working knowledge on OLAP tools like Cognos 7.2 Upfront, Impromptu Web Reports (IWR), Cognos Power play Transformer and Business Objects * Did POC Cognos Installation In Linux Environment with Amazon Web Services Using EC2 Application * Has a Good Working Knowledge on Cognos 8.1/8.2/8.4/Congos 10.1.1/10.2/Cognos Analytics * Worked on Cognos BI10.2 to Cognos Analytics Upgrade * 3 Years of Experience in Informatica Power Center/IDQ * Install and Configure Cognos BI 10.2 and Cognos BI Analytics in Test/UAT/PROD Environments * Expertise in Cognos BI * Worked on Informatica Power Center Upgrade from 9.6 to Informatica10.0.0 * Knowledge on Informatica MDM 10.0 Installation in Windows * Experienced application developer in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center 9.5/9.6/10.0.0 * Setup and administer Informatica Power Center LDAP security in 9.5/9.6/10.0.0 * Expertise in Informatica tools such as Informatica (Power Center Repository Manager, WorkFlow Manager, Designer, Work Flow Monitor And Administration Console) * Worked on Cognos TM1 9.5 * Worked on Cognos TM19.5 to 10.1.1 Upgrade * Experience using ETL Tools Informatica Power Center, Informatica Power Mart, in data mart life cycle development, design, development and testing of ETL procedures using Informatica. * Project Setup, installation-configuration and implementation of Informatica 9.6/10.0.0 Suite Informatica Repository Manager, Power Center Designer, Workflow Manager, Workflow Monitor, Informatica IDQ B2b, VLTrader, VLproxy) NY and Department of Health & Social Services. Xerox Business Services LLC and/or its subsidiaries ("Xerox") provides this portal to support five statues Medical Assistance health care. Build the Environments and deploy the code from all the environments. We are supporting almost 99+ Environments. Responsibilities: Project Setup installation-configuration and implementation of Informatica 9.6 Suite Informatica Repository Manager Power Center Designer Workflow Manager Workflow Monitor Informatica IDQ 9.6 B2b VLTrader VLproxy) Experienced with Informatica administration on Unix and Linux platform * Informatica upgrade and performing end-to-end tasks * Handled repository backups, restoration, failover, * Created the Analyst Service, DataIntegrationService, ModelRepositroy * Installed and configured the following IDQ 9.6 components on Linux Servers * Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments. * Configured Master Node and Backup nodes under High Availability environment. * Creating Relational Connection in Informatica Workflow Manager level * Administration of Repository services and Integration services, Web services on Nodes with Grid concept. * Created various Informatica connections to connect to the sources and targets. * Creation and maintenance of Informatica users and privileges. * Created Native Groups, Native Users, roles, and privileges and assigned them to each user group. * Created Informatica Folders and assigning the permissions to the Folders. * Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments. * Handled outages when there is any maintenance in UNIX and DATA BASE. * Collaboratively worked with Application Support Team, Network, Database Teams, and UNIX teams. * Experience in DR planning and setup * Provide support to team in performance tuning, troubleshooting, best practices and standards * Informatica SCM (Folder Level migration/Object Level Migration) * Informatica object Migration using Repository Manager * Informatica Administration activity (by using Admin console) * Hotfix Implementation * Performance tuning of Informatica application * Code review of mappings of various application across plant Environment: AIX, Linux, Cognos10.1.1, CognosBI10.2.1, Oracle, Informatica9.6, InformaticaRepositoryManager, Informatica PowerCenterDesigner, Informaticaworkflowmanager, InformaticaworkflowMonitor, B2bDataTransformation, B2bDataExchange, WebServices, FrameworkManager, WebSphere Application Server. XEROX HEALTH CARE Cognos/Informatica Administrator June 2014 - August 2014 Description: roles and privileges and assigned them to each user group. * Created Informatica Folders and assigning the permissions to the Folders. * Migration of Informatica Mappings/Sessions/Workflows from Dev to Test and Test to Stage and Stage to Prod environments. * Handled outages when there is any maintenance in UNIX and DATA BASE. * Collaboratively worked with Application Support Team Network Database Teams and UNIX teams. Experience in DR planning and setup * Provide support to team in performance tuning troubleshooting best practices and standards and Department of Health & Social Services. Xerox Business Services LLC and/or its subsidiaries ("Xerox") provides this portal to support five statues Medical Assistance health care. Build the Environments and deploy the code from all the environments. We are supporting almost 99+ Environments. Responsibilities: Project Setup installation-configuration and implementation of cognos BI 10.1.1 and Informatica 9.6 Suite Cognos Go Mobile Cognos Go Office Cognos Insight Cube Designer Power play Transformer Framework Manager Metric Designer Planning Analyst and Contributor Administrator) * User Security implementation using Cognos Authentication Manager with Tivoli Directory Server * Metadata Modeling and publishing of packages using Framework Manager * Implement the Security levels in framework Manager Level. Data Source creation in Cognos Connection package migration across development and production environment * Scheduling Report Studio reports in cognos portal page * Application maintenance tasks like reconfiguring content store User ID creation and maintenance assigning privileges to objects