Candidates About

Khaleel Syed

Senior ETL Developer

Ø  9 years of experience in Data Warehouse Business Intelligence domain with projects involving Informatica and ETL tools.

Ø  Extensive experience working with Data Warehouses and Data Marts using Informatica Power Center 10.x, 9.x, 8.x, 7.x (Designer, Repository Manager, Workflow Manager and Workflow Monitor).

Ø  Responsible for interacting with different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.

Ø  Responsible as a Mentor in training newly hired contractors with the knowledge of Business and the Data flow concepts.

Ø  Knowledge in designing Dimensional models for Data Mart and Staging Database.

Ø  Extensive knowledge in designing functional and detailed design documents for data warehouse development.

Ø  Experience in writing UNIX Shell scripts.

Ø  Experience in writing Stored Procedures and Functions (PL/SQL and T-SQL).

Ø  Performance tuning of Oracle using SQLtrace, SQLplan, SQL hints, Oracle partitioning, various indexes and join types and PL/SQL tuning.

Ø  Working knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Oracle, SQL Server, Teradata, DB2.

Ø  Teradata utilities like Tpump, FastLoad, MLoad and BTEQ.

Ø  Knowledge on Informatica Power Connect and Power Exchange, import sources from external systems like for instance Mainframe (IMS, DB2, Copybooks and VSAM) or ERP.

Ø  Knowledge on Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) for Data Profiling.

Ø  Applied Address Doctor tool in IDQ Plans in order to obtain Gold Source Data / Master Data (MDM).

Ø  XML source and target schema and object definitions.

Ø  Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, XML, Stored procedure in Informatica Power Center.

Ø  Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

Ø  Extensive knowledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3.

Ø  Experience working with different OLAP BI Reporting tools like Business Objects, Cognos.

Ø  Skilled in developing Test Plans, Creating and Executing Test Cases.

Ø  Followed effectively industry standards of HIPAA, ANSI837, ANSI834, ANSI-4010 and ANSI-5010 layouts.

Ø  Experience working with SDLC, SCRUM, RUP, Waterfall and Agile methodologies.

Ø  Reliable, responsible, hardworking and good team player.

Informatica Power Center 10.1/9.x/8.x/7.x [Repository Manager, Designer, Server manager, Workflow Monitor, Workflow Manager], Power Mart 6.2/6.1/5.1.x/4.7,Oracle Ware House Builder 9.2/10g, Pentaho Data Integration (PDI), SSIS.

Spectrum Health, Grand Rapids, MI                                                                                         May 2017 - Current

Sr. Informatica Developer

Responsibilities:

• Interacts with business users to understand the requirements.
• Create technical specification documents, STM documents, detailed ETL designs, Unit test plans, Deployment plans, Turn over documents etc.
• Involved in Data Modeling using different techniques.
• Involved in ETL architecture meetings and any new tool implementations.
• Used complex Informatica mappings to extract data from the source system to the Staging DB.
• Converted complex Oracle PL/SQL Packages to Informatica Mapping/Mapplets.
• Converted complex Transformation requirements to Informatica Transformations to transform the Source data to match the target data.
• Implemented Type 2 Dimensions (SCD Type 2) to maintain history in the Dimensions.
• Attended requirement specification meetings to add/change requirement as per the changing ETL Scenarios.
• Attended change control meetings every week.
• Create test plans and scenarios for development unit testing and data validation.
• Performance tuned slow running mappings by using best practices like Partitioning, SQL Overrides, etc.
• Generated fixed and variable length flat files and read XML files.
• Knowledge on Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation
• Worked on mdm hub, configuring match and merge rules, trust scores, mappings, stagging and base tables
• Worked on clense list and clense functions in MDM.
• Knowledge on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Worked on the Teradata stored procedures and functions to confirm the data and have load it on the table.
• Worked on FTP commands for file transfer.
• Worked on SQL developer, TOAD and DB Visualizer tools to write complex SQL queries

Environment: Informatica Power Center (PWC) 10.1.0/9.6.1, Power Exchange (PWX), Data Quality (IDQ), Oracle 11g, PL/SQL Developer, Toad, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access,  Jira, Co-pilot, Master Job Scheduler.

Blue Cross Blue Shield of Michigan, Detroit, MI                                                                              Aug 2013 – Apr 2017

Sr. Informatica Developer

Responsibilities:

·         Analyzed and thoroughly studied various data sources and different development environments within the organization.

·         Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the oracle databases. 

• Extensively worked with Source qualifier, Filter, Joiner, Expression, Lookups, Aggregator, Router, Sequence Generator, and Update Strategy.
• Used various informatica transformations in the development of complex mappings.
• Extracted data from different heterogeneous source systems applied business logic using transformations and loaded to the target systems using Informatica power center.
• Used Informatica Data Quality (IDQ) to profile the data and apply rules to Membership & Provider subject areas to get Master Data Management (MDM).
• Worked on multiple projects using Informatica developer tool IDQ 
• Involved in migration of the mapps from IDQ to power center.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes
• Worked closely with business for requirement gathering and to understand the project needs.
• Interacted with environmental team and data architects in design and implementation data models.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Extensively worked on data conversion and data cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between WellCare and different vendors.
• Developed UNIX shell scripting, created command task, and email task for providing the pre-session post-session requirements for various informatica jobs.

·         Provide database coding to support business applications using T-SQL

·         Worked on automation of informatica job flow using autosys boxes/jobs.

• Extensively worked on basic SQL queries such as creating altering Tables, Indexes, Views also worked with PL/SQL stored procedures. Queried various tables to get resultant datasets as per the business requirements.
• Prepared ETL mapping documents explaining complete mapping logic.
• Prepared unit test document and performed unit testing, regression testing.
• Provided QA/UAT support while code promotion and worked with QA’s to resolve any defects if found.
• Worked with different teams as Release Management, DBA, and UNIX team for smooth code promotions. 

Environment: Informatica PowerCenter  9.6.1/9.5/8.6.1, Informatica Data Quality (IDQ), Oracle 11g, PLSQL Developer, Flat Files, MS Excel 2010, MS Visual Studio 2010, UNIX, WinSCP, MS Access,  Autosys.

Johnson & Johnson, Ann Arbor, MI                                                                                         Jan 2013 – Aug 2013

Senior ETL/Informatica Developer

Responsibilities:

·         Studied the design of the data warehouse model using Star Schema.

·         Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets

·         Involved in the designing of ETL process using Informatica to populate the BI Data Mart using the Flat Files, SQL server to Oracle and Teradata databases.

• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Applied the rules and profiled the source and target table's data using IDQ.

·         Worked on MDM concepts in large scale implementation environments

• Extracted data from sources like SQL server, and Fixed width and Delimited Flat files. Transformed the data according to the business requirement and then Loaded into Oracle and Teradata databases.
• Experience in writing SQL queries and optimizing the queries in SQL Server.
• Performed data analysis and data profiling using SQL on various sources systems including SQL Server
• Designed and developed complex mappings to load the Historical and Weekly data from the Legacy Systems to Oracle database.
• Worked with Teradata Database in writing BTEQ queries and Loading Utilities using Multiload, Fastload, FastExport.

·         Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.

·         Enrich the transaction and load the enriched transactions into Transaction Enrichment Database (TED).

• Implemented Type II Slowly Changing Dimension methodology for accessing the full history of customers.
• Used XSLT for transforming the XML files in implementing the front-end templating system.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

·         Created and Monitored Workflows to run Session tasks using Informatica Server.

Environment: Informatica Power Center 9.1.1/8.6.1, Oracle 11g/10g, Teradata Database 13.10/12.10, XML, XSL (XSLT and XPath), SQL Server 2008, Flat files.

General Electronics, Louisville, KY                                                                                          Oct 2011 – Dec 2012

DW ETL Informatica Developer

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.

·         Worked with source teams to resolve data quality issues raised by end users.

• Mappings were developed in Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.
• Applied Slowly Changing Dimension and Dynamic lookup techniques.

·         Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

·         Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.

·         Responsible for identifying the missed records in different stages from source to target and resolving the issue.

·         Extensively used PL/SQL Procedures/Functions to build business rule.

·         Used parameters and variables (sessions/mappings) extensively for incremental loads.

• Used SQL tools like TOAD to run SQL queries and validate the data.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Setting up tasks to schedule the loads at required frequency using Power Center workflow manager.

Environment: Informatica PowerCenter8.6.1/8.1, Oracle 10g/9i, SQL Server 2005, Toad, UNIX.

iSpace Global, India                                                                                                                  Mar 2008 – Sep 2011

Client: Verizon Wireless, NY

Programmer Analyst

Responsibilities:

·         Used update strategy to effectively migrate data from source to target.

·         Migrated mappings from development environment to test environment.

·         Imported and created source definitions from Oracle, SQL Server, Sybase and flat files.

·         Created Informatica mappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.

·         Involved in performance improvement project.

·         Involved in designing of testing plan (Unit testing and System testing).

·         Tested scripts by running workflows and assisted in debugging the failed sessions.

·         Used persistent caches whenever data from workflows were to be retained.

·         Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.

·         Performance Maintenance including managing space, remove Bad Files and monitoring services.

·         Set up permissions for groups and users in all Development Environments.

·         Migration of developed objects across different environments.

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, Windows, ERwin, DB2, Sybase 12.x/11.x and UNIX.