Resume of RAMAKRISHNA KADUSUMALLI SUMMARY OF QUALIFICATIONS: · Over SIX years of experience in information technology industry with a strong background in analysis, design, development & testing (full project lifecycle- Which includes Systems analysis and Design, processes and techniques, data warehouse/data mart design, writing/modifying technical and user documentation, data modeling techniques, installation, migration, Construction, Software quality assurance and testing). · Over FOUR years of continuous experience in the field of Data warehousing and Business Intelligence reporting Technology with a special emphasis on ETL & Business Intelligence tools using Cognos Impromptu, Powerplay Transformer and Power Play. · Extensively worked on Transformer for Data modeling of the corporate Data for building up Multi dimensional cubes. · Maintaining & Administering advanced OLAP Tools such as Cognos Powerplay and Impromptu Reports. Created Macros using Cognos Script editor (Cognos script) for automating reports and authenticating reports. · Involved in the implementation of Impromptu 5.0/6.0/7.1, Powerplay 6.0/6.6/7.1. · Worked with Business Users to analyze the business process and made necessary. TECHNICAL SKILLS: Operating System: Windows NT, Windows 98/2000, UNIX, Solaris 8. OLAP/ Business Intelligence Tools: Cognos (Impromptu 7.1/6.0, Impromptu Web reports (IWR), Power Play 7.1, Tranformer 7.1, Powe Play Enterprice Server 7.1, Schedular 7.1, Access Manager 7.1, Query, Cognos Shuttle Builder), Business Objects 5.1.2, Supervisor, Designer, Broadcast Agent. ETL tools: Informatica PowerMart 5.1/5.0/4.7, Informatica PowerCenter 5.1/5.0/1.7, Cognos Decision Stream 6.5. RDBMS: Oracle 8i, MS SQL Server 2000/7.0, MS Access. GUI: Devoloper 2000 (Forms 5.0 and Reports3.0, Visual Basic 5.0, Crystal Reports. Languages: Visual Basic 6.0.SQL, PL/SQL, C, C++, JAVA, HTML, ABAP/4. Server Applications: IIS Server 5.0/4.0, NIS, IPlanet 4.0, Netscape Dierctory Server 4.0, Windows 2000 ActiveDirectory. PROFESSIONAL EXPERIENCE: Oct ‘02 – Present ChartOne CA ChartOne is the healthcare industry's most complete solution for automating the entire patient chart management process. ChartOne is helping more than 1,400 healthcare organizations across the United States reduce the complexities of the chart management process. In order to provide critical information on Key Performance Indicators like profit, expenses, delinquency and MI rates to Business Executives ChartOne has developed Business Intelligence System based on Cognos suit of products. Functionality includes, study, design and upload of the data warehouse. As a part of project, Catalogs and reports are created for Sales functions. That included creation of reports using slice & dice, drill down features, developing of cross-tab reports etc. Also used Web to deploy the reports over Internet. Responsibilities: · Developed Multi-Dimensional Cubes using Powerplay Transformer 7.1. · Developed Reports in Cognos Impromptu, Powerplay and Impromptu Web Reports (IWR). · Involved in Installation of Cognos Tools. Designed and developed various types of Reports (3D Bar, Pie Chart, Impromptu Reports and OLAP Query Reports). · The whole reporting was done using Impromptu.The reporting was quite complex to implement and required to use all the features offered by Impromptu. Various features like Prompts, Query Filters, Chart Frames, List Frames, Form Frames, etc. were used. · Optimized the Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings. · Used the Client/Server option for User Profiles to balance the Client/Server load with the database. · Automating tasks with Cognos Scheduler, CognosScript Editor and CognosScript Dialog Editor. · Involved in all aspects of impromptu, from connecting to the corporate database to setting up effective catalogs, joins, folders, and filters, to ensure that adequate security procedures are in place. · Used Governors settings to limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve, to limit the number of tables a user can retrieve in a report and to limit the query execution time for different User Classes. · Developed and used Stored Procedures to transfer processing load to the backend server. · Created Snapshots to minimize data processing when the network traffic for the database is heavy. · Setting up appropriate User Class and security for the different groups of people who use the catalogs. · Associate Impromptu Reports to drill through from one report to another. · Connecting to the database by setting up open database connectivity (ODBC). · Coordinated in end user training. Documented the whole process. Environment: Cognos Impromptu 7.1, Impomptu Web Reports 7.1, PowerPlay 7.1, Transformer 7.1, Oracle9i, UpFront7.1, CognosArchitect7.1, CognosQuery7.1, PL/SQL, FTP, ODBC, MS Access and Solaris 8.0. Feb ‘02 – Sep ‘02 Johnson & Johnson NJ Johnson & Johnson is the world's most comprehensive and broadly based manufacturer of health care products, as well as provide of relatedservices,. In order to provide critical information on Key Performance Indicators Developed various kinds of reports for Financials, Reimbursement, Sales, Product Line like Accounts Payable/Receivable, Invoices Pending/Dues, Sales Quarterly/Monthly/Yearly, Month End process reports, Sales, Sales on Pending, Customer Reactions, Invoices Pending, Gross Income, Reimbursements. Responsibilities: · Interacted with business people for gathering the business requirements · Designed and developed Catalogs, Impromptu Reports, IQDs. · Drill down, slice and dice and change displays. Changing filters, layers and measures. · Data retrieval, Multidimensional analysis, Power Play structure. · Reporter Operations such as Sum and Average, Intersection, etc. · Exception Highlighting, Sorting, Ranking etc. Created Multi-Dimensional reports using Power Play. · Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using Powerplay reports. · Provided various management levels with reports, time series graphs and pie charts using Powerplay cubes. Designed and maintained catalogs. · Customized data by adding calculations, summaries and functions. · Queried from different database tables as per the requirement. · Using Portfolio, reports were presented Created List Reports and Cross Tab Reports and Drill Through reports. Created the Business Mix report and Top Ten reports. · Generated reports using Cognos Impromptu tools querying database. · Created reports in HTML format for easy navigation of data from web browser. · Created standard and Ad hoc reports using Cognos Impromptu tool. · Some reports have to be ported from Business Objects. · Created Impromptu Web Reports (IWR) and published them in the webserver. · Involved in troubleshooting the report. Environment: Cognos Power Play 6.6, Cognos Impromptu 6.0, Transformer 6.6, Business Objects, Oracle 8.0, Cognos Architect, Impromptu web reports (IWR), PL/SQL, Oracle, SQL Server and Windows NT. Jun ‘01 – Jan ‘02 Best Buy PA The nation’s number one specialty retailer of consumer electronics,personal computers, entertainment software and appliances. The Company operates retail stores and commercial web sites under the names: Best Buy (BestBuy.com), Magnolia Hi-Fi (MagnoliaHiFi.com), Media Play (MediaPlay.com), On Cue (OnCue.com), Sam Goody (SamGoody.com), and Suncoast (Suncoast.com). The Company reaches consumers through more than 1,700 retail stores nationwide, in Puerto Rico and in the U.S. Virgin Islands. Best Buy needed an integrated business intelligence system that would provide both internal users and external partners and supply chain members with visibility into its business performance. Responsibilities: · Created Multi-Dimensional reports using Power Play. · Provided various management levels with reports, time series graphs and pie charts using PowerPlay cubes. Generated reports using Cognos Impromptu tools querying database. · Created reports in HTML format for easy navigation of data from web browser. · Created Impromptu Web Reports (IWR/HTML) and published them in the Web server. · Modified existing catalog using Cognos Impromptu. Extensively used Drill up/down, filter, Aggregators, Slice and Dice Operations for all OLAP applications. · Developed various types of reports such as Simple, Cross tab, Drill through, Sub reports etc. · Worked extensively on Cube optimization. Involved in troubleshooting the reports. Environment: Cognos Impromptu 5.0, Power Play 5.0, Transformer 5.0, Oracle 8.0, MS Access Win NT. Sep ‘00 – May ‘01 Healthcare Capital Resources New York The system has three modules Revolvers/Purchase and Term loans. The system was developed based on the financial support provided to the hospitals and providers. Loans are provided against the receivables submitted by the providers. Interest and fees are calculated on a daily basis. The interest and fees are charged monthly once on the first business day. Also the following reports are generated, initial funding report, Settlement report contract information and projected fund flow report. Responsibilities: · Design of catalogs, security setting and administration of the catalogs. · Created different joins according to User requirements. · Created multi dimensional cubes using Transformer. · Used Cognos Impromptu to generate various management reports like Initial Funding, Settlement Reports, Portfolio information, and client information. · Generated the PowerCubes for day, week, month, quarter and year wise multidimensional report analysis involving the cash receipts, settlements, outstanding and interests. · Involved in generating adhoc report generation for the clients immediate needs. · Involved in the end user training of the use of power play cubes and analysis of the reports. Environment: Cognos Impromptu 5.0, Powerplay 5.0, Transformaer Sserver,Windows NT/98, VB 6.0, SQL Server 7.0. Jan ‘99 – Aug ‘00 ECS Elitegroup Computer Systems, Inc Data Warehouse Analyst ELITEGROUP Computer Systems is a PC motherboard Manufacturing Company, manufactures 2.5 million mainboards and 500,000 barebone and system units per month in Taiwan/china having offices around the world. ECS-USA is a Super warehouse for North & South America. This Project involved in creating a Data Warehouse for sales reporting system. Data from ODS was extracted, transformed and loaded into data warehouse Using Informatica. This project to support the Business Objects applications that are in production, administering the BO activities, and granting the necessary DB access rights and privileges for the BO users. Responsibilities: · As a data analyst involved in design, development and maintenance of database for Data warehouse project. · Involved in designing the procedures for getting the data from all systems to Data warehousing system. · The data was standardized to store data from various Business Units in data warehouse tables. · Used Data Warehouse technique to design a Star-Schema. · Designed the ETL processes using Informatica tool to load data from MS SQL Server, MS Access and Excel spreadsheets into the target Oracle 8.0/8i database. · Created Source and Target Databases on Oracle 8i and SQL Server. · Analyzed and Created Facts and Dimension Tables. · Used Mapping designer and Mapplets to generate different mappings for different loads. · Used Power center Server Manager to schedule and monitor different sessions and batches of loading. · Wrote the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading. · Creating various Transformations like Joiner, Aggregate, Expression, Filter, update Strategy. · Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager. · Created test cases and completed unit, integration and system tests for sales data mart system. Business Intelligence Analyst As a Business Intelligence Analyst involved in design, development and maintenance of Business Intelligence server for analysis and reporting using Business Objects to support Sales & Marketing and distribution, finance Departments. Installed and configured Business Objects, Web Intelligence Server, and Broadcast Agent. Responsibilities: · As a Universe designer, Designed 2 Universe’s Created reports in BO reporter and exported to the repository. · Created the reports using Business Objects functionality like Combined Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail, Reports by Product, Reports by Customer, billing Detail report, Comparative reports, A/R ageing report, A/P ageing report, Vendor Ageing report, Receipt Detail report, Payment Detail Report, Sales report, Margin Analysis report, Invoice Detail report, Balance report, Distribution report, Inventory report. · Dynamic data passed in to reports using BO Prompts, Hiding some of the prompts and setting default values to prompts like Invoice, VendorID, Client ID, and Invoice Date etc. · Generated thin client web reports using Business Objects WebInteligence to popup in ASP. · Scheduled the reports using Broadcast Agent BCA for important financial reports for monthly run. · Trained the end users in working with the Business Objects user module and Web Intelligence. · Developed Models and cubes as required by the users. Environment: Informatica PowerMart/PowerCenter, (Source Analyzer, Data warehousing Designer, Mapping Designer, Mapplet, Transformations), ETL, Business Objects 4.1, Supervisor, Designer Broadcast Agent, Web Intelligence, Erwin, Oracle 8.i, MS SQL Server 2000/7, PL/SQL, Windows NT. Dec ‘97 – Oct ‘98 Athene Softech Pvt. Ltd India This application mainly describes to supply to internal requirements, as well as to the needs of client companies, the Igenesis consulting division collects potential candidate resumes. The collected details are maintained in a database from which a HR person can search the database by candidate name, skill set, location etc. Details of each candidate sent for interview to the client can also be tracked on parameters like company-wise, day-wise, number of attempts, skill sets etc. Statistical reports can also be generated in terms of number of in-house requirements fulfilled, client requirements fulfilled, most required skills, skill set with the most placements, least required skill set etc. Responsibilities: · Designed and developed module screens and tables. · Involved in the creation of Reports. Assisted in requirement analysis. · Conducted unit testing. Involved in developing and coding screens to Windows standards. · Created daily, monthly, yearly reports, functions and modules. · Involved in the design of database. Environment: Visual Basic 5.0, SQL Server and Windows 95. Apr ‘97 – Nov ‘97 Global Trust Bank India This software was developed for keeping track of checking accounts, saving account, Investment Information, generate reports, loan information, and for archiving the older transaction. Involved in the design phase and responsible for creating GUI interface for the Personnel information system Module. The system includes the software application tools development to convert data from dBase to Oracle and generation of reports by using Oracle tools. Responsibilities: · Involved in design, development and implementation. · Responsible for development of forms and interfacing the data selection from the database. · Created various GUI for the personnel Information System Module. · Assisted in developing reports on Branch turnover and profits. · Assisted in the Development of several reports including tabular, master detail, daily, weekly and monthly, using Reports 2.5. Environment: Oracle 6.x/7.x Forms 4.5, Report 2.5, UNIX, and Windows 95.