Vikram Gopal Konchady Email & Phone Number

Washington, Dc, Us

United States

Norfolk, Virginia Area

▪ Developed key metrics used by Executive team to track organizational health and growth by consulting Sales, Digital Marketing, Consumer Marketing, Strategy, Finance, Human Resources and Web Design Teams▪ Proposed a currently operational data architecture to integrate the various data sources with Amazon Redshift, RStudio and Power BI▪ Installed RStudio Server on Amazon EC2 instance; Performed exploratory data analysis using RStudio Server to assist the executive teams to uncover hidden customer behavior and identify opportunities for revenue growth▪ Created and automated the Executive Dashboards and reports using Microsoft Power BI thereby increasing the operational efficiency of the workforce by 70%, and enabling real-time access of data visualization and tracking▪ Forecasted website growth metrics (Visitors, Unique Visitors, Connections, Conversion rate) using open source package from Facebook: Prophet and compared with actuals; Rendered visualizations using Power BI

Charlottesville, Virginia Area

Performed ROI and scalability analysis and built a scalable financial model to build a new visitor center of the client to increase the visits to the museum. Provided recommendations to leverage the existing opportunities and build new value adds to increase visitation.As a data science consultant, I:• Performed exploratory analysis on the museum visits data using R and rendered visualizations using Power BI and R:o Analyzed the distribution of visits across different seasons, years, months, day of month, and day of week using boxplots and histograms.o Created an average daily visits distribution by month and day of week to a) Get an idea of the seasonality and variation of the visits, and b) Get an idea of how an average day of the week looks like to build a visitor center of the right scale.o Analyzed the trends in core, rental, and program visits by segregating the time series data.• Built a forecasting model to forecast the visits for next five years and performed a causal impact analysis on the time series to incorporate the effect of a new visitor center. The numbers from the forecasting model was used to build the budgeted income statement for next five years and to analyze the ROI of the new visitor center.• Performed preliminary marketing data analysis:o Web scraped the user reviews and built a word cloud to understand the key value propositions of the museum and pain points of the customers.o Performed regression analysis to analyze the key drivers of visits to the museums and recommended a targeted digital marketing plan to increase visits.

Bengaluru Area, India | Macclesfield, United Kingdom

• Led a team of 13 for setting up routing (data transfer) channels between the client and its 500 business partners.• Prepared and negotiated cost estimates in bids worth $3.5M.• Designed a new integration method that eliminated the need for an intermediate server between middleware and application, thereby reducing annual running costs by 30%.• Supervised 7 functional teams comprising 14 people for a large-scale Data center migration program.As a Cognizant Middleware Lead, I: Closely interacted with Middleware teams of other stakeholders to gather the technical inputs for each instance and database type in Middleware and verifying them against the Master Repository sheet in order to identify the Cognizant scoped servers. Prepared a Middleware screenshot based on the inputs outlining the total servers, servers under migration scope, potential decommission servers and the orphan servers. The screenshot also outlined the infrastructure details of all the Middleware components server wise thereby suggesting a migration plan in line with the goals of the DC migration program. Analyzed and therefore prepared a dedicated list of Orphan servers which contained the appropriate mapping between the Middleware and the Application residing in the respective servers.• Identified redundancies and decommissioned servers during migration, leading to $2M of savings in annual hardware and software licensing costs.• Rated as a top performer for three consecutive years; earning top two ratings for all three years, given only to top 10% of employees.• Recognized for excellent client management; earned additional allowance over and above annual salary awarded only to top 10% of associates.• Winner of All India Business Practice Blog Competition- Recognized as one of the top five technical blogs in EAS-IPM business practice comprising over 1000 associates.

Bangalore

• Handpicked from 50 people to assume team leader responsibility at Macclesfield, UK. Replaced incumbent two levels more senior• Developed a data transfer model for ambitious procurement system worth $4M for business users across multiple geographies: EMEA, APAC, and NAM:As a part of this Build project, Cognizant was handed the responsibility of implementing a secure channel to route the data to the external trading partner of the client. The client had decided to build a procurement tool housed in a SAP environment in an external environment which necessitated the creation of a secure channel to load all the user and DOA (Delegation of Authority) data, Scanned invoices for direct and indirect materials and also import the Purchase order status into the procurement tool. A special integration method had to be devised to integrate the client tool and Axway Gateway Interchange to render the data SAP environment compliant.• Automated file failure reports used in weekly service reports and (automated) server health check that led to 70% increase in operational efficiency of the workforce.• Awarded “Marvelous Mentor” for mentoring 60 project joiners on Middleware technology and client engagement best practices.

Bengaluru Area, India

Spearheaded business continuity plan to be invoked in case of unforeseen disasterImproved the data transfer process by deploying automated scripts reducing the process time by 40%Awarded “Oscar of the month” for contribution in service improvements and automation

Mangalore Area, India

In-plant training at BASF India Limited:• Worked on the production of nitrogen by PSA (pressure swing adsorption) system controlled by a microcontroller and changeover valves.• Conceptualized the working of motors and their speed control by VFD (variable frequency drive).• Learnt about the electrical distribution system.

Master Of Business Administration - Mba, Business Analytics

Activities and Societies: Leadership: VP - OPS & IT Club, Board Member - International Student Advisory BoardCoursework: Data Science Lean.

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering

Activities and Societies: Performed Summer Project at Central Power Research Institute: “Correlation between some major electrical.

High School

Awarded "certificate of merit" for securing first place in Social science (97%) CBSE examination 2003-04