SUMMARY

• Over 8 years of experience in IT Industry with experience in Software Administration Analysis, design, development, testing, documentation and implementation of client server applications.
• 8 years of experience with Business Intelligence tools like Cognos 10.2/10.1/8, Report Net, Framework Manager, Power Play, Power Play Transformer with Oracle and IBM DB2 Databases.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Involved in all phases of software testing life cycles in Waterfall and Agile SCRUM environments and have an excellent understanding of Software Development life Cycle (SDLC).
• Extensively worked on developing various kinds of reports in Cognos 10.2/10.1/8 Report Studio, Analysis Studio and Query Studio.
• Involved in a data migration process between different versions of Cognos.
• Extensively worked on Power Play Transformer for building up of Multidimensional Cubes.
• Experienced in writing SQL scripts to automate process and optimize the data transfer.
• Experienced in developing Dashboards Reports in Cognos 10.2/10.1/8 based on OLAP Cubes designed on Cognos Transformer.
• Expertise in version upgrades and Migrating Impromptu Catalogs, Power Play Cubes, and Report Net reports into Cognos 10.1.1/8.
• Expert in Java Scripting. Strong experience in business analysis and requirement gathering.
• Transforming their business needs into structured format by thorough documentation of the same to be understood by delivery team to perform necessary analysis.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Experience in applying user level and functional level security on different groups in Cognos 8.2/8.4.1/10.1.1 and also worked on few features of SSO(single sign on)
• Setting up domain groups and assigning access rights to users and groups using the Cognos Server tools linked to standard LDAP.
• Developed and published PowerPlay Cubes and Packages on Cognos Connection and created multidimensional reports using Analysis Studio/Report Studio.
• Hands on experience in Installation, administration and upgrading versions of Cognos from 8.2 to 8.4 and from 8.4 to 10.1.1.
• End to end knowledge on Cognos Setup and Administration.
• Good Knowledge with Databases Oracle, DB2, Vectorwise and Other BI tools like SAP BI/BO and data visualization tools like Tableau, Japersoft, Spotfire and Qlickview.
• Extensive knowledge using SQL for back end optimizing and report development.
• Involved in modeling the Data. Expertise in tuning up the database queries.
• Experience in functional and application knowledge of Finance, Marketing, and Telecom Sector.
• Experience in writing and debugging stored procedures and triggers.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• DevelopedUNIX shell scriptsto be used as pre - session and post session commands and knowledge in AWK Programming.
• Hands-on experience in handling Server Vulnerabilities, Application security, Project external audits and Risk Management.

TECHNICAL SKILLS

OLAP: Cognos 10.2/10.1/8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis Studio and Framework Manager), Cognos Report Net 1.x, Power play Transformer 6.3/7.0/7.1/7.4, Cognos Impromptu 7. x, Impromptu web reports, Tableau, Jaspersoft, Spot fire, Qlickview, SAP BI/BOV3.1.

RDBMS: Oracle 9i/10g/11g/12c, SQL*plus, iSQL Plus, IBM DB2, Vector wise

Operating Systems: Windows Family, Linux, UNIX, SUN Directory Server, Cognos Series 7

Languages: SQL,PL/SQL, Unix Shell scripting, Java Scripting, HTML, R Studio, C, C++

Servers: Application server(Tomcat), Web Server(Apache)

Tools: /Package: MS Office, Toad for Oracle, SQL Developer, Xmanager,Tally9, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Cognos Developer

Responsibilities:

• Designed & developed multiple reports using various templates like list reports, crosstab reports, chart reports, and complex reports with conditional blocks, static choices in prompt.
• Customized data by adding Filters Prompts, Calculations, Macro Functions and Session Parameters.
• Created Framework manager models and Implemented security for Data access, Object level access and Package access based on the Organization Level.
• Worked on Cognos Framework, Parameter Maps, AD Groups, assigned Data level security and added filters accordingly to secure data.
• Created the calculations, filters and prompts in framework manager and user defined functions, procedures and packages at the database level as per the requirements.
• Designed standard reports in report studio and also developed ad-hoc reports in query studio.
• Created functions and procedures at the database level to simplify complex business logic in reports.
• Scheduled the reports to run monthly based on the updates of the cube using schedule management tool in Cognos connection.
• Designed required Packages in Framework manager using database tables, views and stored procedures.
• Organized metadata into star schema groups to best suit the business model.
• Worked on re-configuring application security by organization level.
• Written complex PL/SQL scripts to maintain databases and optimize the queries.
• Security validation of user access/Data source access through Cognos Access Manager.
• Modified Oraclesource tables/views/procedures, etc. to solve the issues on
• Identified, created and modified the procedures and configurations to meet user requirements for computer application.
• Developed test cases and performed unit testing. Performed thorough Tests on modified application, its integration and Cognos Reports to ensure all works as expected
• Documented all the processes and created data dictionary.
• Generated stored procedures to use in the framework manager to create the required packages.
• Created burst reports to distribute reports to different end users.
• Modified the existing report based upon the change request by the user.
• Worked with business, IT teams and application vendor to complete tasks.
• Identified and communicated about the business and technical issues and worked on the issues to resolution

Environment: Cognos 10.2/10.1, Oracle, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer, Cognos Scheduler, Configuration Manager, Content Manger, Access Manager, Apache Web Server, Unix, Windows XP Professional, LDAP, Active Directory, Oracle 10g.

Confidential, Sunnyvale, CA

Cognos Developer/ Administrator

Responsibilities:

• Involved in the installation and configuration of Cognos 10.1.1
• Security validation of user access/Data source access through Cognos Access Manager.
• Involved in Requirement gathering from Business Users.
• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements.
• Developed new reports in Report Studio upon requests from business users.
• Created and published Packages using Framework Manager.
• Implemented data level security, object level security and package level security using the Framework manager and Access manager.
• Designed & developed multiple reports using various templates like list reports, crosstab reports, chart reports, and complex reports with conditional blocks, static choices in prompt.
• Extensively used various Prompts, Drill-through, master-detail relationships, conditional formatting, grouping and sorting features, layout calculation of Report Studio to generate efficient and user-friendly reports
• Deployed packages, folders and reports from a development environment to Testing and Production environment.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Created list, crosstab and drill through reports for departments like claims, billing, and members/subscribers.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our various partners.
• Defined hierarchies according to business requirements for Drill ability.
• Deploying Sample, Testing the Server and Managing Cognos Connection Portal.
• Developed Dimensional Models (DMR) for Cognos 8 Analysis Studios, Migrated Power Play cubes to Cognos 8. Created user classes, sign on for different users and set security for reports and cubes using Access Manger and Conducted user training sessions on Cubes and Reports.
• Used Cognos 8 Data Manager supports high performance analysis of relationat&al data by creating aggregate tables at multiple levels within and across hierarchies in the dimension tables.
• Involved in creating an ad-hoc query model for query studio users. Created and published various packages to meet different requirements. Created different types of reports like List, Cross-tab, and Chart, Drill-Thru and Master-Detail Reports and Dashboard reports.
• Designed and developed Framework models to better suit complex report development, using Oracle as backend.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.

Environment: Cognos 8.1/8.2/10.1.1 (Report Studio, Query Studio, Analysis Studio, transformers), Cognos Connection, Framework Manager, Access Manager, Linux server, Oracle 10g.

Confidential, New Tripoli, PA

Cognos Developer

Responsibilities:

• Lead the project with a team of four people for providing client with a better Analytical solution.
• Developed a Cognos Based Reporting Solution to enable business to have accurate insights on call centre operations performance.
• Ensuring that the solution design is compatible with the overall system architecture.
• Trained the end users in accessing Cognos reports and also how to use the query studio for creating the adhoc reports on their own for their business needs.
• This project was developed for Plan Sponsors and Plan Administrators to give them in-depth analysis of the transactions of the employee stock options.
• The Data warehouse provided comprehensive record keeping and administrative services for Financial Advisor support and decision-making.
• Developed the reports for client’s requirement and fixed the report issues.
• Developed client with real time access to the reports on the web interface.
• Worked with the List reports, Cross tab reports and chart reports.
• Expertise working experience on Cognos report administration and Scheduling of Jobs.

Environment: Cognos 8.3, Cognos Report Studio, Query Studio, Metric Studio, SQL Server 2005 and Windows 2002.

Confidential

Systems Engineer

Responsibilities:

• Created multi-source projects, models andpublished packagesin Framework Manager.
• Analyzed theFunctional requirement documentwith the Business Analyst to confirm the business logic involved in computing the KPI’s for the dashboard.
• Created technical documents for theDashboard, translating the business logic to technical details which included the design and specifications of the dashboard.
• Designed the Cognos architecture based on the number of users logging into the application and the amount of traffic at any given point of time.
• Installedand configured theCognos 8.4/10.1.1BI application with its complete suite of tools.
• Installed and configured Framework Manager Client tool to build metadata models for the reports.
• Designed and developed power cubes usingCognos PowerPlay Transformer 7.4 with IQD file as the source created from Framework Manager relational model.
• Optimize the performance of the cubes by partitioning and enabling the local processing option. Store the Cube in a compressed format.
• Created and published cube based package to be used in Analysis studio
• Developed drill through detailed level reports from summary level Dashboard reports using Report Studio.
• Built interactive and complex dashboards usingCognos Go Dashboard.
• Set upuser level, data levelsecurity for the published Cognos packages. Tested the security settings usingauthenticationinformation of different classes of users.
• Administeredby setting up the Cognos security settings at package, report level using theCognos connection administration portalwith restricted features depending on the class of user.
• Worked on performance tuning of the dispatchers to handle requests better and optimize the performance of the application.
• MaintainedDevelopment and Productioninstances of Cognos 8.2/8.4/10.1.1 BI.
• Application maintenance tasks like reconfiguring content store, automating Power play cube refresh activities by shell scripts, User ID creation and maintenance, assigning privileges to objects
• Worked with DBA’s in devising back up strategy for the Cognos Content store database.
• Troubleshooting the environment in case the BI server goes down or contacts the DBA in case of the down time of the content store database.
• Worked in Project Planning committee to assess the requirement of Project for the next Quarter.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Developed plans for Risk and Disaster Management and was also the person to oversee that all documents/procedures/scripts are updated and stored in a secure location.
• Was involved in Evaluating and identifying the new technologies at Data Warehousing (DWH) BI available other than Cognos.
• Was involved in supporting, Maintaining and conducting Audits through the project.

Environment: Cognos Series 8.2/8.4/10.1.1 (Report Studio, Query Studio, Analysis Studio, transformers), Cognos Connection, Framework Manager, Access Manager, Linux server, Oracle 9i, 10g, 11g, DB2, Tableau, Jaspersoft, SAP BI/BO, QlikView.

Confidential

Report Developer

Responsibilities:

• Created, modified and published Framework Manager Packages on Report net Server.
• Generated Ad-hoc Reports, Standard Reports Using Query Studio and Report Studio.
• Created Reports different formats like HTML, PDF, CSV and EXCEL.
• Created Parameters, Prompt Pages using various Prompt types (Value Prompts, Text Box Prompt, Date Prompt, Select & Search Prompt, and Interval Prompt) on the reports.
• Developed reports using List, Crosstab, Chart, Repeater and Blank Reports.
• Created standard Calculation on Query Item and applied various Filters to Data like Tabular, Group Filters on Query items and formatted the Reports.

Environment: Cognos Series 7.x, Impromptu, PowerPlay, Transformer, Access Manager, Oracle 8, Linux.