Kamal Chavda Email & Phone Number

Atlanta, Ga, Us

Atlanta, Georgia, Us

Paddington, London, Gb

Atlanta, Georgia, Us

Atlanta, Georgia, Us

Atlanta, Georgia, Us

Migrate processes from legacy SSIS solutions to Apache Airflow and Databricks by implementing batch and streaming pipelinesSupport the development and implementation of data lake on AWS infrastructure (Athena, S3, EMR, etc.)Lead developer on two bank partner projects to onboard partner data to data warehouseResponsible for reviewing, approving, and deploying changes to production databases to support Kabbage.com.Design, develop, update, and deploy production ETL pipelines to migrate, transmit, consume data assets to internal and external stakeholdersMaintain and update data warehouse, analysis services, and reporting services processesPerformance tuning of long running queries and processes

Fort Lauderdale, Florida, Us

Lead developer on project for State of South Dakota Education System – Our product delivers School, District, and State level report cards using our Targeted Improvement System – Blender. Project required creating necessary back end tables, T-SQL stored procedures and functions to supporting bulk upload/download from ASP page, error logging and data validation for four different configurations, quick edit functionality allowing user to update individual metric for each configuration, developing, updating, and deploying MS SSRS 2008 R2 reports. Performance tune and debug T-SQL stored procedures Provide advanced technical support in the research, creation, business analysis and use of systems technology including architecture, integration capabilities and database management.Recognize and identify potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding future business expansion.Work closely with other IT groups to coordinate current and future plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment, the coordination of software upgrades and the installation of new products.

Atlanta, Ga, Us

Lead developer on Hortonworks HDP 2.0 development efforts. Worked with admin to install and configure clusterManaged all ETL processes associated with the eCRM process for our client, Verizon WirelessWorked with Architect on infrastructure projects and strategic initiatives Developed, updated, troubleshot, and optimized ETL packages designed in SSIS 2008 R2Designed and developed monitoring and reporting on automated file processing providing real time status on file processing and performance of eCRM campaigns using T-SQL functions and stored procedures. Participated in interview process for new team membersProvided training for new team members Gathered business requirements from Campaign Mangers and converted to code/logic in ETL packages using T-SQL functions and stored procedures.Worked with Business Analysts and Project managers using Agile methodologies Nominated for and completed in-house leadership program

New York, Ny, Us

Developed SSIS ETL packages for migration of data from acquisitionsUpdated and maintained ETL packages and T-SQL code for nightly load from production to ODS and Data WarehouseDeveloped, documented, and deployed production application database changes to the Data WarehouseCompleted a project for internal reporting on support ticket metrics. Involved setting up replication and installing and configuring SSRS server.

Atlanta, Ga, Us

Develop, design, and administer SQL Server 2008 R2 data warehouse architectureMonitor usage of data resources and analyze and resolve database performance issuesDevelop data relationship modelsAutomate data retrieval and storage processes using SSIS 2008 R2Perform data replication, extraction, loading, cleansing, and data modeling for production and development data warehouseInteract effectively with user community to produce analysis results and analytics requirementsParticipate in steering committee meetings to prioritize projects and negotiate deadlinesTechnical lead in multiple cost saving and revenue impacting initiatives which involved interacting with internal and external clients Creating user guides and documentation

Atlanta, Ga, Us

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008 R2.Developed dashboards for senior management and company-wide consumption.Responsible for ongoing maintenance and change management to existing reports and optimize report performance.Implemented automated solutions to provide data to third party vendors utilizing SSIS 2005/2008 R2.Maintained, monitored, and developed production and development data warehouse and SSAS 2008 R2 Cube.Installed and upgraded SQL Servers from SQL Server 2005 to SQL Server 2008 R2.Captured requirements from users and evaluated best form of delivery be it report manager report, refreshable excel spreadsheet using stored procedures, or SSAS Cube.Performed database administrator duties such as server security, query optimization, storage management, indexing, replication, backups, restores, monitoring production jobs, and being on on-call rotation.

Atlanta, Georgia, Us

Atlanta, Georgia, Us

• Analyzed client data in original system-specific format (ASCII, EBCDIC, etc.) and loaded it into SQL Server 2000 databases using ETL tools such as Informatica, Data Junction, Monarch, and other in house tools• Participated in client data acquisition activities to determine requirements and provided technical data format support• Programmatically converted/created new client data definitions• Comprehensive understanding of network architecture and space management• Trained, supervised, and aided in the development of new employees

Atlanta, Georgia, Us

• Responsible for the EOM audit, review, research, and reconciliation of physical inventories for multiple distribution centers• Communicate directly with distribution center manager to discuss inventory related issues • Run variance report and pull purchase journal to build database and voucher queries