Ravi K.

Vaida Ravi Krishna No. 46, Ground Floor, Indraprasth Layout, Behind Ram Murty Nagar P.S Ram Murty Nagar Bangalore - 16 A dynamic professional with a 6 +yrs of IT experience developed from a solid background in IT Database Design, Data Modelling, ETL & Reporting tools, Worked extensively on Oracle, MySQL and Teradata with front ends like Business Objects and web. TECHNICAL SKILLS: Databases : Oracle 9i, Teradata, SQL Server 2000, MySQL MS Access Programming Languages : SQL, PL/SQL Tools : Business Objects / Crystal reports/Web-PHP Internet Technologies : HTML, Java Script Packages : Ms-office, Star office, SAP-Basis Operating Systems : Ms-Dos, Ms-Windows 2000 /2003 server, Linux /Unix Accenture Services Pvt. Ltd : Sep-07 onwards Client : WaMu Responsibilities • Designing the BO reports' Layouts. • Data modelling w.r.t Marketing Resource Management Implementation. • Data mart design as per the reports. • Universe design for the MRM reports. • Managing a team of 7members w.r.t. the team's activities, assigning tasks & deliverables. Wipro Technologies: Jan-07 – Aug-07 - Data warehousing Client: Intel Health Care: • Preparing a Data Model from an existing OLTP databases. • Identifying the different sources of Data. • Database Designing for new Warehouse deployment • Performance Testing with a set of Dummy Data Bharti Airtel: Team Leader for Data warehousing / OLAP -Nov 05 –Jan-07: • Creating universes, users, views, daily database updations by retrieving the data from various data sources as per the requirement of day to day Telecom business requirement. • Customizing new reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc. • Standardizing the reports by minimizing the manual intervention with the help of stores procedures & Packages. • Publishing new reports to the users from the central data warehouse. PROJECT DETAILS: Project Name : Revenue per sub/MOU/Pulse Role : Team Leader Duration : Sep -06 to Dec-06. – 4months Environment : Business objects, Oracle Team Size : 4 Description : To develop a platform where business heads & regional heads can monitor the performance of a region/area (eg Region->State-City-Zone-Area Manager-Account Manager) Responsibilities: Ø Identifying the Scope of the reports as per the respective region Ø Identifying the data sources required to generate the high level business performance report. Ø Synchronizing all the data sources (like Lotus notes, Arbor, CDR, Oracle Financials-GL) to load data in a single data warehouse with the help of an ETL-BO-Data Integrator. Ø Designing the database & Normalizing different tables into a standard data structure. Ø Due to heavy size of the databases of difference sources, table partitions have been used to enable quick processing of queries. Ø Merging different tables into a single materialized view to keep up the pace. Ø Implementing the business logic to calculate the revenue/mou per sub, of each region/area. Ø Developing a web portal where request for drill downs and analysis of the overall reports with a ticket id & expected solution in hours based on the category. Ø Creating Universes as per the required reports in BO with the help of Designer. Ø Creating users & granting access to use & publish reports thru BCA. Project Name : Revenue Analysis Role : Team Leader Duration : April -06 to Sep-06. – 6months Environment : Business objects, Oracle, Teradata Team Size : 4 Description : Post acquisition of a customer/account, the account has be tracked on daily for revenue usage-DEL & DSL. E.g. Oracle corporation will 1000 dels and to monitor the performance of that account some daily tracking of revenue is important to measure the growth in the business. Responsibilities: Ø Identifying main corporate accounts out of the entire sub-base of customers. Ø Segregating the accounts into classes as per the business requirement and depending on their revenue generation. Ø Automating the entire process of new corporate account acquisition & assigning the master code as per the respected group. Ø Data modeling & staging of the CDRs at regular intervals and there by loading to the database. Ø Cleaning the data as per the required format with the help of cursors on daily basis. Ø Designing the revenue analysis reports structure with the help of SQL queries & views. Ø Testing the reports in the business objects & there by releasing them to the users. Ø Publishing the reports with the help of BCA in business objects. Project Name : Sales & Marketing Reports Role : Team Leader Duration : Dec-05 to March-06. – 4months Environment : Business objects, Oracle Team Size : 4 Description : The system is developed to automate the entire process of reporting thereby helping top managers to watch sales online. This was created with the details of data related to sales Representatives-SAF-DEL & DSL, Billing & Credit Control-Arbor, and CDR & DSL Usage . Responsibilities: Ø Analysing business requirement and drill downs required for development of the project Ø Documenting the requirement and the database design Ø Designing table structures and materialized views for publishing the reports. Ø Staging the data for cleansing & accuracy from the production server to warehouse at a schedule time with the help of stored procedures & Business Object Data Integrator. Ø Designing the universes required to get the data in the desired format to get published. Ø Developing the reports in Business Objects using complex SQL queries & materialized views. Dalmia Consumer Care Pvt Ltd May-03 to Nov-05. Worked as Regional IT Executive for South - Oracle Database & SQL Developer Installing Oracle 9.2.0 at the central data warehouse and creating databases for daily Sales tracking Project Name : ERP Implementation Role : Regional IT Executive Duration : Feb-04 to Oct-05– 1yr 8months Environment : Oracle – VB . NET Team Size : 2 Description To develop an ERP which can track both primary & secondary sales upto the distributor level, online sales tracking, customer & payment tracking, stocks & delivery of stocks to the customers PROJECT DETAILS: Responsibilities: • Identifying the business logic for the ERP implementation. • Finalizing the project with the vendor • Preparing documents related to the business logic & the production • Interacting with the client to get the desired output within the specified time • Updating the client with the respective departments requirement • Preparing docs for the changes in the ERP • Writing SQL stored queries for the web based ERP along with vendor for final optimization with the database. • Tuning the ERP queries developed by client to generate correct output • Developing the web a web based application to track offline sales tracking with the help of Oracle & PHP. • Designing web based reports up to the least granularity. • Testing both web reports & ERP for production • Implementing the ERP at all 4 locations across south India. Project Name : IT Infrastructure Mgmt Role : Regional IT Executive Duration : Jun-03 to Dec-03– 6months Environment : Windows 2003 Server, Oracle, Linux Team Size : 2 Description To develop a new setup of IT infrastructure in entire southern region at four locations, with a capacity of almost 450 users. PROJECT DETAILS: Responsibilities: • Identifying the different locations & the respected no. of users. • Procuring hardwares – servers & LAN/WAN Implmentation • Vendor finalization for VPN Connectivity • Installing Windows 2003 server & Oracle 9i as database • Creating users and defining policies for database users. • Granting access to the different tables & creating views as per the requirement. Gillette India Ltd- SAP-ERP Implementation, Business Objects/Oracle 8i Aug 2000 to May-03 Project Name : SQL Developer Role : IT Executive Duration : Aug-03 to May-03 Environment : Windows 2000 Server, Oracle, Unix Team Size : 1 Description To support entire IT setup of Gillette at East zone • Maintaining IT infrastructure across East Zone with 380 users • SAP Implementation across East Zone with almost 120 users • Giving dump thru SQL queries to MIS team for daily business report • Understand the business requirement & fine tuning the sql queries. • Client Architecture, configuration and maintenance. • SAP-Business Objects training to all the users • Export the output in excel to the users to generate MIS reports. • Transporting data East zone related to the local server for faster access to Oracle • Daily updations in the database Mukund International Pvt. Ltd Aug’99 to Aug ‘2000 - Systems Administrator Responsibilities • Maintaining Active directory-creating users/LAN/WAN/TCP/IP • Windows NT server & Client Administration • Backup and recovery policies • Maintaining antivirus updates • Managing the data communication network of MIPL Environment Windows NT/ Win 98 / Microsoft Exchange Educational Qualification : Pursuing MCA from ICFAI University. [login to view URL] (Burdwan University, West Bengal) Personal Profile Date of Birth : 13th August 1976 Marital Status : Married Communication Skill : Good & Confident Working Nature : Hard Working & Flexible. Hobbies : Listening Music, R & D Languages known : English, Hindi, Telegu & Bengali Date: January 16, 2008 Place: Bangalore Ravi Krishna