Power Center Sql Server

Ramu Ketha

Ph:913-***-****(M)

Email : ******@*******.***

Status: US Citizen

Summary:

Over 20 years of experience in IT Industry with experience in analysis, design, testing, development, and implementation of client server applications of which around 19 years of experience on Informatica Power Center (10/9.6/5.1,8.6), Repository Manager, Workflow Manager, Workflow Monitor and Informatica Cloud, Cognos Report Studio, Frame Work Manager, Tableau, Oracle, DB2, SQL server and Teradata, Netezza, AWS databases.

Strong working experience with Repository Server Administration Console, Informatica Power Center and Informatica Cloud.

Expertise in ETL process using Informatica/Informatica Cloud.

Created and Monitored Batches/workflows and Sessions/Tasks using Informatica Power Center Server/ Workflow Manager.

Expert on Informatica (10.4.1/9.6), Cognos 11/10/8.4, Report Net, Tableau, OBIEE, SSRS, SSAS, Qlik View, Qlik Senses.

Strong experience on debug logs for jobs running in push down mode.

Designing of Data mart using Erwin Star schema/snowflake methodology.

Expert in windows server administration and active directory Severs.

Design and development of OLAP models for Data warehousing.

Skillset:

Informatica-Power Center 10.4, ERwin, Informatica Cloud, Repository Manager, Workflow Manager, Informatica Data Quality (IDQ), AWS, Source Analyzer, Mapping Designer, Cognos Sever Administration, Analysis Studio, Power Play, Cognos BI 11/10, Cognos Workspace, Oracle 10g/9i/8i, SQL Server, Dynamic Cubes, Windows NT, OWB, Cognos Visualizer, VB, Teradata, AS400, UNIX Shell Script, TOAD/QUEST, Tableau, Power BI, BIRT, Event Studio, JAVA, SSRS, SSAS, Qlik View, PL/SQL, Qlik Sense, Business Objects, Cognos Access Manager, Progress V8 & 7

Education:

Post Graduate Diploma in Computer Applications (PGDCA) from IICS in 1995.

Master of Business Administration (MBA) from Nagarjuna University in 1994.

Bachelor of Commerce (B.Com) from Nagarjuna University in 1991.

Professional Experience:

Dearborn Group, Lombard, IL July'21 – till now

Senior BI/Data Warehouse Consultant

Worked with Business Units to define business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Designed complex ETL solutions for Data Warehouse Programs.

Provided technical support in all phases of the enterprise architect life cycle.

Developed and enforced best practices for ETL architecture.

Loaded data from files into Staging tables/Datamart tables.

Provided an architecture solution that is reusable, maintainable and scalable.

Assisted in development of project plan and schedules.

Participated in requirements gathering, refining discussions, and review sessions.

Designed error and exception handling procedures to identify, record and report errors.

Used Pushdown Optimization feature of Informatica.

Created Unit Testing documents for Informatica and IICS components and documented the results in JIRA.

Extracted data from Teradata using Teradata utilities to Oracle using Informatica.

Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Preparation of Unit Test plans and Unit testing of COGNOS Reports/ETL jobs.

Provided technical assistance, training and mentoring to Users and Business Partners.

Involved Designed, developed most efficient Reporting Solutions with improved performance and best practices.

Built Cognos models in Cognos Framework Manager and published packages into Cognos connection.

Developed Power BI models in Power BI Query Editor and developed dashboards.

Environment: Informatica Power Center (10.4.1/9.6), Informatica Cloud, IICS, Repository Manager, Designer, Workflow Manager, Workflow Monitor, COGNOS 11/10.2.1 Suite, Tableau, Event Studio, Power Play Transformer, Access Manager, Power BI, Teradata, Oracle, MS SQL Server, Oracle, AWS, Erwin. ERP, UNIX, Autosys, Flat Files.

Argonne National Laboratory

Jan’21 – Jun’21

Senior Data Engineer

Worked closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.

Documented the architecture/technical designs and roadmaps.

Prepared word documentation and Visio diagrams to depict business processes better.

Extracted data from different sources into Staging/Target Tables using Informatica.

Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Loaded data from files into Staging tables/Datamart tables.

Created multiple mappings to load the data from source to target tables using Informatica cloud.

Performed trouble shooting and performance tuning for ETL jobs. Analyzed error table entries and resolved related issues.

Environment: Informatica Power Center (9.1), Informatica Cloud, Designer, Workflow Manager, Workflow Monitor. ERP, UNIX, Flat Files.

Dearborn National, Lombard, IL May'18 – Dec’20

Senior BI/Data Warehouse Consultant

Worked with Business Units to define business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Designed complex ETL solutions for Data Warehouse Programs.

Provided technical support in all phases on enterprise architect life cycle.

Developed and enforced best practices for ETL architecture.

Provided an architecture solution that is reusable, maintainable and scalable.

Assisted in development of project plan and schedules.

Participated in requirements gathering, refining discussions, and review sessions.

Designed error and exception handling procedures to identify, record and report errors.

Used Pushdown Optimization feature of Informatica.

Created Unit Testing documents for Informatica and IICS components and documented the results in JIRA.

Extracted data from Teradata using Teradata utilities to Oracle using Informatica.

Data integration with SFDC and Microsoft Dynamics CRM using Informatica cloud.

Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.

Expertise in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin.

Migrated data from Oracle to Snowflake Data Ware house (AWS) using informatica Cloud.

Developed ETL pipelines in and out of data warehouse using Snowflakes /Writing SQL queries against Snowflake.

Created Cognos Framework model and Cognos reports using Teradata.

Held meetings with business analyst to review/understand business requirements before development.

Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Preparation of Unit Test plans and Unit testing of COGNOS Reports/ETL jobs.

Provided technical assistance, training and mentoring to Users and Business Partners.

Involved Designed, developed most efficient Reporting Solutions with improved performance and best practices.

Built Cognos models in Cognos Frame Work Manager and published packages into Cognos connection.

Environment: Informatica Power Center (10/9.6),Informatica Cloud, IICS, Repository Manager, Designer, Workflow Manager, Workflow Monitor, COGNOS 11/10.2.1 Suite, Tableau, Event Studio, Power Play Transformer, Access Manager, Teradata, Oracle, MS SQL Server,Oracle, AWS, Erwin. ERP, UNIX, Autosys, Flat Files.

Magellan Health Nov’16 – May'18

Senior Data Warehouse Consultant

Extracted data from Teradata using Teradata utilities to Netezza using Informatica.

Worked closely with key business decision makers on strategy.

Monitored production support for data warehouse on weekly basis as well as 24*7 basis.

Performed troubleshooting and performance tuning for Informatica Jobs.

Analyzed error table entries and resolved related issues.

Developed jobs and loaded data into DataMart tables on daily basis.

Migrated data from Netezza to Amazon Redshift (AWS).

Created Cognos Framework model and Cognos reports using Netezza, Oracle and SQL Server.

Held meetings with business analyst to review/understand business requirements before development.

Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Extracted data from SAP/SFDC to DataMart’s using Informatica.

Loading and Transform data Working knowledge of AWS Redshift Provide production support for Data Warehouse issues such data load problems, transformation translation problems Translate requirements for BI and Reporting to Database design and reporting design.

Migrated data from Oracle to Snowflake Data Ware house (AWS) using informatica Cloud.

Developed ETL pipelines in and out of data warehouse using Snowflakes /Writing SQL queries against Snowflake.

Used GitHub to migrate the code from Dev to Test/Production.

Created Dashboard Reports in Report Studio to present data graphically.

Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.

Environment: Informatica Power Center (10/9.6), Informatica Cloud, ERP, UNIX, Flat Files, B2B, Teradata, DB2, MS SQL Server, Netezza, AWS/RedShift, Autosys, Cognos (11/10).

CME Group Oct’15 – Aug’16

Senior Data Engineer

Worked closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.

Documented the architecture/technical designs and roadmaps.

Prepared word documentation and Visio diagrams to depict business processes better.

Extracted data from Teradata using Teradata utilities to DB2 using Informatica.

Extracted data from SAP/SFDC to staging area and loaded into DataMart’s.

Created Cognos Framework model and Cognos reports using Teradata.

Conducting weekly incident/bug review meetings with application team.

Worked extensively with all Informatica Designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Created multiple mappings to load the data from source to target tables using Informatica cloud.

Performed trouble shooting and performance tuning for 8.5 ETL jobs. Analyzed error table entries and resolved related issues.

Environment: Informatica Power Center (9.6/5.1,8.6), Informatica Cloud, Designer, Workflow Manager, Workflow Monitor. ERP, UNIX, Flat Files and UC4, COGNOS 10.2.1 Suite, Tableau.

UNUM Jun’13 – Sep’2015

Senior Data Warehouse/BI Developer

Regularly utilized Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin, and Microsoft Visio.

Worked with Business Units to define business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available.

Designed complex ETL/ELT solutions for Data Warehouse Programs.

Experience in both integration and reporting areas of Data Warehouse using Informatica, Cognos, Business Objects, Teradata and Oracle.

Extracted data To Netezza using Informatica.

Designed error and exception handling procedures to identify, record and report errors.

Conducted performance tuning of Informatica mappings.

Held meetings with business analyst to review/understand business requirements before development.

Published Cubes and Reports to Cognos Connection through Framework Manager and used Analysis Studio to view the cubes.

Used Transformer with a variety of sources and combines them into Multi-Dimensional Cube.

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Prepared of Unit Test plans and Unit testing of COGNOS Reports/ETL jobs.

Provided technical assistance, training and mentoring to Users and Business Partners.

Designed and developed most efficient Reporting Solutions with improved performance and best practices.

Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.

Environment: Power Center (9.6/5.1,8.6),Repository Manager, Designer, Workflow Manager, Workflow Monitor COGNOS 10.2.1 Suite, Tableau, Event Studio, Power Play Transformer, Access Manager, Teradata, Netezza,DB2, MS SQL Server 2005, Erwin. ERP, UNIX, Flat Files and App Works.

BCBS, IL Mar’13 – Jun’13

Senior BI Developer

Interacted with Business Users for gathering Business Requirements to develop the reports.

Developed Dashboards which consisted of charts, graphs, Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.

Implemented Data/row level security to Cognos packages.

Applied dynamic sorting on column headers asc and desc.

Environment: Cognos10 BI Suite, Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced, BIRT, Cognos Transformer, SQL Server, SQL Assistant.

Discover Financial Services (DFS), Deerfield IL Sep’12 – Dec’12

Senior BI Developer

Generated packages in Framework Manager and published them to be used in creating reports in Cognos studios.

Interacted with Business Users for gathering Business Requirements to develop the reports.

Developed dashboards which consisted of Standard Reports, list, cross tab, charts, drill-through Reports by using Report Studio, Query Studio and also delivered reports in different formats like PDF, XML, HTML and CSV.

Designed reports using slicers to filter dimensional data.

Published reports in Cognos connection and implemented security to grant access to business group.

Scheduling and Distributing Reports through Scheduler in Cognos Connection.

Environment: Cognos10 BI Suite (Framework Manager, Cognos Connection, Reports Studio, Query Studio, Analysis Studio, Business Insight Advanced), Cognos Transformer, Teradata, SQL Assistant, Cognos Administration.

Client: DeVry Inc. Aug’ 2007 to July’ 2012

Senior ETL Analyst

Project: Customer Relationship Management (CRM)

Designed, developed and implemented efficient Cognos FM models, Power Play Transformer models and reusable report templates.

Worked closely with Product leadership team and User groups to understand the business needs and source systems to design and implement better report architecture solutions.

Documented the architecture/technical designs and roadmaps.

Responsible for windows server administration and active directory servers.

Act as a primary subject matter expert and given technical directions to team members to develop the better and efficient bug free reporting solution.

Building models and publishing packages in Framework Manager to the Report Net server.

Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.

Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.

Managed the Informatica Server Workflows and Tasks and schedule them.

Created and monitored Workflows and Tasks using Informatica Workflow Manager.

Tested and validate the data on target data system.

Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Look up Transformations.

Extracted the data from ERP, OSS, Oracle, Files into Data Warehouse.

Environment: Informatica Power Center (9.6/5.1,8.6),Repository Manager, Designer, Workflow Manager, Workflow Monitor, COGNOS 10/8.4 Suite (Framework Manager, Report Studio, Query Studio, Analysis Studio and Cognos Connection), Power Play Transformer, DQM, Access Manager, Erwin.

Client: Hill-Rom, Inc, In Jan’2007 – Aug’2007

Project: Lazarus.

Contractor

Hill-Rom, Inc provides to their customers with high-quality, innovative products, outstanding service, extensive clinical expertise and, most importantly of all, great support from their tremendous team.

· Gathered and analyzed User requirements and the reporting issues from Business analyst.

· Prepared Tech Design docs for the mappings.

· Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Stored Procedure, Look up Transformations.

· Extracted the data from Oracle, Files, and Access into Data warehouse.

· Performed data manipulation using Informatica transformations.

· Wrote PL/SQL procedures replaced by Informatica mappings to improve warehouse loading.

· Developed Mappings/ Transformations by using mapping designer and transformation developer in Informatica Power Center.

· Workflow Manager used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, abort and delete the session.

· Setting up workflows and Tasks to schedule the loads at required frequency using Power Center Workflow manager.

· Performed Developer testing, Functional testing, Unit testing for the mappings.

· Analyzed the requirements and framed the business logic for the ETL process.

· Developed Unix shell scripts to execute the workflows.

Environment: Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

AS400, Flat Files, Oracle, TOAD, Unix.

Client: Hewitt Associates, Chicago. April’2006 Dec’2006

Project: Client Profitability.

Contractor

Client Profitability provides flexible reports for analyzing the financial progress of the business. You can look at revenue and profit information by classification, work type, client, division or account handler. Billing and income information for each client, less client-related expenses and overhead allocation, produce a client net profitability statement. This helps you judge which clients show small margins, taking into account all the direct costs as well as the indirect costs and overheads involved in servicing the business.

· Developed Advanced Reports in Cognos Report Studio.

· Developed Cross tab reports and applied advanced filters using Analysis Studio.

· Burst the report to the Network location using Report Studio.

· Created Cascading prompts using Report Studio.

· Created the various business reports - List Reports, Form Reports Cross-tab Report and Drill through Reports.

· Performed data manipulation using Informatica transformations.

· Wrote PL/SQL procedures replaced by Informatica mappings to improve warehouse loading.

· Developed Mappings/ Transformations by using mapping designer and transformation developer in Informatica Power Center.

· Workflow Manager used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, abort and delete the session.

· Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.

· Performed Developer testing, Functional testing, Unit testing for the mappings.

· Analyzed the requirements and framed the business logic for the ETL process.

Environment: Cognos 8 BI, Analysis Studio, Cognos Connection, Cognos Power Play, Power Play Enterprise Server, Framework Manager, Query Studio, Report Studio, Cognos Access Manager, with DB2,Quest. Cognos Report Net, Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Client: Orbitz LLC, Chicago. Sep’2005 Mar’2006

Project: Orbitz For Business (OFB)

Contractor

Orbitz, Inc (www.orbitz.com) is a leading online travel company offering consumers the widest selection of low airfares, as well as deals on lodging, car rentals, cruises and vacation packages. Orbitz makes finding low fares and great deals easier through a state-of the-art flight search engine that scans more than 455 airlines and the Orbitz Matrix Display that provides an unbiased and comprehensive listing of airfares and other rates. Orbitz also offers the largest collection of discounted web-only airfares and low-priced hotel web rates.

Responsibilities:

· Interacted with Business users to collect the Reporting Requirements.

· Prepared prototypes and got approvals from the from business owners.

· Created/enhanced catalogs and set User profiles to grant user permissions for querying.

· Create Joins between the tables and Shortcuts.

· Developed all the required cubes and Drill Through cubes for the project.

· Developed Business Reports and Cycle time Metrics.

· Created User Classes in Access Manager.

· Created Value Prompts and Text Prompts to filter the Data Cognos Report Studio.

· Developed List, Crosstab, Chart, Section and Drill Through Reports in Report Studio.

· Deployed multiple ReportNet Reports from one environment to another.

· Scheduled the Reports on Cognos Connection.

· Created various mappings using Designer include Source Qualifier, Expression, Aggregator, Stored Procedure, Look up Transformations.

· Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.

· Performed Developer testing, Functional testing, Unit testing for the mappings.

· Analyzed the requirements and framed the business logic for the ETL process.

Environment: Cognos Power Play, Power Play Enterprise Server, Framework Manager, Query Studio, Report Studio, Cognos Access Manager, Cognos Upfront, with Oracle 9i,TOAD, Teradata, Cognos Report Net (V1.1), Erwin, Repository Manager, Designer, Workflow Manager, Workflow Monitor.

Client: State of PA, Harrisburg. Mar’2005 Aug’2005

Project: Health and Community Services (HCSIS)

Contractor

HCSIS is Community Services application, which enables the users to process their requested Incidents online. Any incident captured by application form and this is sent to the Underwriter for processing. The metrics of interest to the Business Owners is, to know the count of Incidents in each the statuses.

Responsibilities:

· Identified the required dimensions and, measures for the reports.

· Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.

· Created/enhanced catalogs and set User profiles to grant user permissions for querying.

· Developed all the required cubes for the project. HCSIS Cycle Time Metrics are the main ones developed.

· Cycle Time Metrics at the high level has the summary information and the drill through/the low level has the detailed information of the HCSIS Application statuses.

· Testing and validating the data on Impromptu reports as well as Cognos Cubes.

· Developed Models using the Frame Work Manager.

· Published Packages on Cognos Connection using Frame Work Manager.

Environment: Cognos Impromptu (V7.3), Power Play (V 7.3), Power Play Transformer, Server Administration, Impromptu Web Reports, Cognos Upfront, Report Net(1.1) with Oracle, DB2, SQL Server. ERwin was used for database modeling.

Client: BCBSMA, Boston. July’2004 Feb’2005

Project: Accounting Level DataBase (ALDB)

Contractor

ALDB is Insurance application, which enables the users to process their requested Quotes online. The user data are captured by application form and this is sent to the Underwriter for processing. The metrics of interest to the Business Owners is, to know the count of applications in each of the statuses and the corresponding premium amount.

Responsibilities:

· Identified the required dimensions and, measures for the reports.

· Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.

· Cycle Time Metrics at the high level has the summary information and the drill through/ the low level has the detailed information of the ALDB Application statuses.

· Testing and validating the data on Impromptu reports as well as Cognos Cubes .

· Developed .cpf files using ReportNet FrameWork Manager

· Developed ad-hoc reports using ReportNet Query Studio.

· Develop Advance reports using the ReportNet Report Studio

Environment: Cognos Impromptu (V7.1 & 5.1), Power Play(V 7.1 &5.6), PowerPlay Enterprise Server, Cognos Architect, Cognos Query, Impromptu Web Reports, Cognos Upfront, Report Net with Oracle 8i,TOAD, SQL Server. AIX, ERwin was used for database modeling.

Client: DaimlerChrysler (DCA), MI. June’2003 to June 2004

Project: Integrated Volume Planning (IVP)

Contractor

DaimlerChrysler Corp, Auburn Hills (DCA) is implementing a new integrated volume planning (IVP) initiative that addresses all the volume planning steps from sales forecasting by market to the development of the corporate production program. Integrated Volume planning initiative is the first of its kind in the automotive industry, where such a complex system is developed to optimize production planning.

Responsibilities:

· Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.

· Created packages using Cognos ReportNet Frame work Manager.

· Created reports on Cognos ReportNet, a web based enterprise-reporting solution.

· Schedule the mappings and populate the warehouse system.

· Manage the Informatica Server Workflows and Tasks and schedule them.

· Created and Monitored Workflows and Tasks using Informatica Workflow Manager.

· Testing and validating the data on target data system.

Environment: Cognos Impromptu (V7.1), Power Play(V 7.1) Cognos Architect, Cognos Query, Cognos ReportNet 1.1 with Oracle 9i,TOAD,DB2,AIX, Informatica Power center 6.1, Erwin and PL/SQL.

.

Client: Roche Diagnostics, In. Aug’2002 to June’2003

Project: MyDoc

Mydoc.com is a website, which enables the patients to process their requested prescriptions online. The Patients data are captured by an Application form (www.mydoc.com) and prescription is sent to the nearest Pharmacy.

Responsibilities:

· Created / enhanced catalogs and set User profiles to grant user permissions for querying.

· Used various fields for calculation and manipulation using Cognos Impromptu.

· Created Informatica Mapping designs to map the Production system to the designed star schema model.

· Schedule the mappings and populate the warehouse system.

· Created and Monitored Batches and Sessions using Informatica Server Manager.

· Testing and validating the data on target data system.

Environment: Cognos Impromptu (V7.1/ 6.0), Power Play(V 7.0/6.6) Cognos Architect, Cognos Query with Oracle 9i, Informatica Power center 6.1/5.1, Erwin and PL/SQL.

Client: GE ERC, Kansas. Feb’2001 to July’2002

Project: Medpro PL2.0

Medpro MedicalProtective.com is a website, which enables the users to process their requested Quotes online. The user data are captured using 10 pages Application form and this is sent to the Underwriter for processing. The metrics of interest to the Business Owners is, to know the count of applications in each of the statuses and the corresponding premium amount.

Responsibilities:

· Identified the required dimensions and, measures for the reports.

· Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.

· Schedule the mappings and populate the warehouse system. Manage the Informatica Server sessions/batch and schedule them.

· Done presentations by adding a chart palette, labelling color palettes, creating space among axis tick labels, and by customizing the appearance of lines using Cognos Visualizer used as graphical tool to represent the data at an higher level.

Environment: Cognos Impromptu (V7.0 & 6.6), Power Play(V7.0&6.6),PowerPlay Enterprise Server, Cognos Architect, Cognos Query, Impromptu Web Reports, Visualizer 7.1, Cognos Upfront, with Oracle 8i,TOAD, SQL Server/AS400, Power Center Informatica 5.1 (Designer /Server Manager/ Repository Manager). ERwin was used for database modeling.

Client: Olsten Corporation, NJ. Dec 99 – Jan 2001

Responsibilities:

· Generated standard and ad-hoc Impromptu tools.

· Created List Reports, Crosstab Reports and Drill through Reports.

· Created multi dimensional cubes using Transformer.

· Created and enhanced existing power cubes as per user requirement.

· Create Informatica Mapping designs to map the Production system to the designed star schema model. Schedule the mappings and populate the warehouse system. Manage the Informatica Server sessions/batch and schedule them.

Environment: Oracle 8.0, Cognos Impromptu(V6.6), Cognos Power play(V 6.6 ), Windows NT. Power Center Informatica 4.7 (Designer /Server Manager/ Repository Manager), ERwin was used for database modeling.

Contact this candidate