VENKATA CHANDRA SEKHAR.KESANA
** **** **** ******, *******, L9T-2V5
4.6 years of hands-on experience as a Hyperion Developer and Data Reporting Analyst with extensive experience in designing Multi-Dimensional/ Relational Database, Dashboards and Reports along with creating user required reports using Hyperion IR, OBIEE11g as well as creating process documentation with knowledge of Oracle tools and SQL.
Well acquainted with SDLC & STLC using a waterfall and agile methodologies in software development.
Experienced working with OLTP / OLAP Systems and understanding Star and snowflake schema and having an excellent understanding in BI Architecture, Business Intelligence and Data Warehousing and Database Concepts
Designed, analyzed and maintained American Motorola Applications using Essbase 11.x/9.x, Planning 11.x/9.x, Hyperion Financial Reports, HFM, Essbase Studio, and Essbase Spreadsheet Add-In, & Smart view.
Hyperion Application Modules: Hyperion Planning.
Data Management Modules: ODI 11g, DRM
BI Module: Hyperion Essbase 11.x/9.x (ASO/ BSO), Hyperion Smart View, OBIEE 10g/11g, Hyperion IR Studio
Databases: Oracle PL/SQL Developer, Oracle 11g
Query/Programming Languages: SQL, PL/SQL.
ETL/ELT: Informatica 9.01, ODI 11g.
Data Analysis Tools: WEKA, Rapid minor, TABLEAU, Power BI.
Technical management support: Service Now, JIRA, Confluence, and Jenkins.
Frameworks and IDE: Microsoft Visual Studio.
Web Technologies: HTML, CSS.
Methodologies: Agile, Waterfall, DevOps.
Operating systems: Unix, Windows
Data Warehouse Analyst, Kinaxis, Ottawa
Jan/2019 to Dec/2019
Created several SQL queries and stored procedures for QDW database in SQL server to provide backend data for Business applications.
Used SQL statements (select, delete, update, union, join etc.) and functions (sum, min, max etc.) to manipulate data and create several types of reports for manager/admin and clients.
The primary job responsibilities include collecting technical business requirements report requests, performing quality analysis on reports and implementing the request in Production.
Involved in daily scrum calls with the project team and Involved in agile sprints and tracking required work through JIRA.
Hyperion Developer, (TCS), Hyderabad, India - (American Motorola Solutions)
May/2015 to Dec/2017
Extracted raw data from various regions, transform the data according to the business logic and load the transformed data into relational targeted RDBMS tables using ODI and schedules those tasks.
Worked on DRM (Data Relationship Management) to manage an organization's metadata.
Experienced in transferring source files between different servers UNIX to Windows.
Implemented several business logics by using various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy for designing and optimizing the mappings as per the business user’s requirements in ODI(11.1.1) and INFORMATICA 9.01
Designed Rules Files for the purpose of loading data from flat files to the dimensions in the outline using several load methods such as generation, level and parent-child references.
Developed and maintained several calculation scripts and Hyperion Essbase cubes.
Created and modified required Essbase calc scripts, MaxL scripts and Essbase/Smart View Add-in as per the end user requirements.
Involved in planning, development, analysis and documentation of Functional requirements for Hyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations.
Created different Business Intelligence Dashboards and reports in OBIEE10g/11g and in Hyperion IR Studio as per business client’s requirements over a data warehouse data and share with them.
Created several ad-hoc reports using Smart view.
Provided support and Maintenance of Hyperion services.
Involved in migration and upgrading the Hyperion Essbase versions during, handing over the project from Motorola to Zebra.
Analyzed the data volumes for Job runtime understanding and optimizing the mappings in ODI wherever required and prepared technical design documents.
Data Reporting Analyst, (TCS), Hyderabad, India - (American Motorola Solutions)
Dec/2014 to Dec/2015
Monitored scheduled jobs built-in Oracle Data Integrator (ODI).
Used SQL statements (select, delete, update, union, join etc.) and functions (sum, min, max etc.) to manipulate client data and create several types of IR reports for the Users and clients
Connected to Oracle database and tuned the stored procedures and SQL queries for the effective running of AD-Hoc reports and schedules reports and shared with users.
Scheduled the Daily and Incremental load in DAC in the production environment, Monitoring and supporting the daily incremental load in production.
Connected with the Product users and Business clients to resolve the issues in using and installing the Oracle Hyperion Essbase, Smart view.
Provided extensive support and maintained rules files, calculation scripts, MaxL scripts and Bi -reports.
Provided L2 and L3 support for the Motorola Hyperion application and Performed functional configuration, troubleshooting and support all phases of a project life cycle.
Involved in various support related activities with several vendors for issue resolution and support activities.
Major Project (Data Mining)
Title: “Identifying the probability for a ticketing car from parking space”.
Constructed a classification model to domain experts and inform the accuracy and interpretation of the results for the Vehicle parking area
Provided a solution to address the class imbalance problem is to balance the number of instances within all classes of the parking data collected.
Created a balanced dataset so that the number of instances of classes are close to equal and identified the best classification algorithm to build models against my balanced data.
Provided the best suitable algorithm with a highest accuracy and identified the best cluster to clarify the balanced dataset.
Title: “Improving click-through rates (CTR) for advertising in social media”
Proposed a method for social media platforms to use the information on a profile and by predicting CTR to discover the interests of people and show ads that are relevant to them.
It saved the advertising cost of a person/company by showing relevant ads to relevant people
Demonstrated with a huge dataset with a relevant data mining algorithms
Title: “De-noising/Detection of information from the Radar Signal“(Indian Defense Research and Development Organization Project)
Implemented the wavelet analysis the technique in MATLAB to decompose the input signal into its coefficients, and making the least wavelet coefficients as zero and reconstruct it back to the original Radar signal which gives the Radar signal without noise.
This Radar Signal Processing is an important link in the chain of information processing for target identification in Air-defense.
Presented a paper on “Improving click-through rates (CTR) for advertising in social media”
Presented a paper on “A comparison of visual and textual page previews in judging the helpfulness of web pages” as part of my coursework
Wrote a paper by Performing a comparative study of classification and cluster algorithms, focusing on their strengths and weaknesses to handle the multi-class problem for a given financial bank customer data.
Awards and Accomplishments
Received “Best Team” Award from TCS
Achieved appreciations from clients on several occasions and Continuous best ratings for consistent performance
Grabbed on-spot appreciations from the managers for proactive resolution of issues and Special Initiative Award
Accolade a Gold Medal in the National level Modern ART painting competition conducted by Vishwa Kala Darshani in Rajahmundry, Andhra Pradesh
Stood one of the six students shortlisted to do a research project at IIT-Hyderabad.
Secured Gold medal in State Level Championship in a paper presentation on “Immunization in INDIA” in The Hindu(Indian daily newspaper)-E-Plus Challenge 2012
Won a State Level Silver medal in poster presentation in Hindu- E–Plus Challenge 2013.
Donned as a Student coordinator Technical Project Exhibition (SPOORTHI) in Vignan Mahotsav 2012,2013 and 2014
Organized stage anchoring at INDIAN National level cultural event Vignan Mahotsav 2013
Acted as a Student as a student president for ECE department at Vignan Mahotsav.
University of Ottawa (Ottawa, ON)
Jan/2018 – Dec/2019
Master of Electronic Business Technologies, University of Ottawa, Ontario, Canada.
Vignan University (A.P, India)
August-2010 - July-2014
Bachelor of Technology in Electronics and Communication Engineering, Vignan University, A.P, India
Awarded GOLD Medal for being ‘The Best All-rounder Student of the year’ (2010-2014) by the Vignan University
* * References will be provided on request