OBJECTIVE

• Pursuing a challenging career as a Sr. Data warehouse analyst/architect and TM1 techno consultant wif 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 wif 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 wif 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 wif teh Big Data environment and extract teh reports to cognos form Hadoop file system using HIVE.
• Experience in automating job chains and scripts using cronacle schedulers for teh 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 wif minimal supervision by analyzing and interpreting teh data.
• Ability to communicate verbally and written wif 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 teh framework models and prepare design documents related to teh data model and reports design
• Worked on teh DMR model and implemented to simplify teh process and using various cognos tools.
• Designed and documented teh cognos jobs activities and report delivery time frames based on several ends users.
• Worked on teh active reports methodology which is new feature added in cognos and trained functional users.
• Developed teh complex reports and burst teh bunch of report outputs via email to teh respective stores and supported teh end users using month end and quarter end closing periods.
• Worked on teh Hadoop file systems and reporting using teh HIVE concept in cognos reports (POC).
• Auto-cascading of Value prompts wifout having to do a page refresh is implemented in teh report studio.
• Dynamic Sorting capability is successfully deployed on a List Report.
• Involved in requirements gathering wif end users and involved in documentation as per standards.
• Created teh models and packages for report studio, Query Studio and analysis studio.
• Created teh standalone and embedded filters in models and summary, Detailed filters in teh reports.
• Created and implemented teh drill through reports wif various aspects as per teh requirements.
• Reviewing teh 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 teh queries.
• Coordinating wif teh architects and DBA Performance team for teh performance tuning

Confidential, Los Angeles, CA

Sr. Cognos Report developer

Responsibilities:

• Creating teh professional reports and Dashboards in cognos as per teh user requirements
• Worked on teh DMR model and implemented to simplify teh process and using various cognos tools.
• Worked on teh active reports methodology which is new feature added in cognos and trained functional users.
• Worked on teh Hadoop file systems and reporting using teh HIVE concept in cognos reports.
• Auto-cascading of Value prompts wifout having to do a page refresh is implemented in teh report studio.
• Dynamic Sorting capability is successfully deployed on a List Report.
• Involved in requirements gathering wif end users and involved in documentation as per standards.
• Created teh models and packages for report studio, Query Studio and analysis studio.
• Created teh standalone and embedded filters in models and summary, Detailed filters in teh reports.
• Created and implemented teh drill through reports wif various aspects as per teh requirements.
• Reviewing teh 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 teh queries.
• Coordinating wif teh architects and DBA Performance team for teh performance tuning

Confidential - Milwaukee, WI

Sr. Cognos Report developer

Responsibilities:

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

Confidential

Sr. Cognos Developer

Responsibilities:

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

Confidential

Cognos Finance report Developer & Administrator

Responsibilities:

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

Confidential

Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Developed workflows and mappings to extract teh 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 teh reports in Cognos Connection.
• Analyzing teh 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 teh reports using different catalogs and folders as per requirement.
• Created list reports, Cross-tab Reports and Drill though reports.
• Created Models based on teh dimensions, levels and measures required for teh analysis.

Confidential

Jr. Software Developer

Responsibilities:

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