Data Warehouse Network Support
Resume:
SUMANTH
SAS Consultant
*******.**********@*****.***
PROFESSIONAL SUMMARY:
Over 8+years of experience in IT Industry including implementation of Informatica, SAS and Middleware products.
Strong experience in Installation, Administration, Configuration, Optimizing and maintenance of Informatica 10.1.1/10.4 applications.
Extensive experience in working with all aspects of design, analysis, evaluation and implementation of web based multi-tier applications
Experience in Informatica server maintenance activities apply hot fixes and validation.
Proficient in network support and Infrastructure changes for Informatica servers.
Expertise in Informatica change release deployments.
Involved on coordinate and work with infrastructure admin teams to resolve production issues.
Experience in SAS 9.4 Administration and underlying infrastructure support.
Expertise in SAS platform Administration with backups and disaster recovery, user support and documentation.
Ensures the overall health of the SAS platform.
Good Knowledge on in installation, configurations and troubleshooting of Oracle Fusion Middleware products like OAM 11g, OBIEE 11g, SOA 11g and Oracle WebCenter.
Having good exposure in Oracle9i/10g/11g.
Experience in Performance Tuning Analytics Dashboards / Reports and Data Warehouse database.
Hands on technical experience as an Informatica Administrator supporting application development, data warehouse and production systems.
Having good Knowledge on BIApps Financial Analytics & Procurement & Spend Analytics.
Having extensive working knowledge on oracle ApplicationsR2 (App, AR).
Knowledge on configuration tools like Ansible tower and source code repository like GitHub.
Monitoring application logs using Splunk 6.6.1
Administration experience on Pega 7.3.0 and Axway Secure File transfer 5.2.1
Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.
Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, DML, DDL etc.).
Having Good Knowledge in Creating transformations (Expression, Aggregator, Lookup, Router, Rank, Update Strategy, and Filter) and developing Mappings using Informatica.
Knowledge in designing Business Objects universes, complex BO reports full client and Web Intelligence Reports, Web Intelligence and Crystal Reports to develop and publish thin client reports.
Extensive Knowledge on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis
TECHNICAL SKILLS:
OLAP Tools : Oracle Business Intelligence Enterprise Edition 11.1.1.7.0(OBIEE),IBM Cognos 10.2.1, SAP BO, SSRS Reports 2008,Oracle BI Apps 7.9.6.4,SAS Analytics
ETL Tool : INFORMATICA 9.0/10.1.1, ODI 11g, SSIS 2008.
Data Modelling : ER Studio, Toad Data Modeller, ERWIN
Development Tools : TOAD, SQL Developer, Oracle SQL*Plus, SQL Server Management Studio, Visual Studio2008
Configuration tools : Ansible, Github
Monitoring tool : Splunk 6.6.1, Datadog
Ticketing tools : Service Now, Jira, Remedy, Scrum
Webservers : Web logic, Apache, Tomcat, EA Server
Programming/Scripting Languages: JavaScript, HTML, XML, Python, Bash, Shell,
Databases : Oracle 9i/10g/11g, SQL/PL SQL, T-SQL, MySQL, Oracle EBS, SQL Server
Operating Systems : Windows, Linux (Red Hat), UNIX
Virtualization tools : Virtual Box, VMWare, Citrix XenCenter
Repository management tools: Nexus, GitHub
Office Tools : Ms-Word, Ms-Power Point, Ms-Excel
ERPs : Siebel CRM, Oracle Primavera, Oracle APPS (AP, AR, GL& PO)
Networking : FTP, SSH, DNS, HTTP, HTTPS, TCP/IP, SFTP
Education Details:
Masters of Science in Software Engineering.
PROFESSIONAL EXPERIENCE:
Client: Ameren Corporation May 2019 – Till Date
Employer: Compunnel Inc
Informatica Administrator
Roles and Responsibilities:
Work in installation, configurations and Upgradations of SAS and Informatica applications.
Worked on SAS Enterprise Guide and management console administration.
Worked on user accounts and permissions on SAS management console.
Creating new libraries for connecting to databases like oracle, Teradata.
Worked on SAS suite of components like Visual Analytics, Enterprise guide and Campaign manager.
Worked on setting up Informatica PMPC installations and configurations for Informatica workflows monitoring.
Perform Informatica change release deployments.
Support on call attend production incidents related to Informatica environment.
Managing DAC scheduling jobs for Informatica workflows and also involved on DAC application build.
Creating Informatica data source connections and resolve Informatica user related issues.
Monitoring Informatica environment and setting up alerts for workflows using Informatica PMPC product.
Provide maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and/ or during other enterprise activities that impact SAS infrastructure.
Ensures the overall health of the SAS platform.
Perform new installation as necessary and SAS Visual analytics hub.
Manage the configuration support and maintenance of the SAS platform.
Managing SAS software suit like Campaign Manager and Visual Analytics we can provide visual and interactive reports that analyse data in reports interactively with simple clicks to drill down into those reports.
Performed various critical security patch installations on OBIEE, SOA Suit, Oracle Primavera and WebLogic environments.
Administration on Oracle WebLogic server console including WebLogic server state monitoring, application status and JDBC pool connection monitoring
Involved in configuring WebLogic server JVM heap settings, security parameters using WebLogic console server.
Involved on configuring monitoring setup of enterprise applications using Splunk and Dynatrace.
Worked with automation tools like Ansible Tower, Git hub, Nexus for automation restarts and patch installations to multiple WebLogic servers
Involved in installations and upgradations of Informatica 10.1 and migrations of workflows.
Building complete new environments for Oracle products like OBIEE, Oracle Primavera and Oracle Unifier applications in Linux and Windows servers.
Troubleshooting issues with Oracle Data integrator (ETL) and Primavera analytics/OBIEE 12C.
Root cause analysis for enterprise applications using application performance monitoring tools like Dynatrace.
Worked on upgradations of OBIEE 11g to 12C.
Worked on installations of Middleware products like IIS, Tomcat, JBoss and WebSphere application servers.
Supported Hyperion applications like Oracle Enterprise Performance Management System Workspace and Data relational management systems.
Responsible for the implementation and deployment of Oracle Access Management, Identity Management, and Directory Services.
Work extensively with Oracle Fusion Middleware 11g software. Tasks include, but not limited to: installation/configuration of Oracle Fusion Middleware, Oracle SOA Suite, Oracle Identity and Access Management (Oracle Identity Manager and Oracle Access Manager), OVD (Oracle Virtual Directory) and Repository Creation Utility.
Experience with Configuration Management automation tool Ansible and has worked on creating the Ansible playbooks for various day to day operational activities.
Automated provisioning Oracle Fusion components such as Weblogic, SOA suite and IAM components using Ansible tower component, wrote playbooks to invoke underlying scripts to copy the binaries, create domain templates.
Hands on experience in installing and administrating CI tools like Jenkins,Lara, GIT, Perforce and Nexus.
Environment: SAS 9.3/9.4, Informatica 11,Oracle DAC 11g, Web Logic 10.3.6/12.2.1.3.0, SOA 11g,Apache Tomcat 9.0.10,Oracle 12C, OBIEE 11.1.1.7.0/12.2.1.4, Splunk 6.6.1, Oracle Linux 6, Windows 2016, Linux Red Hat 7.
Client: Centers for Medicare & Medicaid Services (CMS) Oct 2015 – April 2019
Employer: Ventech Solutions, Urbandale, Iowa
Informatica Administrator
Ventech Solutions, a SEI CMMI Level 3 software company, is public sector focused system integration and consulting services firm headquartered in Columbus, Ohio.
Roles and Responsibilities:
Work in installation, configurations and upgradations of SAS.
Worked on SAS Administration activities like Server Maintenance, License renewal, Hotfix installation, Scheduling, User Management and Application troubleshooting.
Worked on setting up Informatica PMPC installations and configurations for Informatica workflows monitoring.
Managing DAC scheduling jobs for Informatica workflows and also involved on DAC application build
Support on call attend production incidents related to Informatica environment.
Worked on installations of Informatica PMPC monitoring server build.
Creating Informatica data source connections and resolve Informatica user related issues.
Monitoring Informatica environment and setting up alerts for workflows using Informatica PMPC product.
Supporting Informatica administrative day to day activities like server maintenance, user accounts, monitoring and scheduling informatica
Workflows.
Provide maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and/ or during other enterprise activities that impact SAS infrastructure.
Manage the configuration support and maintenance of the SAS Visual analytics platform.
Ensures the overall health of the SAS platform.
Administration on Oracle WebLogic server console including WebLogic server state monitoring, application status and JDBC pool connection monitoring
Involved in configuring WebLogic server JVM heap settings, security parameters using WebLogic console server.
Worked with automation tools like Ansible Tower, Git hub, Nexus for automation restarts and patch installations to multiple weblogic servers
Work in install, configure and manage WebLogic Server and Oracle Fusion Middleware products.
Configuration and management of Middleware products on UNIX and Linux environments.
Involved on configuring ETL workflows in Informatica and did installation of PowerCenter 9.6.1.
Worked with J2EE framework components including JDBC, JMS, and JNDI.
Coordinating with subordinates to discuss progress of work, resolve problems, and ensure that standards for quality and quantity of work are met.
Resolve install related issues with Oracle support via service request
Involved on working maintenance of Unix and Application servers(whenever required application servers shutdowns and startups)
Worked on automation of Business Intelligence reports deployments through SDA(Serena Deployment Automation).
Expertise on working Axway secure file transfer 5.2.1 managing file transfers and troubleshooting file tracking issues.
Experience on automation deployments of Code/Artifact’s to higher environments using Serena Deployment Automation 6.1.3
Involved on supporting issues using monitoring tools like Splunk 6.6.1 and monitoring logs.
Involved on setting up alerts using Oracle Enterprise Manager (OEM) and using OPNET JIDA arguments.
Knowledge on configuration tools like Ansible tower and source code repository like GitHub.
Worked on WLST and UNIX Shell Scripts for Pre validation and Post Validation of WebLogic servers after restart/maintenance of servers during maintenance weekends.
Dedicated my time for after hour shifts of operational issues in production.
Experienced in working with LDAP setup and SSO.
Environment: SAS, Informatica Power Centre 9.0/10.1.1/10.4, Informatica PMPC, OBIEE 11.1.1.7.0, SAS 9.3/9.4,Web Logic 10.3.6,OAM 11g, SOA 11g,, Oracle Web center 11g,OSB 11g, Splunk 6.6.1,Axway 5.2.1,Pega 7.3.0, EA Server 5.3/6.3,Solaris 10/11, Linux Red Hat 5/7.
Client: Molina HealthCare, Long beach, CA. Jul 2014 – Oct 2015
Employer: CSR Infotech, Franklin, TN.
Informatica Consultant
Molina Healthcare, a FORTUNE 500, multi-state health care organization, arranges for the delivery of health care services and offers health information management solutions to nearly five million individuals and families who receive their care through Medicaid, Medicare and other government-funded programs in fifteen states.
Roles and Responsibilities:
Involved in Admin related tasks like installations, migrations and up gradations of all components of SAS.
Managing SAS User accounts, roles, permissions, providing support and troubleshooting for user access and authorization issues.
Provide maintenance and support for SAS products during deployment, upgrade and any changes to SAS products and/ or during other enterprise activities that impact SAS infrastructure.
Support on call attend production incidents related to SAS environment.
Worked on installations of Informatica PMPC monitoring server build.
Creating Informatica data source connections and resolve Informatica user related issues.
Monitoring Informatica environment and setting up alerts for workflows using Informatica PMPC product.
Involved on configuring ETL workflows in Informatica and did installation of PowerCenter 9.6.1.
Manage the configuration support and maintenance of the SAS Visual analytics platform.
Ensures the overall health of the SAS platform.
Worked on installations and configurations of weblogic 12c in multiple environments
Proficiency in admin tasks like deployments from different environments (Dev to Prod) and taking backups of RPD and Webcatalog.
Installed and Configured Weblogic, OBIEE, DAC and Informatica on Unix/Windows Environment.
Supporting Informatica administrative day to day activities like server maintenance, user accounts, monitoring and scheduling informatica
Workflows.
Worked on Installations, configure, enable high availability, upgrade, backup and recovery, tuning, and disaster recovery of Oracle Web Center 11g.
Worked on configuring different repository and webcatalog configuration files.
Involved in configuring WebLogic server and security parameters using WebLogic console server.
Experience in giving access to different users like power users, admin users and creating groups.
Worked on applying OBIEE patches to support different Internet Explorer browser versions (IE 10, 11).
Proficiency in deployments of RPD and Catalog from different environments.
Involved on custom ETL migrations in Informatica, ETL objects (mappings, sessions, and workflows) from Dev to QA.
Involved on configuring Oracle BI config files in Linux environment.
Worked on troubleshooting managed servers in application servers of different environments.
Configured OBIEE 11g Clustering and Scale out BI Instances.
Configure the Scheduler to deliver the reports to the Business using Ibots.
Installed BI Apps 7.9.6.4 in windows environment including DAC 11g and Informatica installation
Based on user security matrix created different application roles.
Worked with Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
Generated OBIEE reports using OBIEE answers, dashboards, filters and Prompts.
Created guided navigation links to help files within the dashboards to help the end users.
Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
Experienced in working with LDAP setup and SSO
Environment: SAS, Informatica Power Centre 9.0/10.1, SAS 9.3,OBIEE 11.1.1.7.0, OAM 11g, SOA 11g, Oracle EBS, Oracle Web center 11g, Linux Red Hat 7,Windows, TOAD, WebLogic 10.3.6.
Client: Cisco Systems Inc., Bangaluru, India. Oct 2012 – Dec 2013
Employer: SRS Consulting, Hyderabad, India.
Sr. BI Apps-Consultant
Cisco Systems Inc. is the worldwide leader in networking that transforms how people connect, communicate and collaborate. Cisco Systems, Inc. is an American multinational corporation head quartered in San Jose, California, United States, that designs, manufactures, and sells networking equipment. The scope of this Project is to capture the Sales and Marketing processes of Call centre and data warehouse to maintain client’s history and current data. The reporting will be done by using OBIEE tool to do the sales Analysis.
Roles and Responsibilities:
Install, Configure, and maintain SAS software components and servers.
Involved in managing SAS applications and deployments.
Involved in Admin related tasks like installations, migrations and up gradations of all components of Informatica and BI apps.
Managing DAC scheduling jobs for Informatica workflows and also involved on DAC application build
Support on call attend production incidents related to Informatica environment.
Worked on installations of Informatica PMPC monitoring server build.
Creating Informatica data source connections and resolve Informatica user related issues.
Monitoring Informatica environment and setting up alerts for workflows using Informatica PMPC product.
Involved on configuring ETL workflows in Informatica and did installation of PowerCenter 9.6.1.
Worked on installations and configurations of weblogic 12c in multiple environments
Importing physical tables and columns in to physical layer and establishing relationship between them.
Customized the logical table source in the business model and mapping layer based on the business requirement.
Worked on Dimensional Hierarchies (Drill down& Drill up), Level Based & Share Measures and Time series functions based on Business Requirements.
Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting
Designed Schema/Diagrams using Fact, Dimensions, and Physical, Alias and Logical tables.
Created Drill down Hierarchies and implemented Business Logics for Facts.
Implemented Aggregate tables for better performance.
Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies using RPD Admin tool.
Developed report with filters, presentation variables, prompts, column selector, view selector, charts, narrative, gauge views, pivot table and other views.
Adding new additional data fields in existing reports and publishing reports in dashboards.
Analysed reporting requirements for dashboard reports and adhoc reports.
Developed Reports, Dashboards with different Analytics Views (Drill-Down / Dynamic Pivot Table Chart, View Selector).Reduced the number of reports using Column Selectors and View Selectors.
Unit testing the reports and testing navigation links in reports.
Involved in Admin related tasks like installations, migrations and up gradations of all components of OBIEE and weblogic 10.3.6
Proficiency in admin tasks like deployments from different environments (Dev to Prod).
Created and distributed ibots to subscribed users.
Involved in implementing OBIEE upgrade from 10g to (11g RPD& Catalog) and customizations in 11g.
Proficiency in in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems
Involvement with ETL (Extract-Transform-Load) development team to communicate the Specification for the required dimensional, aggregate and indexed data tables. Responsible for create the ETL for Data Extraction, Data Mapping and Data Conversion using informatica Power Centre 8.1.
Involved in developing the incremental ETL process i.e. Mappings and Mapplets using various Transformations and Workflows with Sessions/Tasks.
Environment: SAS,OBIEE 11.1.1.5(Repository RPD 11.1.1.5), Oracle 10g/11g,, Oracle EBS, Informatica Power Centre 8.6/9.6, Oracle BI Publisher, Windows Server 2007, PL/SQL Developer, EXCEL, TOAD, weblogic 10.3.6.
Igrid Technology Solutions Pvt.Ltd. Oct 2009 – Sep 2012
OBIEE-Consultant
PepsiCo is a world leader in convenient snacks, foods and beverages. The Business Intelligence application was intended to develop a data warehouse and a reporting system, which effectively reports customer behaviour for marketing campaigns, analyse sales from the website, it also monitors and reports order management issues at the sales call centre and customer service. This improves decision making for financial, marketing management, customer service teams. The dashboards are developed using Siebel Analytics as BI tool.
Roles and Responsibilities:
Understanding the requirements of the client, business scenario(s) and the application and prepare the design documents.
Designing the logics to be implemented at the RPD level.
Using OBIEE Administration tool to develop and enhance Meta data to build Business Model and established relationships.
Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.
Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
Extensively used variables (repository and presentation) in the process of making the reports
Implementation data and Object level security.
Generated OBIEE reports using OBIEE answers, dashboards, filters and Prompts.
Created guided navigation links to help files within the dashboards to help the end users.
Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
Configure the Scheduler to deliver the reports to the Business using Ibots.
Creating the Dashboard and Page level prompts.
Displayed BI Publisher reports in BI Answers.
Enhanced existing Business Models & created customized Dashboards.
Fine-tuned the long running reports by re-organizing the data, re-building of indexes
Build Informatica SDE mapping using JDE Enterprise One as a source and build SIL mappings to load data from staging table to target table.
Involved on weblogic configurations and performance tunning of JDBC.
Environment: OBIEE 10.1.3.4, Oracle 10g, Windows 2003, Informatica Power Centre 8.6, SQL Query Analyser, BI publisher,TOAD, weblogic 10.3.6.
Contact this candidate