Data Information
Resume:
Kotya Dheeravath
************@*****.***
IBM INFOSPHERE INFRASTRUCTURE ADMINISTRATOR/LEAD
PROFESSIONAL SUMMARY
Over Eleven (11+) years of Total IT Experience in installation, configuration, administration, deployment, testing, production support, licensing, product enhancement, patching and product support of Business Systems and Applications of Data Warehousing, Data Profiling, Quality and Data Governance teams.
Extensive experience in Energy and Electric Utilities, Investment management, Healthcare, Manufacturing, Financial & Insurance, Retail (Oil & Gas) business domains under all the phases of SDLC.
Over Eight (8+) years of administration experience in DataStage, QualityStage, Information Analyzer, Metadata Workbench, Business Glossary, FastTrack and Information Governance Catalog (IGC) products in IBM InfoSphere Information Server [IIS]/ InfoSphere Foundation Tools [IFT] 8.0/8.1/8.5/8.7/9.1/11.3 Suites and WebSphere Application Server [WAS] 6.0.2.11/6.0.2.27 Base/7.0.0.11/8.0/8.5 Network Deployment Versions.
Over Eight (8+) Years of Experience in administration & support of Business Metadata, Technical Metadata, Project Metadata and Operational Metadata using products of IFT 8.x, 9.x and 11.x suites.
Worked collaboratively with the center of excellence in driving data integration specific solutions and support in doing beta testing of data integration product releases, tool evaluation of different vendors, proof of concept of making data integration products work with other IBM Information Server Platform.
Worked with Project Manager (PM) for specific matters of scope, tasks, and resources prior to setup of technical infrastructure regions using IBM InfoSphere Information Server suite.
Participated in and coordinated the efforts on the technical architecture (infrastructure) design with consideration of capacity, performance, and high availability for the system upgrade and re-platform. Create and update technical design specifications.
Participated in the installation and configuration of the system components, developing/updating scripts, deploying custom code on the new platform, and building the technical environments for the SDLC phases, including Development, Testing, Staging, and Production technical environments.
Managed infrastructure, health check, and performance engagements with clients. Activities include project scoping, developing project plans, resource staffing, activity tracking, stakeholder communications, cost management, issue resolution and project closure.
Worked with cross functional teams to resolve technical issues on networking, databases, and virtual servers in Infrastructure services group.
Conduct architecture infrastructure assessments for servers of data warehousing, data quality and governance projects, addressing the solution requirements from a scalability, flexibility, connectivity, batch performance, real time connectivity, reusability etc.
Worked with IBM Professional Services performing builds with pre-install, install and post-install and configuration tasks for Non-production environments.
Created an escalation process to address product bugs proactively and acted as the focal point for resolution resulting in enhanced system stability with latest version upgrades and patching and higher customer satisfaction.
Used Software Product Compatibility Reports (SPCR) tool to locate and find complete lists of supported operating systems, system requirements, prerequisites, and optional supported software for all versions of InfoSphere Information Server suite.
Adminsitration of IBM IIS suite to support IBM and non-IBM data sources and targets, business intelligence (BI) tools, data warehouse tools, and a comprehensive set of integration products to discover, understand, design, monitor and govern trusted information across the enterprise.
Analyzed and resolved IIS and/or WAS errors and report problems from all environments (i.e., development, test, quality assurance, training, production, Disaster Recovery etc.), and coordinated fixes with software vendors and customers.
Knowledge Transfer [KT] to offshore administration team, handed over tasks and prepared KPIs, Metrics and Root Cause Analysis (RCA) of Issues.
Worked with application development team for resolution of the issues during Unit, Integration, Functional and Regression testing of ETL jobs and data loads.
Excellent knowledge of various operational data sources and data targets like Teradata V2R5/R6, Oracle 11g/10g/9i/8i, DB2 10.x/9.x/7.x, SQL Server, Informix, Sybase etc and their connectivity from DataStage.
Used IBM Education Assistant to gain updated knowledge of Information Management products and use them more effectively to meet business requirements.
Worked as a Subject Matter Expert [SME] for administration & support of IIS suite.
A team member and leader with excellent analytical, verbal and communication skills.
Documented Architecture, Roadmap, Installation, Configuration, Administration, Upgradation, Migration, Operational Tasks, Health Check Reports, Data Quality, Governance, Lineage reports and resolution of PMR issues on Production Server outages and Job Failures using IIS 8.x, 9.x and 11.x suites maintenance.
EDUCATION
Bachelor of Technology in Electronics & Communication Engineering.
TECHNICAL SKILLS
Data Warehousing, Quality & Governance
InfoSphere Information Server 8.5/8.7/9.1/11.3 [Server & Enterprise Editions], [DataStage & QualityStage], InfoSphere Foundation Tools 8.5.0.2/8.7/9.1/11.3 [Information Analyzer, Metadata Workbench, Business Glossary & FastTrack], Information Governance Catalog 11.3
Databases
Teradata V2R5/R6, Oracle 11g/10g/9i/8i, DB2 10.x/9.x/7.x, SQL Server 2005/2000
Programming
C, Java, J2EE, Perl, SQL, PL/SQL, Shell Scripting, XML, Web Services, WebSphere Application Server 7.0/8.0/8.5
Operating system
Unix [HP-UX, Sun Solaris, AIX], Linux [RHEL & SUSE], Windows NT/XP/2000/2003 server
Scheduling
Control-M, Autosys, Crontab Utility
Connectivity
Citrix, Putty, Cygwin X, Xming
CLIENT: SOUTHERN CALIFORNIA EDISON, CA OCT 2015 – TILL DATE
INFORMATION MANAGEMENT & ANALYTICS (IMA)
Edison International, through our subsidiaries, generates and distributes electric power, and invests in
energy services and technologies, including renewable energy. IMA platform is designed for managing
business metadata, technical metadata, project metadata and operational metadata from metadata repository
database using IIS suite products to support analysis and reporting functionalities. Metadata repository is
shared among all the tools of IIS suite and is hosted on the top of WebSphere Application Server.
Responsibilities:
Installed, Configured and Administered server tiers (Repository database tier, services and engine tiers) for Data Warehousing and Governance tools of InfoSphere Information Server 9.1 and 11.3 suites in Dev, Test and Prod regions.
Involved in security roles at suite, product and project levels via InfoSphere Web Console.
Coordinated with Customer and IBM technical Support for Problem Management Requests.
Installation and Coordinate with DEV application teams to setup metadata tools for data profiling, data quality monitoring, data quality remediation, data governance via business metadata.
Completed Source System Profiling and Analysis using IA tool.
Responsible for and ensuring optimal execution of all Data Management related applications and toolsets.
Modify existing Information Server installation to authenticate from custom user registry to LDAP Active Directory for both engine & domain layers.
Experience in working with Resolve IT web-based application tool for ticketing, issue tracking and change control for patch installations and experience working with Versioning systems for managing code base.
Involved in migration of ETL projects, jobs and other assets of DataStage and QualityStage from earlier versions to 11.3 version.
Used DataStage engine to achieve high performance through partition parallelism
Involved in configuration of DataStage configuration file, environment variables, data source connections, execution and monitoring of DataStage jobs and engine workload management
Import and export DataStage jobs and other engine objects
Configured DataStage engine runtime process and environment
Performed the complete Health Check of IIS 9.1 and 11.3 suites using ISALite tool after the migration is completed.
Used Information Analyzer [IA] in Data quality assessment, Data integration and migration and External data source verification projects.
Used Information Analyzer [IA] to run and schedule InfoSphere Information Analyzer jobs outside of console client.
Setup shell scripts to monitor the state of the services of InfoSphere suite product and alerts for any issues.
Used Information Analyzer [IA] to manage reference tables, tables and generate reports that are generated during analysis.
Used Metadata Workbench to Explore and understand information assets in the repository database, analyze dependencies and relationships of key InfoSphere suites assets and BI reports and manage metadata to obtain in-depth analysis reports.
Created business lineage, data lineage and impact analysis reports in Metadata Workbench.
Used Business Glossary to build a vocabulary system between business metadata and technical metadata.
Used FastTrack to automate creation of ETL DataStage jobs, to leverage published profiling results from Information Analyzer and to create and link Business Glossary terms and their relationships.
Worked on Metadata Integration using IA, MWB, BG and FT tools of InfoSphere suite.
Used IGC (Information Governance Catalog) to enable users to create, manage, and share an enterprise vocabulary and classification system in a central catalog.
Used IGC to understand the business meaning of their assets and provides search, browse, and query capabilities along with reports to examine data flow between assets.
Performed Route Cause Analysis and prepared metrics for all trouble shooting issues.
Resolved Bottlenecks in configuration & development of Data Quality and Governance Tools.
Participated in the development of an Enterprise approach to system specification, engineering, operational, administrative, capacity management, maintenance and support services for the information technology infrastructure utilizing IBM InfoSphere product.
Environment: IBM InfoSphere Information Server/Foundation Tools 9.1.2/11.3.0.1 Suite [DataStage, QualityStage, Information Analyzer, Metadata Workbench, Business Glossary and FastTrack], Information Governance Catalog (IGC) 11.3, Oracle 11g, DB2 10.1/10.5 ESE, SQL Server 2005, WAS 8.0/8.5 Network Deployment, Shell Scripts, SOA, Web Services, Windows 7, AIX 7.1 and RHEL 6.5
CLIENT: VANGUARD GROUP, PA OCT 2013 – SEP 2015
INFORMATION MANAGEMENT SOFTWARE GROUP [IMSG]
The Vanguard Group is one of the world's largest investment management companies that offers mutual funds, exchange-traded funds (ETFs), brokerage services, variable and fixed annuities, educational account services, financial planning, asset management, and trust services. Data Integration, Quality, Governance and MDM projects were implemented for management of data assets for data marts from different data sources and for creation of golden record from different source systems.
Responsibilities:
Platform setup and Maintenance (Access, Capacity, Administration & Performance Monitoring) of Unix and Linux servers prior to builds of InfoSphere Information Server 8.7 and 9.1 suites using multi-tier topology.
Installed, configured and customized the behavior of the out of box capabilities of IBM InfoSphere Information Server software.
Installed IIS client tier components on each user Desktop PCs to utilize thick clients and web-based applications.
Coordinated, Planed and installed software & hardware upgrades as needed to support currency of IBM InoSphere products while mentoring others.
Responsible for monitoring the InfoSphere environment (and related software) for hardware, software, memory, storage, user, and performance metrics that are critical to normal production operations and make sure the system continues to function in a consistent and expected manner.
Version control (Subversion source repository, including branching, merging, promoting, access security for multiple projects and integration with DevOps tools)
Coordinated/Planned Execution activities related to platform maintenance, Disaster Recovery and Software release management
L3+ escalation for platform issue resolution, troubleshooting and root cause analysis.
Configured, managed, and monitored DataStage Engine
DataStage project configuration, Engine’s development and runtime environments, and Engine’s data source connectivity
Run and monitor DataStage jobs through the command line and GUI and usage of Engine utilities.
Performed Column Analysis in console for ProfileStage before design of jobs by application development teams.
Completed Source System Profiling and Analysis using Information Analyzer
Generated approximately 80 configurable reports for the visualization of analysis/trends/metrics to assist uncovering data quality concerns and help understand results quickly and efficiently.
Used Information Analyzer for Data quality assessment functions include column, primary key, foreign key, cross-domain and baseline analysis.
Used IA for analyzing profiling results and reports.
Strong analytical and problem-solving skills, the ability to visualize complex data relationships and to understand the relationship to business processes and systems where data is managed.
Worked with data stewards and systems analysts to profile data and develop data quality definitions, thresholds and certification procedures.
Worked with Data Quality Analyst and System Analyst to ensure that DQ definitions are included in enterprise DQ rule repository.
Worked in conjunction with data analysts and data stewards to capture, assesses, analyze, and remediate data quality issues.
Used Information Analyzer [ProfileStage] and QualityStage for Data profiling and Quality.
Imported the contents of DataStage and FastTrack into Business Glossary. Created data lineage and impact analysis reports in Metadata Workbench.
Used IBM Business Glossary [MetaStage] to organize metadata into categories, terms and objects.
Used FastTrack to accelerate design time to create source-to-target mappings and to automatically generate jobs.
Migrated all projects and jobs into IIS 9.1 suite and documented the steps.
24x7 data warehousing and governance support and resolution of errors related to all InfoSphere suite products.
Environment: IBM InfoSphere Information Server/Foundation Tools 8.7/9.1 Suite [DataStage, QualityStage, Information Analyzer, Metadata Workbench, Business Glossary & FastTrack], DB2 9.7/10.1 ESE, WAS 7.0.0.17ND, SOA, Windows 7, Unix [Sun Solaris 10, AIX 6.3], Linux [RHEL AP 5] & Windows 2008 Server R2
CLIENT: EMBLEMHEALTH, NY AUG 2012 – SEP 2013
HEALTHCARE INFORMATION TECHNOLOGY & SYSTEMS (HITS)
EmblemHealth offers a range of commercial and government-sponsored health plans for large groups, small
groups, individuals and families, with an extensive network of doctors and hospitals throughout the tristate
area with dental, vision and telehealth options. HITS is an enterprise data management platform with various
systems and applications and set of organizational capabilities to facilitate efficient and consistent
management of critical master and reference data across a variety of IBM and non-IBM data sources to
discover, understand, design, monitor, govern and manage trusted information across the enterprise.
Responsibilities:
Installed, Configured and Administered IBM IS 8.1 and 8.5 suites.
Identified application software, hardware and/or database incidents and problems and communicated to clients in a timely basis.
Took corrective actions to ensure application software incidents and problems are addressed timely within SLA.
Platform change administration (node upgrades, patch update)
Platform support scripts (Maintenance, schedule, NDM etc)
Experience supporting developers, performing releases and tracking changes.
Able to provide documentation of environment, operational procedures and configuration. Transitioned roles and documentation to support staff.
Maintained infratsurcture details such as User Population, Server Components, Data Sources / Data Volume, Client Machine Requirements, Server Components for DEV, QA and PROD regions.
Used SPCR tool links to find the minimum product levels (software versions and any maintenance levels) that must be installed before opening a problem report (PMR) with IBM InfoSphere Information Server Technical Support.
Used eCare to manage and get answers against questions regarding access, registration, software download, media access, reporting functionality or navigation of contents of knowledge center of IBM InfoSphere Information Server suite.
Managed Users, Groups, active sessions, logs, schedules and licenses for DataStage, QualityStage and other products of IIS suite.
Involved in migration of DataStage and QualityStage projects and jobs from 8.1 to 8.5 version.
Used Information Analyzer [ProfileStage] and QualityStage for Data profiling and Quality.
Configured and administered Information Analyzer (IA) to understand data by completing data quality assessments, data quality monitoring, and flexible data rule design and analysis.
Enabled operational metadata at project and job levels. Managed operational metadata from job runs.
Ran automated services and created data lineage and impact analysis reports in Metada Workbench.
Used Business Glossary to build a vocabulary system between business metadata and technical metadata.
Used FastTrack to automate creation of ETL DataStage jobs, to leverage published profiling results from Information Analyzer and to create and link Business Glossary terms and their relationships.
Documented steps for Upgradation, Configuration, Administration, Development and Production Support of IIS suite tools.
Used Autosys to schedule jobs and e-mailed the status of ETL jobs to operations team daily.
Support and maintain applications utilizing required tools and technologies of IBM IIS suite. Provide support for applications, including involvement with the SupportCenter, NOC, Infrastructure teams, and vendors as appropriate. Provide off-hours support (24 x 7) as required.
Environment: IBM InfoSphere Information Server 8.1.0.2 & 8.5.0.2 Suites [IS Manager & Metadata Server, DataStage], InfoSphere Foundation Tools 8.1.2.5 & 8.5.0.2 Suites [Information Analyzer, Metadata Workbench, Business Glossary, FastTrack], Oracle 10g/9i, SQL Server 2000/2005, WAS 6.0.2.27Base/7.0.0.11ND/7.0.0.5 ND, Shell Scripts, Windows XP, UNIX (HP-UX 11i & AIX 6.1) and Red Hat Linux 4.9
CLIENT: VALSPAR CORPORATION, MN MAR 2011 – JULY 2012
GLOBAL INFORMATION SERVICES DIVISION
Valsar is a global leader in the manufacture, development, distribution, and sale of paints, coatings and
related products to professional, industrial, commercial, and retail customers. Data Cleansing, Data
Conversion and Data Transformation projects have been implemented to provide an integrated
end-to-end solution for cleansing, transforming, delivering and managing data.
Responsibilities:
Involved in analysis based on requirements and developed Cluster & Grid Architecture for data integration.
Selected Installation Topology with layers for the products of Information Server.
Upgraded and configured all the tools from IIS Information Server 8.1 base version to Fix Pack 1->Fix Pack 1a->Fix Pack 2 and then to 8.5 on different tiers.
Installed, Configured and Administered DB2 Metadata Repository Database and WebSphere Application Server components for IIS suites.
Prepared disk, file and network resources. Modified kernel parameters and user limits.
Installed, Configured and Administered IBM IS 8.1 suite.
Worked with IBM to troubleshoot data integration suite issues. Resolved incompatible JRE errors during installation.
Added, deleted and moved projects and jobs. Purged job log files and traced server activity.
Issued DataStage engine commands from Administrator. Started and stopped DataStage engine and managed logs.
Managed DataStage services like DSRPC, Telnet and Engine Resource Services.
Configured NLS for WebSphere DataStage and QualityStage in dsenv file.
Migrated DataStage and QualityStage jobs from earlier versions (7.5.2) to DataStage 8.1 and 8.5 versions.
Created design documents and proto type jobs based on the business requirements and high level design (HLD).
Used Lookup, Join, Funnel, Merge, Lookup, Transformer etc processing stages to design server, parallel and sequence jobs.
Worked on setting up users for IIS suite and suite components for different products.
Used IIS Web Console for administration areas: security, licensing, logging, and scheduling.
Created different type of reports like Administrative reports, IA Column Analysis reports, Metadata reports and Fast Track Mapping specification reports from IIS console.
Used Control-M to schedule jobs and e-mailed the status of jobs to operations team daily.
Worked on Oracle 10gR2 and DataStage Server performance tuning approaches.
Worked on performance tuning of ETL jobs via SQL queries, data connections, configuration files, job parameters and environment variables.
Assisted Data quality specialists use Information Analyzer (IA) scan samples and full volumes of data to determine their quality and structure ranging from individual fields to high-level data entities.
Resolved the issues during creation of data quality rules to assess and monitor heterogeneous data sources for trends, patterns, and exception conditions.
Used Control-M to schedule jobs and e-mailed the status of jobs to operations team daily.
Provided production support and resolved tickets in IBM ESR tool.
Performed Knowledge Transfer [KT] to team members and lead the whole project in all the phases.
Environment: InfoSphere Information Server V8.1.0.2/8.5.0.2 Suite [DataStage, QualityStage, Information Services Director, IS Manager & Metadata Server], InfoSphere Foundation Tools 8.1.2.5/8.5.0.2 [Information Analyzer, Metadata Workbench, Business Glossary & FastTrack], Oracle 11g, SQL Server 2005, WAS 6.0.2.27/7.0.0.11, Shell Scripts, Windows XP, IBM AIX 6.1, HP-UX 11i and Red Hat Linux Advanced Platform 5.2
CLIENT: SECURIAN FINANCIAL GROUP, MN JUN 2009 – FEB 2011
ENTERPRISE DATA & ANALYTICS GROUP [EDAG]
Finance Solutions & Investment Management Division of EDAG group contains an enterprise data
warehouse for retirement segment to keep track of retirement investment and income products and
services to the public, private, and not-for-profit organizations and for asset management segment to
provide a broad array of investment management and advisory services, mutual funds, and other
structured products.
Responsibilities:
Involved in requirements gathering and source data analysis and identified business rules for data migration and for developing data warehouse.
Installed, Configured and administered all the client and server components of DataStage, MetaStage and Parallel Extender.
Configured server daemon environment and accessed remote files via NFS.
Started and stopped DataStage engine and managed logs.
Set environment variables, kernel parameters and C++ compilers.
Configured ODBC connections, maximum no. of processes per node and paging space.
Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
Responsible for building and loading dimension tables and fact tables for the target warehouse system.
Used DataStage Designer/Manager/Director to design and run jobs to implement the Import and Export Interfaces.
Extensively used DataStage Designer components to design various Server and Parallel jobs in accordance with business specs.
Extensively worked on processing stages like Transformer, Hash file, Join, Funnel, Lookup, Switch, Merge, Pivot, Change Apply, Change Capture, Remove duplicates etc.
Used Partition methods and collecting methods to implement parallel processing.
Implemented Slowly Changing Dimensions [SCDs] of types 1, 2 and 3 using Server jobs and Parallel jobs.
Developed parallel jobs and server jobs to load business or transactional data into fact tables.
Used shared containers to re-use stages and links in server jobs and parallel jobs.
Imported table definitions from ODBC/Plug-in table definitions available.
Used Partition methods and collecting methods for implementing parallel processing.
Monitored the performance of Parallel jobs by turning on various environment variables.
Used Job Control routines and Transform functions in the process of designing the job.
Developed jobs in Parallel Extender using different stages like Transformer, aggregator, lookup, source dataset, external filter, row generator, and column generator.
Validated and debugged the developed jobs.
Worked with Platform and DBA folks on the sequence of steps during code migration between operational environments.
Worked on administration and deployment of ETL jobs using DataStage, analysis and data rules using Information Analyzer and cleansing tasks using QualityStage.
Configured DataStage, QualityStage, Information Analyzer, FastTrack, Metadata Workbench & Business Glossary products post-install in each region.
Environment: InfoSphere Information Server V8.1.0.1 Suite [Information Analyzer, IS Manager, Metadata Workbench, Business Glossary, FastTrack, Information Services Director & Metadata Server], Oracle 10gR4, DB2 9.5, SQL Server 2005, WAS 6.0.2.27, Java, J2EE, SQL, PL/SQL, Shell Scripts, Windows XP, Unix [Sun Solaris 10 & AIX 6.1] and Red Hat Linux Advanced Server 4.8
CLIENT: SHELL OIL, TX JAN 07 – MAY 09
CUSTOMIZED MAINTENANCE MANAGEMENT SYSTEM [CMMS]
CMMS application is used by users of gasoline and convenience stores and supports 3 different areas like Maintenance, Purchasing and Inventory. Data has been pulled from oracle and SQL server data sources of different enterprise applications and loaded into target data warehouse for analysis and reporting.
Responsibilities:
Understand EAI Interface design documents.
Create EAI system analysis document.
Create Inbound and outbound EAI process context diagrams.
Create SRS (Software Requirement Specification) document for the EAI ITSRs and sustain.
Create detailed design document for the EAI interface.
Develop and configure the EAI interface and partner set up.
Unit and system testing of the EAI interfaces.
End to end testing with users and trading partners for the EAI interfaces. Deployment support for production and post-go live support for the EAI interface.
Environment: Sun Sprac server, Sun Solaris, UNIX, MS DOS, Windows-XP, Java, PL/SQL, Shell scripting, SeeBeyond SRE 5.0.5, ICAN 5.0.5, JCAPS 5.1.3, Oracle
Contact this candidate