Sr. Informatica Administrator / Infrastructure Services Engineer Resume
TX
SUMMARY:
- Over 15+ years of IT experience in analysis, design and development and Integration of various Datawarehousing and Client Server Business Applications.
- 12+ years of professional work experience in analyzing and development of Data warehouse/Data Mart applications.
- Extract, Transform and Load of Business Information using ETL tools Informatica, OWB, SSIS, and Datastage with Strong Industrial experience includes Manufacturing, Power Utility, Financial and Telecommunications.
- 3+ years of experience in OLAP/ROLAP reporting tools OBIEE 11g/10g / Confidential Analytics 7.8.4/7.7.1/7.5.3, BO, Microstrategy 7i/6.0.
- Worked with clients/users, business analysts and technical staff to design, develop and enhance data warehouse models, Business Intelligence solutions, procedures and metadata for relational databases.
- Good Experience in creating Data marts / data warehouse (Star Schema / Snow - Flakes) and dimensional Modeling (Kimball Methodology) for OLTP Systems.
- Strong Knowledge in SQL and PL/SQL.
- Knowledge in developing the UNIX Shell Scripts (Bourne and Korn).
- Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, SAP 3.1H, Ms Access, Flat files into a staging area.
- Knowledge in HTML, XML, JavaScript, VBScript.
- Ability to work effectively while working as a team member as well as individually.
- Interacted with Business users to analyze the Business process and made changes to the schema objects according to their report requirements.
TECHNICAL SKILLS:
Methodologies: SDLC, Ralph Kimball and Data Warehouse Methodology.
ETL Tools: Informatica PowerCenter 5.x - 10.x, Informatica BDQ 10.2 Informatica Data Quality 8.6.1 - 10.x (IDQ), Informatica EDC 10.2Informatica MDM 10.x, Informatica DVO 9.x, MS-SSISOWB, MS-SAS,TOAD, SQL*Loader, Oracle Datamart Suite.
Data Modeling Tools: Erwin, SilverRun, Designer 2000 and MS-Visio.
Languages: SQL, PL/SQL, T-SQL, SQL*Plus, VBA, COBOL, JCL, C.
ERP & CRM: Oracle Financials 11i, People soft 8.0/7.5, SAP and Confidential .
Databases: Oracle 9i/ 8i/ 8.0/ 7.x, MS-SQL Server 7.0/6.5/2000/2005, MS- Access, Sybase, Teradata, Netezza, DB2, VSAM and Flat Files.
BigData: Cloudera Hadoop 5.12, Horton Works 2.6
Hardware: Confidential PC Compatibilities, SUN/HP Workstations.
Operating Systems: Ms-DOS, HP-UNIX, Sun Solaris, SCO-Unix, MVS/ESA, Windows
Reporting Tools: OBIEE 10g/11g, Confidential Analytics 7.x, Microstrategy 7i, BO, Cognos.
Other Tools: Developer 2000, VB, TOAD and MS-Office Suite
WORK EXPERIENCE:
Sr. Informatica Administrator / Infrastructure services Engineer
Confidential
Environment: Informatica PowerCenter 10.2 / 9.6, Informatica Data Quality, Data Validation Option(DVO), Informatica Metadata Manager, Informatica MDM 10.1, Oracle 11i, RHELinux, VMWare ESXI 4.1, Windows
Responsibilities:
- Installed and configured Informatica 9.6 in a multi-node environment with web layer components exposed to end users from the separate node other than PowerCenter on RHEL 6.7(64-bit) on VM Ware ESX4.1 in Prod and Sub-PROD environment .
- Done pre-installation checks and spotted the issues with the O/S, various database clients that Informatica communicates with and O/S privileges etc.
- Installed and configured Data Validation Option (DVO) in Sub-Prod environment servers.
- Installed Infomatica MDM 10.2 and Websphere server 8.5.5.1 in both Sub-Prod and PROD.
- Created and configured different services like model repository, Content Management, Data Director, Data Integration, Analyst(previously known as RTM), Data Quality Content etc.
- Responsible for the repository upgrades from previous version 9.6 to 10.5 and also migrations from DEV to TEST, UAT and then to PROD.
- Configured LDAP services to give users access to Informatica services thru network credentials. Also created fewer native users inside Informatica.
- Installed and configured Informatica B2B DataExchange service.
- Did troubleshooting with the relational connections inside Informatica workflow Manager created by other users. Resolved connectivity issues.
- Also created technical document for different installations like Informatica Client, Server, Services, DVO and its Client.
- Worked with address validation licenses and address doctor databases for IDQ Mappings.
Informatica Administrator / ETL Architect
Confidential, FL
Environment: Informatica PowerCenter 9.5 / 8.6.1, Informatica Data Quality, Informatica PowerExchange 9.x, Data Validation Option(DVO), Informatica Metadata Manager, Informatica MDM, Oracle 10g/11i, Teradata 13.10, SQL Server, Netezza, RHELinux, VMWare ESXI 4.1, Windows 7
Responsibilities:
- Created the Technical Architecture and specifications document for the installation of Informatica 9.5 in a grid environment.
- Installed and configured Informatica 9.5 in a Grid environment across two locations (Alpharetta, GA and Chicago, IL) on RHEL 5.6(64-bit) on VM Ware ESX4.1 in Stage environment and on single node in Development environment.
- Done pre-installation checks and spotted the issues with the O/S, various database clients that Informatica communicates with and O/S privileges etc.
- Installed and configured Data Validation Option (DVO) in Development and Stage environment servers.
- Created and configured different services like model repository, Content Management, Data Director, Data Integration, Analyst(previously known as RTM), Data Quality Content etc.
- Responsible for the repository upgrades from previous version 8.6 to 9.5 and also migrations from DEV to STAGE and then to PROD.
- Configured LDAP services to give users access to Informatica services thru network credentials. Also created fewer native users inside Informatica.
- Installed Informatica on cloud based servers for Salesforce application.
- Did troubleshooting with the relational connections inside Informatica workflow Manager created by other users. Resolved connectivity issues.
- Also created technical document for different installations like Informatica Client, Server, Services, DVO and its Client.
- Worked with DVO to run the table pairs validation checks.
DWH Architect / Team Lead / BI Consultant
Confidentia
Environment: OBIEE 10g/11i, Admin Tool, Analytics Web (Answers, Dashboards), DAC, Informatica PowerCenter 9.0.1/8.6.1, Oracle 10g/11i, Unix, Windows XP etc.
Responsibilities:
- Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBIEE administration tool.
- Analyzed technical requirements and used metadata design principles to design repository and followed best practices and Installed and configured OBIEE Server components.
- Extensively worked with variable manager to create session and repository variables.
- Worked with join manager to create physical and logical joins in OBIEE administration tool.
- Created Homepage dashboard and it contains logos to the several hidden dashboards. By clicking the logos, user can easily navigate to the respective dashboard.
- Created several reports including table view, pivot table view and chart view and dashboard prompts and filters in OBIEE answers
- Created several dashboards like scorecard dashboard, top 10 customers, top 10 wins etc.
- Created global filters in the dashboards to avoid excessive data showing up in the dashboards
- Created several dashboards like campaign tracking and advisor dashboard, dashboard pages and links to the reports in dashboard pages.
- Worked on ETL mappings design, development and deployment and server administration.
ETL Informatica Administrator / Team Lead /Architect
Confidential, TX
Environment: OBIEE 10g, Admin Tool, Analytics Web (Answers, Dashboards), Informatica PowerCenter 9.0.1/8.6.1, Oracle 10g/11i, SQL server, Sybase, Unix, Windows XP, MS-Visio, Control-M, Toad, Golden Gate etc.
Responsibilities:
- Installed and configured OBIEE Server components
- Analyzed technical requirements and used metadata design principles to design repository and followed best practices
- Created several reports including table view, pivot table view and chart view in OBIEE answers
- Created several dashboards like scorecard dashboard, top 10 customers, top 10 wins etc.
- Created several dashboards, dashboard pages and links to the reports in dashboard page
- Created global filters in the dashboards to avoid excessive data showing up in the dashboards
- Customized all the dashboards and reports to look and feel as per the business requirements
- Tested and validated reports and dashboards.
Principal DWH Consultant / Team Lead
Confidential
Environment: Informatica PowerCenter 8.6.1, Teradata, Oracle, OBIEE, Confidential, Sybase, Unix, Windows XP, MS-Visio, XML, Appworx, Toad, Golden Gate etc.
Responsibilities:
- Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBIEE administration tool.
- Extensively worked with variable manager to create session and repository variables.
- Worked with join manager to create physical and logical joins in OBIEE administration tool.
- Created Homepage dashboard and it contains logos to the several hidden dashboards. By clicking the logos, user can easily navigate to the respective dashboard.
- Created dashboard prompts and filters in OBIEE answers.
- Extended Analyzed technical requirements and used metadata design principles to design repository and followed best practices.
- Created and developed several business models in business model and mapping layer in the form of star schema.
- Created several reports including table view, pivot table view and chart view in OBIEE answers.
- Created several dashboards like campaign tracking and advisor dashboard, dashboard pages and links to the reports in dashboard pages.
- Customized all the dashboards, reports to look and feel as per the business requirements.
- Created groups and users in OBIEE repository and administered visibility to the presentation catalogs.
- Administered both data level and object level security based on business requirements.
- Tested and validated the repository, reports and dashboards.
- Created design specifications for the creation of mappings and converted business specifications into transformation logic to generate XML files with 2000 records in each.
- Involved in trouble shooting the query performance, mappings, sessions etc.
- Planned informatica workflow scheduling with Shell scripting during development and testing and production.
- Monitored the loads thru
DWH Architect / Datawarehousing Consultant / Team Lead
Confidential, TX
Environment: Informatica PowerCenter 8.6.1, Informatica Data Quality (IDQ) 8.6.1 MS-SQL Server 2005, Oracle 9i, SSIS, SSAS, Peoplesoft, OBIEE, Oracle DAC, Mainframe, Teradata, NDM, ERWin, Sun Solaris, Windows XP, Appworx, Toad etc.
Responsibilities:
- Analyze the source systems data and defined metrics and dimensions for the datamart project.
- Developed data model diagrams for the datamart in Starschema and snowflake using dimensions and Facts with ERWin tool.
- Extensively worked with Business clients to understand the business requirements and to gather the business specifications and also to convert them into tech specification.
- Worked with Project Manager in getting the approval for the test results and also for sign off
- Assign work to the offshore resources and help them in developing the ETL routines with the given tech specifications.
- Documented the Technical specifications for the development and coding efforts.
- Created Data Quality Plans using the workbench of the Informatica Data Quality (IDQ) to standardize the Confidential ’s serviceable addresses and get the open for sale metrics.
- Designed the datamart in Starschema and snowflake using confirmed and local dimensions as well with ERWin and created tables in Oracle Database.
- Worked with Business in getting the approval for the test results and also for sign off
- Created design specifications for the creation of mappings and converted business specifications into transformation logic.
- Involved in trouble shooting the query performance, mappings, sessions etc.
- Planned informatica workflow scheduling with Scheduler during development and testing and thru Appworx in production.
Sr ETL Informatica Consultant
Confidential, NYC, NY
- Environment: Informatica Powercenter 7.1.2, Sybase ASE 12.5.3, Linux - Intel, Windows XP, DB-Artisan, flatfiles, Perforce.
- Worked on the Modelware lite Datamart which has the external companies financial data supplied by the vendor.
- The data is sent by the vendors on a regular basis in flatfiles. The data is loaded into the Sybase ASE DB and is used for reporting thru the front-end.
Datawarehouse Consultant (Informatica)
Confidential
Environment: Informatica 7.1.2, Oracle 10g, Autosys, HP-Unix, Windows XP, Toad, PVCS.
Sr. Informatica Developer
Confidential, Northbrook, IL
Environment: Informatica 7.1, Oracle 9i, PeopleSoft, Oracle Financials 11i, Autosys, Metify, Sun Solaris, Windows XP, Toad, Cognos
Technical Manager
Confidential, Chicago, IL
Environment: ERWin, Oracle Warehousebuilder(OWB) 10g, Oracle 10g, TOAD, Sun Solaris, Windows 2000, Microstrategy 8, Infinium.
ETL Informatica Consultant
Confidential, Sanfrancisco, CA
Environment: Informatica Powercenter 6.1/7.1, Oracle 8i/9i, TOAD, SQL*Plus, Autosys, Sun Solaris, Citrix Metaframe XP and Windows XP/2003.
ETL Informatica Consultant
Confidential, Boston, MA
Environment: Informatica Power Mart 6.1, Oracle 8.1.7, Oracle 9i, TOAD, SQL*Plus, People Soft 8.4, People Tools 8.4, SQR, Peoplesoft EPM 8.8, Control-M, Microstrategy 7.2.2, Citrix Metaframe XP, Windows 2000
Data Analyst
Confidential
Environment: Oracle 8.1.7, Informatica*Power center v 5.1, Confidential 7.5.3, Confidential Analytics, Windows 2000, Snow Flake schema, First logic, Unix, Visio, SQL, PL/SQL, PVCS, Toad and MS-Office