PROFESSIONAL SUMMARY:

• SDLC: 7 years of IT experience in the Analysis, Design, Administration, Development, Testing, and Implementation of business application systems for Pharmaceutical, and Insurance using SQL and Informatica.
• Data Warehousing: strong Data Warehousing ETL experience of using Informatica Power Center 9.0.1/8.6.1/8.1.1/7.1 Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Transformations, Scheduler, Exposure , Power Connect, Power Analyzer, MS SQL Server 00, Mappings, Mapplets, Transformations, Autosys, OLAP, OLTP, ETL, Data marts, Repository Manager and Workflow Manager.
• Business Intelligence: Extensively worked on Business Objects 6.1b/6.5/XI R2/R3, IBM Cognos 7 Cognos 8 and Cognos 10 Framework Manger, creating model and implementing best practices while resolving the loops and query items, namespaces, DMR Dimensional modeling with relational data and packages.
• Data Analysis: experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Methodologies: Complete knowledge of Data Warehouse methodologies Ralph Kimball, Inmon , ODS, EDW and Metadata repository.
• RDBMS: experience using Oracle 11g/10g/9i, Toad, MS SQL Server 08/05, AIX,XML, XSL, PL/SQL, SQL Plus, SQL Loader and Developer 00, Win 95/98/00, and Unix experience on Performance tuning and writing SQL Scripts and shell scripts. Integration of various data sources like Oracle, Flat files, DB2, SQL server and MS access into staging area.
• Strong team working spirit, communication and relationship management skills.
• Good knowledge and experience on Work brain application Infor Adept in designing Catalogs and Creating List Reports, Cross-Tab Reports, Sub Reports and Exception Reports using Cognos.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica PowerCenter, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Strong experience in PL/SQL functions, triggers, procedures and Packages.
• A keen communicator with excellent logic and analytical abilities, and flair for interacting with cross-cultural teams.
• A quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Administrator/Informatica Administrator

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Analyzed the Service request SR and Change request CR as per requests from Peregrine ticketing tool.
• Prepared and shared documentation to describe program development, logic, coding, testing, changes and corrections.
• Installation and configuration on a multi-server environment and securing Cognos10 BI.
• Administering, deploying and maintaining Models, reports, and cubes to all environments.
• Setup new database connections and security procedures, Configured the LDAP Server for User authentication.
• Created various IQD packages in Framework Manager and integrated them to PowerPlay transformer to create various models and cubes.
• Closely worked with optum on EMAR and EFADS setup at Informatica level and at cognos level.
• Provided 24X7 and week-end support for optum on both AK and NH MMIS project in order to meet project deadlines.
• Guided optum staff to how to proceed with deployments and structure of optum setup on NH, AK and ND for Informatica files landing and pickup.
• Involved in regular optum TCR execution on daily basis and on AD-HOC basis.
• Supported for optum in troubleshooting the failures occurred in EFADS, EMAR and also prepared run book stats for both weekly loads and regular loads.
• Worked on Cognos connection Data Source, Schedule Management, security admin Content Administration .
• Set up required permissions in the Cognos Portals for the User group for security purposes.
• Published Packages to the Cognos 10 and 8.3 server using Framework Manager.
• Created various reports using Cognos functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Solving PMRs, environment, report bug fixes, Evaluate, understand and implement patches to Cognos environment.
• Installing Informatica Power center 9.1 and configuring environment on IBM-AIX machines.
• Creating SR to Informatica corporation- related to any Power center product issues.
• As per deployment release notes performed migration of objects in all phases DEV, QA and PRD of project.
• Performed regular checks on the licensing files, configuration of the Power Center Domain components.
• Performed repository backup, restore for Informatica Repositories during upgrade process.
• Creating Folders and manages user and user group access to objects through native settings.
• Involved in Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Installing new versions of the Oracle and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Extensively Worked with UNIX Admins, DBA Admins and Application Admin teams related to resolved platform related issues.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions, Created parameter and variables and called them whenever required.
• Worked on trouble shooting and performance tuning of the mappings and SQL statements, worked on Query Optimization.

Environment: Cognos10/8.x, Informatica Power Center 9.x, IBM-AIX, Oracle11g/10g, control-m, Peregrine Ticketing tool , Citrix.

Confidential

Cognos Administrator/Informatica Administrator.

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Resolving the issues Remedy Tickets on Priority basis.
• Analyzed the Service request SR and Change request CR as per requests from IBM ISM tool.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Installation and configuration on a multi server environment and securing Cognos 8.2/8.3/8.4/ Cognos10 BI.
• Administering, deploying and maintaining Models, reports, and cubes to all environments.
• Setup new database connections and security procedures, Configured the LDAP Server for User authentication.
• Created various IQD packages in Framework Manager and integrated them to PowerPlay transformer to create various models and cubes.
• Set up required permissions in the Cognos Portals for the User group for security purposes.
• Published Packages to the Cognos 10 and 8.3 server using Framework Manager.
• Created various reports using Cognos functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Installing Informatica Power center 9.1 and configuring in grid environment on Sun Solaris.
• Creating SR to Informatica corporation- related to any Power center product issues.
• As per Service requests SR migration of objects in all phases DEV, QA and PRD of project and trained developers to maintain system when in production.
• Performed Upgrading Informatica Power center Version 7.x, 8.x to Informatica Power center 9.X.
• Ensures proper application of the licensing files, configuration of the Power Center Domain components.
• Experienced in configuring the HA, Nodes, Repository services and Integration services.
• Create, backup, restore for Informatica Repositories.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Creates and maintains all databases required for development, testing, education and production usage.
• Installing new versions of the Oracle and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Worked with UNIX / Windows Admin team related to OS related issues.
• Monitoring the Jobs and sever space availability and CPU Process.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions, Created parameter and variables and called them whenever required.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.

Environment: Cognos10/8.x/7.x ,InformaticaPowerCenter7.1/8.1/8.6/9.1,SunSolaris 9/10, Windows 2003/2000, Oracle11g/10g, Quality control 10, IBM-ISM Ticketing tool , Citrix.

Confidential

Cognos Administrator/Informatica Administrator.

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development, testing and production.
• Involved in installation , configuration and maintenance of Cognos 8.x
• Analyzed source systems and business requirements needed for report development.
• Developed user acceptance documentation, placing screenshots of actual report and tested report in documentation.
• Created technical requirements for developers to build their reports as per client requirement.
• Deploying reports/packages to various environments.
• Developed, managed and monitored testing and production environment.
• Administered quality of data generated and helped to make the changes whenever required.
• Used Upgrade Manager 8.4 after migration to test the reports for data and layout consistency of reports from 8.3 to 8.4.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Coordinating with Source System owners and day-to-day ETL progress Monitoring.
• Involved in installation, configuration of Informatica Powercenter 8.x.
• Performed Informatica Migrations using Informatica Repository manager to different environments at folder level and repository level.
• Created Repository services and Integration Services using Informatica Administration Console.
• Configured the Repository Services and Integration Services to run on a GRID/HA.
• Extensively used Informatica Client Tools Repository Manager, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, sorter and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Involved in the administration of the Informatica Repository and also in the design and architecture of multiple repositories to support multiple application development areas.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Performed ETL Administrator jobs like maintaining Folder/User level Privileges, Scheduling Jobs based on target system dependencies.
• Day to Day Deploy Objects from Dev to QA and production during weekly release.
• Recently Upgraded Informatica PowerCenter 8.1 to latest Version 8.6.
• Involved in creation of various Unix Scripts which help the ETL scheduling jobs and help in initial validations of various tasks.

Environment: Cognos 8.x/7.x,Informatica Power Center 8.1/8.6,Oracle 10g/9i, PL/SQL, TOAD, Teradata V2R6, SQL Plus, Erwin, Windows 2003, Sunsolaries.

Confidential

Informatica Developer.

Responsibilities:

• Involved in developing mapping from the design documents.
• Installed Informatica on UNIX servers for Development as well as Production Servers.
• Managed Informatica Power Center Domain, Nodes, Service Manager and Application Services.
• Used Putty to connect to UNIX servers to install Informatica on the UNIX box and perform shell script migrations.
• Worked on Informatica Power Center 7.x tools like Source Analyzer, warehouse designer, Mapping Designer Server Manager, Mapplets, and Reusable Transformations.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing Systems to the new system using Informatica Designer.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and Unconnected Lookups for better data messaging and to migrate clean and consistent data using the Informatica Power Center Designer.
• Involved in creating secondary, join indexes for efficient access of data based on the requirements.
• Built Repositories using Informatica Power Center Repository Manager to store Source, Target, Transformations, Mapplet and Mappings metadata information.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target.
• Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load data.
• Unix Scripts were written at various situations like event automation and job scheduling.

Environment: Informatica PowerCenter 8.x/7.x, SQL Server2005, HP-UX, Erwin 4.0 T, ORACLE 8i, Putty, WINDOWS XP, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Designed and developed end-to-end ETL process for Sales Data Mart.
• Studied the existing OLTP system s and Created facts, dimensions for the star schema representation for the data mart.
• Extensively worked on Informatica to extract data from flat files and to load the data into the target database.
• Used Informatica power center for ETL extraction, transformation and loading data from heterogeneous source systems.
• Imported Source/Target Tables from the respective databases and created reusable transformations Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator inside a Mapplet and created new mappings using Designer module of Informatica.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Worked with Data modeler in developing STAR Schemas.
• Created Stored Procedures for data transformation purpose.
• Maintained hierarchies in the designing of the Universe for drill down capabilities.
• Extensively used Autosys for scheduling of the UNIX shell script jobs.
• Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.

Environment: Informatica PowerCenter 7.x, Erwin 4.0, Autosys, XML and Linux 2.4, SQL Navigator.

Confidential

Informatica Developer

Responsibilities:

• Designed, developed and tested Informatica mappings and production deployment of Informatica mappings.
• Wrote PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance
• Involved in the design and development of logical data base model and understood the business requirements to transform the data.
• Created Mappings between Source and Target using PowerCenter Designer.
• Did the Unit testing of the mappings by executing individual sessions and integrated testing with all Sessions and Worklets by executing complete Workflow.
• Designed and developed of BO Universe reports, Involved in unit testing of BO reports and support to UAT.
• Involved in migration of Informatica mapping to SIT and UAT and BO Universe and Reports.
• Involved in writing UNIX Shell Scripting, batch job automation Appworx and handled ad hoc data base change requests and transition to maintenance team.

Environment: Informatica PowerCenter 6.x, Designer, Workflow Manager workflow monitor, Oracle 8i, PL/SQL, UNIX, Windows 2000.