Sr. Informatica Architect Resume
Torrance, CA
PROFESSIONAL SUMMARY:
- Overall 14+ years of Industry and 12+ Years of Informatica experience. Worked on since V5.x till V9.
- Worked various projects like Data warehousing, Data migration, SAP conversion project, LRS projects.
- Extensive experience in Informatica Power Center, PowerConnect/PowerExchange, IDQ and IDE.
- Expertise in all phases of SDLC like Requirements Gathering, Source system analysis, Designing, Implementation, Gap analysis, Development, Testing and QA activities
- Worked on different DBs and utilized DB tools for performance gain during loading and a SME on Informatica Power Center and provided technical support for multiple projects.
- Worked on multiple Data sources including SAP R/3, Mainframe systems, EBCDIC files, COBOL sources, RDBMS, ASCII files, etc.
- Good understanding of DB architecture and worked on many DB objects and written complex SQLs as a replacement to Informatica scripts wherever possible.
- Good knowledge in automation process of Data warehousing loading using PMCMD and Unix scripting.
TECHNICAL SKILLS:
Data Warehousing/ETL Tools: Informatica 9/8.6/8.1.1/7/6/5 (Informatica PowerCenter,, PowerConnect/PowerExchange)
RDBMS: Oracle 10g/9i, TeraData V2R5, DB2/UDB 7.0/6.0, SQL Server 2000, Sybase ASE/IQ.
Programming Languages: PL/SQL, SQL, UNIX Shell Scripting, C.
ERP: SAP R/3, IBM Mainframes.
Tools: & Utilities: TOAD 7.x, SQL Analyzer, Embarcadero Sybase editor, Visio, Erwin 4.0, DAC.
Operating Systems: Windows 98/NT/2000/XP/VISTA, UNIX (Sun Solaris, HP - UX, RS 6000), Linux.
PROFESSIONAL EXPERIENCE:
Confidential, Torrance, CA
Sr. Informatica Architect
Responsibilities:
- Understanding of As-IS interfaces and To-Be interfaces and changes, identifying gaps.
- Writing of requirement specs for To-Be interfaces based on the New ALFA servicing system.
- Documenting Informatica batch interface requirements, TIBCO real-time requirements, MFT file transfer requirements.
- Reviewing of technical design documents in alignment with the approved requirements.
- Reviewing of Informatica mappings, ETL scripts, Test scripts and providing approvals.
- Review and recommend best practices and standards for ODS and batch interface design and mappings development.
- Work with the development team lead for the integrity of the data integration and working across the level for the requirement to final code migration to upper environment.
- Analyze various downstream applications with diverse technologies like Oracle, SQL server, Siebel, Salesforce, custom development applications, etc.
- Devised processes and aligning the development team for smother and efficient code development across the team.
- Involved in the development for the pilot phase of the project and full cutover strategies for various branch/DSSOs.
- Worked on various tools like Informatica power center, IDQ, DA, TDM, etc.
- Involved in performance tuning of long running workflows.
- Raised defects in HPQC for identified ODS Data validation defects.
- Requirement analysis on the Confidential 's requirement document.
- Detailed analysis on PHP calculation and system design requirements.
- Understanding, Analysis and design of Metro 2 format.
- Designed one time load of Active and charge - off accounts of PHP values from Legacy (Lemans/Shaw) source system.
- Involved in the calculation/Recalculation of PHP and merging between the one time loads from legacy to newly calculated PHP values.
- Involved in design of updating the historically derived PHP values and overriding from manual updates from CEP (Salesforce).
- System Requirement review based on the DST output's requirement document for billing statement project.
- Design of billing statements in Informatica power center.
- Development of complex billing statements formats in Informatica power center & UNIX script.
- Reconciliation of statements between the ALFA, ODS and the vendor system (QV) for the correctness of the statement.
- Worked across different teams internally and external vendors for the effective delivery of the statement files.
Environment: Informatica PowerCenter 9.6.1/10.1, TIBCO, Oracle, MFT, SQL Server, Toad, UNIX Scripting. DOORs requirement tool, IR(Integration Repository) data base
Confidential, SantaMonica, CA
Database Management developer
Responsibilities:
- Understanding the existing business model and Atlas data model for the incoming data.
- Designing the develop mapping from source to Atlas Data mart.
- Implementation of data flow from source to target.
- Working with Cognos team to understand the reporting requirements and set expectations
- Enhancing ETL layer object to Cognos for the report development.
- Integration between WAD and DataPassBack (DPB) files.
- Testing the Informatica mappings.
- Migration from DEV environment to QA and then to PROD environment.
- Working with Business users to make the data mart available and usable to them on day to day basis.
- Worked with external vendors for specific brands (XOUT & USTS) data extraction and posting data files in ftp for meaning reports generated by them for the company using customized marketing applications.
- Extracted data from OLTP application using customized client from FOXPRO system and loaded data into staging and then to final data tables using informatica.
Confidential, SantaMonica, CA
Informatica Consultant
Responsibilities:
- Source System analogy for Weblog data.
- Understanding the existing business model.
- Designing the Data mapping from source the Data tables.
- Implementation of data flow from source to target.
- Testing the Informatica mappings.
- Devising SQL to generate the report and circulate to designated DL business users.
- Automation of the data loads and SQL using Informatica scheduler.
Confidential, Irvine, CA
Sr. ETL Developer
Responsibilities:
- Source System analogy for Trackwise system.
- Logical and Physical Erwin Data model development for Landing, ODS and Data mart layer.
- Designing the Data mapping from source the Data mart.
- Implementation of mappings across Landing, ODS and Data mart layer.
- Understanding the Datastage mappings and Business rules for Datastage to Informatica implementation.
- Creation and validation of the incoming source files from external vendor using UNIX scripts.
- Design of Physical DB layer for landing and Data mart stages.
- Implementation of mappings for Landing and Data mart tables. understanding the .NET application architecture and underlying table structure and the metadata of the source system.
- Design the extraction process using the metadata from .NET application.
- Implementation of Informatica mappings for intermediate and final target tables.
- Converting existing source system based complex SQLs into the Data mart based SQLs.
- Documentation for ETL Object Inventory, Source-target column mappings & IQ and OQ process migration documentation.
- Deployment of code to VAL and PROD from DEV with ETL admin team.
- Validating and Attending the defects raised by Test director.
- Production support activities.
Environment: Informatica PowerCenter 9/8.6,Data Stage, Oracle, SQL, Toad, Unix Scripting.
Confidential, Orange, CA
Sr. ETL Developer
Responsibilities:
- Converting Business requirements to technical scripting.
- Implementing Informatica objects, SQL and UNIX scripts.
- Involved in writing generic SQLs for more than 250+ attributes of AGDM.
- Written complex SQLs as ETL scripts for 100% functional coverage & Testing.
- Worked across various teams to understand and co-ordinate the required functionality to Business.
- Performances tuned the existing ETL scripts by optimizing mappings and DB partitions. Covering all the possible scenario exists for the business.
- Created PATCH mappings and modification in existing and new mappings to address the functional defects.
- Provided estimates and implementation plan.
- Provided technical solutions for existing issues/defects.
- Offshore/Onshore co-ordination technically/Functionally and assign tasks.
- Part of the certification team to check and verify the Production data mart’s validation for it’s required functionality.
- Involved in writing Complex validation SQLs for multiple projects which are moved into PROD environment.
- Involved in integrating SQLs in SAS scripts for automated run of certification scripts.
- Managed projects and certification team as a POC.
- Define Auto growth Data mart sourced from FDR- EDW as required by business reporting.
- Reconcile the AGDM reports with the Existing MIS reports for written Premiums and Retention.
- Match and provide required business attributes calculated in ETL and reporting Layer.
Environment: Informatica PowerCenter 9/8.6, DB2 UDB, SQL, PL/SQL, Toad, Unix Scripting, DB2 SQL scripting.
Confidential
Technical Lead
Responsibilities:
- Define various Data marts for areas such as Premium, Claims, Reinsurance and many more subject areas.
- Reconcile with the FINMIS system with various sources for premium and claim.
- Match/Link any new incoming claims into the premium information and evaluation quickly and serve the client better. Currently due to the non-integrated manner, the business is taking too much time with high cost resources and specialists.
- Create a single centralized repository of reports required by business analyst, so that they will analyze more than worry about the technical difficulties accessing data.
- Consolidate various sources of information and into a single data repository as a Data warehouse for the swift product development as a market leader than respond to a competitor for new product development.
- Involved in Requirement gathering & Analysis.
- Managed teams including Data Modeling and Technical Design.
- Technically lead the ETL team and Reporting team.
- Identified required project Standards and implementations of the standards and audit control and balancing.
- Documented the Coding standards and Test cases and test strategy.
- Resource identification and building the team.
- Onshore-Offshore Co-ordination.
- Organized KT with Client team.
Environment: Informatica PowerCenter 8.6.1, DB2 UDB, SQL Server 2000, Toad, Cognos 8.4.
Confidential
Test Lead
Responsibilities:
- Develop various Data marts as required by the Confidential cables.
- Devise strong testing strategy to filter out many an issue during the development projects.
- Documenting the Design, Coding to testing in the identified tool.
- Involved Design Review.
- Involved in Code review in Informatica mappings.
- Involved in devising a effective Test strategy for 100% coverage.
- Involved in Testing and documenting the test results.
- Following Complete cycle in HPQC from releases to requirements, test case, issues, Bug closure and RTM..
Environment: Informatica PowerCenter 8.6.1, Oracle, HPQC, SQL scripting.
Confidential
Informatica Consultant
Responsibilities:
- Achieved SLA for all the supporting projects/Objects and tune.
- Achieved loading time within in the loading windows, since the data has grown over the period of time.
- Documented the recommendation required for the performance improvements.
- Involved in implementing the recommendations with the client team (SDC) and get an approval from them for a new project for these recommendation implementations.
- Analyzed & provided performance tuning recommendations the existing ETL objects.
- Documented and devised implementation strategies.
- Involved in KT with the offshore and SDC team.
- Provided Plan and estimation and expected performance out of the implementation of the recommendations.
Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL, PL/SQL, DAC, Windows.
Confidential
SAP Integration Lead
Responsibilities:
- Design/Develop ETL logic for sourcing SAP R/3 systems.
- Owned the sourcing part from SAP R/3.
- Developed source system analysis on the SAP tables and generated common transformation logic across disparate sources.
- Informatica PowerConnect/PowerExchange used to source from SAP.
- Converting the business requirements to Technical designs.
- Designed ETL components with re-usable components used across multiple related modules.
- Used automation scripts to run off-business hours for data movement.
Environment: Informatica Power Center 8.5, PowerConnect/PowerExchange, DB2 UDB, SQL, PL/SQL, Windows NT
Confidential
SAP Conversion Lead
Responsibilities:
- Design/Develop ETL logic for sourcing from legacy and loading in to SAP R/3 systems.
- Developed complex mappings on cleansing rules using fuzzy logic to cleanse the customer/vendor master.
- Generated outbound IDocs to load into SAP R/3 system.
- Guide the team with the Informatica and SAP integration and Data quality rules applicable to source systems.
- Plan and estimation for the entire project.
- Worked with client SMEs/Senior management and consulted on the Cleansing rule implementation as a technical lead.
Environment: Informatica Power Center 8.5, DB2 UDB, SQL, PL/SQL, Windows NT, iDocs, LSMW.
Confidential
ETL Architect
Responsibilities:
- Architected the new flow replacing the existing data flow.
- Estimated based on the Analogy on the existing objects. Used ADM ( Confidential Delivery Methodology) standard estimators for estimation.
- Planned detailed WBS and resource allocation done based on the available resources and contingency plan for the safe delivery of the project.
- Designed End-To-End ETL design and producing HLD, LLD and coordinated with the client team for the implementation of the same.
- Configured Informatica Environment for the proper management of the Environment and standard processes followed.
Environment: Informatica PowerCenter 8.1, Oracle, PL SQL
Confidential
Informatica Consultant
Responsibilities:
- Contributed for the SME reviews for the project delivery.
- Participated in responding to the RFP with estimation using standard delivery methodology estimators.
- Lead Development teams in developing reusable assets and asset ideas for high performance project delivery.
- Presented and won papers internally to the SME forums.
- Taken trainings technical and behavioral for the new joiners and lateral recruits.
- Improve proficiency with the PDP (Proficiency development plan).
Environment: Informatica PowerCenter 8.1, Oracle, Teradata, SQL server, SQL, PL SQL
Confidential
Informatica Offshore Lead
Responsibilities:
- Upgraded the Informatica V.5 to Informatica 8.1.
- Involved in enhancements on Batch processing
- Rationalized the existing objects.
- Created an Inventory for existing repository.
- Improved manageability by controlling and re-using existing object inventory.
- Involved as an offshore technical lead.
- Technically reviewed and enhancement of various objects from the lower version to higher versions.
- Devised steps for conversion from lower version to higher version.
- Validated and devised testing approach for the converted/Enhanced ETL.
- Also involved in Backups, Running iterative upgradating process, Proper allocation of temp tables and spaces in the ETL repository
Environment: Informatica PowerCenter V 5.x, V.7.2.1& 8.1, Oracle, Unix, Shell Scripting.
Confidential
Technical Lead
Responsibilities:
- Involved in Source system Analogy and produced a Data dictionary for the source system.
- Produced Logical data mapping and data profiling.
- Involved in Designing the R&R Data mart.
Environment: Informatica PowerCenter V 7.1, Erwin, Oracle, Unix, Shell Scripting.
Confidential
Onshore Team Lead
Responsibilities:
- Involved in Understanding the child companies DWH. Environment.
- Generated reports on and above of the two DWH systems.
- Involved in Analogy and identification of metadata for the child company.
- Involved in managing the Onshore Development and Supporting team.
- Design, Development and coordination across teams from provider team to client and then to third party data provider like FDI.
- Data loading plan and implementation.
Environment: Informatica PowerCenter V 7.2.1, Oracle, EBCDIC Files, V-Editor, Cobol,Scripting.
Confidential
Onshore Team Lead
Responsibilities:
- Migrated data from the older application to newer application.
- CBS application is a local one and BBS is a centralized Java application, which has a drastic data model change. Involved in this movement according to Data movement.
- Developed Level information needs to be mapped to Reference data/Master data.
- Involved in Informatica environment standard/Best practices needs to be followed in project environment.
- Involved in requirement gathering, Client discussions, Cleansing and Transformations and rules finalization.
- Reported the Weekly reporting to client manager.
- Test environment and test script generation and test case with data capture.
- DB design, Data migration and reporting and application performance
- Informatica Administration and users/Group management
Environment: Informatica PowerCenter V 7.2.1, Oracle.
Confidential
Technical Team Lead
Responsibilities:
- Involved in Source SAS data sets migrated into Sybase.
- Involved in Re-aligning the existing data for the new Java application
- Lead the ETL team for Data migration with cleansing.
- Involved in Re-modeling of source system into Target model.
- Involved in Requirement Gathering and Analysis and Validation of survey code and Review.
- Lead the Informatica team for re-usable components design and ownership for more than 40 Surveys.
- Involved in migration of surveys and preparation of data mapping sheets, Risk Analysis document, Unit Test cases, Data consistency with the defined data model.
- Coordination with the Java Application team to ensure the single point of understanding as far as the Migration and application development is concern.
- Managed Informatica Administration like managing users/Groups,In Folder creation, Access privileges, Automated Backups, Interface trouble shooting.
- Performed Code review, System testing, UAT and performance tuning in Informatica scripts.
Environment: Informatica PowerCenter V 6.2.1, Sybase ASE 12 & IQ, Windows Batch programming.
Confidential
Technical Team member
Responsibilities:
- Extracted, Transformed and loaded data from site FoxPro files into Target DB.
- Used external loader, Indirect loading Partitions and performance tuning of Informatica scripts.
- Designed Informatica scripts, DTS scripts, Used BO and generated reports.
- Involved in Analysis, Design using DTS with SQL server 2000 and created packages for the monthly transfer activities.
- Maintenance and troubleshooting of data related errors. Responsible for report generation and correctness of Business parameters.
- Regular back up of ISO and SQL Server through SQL queries.
- Performed Code review, System testing, UAT and performance tuning in Informatica scripts.
Environment: Informatica PowerCenter V 5.0, SQL server 2000,SQL Analyzer, VMS.