Srikanth Cognos.doc - Yimg

Document Sample
Srikanth Cognos.doc - Yimg Powered By Docstoc
					                                          Srikanth Bondada
Email: kanth.srikanthcognos.sri2@gmail.com                               Mobile: 703.722.3054


Summary

           Over 8 years of IT experience in the Business Requirements Analysis, Application Design,
            Data Modeling, Development, Implementations and Testing of Data warehousing and
            Database business systems for various modules of Enterprise Risk Management, Financial,
            Pharmaceuticals, and Banking industries.

           Data warehousing experience in using COGNOS Decision Stream, and Data Manager
            exposure on Informatica and Data Stage.

           Expertise in COGNOS Report Net, Framework Manager, Decision Stream, Performance
            application.

           Expertise in Cognos process analysis, catalog design and Performance Analysis.

           Data modeling experience using Dimensional Data modeling, Star Schema / Snowflake
            modeling, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 4.x Highly
            skilled in planning, designing , developing and deploying Data warehouses/Data Marts with
            experience of both relational & multidimensional database design using Data Modeling tool.

           Worked with Different Databases like Oracle10g/9i, SQL Server 2000, DB2 and MS Access.

           Involved in the complete life cycle development process of data warehousing.

           Strong troubleshooting/production support skills and interaction abilities with end users.

           Excellent analytical and communication skills combined with technical knowledge and business
            acumen to deliver results.

Skill Set

Business Intelligence Tools
       Cognos 8.x/7.x, Actuate 7.0, Crystal Reports
COGNOS Tools
       Report Net 1.1(Query Studio, Report Studio, Framework Manager and SDK), Impromptu 7.x/6.x,
       Power play Transformer 7.x/6.x, Impromptu Web Reports (IWR) 7.1x/6.x, Access Manager,
       Architect, Metrics Manager, Transformation Server, Decision Stream, and Performance
       Application.
ETL Tools
      Decision Stream 7.x, Data Manager, Data Stage
Database System
      Oracle9i, 10g, SQL 2000, MS-Access., DB2

Data Modeling Tool
       Erwin 4.0, TOAD, SQL Analyzer
Operating System
       Windows NT/2000/XP, Linux
Programming Languages
       Visual Basic, SQL
Web Services
      IIS, Websphere6.0.
Hardware
      Intel PC, Sun, and Mac workstations.
Web Technology
      HTML, JavaScript, ASP.

Professional Experience


Consultant Engineer,
Open Pages. MA (Jun 08- Till Date)


      Worked closely with Internal Audit, Financial Control, and Operational Risk Management teams to
       understand the business requirements and to design complex reports.
      Worked on Financial Control management dashboards, charts reports which deliver the overview on
       the state of financial reporting and compliance.
      Created Dashboard Reports which provides overview on actionable reporting on current state of
       Risk.
      Created various Gantt Reports which enables organizations to plan, execute, report and review their
       audit universe.
      Created Custom framework models and Custom Query Subjects to support individual business
       requirements and to address the effectiveness of reports.
      Fine tune reports for better performance on large volumes of data.
      Supported various customers in various sectors. Includes Banking, Automobile, and Health Care
       organizations.
      Written customized SQL’s to meet the system requirements.
      Performed administration tasks configuring framework manager and report net
      Written custom test cases to validated reports against the requirements.

Environment
       Cognos 7.1, Report net 1.1, Framework Manager 1.1, Oracle 9i.

Programmer Analyst,
Tufts Health Plan. MA (Oct ’07- Jun’08)


      Designed BI Infrastructure (metadata business model, reporting and analytical objects) to address
       Service Request Management System and Change Management Systems.
      Conducting Technical review meetings for Service Desk Express Management System.
      Created Service Request, Change Management and Timesheet Reports for the Business users.
      Written customized SQL’s in framework manager for increasing the performance of the report.
      Created Views in Database server.
      Performed administration tasks configuring framework manager, reportnet, and applying Security for
       the reports.
      Migrated reports from Development to Production system.
      Validated reports against the tests cases.
      Configured Cognos Auditing to report Cognos usage.
      Designed and developed Dimensional Model in Framework Manager.


Environment
       Cognos 8.2, Report net 1.1, Framework Manager 1.1, MS-SQL 2000


Programmer Analyst,
Fortis Investments NJ (Feb’07 – Sep ‘07)


      Extracted data from multiple legacy system SQL, AS400, CSV Files, and MS Access Databases
       through application of refined Cognos decision stream modification and design techniques.
      Designed and implemented Data Warehouse solution using Cognos decision stream, i.e., gathering
       business user’s requirements, understanding the source OLTP system, designing the star-schemas
       and data marts, ETL, designing multi-dimensional models, building OLAP cubes, deploying the
       cubes, and render the data.
      Involved in migration, testing of Cognos decision stream catalogs from series 7 to Cognos 8
      Created Dimensions, Lookups, and reference dimensions to address the business needs.
      Managed metadata Models from multiple data sources in Framework Manager and published
       packages.
      Collect business requirements from the users and management to identify key dimensions and
       measures for business performance in process of building of building data warehouse.
      Designed models using framework manager published as packages to address the effectiveness of
       reports.
      Created List Reports, Group Reports and Cross Tab Reports in Report studio and Query studio.
      Significantly enhanced and successfully maintained a database management system comprised of
       MS Access Data Warehouse and MS Access Interface with switchboard and forms/reports/macros
       vital to facilitating access of 200+ team members.

Environment
      Cognos 7.x, Cognos 8.0, Decision Stream 7.0, Data Manger 8.0, Report net 1.1, Framework
Manager 1.1, Oracle 10g, DB2, and MS-Access 2003

Programmer Analyst,
Millennium, MA (Dec’07 - Feb’07)


      Designed both data infrastructure (data model, data acquisition, data transformation (business rules
       logic)) and BI Infrastructure (metadata business model, reporting and analytical objects) to address
       Call Activity.
      Created Dimensions, Lookups, and reference dimensions to address the business needs.
      Managed metadata Models from multiple data sources in Framework Manager and published
       packages.
      Extracted data into staging system from various sources.
      Scheduled jobs using Maestro in to extract data weekly.
      Build and deploy data extracts into different dimensional tables.
      Using Cognos ReportNet v1.1, build a simple single extract report to Excel.
      Perform a unit test on all work.


Environment
       Cognos 7.x, Decision Stream 7.0, Report net 1.1, Framework Manager, UNIX, Oracle 9i.


Programmer Analyst,
Comcast, MA (Sep’ 06 - Dec ‘06)


      Designed star-schemas to load date into data marts, designing multi-dimensional models, building
       OLAP cubes, deploying the cubes, and render the data.
      Strategically extracted/cleansed data from multiple data sources including SQL, Excel Spreadsheets,
       CSV Files, and MS Access Databases through application of refined Cognos decision stream
       modification and design techniques.
      Scheduled the builds to extract, transform and load data in to warehouse database using Cognos
       scheduler
      Generated Dimensions, Lookups, and reference dimensions to address the business needs
      Designed and implemented every stage in Framework Manager, Report Net i.e., gathering of
       requirements, model design, and generated reports according to the requirements.
      Designed models using framework manager published as packages that address the services and
       invoices.
      Created List Reports, Group Reports and Cross Tab Reports in Report studio and Query studio.
Environment
       Cognos 8.x, Data Manger8.0, Report net 8.0, Framework Manager 8.0, Oracle 9i, and IIS.

Programmer Analyst
Department of Public Health, MA (Feb 06 – Sep 06)


      Designed and implemented every stage in Framework Manager, Report Net i.e., gathering of
       requirements, model design, and generated reports according to the requirements.
      Designed models using framework manager published as packages that address the services and
       invoices.
      Worked closely with SME’s (Subject Matter Expert) in collecting business requirements documents
       from the users and management.
      Coordinated with database administrator in preparation of data mappings to identify key dimensions
       and measures for business performance.
      Coordinated with offshore development team as part of integration of reports using with web
       application.
      Created List Reports, Group Reports and Cross Tab Reports in Report studio and Query studio.
      Designed models using framework manager published as packages to address the effectiveness of
       reports.
      Written customized SQL’s in framework manager for increasing the performance of the report.
      Performed administration tasks configuring framework manager, reportnet, and applying Security for
       the reports.
      Validated reports against the tests cases provided by the subject matter experts.
      Maintained existing reports and updated them time-to-time with new requirements.

Environment
       Cognos 7.x, Report net 1.x, Framework Manager, Win 2000, Oracle 9i, IIS, and .Net 2.0


Lead/Developer
IBM (Panasonic, NJ) (Aug 05 –Feb 06)


      Designed and implemented Data Warehouse solution, i.e., gathering business user’s requirements,
       understanding the source OLTP system, designing the star-schemas and data marts, ETL, designing
       multi-dimensional models, building OLAP cubes, deploying the cubes, and render the data.
      Updated existing Data marts in the database with new enhancements.
      Worked with offshore team in India for transition and coordinate with the team to perform daily
       tasks.
      Involved in Installation, configuration and, migration process of reports from Power play,
       Impromptu to Cognos 8.
      Read and analyzed the data coming through various sources and various formats like different
       databases and flat files.
      Used Decision stream ETL tool to load data from different source systems like, Flat files into the
       Staging table and load the data into the target database, ORACLE
      Scheduled the sessions to extract, transform and load data in to warehouse database on Business
       requirements.
      Configured Financial and customer Analytic applications using Performance Application.
      Customized built-in reports provided by performance application to address sales, general ledger and
       Accounts receivables.
      Designed models using framework manager published as packages that address the effectiveness of
       corporate sales, analyze sales and profits in each area.
      Created List Reports, Group Reports and Cross Tab Reports in Report studio and Query studio.
      Collect business requirements from the users and management to identify key dimensions and
       measures for business performance.


Environment
       Report net 1.1, Framework Manager, Query Studio, Decision Stream 7.1, Performance Application
7.1x, Windows 2000, Oracle 9i, SAP3.1, Cognos 8, Websphere 6.0,Peoplesoft database.

Programmer Analyst
Intersections Inc. (Jan 04 –Aug 05)


      Generated complex reports according to the various business needs. Designed and developed various
       data models in close association with Data architects and DBA.
      Used several modules under Cognos to develop several user-friendly two-dimensional and multi-
       dimensional reports using Impromptu, Power Play, Report Studio and Query Studio.
      Extracted data from multiple legacy system SQL, CSV Files, and MS Access Databases through
       Cognos decision stream.
      Read and analyzed the data coming through various sources and various formats from different
       databases and flat files.
      Designed and developed new data models that helped a great deal in developing a powerful decision
       support system.
      Generated various data models according to the business needs using Frame work manager, these
       models are published as packages.
      Developing Standard Reports, Charts, and Master Detail Reports in Report Studio based on the
       Business Views.
      Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill down
       functionalities in impromptu.
      Configured report net 1.1 MR1 in windows web server.
      Built-in several features that not only decreased the redundant and resource-intensive maintenance
       functions both from the business user side and the data maintenance side.
      Designed various Power Play Transformer models to effectively create object hierarchy with
       efficient data concurrency and accessibility. This reduced the need to update multiple data models
       where change management was required.
      Performed administration tasks include user creation, providing user based access to reports, and
       catalogs.
      Involved in administration of Web reports and applying Security for the reports.
      Maintained existing reports and updated them time-to-time with new requirements.
      Built Metadata driven ETL modules using Cognos decision stream.
      Developed various transformations in extraction process of data from various source systems and
       loaded them to target database.
      Understanding of Business requirement and Build Application integration Suite of ETL, Data
       warehouse and Data marts.
Environment
     Reportnet 1.1, Framework Manager, Query Studio, Decision stream, COGNOS Connection,
COGNOS Impromptu 7.x, Impromptu Web Reports (IWR) 7.1x, Windows 2000 server, Oracle 8i,IIS.

Cognos Developer
Dynex Capital Inc, (Oct 02 – Dec 03)


      Created Cubes using Power play Transformer for multidimensional reports.
      Performed administration tasks include user creation, providing user based access to reports, and
       catalogs.
      Build catalogs for different users keeping the security aspect in view including the master catalogs
       for different departments.
      Maintained existing cognos reports, and updating with new additions to the existing reports.
      Interaction with management to identify key dimensions and measures for business performance.
      Redesigned reports using cognos impromptu with client requirements.
      Enhance performance by Optimization of cubes by choosing appropriate measures and dimensions.
      Performed data modeling for fact and dimension tables.
      Wrote Stored Procedures and PL SQL to Extract Transform and Load data from transaction
       systems into the Data warehouse environment.
      Participated in business analysis, ETL requirements gathering, physical and logical modeling and
       Created Fact and Dimensional tables using Erwin.


Environment
        COGNOS EP Series 7 Impromptu, IWR, COGNOS Power Play 7.x, Report                Administration,
Oracle 9i, DB2, Windows 2000.

Software Engineer
Gencor Pacific Inc, (Jul 01 – Sep 02)


      Developed new data models that helped in developing a powerful decision support system.
      Analyzed the data coming through various sources and various formats like different databases and
       also flat files.
      Redesigned reports using cognos impromptu with client requirements.
      Performed data modeling for fact and dimension tables.
      Created the database for data warehouse tables using Erwin for both logical and physical entities
      Involved in designing and analyzing the data warehouse using Reverse engineering and Forward
       engineering methodology in ERWIN Star schemas and the respective dimension tables were
       designed and generated.
      Produced logical and physical data models and metadata mgt for Oracle 8i.


Environment
       Oracle 8i, Cognos EP series 6.0 Impromptu, UNIX 7.0, ERWIM 4.0.


Software Engineer (May 00 – Jun 01)
IRMAC Systems Inc.


      Created various functions, stored procedures, and materialized views to optimize database
       performance.
      Involved in developing user interfaces (forms and page flows) for the application.
      Interacted directly with various clients as a part of the team involved in requirements collection and
       analysis, this included understanding the features expected by the clients and also educating them
       about the abilities and limitations of the developer community
      Evaluated software development tools intended to create reporting applications, and provided
       knowledgeable feedback to the management, which would influence software purchase decisions.
      Carried out application maintenance as per customer requirements, which involved altering of
       existing reports and addition of new ones.


Environment
       Oracle 8i, Visual Studio 6.0, Crystal Reports 8.0, Windows NT 4.0

Education
      B.E, Computer Science, University Of Madras, India.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:38
posted:7/14/2011
language:English
pages:7