SUMMARY:

• Confidential has been in the Information Technology Industry for 10 years, primarily working in Data Warehousing &Business Intelligence competency.
• Experience in Business Intelligence & Data Warehousing projects, Information Management & Delivery involving Complete Life Cycle (Requirements Gathering, System Analysis, Design, Implementation, Testing & Migration).
• Experience in Development & Production of various business applications using Cognos8x/10x
• Cognos 10 BI Author & Cognos 10 BI Metadata Model Developer Certified
• ITIL Certification & Sun Certified Java Programmer.
• Published 2 white papers “Method to Implement cascading functionality without page refresh” & “Cognos Report to Implement Drill Down & Drill through” on IBM site.
• Successfully performing role of Cognos onsite lead as well as Cognos offshore lead
• Excellent knowledge & hands on working experience with Cognos tools: Cognos 8x, 10x BI (Report Studio, Query Studio, Framework Manager, Cognos Workspace, Cognos Workspace Advanced).
• Expertise in developing ad - hoc reports using Cognos Workspace Advanced, worked closely with business users to create adhoc reports.
• Experience in designing interactive Dashboards with user friendly capabilities such as Prompts, Navigation & drill-down using Cognos Report Studio
• Experience Active reporting dashboard development for iPads.
• Proficient in Meta data modeling with Framework Manager & experienced in layered approach such as Physical Layer, Business Layer & Presentation Layer. Also, worked with data level, Object level & package level security.
• Trained End Users in using the Ad-Hoc components like Cognos Workspace & Cognos Workspace Advanced.
• Good exposure in Relational Databases (Oracle, MS SQL server & Teradata) for modeling & for supporting analytical & reporting needs of Corporate Business needs
• Created Tables, Views, materialized views, Constraints, Indexes for performance tuning in Oracle 10g
• Extensive experience in developing Packages, Stored Procedures, Functions, Views & Triggers, Complex SQL queries using Oracle PL/SQL (Oracle 10g).
• Data Warehousing ETL experience of using Informatica 9.1/9.6.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Actively involved in Business & Functional Analysis, Data Modeling, & Source System Analysis, Design, Reporting Architecture, development & implementation of BI Applications.
• Excellent Communication, Analytical & Problem-solving abilities with excellent understanding of system development life cycle & proven project management skills.
• Proficient at developing & implementing training programs to enhance the efficiency, competency & motivation levels of the employees in line with organizational objectives.
• Hands on experience in Kronos to create different profiles for access, Monitor Volume, Labor & Schedule jobs & run the jobs in case of failures.
• Extensive experience in writing the SQLs on Kronos tables for Schedules, Forecast, Time of Requests, Availability Pattern, Profiles, Time Card.

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Cognos Lead

Software & Tools: Oracle 10g, Cognos 10.2, Informatica 9.6.1, Kronos 7.x

Responsibilities:

• Involved in design, development of reports in Report Studio. Created reports using List, Crosstab, Charts.
• Work on the performance tuning of the reports
• Worked on scheduling the reports to send it to the IT management as per requirement
• Worked on the Defining User Security as per different user groups & roles in the organization.
• Production support for Cognos Windows servers
• Collaborate with Customer team as required for resolution of Problems & Incidents
• Worked on the Oracle PL/SQL. Created Stored Procedures, Functions for different applications.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages.
• Worked on creation of complex SQLs to provide the adhoc reports to different business users.
• Used various transformations like Filter, Expression, Source Qualifier, Aggregator, Lookup Transformation, Joiner, to develop robust mappings in the Informatica Designer.
• Developed mapping parameters & variables to support SQL override.
• Developed mappings using ETL standards to load into staging tables & then to Dimensions & Facts.
• Worked on different tasks in Workflows like sessions, e-mail, command, & scheduling of the workflow in UNIX servers.
• Created sessions, configured workflows to extract data from various sources, transformed data, & loading into data warehouse.
• Monitor Volume / Labor Forecast, Auto Schedules in Kronos 7.0. Creating the different user profiles for access.
• Created different reports in Cognos based on Scheduling, Time off requests, Time Punch, Availability Pattern, Forecast vs Actual, Keyholder. Also, generated the different data extract from Kronos database for Legal.

Confidential, Saint Paul, MN

Cognos Lead

Software& Tools: Teradata Cognos 10.2

Responsibilities:

• Involved in design, development of the Cognos base reports in Report Studio
• Created structured report using multiple List and Crosstab.
• Worked on the formatting of the layouts as per the project standards
• Provided JavaScript solutions for the reports to validate the prompt selection based on the different user groups.
• Created the drill through for the crosstab to vary the output based on the measure value clicked on.
• Provide the alternate solutions for the complex requirements
• Work on the performance tuning of the reports
• Suggest the changes to the database team to improve Cognos performance
• Provide demo to different business groups within organization.
• Collaborate with Customer team as required for resolution of Problems and Incidents
• Gather requirements from users and provide estimates for the same

Confidential, Warren, NJ

Cognos Lead

Software: Sql Server, Cognos 10.2

Responsibilities:

• Work on SQL Server database and Cognos dashboard Implementation from onsite single handedly
• Perform data model analysis based on the current Business needs and Suggest the implementation changes wherever required
• Make the changes in the database. Create tables, views, and perform data load
• Suggest the changes to the database team to improve Cognos performance
• Involved in design, development of the Cognos base reports in Report Studio required to create dashboard
• Involved in design and development of Cognos Dashboard for Project Manager and Program Manager using Cognos Workspace to get more interactive features available in tool.
• Provide demo to different business groups within organization.
• Propose solution for Adhoc Reporting & provide training on Cognos Workspace Advanced to create Adhoc reports.
• Gather requirements from users and provide estimates for the same

Confidential, Lansdale, PA

Senior Cognos Developer

Software & Tools: Teradata, Cognos10x

Responsibilities:

• Design and development of Cognos Framework manager model
• Create Adhoc reports for different user groups
• Design, development & testing of the dashboards
• Provide training to the business users for adhoc reporting
• Coordinate with Confidential Project Manager & drive the project from the Cognizant side
• Report project progress and escalate issues and risks to the Confidential US Project Manager as per Project Plan
• Interact with Business users, technical staff, and domain experts to obtain clarifications on requirements, analysis, and supporting documents to be communicated for offshore development
• Coordinate with offshore Implementation team
• Work with different stakeholders to promote project goals
• Ensure smooth communication across project teams
• Coordinate with Cognizant project team