SUMMARY

• BI Professional with 9 years of experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, and Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Healthcare, Banking, Insurance, and Pharmaceutical industries.
• Expert in agile and waterfall SDLC methodologies. Experience in successful implementation of technical standards, blueprints and roadmaps for cognos soultions.
• Having 9 years of experience on Cognos Suite - Cognos Analytics V11, Cognos 10.2.1, Tableau 9.3, Tableau 8x, Cognos 8x (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio, Cognos Adminstration and Cognos Connection)
• Experience in handling complete range of admin capabilities: Monitoring Server status, system metrics, monitor activities, create groups and user roles, set user interface profiles, setting up data source connections.
• Extensive experience in conducting knowledge transfer sessions to clients and client managers on cognos.
• Developed Active reports, Bullet Charts and Micro Charts with Cognos 10.2.1.
• Developed Dashboards using Cognos 10 Business Insight and Cognos 10 Business Insight Advanced.
• Extensively worked on Active Reports Objects (Deck, Data Tab controls, Data Controls, Connections and Variables).
• Designed & developed Cognos Go Mobile 10, Configured Go Mobile with IPad Reporting.
• Strong complex reporting skills-Complex Drill-Through, Cascading Prompts, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Strong knowledge with Power Play Transformer model design and Power Play cube building.
• Expertise in version up gradations of Cognos 10x and Migrating Report studio reports and models intoCognos10 BI from previous versions.
• Good experience in Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Developed DMR Models & IQD’s in Framework Manager.
• Indepth knowledge on Tableau Desktop, Tableau Server and Tableau Administration.
• End to end experience in designing and deploying data visualizations and Data storytelling using Tableau
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Extensive work on Data Extraction with Oracle 11g, SQL Server & MS-Access.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and Involved in providing knowledge transfer with respectiveCognos to the associates.
• Worked with the business users and provide expertise in problem definition, requirements analysis and the general design of the BI System.Provided support to multiple concurrent and cross platform projects.

TECHNICAL SKILLS

Reporting Tools: Cognos Analytics v11, Cognos 10 BI Suite(Business Insight Advanced, Framework Manager, Report Studio, Transformer), Tableau 9x, Cognos 8x BI Suite, SSRS.

ETL tools: Informatica Power Center 10,9x,8x, IBM WebSphere DataStage 11.x/9.x/8.x/7.x. IBM Cognos Data Manager

Operating Systems: Windows Family, UNIX and Linux

Web Servers: IIS, Tomcat and Apache, WebSphere,IHS,WEBrick

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Databases: DB2 10.5/9.5, Oracle 10g/11gR2, MS SQL Server 2014/2012/2008/2005 and Teradata.

Programming skills: C, C++, HTML, JavaScript, SQL, PL/SQL, Ruby programming

Statistical Analysis: SAS Advanced analytics, Cognos SPSS, Stat Crunch

PROFESSIONAL EXPERIENCE

Confidential, PA

Cognos Developer/ Admin

Responsibilities:

• Prepared Functional Specifications, Technical Specifications, Testing Plans and other documentation as required by client’s Systems Development Lifecycle.
• Developed dashboards using Cognos V11 Dashboards, Active Reports and Workspace Advanced.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Developed DMR against underlying query subjects and defined scope relationship between regular dimension and measure dimension.
• Involved in creating and working with PL/SQL Stored Procedures, Functions, Cursors and Triggers.
• Used complex SQL queries in validating the data for reports while working on Prod Support (cognos, database and data) and Research & analysis (Data related) issues.
• Created Complex reports like the Multipage reports, drill though reports and conditionally formatted reports including graphs and images.
• Worked with agent studio in creating, scheduling, refreshing and supporting agents.
• Created Conditional Block reports to dynamically hide or show report objects and provide the end user the option to view the data in different formats.
• Developed Cascading prompts to filter data dynamically and conveniently locate the data the users are trying to use.
• Developed complex reports, multi-query reports and sub-selects queries to meet the client requirements.
• Scheduled batch processing of weekly, monthly and quarterly reports using CRON.
• Developed interactive Dashboard reports using Business Insight and Business Insight Advanced.
• Using the Cognos Scheduler (Schedule Management tool), scheduled the long-running reports to provide static views to the business user.
• Integrated third party authentication sources like LDAP, Active Directory.
• Deployed the Content store, packages, top level folders and reports from Dev to UAT/TEST and TEST to Prod environments.
• Performed Administration activities such as granting access to the users, modifying the distribution list and Deployment.
• Responsible for creating User groups and roles to manage security in Cognos Connection and Access Rights of the Reports for the end users.
• Involved in fixing the issues of the reports after changing the reports from Cognos 8.4 to Cognos 10.1.1.
• Applied Security by Authorization of grant/deny access based on groups, user roles and user identity through namespaces.
• Configured external namespaces for assigning permissions Read, Write, Execute, Set Policy and Traverse.
• Extensive working knowledge on pre-defined administrative roles (Server administrators, Directory administrators, Report administrators and system administrators.
• Developed horizontal bars, line views, scatter plots, geo maps, and Heat Maps using Tableau 9.3.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Developed reports using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau 9.3 .
• Worked on the development of Dashboard reports for the KPIs for the top management using Tableau 9.3.

Environment: Cognos Analytics v11, Cognos 8x, Cognos 10x, Report Studio, Framework Manager, Query studio, Analysis studio, Workspace, Workspace Advanced, IBM Db2 9.5, 10.5, TOAD for DB2, SQL Programmer, MS Office Tools, MS access, Java Script, Shell Scripts, CRON .

Confidential, VA

Cognos Report Developer

Responsibilities:

• Developed Cognos 10.1.1 Reports using Active Reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them ontoCognosConnection.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Quarter End Financial Reports to define total Assets, Liabilities, Balance sheet and P&L.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Testing the developed reports for final deployment.
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 10 Transformer.
• Created simple and ad-hoc reports using Query studio.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger.
• Created SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.

Environment: Cognos10.1.1, 10.1.2, Report Studio, Framework Manager, Query studio, Analysis studio, Oracle, SQL Server, TOAD for Oracle, MS Office Tools, MS access, Java Script, Unix.

Confidential, Boston MA

Cognos Developer

Responsibilities:

• Developed Cognos 10.1.1 Reports using Active Reports in Report Studio.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed Framework Manager Models, Implemented Layer’s Architecture, Security, and Best Practices in FM.
• Created Database Layer, Intermediate layer and Presentation Layer defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Created Packages with various security settings and published them ontoCognosConnection.
• Upgraded Cognos Reports & Packages from 8.4 to Cognos 10.1
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Developed Active Reports and Heat Maps using Cognos 10.1.1.
• Created reports with custom prompt pages (using HTML and JavaScript) in Report Studio.
• Developed Quarter End Financial Reports to define total Assets, Liabilities, Balance sheet and P&L.
• CreatedPower Play cubes in Transformer 8.4 based on business requirements.
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Testing the developed reports for final deployment.
• The work related to finalizing and testing/debugging IQDs, appropriate documentation and functional training in designing, building, and maintaining cubes in Cognos 8 BI v8.4.
• Created simple and ad-hoc reports using Query studio.
• Scheduled the reports in Cognos connection and distributed them via mail.
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Create SQL queries using Oracle SQL Developer to verify accuracy of Cognos reports.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Involved in performance tuning of the reports in Report Studio.
• Involved in implementing security in FM and Cognos Connection Portal.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 8.4& 8.2 Report Studio, Framework Manager, Query studio, Analysis studio, Cognos Connection, Cognos Transformer 8.3/8.4, Data Manager, Oracle 10g, DB2, SQL Server 2005, MS Office Tools, MS access, Java Script, Unix.

Confidential, Stamford

Sr. Cognos Developer

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Provide best practices for day to day operations, performance analysis, tuning and capacity planning.
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Implemented Framework manager security for row level access and Package access based on the Department and region Level.
• Creating star schema grouping for better understanding of the model.
• Develop framework model to perform most of the calculations and give power to user to create Ad-hoc reports with ease.
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Ensuring clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Created ad-hoc packages for the query users with pre-defined filter conditions prompt customization.
• Created Filters, Prompts, Calculations both at package level and report level.
• Designed various kinds of Reports in Report studio (Conditional Formatting, Conditional Blocks, Sections, page Breaks, Master-detail, and Drill through).
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes.
• Developing Analysis Studio views of analysis from dimensional modeled packages.
• Scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• Designed & developed Reports using Cognos Go Mobile 10.
• Designed Data marts for creation of reporting database using Data Manager
• Created multiple star schemas using Cognos Data Manager.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments.
• Worked on conducting User Interviews and documented their query, business analysis and reporting needs, Understood data and business logic with reporting viewpoint.
• Developed technical specifications and deployed efficient Business Intelligence solutions.
• Provide training, support and guide for best practices for Adhoc Query Users and Report Authors.
• Interaction with the business users at various stages of the project through demos.

Environment: Cognos 8.x, Report Studio, Framework Manager, Query studio, Analysis studio, Cognos Connection, Cognos Transformer 8.3/8.4, Data Manager, Oracle 10g, DB2, SQL Server 2005, MS Office Tools, MS access, Java Script, Unix.

Confidential, NJ

Cognos Developer

Responsibilities:

• Developed models in Cognos 8.2 Data modeling tool Framework manager and 8.2 Transformer.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager.
• Customized Cognos Connection with appropriate reports and security measures.
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Created Dash board reports to get all the information from other reports.
• Involved in access and analyze large data sets for completeness and quality.
• Built Power Play Reports based on the cubes.
• Prepare deployment specifications and work with system administrators to move reports into QA and Production.
• Analyzed the Explain Plan to check how the queries are performing scans.

Environment: Cognos 8.2/ 8.3 BI Suite (Report Studio, Query Studio, Cognos Connection, Framework Manager, Event Studio, Metric Studio, Analysis Studio, Metrics Manager), Transformer 7.4, Content Manager, Oracle 10g, SQL Server 2005, SQL, PL/SQL, JavaScript, HTML, MS- Excel, Data manager.