SUMMARY

• Business Intelligence Professional with 9 years of Complete BI project life cycle experience - Analysis, design, Administration, configuration and implementation of business intelligence systems, Operational databases, Enterprise Data Warehouses (EDW) and data marts, Data Mining, Data Modeling, Transformation and Loading Methodologies, OLAP tools, Reporting tools and OLAP environments, along with strong analytical skills and application of structured methodology for reporting / BI design, specification and development.
• 8 years Business Intelligence experience using Cognos Series 7, Series 8 and Series 10.2,1, PowerPlay, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, Cognos Decision Stream, Scripting, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Metrics Studio, Map Manager, Business Insight, Business Insight Advanced, Active Reports.
• Strong experience in Business Objects 3.1, 4.0, 4.1. Good expertise in Crystal Reports 2008, Crystal Reports 2011. Crystal Reports for Enterprise, Web Intelligence Rich Client. Very well experienced in administrative tasks such as installation, setting up users and groups, promotion and day to day troubleshooting complex issues across all the environments.
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms.
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Worked in waterfall and Agile methodologies.
• Sound Skills in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8/10.
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 and from Cognos 8.x to 10.x. Complete understanding of key & important milestones associated with migration from Cognos Series 7 and Reportnet or Cognos 8.x.
• Experience in OLTP Modeling (2NF, 3NF) and OLAP Dimensional modeling (Star and Snow Flake) using ERWin (Conceptual, logical and physical data models).
• 7 years of experience using Oracle 12i/11i/8i/7i, Developer 2000, DB2, PL/SQL, SQL*Plus, Win NT 4.0, Linux. Experience in Oracle PL/SQL programming (Collections: Nested tables/VARRAY, Functions, Procedures, Packages, Triggers, Indices and database objects) and Shell Scripting (C Shell, K Shell, Bourne Shell). Possess advanced MS Excel and MS Access skills.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience at building, training, motivating and leading professional teams, managing projects and supporting client relationships

TECHNICAL SKILLS

BI TOOLS: Cognos10.2/10.1/8 series, ReportNet1.1/1.0x,, Report Studio, Framework Manager, Business Objects 3.1, 4.0, 4.1, Crystal reports 2008, Crystal Reports for Enterprise, Web Intelligence Rich ClientDATABASE ORACLE 12i/11i/8i/9i, Sybase 15.0.3, 15.5, 15.7, MS-Access7.0/2000, SQL Server 2000, 2005, 2008, DB2, Teradata.

DATA MODELING: Erwin, Microsoft Visio, ER Studio

ORACLE TOOLS: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer.

LANGUAGES: SQL, PL/SQL Programming, C.

ETL TOOLS: Informatica, BODS

OPERATING SYSTEMS: UNIX, Windows XP/NT/ 2000/2003/2008/2012

WEB: HTML, XML, and JAVASCRIPT

WEB SERVERS: IIS, Netscape Enterprise Server, IE

APPLICATION SERVERS: Apache Tomcat, Web sphere application server(WAS 6.0)

PROFESSIONAL EXPERIENCE

Confidential, Somerset,NJ

Sr. Cognos Developer/Admin

Responsibilities:

• Deployment across development, test production server for Cognos 8.3/8.4/10.1
• Setting up user accounts & permissions for Cognos 8.3/8.4/10.1 Acted as reliable resource for providing production/test/development environment support & troubleshooting.
• Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis
• Created star schema groupings in Framework Manager Models to meet the reporting requirements, Created Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
• Designed and developed numerous lists, crosstab, multi-query, multi-page reports utilizing the master-detail relationship, conditional blocks, conditional formatting, unions, etc.
• Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos Version 8.4 to 10.
• Administered the Scheduling and Distributing Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups
• Customized Cognos Connection with appropriate reports and security measures.
• Created Executive Dashboards, using Business Insight and Business Insight advanced.
• Design & development of multiple reports (adhoc and complex) using various templates like list reports, cross-tab reports and chart reports.
• Acted as the primary contact for cognos support issues from users. Actively interacted and resolved the issues with IBM support team on various cognos bugs and defects.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Developed Custom Portal Tabs and Custom User Interfaces for Reports based on UAT Feedback. Created, refreshed and supported Cognos Transformer OLAP models and Power Play cubes.
• Worked very closely with the ETL team to review stored procedures and workflows using Informatica 9.1.
• Used TOAD for Oracle to write SQL queries to develop test plans and troubleshooting.
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating with Development Team tasks & Deliverables and working on high priority issues.
• Participated in various UAT session and assisted client with the report tool (Cognos).
• Worked in Agile Environment & waterfall environment .Participated in daily scrum, Iteration planning. Conducted Sprint Demos.

Environment: Cognos 10.2.1,Cognos 8.3/8.4(Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced Cognos,Workspace

Confidential, Philadelphia, PA

Sr. Cognos Developer

Responsibilities:

• Conducted design sessions on a weekly basis to discuss design updates/changes to the Enterprise Data Warehouse based on business and data requirements.
• Worked with business users to understand their need from data and reporting perspective and delivered them in a timely manner.
• Acted as a subject matter expert from the data service team to business users.
• Developed star-schema and snow-flake schema metadata model using IBM Cognos Framework Manager 10.2.2.
• Followed best practices while creating Database layer, Business Layer and filters in IBM Cognos Framework Manager (Example: Aggregation of Measures, identifiers and attributes).
• Developed complex reports in the form of list, crosstabs charts and dashboards using Report Studio, Cognos Workspace Advanced and Analysis Studio support Association’s internal and external report.
• Developed reports also based on BRD’s/user stories.
• Used functions like Union, Outer Joins, SQL, Except available within Report Studio to meet the requirements.
• Created prompted and drill through reports based on subject areas like Policy, Accounting and Claims.
• Deployed reports from Cognos development server to test and production server along with the data sources and packages.
• Set up group and user level access and permission using Windows Active directory in all the three environments.
• Converted reports and metadata model from Business Objects to Cognos 10.2.
• Provided production support and maintained Cognos servers to make sure if the services are up and running.
• Set up Image location using IIS on Cognos Web Server on dev, test and prod.
• Identified the difference between Dynamic Query Mode and Compatible Query Mode while developing a model using Framework Manager to resolve and improve performance.
• Configured report bursting and file system location in Cognos configuration in all the three environments.
• Generated reports from report bursting for 254 counties separately in the form of excel and pdf.
• Worked on policy reports like Actuary Annual Reserve Study report which helped the client to identify contribution amount for the members.
• Worked on financial reports like Earned and Unearned Contribution and RMP Reconciliation that helped business to identify the revenue, expense and losses.
• Helping in mapping data fields from old data warehouse (Risk360) to new data warehouse (NavRisk).
• Identified the sources from fact and dimensions for Enterprise Data Warehouse.
• Monitored data mart loads on a daily basis.
• Worked on employee data reports for the counties and county officials (like Judges, Sherrif’s etc.)
• Written SQL scripts using SQL server management studio to develop test plans and troubleshooting purposes.
• Provided one-on-one and group working demo/training on Report Studio, Query Studio and Analysis Studio in Cognos.
• Participated in various UAT session and assisted client with the reporting tool.
• Resolved complex queries, created unions and joins while developing a report in report studio.
• Configured report bursting and file system location in Cognos configuration.
• Generated reports from report bursting for 254 counties separately in the form of excel and pdf.
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Used SQL Server Management Studio to write SQL queries for troubleshooting issues impacting reports and identifying data anomalies.
• Followed Ralph-Kimball methodology and Data Ware Housing concepts.
• Worked with the ETL team to identify and create workflows, stored procedures and packages using Microsoft SSIS.
• Worked with data services team on various tickets with IBM.
• Worked in Agile Environment & waterfall environment .Participated in daily scrum, sprint planning.
• Worked in a fast paced environment in the form of sprint sessions.
• Prepared documentation like Cognos training material for business users, detailed deployment process across multiple environment, set up report bursting on Cognos server etc.

Environment: Cognos 10.2.1, (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advanced), Microsoft SQL Server 2008/2010/2012, Version One, Agile and Waterfall, Risk360,NavRisk

Confidential, Secaucus, NJ

Sr. Cognos developer/Tableau Developer

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Helped screen Tableau Developers for the proposed BI team.
• Was engaged with Enterprise Business Continuity Management in efforts to implement Tableau as a reporting tool.
• Gathered business and functional requirements from all stake holders.
• Recommended and procured necessary infrastructure for users to be able to fully utilize the reports in the Tableau ecosystem.
• Successfully trained senior management in developing self-service dashboard for personal data discovery and consumption.
• Helped with tracking and automating employee business continuity training progress (slowly changing data) through Tableau.
• Involved in the installation of various Cognos tools in distributed environment (Development, Test and Production).
• Customized Cognos Connection portal with appropriate requests and security measures.
• Configured the Cognos server, Scheduled and monitored the reports and jobs schedules, Created Data source connections, administered the report, package, cube and folder permissions, created the user groups and roles based on the security requirements, migrated/deployed the cognos content from Development to test to Production environment.
• Involved in Design and Development of Security Architecture to meet the Business needs.
• Implemented Single sign on Security with LDAP and Group level security in Cognos Connection Portal.
• Built Relational Models for Reporting and DMR for OLAP Style Analysis and Reporting using multi layer Approach and Modeling best Practices to meet the reporting requirements.
• Ensured Ambiguous Relationships are resolved and implemented Model enhancement techniques to improve Model Performance.
• Created Model Query Subjects, Data Source Query Subjects, Stand alone and Embedded Filters to implement the Complex business Logic.
• Implemented internal Cognos Security - Column Level, Row Level Security using Security tables to secure sensitive data with Security Filter, Macros, Session Parameters and Parameter Maps.

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio),Transformer, Oracle 10g,Informatica8.1,Oracle Streams, Active Directory, Oracle Access Manager, OID, Solaris, Sun One I Planet, Web Logic 10.2,Erwin, PVCS. Tableau Server 8.0, Tableau Desktop, SQL Server 2008 R2/2012, ASP, HTML, Windows, SAP BO, Business Objects XI Release 3.1/XI R2/6.5

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Worked on Associate Reporting project used by 20 carriers and 500 Customer providers to monitor their incoming traffic and their funnel activity.
• Designed & implemented various reports for financial dashboards, P&L reports, Retention data, Billing data, Customer Acquisition, Email Marketing, IT & Sales Center, Enterprise wide reporting which left me with abundant subject, applications and data knowledge surrounding the Finance, Planning, Marketing, IT, Operations and Sales Center departments.
• Created metadata models, Namespaces, Folders, Query Subjects and Packages from SQL data source using Cognos Framework Manager.
• Involved in defining cardinality between query subjects.
• Involved in organizing the Framework Manager model into several different business views based on end user requirements.
• Generated projects and publishedpackagesusing Framework Manager.
• Developed list, Crosstab, chart and complex reports in report studio which involved prompts, cascading prompts, filters, drill through, master-detail relationships, and tabular models and enhanced reports using conditional formatting.
• Created daily, weekly, monthly and quarterly reports for the management team and sales center operation managers to run call-center using Report Studio.
• Created Query Prompts, Calculations, Conditions and Filters to generate efficient and user-friendly reports.
• Created multi page report based on multiple Master queries to show the data on different pages when the Master record changes in a Report.
• Developed reports with several prompts, (text box, value, select & search and date prompts) and cascading prompts.
• Involved in testing and improving report performance by optimizing the query performance and implementing appropriate prompts.

Environment: Cognos BI 8.4.1/8.3, Cognos Connection, Report Studio, Query Studio, Framework Manager, MS SQL server, SQL, Quality Center, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Created Physical layer, Development layer and Business layer in Frame work manager.
• Involved in the creation of Relationships and implemented the embedded calculations and Standard Calculation in Frame work manager level.
• Developed and Published packages in Frame work Manager.
• Creating the list reports, crosstab and Chart reports with drill up and down Features.
• Created the drill though reports, bursting reports and Master-details reports.
• Extensively worked with Different kind of Prompts like Value prompt, Cascading, and Textbox prompt, Time and Date prompt.
• Implemented the Conditional block, Conditional variable and Render variable for Hiding and showing the Objects.

Environment: Cognos 8.4, SQL Server 2008, SSIS (ETL), SSRS