Badri Narayanan Kannan

Master's

Management Information Systems

IBM

DATA Analyst

• • Built an application to expedite data management for extraction, merging, data cleansing, aggregation, and data profiling of over 270 million business records for creating marketing reports, maps and market insights using SAS. • • Created the master data files for customers like Microsoft and Dell which involved checking the data integrity, data migration, creating data backups and optimizing the data for high scalability and efficiency. • • Formulated sophisticated models like Market Insight, Customer Insight and data append which have helped to generate higher revenue for clients from Fortune 500 companies and produce descriptive statistics using SAS Macros. • • Implemented customized ad-hoc solutions by extracting, merging and cleaning multiple tables using SQL Joins and query optimization on the old ones by removing bushy joins, indexing, setting constraints and measuring redundancy. • • Generated Market Penetration Analysis reports, this has helped to research the changing market extensively and developed comprehensive solutions to boost the profitability and streamline operations. • • Automated the creation of master files using job triggers and SQL thereby eliminating human errors by 80 percent and creating performance measures and monitor data transfer error logs to validate the data accuracy. • • Delegated meetings and discussions to understand the product requirements and formulated methods to achieve the requirements thus decreasing the turnaround time by 40 percent. • • Handling ad-hoc maps with historical data including exploratory data analysis and creating BI dashboards, business intelligence and financial reports that have boosted the revenue by 20 percent. • • Lead the team in analyzing highly analytical requirements involving source to target mapping and collaborate with cross-functional teams on business solutions, thus doubling the productivity of the team