Syed Quadri

Summary

I have extensively worked on suite of Informatica products (Power Center, Power Exchange, Informatica Data Quality, Metadata Manager, Dash Board & reporting, TDM-Data Masking Data Sub setting, Data Archiving and Data Validation etc.) as an Informatica administrator. I was involved in establishing Business Intelligence Competency Center, Data Governance, Metadata Maturity Model For Business Glossary and Information linkage to data assets. Implemented Enterprise Data Warehouse for a Major Bank which includes many subject areas like Core Bank, Debt Investments, Foreign Trade, Fixed Deposits, Credit swaps, Anti Money Laundry, Basel II etc.

Proficient in provisioning AWS cloud technologies like VPC, IAM Security group, EC2 platform, EBS, EFS, S3, Glacier storage, RDS and Redshift databases.

Worked on technologies for more than 6 years (Expert):     

DWH ETL Tools          Specialized in Informatica 9.6.1 HF2, Power Exchange 9.6.1 HF2,

                                     Informatica IDQ 9.6.1HF2, ILM-TDM 9.6.1 HF1 and B2B etc.

Databases:                  Oracle All Version, SQL Server

Oracle HA:                   RAC on Linux/Solaris, shareplex, golden gate, VERITAS Cluster etc.

EMC Storage:              Tier 2 Clariion CX Series.2

OS:                              Solaris/SunOS, Red hat Linux, IBM AIX, Windows

File Systems & VM:     VERITAS Volume Manager, VXFS, VERITAS cluster file system,

                                    ASM, NFS, ZFS, CIFS etc.

Worked on technologies for more than a year:                         

Databases:                 Oracle 7/8i/9ir2/10gr2/11gr2/12c, DB2 UDB 9.7, SQL Server 2k, 2008

Data Quality:               Informatica IDQ (Athenor and Axio), Siperian MDM Administration.

BI Tools:                     OBIEE 10g, 11g

Storage:                     Tier 2 NetApp (ONTAP 8.1)

Apps servers:             IBM Web Sphere 6.1,15, 7.0.0.17

Hadoop                      Cloudera Hadoop Cluster (HDFS)

Education / Certifications

BS (Business Accounting)

Informatica Basic Mapping Design PC7

Informatica Basic Administration PC7

Informatica Advance Mapping Design PC7

Informatica Advance Administration PC7

Oracle Certified Professional 10g

SAP HANA (C_HANATEC151)

TOGAF 9 (Certified Enterprise Architect).

Professional Trainings

Informatica IDQ Administrator

zLinux Administrator

Informatica Power Center Admin./Advance Mapping design – Informatica Inc USA

Informatica IDQ & IDE Athenor and Axio – Informatica Inc, USA

Informatica Power Center 8 New Features  -- Informatica, USA

Informatica B2B (Complex data exchange, Unstructured data option)

Oracle Streams 10g -- Oracle Corp CA – USA

Oracle 10g new Features – Oracle Corp, CA - USA

Oracle RAC Oracle 9i -- Oracle Corp. CA USA

Solaris Admin I – Solaris 7 NJ USA

Solaris Admin II – Solaris 7 NJ USA

EMC Replication Manager Web Based Training

RDBMS

Oracle 11g, 10g R2, 9.2.6(9iR2), 9.0.1(9iR1), 8.1.x(8i), 7.3.4,8.0.x, Oracle Exadata, SQL Server 2005, 2000, DB2 UDB 9.7,9.5,9.1,8.2

Replication/Integration tools

SharePlex 5.1, Oracle Streams, Power Exchange

ETL/BI Tools

OBIEE 10.x (DAC, Informatica, OBIEE Reporting tools, BI Apps), Informatica PC 5/6/7/8.1.1,9.0.1, PWX 5.2/8.1.1, Metadata Manager 8.1.1, Informatica IDQ Athenor/Axio etc

Operating Systems

Solaris 10, 9, 2.7, 2.6, 2.5.1, Red hat 4.x/5.x/6.2, IBM AIX 4.1, 5.1, 5.2,6.1

Query Languages

SQL ISQL PL/SQL, TSQL.

Hardware Worked On

Sun Enterprise Server 3500,3400,Sun fire 10k, 12k, 6800, 3800, 880, 480

Storage & SAN

DMX1000, DX4, Clariion CX4, CX700, CX600 (SAN/SAN). Netapp FAS 6040

AWS Cloud

VPC, EC2 Platform, VSphere 5.1, S3, Glacier, Redshift

Work Experience

IT Strategic Planners Inc.

AWS Big Data / Informatica Consultant

May 2016

Till Date

Provisioned EC2 Instances with EBS volumes, created encryptions key pairs for connectivity provisioned S3 shared across multiple systems, configure data files archiving policies. established connectivity between on premise system, AWS systems, Informatica and leveraging lambda, kinesis stream SQS, Big Data Connector for EMR and DynamoDB to maximize integration, installed and configured Informatica 9.6.1 on oracle database and migrated Informatica IDQ, MM, PC, TDM and PWX. Created data warehouse schemas into Redshift and running in parallel as pilot.  

Installed and configured Informatica suite of products (PowerCenter, Informatica Data Quality, Metadata Manager, Test Data Manager, Data Masking, PowerExchange and configure archiving policies on glacier, Administrating Informatica services, configured PowerExchange client to extract data from legacy VSAM files, AS/400 and load it into Redshift, configured EMR, EMRFS with master node and multiple core nodes,

Current OLTP application are mostly deployed on Oracle, SQL Server, SAP NetWeaver, SAP HANA,  DB2 DB/400, MQ, JSON file, SQL Server Publisher for PWX CDC, xml files etc., Analyzing integration, automation and cost effective reusable services. 

Developed blue prints and TO-BE cloud architecture for business services and IT Infrastructure, planning full data warehouse data migration strategy. Cost analyzing to use AWS service like data pipeline, Kinesis firehose, lambda, SQS (Queues), scala spark S3Distcp etc.

Architected and responsible for setting up the AWS environment with Informatica to extract data from legacy and In-house systems and load it into AWS redshift Data warehouse and Big data ,  implementing AWS Hybrid, AWS VPC, AWS EMR, AWS EC2, CLI & Python, Cloud API, Cloud Front, Auto Scaling, Cloud watch and management solutions.

Responsible for Big Data deployment, data extraction, Inbound data volume and velocity planning, Inbound Data Ingestion, loading, capacity planning, HDFS cluster and Data node capacity planning and HDFS storage infrastructure planning with EMR machines on AWS cloud, HDFS performance tuning, Data modeling and Architecture, YARN, HDFS, Spark & KAFKA Real time analytics architecture, Spark RDD, Data frame, Data sets, Spark SQL design and implementation.

Multiplan Inc.

Informatica Admin

Nov 2014

May 2016

Informatica Admin/Architect:

Installed Informatica in all environments, Upgraded Informatica Platform from 8.6.1 to 9.5.1/9.6.1 HF2, Maintaining Informatica Platform (Power Center, IDQ, MM, PWX, DVO, and ILM-TDM), Applied Hotfixes and EBFs. All changes are applied following SDLC process. Proposed migration strategy of Informatica Objects (PC, IDQ, MM etc.)  Used versioned repository, dynamic deployment group for migration, used SVN version control for other objects like shell scripts & database scripts.

Configure PowerExchange Listener and Logger service on Informatica HA Grid Control, setup monitoring of CDC workflows, Configure Connection session setting to restart from the last token.  Setup seamless migration process using DTLURDMO utility. Written shell scrips o monitor the CDC process, starting &U stopping PowerExchange CDC workflows etc. 

Developed and suggested Informatica best practices to the team, helped developer in setting up the right encoding, helped developer in resolving common issues. Configured PowerExchange for SQL Server & Oracle with TDE enabled.

Suggested alternate architectures for HA & DR based on Enterprise Architecture team input on RTO, implemented systems in DR using Informatica spanning domain architecture.

Developed more than 50 mappings for real time replication using Power Center and Power Exchange CDC. All workflows are running under Informatica Grid environment.

Data profiling, Join Profiling, Custom Profiling, domain discovery, score carding and build cleaning rules in IDQ Knowledge of Human Task workflows for data governance.

Architected and Implemented Informatica Disaster Recovery Site using VERITAS Cluster file system, Veritas replication software, Oracle MAA, Oracle extended Data Guard and Informatica spanning domain. Tested all service active & active-passive in DR periodically. 

Moved Informatica and Data Modeling ER Studio infrastructure from old data center to new datacenter seamless without any issues included Informatica Power Center, Informatica PowerExchange, Informatica IDQ, Informatica MM, spanning domain (4) nodes and ER Studio Repository Server and License Server etc.

Informatica Partners

Consultant

May 2007

Aug 2014

Informatica Architect:

Installation, maintenance and upgrade of Informatica Power Center from 7.1/ 8.1.1 to 9.5, configured and maintained session on grid control 2 node cluster environment, Power Exchange 9.5, Informatica Data Quality 9.5, Oracle Golden Gate 11g and Metadata Manager 9.5.

Used Data Cleansing transformations and matching based on agreed profiling result later these rules was incorporated into oracle Siebel UCM (MDM) within data governance umbrella and applied fixes on the source system.

Setup Code Migration strategy according to SDLC process and Informatica velocity best practices, used Version control repositories, create dynamic deployment groups and roll back of deployment if necessary. Responsible for preview and code migration to SIT/UAT/PROD.

Maintained PCI compliance for data stored onto the file system data masking, write shell script to automate jobs using third part scheduler, wrote shell scripts for archiving and cleanup, backup the Informatica repository etc.

Integrated Power Center & Metadata Manager with Active Directory (LDAP) and deployed Metadata Manager on IBM WebSphere Application Server (network deployment).

30% of the time developing complex mappings using Informatica velocity best practices mapping standards, extracted data from AS/400 DB2, VSAM (VMS Cobol) file, XML, DB2, Oracle, SQL Server, MQ, Swift format file etc.

Involved in the full implementation of DWH project, developed new maps (slowly changing Dimension Type 2), modified existing one for data warehousing and BASEL II project; suggested and implemented error handling. Assisted in data reconciliation process for ALGO, ACLM and Basel II.

Implemented load control tables for recovery and reload of data into the target systems, automated the generating parameter file for daily and monthly load from the control tables.

Excellent skill on performance tuning of database SQL, Informatica Power Center and inefficient mappings.

Used Power Center data profiling to identify the Data Quality issues and scheduled reporting to source system owner for getting it fixed.

Installed, configured and maintained Informatica Siperian MDM, established to other systems using MQ & Adaptors. Established Data Governance which includes Data steward, Business Analyst and source system business owners.    

DB2:

Installed DB2 software, created databases and Upgraded DB2 databases from DB7.2 to 9.1 twostep upgrade,

Configured backups exported and imported database objects, performance tuning, migrated full databases from DB2 9.1 to Oracle 11g and taken care of different Foreign character encoding as part of DB2 decommissioning projects...

Internet Banking:

Installed and configured WAS 6.1 and 7.1 application servers (3 node Cluster), maintained, upgraded, applied fix packs and deploying code provided by development team into production following complete release management process. Applying configuration changes as required, writing shell scripts for archive log files and automation, write maintenance jython scripts.

Type of Sources/Target used:

Oracle, DB2, Informix, Sybase, SQL Server, XML, Cobol Copy Book using Power Exchange, Informatica Data Quality, Data Masking etc.

Informatica Corporation – California

Informatica Professional Services (IPS) Consultant

March 2004

May 2007

Installed, configured and supported Siebel Analytics which is also known as OBIEE suite.

Designed database for company standards where entire enterprise lookup for company standards.

Involved in the full Data Quality life cycle (Assessing Data Quality, Defining Data Quality Targets, Designing Quality Enhancement plans, Implementing Quality Enhancement Plans, and Monitoring Data Quality Vs Targets).

Analysis phase includes (Assess data, completeness, conformity, consistency, data duplication, integrity, accuracy )

Designed and developed complex mappings from source systems to Enterprise Data Warehouse and from EDW to Data Marts. – Type 2, Type 3 dimensions, designed and developed complex mappings from xml and cobal sources to EDW, designed Crosswalk tables for translation between new and old systems for data integration, designed Job processing control tables to monitor jobs (number of rows loaded, job kickoff time, job end                   time, job status, Batch ID, etc.).

Designed and developed complex workflows using command task, decision task, assignment, timer, Event waits, Event Raise, custom shell scripts and used Control M to schedule workflows etc.

Designed and developed recoverability procedures if the job fails. Implemented error handing to capture errors into database tables for reconciliation purpose.

Analyzed applicability of new features to enhance existing session performance, analyzed Informatica mappings and sessions for performance impact, helped customer in educating the impact of repository configurations on performance and load on the system, implemented session partitioning and explained Informatica partitioning benefits.

Informatica Upgrade Assignments:

Upgraded Informatica for more than 9 customer sites (Upgraded options metadata manager, SAP Power Connect, Teradata, etc) Upgraded from 4.7 Power Mart to Informatica 8.1 (two/three steps upgrade), moved repository from Informix to oracle database, and wrote shell scripts for clean shutdown/startup of all services including MM, backup shell script, file parsing script, etc.

Developed blue print for data warehouse initiative, baseline architecture, proposed architecture (applications, high level data entities, prebuild analytics, Hardware & Software Infrastructure), guidelines on data governance, business Intelligence competency, etc.

Developed and enhanced TRM, looking at the corporate strategic initiatives, added software and hardware products by looking at the current infrastructure, Gartner & Forrester rating wherever necessary, and consulted with ARB & APC for final approvals.

Implemented Power Exchange CDC for Oracle/SQL/DB2.

Gave training on PWX CDC for Oracle/SQL server.

Followed Velocity Methodology in the development of Informatica ETL mappings.

Configured Active registration for CDC objects enabled supplemental Logging for oracle objects, installed and configured power exchange listener for Oracle and SQL Server, configured ODBC interface using power exchange ODBC drivers and developed mapping using Power Exchange for providing change data captures (CDC) from OLTP to ODS.

Responsible to design, development and unit test different components (Informatica mapping, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data), Setup Procedures & Mappings to Extract, and Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse tables by using Informatica.

IPS Training:

Presented Online Training on Power Exchange CDC to Other IPS consultants.

Oracle Performance Tuning:

Created partitioned on tables and indexes for better performance, tuned SQL statement, and added hints.

Exported, Imported and customized table statistics for SQL Plan analysis.

Created outlines for existing statements to use proper indexes.

Collected Statistics and histograms for oracle to generate accurate SQL Plan.

Tuned database using STATPACK, AWR, OEM diagnostics and tuning pack, also used Spotlight.

Created functional index, bitmap index, materialized view for better performance.

Activated SAR reports and OEM reports for capacity planned and tuned the database.

Proactively catching top SQL’s, tuned them and worked with the application team to implement it.