Sales Manager

GOPI KRISHNA MAMIDI

Mobile: 510-***-**** Email: **********@*****.***

SUMMARY

Over 12 years of total IT experience in the Analysis, Design, Development and Implementation of Data Warehousing Systems using Business Objects, Informatica, Tableau, OBIEE, Teradata, SAP HANA, Oracle, Qlik View and Qlik Sense.

Business Objects & Crystal Reports experience using Business Objects Administration, BO Developer Suite using SDK, Application foundation, Broadcast Agent, Auditor, Web Admin tool, Supervisor, Designer, Web Intelligence/Infoview

Experience in working with Agile Methodology and expertise in Scrum Practices.

Conducted End User Training on Business Objects Reporter, Designer, Web Intelligence, Supervisor & BCA.

Extensive experience in working with Informatica Power Center involving Warehouse Designer, Workflow Manager, Workflow Monitor, Repository Manager, Source Analyzer and developed Source and Target layouts, Mappings, Mapplets, Worklets and Transformations.

Strong Experience in creating Transformations such as Aggregation, Expression, Update Strategy, Lookup, Joiner, Rank, Router and Source Qualifier Transformations in the Informatica Designer.

Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type I, II, III and Cleansing, Profiling, Conversion, Aggregation, and Performance Optimization.

Experience in working on the system specific Teradata Data Warehouse Architecture.

Involved in CRM functionality of handling tickets in Remedy, ServiceNow & PeopleSoft Vantive tools.

Hands on Project Management experience in working with various cross functional teams and managing the projects.

Experience in conducting meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.

Extracted data from Homogenous sources, Heterogeneous sources which includes RDBMS, Flat files - Fixed Width and delimited files.

Involved in all phases of SDLC viz; Requirements Analysis, Design, Development, Testing and Implementation.

Expertise in designing the data warehouse using Star schema/Snow-flake schema and Dimensional Modeling, and creating Business Objects Repositories.

Created different type of reports including Cross-tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports

Involved in upgrading to the various versions of Business Objects viz., XI-R1, XI-R2, BO 4.0, 4.1.

Performed analysis of various legacy operational systems to understand the business value and quality of source data.

Experience in using Tableau Desktop and Server applications and creating Dashboards.

Experience in Logical and Physical data warehouse models to represent business needs.

Successfully developed and implemented various Data Modeling and Reporting need for OLTP and OLAP using Power Designer, Designer 2000, Erwin, and Business Objects, Web intelligence with SDK, Crystal Reports 10.0, VB 7.0 and MS Access.

Interacted with the Business teams closely to gather the requirements and make sure that the requirements are properly designed and developed.

Establish and Maintain Productive Working Relationship with Management, Clients and Team Members.

Strong technical background, and possess excellent analytical & Communication skills, Creativity, Leadership qualities, Team spirit & above all a Positive attitude to shoulder any responsibility or challenges successfully.

Education: Master of Computer Applications

Technical Skills:

BI Tools: Business Objects 4.1/4.0/XI R3/R2/R1/6.5.1/6.1b/5.x (Designer, Reporter and CMC), Tableau 9.5/9.3/8.1, Web Intelligence/Infoview, Xcelsius, QlikSense, QlikView

ETL: Informatica Power Center 9.x/8.x, Informatica IDQ, Datastage

RDBMS : Teradata 15/14, Oracle R12/11i/10g/9i, SAP HANA, MS SQL Server 2005/2000, MS-Access, DB2

Languages: UNIX Shell Scripting, Python, Java/J2EE, XML, JSP, JavaScript, PERL, C++

OS Windows 10/7/XP/NT/2000, Sun Solaris, UNIX

Servers Weblogic, Websphere, Tomcat

Tools Teradata SQL Assistant, ServiceNow, SQL Developer, TOAD 9.7.2, Remedy, Application Lifecycle Management 11.5, Quality Center, QTP, NOAD, Auditor, Application Foundation

Professional Experience:

SYMANTEC, Dallas, TX Dec ’16 to till date

Senior Business Intelligence Consultant

Project: Bluecoat Integration

Description: Bluecoat Integration project is mainly to integrate the Bluecoat ERP and Business Intelligence models into Symantec process. BO Universes such as Class (Order Management), Entitlements, Renewals (OASIS), Install Base (OASIS) and Product & Pricing which are part of the existing Oracle 11i are getting integrated into the new Oracle R12 system based on the Symantec process for NRT and Non-NRT reporting.

Responsibilities:

Involved in the Development of the BO Universes for Class, Entitlements, Renewals and Install Base.

Extensively worked with @Aggregate_Aware to implement Aggregate Aware.

Worked on resolving the loops and built contexts in the Universes.

Worked extensively on Information Design Tool and BI Launchpad.

Created Derived Tables based on the requirement of the Project.

Developed Full Client and Webi reports.

Performed the Admin role in providing the access to the various users accessing the Bookings universe

Involved in developing Teradata SQLs on the Business Views (BV) and fine tuning the SQLs for better performance

Interacted with the Business team closely to gather the requirements and make sure that the requirements are properly designed and developed.

Created the Reports using the universes as the main Data Providers and writing the complex Queries including Sub queries, Unions, Intersect and Aliases.

Worked on Xcelsius dashboards using Qaaws and Live Office.

Worked on Teradata architecture in relation to the Data Warehouse specifications.

Created Hierarchies, Created complex objects using Aggregate Aware function and @functions like @Prompt, @Variable, @Select, @Where.

Created the Reports using the universes as the main Data Providers and writing the complex Queries including Sub queries, Unions, Intersect and Aliases.

Implemented Import wizard & publisher for migrating reports & universes.

Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.

Fine-tuned the SQLs using Explain Plan functionality in Teradata.

Involved in the implementation of single sign-on & security layer with row level restrictions.

Involved in SQL and WEBI tuning for better performance of the BI reports.

Environment: Business Objects 4.1/XI-R3, BI Launchpad, Designer, Deski, CMC, Web intelligence, Xcelsius, Crystal Reports, Qlik view, Qlik Sense, Teradata 15/14, Oracle R12/11i, Service Now, Application Lifecycle Management 11.5, SQL Developer, Toad, UNIX, HP Quality Center, Windows 10/7

CISCO, San Jose, CA Apr ’14 to Dec’16

Business Intelligence Lead

Projects: One Sales BO, Sales BO Ops, DISE, iOPS

Description: Sales BI projects are associated with Cisco Sales credits and compensation and for Operational reporting. The BI reporting was mainly developed for Dynamic Restatements, Validated Customer and DISE. The Year-End reporting was one of the main priorities for the Sales Customers.

Responsibilities:

Involved in the Development of the BO Universes for One Sales BO, Sales BO Ops and DISE.

Involved in resolving the loops, cardinalities, contexts and checked the Integrity of the Universes.

Worked extensively on Information Design Tool and BI Launchpad.

Worked on upgrading the Business Objects from XI-R3 version to 4.0 & 4.1 versions.

Created Derived Tables based on the requirement of the Project.

Used Tableau Desktop to create Reports and Dashboards for Bookings and Forecast.

Used Tableau Add-in to generate reports from the Excel spreadsheets.

Connected live to Teradata, SAP HANA and Oracle Databases to create Tableau Dashboards.

Extensively held the Project Management role by working with the various cross functional teams.

Created Projects and Change Requests (CRs) for assisting the various project teams.

Worked with the PDM and MB teams to create BVs & PVs by creating BVR/PVR, BVCR/PVCR based on the different Project requirements.

Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.

Implemented single sign-on & security layer with row level restrictions.

Worked on the OBIEE associated with MBR applications.

Involved in developing Teradata SQLs on the Business Views (BV) and fine tuning the SQLs for better performance

Worked on building complex Crystal Reports.

Trained the Sales User base on the new functionalities in BO.

Created Hierarchies, Created complex objects using Aggregate Aware function and @functions like @Prompt, @Variable, @Select, @Where.

Environment: Business Objects 4.1/XI-R3, Tableau 9.5/9.3, BI Launchpad, Dashboards, Designer, Deski, CMC, Web intelligence, Xcelsius, Crystal Reports, Teradata 15/14, SAP HANA, OBIEE, Oracle 11i, Informatica 9.1, UNIX, Remedy 6, Toad, HP Quality Center, Windows 10/7

CISCO, San Jose, CA Feb’09 to Apr’14

Business Intelligence Lead

Projects: Finance BI – Bookings, Revenue, Expense & Headcount, ICPM

Description:

Finance BI are the Business Intelligence projects developed for providing the flexibility to the various Cisco groups in order to generate the Cisco Financial Reports. The various applications such as MARS, Safari, Pricing & Discounting etc. are integrated into these universes. The users will be generating the reports on Bookings & Revenue of the various Cisco products such as Wireless Routers, Data Center Switches, VOIP phones and various mobility devices. The reporting is performed on Bookings, Forecast, Pricing & Discounting etc. with respect to the various Hierarchies such as Time, Product, Sales, BE, Customer based on the user requirement. The management will be accessing the reports in the form of dashboards in order to analyze the Monthly, Quarterly and Year-wise data.

Responsibilities:

Involved in the Development of the BO Universes for Sales BO & Finance BI – Bookings & Revenue.

Designed and Developed BO Universe containing 3000 Objects, 350 Tables and 250 Aliases.

Extensively worked with @Aggregate_Aware to implement Aggregate Aware.

Involved in resolving the loops, cardinalities, contexts and checked the Integrity of the Universes.

Worked extensively on Information Design Tool and BI Launchpad.

Developed Full Client and Webi reports.

Upgraded Business Objects 6.5 version applications to Business Objects XI-R2/R3.

Worked on resolving the Alliance Production cases raised by the users in the Remedy tool

Developed Active and Passive Transformations in Informatica like Source Qualifier, Lookup, Unconnected Lookup, Dynamic Lookup, Router, Stored Procedure, Aggregator, Filter, Joiner, Expression and Sorter as per functional requirements.

Created Sessions, Tasks, Workflows and Worklets using Workflow manager.

Worked extensively with Session Parameters, Mapping Parameters, and Mapping Variables and Parameter files for Incremental Loading.

Performed the Admin role in providing the access to the various users accessing the Bookings universe

Installed & Configured Business Objects XI R2 with CMS on Unix Platform

Facilitated meetings across Departments for implementing a standard Architecture for deploying Business Objects XI R2 across the entire Organization.

Worked on Xcelsius dashboards using Qaaws and Live Office.

Implemented Import wizard & publisher for migrating reports & universes.

Involved in the implementation of single sign-on & security layer with row level restrictions.

Worked on building complex Crystal Reports.

Involved in SQL and WEBI tuning for better performance of the BI reports

Environment: Business Objects XI-R3/R2/6.5, Designer, Deski, CMC, Web intelligence, Xcelsius, Crystal Reports, Teradata 13/12, Oracle 10G, Informatica 9.1, Hyperion Essbase, UNIX, Remedy, Toad, HP Quality Center, Windows 7/XP

VOCOLLECT, Pittsburgh, PA Aug ’08 to Dec ‘08

EVERTICALS, Pittsburgh, PA Jan ’08 to Aug ’08

Business Intelligence Consultant

Project: Redbird

Description:

Redbird is a Voice based Supply Chain and Logistics management product which improves the performance, reliability, productivity, accuracy and safety in the Logistics marketplace. The main objective of Redbird is to hear the Voice of the Customer. REX (Redbird Execution Engine) takes care of the interaction between the operator and the TTS (Text to Speech) device. Redbird handles the T5 Talkman device which is used by the operator in order to perform a task in the large stores easily. The speech recognition technique involved in the TTS is used to perform the task with more accuracy and reliability. The VoiceIDE plug-in is developed in Eclipse to create a Tasklet/Dialog which helps the operator to accomplish the task.

Redbird mainly revolves around People Task which is the basic task used for the interaction between the operator and the TTS using the Speech Recognition software.

Agile Methodology was used more effectively in Redbird using Rally. The User Stories containing small tasks were accomplished within a sprint (2 weeks) time. The Burn-Up, Burn-Down charts helped the team to complete the assigned tasks in the stipulated time.

Responsibilities:

Developed Full Client and Webi reports.

Used Business Objects Web Intelligence tool for deploying analysis reports on Internet

Involved in developing SQL, PL/SQL and WEBI tuning for better performance

Designed and Developed Universe using Business Objects XI.

Extensively worked with @Aggregate_Aware to implement Aggregate Aware concepts

Involved in resolving the loops, cardinalities, contexts and checked the Integrity of the Universes.

Exporting the universe to the Repository to make resources available to the users.

Created the Reports using the universes as the main Data Providers and writing the complex. Queries including Sub queries, Unions, Intersect and Aliases.

Migrated Business Objects 6.5 & Crystal 10 to Business Objects XI.

Implemented Import wizard & publisher for migrating reports & universes.

Developed complex mapping using Informatica PowerCenter tool.

Implemented concurrent runs in Informatica for multiple data regions that reduced coding effort by considerable time

Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.

Involved in writing User Stories in order to accomplish the tasks during the Sprints

Helped Scrum Master in Assigning Tasks

Involved in Extraction, Transformation and Loading in Informatica tool

Accomplished the Tasks within timeframe during the Sprints

Used the Points system and Agile Methodology effectively

Participated in the Engineering meetings to discuss the issues which stop the team members

Facilitate with tech Support to Formulate a Strategy for Implementing good User support

Involved in Unit Testing and User Acceptance Testing phases of the application

Instrumental in Starting the Dashboard Reporting structure to visualize KPI’S.

Exported the reports to Broadcast Agent Server, which is used to Schedule and Monitor the reports

Involved in SQL and WEBI tuning for better performance

Environment: Business Objects XI-R2/R1/6.5.1, Crystal Reports XI, Informatica 8.1, VBA, Web intelligence, ZABO, BO SDK, BCA, Xcelsius 2008, Oracle 9i/10G, PL/SQL, UNIX & Windows XP

COVANSYS (CSC), Chennai, India Nov ’06 to Dec’07

Client: UNUM, Chattanooga, TN

Business Intelligence Developer

Project: UNUM

Description:

Simply Unum combines a wide range of group and voluntary benefits that work together in one integrated package. It gives you one-stop access to all the coverage you need to fit your employees' needs at different life stages and financial situations.

Simply Unum is a healthcare insurance coverage that provides Group products such as Group Term Life, Group Voluntary Term Life, Renewable Term Life and Interest-Sensitive Whole Life and Supplemental Health VWB products such as VWB Accident, MedSupport and Critical Illness to the employees of various companies.

Simply Unum is a re-engineering version of an existing Disability Income Protection Individual Insurance System; and now it is developed for supporting Group and VWB products with .Net technology with supporting of i-Services, CCP, IRP, PCES & CRM platforms.

Simply Unum health coverage process starts when a Company employee decides to opt for a product and gets Quote & Proposal from the Unum agent. Once the employee agrees the Quote given by the agent, the Issue & Enrollment process will come into picture and the employee will be enrolled for a particular product of his choice. Then the Case is said to be sold and the Healthcare Product is finalized.

Responsibilities:

Having experience in conducting peer meetings, status meetings and setting the standards.

Designed dashboard reports and scorecard formats with process analytics & predictive analytics.

Designed Metric universe for dash board reporting solutions.

Implemented Best Practices for Using Business Objects Suite of Products.

Trained users for Ad-Hoc reporting analysis & Drill-Down Capabilities.

Designed View lets for Business Objects Training on reporter, Designer, Webi.

Instrumental in Starting the Dashboard Reporting structure to visualize KPI’S.

Designed architecture & set up for development, production & test repositories

Installed & Configured Business Objects Enterprise XI-R2 Premium Edition

Added/created complex objects to the universe to enhance the report functionality.

Optimized the usage of user objects, conditions and universe level filters

Created and maintained around 30 Business Objects reports.

Created the users, user groups and handled the user security

Worked on Unit Testing, UAT phases of Testing

Built Cross-Tab reports and defined VBA macros for automation of execution of BO reports.

Defined BO reports with universes MS-excel sheets & free hand SQL.

Implemented EPM with Dashboards and Scorecards reporting formats

Implemented Dashboard with performance manager

Designed and Implemented Production model through CMC

Worked on event based scheduling, discussions, BO live office.

Created Hierarchies, Created complex objects using Aggregate Aware function and @functions like @Prompt, @Variable, @Select, @where.

Customized Webi front page by HTML, Java script, JSP.

Developed full client and Webi reports.

Exported the reports to Broadcast Agent Server, which is used to Schedule and Monitor the reports

Used Business Objects Web Intelligence tool for deploying analysis reports on Internet

Involved in writing SQL queries, PL/SQL procedures and functions

Environment: Business Objects XI-R2/R1/6.5.1, Crystal Reports XI, Informatica, VBA, PL/SQL, Web intelligence 6.X/2.7, ZABO, BO SDK, BCA, Xcelsius 2008, Oracle 9i/10G, UNIX & Windows 2000/2003

CARITOR, Bangalore, India Mar ’05 – Oct ’06

Client: UNISYS, Eagan, MN

Business Objects Developer

Project: AirCore

Description:

AirCore is a web based product that assists the customers in Airline Reservation/Booking System wherein the customers are allowed to react with the system in order to reserve the tickets for traveling to different destinations across the world. International Air Transport Association (IATA) rules and regulations are taken into consideration for developing the AirCore in a customer friendly manner. In brief, AirCore allows the customers to reserve the flight tickets at their will and based on the availability between different Segments, the tickets are issued, takes care of the Flight ticket booking which has the options such as Selection of a window or aisle seat, Food Selection, carrying an infant in lap, Car Booking and Hotel Accommodation at the destination and allows the system to re-schedule the itinerary in case of any alteration in the schedule of flights for the convenience of the passengers.

Responsibilities:

System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.

Gathered requirements by conducting sessions & defined best practices & standards.

Co-ordinate team meetings for project initiation & development.

Instrumental in fitting the Business Objects Architecture into the System.

Implemented Best Practices for Using Business Objects Suite of Products.

Migrated Business Objects 6.5 & Crystal 10 to Business Objects XI.

Implemented Import wizard & publisher for migrating reports & universes.

Conducted meetings with management and user community to understand the business requirements and convert Business requirements into technical specifications.

Implemented single sign-on & security layer with row level restrictions.

Facilitate with tech Support to Formulate a Strategy for Implementing good User support.

Instrumental in Starting the Dashboard Reporting structure to visualize KPI’S.

Designed architecture & set up for development, production & test repositories.

Involved in Production Support 24/07 for Business Objects end users

Created the Logical and Physical Model using classic Star-Schema.

Trained the user community in making use of universe to create and publish reports.

Creation of reports like Reports by Period, Demographic reports and Comparative Reports.

Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Implemented application foundation with dash board manager.

Designed dashboard reports and scorecard formats with process analytics & predictive analytics.

Prepared user documentation for hand on training for end user community.

Designed Production System support and handling opened user cases.

Implemented web intelligence in distributed (clustered) Environment.

Actively involved in gathering server sizing requirements for software/hardware.

Conducted End User Training Sessions and Prepared Training Material.

Trained users for Ad-Hoc reporting analysis & Drill-Down Capabilities.

Environment: Business Objects XI R1/6.5.1, Informatica, Crystal Enterprise, Crystal Reports, Web Intelligence, AIX 5.1, SQL SERVER, TOAD, Oracle 9.2, SQL Server 2005, VBA, SQL, PL/SQL, Java

Contact this candidate