SUMMARY:

• 12+ years of professional work experience in D Confidential warehousing and D Confidential Analysis, design, development and Implementation of Business Intelligence solutions using D Confidential Warehouse/D Confidential Mart Design, ETL and Reporting on Windows/UNIX platforms and have extensively worked as Informatica/DAC Admin.
• Expertise in Upgrading Informatica9.1 to Informatica9.6.1/10.1
• Expertise in Automation of Restoring Repository from PROD backups without losing any d Confidential .
• Expertise on Automation of Repository backup which would run daily.
• Experience in Installation, Configuration, Patching, Upgrading and administering OBIEE 11g, Oracle BI Applications (OBIA) 7.9.6.x, DAC 10g & 11g and Informatica 9.x in Windows, UNIX environments.
• Experienced in Informatica, DAC code migrations over different environments, patch management and fixing development issues with reports / dashboards.
• Well versed with the D Confidential base and D Confidential Warehouse concepts like OLTP, OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling and ETL.
• Expertise on Activating LDAP security to pull Informatica users from Active Directory.
• Excellent organizational skills and ability to prioritize workload.
• Attention to detail and precision, solid work ethics concerning meeting deadlines and reliability.
• Installing and upgrading DAC the scheduling tool.
• Much familiar in writing UNIX shell scripting.
• Expertise in Disaster Recovery and Business Continuity planning and testing with both Informatica and file Transmission and have a smooth running of ETL jobs without any issues.
• Conceptual knowledge in d Confidential transformation tools like ODI and Informatica Power Center 9.x.
• Good Understanding of Informatica Power center (versions 9/8.x), OBIEE 11g Mappings, Transformations, Workflow Manager, Workflow Monitor, Repository Manager.
• Worked on customizations in existing custom mappings and experience in creating new mapping using Informatica power center.
• Experience in configuring Informatica servers and different d Confidential sources (like., OLTP, OLAP, Flat file, Confidential, DRM etc.).
• Have created execution plans as per business requirement using DAC 10g/11g client tool.
• Proficient in Relational D Confidential base Management Systems Oracle.
• Good programming skills in SQL, PL and SQL, TSQL, C, C++, Java.
• Good skills in testing tools like QTP, Quality Center.
• Good Skills in Version controls tools like DollarU, Subversion and Team foundation Server, Jira
• Proficient in MS Office Suite especially Access, Excel and Outlook.
• Good skills in assisting project related problem and having good experience in Client Interactions.
• Good knowledge of Testing Methodologies.
• Superior communication skills, strong decision - making skills, organizational skills, and customer service oriented. Excellent analytical and problem-solving skills, client relations and negotiations.
• Working Knowledge in Big D Confidential .

TECHNICAL EXPERIENCE:

ETL:

• Installation of informatica on Linux servers.
• Installation of IDQ, PE10.2, DIH
• Created folders, Migrated Versions, Queried Metad Confidential and fixed many admin challenges.
• Worked in Confidential in ETL using power exchange, golden gate and informatica logics using MD5.
• Design, develop, standardize, and review of Informatica ETL mappings
• Developed ETL design standards and performance tuning guidelines
• Design complex ETLs involving various transformation such as XML, Loaders & Webservices
• Use of Power Exchange for connectivity to disparate source & target systems
• Maintaining reusable objects such as mapplets and transformations in global repository
• Scheduling programs using scheduler such as Autosys, DAC, Cronjob & Maestro etc.
• Work exp. in Big D Confidential participated in POC.

Tools: Informatica Power Center 9x/8x/10.2, DH, Informatica D Confidential Quality, D Confidential Stage, Power Exchange, PLSQL, Hadoop, Talend and Tableau

Business Intelligence Reporting:

• Expertise in Installation of OBIEE on Linux servers.
• Extensively worked as OBIEE Admin and web logic Admin
• Developed various UNIX scripts to automate the deployment process using Python.
• Used Active Directory authentication and SSO implementation
• Administration and deployment for publisher
• Expertise in debugging issues in OBIEE and interact with Oracle Team.

Tools: OBIEE, Cognos

D Confidential base:

• Extensive experience in various d Confidential bases
• Taking D Confidential base Backups using RMAN, expd/impdp
• Creation D Confidential base and monitoring of D Confidential base
• Expertise in OEM maintenance and monitoring
• Extensively used loaders utilities Bulk loader, B-TEQ, Fast Load, MultiLoad, FastExport
• Performance tuning using appropriate Indexes, Partitioning, Aggregate storage, MVs etc.
• Exceptional understanding of inheriting, casting and converting PL/SQL objects
• High proficiency in developing Oracle PL/SQL packages

D Confidential bases: Oracle11g/12g, Terad Confidential, DB2, Sybase ASE/IQ, SQL Server, MS Access

Tools: TOAD, SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Admin, Plano, Texas

Responsibilities:

• Installed and Upgraded Informatica from 9.5 to 10.2/9.1 to 9.5 and 8.6 to 9.1 on all three environments.
• Installed Repository service, Integration services, Web services, Reporting services, Model repository service,
• D Confidential integration, Analyst service and content management services on Informatica v10.2.0/v10.1.0/v10.1.1/v9.5.1.
• Installed and configured Informatica MDM Hub serve, cleanse server, resource kit in development, QA, PreProd and Prod Environments.
• Create ODBC connections, Terad Confidential connections, oracle connections and Hadoop, Salesforce connections.
• Have good experience as Informatica Administrator in creating domains, repositories and folders, applying hotfixes and updating to new versions
• Good experience in maintaining Informatica environment in Linux SuSE 10/11 and Unix AIX 5.3/6.1 environments.
• Maintained ODBC and Oracle TNS files on Informatica servers for connectivity to different d Confidential bases like oracle, SQL Server, Sybase and Terad Confidential .
• Good experience in maintaining Oracle, ODBC connections and installing and maintaining various new d Confidential base connectivity software and Informatica plugins for respective software.
• Have good experience in integration of various d Confidential sources like DB2, Oracle, Terad Confidential, SQL Server, Flat Files, XML files and Mainframe files into the staging area and then into the Warehouse and Marts

Environment: Informatica Power Center 9x/8x/10.x, DIH, PE10.2 Oracle11g/10g, SQL, PL/SQL, Autosys, UNIX Shell Scripting, TFS, HP Quality Center, OBIEE 10g/11g

Confidential

Informatica Admin, San Antonio, Texas

Roles and Responsibilities:

• Working as Sr Informatica Administrator
• We started an POC project to migration ETLs and Reporting to BigD Confidential, so have work exp in Talend, tableau.
• Migration of Informatica Env from Physical to Virtual Linux Env.
• Expertise in planning the upgrades for informatica from lowers to higher versions.
• Work experience in Confidential using powerexchange, Golden gate and Informatica using MD5.
• Expertise in upgrading the Domain to point to RAC d Confidential base.
• Upgraded Informatica from 9.0.1 to 9.6.1 and then to ODI
• Expertise taking Repository backup through Unix scripts
• Restoring the Repository thru automated Unix scripts.
• Implemented LDAP security to pull users from Active Directory instead of manual creations.
• Security Migration from PROD to Lower Env
• Automation of Linux script to re-start Informatica on Weekly basis.
• Working as L4 support with an on-call Rotation.
• Enhancing of UNIX shell scripts to create an interface to automate the ETL loads.
• Scheduling the DAC and monitoring the schedules.
• Carry out comprehensive testing and test plan for changes in system.
• Coordinated and helped other developers in the team to their development tasks.
• Coordinate offshore development and production support team members.
• Production support of developed application.
• Involved in documentation which includes preparing requirement document, estimation and approach document for change request.
• Have good experience as Informatica administrator in creating domains, repositories and folders.
• Enabling Active Directory LDAP security.
• As Informatica Admin and have Developed UNIX Shell scripting for Informatica server maintenance, and scheduled ETL load using utilities like Autosys and $Universe
• Used rsync tool for synchronizing d Confidential between two environments.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

Environment: Informatica Power Center 9x/8x, Oracle11g/10g, SQL, PL/SQL, Autosys, UNIX Shell Scripting, TFS, HP Quality Center, OBIEE 10g/11g.Hadoop, Tableau, Talend.

Confidential, Jacksonville

Informatica Admin

Responsibilities:

• Responsible Installation of Informatica and OBIEE Servers on Linux Servers.
• Automation of Linux script to re-start Informatica and OBIEE Services on Weekly basis.
• Creation of Linux scripts of automation script to deployment RPD and xml files.
• Developed complex Informatica mappings, Mapplets using connected and unconnected Lookups,
• Rank, Sorter, Joiner, Aggregator, Filter, Router, Sequence generator and Stored Procedure transformations to transform the d Confidential as per the client requirements.
• Working as L2 support dur
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow mapping for insert/update using effective end date while loading d Confidential into the d Confidential marts.
• Prepared various mappings to load the d Confidential into different stages like staging1, Staging2 and Target tables.
• Extensively used Mapping parameters, mapping variables to make mappings more flexible and minimizing hard coding in ETL logic.
• Requirement gathering from Specs, Users and direct interaction with the Confidential Clients.
• Conducting analysis and descending for implementing the Confidential project development phases.
• Enhancing of UNIX shell scripts to create an interface to automate the ETL loads.
• File transmission automation and monitoring of the files at the stage location and alerting the technology for the files coming inside and going outside of the BOFA using UNIX shell scripting.
• Responsible for preparing the migration and deployment scripts for SIT, UAT as well as Production environments.
• Scheduling the Autosys jobs for various Confidential ETL.
• Carry out comprehensive testing and test plan for changes in system.
• Coordinated and helped other developers in the team to their development tasks.
• Coordinate offshore development and production support team members.
• Production support of developed application.
• Involved in documentation which includes preparing requirement document, estimation and approach document for change request.
• Dealing with performance tuning, Informatica bottlenecks, SQL related issues and resolving the issues with Oracle 10/11g as to cope up with con-current process and to make it faster.
• Involved in production support activities, providing support, addressing and Resolving Client Issues.
• Have good experience as Informatica administrator in creating domains, repositories and folders.
• Enabling Active Directory LDAP security.
• As Informatica Admin and have Developed UNIX Shell scripting for Informatica server maintenance, and scheduled ETL load using utilities like Autosys and $Universe
• Used IDR tool for synchronizing d Confidential between two environments.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

Environment: Informatica Power Center 9x/8x, Oracle SQL, PL/SQL, Autosys, UNIX Shell Scripting, TFS, HP Quality Center, OBIEE 10g/11g, OBIEE

Confidential

Responsibilities:

• Gathering requirements from Onsite team.
• Participating in telephonic conversation with Confidential 's partners and vendors to meet day to day deliverables
• Involving in Design/Implementation of Products track
• Developing ETL objects, D Confidential base objects.
• Deploying the development objects to QA with all the necessary approvals
• Maintaining design documents, Business Requirement documents, and Production issue logs/statistics and uploading to Confidential 's Live link for easy sharing and maintenance
• Interacting with DBA people in case of production deployments, environmental problems and emergency
• Adherence to Quality procedures as per Confidential 's IT standards
• Prepare the Test cases for the Unit testing
• Conducting impact analysis of the specifications provided by the clients
• Preparing Low Level Designing
• Coding based on the Specifications provided by the Client and according to the checklist
• Testing application (Includes the Unit Testing and Pre Integration Testing)
• Reviewing the work done

Environment: Informatica 8.1.1, UNIX, Windows NT, Terad Confidential SQL Assistant, TOAD 7.6, $ Universe (Scheduling Tool)

Confidential

Responsibilities:

• As an ETL developer, handled the following:
• Design Analysis.
• Developed DDL scripts and ETLs for WSH, TAC Center and TAC Center Line dimensions.
• Unit testing of the ETLs developed.
• Support testing (TCC/TCD).

Environment: Informatica 8.1.1, Windows 2000 Professional, Oracle Warehouse Builder 9.2, TOAD, and SQL *Plus.