ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
Professional Summary:
● Over 9 Years of experience in Business Intelligence reporting, development, analysis, design,
testing and implementation of Cognos applications in providing solutions for Retailing, Finance,
Health and IT.
● Expertise in Cognos 10.2/10.1/8.x BI Suite (Report Studio, Framework Manager, Query
Studio, Analysis Studio, Event Studio, Cognos connection, Business Insight, Business
Insight Advance), Cognos 8 BI Suite (framework Manager, Report Studio, Analysis Studio,
Event Studio, Query Studio, Cognos connection), Cognos Impromptu 7, Cognos TM1 9.x.
● Cognos Transformer, Power Play, Access Manager and Server Installation & Maintenance.
● Experience in building Complex Report using Report Studio like Filters, Customized Prompts,
Conditional Formatting, Conditional Blocking, Master/Detail relation Reports,
Drill-Through reports and Ranking.
● Proficient in Bursting the List reports to different user groups and Scheduling.
● Creating reports having Filters, multiple Prompts such as Select & Search, Value, Date, Time &
Date & Time prompts.
● Designed complex report calculations like Query Calculations and Layout Calculations,
created various Sections, Groups, Classes, Joins, Unions, Section filters, Customized filters,
dynamic and Cascading filters.
● Expertise in relational and Dimensional Modeling (DMR) with strong knowledge on developing
schemas like Star Schema and Snowflake Schema.
● Developed and Published Packages using Framework Manager - Connecting and testing the
data source, creating database layer, physical layer and presentation layer, defining appropriate
relationship between query subjects and created Model level filters, prompts, calculations and
summaries in Framework Manager.
● Proficient in creating and translating information from various corporate systems data into
visually rich Dashboards using gauges, maps, charts, and other graphical elements.
● Experience in migrating Catalogs and Reports from Cognos 8 to Cognos 10 environment.
● Having experience in Event Studio for scheduling and emailing reports. Automate Reports and
generate documents using Scheduler.
● Experience in Deployment (Export/Import) using Framework Manager into Cognos Connection
and Implement Security at various levels.
● Experience in Analysis Tools like SAS, SPSS and Excel VBA.
● Extensively worked on Relational databases like Oracle 11g/10g/9i, SQL Server, and DB2
● Expertise in OLTP/OLAP system study, developing Database schemas like Star Schema and
Snowflake Schema, analysis and E-R modeling.
● Having knowledge on ETL tools; Datastage 8.x, Informatica Designer tools (Source
Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and
Mapplet Designer), Informatica Workflow Manager and Workflow Monitor to build sessions
and run workflows.
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
● Provided User Acceptance testing, End User Training, Support and performed different Test
scenarios like System level, Use-Case and Role-Based.
● Strong Troubleshooting and production support skills and coordination/interaction abilities with
end users in gathered Requirements and reporting issues from them.
● Having excellent analytical, Problem Solving, Communication and Inter-personal skills to
manage and interact with individuals at all levels. Able to interact effectively with other
members of the Business users, Quality Assurance and other teams involved with the System
Development Life cycle.
Certifications:
IBM Cognos10 BI Author
SAS - Business Intelligence
SAS - Data Integration
Technical Skills:
IBM Cognos 10.2/10.1/8.x BI (Report Studio, Framework Manager, Query
BI Tools:
Studio, Analysis Studio, Event Studio, Cognos Connection, Business Insight,
Business Insight Advanced)
IBM Cognos Impromptu 7, Cognos TM1 v9.x
SAS BI tools (Enterprise Guide, Information Map Studio, OLAP Cube
Studio, Web Report Studio, Dashboard, Information Delivery Portal, Add-in
for MS Office).
Informatica (Power Center Designer, Workflow Manager), Informatica
ETL Tools:
Repository Services and Integration Services.
Datastage 8.x
SAS (Data Integration Studio,Management Console, DQ-DataQuality)
Oracle 11g/10g/9i, SQL Server 2005/2000, My Sql, MS Access, DB2, HDFS
Database Systems:
SQL, PL/SQL, HTML, Java Script, XML, PHP, C#, Hadoop, MapReduce,
Programming Skills:
Pig Latin, Hive
MS Office Suite - Excel, VBA - Macros, Word, PowerPoint, Visio, Project
Business Tools:
SQL*Plus, SQL Developer, Toad for Oracle
Database Tools:
Predictive Analytics SPSS, SAS- Enterprise Guide
Software
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
Professional Experience:
Ohio Administrative Knowledge Systems, OH Jul' 13 – Till Date
Sr. Cognos Developer
As a part of DSI team on OAKS project, involved in design and implement new IT systems to modernize
the departments of both FIN and HCM operations in the Ohio state. Converted user requests into
technical requirements and created/modified test procedures for capability and reliability. Provided
training for OAKS Users across agencies on Cognos Query Studio. Involved in providing training to the
enrolled employees. Provides technical system advice and guidance to FIN and HCM teams. Perform
systems analysis and designing assistance to data warehouse & ETL developers. Analyzes system
problems & creates System Investigation Requests (SIRs) & Customer Relations Management (CRM)
cases and Maintain system design standards & procedures
Responsibilities:
● Design and Developed Framework Manager models by using Model/ Data Source / Stored Procedures,
and published them to server.
● Designed Complex reports in Report Studio by creating conditional Formatting, Master-Detail
Relationship and Drill-through reports.
● Created new query items by Query calculation and Layout calculation, formatted headers.
● Created Sections, Groups, Aggregate functions and Rollup aggregations on List and cross-tab reports.
● Created conditional page layouts, page Breaks, Bookmarks.
● Migrated reports from Cognos Series 8.x to Cognos 10.1
● Migrated reports from Cognos 10.1 to 10.2 Environment.
● Provided Training to user on creation of Ad-hoc reports using Query Studio.
● Involved in understand the user requirements registered in OAKS Help desk, and translating them into
user requirement documents and creating reports after the BISC approval.
● Create / built, tested and validate the enhancements in General Ledger reports based on the requirements
documents provided by the users and create / modify design test procedures, test system for validity &
reliability
● Creates & maintains Cognos architecture, user manual and guidelines and upload the enhanced
documents in OAKS site for further user reference.
● Created new query items based on the user requirements in Budgeting and Planning reports
● Updated the EDGE Data-marts.
● Row level suppressions in the report for better understanding insight.
● Frequent updations of the query items/ query subjects based on the ERP changes.
● Experience in setting up environments and providing best practice approaches and solutions to clients
along with the team.
● Coordinating with FIN and HCM development Team tasks, Deliverables and working on high priority
issues.
● Testing reports using review checklists for Quality Assurance before delivering to the end users.
● Conducted accounts testing for correct access by following security procedures to ensure data security
and correct user access.
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
● Involved in architecture and data analysis team meeting for data related issues and provided design
assistance and its impacts with automation.
● Provided Training for OAKS reporting Users across agencies.
● Involved in training on Creates logical / physical / dimensional data model & data dictionaries for
enrolled employees, and providing knowledge on writing system requirements and documentation.
● Participates in multi-organizational, multi-disciplinary team to determine, articulate & codify business
requirements, models and assist them to establish & maintain the OAKS EPM infrastructure team.
Environment: Cognos 10.2/10.1/8.4 (Framework Manager, Report Studio, Query Studio, Events Studio,
Cognos Configuration, Cognos Connection), Datastage, Oracle11g, PL/SQL, TOAD and Windows
JPMorgan Chase, NY Mar' 12 – Jun' 13
Sr. Cognos Developer
JPMorgan Chase (NYSE: JPM) is one of the oldest financial institutions with a history dating back over
200 years with a leading global financial services. Its client portfolio consists of consumes, small
businesses and many of the world’s most prominent corporations, institutes and governments. The
application mainly has three reports relates to HR department with pre-defined templates. The application
had multi drill-through crosstab reports, Conditional formatting (highlighting), dynamic prompts,
cascading prompts and macros. Familiar with TM1 rules and editor in creating various calculations like
What if analysis for TM1 planning, budgeting and forecasting. Experience in working with large sets of
data, Multi dimensional data sets in a Datawarehouse/Data Store supporting Data Mart, etc.
Responsibilities:
● Created Drill-through on crosstab report
● Developed and Designed Chart reports, List reports, Crosstab reports for dashboards
● Created complex reports like Master-Detail reports, Drill through reports, Drill down reports
in report studio.
● Gathering client requirements and writing Specifications to report generation.
● Created Ad-hoc reports in Query Studio and standard reports in Report Studio.
● Used Macros to create multi selection for prompts
● Created Report Template Layouts to be a basis for the other reports
● Developed various reports with several functionalities such as drill-through, roll-up and drill-
down using dimensional modeled relational (DMR) sources.
● Developed different kinds of reports using calculations, conditional formatting, exception
highlighting, static choices, style variables, dynamic grouping, Conditional Blocks on the reports
using Report Studio.
● Creating reports having filters, multiple Prompts such as Select & Search, Value, Date, Time &
Date & Time prompt and cascaded prompts.
● Configured Cognos to perform bursting and bursted reports in order to have users to view the
subset of data and send emails based on the user groups.
● Migrated several packages and reports from Cognos version 8.4 to Cognos 10.1.
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
● Developed reports from medium to high level complexity using Report Studio and Analysis
Studio.
● Creating Master-Detail reports which has parameterized detail query / filtered detail query based
on the user requirements in Report Studio.
● Built Framework Manager Model, and established the cardinalities to suit the business needs.
Created Projects, Models, and Packages using Cognos Framework Manager and deployed
packages on Cognos Connection
● Familiar with TM1 rules editor to create various calculations, What if analysis for TM1
planning, budgeting and forecasting. Load and retrieve data from various data sources to create
complex Active Forms.
● Developed and Published Packages in Framework Manager - Connecting and testing the data
source, created database layer, physical layer and presentation layer, defining appropriate
relationship between query subjects.
● Testing the reports for data accuracy and consistency, run, view and analyze the reports in
different formats.
● Analyzing client business processes and information needs and Interacted with the client for
requirement analysis.
Environment: Cognos 8.4 and 10.1 BI (Framework Manager, Report Studio, Query Studio, Analysis
Studio), Cognos TM1, Informatica, Oracle 9i, DB2, IIS, Windows.
Amgen Inc., Thousand Oaks, CA Feb ’10 – Dec ’11
Cognos Developer
Amgen is a leading human therapeutics company in the biotechnology industry. The project effort was to
incorporate Argus Safety as an adverse event reporting system that offers regulatory reporting and drug
safety database. Argus Safety Modules helps in providing a solution for integrated drug safety and risk
management; resolves obstacles for pharmaceutical companies; provides systematic pharmacovigilance
data; and delivers key performance indicators and metrics from various components. It provides
innovative medical solutions for better patient outcomes and delivers values through clinical leadership
and excellence
Responsibilities:
Worked extensively on Framework Manager, Report Studio and Query Studio of Cognos 8.2
Managed scheduling of reports, maintenance of public and individual folders, distribution lists,
users, groups and Roles using Cognos connection in Cognos 8.2
Worked on Multidimensional Models(OLAP) in Framework Manager and used it in Analysis Studio
Created Models, Model level Filters, Calculations and Prompts in Framework Manager.
Created various packages in Framework Manager and published it to Cognos Connection
Used Framework Manager in ReportNet to model metadata from different databases for use in Report and
Query Studio.
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
Extensively used prompts, drill-through, master-detail query relationships, conditional formats,
grouping and sorting features of ReportNet to generate efficient and user-friendly reports
Created Business mix reports, Trend over time reports, Forecast reports using PowerPlay
Involved in the entire project life cycle from evaluation, installation and development of end user
Reports
Environment: Cognos 8.2 (Framework Manager, Query Studio, Report Studio, Query Analyzer),
Reportnet1.1, SAS Enterprise Guide, Oracle 9i .
Satyam Computer Ltd, Hyderabad, India Mar’ 2006 – Dec’09
BI Developer
Emergency Management and Research Institute, is a world class organization to handle Emergencies
caused by either Medical, Police or Fire. Call centre handles the calls from entire state and respond the
emergency with ambulance (includes life saving equipment), in India with the head office located at
Hyderabad. They has more than 15 different departments which depend on various kinds of reports and
Dashboards. For report building IBM Cognos is used and later, migrated to SAS BI and Microsoft
products for their web development.
Responsibilities:
Gathering Business Requirements for reports generation by using Cognos and SQL Server.
Was actively involved in gathering user requirements, converting them into Documentation.
Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter,
Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, XML Source Qualifier and
Sequence Generator Transformations.
Created Complex Mappings which involved slowly Changing Dimensions
Actively involved in creating several reports like trend reports, Crosstabs, Multidimensional reports
Worked on Cognos 8 tools like Framework Manager, Report Studio, Analysis Studio, Query Studio
Was involved in monitoring the Web based client applications as well.
Actively involved in Migration from Cognos to SAS BI tools like SAS Information Map Studio, SAS
Dashboard, SAS Enterprise Guide, SAS Management console.
Environment:
Cognos8.3 (Framework Manager, Report studio, Query Studio), Informatica 7.1,Oracle9i, TOAD, SAS
BI Tools (SAS Information Map Studio, SAS Dashboard, SAS Enterprise Guide, SAS Management console),
SQLServer 2005/2008, Windows 2003 and NT Server, Ms visual Studio DotNet C#, ASP .NET.
Aqua Information Systems, Inc
ARUNA. KANUMURI
Sr. BI Developer
aco7a6@r.postjobfree.com
Logic Designers Feb’ 05 – Mar’ 06
Hyderabad- India
Developer
Logic Designers is an offshore development company to "New Breed Inc." Located at North Carolina,
USA. The New Breed Inc works for Logistics Ware House Management support system with various
clients Siemens, i2, isoft, Karcher, Verizon, Motorola, etc.
Responsibilities:
Involved in designing the web based module using ASP . Net using C#.
Created several forms and reports using Oracle 8i.
Extensively involved in back end coding by writing several Stored Procedures, Triggers, Cursors,
Functions and SQL statements for Data retrieval and Data loading into the database from the front end
screens
Transferred knowledge using a strategy document describing requirements and issues.
Involved in testing the forms and reports developed by other users and comparing the samples by
querying the databases
Interacting with non-technical users to gather the functional requirements
End user training for the non-technical users and explaining the functionality of the applications
Involved in creating low level design and high level design documents
Designed and developed crystal reports using Seagate crystal reports and Oracle with Toad interface.
Interacted with onsite team in gathering the requirements and developing an Web based application using
ASP.Net with coding in C# and Oracle as backend database.
Involved in Fine-tuning SQL overrides and Look-up SQL overrides for Performance Enhancements.
Environment:
C#.Net, ASP.Net, Oracle, Seagate Crystal Reports, Toad, Windows 2000, XP
Education:
Ph.D Annamalai University
M.phil, BITS Pilani, India, 2010
MCA - Master of Computer Applications (MK University, TamilNadu, India), 2002
Aqua Information Systems, Inc