Kani Venkatesan

Experience

• 

  National Board for Professional Teaching Standards

  Sept 2002 - Mar 2013

  • Migrated databases from SQL Server 2000 to SQL Server 2005 and from 2005 to SQL Server 2008 • Validated the migrated databases• Rewrote/ Converted DTS packages to SSIS• Wrote complex stored procedures and queries for all applications developed• Responsible for data synchronizations between two organizations that were using SQL Server and Oracle• Automated the routine task of extracting and updating the database with data files from remote locations• Automated the extraction and delivery of data to end-users• Provided complex reports on a needed basis • Trained the junior DBATools and EnvironmentMS SQL Server 2008/2005/2000, DTS, SSIS, Visual Basic, ColdFusion Show less • Responsible for the installation and configuration of SQL server database on Dell Servers• Responsible for data modeling. Created ER diagrams using ER Win• Implemented database standards and naming convention for database objects• Responsible for loading the partner flat files into the OLTP database• Developed DTS packages to extract, transform and load data into the company database from OLTP data• Developed the T-SQL stored procedures/functions to process the data and populate them in the appropriate destination tables• Created and configured an OLTP replication database for disaster recovery purpose• Responsible for database backup and recovery• Created a data warehouse to maintain historical data• Worked with developers to fine-tune SQL queries• Built standard reports using Crystal Reports and ColdFusion• Built complex ad-hoc reportsTools and EnvironmentMS SQL Server 2005/2000, DTS, VB 6, ColdFusion Show less • Creating stored procedures to automate database transactions• Created script files to create databases and to perform needed transactions on the database• Extracted data from the database and loaded it into remote web sites• Extensively used 3rd party DLL’s in MS Excel to import and refresh data dynamically from the database • Imported vendor created files into the database • Created ad hoc reports and provided the data in MS Excel • Created and managed standard reports for various departments using Crystal Reports • Provided front-end support and training to users in the organizationTools and EnvironmentSQL Server 2000, MS Excel, iMIS, PC Anywhere and Crystal Reports. Show less

  • Database Consultant

    Mar 2007 - Mar 2013

  • Database Administrator

    Aug 2003 - Feb 2007

  • Database Specialist

    Sept 2002 - Jul 2003
• 

  IStream Solutions

  Oct 2011 - Nov 2013

  Database Consultant

  • Responsible for analyzing the available data sources and existing databases for planning and working out a solution to integrate/ consolidate data based on business needs. This involved data that required cleansing and formatting before linking• Migrated and validated data from heterogeneous data sources (Oracle, Access, Excel, Flat files) to centralized SQL Server 2012 using SSIS• Migrated and validated data from SQL Server 2008 to SQL Server 2012 as part of the upgrade process• Created needed database objects – views, triggers, functions, stored procedures, indexes for application and reporting needs• Implemented database standards for capturing and formatting data• Analyzed long running slow queries and fine-tuned them to optimize application and system performance• Designed and deployed SSRS reports utilizing varied databases and data sources according to the user needs of the organization• Automated weekly file uploads to clients using ETL solutions• Extensively used SQL Server Data Tools (SSDT)• Working as a consultant providing services for the company on a needed basisTools and EnvironmentMS SQL Server 2012/2008, Visual Studio, TFS, SSIS, SSDT Show less

• 

  EPlus inc.

  Nov 2013 - Aug 2017

  Database Administrator

  • Managed and maintained all development and testing database servers/ environments which were housed both internally and externally• Designed and developed SQL Server components, SQL agent jobs, push/pull subscriptions, replications, performance tuning, etc., to satisfy end-user and development needs of the organization• Developed SSIS packages and ETL solutions to load data from external sources, update internal databases based on data received to provide updated information for analysis and reports to various departments on a daily basis• Automated the task of updating leasing information which involved ETL solutions to extract, cleanse and format data before integrating with local database• Troubleshot and resolved all SQL Server database issues (e.g., integrity, performance, blocking and deadlocking, replication, connectivity, security, etc.)• Monitored and troubleshot SQL agent jobs for failure (data loads, reporting, scheduling, etc.,)• Identified indexing issues including missing indexes and redundant indexes that were responsible for slow running queries to improve response time on applications and reports• Worked closely with software engineers and stakeholders to help determine, design and develop data mining and reporting needs for the organization• Worked with corporate production DBAs to provide operational support, resolve recurring problems, and engineer database solutions• Supported database-related initiatives e.g., integrations, data marts, data warehousing, and reporting/BITools and EnvironmentMS SQL Server 2014/2012/2008, SSIS, SSRS, SSAS, Visual Studio, AccuRev, vSphere Show less

• 

  Alion Science and Technology

  Nov 2019 - Apr 2020

  Business Intelligence Consultant

  SQL & Business Intelligence Developer • Work with business development teams and stakeholders to gather requirements, design and develop data mining and reporting solutions• Develop strategies for report implementation, data acquisition, and archive recovery• Work with key business users to identify and rectify any issues with data and/or performance • Collaborate with application developers, database administrators, and the IT team to coordinate the creation and implementations of BI solutions• Use SSIS to develop ETL processes to acquire & load data from internal and external sources• Proficient in creating calculations, parameters, actions, charts, and graphs• Responsible for performance tuning, query optimizations, reverse engineer solutions, troubleshoot and resolving data issues• Demonstrate ability to work both in an independent and team-oriented environment with exceptional communication skillsTools and EnvironmentMS SQL Server 2012/2008, SSIS, SSRS, Visual Studio Show less

• 

  The Nature Conservancy

  Apr 2020 - now

  • Associate Director, Marketing Data Engineering

    Mar 2024 - now

  • Sr. Data Engineer

    Jan 2022 - Apr 2024

  • Sr. Database Developer & Support Engineer

    Apr 2020 - Jan 2022