SUMMARY

• Highly-motivated, quality and detail-oriented IT professional with experience in Informatica development and practical application of the datawarehouse Life Cycle, including analysis and design, application development, and quality assurance testing.
• Worked closely with various database projects, and staff to understand and document datawarehousing requirements, functional requirements, and design specifications for new applications along with enhancements to the existing applications. Researched, created, reviewed, and revised requirements for datwarehousing.

COMPETENCIES

• Seven plus 7 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial, Telecom and Manufacturing Sectors.
• Strong BI tools experience using Business Objects XI R2/XI/6.5/6.0 Web-Intelligence 6.X/2.X, Designer, Info view, Designer, Supervisor, Application Foundation Dashboard Manager, Business Objects Reporting, Cognos Impromptu reports, Transformer, Power play, ReportNet .
• Datwarehouse expertise in OLAP system and OLTP system as well
• Strong experience in analysis, design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 Power Center/ Power Mart Designer, Workflow Manager, Workflow Monitor and Server Manager Teradata and Business Objects.Experience in Ab Initio
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger , Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle SDLC including business requirement analysis, data mapping,data services, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

• ETL Tools: Informatica Power Exchange 8.6, Informatica Power Center 8.1/8.0/7.1.2/7.1.1/7.0/6.2/5.1.2, Power Mart 6.2/5.1.1/5.0, Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, DataStage, Oracle Warehouse Builder OWB , SQL Plus SQL Loader
• Business Intelligence: Business Objects XI R2/XI/6.5/6.0 Web-Intelligence 6.X/2.X, Designer, Info view, Designer, Supervisor, Application Foundation Dashboard Manager, Business Objects Reporting, Cognos Impromptu reports, Transformer, Power play, ReportNet
• Data Modeling:Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5.2/ 3.X Toad 8.0/9.1
• RDBMS: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, SQL Server 2000/ 2005 MS Access
• Programming: UNIX Shell Scripting, SQL, PL/SQL, VB, C, C Java
• Operating Systems: Windows 2000, UNIX AIX, Windows XP
• Other Tools: Aqua Data Studio and Dashboard CDMA

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL developer

• Confidential is one of the full service international cars/trucks carriers. The company utilizes a vast network of ocean vessels, barges, and, motor carriers to link the international shipper with the consignee and also services offered include Intermodal services, terminals and warehousing, dispatching, trucking, as well as repair and maintenances.
• The project responsibility was to develop an Enterprise DataWarehouse EDW . The main responsibilityis to completely integrate the business to single environment. These data warehouse projects are used to access easily the detailed data on a single platform and also to facilitate the enterprise-wide data analysis to Reporting within the business environment. This Data Warehouse built using Informatica Power Center 8.6.1 for extracting data from various sources including flat-files, SQL Plus, and Oracle.

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Develops advanced domain specific technology solutions in multiple work environment
• Extracted data from Oracle as one of the source databases.
• Involved in JAD sessions for the requirements gathering and understanding.
• Involved in the ETL design and its documentation.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-STUDIO.
• Followed Star Schema to design dimension and fact tables.
• Experienced in handling slowly changing dimensions.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Responsible for the development, implementation and support of the databases.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, JAVA, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Used data integrator tool to support batch and for real time integration and worked on staging and integration layer.
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Design, develop and Informatica mappings and workflows Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Scheduled the tasks using Autosys.
• Loaded the flat files data using Informatica to the staging area.
• Created SHELL SCRIPTS for generic use.
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects using Quality Center 10.
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.

Technologies: Windows XP/NT, InformaticaPowercenter 9.1/8.6, UNIX, Oracle 11g, Oracle Data Integrator, SQL, PL/SQL,SQL Developer, ER-win, Oracle Designer, MS VISIO, Autosys, Quality Center 10. Ab initio ETL tool,

Confidential

Software Developer

• Used UML, Eclipse, Struts 2, Spring Framework 2.0, WebLogic, Hibernate 3, Oracle, VSS for the design, development and deployment.
• Developed with C following an Agile methodology. Used Sharepoint, MCMS, IIS, Active Directory and ASP.NET.
• Created and maintained high-traffic content managed intranet and Internet sites for clients including George Wimpey, Laing Homes, Mazda, Jaguar and Land Rover.
• .NET Application and Website Development C , ASP.Net, MCMS

Confidential

ETL consultant

• Designed and created 200 mappings/sessions/workflows to move data from source to reporting data warehouse for complex Cognos Business Intelligence project in credit card processing industry.
• Used Informatica in MS Window 2008 / SQL Server 2008 environment.
• Created standard and best practices for Talend ETL components and jobs.
• Implemented custom Change Data Capture solutions.
• Accountable for documenting, designing and constructing the Extract, Translate and Load jobs that will move data for the Operational Data Store using Talend ETL Platform
• Experience in ETL TALEND tool in designing jobs, database connectivity, transforming and filtering data Implementation of ETL Process using TALEND Tool
• Responsible for ETL development with succ.essful design, development, and integration of components within the Talend ETL Platform and Java Technology
• Perform object oriented design, code formulation unit testing in Java for the business rules required for data validation

Confidential

Senior ETL developer

A data warehouse was developed in line with the business strategy to perform advanced analysis of the customer data to help enhance and offer better service based on their needs. The purpose of the project is to obtain the data about the customers from different regions and different databases and aggregate within the datawarehouse using Informatica Power Center Tool and to analyze data using OBIEE reporting tool.

Responsibilities:

• Responsible to gather and document reporting requirements.
• Understanding the design considerations for creating target tables for optimized and integrated customer and account related data.
• Worked on Data modeling with respect to the business rules, participated in Designing and physical and logical models for the subject area using ERWIN tool.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database. Applied required transformations and created Mappings.
• Implemented Staging Area to improve performance for OLAP and OLTP systems.
• Implemented PL/SQL triggers, stored procedures, functions, packages. Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Designed and Deployed UNIX Shell Scripts.
• Implemented Slowly Changing Dimensions. Created Type1, Type2, Type3 tables for different data backup requirements.
• Scheduled mappings daily, monthly and weekly basis based on requirements.
• Integrated the so developed Data Warehouse to OBIEE administration tool.
• Developed and Designed Repository based on the Requirement, Understanding the design considerations for star schemas/ snow flake schema and its relationships.
• Worked on three layers of the repository at Physical, Business Mapping and presentation layer.
• Created Initialization Blocks, Repository and Session Variables. Implemented persistence
• Aggregation wizard.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in Analytics business model mapping layer.
• Used TOAD for Oracle and SQL Loader to load bulk data in to the Oracle databases.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.

Technologies: Informatica Power Center 8.6.1/8.1.1, OBIEE 10.1.3.4, Oracle Answers 10.1.3.4, Oracle 9i/10g, TOAD, Unix, MS EXCEL, XML, Windows XP Professional.natezza

Confidential

Senior ETL developer

This system includes supplier details, order entry, tracking, shipping information and billing modules. A Data Warehouse was developed to integrate all the related data from different sources, and to integrate OBIEE reporting tool to the so designed Data Warehouse. The system includes a query module to report on product details and product sales. Various analytical and decision support reports like Sales Analysis by regions and Sales by category and period were produced from this system. These reports were used by Senior Management as a means of tracking various sales related activities.

ROLE:INFORMATICAConsultant

Responsibilities:

• Involved in analysis and requirements gathering and translating high-level businessrequirements into logical business dimensional model.
• Created different mappings using transformations, lookup, Round Robin algorithm,
• Stored Procedures, Required Aggregations and populated data from different sources toOracle target Database.
• Integrated the Warehouse to the Seibel Analytics/OBIEE reporting application tool andimported data for Repository development.
• Customized Physical Layer, Business Model and Mapping Layer and Presentation Layer
• using Siebel Analytics Administration Tool.
• Generated Snowflake, Star schemas, and defined Logical relation between them at the
• Business model and mapping layer based of the reporting requirements.
• Created presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized and Formatted Reports and Dashboards
• using Siebel Analytics Web.
• Created Users and Groups and managing the object level and data level security.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Created web-groups for security purpose with access privileges.
• Assigned Data level UI level security to the Users.
• Worked on cache purging strategy.

Technologies: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Oracle BI Server, BI Answers, BIAdministration, BI Dashboards, BI Scheduler, BI Publisher, Oracle BI apps 7.9.5, DAC, Informatica 8.1,Oracle 10g, PL/SQL Windows XP.

Confidential

Data Warehouse /ETL/Informatica Specialist

The project involved understanding of Healthcare Data in the core areas of Claims, Eligibility, Customers and Providers. The main objective of the project was to consolidate the data from various sources for the claims and loading into datawarehouse. INFORMATICA POWER CENTER was used to load data into the data warehouse. The purpose of data integration was for end user reporting.

Responsibilities:

• Involved in analysis and requirements gathering and translating high-level business requirements into logical business dimensional model.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin tool.
• Data integrated different source and target databases like Oracle, MS SQL Server, Teradata, DB2 and Microsoft EXCEL to the ETL tool.
• Created Different Mappings, Mapplets, Worklets applied required Transformations based on Source to Target mapping document specifications.
• Implemented Performance tuning of targets, sources, mappings and sessions using round robin, hash auto key, Key range partitioning.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, and dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created and established different Metadata, and Data load connections while designing mapping and loading data to Target.
• Implemented stored procedures, created sessions, Experienced in Workflow manager, Workflow monitor, Task developer, Debugger, fixing Errors.
• Managed Change control implementation and coordinating daily, monthly releases and reruns by Scheduling tasks.
• Implemented SQL Override in mappings Using complex SQL, PLSQL Logic.
• Data Quality Analysis to determine cleansing requirements.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export. Created various UNIX
• Shell Scripts for scheduling various data cleansing scripts and loading process and terminating process.
• Generated reports using BI tools and Ad hoc reports using Reporting tool querying database.
• Performed Unit Testing and worked with the end user at various stages of the test cycles.
• Technologies:Informatica Power Center 8.6.1/8.1.1, ERWIN 7.1, Oracle 9i,SQL server, TOAD, SQL Navigator,MS EXCEL, DB2, Windows XP Professional.