SUMMARY:

• Over 10 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, requirement assessment, design, analysis, development, documentation, coding, enhancement, testing and implementation of the business technology solutions. Extensive experience in developing scalable enterprise applications to the user needs which serves for Financial, Insurance, Pharmaceutical and Market Research Industries. Worked in Data modeling, OLAP, Business Intelligence (BI), Data Warehouse development (ETL), Client - Server, 3-Tier technologies, ERP, ORACLE /11g/10/ 9i/8i/7.i, PL/SQL, SQL*Plus. Over 10 years of BI experience using Cognos (Report Net/7.x/8.x /10.x/10.x.x/11.x) (Report Net, Cognos Impromptu, Power Play, Transformer, Power play Enterprise Server, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Metrics Manager), Micro Strategy 9 (Web Reporting, Dashboards, Scorecards, Analysis and Visual Insight) and Microsoft SQL Server 2000/2005/2008/2012 , DTS Packages, SQL Server Integration Services (SSIS), SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Query Analyzer, Enterprise Manager and Informatica. Extensive knowledge versioning control tools like MotioCI for reporting and modeling and SVN for ETL and also expert in Data modeling tools Erwin, Visio etc.
• Cognos Certified Professional with Over 10 years of IT experience in Design, Development, Testing, Administrator, Support Associate, maintenance and Documentation.
• Worked with business owners to gather requirements.
• Extensive experience in Cognos 11.0.x Cloud Analytics.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos BI Suite (Report Net, 7.x, 8.x, 10.x, 10.x.x and Cognos Analytics v11.x).
• Experienced in Installation and Configuration of Cognos 8.4, 10.1 and TM1 versions of Server and Client components on Windows and UNIX.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 11.x/10.x /8.x
• Modeled metadata from different sources for use in Query Studio and Report Studio using Framework Manager in Report Net, Cognos, 7.x, 8.x, Cognos 10.x, Cognos 10.2.2 and Analytics v11.
• Experienced in Cognos 10.x.x, 8.x Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio, Cognos Connection, Work Space, Work Space Advanced.
• Installed, Upgraded and configured Multiple Cognos environments.
• Having Experience on server maintenance and Performance techniques.
• Experience in development of OLAP solutions including DMR Models in FM.
• Involved in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Documenting Business Information Requirements, and Developing Technical Design documents, FM/Transformer Models and Report Development, Testing, Deployment and Production Support.
• Built Cube models and maintained cubes.
• Implemented security using LDAP and Cognos Access Manager in Cognos reports and Packages.
• Proficient in developing, optimizing cubes and dynamic cubes in Cognos Transformer for OLAP reporting.
• Proficient in implementing best practices in Framework Manager and Cognos Transformer in developing relational and dimensional packages (Relational and DMR).
• Experience with migration from Cognos 10.2.2 to Cognos Analytics v11.
• Strong Experience in developing and testing Complex reports (Multi-chart, Cross tab, Maps, Drill-through, Master-Detail and Bursting) using Report Studio.
• Skilled in designing Scorecards, Metrics, Strategy and Reports using Metric Studio and Cognos Workspace.
• Proficient in each phase of Data warehouse lifecycle involving Data Discovery, Data Modeling, ETL Architecture, Implementation, Deployment, Business Intelligence Reporting, Production support.
• Experience with IBM Cognos SDK development and Business Intelligence Technologies.
• Produced detailed reporting specifications with model and database technical reporting needs.
• Developed and Optimized models with Database Interaction, Client/Server balancing, Database functions, Table Weighting, Qualification and Governors Settings.
• Implemented Data Security, Object Security, Package Security in Framework Manager and created user classes, roles or groups as per the requirement.
• Strong knowledge of database design, OLAP (star schema), OLTP, Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Normalization, Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Proficient in writing complex database reports and customizing PeopleSoft delivered Application Engine and People Code.
• Expertise in Publishing Cognos reports to SharePoint site using Core Publisher.
• Manages day-to-day administration of Cognos infrastructure.
• Experience with Microsoft Windows OS (10, 8, 7, Vista, XP, 2000, and Win NT) and MS Office (Access, Excel, Outlook, Word, PowerPoint, and Visio).
• Strong understanding of .NET technology, VB, C#, ASP.NET, JAVA, JSP, Cognos SDK, High slide, etc.
• Leading Cognos Reporting team onshore and offshore.
• Experience in different SDLC methodologies including V-Model, Agile and Waterfall development methodologies.

TECHNICAL SKILLS:

BI Warehousing Tools: Cognos11.x/10.x.x/10.x/ 8.x, Framework Manager, Report Net, Report Studio, Query Studio, Workspace advance, Impromptu, Power play Transformer, Power Play, IWR, Access Manager, Crystal Reports 9.0/ 8.5, Informatica, MicroStrategy9 (Web Reporting, Dashboards, Scorecards, Analysis and Visual Insight) and SSRS Reports.

Administration tools: Cognos Administration and Configuration.

Security Components: Access Manager Administration 7.3 and Active Directory.

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Application servers: Tomcat, IBM Web Sphere 5.1/6.1

Directory servers: Active Directory, Access Manager and LDAP.

ETL Tools: Informatica, Data Stage and ODI

Scheduling Tools: Espresso, BMC Control-M Manager 6.3

QC Tools: HP QC 9.2, ALM,TFS,Trello and TDP

Web server: IIS 6/7.5, Tomcat, HTTP Server 1.3 and Apache.

ERP: Oracle Applications (Oracle Financials), SAP, PeopleSoft

Operating Systems: Windows 2000/XP/7 and UNIX (AIX & Solaris).

RDBMS: Oracle 9i/10g, IBM DB2 8.2/9, Teradata and MS-SQL Server 2008

Languages: C, Java, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior Cognos Developer

Responsibilities:

• Worked with the Business users to understand what reports were critical, non-critical and not needed. Eliminated the ones that were no longer being used by business.
• Created Report Specs, Mapping documents, Unit Test documents
• Provided POC by creating dashboards using Tableau and Cognos Analytics v11.
• Developed self-service reports, fix Cognos v11 reports and provided v11 support.
• Developed documents/guides on using new features of V11, developed best practices for cube design
• Involved in dimensional modeling, schema design, data analysis.
• Reports and Model for Different Projects and migration from Cognos 10.2.2 to Cognos Analytics/Cognos 11.
• Generated Active reports for offline users based upon variety of requirements.
• Created metadata model in FM for couples of projects in Cognos Analytics v11.
• Created report in Reports and schedule and triggers in Cognos Analytics v11.
• Worked on reports migrations and deployments in Cognos 11(Cognos Analytics).
• Performed check out Cognos server patching in Cognos Analytics v11.
• Performed various Admin part like Cognos security, backups and trouble shooting...etc.
• Trained end users in Cognos analytics v11.
• Completed internal training on Cognos Analytics V11.
• Generated complex list, crosstab and chart reports in Cognos 11 analytics.
• Developed design documents, project plans for the reporting project.
• Directly interacted with client technical team and understand /propose the best solutions on Cognos.
• Extracted the queries from the legacy reports and documented it in the Cognos specs.
• AGILE process has been followed for development.
• Designed & Developed Models & Packages by following firm and product standards.
• Developed List Reports, Cross Tab Reports, KPI Scorecards, Scoreboards, Charts and Maps.
• Created Dashboards using Cognos workspace, Cognos workspace advanced and Cognos report studio reports.
• Modified existing Framework manager package to create filters in Package for improved performance.
• Wrote SQL’s to implement report specific queries in reporting.
• Created dashboard reports on Cognos Analytics version in Development environment.
• Successfully managed and trouble shoot numerous complex issues in the Cognos environments.
• Proficient in deploying Reports and Packages from one environment to other environments (export, import and Copy to Clipboard).
• Identify and define criteria for additional data elements needed to support pharmacy control plan, including

  eligibility, enrollment, and Smart PA criteria.

• Worked with IBM team to trouble shoot the issues in PMR.
• Resolving Performance issues related to Reports.
• Extracted the queries from Legacy reports and validating against Cognos report studio reports.
• Set user and role based security at reports, package and folders levels
• Tuned performance of reports and models by following database and design standards.
• Fact and Dimension tables were used in the Cognos FM model for Package building.
• Used ROLAP and OLAP models as source to create reports using Report Studio.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting using MDX function for revenue and gross profit analysis reports for each quarter.
• Deployed the reports and packages across different environments.
• Effectively involved in defect tracking, reviewing and analyzing test results using ALM (HP Quality Centre).
• Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
• Worked with Cognos Support team for troubleshooting complex issues.
• Prepared training documentation and helped Business Users related to Cognos Reports.
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Responsible for knowledge transfer, training and communication with the vendor, end users and team members.

Environment: Cognos 10.2.1/10.2.2 Suite, Cognos Analytics v11 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Workspace Advanced, Cognos Workspace, Active Reports), Dynamic Cubes, Power play transformer, Cognos Administration, Trello, Informatica Power Center 9.6, Oracle11g/12c, Win2008, ASP.NET, HPALM 12.0/12.1, SharePoint and Agile Process, Medical Records, Medical, Medical Records, Medical Billing .

Confidential, Columbus, OH

Senior Cognos Developer Administrator

Responsibilities:

• Understanding the business requirements and designing applications to meet their needs.
• Analyze flow of data collect reporting and model requirements and reporting issues from users.
• Worked on Cognos Framework Manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos server.
• Built Relational and DMR models in Framework Manager and created the packages for developing user specific reports.
• Experience in developing complex reports using Drill-through reports, Prompts, Master-detail, Burst reports, Conditional formatting, complex hierarchical list reports, Dynamic filtering calculated columns and conditional formatting in Cognos.
• Developed Dynamic cubes using IBM cube designer.
• Created the burst table to include all the recipients and busted reports to the recipients (bursting) Applied conditional formatting, calculations, prompts and filters on the reports.
• Worked on Java Script to perform Prompt page validations.
• Developed complex multi-page list reports with multiple report outputs (PDF, HTML and CSV), Used all type of variables (Render, Style, and Text Source), Page Set and advanced sorting options.
• Migrated Power play studio reports to Analysis studio reports, assisted user in understanding analysis studio features.
• Administration of Dispatchers, Query service settings, cache refresh, data sources, configuration for Dynamic Cubes on Cognos connection.
• Dimensional reporting based off Dynamic cubes and Framework Packages in Report studio and workspace advanced.
• Implemented security in Dynamic Cubes and Transformer Cubes and Framework Models.
• Developing Design documents for Dynamic cubes, Framework Models, Reports, Dashboards before the development as per best practices.
• Created burst reports and scheduled those reports with bursting enabled at weekly and monthly.
• Extracted the Data using SQL queries and validating against Cognos report studio reports.
• Experience in writing HTML/Java Script in Cognos report studio reports as per the requirements like tabbed reports, dynamic sorting, hide and show objects.
• Set user and role based security at reports, package and folders levels.
• Daily checking resolved tickets raised by customers.
• Deployment of application changes (publishing packages), Import/Export packages to Different environments.
• Created reports in ASP.NET for business requirements.
• Working on report enhancements and troubleshooting the issues at report level.
• Reviewing and fixing the Report level issues, pertaining to Development or Administration.
• Involved in migration of projects from older versions to latest environments.
• Modify existing Framework manager package to create filters in Package for improved performance.
• Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied.
• Trained end users in Cognos suite of products.
• Implemented Securities on cubes and reports in report level, Model level, packages and catalog level.
• On-Call support activities which involves close monitoring of Cognos servers, taking necessary steps to tune up the environment’s performance.
• Proactive monitoring and reporting continuous Reports failure, Badly Scheduled, Long Executing and worst performing reports.
• Designed and modified reports with Java SDK in Report Studio.

Environment: Cognos 10.2, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, PeopleSoft HRMS 7.6, Workspace, Dynamic Cubes, Workspace Advanced, Active Reports, Informatica Power Center 9.5/9.6, DB2V10, Oracle11g, Toad, TFS, Share Point, VB.Net, ASP.Net, MS. Word, MS. Excel, Windows 2007/XP and UNIX.

Confidential, Austin, TX

Senior Cognos Developer Administrator

Responsibilities:

• Involved in requirements gathering from business users and prepared functional and technical design documents for further development.
• Developed Cognos Framework Manager models/packages (DMR and Relational), IBM Cube Designer (Dynamic Cubes), Transformer models (Power play Cubes), Cognos TM1 cubes to solve the BI needs of the user community.
• Successfully installed and configured Cognos10.2 environments in Windows server 2008 across IIS 7.5 and Active Directory.
• Identified Reporting elements from the data sources and developed the model for reporting.
• Used Framework Manager to create dimensional/relational data model using multiple data sources.
• Developed List, Crosstab, Charts, Master Detail, Burst and Drill through reports Adhoc reports and Top ten reports for departments like Retail Sales, Dealer Stock, Wholesale Sales, Plant Stock and Customer Orders in Report Studio.
• Created active reports as per business and user’s requirements.
• Set user and role based security at reports, package and folders levels.
• Involved in fine-tuning reports to improve performance by manually creating joins, reducing number of queries in reports.
• Created Burst Reports and Multilingual Reports based on groups of users and Preferences for our Australia, New Zealand and China partners.
• Created Drill Through Reports and Master Detail Reports for Marketing Department.
• Created dashboards, port lets for various Sales and Cost Group reports. E.g. Sales by region were displayed as dashboards.
• Extracted the Data using SQL queries and validating against Cognos report studio reports.
• Creating reports based on DMR Model, Cubes using MDX Functions.
• Administer Cognos environment that included report and job(s) scheduling, maintenance of public and individual folders, distribution lists, user groups and roles on Windows platform.
• Used Governing techniques for improving performance of the Query.
• Tested and validate report/model data using SQL and MDX queries.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Designed OLAP Reports using most of the Report studio features (Conditional Formatting, Conditional layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Wrote Macros and scheduled macros to run Reports and refresh Cubes.
• Implementing security using macros, session parameters & parameter maps.
• Exceptionally good and experienced in handling the problem and troubleshooting.
• Updated Stored procedures, Database views as per user requirements.
• Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
• Troubleshooting environment related issues in Cognos connection portal.
• Working on report enhancements and troubleshooting the issues at report level.
• Reviewing and fixing the Report level issues, pertaining to Development or Administration.
• Support includes but not limited to server, software installation, tuning, configuration, security/role, and release and license management.
• Regular check for application servers for ensuring they are up and working properly.
• Create quality documentation on work relate issues and resolutions which are useful for knowledge sharing.

Environment: Cognos 10.2 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, SDK, Active Reports), IIS, IBM HTTP, Windows, Dynamic Cubes, VM, Cognos Power Play Transformer, JSP, HTML, Java, Schell Script, Oracle 11g, Netezza, Quality Center, Linux 5.4.2, Win2008.

Confidential, Pennington, NJ

Cognos Administrator / Developer

Responsibilities:

• Gather Requirements and reporting issues from the End users
• Functioned with the development, infrastructure, support for providing the BI development, upgrade, migration and support.
• Enabled single sign on for Cognos login.
• Installed and configured Cognos10.
• Configured Active and Standby content managers for failover protection.
• Successfully upgraded reports and models from Cognos 8v4 to Cognos 10.
• Configured online and batch dispatchers for load balancing.
• Involved in performance tuning to free up memory and prevent memory leaks.
• Extracted the Data using SQL queries and validating against Cognos report studio reports.
• Monitoring the Cognos infrastructure.
• Responsible for Cognos Server Administration, security and migrations.
• Worked in Cognos tools in Cognos 10 (Transformer, Framework Manager, Query Studio, Report Studio, and Cognos Connection).
• Set user and role based security at reports, package and folders levels.
• Developed Model and Packages using Framework Manager 1.0 for both Report Studio and Query Studio.
• Taking updates from Users on daily bases updated same in to the Reports and Documents.
• Developed most of the reports along with the team to reach the requirements and deliverables.
• Developed list reports with multiple queries, Joins, Unions and complex formatting using Repeaters, Singletons, Layout Component Reference.
• Created various IQD package in Framework Manager and used this IQD’s in Power Play transformer to create various models and build cubes.
• Code deployment, user creation and licensing.
• Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.
• Monitored the jobs in Tivoli.
• Security Implementations for the deployed packages and reports.
• Prepared the MOI and HR Dash boards on daily Weekly basis and sent to users.
• Involved in Server Validation Test when Server moved from one environment to other.
• Managed distributed servers (BI and Cognos dispatchers).
• Perform day-to-day support activities & work in the Cognos Support team and development project teams to understand business requirements, models and reports design. Transition the same knowledge to the team for full support.
• Enhanced the existing Cognos environment using Cognos software development kit (SDK).
• Implemented Cognos SDK to query Cognos content store.
• Handled different issues as for the process of P1, P2 and P3
• Schedule the reports in Cognos connection and burst them through email and directories, using the burst table.
• Grant the user access in different environments.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Responsible for creating the Cubes and Reports and scheduling them accordingly.
• Deployed the reports using Cognos connection.
• Resolved the errors in operator and Designer (Dead Lock, Data Issue, Data base down, Unique Primary Key Error, Delimiter Issues).
• Created the ODI repository.
• Involved in unit testing of all the reports and documented all the test cases worked on.
• Responsible for developing and mentoring project team both onshore and offshore and deployment of the solution in production.
• Monitoring daily, weekly & Monthly Jobs Preparing consolidated daily job monitoring report for the team.

Environment: Cognos 8.4/10 BI (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection), Impromptu reports, Cognos Transformer v7.4, Java, Shell Script, Oracle 10g, Service Now, Teradata v13, HP-UNIX, Tivoli, ODI11g, FileZilla.

Confidential

Cognos Developer

Responsibilities:

• Created Standard reports in Report Studio, Analysis Studio, Ad-hoc Reports in Query studio.
• Created the reports using Report functionalities like Cross-tab, Master Detail.
• Involved in designing detail filters, summary filters, calculations and develop the report with the client specific guidelines for report development.
• Creation of Prompts like Value Prompts, Search Prompts, Date Prompt, Cascading Prompts, Calculations and Filters.
• Creating List, Chart, and Drill through, Dashboard reports as per the analysis made on the user requirements.
• Involved in security for creating Groups, Roles and giving access to the Users.
• Created Conditional blocks using String Variables & Boolean Variables, Layout Calculations.
• Dynamic dropdowns with value prompts.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Developed Impromptu Web Reports and published using Upfront.
• Setting up Drill Through to Cognos Impromptu and to the Power Cubes.
• Involved in using Framework Manager IQD's and CSV's in Cognos Power Play Transformer.
• Good interaction with the on-site coordinators on a regular basis for resolving issues pertaining to reports delivered and special client requests.
• Involved in Query Calculations & Layout Calculations as per the Requirement.

Environment: Cognos 8, Impromptu 7.3,Access Manager, Windows XP, ORACLE 9i (SQL, PL/SQL), PeopleSoft (HR, Benefits, Payroll, Fully Custom Time & Labor), Power Play Transformer, Windows NT, UNIX, Informatics Power Center 6.1, TOAD.