SUMMARY

• Results - oriented and certified professional with over 8 years of experience in the Analysis, design, and implementation of business intelligence systems, Reporting tools, OLAP environments.
• Excellent analytical and organizational skills in Meta Data Modeling, Data Mapping RDBMS, ETL processing, Data Movement, Data Conversion, design and development of applications.
• 7+ years Business Intelligence experience using Cognos Series 7, ReportNet, Series 8 and Series 10 - Impromptu 7.1/6.6/6.x, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, Cognos DecisionStream, Scripting, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Map Manager, Business Insight, Business Insight Advanced, Active Reports.
• Recent experience with Cognos 10.1 version, installation and configuration, development of Active reports, Dashboard reports using Business Insight, Business insight advanced. Experience in Migration of the applications from Cognos Series 7 to Report Net and 8BI and upgrading the cognos content from cognos 8.x to Cognos 10.x
• Excellent experience in complete project life cycle of Business intelligence - Administration, Business analysis, Meta data Modeling, security analysis, Development, testing and user training, documentation.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms. Expertise in defining the multi-tiered Cognos Architecture, Security infrastructure and Deployment work flows from Prod, Dev and Test environments. Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in Oracle and SQL Server
• 7 years of experience using Oracle 8i/7.x, Developer 2000, DB2, PL/SQL, SQL*Plus, Win NT 4.0, Linux. Experience in Oracle PL/SQL programming (Collections: Nested tables/VARRAY, Functions, Procedures, Packages, Triggers, Indices and database objects) and Shell Scripting (C Shell, K Shell, Bourne Shell). Posses advanced MS Excel and MS Access skills
• Extensively worked on performance tuning of the existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization. Experience in coming up with data cleansing, backup and restoration strategies.
• Excellent communication and documentation skills & Expertise in gathering requirements and end user training.

TECHNICAL SKILLS

Cognos tools: Cognos version 10.1, Business Insight, Business Insight Advanced, Active Reports, Report Studio, Event Studio, Framework Manager, Cognos for MS Office, Analysis for MS ExcelCognos 8 & 7Cognos version 8.3 & 8.4, Cognos Connection, Metric Studio, Query Studio, Analysis Studio, Report Studio, Event Studio, Framework Manager, Cognos 8 Go Office, Office Connection, Metrics Designer, Metric Studio, Map Manager, Cognos ReportNet, Impromptu, Transformer and Upfront, Architect, PPES, Access Manager, Cognos Query, Visualizer, Notice Cast, IWR, Cognos EP, Cognos Metrics Manager.

ETL Tools: Informatica Powermart / PowerCenter, Cognos Decision Stream.

Programming: Visual Basic, Java, C, Pro*C, SQL, SQL/2000, PLSQL, C++

Internet Technologies: HTML 4.0, VB.NET, JavaScript, ASP.

Front End: Developer 2000, MS Excel and Visual Basic.

Databases: Oracle (7.x, 8i, 9i & 10g), Sybase, DB2, SQL Server, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Tech Lead / Sr. Cognos Analyst

Responsibilities:

• Assisting the client, through analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with Business users and collected business information and their requirements for developing the project.
• Analyzed the data needs and accuracy of the data for the report purposes.
• Acted as a bridge between the business users and technical users, translating the technical terms to business users and vice versa.
• Developed and maintained the technical design specifications of Meta Data Layer presentation and Report specifications documents with best practices
• Scaled the production environment from a single server to a multi-tiered architecture that included 4 application servers and 1 web gateway server to allow more concurrent users
• Install Multi-server Dispatcher Cognos installations for Dev/QA/Pseudo Prod/Prod Environments. Crete/Maintain Cognos User classes and groups with Windows Role Based Structure and user account provisioning. Created the Data source connections, maintained the migration of the content from DEV to TEST to PROD
• Install/setup Cognos 10.1 software. Upgraded the Models, Reports and cognos 8.4 content from Cognos 8.4 to Cognos 10.1 Troubleshoot upgrade problems/fix issues
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
• Published IQD’s which are used as Datasources in Cognos Transformer to build a cube, by prepraring the Meta data in Frame work manager and externalizing the query subjects.
• Implemented Cognos independent row level security based on the Geography and Business units, from the database security tables.
• Implemented the Data level, row level and object level security and also administred the permissions given to the packages, Cubes, folders and reports.
• Enhanced the Framework Models and Transformer Model to suit the user requirements.
• Validated the Data Loads in the Cube using Analysis Studio
• Developed numerous multi tab, multi page, Mulit-Query, dashboard reports and regular reports based on the existing remedy database incident management system, with drill through functionality to the detail reports.
• Developed the dashboard reports and active reports with aggregate data metrics utilizing the 2D and 3D graphical UI.
• Added the Dashboard reports to the portal page and specified the order of the tabs that appear in the dashboard report portal. Converted the dashboards to Active reports in Cognos 10.
• 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 Java scipts for the custom functionality.
• Created and managed agents, events and tasks using Event studio, which monitors the CMB data and performs the task when an event occur.
• Generated SQL/MDX and analyzed Native SQL to trouble shoot the report issues and performance 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 Cognos Connection and Bursting reports to different user groups.

Environment: Cognos 10.1 (Framework Manger, Report Studio, Active Reports, Event Studio, Dashboard reports, Business Insight, Business Insight Advanced), Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Transformer), Cognos Transformer 7.4, Oracle 10g, Sybase IQ, Abinitio.

Confidential, New York, NY

Sr. Cognos developer / Admin

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Involved in the installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection portal with appropriate requests and security measures.
• Configured the Cognos server, Scheduled and monitored the reports and jobs schedules, Created Data source connections, administered the report, package, cube and folder permissions, created the user groups and roles based on the security requirements, migrated/deployed the cognos content from Development to test to Production environment.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Implemented Single sign on Security with LDAP and Group level security in Cognos Connection Portal.
• 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.
• 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 Cognos 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 Cognos 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.
• Used Event Studio to create agents and monitor the data.
• 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 Cognos Connection and Bursting reports to different user group

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio),Transformer, Oracle 10g,Informatica8.1,Oracle Streams, Active Directory, Oracle Access Manager, OID, Solaris, Sun One I Planet, Web Logic 10.2,Erwin, PVCS.

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Worked on Associate Reporting project used by 20 carriers and 500 Customer providers to monitor their incoming traffic and their funnel activity.
• Designed & implemented various reports for financial dashboards, P&L reports, Retention data, Billing data, Customer Acquisition, Email Marketing, IT & Sales Center, Enterprise wide reporting which left me with abundant subject, applications and data knowledge surrounding the Finance, Planning, Marketing, IT, Operations and Sales Center departments.
• Created metadata models, Namespaces, Folders, Query Subjects and Packages from SQL data source using Cognos Framework Manager.
• Involved in defining cardinality between query subjects.
• Involved in organizing the Framework Manager model into several different business views based on end user requirements.
• Generated projects and publishedpackagesusing Framework Manager.
• Developed list, Crosstab, chart and complex reports in report studio which involved prompts, cascading prompts, filters, drill through, master-detail relationships, and tabular models and enhanced reports using conditional formatting.
• Created daily, weekly, monthly and quarterly reports for the management team and sales center operation managers to run call-center using Report Studio.
• Created Query Prompts, Calculations, Conditions and Filters to generate efficient and user-friendly reports.
• Created multi page report based on multiple Master queries to show the data on different pages when the Master record changes in a Report.
• Developed reports with several prompts, (text box, value, select & search and date prompts) and cascading prompts.
• Involved in testing and improving report performance by optimizing the query performance and implementing appropriate prompts.

Environment: Cognos BI 8.4.1/8.3, Cognos Connection, Report Studio, Query Studio, Framework Manager, MS SQL server, SQL, Quality Center, Windows XP.

Confidential, Boise, ID

Cognos Developer

Responsibilities:

• Involved in Installation and configuration Cognos 8, Power Play and Framework manager.
• Extensively used Analysis Studio, Query Studio and Report Studio for Report design in Cognos BI version 8.
• Expert in designing multidimensional Model in Framework Manager in Cognos BI version 8.
• Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
• Built Framework Manager Models, and established the cardinalities to suit the business needs. Implemented security for Data access, Object level access and Package access.
• Developed complex dashboard reports using Report studio.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship.
• Testing and improving Report Performance.
• Developed Power play Reports, Power Cubes and Multi-Dimensional Cubes
• Created User Groups, Roles to implement the Cognos Security.
• Analyzed and explored complete SQL Server to reduce the process time.
• Involved in Deploying reports, packages from Development to Testing and then to Production environment.
• Worked as administration like creating users & giving permissions, including scheduling reports, creating jobs, Batch files and distributing reports.

Environment: Cognos 8.2, Cognos Connection, Frame Work Manager, Cognos Power play & Transformer 7.3, SQL Server, Windows.