Manager Project
Resume:
Cognos BI Developer
Pooja Sharma
***, ** ********** **., *********, ON M9R 3L5
***********@*****.***
* ***** ** *********** ********** experience including 2 years as a Cognos BI & Oracle Developer. Skilled in understanding Business Requirements & developing simple to complex reports / DMR / cubes in Cognos. Experienced in developing back end procedures, functions in Oracle as well as creating Tables, indexes & constraints. Writing complex sql queries using joins, group by, case, sub queries etc. Good knowledge of datwarehousing concepts including Star Schema design & Inmon & Kimball methodologies.
KEY AREAS2+ years in Cognos & Oracle development.1 Year as Web Developer.Worked for Morgan Stanley through Keane Canada (now NTT Data Americas) Cognos Report, Analysis & Query Studio.Powerplay Transformer & creating – publishing packages.Developing Oracle sql queries using joins, sub queries, case, group by & decode statementsCreating tables, indexes & constraints in Oracle Creating procedures & functions in Oracle Pl / Sql.Managing network and administering Windows & UNIX servers.
CERTIFICATIONS / TRAININGTraining Course on Cognos Reporting Suite 8.4Working on Oracle Certified Professional certification OCPSun Certified Java Programmer (1.2) SCJPSun Solaris Administrator SSADMicrosoft Certified Systems Engineer MCSE
PROFICIENCY
Database : Oracle 10g/11g
BI : Cognos 8.4, Cognos 10
Scripting : PL-SQL / Unix Korn shell (ksh)
OS : Windows 2003 Server / Sun Solaris Server
EXPERIENCE
Mindzone Technologies Feb 2010 – May 2012
Software Consultancy Cognos & Oracle Developer
Project 1: Ranbaxy is a major pharmaceutical company selling drugs all over India- states & UTs. The vision of the Data Warehousing Project is to download the Sales, Returns, Physician Prescription, ROI of different drugs / lines / compounds data in the form of delimited files from the different regional sites and load the data into Oracle 10g Data warehouse, sending the scheduled & ad hoc reports to the all regions and creating the reports using Cognos Report Studio.
ROLE & RESPONSIBIITY:
Modified the existing model by adding required query items, query subjects and model filters to meet the report.Published Packages to Cognos Connection for report development using Report Studio and Query Studio.Created List Reports, Cross-tab Reports, Chart Reports and Master Detail Reports using Report Studio.Created Ad-Hoc reports using Query Studio.Created Multi Page Reports based on Master queries to show the data on different pages when the master record changes in the report.Created Query Prompts, Calculations, Conditions and Filters in the reports.Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.Experience in creating reports using drill-through and drill down functionalities.
Environment: Cognos 8 BI, Oracle 11G, Windows XP.
Project 2: Environment project for a Ministry of Environment, Pollution Control Board on Cognos 10 – Oracle 11G – Aimed at checking the pollution data of different vehicles and spending by Automobile Manufacturers in meeting the Euro 4 norms and the resultant reduction in pollution. Cognos 10 & Oracle 11g – created Data warehouse Tables, publish Framework Manager Packages & developed reports in Report Studio.
ROLE & RESPONSIBIITY:
Developing models & packages in Framework Manager.Participating in data model creation & back end procedures / functionsCreating & importing iqds from C7 for Analysis Studio and generating C8 cubes.Developing Reports – prompt based, cross tab. Created List Reports, Cross-tab Reports, Chart Reports and Master Detail Reports using Report Studio.Created Ad-Hoc reports using Query Studio.Created Multi Page Reports based on Master queries to show the data on different pages when the master record changes in the report.Created Query Prompts, Calculations, Conditions and Filters in the reports.Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.Experience in creating reports using drill-through and drill down functionalities. Created and published Cognos packages using Framework Manager and generated different kind of reports including templates, list, Cross-tab, Conditional Block List Query Studio & Report studio Analysis Studio.Developing models & packages in Framework Manager.Creating & importing iqds from C7 for Analysis Studio and generating C8 cubes.Developing Reports – prompt based, cross tab.
Environment: Cognos 7, Cognos 8, Cognos Impromptu, Power Play, Oracle 10G, Java Script, Windows XP.
Keane Canada Jun 2007– Dec 2007
Software Consultancy Consultant
Project: Morgan Stanley is a major financial client for Keane Canada. Project involved carrying day to day operations of Production System at Morgan Stanley. Job involved providing Tier 2 Support of Production UNIX server, noting & resolving incidents and escalating accordingly in a timely and SLA approved manner.
Interacting with the end users and noting down complete details of any UNIX incidents that occur.Investigating & resolving alerts at Level 2 per Net Cool. Meeting Batch Timeline. Getting approved through Team Lead.Escalating to a Tier 3 level Support as and when needed in accordance with the policies.Conforming to the SLA requirements.
Environment: Sun Solaris UNIX, Windows, Putty
NBRI Jan 2003 – May 2004
Government Lab Web Developer
Project: National Botanical Research Institute (NBRI) is a Government Research Lab under Council of Scientific & Industrial Research (CSIR) affiliation. Job involved creating, implementing and maintaining the web site of NBRI.
Creating the website using HTML, Java & Java ScriptCreating tables, procedures & functions in Oracle 9iMaintaining & enhancing the website per user feedback & requirement.Running reports and inquiries from the website & providing to the Management.
Environment: HTML, Java & Oracle.
EDUCATION
Diploma in System Management M Sc in Computer Science (1st Year) Bachelor in Commerce
Contact this candidate