We provide IT Staff Augmentation Services!

Sr. Report Developer Resume

Nashville, TN

SUMMARY

  • 8 Years of experience in SDLC (design, development, testing and implementation) of Cognos Business Intelligence applications.
  • 8 years of expertise in Analysis, Design, Development and Implementation of Cognos 10.1/8.4/8.3 BI Suite (Report Studio, Query Studio, Framework Manager, Cognos Configuration, Cognos Connection, Analysis Studio, and Metric Studio), Report Net, Cognos EP 7 Series, (Impromptu, Power Play Transformer, Impromptu Web Reports (IWR), Upfront) and Power Play Enterprise Server and Power Play Tools, Solution focused, Custom - driven BI professional.
  • Well versed with the complete BI Life Cycle Development Process.
  • Expertise in using Cognos 8.4 BI Suite (All Studios), Report Net Suite (Cognos Connection, Query Studio, Report Studio and Framework Manager), Cognos Enterprise Series 7 Suite (Impromptu, Impromptu Web Reports (IWR), Power Play Transformer, Power Play for Windows, Cognos Query, Cognos Visualizer, Upfront and Cognos SDK, Hands on experience in administering, deploying, and maintaining Models, Reports, and Cubes.
  • Experience in Migrating Cognos series 7 to Report Net/Cognos 8 using Migration Tools.
  • Got good knowledge in creating and maintenance of catalogs which involves in defining joins, governor settings and client server balancing.
  • Good experience in using Framework Manager IQDs to create Power Play Models in Power Play Transformer.
  • Knowledge of software development kit (SDK) and created applications published packaged in Framework.
  • Excellent skills in Oracle SQL, PL/SQL, MS-SQL, DB2.
  • Got good Knowledge on SSIS, SSRS, and SSAS in SQL Server.
  • Expertise in handling Informatica tools Power Center 7.1/6.1.
  • Excellent team player at all levels with ability to perform independently
  • Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.

TECHNICAL SKILLS

BI Tools: Cognos 8.0/8.2/8.3/8.4 BI Framework Manager, Report Studio, Query, Studio, Analysis Studio, Metric Studio, Event Studio.

Report Net 1.1 (MR1/2): Cognos Connection, Framework Manager, Query Studio, Report Studio, Cognos Configuration.

Cognos Series (7.x/6.x): Cognos Impromptu, Impromptu User, Impromptu Web Reports, Cognos Power Play Transformer, Power Play User, Power Play Web Reports, Power Play Enterprise Server, Access Manager, Configuration, Manager, Scheduler.

Languages: C, C++, VB Script, SQL, PL /SQL.

Databases: SQL Server 2000/2005, MS Access, Oracle 10g/ 9i/8i. DB2

Web Technologies: XML, HTML, DHTML, VB Script.

Operating Systems: Windows XP/2000/NT/98/95, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. Report Developer

Responsibilities:

  • Working as a Sr. Cognos Report Developer on version10.2.
  • Developed various reports on Cost Centre, Batch Accounts, Inbound, Outbound and International.
  • Working on Lists, complex crosstabs, Drill Through reports.
  • Created Relational and Dimensional Models in 3 layers of FM and deployed packages on Cognos Connection.
  • Experience in writing customs SQL’s in FM and publish the packages.
  • Expertise in implementing Object level and Data level security in Framework Manager Models.
  • Also involved in developing Dashboard by using drill through’s, filter’s, java script.
  • Used JavaScript in Cognos reports to make the default prompts available according to the BRD.
  • Supporting reporting team on all technical aspects for go-live activities, using agile methodology.
  • Introducing Cognos Workspace reports on User’s demand.
  • Scheduled the reports to the user email ids weekly/monthly according to the requirement.
  • Migrating the reports from DEV to UAT and to PROD after the reports are reviewed by the users.
  • Actively involved in troubleshooting the Cognos report errors.
  • Responsible to maintain the Cognos services - start and stop sevices for restarting.

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio),Cognos Workspace, Toad, PLSQL, Windows7.

Confidential, Richardson, TX

Sr. Cognos BI Developer

Responsibilities:

  • Working as a Cognos Dashboard Developer on version 10.1 and 10.2.
  • Developed various Renewals reports, Commissions reports, small group renewals ACA reports for IL,TX,OK and NM corps
  • Migrated all the reports from Cognos version 10.1 to Cognos version 10.2
  • Used SQL Server Management tool to write the queries and cross check the Cognos report result with the sql result.
  • Also involved in developing Dashboards.
  • Worked on O65 project individually and delivered all the reports.
  • Supported reporting team on all technical aspects for go-live activities, using Scrum agile methodology.
  • Troubleshooting the existing report issues/reports which fails in prod.
  • Coordinate with Software Testers and Release Management to integrate the final work product into the production environment and provide off hours support as required.
  • Took traning sessions on Tableau from client side
  • Scheduled the reports to the user email id’s weekly/monthly according to the requirement.
  • Actively involved in identifying the cognos report bugs and identifying the report scope for users in Cognos

Environment: Cognos 10.1 and 10.2 (Framework Manager, Report Studio, Query Studio), SQL Server Management Studio, Sql Server 2008, Windows7, Tableau.

Confidential, Houston, TX

Cognos Report Developer

Responsibilities:

  • Worked as a Cognos Developer on version 10.1
  • Developed Lists, crosstabs, prompts, render variables using Report Studio.
  • Worked on Analysis Studio to build reports as well.
  • Worked on Framework Manager Models and published the Packages through Cognos Connection.
  • Working on AWS (Amazon Web Services) using Java Script where Cognos has to interact with the web services and get the data dynamically.
  • Involved in developing the Cube in Transformer.
  • Worked on couple of simple Active Reports.
  • Developed various dimensions, measures and calculation in Cognos Transformer
  • Taking backup of the cube weekly/monthly and running the cube as scheduled.
  • Taking backup of Models as well.
  • Worked on administration side like startandstop the Cognos services, rebooting the Cognos server, granting access if the user doesn’t have the Cognos access.
  • Use to deploy the reports weekly and maintained the status.
  • Worked on moving the reports from UAT to PROD and schedule the jobs accordingly.

Environment: Cognos 10.1 (Framework Manager, Transformer, Report Studio, Analysis Studio), SQL Developer, Sql Server 2008, Windows XP.

Confidential, Jacksonville, FL

Senior Cognos Developer/Analyst

Responsibilities:

  • Working as a Cognos Developer as well as a Business Analyst.
  • Involved in gathering the requirements and developing the reports.
  • Developed Personal/Commercial Lines reports using Lists, Crosstabs, Charts and Prompts.
  • Scheduling the reports according to the user requests.
  • Created Models through data source and published the packages through Framework Manager to Cognos Connection.
  • Expertise in Object level and Data level security.
  • Created Dashboards on Agents, Underwriting and Claims request reports.
  • Created prompts, calculations, conditions, filters and other metadata objects using Report Studio.
  • Developed prompt pages and cascaded input prompts to filter reports on user specified criteria
  • Imported the excel sheet data saved on Data Repository through External Data and developed reports.
  • Troubleshooting and improving the performance of the existing/new reports.
  • Used AQT/SSMS to cross check the report data.
  • Develop Report Design Documents after the report development.
  • Develop Test Plans and Production Checklists before the deployment.
  • Following up the tickets and reviewing the statuses of the reports.

Environment: Cognos 10.1 (Framework Manager, Report Studio, Cognos Connection, Query Studio), Advanced Query Tool, Sql Server Management s/w, Sql Server 2008, Windows 7.

Confidential, Raleigh, NC

Cognos Developer

Responsibilities:

  • Involved in Installing and configuring the tool and its components on Windows7.
  • Used ETL (Informatica) to load the SQL Server data from flat files, client to DB2 Database.
  • Involved in gathering the requirements and developing the reports.
  • Developed the Model through Data Source in Framework Manager.
  • Involved in developing BEFOVA TOOL by using Report Studio which Forecasts the data.
  • Developed Reports using Lists, Crosstabs, Charts and Prompts.
  • Created Custom Reports using JavaScript to interact with java web services.
  • Created a Dashboard to view multiple views of the forecasted reports.
  • Used Data Studio to ensure the correct data for reports.
  • Involved in migrating the model and the reports.
  • Developed and Documented the BEFOVA Reports.
  • Used Cognos API as the main component for Cognos SDK.
  • Used IBM Cognos software development kit API in web pages using JSP’s.
  • Scheduled the reports in Cognos Connection on daily basis.
  • Taking back up of the reports from the content manager.
  • Testing the reports and troubleshooting the issues.

Environment: Cognos 10.1 (Framework Manager, Report Studio, Cognos Connection, Cognos Configuration), Cognos SDK, Cognos API, Informatica, Data Studio 3.1 version, DB2, Windows 7.

Confidential, Irving, TX

Cognos Developer

Responsibilities:

  • Involved in gathering client’s requirements and performing requirement analysis.
  • Used ETL (Informatica) to load data from source to ODS.
  • Customized data by adding Filters Prompts, Calculations, Conditions and Functions.
  • Performed data analysis between multiple data bases/schemas and verified data accuracy incorporating TOAD/SQL Developer to ensure correctness of data on reports.
  • Created public folders, private folders, personalized pages and custom views on Cognos Connection Portal.
  • Developed Framework Manager Models to import the data from multiple data sources, specified the overall relational data architecture (metadata) and generated packages of various subject areas to be published.
  • Migrated the reports from Cognos 8.4 to Cognos 10 version.
  • Involved in UNO documentation and development.
  • Worked on Owned Default Reports like creating Foreclosure reports, Bankruptcy reports, Loss Mitigation reports etc.
  • Tested and validated over 200 reports and did performance tuning of the complex reports for better performance
  • Used Report Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance over various periods of time, and master-detail, drill-through reports.
  • Created Dash Boards for multiple views of Reports in same Report page.
  • Developed metadata model, created and published packages incorporating Framework Manager.
  • Created IQD files in Framework Manager to be used in Power Play Transformer for creating multidimensional cubes.
  • Documented all requirements document, technical document, Unit test process document and preserved them in Share Point drive for use by others and for future references.
  • Scheduled periodic refreshes of reports using Schedule Management in Cognos Connection.
  • Supported Production issues like attending tickets created by end users on report issues such as data not found, report link broke, cannot log into Cognos portal, data mismatch etc.
  • Did Troubleshooting on administrative issues, reporting issues and resolving user’s problems.

Environment: Cognos 8.4 (Framework Manager, Report\Query Studio, Cognos Connection, Cognos Configuration), Oracle 9.6.1, SQL Server 2005, Windows Xp.

Confidential, New York City, NY

Cognos Developer

Responsibilities:

  • Involved in the entire project life cycle from evaluation, design, development and deployment of end-user reports.
  • Experience of migration of report from cognos 7 to cognos 8 series.
  • Used ETL (Informatica) to load data from source to ODS.
  • Developed Framework Manager Models to import the data from multiple data sources, specified the overall relational data architecture (metadata) and generated packages of various subject areas, to be published onto Report Net server.
  • Created and maintained SSIS packages using Microsoft SQL server visual studio or Business Intelligence Development Studio (BIDS).
  • Used Report Studio and Query Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance of geographical regions over various periods of time, and master-detail, drill-through reports.
  • Created Cascading scorecards, child report, converted excel sheets to tab-delimited files using metrics manager.
  • Expertise in Object level and Data level security
  • Work on (SSAS) multi-dimensional data in SQL Server which can be gathered from different kinds of resources like flat files to relational databases.
  • Created Multidimensional reports by implementing Multi Dimensional Cubes using Power Play and Transformer.
  • Imported power cubes from the Power Play enterprise server to Report Net Cognos connection server.
  • Used Dimensionally Modeled Relations to create Regular Dimensions and Measure Dimensions.
  • To avail multidimensional advantages like drill up, drill down, slicing and dicing used DMR’s.
  • Experience Decision Stream with OLAP analysis, scorecards and dashboards on one product and modern architecture.
  • Created prompts, calculations, conditions, filters and other metadata objects using Framework Manager.
  • Developed prompt pages and cascaded input prompts to filter reports on user specified criteria.
  • Scheduled periodic refreshes of reports using Schedule Management in Cognos Connection.
  • Experience in financial planning and analysis.
  • Experience in working with Informatica tools.
  • Created all types of report by using report studio, query studio and analysis studio.
  • Worked on documentation and end-user training on Query Studio for Ad hoc reporting.

Environment: Cognos 8.4 (Framework Manager, Report/Query Studio, Cognos Connection, Cognos Configuration), DMR, Power Play Transformer, Power Play, Oracle 10g, MS SQL Server 2005, Windows Xp.

Confidential, San Diego, CA

Cognos Developer

Responsibilities:

  • Worked with end users, business analysts, and project managers to define reporting requirements for various services and processes using Report Net (Cognos connection, Query Studio, Report studio and Framework Manager).
  • Installed and configured Cognos 8 BI and worked with Cognos 8 BI modeling, Report Studio.
  • Created highly customized reports in Cognos 8 Report Studio and ad- hoc reports in Query Studio.
  • Involved in migrating reports from Cognos Series 7 to Cognos 8.2 using Migration Utilities.
  • Developed List Reports, Charts and Drill through reports using Report Studio.
  • Created Dash Boards for multiple views of Reports in same Report page.
  • Created and Published Packages using Framework Manager.
  • Implemented security in Framework Manager using Access manager and Report Net with LDAP, NTLM.
  • Involved in Creating Content store, installation and Configurations of Report Net.
  • Developed Scorecards using Metric Studio.
  • Created folders, filters, prompts and complex financial calculations in Framework Manager and Report Studio.
  • Used Dimensional Modeled Relational to create Hierarchies and Levels and to apply multidimensional analysis.
  • Created metadata models, Namespaces, Folders and Query Subjects from multiple data sources in Report Net Framework Manager.
  • Used Cognos Software Development Kit which includes libraries, tags used to create JSP pages.
  • Utilized Star schema multi-dimensional models for optimized performance on large datasets
  • Responsible in bursting Report net depending upon different levels of administration.
  • Moving/deploying reports from Development to testing and production servers using Content Administration.
  • Associate with ETL team to build a data warehouse environment and provide constant updates about the necessary changes required.
  • Testing the reports for accuracy and performance.

Environment: Cognos 8.2/8.3 BI Suite (Framework Manager, DMR, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio), SDK, SQL Server, DB2.

Confidential, Columbus, Ohio

Cognos BI Developer

Responsibilities:

  • Setup the Cognos samples and created a Pilot project in Cognos 8 BI
  • Installed Report Net Migration Tool and migrated Impromptu catalogs.
  • Migrated Impromptu reports to Report Net using migratetoc8 command and deployed migrated reports to Report Net using deploytoc8 command.
  • Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.
  • Involved in Creating Content store, installation and Configurations of the Report Net.
  • Involved in creating security and deployment (exports and imports).
  • Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
  • Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
  • Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio.
  • Provided security to the Report Net in Access Manager through LDAP Server and configuration settings in Cognos configuration.
  • Administration involved Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization. Worked on bursting reports for the web users.
  • Developed various dimensions, measures and calculation in Cognos Transformer.
  • Implementation of Impromptu reports and Power Play cubes using multiple queries.
  • Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification, and Governors Settings.
  • Imported power cubes from the Power Play enterprise server to Report Net Cognos connection server.
  • Scheduled Impromptu and Power Play reports to run on a monthly, weekly, and daily basis Using Cognos Scheduler.
  • Used Transact-SQL for incorporating stored procedures, exception handling, and logical flow control purposes.

Environment: Cognos 8BI(Framework Manager, Analysis Studio, Report Studio, Query Studio, and Cognos configuration), Cognos Impromptu 7.0, Impromptu Web Reports, Cognos Transformer 7.0, Cognos Power Play 7.0, PPES, Cognos Access Manager, Upfront, SQL Server 2000,Unix, Windows NT/2000.

Hire Now