SUMMARY:

SQL Server development, Application Management, Document Management System Engineer, SharePoint Administrator/Developer in Law Firm, Experience includes full life cycle Web, Windows, Mainframe, SQL Server and Report Application development by using technologies such as SharePoint, Database analyzing, BI and Data Virtualization. Programmer/Analyst with strong .NET, HTML, JavaScript, MS Access and DBA Skills

TECHNICAL KNOWLEDGE:

DBMS: SQL Server 2000/2005/2008/2012/2014/2016 , T - SQL, MySQL, ETL, SSIS, SSRS, AlwaysOn OpenText DM system, Elite 3E 2.8, Elite 3.7/Webview 5.5, SharePoint 2007/2010/2013 , InterAction, BigHand, LegalKey, LexisNexis, Ethical Wall, NuancePDF, LiveNote, SummationAD, UniversitySite

Programming Language: Visual Basic.Net, Java, Visual C#.Net, Visual Basic6.0, Cold-Fusion, IDE, ASP, ASP.Net, ADO.Net, WordML, HTML, JavaScript, VBScript, C/C++, XML, ODBC

System: Xen Desktop, Citrix, Windows Server 2008, Windows Server 2012, Windows7, Windows10

Others: Crystal Reports, Tableau, Adobe graphics, ERWin modeler, WebTrends, Oracle, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Hoboken, NJ

SQL Server Database, SSIS, SSRS Developer, DBA

Responsibilities:

• Created SSIS package to import data from Excel, CSV, XML and text files to data warehouse database in SQL Server. After data was imported to the database tables, the data files were moved to archive directory in the data server. Also, setup SSIS to transform data from data warehouse server to reports server.
• Designed, tested, SSRS reports for a pharmaceutical business on inventory, purchase order, sales, charge back and invoice by using Microsoft Visual Studio; Deployed to domestic server and SharePoint server; Setup reports delivery options in SQL Server Reporting Services to deliver reports by email/file share, render format and schedules for accounting, charge back, sales department and firm management team.
• Created maintenance plans in SQL Server for development server, production data warehouse server and reports server; Created database, backup/restore database as needed for different applications. Documented all designing works, settings and code in queries.

Confidential, Matawan, NJ

Contract Consultant

Responsibilities:

• Completed Analysis, design, customization and integration on Thomson Elite 3E and Connect data structures. Job includes communicating with financial department user, analyzing requirement and creating documents, mapping the database tables and attributes in two application databases, creating data transforming between two applications in SSIS to implement the ETL in 15 minutes based scheduled jobs.
• Application configuration, custom designing and setting on the Elite 3E Dashboard, Security Tree, Reports in IDE the Elite development tool on Archetype/OQL, Object/Code, Form, Page and Process level.
• Worked with vender and the development team closely to Create and update Software Requirements Specification (SRS) documents, acceptance test scripts and other documents on Billing, Entity intake, Client/Matter, Timekeeper, Proforma, Trust etc. to guide the development, testing and Go - Live processing.

Confidential, New York, NY

Database Developer/Administrator

Responsibilities:

• Creating, setting up disaster recovery database server for the SharePoint intranet site of the firm, creating, setting up, maintaining maintenance plans for SQL Server database in firm’s production server and development server and writing stored procedure to analyze the behavior and performance of the SharePoint sites.
• Analyze the performance of SQL Server databases, including index usage, query syntax enhancements and configuration changes.
• Setup and configure Transaction Log Shipping on primary database in production server, secondary database in DR production server to copy the T-log files and restore the databases.
• Setup, test and monitor database maintenance plans including backup (in local and DR servers) and restore.
• Wrote T-SQL code and create stored procedures in SSMS to analyze the data flow, errors in reports of SharePoint intranet site and the status and performance of databases.

SharePoint Administrator

Confidential

Responsibilities:

• Built disaster recovery SharePoint intranet site of a global firm and setup DR services, resolved issues on SharePoint intranet sites of firm and document the solutions on the knowledge base of the firm.
• Setup, configure SharePoint application in DR site which is located in other state.
• Setup the domain property to SharePoint server farm to speed up the people searching of the intranet sites.
• Figured out the reason and fix the RSS feed missing issue on the intranet sites.
• Configured and setup the Site Collection Web Analytics reports on the intranet sites of the firm.
• Analyzed deeply on the errors in the search and resolved the issue in the configuration on the Workflow timer and data processing in Central Administration and database level.

Confidential, Ewing, NJ

SQL Server Database Developer

Responsibilities:

• Created new banking statement from SQL Server database by creating complex queries.
• Updated in SQL Server database on tables, views, stored procedures and reports according to the new business requirements.
• Generated customized reports from writing TSQL code in database to apply the code in reports tools to generate reports in Tableau for the clients according to the business upgrade and security rules updates.

Confidential, Newark, NJ

Database Developer/Administrator

Responsibilities:

• In charge creating, setting up, maintaining, evaluating, tuning and updating databases (e.g. database tables, views, stored procedures, triggers, Indexes, SSIS, SSAS, SSRS for 142 databases in 27 servers/instances). Provide data extracting, transforming and loading (ETL) by creating DTS/SSIS Packages in Elite DB and other application databases. These packages synchronized the new client/matter information to all other application databases after new client /matter intake processing finished in Elite DB and upload applications data to Elite DB at month end.
• Custom designed and created reports (SSRS, Crystal Reports, Excel, Tableau) from Elite DB and all other application databases.
• Also deployed reports on the firm s intranet or other reports viewer. Those reports helped executive management team to manage the performance of the firm also helped the finance department to work on the month - end closing.
• Analyzed database response time and determine optimization and tuning options to improve database performance.
• Analyzed data in databases to find out the root of the issues in the firm s applications and fix problems to improve their functions. Wrote T-SQL code to process data in database for maintenance, data processing and reporting purposes.
• Setup, tested and monitored database maintenance plans including backup (in local and DR) and recovery.
• Setup log shipping procedure on Elite DB to send T-log files to DR server in every 15 minutes and full backup files to DR server every 3 days.
• Planed and tested recovering procedures in the event of disasters and maintaining technical documentation.
• These provided the high availability of Elite DB, the center finance database of the firm.
• Coordinating with vendors, MIS engineers and accounting managers to install, configure backend databases of applications in the servers of the firm, configure to other applications for accounting department and set up users;
• Coordinating with senior management of the firm to develop and implement the firm-wide policies and group policies to assigned programs and/or databases;
• Developed Expert System for different practice department by using C#.net, ASP.net;
• Upgrading applications and databases into new versions;
• Created Client/Matter intake workflow applications.