OBJECTIVE:

To pursue a challenging career in a dynamic organizations that give me scope to enhance my knowledge and skills to cope up with the latest technological changes.

SUMMARY:

• 11+ years of professional experience as IT consultant in Client/Server, Data Warehouse/Data Mart and Business Intelligence tools.
• Expert with Cognos tools such as 10BI, 8BI, Report Net (Framework manager, report studio, query studio) Impromptu, Power Play, Impromptu Web Reports (IWR), Access Manager, Architect, and server Administration on Enterprise.
• Expertise in Business Objects XI 3.1/3.0/XI R2/6.x/5.x(Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Xcelsius, Central Management Console and Business Objects Administration),
• Proficient in designing Business Models to meet the complex reporting requirements using Cognos Framework Manager, Report Studio and Query Studio.
• Administration of Access Manager to implement Security among Cognos applications
• High degree of proficiency in Web - enabled, three tier and Client/Server computing environments using Oracle 11g,10g, 9i/8i, SQL Server 7.0, MS Access, SQL, PL/SQL.
• Experience in gathering of end-user business requirements and responsible to provide specific direction, training and mentoring to clients.
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementation and Production Support using Cognos as a BI tool.
• Excellent organizational, interpersonal, analytical, verbal, written, and presentation skills.

TECHNICAL SKILLS:

BI Tools: COGNOS 10BI, COGNOS 8BI, REPORT NET 1.1(MR 2), COGNOS Series 7 VERSION 3, Business Objects 3.1, Crystal Reports. Pentaho 5BI

COGNOS 8BI, 10 BI: Analysis Studio, Cognos Connection, Event Studio, Framework Manager, Query Studio, Report Studio, Transformer, Active Reports, Cognos Express, Cognos Mobile, Cognos Workspace and Cognos Workspace Advanced

Business Objects 3.1: Universe, Web Intelligence, CMC, Crystal Reports, Import wizard

COGNOS Series 7 VERSION 3: Impromptu Administrator, Impromptu, Impromptu Web Reports, COGNOS Architect, COGNOS Power Play Transformer, Power Play User, Power Play Web Reports, Power Play Enterprise server, Upfront Administration, Access Manager LDAP Server, Configuration Manager, Visualizer .

PENTAHO 5.3, 6.1: PDI, Analysis Reports, Interactive Reports, Dashboard, Manage Data Source, Scheme Work Bench, Metadata Model, Administration

ETL Tools: Informatica 9.1, Informatica Power Center 9.1, Data stage 6.0, Oracle warehouse Builder 10g,11g, Pentaho Data Intigration

Operating Systems: Windows 95/98/NT/XP/2000/7,UNIX

Data Bases: Vertica 8.0,ORACLE 7.x /8i, 9i, 10g, 11g R2 (Rac), SQL Server 2005, 2000, and MS- Access

Languages: PL/SQL, Unix Shell Scripting, HTML, DHTML, JSP, Java, .Net Technologies, HTML Coding, Java Script Coding, jQuery.

Database Modeling: Erwin 4.1, Visio2000

Database Tools: Toad, SQL Developer, SQL*Plus

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

BI Analyst III

Responsibilities:

• Administer Pentaho Environments in Dev, Test and Production domains
• Work with Support to solve various Pentaho issues faced by Team,
• Work on Performance issues in Pentaho.
• Design and optimize data mart schemes in order to handle the dimensions and measures required
• Create Schemas using Pentaho Infrastructure for Reporting & Analytics
• Serve as sole subject matter expert in the development of business intelligence reports and analysis
• Research and integrate external data sources into USACs OLTP and Data Mart environment
• Manage reporting environment including report data sources, security, subscriptions and metadata
• Assist in data normalization and data integrity initiatives across the enterprise
• Assist Data Warehouse Engineers in identifying and revising enterprise reporting requirements
• Evaluate, test and implement new or upgraded software
• Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
• Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
• Work directly with business owners and analysts in the development of requirements and user stories for data solutions
• Assist with the development of data related APIs for the exposure of USAC data to external customers
• Audit reporting on usage and performance.
• Conduct end user training on reporting system

Environment: Pentaho BI Suite 5.3, 6.1 (PDI, Analysis Reports, Interactive Reports, Dashboard), Manage Data Source, Scheme Work Bench, Microsoft SQL Server 2008, SQL Server Business Intelligence Studio, Visual Studio 2010, Oracle 11g, PostgreSql, Vertica 8.0,Agile.

Confidential, Washington, DC

BI Administrator/ Sr. Developer

Responsibilities:

• Work 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.
• Installed, configured and administered various Cognos components, such as the Cognos BI Server, Framework Manager, Transformer, Cube Designer, Dynamic Cubes and Content Store.
• Build the Models, Cubes, and Packages using 8BI, 10 BI Framework Manager and published the Packages to Cognos Connection.
• Worked with Business Users for requirement gathering and create requirement specification documents.
• Created Dashboards using Work Space Advanced, and trained users to use work space for there adhoc reporting or querying.,
• Closely worked with ETL team and design data marts by understanding user requirements and increasing the reporting efficiency.
• Installed and configured of Cognos Version 8.4, 10.1.1, 10.2.1 (DEV, QA, PROD environments) .
• Involved in creating Star Schema Metadata models (Using multiple data sources) using Framework Manager and setting up Governors.
• Involved in setting up the Security to Cognos FWM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Created List Reports, Dash Board Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters, formatting of reports.
• Worked extensively on creating complex Query Prompts, Calculations, Conditions and Filters in the reports and framework manager packages.
• Created the Dashboard portlets using portal tabs in Cognos connection using Cognos viewer and navigator.
• Created Active Reports for specific data needs.
• Involved in basic user training, product documentation, user test documentation.
• Supported Production environment 24X7.
• Worked with Various departments in organization and created core reports like Balance Sheet, Income statement, Budget Reports, DGR, Key Dates, Repayment Schedule etc.
• Used Java Script to optimize the look and performance of Cognos reports.
• Customized Cognos connection look and feel with client name and logo.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• As part of ACBS project (Portfolio Management System), Business Objects is used to create reports from the DATA MART provided by Fidelity.
• Involved in complete Architectural Design of BO XI 3.1.
• Involved in the designing and Building of Universes, Classes and objects
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe
• Customized Universe level Prompts as per Functional Requirements.
• Check the integrity of the Universes, and export the universes to Repository for making available to users
• The project involved in the development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail and Formulae.
• Created Standard Reports utilizing all the features on Web Intelligence in BO XI 3.1 like Optional Prompts, Functions etc.
• Developed WebI Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Cross-Tab).
• Worked on various Business Object Reporting functionalities such as Slice and Dice, Master/detail, User Response function and different Formulas.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the Webi reports.
• Extensively worked with formatting the reports according to the user requirements.
• Scheduling Reports, Invoices to generate save to external file.

Environment: COGNOS 10.2.1, 10.1.1,8.4 (Frame work Manager, Analysis Studio, Metric Studio, Report Studio, Query Studio, Cognos Workspace, Cognos Workspace Advanced, Active Reports), Business Objects 3 .1 (Full Client, Designer, Reporter, Web Intelligence, Info View, Publisher, Import Wizard, Central Management Console, Central Configuration Manager ), .Net Technologies, ISS, Tomcat, Server Administration, Report Administration, Oracle Warehouse Builder 10g, Oracle 10g, TOAD, Oracle 10g,11gR2 Rac, TOAD

Confidential, Milwaukee, WI

Cognos Administrator/ Developer

Responsibilities:

• Worked on designing reports through Crystal Reports using Stored Procedures and non-SQL data sources.
• Used Crystal Reports to simultaneously access multiple SQL and non-SQL data sources to design enterprise reports
• As part of R-log conversion project redesigned different Customer Service and Manufacturer reports from crystal reports into cognos reports.
• Worked closely with Database team and data warehouse team in setting up the databases and worked on managing users, groups and roles from active directory.
• Involved in setting up different project databases like Oracle, SQL server and imported and managed users, groups and roles from active directory.
• Closely worked with ETL team and design data marts by understanding user requirements and increasing the reporting efficiency.
• Created staging areas to copy data from source systems.
• Involved in the installation and configuration of Cognos Version 8.3 .
• Involved in creating Star Schema Metadata models (Using multiple data sources) using Framework Manager and setting up Governors and Determinants.
• Involved in setting up the Security to Cognos FWM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Created List Reports, Dash Board Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters, formatting of reports.
• Worked extensively on creating complex Query Prompts, Calculations, Conditions and Filters in the reports and framework manager packages.
• Created the Dashboard portlets using portal tabs in cognos connection using cognos viewer and navigator.
• Extensively used Metric Studio to create performance metrics and watch rules.
• Involved in basic user training, product documentation, user test documentation.
• Used Java Script to optimize the look and performance of cognos reports.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.

Environment: COGNOS 8.3 (Frame work Manager, Analysis Studio,Metric Studio, Report Studio, Query Studio), ,Crystal Reports 10, Server Administration, Report Administration, Access Manager, Upfront, Cognos 8 SDK, Informatica 9.1, Informatica Power Center 9.1, TOAD, MS SQL Server 2005.

Confidential, Greenville, SC

Cognos Administrator/ Developer

Responsibilities:

• Work 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.
• Installed, configured and administered various Cognos components, such as the Cognos 8BI, ReportNet- Framework Manager and Content Store.
• Build the Models, Cubes, and Packages using 8BI Framework Manager and published the Packages to Cognos Connection.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Developed Complex Reports in Report Studio, AdHoc Reports in Query Studio, Multidimensional Data Reports in Analysis Studio, Scorecards and Dashboards in Metric Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for their several projects TLC and LTC Claims.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters and used Text Box, Value, Date time prompts.
• Involved in the Installation and Configuration of Cognos 8 SDK to programmatically create or modify reports by using the Cognos 8 software development kit (SDK) to implement the reports in Cognos 8 environment.
• Modified a group of reports that have a common change request using SDK
• Automated the process of Import and Export in the deployment using SDK.
• Customized the User's Portal Pages based on Organization using of SDK
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio and Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Involved in Migrating catalogs, reports into version 8 using migration utility tools.
• Migrated several reports from version 7 to version 8.
• Integrated the existing security with Report net Security.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes, deployment and provided drill-through targets to another Cube, Power Play Portable Reports, Impromptu reports and ReportNet reports.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• In the order of bursting reports, distributed and scheduled reports to online, email.
• Provided technical assistance, training and mentoring to Users and Business Partners.

Environment:: COGNOS 8BI (Frame work Manager, Analysis Studio, Event Studio, Metrics Studio, Metrics Designer, Report Studio, Query Studio), COGNOS ReportNet 1.1 MR2 (Framework Manager, Report Studio,Query Studio, Cognos Connection), COGNOS 7.3 (Impromptu Administrator, IWR, Power Play, Transformer, Power Play Enterprise Server, Power Play Web, Server Administration, Report Administration, Access Manager, Upfront), Cognos 8 SDK, Data Stage, Oracle 10g, TOAD, MS SQL Server 2005 and Win2K.

Confidential, Memphis,TN

Cognos Developer/Administrator

Responsibilities:

• Involved in Installation and Administration of Cognos Series 7 Tools.
• Created catalogs using Cognos Impromptu 7 to generate reports.
• Created different types of reports like Drill through reports, Sub reports, and List reports using Cognos Impromptu.
• Created users and changed their profile as per the requirement.
• Created standard filters, calculations, prompts and conditions in catalog.
• Enhanced existing reports and created new reports as per requirements.
• 8 Designed report sets with user class mapping and published to different news boxes in Upfront in IWR server.
• Created DB links in database to generate Impromptu reports using two databases.
• Designed models by mapping business needs using Power play Transformer and created multi-dimensional cubes, cube groups, power play reports.
• Decreased the cube build times drastically and increased runtime performance.
• Maintained the Cognos Query Models, Impromptu, IWR, Cognos Power play and Power play Web Server Administrator
• Updated the Java Environment for the Report Net Installation on the server
• Used the HTML Items in the Reports for various Prompt customization options.
• Scheduling Reports by passing various prompt values is automated using Java Script Code.
• Implemented security and granted privileges according to user classes using Access Manager.
• Used shell scripting to start the application.
• Used shell scripting to monitor the users who are logged into the server and if the user is idle for certain period then that particular session is killed.
• Provided training to end users on Cognos Impromptu, IWR and Power play
• Upgrade of Cognos products from Version 7.0 to 7.1.

Environment: Cognos Impromptu 7.1, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1, Cognos Power Play Transformer 7.1, Cognos Power Play Enterprise Server 7.1, Cognos Upfront 7.1, Access Manager 7.1, Configuration Manager 7.1, Business Objects, HTML Coding, Java Script Coding, SQL Server, Erwin, Ms-Excel, UNIX, Unix Shell Scripting, Windows NT

Confidential

Software Analyst/SQL Developer

Responsibilities:

• Participated in resolving multi-tier architecture issues.
• Transferred knowledge using a strategy document describing requirements and issues.
• Created customized database with appropriate table spaces to increase the performance.
• Created SQL scripts to schedule the Backup jobs.
• Created stored procedures and packages to view, update and enter the check-in and checkout procedures.
• All the transactions were archived into files using UTL-FILE packages.
• Created lot of views to protect critical information from normal users.

Environment: Oracle 7.x, PL/SQL, SQL, MS-SQL Server, Forms 4.5/ Reports2.5