SUMMARY

• Over 8 years’ experience in Design, Development and Implementation of business applications using ETL Tools (Informatica Power Center) and 3years experience working with BI Tools (OBIEE) for Report Development and Presentation in various domains like Manufacturing and Distribution.
• A seasoned ETL Developer in designing and implementing Data Warehouse applications using Informatica Power Center 9.x (Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Experience in Relational data base systems like Oracle 8i/9i/10g/11g, Sql Server 2000/2005, MS Access.
• Design and develop complex mappings from various Transformations like re - usable transformations and Mapping/Mapplets, Unconnected/connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using stored Procedures, Normalizer, XML and External Procedures.
• Knowledge in Performance tuning of targets, sources, mappings and sessions, Integration of various data sources like Oracle, Flat files and XML files.
• Experience in OLTP/OLAP System study, developing Database schemas like star/snow flake. Dimensional Data Modeling used in relational, dimensional model and slowly changing dimensions.).
• Experience in Informatica DAC Tool for customizing Data Warehouses and creating Task and Task Groups in it and hands on experience in UNIX shell scripting.
• Expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Experience in reporting tools like OBIEE building Dashboards and reports, Physical, Business and Presentation layers.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Expertise in developing Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports) and KPI’s for performance indication.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards.
• Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Designed and developed efficient Error handling methods and implemented throughout the mappings. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks.
• Expertise in developing ETL Strategies using Informatica Power Center and Loading of data from multiple data sources and creating workflows with worklets and various tasks and scheduling them using both workflow manager and Unix Shell Scripts (using pm cmd).
• Ability to define project technical requirements, documenting and communication for conversion into robust system designs.
• Unique combination of personal, analytical, technical and communication skills.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Generated various Analytics Reports like Formulary Report, Union Report.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x (Power Center)

Databases: Oracle 11g/10g/9i/8i,MS SQL Server 2005/2008

BI/Reorting Tools: OBIEE

Query Tools: SQL, PL/SQL, SQL*Plus, and TOAD

Languages: SQL, UNIX Scripting, PL/SQL

Data Modelling: Relational and Dimensional Modelling (Star Schema, Snow-Flake schema, Fact, Dimensions)

Operating Systems: Windows 2003/XP/7/8, Unix

PROFESSIONAL EXPERIENCE

Confidential - Savannah, GA

Senior Informatica/OBIEE Developer

Responsibilities:

• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Demonstrated expertise utilizing ETL tools, including Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the processes using UNIX shell scripts.
• Developed new reports and customized Financial Analytics OOTB reports.
• Customized out of box Dashboard pages like Sourcing Trends, Revenue, Customer, Backlog, Shipping Performance, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain, Procurement and Spend Analytics.
• Customized OOTB Informatica mappings for financial analytics based on the business requirements.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Worked on performance tuning (Both Database and Informatica side) and thereby improving the load time.
• Created Dimension hierarchies to achieve the drill down functionality.
• Worked extensively on BMM (Business Model and Mapping) layer to capture the changes.
• Responsible for documenting all the mapping changes in the Physical Layer /Business Model / Presentation Layer of a Repository.

Environment: OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3(Financial, Oracle Applications R12.1.3, Informatica9.X, Oracle 11g, TOAD, windows 7, SQL Developer

Confidential, MD

Informatica Developer

Responsibilities:

• Gathering requirements, preparing understanding document and constructing a design document detailing the changes and sharing the details with offshore team.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
• Designed the target Data Warehouse using Star Schema, Involved in Extraction, Transformation and Loading (ETL) Process
• Extract data from different Data marts for creating strategic Reports
• Designed and developed mappings using Source Qualifier, Aggregator, Joiner, Lookup, Sequence Generator, Expression, Filter and Rank transformations
• Involved in creating various metadata types, including legacy source and data warehouse target data definitions and ETL jobs
• Worked on multiple Data bases and have good knowledge of Oracle Schema’s and it’s functionality.
• Implemented mapping for slowly changing dimensions (SCD) to maintain current data as well as historical data
• Created reusable Transformations and Mapplets and used them in mappings in case of reuse of the transformations in different mappings
• Created parameter files with workflows and sessions
• Configuration of Teradata Load / Unload Utilities with Fast Load, Multi Load.
• Tuned mappings to perform better using different logics to provide maximum efficiency and performance
• Developed PL/SQL Packages, Procedures and Functions accordance with the business requirements.
• Identified Bottlenecks and executed Performance tuning
• Extensively used PL/SQL programming by using oracle10g/11g in backend and front end Functions and Procedures, to implement business logics / rules
• Used Unix Shell script for Oracle to automate the server start and shutdown process
• Executed Daily and Monthly reports in UNIX and automated the scripts using shell script,.
• Created new extracts for external vendors and use Informatica ETLs for new workflows to move data out of multiple data sources.
• Unit test coding changes, fill out required documentation such as installation instructions, and follow standards and procedures.
• Provided Tier l support duties for Informatica Production Support, including off hours and weekends. Keep the Production Support team management informed of any issues or concerns. New development and support task responsibilities.

Environment: Informatica Power Center 8.6.1/8.1.3 , Oracle 10g, SQL Assistant and Administrator, XML, UNIX Shell Scripting

Confidential, Madison WI

Informatica Developer

Responsibilities:

• Interacted with business users and business analyst to understand reporting requirements and prepared system requirement specification document.
• Worked with Reporting team to get to an agreement on what level of complexity to be handled by ETL and reporting side.
• Experience in developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Identifying and Removing Bottlenecks in order to improve the performance of Mappings and Workflows.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.
• Designed Incremental loading process to load data into staging tables.
• Actively contributed in framing the Data Warehouse SDLC standards, methodologies and best practices.
• Developed shell scripts for Informatica pre-session, post-session scripts.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Wrote DB2 scripts for implementing in the production databases.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Carried out unit testing, systems testing and post-production verification.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Developed a UNIX Shell scripts which will send the reports to client over the network by using file transfer protocol (FTP) and generating the log file, which will keep the history for the FTP reports.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Worked on test cases and use cases.

Environment: Informatica Power Center 8.5/8.1, Web intelligence, Oracle 9i, SQL/PL-SQL, DB2 8.0, Flat Files, Windows XP, UNIX Shell Scripting, Sql*Loader.

Confidential

Oracle PL/SQL and Network Admin Developer

Responsibilities:

• Installed, configured, troubleshot and maintained network and computer failures.
• Supported end-users with connectivity problems and hardware failures.
• Built, configured and installed Microsoft NT Servers, created user accounts.
• Created and monitored and maintained user accounts on the Network.
• Understanding Requirements as defined in Functional and Business Requirement documents.
• Wrote complex SQL queries using joins, co-related subqueries & inline views to retrieve data from the database in order to meet some of the complex requirements for reporting purposes and performance tuning the queries.
• Adhering to plans, schedules and attending team meetings.
• Creating database objects like Tables, Views, Sequences, and Stored procedures, Functions, Packages, Cursors, Ref Cursors and Triggers.
• Preparing Program Specification and Unit Test plan documents for the development of assigned modules.
• Involving in Code review, Unit Testing, end to end testing and tracking of defects to closure.
• Maintaining the Code repository in Version Control tools like OrbiVault.
• Participating in system integration, debugging and troubleshooting of the application.
• Fixing and tracking of end users business issues in Production environment.

Confidential, MD

Electronics Test Technician

Responsibilities:

• Confidential designs, manufactures and sells dense wavelength division multiplexing systems for long distance fiber optic telecommunications networks. (NASDAQ: CIEN).
• Responsibilities:
• Performed alignment tests and calibration on communications modules for signal reception and transmission quality.
• Identified and repaired failures
• Conducted extreme weather and atmospheric test simulations on communications modules.