Gokul Vinoth Kumar Balakrishnan Email & Phone Number

Richmond, Virginia, United States

Richmond, Virginia

Pittsburgh, Pennsylvania

United States

Developed a cognitive engine that predicted disease onset based on weather conditions across the United StatesExtracted Weather data from IBM weather API using Python ScriptsCreated R scripts to merge daily aggregate of weather and health claims data at a Metropolitan Statistical Area levelSelected relevant features from weather and health data by performing correlation analysisDeveloped Statistical models in R to predict disease exacerbations in individual geographies across the USAnalyzed longitudinal patient records and defined clusters for patients diagnosed with Multiple SclerosisReported characteristics of patients in each cohort and mapped their clinical journeyPerformed Extract, Transform and Load operation on data from disparate sources to set up reports for analysis of healthcare products offered by the payerDeveloped sales pitches to pharmaceutical clients for vaccinations and multiple disease areas by leveraging Real World Evidence Data available from IBM assets

Greater Pittsburgh Area

Worked with Professor to develop course contentConducted class activities for students to participate in experiential learning of Agile TechnologiesCreated and graded assignments submitted by students

Greater Pittsburgh Area

Conducted weekly office hours to guide students on database concepts like ER Modelling, Normalization and advance SQL Evaluated and graded assignments submitted by the students

Chennai Area, India

Led a team of 5 that designed and developed DataStage based ETL solutions for a USA based Retail Client

Chennai Area, India

Client - Leading Multi-Channel e-Commerce corporationDeveloped reports and dashboards in MS Excel and Tableau to analyze performance of individual seller and categories.Reported the performance of coupons and success of marketing campaigns to pursue targeted marketing for each seller and buyer segments.Automated weekly and monthly recurring reports on Top sellers and customer segments, reducing manual efforts by 16 hours per week.

Chennai Area, India

Client - Leading Retailer in UK Created and implemented execution plans to migrate 18 DataStage projects from versions 8.0.1 and 8.1 to 8.5Modified application and project level parameters in ETL to improve performance by 20% and reduce errors in execution.Optimized SQL queries to improve performance of Business Objects reports by 50%Re-engineered the existing data model to correct multiple flaws in reporting sales and returnsDefined and documented design principles to validate ETL jobs before deployment in production

London, United Kingdom

Client - Leading Retailer in UKConducted periodic reconciliations to reduce data discrepancy between multiple reporting platforms from 10% to 2%Performed requirement mapping to guide the incumbent development team in design and development of reports for the new multi-channel implementationManaged consultants from multiple vendors to resolve data issues that improved accuracy of reporting by 5%

London, United Kingdom

Client - Leading Retailer in UKDesigned and implemented the new DataStage architecture to use a local file system as opposed to a network shared file system to resolve performance issuesRe-designed the architecture of the Business Objects services from a vertical to a horizontal arrangementAchieved better load balancing of report requests by cloning Business Objects Web Intelligence servers at a service level Worked with lead solutions architect to set up road map for various environments used in multiple phases of development

Chennai Area, India

Client - Leading Retailer in UKOptimized SQL queries to improve performance of Business Objects reports by 50%Modified application and project level parameters in ETL to improve performance by 20% and reduce errors in execution.Incorporated optimization techniques available in the ETL tool set up to reduce the execution time for 3 jobs cumulatively from 90 minutes to 90 seconds. This increased the report availability time by 90 minutes

Chennai Area, India

Master Of Information Systems Management, Management Information Systems, General

Bachelor Of Engineering (Beng), Electrical, Electronics And Communications Engineering