SUMMARY:

• Having 10+ years of Experience in IT as a Senior Business Intelligence Developer, dedicated to Data Warehousing technology and specially in to Cognos BI, Tableau, Apriso.
• Experienced in Cognos 11, 10.x BI, Cognos 8.X Report Studio, Query Studio, Cognos connection, Framework Manager, impromptu, power play, Transformer, Tableau Desktop, MPI, BPW Designer, Application studio and deploying the applications
• Have good exposure in Cognos Analytics 11 and gave training to the business users.
• Exposure to Waterfall and Agile methodologies and in various domains including Banking, Healthcare.
• Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize in a productive manner
• Working with business users to design and develop Dashboard reports using Tableau and Cognos
• Extensively worked on Cognos Framework manager models
• Having Work Experience in Cognos Life Cycle while upgrading from Cognos 10.x to Cognos 11
• Involved unit testing after the upgradation from Cognos 10 to 11
• Involved in Performance Tuning of Reports to reduce report execution time.
• Developed various dashboards in Tableau, used context filters, sets while dealing with huge volume of data.
• Handled Tableau admin activities managing extracts and granting access
• Having good experience in Power Play Transformer, Oracle & SQL Server
• Having good knowledge in Talend & Data Warehouse concepts
• Certified professional in Cognos BI Author v2
• Having experience in MSBI into SSIS, SSRS and SSAS
• Having experience in FlextNet - MPI and Infor BI (BPW Designer, Application Studio, M3 Analytics)
• Having good experience in Infor BI and Cognos BI administration activities
• Experienced in all phase of Finance, Pharma, Manufacturing and Data warehousing applications and requirement gathering from the client, based on which advising database team to create objects in database
• Having technical and lead experience
• Good Communication skills, Quick learning and keen interest in learning and implementing new technologies
• Having Good management skills and problem-solving skills ngoing project status and issues.

TECHNICAL SKILLS:

LANGUAGES: Cognos 11,10.2.2, Tableau Desktop 10.4.1, Talend 6.0, M3 Infor BI, Apriso MPI(3DS)

Databases: Oracle 9i/10g/11g, SQL Server 2010, Teradata 13, flat files, mainframe

Client Technologies: Cognos, Tableau, Talend

Languages: SQL, PL/SQL

Operating Systems: Windows XP, Windows NT, UNIX

Tools: / Utilities: Management studio, SSIS, SSRS, SSAS, Oracle SQL Developer

DATABASE: Oracle 8/8i/9i/10g/11g, DB2, MySQL

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr Cognos Developer

Responsibilities:

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed and managed relational models using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports (which involves Joins, Unions, Prompts, Report Library, Table of Content, Report Layout, template, Dashboards etc.) in Report Studio based on the business requirements involved Multiple Prompts in Report Studio
• Developed Query Studio Packages for Ad-Hoc reporting.
• Used HTML, Java scripts in prompt pages
• Worked on enhancements to existing Cognos reports in Report Studio & models in Framework Manger
• Migration of reports from Cognos 7 to Cognos 10
• Involved in Upgradation project from Cognos 10.X to Cognos 11
• Performed detailed Cognos Analytics 11 Support tasks by creating application feeds and scripts to activate data loading and scheduling procedures within the environment.
• Written MDX to develop dashboards and Framework models (GMIS package) and developed IBM Cognos 11 Reports Using MDX functions from that package.
• Created query studio reports using Custom Grouping option.
• Applied conditional formatting for hiding the data, and highlighting the data
• Incorporated Layout Component Reference in the new reports.
• Created Cascading prompt and re promotable prompts to view report
• Coordinated with offshore team for Migrations.
• Performed administration task for user permissions (LDAP, ADFS) & scheduling the reports.
• Administered Security using Cognos Access Manager
• Used Static Choices to conditionally hide and display the objects
• Used Event Studio to trigger the jobs.
• Developed Structural and Transactional IQD’s from Framework Manager and used it for Transformer.
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.
• Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.
• Interacted with QA team for Unit Testing, System Testing and Performance Testing.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.

Environment: Cognos 11,10.2.2(Cognos Connection, Framework Manager, Report Studio and Query Studio), CognosEPseries7.3(Impromptu administration, Transformer, Powerplay Windows/web and upfront) Oracle 11g, IIS 6.0, Windows 2003 Server, TOAD, PLSQL Developer.

Confidential, Chicago, Illinois

Sr Cognos BI Developer

Responsibilities:

• Installed and Configured Infor BI and Cognos BI on Dev and QA and Production environments
• Gathered ETL, Cube model and Reports requirement from customer
• Created a mapping document based on High level design document
• Create the mappings, sessions and Workflows as per requirement of business to implement the log in SSIS
• Created Cube model documents based on High level design document
• Created cubes for the all modules like sales, finance, procurement in Transformer
• Created dimensions and fact tables using BPW Designer
• Developed Cognos models and packages in Framework manager
• Developed Dash boards for all the modules using in Infor BI and Cognos BI, SSRS
• Developed different reports using Application studio and Report studio, SSRS especially drill through reports, Chart reports, Conditional formatting reports and conditional block, Master detail reports
• Involved Infor BI and Cognos BI administration activities like Repository administration, OLAP administration and Cognos administration
• Implemented Security with LDAP and group level security in Cognos Connection Portal
• Using Repository administration created repositories and using OLAP administration created OLAP databases for all the modules
• Using administration tools created users and gave permissions for reports and data
• Involved in deployment of reports and models
• Involved in migration of Catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities
• Cognos Software upgrade, Administration and Support.
• Installed ESRI Maps and Integrated version control.
• Maintenance of Cognos server performance, users, roles, and security using LDAP.
• Restart servers and Monitor server performance.
• Execution and monitoring the SSIS packages and SSAS Cubes daily

Environment: Cognos BI, Infor BI, Power Play Transformer, SSIS, SSRS, SSAS, Framework Manager, Report studio, SQL Server, SSIS, SSAS, DB2.

Confidential

Tableau Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote Test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Environment: Windows 7 and Linux, Tableau, tableau server, MS-Excel, SQL Server, SharePoint, Microsoft office, SQL-PLUS.

Confidential

Cognos BI/MPI Developer

Responsibilities:

• Gathered Functional & Technical requirements for Cognos BI and MPI
• Gathered Reports requirement from customer
• Installed and configured Cognos BI tools in Dev, test and production Environments
• Developed reports and dashboards using Cognos and MPI tools
• Developed drill through reports, chart reports, crosstab reports using Cognos BI and MPI
• Maintained security levels (Roles, groups) in Cognos using Active Directory
• Execution and monitoring the SSIS packages and SSAS Cubes daily
• Created Cube views in Flex Net portal and created dashboard reports in Cognos BI
• Prepared Schema relationship document at modelling level
• Prepared Cube dimension relationship document for MPI
• Prepared Table mapping document for all dashboard reports
• Testing the reports for data accuracy and consistency
• Run, view and analyze the reports in MPI excel add in
• Analyzing client business processes and information needs

Environment: Cognos BI, Report Studio, Frame work manager, Flex Net 9.6, MPI 2.1, SQL Server, SSIS, SSAS

Confidential

Cognos BI developer

Responsibilities:

• Worked on multiple projects simultaneously
• Used Cognos Connection for the design of reports using Cognos 10 BI (Report Studio), query studio and also created portal pages
• Involved in deployment
• Creation of Calculations, Variables, Filters at reports designing
• Developed Reports with conditional formatting. And Created text-based prompts, date prompts and value prompts
• Generated reports like list, cross tab
• Created scorecards, dash boards using relational and dimensional models
• Involved in creating, modifying and deleting prompts in a report
• Modifying the Prompts Using Java Scripts
• Generated reports using cascading prompts, generated prompts in report Studio
• Created master/detail, drill through reports to link two or more reports
• Created cubes and models in Cognos Transformer
• Testing the reports for data accuracy and consistency
• Run, view and analyze the reports in different formats
• Interaction with the client for requirement analysis
• Analyzing client business processes and information needs
• Migration of Catalog using impcat2xml utility
• Migration of Impromptu Reports using migratetoc8 utility
• Deployment of migration package using deploytoc8 utility

Environment: COGNOS 10 BI, Transformer, Data Stage 8.x, Oracle 10g, Impromptu

Confidential

Cognos developer

Responsibilities:

• Developed different relational FM packages and models in frame work manager
• Developed List Reports, Cross-tab Reports and Drill-through Reports
• Created reports using cascading prompts
• Created various types of reports for various user levels
• Queried from different database tables as per the requirement
• Created SQL/PLSQL based reports in report studio
• Scheduling the reports
• Created and enhanced existing Power Cubes as per user requirements
• Imported IQD files created in impromptu into transformer to construct a power cube Involved in optimizing Power Cubes
• Daily Interactions with Clients and Onsite Counterparts
• Maintenance of complete life cycle of the PQR’s
• Developed Adhoc Based Reports
• Daily, weekly, monthly and quarterly Monitoring of the Scheduled Jobs and Tasks
• Daily Monitoring of Cognos Cubes
• Working on Impromptu PQR’s
• Creating Users in Access Manager
• Creating and scheduling the automated reports using Impromptu scheduler and Macros
• Creating the reports, jobs and scheduling the reports in Cognos 8.0 also

Environment: Cognos Power Play Transformer, Impromptu, Cognos 8.X Report Studio, Analysis Studio, Framework Manager, IIS Web-Server, Access Manager and TOAD

Confidential

Cognos developer

Responsibilities:

• Used Cognos Connection for the design of reports using Cognos 8 (Report Studio), query studio. And also created portal pages
• Involved in deployment
• Creation of Calculations, Variables, Filters at reports designing
• Developed Reports with conditional formatting. And Created text-based prompts, date prompts and value prompts
• Generated reports like list, cross tab
• Involved in creating, modifying and deleting prompts in a report
• Modifying the Prompts Using Java Scripts
• Generated reports using cascading prompts, generated prompts in report Studio
• Created master/detail, drill through reports to link two or more reports
• Testing the reports for data accuracy and consistency
• Run, view and analyze the reports in different formats
• Interaction with the client for requirement analysis
• Analyzing client business processes and information needs
• Testing the reports Using SQL queries
• Publishing the packages in FM
• Used Cognos Connection for the design of reports using Cognos 8 (Report Studio), query studio. And also created portal pages.
• Involved in deployment.
• Importing the Stored Procedures from Data Source to FM and Creating the Packages in FM.
• Modified the Prompts Using Java Script.
• Creating the data sources in Cognos Connection for DEV, UAT and Prod.
• Giving production support maintenance.
• Working weekend support
• Generated reports like list cross tab.
• Involved in creating, modifying and deleting prompts in a report
• Generated reports using cascading prompts, generated prompts in report Studio.
• Created master/detail, drill through reports to link two or more reports.

Environment: Cognos 8BI, Cognos 8.2, Informatics, Oracle 9i, SQL Server