Resume

Sign in

SQL Developer/Data Analyst

Location:
Sterling, Virginia, United States
Posted:
August 13, 2018

Contact this candidate

Resume:

RAVI GADDAM

202-***-****

https://www.linkedin.com/in/ravi-gaddam

****.******@*****.***

Results-oriented, self-motivated database developer/dba and application software developer with experience in analysis, design, development, testing and implementation of various web applications. I am proficient in database design and coding with a MCITP certification. I also have expertise in electronic discovery, litigation consulting and developing e-discovery solutions using Microsoft technologies. Technical proficiencies include….

Extensive knowledge in setting up and configuring SQL Server databases.

Experience in various utilities like BCP, BULK INSERT, DBCC, SQL Profiler.

Excellent skills in setting up linked servers and distributed queries.

Expertise in various database activities like Backup and Recovery and Performance

monitoring/Tuning.

Experience in T-SQL, Data Modeling, Database Mirroring and SQL Server Replication.

Experience in SQL Reporting Services (SSRS), SQL Integration Services (SSIS)/DTS/ETL and SSAS.

Experience in writing database backend testing using TSQLT.

Extensive working knowledge on EXTJS (Sencha), C#.Net, VB.Net, AJAX, Web Forms, Java script,

VB, ASP, HTML, CSS, XML, JQuery, MS Access, C, Crystal Reports.

Experience in designing front-end web forms using EXTJS (Sencha) and C#.

Good Knowledge in Oracle, Sybase.

Excellent troubleshooting /problem solving skills.

Excellent written/verbal communication, leadership and teamwork skills.

PROFESSIONAL EXPERIENCE

FTI Consulting Inc, Mclean 08/2017 – Present

Working a Rail Road project which involves extensive data analysis involving huge volumes of data.

SQL Database Developer/Data Analyst

Created complex T-SQL queries for generating reports by working on large data files/tables with an average of 70-80 million rows and more than 100 columns.

Automated Uploading huge text files using bulk insert/xp_cmdshell without manual intervention.

Developed optimized data collection and qualifying procedures.

Fine-tuned large tables using a combination of indexing/updating statistics, modifying queries etc.

Automated uploading Excel files which had tab combinations of various lengths into SQL.

Developed an ASP.Net C# application by using Google API to calculate distance between Railroad/Truck Shipper and Consignee to make sure that reported mileage by client is consistent.

Automated uploading Access databases into SQL Server and report generation for Senior Management after analysis as per requirements.

FTI Consulting Inc, Washington D.C/Mclean 06/2005 – 12/2016

FTI Consulting specializes in the fields of forensic and litigation consulting, strategic communications and technology. The Technology practice offers clients a comprehensive portfolio of e-discovery software, services and consulting support. FTI’s Ringtail Discovery Software Suite, provides e-discovery and document management tools to assist corporations and law firms during litigation engagements.

Database/Web Developer

Design, develop and implement database schema and web applications that support day-to-day operations for e-discovery issues.

Extensive experience with T-SQL in constructing Stored Procedures, Functions, Views and Triggers for various applications and data modeling.

Designed and implemented SSIS packages to ETL data from various sources like flat files, MS Access, and Excel.

Worked on large data migrations and VLDB’s.

Created reports using SSRS and jobs for data processing.

Implemented and optimized queries, stored procedures for improved performance.

Worked on production support for upgrades and critical issues.

Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Prepare automated unit tests (tSQLt) for database code coverage.

Designed and implemented e-discovery front-end applications which process and extract meta-data from PST files, and from around 3000 loose files.

Developed OCR for PDF application. This application reduced the work load by 80%. Duties involved complete design of front-end, database and writing all the code.

Project Lead for all the above applications. Coordinated with product owners and stake holders to prioritize backlog items (triage) and then groom the items.

Lead the development standards forum within the organization to ensure that every developer follows the dev standards and delivers the right code.

Team Foundation Server (TFS) was used for version control. Shelving, merging changes along with code reviews was a daily activity.

Responsibilities included designing the database schema, stored procedures and implementation of UI forms using C# as middle-tier.

Solidified the applications by writing test cases for each of the layers, UIStatic tests (Siesta framework), middle-tier tests (Xunit) and database tests (tSQLt). These tests ensured that we had an 80% code coverage.

Experience in providing day-to-day production support, bug fixes and enhancements.

Agile practice of continuous integration and test-driven development was followed.

Worked on Ringtail project which is a processing, review tool for e-discovery process developed in C# with ExtJS (Sencha) as front-end framework.

Successfully delivered various modules in Ringtail Application using EXTJS, HTML, JavaScript, CSS, MVC and SQL Server.

Created various modules for Predictive Analysis in the e-discovery process.

Created database tables, stored procedures, functions for the Notifications project and implemented them within Ringtail Data Access Layer.

Worked with Language-Integrated Query (LINQ) to retrieve and modify data.

Tier Technologies, Reston, VA 10/2004 – 06/2005

Software Engineer

Involved in the design and development of $89M child support payment processing application for Michigan State disbursement unit. The application managed the receipt of the child support payment and disbursement of the funds efficiently and accurately.

Developed SQL stored procedures and DTS packages which takes data from excel and dumps the data in database as per business logic.

Developed security and encryption DLL’s which are integrated into the application.

Developed security component which has features for add/update/delete users, assign users to separate groups based on user role.

Developed Encryption DLL which encrypts/decrypts the user password and stores this in the database.

Develop and publish dynamic web-based Crystal Reports.

Aligned Development Strategies Inc, Washington DC 07/2003 – 10/2004

Software Engineer

HIPPA Compliance ePartner from Aligned Development Strategies (ADSI) is a web-based application that supports the communication and tracking needs of an organization complying with the Health Insurance Portability and Accessibility Act (HIPAA) regulations. Core modules included Training, Policies and Procedures, Complaints, Disclosures Tracking, Individual Rights and Management Reporting.

Developed SQL Server functions, triggers and stored procedures and was the main POC for support.

Designed and developed web pages based upon customization requests from the client.

Designed and developed Security module which helps the administrator assign rights based on user roles.

Developed a VB email module which automatically sends e-messages to the Privacy officers when an Authorization or a request expires.

Logicon Inc/Northrop Grumman, Arlington, VA 03/1999 – 06/2003

Web Developer

Visa Information Service and Tracking of Applicants (VISTA) is a web-based document imaging and workflow management application which helps automate the process of issuing Visas to legitimate foreign travelers and denying entry to ineligible foreign nationals and is developed for DEPARTMENT OF STATE (DOS). The system uses an Oracle 8.0 RDBMS as the server on a Windows NT/2000 operating system with Visual Basic 6.0, IIS, Visual Interdev, Eastman Workflow, Crystal Reports and other Third-party tools.

Designed and developed dynamic interactive web pages (Active Server Pages) in Visual Interdev 6.0 delivered to users via the DOS Intranet

Developed out-of-process COM components using ActiveX DLL’s that reduced DOS personnel work load by 50%. Designed and developed Crystal Reports.

Developed Menu navigation system for VISTA using JavaScript.

Designed and developed Oracle SQL scripts.

Provided user training to customers/software installation at Department of State

Cinergy, Cincinnati, OH 03/1998 – 12/1998

Visual Basic Developer

Designed and developed a front-end tool called Feeder Direct Reporting (FDR) tool. FDR Tool was one of the tools in the Business Data Management System (BDMS) project, acronym for Cinergy’s financial and accounting system. BDMS basically is a system that accepts transactions from feeder systems, performs some validations on these transactions, and creates additional records to meet Cinergy’s external reporting needs. This tool will provide access to managers and others who have a need for quick access to transactions that have been entered through the accounting system feeder systems (payroll, accounts payable, Inventory, etc.). The information is displayed both in Crystal Report windows and graphically, and can be printed, e-mailed, or exported to other formats, such as Excel or Word. Responsibilities included designing front-end screens and writing business logic. Use of crystal reports 6.0 for reporting and Pinnacle Graphics Server 5.0 for ActiveX controls was used. Also, involved in technical and database design.

Technical Environment: VB 5.0, Windows NT, Crystal Reports 6.0, Sybase SQL Server.

EDUCATION

MS (Electrical Engineering/Computer Science), SDSU, Brookings, South Dakota

BS (Electronics & Communication), Osmania University, India

MCITP: Database Developer on SQL Server 2005

MCTS: SQL Server 2005



Contact this candidate