Posted by on January 13, 19103 at 17:32:23:

ASHOK .D
Contact Details:
Email : duduruashok@yahoo.co.in
Home : + 91+ 80 + 3133198
SUMMARY:
· Over 4+ years of IT experience in diversified fields like Data warehousing & OLAP tools, Client/Server Technology as application software designer.
· Experience in Data Modeling, Data warehouse, Data Mart and OLAP for business analysis using Star & Snowflake schema.
· Experience in usage of COGNOS, INFORMATICA and Erwin tools.
· Good exposure to relational databases SQL, PL/SQL
· Have good knowledge of Backend tools like Oracle 8.0/9i.
· Exposure to Web Development, HTML, JavaScript.
· Possess excellent communication & interpersonal skills.
· Involved in the complete life cycle development process in the Data warehousing.

EDUCATION:
Bachelor of Engineering (Computer Science& Engineering)

TECHNICAL SKILLS

Data warehousing & OLAP Tools
COGNOS (Impromptu, Power Play, Transformer, IWR),
INFORMATICA Powermart 4.7.x. Upfront, Business Objects, Erwin, OWB,.
DataModelling Techniques : ER-Win, Dimensional Modeling
(Star-Join/Snowflake Designs)
RDBMS / DBMS : Oracle8.0/9i, MS Access, Fox Pro 2.6, Dbase, DB2,
SQL & PL/SQL.
Internet Platforms : Java1.2, JSP, JDBC 1.0/2.0, AWT, HTML/DHTML,
XML, JavaWebServer
O/S : DOS 6.22, Windows NT4.0/2000, and Unix.
Languages : C, Java, and VB6.0
Scripting Languages : Java Script, and VB Script.

PROFESSIONAL EXPERIENCE

Convergis Infosoft Ltd
Designation : Software engineer.

Hitachi Semiconductor (America) Inc, San Jose, CA Apr’02 – Tilldate
Description:
Project involves Design, Development, Implementation, Maintenance &
Production Support of applications for Open system database and Data Warehouse.
Internally developed custom data warehouse approaching 1 terabytes which is a
repository containing Sales data to support functions such as Backlog & Booking,
Forecast and Billing, HSA Summary, Reports for Sales Status, Management and
Sales Detail, Customer Ranking, Standard Reporting, Ad Hoc Reporting.

Responsibilities:
· Responsible for loading data into warehouse from different sources using SQL
Loader, Import/Export
· Responsible for Extraction Transformation and Loading of data into warehouse from distributed database systems using stored procedures and massaging of data using shell scripting regular expressions.
· Scheduling Data warehouse batch Jobs using Autosys Scheduler.
· Using shell scripts to automate data load into warehouse and data transmission shell scripts to automate data transmission to Japan and Malaysia.
· Designed and Developed Data Model(Star Schema) .
· Responsible for the Production Support (24/7) and User Support and Enhancement of all the systems.
· Responsible for interacting with business partners to identify information needs and business requirements for reports

Sales Tax Analysis . Aug’01 To Mar’02

Description:
This Project is to Build the Decision Support System for Tax department using the present Transaction Database.
The Heads of the Divisions of taxes dept are desirous of collecting various information pertaining to their Divisions. The information content varied from the number of registered Dealers to the taxes paid and their Commodity Dealt.
A lot of meaningful analysis is also carried out using the data. Some of the Sample reports were Tax paid by the dealers Divisionwise ,during particular period ,Top commodities,Top
Dealers for a range of periods etc.
Responsibilities:
· Identification of heterogeneous data sources
· Cleaning and filtering of data
· Design-staging tables and Mappings using Informatica
· Monitoring of Log files
· Proper scheduling of data
· Creating Reports for end users
· Understanding existing business model and customer requirements.
· Involved in designing Schema (STAR and SNOWFLAKE) for the business processes.
· Created the catalogs, tables, joins and folders for the users and managing & testing of catalogs with Cognos Impromptu.
· Created the reports using different catalogs and folders as per requirement.
· Slice and Dice Operations done for all OLAP applications.
· Drill Up/Down operations done for all OLAP applications
· Used Cognos Transformer to built multidimensional cubes and used it in Cognos PowerPlay to build graphs and charts of sales data for Sales and Marketing departments.
· Based on user requirement created a dimensional map using Cognos Transformer.
· Involved in performing Administrative tasks like user authentication, creating new users for the cube.
· Created Models based on the dimensions, levels and measures required for the analysis.
Environment : Oracle 8.0, Cognos Impromptu6.0, Cognos PowerPlay6.6,
Cognos Transformer6.6, IWR, Upfront, Informatica Powermart4.7, Erwin4.0, Unix and Windows NT.

Mafatlal Counsltancy Services Ltd, M.C.S, Bangalore Jan’01- July’01
(A complete subsidiary of O.R.I, inc, U.S.A)
Designation : Software engineer,
Title : Web Based Training & Certification Program
Client : Object Resource Inc., USA.

Brief Description
This project is referred as IAITPRO-CLARIENT Web Based Training & Certification Program. This is a Knowledge based product. This portal is to provide online Training, Certification in Software Engineering. It is in collaboration with International Association for IT Professionals; USA.IAITPRO is a On-line e-portal being developed for providing on-line training for organizations, corporate & individuals. This portal maintains the whole information about the latest software by which the client can be able to update the latest technologies in IT industry. The total portal is being developed in JSP, where the session of each user is created & tracked depending on which course he/she has to under go on-line. It uses third party software for on-line transaction through credit cards. The FTP server is used to maintain total courseware, which is used to download the courseware on the client system directly. It has many interfaces like chat page for on-line interaction with professors, discussions forms etc.
Environment: Java1.2, JDBC, Servlets, JSP, Oracle8i, JBuilder, HTML, Java Script, BEA WebLogic 4.5, and WindowsNT.

Kaashyap Radiant Systems Ltd., Bangalore May’00- Dec’00
A Joint venture with Radiant Systems Inc., NJ, U.S.A
Designation: Java & E-Commerce Consultant

Franchise Portal
Client : www.indiafranchisebiz.com

Description: Designed and developed a portal for companies that offer franchise to interested clients. The site lists the registered companies in alphabetical order and also provides search capabilities for site visitors based on several criteria like Category, Capital Investment and company name. The site offers automatic mailing service for the registered clients, these clients will be notified with the changes in the registered customers list. Discussion Forums are implemented to help clients post questions related to franchising and could get replies from either professional or other registered clients. Future plans include implementing online professional chat to allow registered clients talk with professional person regarding matters related to franchising.

Role: Designed the home page using HTML and AWT. Involved in developing the code on Java Script to validate the user input. Implemented the front-end using Java and JavaScript.
· Used Servlets to handle all forms sent to the back end.
· Involved in testing the Servlets using Web logic server

Environment: Java1.2, JDBC, Servlets, JSP, Oracle8.0, JBuilder, HTML, Java Script, BEA WebLogic 4.5, and WindowsNT.

Web Site Design and Deployment Sep’99- April’00
Client : Salians Industries Pvt. Ltd., Bangalore.
Description: Designed and deployed static web site for a major electrical components supply company. The web site provides current product information. Second phase of the project will involve supporting online selling of products to its partners and dynamic updates to inventory.
Role:
· Involved in design, development and testing of the various GUI to view the data.Involved in designing the documentation standards.
· Involved in quality control to review all standards
Environment: Java1.2, JDBC, Servlets, JSP, Oracle8.0, JBuilder, HTML, Java Script, BEA WebLogic 4.5, and WindowsNT.
Atharva Technologies(India) Pvt Ltd., Bangalore Nov’98- Aug’99
Designation : Software engineer,
Title : Electronic BookShop
Description
Involved in emulating a comprehensive bookshop on the net. The user is provided with various options of browsing and searching like search by author’s first name, last name, subject of the book etc. Finally the user can make payment on-line and get books delivered. Servlets, JSP, JDBC were used to develop this project. HTML and Java Script developed client side front end.
Role
· Designed the home page using HTML and AWT.
· Involved in developing the code on Java Script to validate the user input.
· Implemented the front-end using Java and JavaScript.
· Used Servlets to handle all forms sent to the back end.
· Involved in testing the Servlets using Web logic server
Environment: Java1.2, JDBC, Servlets, JSP, Oracle8.0, JBuilder, HTML, Java Script, BEA WebLogic 4.5, and WindowsNT.

Yours faithfully,

(D. ASHOK)