SUMMARY

• Highly motivated, result oriented professional with a short learning curve and strong communication skills.
• 7 years of IT experience in varied domains like insurance, healthcare, logistics, finance etc.
• Good knowledge of Data warehousing Concepts like Star Schema, Snowflake schema.
• Extensive Reporting experience using Cognos 8.x & 10.x.
• Experience with Cognos Modeling tools Framework Manager, Metric Designer.
• Extensive experience in creating complex reports using customized prompts, calculations, summaries, functions etc.
• Extensive experience in creating visually rich management reports and dashboards using gauges, maps, charts and other graphical elements.
• Extensive experience in creating scorecards for KPIs.
• Extensive experience in writing Complex SQL and working with different RDBMSs.
• Experience with identifying performance bottlenecks and coming up with resolutions.
• Experienced in working with end - users for documenting test cases and supporting them during UAT.
• Experience with migrating reports from Cognos 8.4 to 10.1.
• Experience in Administration tasks in Cognos Suite.
• Knowledge of user security management via Access Manager and LDAP
• Experience in setting up managed Domain groups and namespaces.
• Provided technical and functional consulting/training to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Experience supporting offsite and off-shore teams for incident responses and service request submissions.
• Experience with understanding business objectives, Requirements Gathering, Report Design and Development, Unit and System testing.

TECHNICAL SKILLS

• Cognos 10.x BI Suite
• Cognos 8x. Suite
• Framework Manager
• Cognos Connection
• Cognos Report Studio
• Cognos Query Studio
• Cognos Impromptu Series 7.3
• Access Manager
• Impromptu Web Reports (IWR)
• PowerPlay Transformer v7.3
• Informatica PowerCenter 9.5/9.1
• ERWin
• MS SQL Server 2005/2008
• Oracle 9i/10g/11g
• IBM DB2 UDB
• SQL
• Microsoft Office
• Windows 7/XP.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. Cognos Consultant

Responsibilities:

• Worked with Business groups in identifying and documenting report specification documents.
• Conceptualized and formalized several List, Chart, Cross tab, master-detail, Drill-Down reports using Report Studio as per documented report specifications
• Leveraged report views and report bursting capability in Cognos to reduce maintenance burden by use of parameter prompting.
• Designed and developed complex reports using framework manger model where exists or direct pass-thru SQL in some cases
• Developed several custom SQL reports in Cognos report studio using advanced sql such as pivoting, ranking dense rank, aggregating at different levels of granularities
• Created custom templates and custom toolboxes for the use of reporting
• Extensively participated in fine tuning complex reports with multiple queries by identifying performance bottlenecks and resolving them.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Collaborated with the team in implementing Framework manager security for Data access, Object level access and Package access.
• Validated report content between versions of Cognos software using Lifecycle Manager (LCM)
• Provided technical assistance and end-user training to business users.
• Assisted business users in writing test cases for UAT and validating reports.

Environment: Cognos 10.2 (Report Studio, Query Studio, Analysis Studio, Framework Manager, Workspace, Workspace Advanced, HP Quality Center), Oracle11g, SQL Developer, Windows 7.

Confidential, Melville, NY

Sr. Cognos Developer

Responsibilities:

• Participated in several business workshops to understand business requirements and document reporting requirements.
• Responsible for supporting changes to existing reports while creating new reports as per specifications.
• Responsible for supporting existing Framework Manager Models.
• Migrating reports from Cognos 8.4 to Cognos 10.1 environment.
• Created database layer and presentation layer and created packages using FM model and published in Cognos Connection for new projects.
• Design and build multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Developed Dashboard reports in Report Studio.
• Responsible for Report validation by validating data in the reports with the data from using SQL queries.
• Used Cognos connection extensively for organizing, scheduling and distributing reports.
• Responsible for conducting end-user training in Query Studio and Analysis Studio.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Customized Cognos Connection with appropriate reports and security measures.
• Coordinated with Offshore Team in delegating tasks & tracking deliverables based on business priority.

Environment: Cognos 10.1.1, Cognos 8.4.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Cognos Transformer 8.3/8.4, Oracle10g (SQL, PL/SQL), Oracle SQL Developer, MS SQL SERVER 2008, Microsoft Visio, Linux and Windows 2003 server.

Confidential, Omaha, NE

Sr. Cognos Admin/Developer

Responsibilities:

• Closely worked with Business Users to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Developed requirement specification documents with inputs given from Power users and also designed report mockups when required
• Worked on modeling the metadata extracted from multiple databases and established joins and cardinality to meet the business needs
• Managed security via IBM Cognos Administration and LDAP
• Installed, Configured and Managed Cognos Environments
• Developed required models for reporting using advanced Framework Manager Techniques to meet all the reporting requirements.
• Created security filters at the Framework level to restrict data access created very effective and user friendly prompts which gives users flexibility to analyze the data in all possible ways and at the same time achieved tremendous performance time.
• Used metrics manager to create KPI s such as employee satisfaction and customer profitability.
• Developed simple to complex filters, calculations, conditions, layouts using Cognos Report Studio for their several reports like Vendor Analysis, Allocation, Size-Profile Analysis, Unmatched Receipts and RTVs, Stock Ledger Audit Trail, Prepaid Unmatched
• Created reports with Dashboards, Scorecards this includes complex calculations Planned and implemented Cognos security.
• Provided performance monitoring and tuning for BI Server platforms.
• Used Capabilities features to customize the security features and provided required security for Different user groups.
• Created exports and imports for the Deployment of reports within servers Test, Stage and Production.
• Worked closely in achieving performance tuning Created Jobs and scheduled some of the complex reports periodically during the off-peak times to effectively utilize the resources using Schedule Management in Cognos Connection
• Worked on Version control for all objects in the BI environment.
• Worked with users throughout the testing phases to assure that data being generated matched current merchandizing, accounting reports. As well as familiarize employees with the new system Involved in the entire project life cycle from evaluation, installation, development and documentation of end user reports.
• Provided 24/7 on-call support for end-users and documented the responses.

Environment: COGNOS 8.3/8.4(Frame work Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Metrics Designer, Cognos Configuration), Transformer, Power Play, Access Manager, FACESTS, Oracle 10g, SQL Developer, TOAD, MS SQL Server 2005, IIS Manager, Escalate Retail ERP, Windows server 2003 and Linux.