Naveen Reddy Adulla
Experience Summary
Around 5 years of experience as Software Developer and Admin in monitoring, analytics solutions, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, Data Modelling and Data Visualization using OBIEE 11g/10g/12c, BI Publisher, MS Power BI, Tableau, SSIS, SSRS and SSAS, Oracle, SQL Server.
Good knowledge in Security, Oracle Business Intelligence Enterprise Edition (OBIEE), UNIX Shell Scripts, Web Catalog metadata, Erwin and Payment gateway domains.
Expert in configuration and integration of OLAP AND OLPT data bases.
Profound experience in Splunk, working knowledge on programming languages like Python, technologies like HTML, CSS and XML.
SQL, PL/SQL, Informatica, Power Exchange, Autosys, Golden Gate, DB2 Connect, Teradata, Molad, Fastload, TOAD, T-SQL, MS DTS, Star Schema and Snowflake Schema.
Expert in Developing RPD and Web Catalog metadata, Business Models with Business Model and Mapping (BMM).
Expert in in design and developing Reports and Dashboards using OBIEE, BI Publisher 11g/10g/12c.
Expertise on working with multiple RDBMS platforms – Oracle, MS SQL Server and Azure SQL DB
Database programming experience using SQL, T-SQL and PL/SQL
Proficient in understanding the concepts of Data warehousing (OLAP) and Transactional systems (OLTP).
Expert in Splunk search language – SPL.
Expert in writing Splunk configurations like props, transforms, server, inputs, outputs, saved searches etc.,
Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis.
Expert in installing and using Splunk apps for Unix and Linux (Splunk nix).
Experience with Splunk authentication, permissions, KPIs and metrics in ITSI.
Experienced in ingesting data from various sources like REST API, HTTP event collectors, files, directories, syslog and Splunk DB connect.
Key team player with the ability of interpersonal relationship and good communication skills.
Career Profile
Dec 2017- Current Positive Group
Title Global Event Management
Business area Internet Service Provider
Position Software Developer/ Data Analyst
Responsibilities Requirement analysis, Data on boarding, develop reports/dashboards, setup alerts, enable troubleshooting, respond to ad-hoc requests, provide stats to the management, troubleshoot alerts and reports, help monitoring team with data.
Project Global Event Management utilizes Splunk as log aggregation and centralized storage for analysis, logs from various network devices and satellites are ingested into Splunk. Real-time dashboards enable monitoring team to analyze and work on the incidents and resolve the issues. The dashboards are actionable and help the monitoring analysts to immediately work on the events. Splunk integration with Salesforce helps automating in creating the tickets and assigning to relevant teams. Also, Splunk integration with Hip-Chat helps notifying the users about the issues in real-time with a notification.
Carried out the following activities:
Created reports and dashboards using OBIEE, Tableau and Microsoft Power BI
Developed RPD and Web catalog metadata according to the reporting needs of the client.
Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
On board data from different sources, parse and store the data on the indexers.
Delivered solid, scalable, robust BI reporting/analytic solutions.
Configure alerts; develop search queries, reports and dashboards.
Troubleshoot issues and address tickets.
Environment: OBIEE 11g/10g/12c, BI Publisher, Tableau, Splunk , SSIS, SSRS, Microsoft Power BI, Oracle 12c, SQL Developer 3.x, MS SQL Server 2012/2016, T-SQL.
Sep 2016 – Nov 2017 Positive Group
Title Log Aggregation and Analysis
Business Cloud storage
Position Software Developer
Responsibilities Requirement gathering and analysis, data on boarding, write search queries, build dashboards and reports.
Project Log aggregation and analysis is aimed to provide an end-to-end solution to monitor the event data from storage systems. The legacy storage system is a failure when the analytics are demanding to produce a very old data. The proposed solution makes extensive use of the existing servers and scaled them to work together with clustered storage for the Log data. The proposed solution meets the demand to make the specific data out of the bin ready analytics within no time. Solution also includes analysing the data in real time providing scope for proactive business measures preventing failures and congestions in the storage.
Carried out the following activities:
Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
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.
Worked extensively on BMM (Business Model and Mapping) layer to develop various business models using Star Schema and Snowflake Schema
Created the Repository variables and Session Server variables in the RPD.
Designed and Developed full and incremental workflows in Informatica to Load the Data from Source System to Staging system and Warehouse System.
Created BI Publishers in OBIEE Repositories.
Worked on Informatica Designer tools –Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches. Created and ran Sessions & Workflows to load the data into the Data warehouse.
Environment: Splunk, Oracle11 g, Service Now, NetApp, Data Warehouse, OLAP,OBIEE.
Feb 2016 – Sep 2016 Positive Group
Title Healthcare data analysis
Business Health Care
Position Software Developer / Programmer Analyst
Responsibilities. Data ingestion into ORACLE Database , write search queries, build
dashboards and reports.
Project Healthcare data analysis is a POC aimed at integrating SAS – datasets via SQL Server into Splunk and use the data for content presentation in Splunk. Processes dump the SAS datasets into SQLServer, and db connect app enables data ingestion into Splunk. The ingested data is used for reporting and building dashboards.
Carried out the following activities:
Handled and transformed data through the ETL (Extraction, Transformation and Loading) process.
Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informant’s to read these data files
Involved in gathering and documenting business requirements and interacted with cross functional teams to analyze and discuss the primary requirements for the project
Handled files having many missing values and special characters and generated datasets based on the conditional requirements of the special character and missing values present in the file raw data files
Performed data scrubbing during the ETL Phase by analyzing the raw data and writing SAS program and creating complex reusable Macros
Employed SQL statement functionalities for analysis of large datasets (million records) and for data manipulation like Indexing and appending various datasets
Utilized PROC SQL for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
Environment: Splunk, SAS, SQL Server, ORACLE, SAS/BASE, SAS/MACRO, SAS/ETS, SAS Enterprise Guide, Teradata, Windows XP, UNIX.
Capstone Project
University of New Haven Aug 2015 – Dec 2015
The Capstone Project engages students on a project of significant importance that is a current problem or initiative for a health care organization. In Collaboration with the Milford Hospital, CT our team was involved in identifying the current process and ways to improve the patient access of care in the facility. The team was involved in engaging the practice patient satisfaction study with the quality measures that are reported to the CMS.
Lead a team of 7 members in analyzing current business process flow by understanding preset business rules and conditions.
Conducted formal interviews, Live Meetings and JAD sessions with End users.
Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML.
Defined project milestones, schedules, and monitored progress using MS-Project and updated plans as required.
Performed SWOT and Gap analysis for the new functionality requirements
Conducted Data Analysis and Visualization using Numpy(Python) and Tableau from the CMS Data for determining the patient satisfaction scores on various measures the facility has to offer.
Did a research and presentation on Competitors by performing Competitor Analysis based on the performance measures and satisfaction scores to the senior levels of the organization.
Working with Medicare operational management to monitor, trend, and report on operational metrics such as timeliness, workload, and staff trending, customer satisfaction, and other key measures to facilitate performance excellence.
Developed and linked data researched documentation practices to improve quality assurance and improvement. Prepared reports, charts, graphics, surveys, and non-complex briefing materials, records, reports and surveys using IBM Cognos and Tableau.
Analyzed, researched, reviewed and resolved complex issues and sensitive information in an accurate and timely.
Involved in data migration to RDBMS for quick analysis and visualization using SQL.
Analyzed and tested Data Interface related to HEDIS, Consumer Assessment of Healthcare Providers and Systems (CAHPS), for the Medicare and Medicaid reporting services based on the various reporting measures involved with HEDIS.
Educational Qualifications:
Master of Science Healthcare Administration, University of New Haven, CT.
Master of science Formulation Science, University of Greenwich, United Kingdom.
Bachelor of Pharmacy, Osmania University, Andhra Pradesh India.
TECHNICAL SKILLS:
BI Tools: OBIEE 11g/10g/12c, BI publisher, SSRS, Tableau, Microsoft Power BI, Splunk.
ETL Tools: Informatica Power Center 9.1/8.6, SSIS.
Databases: Oracle, MS SQL Server 2012/2016.
Reporting Packages: SSRS, MS Excel.
Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snowflake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.x/3.x, OLTP, OLAP.
Miscellaneous Tools: SQL Developer, TOAD, SQL*Plus, SQL*Loader.
Programming: SQL, PL/SQL, T-SQL,SPL.
Operating Systems: Windows 7/8, Windows 2003/2008/2008R2, UNIX (Sun Solaris, Linux).
The post Naveen Reddy Adulla Experience Summary Around 5 years of experience as Software appeared first on PapersSpot.
