Summary

• 9.6 years of experience in Software Engineering experience with good Data Analytical capabilities and strong expertise Data warehouse and Business Intelligence technologies.
• Extensive experience in BI Modeling/Report Authoring using Cognos10.1 8X suite Framework Manager, Report studio, Query Studio, Analysis Studio, Event Studio, Business Insight/ Business Insight advanced , Cognos ReportNet1.1 MR1, Cognos EP series 7.1,7.2, Impromptu Administrator, Impromptu Web Reports IWR , Power Play, Transformer, Access Manager.
• Expert in Design, develop and maintain the Relational and Dimensionally Modeled Relational DMR metadata-model using Framework Manager
• Created cognos reports and automated administration tasks using Cognos SDK.
• Expertise in Cognos Migration from Cognos 8.4 to Cognos 10.1
• Expertise in migration of user/groups from Cognos Access Manager to Active Directory
• Designed and developed OLAP Cubes and created reports from the cube.
• Deployed Models, Cubes and reports from Staging to Production and administered users/ groups/roles.
• Automated the deployment process, User authentication process using Cognos SDK.
• Designed and developed customized Cognos reports for the client: Impromptu, Power Play Cube, Ad-hoc and Cognos queries using Cognos 8.4 10.1 reporting platform.
• Lead the development of reporting functionality using Impromptu and Ad-hoc reports to meet client requirements
• Hands on Experience in creating advanced and professional reports like Dash Board,Templates, List, Cross-tab, Maps, Repeater tables, Charts, Complex Financial Reports and Conditional block lists using Report studio in Cognos 10.1/8x
• Strong knowledge on Installation Configuring the Cognos10.1/8x/7i tools in distributed Environments on windows/Unix
• Excellent knowledge on Data warehousing concepts - Star schema, Snow-flakeSchema and worked on both OLAP and OLTP databases.
• Developed SQL queries to Test the performance and functionality of new reports.
• Working experience with multiple database environments like Oracle 12c/11g/10g/9i/8i,SQL Server 2005/2000, PL/SQL,MS Access, DB2
• Worked independently with Business Analysts to gather the requirements.
• Experience in working with various Microsoft products like Visio, MS Project MS Project/MPP , Excel, Power point and Word.
• Good knowledge in Unix Shell Scripting, Java J2EE and PL/SQL Scripting.
• Strong skills in Testing Applications and writing the Test cases for the applications at various levels and good experience in Quality Assurance QA support.
• Interested in emerging technologies. Ability to quickly master in new concepts.
• Excellent communication and administration skills, analytic, multi-tasking and interpersonal skills.
• Possess excellent trouble shooting as well as problem solving skills.
• Excellent understanding of project issues, Ability to work independently and in teams.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Cognos Developer/Administrator

Responsibilities:

• Involved in meetings/sessions with users for requirement gathering.
• Prepared the System Specification document and Design documents.
• Designed Cognos Framework Manager Model with different views Database View, Business View, Presentation View using Oracle 12c/11g.
• Responsible for creating users, groups and roles to manage security.
• Designed and developed Cognos Power play cubes and Schedule transformer scripts to update Power play cubes depending on the data ware house load process.
• Implemented Relational Modeling in Framework Manager
• Migrated the Cognos Users, groups, roles from IBM Access Manager to Active Directory.
• Implemented security for Data access, Object level access and Package access in framework Manager.
• Created various different kinds of dash board reports like Dial reports, Bar Graph report
• Worked with business customers and suggested them various different kinds of reports and dashboards as per their requirements.
• Automated the deployment process and User Authentication process using Cognos SDK.
• Created Cognos reports and scheduled customized email notifications to users using Cognos SDK.
• Created custom templates and custom toolboxes for the use of reporting.
• Created the list, cross tab, repeater and drill-through reports and created the reports in different formats like PDF, XML, HTML and CSV.
• Created reports ranging from ad-hoc to complex reports using drill through, conditional formatting and cross tab reports
• Created and scheduled events using Event Studio for production error monitoring to provide the updates to the business users.
• Created jobs and scheduled burst reports using schedule management tool to run daily/weekly and monthly basis and sending reports and report links to users through email.
• Used Toad to test the queries.
• Trained end users in building Ad-hoc reports using Cognos Business Insight/Business Insight Advanced.
• Proactively modified the existing Metadata models Frame work packages to improve the performance of the reports.
• As part of Admin team, performed cognos upgrades from Cognos 8.4 to Cognos 10.1
• Performed data validation and unit testing of reports.
• Create data source connections in the Cognos connection to facilitate package and cube promotion process
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Deploy reports and cubes to development and production environments
• Administer the publishing of all approved Cognos reports and Cubes to Cognos connection

Environment: Cognos 10.1/8.4 Framework Manager, Report Studio and Query Studio, Business Insight/ Business Insight advanced , Cognos SDK, Java,J2EE, Eclipse, Erwin, TOAD, Oracle 12c/11g, Windows 7,Microsoft Visio, Microsoft Project MPP , Active Directory, Unix, Windows 2003/2008.

Confidential

Role: Sr. Cognos Developer/Designer

Responsibilities:

• Involved in meetings/sessions with users for requirement gathering.
• Prepared the System Specification document.
• Involved in the preparation of high level and low level design document.
• Designed Cognos Framework Manager Model with different views Database View, Business View, Presentation View using Oracle 10g.
• Responsible for creating users, groups and roles to manage security.
• Implemented Relational Modeling in Framework Manager
• Implemented security for Data access, Object level access and Package access in framework Manager.
• Designed and developed Power Play cubes and created drill thru reports using the power play cubes.
• Review and understand the application team work plan and to complete the admin tasks as per the time schedule.
• Created custom templates and custom toolboxes for the use of reporting.
• Created the list, cross tab, repeater and drill-through reports and created the reports in differentformats like PDF, XML, HTML and CSV.
• Created reports ranging from ad-hoc to complex reports using drill through, conditionalformatting and cross tab reports
• Created jobs and scheduled burst reports using schedule management tool to run daily/weekly andmonthly basis and sending reports and report links to users through email.
• Used Query Analyzer to test the queries.
• Trained end users in building Ad-hoc reports using Cognos Business Insight/Business Insight Advanced.
• Performed data validation and unit testing of reports.
• Create data source connections in the Cognos connection to facilitate package and cube promotion process
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Provided the risk contingency plans to Chrysler IT and Business and implemented those plans to bring back the project back on track.
• Deploy reports and cubes to development and production environments
• Administer the publishing of all approved Cognos reports and Cubes to Cognos connection

Environment: Cognos10.1 Framework Manager, Report Studio and Query Studio, Business Insight/ Business Insight advanced , Cognos TM1, TOAD, Oracle 11g, Windows 7,Microsoft Visio, Microsoft Project MPP , Unix.

Confidential

Role: Sr. Cognos Developer/Designer

Responsibilities:

• Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.
• Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.
• Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio.
• Successfully migrated several environments from Cognos Report Net to Cognos 8 and Cognos 8.4 to Cognos 10.1.
• Migrated reports from Business Objects to Cognos.
• Designed reports with Cascading Prompts, Filters, and Custom Calculations.
• Monitored data quality, resolving problem data issues, and ensuring timely updates
• Involved in deployments of Packages and Reports to different environments.
• Developed Master detail reports, Multi query and Multi page master reports as per BRD Business Requirement Document .
• Review and understand the application team work plan and to complete the admin tasks as per the time schedule.
• Developed the yearly, quarterly and monthly Power play cubes to analyze the financial performance of the dealers.
• Designed and developed reports against multiple data sources using Oracle, XML data, data warehouses and data marts as well.
• Worked in Framework Manager to create Models using different data sources, and publishing packages to Cognos connections for reporting requirements.
• Responsible for creating users, groups and roles to manage security.
• Deploy reports and cubes to development and production environments
• Administer the publishing of all approved Cognos reports and Cubes to Cognos connection
• Created multidimensional cubes using Impromptu's Query Definition in PowerPlay Transformer
• Created complex package reports using conditional blocking / conditional formatting / conditional layouts as per business requirements.
• Implemented Security filters at Package level, Object level, Data level to meet user needs.
• Analyzed and validated the report and performing data analysis by writing complex SQLs
• Coordination for Integration testing, UAT, UTC and smoke tests and resolving the support issues.
• Working with different client teams to support Reporting issues and enhancing the existing reports.
• Handled day to day adhoc requests and issues given by key users and resolved in time.
• Participated in deployments, production release.
• Responsible for development and automation of Client using IBM Cognos tool
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Provided the risk contingency plans to Chrysler IT and Business and implemented those plans to bring back the project back on track.

Environment: Cognos 8.4/8.0,Cognos 10.1, Framework Manager, Report Studio, Cognos TM1, Query Studio, Event Studio, Analysis Studio, Metric Studio, Cognos Power Play Transformer, Db2, Oracle 11g, Windows 7, Microsoft Visio, Microsoft Project MPP , Unix.

Confidential

Role: Sr. Cognos Developer/Designer

Responsibilities:

• Built models using Framework Manager and published the package.
• Accessed published package using Cognos Connection.
• Prepared Unit Test Cases and performed testing in the development environment.
• Reports were triggered by DB Stored Procedures.
• Created Query Subjects in Framework Manager as stored procedure source
• Analyzed existing Crystal reports and incorporate the calculation in the Framework Model.
• Initially the Framework Manager Query Subject was pointed to SQL Server2000 as database and all the reports have been developed. In final, the same Framework Manager is deployed to Oracle 9i and all the ReportNet reports made to run successfully on both the platform.
• Created drill-thru reports and cross-tab reports in Report Studio.
• Created Cognos reports using Dealer Web services using Cognos SDK.
• Involved in the design and development of CRN reports in Report Studio.
• Created complex reports with sub-queries and sub-sub-queries.
• Created reports that included ReportNet functionality such as prompt pages, cascading prompts, conditional filters etc.
• Used Query Analyzer to run the queries.
• Responsible for creating users, groups and roles to manage security
• The report was designed as a Master-Detail report as every manager could have several objectives, strategies and resources.
• Reports output have been designed to carter for both PDF and HTML formats.
• Tested the reports and migrated to UAT for the second level of testing.
• Deploy reports and cubes to development and production environments
• Administer the publishing of all approved Cognos reports and Cubes to Cognos connection
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Provided the risk contingency plans to Chrysler IT and Business and implemented those plans to bring back the project back on track.

Environment: Cognos8.4 Frame work Manager, Query Studio, Report Studio, Analysis Studio , Cognos SDK, Report Net 1.1MR2 ,Cognos TM1, Crystal Reports, Oracle 11g,SQL Server2000, Toad, Windows XP. Microsoft Project MPP , UNIX

Confidential

Role: Sr. Cognos Developer/Designer

Responsibilities:

• Worked with business users to gather business requirements and mapped into technical requirements for developing the BI reports.
• Created complex package reports using conditional blocking as per the business needs.
• Created Executive Dashboard to bring multiple reports together to show information in context.
• Responsible for creating separate models and packages as per the requirements and reporting needs.
• Administered the security for package, reports and created user groups and implemented security as per the needs.
• Developed the complex cross tab reports and list reports using functions.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved multiple prompts, filters, calculations, multi-page and multi-query with joins.
• Developed master detail reports, multi query and multi-page master reports as per business needs.
• Responsible for handling and maintaining Cognos Content Store, content administration and backup related issues.
• Created and scheduled events using Event Studio for production error monitoring to provide the updates to the business users.
• Developed Power Play cubes and published packages utilizing Cognos Transformer to facilitate OLAP analytical reporting.
• Designed and developed analysis reports in Analysis Studio analyzing MDX expression using cubes.
• Created multidimensional cubes using IQDs and created models in Power Play Transformer.
• Worked on Cognos Security Administration by providing the accesses and privileges to the users and user groups using Access Manager.
• Coordinated system test plan execution for the integration of code in to the production environment, UAT, UVT and smoke tests and resolved the production support issues.
• Created user manuals for internal and external user training and orientation. Provided documentation and tutored the end users how to use different types of studios.
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Provided the risk contingency plans to Chrysler IT and Business and implemented those plans to bring back the project back on track.

Environment: Cognos 8.0/8.2 BI, Cognos Connection, Report Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Access Manager, XML, Oracle, Windows 2003, Microsoft Project MPP , Unix.

Confidential

Role: Cognos Designer/Developer

Responsibilities:

• Worked on Cognos tools like Report Studio, Framework Manager, Query Studio and Cognos Connection.
• Involved in design phase, gathered requirements from users and developed report specifications including report documentation.
• Imported data into Framework Manager from Oracle.
• Involved in setting up cardinality, building models, applying joins, creating packages in Framework manager.
• Set up Data, object and Package security in Framework Manager.
• Used master/detail Relationships, tabular model and tabular set in report studio.
• Involved in the creation of list, crosstab and chart reports in report studio.
• Used calculations, filters for easy user readability.
• Implemented Drill Through, Prompts and HTML text for better utilization of reports.
• Involved in Query Optimization, Creating Query Prompts, developing Prompt pages and Conditional variables.
• Created complex Report Studio reports using Conditional Blocks, Conditional Layout and Sections.
• Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata.
• Created Multi-Dimensional reports using Powerplay
• Developed Impromptu Query Definitions, Hot files and Thumbnails.
• Used impcat2xml utility to migrate Impromptu reports to Report Net.
• Created different type of report formats like PDF and Excel 2000.
• Created jobs to schedule reports using Cognos Connection.
• Used Eclipse tool to manage the code base and to create ER files.
• Assisted in training the end users to create ad hoc reports.
• Extensively worked with Repository Manager, Designer, Workflow manager and Workflow Monitor.
• Developed transformation logic and designed various Complex Mappings
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy and Stored Procedure.
• Provided the weekly progress to IT managers on a weekly basis and highlighted the project risks and dependencies using MS Project
• Provided the risk contingency plans to Chrysler IT and Business and implemented those plans to bring back the project back on track.

Environment: Report Net 1.1MR2 Cognos Connection, Report Studio, Query Studio, Framework Manager , Impromptu 7i, Informatica Power Center 8.1/7.2, Eclipse, Oracle 10g, Microsoft IIS, SQL and Windows XP, Microsoft Project MPP , Unix

Confidential

Role: PL/SQL /Crystal Report Developer

Responsibilities:

• Involved in Business Analysis, Design and Development
• Performed Normalization and Logical Database Design
• Created Stored Procedures, Functions, and Packages to manipulate the database and to apply the business logic according to the user specifications.
• Involved in hard coding of SQL PL/SQL scripts.
• I did Performance tuning for rapid execution of SQL PL/SQL Scripts.
• Developed GUI interface in Java using Applets, HTML, JDBC and JavaScript.
• Created Stored Procedures, Functions, Packages, Triggers, Tables, Views and Synonyms
• Accessed data from the database using RDO Controls and Remote Data objects
• Created the VB Forms for Data Capturing using Active X Data Objects.
• Created Active X DLL's using Class Builder Utility and generated different Crystal Reports.
• Used Eclipse tool to develop the Java code and to manage various classes and to create ER files.

Environment: Oracle 9i/10g, PL/SQL 8.0, SQL Server, Sybase, Visual Basic 5.0/ 6.0, JAVA, JSP, Eclipse, Crystal Reports and Windows NT