CognosnDeveloper

SWETHA C

Status: Greencard

**********@*****.***

Mobile no 618-***-****

PROFESSIONAL SUMMARY

• Over 5 years of IT industry experience and 4 years of Enterprise Business Intelligence lifecycle implementation and Cognos BI Suite.

• Expertise in Cognos 8 BI including Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Administration Tasks, HTML, Dashboards, Cognos Report net 1.1MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Analysis Tools such as Cognos Transformer and Power Play 7.x/6.x.

• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Report Studio.

• Strong Experience in developing Custom Portal Tabs, complex Dashboards, custom prompt pages using HTML and Creating Variables for Complex Formatting Reports.

• 2 years of experience in working with Cognos Report Net utilizing Framework Manager, Cognos Connection, Report Studio and Query Studio.

• Experienced in IWR (Impromptu Web Reports), Publishing using Upfront, maintaining Users, User classes, Deployment, Scheduling the Reports and sending Updated Reports to Recipients through E-Mail Notice Cast.

• Experience in Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access and DB2.

• Strong knowledge in data warehousing concepts - Star schema, Snow Flake Schema, Fact Analysis.

• Experience in Migrating Cognos models and applications from CRN to Cognos8 and Cognos Series 7 to Cognos8.

• Experience in Utility, Financial, Healthcare and Pharmaceutical sector.

• Excellent written and verbal communication skills. The ability to work independently as well as collaborate as needed to meet project requirements and deadlines.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 8.4.1/8.4/8.x Suite: Framework Manager, Report Studio, Query Studio. Event Studio, Cognos Transformer 8.4/8.3 (Multi-Dimensional OLAP), ReportNet 1.1/1.0x, Cognos EP series 7, Impromptu, IWR), Cognos Administration, Access Manager, Cognos Connection, PowerPlay Studio

Databases: Oracle 9.x/10g/11g, SQL Server 2000/2005/2008, DB2, MS Access

Programming Languages: PL/SQL, TSQL, HTML, XML

Web Servers: IIS, Apache, HTML, XML, CSS

Operating Systems: Windows NT/2000/XP/ME/98/95, Windows Server 2000/2003, Linux Distributions-Red hat, SUSE, Ubuntu, UNIX

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables

CASE Technologies: Rational Rose, UML, and MS Visio

Agile Methodologies: SCRUM

EDUCATION

Master of Science, CIS (Computer and Information Systems) –University of South Alabama, USA

Bachelor of Science, CSE (Computer Science Engineering) – JNTU, India

WORK EXPERIENCE

Employer: Consilium 1

Client: GE Aviation, Cincinnati, OH Feb11 – Present

BI Cognos Developer

The purpose of the program is to assist airline customers with fuel usage and processes. This involves multiple BI methods and Cognos reporting for detailed analysis of flight records and then recommendations to reduce consumption, save money, and reduce emissions.

• Reviewed functional requirements and technical specifications and documented them as needed.

• Created projects, designed models for reporting, created and published packages in Framework manager from various data sources.

• Migrating reports from Primus Cognos to GE Cognos environment.

• Created reports using report studio as per the client requirements.

• Resolved the Performance issues of the Reports.

• Testing the report and the validity of the data it retrieves from the database.

• Verification of the data in the back end database using TOAD.

• Making enhancements of the report based upon the requirements of the user.

• Modifying the existing report based upon the change request by the user.

• Involved in Client interaction when further clarifications are needed.

Environment: Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio) MS SQL 2005

Employer: TXU energy Dallas, TX Feb10 – Nov10

Business Intelligence Analyst/Developer

TXU energy is a Texas-based company and a subsidiary of Energy Future Holdings. The project was to provide transactional support to the organization – Business Markets by managing and estimating the modifications(Deal changes) to current contracts and providing analysis of historical usage files for the business to prepare customer energy quotes.

Responsibilities:

• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.

• Designed Reports using complex features of the Report studio (Conditional Formatting, Conditional Page layout, Sections, page Breaks,Drill Through, Drill Down, Drill Up).

• Developed List, cross tab, drill through, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple data bases.

• Developing Analysis Studio views of analysis from dimensional modeled packages.

• Involved in Unit Testing for all reports and packages.

• Analyzing all reports and Standardize these reports using Power Prompts and Charts

• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports

Environment: Cognos 8.3/8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Oracle10g (SQL, PL/SQL) and Windows 2003 server.

Employer: Pinnacle Consulting

Client: TXU energy, Dallas, Tx May09 – Jan10

Cognos Consultant

The OLAP project was to provide an analysis report for the Business Markets by managing and estimating the modifications(Deal changes) to current contracts and providing analysis of historical usage files for the business to prepare customer energy quotes.

Responsibilities:

• Reviewed functional requirements and technical specifications and documented them as needed.

• Created and published packages/multidimensional models using Framework Manager from multiple data sources.

• Performed data modeling and query tuning in Framework Manager and Report Studio to achieve maximum performance while retrieving data from multiple data sources.

• Developed complex Report Studio reports involving drill up, drill down and master/detail queries.

• Migrated impromptu reports Cognos Series 7 to Cognos BI 8.3

• Created Scorecard as well as Dashboard reports for the company executives.

• Used Cognos Connection to schedule and burst reports across the Business segments based on the security settings.

• Create the scorecard reports using the Metric Studio.

• Provided production support and trained end users in Cognos 8.3.

Environment: Cognos 8.3(Report Studio, Query Studio, Analysis Studio, and Cognos Connection), Framework Manager (MR3), Windows XP, Cognos 7.3 Cognos Transformer 8.1/8.4, Oracle10g (SQL, PL/SQL) and Windows 2003 server.

Employer: Armanda Resources Consulting

Client: NorthShore University Health Systems,Chicago,IL Sep08-Jan09

Business Intelligence Consultant

This project was developed for providing the information about the patients and physicians records such as Labor Delivery and Hospital Billing. Reports were developed for the users to provide the information and there were reports which has to be sent to state government on timely basis.

• 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.

• Define Global Drill through Definitions and established drill-through functionalities.

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

• Used Cognos Transformer to build multidimensional cubes and used it in Dashboards.

• Resolving the Performance issues of the Reports.

• Testing the report and the validity of the data it retrieves from the database.

• Verification of the data in the back end database using TOAD.

• Making enhancements of the report based upon the requirements of the user.

• Modifying the existing report based upon the change request by the user.

• Involved in Client interaction when further clarifications are needed.

• Involved in UAT with Users (Reports Demo) and working on Modifications provided by the users and taking Sign Off from Testing.

• Customizing cognos Connection Portal based on the User Requirements.

Environment: Cognos 8.3 Bi Suite( Framework Manager, Cognos connection, Report Studio, Query Studio, Analysis Studio, Oracle 9i, Cognos Access Manager, Sun Java Directory Server (LDAP), Windows 2003

Employer: Vedicsoft Solutions Consulting

Client: Daiichi Pharmaceuticals, Montvale, NJ Jan08 – Aug08

Cognos Consultant

Daiichi is a wholly owned subsidiary of Daiichi Pharmaceutical Co. Ltd in Tokyo. Daiichi focuses in specific and specialized therapeutic areas through the development of innovative products that improve patient's lives. The objective of this project was to support Business Executives to take quick decisions. Generated and analyzed reports based on buyers, representatives and marketing specialist that focus on market performance in different locations.

Responsibilities:

• Involved in Planning and implementation of Cognos 8 BI Suite.

• Worked jointly with the data management team members to understand data domains, values, cardinalities and other dimensions of data needed to support BI solutions.

• Created and published packages from Cognos 8 BI Modeling.

• Created Complex Reports in Cognos 8 BI Report Studio.

• Developed List, cross tab, drill through and complex reports which involved multi-queries.

• Scheduled the reports and bursted reports according to user requirements in Cognos.

• Upgraded Reportnet Reports, Packages and Data Source Connections into Cognos 8 BI.

• Upgraded the Cognos version 7.x to Cognos 8.2

• Deployed Packages and Reports from DEV Environment to QA and PROD Environments.

• Creating report views with saved prompts and schedule according to the business requirement.

• Personalized Cognos Connection, Specified display options, regional options and personal information.

Environment: Cognos 8.2 BI Suite, Framework Manager, Query Studio, Report Studio, Analysis Studio,SDK, CognosTransformer7.4,Windows NT/2000, .Net 3.5 framework, Oracle 10g, JavaScript, SQL, PL/SQL, TOAD 9.6

Attended school at University of South Alabama Aug 2006 – Dec 2007

Employer: UTL Technologies Ltd, Secundrabad, India Feb06 – July06

Cognos Developer

The main objective is to provide an automated platform for reconciliation of Ending Derivative Asset and Liability Balance and P&L between the multiple Business Units data and the FP data. It also helps in summarizing the variances and creating the final Journal entry numbers for the given quarter for Corporate.

Responsibilities:

• Worked with Business Analysts for requirement gathering, business analysis, and testing and project coordination.

• Designed the metadata model using Framework Manager.

• Developed new reports in ReportNet1.1 using Report Studio that include Cross tab, Prompt, Drill through, Master Detail Reports.

• Created adhoc reports in Query Studio.

• Involved in installation and configuration ReportNet 1.1.

• Created IQD files for Power play cubes as data sources.

• Identified the dimensions, hierarchies and performance measure for Analytical requirements.

• Designed the Transformer Model and build the Power Play Cubes using Power Play Transformer.

• Implemented dimensional based security in cubes using Access Manager.

• Involved in troubleshooting and maintenance.

Environment: COGNOS ReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio, Cognos Connection), COGNOS 7.3 (PowerPlay, Transformer, PowerPlay Web, Report Administration, Access Manager, Upfront), Oracle 9i, Windows2003

References available upon requested

Contact this candidate