Data Information

Location:

North Wales, PA, 19454

Posted:

October 25, 2017

Resume:

SR INFOSPHERE DEVELOPER

Nine (*+) years of Total IT Experience in requirements gathering, design, development, deployment, testing and production support of Business Application Systems of Data Warehousing & Data Governance teams.

Extensive experience in Finance & Banking, Health Care, Manufacturing, Retail and Hospitals domains under all the phases of SDLC.

9 Years of IT experience in Architecture, Development, enhancement, maintenance, Production support, Data profiling, Data Quality, Data Lineage, Data Governance, Master Data Management and Reporting including Business requirement, system requirement gathering.

Extensively used IBM InfoSphere MDM suite (Physical MDM/Advanced Edition) to achieve greater agility by creating a single, authoritative view of business-critical data and create quality data about customers, products, suppliers and more to drive better customer experiences, make smarter decisions, optimize critical business processes, and ensure regulatory compliance

Five (5+) years of experience in Architecture, Roadmap, Development, Deployment & Support of IBM Master Data Management [MDM] Server 8.0/8.5/9.0/10/11/11.5 (Advanced Editions), Service-Oriented Architecture [SOA] and IBM WebSphere Application Server [WAS] 6.1.0.17 ND/7.0.0.5/7.0.0.17/8.0/8.5 ND versions.

Five (5+) years of Architecture, Planning, Development, Production Support, Lead and Management experience of IBM [Ascential] DataStage 6.x/7.x/8.x/9.x on Windows/Unix/Linux Platforms with Enterprise Edition [EE] & Server Edition [SE], Multidimensional Modeling [MDM], Operation Data Store, Enterprise Data Warehouse, MOLAP, ROLAP, Control-M and Autosys.

Four (4+) years of experience in Development, Production Support, Lead and Management of Metadata Management using Information Analyzer, Metadata Workbench, Business Glossary & FastTrack of IBM InfoSphere Information Server [IIS] 8.1, 8.5, 8.7, 9.1 & 11.5 Suites.

Used IBM MDM BAUI (Business Administration) user interface to implement Rules services, Metadata services, Code Tables and Error Messages services, Security services and System services.

Used IBM MDM DSUI (Data Stewardship) user interface to manage Party Records, Suspect Processing, Hierarchy and Grouping management functionalities.

Experience in leading and defining architecture and technology components for MDM implementations

Provided the design approach and parameters for systems in the MDM eco-system – search, data quality tool, portal, workflow, etc.

Partnered closely with the business and application teams to implement and measure effectiveness of MDM, Data Governance and Data Quality processes across multiple technical systems using domain data.

Drive the initiation, planning, requirements, design, test, and post-production phases of the solution development life cycle

Expertise in Data modeling using Star Schema, Snowflake Schema and 3NF for Data warehousing / OLTP systems

Strong expertise in Oracle SQL Loader, IBM Data Studio for DB2, Export/Import, Data Pump and Teradata loading tools Fast Export, Multiload, TPump, TPT, VIEWPOINT, TBAR, Performance tuning

Strong expertise in design and implementation of extraction and transformation (ETL) process using IBM DataStage

Lead projects from initialization phase from capturing business requirements to final phases of testing and production deployment

Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL. Experienced in End user training, documentation, and Audit record maintenance and application/product demos

Ability to quickly adapt to changing priorities, requests, and environments.

Dedicated to maintain high quality standards.

Active team player and self starter with immense ability to grasp and apply new concepts

Very strong expertise in DataStage Designer, Director and Administrator client UI’s

Solid analytical, presentation, verbal and communication skills

Served as mentor and reviewer to junior Specialists in all areas of data warehousing, Data Quality, Governance and Master Data Management. Experienced in End user training, documentation, and Audit record maintenance and application/product demos

EDUCATION

Bachelor of Science in Computer Information Systems.

TECHNICAL SKILLS

ETL

Ascential DataStage 7.5.x, 8.0, 8.1, 8.5, 8.7, 9.1, 11.5 [Server & Enterprise Editions], InfoSphere Information Server 8.0/8.1/8.5/8.7/9.1/11.5 [DataStage, QualityStage], InfoSphere Foundation Tools 8.1.2.5/8.5.0.2/8.7.0.1/9.1.2/11.5 [Information Analyzer, Metadata Workbench, Business Glossary & FastTrack], IBM InfoSphere MDM Server 8.0/8.5/9.0/10/11/11.5 (Advanced Edition)

Data Modeling

Dimensional, Logical & Physical Data Modeling, Star Schema, Snow-Flake Schema

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

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

PROFESSIONAL EXPERIENCE

CLIENT: FRONTIER COMMUNICATIONS, NY MAR 2014 – TILL DATE

FRONTIER INFORMATION MANAGEMENT & SYSTEMS (FIMS)

FIMS 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 services to residential customers over its fiber-optic and copper networks, including video, high-speed internet, advanced voice and Frontier Secure digital protection solutions. Frontier Business Edge offers communications solutions to small, medium, and enterprise businesses.

Responsibilities:

Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects

Worked with IBM engineer on pre-installation, installation, post-installation and configuration tasks for IBM InfoSphere MDM Server (Advanced Edition) suite and verified build books

Established a 360-degree view of all JNJ customers and related parties.

Created a common business framework that drives policies and procedures to promote information quality and reusability

Created a unified method to access, maintain and share mastered Party/Policy data

Developed an implementation methodology to facilitate progressive improvements in JNJ’s “Party” centric focus through investment in foundational data management, data quality and data integration capabilities to prevent “reinventing the wheel”

Established an Enterprise Data Warehouse (EDW) platform to support detailed inquiry, self-service BI, cross LOB reporting and analytics.

Worked on Additions, Behavioral and Data Extensions, Event Management, Rules of Visibility, Business Proxies, Product Domain Both Hard Type and Soft Type Implementation, External Rule Framework for implementing Party or Role Level Survivor ship, UI Generator, Custom Matching Engine and Response Publisher.

Customized Batch Framework and Optimized MDM Server Deadlock and Performance Issues. Created custom Code Tables.

Worked on DSP (Duplicate Suspect Processing): Both with OOTB deterministic matching and with Quality stage integration for Probabilistic matching.

Worked with Platform and DBA folks on the sequence of steps during code migration between operational environments.

Worked on retrieval, updation, and deletion of glossary content and data quality tasks of Business Glossary and Information Analyzer using REST API of Information Governance Catalog (IGC).

Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM and data governance related activities

Strong skills in SQL PL/SQL packages functions stored procedures triggers and materialized views to implement business logic in oracle database

Working with tools like TOAD SQL Developer and SQL plus for development and customization

Worked extensively on creating new CUSTOMER ONBOARDING process with new configuration on External matching Rules and processing the customer data before loading into MDM

Environment: IBM Information Governance Catalog (IGC) 11.5, IBM InfoSphere MDM Advanced Edition 11/11.5, WAS 8.5.0.2/8.5.5.7 ND, SOA, Web Services, DB2 10.1/10.5 ESE, Windows 7 & RHEL 6.5/7.2.

CLIENT: MERCEDES-BENZ USA, NJ OCT 2012 – FEB 2014

METADATA PLATFORM WAREHOUSE SYSTEM [MPWS]

Mercedes-Benz combines luxury with performance across the full line of luxury cars, sedans, SUVs, coupes, roadsters, convertibles & more. MPWS was established for managing different enterprise applications like to combine technical metadata, business metadata, operational metadata, project metadata and master data using products of ETL & MDM technologies.

Responsibilities:

Configured and installed IBM InfoSphere MDM server in Pre-Prod and Prod Environments.

Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.

Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.

Involved in implementing the Land Process of loading the customer/product Data Set into IBM MDM from various source systems.

Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Created Unit Test Case document.

Worked on integration of QualityStage with MDM to provide standardization, matching, searching and other capabilities.

Worked on implementation of LDAP external user registry authentication for all MDM user security roles.

Developed Rules of Visibility, group validations & element validations via Rules Module, data associations via Meta Data Module, code tables & error messages via Code Tables Module, user groups via Security Module and extension framework & TAIL via System Module along with offline tasks.

Used MDM Workbench for generating data additions, extensions, behavior extensions, and query extensions (Extensions tooling) and for metadata specs and Product type hierarchies (Metadata tooling).

Provided technical leadership to Master Data Management team on design and implementation using J2EE-based solutions.

Worked on migration of customizations to OSGI manually and deployed them to operational server instance.

Environment: IBM InfoSphere Information Server 9.1.2 Suite [DataStage & QualityStage], IBM InfoSphere MDM Server & Initiate 8.5/11, WAS 7.0.0.17/8.5.0.2ND, SOA, SOAP, Web Services, DB2 ESE 10.1 & z/os DB2 database V11, Windows XP, Z/OS 10.1 & AIX 7.1

CLIENT: CITI GROUP INC, NJ JAN 2012 - SEP 2012

SYSTEM TECHNOLOGY APPLICATION SERVICES [STAR]

Projects & jobs are developed to load data into different applications like Customer Finance Data Integration [CFDI], Credit Data Mart [CDM], Sales Force Automation [SFA], Tax Warehouse etc of STAR group using IIS suite products and their functionalities.

Responsibilities:

Worked with parallel extender jobs using different stage like join, merge, lookup, xml input, xml out & MQ Series.

Worked with EDW Project for loading the tables from Oracle to Teradata Database.

Designed & developed interface for ES3, Manhattan, Mainframes & Biceps to RDS and tested the results.

Trouble shooting issues faced in Production & given simplified solutions to resolve the issue.

Handling different types of data in this period like XML & Flat file.

Scheduled the jobs in Orsyp where Orsyp is other scheduling tool.

Prepared technical specification documents like High level design document, Low level design documents and helped business analyst in preparing the mapping document.

Worked with TOAD to interact with Oracle and Used SQL Trace and Explain Plan to improve the performance of the PL/SQL programs

Designed and Developed Data Stage mappings for Data cleansing and Conversion and loaded data into target Oracle database.

Responsible for creating and testing ETL processes composed of multiple DataStage jobs using Orsyp and shell scripts.

Involved in unit, performance, Regression and integration testing of data stage jobs and prepared Documentation.

Used lookup stage with reference to Oracle tables for insert/update strategy and updating of slowly changing dimensions.

Source Data Quality tests to determine cleansing requirements and to assign the Defaults.

Parsing high-level design spec to simple ETL coding and mapping standards.

Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target and maintenance.

Modeled and populated the business rules using mappings into the Repository for metadata management.

Worked on performance tuning of ETL jobs using SQL queries, data connections, configuration files, parameter sets and environment variables.

Used Information Analyzer [ProfileStage] and QualityStage for Data profiling and Quality.

Used IBM Business Glossary to organize metadata into categories, terms and objects.

Used FastTrack to automate to integrate mappings and jobs into metadata repository.

Used Metadata Workbench to understand, analyze and explore the assets of business, technical and operational metadata.

Used Autosys to schedule jobs and e-mailed the status of ETL jobs to operations team daily.

Environment: InfoSphere Information Server V8.1.0.1 Suite [DataStage, QualityStage, Information Analyzer, IS Manager, Metadata Workbench, Business Glossary, FastTrack, Information Services Director & Metadata Server], Ascential DataStage 7.5x2, 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: MICHIGAN STATE UNIVERSITY, MI JAN 2011- DEC 2011

SCIENCE, ENGINEERING, RESEARCH & COMPUTING [SERC]

DataStage projects have been created for SERC platform belonging to recognized academic, residential college, and service-learning programs for the diverse community of dedicated students and scholars, athletes and artists, scientists and leaders.

Responsibilities:

Selected Installation Topology with layers for the products of Information Server.

Prepared disk, file and network resources. Modified kernel parameters and user limits.

Installed, Configured and Administered IBM IS 8.0 suite.

Worked with IBM to troubleshoot data integration suite issues. Resolved incompatible JRE errors during installation.

Migrated DataStage and QualityStage jobs from earlier versions to DataStage 8.0 version.

Worked on setting up users for IIS suite and suite components for different products.

Used Control-M to schedule jobs and e-mailed the status of jobs to operations team daily.

Performed Data Profiling using Information Analyzer in console for business analyst's review before designing jobs.

Used Investigate, Standardize, Match and Survive stages in WebSphere QualityStage to improve data quality.

Optimized server, parallel and sequence jobs for extracting, transforming, integrating, and loading data into data mart using DataStage Designer.

Worked with DataStage Director to schedule, monitor, analyze performance of individual stages and run DataStage jobs.

Worked with Developers to design Complex ETL jobs to implement Slowly Changing Dimensions and Change Data Capture.

Developed Job Sequencer and batches and have edited the job control to have jobs run in sequence.

Developed shell scripts to validate, automate and schedule DataStage jobs using UNIX shell scripting and Crontab Utility.

Environment: IBM Websphere Information Server V8.0 Suite [DataStage, QualityStage, ProfileStage/Information Analyzer, Metadata Workbench, Business Glossary, FastTrack, Information Services Director and Metadata Server], Oracle10gR2/9i, SQL Server 2005, DB2 9.1, Teradata V2R5, WAS 6.0.2.11, Java, J2EE, SQL, PL/SQL, XML, Control-M, Shell Scripts, Windows XP, Unix (AIX 5.3/Solaris 9) and SUSE Linux 10.

CLIENT: ALLY BANK, MI APR 2008 – DEC 2010

ISCoE [INFORMATION SYSTEMS CENTER OF EXCELLENCE]

DataStage projects have been created for different business units at Ally to support automotive financing products and services, mortgage operations and commercial finance, and the company's subsidiary, Ally Bank, offers online retail banking products.

Responsibilities:

Primary responsibilities involved in design, development & interface of RDS (Retail Docking Station) where RDS is the Hub for data warehouse.