Manager Data

Sunitha Veeroju

614-***-****/**************@*****.***

Professional Summary:

Highly qualified Cognos BI developer with over 10 years of verifiable experience different phases of software development life cycle (SDLC) including Analysis, Design, Development, Testing and Production Experienced in Oracle Database 10g and 11g using PL/SQL in both OLTP and OLAP.

Experienced in Data Warehouse, Data modeling, Data mapping and Database design.

Strong experience in creating and developing and publishing packages in Framework Manager.

Experienced in various Cognos tools (Cognos Connection, Report Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advanced, Event Studio and Transformer with expertise in Metadata Modeling.

As Cognos BI Consultant, responsible for evaluating and analyzing customer's requirements, design, architect, develop integrated data warehouse, data models, reports, dashboards and integrated solutions.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses(DMR, MDX).

Experience in creating Active Reports, Dashboards, Drill Through, Master Detail, Burst Reports, List, Cross-Tabs, Summary Reports and Multipage Report using Report Studio.

Extensively worked in Performance Tuning for BI reports to provide performance.

Experience in Cognos Admin 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.

Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica .

Proficient in testing reports using Motio Ci Reporting testing tool.

Excellent Communication, strong Interpersonal and presentation skills with ability to work successfully as a part of team and lead the team as well as client interaction.

Trained users on Cognos with Query Studio and Report Studio, design Cognos dashboards and also created training manuals and demos for user reference with company standards.

Strong time management and project coordination skills with simultaneous projects and meeting user requirements with uncompromising detail.

Self-motivated and ability to adapt to new technologies quickly.

Knowledge on Qlikview, SSRS, Tableau.

Used Agile sprint to deliver the project on time.

Testing\Documentation:

Experienced in drafting testing functionalities, Design Documents.TIP,TIR.

Good working experience in testing tools like Quality Center, QTP.

Technical Skills:

Cognos 10.x Suite, Cognos 8.4 Suite,Supply Chain Intelligence 2014, Framework Manager,Report Studio, Query Studio, Metrics Studio, Event Studio, Analysis Studio, Business Insight, Business Insight Advanced,Workspace, Workspace Advanced, Cognos Administration, Cognos Content, Active Reports, Visualization, Scheduling, Dashboard, Packages, Cognos Configuration, Framework Configuration, Cognos Packages, Power Play Transformer, Business Objects.QlikView.

Languages:

C, C++, Java, Java Script, HTML, XML, VB Script, SQL, PL/SQL.

Databases:

Oracle 10g and 11g, SQL Server, DB2, MS Access.

Operating Systems: Windows, UNIX.

Domain: Pharma, Insurance, Energy, Utilities.

Other: Manhattan Associates WMOS 2011, Agile Methodology, WAS 8.

Projects:

Client: GlaxoSmithKline (GSK), King of Prussia, PA Jun 2014 – Till Date

Role: Lead Cognos Developer

Project: OPAL Reporting

OPAL (Online Product Authorizations & Lifecycle) is an effective and efficient GSK-wide system for the tracking of regulatory applications and product registration details for both investigational and marketed products for all central Pharma and LOCs. It is the authoritative source of product registration information for GSK. It is a one-stop system for answering the question of what product is registered where, and what the details of each authorization are.

Responsibilities:

Interact with users on daily basis from different divisions to gather new requirements or with user issues.

Converting business requirement into code and vice versa also created technical specification documents.

Created prototype reports for business users.

Developed a Framework Manager model by importing Meta data, preparing business logic, layers, setting up object level security and developing and publishing package.

Improvement of preexisting reports by tuning and convert them into active reporting also existing Framework Manager data Model modifications.

Created several Report Studio reports using List, Cross tab, graphs,Charts,Filters, Multi Query, Ad-hoc, Bursting, Drill-Through,Drill up, Drill Down,Calculations, Conditional Formatting, Prompts, Cascaded,Page set property, Render variable etc.

Validating Cognos reports and resolving Cognos issues in UAT phase and documenting process control and changes requests in Cognos.

Created Cognos reports and alerts in OPAL to track Products Status.

Developed report against relational database model OLTP.

Developed and implemented complex reports to meet business requirement such as financial Expenses on difference life cycle, Drug life cycle statuses reports with high level of security.

Build Power play cubes to satisfy set of reporting requirements also dashboards.

Supported Dashboard for report development, configuring alerts for warnings and maintenance for update.

Detailed Knowledge on Data warehousing concepts – star schema.

Generated complex reports using Cognos Reporting Tool also involved invalidation of report using SQL Developer and performance tuning of Cognos SQL.

Demonstrated active reports and trained end users to create Ad-Hoc reports using Query Studio.

Worked under very dynamic environment.

Trained many business users in Query Studio, Report Studio, Metrics Studio, Business Insight/Advanced and Workspace and Workspace Advanced also created User Manuals with company standards.

Environment: Cognos 10.2.1(Framework Manager, Transformer, Cognos Connection, Cognos configuration, Cognos planning, Query Studio, Report Studio, Metric Studio, Event Studio, Cognos workspace,Cognos Workspace Advanced),Cognos SDK, Linux, Unix, Oracle 11g, SQL Server 2008, DB2, SQL Developer.

Client: GlaxoSmithKline (GSK), King of Prussia, PA Jan 2012 – Jun 2014

Role: Lead Cognos Developer

Project : GSK Enterprise supply Chain Finance (ESCF) Reporting

Responsibilities:

Collaborated closely with technical and non-technical resources (Technical Analysts, Systems Project Leaders, Senior BI Developer/Architect, vendors, and other business or IT personnel as needed) .

Involved with stockholders and vendors to gather new requirements or existing requirement changes on daily basis.

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

Created audit reports for internal team to monitor, analyze performance of existing model and its changes.

Designed and implemented various Materialized Views in Oracle to use in Cognos Reporting.

Created master details reports using drill through definition in report studio also Drill up- Drill down capability with DMR model.

Involved in analysis and testing of business requirements in Query and Analysis studio for its best possible output.

Created Model Query Subjects, Data Source Query Subjects and Customized data by adding Stand alone and Embedded filters in Framework Manager.

Developed hierarchies and measures to support Ad-hoc Reporting as well as Multi-Dimensional Reporting.

Renewed SSL/Webserver certificates for accessing the Cognos application.

Developed many complex reports for the different division including Finance, Claims, Providers, Members, drugs, external government agencies.

Created Dashboards using Business Insight, Business Insight Advanced, portal page dashboard, Workspace and workspace advanced.

Experienced in complex queries testing and validation of Ad-hoc report. Involved in testing, debugging and deployment of the application

Actively participated with the team when Cognos upgraded from 8.4 to 10.x

Tested the reports in Motio CI tool.

Environment: Cognos 10.2 (Framework Manager, Transformer, Cognos Connection, Cognos configuration, Cognos planning, Query Studio, Report Studio, Metric Studio and Event Studio) Cognos SDK, XML, Windows 2003 server and Unix.

Client: Guardian Life Insurance (Insurance)/ New York/Hyderabad Jun 2010 – Dec 2011

Role: Sr Cognos Developer

Responsibilities:

Installation and configuration of Cognos 8.4 and 10.1 versions, Transformer and framework managers.

Work with dimensional data warehouses in Star schemas.

Experienced in Complete Data Warehouse and Framework Manager to develop Cognos reports.

Developed models in Framework Manager and Power play Transformer. Provided training to power users in Dashboards, Query Studio and Report Studio.

Extensively worked on PL/SQL for creating triggers, stored procedures and Complex Queries.

Hands on experience in Migration of Data from Excel files to SQL 2005 using SQL Loader by creating scripts.

Experience in cubes, dashboards, scorecards and reports using Framework Manager, Transformer, Report Studio, Query studio, Metric studio, Analysis Studio, and Power Play.

Installation and configuration of Oracle, SQL developer and SQL loader in local for web portal development team.

Experienced in developing complex ETL processes in Informatica, includes extract,transfer and load data.

Worked with Product Management to prioritize and schedule development activities, design, install, configure, deploy, and operate BI tools.

Created and maintained Catalogs, Organizing Folders, Prompts, Calculations and Conditions using Impromptu Administrator.

Worked on performance tuning of existing reports and dashboards. Estimate and plan development work, track and report on task progress, and deliver work on schedule

Experienced in Cognos Administration, Active directory, Groups, roles, Security, configuration, DB connection.

Environment: Cognos 8.4 BI, Cognos Connection, Report Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Access Manager, XML, MS, Oracle, Windows 2003 server and Unix.

Client: Guardian Life Insurance (Insurance)/New York/Hyderabad Mar 2009 – May 2010

Role: Sr Cognos Developer

Project : GLIC BI

Responsibilities:

Designed and execution of Cognos8 BI Architecture, Security Implementation, Server management.

Created Framework Manager Model as well as DMR models with Database, Physical and Presentation layer also dimensional hierarchies and levels.

Implemented Concepts of Star Schema Modeling in Framework Manager.

Creating model Query subjects, Data source Query subjects and stored procedure in Framework Manager.

Developed query subjects in FM and materialized views in the database to accommodate the report net requirements.

Used TOAD and SQL scripts for testing, data analysis and query optimization.

Created List, Sub, Cross-tab reports using Customized prompts, advance filters and conditional formatting.

Involved in prompts, drill-through, master-detail query relationships, conditional formatting, grouping and sorting features of Report Studio also end user training and support.

Experienced in Decision Stream, portal, dashboard and report development using analysis.

Analyze and troubleshoot the issues regarding performance.

Scheduled reports and with different output formats.

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

Involved in testing of instrumentation equipment data also validating reports.

Performance tuning and optimizing and evaluated report effectiveness by tuning query data.

Experienced with leadership and technical direction as a team.

Environment: Cognos 8.2 BI, Cognos Connection, Report Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Access Manager, XML, MS, Oracle, Windows 2003 server and Unix.

Client: GE Nov 2008 – Apr 2009

Role: Cognos Developer

Project :Commercial Reporting

GE Power Systems (GEPS) currently consists of 7 primary businesses. Each of these businesses consists of smaller business units that are supported by various operational systems. Many of these systems were part of an acquisition or remain as a legacy of past operations. GEPS currently has a project underway called the “GEPS 25 Digital Cockpit”. The mission of this project is to implement an Enterprise Information Portal which improves business results and mitigates risks. This will be accomplished by providing a single source, web-based application for critical business metric reporting and analysis.

Responsibilities:

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

Created Database reporting tables and views for all dashboard reports in SQL Server and inserting data for prototypes and updating tables as required.

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.

Experienced in creating complex reports using Report Studio & performing ad-hoc queries using Query studio.

Developed advanced dashboards for users for different departments weekly dynamic Activities. Implemented reports in Report Studio using dimensional and relational models.

Setting up cardinalities to suit the business needs between Query Subjects.

Created new system using Report Studio which reflect the Metrics Studio Functionality this end up in cost saving.

Created Drill through & Summary and Detail Reports in cognos8 environment.

Created Variable and Conditional rendering of reports in Cognos 8.

Environment: Cognos 8 BI, Cognos Connection, Report Studio, Query Studio, Framework Manager, Impromptu, Cognos Power Play Transformer, Power Play for Web, Access Manager, XML, MS SQL Server 2005, Oracle, DB2, Windows 2003 server and TOAD.

Client: GE Energy Mar 2007 –Dec 2008

Role: Cognos Developer

Project : PS Reporting 2

GEE Power Services needs to capture the required data from different source systems (EMIS, FRMT, JDE, COMPAS, PS ERP) into a single repository environment, and make this data available within the PS SMART Data Warehouse environment. The reporting solution will provide a single automated & repeatable process for all financial reporting cycles (weekly, quarterly and annually) whilst eliminating the need for human intervention.

Responsibilities:

Installed and configured Cognos 8 BI and worked with Cognos 8 BI modeling, Report Studio.

Developed Metadata Models using cognos 8 Framework managers.

Responsible for Access permission and administrating the server.

Created highly customized reports in Cognos 8 Report Studio and some of the Ad-hoc reports in Query Studio.

Created Score Cards, Dash Boards for multiple views of Reports from multiple data sources.

Developed Prompt Page Reports using Conditional blocks and Conditional Variables

Created Repeater reports and graphical reports based on HR and Financial data warehouse.

Scheduled the Reports using schedule management tool in cognos8.1&8.2.

Migrated from Impromptu Reports to cognos 8.2

Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.

Created HR Reports based on Employee details, Leavers, Budget vs. Forecast reports etc.

Implemented security in reports according to employee groups and roles according to the requirement.

Migrated Impromptu reports to Report Net using migratetocrn command and deployed migrated reports to Report Net using deploytocrn command.

Involved in creating security and deployment (exports and imports).

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.

Created Repeater reports based on human resource data.

Developed Portlets and dashboards reports according to the user requirements.

Created Region Cubes Using IQD’s which were built in Frame work Manager.

Responsible in burstingReport net depending upon different levels of administration.

Tuned cube builds, Impromptu Reports and servers for better performance.

Environment :Cognos BI 8.1, Framework Manager, Cognos ReportNet1.1 MR1, Framework Manager, Report Studio, Query Studio, EP 7 Series, Impromptu v7.0, Power Play Transformer, Impromptu Web Reports, MS SQL Server 2000, HTML, SQL, Windows NT. Configuration Manager, Content Manager, Windows 2000, UNIX.

Client: British Petroleum - Utilities /Bangalore Mar 2006 – Feb 2007

Role: DWH/Data Modeler/Cognos Developer

Project : CS DWH Phase 2 Reporting

Enterprise Data warehouse is one of the largest data warehouse projects in the world presently. BP CS team requires understanding the existing BO reports and migrate them to the Cognos Reports for CSDWH Phase2 Reporting solution.

Responsibilities:

Preparing functional design document, requirement document and technical design document.

Understanding the functionality & business rules.

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

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

Developed the List, Crosstab, and Chart reports using Report Studio.

Provided the reconciliation reports between Source data Vs BO reports Data Vs Cognos reports

Environment: Cognos Impromptu, IWR, Oracle 8.0, Windows 2000

Education:

Master of Computer Applications (MCA) (2002-2005), Osmania University,India.

Contact this candidate