SUMMARY:

• Over 12 yrs. of extensive experience in OLAP tools and Cognos Application.
• Around 2 yrs. of experience in Power BI, SSRS
• Experienced with Cognos reporting and Business Intelligence tools such as Cognos 11/10/8, ReportNet, Impromptu, Powerplay, Access Manager, Transformer, Framework Manager, Active Report
• Received official Cognos TM1, Informatica, LinkedIn/Microsoft Power BI
• Experience in Cognos 11/10/8 tools for advanced Report authoring and Metadata Modeling
• Involved in building Dimensional Models using Framework Manager in Cognos
• Created packages in Framework Manager and published to Cognos Connection
• Created and managed reports in Zero - footprint environment using ReportNet
• Administered Access Manager to implement Security among Cognos applications
• Optimized cubes in Powerplay Transformer by auto-partitioning and caching
• Created Business Intelligence Reports using Cognos Impromptu and Cognos Powerplay
• Installed and Configured Cognos for building multidimensional Cubes as per the Business requirements
• Used Event Studio for scheduling and emailing reports
• Automated Reports and generated Documents using Scheduler
• Published Reports in Various Cognos Portal environments.
• Gathered Requirements and reporting issues from the end users
• Provided End User and Support

PROFESSIONAL SKILLS:

Cognos Administration: Advanced, Cognos 11/10/8: Expert

SQL: Expert

Framework Manager: Expert

Report Studio: Expert

Tableau: Intermediate

Power BI: Intermediate

TECHNICAL SKILLS:

OLAP Tools: IBM Cognos 11/10/8.4/8.3 , ReportNet 1.0/1.1 (Query Studio, Report Studio, Framework Manager, Cognos Connection), Informatica 9

Database systems: Oracle 11g/10g/ 9i/8i, SQL Server 2005/2000/2016 , MS Access, DB2, Teradata

Web Servers: Sun One 5.2, Microsoft Internet Information Server (IIS) 10/4.0/3.0, Apache, IBM HTTPS

Programming Skills: C, SQL, HTML

Microsoft Tools: MS Excel, MS Word, MS Visio, MS PowerPoint and MS Access

Operating Systems: Windows 2010/95/98/2000/ NT/XP, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

BI Lead/Administrator

Responsibilities:

• Set-up and configured the environment for Cognos R6/11.0.11
• Set-up and configured the multi servers environment for Cognos 11.0.13 which involves multiple dispatchers, active and stand by content manager and multiple gateways.
• Set-up and Configured the IIS settings
• Optimized the server and IIS for the better performance
• Worked with IBM to address multiple bugs and tickets
• Optimized IIS settings by enabling dynamic caching, dynamic compression and disable anti-virus.
• Troubleshoot server related issues and networking with large packets size.
• Optimized server with different options for enhance query performance and better user experience
• Interacted with business and analyst to collect the user requirement and translated into technical documents.
• Responsible for Designing and developing the reports
• Designed new dashboards, POC using Power BI
• Published the content to Power BI cloud Service for online consumption.
• Developed calculated measures using Data Analysis Expression language (DAX).
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, drill trough’s
• Fine-tuned the performance of the reports using performance parameters worked with database team to optimized the tables and query
• Modeled and designed Datasets on the Power BI cloud Service for uniform consumption.
• Worked on Framework Manager Models and tuned them for optimized performance.
• Tuned the performance of reports, FM Models for optimized performance.
• Traced the SQL queries and optimized using SQL Profiler
• Worked on Data Modules to support the Dashboard.
• Managed schedule, folder and user based security
• Managed Roles and row level security using Lookup expression in Power BI Desktop.
• Scheduled Automatic refresh and scheduling refresh in Power BI Service.
• Implemented internal Cognos Security, Row Level Security, Macro’s, Session Parameters and Parameter Maps.
• Performed Unit testing/Performance testing on Dev/UAT and created test cases.
• Worked on lineage, user, test cases, troubleshooting documentation.
• Worked on the deployments and security set-up.
• Documented the deployment process to get the appropriate approvals to follow the SOX compliances by opening/tracking Service-NOW requests.
• Used Team Foundation Server (TFS) for tracking bugs and work items and as a version control.
• Managed Service-NOW requests to troubleshoot user issues.

Environment: Cognos 11.0.6/11.0.11/ R13 (Framework Manager, Dashboard, Report Studio, Data Module), SQL Server 2014/2016, TM1 10.x, Windows, Service-NOW, IIS, DBeaver, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS)

Confidential, Portland OR

Cognos Lead

Responsibilities:

• Managing and supporting on-shore and off-shore team
• Interacted with business and analyst to collect the user requirement and translated into technical documents.
• Responsible for Designing and developing the reports
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Burst Reports
• Fine-tuned the performance of the reports using performance parameters worked with database team to optimized the tables and query
• Worked on Framework Manager Models and tuned them for optimized performance.
• Tuned the performance of reports for optimized performance.
• Managed schedule, folder and user based security
• Developed and enhanced Active Reports using Visualization and Rave Concepts for IPAD application.
• Implemented internal Cognos Security, Row Level Security, Macros, Session Parameters and Parameter Maps.
• Performed Unit testing on Dev and supported the users on UAT and Production.

Environment: Cognos 11.0.6/10.2 (Framework Manager, Cube Designer, Query Studio, Analysis Studio, Report Studio, Workspace Advance, Active Reports), Teradata, Linux

Confidential, Little Rock, AR

Sr. Cognos Developer/Administrator

Responsibilities:

• Involved in Analysis, Design, Development, Testing, Implementation, and Support
• Worked on user, knowledge transfer and documentation
• Involved in production support activities, incidents, and tickets.
• Maintenance of servers, scheduled jobs and monitored the environments’
• Troubleshooting and tuned FM models for optimized performance.
• Used multiple data sources for building FM model, DMR, relational
• Report Design using Cognos Report Studio, Analysis Studio, Workspace, Workspace advance and Query Studio
• Created complex reports which involve Joins, Unions, Drill Through, Prompts, Report Library, Table of Contents and Report Layout.
• Created dimensional reports with MDX functionality.
• Involved in Unit Testing and User Acceptance Testing
• Wrote and tuned Pass-Through SQL for ad hoc report requests
• Involved in migration jobs (package and reports) from lower environments to higher ones.
• Provided access permissions to the users and maintained the securities at an object level, package, and report level.
• Created and maintained complex report studio reports with multiple complex queries, joins, unions, conditional formatting, drill through etc.
• Tuned the reports for optimized performance and scheduled them accordingly.
• Worked on layout component and centralizing formatting of the reports.
• Used scheduler and jobs to dispatch the reports periodically.
• Implemented upgrade to implement the fix packs for better performance and enhancements.
• Worked on web server up-gradation from Apache to IBM HTTP.
• Involved in security settings, scheduled management, performance tuning, data source creation, and deployment.
• Installation and configuration of SSL s and setting of the trusted chain of trust.
• Successful implementation of migration of Cognos 10 to Cognos11
• Worked on Cube Designer to create POC.
• Worked on Framework Manager Models and tuned them for optimized performance.
• Multi-server node installation of Cognos 11, load balancing and tuned for the optimal performance
• Up-gradation of IBM HTTP server and load balancing for the multi-server.
• Worked on Tableau dashboards for POC purpose

Environment: Cognos 11.0.5.2, Cognos 10.2.1 (Framework Manager, Cube Designer, Query Studio, Analysis Studio, Report Studio, Workspace Advance, Active Reports), DB2 Server 10.5, AIX 7.1, LDAP(AD), Putty, IBM HTTP Web server 8.5.5.12, Apache Web Server, OpenSSL, Fiddler, Tableau 10.x

Confidential, El Segundo, CA

Sr. Cognos Consultant/Analyst

Responsibilities:

• Involved in Analysis, Design, Development, Testing, Implementation, and Support
• Interacted with internal team to understand the complex business requirements and timelines.
• Maintained strict adherence to all project milestone and timely execution for all issues
• Provided technical assistance and
• Performed the administrative duties of migration, scheduling, creating Roles, User Groups, triggers
• Designed and developed projects, packages, reports using framework manager, query studio, report studio, active reports and workspace advance
• Created relational models with Cognos best practices with proper cardinality, determinants, and security
• Extensively worked on determinants, embedded/standalone filters and calculations
• Report Design using Cognos Report Studio, Analysis Studio and Query Studio
• Worked on dimensional reports and used MDX functions.
• Build and trained users to use Workspace advance for their analysis
• Created and maintained complex report studio reports with multiple complex queries, joins, unions, conditional formatting
• Performed Unit Testing and User Acceptance Testing
• Developed test cases for the validation and verification of the reports against the legacy system.
• Worked on the design documentation, deployment guide, and user guide.
• Worked on ticket tracking system to work with priorities

Environment: Cognos 10.2 (Framework Manager, Query Studio, Analysis Studio, Report Studio, Workspace Advance, Active Reports), SQL Server, Ultipro

Confidential, El Segundo, CA

Sr. Cognos Developer/Architect

Responsibilities:

• Interacted with internal team and external team for Cognos project allocation and service requests.
• Developed a high-level design to work with PM for project planning purposes
• Maintained strict adherence to all project milestone and timely execution for all issues
• Provided technical assistance, and mentoring to Users and business analyst
• Involved in migration process to map the scope of the reports from Cognos 8 to Cognos 10
• Extensively worked on multidimensional Cognos cubes with multiple data sources to facilitate OLAP Reports and other analytical tools across the organization using Cognos Transformer 10.x
• Worked on enhancement and creation of new cubes with various optimization techniques
• Performed the administrative duties of scheduling, creating User Groups, triggers etc.
• Troubleshooting and tuned FM models.
• Used multiple data sources for building FM model.
• Report Design using Cognos Report Studio, Analysis Studio and Query Studio
• Developed and tuning report studio reports using TM1 cubes and Transformer cubes
• Created relative time categories and customized calculations to be used for reporting purpose
• Created and maintained complex report studio reports with multiple complex queries, joins, unions, conditional formatting, and customized SQL based reports.
• Provided inputs to design global reporting template across all business segments
• Performed Unit Testing and User Acceptance Testing
• Performed and interacting with database team to tune the SQL
• Wrote and tuned Pass-Through SQL for ad hoc report requests
• Implemented security at Package level, Object level, Data level using Framework Manager
• Enhanced Transformer cubes with new reporting updates
• Developed test cases for the validation and verification of the reports.
• Worked on the design documentation, deployment guide, and user guide.
• Worked on ticket tracking system to work with priorities
• Involved in the production support activity to resolve the issues with high priority reports

Environment: Cognos 10/8.3 (Framework Manager, Transformer, Query Studio, Analysis Studio, Report Studio, Active Reports), Informatica 9, Teradata, BSP Meta Manager

Confidential, Temecula, CA

BI Architect/Sr. Consultant

Responsibilities:

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Worked with offshore team and lay down project scope and project deliverables.
• Worked on the design documentation, deployment guide, and user guide.
• Created the mapping document between the UI, transactional system and the analytics.
• Participated in the discussion of design and development ETL mappings and Fine-tuned existing Informatica maps for performance optimization
• Troubleshoot and tuned for FM models and reports for better performance.
• Created and maintained complex report studio reports with multiple complex queries, joins, unions etc
• Performed the administrative duties of scheduling, creating User Groups, deployment across different environment
• Provided technical assistance, and mentoring to Users and Business Partners.
• Worked on Proof of Concepts (POC) for Active Reports etc
• Created the mapping and scalability document to find out the scope of UI, transactional and analytics systems

Environment: Cognos 10/8.4 (Framework Manager, Query Studio, Analysis Studio, Report Studio), Linux, Informatica 9, Oracle11g, Windows 2005, SQL Developer, WinSCP, Putty, LDAP

Confidential, Greater Chicago, IL

Sr. Cognos Developer

Responsibilities:

• Installed and configured of Cognos 8 BI (Framework Manager).
• Gathered, analyzed and documented user requirements for reporting.
• Enhanced the existing Framework Manager and Transformer model for the new enhancements.
• Modified the Cognos Impromptu query definition (.iqd) files.
• Developed Complex Report Studio Reports and Dashboards using Lists, Crosstabs, charts, singleton, sections, Drill Through, Joins, Unions, Images and HTML applications using Report Studio
• Developed the Analysis Studio report using the Transformer cube.
• Involved in the performance tuning of SQL queries.
• Involved in verification and validation of reports using SQL developer.
• Participated in Unit Testing and System Testing.
• Documented the deployment process and assisted to the administrator to finish the task.

Environment: Cognos 8.4 (Framework Manager, Transformer, Query Studio, Report Studio), Oracle10, Windows 2005

Confidential, Chicago, IL

Sr. Cognos Developer/Administrator

Responsibilities:

• Involved in the entire project lifecycle from analysis, installation, development, testing, production and end-user support.
• Involve in the LDAP securities with creating/modifying different user groups and roles based on the plan information and Created/modified data source connections.
• Mapped LDAP groups to the Cognos user groups and roles.
• Recommended and implemented the sizing, scaling and load balancing to optimize the burst report output performance.
• Developed disaster recovery plan by configuring primary/secondary content manager and application servers.
• Involved in System Performance monitoring task.
• Interacting with Business Users to map the data.
• Developed FM model based on the transactional data for ad-hoc reporting.
• Using Stored Procedure in Framework Manager to update the information in the database.
• Troubleshoot and optimized FM models.
• Provided row level securities to control the plan information for care managers in FM.
• Worked on geophysical mapping solution using ESRI and VISIO software and integrated into Cognos reports.
• Handling independent projects such as LDAP reporting and integration of Google Maps. created complex reports and briefing books involve JavaScript, Joins, Unions, Drill Through, Prompts, Bursting, Report Library, Table of Contents and Report Layout.
• Created canned reports and ad hoc reports using Report Studio and Analysis Studio.
• Use the advanced functionality of Analysis Studio such as drill up and drill down, rank and slicers.
• Used Event Studio to trigger the jobs.
• Tuned the reports by modifying queries to minimize the execution time.
• Developed Structural and Transactional IQD’s from Framework Manager and used it for Transformer.
• Created Transformer Cube in UNIX environment by the running script.
• Provided security in Transformer Cube by using Custom Views.
• Interacted with QA team for Unit Testing, System Testing, and Performance Testing
• Worked on deployment of packages and reports in UNIX environment
• Working with Control Center (DB2) to execute the query for report testing and update the table for report bursting.
• Involved in Production Support.
• Analyzed the impact on the models and reports before the data loading for Market Research application.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Transformer) DB2.x, Windows 2003, AIX 3.0, Tivoli LDAP, ESRI, WebSphere

Confidential, Atlanta, GA

Sr. Cognos Developer

Responsibilities:

• Interacted with end users to gather requirement and solve issues.
• Interacted with the Business Analyst to determine the scope of the project.
• Installation and Configuration of Cognos 8, Oracle Client and Toad on window server.
• Imported metadata into Framework Manager and created packages in Cognos 8
• Worked on Dimensional Modeling in FM.
• Generated the relationships for different tables and set the Cardinalities for it.
• Updated the package as per the user requirement.
• Assisted in user securities and administration for LDAP
• Assisted ETL team to developed summarized tables.
• Used Macro and Parameter Map to perform the row level security for pharmacies.
• Created complex reports using Report Studio such as Dashboard, Page Break, Master Detail, Joins, Unions, Classes, Sections
• Created various Advance Prompts, Filters and Calculation in Report Studio
• Developed the Custom Templates for reporting purpose.
• Used various conditional formatting for list, crosstab report and prompt page
• Wrote the native SQL for ad-hoc queries for quick reporting.
• Involved in the tuning of the reports to optimized the report response time
• Migrated reports to Cognos 8 from the RxER environment.
• Modified the SDK code in Report Studio
• Perform the unit testing of report using Toad
• Worked closely with QA team using JRAC Tracking System
• Deployment of packages, folders, reports, and jobs from Development to Production.
• Created Events in Event Studio to run the Weekly and Monthly jobs
• Schedule the jobs and maintain the public folder in Cognos Connection portal
• Troubleshooting in Development and Production environment.
• Updated the tables in Dev Environment for the testing purpose.

Environment: Cognos 8.2/8.4(Framework Manager, Report Studio, Query Studio, Event Studio) Oracle10.0, Windows2000, Toad 9.5, JTRAC

Confidential, Gaithersburg, MD

Cognos Developer

Responsibilities:

• Gathered end-user requirements
• Created metadata model using Framework Manager and published packages in the Cognos 8.2
• Created calculation and filters in the metadata model to improve performance.
• Migrated Catalogs and Reports to Cognos 8 environment.
• Provided data security, object security and package security in Framework Manager
• Created complex report using Report Studio and ad hoc reports using Query Studio
• Worked on Drill Through from Report Studio to Report Studio in Cognos 8.2
• Perform validation of reports by using Query Analyzer
• Created dashboard reports in Report Studio and burst them to the Cognos Connection web portal
• Carried out bursting of reports to distribute reports to different end users
• Used IQD’s to create cubes and created reports in report studio
• Used Access Manager to provide security for transformer models.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos Connection in Cognos 8.2
• Worked on knowledge transfer and end-user .

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio), Powerplay, Transformer, Oracle9.0, Cognos Series 7.x, SQL Server2000, Windows2003