Manideep, Hanumanthavarjula

ac6k70@r.postjobfree.com

+1-904-***-****

Jacksonville, USA

Summary:

Qlikview 11 Certified Professional having 5.5 years of IT experience with extensive knowledge in Business intelligence tools like Qlikview, Spotfire.

Strong experience in designing and developing dashboards using QlikView by extracting data from multiple data sources.

Good Knowledge Set Analysis to provide the custom functionality in QlikView Applications.

Having good experience in designing and modeling of QlikView with complex multiple data sources.

Created batch files for the Qlikview applications to run on scheduled job.

Good understanding of Qlikview Server.

Extensively executed T-SQL queries on SQL Server 2008 R2 to view successful transaction of data and to validate and test Data Flow as well as Data Integrity.

Worked on ASP.NET, HTML, CSS, Java Script and AngularJS for the Web portal development.

Having Good Knowledge on the Tibco Spotfire for the Report development.

Worked on MS-BI tools like SSIS and SSRS to pull the data from production line to Staging as well as data ware house and generated dash boards in SSRS.

Having knowledge on the Tableau & Power BI reporting tools.

Understanding software requirement specification and identifying the functional requirement scenarios.

Professional Experience:

Currently working as a computer programmer in ICube Consultancy Services INC., Jacksonville, USA from June 5th, 2017 to till date.

Worked as Software Engineer in ICube Consulting India Services Pvt. Ltd., Hyderabad from January 15th, 2013 to June 4th, 2017.

Technical Skills:

Database : MS-Sql Server 2008 R2. Oracle 12C

BI Reporting Tool : QlikView 10, Qlikview 11, Tableau, Spotfire, Power BI, SSRS

ETL Packages : Sql Server Reporting Services (SSIS)

Web technologies : Asp.net, HTML, CSS, Javascript and AngularJS

BigData Technologies : Hadoop, HIVE, HBASE, PIG, SQOOP, KAFKA, SPARK(Learning)

Academic Qualifications:

B. Tech (Computer Science & Engineering) from Sri Sai Aditya Institute of Science & Technology affiliated to Jawaharlal Nehru Technological University, Kakinada with an aggregate of 76.28%, 2012

Carrier projects in ICUBECSI, Jacksonville, Florida, USA

Project #1

Project Name

Janssen – QCAR - List of All Audits, Audit Timeliness Report

Role

Developer

Technologies Used

Spotfire, Microsoft Excel, ORACLE 12C

Description: This is Project mainly deals with two reports. First is List of all audits and the second one is Audit Timeliness Reports. The first one gives the visual representation of audits that are conducted across various departments in Janssen Pharmaceuticals. There are various varieties of dashboards were built based on requirement. The second one Audit Timeliness Reports shows that the audit timeliness like Audits closed on time, late audits, observation data.

Project #2

Project Name

Janssen – BRQC Audit Schedule

Role

Developer

Technologies Used

Asp.net, HTML, CSS, Javascript, AngularJS, ORACLE 12C

Description: Audit Schedule is a web portal where the BRQC domain heads will enter the data for the future audits that are going to be performed and for the current year audits. This portal also can edit the existing audits and can display the what are the changes that have been made. This will Log the History of the Audits and user login history. This has ability to display the audits to JNJ public.

Project #3

Project Name

Janssen – CAPA - Corrective Actions and Preventive Measures

Role

Developer

Technologies Used

Spotfire, Microsoft Excel, ORACLE 12C

Description: This is a Spotfire Dashboard provides visual representation of Investigations and CAPAs (Corrective Actions and preventive Measures) that are assigned, Completed and remaining Due. This also represents the Timeliness, Aging and Extension factors for the Investigations and CAPAs. Timeliness is factor that tells the count of Investigations and CAPAs completed in time. Aging tells how long the Investigations and CAPAs have been created and Extensions tell about the count of Investigations and CAPAs with one extension and more than one extension. This has also the One View Dashboard captures the change in count of Investigations and CAPAs based on the Timeline for every Quarter.

Project #4

Project Name

Janssen – HAI Metrics – Health Authority Inspection

Role

Developer

Technologies Used

Spotfire, Microsoft Excel, ORACLE 12C

Description: This is a Spotfire dashboard that provides the visual representation of the Audits inspected by Health Authority. This includes the information about Inspections, Observations and CAPAs. This dashboard provides the Audits, CAPAs by Sector wise. The Sectors involved are Consumer, Pharma, MD&D and TACQA. This Dashboard Provides the status of the Audits whether they are open, closed, New based on the Sector.

Carrier projects in ICUBECSI, Hyderabad

Project #1

Project Name

LINE 51 – Engineering Analysis Tool

Role

Developer

Technologies Used

Qlikview, MS-SQL Server 2008 R2 and SSIS.

Description: The EAT application relies on data collection and data retrieval from various sources to analyze the quality, performance and production. The Line 51 architecture represents the latest Lens Production Line. There occur many defects in the Lens manufacturing process. EAT application is used to identify various defects with different parameters that are applicable in Lens manufacturing process.

Project #2

Project Name

LINE 46 – Engineering Analysis Tool

Role

Developer

Technologies Used

Qlikview, MS-SQL Server 2008 R2 and SSIS.

Description: The EAT application relies on data collection and data retrieval from various sources to analyze the quality, performance and production. The Line 46 architecture represents the latest Lens Production Line. There occur many defects in the Lens manufacturing process. EAT application is used to identify various defects with different parameters that are applicable in Lens manufacturing process.

EAT also tells about the concentration of defects. It allows the end user to identify the various defects plotted on each Lens Cavity for different stages while manufacturing the Lenses. It allows the user to identify the number of defects those are occurred within the given radius of a Lens. It also helps the user to count the Lens defects over a particular time period. This data is imported into application database (APPADW), mapped and is used in the EAT QlikView file.

Project #3

Project Name

TAM 04 – Engineering Analysis Tool

Role

Developer

Technologies Used

Qlikview, MS-SQL Server 2008 R2 and SSIS.

Description: The EAT application relies on data collection and data retrieval from various sources to analyze the quality, performance and production. The TAM04 architecture represents the latest Lens Production Line. There occur many defects in the Lens manufacturing process. EAT application is used to identify various defects with different parameters that are applicable in Lens manufacturing process.

EAT also tells about the concentration of defects. It allows the end user to identify the various defects plotted on each Lens Cavity for different stages while manufacturing the Lenses. It allows the user to identify the number of defects those are occurred within the given radius of a Lens. It also helps the user to count the Lens defects over a particular time. This data is imported into application database (APPADW), mapped and is used in the EAT QlikView file.

Project #4

Project Name

Lens Parameters & Plastic Parameters

Role

Developer

Technologies Used

Qlikview, MS-SQL Server 2008 R2, CSV Files, MS-Excel.

Description: A Qlikview application to trend and monitor all finished goods testing results during Validation and standard manufacturing of the lenses. It is a tool that monitors the process capability for finished goods lens parameter results to help drive continuous improvement opportunities throughout the product lifecycle. The tool is used to show the high level statistical results of process capability in the form of a dashboard and will then can drill down into the various categories to be able to identify the trends to help make appropriate decisions on a proactive basis. This is a web based application that was used by the multiple users globally.

Project #5

Project Name

Plato Qlikview Application

Role

Developer

Technologies Used

Qlikview, MS-SQL Server 2008 R2, CSV Files, MS-Excel.

Description: This application is to validate the actual expenses and the spent expenses. A Dashboard to represent the difference b/w the actual expenses and spent expenses for a year. The data was given in a excel sheet quarterly which can be pulled into Qlikview and the reports are made.

Personal Details:

Fisrt Name : Surya Padmanabha Manideep

Last Name : Hanumanthavarjula

Date of Birth : 16th July 1991.

Languages Known : English, Telugu, and Hindi.

Contact this candidate