SUMMARY

• Over 8+ years of professional experience as a Cognos Business Intelligence Project Lead, Administrator and CognosTechnical Manage, Developer - Analyst with key activities in all the stages of the project SDLC such as support, analysis, designing, testing, debugging and documenting Cognos BI solutions across multiple industries.
• Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Data Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
• Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
• Experience in understanding existing business processes, gathering business systems requirements analysis and design thereby converting into detailed reports for strategic decision making.
• Extensive experience working with Cognos 8.x/10.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio and Transformer, Dynamic Cubes, Workspace, Workspace Advanced, Power Play Studio, Cognos mobile) Applications.
• Designed and implemented enterprise wide Reporting strategies utilizing Business Intelligence (BI), Data warehouse, Data Analysis, Data Modeling, Data Mining techniques.
• Implemented the Enterprise level Cognos security and Server Administration using Cognos 10.x/8.x and administration of security using Access Manager, LDAP (ADLDS) and Custom Authentication Provider.
• Developed simple and complex reports including list, crosstabs and charts with drill-thru capabilities& report level calculations.
• Experience in Database coding using ETL tools, data mining techniques, installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, MY SQL and Oracle 10 series databases
• Extensive experience using various data sources such as Oracle, DB2, SQL Server and Access.
• Excellent knowledge on SDLC/Data Warehousing implementations using Star schema and Snow flake schema and developing reporting solutions from OLTP.
• Experienced in Migration of other reports into Cognos and version up-gradation in Cognos.
• Has worked on several requests from business towards building Report Studio reports, Query Optimization and Performance Tuning of all reports.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
• Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts.
• Responsible for Interacting with users and department directors to identify information needs and business requirements.
• Experience with the Enterprise level Cognos administration and Framework Development support, which includes the installation, configuration, administration and maintenance of a business-critical Cognos product set in a 24x7 production environment.
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas methodologies, dimensional data structures and complex hierarchies.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.

TECHNICAL SKILLS

Tools: Cognos 10.2.X, Cognos10.1.1, Cognos Mobile 10.1.1, Cognos Express, 8 Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Framework Manager), ReportNet 1.1 MR3/1.1 (Framework Manager, Report Studio, Query Studio), Cognos Impromptu 7.x/6.x, Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server, Modeling Tools Transformer & Framework Manger 1.1/8.x, Cognos10.

ETL Tools: Cognos Decision Stream and Cognos Data manager

Languages: SQL, PLSQL, HTML, XML, Java script.

O/S: Windows 2000/2003/2008/2012 server.

RDBMS: Oracle, Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, MY SQL and SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Cognos BI Admin/ Developer

Responsibilities:

• Defined Kraton’s BI technology architecture including database and reporting suite technologies.
• Provide design and implementation architectural solutions for data warehouse and data marts database design, ETL/data loading strategy, and business intelligence reporting data, taking into account system requirements, security, system extensibility and interoperability, costs, operations and support considerations, and BI best practices.
• Develop and maintain BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.
• Logical and physical data design modeling and implementation to meet business objectives and the needs of BI architecture other program deliverables.
• Provide an end to end solution and work with integration partner during design and implementation of the data warehouse, BI tool integration, and associated sub systems.
• Developed Complex ETL code through Data manager to design BI related Cubes for data analysis at corporate level.
• Formulated ETL processes to Extract Data from Operations DB to the Reporting DWH, Designed and developed Cognos EP models and Cubes.
• Work with MDM Data Governance Lead to implement processes to maintain integrity and quality of the data residing in the data warehouse and data marts.
• Design and implement production processing architecture, including performance monitoring, scheduling, and notification in the event of failures.
• Once deployed, responsible for day to day support of the data warehouse and marts, ETL integration, and BI application.
• ManageCognos BI licenses for projectlife cycle and reviewed the report design and documentation.
• Developed Windows Batch scripts for reports and cubes scheduling.
• Developed and Present POC on modeling, administration activities.

Environment: Cognos 10.2 and 10.2.2 BI versions, Report Studio10.2.2, Query Studio 10.2.2, Framework manager 10.2.2, Dynamic Cubes, IBM Cognos Business Insight, IBM Cognos Configuration, IBM Cognos Lifecycle Manager, Cognos 10.2 tool suite, Cognos Decisionstream 7.0 and SQL, PL/SQL, Windows 2008, 2012.

Confidential, New Brunswick, NJ

Sr. Cognos Admin/ Developer

Responsibilities:

• Extensively worked on developing simple and complex reports on Cognos Report Studio 10.1.1.
• Developing the reports using various templates like list report, Cross-tab Report and Chart Report.
• Created cascading prompts and worked with various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
• Created reports using conditional formatting and sorting options.
• Created Boolean, String and Report language variables to render the reports to the particular query.
• Worked on Stored Procedures in SQL Server Management Studio 2008 R2(DEV,TEST and PROD).
• Interacting with different application team members and fixing the issues related to the framework models.
• Involved in refreshing the metadata models whenever the changes are made in the stored procedures.
• Worked a user application called E-sales(DEV, TEST and PROD) where the users can access the reports.
• Responsible for upgrading reports from Cognos 10.0 to Cognos10.1.1in Dev, UAT, QA and Production environments.
• Involved in testing and quality assurance of all the reports before delivering them to the end users.
• Assisted to build dashboards using Cognos Workspace, Cognos Workspace Advanced and Cube Designer.
• Developed active reports, dashboards, metrics, analysis and other information in a security-rich environment using Cognos Mobile 10.1.1 to make the user to view and intract.
• Prepared back up plan and Fact Finder documents Disaster recovery plan forCognosBI environments.
• Develop and maintain custom audit reports forCognos usage, servers & portals monitoring plan for n Cognos environments.
• Design and implementCognosportal setup,CognosPortal Performance settings, Cognos server performance settings andCognosproduction deployment plan.

Environment: Cognos 10.1 and 10.1.1 BI versions, Cognos Mobile 10.1.1, Report Studio10.1.1, Query Studio 10.1.1, Framework manager 10.1.1, SQL Server Management Studio 2008 R2 database, XML, Excel and Windows 2008, 2012.

Confidential, Charlotte, NC

Cognos BI Developer/Report Author

Responsibilities:

• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents.
• Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
• Assist in conducting in-depth review of requirement specifications collected and analyzing business process to determine the exact nature of user’s system requirements.
• Designing mapping of process flow and interacting with analysts and core team members to select the proper system infrastructure.
• Design and review the processing steps and create processes for new system.
• Review project specifications, flow charts, process diagrams and system documentation for application operations and methodology.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Installation and configuration of Business Objects suite in all (Dev, Test and Production) environments.
• Coordinating with other teams to improve the quality of work.
• Extracting OM(Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
• Designed, developed, deployed and maintained Universes using Business Objects Designer tool.
• Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
• Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Project / Framework Model.
• Created prompts in report to restrict data fetch and ease data load.
• Restricting the user access with help of Access Level privileges.
• Creation of repositories and security domain with user groups and security implementation.
• As per the Business requirement creating the reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of the application.
• Provided the security access management by creating users/groups and folders.
• Upgraded fromCognos8.4.1 to10.x.

Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 10g, SQL Server 2008, DB2 9.1 on Windows Server 2003/2008.

Confidential, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Analyzed business and user needs to design Business Intelligence solutions that supported business and operations.
• Interacted with ETL team and the DBA to make available certain tables and data modifications required to successfully execute report requirements.
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.
• Experience in implementing security based on user roles in Framework Manager and publishing reports.
• Used static choice value prompts, cascading prompts, conditional variables (Boolean and string) to create reports.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Maintenance of TM1 users, roles, and security, Imported the data from ODBC and Text files using TM1 Turbo integrator.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Created Conditional Block reports to dynamically hide or show report objects and provide the end user the option to view the data in different formats.
• Extensively used insertable objects like query calculation, layout calculation and tables to generate efficient and user-friendly reports.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Implemented Conditional formatting and Java Scripts for customizing the reports. Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.
• Created Drillable reports to provide users with more detailed information for the next levels.
• Developed various Dashboard Reports such as the Loan Originations dashboard to see at-a glance the volume and characteristics of new loan originations, such as credit scores and loan-to-value calculations throughout the portfolio.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email.
• Created Backups of the content store and Public folders.
• Involved in performance tuning of several Reports.
• Mentored the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Involved in unit testing of all the reports and documented all the test cases worked on.
• Responsible for upgrading reports from Cognos8.4 to Cognos10.1.
• Knowledge in creating Reports and Dashboards using Active Reports and Business Insight.

Environment: Cognos 10 BI, Cognos 8.3 BI Suite, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos TM1 9.5.2, Java Script, PLSQL Developer, SQL Server, SQL DBX.

Confidential - Princeton, NJ

Sr. Cognos Developer

Responsibilities:

• This included debugging and optimizing Cognos reports and used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.
• Managing and Administering the entire Cognos 8 for BI Team.
• Involved in designing the Framework Manager Models.
• Improving existing models by Creating Alias tables and applying other techniques for effective reporting.
• Developed several Cognos reports.
• Responsible do to Query Optimization and Performance Tuning of all reports.
• Highlight: Lead functional role involving complete estimation, scheduling and delivery of a project for one of the business clients.

Environment: Cognos 8.4 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i, MySQL, MSQL Server, windows 2003, Unix.

Confidential, Rochester, NY

Cognos BI Developer

Responsibilities:

• Developed and implemented Business Intelligence solutions as a part of Business Intelligence Organization.
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Designed and developed PowerPlay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.
• Administered Cognos BI Server Environment
• Managed Package Migrations and Deployments from one Environment to another.
• Managed Data Sources, run activities, user accounts and permissions
• Used Cognos SDK to develop various java applications.

Environment: COGNOS REPORT NET Framework Manager, Report Studio, COGNOS Connection, COGNOS Configuration 7.1, Cognos 8.4 Suite, Oracle 10g, SAPBW, SQL, PLSQL, AQT, PowerPlay Transformer 7.1/7.3, Quest Central, PowerPlay Enterprise Server Administration, Windows 2000, 2003, Unix.

Confidential

Cognos Report Developer

Responsibilities:

• Created the design documents for the development of Cognos Report net.
• Involved in creating the model and package using Framework manager.
• Created reports for various departments like HR, sales and production.
• Communicated with the business users to comprehend the requirements.
• Involved in the migration of catalogs from impromptu to Report Net using migration utility.
• Created customized BI reports linking various databases, to meet the user requirements.
• Developed numerous sophisticated drill-through ReportNet Reports.
• Created standard and Ad-hoc reports using Cognos Query Studio(Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio.

Environment: Cognos Report Net, Cognos connection 7.1, Power play Enterprise Server 7.1, Oracle 9iWindows XP, Windows NT, Windows 2000.