SUMMARY

• Completed Bachelor of Engineering and Certified Confidential Professional with around 9 years of IT experience with Software Development Life Cycle (SDLC). Expertise in Installation, Configuration, Upgrade, Analysis, Design, Development, Customization, Implementation and Testing of various Software applications and generation of reports using Various Databases.
• Interacted with end users and business clients to gather there report requirements.
• Prepared project relevant documents - Report Specifications, Report testing documents, Report deployment documents and ETL specifications.
• Captured meeting minutes and prepared agenda for the BI project.
• Extensive experience in working with Confidential 10.1.1, Confidential Mobile, Cognos10.1 VVM, Confidential insight,Cognos8.4, Confidential 8.3 Report Net 1.1, Confidential 7.4 series Report Studio, Query Studio, Analysis Studio, Impromptu, Transformer, Power play.
• Recent experience with Confidential 10.2 Installation and configuration and over 2 years worked with Confidential 10.1.1 BI modeling, Report Studio, Query Studio and Analysis Studio.
• Over 5 years of hands on experience in Confidential 8 (Framework Manager, Report studio, Query Studio, Analysis Studio and Confidential connection).
• Extensive experience in working with Cognos10.1.1, Confidential 10 Mobile, Cognos10.1 VVM Confidential 8.4, Confidential 8.3, Report Net, Query Studio, Report Studio, Impromptu, Transformer, Power play, Involved in migration of reports from Confidential 8.4 to Confidential 10.1.1
• Experience installation and configuration Confidential 8.3, 8.4, 10.1.1 servers, Installing Oracle 11g client and configuring with Confidential BI server, Configuring Confidential 8.3,8.4, 10.1 BI server with IIS 6.0 & ISS 7.0,Installtion and Configuration Confidential Access Manager, Configuration with LDAP. Enable single sign on in Confidential BI server.
• Experience in installation and configuration of Confidential Virtual view Manager
• Experience in installation and configuration of Confidential 10.1.1 mobile and integrate with Apple Ipad Confidential mobile app
• Experience in installing and configuring Confidential 10.1 Framework manager
• Integrating Confidential 8.3 with Java front end application through Confidential SDK
• Experience with integrating the SAP BW, Netezza, RDB (ODBC connection) to Confidential Framework Models and reports.
• Experience with Confidential admin activities (i.e.) creating new roles and user groups, Performance tuning of Confidential server (dispatcher settings),Periodic health check of Confidential BI server, Periodic back up of Content store, Save the report file into external share drive, Performance tuning of reports and Packages
• Implemented report folder Security and created user classes as per the requirement.
• Designed and Developed Projects, Packages, Reports using Framework Manager, Query Studio and Report Studio, Analysis Studio, Confidential business Insight, Confidential business insight advanced
• Designed and developed dynamic dashboards to evaluate the Company’s performance.
• Extensive experience in creating complex Lists, Cross Tabs, Charts and Repeater in Report Net and Confidential 8 BI and Confidential 10 BI
• Creating conditional Block, Conditional formatting, Render variable (Boolean, string, Language),Creating Multilingual report, Drill through reports,
• Created DMR models and relational Model - Import database tables defining database layer, presentation layer, business layer, defining proper cardinality, applying determinants, apply row level and object levels security, applying embedded/standalone filters, providing multilingual support to package, publishing package and applying package security.
• Experience with Deployment, scheduling, automated report bursting and delivery via email.
• Database experience using Oracle 11g/10g/9i, DB2, MS SQL Server, MS Access, Netezza, oracle RDB
• Experience in working OBIEE 10.1.3, creating, modifying the existing reports in Answers, Report Ibot, Schedule and deliver the report to user mail box using Delivers, Creating new users and assign them into proper role, applying folder level security
• Creating / updating the existing RPD in OBIEE
• Stop and start the OBIEE servers installed in Unix and windows Operating system
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server.
• Strong understanding of Relational database design concepts and in depth knowledge of OLAP solutions.
• Good knowledge of ETL. Extensive knowledge in Monitoring Daily jobs in DAC (Data warehouse administration console)
• Good knowledge in creating new jobs/ updating existing jobs in Informatica 7.1.2
• Having strong knowledge in the financial, Sales, Manufacturing domain.
• Good Analytical and Communication skills and work independently with minimal supervision

TECHNICAL SKILLS:

Confidential BI Series 8.3, 8.4:   Confidential administration, Confidential Connection, Query Studio, Analysis Studio, Report Studio, Event Studio, Framework Manager

Confidential BI Series 10.1.1:   Confidential version 10.1.1, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Framework Manager, Confidential 10.1.1 Mobile

Other BI Tools:   Report Net CRN 1.1 MR2, Power play, Impromptu, Transformer Confidential Access Manager, Confidential EP 7 series Manager, Confidential Report Net, Confidential 8 SDK, Jasper

OBIEE 10.1.3:  OBIEE Answers, Delivers, Administration

ETL Tools: Informatica workflow designer, Workflow manager Workflow Monitor, DAC (data warehouse admin console)

Project Management Tools: IBM Clear quest, IBM Clear case, VSS, Remedy

Databases: Oracle (9i, 10g & 11g), Toad, sql developer, SQL Server

Operating Systems: Windows 2003/XP/2008 R2, UNIX, AIX

WORK EXPERIENCE

Confidential, Shelton, CT

Admin / Solution Architect

Responsibilities:

• Setup entire Confidential environment including installation, configuration, IIS set up, creating virtual directories and Enabling single sign on.
• Upgrade Confidential content store, Migrate Confidential roles and user groups. Involved in creating custom roles
• Set up Framework Manager Including Installation, Configuration and migrate the existing packages and Models.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Install and configure IBM Confidential Mobile and integrate the Confidential application with Ipad.
• Involved in business requirement gathering, Interact with business group. Developing new reports in OBIEE 10.1.3 answers and set up Ibot to schedule a report to user mail box.
• Involved in creating new group and users in OBIEE and assigning them different level of permission
• Involved in updating the RPD and publishing to web
• Involved in creating new Jobs in informatica based on business requirements
• Involved in Confidential virtual view Manager setup and Integrate Confidential insight with Confidential 10

Environment: Confidential 10.2, Confidential 10.1.1, OBIEE 10.1.3, Informatica 7.1.2, DAC, Cognos10.1.1.Mobile, Confidential VVM

Solution Architect

Confidential

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
• Built Framework Manager Models and Published Package, Implemented Confidential independent row level security based on Business units.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Validated the Data Loads in the Cube using Analysis Studio
• Developed Lease Monthly and Daily reports based on DMR Models
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues.
• Performed Unit testing on Dev and supported the users on UAT and Production
• Developed and Maintained technical documentation of the implementation.
• Assisted the users on Production for the latest enhancements and production fixes.
• Involved with Scheduling and Distributing Reports through Schedule Management in Confidential Connection and Bursting reports to different user groups
• Developed and distributed the Active reports in Confidential 10.

Environment: Confidential 10.1.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio) Oracle 11g, Data stage

Solution Architect

Confidential 

Responsibilities:

• Understand user requirements and Data Model defined and developed by the business analysts and data architects in Erwin Data Modeler to understand the underlying relationships between the tables.
• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using three layer semantic approaches.
• Built and Developed Models in Confidential 8.3 and published it to Confidential Connection as Data Source, created packages using Framework Manager.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Confidential Security - Data Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Designed and Developed Advanced Prompt Pages using various varieties of Prompts and validating the Prompts using Java Script.

Environment: Confidential 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Confidential Connection), Data stage, Windows Server 2008, Erwin7.3, Oracle 11g

Sr. Consultant

Responsibilities:

• Modeled and Reported against a Dimensional Database which is in the form of a Star Schema.
• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using multi-layer Approach and Modeling best Practices to meet the reporting requirements.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Confidential Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Developed Hierarchies and Measures to support Adhoc Reporting, Multi-Dimensional Reporting.
• Published Packages to Confidential Connection and implemented Package Level Security.
• Managing User ID’s and User groups like Providing Privileges to the users and User Groups in Access Manager.
• Using Transformer cubes as data source import into Framework Manager, and created Models, packages for Analysis Studio.
• Created highly Complex Reports using OLAP Cubes as Data Source for Multi-Dimensional Analysis.
• Automated the Monthly cube refresh Process using Command Line options and scheduled it using Windows Scheduler.
• Developed Report Templates for Standard and Adhoc reporting to make the Reports look Consistent.
• Developed List, Cross Tab and Chart Reports for different Views of Data.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail and secured the Reports and Folders to specific user groups.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved with Scheduling and Distributing Reports through Schedule Management in Confidential Connection and Bursting reports to different user group

Environment: Confidential 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio),Transformer, Oracle 10g,Informatica8.1

Sr. Consultant/Admin

Confidential 

Responsibilities:

• Modeled and Reported against a Dimensional Database which is in the form of a Star Schema
• Involved in Business Requirements gathering along with Analysis team and participated in designing in Functional Design and writing detailed Technical Design documentation.
• Developed DMR Model for Standard Reporting, Adhoc Reporting and for Multi-Dimensional Analysis using multi-layer Approach and Modeling best Practices to meet the reporting requirements.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Confidential Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.
• Implemented various reporting Techniques like Drill up, Drill down and Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting.
• Generated SQL/MDX and analyzed Confidential SQL, Native SQL to trouble shoot the report issues.
• Tuned the Performance of the reports using Performance tuning techniques and ensured that reports run faster.

Environment: Cognos8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Power play Transformer, Power Play, Oracle 10g,TOAD,Access Manager, Windows 2003 Server

Sr. Consultant/Admin

Confidential

Responsibilities:

• Modeled and Reported against an Operational Data Source(OLTP).
• Extensive interaction with Business Users and gather information and requirements.
• Upgraded Report Net Models and reports to Confidential 8.2.1 Environment.
• Created several List, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text box, Date, Interval, Cascading, tree prompts).
• Used Conditional Blocks, Conditional Formatting to merge 2 or more Confidential Report Net reports and developed Consolidated Reports in C8
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query studio.
• Generated SQL/MDX and analyzed Confidential SQL, Native SQL to trouble shoot the report issues.
• Performed Unit Testing to verify if the Actual Results meets the Expected.
• Deployed Packages, Reports to Test Environment using Content Administration.
• Involved in creating OLAP hierarchy, Dimensions, formulas & power cubes using Confidential Transformer and Reports using Power Play.
• Created Member based Security, Custom Views, Dimension Views, Apex Custom views, Cloak.
• Added Drill through reports to another cube (.mdc file) from the same model, to overcome row or category limitations

Environment: Confidential 8.2.1(Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio), Report Net 1.1 MR3, SQL Server 2005, TOAD, Access Manager, IIS, Windows 2003 Server, Confidential Power Play Transformer, Confidential Power Play, Power Play Enterprise Server

Sr. Confidential Consultant

Confidential 

Responsibilities:

• Analyze and understanding the client requirements based on High level design document and existing model.
• Preparing the Detailed design document of Framework manager for production environment as well as Adhoc environment.
• Creating the Test cases for Framework manager and Reports.
• Importing the query subjects from database and creating joins, Star schema grouping in Framework manager.
• Creating Model and publishing the package in to report environment
• Testing the package in Report environment
• Modeled and Reported against an Operational Data Source(OLTP).
• Extensive interaction with Business Users and gather information and requirements.
• Created several List, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text box, Date, Interval, Cascading prompts).
• Used Conditional Blocks, Conditional Formatting to merge 2 or more Confidential Report Net reports and developed Consolidated Reports in C8

Environment: Confidential 8.2.1(Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio), ORACLE 9i, TOAD, Access Manager, IIS, Windows 2003 Server

Sr. Confidential Consultant

Confidential 

Responsibilities:

• Analyze and understanding the client requirements based on High level design document and existing model.
• Preparing the Detailed design document of Framework manager for production environment as well as Adhoc environment.
• Creating the Test cases for Framework manager and Reports.
• Importing the query subjects from database and creating joins, Star schema grouping in Framework manager.
• Creating Model and publishing the package in to report environment
• Testing the package in Report environment
• Modeled and Reported against an Operational Data Source (OLTP).
• Extensive interaction with Business Users and gather information and requirements.
• Created several Lists, Cross tab, Chart, and Repeater Reports using Report Studio.
• Created reports having multiple Report Pages, Prompt Pages (with Select & Search, value prompt, text box, Date, Interval, Cascading prompts).
• Used Conditional Blocks, Conditional Formatting to merge 2 or more Confidential Report Net reports and developed Consolidated Reports in C8

Environment: Confidential 8.2.1(Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio), ORACLE 9i, TOAD, Access Manager, IIS, Windows 2003 Server

Confidential

Report Net Consultant

Responsibilities:

• Involved in Installing and Configuring Report Net Server, Framework Manager, Report Studio, Query Studio and Confidential Connection Portal.
• Interacted with business users for their requirement.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Developed packages and collections using PL/SQL.
• Published newly created impromptu reports to Upfront.
• Developed Standard templates in Report Studio for developing reports.
• Developing Drill through Reports, Cascading Prompts

Environment: Confidential Report Net 1.1, Framework Manager, Confidential Connection, Query Studio, Report Studio, Confidential Series 7.x, Impromptu, Powerplay, Powerplay Transformer, Access Manager

Confidential

Report Net Consultant

Responsibilities:

• Interacted with business users for their requirement.
• Developed and Published Packages in Framework Manager -
• Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Developed Standard templates in Report Studio for developing reports.
• Developing Drill through Reports, Prompts

Environment: Confidential Report Net 1.1, Framework Manager, Confidential Connection, Query Studio, and Report Studio