Sign in

ETL,BI,OBIEE,SAP BO,Data Modeling,report writing,dashboard design, KPI

Portland, Oregon, United States
August 29, 2017

Contact this candidate

Ashwini Munuswamy Tummala **** NW Overlook Dr Apt 411,

Hillsboro, OR 97124.

Email: Mob: 971*******

Professional Summary

* ***** ***** ** ********** in Design, Development, Testing, Deployment, Troubleshooting, documenting Specifications, Support and Validation of Applications in Real Time Environment.

5 years of experience in Business Intelligence Applications like Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps)/SAP Business Objects 4.x.

Expert knowledge and experience in Java, PHP, C, C++, OOD, Oracle 11g/12c, mySql, SQL, Ms Access and VB 6.0

Expertise in Client and Server side technologies HTML, CSS, DHTML, XML, XSLT, Java Script, UNIX, JSP, ASP, J2EE, AJAX and RMI.

Expertise in ETL process to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.

Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data models. Data conversion, Data cleaning, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.

Experience in creating entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema.

Expertise in creating business critical reports, dashboards & KPI’s with excellent visual representation of data.

Multi-Role Release Engineer for many Application projects writing Technical Specifications, Functional Specification Documents, Project Estimations, Unit Tests, and Manuals after the release.

Strong Implementation knowledge of OOAD, UML Design Patterns, Software Development Life Cycle, Agile environment and Scrum.

Personal Strengths

Excellent communication, leadership, interpersonal skills with good listening and analytical skills. Extensive technical skills incorporating computer literacy and Engineering discipline. Consistent capacity for hard work, flexible to adapted to new changes and ability to work both individually and in cross functional teams.

Education Profile

Master of Advanced Computer Science (MSc) University of Sheffield, UK (Sep’09-Sep’10) Result: 2:1

Bachelor of Information Technology (B.Tech) Anna University, India (July’03-April’07) Result: Distinction

Technical Expertise

Languages: Java, PHP, Python,C, C++, UNIX Scripting, SQL and Visual Basic 6.0(VB)

Technologies: RMI, AJAX, J2EE, Java Servlets 2.3, JSP 1.2, ASP, XML, XSLT, HTML, CSS, DJTM, Java Scripts, Webservies.

BI : OBIEE 11g/12c,OBIEE Repository builder, BI publisher, OBIEE Console,OBIEE Enterprise Manager(EM), OBIEE Catalog manger, Oracle Warehouse builder(OWB),IBM cognus, SAP BO 4.1 - Information Design Tool(IDT), BI Launchpad, Universe Design Tool, Web Intelligence(WEBI), Web Intelligence Rich Client, Central Management Console, Promotion Manager, Report Conversion Tool, Desktop Intelligence(DESKI).

IDEs, Tools & Framework: Myeclipse, WinCVS, WinSCP, Toad, PM Smart, Rational Rose, JXplorer, EMacs, Matlab, Netbeans, JEdit. TWiki, Microsoft Visual C++, XFW Framework (struts framework), Erwin,PL/SQL 10.0.5, Putty,SQL developer, MS Office, Visio,MS Office 365, MS-Project 2000’s, SQL* Plus, Oracle designer, SQL*Loader,SVN.

Web Server &Testing Software: Web Logic Server, Apache Tomcat 6.0, IIS SOAPUI Pro, LoadUI Pro.

Database: Oracle 9i/10g/11g/12c, SQL, DDL, MS-Access 2005, mysql.

Operating Systems: UNIX, LINUX, Windows 2000’s, Windows visa, Windows XP.

Work Experience:

University of Portsmouth, UK (Senior Application Developer) (Feb 2011 –Feb 2017)

Senior BI Analyst – Business Intelligence: (Feb’11- Feb 2017)

Platforms used: OBIEE 11g/12c, OBIEE repository manger, OBIEE Catalog manager, OBIEE Console, OBIEE EM, Oracle warehouse builder(OWB),Web Logic Server, Oracle 11g/12c, SQL, PL/SQL, SQL* Plus, Unix, Windows 7,SAP BI 4.1- Information Design Tool, BI Launchpad, Universe Design Tool, Web Intelligence, Web Intelligence Rich Client, Central Management Console, Promotion Manager, Report Conversion Tool, Desktop Intelligence.

Summary: The projects involved creating various business intelligence solutions for many departments in university like HR, Marketing, Dentistry and Academic Register. It enabled organization to develop and influence more intelligent business decisions, improve overall profitability, introduce new performance based KPI's for budgeting, marketing, and forecasting, by comparing and contrasting data from various sources and then consolidating them at the report/dashboard/KPI’s level.

Roles and Responsibilities:

oData modeled business requirements gathered from Business Users and Managers and optimization of data models for Business Intelligence implementations like Star-Schema and Snow-Flake Schema.

oDesigned and developed a series of ETL processes to populate data in to the Data warehouse .

oDesigned Schema/Diagrams using Fact, Dimensions, Physical, Logical, measure objects, Alias and Extension tables using OBIEE/SAP IDT

oConfigured and created OBIEE Repository, involved in designing of physical, BMM, and presentation layers of metadata repository using OBIEE Administration Tool.

oCreated mappings as per the business requirements using Transformations like Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy.

oExtensively worked with performance tuning of mappings, sessions and stored procedures.

oInvolved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes. Developed UNIX scripts to automate chronological loads. Maintained MDM.

oBuilt Business model and established relationships & Foreign Keys Physical & Logical between tables.

oWork closely with business users in designing reports, dashboards and KPI’s, suggested better ways of reporting in OBIEE/Web Intelligence(WEBI) so that the required information is better visualized by end users.

oDeveloped Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.

oCustomized users, groups and assign privileges for the users to access the data from the warehouse in web logic console of OBIEE 11g.Setup Multi User Development Environment (MUDE) in OBIEE.

oManaged security privileges for each subject area and dashboards according to user requirements in OBIEE.

oDesigned, Created and Implemented KPI’s using BI Publisher.

oPrepared Technical design, Source to target (S2T), Review checklist and Technical Specifications documents.

oInvolved in analyzing, documenting business requirements, functional requirements for developing universes and reports. Established effective working relationships with cross teams to ensure timely delivery of services.

oInvolved in the Designing, Modifying and Building of Universes, Classes, Prompts and objects in Business objects Information design tool.

oValidated and exported Universes to Repository for making it available for users .

oGenerated various Analytics Reports using global and local filters in WEBI.

oResponsible for generating and developed reports on request, Ad-hoc, Summary, Sub Reports, dynamic grouping, Cross-Tab, Graphical reports etc using WEBI/DESKI.

oSet up conditions to restrict data based on report requirements at Universe level and created Derived tables to increase the performance of the universe.

oInvolved in the troubleshooting of universe schema with loops, fan trap, chasm traps and cardinality problems using Contexts and Aliases . .

oAdministered, Maintained and Managed SAP BO security, services, groups and user profiles.

oSetting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.

oMonitoring Incremental & Full load through DAC.

oWorked in production support and seen through the phase of the developments in the production and done various bug fixes.

Enterprise Architecture UI designer for Residential Management System: (Feb’12 -Oct’12)

Summary: Collaborated with Product Development group to design highly interactive, data-intensive web applications for Halls and inventory management system. Acted as a liaison between technology team, customers and subject matter experts to establish requirements and determine user needs.

oDefined navigation, user workflows and layouts focusing on usability.

oDeveloped wireframes, interface mockups, page prototypes using Axure and data model using oracle data modeler. As a part of this project produced an excellent solution oriented report on password management applications by making a high level research on products available in market to help business make decisions.

QMP Integration: (Apr’11- Oct’11)

Summary: Designed, Developed and implemented to integrate information systems to increase process efficiency and reduce administrative overheads using Agile development methods.

Platforms used: Oracle 11g, Java, PHP, HTML, XML(XMLDOM).

Roles and Responsibilities:

o Developed an automated solution to integrate the university databases and QMP (Assessment tool) database with improvised database performance. Enabled a single sign –on by collaborating with LDAP

oResponsible for coding, testing and documenting various packages, procedures, and functions for libraries and stored procedures, which were commonly used by different modules.

oApplication Management (Bug identification and fix, Testing, Release, Future Proofing, Risk analysis)

oProvided support to develop customized discoverer reports and technical specification documents

HCL Technologies Ltd, India (Software Engineer) (June’07 - Sep’09)

GODOT Applications and CPD RANREC Applications (Production support: (Apr’09-Sep’09)

Platforms used: VBA, Ms Access, Oracle 10g.

Roles and Responsibilities:

oSupported Banking and Trade applications 24/5, adapting changes and satisfying the client requirements.

oTroubleshooting the applications and fixing the issues immediately for the customers with ITIL methods.

oEnhanced the existing applications as per client requirements and Testing in multiple levels for damage control of the issues in real environment. Given Knowledge Transfer Sessions and documents to peers about the Applications, Business, Existing Errors in the application ((Known –Error Database) and Technical aspects as a primary resource for GODOT and CPD RANREC applications.

American Express Bank Phase II Channels Integration CR(AMEXCO),(Developed) (Dec’08–Apr’09)

IBAN Validation (Sep’08–Dec‘08)

AEB CHANNELS INTEGRATION –Quick Payments (Dec‘07–Sep’08)

Summary: Designed, Developed and implemented the IBAN validation functionality, Bank Search utility,Quick Payments, mobile banking for corporate banking, template migration and created a new concept called locks for Standard Chartered Bank payments and Inquires.

Platforms: XFW Framework (Struts based), JSP, Servlets, HTML, CSS, Java Scripts, AJAX, Oracle 10g, Java,, RMI, UNIX, Tomcat.

Roles and responsibilities:

oDeveloped multiple new functionalities - Quick Payments Summary Screen CR, “Template ID” in Bulk Import, Creation of Default Payment Type and Account to avoid File Rejection.

oDeveloped Authentication for templates using RAS algorithm. Used RMI technologies to bring FOREX (FX) rate from the server located in UK.

oPerformed Technical Reviews and configuration Control activities and supported SIT, UAT and Production

oPrepared Technical specification document and Test Strategy for the Testing Unit.

oInvolved in Release Engineering work with UNIX boxes and involved in Technical writing, writing about the project and preparing manual for the users.

oDone Unit Testing and Code Reviews for the functionalities and coding standards of banking environments.

Academic Projects

Analyzing and Investigating ‘The National Archives’ Query Logs(UK Government Archives) :

Investigated the transaction logs in three stages of user’s session pattern, term, and query analyses and analysed using Jansen’s Algorithm. Migrated data using Java from Microsoft IIS 6.0 server to relational MySQL Database

Crime City-A Serious Game:

Modelled the behaviour of the crime game using FLAME GPU framework, developed in C.

Online E-journal Web Application and Client/Server Communication using RMI(Diffie-Hellman Key Exchange algorithm):

Developed with the MVC Architecture using HTML, JSP, J2EE, CSS, javascript, and javaservlet in the presentation layer and SMTP for E-Mail communication. Business layer was developed using Java Beans and MYSQL database was used for the database layer.

Certifications and Training

Certified by SUN Microsystems as SUN Certified Java Programmer 1.5 (SCJP 1.5).

Certification in banking-Indian Institute of Banking and Finance (IIBF) and ITIL.

Attended Training in Oracle 10g,SQL tuning, Dimensional modeling, BI Data visualization, Oracle Warehouse Builder, OBIEE administrator,OBIEE repository, OBIEE dashboard design, SAP business objects Universe Design Tool and administrator tools, WebSphere, UNIX, C, C++, ITIL, XFW Framework (Standard Charted Bank Frame Work), SQL Server 2005.

Contact this candidate