SUMMARY

• Offering 7 years and 6 months of IT experience in developing BI Applications Using Informatica 9.x/8.x, Oracle, Unix, Shell and Perl scripting,PL/SQL and OBIEE 11.x/10.x
• I have 6 years experience on pl/sql such as stored procedures, packages and have 6 years experience on Linux/UNIX environment such as shell scripting and Perl scripting.
• Very good knowledge on Oracle EBS 11.5(Supply chain) as System Administrator and code migration tools such as HP PPM (Kintana), clear case and scheduling tools like DAC (Data Warehouse Administration Console).
• Diverse experience in Telecom Domain.
• Very Good knowledge on Informatica IDQ.
• High working experience with Informatica PowerCenter transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with varied sources and targets like relational tables, flat files, XML Editor, VSAM files, XLS, Salesforce etc. Strong knowledge on administrative tasks with Integration Service, Repository Manager and Admin console.
• Excellent skills in working with UNIX shell scripts. Developed shell scripts for feed file integrity checks, FTP activities and commands like ftp, scp, find, grep, pipe, cut, redirection and utilities like awk and sed.
• Knowledge on dimensional modeling techniques like Star and Snowflake schemas.
• Designed and developed EDW, DM and Data Quality Systems for prestigious clients Confidential, Confidential .
• Strong in performance tuning of complex SQL queries
• Involved in detailed Analysis, design, development, maintenance and upgrading systems to support business operations.
• Created and Used Workflow Variables, Session Parameters and Mapping Parameters
• Experience in Creating Tables, Views, Indexes, Synonyms, Constraints, Procedures, Shell Scripting, FTP and Perl Scripting.
• Expert in Informatica PC and PA Repository Metadata Queries
• Strong in Database concepts like SQL, PL/SQL, Procedures, Functions, Triggers, Advanced PL/SQL programming, Data warehouse and Dimensional Modeling concepts
• Very flexible and can work independently as well as in a team environment
• Involved in Preparing HLD,LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation
• Helped Infra in migrate code into different environments
• Very good in developing, Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports OBIEE 10/11g and ETL.
• Extensive experience in building business models & analytical repository - - RPD (Physical Layer, Business Model & Presentation Layer), configuring metadata, Answers, Delivers/ iBots,Dashboards, Security Setup, and Web Catalog Objects using Oracle Business Intelligence
• Identified and tracked the SCD tables
• Experience with Level 2 production support, involving resolution of issues escalated to development team
• Shares learning and coaching experience through knowledge transfers between personnel.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5.1/8.5.1/6. x,Informatica IDQ.

Business Intelligence: OBIEE 10.x/11.x

RDBMS: Oracle 11i/10g/9.x/8.x.

Design/Application: ERwin, Microsoft Visio (Visio Soft Diagram), TOAD, SQL Developer, PL/SQL developer.

Languages/Scripting: UNIX, PL/ SQL, UNIX Shell Scripting and Perl scripting.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling.

Operating System: Sun Solaris, UNIX/LINUX, MS-DOS, Windows 2008/2007/ NT/2000/XP

ERP: Oracle EBS Supply Chain.

Other Tools: HP-PM(Kintana),Toad,SqlDeveloper,Winscp,Putty,ClearCase,ERWIN,sitescope and BAC(Business availability center)

PROFESSIONAL EXPERIENCE

Confidential, Horsham, PA

Informatica Lead/Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications
• Lead the development team and co-ordinate the projects among the developers
• Developing Informatica mappings and workflows for extracts and feeds. Data is extracted through mappings from different sources like Relational database tables, XML files, etc.
• Designed ETL processes for optimal performance.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse
• Created Parameter files to pass database connections, parameter entries for source and target
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic
• Implemented Target Load Plan and Pre Session and Post Session Scripts
• Created test cases and test scripts to validate data.
• Review the detail level design and ensure that the IT standards are followed
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like staging and target tables.
• Best use of METADATA in Informatica to reduce the manual effort.
• Involved in building subject areas and OBIEE reports as per the customer specifications.
• Involved in fixing the issues from OBIEE reports perspective after upgraded from 10 to 11 versions.
• Tuned the performance of complex Informatica mappings and database.
• Worked with cross functional teams to resolve the issues.
• Created slowly changing dimensions & Fact tables to meet the business requirements.
• Used the debugger in Informatica to test the mapping and fix the mappings
• Worked on various lookup caches like static, dynamic and persistent
• Created the ETL best practices and mentored other team members.
• Scheduling of Informatica Jobs, Infa code Migration using Kintana and clear case.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing.
• Performed data validations for ETL end and reporting end as well.
• Created deployment documents, Informatica install instructions, etc.
• Created SQL Server ODBC connections in Informatica workflow Manager.
• Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.
• Performed root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.

Environment: Informatica Power Center 9.5, Oracle 11g/pl-sql, OBIEE 11.1.1.5, Windows, Linux.

Confidential, Chicago, Illinois

Informatica Lead/Change Manager

Responsibilities:

• Created database objects such as tables,views,stored procs,functions in Oracle
• Involved in ETL design, coding, testing and implementations.
• Designed ETL processes for optimal performance.
• Created test cases and test scripts to validate data
• Tuned the performance of complex Informatica mappings and database.
• Worked with cross functional teams to resolve the issues.
• Created slowly changing dimensions & Fact tables to meet the business requirements.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Performed data validations.
• Created Informatica XML and Install documents.
• Presenting Demos to business users about SAS reporting tool and monitoring SAS ETL jobs.
• Developed various reports based on business requirements using SAS EG(Enterprise Guide)
• Created SQL Server ODBC connections in Informatica workflow Manager.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
• Performed Root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues.
• Handling the Security Administration for Oracle EBS and code migrations using kintana/clear case.

Environment: Informatica 8.6, Oracle 10g, SAS 9(Statistical Analysis System), Windows, UNIX,kintana,clearcase and Oracle ERP.

Confidential

IT/ETL Developer

Responsibilities:

• Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.
• Interpreted and comprehend business/data requirements from upstream processes
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
• Created and documented source-to-target mappings and ETL specifications.
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Created scripts for FTPing files, data manipulation and validations.
• Designed and performed all activities related to migration of ETL components between environments during development and deployment (Eg. Dev to SIT, SIT to UAT and UAT to PROD repositories).
• Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency.
• Created slowly changing dimensions tables to meet the business requirements.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document.
• Involved in the defect analysis call for UAT environment along with users
• Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor.
• Prepared the UNIX Shell Scripts to process the file uploads, one of the SOURCE for the data that process the uploads into different stages (Landing, Staging and Target tables)
• Involved in the repository administration like backup and restoration process when required.
• Supported the applications in production on rotation basis and provided solutions for failed jobs.
• Actively attended the production support calls and pagers at all times and answered the business questions.
• Prepared the recovery process in case of workflow failure due to database issues or network issues.
• Developed the reports using SQL in Servigistics application and scheduled the reports as per business requirement.
• Involved in Informatica power Center up-gradation from version 6.2.1 to version 8.1.1.
• Worked with site scope and BAC applications team to integrate the system availability for alert mechanism.

Environment: Informatica 6.x/8.1.1, Servigistics, Oracle 10g, Windows, UNIX.