We provide IT Staff Augmentation Services!

Edi Developer Resume

Hoboken, NJ

SUMMARY:

  • Confidential has overall 13 years IT industry experience as a Solution Architect/Lead Developer encompassing wide range of skill set, roles and industry verticals.
  • Confidential has worked as INFORMATICA Power - Center, Master Data Management, Data Quality and Data Governance expert in various Data Warehousing, Data Migration ETL (Informatica) and Data Lake implementations, he is currently a Senior Architect in IBM Global Services in New Jersey, USA.
  • Strong working/hands on experience in INFORMATICA Product Suite (Power Center, Workflow Manager, Monitor, IDQ Developer, MDM Hub Console, Informatica Big Data Edition, Informatica Cloud), Web Methods Product Suite and databases like TERDATA, ORACLE, DB2.
  • Implemented end to end strategic solutions for Customer Data Mart (CDM) and Product Data Hub (PDH) using Informatica Master Data Management (MDM) to support SAP AR business (Accounts Receivables) by providing single version of truth of a customer.
  • Working knowledge of IBM Banking Data Warehouse (BDW) Model, worked on Servicing and Originations Systems Financial Markets Back Office and settlements.
  • Have strong experience in building Data Governance Framework and Management strategies for better utilization of existing data. Familiarity with various Data Cleansing and Standardization procedures.
  • Have good understanding and working knowledge of Informatica MDM (Siperian) Hub, Informatica Data Director (IDD), Design of Match Rules, Merge/Un-merge operations based on business requirements, Publish layer design.
  • Basic understanding on Python as a programming language.
  • Good understanding of Salesforce.com and partner programs.
  • He has good Knowledge on Dimensional Modeling concepts, Star & Snow Flake Schema Design in Media/Health Care/Banking/Insurance Domains.
  • Excellent Communication, interpersonal and presentation skills, with ability to interact various key business and Technical stake holders across organizational hierarchies.
  • Extensively worked with large EDW systems in all functional areas including Financial Services, Investment Banking, Insurance, Health Care, Manufacturing and Media & Communication, Risk & Compliance Management.
  • He received GIS “Onsite Talent award” for outstanding contribution to client’s success for 5 consecutive Quarters in 2017-2018.
  • Experience with formal delivery methodologies such as SDLC, Iterative, Agile,
  • Good exposure with SQL performance Tuning, Informatica development and Teradata utilities like BTEQ, TPUMP, FASTLOAD etc.
  • Strong experience in Performance Tuning of existing Informatica Jobs, trouble shooting production jobs as part of support.
  • Hands on experience with SQL analytical functions and ability to write COMPLEX SQLs joins to transform data as per requirements.
  • Strong experience with various scheduling tools such as Tidal, Autosys, Control M etc
  • Knowledge on ITIL and ITSM processes.

TECHNICAL SKILLS:

Business Intelligence: INFORMATICA 8.x, INFORMATICA 9.x, INFORMATICA Data Quality, Informatica MDM, BI Architecture, IBM BDW Architecture & Data Model, Power Exchange, Ab Initio 2.1.

Development Tools: Informatica PowerCenter, Workflow Manager, Monitor, Power Exchange, IDQ, MDM Hub Console.

Functional Modules: Media & Entertainment, Banking and Financial Services, Servicing and Originations, Mortgage, Risk, Business Objects, Business Analytic and Optimization, EDI

RDBMS: Teradata 12, Teradata 13.1.1, Oracle 9i, Oracle 8.1, MS-SQL Server 6.5/7.0, MS Access 2000, DB2 10.5

Languages: SQL, T-SQL, BTEQ scripting, Flow Language, AS400, Mainframe

O/S: Windows NT/2000 Server, HP-UX 11.1, SCO UNIX

EAI: WebMethods 6.5, WebMethods 7.1, IBM Websphere, WPS, WID, MQ Series, SFDC

Processes: IBM’s QMS (Quality Management System), ITIL

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

EDI Developer

Responsibilities:

  • Architect the overall Migration Design for the Contracts/Deals between Confidential and its respective Authors/Vendors and subsidiaries.
  • Understand the Royalty Terms, Advance Schedule, Sales Bonus, Subright Terms, Charge backs, Recoupable allocations calculations on Author contracts in current Legacy system and architect the migration strategy for a smooth transition into new IPM (Intellectual project Management) system with all business rules intact.
  • Responsible for designing the overall data model for data extraction/transformation and ingestion into new system.
  • Provide a roadmap for the overall enterprise level BI solutions and keep the client leadership abreast with progress and timelines.
  • Work with vendors, development team, Data governance team and the business to deploy, maintain, and configure custom applications and build new environments as required.
  • Design and Development in configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Work in the fast paced environment to analyze data quality and data flow issues into IPM and quickly fix them programmatically.
  • Analyze the data flow requirements and develop scalable mappings for staging and loading data.
  • Develop Mappings, Mapplets using transformation as outlined by business
  • Responsible for Source data analysis, Data Profiling and Data Quality Rules development.
  • Involved in preparing and executing unit test cases.

Confidential, Hoboken, NJ

EDI Developer

Responsibilities:

  • SPOC for various queries from business and DATA GOVERNANCE team on all data and applications related aspects.
  • Work with vendors, development team, Data governance team and the business to deploy, maintain, and configure custom applications and build new environments as required.
  • Design and Development in configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Create Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group.
  • Consult, Strategize, formulate setting, defining data governance and stewardship processes for MDM solutions
  • Work in the fast paced environment to analyze data quality and data flow issues into CDM and quickly fix them programmatically.
  • Analyze the data flow requirements and develop scalable mappings for staging and loading data.
  • Develop Mappings, Mapplets using transformation as outlined by business.
  • Develop reusable mapping to load SAP IDOCs in Migration processes.
  • Responsible for source data analysis and Data Profiling.
  • Involved in preparing and executing unit test cases.
  • Develop informatica mappings to generate data in XML format to be consumed by Tibco bus.

Project Environment: INFORMATICA 9.6.1 Power center, Developer (IDQ), MDM 9.7 Hotfix 7, TIDAL, Oracle 11g, XML, Modeling, UNIX, SQL scripting.

Confidential, Roseland, NJ

EDI Developer

Responsibilities:

  • Analyze the Business Requirements Documents (BRD) and conduct requirements gathering sessions for functional design.
  • Work the domain experts to create Functional Solution document (FSD) and conduct walkthru’s to ensure all the business requirements have been captured.
  • Prepare Technical Design documents (TDD) based on the BRD and FSDs to architect BI solutions.
  • Develop Mappings; Mapplets & IDQ Mapplets validations and Standardizations and Workflows using Designer and workflow Manager.
  • Conduct Code walk through and Design review sessions with the team and identify the performance bottlenecks to improve deliverables.
  • Analyze the new INFORMATICA products like B2B DX, Data Transformations, Power Exchange, IDQ and efficiently use them in current design.
  • Responsible for source data analysis and Data Profiling.
  • Implement SCD type 1 and Type 2 using DB2 10.5 Temporal table concepts.
  • Involved in preparing and executing unit test cases.
  • Handling defects.

Environment: INFORMATICA 9.5.1, IDQ, Autosys, DB2, Temporal Tables, Modeling, Unix, SQL scripting.

Confidential

ETL Specialist

Responsibilities:

  • Analyze the data flow requirements and develop scalable mappings for staging and loading data.
  • Analyze the Data Mart requirements and accordingly prepare the Semantic solution. Work with Confidential architects to get the sign off on design.
  • Responsible for aligning DI architecture and overall design with Confidential information standards and Phase-End QA checkpoints
  • Work with CAF (Chase Auto Finance) business and technical heads for understand and resolve the environmental dependencies to achieve the CREDIT DATA MART (Auto) completion.
  • Develop Mappings; Mapplets & Surrogate key generation design and Workflows using Designer and workflow Manager.
  • Responsible for source data analysis and Data Profiling.
  • Utilize the extensive experience of Slowly Changing Dimensions Type 1 and Type2.
  • Involved in preparing and executing unit test cases.
  • Handling defects.
  • Provide the functional and technical guidance to Credit Data Mart - Auto Finance and Mortage Banking ETL developers.

Environment: IBM Data warehousing Model, INFORMATICA 9.1, Ab-Initio, TERADATA 13, BTEQ, FAST LOAD, Power Exchange 8.6,Teradata Parallel Processing (TPT), Push Down Optimizations (PDO), DB2, Oracle, IBM Banking Data warehouse (BDW) Modeling, Unix, Control M Scheduling

Confidential

EDI Developer

Responsibilities:

  • Analyze requirement to be implemented and discuss with client for further clarification.
  • Analyze the request complexity and categorize the same along with the LOE preparations
  • Allocate the work to team members and guide them towards completion.
  • Develop the Technical design document based on the business requirements using TERADATA FAST LOAD, MULTI LOAD, FAST EXPORT and T-PUMP utilities.
  • Work on developing the mappings and reusable components to the requirements fulfillment.
  • Develop the Informatica Mappings and UNIX scripts.
  • Generate the extract as per BTRD and share the same with Confidential ’s Client.
  • Fixing the defects logged by the testing team during SIT and ensure the zero defect quality in UAT.
  • Coordinate with onshore and Confidential IT and Business teams to manage end to end delivery and adherence to Service Level Agreements and key Performance Indicators.
  • Responsible for recruiting project staff and functional consultants.
  • Responsible to drive transformation, automation and innovation initiatives within the team.
  • Provide directions to the team and ensure Confidential BI/DX project implements some of the best practices in delivery to improve the efficiency.
  • Responsible to allocate the work to team members and guide them towards completion.
  • Coordinate with Confidential ’s client in case of any clarifications and suggestions.

Environment: WMS scheduling, INFORMATICA, 9.1, TERADATA 13.1, Utilities, TPUMP, MULTILOAD, FAST LOAD, FAST EXPORT, UNIX, BTEQ

Confidential

EDI Developer

Responsibilities:

  • Functional analysis of the system
  • End to End Interface understanding
  • Detailed interaction with client on all the details of the interfaces
  • Understanding the current architecture and proposing the solutions for improvements
  • Design specifications of the documents which get generated for the end Users.

Environment: WID, IBM WebSphere, FROI generation mechanism.

Confidential

EDI Developer

Responsibilities:

  • Analyzed requirements and developed customized solution in EDI module to meet quality management requirements
  • Work with various TPs to understand the B2B transaction requirements and accordingly suggest the improvements on data format.
  • Once boarded, work with TPs right from inception to post production support of their EDI transactions
  • Work on complex supplier transactions and co ordinate with Arrow Business contacts to ensure all data format requirements are met.

Environment: WebMethods 6.5, WebMethods 7.1.1, AS400, Mainframe, COBOL, JCL, CICS, Rossettanet, EDI, EDIFACT and ANSI X12, MS SQL Server 2007Team Size: 15

Hire Now