Informatica Lead Resume
Boston, MA
SUMMARY:
- Motivated and result oriented professional with a 14 - years of experience in IT with focus on Master Data Management and exposure to various Confidential products - i2- Confidential, Informatica Confidential, TIBCO- Confidential & SAP- Confidential, Teradata-eMDM. Extensive end to end exposure in product development and customer facing IT projects.
- Expertise in Master Data Management ( Confidential ) - Hands on expertise with major Confidential products such as Informatica- Confidential, Stibo Confidential, i2- Confidential /ABPP, TIBCO- Confidential, Microsoft-MDS and SAP-MDMGood knowledge of J2EE, EJB, SOA and Web services
- Experience with TIBCO EMS, Confidential, BE
- Trained in SAP-HANA & SAP- Confidential
- Good Experience in i2/ Confidential products - Confidential, ABPP, BPE Studio, CIS, SRM, Data Modeler, Navigator etc., as a Sr. developer in the Core team
- Good knowledge of PIM for CPG/Retail, CDI and Global Data Synchronization
- Good knowledge of SAP Confidential: Console, Data Manager, Import Manager, Syndicator and Master Data Harmonization
- Complete SDLC experience including functional, requirements gathering, design, development, testing, maintenance and support.
- Experience in development using Core Java, JFC/Swing, Jython, Python, XML.
SKILLS SUMMARY
- Master Data Management
- Technical Support
- Supply Chain Management
- Project Management
- Software Development
TECHNICAL SKILLS:
Applications: i2-ABPP, Teradata- eMDM,, SAP- Confidential, Informatica Confidential, Oracle Customer/Product Hub
Programming: J2EE, Struts, EJB, Hadoop,Hive, Web Services, XML, VB
Scripting: Java Script/Jscript, Python, Jython, VBScript, Perl
Web/App Servers: Weblogic, Websphere, Tomcat
GUI: Java Swing, HTML
IDE: JBuilder, Eclipse, Microsoft Visual Studio
OS: Windows XP/2k, Unix (HP, Solaris), AIX
Databases: Oracle, SQLServer, DB2, MySQL
Version Control: Clearcase, CVS, MKSSI
Project Management: Microsoft Office, MS Project, MS Visio
Testing Tools: Silk Test, WinRunner, Rational Visual Test
PROFESSIONAL EXPERIENCE:
Confidential, Boston, MA
Informatica Lead
Responsibilities:
- Update Party data model, mappings, match rules, cleanse functions etc using console
- Build and modify the Informatica Data Director (IDD) interface per Business Users requirements
- Analyze and Maintain data for 40 different reference data tables/Lookups
- Followup with vendors on product related issues and help resolve
- Configuring various batch processes -stage,load, match-merge etc
- Code Migration & Data loading across different different environments - DEV, QA & UAT
- Identify & resolve data related issues at various stages of data integration - ETL,Landing, Staging,Loading
- Configure Business rules and workflows for process management/approvals
- Using SIF Servives to clean data,register indexes etc
- ActiveVOS workflow confguration
Environment: Informatica- Confidential v10.1, Websphere, IDQ, Oracle
Confidential, Ohio
STIBO Developer
Responsibilities:
- Analyze requirements for new data attribution of Products
- Propose solution for new attributes mapping to old attributes
- Updating Model ( Attributes, Attribute Links, Valid Object Types etc ) using Talend process to read from Excel
- Develop Business rules and workflows for process management/approvals
Environment: STIBO- Confidential, Talend,Excel, Javascript
Confidential, Vancouver, WA
Data Analyst
Responsibilities:
- Architect ETL process for Initial & incremental Load of approx 100 source tables from various sources using BIML, C# to generate SSIS packages
- Develop Data Integraion Hub for various domains - Customer, Vendor, Product, Finance etc.
- Create Data Dictionaries of metadata
- Develop various other SSIS packages for Sales, Finance and other data processing for various downstream BI/Analytics and SAP applications
- Analyse exisitng data and help develop Confidential artifacts
- Gap Analysis and help generate Data for BI & integration with Adaptive Insights, Tableau, Confidential Supply Chain planning etc., Oracle Product/Customer Hub
- Participate in requirements gathering and drive Confidential data strategy using TIBCO Confidential & Microsoft Data Services ( Confidential ) for mastering Product,Vendor,Customer,Bank for BI
- Initial data standardization and quality analysis using Talend Confidential
Environment: Dell Boomi, Talend- Confidential, Microsoft -MDS, TIBCO- Cloud Confidential 8.3x, TIBCO-Business Works, TIBCO-EMS, SQLServer 2012, BIML,SSIS, Excel, BI
Confidential, Dallas, TX
Architect
Responsibilities:
- Participate in requirements gathering
- Enhancement to existing Location Master
- Debug issues in Confidential or Confidential of Location,Equipment or Market Domain(s)
Environment: TIBCO- Confidential 8.2x, TIBCO-Business Works, TIBCO-EMS, Oracle 11g, JBoss 6.x
Confidential, Carlisle, PA
Architect
Responsibilities:
- Participate in process flow analysis and process design along with the Engagement Manager
- Produce a detailed functional design document to match customer requirements
- Produce a technical specification for custom development and systems integration requirements - Data Acquisition, Transformation, Data Cleansing, Data Modeling etc
- Provide current best practice and 3rd Party solution alternatives as part of the functional design document
- Participate in training design, documentation and delivery efforts in concert with the Engagement Manager
- Participate and lead the offshore team to track progress and assist in any solutions needed
Environment: TIBCO- Confidential 8.3x, TIBCO-Business Works, TIBCO-EMS, TIBCO - Active Spaces, Oracle 11g, JBoss 6.x
Confidential, Cincinatti, OH
Lead Consultant
Responsibilities:
- Participate in Production support scrum meetings
- Testing/validating for data received from 1sync as part of the Production Support team
- Testing/validating data loaded into Confidential and its corresponding class hierarchy using GEMS client
- Mentoring developers on the testing process
Environment: TIBCO- Confidential, TIBCO- Confidential, TIBCO-EMS, Unix, Weblogic
Confidential, Buffalo, NY
Lead Consultant
Responsibilities:
- Participate in requirements and design review meetings
- Analyse requirements and propose solution for Initial Load and Incremental data loading process
- Create Logical Model in Confidential Studio and the Physical model in database using Confidential Studio
- Assist in implementing the Match and Merge process using Confidential and Confidential Workflow
- Implement the merge workflow and custom Rulebase function for merging based on precedence
Environment: TIBCO- Confidential, TIBCO- Confidential, TIBCO-EMS, Unix, Weblogic
Confidential, Dalton, GA
Lead Consultant
Responsibilities:
- Facilitated daily scrum meetings
- Participate in requirements and design review meetings
- Mentor developers on development of processes and workflows
- Implement workflow and validations based on a set of parallel/split approval processes
- Debugging and fixing issues in solution
Environment: TIBCO- Confidential, TIBCO- Confidential, TIBCO-EMS, Unix, Weblogic
Confidential, Milwaukee, WI
Lead Consultant
Responsibilities:
- Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the Confidential implementation
- Mentor and provide direction to offshore junior engineers on development, processes, and product architecture
- Participate in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resource
- Create Logical Model in Confidential Studio and the Physical model in database using Confidential Studio
- Application Performance testing with high volumes of data
- Debugging and fixing issues in solution
Environment: TIBCO- Confidential, TIBCO- Confidential, TIBCO-EMS, Unix, Weblogic
Confidential, New Jersey
Lead Consultant
Responsibilities:
- Mentor and provide direction to junior software engineers regarding Confidential platform development, processes, and product architecture
- Responsible for developing custom workflows/processes and validations in Confidential .
- Deployment of HotFixes of the product
- Help the Support team troubleshoot customer issues
- Supported customer go-lives
Environment: TIBCO- Confidential, TIBCO- Confidential, TIBCO-EMS, Unix, Weblogic
Confidential, Bentonville, AR
Data Analyst & Product Integration
Responsibilities:
- Workflow/UI development using ABPP for custom User/Role Management
- Responsible for System Integration and analysis of high volumes of raw data (millions) from SAMS Club’s legacy systems (that existed in various formats)
- Using Java/Python/Jython scripts to prepare raw Product Hierarchy, Time Hierarchy, Stores & miscellaneous data to database loading requirements
- Writing code & helping in code fixes
- Creating sample data of millions of records in DB2 to test aggregation and various other scripts for History data and other analysis, performance testing etc
- Using DB2 Load to load high volume data
- Writing SQL & batch scripts to load formatted data in a form required for loading into final tables
- Installing and maintaining the Hub Servers and Satellite clients on various servers & laptops in SAMS Club environment
- Helping in debugging issues at client site and capturing logs from time-to-time
Environment: .Net, C#, Microsoft Excel (UI), Microsoft Office & Charts, Java, DB2, Python/Jython
