Manager Data

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

Hillsboro, OR 97124.

Email: **********@*****.*** Mob: 971-***-****

Professional Summary

• 8 Years total IT experience in Design, Development, Testing, Deployment, Troubleshooting, documenting Specifications, Support and Validation of Applications in Real Time Environment.

• 5 years of experience in Business Intelligence(BI) Applications like Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps)/SAP Business Objects 4.x(SAP BO), CMC, WEBI, DESKI, IDT.

• 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, Data Mining and analytics specialization in the areas of Data Warehouse(DW) and Business Intelligence(BI).

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

• Expertise in creating rich interactive graphics and data visualization of business-critical reports, dashboards & KPI’s.

• Expertise in designing, developing and managing the BusinessObjects Universes and OBIEE repository.

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

• Expert knowledge and experience in Java, PHP, C, C++, OOD, Oracle 12c/11g/10g, mySql, SQL, PL/SQL.

• 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(SDLC), Software Testing Life Cycle (STLC), Agile and Scrum methodology. 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 adapt to new changes and ability to work both individually and with 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(CMC), Central Management Service(CMS), 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 12c/11g/10g, SQL, DDL, MS-Access 2005, mysql, NoSQL,MS SQL server

• 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 – OBIEE: (Feb’11- Feb’17)

Platforms used: OBIEE 12c/11g, OBIEE repository manger, OBIEE Catalog manager, OBIEE Console, OBIEE EM, Oracle warehouse builder(OWB), Web Logic Server, Oracle 12c/11g/10g, SQL, PL/SQL, SQL* Plus, Unix, Windows 7, SQL Developer, ERwin 4.1, HTML, CSS, javascripts, Agile, SOAP webservices. Summary: The projects involved creating various business intelligence solutions for many departments in university like 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 data from various sources and then consolidating them at the report/dashboard/KPI level. Roles and Responsibilities:

o Data modeled business requirements gathered from Business Users, Department heads and Managers. Also optimized data models for better performance and implementations like Star and Snow-Flake Schema models. o Designed, developed and implement a series of ETL processes to populate data in to the Data warehouse(DW) and Data Marts.

o Worked in transferring data from multiple sources (Oracle, Flat files, MS access/excel, mysql, SQL server) to multiple targets.

o Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, measure objects, Alias and Extension tables. o Configured and created OBIEE Repository, involved in designing of physical, BMM, and presentation layers of metadata repository using OBIEE Administration Tool. o Created mappings as per the business requirements using Transformations like Lookup, slowly changing dimensions, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy. o Extensively worked with performance tuning of mappings, sessions and stored procedures. o Involved 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 and Maintained MDM. o Work closely with business users in designing reports, dashboards and KPI’s and suggested better ways of reporting in OBIEE so that the required information is better visualized by end users. o Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services. o Customized 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. o Managed security privileges for each subject area, dashboards, groups and roles according to user requirements. o Experienced in Unit and System testing by building Test Scripts and involved in UAT testing with Business users. o Designed, Created and Implemented KPI’s using BI Publisher. o Prepared Technical design, Source to target (S2T), Review checklist and Technical Specifications documents. o Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository. Created script in linux to take a backup of catalog and RPD file at the end of every day. o Implemented skins, styles and usage tracking in OBIEE 11g. o Developed and monitored Incremental & Full load through DAC. o Responsible for migrating repository and catalogs from Development to Test and production Environments o Worked in production support and seen through the phase of the developments in the production and done various bug fixes during ETL run and dashboard implementation.

Senior BI Analyst - University HR Data Management SAP BO (SAP Business Objects): (Jun’ 14 – Feb’17) Platforms used: Oracle 12c/11g/10g, PL/SQL, SQL, SQL Developer, UNIX, SAP BO 4.x - Information Design Tool(IDT), BI Launchpad, Web Intelligence(WEBI), Web intelligence Rich Client, Central Management Console(CMC), Central Management Service(CMS), Import Wizard, Promotion Manager, Report Conversion Tool, Desktop Intelligence(DESKI), SQL*plus, Agile.

Roles and Responsibilities:

o Worked with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports. Established effective working relationships with cross teams to ensure timely delivery of services. o Responsible for Designing, Modifying and Building of Universes, Classes, Measures, Prompts and objects in Business Objects Information design tool. Generated various Analytics Reports using global, local filters, multiple queries and combined queries in WEBI.

o Analyzed all tables and created various indexes to enhance query performance working with DBAs. o Responsible for generating and developed different type of reports on request, Ad-hoc, Summary, Sub Reports, Tabular, dynamic grouping, Cross-Tab, Drill down reports, Graphical reports with drilling capabilities in tables, complex calculations, Variables, Breaks, Sorting, Parameter prompts and Alerts using WEBI/DESKI. o Created cascading List of Values (LOVs) for better understanding of prompts by the end users. o Set up conditions to restrict data based on report requirements at Universe level and Object level security in the CMC. Created Periodic reports: daily report, weekly, monthly and annual reports, till and employee reports. o Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes. o Validated and exported Universes to Repository for making it available for users. o Trained the users on the Ad Hoc reporting and on navigating the Business Objects tools. o Created Derived tables and Aggregate tables to enhance the SQL performance of the universe. o Involved in the troubleshooting of universe schema with loops, fan trap, chasm traps and cardinality problems using Contexts and Aliases.

o Administered, Maintained and Managed SAP BO security, services, folders, groups, roles and user profiles using SIA, CCM and CMS.

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, mySql, SQL, Java, PHP, HTML, XML(XMLDOM), JSON, RESTful, SOAP, JavaScript 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 o Responsible for coding, testing and documenting various packages, procedures, and functions for libraries. o Application Management (Bug identification and fix, Testing, Release, Future Proofing, Risk analysis). o Provided support to develop customized discoverer reports and technical specification documents. o Used SOAP and webservices to extract data for QMP server. 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, PL/SQL, SQL, Oracle 10g. Roles and Responsibilities:

o Supported Banking and Trade applications 24/5, adapting changes and satisfying the client requirements. o Troubleshooting the applications and fixing the issues immediately for the customers with ITIL methods. o Enhanced 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 to peers regarding Existing Errors((Known – Error Database) and client application 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), MVC, JSP, Servlets, HTML, XML, CSS, JavaScript, AJAX, Oracle 10g, PL/SQL, SQL, Java, J2EE, RMI, UNIX, Tomcat, WebSphere, Toad. Roles and responsibilities:

o Worked on SDLC including Designing, Developing, Testing, debugging, configuring, deploying and documenting multiple new and existing modules using Java, J2EE(Struts), HTML, XML, PL/SQL, CSS, JavaScript. o Developed Authentication for templates using RAS algorithm. Used RMI technologies to bring FOREX (FX) rate from the server located in UK.

o Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML. o Trained resources on the Client Applications and Exhibited excellent problem solving and troubleshooting skills. o Performed Technical Reviews and configuration Control activities and supported SIT, UAT and Production o Prepared Functional, Technical specification document, preparing manual for the users and Test Strategy for the Testing Unit. Involved in Release Engineering work with UNIX boxes. 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 Practitioner.

• Strong supporter of Athena SWAN (Scientific Women’s Academic Network).

• 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, CMS, IBM Cognos, Tableau, WebSphere, UNIX, C, C++, ITIL, XFW Framework

(Standard Charted Bank Framework), SQL Server 2005, SAP HANA(NoSQL).

Contact this candidate