Manager Developer

Swetha L

*******.***@*****.*** +1-732-***-****

SUMMARY:

Certified Cognos Developer with around 7 years of in depth and comprehensive experience in

•

design, development, testing, Security and Support for Data warehousing and Client/Server

projects .

• Thorough understanding of Software development life cycles (SDLC) designing, developing and

implementing enterprise scale information management applications, reporting and handling

multiple projects

Proven experience in development and implementation of applications in various domains viz.

•

Insurance, Food and Airlines.

Experienced application developer with expertise in designing and developing Business Intelligence

•

solutions in Data Warehousing using Cognos suite (Framework Manager, Cognos connection,

Report Studio, Query Studio, Analysis Studio,Metric Studio, Event Studio, Business Insight,

and Business Advanced Insight),Cognos 8.3/8.4,Cognos 10, Cognos Report Net 1.0/1.1,

Impromptu 7.3/7.4, Impromptu Web Reports, and Analysis Tools such as Cognos

Transformer & Power Play Transformer 8.x/10.x) .

Experience in gathering and analyzing end user requirements.

•

Sound working knowledge of building complex reports, Dashboard Reports, Burst Reports,

•

Drill Through reports and Score carding reports.

Created reports by writing complex SQL queries, procedures against the database.

•

Involved in Upgrade & Report Migration from Impromptu to Report Net, Report Net to

•

Cognos 8 & 10.2, and Power play 7.x to Power Play 8.x.

Experience developing Metadata Models, and creating filters, Prompts, Calculations,

•

summaries and functions in Framework Manager.

• Complex Report building with Report Studio to customize the functionality in prompt page,

Master detail Relationships, Drill through in Report page, Customized Prompts and

Conditional Formatting.

Experience in building multi dimensional cubes as per business requirements.

•

Deployed Cognos content from development server to production server.

Extensively worked on Data Warehouse and Business Intelligence projects with ETL teams.

•

Experienced in relational data concepts and structures with large databases and complex SQL on

•

Oracle RDBMS 9i/10g SQL Server 2000,Stored Procedures, Functions, Triggers.

Extensively worked with SQL Analyzer, SQL Plus, Oracle SQL Developer and TOAD.

Worked with Business users and developed Functional and Technical design documents,

•

implementing Star Schema and Snowflake Schema Concepts based on the business process.

Expertise in developing Database Schemas like Star Schema and Snowflake Schema used in

•

relational, dimensional and multidimensional modeling.

Effectively created reports with Exception Highlights, Drill Up/Down, Drill Through Reports,

•

Cascading Prompts, Chart Reports, Crosstab Reports, List Reports and Calculations.

Automated Reports using scheduler. Experienced with performance tuning of the reports.

•

Experience in working with off shore development teams. Proven ability to deliver output on time

•

and complete detail oriented tasks efficiently.

Proven track record for attention to detail and dedication towards work.

•

Possess ability for critical thinking, analysis, good interpersonal and communication skills.

•

Team oriented, technically motivated and creative. User oriented with a desire to learn client's

•

business requirements.

Technical Proficiency:

Reporting Tools Cognos 10.2/8.x BI (Version 8.1.1, 8.2, 8.3, 8.4 )

Analysis Studio, Cognos connection, Business Insight &

Advanced, Query Studio, Report Studio, Event Studio,

Cognos Report Net 1.1, Impromptu, Impromptu Web

Reports, Power Play Transformer, Sun one Directory,

MS Active Directory, Access Manager and

SQL Server Reporting Services.

Modeling Tools Cognos Framework Manager, Cognos Transformer.

Languages SQL, PL/SQL,SQL Plus, TOAD, HTML,C,

Databases Oracle 9i, 10g, SQL Server 2000/2005/2008.

Platforms Windows Vista/2003/XP/2000/NT.

Technical Certifications : COG 112, COG 612 Report Authoring.

Educational Qualifications : Bachelor in Computer Science (JNTU).

PROFESSIONAL EXPERIENCE:

AIG, Huston, Texas Sep 2013 to Till date Sr.

Cognos Developer

American International Group, Inc. (AIG), world leaders in insurance and financial services, is the

leading insurance organization with operations in more than 130 countries and jurisdictions. The project

involved developing Cognos applications for AIG.

Responsibilities:

• Coordinated projects with off shore development teams.

• Provided guidance to the junior developers in accomplishing their tasks.

• Extensively worked with Report Studio, Frame Work Manager, and Transformer to create

reports containing complex calculations, prompts, and charts according to the user

requirement.

• Created and supported the development of Complex Reports in Cognos while working with features

including Conditional Formatting, Drill Through, Cascading Prompts, Query Calculations,

Conditional Blocks, Master Detail Relationship, Page Breaks, and Render Variable.

• Involved in the integration of Cognos portal with the business portal.

• Provided administration to the development environment.

• Applied row level security to restrict access to the data based on user.

• Built Leave administration model by using Framework manager.

• Organized metadata into different star schema grouping for each module.

• Resolved ambiguous joins as a result of parallel joins, loop joins, self joins and multiple

relationships in framework manager.

• Traced the performance of the reports and validated them from the Database level and

Framework Manager level, to the Report Studio level and tuned the reports for better

performance.

• Involved in the installation and configuration of Cognos 10, Cognos tools, web server, and

assisted in migrating reports from Cognos 8.4 to Cognos 10.

• Carried out deployment of Cognos content across different servers.

• Prepared technical document for the set up and configuration of Cognos application.

• Created reference documentation for some of the important tasks to be performed in Cognos

environment.

Environment:

Cognos 10/Cognos 8.4 (Frame work Manager, Cognos Connection, Query Studio, Report Studio,

Business Insight Advanced, Business Insight, Analysis Studio, and Transformer ) Site minder,Sun

one Directory Server, Oracle Database 10g,HTML, Windows 2003 Server, SQL Server 2005.

UPS, Alpharetta, GA Feb 2012 to Aug 2013

Sr.Cognos Developer.

UPS Supply Chain Solutions is one of the world leaders in global freight forwarding. FGV

provides customers and SCS operational personnel with comprehensive visibility against all UPS SCS

product service offerings including, Supplier Management, Transportation, Customs

Brokerage and Inventory Management. The project involved developing Cognos application for

Flex Global View.

Responsibilities:

• Installed and configured Cognos 8 & Report Net Applications. Created Database Layer,

Business Layer, and Presentation Layer, defining appropriate relationship between Query

subjects and Fact Table in Framework Manger.

• Worked on Bug Fixing and enhancements to existing Cognos reports in Report Studio & models in

Framework Manger and development of any new Reports.

• Developed List, Crosstab, Drill Through, Master Detail, Chart and complex reports which

involved Multiple Prompts in Report Studio.

• Created Reports with Optional Filters and Custom Prompt Pages in Report Studio.

• Migrated Report Net reports and Impromptu reports to Cognos 8.

• Built the metadata models using Framework Manager to best suit the Business Requirements for

Supplier Management, Brokerage and Transportation Modules.

• Involved in the integration of Cognos application with FGV portal.

• Created multi dimensional cubes using Transformer for analysis.

• Implemented cube security by using dimension views and user class views/customs views.

• Created standard report template for each business module.

• Created most commonly used calculations and filters in framework manager and organized

metadata into different namespaces, query subjects and folders in business view.

• Created ad hoc reports in Query Studio and Standard Reports in Report Studio.

• Implemented complex report logic by writing SQL queries and creating stored procedures in the

database.

• Built dashboard reports for management, score carding reports for operations personnel.

• Scheduled reports, maintained public and individual folders, created users, groups and roles

in Cognos Connection.

• Created burst reports to distribute reports to different end users. Involved in migrating

reports from Development to Testing and from Testing to Production Environment.

• Administered security to Report Net environment using Access Manager.

• Tuned the performance of the reports by using functions created at the database level and filtering

out unwanted data at the framework manager level.

• Worked in the production support team and resolved production issues as per the SLAs.

• Prepared best practices documentation for Cognos applications.

Environment:

Cognos 8.4,8.2(Report Studio, Query Studio, Cognos Connection,Framework Manger, Analysis

Studio), Access Manager, Content Manager, Oracle 10g, Cognos Report Net, Cognos Series 7, Sun

One Directory Server, SQL Server 2005, Toad, SQL, HTML,MS Access, MS Excel.

Heinz,Pittsburgh, PA Jul 2010 to Jan 2012

Cognos Analyst/Developer

The H.J. Heinz Company, headquartered in Pittsburgh, Pennsylvania, is the most global of all

U.S. based food companies. Famous for its iconic brands on five continents, Heinz provides

delicious, nutritious and convenient foods for families in 200 countries around the world. The

project involved developing Executive level dashboards, reports and cubes for Heinz Supply

Chain Division.

Responsibilities:

• Involved in the entire project life cycle from evaluation, design, and development of end user

reports.

• Gathered and Analyzed User requirements and the reporting issues from the users.

• Created Packages combining data from different data sources using Framework Manager.

• Created reports in report studio involving Drill through, Conditional formatting,

Union queries, Joins and SQL queries.

• Created dimension maps and multidimensional cubes using impromptu's Query Definition in power

play Transformer and Analyzed cubes using Analysis Studio.

• Implemented cube groups, incremental updates and time based partitioning to improve the

performance of the Power play cubes.

• Migrated power cubes from Cognos 7.3 to Cognos 8 and updated them on daily and weekly basis.

• Responsible for the cube performance tuning and reducing cube build time.

• Scheduled report using Schedule Management Tool, maintained public and individual folders

distribution lists, users, groups and roles using Cognos Connection.

• Drill through reports to drill down to the smallest factor, or key performance indicator, to see the

implications of a change on a forecast.

• Worked with Decision Stream and extracted data from different database and created own database

and used that data base in Framework Manager as a data source.

• Migrated numerous existing impromptu catalogs to Cognos8 Framework Manager.

• Worked on Framework Manager to import data from heterogeneous data sources and created

models & packages.

• Created metadata models against relational databases for creating OLTP reports and also created

DMR models in Framework Manager for OLAP reports against live data.

• Created Master Detail reports which had parameterized detail query or filtered query based

on the requirements in report studio.

• Deployment of packages, folders and Reports from Development environment to production

environment using Content Administrator.

• Provided different level of authentication and privileges to various user classes and users using

Access Manager.

• Set up alerts using event studio.

• Involved in monitoring Audit reporting based on users, reports and packages.

• Closely worked with ETL team to design data marts by understanding user requirements and

increasing the reporting efficiency.

Environment:

Cognos 8.4/8.2 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio,

Framework Manager and Transformer), Sun One Directory Server, Access Manager, Oracle 9i/10 g,

Windows 2000/XP/2008, Oracle SQL Developer.

Newark In One,Chicago, IL Feb 2009 to Jun 2010

Cognos Developer

Newark In One, a division of Premier Farrell PLC, is a world leader in the marketing and distribution of

widest range of electronic components. The project involved installation and configuration of Cognos8

server and developing Cognos application.

Responsibilities:

• Created appropriate User classes,users, and database Sign ons in Access Manager to provide

different levels of security for the users.

• Upgraded Cognos content to the latest version of Report net.

• Creating relationships between query subjects to better represent the logical structure of the business and

the user requirements.

• Created standard list, cross tab, charts and drill through reports using multiple queries in a single

report, drill through reports in report studio.

• Built reports using conditional blocks to implement certain complex business logic and also

implemented conditional styles to highlight business sensitive data.

• Provided data security, object security and package access in Framework Manager and also secured

the folders by setting up access permissions in Cognos Connection.

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

• Scheduled reports to run daily, weekly and monthly using Schedule Manager.

• Carried out bursting of reports to distribute reports to various end users by email.

•Deployed packages from development environment to production environment. Worked on complex reports

using Tabular Objects, static prompt conditions.

• Created most commonly used calculations and filters in framework manager and organized into

different folders in business view.

• Created ad hoc reports in Query Studio and Standard Reports in Report Studio.

• Tuned the performance of the reports by creating functions, procedures and packages at the database level

and filtering out unwanted data at the framework manager level. And also recommended and utilized the

aggregate tables in the database to achieve user acceptance level of run time for the reports.

• Prepared documentation for the setup and configuration of the Cognos application.

• Prepared training documentation for the developers to accomplish complex tasks in Report net.

• Administering the business users in the portal based on the requirements.

Environment:

Cognos 8.1, Cognos Reportnet1.1 MR3(Framework Manager, Cognos Connection, Query Studio,

Report Studio), Sun One Directory Server, Access Manager, SQL Server, Windows 2000.

American Airlines, Tulsa Nov 2007 to Jan 2009

Cognos Developer

American Airlines, Inc. (AA) became the world's largest airline after the recent merger with US Airways.

American Airlines, a subsidiary of the AMR Corporation, is headquartered in Fort Worth, Texas. The

project involved in developing Business Intelligence Applications for Maintenance & Engineering (M&E)

Division using Cognos BI Suite.

Responsibilities:

• Involved in data gathering during the business analysis and planning phase of the project.

• Develop Metadata models in Framework manager as per the business requirements.

• Build Multidimensional Cubes in Transformer for Analysis.

• Build Dashboard in Cognos for the Management to provide high level overview of the business.

• Developed packages for Adhoc reporting in Query Studio.

• Created complex/standard reports in Report Studio.

• Set up Power play Studio and Analysis Studio reports for multidimensional analysis.

• Created reports in report studio involving Drill through, Conditional formatting, Union queries,

Joins and SQL queries.

• Improving query performance using Governors. Importing metadata using Impromptu catalogs.

• Provided row level security, object security and package access in Framework Manager and also secured

the folders by setting up access permissions in the Cognos Connection.

• Involved in Troubleshooting and Performance tuning of the reports and cubes.

• Involved in the upgrade of reports from Cognos 8 to Cognos 10.

• Set up time critical alerts and reports in Event studio.

• Decreased the cube build time drastically and increased runtime performance.

Environment:

Cognos 10/Cognos 8 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Cognos

Connection, Event Studio and Transformer), Sun One Directory Server, Site minder, Oracle 9i/10g, SQL

Server 2005, Teradata, Windows XP, Toad.

Contact this candidate