We provide IT Staff Augmentation Services!

Informatica Architect/lead Developer/administrator Resume

Chadds Ford, PA

SUMMARY:

  • 14+ Years of IT Experience in Business Intelligence, Application Architecture & Design, Development, Customization, Marketing, Master Data Management (MDM), Big Data and Implementation
  • Industry experience in Biotechnology, Health Care, Electronic Security, Financials, Insurance, Networking, Manufacturing, Automotive, Telecom, Supply Chain, Transportation, Pharmacy and Brokerage
  • Implemented Ralph Kimball and Bill Inmon Dimensional Modeling Techniques
  • Implemented Methodologies like Agile and Waterfall Model
  • Technical Leadership, Small and Large Team Management
  • Excellent Communication Skills, Technical and Non - Technical at all levels
  • Logical Database Design and Physical Database Implementation
  • Business Intelligence Reporting, Enterprise Data Warehouse and D imensional Data Modeling
  • Business Analysis, Requirements Gathering, Functional Specs and Solution Architecting
  • E nterprise Application Development, Client/Server and M ulti-Tier Architectures, Transaction Processing, Real-Time Systems
  • D atabase Administration and System Management

TECHNICAL SKILLS:

Data Warehouse Informatica: 6.2.2/7.1.2/7.1.3/8.1.1/8.6/9.0.1, 9.1.0, 9.5.1, 10.0.0

DAC: 7.8.2/7.8.4/7.9.5 / 10.1.3.4.1 Siebel

Analytics: 7.8.2/7.8.4/7.9.5

OBIEE: 10.1.3.3/ 10.1.3.4.1 /11.1.1.5. x/11.1.1.6.x/11.1.1.7.x/ 12.2.1.0.0

BI Apps: 7.9.5/7.9.6.3/7.9.6.4, BI Publisher, Visio Professional 2013, Erwin 7.1

CRM/EBS: Siebel 7.x/7.5.x/7.8.x/8.x eSales, eFinance, eBusiness, Call Center, Marketing, eAutomotive, eCommunications, Oracle CRM Public Sector 8.x, Oracle E-Business Suite R12.1.3 AGIS Module , PeopleSoft HCM 9.1, AS 400

OS Windows: 2000/2002/2003/2008/ NT/XP, HP-UNIX 11.x, AIX 5.3/6.1/6.2Oracle Enterprise Linux 5.x, Oracle Solaris 10, Red Hat Enterprise Linux Server 64-bit x86

Databases: Oracle-11g/10g/9i/8i, MS-SQL Server 2016, UDB DB2 8.2, Toad 8.5/8.6.1/9.6.1.1/9.7.2/9.1.0.62, Quest Central 4.8.0.7, Teradata 6.2.2, 15.00, Teradata SQL Assistant 7.2, 15.00 Hummingbird FTP 10

Big Data: Cloud era 5.10, Hue 3.11, Hive 1.1.0, HDFS 2.0, Centos 7.3

Languages: SQL, C/C++, Visual Basic 6.0, Shell Scripting

Web: HTML, ASP, Java Script, XML

PROFESSIONAL EXPERIENCE:

Confidential, Chadds Ford, PA

Informatica Architect/Lead Developer/Administrator

Responsibilities:

  • Gathering Business Requirements or Enhancements to tweak the existing Mappings during the conversion from Pentaho to Informatica
  • Documenting Functional and Technical Design Specs based on the Business Requirements
  • Training the Development Team on Informatica Power Center Version 10.0.0 (Mappings and Workflows)
  • Developing and Executing 198 Tables in total by building both Staging and Target Mappings for Job Control Master, Customer Master, AGGSPEND Vendor File Import, LASH Files and ICS Files
  • Also, build 7 Workflows by breaking them into 18 Worklets by Scheduling them in the required nightly timing by using Informatica Scheduler
  • Doing Performance Tuning for the Mappings where there were Bottle Necks by following the Best Practices
  • Loading data from PeopleSoft Finance, Salesforce, MDM and other Legacy Systems data into MS SQL Server 2014 Tables using Informatica Power Center 10.0.0
  • Converting all ETL mappings of Pentaho 5.0.1 to Informatica Power Centre 10.0.0
  • Following the entire SDLC Process i.e. Development, Unit Testing, Regression Testing, UAT, Production and Post Production Support
  • Was doing On Call Support to Fix Production Issues or Failures
  • Was taking care of Informatica Administration by trouble shooting the system if the services come down or any other system error occurs
  • Resolved the Foreign Characters data issue by replacing the MS Windows ANSI Connection with UTF-8 Encoding of Unicode
  • Setting up ODBC Connections in both (TEST and Production) Informatica Boxes and in all the 4 Environments of Informatica
  • Done the Migration of all the Mappings and Workflows from DEV to TEST, TEST to UAT and UAT to Production Environments

Environment: Informatica 10.0.0, Pentaho 5.0.1, MS Windows Server 2008 R2 and 2012 R2, Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 Bit, Oracle SQL Developer 4.1.5.21, Linux Version 12.1.0.2.0, MS SQL Server 2008 R 2 10.50.6000.34 64 Bit and MS SQL Server 2014, Windows NT 6.1 64 Bit

Confidential, Scottsdale, AZ

Informatica Lead / Big Data Developer

Responsibilities:

  • Gathered Business Requirements, assess, develop Business Intelligence Program Strategies, Design and Implement BI Information and Analytical Solutions for Big Data
  • Prepared Functional and Technical Design Documents based on the Business Requirements
  • Trained all my 7 Team Members to come up to speed on Informatica (Mappings and Workflows)
  • Developed and Executed 400 Tables Approx. by building both Staging and Target Mappings
  • Worked on Hive 1.1.0 by creating Source Tables where the data gets loaded into HDFS 2.0 from AS 400 DB2 Database
  • Done Performance Tuning for the Mappings where there were bottle necks by following the Best Practices
  • Build History Tables, Partitioning by Year in Hive using Hue 3.11 with the new version of Cloud era 5.10
  • Loaded data from Hive Tables into MS SQL Server 2016 Tables using Informatica Power Center 10.0.0
  • Converted Teradata .BTEQ Scripts to MS SQL Server T-SQL Scripts
  • Conversion of Teradata 15.00 Database to MS SQL Server 2016 Target Database
  • Used Impala to query from Hive Tables as and when there were Performance Issues
  • Prepared Sqoop Scripts to pull History Data from Teradata Database to MS SQL Database
  • Prepared all the DDL's for Work, History, Stage, Target and Polybase (Sqoop) Tables to be executed in Hive and MS SQL Database

Environment: Informatica 10.0.0, Cloud era 5.10, Hue 3.11, Hive 1.1.0, HDFS 2.0, Teradata 15.00, MS SQL Server 2016, AS 400 DB2, Centos 7.3

Confidential, Phoenix, AZ

OBIEE Lead Developer/Architect

Responsibilities:

  • Involved in JAR/JAD sessions with Product Owners and Safeway Top Management to Gather Requirements
  • Prepared Prototypes and given Estimates to complete the development work for the future Sprints where the Sprint Life Cycle is typically 2 Weeks
  • Worked with my Team Members along with other teams for the Upgrade of OBIEE from 11.1.1.7.1 40415 to 12.2.1.0.0
  • Worked extensively on Gross Profit Dashboard (Factors and Projections, Period Facility…etc.) reports by building RPD (All 3 Layers) metadata and Web cat
  • Worked extensively with End Users to understand their data needs for Reports, Training, Service Levels and Quality.
  • Designed the Reports Layout to Build 5 Reports in total where 2 Complex, 2 Medium and 1 Simple
  • Worked on both Object Level Security and Data Level Security
  • Done Performance Tuning for the Existing Reports and Dashboards and followed the Best Practices.

Environment: OBIEE 12C ( 12.2.1.0.0 ), Oracle Exadata 11.2.0.4.0, Oracle Linux x bit

Lead Developer/Datawarehouse Architect

Confidential, Milpitas, CA

Responsibilities:

  • Involved in JAR/JAD sessions with Customers to Gather Requirements
  • Build or Modified 15 Star Schemas and 6 Snowflake Schemas
  • Prepared Technical Design Doc ument (MD 070) by coordinating with Functional Consultant
  • Prepared Prototypes and given Estimates to complete entire SDLC
  • Designed ETL and DAC for Data Loads to bring data from 5 Different Data Sources (e.g. Agile PLM, EBS, Demantra etc...)
  • Worked Extensively with the Teams both Offshore and Onsite OBIEE (4 Developers), Functional (1 Consultant), Informatica and DAC (6 Developers) in Development, Testing and Production
  • Implemented Solutions with modeling of conceptual, Logical and Physical data elements.
  • Conducted Interviews for End Users to understand their data needs for Reports, Training, Service Levels and Quality.
  • Designed the Reports Layout to Build 48 Reports in total where 13 Complex, 30 Medium and 5 Simple
  • Worked on both Object Level Security and Data Level Security
  • Prepared Cut Over Master Plan for entire Implementation

Environment: Oracle R12 (12.1.3), OBIEE 11.1.1.7.1 5, BI Apps 7.9.6.4, Informatica 9.5.1, DAC 10.1.3.4.1, Oracle Database Enterprise Edition 11.2.0.3.0, Oracle Linux x bit

Confidential, Princeton, NJ

Informatica & OBIEE Architect/Lead Developer

Responsibilities:

  • Involved in JAR/JAD sessions with Customers to Gather Requirements
  • Involved in preparing the Project Plan with my Delivery Manager by giving the actual time lines be taken to Implement the project successfully
  • Actively coordinated with Functional Consultant to prepare Technical Design Doc ument (MD 070)
  • Upgraded the System from OBIEE 11.1.1.6.4 to 11.1.1.7.1 on a Single Node Environment
  • Setup LDAP Security and worked on both Object Level Security and Data Level Security
  • Build or Modified 19 Star Schemas and 11 Snowflake Schemas for 17 Modules (Learning and Compliance, Global Payroll, Staffing, Standard HR and Talent, Utilization etc...)
  • Worked Extensively with both Onsite and Offshore Teams for OBIEE (8 Developers), Functional (2 Consultants), Informatica and DAC (9 Developers), Testing (8 Testers) for Design, Development, Testing and Production
  • Fully Integrated Oracle HR Analytics into Existing Environment where Existing Integrations are Designed for Cognos
  • Worked Extensively on 15 Data Sources to pull data into Datawarehouse to build 135 Reports and 36 KPIs
  • Designed ETL in such a way to Populate Current and 10 Years of Historical Data to Oracle DHW
  • Educated Users on where to use Export Options for Summary Reports by considering only Excel 2007, PPT 2007 and PDF where as for Drill Through or Detail Reports only Excel 2007 and CSV based on their Usage not considering the Default Options
  • Actively coordinated with Testing Lead and Team Members solving Defects and updated HP QC Tool accordingly
  • Coordinated and worked with the Testing Team to prepare UAT Scripts for User Sign Offs

Environment: PeopleSoft HCM 9.1, OBIEE 11.1.1.7.1, BI Apps 7.9.6.3, Informatica 9.1.0, DAC 10.1.3.4.1 , Oracle Database Enterprise Edition 11.2.0.3.0, Red Hat Enterprise Linux Server 64-bit x86, HP QC 12.01

Confidential, Princeton, NJ

Informatica & OBIEE Architect/Lead Developer

Responsibilities:

  • Involved in JAR/JAD sessions with Customers to Gather Requirements
  • Designed 9 Star Schemas and 5 Snowflake Schemas
  • Prepared Technical Design Doc ument (MD 070) by coordinating with Functional Consultant
  • Prepared Prototypes and given Estimates to complete entire SDLC
  • Designed ETL and DAC for Data Loads to bring data from 7 Different Data Sources
  • Worked Extensively with the Team OBIEE (4 Developers), Functional (1 Consultant), Informatica and DAC (4 Developers) in Development, Testing and Production
  • Implemented Solutions with modeling of conceptual, Logical and Physical data elements.
  • Conducted Interviews for End Users to understand their data needs for Reports, Training, Service Levels and Quality.
  • Designed the Reports Layout to Build 39 Reports in total where 9 Complex, 25 Medium and 5 Simple
  • Worked on both Object Level Security and Data Level Security

Environment: Oracle E-Business Suite R12.1.3 AGIS Module, Informatica 9.1, DAC 10.1.3.4.1, OBIEE 11.1.1.5, BI Apps 7.9.6.4, Oracle 11g, AIX 6.1

Confidential, Herndon, VA

Team Lead/Lead Developer

Responsibilities:

  • Involved in preparing the Proposal Document along with my IT Director and CEO/President
  • Involved in creating Sample Reports by my Team, proposed by the client as a POC from the 4 Modules listed Customer Management, Marketing Analytics, Contact Center Telephony Analytics and Service Analytics
  • Handled a Team of 8 both Offshore and Onsite i.e. 2 ETL Developers, 4 OBIEE Developers, 1 Business Analyst and 1 DWH Admin
  • Used to Upload entire Project Documents in a SDLC form by creating Individual Folders accordingly
  • Used to Motivate and Mentor the Team to Deliver their Assigned Tasks to meet Deadlines by having Daily Status Meetings

Environment: Siebel eAutomotive 7.8, Informatica 9.0.1, DAC 10.1.3.4.1 , OBIEE 11.1.1.6.0, BI Apps 7.9.6.3, Oracle 11g, Windows 2008 Server

Confidential, Novi, MI

Datawarehouse Architect/Lead Developer

Responsibilities:

  • Involved in Signing Up of SOW and MPP plan by the Stakeholders
  • Involved in JAR/JAD sessions with Customers of 6 Sectors to Gather Requirements
  • Handled a Team of 16 both Offshore and Onsite i.e. 6 ETL Developers, 7 OBIEE Developers, 1 Business Analyst, 1 Offshore Team Lead and 1 DWH Admin
  • Used to Upload entire Project Documents in a SDLC form by creating Individual Folders accordingly
  • Build 360 Reports, 9 Score Cards and 875 Mappings to meet the Requirements

Environment: Oracle CRM Public Sector 8, Informatica 9.0.1, DAC 10.1.3.4.1 , OBIEE 11.1.1.5, BI Apps 7.9.6.3, Oracle 11g, Oracle Solaris 10

Confidential, West Chester, PA

Team Lead/Datawarehouse Architect

Responsibilities:

  • Involved in JAR/JAD sessions with Customers to Gather requirements
  • Involved in preparing the Project Plan with my Manager and made necessary changes for the project implementation
  • Actively coordinated with BA’s both On-site and Off-shore for Functional Design Doc
  • Designed Product Complaint, Order, Service Request and Animas Install Base Star Schemas
  • Prepared Technical Design Document, ETL Spread Sheet, Image Suffix, DAC Migration from DEV to Test and Test to Production environments, and Scripts for backend changes, Informatica and DAC for this Release
  • Worked extensively with OBIEE (6 Developers), 2 BA’s (1 On-Site and 1 Off-Shore) and Informatica (4 Developers) Teams for Design, Development, Testing and Production
  • Actively coordinated with Testing Lead and Team Members solving defects and maintained a tracker for reporting status
  • Trained all Informatica Team members as to how the new workflows to be registered in DAC and prepared a document with a sample task by taking screen shots
  • Provided Suggestions or Solutions for the Team Members on the need bases by doing Feasible Analysis

Environment: Siebel eBusiness 7.7, Informatica 7.1.2, DAC 7.8.5, OBIEE 10.1.3.4.1, Oracle 10.2, Windows 2003, Toad 9.1.0.62, MS Visio 2007

Confidential, Jacksonville, FL

Datawarehouse Architect/Tech Lead

Responsibilities:

  • Involved in JAR/JAD sessions with Customers to Gather requirements
  • Worked extensively on Audit Trail, Activity, Revenue, Quote, Quote Item Star Schemas
  • Worked extensively in Informatica, DAC, RPD and Web Cat
  • Extended W DAY D dimension thru 2020
  • Build a new Subject Area called “Audit Trail Others” by building a new star schema
  • Created ADT CC Corp, ADT NA Corp and ADT TCML Security Groups in RPD and Web Cat for specific Dashboards like Core Commercial, National Accounts and Total Commercial Sales
  • Done a POC (Proof of Concept) for Vice President of ADT by creating a Brand new Dashboard called Total Commercial Sales with Sub Dashboards called Total Commercial Sales, Total Business Line, Region, Group, District and Town and explained the differences or advantages of using Drill Downs and Navigation within the Reports
  • Modified and Developed the existing reports and met all Enhancements as and when required for both the releases 2.0 and 2.1
  • Actively participated with the Testing Team by preparing Test Cases for 2.0 and 2.1 Releases
  • Detecting Defects, Opening Tickets by using HP Quality Center and solving them
  • Done Design Documents, ETL Spread Sheet and Scripts for backend changes, Informatica and RPD for Release 2.0, 2.1 (Phase 1, 2 and 3)
  • Done knowledge Transfer to 2 Employees of ADT for Application Maintenance

Environment: Siebel eCommunications 7.8.2.3, Informatica 7.1.2, DAC 7.8.2, Siebel Analytics 7.8.2, Oracle 10.2.0.4.0, AIX 5.3, Windows 2003, Toad 9.6.1.1, HP Quality Center 9.2

Confidential, Schaumburg, IL

OBIEE Architect/Lead Developer

Responsibilities:

  • Involved in JAR/JAD sessions with customers to gather requirements
  • Involved in implementing a prototype model for “OBIEE Integrated Application
  • Installed and configured Informatica and DAC on Unix Environment and OBIEE on Linux servers by coordinating with Navistar Unix Administrators
  • Involved in Gap analysis between the OOTB Informatica Mappings with the current requirements
  • Worked extensively on Revenue, Pipeline, Person, Service Request and Activity Star Schemas
  • Done Data Modeling and created 8 Dimension and Fact extension mappings, 4 Custom Dimension and Dimension Extension Mappings and 3 Auxiliary change capture mappings
  • Design and configured DAC by creating a New Container called “Navistar Sales Container” which involves all the Vertical version of OOTB SDE and SIL workflows and Custom Folder for all the custom workflows
  • Created a separate Execution Plan called “Navistar Automotive Sales” and Scheduled Full & Incremental loads for the Data warehouse
  • Ran 332 OOTB jobs and registered 15 Custom Jobs in DAC
  • Worked extensively on 3 Layers of RPD and build 9 Reports like Forecast Analysis, FSP Trend Analysis etc…

Environment: Siebel eAutomotive 8.0, Informatica 8.1.1, DAC 7.9.5, Oracle 10.2.02, HP-UNIX 11.11, Oracle Enterprise Linux 5.0, OBIEE 10.1.3.3, BI Application 7.9.5, Toad 9.7.2

Confidential, Charlotte, NC

Informatica Architect/Lead Developer

Responsibilities:

  • Involved in JAR/JAD sessions with customers to gather requirements
  • Been an active participant for developing Technical Design Document
  • Used Informatica Tool extensively to develop 58 mappings and created 8 workflows to meet the requirements
  • Some of the source files are brokerage in, pergotx in, pergtde in, perisca in, perktrv in, peroelg in, pergact in, pergcus in, pergmon in and peraccf in which is a weekly fixed length TXT file
  • Created 23 Dimension Staging, 11 Fact Staging, 2 Static, 6 Dimensions and 5 Fact Tables to deliver this project. For e.g. some of them are W TC BRK ACCT D, W TC BRK ORDR D Dimensions and W TC BRK TRDE F, W TC BRK ASSET F Facts

Confidential, Cupertino, CA

Sr. Siebel Analytics Architect/Team Lead

Responsibilities:

  • Involved in JAR/JAD sessions with customers to gather requirements
  • Actively Coordinated with Client Managers and Business Analysts to perform Gap Analysis
  • Been an active participant for developing Functional Design Document
  • Extensively designed and worked on creating Segments, Segment trees and Lists
  • Developed various Subject Areas to meet the reporting requirements, both Adhoc as well as Canned Reports by leveraging the OOTB Subject Areas like Activities, Agreements, Assets, Service Requests and custom Subject Areas like Response Literature Segmentation
  • Worked extensively with Siebel Analytics (6 Developers) and Informatica (8 Developers) Teams by coordinating off-shore for Design, Development, Testing and Production Implementation

Environment: Siebel Call Center & Marketing 7.7, Marketing Analytics 7.8.4, Informatica 7.1.2, DAC 7.8.4, Oracle 9i, Toad 7.6.0.11, Windows 2000 Server

Confidential, SanRamon, CA

Sr.Siebel Analytics Consultant/Lead Developer

Responsibilities:

  • Actively Coordinated with Sales Manager, Development Team and DBA’s to resolve the performance problems of the reports
  • Some of the Dashboards are APU Dashboard, Assign to Upload, GAV Dashboard, Labor Dashboard, Map Viewer, Productivity Dashboard, Server Administration and Summary Dashboard
  • Created ibots for seeding cache and sending Alerts to the users using Oracle BI Delivers
  • Set up entire security for Confidential where all the Users have been divided into three different groups Travelers, Premier and Confidential

Environment: Oracle BI 10.1.3, Oracle 10g, Toad 8.5, MS Windows Server 2003

Confidential, Stamford, CT

Sr.Siebel Analytics Consultant

Responsibilities:

  • Actively Coordinated with SME’s and Director of Marketing to perform Gap Analysis
  • Involved in granting access to the Users where the Users have been divided into 3 different Groups GMS REP, GMS PU and GMS DB
  • Extensively worked on Stage and Production Environments
  • Involved in fixing a SDE and SIL Mapping for the fact table WC ACCNT POSTN F for which caused a data discrepancy in the Territory Reports where the Primary Accounts are shown as secondary

Environment: Siebel Sales 7.8.2, Siebel Analytics 7.8.4, Informatica 7.1.2, DAC 7.8.4, Oracle 9i, Toad 8.6.1, HP UNIX version 11

Confidential, Jacksonville, FL

Sr.Siebel Analytics, Informatica & DAC Consultant

Responsibilities:

  • Involved in JAR/JAD sessions with customers to gather requirements.
  • Actively Coordinated with Business Analysts to perform Gap Analysis.
  • Involved in implementing OOTB security model for various new star schemas developed to meet the business requirements.
  • Developed various Subject Areas to meet the reporting requirements, both Adhoc as well as Dash Board Reports in areas such as Group Sales, Individual Sales, Service, Activity Tracking, Underwriting and Enrollment.

Environment: Siebel eFinance 7.5.3, Siebel Analytics 7.8.2.2, Informatica 6.2.2, DAC 7.8.2, DB2 8.2, Quest Central 4.8.0.7, AIX 6.2, Win XP Professional, Erwin 7.1

Confidential, Sunnyvale, CA

Jr.Analytics, Informatica & DAC Consultant

Responsibilities:

  • Involved in implementing “Full Life Cycle” of the project for “Analytics Integrated” version
  • Involved in gathering requirements with my Team Lead from the Business Analysts, Sales Team, Program Manager and Development Manager of the Client
  • Used DAC and Informatica to load data from OLTP (On-Line Transaction Processing) to OLAP (On-line Analytical Processing) staging and then to the final Data Warehousing Tables for reports
  • Ran 411 OOB (Out-of -the box) mappings through DAC and populated the data in staging and final target tables

Environment: Siebel Sales 7.8.2, Siebel Analytics 7.8.2, Informatica 7.1.2, DAC 7.8.2, Oracle 10g, Toad, Windows 2003 Server

Hire Now