CAREER SUMMARY:

• Working as Technical Architect with around 10 years of experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using BI - Data Warehouse/Data Mart Design, ETL, OLAP, and Client/Server applications.
• Excellent knowledge on data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• Having very strong experience on Cognos 10.x,8.x,Reportnet and Cognos Series 7.x (Impromptu, Powerplay Transformer, Powerplay for Windows and IWR (Impromptu Web Reports)
• Strong knowledge on Installation & Configuring the Cognos 10.x/8.x/7i tools in distributed environments on Windows/Unix.
• Proficient in IBM Cognos Technologies such as Report Studio, Query Studio, Analysis Studio, Event Studio & Frame Work Manager.
• Proficient in building COGNOS reports using relational data models, as well as enhancing, customizing, and managing professional reports.
• Extensive expertise in the various faces of Data warehousing - Requirements elicitation, data modeling, ETL development and reporting solutions.
• Adept in COGNOS Framework metadata modeling for predictable reporting and analysis results using Cognos ad-hoc environment (Query studio).
• Exposure to all phases of the report development life cycle including requirements gathering, analysis, design, coding & unit testing and deployment.
• Experienced with migration of Cognos code (reports/models/ Frameworks) from one environment to another.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Creation of Relational and DMR models using Framework manager.
• Coordinates training, support and best practices for users and conducts in-house training, support and best practices for users and conducts in-house training and mentoring the user requests, documenting system requirements, data modeling and data analysis.
• Performed different Test scenarios (Unit, Integration and System Integration testing).
• Good Knowledge of DBMS, Data Modeling, Performance Tuning and Supporting Enterprise Reporting Applications.
• Strong work experience with Business users to analyze the business.
• Excellent Communication and interpersonal skills Ability to work effectively in a team as well as individually.
• Manages offshore team duties and prepares weekly status updates.

TECHNICAL SKILLS SUMMARY:

Reporting Tools: Cognos10.x & 8.x (Framework Manager, Cognos connection, Query Studio, Report Studio, Analysis Studio, and Event Studio), Active reports, Business Insight and Business Insight Advance, CRN 1.1 MR3, Cognos EP Series 7.x ( PowerplayTransformer, Architect Model, Power play Windows/Web, Impromptu, Upfront),Cognos TM1, SAP Business Objects XI 3.1, OBIEE (11.1.1.7)

ETL Tools: Informatica 7.X, Data Stage 7.5.2,Oracle Data Integrator (ODI 11.1.1.7)

Web Scripting: HTML, JSP XML, Java Script

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, Windows XP Professional, UNIX-AIX

Web Servers: IIS,Tomcat and Apache

Application Servers: Web logic and OAC

Databases: Oracle, SQL Server 2000/2005,Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Warren, New Jersey

Environment: Cognos 11.XSuite (Dashboards, Data Modules, Framework Manger, Report Studio, Query Studio, Analysis Studio, and Event Studio, Active Reports), Oracle 11g.

Responsibilities:

• Leading the offshore team of 10 members
• Involved in Business analysis and requirements Analysis and Design phase.
• Created Active reports by using Cognos 10.
• Creating Business Technical design documents for different interfaces.
• Performed analysis with end users and business process owners in order to determine and document requirements for the design, development, and implementation of new system.
• Involved in preparing the estimations based on impact analysis and technical requirement document.
• Worked with cross-functional team members to recommend technical solutions to business issues and system issues.
• Implementing Row level Security, Object Level Security and Package Security in Framework Manager.
• Created different types of reports and dashboards by using Report Studio and Query Studio.
• Crated Complex reports by using Drill Through, Master Detail and Conditional Formatting techniques.
• Bursting the reports by using Report Studio.
• Troubleshoot Cognos Server Environment for the better performance
• Implementing securities and permissions to Packages, Folders and Folder Objects (Reports, Dashboards and Cubes).
• Responsible for overseeing the quality procedures related to the project.
• Designed and Developed Multi-Dimensional Cubes using Power Play Transformer.
• Installation and Configuration of the servers in Distributed environment (Web, Application and Data servers).
• Served as liaison between offshore developers and end users in translating business requirements to technical designs and applications.

Confidential

Environment: Oracle Data Integrator (11.1.1.7), OBIEE (11.1.1.7), Oracle 11g.

Responsibilities:

• Managing the team of 15 members.
• Report status to stakeholders, mitigate risks, coordinate meetings, set agendas, and assign action items
• Manage the client relationship, address client requirements, meet the projects specifications and deadlines, and ensure client satisfaction
• Direct the project team through the full system development lifecycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation, and support
• Conduct reviews of team projects on a routine basis, sought information about completion obstacles, and aligned teams as necessary or managed customer expectations as necessary
• Independently evaluate system impacts and produce technical requirement specifications from provided functional specifications
• Analyzing the data and developing Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Mentoring the team in setting up the Topology, models for the data sources - flat files, MS SQL server, Oracle.
• Working closely with the Data Architect,. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Assisting the development team in developing interfaces to load the data from source systems to stage and from stage to Oracle HUB, ODI packages, scenarios using interfaces, variables, procedure.
• Performance tuning the ODI interfaces
• Mentor the development team on OBIEE development
• Assisting is developing OBIEE Repository & dashboards
• Assisting in performance tuning from DHW to OBIEE queries Implemented best OBIEE development practices

Confidential, Warren, New Jersey

Environment: Cognos 10.XSuite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, and Event Studio,Active Reports,Business insight, Business Insight Advace), Oracle 11g.

Responsibilities:

• Involved in Business analysis and requirements Analysis and Design phase.
• Involved in migration of the Universe and reports from BO to cognos10.
• Creating Business Technical design documents for different interfaces.
• Performed analysis with end users and business process owners in order to determine and document requirements for the design, development, and implementation of new system.
• Involved in preparing the estimations based on impact analysis and technical requirement document.
• Worked with cross-functional team members to recommend technical solutions to business issues and system issues.
• Designed models using Framework Manager and published packages to the Cognos Connection.
• Implementing Row level Security, Object Level Security and Package Security in Framework Manager.
• Created different types of reports and dashboards by using Report Studio and Query Studio.
• Crated Complex reports by using Drill Through, Master Detail and Conditional Formatting techniques.
• Bursting the reports by using Report Studio.
• Troubleshoot Cognos Server Environment for the better performance
• Implementing securities and permissions to Packages, Folders and Folder Objects (Reports, Dashboards and Cubes).
• Created Models by using Power play Transformer and building the cubes.
• Responsible for overseeing the quality procedures related to the project.
• Installation and Configuration of the servers in Distributed environment (Web, Application and Data servers).
• Served as liaison between offshore developers and end users in translating business requirements to technical designs and applications.
• Created Active reports by using Cognos 10.

Confidential, Warren, New Jersey

Environment: Cognos 10.1 & 8.x Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio), Oracle 10g/11g.

Responsibilities:

• Involved in understanding the Business needs and Customer requirements by participating in the Design Phase, user requirement gathering.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for reports.
• Involved in Framework Manager Modeling - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Designed and Developed Multi-Dimensional Cubes using Power Play Transformer.
• Designed Multi-Dimensional Reports using Analysis Studio.
• Involved in effort estimation based on the complexity of the business and the report design.
• Understand the security model and implemented the Row-Level Security according to the requirements.
• Developed Reports using Conditional Formatting and Cascading Prompts Developed List, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Resolving the Performance issues of the Reports.
• Implemented security for Data access, Object level access and Package access.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Schedule management - Daily, Weekly, Monthly, and Quarterly and Yearly reports.
• Testing reports using review checklists (SQL Scripts) for Quality Assurance before delivering to the end users.
• Installation and Configuration of the servers in Distributed environment (Web, Application and Data servers).
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Understanding of Cognos BI security model and implement the security (Data Security, Object and Row level Security) according to the requirements.
• Managing Multiple Dispatchers, Content managers and Content Store in Multi-server environment.
• Responsible for back up Cognos 8 BI data and tune the Cognos 8 BI Environment.
• Troubleshoot the server Environment by using logs.

Confidential

Environment: Cognos 8.2/8.4 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Power play Transformer, Power play cubes, Oracle

Responsibilities:

• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Used filters for efficient data retrieval.
• Share point reports maintenance and Schedule management for the daily email reports.
• Modifying the existing report based upon the change request by the user.
• Creation of various reports by using Planning cubes as sources for the forecast analysis.
• Customizing Cognos Connection Portal based on user specifications.
• Created business models based on power cubes, published to the portal and created daily, Monthly reports based on published package.
• Deployment of reports from Development to Production.
• Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Migration to the Cognos 8 platform in a distributed environment.
• Interacting with the Cognos support team and creating & following-up the cases in the Cognos support site.

Confidential

Software: Cognos 8.2 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Oracle 9i, UNIX

Responsibilities:

• Built Framework Model, and established the cardinalities to suit the business needs.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Modifying the existing report based upon the change request by the user.
• Customizing Cognos Connection Portal based on user specifications.
• Created business models based on power cubes, published to the portal.
• Migration to the Cognos 8 platform in a distributed environment

Confidential

Software: Cognos ReportNet 1.1 MR2, Oracle 8i, Window 2000.

Responsibilities:

• Analysis of the requirements for the creation of CRN reports.
• Involved in the design and development of CRN reports in Report Studio.
• Developing Standard Reports, List, Crosstab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio and Query Studio.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Experience with conditional blocks and conditional layouts.
• Upgraded the existing (Cognos ReportNet 1.1 MR2) Models and Packages to Cognos 8 BI environment.
• Converted the existing ReportNet 1.1 reports to Cognos 8 BI reports.
• Troubleshoot the errors during the upgrade process.
• Manage Cognos Portal and all content in the portal.
• Interacting with the Cognos support team and creating & following-up the cases in the cognos support site.