SUMMARY:

• 12+ Years of IT experience that involves architect, design, develop and implement Data Warehouse and Business Intelligence solutions.
• Excelled in various BI roles that include BI Architect, BI Analyst, Administrator, Application Developer, BI Support Analyst, BI Lead and SME.
• Extensive experience in COGNOS Suite of Products including Cognos 10.2/10.1.1, 8.4 & 8.3, Report Net 1.1, and Cognos 7, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Power play Transformer and Impromptu.
• Experience in diversified domains that involves Healthcare & Pharma, Transportation & Logistics, Communication, and Retail
• Strong experience as a Report Author in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master - Detail, and Cascading) and Dashboards using Report studio
• Good experience in designing and building Framework and transformer models, creating ad-hoc reports, dashboard reports and active reports using Cognos Connection / IBM Cognos series 10/8 (Query Studio, Report Studio, Framework Manager, Power Play Transformer, Analysis Studio).
• Very strong experience in Cognos Support and Administration, administering the Cognos servers, monitoring and performance tuning, installing the software patches and fixes, handling security structure.
• Expertise in Installing and configuring Cognos BI Server 8.4/Cognos 10.1.1 using distributed Servers methodology.
• Proficient in setting up IIS server website/Setting up Virtual directories/ Knowledge of installing IIS certificates etc.
• Expertise on Cognos security configuration like Access Manager Administration, Active Directory, LDAP and NTLM.
• Strong SQL and PL/SQL skills.
• Expertise in multiple relational databases includes Oracle (9i, 10g), Teradata 13.10, MS SQL Server 2000 and MS SQL Server 2005.
• Experience in SQL, SQL*Plus, TOAD, SQL Assistant, SQL Developer, Stored Procedures & Triggers, IIS, Eclipse, Apache Tomcat 7.0.
• Good knowledge on Cognos TM1, SAP Business Objects, Informatica ETL tool
• Good knowledge with Qlikview development.
• Proficient in developing and executing test plans based on system and validation requirements.
• Worked effectively on Change Management, Problem Management, Configuration Management and Release Management Processes and developed reports to see the performance of those processes under Business perspective.
• Experienced in delegating and coordinating development and testing in an onsite-offshore delivery model .
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact Analysis).
• Excellent Communication, Presentation and Leadership Skills.

TECHNICAL SKILLS:

Language:  C, C++, Java, SQL

Operating System:  Windows NT/2000, Windows XP, Windows 7

BI Tools:  Cognos 10.1/8.0/8.2/8.3/8.4 BI Framework Manager, Report Studio, Query Studio,Analysis Studio, Cognos Powerplay, Transformer, Cognos Administration,Informatica, Business Objects

Web Tools:  HTML, Java Script,XML

Project Management:  MS Office 95/2003/2010

Database:  Oracle 11G, 10g, 9i, Teradata13.10, Sql Server 2000 & 2005

Other Tools:  SQL/PLSQL Developer, TOAD, SQL Assistant, Autosys job Scheduler, Remedy ITSM, and MKS Integrity tool, IIS, Eclipse, Apache Tomcat 7.0

PROFESSIONAL EXPERIENCE:

Cognos SME, Project Lead

Confidential (Waukegan, IL)

Responsibilities:

• Stand-in as single person of contact for all Cognos reporting needs.
• Interacting with respective teams to obtain business requirements and preparing the Functional and Technical Documents and communicate the same to the team members.
• Validate the BI design and ensure that technical specifications are complete, consistent, concise, and achievable.
• Estimating the effort required for all Cognos activities includes Analysis, Documentation, Development, Testing, Bug Fixing, Deployment and Support.
• Created metadata models using framework manager, created packages and published the packages.
• Created Complex reports like the Multipage & multi-query reports, drill though reports, Dashboard reports and conditionally formatted reports including graphs and images.
• Experience with connecting SalesForce and cost point.
• Maintaining Cognos production Servers, Performing deployment and creating backups of Content Store.
• Providing Access to the User groups through LDAP and maintaining the Cognos security groups.
• Using the Cognos Scheduler (Schedule Management tool), scheduled the long-running reports to provide static views to the business user.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors from Oracle procedures and packages through TOAD.
• Involved in manual data loads from flat files into Oracle DB through MS Access.
• Install and Configure the Cognos 10 Server Components on Windows 2008R2 servers for DEV, TEST and PROD Environments.
• Configured the Cognos 10 gateway in IIS Server on Windows Server.
• Worked on Upgrading the Cognos 8.4 Environment to Cognos 10.1.1 Environment.
• System, Unit testing, and regression testing on all the changes for reports.
• Experience in maintenance, support, change-control and end-user training as part of setting up a sustainable BI life cycle.
• Coordinating with the Offshore and the client for the daily activities
• Communicating status to the management on a regular basis
• Providing production support to Business, Handling the issues and providing the solution.

Cognos & SME

Confidential (Waukegan, IL)

Responsibilities:

• Responsible for understanding Business Process and specific business needs from Business users
• Metadata modeling of both Relational and Dimensional data using Framework manager
• Queried data from different database tables as per the requirement.
• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created packages using multiple data sources in the framework manager.
• Created Calculated Levels based on Business Requirement to perform Analysis using Analysis Studio.
• Created highly complex and formatted reports in Cognos8 using most of the Cognos functionality (such as Conditional Formatting, Drill Through, Repeaters, and Discontinuous Crosstabs, Dashboards etc.)
• Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
• Administration and maintenance of Cognos Reporting Application which includes installing patches, fixes and deployment of code to higher environments.
• Involved in backup and restore of Cognos TM1.
• Provided support and troubleshooting problems as required
• Design and Development of Data Warehousing reports on Cognos Transformer, Analysis Studio and Power play.
• Created OLAP cubes using Power Play Transformer against various data sources like Oracle& Flat Files.
• Creating and maintenance of Cognos data source with custom security for each user group
• Scheduling and maintenance of monthly and weekly reports
• Setting and maintenance of Dashboards and distribution of Cognos reports file system and bursting of the reports (Network Bursting, Directory Bursting & Email Bursting)
• Responsible for Auditing reports in all 4 Cognos environments (Dev, Pre-q, QA, Training, and Production).
• Responsible for maintenance and backup of Content store all the environments
• Hands on experience on Performance tuning and Optimization of the reports and FM models.
• Responsible for troubleshooting the issues resolving the open tickets created by user for application reports.

SR. Developer

Confidential

Responsibilities:

• Involved in requirement gathering and preparing the both functional and technical documents for all reporting needs.
• Assisted System Administrators in Cognos Migration from series 7 to 8
• Involved in data gathering and developing models in Framework Manager and publishing the packages onto Cognos Connection.
• Converted as many as 50 + reports from Series 7 to Cognos 8.
• Designed the reports to audit the report user's activities and reported this on a monthly basis to the Users.
• Implemented Package level security and object level security in Framework manager
• Created Simple List reports, Cross-tab reports, Conditional formatting and Drill - through Reports using Report Studio.
• Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
• Worked using OLAP tool, Power Play for building cubes and reports that meet the business requirements.
• Experience in building multidimensional cubes.
• Involved in creating complex reports involving stored procedures with parameters.
• Optimized cubes by selecting appropriate methods, which include partitioning, time-based partitioning, cube groups and incremental updates.
• Tuned transformer models for faster cube builds and access times.
• Provided documentation to the end users and conducted training workshops.
• System level testing against the QA database for reports.
• Preparation of data validation and issue log sheets for reports.
• Coordinating with the team for the daily activities
• Weekly status report and forecast analysis for future project tasks
• Enhanced Transformer cubes with new reporting updates
• Developed test cases for the validation and verification of the reports.
• Worked on the design documentation, deployment guide and user guide.

Cognos Lead, SR. Developer

Confidential 

Responsibilities:

• Analyzed business and user needs and designed Business Intelligence solution that supports business and operations with attention to business value and strategic BI direction.
• Implemented security for Data access, Object level access and Package access.
• Analyzed and designed the data model in Visio diagram which needs to be implemented in Framework Manager
• Reduced the no of tables count by merging different tables based on cardinality.
• Designing the logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Import the database objects to the Framework manager model and set the cardinality between them as per the business requirements.
• Created Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developing the List Reports, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Administering the Cognos packages using the user security.

Cognos Developer

Confidential

Responsibilities:

• Involved in the requirement analysis phase
• Requirement Gathering for Cognos reports.
• Understanding and discussing the new requirements from user through regular interaction.
• Developing the Reports (Medium & Complex)
• Analyzing the change requests
• Modifying the reports and testing the reports Implementation of Hot fixes.
• Resolution of Cognos development issues.
• Follow up with Cognos support to find out the solutions for achieving the tasks which are not possible through the tool.
• Coordinating on Maintenance issues with PM.
• Preparation of activity list for Code migration to Production environment once UAT is over
• Involved in Designing the HLD according to the RRT.
• Created various types of Filters for reports
• Created Master-Detail Relationship Report.
• Involved in Recurring Scheduling and Batch Scheduling.
• Involved in Unit Testing and System Testing.