Vamshi Reddy Velumala
- QlikView Developer
- New York City, NY
- Member Since Mar 03, 2023
Candidates About
Vamshi Reddy Velumala
|
o 5.7 years of IT professional experience in Data Warehouse, ETL, Data Analytics / Business Intelligence using QlikView, Qlik Sense, OBIEE 11g/12c, OBIA (Informatica, DAC) and Oracle BICS across Accounting, HealthCare and Banking domains.
o Extensive experience on Qlik Sense data visualization and implemented the new features of Qlik Sense like Pivot Table, KPI Object, PDF Printing etc.
o Excellent knowledge on Dimensional Modeling concepts like (Star Schema, Snow Flake Schema) & Loading Data from multiple sources.
o Expertise in 3 Tier Implementation of QlikView application as a standard best practice methodology.
o Experience in Data Models/ Scripting to handle high volume of data applying optimization techniques and data statistics calculations using different sources: Excel, QVD, Oracle, SQL Server, Siebel and Noetix Views.
o Knowledge on CDM development using TCA data model.
o Extensive knowledge on implementation of Set Analysis and also worked on the Alternate states to do a comparative analysis in QlikView.
o Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.
o Good Exposure to working with QlikView/ Qlik Sense Functions and Expression Scripts and streamlining reporting operations of QlikView Applications.
o Strong Experience in working with Charts (Table Box, Pivot Tables, Straight Tables, Pie-Charts, Gauge-Charts, Trellis)
o Extensively used various QlikView Scripting and UI functions such as aggr, rank, rangesum, firstsortedvalue, applymap, match, concat, numeric and date functions, etc.
o Implemented Incremental ETL to handle high, historical and incremental volume of data, resolved Circular Relationships, Synthetic Keys.
o Implemented Section Access, Binary Loads and abstracting the data layer using QlikView library and QVX files.
o Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView.
o Experience in scheduling jobs in QlikView Enterprise Management Console (QlikView Publisher) and managing user accounts in QlikView Management Console.
o Co-ordinated System and User Acceptance Testing and performed Data Validation for all the reports and dashboards generated from various database sources.
o Experienced in implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer in OBIEE.
o Design experience in RPD, Report creation & Dashboard Creation. Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
o Worked extensively with Oracle Business Intelligence Applications (BI Apps) that have completely pre-build BI solutions.
o Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local filters.
o Extensive experience in OBIEE Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTs, Cache Management , Job Manager and Scheduler Configuration.
o Expertise in Business Model development with various functionalities like Dimensional Hierarchies, Measures, Aggregation Rules, Time Series. etc.
o Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
o Overall understanding of Requirement gathering, Design, ETL, Reporting, Performance Improvisation, Release process and Support phases in project.
Achievements:
o Received a Spot Award for satisfying the HOLOGIC requirements in 2017.
o Part of Best Team of the Year(2017) award .
o Received a Bronze Award for an Individual contribution in a project in 2015
|
o Certified Qlik Sense Business Analyst
o Certified Oracle Business Intelligence Cloud Service Specialist (BICS)
|
o Working as 'Staff Consultant' for "Apps Associates (I) Pvt. Ltd", Hyderabad
o Worked as ‘Technical Analyst’ for “Jade Global Software Pvt. Ltd”, Pune
o Worked as BI Developer for “Binary Semantics Limited", Gurgaon.
|
o Bachelor of Technology(B.Tech) from VEC, Karimnagar, Telangana.
|
BI Tool : Qlik Sense, QlikView , OBIEE, BI Apps, Tableau
ETL : Informatica Power Center 9.x, DAC and ODI 11g.
Database : SQL Server, Oracle EBS, Siebel, CRM
Case Tools : Oracle SQL Developer.
Others : WinScp, Putty, Toad, Service Now
|
Project 4:
Project : Hologic
Role : Staff Consultant (BI)
Environment : Qlik Sense, Qlik View, Database Oracle EBS, Siebel, ODI 11g/Informatica, Oracle SQL and Service Now
Duration : Jan 2017 to Till date
Description : Hologic, Inc. is a developer, manufacturer and supplier of diagnostic products, medical imaging systems and surgical products. The Company’s core business units focus on diagnostics, breast health, gynecological surgical, and skeletal health.
Responsibilities:
ü Developing CDM(Customer Data Management) reports by using TCA data model
ü Designed the Data-Model using data from various sources like Oracle Database and flat files.
ü Designed and implemented the Incremental Load using QVDs, so that QlikView would only load the data worth of one day and append it to the old data which is already stored in QVDs.
ü Implemented the 3-tier architecture, Data Extract, Data transform and Data model & Application. Data Extract would load the Data from the data sources into the QVDs. Data transform will transform the data and Application layer is User Interface Design layer where we layout all our Charts, Tables and List Boxes.
ü Developed a Calendar logic which replaces OBI Calendar logic which is being used in more than 60 QVW's and 6 QVD Generators.
ü Written complex expressions using Set analysis and various QlikView functions.
ü Scheduled Data Extractions, Data Model and Dashboard Reloads using QlikView Management Console (QMC).
ü Designed the Dashboard with various objects such as Pie Charts, Line Charts, Bar Charts, Combo Charts, Gauge Chart, Table Object, Straight Table, Pivot Table etc.
ü Resolved and removed any Circular Loops or Synthetic Keys by renaming or removing unwanted columns, using Qualify statement, performing Join operations and by concatenating the tables.
ü Developed Linked and Concatenated tables and solved the loops issues.
Project : Sensata
Role : Staff Consultant (BI)
Environment : Qlik Sense, Qlik View, OBIEE 11g, OBIA 11.1.1.7.1, Database Oracle EBS, Siebel, ODI 11g, Oracle SQL, Microsoft SQL Server, Service Now
Description : Sensata Technologies is one of the world's leading suppliers of sensing, electrical protection, control and power management solutions. Sensata's products improve safety, efficiency and comfort for millions of people every day in automotive, appliance, aircraft, industrial, military, heavy vehicle, heating, air-conditioning and ventilation, data, telecommunications, recreational vehicle and marine applications.
Responsibilities :
ü Replicated OBI reports /dashboards inot Qlikview and written a Load Scripts for distribution across multiple data sources.
ü Designed and maintained Qlikview applications and Managed all new and some existing projects.
ü Developed complex QlikView scripts to build model, to support various KPIs and time comparison.
ü Responsible for positioning and delivering QlikView projects and cross building applications into new and existing customer base.
Project 3:
Project : Riot Games, USA
Role : Technical Analyst (BI)
Environment : QlikView 11, Database Oracle EBS,ODI 11g, Informatica, Oracle SQL.
Description : Riot games aspire to be the most player-focused game company in the world. We were established in 2006 by a couple of entrepreneurial gamers who believe player-focused game development can result in awesome games. In 2009, we released our debut title, League of Legends, to critical and player acclaim. Over 67 million play every month. We know players form the foundation of our community and it’s for them that we continue to evolve and improve the League of Legends experience.
Responsibilities:
ü Designed the Qlikview Dashboards (Finance Module) with various objects such as Pie Charts, Line Charts, Bar Charts, Combo Charts, Gauge Chart, Table Object, Straight Table, Pivot Table etc.
ü Used Set Analysis in the Expressions for various charts.
ü Resolved and removed any Circular Loops or Synthetic Keys by renaming or removing unwanted columns, using Qualify statement, performing Join operations and by concatenating the tables.
ü Developed Linked and Concatenated tables and solved the loops issues.
ü Customized business reports (GL,AP,AR, etc..) as per requirements.
ü Maintained user guides for Qlikview applications and provided ongoing Qlikview implementation and support.
ü Outlined new features of Qlikview for clients.
ü Submitted all projects by or ahead of deadlines.
Project 2:
Project : Lafarage, India
Role : BI Developer
Environment : QlikView, OBIEE 11g, OBIA, Database Oracle EBS, Informatica, DAC ,SQL
Description : Lafarge is the world leader in building materials, Lafarge has an established presence across all major cities and towns in India. The group responds to the needs driven by its customers, business associates, shareholders, regional authorities and local communities. Lafarge through its specialist solutions under - Cement, Aggregates and Concrete enable and empowers its customers by bringing innovation & sustainability to their construction. Lafarge entered the Indian market in 1999, through its cement business. The company has established its presence in all its three businesses- cement, aggregates and concrete.
Responsibilities:
ü Migrated Sandbox reports from OBIEE to QlikView
ü Designed Order Management, Inventory reports using QlikView.
ü Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, using OBIEE 11g.
ü Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
ü Implemented the delivery of iBots using OBI Delivers to alert the teams.
Project 1:
Project : UTC
Role : BI Developer
Environment : OBIEE 11g, BI Apps7.9.6.2,Database Oracle10g/11g, Informatica Power center, DAC,SQL, Putty, and Windows.
Description: It researches, develops, and manufactures products in numerous areas, including aircraft engines, aerospace systems, HVAC, elevators and escalators, fire and security, building systems, and industrial products, among others. UTC is also a large military contractor, getting about 10% of its revenue from the U.S. government.
Responsibilities:
ü Worked extensively on OBIEE Answers to create the reports as per the client requirements.
ü Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
ü Identified Facts and Dimensions according to the design specification.
ü Worked on repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports).
ü Implemented Object level security and data level security by Creating Users, Groups and giving the permissions in OBI Analytics Administration Tool and verified the Permissions of the users in OBI Analytics web.
ü Responsible for installing, configuring, developing, support and maintenance of the BI APPS.