PROFESSIONAL SUMMARY:

• 9+ years of experience in providing services in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Over 7 years of experience in handling Data Warehousing and Business Intelligence (BI) Tools like Cognos 10.2, 10.1.1, 8BI( 8.1.1, 8.2. 8.3,8.4) Suite, Cognos ReportNet, Framework Manager, SDK, Impromptu, PowerPlay, Transformer, PowerPlay Enterprise Server, Impromptu Report Administrator, Impromptu Web Reports (IWR), Access Manager, Active Directory, Sun Directory with knowledge of programming techniques in administering Oracle and SQL Server Databases and ETL tools like Oracle warehouse builder (OWB), Informatica and DataStage, Erwin .
• Extensive hands on experience in developing Data Warehousing/BI applications using Cognos BI, ETL tools with strong business understanding of Finance, Banking, Retail, Insurance and Health Care domain.
• Provide overall administration, configuration, security, and maintenance for the Cognos environment. Monitor system utilization and performance, troubleshoot and contact IBM support when problems arise, plan and test for system patches or upgrades, and offer new ideas for improvements
• As a Business Intelligence Analyst I was involved in various business operations and helped the organization to achieve cost - effective production with increased quality, efficiency and satisfied customer service. Involved in documenting the business process by identifying the requirements. Due to my wide knowledge in Business Intelligence, I had to support the application, created and delivered training programs and solve problems including troubleshooting of operational/data issues.
• Prepare weekly project status reports and keep management informed of project status and related issues.
• Responsible for remote support services for internal and external clients in order to increase productivity, reducing travel expenses and system downtime.
• Analyzed, incorporated new business rules to Oracle packages ETL process to support changes as required by the business.
• Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
• Have expertise in Business Requirement Analysis, Analytical Reports using OLAP Tools.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Good experience in Creating, Testing and deploying SSIS Packages.
• Excellent skills in High Level Design of and implementing ETL packages using SSIS 2008/2005 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Experience with ETL framework standards including error processing, validation and data reconciliation.
• Experience in Designing and Building the Dimensions and cubes with star schema using SSAS 2008/2005.
• Ability to transform functional requirements into reports.
• Knowledge in Installation of the Cognos 8, ReportNet Server and setting Security.
• Expertise in supporting and developing Report Template Library.
• Expertise in designing DMR and Relational models using star and snowflake schema.
• Have good experience in Developing Secured Models in Framework Manager and Publishing Secured Packages on to the Cognos Connection.
• Expertise in Cognos 8 Query Studio, Report Studio, Analysis Studio, Metric Studio, Cognos Connection and Framework Manager.
• Expertise in performance tuning on Report Level and Database Level.
• Expertise in performance tuning of Cognos Cubes.
• Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multi Dimensional Cubes.
• Expertise in developing Dashboards and Score cards using Cognos 8 BI Suite.
• Generated List Reports, Cross Tab Reports, Charts and drill through reports in Cognos Impromptu, ReportNet and Cognos 8 BI.
• Involved in Extraction, Transformation, and Loading (ETL) Solutions using SQL server integration services (SSIS) and developing reports using SSRS and SSAS.
• Expertise in using Parameter maps, Macros and setting Governors on Framework Manager.
• Expertise in developing Cognos portal pages for Dashboards on Cognos Connection.
• Customized data by adding, Filters Prompts Calculations, Summaries and Functions.
• Implemented security on Package and Report Level.
• Scheduled the reports and performed report bursting.
• Created new jobs in Cognos Connection for scheduling a group of reports.
• Expertise in deploying the reports from development server to Testing and Testing to Production environment using Content Administration.
• Experience in training the user on Query Studio, Report Studio and Cognos Connection.
• Involved in testing and exploring tools using Query Studio, Report Studio and Cognos Connection.
• Good experience in Migrating Cognos Catalogs, Architect Models and Reports to ReportNet
• Developed Reports Using Crystal Reports 9.0 and SAP BW.
• Manager using SAP Info cubes as sources with various security features and published packages to Cognos Connection Portal.
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros) using SAP Info cubes and Power cubes.
• Performance tuning of Queries (SAP BW Net weaver BEX and Cognos) by maintaining Aggregates, Compression of info cubes and use of statistics for the same.
• Experience in developing reports for retail data acquisition analysis, sales analysis from Bex Queries using OLAP functions (MDX Scripting).
• Created complex sales and retail reports to show the trend analysis of growth of the company.
• Working on large data mart with complex Business Intelligence Reports using Cognos Report studio and Analysis Studio.
• Gathered requirements for automated system to track/control expenses and relate them to cost centers using SAP and COGNOS for development of new analytical models to assess opportunities and strategic plans based on results
• Ability to convert Crystal Reports to Cognos Reports.
• Have good knowledge in Full Life Cycle Development of a Data warehousing project.
• Extensive experience in writing PL/SQL Stored procedures, Views, Triggers, and Packages using Oracle and SQL Server Databases.
• Participated in system integration, performance and user acceptance testing for systems.
• Provided Production support by checking the integrity of the reports in the production support.
• Good team player and have good understanding and ability of business problems.

TECHNICAL EXPERTISE:

BI Tools: SSRS, SSIS, SQL Server 2005/2008,2000, Cognos Tm1 9.5.1((Architect, Contributor, Perspectives, TurboIntegrator)SAP BO 3.Xi, Universe, Designer, WEBI, Life Cycle Manager, MS BI SSAS, SSRS,, Cognos 10.2.1, 8 BI Suite, Cognos ReportNet1.1, 1.1 MR2, 1.1 MR3,FrameworkManager, SDK, Impromptu6.x/7.x, PowerPlay6.x/7.x, Impromptu web reports 6.x/7.x, OLAP and PowerPlay Transformer, PowerPlay Enterprise Server, Access Manager, Upfront, Scheduler, Cognos Scripting.

RDBMS: MS SQL Server, Oracle 7.x, 9i, 10g,11i MS Access, DB2 UDB 8.1, 8.2.

Database Tools: Toad 8.5,9.0,9.7.2

ETL Tools: Oracle warehouse Builder 9.1.X, Informatica7.1.X,Cognos Decision Stream 7.0,Cognos Data managerData Stage, Erwin, SAP BW 7.0.

Testing Tool: Test Director 7.x/8.0, Quick Test Pro 8.2, Quality Center 9.0

Languages: SQL, PL/SQL, C, C++, Java.

GUI: Visual Basic 6.0 .

Web Server: IIS 5.x/6.0, Java Web Server, Netscape Directory Server,Web Server, Tomcat 4.01.

Web Technology: HTML, DHTML, XML, Java Script

Operating Systems: Windows 95/98/NT/XP/2000, UNIX (IBM AIX)

Other Tools: Deployment Tool & Migration Utility (Impcat2xml)

PROFESSIONAL EXPERIENCE

Confidential, Stamford

Sr. BI Datawarehose Reporting Analyst

Responsibilities:

• Prepared Migration Document for Sap BO Xi to Cognos 10.2.
• Analyze financial data, compiles reports and prepares recommendations.
• Interacting with Business Users for gathering Business Requirements to develop the reports.
• Develop Business Objects Reporting and Dashboard
• Meet with decision makers, systems owners, and end users to define business requirements and systems goals, Identifying, and resolving business systems issues.
• Created a planning system with the unit managers to streamline the external auditing process which resulted in a 50% reduction in the time needed to produce the final audit statement.
• packag
• Responsible to maintain all the documentation for Cognos reports and create ad hoc queries extracting information from the datamart.
• Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals •
• Prepared the data mapping document for Cognos from data dictionary.
• Analyzed and Prepared the Pros and Cons of SAP BPC and Cognos TM1.
• As a, Team Leader, implementing Cognos application and managing all process and activities at client end, analyzing user's requirements, developing test schedules, reviewing testing plans, tracking and documenting the development and results of these plans, and maintaining tables used in departmental databases.
• Analyzed the existing BO universe and provided the gudelines to migrate and implementation effect of Cognos.
• Work with informatica developers, once they pull the data through ETL process to build cognos reports.
• Working on internal “BIG DATA” project to build the reports using Workspace, Report Studio.
• Developed standard reports, Ad hoc reports, jobs, events, Dashboard, based on requirements.
• Authoring reports in report studio according to requirement by implementing many features like prompts, Conditional Formatting.
• Build package with 32 tables and one fact ( posting table) to walk through the business users.

Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer), SAP BO 3.X, Universe Designer, Hadoop, MapReduce, HDFS, Pig, Hive, HBase, ZooKeeper, Oozie, Java (jdk1.6), Oracle 11g/10g, PL/SQL, SQL*PLUS, Windows NT, UNIX Shell Scripting

Confidential Orangeburg NY

Sr BI Reporting Developer

Responsibilities:

• Created and updated Materialized View for one of the dashboard.
• Prompt reslovement of the Production issues in due time.
• Developed standard reports, Ad hoc reports, jobs, events, Dashboard, based on requirements.
• Implementing a Business Intelligence (BI) program to improve scorecard, dashboard and analysis capabilities.
• Interact with customer as needed to better define and understand reporting requirements.
• Working directly with the business to plan and implement reporting solutions.
• Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
• Assisted in the troubleshooting of several VZW ( Confidential Wirless) systems problems and successfully corrected them.
• Authoring reports in report studio according to requirement by implementing many features like prompts, Conditional Formatting.
• Used TM1 rules editor to create and edit rule to create various calculatio
• Utilized best in class Cognos OLAP technology to design financial solutions
• Prompt reslovement of the Production issues in due time.
• Developed budgeting and forecasting cubes and designed standard operating manuals
• Designed and maintained TM1 hierarchical cubes and security procedures.
• Maintenance of TM1 users, roles, and security
• Developed standard reports, Ad hoc reports, jobs, events, Dashboard, based on requirements.
• Used Replication to copy the Cubes from one server to other server
• aImport the data from ODBC and Text files using TM1 Turbo integrator.
• Manage TM1 data through TM1 Reports (Active Form & Slice)
• Created Boolean variables and String variables for blocking charts.
• Redesigning and creating new reports according to the user requirements.
• created joins between huge tables to map the columns from multiple tables.
• Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like Oracle Client
• Extensive usage of SQl Queries for data Analysis.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Involved in review sessions and demos with business users and draft design/solution
• Maintain the repositories for different environments like DEV, QA and PROD
• Regularly synchronized the QA, DEV environments with Production reports.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Hosted Weekly status meetings to update and explain the work expected from them in coming week as well as get status on work completed to Cognos developers.
• Responsible to support the issues with reports on the Cognos enterprise environments ( Development, UAT, Test and Production )
• Responsible to Sign-Off on the crystal enterprise and Ad-Hoc application after the release.
• Responsible to trouble shoot problems incurred on parameter tool communication to Enterprise System. Cognos 10.2 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Cognos Enterprise Planning 8.2(Analyst, contributor),MS Excel, JavaScript, Oracle Warehouse builder 11.2 (OWB)PL/SQL, Java, XML, Tomcat, TM1 9.5,Turbo Integrator, Architecht,

Oracle 11iV2, Toad 9.7.2, Oracle Ware house builder,UNIX, Quick Test Pro, Clear case, Windows 2000/XP,MSOffice/Excel/Visio.

Confidential, Montvale NJ

Tech Lead Cognos/ SAP BO Report Developer

Responsibilities:

• Involved in analysis, design and gathering of requirements for project.
• Designed TSD and data mapping documents.
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers
• Configure Business Objects XI to work in Firewalls, Enable the port(s) needed like 6400, 6401 etc for Business Objects Enterprise Rel II
• Developed various Reports to test the newly added objects in the universe and created regression reports for all the modified universes using Business Objects XI 3.
• Worked on Administration of BOXIR2 and BOXI CMC Security setup.
• Involved in Creating Repository, Creating Users and User Groups.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• Prepared Technical Specification document and Business requirement document.
• Involved in the Change control for the approvals.
• Created Projects, Models (layers, relations, cardinality, Query subjects, star schema and packages) and Published Packages using Framework manager.
• Created Metadata Modeling by using multiple data sources in Cognos 8 BI Modeling.
• Extracted data from sharepoint as datasource.
• Created and maintained issur tracking and Change control documents.
• Used Report Studio to create standard reports and complex reports with drill through, master detail relationships, cascading prompt, complex layout, conditional formatting, and user interactions. Created Calculations, Prompts and conditions in Reports.
• Install, Maintain and Trouble shoot the Business Objects Enterprise Servers
• Configure Business Objects XI to work in Firewalls, Enable the port(s) needed like 6400, 6401 etc for Business Objects Enterprise Rel II
• Design and Recommend changes to Datawarehouse schema’s like Star and Snow Flake designes at Active Health.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Created web reports through report template in Web Application Designer.
• Converted business requirements in business/technical requirement documents.
• Designed web intelligence reports for dimensional hierarchical data
• Developed standard reports, Ad hoc reports, jobs, events, Dashboards, and portals based on requirements.
• Queries and Stored Procedures, improved the performance of the reports.
• Used Informatica Source Analyzer, Mapping Designer, Mapplet Designer and Target Designer for Extraction, Transformation and Loading data.
• Created mappings to populate the dimension tables and the fact tables.
• Implemented SCD type I & type II for different dimensions.
• Extensively used Informatica power center and created mappings using transformations and flagging the record using update strategy for populating the desired slowly changing dimension tables.
• Created complex mappings using unconnected lookup, Aggregate and Router transformations for populating target table in efficient manner.
• Sequence Generator procedure is re-used for generating surrogate keys for different dimensions and facts.
• Involved in Unit Testing, Integration Testing and System Testing .
• Involved in converting IBM DB2 to Teradata.
• Extensively worked on Teradata SQL, created joins between huge tables to map the columns from multiple tables.
• Involved in all phases of migration from Cognos 10 to XI R2.
• Involved in review sessions and demos with business users and draft design/solution.
• Deployment of reports, packages and cubes .

SAP B) 3.XI, Cognos 10.1.1 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer) Informatica Power center 8.6, Teradata V13, Oracle11g, Flat files, Windows xp, Unix, Subversion Business Objects XI R2, 3.1, Crystal Xcelsius, Windows 2003,SAP 4.7, ECC 6Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Virtual Visual Studio, Power Broker 5.00,3.11 Excel, JavaScript, PL/SQL, Java, XML, Tomcat, sharepoint 2010

Confidential, Hartford CT

Sr Cognos Developer ( Tech Lead)

Responsibilities:

• Involved in Understanding existing Business Models and Customer requirements by in the Designing Phase meetings with users.
• participating Analyzing vendor renewals and plan experience and estimate future plan costs.
• Performing basic cost projections using client cost and enrollment data.
• Assisting in the development of customized pricing and valuation model
• Authoring reports in report studio according to requirement by implementing many features like prompts, Conditional Formatting.
• Created Boolean variables and String variables for blocking charts.
• Redesigning and creating new reports according to the user requirements.
• Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Used Framework Manager to Build Models (layers, Cardinality, Relationships, Query subjects), Packages and publish packages to cognos connection. Defining appropriate relationships between query subjects in Framework manager.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Created complex reports like LMA Summary Reports which was all about the daily transactions amount and total amount, process date, transaction codes, etc. used join and union for creating queries.
• Bursting Reports and Multilingual Reports based on groups of users & Preferences for our Asian and European partners.
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
• Led team meetings, providing status and defining go-forward approach based on achievable results.
• Extensively worked on Teradata SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Creating workflows and batches for the load and scheduling the same.
• Extensively used Informatica power center and created mappings using transformations and flagging the record using update strategy for populating the desired slowly changing dimension tables.
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.
• Extensively worked on Teradata SQL, created joins between huge tables to map the columns from multiple tables.
• Involved in review sessions and demos with business users and draft design/solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• A reusable mapplet is created for loading session details into the Data mart tables.
• Involved in design and development of joins, filters, calculations and conditional variables in Packages within Framework Manager.
• Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like Teradata Client
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.

Cognos 10.1.1 (Framework Manager, Report Studio, Query Studio, Metric Studio, Workspace, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Cognos Enterprise Planning 8.2(Analyst, contributor),MS Excel, JavaScript, PL/SQL, Java, XML, TomcatTeradata 13.10, Quick Test Pro, Clear case, Windows 2000/XP,MSOffice/Excel/VisioInformatica Power center 8.6.1, Oracle10g, Flat filesBoerhringer Ingelheim

Confidential, Ridgefield CT

Sr. Cognos BI developer

Responsibilities:

• Involved in Understanding existing Business Models and Customer requirements by participating in the Designing Phase meetings with users.
• Authoring reports in report studio according to requirement by implementing many features like prompts, Conditional Formatting.
• Created Boolean variables and String variables for blocking charts.
• Redesigning and creating new reports according to the user requirements.
• Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Used Framework Manager to Build Models (layers, Cardinality, Relationships, Query subjects), Packages and publish packages to cognos connection. Defining appropriate relationships between query subjects in Framework manager.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Created complex reports like Spend Apportion detail report which was all about the daily transactions amount and total amount, process date, transaction codes, etc. used join and union for creating queries.
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
• Led team meetings, providing status and defining go-forward approach based on achievable results.
• Extensively worked on Oracle SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.
• Extensively worked on Oracle SQL, created joins between huge tables to map the columns from multiple tables.
• Involved in review sessions and demos with business users and draft design/solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Involved in design and development of joins, filters, calculations and conditional variables in Packages within Framework Manager.
• Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like TOAD and SQL* Plus
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Cognos Enterprise Planning 8.2(Analyst, contributor),MS Excel, JavaScript, PL/SQL, Java, XML, TomcatOracle 10gV2, Toad 9.7.2, Clear Case, Quality Centre,Informatica,UNIX, Quick Test Pro, Clear case, Windows 2000/XP,MSOffice/Excel/Visio.

Confidential, Burbank, CA

Cognos Lead Developer

Responsibilities:

• Involved in gathering the functional requirements for financial budgeting, forecasting and
• Deployment of reports, packages and cubes .
• Involved in adding business rules by defining different kinds of calculations and filter.
• Authoring reports in report studio according to requirement by implementing many features like prompts, Conditional Formatting.
• Created Boolean variables and String variables for blocking charts.
• Redesigning and creating new reports according to the user requirements.
• Created the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal
• Migrated Cognos 8.3 reports to Cognos 10.1.1
• Created new page in the cognos connection and embedded the different Portlets, reports in the same page.
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Writing the Java Script in Report Studio Reports to display default values in value prompt.
• Extensively worked on call support by coordinating with offshore,
• Trained power users to use Query Studio for Ad-Hoc reporting.
• Led team meetings, providing status and defining go-forward approach based on achievable results.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Created custom portals based on metrics and custom reports on Metric Packets.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Involved in review sessions and demos with business users and draft design/solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.

Environment: Cognos 10.1, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Cognos Enterprise Planning 8.2(Analyst, contributor),MS Excel, JavaScript, PL/SQL, Java, XML, TomcatDB2 9.1, Toad 9.7.2, UNIX, Quick Test Pro, Clear case, Windows 2000/XP,MSOffice/Excel/Visio.

Confidential, Tampa, F

Cognos Lead Analyst/ Developer

Responsibilities:

• Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Installation and Configuration of Cognos BI Server and PowerPlay Transformer on Windows Sandbox at Business Edge Solutions.
• Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
• Extensively worked in developing Cubes in Cognos Transformer 8 using Cognos Report
• Created Alternate Drill-Down Path, Special Categories & Currency Conversion set up in Power Play to better suit different user groups.
• Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
• Led team meetings, providing status and defining go-forward approach based on achievable results.
• Extensively worked on Oracle SQL, created joins between huge tables to map the columns from multiple tables.
• Worked closely with the business users to build the models and delivered based on the sign-off
• Worked extensively using Hints to Achieve the Performance and Tuned SQL, PL/SQL Queries and Stored Procedures, improved the performance of the reports.
• Extensively worked on Oracle SQL, created joins between huge tables to map the columns from multiple tables.
• Involved in review sessions and demos with business users and draft design/solution
• Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
• Developed Architectural, Technical documents and Diagrams.
• Studio Report as the Data Source in the Transformer.
• Extensively worked on call support by coordinating with offshore,
• Trained power users to use Query Studio for Ad-Hoc reporting.
• Created pilot reports that introduced JavaScript through imbedded HTML tags.
• Utilized MS Office to my advantage by creating visualizations for reports from business requirements on Word, Excel, Visio, MS Project and utilized Cognos Go Office add-on to extract and present Cognos reports on Excel for executive meetings.

Environment: Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Transformer) Metric Studio, Metric Manager, Cognos Connection, Power-Play Transformer 7.3, Impromptu 7.3, Cognos Enterprise Planning 8.2(Analyst, contributor),MS Excel, JavaScript, PL/SQL, Java, XML, Tomcat Oracle 10gV2, Toad 9.7.2, Oracle Ware house builder,UNIX, Quick Test Pro, Clear case, Windows 2000/XP,MSOffice/Excel/Visio.

Confidential, Santa Barbara, CA

Sr. Cognos BI consultant

Responsibilities:

• Involved in Understanding existing Business Models and Customer requirements by participating in the Designing Phase meetings with users.
• Designed and implemented Cognos multi server environment with Disaster Recovery capability.
• Provided users with several Dashboards and Trend Analysis Graphs to help those balances decision and linked these as Drill through to detail reports.
• Involved in upgrading FM models and reports from cognos 8.3 to cognos 8.4.
• Extracted data using SSIS packages (ETL) to transfer data from different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text Format Data.
• Experience in database design, development, SQL performance tuning, creating views, functions, stored procedures, ETL process
• Developed Architectural, Technical documents and Diagrams.
• Provided users with several Trend Analysis Graphs by applying strategic performance management models (SPM) to help them make balanced decisions and linked these as Drill downs from the Dashboards.
• Created List, Crosstab, Chart, Repeater reports using Report Studio & Ad-hoc reports using Query Studio
• Create and maintain documentation on data warehouse and business intelligence reporting system including data models, ETL source to target mappings and report design.
• Installed and Configured Cognos 8.3, Cognos tools, web server, and directory server and configured together for cold standby project
• Used Data Manager Designer to acquire data from source database with set of processing rules.
• Used Data movement Service which is in Data Manager to run and schedule builds and job streams on remote computers using Cognos Connection
• Provided administrative support to issues related Cognos server administration, performances.
• Developed models from SQL Server warehouse and performed tuning using T-SQL which contained summarized, detailed current and historical data from ERP transactional database.
• Involved in developing reports Ad-hoc and standard reports using SSRS and SSAS.
• Experience in Scheduling and Bursting reports.
• Used Cognos Metric Designer to populate the application by transferring information from relational and dimensional data sources.
• Used Metric Studio score cards extensively to track the Finance and sales Metrics such as revenue, margin and customer growth.
• Trained power users to use Query Studio for Ad-Hoc reporting.
• Developed the mapping specifications from informix the business requirements and the data model.
• Created packages and Set up the security at the package level, query subject level and the query item level and created New Groups and Roles.
• Involved in Step-by-Step Documentation of training material and Training of end users on Query Studio and Analysis Studio for Reporting.

Environment: Cognos 8.3,Cognos8.4 (Framework Manager, Report Studio, Query Studio) Cognos Connection, Cognos Planning, 8.1MS SQL Server 2005, MS Active Directory, Cognos Data Manager 8.2, DB2 UDBv 8.2,) Windows 2000/XP, Cognos Go Office, MS EXCEL 2007Office/Excel/Visio,Test Director SQL Server2005/2008(SSIS, SSAS, SSRS), TOAD, Windows XP

Confidential, Stamford, CT

Cognos Developer/Administrator

Responsibilities:

• Migrated existing Cognos series 7 applications to Cognos ReportNet 1.1.
• Migrated existing Cognos 8.3 to Cognos 10.1.1.
• Interacted with Management and Development teams to gather Business requirements for new models.
• Involved in Relational and Star schema database design and loading data.
• Migrated Impromptu Web Reports (IWR) to Cognos ReportNet 1.1.
• Integrated Cognos Series 7 Security to ReportNet.
• Integrated Cognos Upfront News-boxes and News-Items in Cognos Connection.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Created metadata models, made appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Maintained Security in Cognos Connection by controlling privileges for users, groups and roles.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Involved in design and development of joins, filters, calculations and conditional variables in Packages within Framework Manager.
• Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like TOAD and SQL* Plus
• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Created and Modified Catalogs for different applications by using Impromptu Administrator.
• Developed Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports and published them onto Cognos Connection.
• Created multi-dimensional cubes using Power Play Transformer and deployed the same along with reports using PowerPlay Enterprise Server.
• Created Calculated Measures in Transformer.
• Maintained Dimension level Security for Cubes in Power Play Transformer.
• Implemented Centralized Security in Access Manager.
• Created Users, User Classes and Database Sign-ons in Access Manager.
• Performed Pivoting, Drill-down, Slice & Dice and Filtering operations done for all OLAP applications.
• Extensive experience in Exceptional highlighting, sorting and Ranking.
• Performance tuning power-cubes to reduce Query time and Partitioned Cubes.
• Optimizing by assigning Relative Weights to the Tables in the Catalog for Query Performance.
• Helped developers rewrite many of their slow running stored procedures. Worked with developers in reducing lock contention by streamlining the order in which various tables were accessed. Involved in the effort to reduce long running and log intensive transactions, and to remove user interaction within transactions.
• Developed standard Templates for various kinds of reports.
• Involved in Scheduling reports using Cognos Scheduler.
• Trained end users on Query Studio for Ad-hoc reporting as well as involved in the Documentation.
• Designed and developed various SSIS packages (ETL) to extract and transform data and Scheduled SSIS Packages
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal process
• Created ETL metadata reports using SSRS, reports including like execution times for the SSIS packages, Failure reports with error description
• Developed an automated report subscription process using SSRS
• Applied conditional formatting in SSRS to highlight key areas in the report dataUsed Report Builder to do Ad-hoc Reporting
• Created report links to refer other reports in a particular report
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis
• I have also imported and exported data into MS Access databases and debugged VBA scripts linked to said databases
• Created multiple hierarchical aggregates for faster performance
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical database Design using Erwin tool
• Created database objects like tables, users, roles, stored procedures, triggers
• Solved issues by doing data recovery in existing database
• Used various formatting techniques like interactive sorting, grouping to create user friendly reports

Environment: Query Analyzer, DTS, BCP, SQL Profiler Cognos Reportnet1.1, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Impromptu Administrator 7.1/7.3, Architect 7.1/7.3, Powerplay Enterprise Server 7.1/7.3, Impromptu Web Reports 7.1/7.3, Powerplay Transformer 7.1/7.3, Cognos Scheduler, Cognos Query 7.1/7.3, Cognos Upfront 7.1/7.3, Access Manager, Configuration Manager, Microsoft IIS, Erwin 3.5,Oracle 8i/9i, PL/SQL, SQL Server 2000, Clear Quest 7.1.0,TOAD 8.0, HTML, MS-Access, MS- Excel, Unix, Windows 2K.

Confidential, Ontario, CA

Cognos Developer

Responsibilities:

• Gathering Business Process Requirements from business users, for the reports to be developed
• Developing a technical spec by analyzing the business from the gathered BPR.
• Ability to transform functional requirements into reports.
• Developing and publishing DMR model packages onto Cognos connection.
• Training users to use the Cognos connection to access their corresponding reports and cubes.
• Developed various reports, and they include, simple lists, cross tabs, charts, complex reports with tables in them, conditional block, static choices in prompt, bursting etc.
• Extensively used TOAD to query data, to validate reports and to write views for some reports.
• Running various data stage jobs to update the database.
• Used decision stream Designer to acquire data from source database with set of processing rules.
• Used Data movement Service which is in decision stream to run and schedule builds and job streams on remote computers using Cognos Connection
• Expertise in handling Administration tasks like bursting reports to stores and force printing them to stores, scheduling the reports by creating new jobs.
• Expertise in Customizing Cognos connection and experience with Portal Layout.
• Installing and configuring of Cognos 8BI and Sun one directory Server.
• Expertise in Developing Ad hoc Reports using QueryStudio.
• Used ReportStudio to develop the Dashboards.
• Used SDK to customize and automate various Tasks.
• Used Event studio to set the targets and sending the Appreciation mails to the Managers.
• Used Metric Studio to develop the scorecards.
• Experience with OLTP data where the transaction system databases are live and actively changing when the reports are going to run against them.
• Updating PowerPlay cubes and reports on Cognos connection and updates them daily using scripts and batch files, after the database gets updated.
• Tested the Metadata model and relationships in Framework Manager.
• Changed the properties of the report by modifying the XML code of the report.
• Created views and tables in oracle database as a requirement for some Cognos reports.
• Provided administrative support and Development support for production issues.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Good at modifying shell scripts for updating tables in the database.

Environment: Cognos 7.1 BI Suite (Frame work Manager, Cognos Connection, ReportStudio, QueryStudio, Analysis Studio, Metric Studio and Event Studio), Reportnet1.1,Transformer, PowerPlay Enterprise Server, SDK, SQL Server, Oracle 9i, DB2 UDB 8.1, Cognos Decision Stream, TOAD 8.5.3.2, Datastage, AIX - Unix, XML, HTML,JavaScript, DataStage.

Confidential

Cognos Developer

Responsibilities:

• Analyzed & defined customer requirements/ specifications and offered solutions to fit the customer’s need.
• Use Cognos Impromptu to create Catalog files, create IMR/IQD and Cubes using Cognos 7 EP Series, Impromptu and Transformer. Schedule the cubes.
• Applied appropriate client/database server balancing for the reports.
• Created User Classes that reflects the business hierarchy and provided security.
• Designed Catalogs, Reports and IQD’s using Impromptu Administrator.
• Created standard filters, calculation, prompts, and conditions.
• Published reports to the upfront web portal to provide accessibility to the staff.
• Created cascading prompts in Impromptu reports to help users refine their search.
• Created Drill-Through reports to provide users with more detailed information.
• Created List Reports, Crosstab Reports and Drill through Reports.
• Published Impromptu Web Reports .