PROFESSIONAL SUMMARY:

• 7+ years of IT experiencein Analysis, Design, Development, Implementation, Testing and Supportof Data Warehousing Informatica and Cognos applications.
• Extensive experience in all the stages of Data warehousing and Cognos 7x/8 BI.
• Experienced in data extraction and loading from and into flat files, Oracle and Teradata Tables.
• Have extensively worked in developing ETL’s for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in Using Repository Server/Manager, Designer and Workflow Manger, Workflow Monitor Tools in Informatica Power Center .
• Experience in preparing and running Sessions/tasks, Work Flows in Informatica Server.
• Developed OLAP applications using Cognos suite of tools Cognos Impromptu, Cognos ReportNet / Cognos 8BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), PowerPlay, Transformer.and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
• Strong understanding of relational database design concepts.
• Good exposure in Relational Databases(Oracle, MS SQL server, DB2 and MS Access) for modeling and for supporting analytical and reporting needs of Corporate Business needs
• Knowledge of Sales & Marketing, Finance, Accounting, Inventory within Service/ Trading/ Manufacturing business domains.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

SOFTWARE KNOWLEDGE:

Operating Systems: Windows, UNIX , Linux
Database: SQL Server 2005/2000, Oracle 10g/9i/8i, MySQL, MS Access.
ETL: Informatica PowerCenter 5.x/6.1/7.1/8.x
Modeling: Framework Manager, PowerPlay Transformer
OLAP/BI Tools: Cognos 8 Series and Cognos 7 series
Languages: Java, HTML, XML, PL/SQL.
Web/Apps Servers: IBM Web Sphere 4x, Sun iPlanet Server 6.0. , IIS , Tomcat
Tools: TOAD, Visio, Eclipse

PROFESSIONAL EXPERIENCE

Confidential,Chicago, IL March 09 to present
ETL Developer

Description:
Allstate is one of the fastest growing Auto/Property/ life insurance company. It serves its customers by offering a range of innovative products to individuals and group customers at more than 600 locations through its company-owned offices.

The primary objective of this project is to capture different Customers, Policies, Claims , Agents , Products and financial related data from multiple OLTP Systems and Flat files. Extracted Transformed Loaded data in to data warehouse using Informatica Power centre and generated different reports to Sales managers, Business Development managers , Insurance agents & HR Deportment using Cognos BI Tools on daily ,weekly,monthly,yearly basis .
Responsibilities:

• Worked in team environment in finalizing the Data Warehouse modeling.
• Identified the facts and dimensions and designed the relevant dimensions and fact tables.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Involved in design, development and maintenance of database for Data warehouse project. Designed the ETL processes using Informatica tool.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, Sequence generator etc.,
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Analyzed data with discrepancies through Error files and Log files further data processing and cleansing
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Cognos Developer July08 to March 09
Responsibilities:

• Interact with the Business users for requirement gathering.
• Created packages according to the company specifications using Framework Manager.
• Published Framework Manager Packages to the Cognos Connection.
• Set up the reporting infrastructure to effectively group reports to use Query or Report Studio as per functionality, user and security requirements.
• Created reports using Metric Studio provides Metric data sourced from PowerPlay Transformer
• Involved in setting the Cognos8 users, groups and security on Cognos8 packages.
• Created a simple HTML report template to get an idea on amount of time it takes for each report to run.
• Followed Cognos8 best practices to optimize the Cognos8 reports performance which includes Oracle database.
• Applied techniques and modeling approaches to minimize SQL generation.
• Created Ad-hoc reports using Query Studio.
• Created complex reports using Report Studio.
• Created corporate templates using Report Studio.
• Expertise with union joins, master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, bursting reports, crosstab, multi-query reports & charts.
• Defined dimensions, levels, categories and measures.
• Developed the Cognos Impromptu query definition (.iqd) files that will feed Cognos cubes.
• Involved in the design, development and implementation of PowerPlay Cubes.
• Used extensive conditional formats for highlighting the critical data.
• Created dashboards for performance management, information is consolidated and arranged on a single screen.
• Experienced in writing PL/SQL code to support report development.
• Troubleshooting and fixing errors in Cognos8, impromptu7.x ,PowerPlay and other existing reporting tools.
• Involved in Designing and developing multi-dimensional model (Star Schema) using Erwin
• Designed and developed ETL process.
• Involved in Designing and creating mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Maplet Designer &, Transformation Designer.
• Used all Transformations such as Expressions, Filters, Joiners, aggregators, Lookups and Routers, to load consistent data in to database tables
• Informatica Server Manager used to create database connections, sessions, batches to run the mappings.
• Prepared documentation of Informatica ETL implementation.
• Scheduled Reports on weekly basis.
• Closely worked with Data Warehouse designers to refine data and metadata.
• Conducted end-user training.

Environment: Informatica 8.6 (Repository Manager, Source Analyzer, Target Designer, Work Flow Manager, Work Flow Monitor), Cognos 8.4 (Report Studio, Analysis Studio, Query Studio, Metric Studio,Event Studio), PowerPlay Transformer, Active Directory Server, Oracle 9i/10g, SQL Server. MS Office 2003/2007, UNIX.

Confidential,San Jose , CA Jan 07 to July 08
ETL Developer

This position requires implementing data warehouse for Forecasting, Marketing, Sales performance reports. The data is obtained from Relational tables and Flat files. I was involved in cleansing and transforming the data in the staging area and then loading into Oracle data marts. This data marts/Data warehouse is an integrated Data Mine that provides feed for extensive reporting.

Roles and Responsibilities:
Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 7.xSource Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.

Environment:
Informatica 7.x (Power Center), Oracle 9i, Windows NT.

Confidential,Newark, NJ March 05 to Jan 07
Cognos Developer

Prudential Financial companies serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S. These companies offer a variety of products and services, including mutual funds, annuities, real estate brokerage franchises, relocation services, and more. Involved in the development and implementation of goals, policies, priorities, and procedures relating to financial management, budget, and accounting. Analyzes monthly actual results versus plan and forecast

Responsibilities:

• Involved in Cognos migration projects: From Impromptu 7.3 (Catalogs) to ReportNet Created Cognos ReportNet Framework Manager models to support reports development.
• Created list, summary, cross-tab, repeater and drill through reports in ReportNet Report Studio and Query Studio.
• Involved in administration, development and support of existing & new Catalogs and query definition files using various joins and filtering conditions using Impromptu administrator.
• Provided technical support and administration for the existing Cognos PowerPlay Cubes.
• Implemented and administered different levels of security and report bursting, using Cognos ReportNet, Access Manager.
• Involved in designing the Risk Metrics model using Cognos Metrics Designer
• Developed and implemented the security in Catalogs by defining filters on user classes to control data access to the tables, etc, and Transformer models by creating user class and dimensional views.
• Designed and developed financial cubes, models and reports with PowerPlay Transformer, and ReportNet Framework Manager, using Oracle database as the source.
• Developed numerous sophisticated drill-through PowerPlay and ReportNet reports.
• Involved in intensive end user training (both Managers and business users in Report studio and Query studio) with excellent documentation support.
• Involved in providing production support and troubleshooting of ReportNet and PowerPlay Transformer environments.

Environment: Cognos ReportNet 1.1 MR2, Framework Manager, Cognos series 7.x, SQL Server , Oracle 9i, Win 2000

Confidential,Dearborn, MI April 05 to Feb 06
Cognos Developer

The Oakwood Healthcare System serves 35 different communities in southeastern Michigan with over 40 primary and secondary care locations. Responsibilities include working with the clinical analytics team on the measurement of provider performance, quality improvement initiatives, and various ad-hoc requests. The reports are created, distributed and published using various Cognos BI tools like ReportNet, Impromptu, Power Play, IWR, and UpFront to the end-users. The application had OLAP features like Drill Down analysis, Multidimensional analysis, Prompts, Exception Highlighting and User Privileges.

Responsibilities:

• Developed models in Framework Manager.
• Published packages and managed the distribution / setup of the environment.
• Used Query Studio for creating Ad-hoc Reports.
• Created complex and multi-page reports using Report Studio
• Performed migration from Impromptu to Reportnet.
• Used Schedule Management in Cognos Connection.
• Performed Bursting Reports and Multilingual Reports using Report Studio
• Developed Layout, Pages, Object Containers and Packages using Report Studio.
• Created reports using ReportNet with multiple Charts and Reports.
• Responsible for assigning user Sign-Ons for the new users.
• Provided guidance to report creators for enhancement opportunities.
• Created Multidimensional Cubes using PowerPlay and published on the UpFront Portal using PowerPlay Enterprise Server.
• Developed PowerPlay Cubes, used multiple queries, calculated measures, customized cube content and optimized cube creation time.
• Fine-tuned the Cubes and checked the database space issue and cube growth periodically.
• Responsible in the creation of new User Groups and User Classes using Access Manager.

Environment: ReportNet 1.x (Frame work manager, Cognos Connection, Report Studio, Query Studio), PowerPlay, Impromptu, PowerPlay Transformer, , Oracle9i and SQL server 2000.

• Confidential,Chicago, IL May 04 to March 05
• Data Warehouse Developer
• The aim of this project was to support Business Executives to take quick decisions. Project involved in developing Enterprise Subject Data warehouse to implement a centralized database that collects and organizes and stores data from different operational data sources to provide a single source of integrated and historical data. Responsible for the design, development and implementation of Cubes and Reports for Sales Tracking.

• Designed the ETL processes using Informatica to load data from DB2 Oracle, SQL Server, Flat Files, XML Files and Excel files to target Oracle Data Warehouse database.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Used workflow Monitor to monitor the performance of the Jobs.
• Developed Pre-Session and Post-Session UNIX scripts to automate the data load processes to target Data warehouse.
• Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department
• Created Cubes for multi dimensional analysis using PowerPlay Transformer.
• Created Multi-Dimensional reports using PowerPlay.
• Designed and developed multi dimensional cubes.
• Created Catalogs and assigned joins as per the requirements.
• Worked on Exception Highlighting, Sorting and Ranking.
• Generated the reports using Cognos Impromptu by querying the data from different tables from the database as per the requirements.

Environment: Informatica 6.2, Cognos Impromptu, PowerPlay Transformer, PowerPlay Enterprise Server, Upfront, Access Manager, Windows NT/2000, ORACLE 8i, DB2, SQL Server 2000.

Confidential,Bridgewater, NJ Nov 03 to April 04
ETL Analyst

Aventis is a Pharmaceutical company, which provides new and improved biotech drugs for various diseases and their symptoms. The objective of the project is to extract data stored in different databases and load into oracle system which is the staging area and the business logic is applied to transform the tables in the required way. The data warehouse is fed by marketing data, sample data, market (competitor) data, prescription data and others.

Responsibilities:

• Extensively used ETL to load data from Flat Files, XML, Oracle to oracle 8i
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created, launched & scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
• Used Server Manager to schedule sessions and batches.
• Involved in creating Business Objects Universe and appropriate reports
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

Environment: Informatica 6.2, ORACLE 8i, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, TOAD Quest Software

Confidential,Bangalore, India May 02 to Oct 03
Oracle Developer

Core project focused on designing and implementing scalable solutions that would support the company\'s continued dramatic growth, under girded by the corporate data warehouse.

Responsibilities:

• Developed Oracle PL/SQL packages, procedures and functions
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis
• Used Oracle Warehouse Builder to implement changes to the operational data store, as well as create data marts
• Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs
• Involved in supporting and maintaining Unix shell script jobs

Technical Details: Oracle 8, PL/SQL, Windows 98

Education

• Masters in Business Administration with the specialization of Management Information Systems
• Post Graduate Diploma In Computer Applications.

Certifications:
SCJP 5.3 Sun Certified Java Professional