PROFESSIONAL SUMMARY

• Cognos Certified BI Professional with 9 years of experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, and Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Healthcare, Banking, Insurance, and Pharmaceutical industries.
• Expert in agile and waterfall SDLC methodologies. Experience in successful implementation of technical standards, blueprints and roadmaps for cognos soultions.
• Having 9 years of experience on Cognos Suite - Cognos Analytics V11, Cognos 10.2.1, Tableau 9.3, Tableau 8x, Cognos 8x (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio, Cognos Adminstration and Cognos Connection)
• Experience in handling complete range of admin capabilities: Monitoring Server status, system metrics, monitor activities, create groups and user roles, set user interface profiles, setting up data source connections.
• Extensive experience in Exporting and importing IBM Cognos content for Deployment, create distribution lists, contact lists and setting up printers.
• Developed Active reports, Bullet Charts and Micro Charts with Cognos 10.2.1.
• Developed Dashboards using Cognos 10 Business Insight and Cognos 10 Business Insight Advanced.
• Extensively worked on Active Reports Objects (Deck, Data Tab controls, Data Controls, Connections and Variables).
• Designed & developed Cognos Go Mobile 10, Configured Go Mobile with IPad Reporting.
• Strong complex reporting skills-Complex Drill-Through, Cascading Prompts, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Strong knowledge with Power Play Transformer model design and Power Play cube building.
• Expertise in version up gradations of Cognos 10x and Migrating Report studio reports and models intoCognos10 BI from previous versions.
• Publication of reporting via Office using CAFE (IBM Cognos for Microsoft Office) and ad-hoc querying via Cognos BI Analysis for Excel, Word, Power point.
• Good experience in Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Good knowledge in Data Warehousing tools including Informatica, Data modeling Tools like Erwin using Oracle, DB2, MSSQL Server databases.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Developed DMR Models & IQD’s in Framework Manager.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Extensive work on Data Extraction with Oracle 11g, SQL Server & MS-Access. Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and Involved in providing knowledge transfer with respectiveCognos to the associates.
• Worked with the business users and provide expertise in problem definition, requirements analysis and the general design of the BI System.Provided support to multiple concurrent projects.

TECHNICAL SKILLS

Reporting Tools: Cognos Analytics v11, Cognos 10 BI Suite, Tableau 9x, 8x, Cognos 8.4 BI Suite (Framework Manager, Cognos connection, Query Studio, Report Studio and Analysis Studio), CRN 1.1 MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront), SSRS, Tableau 9.3,9.2,9.1,8x.

ETL tools: Informatica Power Center 10,9x,8x, IBM WebSphere DataStage 11.x/9.x/8.x/7.x.

Operating Systems: Windows Family, UNIX.

Web Servers: IIS, Tomcat and Apache

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Databases: DB2 10.5/9.5, Oracle 10g/11gR2, MS SQL Server 2014/2012/2008/2005 and Teradata.

Programming skills: C, C++, HTML, JavaScript, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential PA

Cognos Admin/ Developer

Responsibilities:

• Prepared Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by client’s Systems Development Lifecycle.
• Developed dashboards using Cognos V11 Dashboards, Active Reports and Workspace Advanced.
• Developed Framework Models against DB2 and Sql Server databases with filters and calculations
• Developed DMR against underlying query subjects and defined scope relationship between regular dimension and measure dimension.
• Involved in creating and working with PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Used complex SQL queries in validating the data for reports while working on Prod Support (cognos, database and data) and Research & analysis (Data related) issues.
• Created Complex reports like the Multipage reports, drill though reports and conditionally formatted reports including graphs and images.
• Worked with agent studio in creating, scheduling, refreshing and supporting agents.
• 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.
• Developed Cascading prompts to filter data dynamically and conveniently locate the data the users are trying to use.
• Developed complex reports, multi-query reports and sub-selects queries to meet the client requirements.
• Developed interactive Dashboard reports using Business Insight and Business Insight Advanced.
• Using the Cognos Scheduler (Schedule Management tool), scheduled the long-running reports to provide static views to the business user.
• Integrated third party authentication sources like LDAP, Active Directory.
• Deployed the Content store, packages, top level folders and reports from Dev to UAT/TEST and TEST to Prod environments.
• Performed Administration activities such as granting access to the users, modifying the distribution list and Deployment.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Involved in fixing the issues of the reports after changing the reports from Cognos 8.4 to Cognos 10.1.1.
• Applied Security by Authorization of grant/deny access based on groups, user roles and user identity through namespaces.
• Configured external namespaces for assigning permissions Read, Write, Execute, Set Policy and Traverse.
• Extensive working knowledge on pre-defined administrative roles (Server administrators, Directory administrators, Report administrators and system administrators.

Environment: Cognos Analytics v11, Cognos 8x, Cognos 10x, Report Studio, Framework Manager, Query studio, Analysis studio, Workspace, Workspace Advanced, IBM Db2 9.5, 10.5, TOAD for DB2, SQL Programmer, MS Office Tools, MS access, Java Script, Unix.

Confidential VA

Cognos Report Developer

Responsibilities:

• Developed Cognos 10.1.1 Reports using Active Reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them ontoCognosConnection.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Quarter End Financial Reports to define total Assets, Liabilities, Balance sheet and P&L.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Testing the developed reports for final deployment.
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 10 Transformer.
• Created simple and ad-hoc reports using Query studio.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger.
• Created SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.

Environment: Cognos10.1.1, 10.1.2, Report Studio, Framework Manager, Query studio, Analysis studio, Oracle, SQL Server, TOAD for Oracle, MS Office Tools, MS access, Java Script, Unix.

Confidential MA

Cognos Developer

Responsibilities:

• Developed Cognos 10.1.1 Reports using Active Reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them ontoCognosConnection.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Active Reports and Heat Maps using Cognos 10.1.1.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Quarter End Financial Reports to define total Assets, Liabilities, Balance sheet and P&L.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Testing the developed reports for final deployment.
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 8 BI v8.4.
• Created simple and ad-hoc reports using Query studio.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Create SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Involved in performance tuning of the reports in Report Studio.
• Involved in implementing security in FM and Cognos Connection Portal.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 8.4& 8.2 Report Studio, Framework Manager, Query studio, Analysis studio, Cognos Connection, Cognos Transformer 8.3/8.4, Data Manager, Oracle 10g, DB2, SQL Server 2005, MS Office Tools, MS access, Java Script, Unix.

Confidential

Sr. Cognos Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Implemented Framework manager security for row level access and Package access based on the Department and region Level.
• Creating star schema grouping for better understanding of the model.
• Develop framework model to perform most of the calculations and give power to user to create Ad-hoc reports with ease.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Created ad-hoc packages for the query users with pre-defined filter conditions prompt customization.
• Created Filters, Prompts, Calculations both at package level and report level.
• Designed various kinds of Reports in Report studio (Conditional Formatting, Conditional Blocks, Sections, page Breaks, Master-detail, and Drill through).
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes.
• Developing Analysis Studio views of analysis from dimensional modeled packages.
• Scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Designed & developed Reports using Cognos Go Mobile 10.
• Designed Data marts for creation of reporting database using Data Manager
• Created multiple star schemas using Cognos Data Manager.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments.
• Worked on conducting User Interviews and documented their query, business analysis and reporting needs, Understood data and business logic with reporting viewpoint.
• Developed technical specifications and deployed efficient Business Intelligence solutions.
• Provide training, support and guide for best practices for Adhoc Query Users and Report Authors.
• Interaction with the business users at various stages of the project through demos.

Environment: Cognos 8.x, Report Studio, Framework Manager, Query studio, Analysis studio, Cognos Connection, Cognos Transformer 8.3/8.4, Data Manager, Oracle 10g, DB2, SQL Server 2005, MS Office Tools, MS access, Java Script, Unix.

Confidential, INC, NJ

Cognos Developer

Responsibilities:

• Developed models in Cognos 8.2 Data modeling tool Framework manager and 8.2 Transformer.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager.
• Customized Cognos Connection with appropriate reports and security measures.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Created Dash board reports to get all the information from other reports.
• Involved in access and analyze large data sets for completeness and quality.
• Built Power Play Reports based on the cubes.
• Prepare deployment specifications and work with system administrators to move reports into QA and Production.
• Analyzed the Explain Plan to check how the queries are performing scans.

Environment: Cognos 8.2/ 8.3 BI Suite (Report Studio, Query Studio, Cognos Connection, Framework Manager, Event Studio, Metric Studio, Analysis Studio, Metrics Manager), Transformer 7.4, Content Manager, Oracle 10g, SQL Server 2005, SQL, PL/SQL, JavaScript, HTML, MS- Excel, Data manager.

Confidential

SQL Developer

Responsibilities:

• Provided security to control information access.
• Re formatted queries for optimal execution.
• Supported automated job control services for daily loads to the database.
• Created mappings to input data for data ware house repository.
• Resolved and created primary keys and foreign keys for load tables.
• Used complex SQl to extract data in to appropriate formats.

Environment: SQL Server7.0/2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Crystal Reports, T -SQL.