OBJECTIVE

• Pursuing a challenging career as a Sr. Data warehouse analyst/architect and TM1 techno consultant with experience in Teradata, Cognos and TM1 Web - based application designs, development and administration, Object-oriented analysis and design, and enterprise wide application development.

SUMMARY

• 10+ years of experience in IT industry with in depth understanding of a software development life cycle- Requirement gathering & Analysis, System Design, Software Development, System Testing, Performance tuning, Documentation and implementation.
• Extensive work experience as a cognos Report developer in all cognos reporting (Cognos 10.2.2) and performance management tools, and in depth proficient experience in OLTP, Data Mining, Dimension Modeling, Data warehouse, T-SQL, OLAP and Business Intelligence technologies.
• Experience in stand-alone and distributed installation of cognos tools as per business needs with proper architecture.
• Extensively worked in setting up of Cognos infrastructure which includes installing, Configuring and migrating from old to newer version of cognos.
• Experience in cognos performance management tool cognos finance 7.X
• Expertise in Data Warehousing methodologies and concepts, including star schemas, snowflake schemas, dimensional modeling and having knowledge on other reporting tools like Hyperion, Metreo, Business objects and OBIEE.
• Experience in working with the Big Data environment and extract the reports to cognos form Hadoop file system using HIVE.
• Experience in automating job chains and scripts using cronacle schedulers for the cognos cube build and ETL process from different sources to Teradata.
• Extensive experience in report generation using Cognos from both relational databases and OLAP cubes.
• Applying creativity, problem-solving, data collection, logical and analytical skills to achieve business results.
• Good knowledge in Performance testing and performance tuning of cognos reports and cubes.
• Ability to prioritize and organize effectively, can handle multiple tasks and deadlines with minimal supervision by analyzing and interpreting the data.
• Ability to communicate verbally and written with all level of management
• Strong troubleshooting and problem solving skills.
• Worked extensively on system design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Operating Systems: Windows-2000/NT, Linux

Business intelligence tools: Informatica power center 8.xx, Cognos 10.2.2, Cognos TM1, Business objects, OBIEE

Database: Oracle 10g, Teradata, Netezza, HDFS

PROFESSIONAL EXPERIENCE

Confidential

Sr Cognos Developer

Responsibilities:

• Designing the framework models and prepare design documents related to the data model and reports design
• Worked on the DMR model and implemented to simplify the process and using various cognos tools.
• Designed and documented the cognos jobs activities and report delivery time frames based on several ends users.
• Worked on the active reports methodology which is new feature added in cognos and trained functional users.
• Developed the complex reports and burst the bunch of report outputs via email to the respective stores and supported the end users using month end and quarter end closing periods.
• Worked on the Hadoop file systems and reporting using the HIVE concept in cognos reports (POC).
• Auto-cascading of Value prompts without having to do a page refresh is implemented in the report studio.
• Dynamic Sorting capability is successfully deployed on a List Report.
• Involved in requirements gathering with end users and involved in documentation as per standards.
• Created the models and packages for report studio, Query Studio and analysis studio.
• Created the standalone and embedded filters in models and summary, Detailed filters in the reports.
• Created and implemented the drill through reports with various aspects as per the requirements.
• Reviewing the model and reports design as per Client’s Standards.
• Working on long running reports and failure reports in production, and involved in performance tuning of the queries.
• Coordinating with the architects and DBA Performance team for the performance tuning

Confidential, Los Angeles, CA

Sr. Cognos Report developer

Responsibilities:

• Creating the professional reports and Dashboards in cognos as per the user requirements
• Worked on the DMR model and implemented to simplify the process and using various cognos tools.
• Worked on the active reports methodology which is new feature added in cognos and trained functional users.
• Worked on the Hadoop file systems and reporting using the HIVE concept in cognos reports.
• Auto-cascading of Value prompts without having to do a page refresh is implemented in the report studio.
• Dynamic Sorting capability is successfully deployed on a List Report.
• Involved in requirements gathering with end users and involved in documentation as per standards.
• Created the models and packages for report studio, Query Studio and analysis studio.
• Created the standalone and embedded filters in models and summary, Detailed filters in the reports.
• Created and implemented the drill through reports with various aspects as per the requirements.
• Reviewing the model and reports design as per Client’s Standards.
• Working on long running reports and failure reports in production, and involved in performance tuning of the queries.
• Coordinating with the architects and DBA Performance team for the performance tuning

Confidential - Milwaukee, WI

Sr. Cognos Report developer

Responsibilities:

• Creating the professional reports as per the user requirements
• Worked on the DMR model and implemented to simplify the process and using various cognos tools.
• Worked on the active reports methodology which is new feature added in cognos and trained functional users.
• Auto-cascading of Value prompts without having to do a page refresh is implemented in the report studio.
• Dynamic Sorting capability is successfully deployed on a List Report.
• Involved in requirements gathering with end users and involved in documentation as per standards.
• Created the models and packages for report studio, Query Studio and analysis studio.
• Created the standalone and embedded filters in models and summary, Detailed filters in the reports.
• Created and implemented the drill through reports with various aspects as per the requirements.
• Reviewing the model and reports design as per company Standards.
• Working on long running reports and failure reports in production, and involved in performance tuning of the queries.
• Installing and Configuration of Cronacle objects for the automation of the jobs.
• Monitoring the cognos tool availability by topaz and taking appropriate action in case of any issues.
• Coordinating with the architects and DBA for the performance tuning

Confidential

Sr. Cognos Developer

Responsibilities:

• Involved from requirements gathering to deployed stage with end users and involved in documentation as per standards.
• Creating the Report studio reports as per the user requirements
• Created the models and packages for report studio, Query Studio and analysis studio.
• Created the standalone and embedded filters in models and summary, detailed filters in the reports.
• Created and implemented the drill through reports with various aspects as per the requirements.
• Auto-cascading of Value prompts without having to do a page refresh is implemented in the report studio.
• Reviewing the model and reports design as per company Standards.
• Working on long running reports and failure reports in production, and involved in performance tuning of the queries.
• Installing and Configuration of Cronacle objects for the automation of the jobs.
• Monitoring the cognos tool availability by topaz and taking appropriate action in case of any issues.
• Coordinating with the architects and DBA for the performance tuning

Confidential

Cognos Finance report Developer & Administrator

Responsibilities:

• Interacting, analyzing with the users and gathering their business requirements
• Developing the scripts for loading financial data from different sources to the Target and then to cognos finance submissions.
• Documentation on the project as per the client standards.
• Installing and migrating cognos finance versions on need basis.
• Maintaining and monitoring the cognos web services in the web server machines.
• Creating the new cognos finance cubes and submission on need basis
• Co-ordinate with testing team and Involved in the unit testing, regression testing and UAT and prepare test plans.
• Tuning the queries which cause the performance of the huge data loads.
• Understand the Recasting process and work with the functional team to upload OP finance data in the cognos submissions
• Managing all the ETL and Reporting applications to ensure timely delivery in terms of data and data quality
• Designing and Developing the cognos financial reports and Input forms for the end users consolidation and recasting activity.
• Automating the Cube builds and ETL loads in the cronacle scripts.

Confidential

Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Developed workflows and mappings to extract the data from source to target
• Involved in Unit testing and prepared test cases and test plans.
• Installed and Configured Cognos 8 in windows and Linux servers.
• Deploying Cognos model and reports into different environments.
• Developing simple to medium reports in report studio.
• Creation of Simple and Cascaded prompts to filter data.
• Scheduling, monitoring the reports in Cognos Connection.
• Analyzing the business requirements, Report Mock-ups.
• Analyzing reports in respective to business needs

Confidential

Jr. Software Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Creating Reports for end users analysis.
• Created filters, calculations and conditions in catalog.
• Created various types of prompts by using prompt manager.
• Created the reports using different catalogs and folders as per requirement.
• Created list reports, Cross-tab Reports and Drill though reports.
• Created Models based on the dimensions, levels and measures required for the analysis.

Confidential

Jr. Software Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Creating Reports for end users
• Involving in the report testing and UAT
• Preparing the test cases for the reports.
• Create various types of prompts by using prompt manager.
• Created Models based on the dimensions, levels and measures required for the analysis.