SUMMARY

• Over 11 years of IT experience in Software Development, with specialization in 6 years of Data Warehousing and ETL Implementations using Informatica Power center 9.5/9.1/8.6.1
• 5+ years of Oracle Business Intelligence Enterprise Edition (OBIEE 11g) experience, OBIEE Rpd Development, OBIEE Rpd Development
• Experience in all activities related to the development, implementation and Production support of ETL processes for large - scale data warehouses using Informatica Power Center.
• Thorough knowledge of Data warehouse concepts with complete hands-on experience in conceptualizing designing, building and building Enterprise Data warehouse from multiple source systems using Informatica Power Center
• Varied experience in Designing and developing the complex mappings by using various Transformations like Source Qualifier, Joiners, Aggregator, Routers, Filters, Expressions, Lookups, Sequence Generators, Update Strategy etc.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations. Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience in creating Sessions and Workflows by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle, SQL Server and MS Access.
• Good experience in creating and using Stored Procedures, Functions, Triggers, Views and packages in Oracle database
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, Slowly Changing Dimensions and data ware housing concepts.
• Experience in Scheduling the workflows using Data warehouse administration console(DAC) Scheduler
• Expertise in slowly changing dimensions type 1 and type 2 to maintain the history of records.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Worked extensively on OBIEE Admin Tool involving all the layers namely Physical Layer, BMM Layer and Presentation Layer
• Extensive experience in OBIEE Presentation Services including Answers, Interactive Dashboards, Delivers/iBots, Cache Management, Scheduler Configuration.
• Excellent aptitude in translating high level business requirements into logical business dimensional model, building business models, configure metadata, Answers, Delivers/IBOTS, Creating reports/Dashboards, Cache Monitor.
• Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules and Aggregate Navigation, Time Series functions etc.
• Skilled with Caching and Mapping, data-level and object-level security, Integration Variables/Initialization Blocks configuration.
• Highly skilled in building Interactive Dashboards with drill-down and drill-across capabilities using global and local filters, Business Rules with User Identity and Roles, Profiles and Personalization.
• Very good with implementing the Oracle BI Security Setup (Groups, data access/query privileges), Metadata Objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboards, Pages, Folders, Reports).
• Practical understanding of the Data Modeling (Dimensional and Relational) Concepts like Star Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Strongly motivated, enjoy team work and capability of mentoring others and learning new skills.
• Excellent writing, analytical and communication and interpersonal skills.
• Practical understanding of PL/SQL and Oracle SQL.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/8.x/7.X/6.X (Repository Administration Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor)

Data Modeling Tools: Data Mart, Dimensional, Snow Flake, Star Schema, CA Erwin, Microsoft Visio.

BI Tools: Oracle’s BI Analytics 10g, 11g, BI Publisher, MS word, Excel, SQL Navigator.

Databases: Oracle 11g, 10g, SQL Server 2000/2005/2008, MS Access

RDBMS Utilities: SQL Server Query Analyzer/ Enterprise Manager

Applications: MS Word, MS Excel, MS PowerPoint, MS Outlook

DB Tools: Oracle SQL developer, Toad, SQL* Loader

Scheduling Tools: Control - M, AutoSys, Tivoli and Active Batch.

Operating systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, MD

Informatica Developer

Responsibilities:

• Prepared TSD and ETL Specification documents based on BSD and Mapping document.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement the business logic.
• Extensively worked with flat file sources to read data and write the data into the flat files.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Extensively worked with various Active transformation like Filter, Sorter, Aggregator, Router, Lookup, Joiner and Update Strategy transformations
• Extensively worked with various Passive transformations like Expression, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Involved in team meetings with Data Modelers, Data Architects and Business Analysts to analyze and resolve the modeling issues and to discuss requirements.
• Involved in in production support and code migrations from DEV to SIT, SIT to UAT and UAT to PROD migrations.

Environment: Informatica Power Center 9.x, Oracle 11g, Windows 2008 Server, SQL*PLUS, UNIX, TOAD.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Architects and DBAs.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored their work status daily.
• Worked on Informatica tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Developed Informatica Type-1 and Type-2 Mappings based on the requirements.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Marts.
• Involved in Mapping, Session and database level optimization techniques to improve the performance
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and session tasks.
• Extracted data from Flat files and Oracle and loaded them into Oracle.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on WLM Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development environment

Environment: Informatica Power Center 9.5.1, Oracle 11g, Teradata, UNIX,PL/SQL,SQL Developer, Putty, AutoSys, HP ALM

Confidential, Arkansas

Informatica Developer

Responsibilities:

• Effectively handled the Production Support by performing normal loads, initial loads, daily loads and monthly loads.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting during the job failures.
• Extensively worked on Performance Tuning at the mapping level, session level, source level, and the target level for the mappings which were taking long time to complete.
• Extensively worked on handling production defects and change requests.
• Analyze source data for potential data quality issues and created the exception mappings/clean up scripts to clean up the bad data in data warehouse.
• Built many reusable components in informatica, like mapplets, worklets, reusable transformations and User Defined Functions.
• Built deployment group for informatica components for migrating the code from lower region to higher region.
• Wrotecomplex SQL queriesto retrieve information from the databases depending on the requirement and also for data cleanup process.
• Created a shell scripting in UNIX platform for running Informatica workflows, updating the Parmfiles, sending emails and the FTPing the Files.
• Used the EPS Scheduler to schedule the jobs and to set the job dependencies.
• Worked on Waterfall methodology

Environment: Informatica Power Center 9.1.0/8.6, Oracle 11g/9i, TOAD, Congo's, UNIX, Windows XP

Confidential

Informatica Developer

Responsibilities:

• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Architects and DBAs.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored their work status daily.
• Worked on Informatica tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Developed Informatica Type-1 and Type-2 Mappings based on the requirements.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Marts.
• Involved in Mapping, Session and database level optimization techniques to improve the performance
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and session tasks.
• Extracted data from Flat files and Oracle and loaded them into Oracle.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on WLM Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development environment.

Environment: Informatica Power Center 8.6.1, Oracle 11g/10g, DB2, WLM, UNIX, Windows XP

Confidential, Canton, MA

OBIEE RPD Developer

Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the necessary tables and creating physical joins/key on the existing tables
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features.
• Used simple to complex analytical SQL queries against the source databases to identify and analyze the authenticity of the data before importing to build the OBI repository.
• Identified the appropriate facts, metrics, hierarchies, and territories to structure the initial conceptual model of the business from the requirement documentation.
• Created dimension hierarchies and assigned levels for each level.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs
• Add disparate sources to business model objects
• Add time series calculations (for example, percent change in a measure compared to same period in previous year).
• Experience in building and deploying an OBI repository (Physical, Business and presentation model) to create Dashboards, answers, ibots.
• Model aggregate tables to speed processing.
• Build calculated measures for the fact tables
• Identified granularity level of the Financial data required to be available for analysis
• Created security settings to setup object and data level securities
• Performance tuning on the Dashboards and Answers
• Train business users
• Proficient in using the time-series functions to support historical time comparison analysis.
• Experience in using OBI answers to run queries to test and validate the repository.
• Use the query log to verify query results and debugging issues if any.
• Enable cache for specific tables on the physical layer
• Create alias tables in the physical layer to be used for complex star schema dimensional modeling.
• Create data and object level security as per requirement for the different users.

Environment: OBIEE 11.1.3., BI Publisher, Oracle 10g, Windows, Oracle 11g, Flat Files, Windows.

Confidential, Arkansas

OBIEE DEVELOPER

Responsibilities:

• Meet with business representatives, business analysts and end users to understand the business needs, business models and functionality.
• Built the physical, Business Model and Mapping and also Presentation layers of the repository.
• Created dimension hierarchies and level based measures, built time and calculated measures of a fact table.
• Used BI answers to run queries, test and also produce reports and validated the repository.
• Customized data modeling of scorecards using department metrics and KPIs.
• Worked extensively on performance tuning including creating aggregate tables. Caching and event polling tables.
• Tested and modified OBIEE security for the internal controls environment.
• Enhanced performance tuning using SQL Developer and SQL statements.
• Analyzed, designed, implemented and documented BI specifications incorporating OBIEE development standards and best practices.

Confidential, Maryland

OBIEE Report Developer

Responsibilities:

• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.
• Created drill down charts and drill down tables to gather more information according to business requirement
• Designed Intelligence Dashboards and created Global Filters.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Using Selections, Groups and calculated items to manage analysis results
• Participate in the definition, design, development, configuration, deployment, verification testing and support of the OBIEE reports.
• Create custom KPI and scorecards to meet business requirements and objectives
• Participate in design and code reviews, documentation of design, and implementation of methodologies to ensure high quality deployments.
• Train client staff in using OBIEE
• Administer presentation catalog objects and permission using user and roles.
• Add Named filters to analysis
• Combine analysis using set operations and Modify and Format views.
• Create master detail links between views.
• Add column selector and view selector to an analysis
• Use prompts to filter dashboard data
• Embed contents in dashboard
• Build and use charts (add features like scale markers and sliders on graphs) in analysis and dashboards.
• Add conditional formatting in reports and also include legends and narratives to describe the state of the various conditions.
• Use hierarchical columns in analysis and dashboards
• Build calculations using formulas and functions on reports.
• Use Repository, session and presentation variables on reports and dashboards.
• Add contents and pages to a dashboard
• Build reports with BI Publisher using various data sources.
• Add contents to briefing books

Environment: Oracle Business Intelligence, SQL server, Oracle, Microsoft SQL Server, Windows.