Sai

Sr Cognos Developer

acu5ii@r.postjobfree.com 908-***-****

Professional Summary:

Accomplished Data Warehouse and BI professional with proven expertise in ETL, BI and DBA.

More than 9+ years of total software experience.

Experience with SAP FI, oracle financials and HRMS, QAD EE, PeopleSoft and Seibel. Reported off the views created on oracle HRMS system.

Proficient in all phases of Data warehousing concepts. Experience with Dimensional modeling, like Star Join Schema, Snowflake Schema, FACT, Dimension Tables and logical/Physical data modeling using ERWIN.

Expertise in SQL, PL/SQL and Dynamic SQL for stored procedures.

Excellent knowledge of Data Analysis & Report Building

Proficient in designing complex reports using Conditional Prompts, Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards and Drill-Through Reports.

Experience in creating scripts to refresh the cubes and automating the process using TIDAL and command Center.

Experience in Cognos Administration like setting up Security access to clients using Access Manager, Setting up Users, Groups, Roles, Data Source Connection, Content Administration, Dispatchers and Services and Deployment of content from Development to Production Servers.

Extensive experience in Cognos security and external security like LDAP, AD and OAM.

Extensive experience with Data warehousing and ETL concepts

Extensive experience in performance tuning in database (oracle) and framework manager to enhance the report performance.

Extensive domain knowledge around Budgeting, Forecasting and Planning Business Process.

Expert in creating cooperate level Dashboard for better visibility of overall metrics affecting the performance. Used Cognos NOW to provide real time continuous monitoring of operational metrics and KPIs (Key Performance Metrics)

Effective Team Player with excellent analytical, programming, written and verbal communication skills.

Excellent interpersonal and technical skills with a sharp acumen for understanding and grasping of the various needs of businesses

Technical Skills:

Reporting Tools

Cognos 8.1, 8.2, 8.3, 8.4, 10.1, 10.2, 10.2.1, BI Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio and Analysis Studio), TM1, CRN 1.1, MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web, Impromptu, Upfront)

ETL Tools

Informatica Power center, SSIS, Data Stage, Data Marts, Staging, OLAP

Operating Systems

Windows 2003 Enterprise Server, XP, 2000, Windows XP/7 Professional, UNIX-AIX

Web Servers

IIS, Tomcat and Apache.

LDAP Servers

Active Directory, Sun One Directory, Apache Directory.

Programming skills

C, C++, Java, HTML, JavaScript, Visual basic, SQL, PL/SQL

Databases

MS SQL Server 2000/2005, 2008, 2010, Oracle 8i/ 9i, 10g/11g, TOAD, Teradata SQL Assistant

Professional Summary:

Maximus, Austin TX May 15 - Dec 15

Sr.Cognos Developer/Systems Analyst

End Client: Texas Health & Human Services Commission, Austin TX

Responsibilities:

Involved in Gathering Requirements and the reporting issues from the business and end users.

Developed Framework Manager Models by following best practices and also modified to incorporate the new data elements as per the business needs.

Extracted data from databases using ETL tools like Informatica Power Exchange and also involved in monitoring ETL jobs that run every day to load the data from source environment.

Designed and developed ETL Informatica Power Exchange solutions to load Data Warehouse/Data Marts.

Involved in Installation and configuration of Cognos 10.2.1 BI (Framework Manager).

Migration of reports, developed Cognos 10.2 reports from Historical Reports(Oracle Discoverer).

Involved in the performance tuning of Pl/SQL queries (Oracle as background).

Involved in verification and validation of reports using Pl/Sql (Oracle).

Developed Complex Report Studio Reports and Dashboards using Lists, Crosstabs, charts, singleton, sections, Drill Through, Joins, Unions, Images and HTML applications using Report Studio.

Involved in Unit testing and deployment to UAT and Production.

Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.

Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.

Analyzed reports and fixed bugs in stored procedures.

Involved in creating efficient multiple parameterized stored procedures for various kinds of reports.

Performance tuning by analyzing and comparing the turnaround times between Pl/SQL and Cognos.

Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new reports.

Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.

Created reports using Cognos workspace and Cognos workspace advanced.

Worked on Cognos Administration in assigning User groups, User roles with access permissions.

Environment: Cognos 10.2.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), Pl/Sql, Informatica Power Exchange, JavaScript and HTML, Windows 2007.

Genuine Parts Company, Atlanta GA Sep 14 - Apr 15

Sr.Cognos Developer/Systems Analyst

Responsibilities:

Involved in Installation and configuration of Cognos 10.2.1 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.

Involved in the performance tuning of SQL queries (Teradata as background).

Involved in verification and validation of reports using SQLA (Teradata).

Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.

Involved in designing models using Framework Manager and Deployed packages to the ReportNet Servers

Worked on automation of tasks using schedulers and scripting using UNIX Shell Scripting in UNIX environment.

Built Power Play Reports based on these cubes and published to ReportNet Server

Implemented collaborative planning, budgeting and forecasting solutions using TM1 with TM1 Turbo Integrator and Advance Rule Writing by TM1 Modeling.

Creating pixel-perfect report layout ideal for viewing an active report for multiple devices like iPads and mobile devices using active reports and report studio in 1024*704 format.

Documented the deployment process and assisted the administrator to finish the task.

Administered Access Manager to implement Security among Cognos applications (Cognos 7.5).

Migrated Catalogs and Reports to Cognos 10.2.1 environment.

Worked with the project team to deliver OLAP solutions to provide robust high availability and performance.

Optimized cubes in PowerPlay Transformer by auto-partitioning and caching.

Also created Business Intelligence Reports using Cognos Impromptu and Cognos PowerPlay.

Installed and Configured Cognos for building multidimensional Cubes as per the Business requirements.

Published Reports in various Cognos Portal environments.

Gathered Requirements and reporting issues from the end users.

Provided End User Training and Support.

Data is taken from data warehouse to build dynamic memory cubes in cognos which are added in query service.

POS (Point of Sale) support: Coordinated with business end users, vendors, software development teams & executive management to translate business requirements into actionable functional/technical design specifications and assess system performance and enhancements.

Involved in monitoring the dataflow and in optimizing the load times.

Created macros and used various Teradata analytical functions.

Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.

Environment: Cognos 10.2.1 (Framework Manager & Report Studio), Cognos 7.5 (Impromptu Administrator, Impromptu, Impromptu Web Reports, ReportNet 1.1 MR3, Cognos Power Play Transformer, PowerPlay User, Upfront Administration, Shell Programming, Access Manager LDAP server, Configurations M manager), Windows 7, Teradata R13/R14, Teradata SQL Assistant.

Catamaran, Schaumburg IL Jan 13 – Aug 14

Sr.Cognos BI Developer

Responsibilities:

Worked closely with Merchant card analysis team togather business requirements and specifications.

Developed technical specifications, data identification and also recommendations on the preferred solution for development, and deploy efficient BI solutions.

Worked on technical design specifications for Framework manager, and reporting per the requirements.

Used Framework Manager to build projects, packages based on business requirements and publish packages to the Cognos connection. Created relational models and dimensional models in Framework manager according to requirements.

Designed projects in Framework manager based on two tier models (Physical view and Presentation view). Improved long running reports performance thru writing SQL queries, resolving complex joins in framework manager, filters, and importing only necessary query subjects.

Implemented package level security and object level security while creating models in Framework manager.

Worked for global JDA i2 Demand manager implementation for North America through all the SDLC phases from requirements gathering and designing to deployment and maintenance.

Developed cubes in Transformer from IQD files and packages.

Modeled metadata from SQL Server 2008 data source for use in Report Studio and Query Studio using Framework Manager in ReportNet

Designed & developed reports using Cognos 8 Report Studio, Query Studio and Analysis Studio.

Created various List Reports, Grouped Reports, Cross Tab Reports, Charts and Drill- through Reports using Conditional Formatting, multiple Prompts, Queries, Filters, Slicers, master-detail relationship, aggregation function and Cognos complex Functions.

Created reports in Analysis Studio by using cubes and multi dimension models.

Involved in reviewing business requirements and analyzing data sources from Excel/SQL Server for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop

Developed Dashboards and created Drill through reports from Dashboard to all summary reports and Summary to Detail reports.

Developed and maintained customized cubes and optimized cubes using Transformer to meet business requirement.

Worked with cubes security issues and maintain security as technical specifications.

Scheduled and distributed reports to the end users by schedule management in Cognos connection. Implemented bursting and event trigger function when it’s needed.

Developed Cognos Portal integration &Cognos portal design.

Customized Cognos Connection with appropriate reports and security measures.

Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.

Provided technical assistance and training to Users.

Environment: Cognos8.4(Report Studio, Query Studio, Metric Studio, Analysis Studio, Framework Manager, Cognos Connection, Transformer 8.4), CRN 1.1 MR3, Informatica 8.6, JDA 8.3, PeopleSoft, SQL Server 2008 R2,Apache web server, Windows XP and Linux.

Bank of America, NC Oct 11 – Dec 12

Sr. Cognos BI Developer

Responsibilities:

Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.

Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio and created scorecard reports using the Metric Studio.

Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.

Creating new reports of Enterprise data marts for Baan Data Warehouse for the support team.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.

Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.

Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.

Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).

Managed TM1 data through Excel and customize active forms using TM1.

Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.

Customized Reports using HTML and JAVA SCRIPTS.

Upgrade the report and packages version of COGNOS from 8.4 to 10 and Participate in the regression testing and unit testing.

Customized Cognos Connection with appropriate reports and security measures.

Implemented Security with LDAP and Group level security in Cognos Connection Portal.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.

Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.

Created Active Report which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.

Developed Dash board reports to display all the information related to environment using Summary reports.

Environment: Cognos 7.3/8.4/10.1/10.2 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Transformer and Event Studio), Teradata, Hyperion, JavaScript and HTML, Oracle Data Integrator(ODI), Oracle Database 10g, Cognos Transformer 8.4, Active Reports, TM1, Windows XP Professional, VB Script, T-SQL, XML and HTML.

Dobson Communications Corporation Mar 09 – Sep 11

Oklahoma City, OK

Cognos Developer

Responsibilities:

Installed and Configured Cognos ReportNet tools and Cognos 7.2 tools

Administered the Reporting Environment

Created Reports Using Cognos Impromptu

Developed data specific Impromptu reports with various filter conditions

Developed Several Reports including burst reports using Report Studio and other Cognos 7 tools

Migrated Cognos 7 series Catalogs and Reports to Report Net1.1

Configured LDAP namespaces

Administered tasks such as scheduling, deployment, Dispatchers and security

Was involved in data merging, transformation and aggregation using Cognos Decision Stream

Was involved in developing slowly changing dimensions and data marts using Cognos Decision Stream

Published Impromptu reports to Upfront portal by using IWR Report Administrator

Responsible for data analysis, design, loading and manipulation

Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process

Made the end users comfortable using the centralized upfront server

Environment: Cognos 7.1/7.2 tools, Cognos Report Net 1.1, Cognos Visualize, Oracle 9i, SQL Server, MS Access, WINDOWS 2000/XP, PL/SQL, SQL Loader, Synopsis Tool.

Neo Soft Tech, India Aug 06 – Feb 09

PL/SQL Developer

Responsibilities:

Converted standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control

Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL*Loader

Used SQL tools like TOAD to run SQL queries and troubleshoot

Developed Stored Procedures and functions, triggers to accomplish several computations

Created user-friendly GUI interface and Web pages using HTML

Developed Servlets and used JDBC for storing and retrieving user data into and from the Oracle database

Environment: SQL Server200, Microsoft.Net, Apache server, Windows NT, and Windows 98

Education:

Bachelor of Technology in Information Technology, JNTU, Hyd. Graduated in May 2006.

Contact this candidate