Summary

• 6 years of overall experience working in the Information Technology Industry.
• 5 years of experiencein BI / Data warehouse projects involving Cognos suite of products and Informatica.
• Very strong with Oracle and PL/SQL development.
• Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports etc.
• Extensive experience with Cognos security (Access manager, object level security, data security).
• Experience with Cognos 8 RTM SDK.
• Experience with interfacing Cognos reports with Java Servlets and Java applications.
• 4 Plus years of Data Modeling experience using ERWIN 3.x
• Experience in coming up with data cleansing, backup and restoration strategies.
• Extensive knowledge withDimensional Data modeling, Star Schema/snowflakes schema,Fact and Dimension tables.
• Extensive Unix Shell Scripting knowledge.
• Expertise in Cognos 8(Cognos 8.4/8.3/8.1), Cognos Series 7 Impromptu, Reportnet 1.1 (Report Studio/ Query Studio)
• Experience in creating theCatalogs and implementing the Security using User Classes in Impromptu Administrator.
• Expertise in building and publishing packages usingFramework Manager
• Interacted with the business usersextensively to understand theirreporting requirements, trained them on new tools like Query studio where they could create ad-hoc reports.
• Developedreport prototypesto get user's feedback, incorporated user's feedback in the reports.
• Experience with migration of reports from Impromptu to ReportNet and from ReportNet to Cognos 8.
• Experience in creating complex models (dimensions/hierarchies/categories) in Transformer.
• Expert in creating PowerPlay Reports.
• Expert inOracledevelopment (PL/SQL, Forms, Reports).
• Worked with Cognos Go! Office reports.
• Project management capability with ability to multitask, team-oriented approach and strong interpersonal and communication skills.
• Experience in developingnew reports in ReportNet1.1 using Report Studio & Query Studio.
• Creating ad-hoc reports using Query Studio.
• Refining models inReportNet Framework Manager
• Installation and configuration of various components of ReportNet

Technical Skills

BI / OLAP tools: Cognos Series 8 v8.2/8.3/8.4,Crystal Report, SSRS
ETL Tools: Informatica 6.0, 6.1, 7.1, 8, SSIS
RDBMS: Oracle 8.x/9.x/10g,Teradata v2 R6, DB2, Sql Server 2000/2005
Database skills: Stored Procedures, Database Triggers, and Packages
Languages: Java, SQL, PL/SQL, HTML/DHTML, UNIX
Web Servers: IIS v4.0/5.0/6.0, Apache Tomcat, IBM WebSphere V6
OS: UNIX/Solaris, Red Hat Linux, AIX, Windows 2000/2003/XP/Vista
Version Control: Visual Source Safe 6.0, CVS, Documentum SmartSpace
Tools: Erwin 3.x, MS Project, MS Visio

Education

Bachelor in Computer Engineering

Professional Experience

Client: Confidential, Morrisville, NC May 2009 - Jun 2010
Position: Cognos Developer

Environment: Cognos 8.4/8.3, Transformer 8.3, Report Studio, Query Studio, Cognos 8 RTM SDK, JDK 1.4/1.5, Oracle 10g/11g,Siebel, Erwin 4.0, TOAD, PL/SQL, UNIX

Description: Confidential, is the world\'s largest pharmaceutical services company. Quintile performs routine and non-routine research for companies engaged in drug development. Such research includes services and facilities necessary for Phase I, II, III and IV trials. Clinical trial management system is management system implemented worldwide for tracking clinical trial being carried out for various purposes. This project is part of clinical trial management system and involves data integration for its clinical trial processes The data is thoroughly checked for validity during processing. Audit data is created which characterize the data in various categories. This data is used in developing reports and the warehouse is built on Oracle.

Job Responsibilities:

• Created report specifications for business user approval.
• Wrote Procedures and triggers in Oracle10g/11g for file handling, data validation, Inserting data etc.
• Involved in defining the business rules by reading existing procedures and recreating them using the new back end database.
• Generated IQD's for cubes.
• Designed the model with the Cognos transformer to build the cubes with the Cognos Power play and published with Power play enterprise server.
• Created Logical and Physical Models in Framework manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Built cubes, cube groups and cubes based on alternate views of various dimensions
• Created materialized views to aggregate data for faster report response time.
• Created Materialized views to aggregate data at the lowest level for faster cube build times
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Understood and implemented the complex joins between factsdimensions and hierarchy
• Created complex multiple query reports having joins and unions between different queries
• Developed Cognos RTM SDK routines to link Cognos reports to Java Server pages (JSPs) and Servlets.
• Wrote administrative utilities using JSPs/Servlets to monitor the performance of various production servers and called Cognos Report Studio reports from Java programs.
• Created scorecards using metric studio which included risk scorecards, profitability scorecards, etc.
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Developed new and enhanced functionality of Drill through Reports & Master Detail Reports for Sales Data Cleaning & Slicing.
• Development of customized tables, complex joins, and specialized exception reporting requirements were some of the complexities addressed in the project.
• Powerful and ad-hoc analytical capabilities including pivoting and drill-downs
• Worked with Cognos Go! Office reports
• Migration of Impromptu and ReportNet reports to Cognos 8.
• Wrote and executed the test cases for various reports that were developed in Cognos.
• Update the Transformer Model with User Classes from Access Manager.
• Tested and improved Report Performance through query optimization.
• Deployed reports from Oracle to SQL server 2005 and converted views ,procedures ,function in sql server , tested reports in cognos report studio, query studio and Power play
• Prepared Test Scripts for users as to verify the reports.

Client: Confidential, Swiftwater, PA Mar 2008 - Apr 2009
Position: Cognos Developer

Environment: Cognos 8.2, Report Studio, Query Studio, Powerplay, Transformer,ReportNet 1.1, Crystal
Reports 8.5, Informatica Power Center 8.1.x, Oracle 10g, PL/SQL, SQL*Loader, ERWIN3.X, TKProf, SQL
Navigator, UNIX, Autosys

Description: Confidential, is a multinationalpharmaceutical company, the world's fourth-largest by prescription
Sales. Sanofi Pasteuris thevaccinesdivision ofsanofi-aventisGroup. It is the largest company in the world devoted entirely to vaccines. Sanofi-Aventis engages in theresearch and development, manufacturing and marketing of pharmaceutical products. The Electronic Data Analysis & Design project performed at this company provided a standardized means for transforming, calculating and reporting Case Report Form (CRF) subject level data. This standardized capability provided an automated procedure for generating Clinical Study Report tables that are very essential for the company.

Job responsibilities:

• Interacted with users for gathering requirements
• Intake, review and processing of safety information related to Idenix investigational and marketed products.
• Collecting safety information from Investigator sites and/or via the CRO managing the safety reporting for processing, building reports off of this data.
• Created Logical and Physical Models in Framework manager.
• Worked on query subjects, relationships within Query subjects, IDQ's for cubes, importing views, tables, stored procedure in Frame work Manager.
• Created and published packages in Framework Manager.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Established Package security to Cognos portal
• Created Complex reports using Multiple Drill through, Conditional Layout, Reports with Burst Options, Dynamic Filtering, Dashboards and Scorecard applications.
• Developing Prompt pages and Conditional Variables depending on user requirements
• Created reportsfor managers, employees located at different locations, having different positions, retrieving top most representatives for different regions using prompts, drills through and conditional filtering in Report Studio.
• Created Lists, groups and Cross-tab Reports With drag & drop functionality.
• Migrated various reports from Crystal reports 8.5 to Cognos 8
• Derived various complex calculations as per the report specification.
• Scheduled the reports using Cognos Scheduler and Cognos Connection.
• Involved in maintenance of reports in Reportnet and Powerplay cubes.
• Involved in Powerplay transformer mapping and creating security in powerplay cube
• Deployed reports to multiple servers and tested.
• Prepared Test Scripts for users as to verify the reports.
• Worked on materialized views, stored procedures, functions in oracle
• Worked with data regarding Demographics, Power, Parallel design, related to Clinical Trials
• Loaded data from the load tables to the staging tables using SQL* loader.
• Trained End users to operate the reports.
• Set User profiles to grant user permissions for querying.

Client: Confidential, Mason, OH Jan 2007 - Feb 2008
Position: Cognos Consultant

Environment: Cognos 8 BI series, RTM SDK, JDK 1.4/1.5, Web logic 8.1, ReportNet 1.1, Report Studio, Powerplay, Transformer, Reports, Oracle 9i,Teradata, PL/SQL, TOAD, UNIX, ERWIN 3.x

Description: Confidential, companies are franchisees, independent of the association (and traditionally each other), and offering insurance plans within defined regions under one or both of the association\'s brands. Blue Cross Blue Shield insurers offer some form of health insurance coverage in everyU.S. state. The insurance claim and policy data from different source systems is collected and integrated into a data warehouse which is used to generate various reports required by the management in the decision making process.

Job responsibilities:

• Assisted in logical and physical data modeling using ERWIN 3.x
• Analyzed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Developed Technical Design Documents
• Designed models in Framework Manager
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Created complex reports in Cognos for PHI department which involved dealing mainly with MemberData, Claims data and Provider Data
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables
• Used Union, Intersection for creating queries.
• Created customized BI reports linking various databases, to meet the user requirements
• Developed Cognos RTM SDK routines to link Cognos reports to Java Server pages (JSPs) and Servlets.
• Wrote administrative utilities using JSPs/Servlets to monitor the performance of various production servers and called Cognos Report Studio reports from Java programs.
• Created scorecards using metric studio which included risk scorecards, profitability scorecards, etc.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Involved in migration of catalogs from Impromptu to ReportNet using Migration Utility.
• For Oracle and Teradata database systems for creation of adhoc queries and for improving various performance issues.
• Wrote shell scripts to backup the log files in QA and Production
• Experience with Teradata Worked on TOAD and BTEQ as the target for the datamarts.
• Involved in monitoring Informatica jobs/processes and generating reports after successful job scheduling

Client: Confidential, Bloomington, IL Oct 2005 - Dec 2006
Position: Cognos Developer

Environment: Cognos 7 series (PowerPlay, ReportNet, Impromptu), Informatica Power Center 7.1. Oracle
9i, Erwin 3.5, Cognos SDK, Shell Scripting, PL/SQL, UNIX, Windows 2000

Description: Confidential, provide a single source to analyze data. Data from newly acquired companies are also merged with the existing data. After the process of Data warehousing, different reports were generated for claims, billing, members/ subscribers and sent to respective departments and employees.

Job Responsibilities:

• Involved in the complete lifecycle of the data warehouse creation starting form requirements gathering to putting the product into production.
• Developed logical & physical modeling as per business requirements using ERWIN
• Used Dimensional Modeling Techniques to identify parameters necessary to create Dimensions and Fact tables.
• Created tables, views and materialized views in the database as per the requirement.
• Wrote Procedures and triggers in Oracle 9i for file handling, data validation, Inserting data etc.
• After development, performed extensive unit testing to check the proper and timely flow of data. Performed tuning of sessions by monitoring the cache size of the transformations.
• Once the development is complete, performed migration of the objects from development environment to the production environment.
• Designed models in Framework Manager and worked with parameter maps.
• Created models in Transformer, built cubes and published cubes to PowerPlay server.
• Business model created using framework manager to map the Business requirements to fit their business and reporting needs for ad-hoc querying and standard reporting.
• EstablishedPackage security and published packages to Cognos portal
• Created Complex reports using Multiple Drill through, Conditional Layout
• Created Hierarchy reports using JavaScript
• Used Cognos RTM SDK to call Report Studio reports from Java programs.
• Created various reports viz. List, Cross-tab and drill through as per the requirement.
• Worked with Complex reports in Report Studio using master-detail relationship, drill throughs, drill up and drill down, burst options, PROMPTS.
• Prepared Test Scripts for users as to verify the reports.
• Developed new reports in Cognos BI 7 Series using Report Studio & Query Studio in Creation of ad-hoc reports using Query Studio
• Set User profiles to grant user permissions for querying.
• Trained End users to operate the reports.
• Fixed the production issues, Involved in maintenance of reports in reportnet and Powerplay cubes.
• Performed production support after the project went live into production.
• Deployed reports from oracle to sql server and converted views ,procedures ,function, in sql server , tested reports in cognos report studio, query studio, Power play
• Experience backup/restore procedures/ upgradation of versions, setting up users, permissions, migration of objects from development to QA and to Production.
• Resolved issues in Production/QA with repositories, etc.
• Helped developers fine tune their Informatica mappings(partitioning, etc)
• Came up with test cases and executed these cases using Oracle to test various mappings and transformations of informatica. Also wrote and executed the test cases for various reports that were developed in Cognos.

Client: Confidential, India Oct 2004 - Aug 2005

Position: DW Developer

Environment: Informatica Power Center 7.1, Impromptu, Powerplay, ReportNet1.1 (Report Studio, Query Studio) Oracle9i, Erwin 3.0, Shell Scripting, PL/SQL, UNIX, Windows 2000

Description: This system provides online banking to its customers like money withdrawal, fund transfers between accounts and loans etc. The system aims at integrating data scattered in many legacy systems and presenting a centralized data warehouse interface.

Job Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data.
• Involved in designing logical models for staging, production warehouses using ERWIN 3.0
• Assisted in data modeling using Erwin.
• Designed models in Framework Manager and worked with parameter maps.
• Created and published packages for different functional areas and assigned security rules to them.
• Derived various complex calculations as per the report specification.
• Scheduled reports using Cognos scheduler as needed.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using PMCmd on Unix Environment. Conversant with the Informatica API calls.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.
• Upgradation of repositories when upgrading to new versions of Informatica.
• Extensively worked on Unix Shell Scripting, Using pmcmd to automate the process by Autosys on UNIX environment.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Improved session run times by partitioning the sessions. Was also involved heavily into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• Developing new reports in ReportNet1.1 using Report Studio & Query Studio. Creating ad-hoc reports using Query Studio. Migrating reports from Cognos Impromptu to Report Net1.1
• Writing SQL, PL/SQL, stored procedures and triggers in Oracle9i.Migrating report from D2K (Forms 6.0) to Report Studio.
• Identified the required dimensions and, measures for the reports.
• Manually changed the converted reports to provide functionality that was not converted correctly.
• Thoroughly tested the converted reports to make sure that all functionality worked correctly.
• Scheduled the reports using Cognos Scheduler and Cognos connection.
• Came up with the security mechanism for the reporting environment.
• Implemented package level security in framework manager and report level security in Cognos connection.
• Implemented table level and Query subject level security by using embedded filters.
• Created different joins according to User requirements.
• Developing Standard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query Studio.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Used Union, Intersection, etc for creating queries.
• Used custom queries in certain reports.
• Fine tuned the performance of the reports by creating appropriate indexes and using performance parameters provided in ReportNet. The processing times in certain cases was improved by over 50%.
• Developing Prompt pages and Conditional Variables
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Worked extensively with burst reports and Event-triggered emails.
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in Impromptu reports