SUMMARY

• Around 6+ years of diversified experience in the IT industry with Design, Development, Administration and Implementation of Cognos BI applications.
• Having hands on experience with Installing, Configuring, administration and support of Cognos BI systems.
• Experience in gathering the requirements, analyzing, design, and development of BI solutions.
• Experience in installing, administering, maintaining and supporting Cognos TM1 (both Stand - alone and distributed environment).
• Extensively worked on Report Studio to design and develop complex reports, dashboards and scorecards that includes the features such as MDX, Relational functions, list, cross tabs, charts, conditional formatting, java script, burst, SQL Objects etc.
• Worked with Cognos Framework Manager to create both relational and DMR models.
• Worked on Turbo integrator (TI Processer), Cubes, Dimensions, Rules, Skip check and Feeders.
• Designed and developed complex power cubes using Cognos Transformer.
• Experience on working with Waterfall, Agile and RAD methodologies
• Experience in creating complex reports using various data sources including Netezza, Oracle, SQL Server, Power cubes etc.
• Having experience in working on the projects that spawn all across the SDLC components.
• Sound business knowledge of Banking, Financial and Health care systems.
• Have good communication skills, analytical skills, out of box thinking, goal driven, solutions oriented, well organized, and able to work independently as well as a team member.

TECHNICAL SKILLS

• Cognos BI
• Frame Work Manager
• Cognos Portal
• Cognos Dashboards
• Access Manager
• TM1 Architect
• TM1 Turbo integrator
• Cognos Report Studio
• Query Studio
• Analysis Studio
• Workspace Advanced
• Transformer
• Microsoft Excel
• Microsoft Outlook
• Java
• Java Script
• Oracle
• SQL Server
• SQL/PLSQL
• HTML

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI/TM1 Developer

Responsibilities:

• Designed and developed BI models in Cognos Framework Manager based on business requirements for Security project.
• Created Complex ATO Dashboard that uses oracle as data source and that data has been used from excel file.
• Modified and updated column information as per business requirement
• Created dimensions, cubes, processes, and chores in TM1 Architect.
• Created several dashboards, Drill reports in TM1 Architect and publish to TM1 web.
• Created separate dimension using TI processes for validating that data remained unchanged throughout the conversion process.
• Experience in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting.
• Created and designed web templates for user enter their data into cubes for budget analysis.
• Created multiple tabs for load budget data and analysis actual amount vs budget amount.
• Maintained Rule’s document as per management required.
• Using Turbo integrator updated the cubes by configuring mappings, attributes, consolidations etc.
• Performed the mappings of elements, data, attributes and consolidations in Turbo integrator process.

Environment: Cognos 11, Oracle 10g/11g, SQL Server, Cognos TM1 10.2.2, AWS RDP, Bastion servers

Confidential, MD

Cognos BI Admin & Developer/TM1 Developer

Responsibilities:

• Installed and configured Cognos 11 on Sandbox server as part of upgrade project.
• Responsible for creating User groups and roles to manage security and Access the Reports for the end users
• Created several skins/styles in Cognos 10.2.2 using Theme designer based on the client needs as part of upgrade project.
• Created routing rules to run the dynamic cube reports on a specific dispatcher.
• As part of support team provided support to Cognos applications including migrations, resolving user issues, troubleshooting errors etc.
• Designed and developed several BI models in Cognos Framework Manager based on business requirements for Survey project.
• Designed and Developed reports which involve drill down, drill up and drill through functionalities along with bursting features in report studio.
• Created database, Business, and presentation layers in framework Manager, defining appropriate relationship between query subjects.
• Created complex Survey reports that uses both power cube and Oracle as data sources. SQL objects have been used to calculate statistical function and used MDX to perform the calculations on the cube.
• Designed and developed cubes using Dynamic cube designer by creating dimensions and measures.
• Designed and developed complex reports for several applications including Survey, Claims, and Authorizations.
• Created power cubes using Cognos transformer with the package and reports as source.
• Created dimensions, cubes, processes, and chores using TM1 Architect.
• Resolved various issues that occurred during the TM1 development process.
• Using Turbo integrator updated the cubes by configuring mappings, attributes, consolidations etc.
• Performed the mappings of elements, data, attributes and consolidations in Turbo integrator process.
• Writing TI process to Load data into different Revenue and Expense Cube with excel file as data source.
• Worked on developing TM1 Chores, complex Rules & Feeders and TI processes

Environment: Cognos 11, Cognos BI 10.2.2/10.2.1 , Oracle 10g/11g, SQL Server, Netezza, TM1 10.2.2, PUTTY, CYGWIN, UNIX, Windows 2008 servers

Confidential, Washington DC

Cognos BI Consultant

Responsibilities:

• Installed and configured Cognos 10.2.1 to 10.2.2 as part of upgrade project.
• As an admin, implemented security permission in Cognos by creating/managing groups and roles in Cognos and in Active directory.
• Created data sources in Cognos on top of various data bases such as Oracle, SQL server, OLADP Cube etc.
• Migrated the reports/packages from one environment to another, using the Cognos deployment process.
• Used the Remedy tool to create/update the incidents, work orders, change requests and assigning the tasks to respective teams/users.
• Restarted Cognos services on Unix/Windows servers as needed. Especially during the Windows patching schedule.
• Troubleshooting critical issues related to Report Studio reports and helped developers in resolving the development issues and helping them providing the solutions.
• Made several modifications to Report studio reports such as updating drill thru definitions, filters, prompt pages etc.
• Worked with Putty tool to connect to UNIX and work with FTP process.
• Worked closely with business users to gather the business requirements and analyze them to provide the BI solutions.
• Responsible for creating the Models & Cubes for the reports and scheduling cube build on monthly basis.
• Created/Maintained complex MDX reports to produce Profit and Loss, Balance sheet, Loans and other types of financial reports.
• Used Java script in report studio reports to control prompt behavior and tabular style of reporting.
• Created burst reports to deliver the reports by individual account.
• Designed and developed several reports on Cognos Audit package. In order to meet the client needs, modified IBM Cognos Audit package and created custom reports.
• Created Report studio reports by utilizing HTML objects to have links to various applications such as VPS, VPP and AUG.

Environment: Cognos BI 10.2.1/10.1.0 , Oracle 10g/11g, SQL Server, Netezza, IBM Data stage, PUTTY, CYGWIN, UNIX, Windows 2008 servers