Application Support

Anuradha .J anu.kapa@yahoo.com Ph.No:612-284-6463 Experience Summary: I am worked as a associate with Accenture for the last 17 months with a total of 3.2 years of work experience in Information Technology with strong knowledge and expertise in Development and Implementation of state of the art, Business Intelligence & Data Warehousing (BI/DW) technologies. I have worked primarily on Banking and Sales domains. • Good Experience on OLAP tools like Cognos 8.4, Cognos Report net 1.1 in Business Intelligence environment. • Developed OLAP applications using Cognos Report net, Cognos 8.4 BI Tools, with extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units. • Good Knowledge with Framework Manager, Cognos Connection, Report Studio, and Query Studio tools of Cognos 8.4 and Cognos Report net. • Good knowledge on Sql Server Database. • Having Knowledge in Data Warehousing concepts. • Good exposure on communication and Interpersonal skills which provide me with the ability to interact with clients, Team Members, Technical and Personal Managers. • Having good hardworking and result oriented as an individual and in a team, Self- motivated, willing quickly to learn and adapt to new technologies, ready to mobile nature. Technology: OLAP Tools : Cognos 8.4, Cognos Report net 1.1. Database : Sql server. ETL Toll : Informatica 7.1.1. Operating System : Win 2003 Server, XP. Career Profile: • Currently worked as a Accenture Services Pvt Ltd, Mumbai, Through Hall yard technologies as a “Associate” since Jan 2009 to May 2010 • Worked as a “Cognos BI Consultant” for Patni Computer Systems, Through hall yard technologies Bangalore Since Apr 2007 to Dec 2008 Qualifications: • B.Tech in Civil Engineering from Nagarjuna University. Project #1 Title : Transport Management Systems (TMS) Client : ANHAM (www.anham.com ) Environment : Cognos 8.4, Sql server, Windows XP Client Description: ANHAM is a leading contracting firm with projects throughout the Middle East and North Africa ("MENA"), South and Central Asia, and Europe. ANHAM is headquartered in Dubai, UAE. The company's offices across many regions specialize in providing local support and services to its initiatives, projects, and investments across the globe. This structure ensures that ANHAM has the ability to deliver products and services around the world - efficiently, effectively, and economically. ANHAM and its affiliates combine manufacturing, trade, contracting, and logistics entities; ANHAM has also provided for the security of goods, services, and personnel in order to complete contracts with a documented record of success. Responsibilities: • Designed various types of reports according to end user requirements. • Understanding the DLD’s for report development. • Created Lists and Cross-tab reports. • Applied advanced formatting features to the reports using Query Studio and Report Studio. • Create different type of charts like Column charts and Bar charts. • Used Cascading prompts to design user friendly reports. • Created different types of prompts. • Designed Drill-through reports and Master detail reports. • Prepared the Issue Trackers. Project #2: Title : Financial Analysis System (FAS) Client : Development Bank of Singapore (DBS) (www.dbs.com ) Environment : Cognos 8.4, Sql server 2000, Windows XP Client Description Development Bank of Singapore (DBS) is a long term finance group, which is one of the successful banks of Singapore. Having large volumes of data, this bank had a need for making intelligent business decision based on data available in various branches across the country connected over a period of time; bank wants to have a tool, which will be useful to analyze the current business trends and to make predictions about the future business trends. Especially the bank is focused on getting the analytical information about target customer groups, loss making schemes, Season wise financial analysis etc. Responsibilities:  Designed various types of reports according to end user requirements.  Created Lists and Cross-tab reports with Drill-through functionality  Applied advanced formatting features to the reports using Query Studio and Report Studio.  Create different type of charts like Column charts and Bar charts.  Used Cascading prompts to design user friendly reports.  Created variables and applied conditional style and con text for highlighting the specific data.  Used Cascading prompts to design user friendly reports  Designed Drill-through reports and Master detail reports. Project #3: Title : Hospital Management Systems (HMS) Client : Kingston Hospital (UK) (www.kingstonhospital.com ) Environment : CognosReportNet1.1, Sql server, Windows XP Client Description: The hospital, which is located on one site in Kingston, serves approximately 320,000 people in Kingston and other parts of South West London. The Trust provides a full range of diagnostic and treatment services and focuses on innovative developments in healthcare, particularly in 'patient-focused' care, day surgery and maternity services This Hospital Information system is purely meant for giving valuable information for the qualitative maintenance of any corporate hospital. This HMS includes five modules, which covers almost all the activities of the hospital. In detail it covers from the patient to ambulance. The main modules are patient, labs including lab inventory, pharmacy including pharmacy inventory, scheduling and maintenance. In patient module we covered lab tests, pharmacy, prescriptions, operations, activities, bed allocation etc. Responsibilities:  Extensively developed reports as per the business requirements.  Developed simple as well s complex reports using report studio.  Applying different functionalities like filter prompts to retrieve relevant data from the database.  Created Simple, medium and complex reports.  Creation of drill-through and master-detail reports.  Developed complex functionalities like conditional formatting and conditional display using conditional explorer.  Involved in scheduling the reports.  Created reports with value and search prompts and headers.

Application Support

Hopkins, MN