Technical Consultant

• Apr 2020 - Present

• Developed SQL backend-based document migration solutions for iManage product for various Ascertus clients. Created SQL Databases, tables, stored procedures, views, constrains indexes, agent jobs, synonyms for document migration data mapping projects. • Build beginning to end document migration process using Interface. • Run document migration from various sources and other DMSs to iManage on-prem/Cloud environment. In last few years I ran migration from SOS, Partner for Windows, Envision, SharePoint, netDocuments, and File store with structured and unstructured folder structures. I used Interface, Litera Cloud Migrator, Ascertus Folder Import tool to run those migration. Ran document migration to on-prem iManage and cloud iManage. • Wrote SQL script and fix on-prem iManage data issues before running Litera cloud migrator to migrate documents into iManage Cloud. • Developed CAM/Interface integration from Various different PMS Systems to create workspaces in iManage environment. Mapped workspaces metadata accordingly. • Run document & metadata export project from iManage environment to network share. • Meeting with client and get document migration requirements and prepare design document. • Wrote CAM handover to support document. • Wrote PowerShell to manipulate workspaces/documents metadata in iManage cloud. • Helped Ascertus support team to fix SQL related issue. • Helped Ascertus sales team to identify number of days required to run the project and tool can be used to complete the tasks.

Consultant

• Nov 2017 - Apr 2020

• Developed SQL backend based solutions for iManage product for Phoenix clients. Created SQL Databases, tables, stored procedures, views, constrains indexes, agent jobs, and synonyms. • Develop and implement Workspace Control (WSC) backend solution for Phoenix client. WSC is used for iManage Work Workspace creation, metadata update and Archiving solution. WSC used for integration between client source PMS and iManage Work. • Write SQL script’s for managing and changing user access. Migrating metadata from one SQL database to another. • IManage Work database document renumbering to synchronize document number in archiving solution. • Client data cleansing, data report development for document management system. • Developed and prepare migration scripts to migrate documents to WorkSite from other document management system for legal firm. Migration script been used to import documents and update metadata for document import to Document management system. Also, prepare and write delta migration scripts to find new and edited documents for document migration. • Worked as a backend support analyst to identify and resolve any SQL Server critical issues. • Developed SSIS DTS (ETL) packages for Phoenix client that information been used for workspace creation. • Prepare Business/System requirements or process documents for client. • Write complex TSQL Scripts for apply workspace security through Workspace Control. • Help support team to resolve any issues if support unable to resolve. • Worked with iManage 10+ upgrade projects to update iManage work from lower versions.

Technical Consultant

• Jan 2015 - Nov 2017

• Developed SQL backend based solutions for HP iManage product for Tikit clients. Creating Database, tables, Sps, views, constrains indexes, agent jobs, and synonyms. • Developed Integration database to communicate between PMS and iManage WorkSite database. • Developed and prepare migration script to migrate documents to WorkSite from other document management system for Tikit world class legal firm. • Worked as a backend support analyst to identify and resolve any SQL Server critical issues. • Developed SSIS packages for Tikit client. • Developed SSRS report for Tikit clients and internal higher management. • Prepare Business/System requirements or process documents for Tikit client. • Configure and install HighQ connector that helps legal client to collaborate legal document to upload to a secured link. • Work with sales team to understand client requirements and estimate the effort require for the project. • Help support team to resolve any SQL server/TSQL issue and work as a third line support.

Data Analyst/Developer

• Mar 2014 - Jul 2014

Managed PPI Reconciliation implementing changes for applications Case Viewers and Self Service MI (SSMI) Worked closely with business team to implement change requirements Analyzed, designed and deployed it (SQL Server, Access, Excel, VBA, Visio, SharePoint) Built changes in test environment and worked with test team to go through the test process Implemented those changes and documented in share point site Built reconciliation dashboards for higher management for Lloyd’s Banking Group using SSRS. Used Excel VBA for data analysis and power point for higher level reporting Worked with SSIS sys packages, to identify the change required, Impact analysis and deployed it Worked to help testing migration data in Pre-production and production environment in SQL Server 2008

Report Developer

• Jan 2014 - Jan 2014

Worked with HR to fix SSRS reports Created reporting environment using Visual Studio and MS SQL Server and loaded existing files Analyzed problems of existing reports and made proposal of changes Used SQL Server; excel VBA, Access VBA to analyze the data and compared with SSRS. Redesigned front end (MS BI) and back end stored procedures to implement changes and documented it. Worked with HR to fix SSRS reports Created reporting environment using Visual Studio and MS SQL Server and loaded existing files Analyzed problems of existing reports and made proposal of changes Used SQL Server; excel VBA, Access VBA to analyze the data and compared with SSRS. Redesigned front end (MS BI) and back end stored procedures to implement changes and documented it.

Database Developer/Analyst

• May 2013 - Jul 2013

• Developed Process Improvement module (Validation Process) for DeliverIT database. Create SQL Server tables, Views, Functions, Stored Procedures, Triggers to develop the backend and used Access/VBA to develop the front end. • Build Data Dictionary for DeliverIT database. • Developed User Manual for DeliverIT. • Design and developed some customized report in SSRS • Developed some module for Book of Work database. Used Access, VBA to developed the front end and SQL Server to develop the backend, including Tables, Views, Stored Procedures, Triggers and user defined functions.

Database Developer

• Nov 2012 - Mar 2013

• Design and development of ADS Database in SQL Server. I have design and developing the database from scratch. Development includes SQL Tables, Views, Stored Procedures, Triggers and Indexes. • Design Access/VBA backup DB to do table backup of the database. • Feed Master data to ADS through Access/VBA front end. Use Excel VBA to clean the data import it to MS Access and use ODBC connection to connect with SQL Server to feed the data into the database. • Define various access levels in SQL Server so that various different level of use can access the data only they are allowed to. • Used SSRS to create report template. • Create technical documentation of the database. • Meeting with users to understand their needs and analysis the ADS System based on their needs.

Database Developer/Data Analyst

• Oct 2011 - Oct 2012

• Design and development of Manual Adjustment Master Database that store all the manual adjustments data done by the team. Used Excel VBA to clean the data and Import data to Access DB. Used Access/Excel/VBA to develop the whole system. • Design and developed Effective Rate Analysis Database. Received data from other data source and clean and process the data and final data used for Effective Rate Analysis Reports. • Design and run query in DB visualizer/ Micro strategy to extract the data and for MI reporting purpose. • Communicate with BI team to get the adjustment data according to BR and distribute the data within the team. • Customer Support query to answer manual adjustment queries. • Do Manual Adjustments using Excel. Download data from BI Micro strategy and compare the data with other source and final reports used for Finance billing and higher management reporting. • Design and developed dashboard reporting for higher management using Excel. • Answer member bank query about interchange amount, interchange rate. • Improved manual adjustment procedure using Excel VBA Macro.

Database Developer/Analyst

• Aug 2011 - Sep 2011

• I was responsible for developing Workshop Interactive Database from beginning. • Communicate with the team to capture the user requirements. • Build the database using Access/VBA to store various workshop feedback information. • Design some MI reports in Access/VBA and Excel VBA. • Write user manual and provide training to the user. • I was responsible for developing Workshop Interactive Database from beginning. • Communicate with the team to capture the user requirements. • Build the database using Access/VBA to store various workshop feedback information. • Design some MI reports in Access/VBA and Excel VBA. • Write user manual and provide training to the user.

Data Analyst

• May 2011 - Aug 2011

• Generate survey reports using Excel, VBA based on Towers Watson client requirements. After client survey received client data, loaded it to Excel, Design the report based on the client requirements and generate report. • Communicate Project Managers to discuss about the project reports and requirements. • Developed Translation database using Access, VBA and Excel. Survey data needs to translate from/to English to various other languages. Import excel report file in one language and choose the other language and then translate it. The final result will be transferred to Excel. • Developed Project Info Database in Access VBA to Keep Project Information.

Database Developer/Analyst

• Oct 2010 - Feb 2011

Database Developer/Analyst

• Jan 2008 - Oct 2010

Bank of New York Mellon Bank of New York Mellon

It Support

• 2000 - 2004