Praveen KONDA

• As a leading supplier of wafer fabrication equipment and services to the global semiconductor industry, Lam Research develops innovative solutions that help customers build smaller, faster, more powerful, and more power-efficient electronic devices, the kind that are driving the proliferation of technology into our everyday lives.
• Hands on Skills:
• Involved in Business meetings and gathered detail requirements from Business
• Created Functional Specs and shared with Technical Teams
• Responsible for Project Planning and Management
• Played key role in understanding technicalities to analyze project requirements, identify technical risks, and collaborate with engineering teams to find solutions
• Worked closely with various teams, including product management, engineering and stakeholders to ensure alignment and facilitate effective communication
• Regularly communicated project status to stakeholders, provide updates on progress, and manage expectations
• Proactively identified and mitigated technical risks that could impact project success
• Proactively helped Team members at troubleshooting technical issues and finding creative solutions to overcome challenges
• Played key role in improving project management processes and establishing best practices within the organization
• Always ensured that technical projects align with the overall business strategy and contribute to the company’s goals
• My Leadership provided guidance and influenced teams ensuring they are aligned and motivated
• Environment: Power BI, PowerApps, Power Automate, SAP HANA, Windows 11 Enterprise and Microsoft SQL Server 2022.

• As a leading supplier of wafer fabrication equipment and services to the global semiconductor industry, Lam Research develops innovative solutions that help customers build smaller, faster, more powerful, and more power-efficient electronic devices, the kind that are driving the proliferation of technology into our everyday lives
• Created more than 20 dashboards for different departments and currently working on another set of requirements.

Hands on Development Skills:

· Involved in Business meetings and gathered detail requirements from Business.

· Created dashboard prototypes for Business Users and technical Documentation for the gathered requirements.

· Experience in working onsite and offshore model as an onsite coordinator and worked as a scrum master.

· Experience in Qliksense development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues.

· Experience in resolving performance issues in Dashboard.

· Developed dashboards using third party extensions.

· Experience in Qliksense Management Console in adding users, assigning tokens, creating security rules, streams, upgrading license etc.

· Proficient in SET ANALYSIS to provide customized functionality in Qliksense Applications

· Implementation of security in Qliksense Applications at Document and row level.

· Worked on Document chaining in Qliksense with dynamic variables.

· Creating Power BI Dashboards for the existing business use ca.ses to migrate few dashboards from Qliksense to Power BI.

· Experience in writing DAX queries.

· Experience in setting up role-based security.

· Experience in setting up real time alerts when data changes.

· Experience in developing PowerApps and Powerautomate flow to implement write back functionality in PowerBI which enables users to comment on a particular row in a PowerBI Report

• Power BI, PowerApps, Power Automate, Qliksense 2.1.1, HANA, Windows Server 2012 Datacenter and Microsoft SQL Server 2014
• The Crum & Forster groups of companies are wholly owned subsidiaries of Crum & Forster Holdings Corp
• And indirect subsidiaries of Fairfax Financial Holdings Limited
• The operating units within Crum & Forster Holdings Corp
• Provide standard and specialty insurance products & services
• Crum & Forster has a Data Warehouse which includes different department’s data and is populated using various jobs of Informatica
• C&F has a Reporting Framework on SSRS 2005 and all the existing Reporting framework should be moved to SSRS 2008 R2 and some new reports development using OLAP in SSAS 2008
• Migration activity is the major initiative to move existing Reporting Framework of 2005 to Reporting Framework 2008 R2 and Supporting users for production issues and development of SSRS reports in 2012 and Qlikview dashboards using SSAS Cube
• Hands on Development Skills:
• Migrated SSRS Reports from 2005 to 2008 R2
• Optimized SSRS Reports in 2008 R2
• Experience in installing Hot fixes for SSRS 2008 R2 Issues
• Resolved the Formatting Issues in Reports
• Developed SSAS cube using multiple Facts
• Developed various calculated measures using MDX Queries
• Worked on Optimization of MDX Queries
• Involved in Development of OLAP Cube creation using SSAS
• Involved in Development of SSRS Reports using OLAP Cube
• Involved in Development of SSRS Reports like Summary and Detail reports with Drill Downs
• Experience in Qlikview development of ETL scripts for Data Modeling along with resolving Synthetic Key and Circular Loop issues
• Proficient in SET ANALYSIS to provide customized functionality in Qlikview Applications
• Implementation of security in Qlikview Applications at Document and Server Level
• Environment: Qlikview 11, Microsoft Reporting Services 2008 R1, R2 & 2012 (SSRS), Microsoft Analysis Services 2008 R1, R2 & 2012, 2012 (SSAS), Microsoft SQL Server 2008 R1, R2 & 2012 and Windows 2008 Server R2
• Office for National Statistics, UK

• The Office for National Statistics (ONS) is the executive office of the UK Statistics Authority, a non-ministerial department which reports directly to the Kingdom
• It is charged with the collection and publication of statistics related to the economy, population and society of England and Wales at national, regional and local levels
• The Collected information will be stored into a third-party system and will be generated as a XML format which will act like a source to populate an Oracle database
• ONS generates a format of SDMX - XML which are generated through third party tool CODP.A Business Intelligence Open source ETL tool called TALEND of version 5.0.1 which is java-based tool and this tool picks any type of database as source like SQL Server, Oracle, and ERP etc
• And also picks any type of file as source file like CSV, XLS, and XML etc
• Files as input and processes it for further use in different applications/Database
• In this Assignment Talend is used to extract data from the XML to the Oracle Environment called as IMPORT and from IMPORT data will be transformed and dumped into another Oracle environment called STAGING and finally from STAGING data will be loaded into the final Oracle environment called as TARGET
• On top of the TARGET environment Liferay Portal is deployed and some additional data being fed into TARGET using Liferay Screens
• Finally, TARGET Data will be deployed and shared as dashboards, scorecards, charts and reports in QlikView
• Few existing SSRS 2008 Reports are migrated to Qlikview Reports with some minor changes
• Hands on Development Skills:
• Created mock-ups showing the intended functionality, visual aspects of the dashboards to be developed
• Developed dashboards pertaining to KPI monitoring using QlikView10
• 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
• Worked as Subject Matter Expert (SME) for various projects
• Taught the users to get along with Qlikview
• There were 40 million records with daily incremental reload schedule
• Emphasized on Data Integrity to good chart aesthetics
• Performed time over time analysis of Census
• Worked with QlikView 10, SQL, Excel files and flat files
• Involved in migrating SSRS reports to Qlikview Tabular Views and charts
• Environment: Qlikview 10, SQL Server Reporting Services 2008Oracle 11g, SQL Server 2008, Flat files and Windows Server 2008.

• This project caters to Reporting needs of a large Insurance Company
• This Insurance Company sells policies to Customers through various Agents appointed by the company
• These Agents contact customers & submit proposals
• On acceptance of a proposal by the customer, the proposal is converted into a policy
• The customer on receipt of a policy pays Premium to the Insurance Company as per the policy terms
• The Agent in turn gets commission out of these premiums
• Company analyses the Agent performance vide No
• Of Customers, No of Policies, No of Proposals, Premiums etc
• The various reports constitute this analysis
• Maybank is an ERP product developed for Insurance Company
• This product has various modules, we are asked to handle 3 modules which are CMS i.e
• Channel Management System, Finance, Claims
• For all the above 3 modules we have generated data marts and reports
• On basis of reports study, we have created the data marts from which the reports are generated
• For populating data in Data mart, we had to do ETL i.e., Extract, Transform, Load using SSIS
• Once the Data mart is populated, the reports are connected to this Data mart by Creating SSAS OLAP Cubes and Stored procedures
• Hands on Development Skills:
• Involved in the Requirement gathering and ETL mapping
• Involved in developing ETL Packages using SQL Server Integration Studio (SSIS)
• Involved in the development of the Reports as a team member
• Created Functional specifications of the business requirements
• Created Monthly, Quarterly and yearly reports for the management team using SSAS and SSRS
• Involved in the development of the Complex Reports
• Developing complex drop out Reports using SSAS OLAP Cube and SQL Stored procedures
• Extensively Worked on OLAP and MDX in Developing Complex Reports
• Creating User Parameters, Inserting Logos, validating Logos depending on the Parameter Passed by User
• Environment: Microsoft Integration Services 2005 (SSIS), Microsoft Analysis Services 2005 (SSAS), Microsoft Reporting Services 2005 (SSRS), Microsoft SQL Server 2005 and Windows 2000 Server.

• Student retention is an important issue for the University as it has funding consequences; it is used by government as a measure of performance and is a reflection of the student experience
• There are known to be several indicators of a student’s behaviour, course of study and demographics, which can be used to highlight a student at risk of dropping out of their course
• These behaviours concern how students make contact with the University and how often
• By defining these touch points and measuring them a scorecard of the students contact with the University can be created and students can be identified as being at risk
• The SOAP Opera 2 BI will be a key initiative to build such Key performance Indicators that will showcase the information from Data Warehouse which is populated from the STARTRAK application tables through an ETL approach
• A Qlikview reports engine is places on top of the Data Warehouse to create a reporting user interface to display the analysis reports and Dashboards using Qlikview as per Leeds Met requirement
• Hands on Development Skills:
• Involved in Understanding the Business Life Cycle
• Involved in Requirement Gatherings and Detail Design Documents Creation
• Involved in Designing Report Formats based on the Requirements
• Involved in development of QVD’s
• Involved in Development of Calculated measures for calculating various KPI’s like Day Score, Risk, Lowest Engagement, Medium Engagements and Highest Engagements using Qlikview
• Designed and Developed Various Reports, Dashboards and Charts
• Environment: Qlikview 9.0 SR2, SQL Server, Flat Files and Windows Server 2008.

• Raksha TPA Pvt
• Ltd is one of the premier and most comprehensive Health service facilitators
• With its vast experience as a Health Service provider, Raksha TPA has emerged as one of the leading Third-Party Administrators in providing Unique and innovative services through Web based technology linking the Insurer, Insured and Provider
• The concept of TPA (THIRD PARTY ADMINISTRATOR) has been introduced by IRDA (Insurance Regulatory and Development Authority) for the benefit of both the insured and the insurer
• While the insured is benefited by quicker & better service, insurers are benefited by reduction in their administrative costs, fraudulent claims and ultimately bringing down the claim ratios
• We Extracted the Insurers and Insured Details from Oracle to a Ware House and Generated Management and Analysis Reports
• Hands on Development Skills:
• Involved in the development of the Web Reports as a Team Player
• Created Functional specifications of the Business Requirements
• Developed Monthly, Quarterly and yearly reports for the management
• Involved in the development of the Complex Reports
• Involved in development of Reports and Customizing Portal using SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio, SAS Web Dashboard, SAS OLAP Viewer and SAS Information Portal
• Developed the reports using SAS functionalities like SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio, SAS Web Dashboard, SAS OLAP Viewer and SAS Information Portal
• Developed Management Reports using Different Layouts as Per Client requirements like Zero Premium Reports, Serviced, and Un-serviced Premium
• Environment: SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide, SAS Web Report Studio, SAS OLAP Viewer, SAS BI Dashboard and UNIX.

• This project is involved in the development of data warehouse for Am South Bank based on four kinds of data marts such as Accounts, Loans, Credit Cards and Insurance
• Each data marts represent a collection of data pertaining to a single business process
• In Loan data mart, Am South Bank involved in disbursal of loan amounts for various purposes like: Personal Loan, Educational Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans etc
• The company requires different levels of analysis regarding loan amount, type of loans, type of the penal interest calculations etc
• They needed a data warehouse so that they could maintain historical data and central location for integration, analyze business in different locations
• Hands on Development Skills:
• Created Functional specifications of the business requirements
• Involved in the development of ETL Packages using basic transformations
• Involved in the development of the Complex Reports
• Developing Reports and Customizing Reports using Tables, Matrix, List, Rectangle and Sub reports
• Developed the reports using Stored Procedures and OLAP
• Created and Deployed Reports and Satisfied the Clients with Efficient work and In-Time Delivery
• Extensively Worked on OLAP and MDX in Developing Complex Reports
• Creating User Parameters, Inserting Logos, validating Logos depending on the Parameter Passed by User
• Environment: Microsoft Integration Services 2005 (SSIS), Microsoft Analysis Services 2005 (SSAS), Microsoft Reporting Services 2005 (SSRS), Microsoft SQL Server 2005 and Windows 2000 Server

• The warehouse consists of business data related to automobile products
• The current business model of the client relies heavily on paper-based sales reporting to inform business and sales managers about performance, thereby lots of paper-based reports being accumulated
• This project enables business users to explore large volumes of summarized data within different environments at any technical and business level for performing multi-dimensional analysis, the monetary value of the products sold, pieces sold, analyze profit margins on different products and patterns, etc to help take effective decision-making judgments for improving their business and contribute to profitability
• Hands on Development Skills:
• Created Functional specifications of the business requirements
• Involved in the creation of the Complex Reports
• Developing Reports and Customizing Reports using Tables, Matrix, List, Rectangle and Sub reports
• Created the reports using Stored Procedures and OLAP
• Created and Deployed Reports and Satisfied the Clients with Efficient work and In-Time Delivery
• Extensively Worked on OLAP and MDX in Developing Reports
• Developed User Parameters, Inserting Logos, validating Logos depending on the Parameter Passed by User
• Environment: Microsoft Analysis Services 2005 (SSAS), Microsoft Reporting Services 2005 (SSRS), Microsoft SQL Server 2005 and Windows 2000 Server
• Page 6 of 6