MOHAMED ATIK ANWAR

ETL Developer/Informatica Developer

323-***-****

adurvf@r.postjobfree.com

Calabasas, California 91302 US Citizen

SUMMARY:

●Over 9 years of IT experience in Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of datawarehousing applications.

●Experience in the field of Data warehouse using ETL tools such as Informatica Power Center 10.2/9.6/8xPowerMart 9x/8xdatabases as DB2, Oracle, MS SQL Server ztd Teradata.

●Extensive experience in the implementation of Extraction, Transformation & Loading (ETL) using Informatica Power CentedFerar, Teradata, Oracle 11g/10g/9i,MS SQL Server 2008, SSRS and SSAS.

●Extensively used various transformations such as Filter, Expression, UpdateStrategy, Look-up, Sequence, Joiner, Router, Aggregate, and Stored procedure t.

●Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow, Sessions, reas, and processing tasks using Designer/ Workflow Manager to move the data from multiple Source system to Targets.

●Solid understanding of Data Warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) and Relational Data Modeling and Slowly Changing Dimensions.

●Experience in documenting High Level and Low level Design, Source to Target Mapping (STM), Macro and Micro Documents, Unit test plan, Unit test cases and Code Migration Report.

●Worked with Business analysts and the DBA for requirements gathering, business analysis, designing and documentation of the data warehouse.

●Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

●Knowledge in Oracle, BTEQ, SQL, PL/SQL, MS Access, MS Excel on UNIX and Windows platforms.

●Experience in populating the data warehouse tables using SQL*Loader, MULTILOAD, FASTLOAD, Oracle Packages, Stored procedures, Stored functions.

●Knowledge in Data Analyzer tools like Informatica Power Exchange to capture the changed data.

●Worked in Agile Methodology for SDLC (Software Development Life Cycle) and utilize agile scrum meetings for creative work.

TECHNICAL SKILLS:

Data Warehouse Tools

Informatica Power Center 9.6/9.5/8.x/7.x, Data Stage, Informatica Power Analyzer/Powermart 9x

Operating System

Windows XP/Vista 08/07, Unix, Linux, IBM Mainframes, Putty, Winscp

Databases

Oacle 11g/10g/9i, MySql, Sql Server 08/05, Teradata, MS Access

Reporting Tools

Cognos, Tableu, SSRS, SSAS

Dimensional Data Modeling

Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake, Modeling, Erwin.

Data Base Tools

Oracle SQL Developer, SQL Plus, Toad, MS office, Microsoft Visio

Languages

SQL, PL/SQL, XML, Unix Shell Scripting, Cobol

Dimensional Data Modeling

Dimensional Data Modeling, Star & Snow Flake modeling, Erwin

PROFESSIONAL EXPERIENCE:

Qualcomm, San Diego, CA January 2019 - July 2020

ETL Developer/Informatica Developer

Qualcomm Incorporated is an American multinational semiconductor and telecommunications equipment

Company that designs and markets wireless telecommunications products and services. It derives most of

Its revenue from chipmaking and from patent licensing businesses. The company headquarters is located

In San Diego, California. It has 224 worldwide locations. Qualcomm introduced CDMA (Code Division Multiple

Access) technology for wireless and data products in 1989. CDMA quickly became one of the world’s fastest growing wireless technologies. Since the beginning, Qualcomm has grown and prospered by developing and

Applying advanced technologies for wireless telecommunications products and services.

Responsibilities:

●Provided development and technical support for Sales and Payroll related data and loaded this data from Insight to Oracle database.

●Created mappings to load raw data from Insight (Flat files) to staging tables (Oracle). This data was then loaded to various dimensions and facts to be used for report development (Cognos) for business users.

●Captured data changes with the help of SCD Type 1 and Type 2 mappings and also utilized MD5 to accomplish Dimension, Facts and error record loading.

●Worked with Look Up transformation using both Connected and UN - connected options.

●Worked with various look up cache like Static Cache, Dynamic Cache and Persistent Cache.

●Created scripts to unzip raw data file, load data to staging tables and them move the zipped files to archive folder and also to create list file dynamically.

●Extensively used various transformations like Union, Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.

●Based on the error message from logs, review Informatica mappings and stored procedures to identify the reason for batch job failure and propose an appropriate solution. Also documented failures for future references.

●Worked with business users to troubleshoot faulty data in reports.

●Extensively worked with Joiner transformation using the four types of joins-Normal Join, master outer join, detail outer join, and Full Outer join.

●Used parameters and variables in PowerCenter code to avoid hardcoding values.

●Worked with Business analyst and business users to capture business requirements before working on mappings.

●Did performance tuning at ETL and database level to perform ETL faster.

●Responsible for supporting multiple functional high availability business applications and business users. Additional responsibilities include but not limited to troubleshoot production data issues and failures, manage critical incidents and bridge calls, automate repetitive tasks, problem analysis, maintain knowledge base and documentation, implement process improvement methods.

●Extensively worked with aggregate functions like Avg, Min, Max, Count, First, and Last in the Aggregator Transformation.

●Used Filter transformation at the early stages of the mapping for the performance tuning of the mapping.

●Ability to work on performance issues by accessing both Informatica and Oracle logs to increase process efficiency.

●Good experience in scheduling jobs with Autosys.

●Coordinate with other technology groups to resolve incidents and problems, and escalates complex problems to the next level of support as required by documented procedures. Perform as incident manager to ensure resolution and follow up.

●Develop and gather metrics to assist in problem analysis and resolution, support efforts to improve system monitoring tools and processes to enhance service delivery and support model for the end users.

●Participate in problem analysis and incident management procedure meetings to enhance process improvements. Ensure timely communication to the impacted parties during an incident.

●Provide post-implementation and system checkout support for changes to production applications and services and provide information and updates to tasks and incidents in the appropriate systems and knowledge base tools.

●Respond to inquiries, requests for support or information, and escalations from Level 1 support or other technology and business users. Respond to production incidents and help resolve or escalate in a timely manner.

Environments: Informatica 10.x/9.x, Oracle 11g, UNIX, SQL, SQL Server, Rapid SQL, TOAD 8.6, Erwin.

Capital One Management, Calabasas, CA July 2014 –July 2018

ETL/Informatica Developer:

Capital One Financial Corporation is an American bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. The company measured in terms of total assets and deposits, Capital One is the eighth largest bank holding company in the United States. As of 2012, the bank has 963 Capital One Bank Branches including 10 cafe style locations for their Capital One 360 brand and 2,000 ATMs. Capital One Financial is a member of the Fortune 500, and also conducts business in Canada and the United Kingdom. The company helped pioneer the mass marketing of credit cards in the 1990s, and it is now the fourth-largest customer of the United States Postal Service.

Responsibilities:

●Involved and understanding the Business requirements/ discuss with Business Analyst, analyzing the requirements and preparing business rules.

●Design and Developed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure to implement complex logics while create mappings.

●Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.

●Developed mappings/Transformation/ mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.

●Experienced in methodologies like SDLC and Agile methodologies such as SCRUM.

●Contributed and actively providing comments for user stories review meeting within an AGILE SCRUM environment.

●Extensively worked with transformations like Lookup, Expression, Router, Joiner, Update Strategy, Filter, and Aggregate.

●Extensively worked on SQL override in Source Qualifier Transformation for better performance.

●Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL.

●Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.

●Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.

●Implemented slowly changing dimension (SCD Type 1 & 2) in various mappings.

●schema

●Created sessions, database connections and batches using Informatica Server Manager/Workflow Manager.

●Extensively used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic implanted in the mappings.

●Coordinated all ETL (Extract, Transformation and loading) activities and enhancements using Agile Methodology.

●Extensively used Informatica debugger to find out the problems in mapping. Also involved in troubleshooting and rectify the bugs.

●Involvement in all phases of software development life cycle in this project which includes but not limited to Requirement gathering, analysis, technical design, development, testing, and user acceptance testing.

Environment: Informatica PowerCenter 9.6, Oracle 11g, UNIX, XML, PLSQL, Erwin 4.0, Putty, Winscp, Windows XP/Vista, Quality Center.

Cardinal Health, Los Angeles, CA October 2012 – June 2014

ETL/Informatica Developer

Cardinal Health is one of the largest healthcare supply companies in the United States. Cardinal Health manufactures medical and surgical products, including gloves, surgical apparel and fluid management products. In addition, it operates the nation’s largest network of radio pharmacies. Cardinal Health provides medical products to over 75 percent of hospitals in the United States. The company's core value is to Essential to Care, and with connections across the continuum of care, and continues to make critical moves necessary to compete and create value in today’s dynamic healthcare environment.

Responsibilities:

●Analyzed source and target systems for loading data into CDW and to create external data feeds.

●Involved all the phases of SDLC design and development.

●Involved in gap analysis and STM documentation to map flat file fields with relational table data in CDW.

●Developed mappings, mapplets, re-usable transformations to load external data into CDW.

●Extracted data from CDW to create delimited and fixed width flat file data feeds that go out to external sources.

●Analyzed Design documents and developed ETL requirement specs.

●Created re-usable objects and shortcuts for various commonly used flat file and relational sources.

●Developed a shell script in order to append Date and Time stamp for output xml files, to remove empty delta files and to FTP the output xml files to different servers.

●Validate Logical Data Models relationships and entities, Determine data linage by including all associated systems in data profile.

●Excellent Data Profiling experience used Data Polling validating data patterns and formats.

●Integrated data into CDW by sourcing it from different sources like Oracle, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.

●Technical Analysis writing & reviewing technical designs.

●Created UNIX scripts to deal with flat file data like merging delta files with whole files and to concatenate header, detailed and trailer parts of the files.

●Developed Mappings which loads the data in to Teradata tables with SAP definitions as Sources.

●Created mappings to read parameterized data from tables to create parameter files.

●Used XML Source Qualifier and used only with an XML source definition to represents the data elements that the Informatica Server reads when it executes a session with XML Developed.

●Used XML Parser transformation lets you extract XML data from messaging systems.

●Used ODI to perform data integration to ELT processing. Data is extracted from multiple sources, sent through several transformation processes and loaded into a final destination target.

●Used SAS for data entry, Retrieval, Management report writing and Statistical analysis.

●Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load (ETL) data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).

●Used Message broker as translate messages between the interfaces.

Environment: Informatica PowerCenter 9.5, Power Exchange, Windows, Oracle, Toad for Oracle, BODS, UNIX Shell Scripting, workflow scheduler, Perl, Putty, WinScp.

CITI Group, Chicago, IL March 2011 – September 2012

ETL/Informatica Developer

Citigroup is an American multinational banking and financial services corporation headquartered in Manhattan, New York City. Citigroup is today s pre-eminent financial services company and was built to create a highly diversified financial services company that could act as one to deliver solutions to clients throughout the world. The company has the most diverse array of products and the greatest distribution capacity of any financial firm in the world, and its employees manage 200 million customer accounts across six continents in more than 100 countries.

Responsibilities:

●Interact with business analysts, Analyzed, inspected and translate business requirements into technical specifications.

●Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.

●Involved Creating Fact and Dimension tables using Star schema.

●Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.

●Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.

●Design and developed complex informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).

●Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.

●Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.

●Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

●Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica Power Center 9.1/8.6, SQL server 08, Oracle 11g/10g,PL/SQL, Cognos, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

UnitedHealth Group, Cypress, CA January 2010 – March 2011

ETL/Informatica Developer

UnitedHealth Group is the one of the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone. UnitedHealth Group serves more than 85 million patients worldwide with its health benefits and services. It's the largest U.S. health insurer, surpassing the likes of Kaiser Foundation Group and Anthem. United Health Group's core capabilities in clinical care resources, information and technology uniquely enable us to meet the evolving needs of a changing health care environment as millions more Americans enter a structured system of health benefits and we help build a stronger, higher quality health system that is sustainable for the long term.

Responsibilities:

●Maintaining the data coming from the OLTP systems.

●Developed and maintained complex Informatica mappings.

●Involved in analyzing and development of the Data Warehouse.

●Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,

●Perform data validation tests using complex SQL statements.

●Worked with data warehouse staff to incorporate best practices from Informatica.

●Worked with Business Analysts, using work sessions, to translating business requirements into technical specifications, including data, process and specifications.

●Implemented Type II slowly changing dimensions using date-time stamping.

● Created database structures, objects and their modification as and when needed.

●Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

●Performed Unit testing and maintained test logs and test cases for all the mappings.

●Testing for Data Integrity and Consistency.

Environment: Informatica Power Center 8.6, Informatica PowerCenter, Power Exchange, Windows, IBM DB2 8.x, Mainframes, SQL Server 2007, Enterprise Architect, Meta data Manager, ER studio, Oracle, SQL Plus, PL/SQL, Windows 2007.

AAA, Phoenix, AZ April 2009 – November 2009

ETL/Informatica Developer

AAA formerly the American Automobile Association is a federation of motor clubs throughout North America. AAA is a not-for-profit member service organization; in 2010, it had 51 million members. AAA provides services to its members, including roadside assistance and others.

Responsibilities:

●Extensively used Informatica to load data from Oracle9 and flat files into the target Oracle 10g database.

●Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.

●Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.

●Created and scheduled workflows using Workflow Manager to load the data into the Target Database.

●Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.

●Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.

●Involved in meetings to gather information and requirements from the clients.

●Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.

●Used Debugger to validate mappings and also to obtain troubleshooting information about data by inserting Breakpoints.

●Extensively used Variables, Break points, and Sorted inputs.

●Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.

●Created UNIX shell scripting and automation of scheduling processes.

●Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environment: Informatica Power Center 7.1, ETL, PL/SQL Developer, Oracle 10g, UNIX, Microsoft SQL Server, TOAD.

EDUCATION:

California Polytechnic University, Pomona, CA - 2004

Bachelor of Science - Electrical and Computer Engineering

Contact this candidate