Summary

• 10 years of IT experience with expertise in Analysis Design Development Testing and implementation of Data warehouse Data marts with ETL OLAP Tools using Informatica Power Center v9.x 8.x 7.x Oracle 10g/9i/8i Netezza SQL Server Teradata.
• Ability to analyze source systems and business requirements identify and document business rules design data architecture.
• Extensive Knowledge in Dimensional Data modeling Star Schema modeling Snow-Flake modeling Fact and Dimension tables Physical and logical data modeling using Erwin data modeling tool.
• Worked with Dimensional Data warehouse in Star and Snowflake Schemas created slowly changing SCD Type I/II/III dimension mappings.
• Experience in Performance Tuning of Informatica PowerCenter ETL jobs Oracle/Netezza SQL Queries and stored procedures.
• Experience with the Informatica Data quality and Master Data Management products.
• Designed developed and implemented Master Data Management solution Customer Party MDM Domain using MDM 9.6.1.
• hands-on lead for Informatica IDQ 9.5.4 Analyst IDQ Data profiling IDE Data Discovery IDS for reporting and Developer ETL Application. Performed Informatica server administration work Installations and upgrades. Worked for over three years with Informatica Professional Services team at various client locations. Expertise in using Informatica Webservices HTTP and XML transformations. Working knowledge of Business Intelligence tools Brio Business Objects XI SAS BI DI Studio. Expert in designing most optimized ETL Mapping using Informatica Powercenter Power Exchange. Strong Experience in writing complex SQL Queries PL/SQL stored procedures triggers creating Tables Indexes Views and Materialized Views. Expertise in UNIX shell scripting Windows and UNIX operating Systems.
• Experience in scheduling the batch jobs using workflow monitor DAC Scheduling Tivoli TWS Autosys and FTP methods.
• Strong managerial skills and good experience in managing and coordinating the project and providing project status to the stakeholders of the project and Project Estimates resource loading.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Excellent team player quick learner ability to work and deliver under tight deadlines.

EXPERIENCE

Confidential

• Provides online approval for financing and leasing options at Confidential
• Financial services operations are coordinated by a wholly owned subsidiary of Confidential
• TMC Toyota Financial Services Corporation TFSC which has overall responsibility for the financial services subsidiaries globally. TFS offers its customers financial services that include auto sales financing credit cards retail sales of corporate bonds and investment trusts and insurance.

Project Confidential

BI Analyics.

• Designed and Developed and implemented ETL process for Prod Prof Mart for the TCCI Canada project to track the Total Expenses Subvention / Dealer discount Balance due Amort Term for the Active accounts Payment due.
• The Key tables Loan Master History Retail Monthly Fact Summary Fact Contract Dim Application Dim.
• The Transaction source and the Loan master Files were in cbl mainframe format handled and loaded to the Stage tables by Informatica. Some of the Logic are handled with the Netezza Stored Proc for the business calculated fields. Automate the SPs for Several MonthEnd loads with Informatica Workflow and setting up the Calander Dim for each MonthEnd Load run.
• BI- Analytics prepare the dataset for the Customer Value Model showing expenses amounts from Accounting Mart breakup by Vendor under each Channel by Date By region.
• involved in analysis on Loyalty and Early termination and New Contract Groups from the Customers data from the SERVICE REQUEST table.
• Compute the Cost of Services like Telephone Call expense Count of AutoPay enrollment Pay by Phone Counts from the Services data.

Confidential

Lead Informatica Developer

Confidential is a biopharmaceutical company that designs develops and commercializes novel therapies intended to improve quality of life increase duration of life and resolve serious medical healthcare needs. To identify promising product candidates based on exceptional scientific development and administrational expertise develop products in a rapid cost-efficient manner.

Responsibilities

• As Sr. ETL developer I was working on the SALES and INVENTORY data populating the Dimension and Fact tables using Informatica as tools.
• Requirements gathering from business.
• Prepare Source Target mapping document Process Matrix document.
• Source data was received from different sources for Specialty Health MCKESSON Pharma and ABC in the form of delimited Flat files daily and weekly.
• Responsible for the ETL to take care of the frequency of the Load to the datawarehouse Oracle tables.
• Upgraded Informatica MDM from 9.1 to 9.6.1
• Configured Informatica Data Director IDD in reference to the Data Governance of users IT Managers Data Stewards.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
• Developed business rules for cleansing/validating/standardization of data.
• Developed User Exits for implementing custom business rules.
• Defined System Trust and Validation rules for the base object columns.
• Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
• Created Queries Query Groups and packages in MDM Hub Console.
• Designed and developed multiple reusable cleanse components.
• Configured Address Doctor to Validate Parse Cleanse and Standardize North America Address data. Created and deployed new applications in Informatica Data Director and binding applications to a specific ORS.
• Developed and reviewed configuration documentation and design documentation as well as analyzed functional specifications and user requirement documents.
• Prepare Master data to populate the Dimension tables attributes using lookup transformation.
• Prepare and validate Unix script to validate and FTP files from the Remote Server source directory and call them using informatica.
• Deployment activity from Development to UAT and PROD.
• Code review and incorporate and further changes as needed by the business.
• Automating the workflow run and sending Alert email notification using Informatica.
• Provided technical decision support for the system and business analysts.
• Effectively coordinated between onsite and offshore teams for optimum utilization of the resources and time.
• Environment Informatica Master Data Management 9.6.1/9.1 Informatica MDM Hub Informatica IDD Informatica MDM Workbench Oracle 11g PL SQL HP Quality Center.

Confidential

Confidential is a global company with leading brands that have become household names our namesake bleach and cleaning products manufacture products in more than two dozen countries and market them in more than 100 countries. Informatica HPCC Master Data Management Implementation Dayton OhioProject Role Onsite Business Analyst Lead/Technical Project Lead Master Data Management MDM for 11 Entity Data sets is implemented using Informatica HPCC MDM to provide single unified view of unstructured data by processing the identified Discrepancy from trusted/non-trusted sources via multiple intermediate components Middleware/ETL/Staging Area to MDM repository. Various Data governance Data Profiling Trust Frameworks Match/Merge Cleansing-Name/Address Normalizations de-duplications business rules are applied to create Golden Master records. These records are exported to Product to provide comprehensive view to our customers. Data edits are conducted using a Data Steward UI interface Informatica Data Director.

Responsibilities

• Identify Business Requirements on discussing with various stakeholders Prioritize/Baseline/Track the requirements in Requirements Centre and create wireframe diagrams using MS Visio.
• Drove the requirements gathering process through approval of the documents that convey their needs to management developers and quality assurance team.
• Developed and updated functional use cases and conducted business process modeling to explain business requirements to QA teams.
• System appreciation and Test Strategy document and QC execution Plan.
• Collaboratively Develop ATDD s with examples with engineering and Business users and conducted business process modeling to identify acceptance criteria for requirements
• Ensure Requirements are baselined and signoff by business.
• Review Test Scenarios acceptance criteria documents and test cases through detailed steps developed by Offshore Testing teams.
• Facilitated Daily Stand Up Calls and during Implementation phases
• Reported the status of the project daily weekly and on cycle basis as technical lead of the project during test execution phases.
• Coordinated the UAT and ensured sign off.
• Lead the production release and lead transition to support teams

Confidential

ETL Informatica Team Lead Data Architect

Confidential Information Service North America is a subsidiary ofConfidential companies specializing in IT services. Confidential was formed 7 years ago and is committed to providing world-class technology services to its clients of Confidential Motor companies throughout North America. Responsible for administering and optimizing a pre-existing Informatica ETL environment and providing operational support and develop reliable and complex ETL processes to support maintenance and new development related to Telematics initiative.

Responsibilities

• Responsible for support of business teams in addressing of operational system issues as well as requests for new capabilities
• Integration Manager for different modules in HISNA for Cassiopae datawarehouse for managing Hyundai Leasing and Financing/Daybreak application.
• Develop the design to incorporate new ODS datawarehouse and CRM datawarehouse to Report the Leasing and Financing Information to Credit Bureau companies.
• ETL Integration for the interfaces with near real time datawarehouse like CRM and EDW Enterprise Datawarehouse and source and Target Stage datawarehouse.
• Provide the ETL High and Solution design for different interfaces for inbound and Outbound processes. Designs and implements complex ETL processes.
• Implement the best practices ETL Coding standards and guidelines for the development team and the Database standard naming conventions.
• Requirements gathering with Functional team on reporting Metro 2 format for consumer reports to different Credit Bureau companies.
• Responsible for the operational support of Informatica environment including but not limited to automation job scheduling dependencies monitoring maintenance security and administration
• Implements on-going optimization and tuning of Informatica mappings using database portioning and Partition points within Informatica to run parallel threads for loading source data.
• Supports and enhances existing Informatica environment and develops new complex ETL processes to support additional design development and deployment of the new Telematics capabilities
• Manage Unix scripts to support file transmissions and placing the files in appropriate target locations for external vendors using Control M scheduler which has the functionality of scheduling the batches and capable of doing file transfer to External vendor locations.
• Design and Manage the file validation scripts which are specific to inbound interfaces The credit Bureau files which are received from external vendors.
• Tibco JMS integration with Informatica for Real time updates for datawarehouse.
• Provide presentation on Solution design and Code walkthrough with the Architecture review board to the client.
• ETL design to maintain Common error handling and logging mechanism framework. Prototype for the same was build and is being implemented by the team which captures ETL run error Job status email to the admin and business stake holders and capturing the Etl last run date information.
• Provide guidelines and inputs to Team of developers and module lead to complete development on each sprint of activities on the deadline. Make them understand the functional knowledge and provide them with solution on the business definition on the data mapping activities which is required for them to complete the development.

Confidential

Informatica Team Lead and Integration ETL Architect

Confidential Technology is an enterprise software and security company specializing in secure business mobility. Confidential empowers users worldwide through our Confidential for Enterprise and Confidential for You products and manages a secure world-class network operations center NOC .Confidential Technology s secure solutions work to keep corporate and personal data safe secure and accessible. Confidential Technology s services are used by major organizations including 50 of the Fortune 100 as well as enterprise customers in 90 countries operating on over 200 carriers. Good Technology has partnerships with industry leaders including LG HTC Microsoft Nokia Palm Symbian and leading systems integrators.

Responsibilities

• Manage the team by assigning the ETL tasks on the Mapping and database or the back end related level activities.
• Conduct Daily status/standup meeting with the development and support team to assign new task and prioritize the activities and address the issues in order complete the work.
• Attend meetings with business and get the logic and knowledge on the Functional and Non functional requirement information and pass it to the development team.
• Provided inputs on the High level Solution document and conduct review meeting on getting approvals from the business.
• Handled few complex maps to handle the Hierarchy of customer products like the product code desc Region etc was taken care. Most of the table sources come from multiple Oracle legacy systems.
• Developed and reviewed Informatica maps to design and Load the Revenue data from the Requirements by the client. Informatica Version 9.1.
• The billing and adjustments data load to take care of Incremental ETL data load to the Daily snapshot table.
• Transformations used like Source Qualifier Lookups connected and unconnected lookup Lookup overrides Filter Router Expression.
• Maintain the Informatica coding standards like shortcut Migration and deployment procedures while loading data.
• Unit testing data validations.
• Creating Quality Management Plan Test Strategy Documents.
• Developed and updated functional use cases and conducted business process modeling to explain business requirements to QC teams.
• Schedule the ETL using the DAC Datawarehouse Administration Console scheduler.
• The end result was to develop OBIEE reports in R12 environment taken care by the Reporting team for customer reporting.
• Requirements gathering and working as solution architect for New project requirement on existing design.
• Develop HDL Framework and Logical Solution design doc for implementation of the New project
• Design the server Landing area which is in Unix for the inbound flat file defining file naming conventions defining the sftp process which is handled by control M and Scheduling of Informatica jobs based on the Job frequency as a part of non functional requirement .

Confidential

Sr. Informatica Lead

Description

Confidential is a health insurance and Health care company headquartered in Pasadena CA. It has developed a datawarehouse called Supply Chain Management. The Supply Link project is to build a multi star schema integrated data warehouse to support supply chain reporting needs in an effective and efficient manner. This will be based upon the structure of new OneLink PeopleSoft 8.9 Application and will include SCMDW historic data set and going forward OL data.

Design Summary

With the implementation of One Link PeopleSoft 8.9 software for finance and supply chain integrated Supply Link Data Warehouse will be implemented. It will source data from both SCM DW data sources for legacy data and from One Link. Going forward SDW will be the centralized store of detailed transactional data related to supply chain operations accounts payable purchasing and inventory . For SCM Legacy information SCMDW will be the staging for Supply Link DW and for OneLink Application LinkStage will be the staging area which was implemented. The role also involved loading dimension tables.

Responsibilities

• Involved in enhancement for implementing new regional data roll out. Incorporating additional columns requested by the business.
• Interact with business for preparing the mapping documents.
• Develop the Design documents to incorporate the changes for the enhancement.
• Maintain the Functional Specification Design docs and the Data Model and Mapping documents in the STAR team which maintains the Version of the documents.
• Implementing the Health check remediation process from Informatica coding standard point of view like saving session logs by timestamp eliminating duplicate sources and other performance improvement issues.
• Worked as SME role on requirements gathering on the Supplylink project.
• Provide Understanding on the business requirements to the Development team in US as well as offshore team in India. And Assign tasks and deadlines to each task.
• Manage and coordinate onsite and offshore team. Arrange status meetings.
• Provide status update to the business reporting manager on the project milestones and highlight achievements by the team weekly. Prepare weekly status report.
• Maintenance of data warehouse using data warehouse Administration Console.
• Providing status report on Daily jobs loaded in the target data warehouse.
• Informatica Admin role for doing repository maintenance Code review and Deployment activities. also adding new users and maintaining logon credentials and providing security permissions.
• Code Migration or deployment process setup. Inform stakeholders raise CR and Admins and conduct testing and test cases and test results and close the CR/SR Service Request in Remedy .
• Troubleshooting in case of any production issue on an event of a job failure.
• Status reporting on the ongoing and planned activities with realistic estimates to stakeholders of the project.
• Designed and developed various PeopleSoft objects
• Working as a consultant architect providing High level designs and help in designing the system for the application to support the BI and Supply link data warehouse.
• Generated and analyzed compare reports for QA for UAT testing.
• Update and modify the data model for the project supply link project as per the business requirement. Come up with the Logical and Physical model and implement the changes in the backend.
• Production support through Remedy.
• Prepare template and review the checklist and for the informatica workflows to be triggered using Tivoli scheduler.
• Environment Informatica PowerCenter 9 Oracle 11g OBIA ETL adaptors Tivoli Workflow Scheduler Oracle SQL Developer UNIX Shell Scripting.

Confidential

Sr. Informatica Team Lead and ETL Solution Architect

Description

Confidential is a health insurance and Health care company. It is the largest publicly-traded company focused exclusively on meeting the needs of those enrolled in publicly-funded healthcare programs such as Medicaid and Medicare. A data warehouse has been built for cash reserve calculations customer information sales tracking. The architecture involved moving data from Legacy systems to relational tables in the staging area moving staging data to the Data Mart and finally moving data to the Multi-Dimensional Data Warehouse which is stored in Oracle 10g. The Project Medicare Advantage/Cost Encounter Data Submission MAEDS a part of National Medicare Finance NMF track is build an application KPMETA to process store and track Medicare Cost and Advantage encounter data reportable to CMS Center of Medicaid and Medicare . All input and output encounter data will be in the CCF Claims Centric File format defined by the EDI track. KPMETA will also provide an extract of its encounter and status data to MIA group for reporting and analysis.

Responsibilities

• Collection of data source information from all the legacy systems and existing data stores.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse ETL .
• Involved in designing the process for getting the data from all systems to Data Warehousing system as a architect consultant in the project.
• Gathering all technical and business requirements.
• Design the end to end solution of loading data in data acquisition layer Staging Area and Claims.
• Responsible for designing the end to end process to capture Audit Balance and control information of the end to end project.
• Informatica Admin role for doing repository maintenance Code review and Deployment activities. And add new users and maintaining logon credentials and providing security permissions.
• Maintenance of data warehouse using data warehouse Administration Console.
• Led design and development of End to End ETL solution.
• Create Informatica ETL mappings to extract data from VSAM files and load into staging area.

• Creation of Informatica mappings to read data from different staging areas apply all business rules and load in claims canonical.
• Experience in Design and Development ETL mappings.
• Used aggregator lookup expression stored procedure filter in the mapping.
• Accountable for increasing the performance through identify the bottleneck methods.
• Used Advanced Transformations like stored procedure unconnected and Transformations.
• Hands on experience in Transaction Control Transformation TCL.
• Utilization of Job Schedulers like Tivolli to schedule the jobs using pmcmd command.
• Used Constraint based load technique CBL as advance transformations.
• Data modeling using Erwin to design the Physical and conceptual layer.
• Experience in writing PL/SQL procedures.
• Working as a consultant architect providing High level designs and help in designing the system for the application to support the BI and Supply link data warehouse.
• Managing and monitoring the ETL team of 3 developers and reporting the progress to management. Scheduling daily calls with the Business for QA and Status.

Environment Informatica Power Center 8.6 Oracle 11g Tivolli Workflow Scheduler Oracle SQL Developer UNIX Shell Scripting. Erwin DM Visio.

Confidential

Sr. Informatica Team Lead

Description

This was a Data warehousing ETL scripting project where CLARITY ETL Business information across various Data Source systems would be extracted per different regions loaded into the delimited file extracts for business analysis and reporting. This project extracts data from the WITS regional data source systems and our extract queries run against the Teradata database and created flat file extracts for the Business. There are weekly Full extracts and Daily Increment and Update Extracts. The records are updated using the Hashing function in Teradata.

Responsibilities

• Involved in complete understanding of business requirement and involved in analyzing the sources to load in Oracle warehouse.

• Carry out requirement analysis and Feasibility study.
• Manage Resource loading and Project budget Estimates.

• Designed Sources to Targets mappings from SQL Server Excel/Flat files to Oracle using Informatica Power Center.
• Worked with DBA and Data Modelers for project coordination.
• Responsible for Detail design of each interface.
• Involved in complex Informatica mappings using different types of transformations like UNION transformation Connected and Unconnected LOOKUP transformations Router Filter Aggregator Expression and Update strategy transformations for Large volumes of Data.
• Developed SDE mappings to load large amount of data from different sources to staging area SID mappings for load the data from staging area to target system.
• Implemented slowly changing dimension Type 1 and Type 2 for Change data capture using Version control.
• Created Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Implemented various tasks like Event wait Event Raise and E-mail etc.
• Created Shell scripts for Automating of Worklets batch processes and Session schedule using PMCMD.
• Used Oracle Data Integrator ODI to improve inter-application dialog by having interfaces executed asynchronously.
• Created various Oracle database SQL PL/SQL objects like Indexes stored procedures views and functions for Data Import/Export.
• Tuning the Informatica mappings to increase the performance.
• Wrote test plans and executed it at Unit testing and also supported for system testing volume testing and User testing. Also provided production support by monitoring the processes running daily jobs.
• Performed System testing and unit testing.
• Managing and monitoring the ETL team of 3 developers and reporting the progress to management. Scheduling daily calls with the Business for QA and Status.

Confidential

Module Lead for ETL Team Lead Informatica Developer

Description

This was a Data warehousing project where Business information across various Data Source systems would be consolidated loaded into the warehouse as per a pre-defined Enterprise Data warehouse Model in order to raise the quality level of business analysis and reporting. This project extracts data from various source systems and collates it together in a data warehouse. This data warehouse maintains historical data as well.

Responsibilities

• Involved in Requirement Analysis ETL Design and Development for extracting the data which is stored in different sources like Oracle SQL Server Sybase and DB2.
• Analyzed designed and developed an environment that would facilitate the use of Informatica to transform data coming from Igrasp oltp into Adim data marts.
• Developed complex Informatica Mappings with transformations like lookup router aggregator expression update strategy joiner and etc.
• Created Connected Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions worklets workflows for the mapping to run daily biweekly based on the business requirements.
• Extensively used Parameter files mapping variables in the process of development of the mappings for all the dimension tables.
• Data encryption/masking transformation used as a part of confidential user data implementation.
• Implemented Slowly Changing Dimension type2 methodology in Informatica.
• Worked on handling performance issues of Informatica Mappings evaluating current logic for tuning possibilities.
• Tuned SQL PL/SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings workflows and scheduling workflows through Autosys.

Confidential

ETL Informatica Module Lead OBIEE

Description

This project is to capture all the 837 s coming into care first through Pipeline gateway into Canonical. The first step was to capture 837s from Pipeline into a Data Acquisition DA Layer. The second step is to extract the 837 data elements from this DA layer and store it in the Claims Canonical.

Responsibilities

• Involved in designing of mappings framework and load design architecture.
• Used ETL Informatica to frame load data strategy from source to DWH.
• Manage Resource loading
• Conducting project dashboard activities PMR and Audits from time to time.
• Create Reusable Transformations alter or override default query in source qualifier.
• Design ETL Mappings as the requirement.
• Faster execution of SQL query on windows environment.
• Designed and Developed Oracle PL/SQL procedures performed Data Import/Export Data Conversions and Data Cleansing operations.
• Connecting the software using SAAS application tool
• Used UNIX Shell scripting for automation of the process invoking PL/SQL procedures and Informatica sessions.
• Responsible for performance tuning for several ETL mappings Mapplets workflow session executions.
• Created complex Informatica mappings reusable objects of Mapplets depending on client requirements.
• Used Informatica Data Migration to decrease the risk and minimize the errors.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Writing queries in SQL for checking the Source and Target Tables Row Count.
• Implemented performance tuning logic on Targets Sources mappings sessions to provide maximum efficiency and performance.
• Involved in unit testing and identified new requirements/concerns. Scheduling and rerunning failed jobs as required.

Confidential

ETL Informatica Module Lead Description

The Confidential The Allstate Corporation is the nation s largest publicly held personal lines insurer. The scope of the project is to build Data Marts for business analysis departments such as generation transmission distribution and customer satisfaction.

Responsibilities

• Developed Logical and physical database designs for the transaction system.
• Performance tuning on sources targets mappings and SQL queries in the transformations.
• Created reusable transformations and Mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Created and implemented the Unix shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email Event wait Timer Command Decision Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.

Confidential

Senior ETL Team Lead

Description

The project consisted of providing a financial support system BI project Support and development of Business Intelligence Solution. It included providing Site BI solution to ING Bank Singapore to help the Business user and the IT operations in maintaining banking transaction and Business operations data warehouse.

Confidential

Project Manager Lead ETL

Description Manufacturing Data Integration

To address data requirements and reporting needs of Lilly manufacturing sites nearly 20 sites MI CS has developed MDI Manufacturing Data Integration data warehouse. Data from critical business applications such as ERP Lab Systems and Event Management systems is integrated in MDIProvides Site BI solution to IBO Data Mart to help the manufacturing plants monitor improve efficiency and quality in Mfg operations

Responsibilities

As a Project Lead handling team size of 7 was responsible for the following

• Carry out requirement analysis and Feasibility study.
• Manage Resource loading and Project budget Estimates.
• Conducting project dashboard activities PMR and Audits from time to time.
• Creation and validation of Informatica mapping design document.

Confidential

Senior Developer

Description

VCCA-Project - The Victorian Curriculum and Assessment Authority is a statutory authority of the government of Victoria responsible for the provision of curriculum and assessment programs for students in Victoria State Confidential.

• Business Requirement need and scope of analysis for implementation of the new APS data warehouse.
• Collaborated in the data warehouse front-end and backend design.
• Involved in Reporting requirement gathering and develop new and efficient reporting strategy from the existing reporting system.
• Performed in analysis design and documentation of HLD for Data warehouse.
• Informatica ETL Designer is used for Extraction and Transformation of data from the existing system.
• Environment Business Objects 6.5 SAS BI DI ETL Studio Oracle 10g Relational Rose Data modeling tool SQL Developer.

Confidential

BI Developer Business Intelligence

Description Credit Card System

The Confidential Global Consumer Group businesses comprise the financial service sector s most diverse consumer product offerings banking services credit cards loans and insurance. The company works mainly on industry-leading advanced technology has a strong worldwide presence and is powerful global franchise in Confidential. Confidential is the first financial services company in the U.S. to bring together banking insurance and investments under one umbrella.Confidential

Desktop Support/Developer

Description CRPR - Project

Pacific Oriental Nedlloyd is the world s second largest Confidential Company having an annual turnover of 4 Billion. Global Tracking System GTS tracks Container movement worldwide. GTS receives messages form Message Originators spread across the globe. It validates and tracks these messages and sends them to Internal Container Management ICM System.