SQL Developer/Data Migration Lead - Sedgwick Claims Management Solution Inc. - Atlanta, GA USA
(2011-04)
Led team of developers in data conversion for Pacific healthcare, Harford Healthcare SRS systems, Ovation systems, Cambridge Data worth over 100 Million dollars clients' data from AS400, Excel,Csv ,medium into IVOS application systems backend (SQL Server database) after company's acquisition.
- Moving data for system conversion from multiple acquired legacy systems into our IVOS enterprise
- Worked on the complete software implementation lifecycle, which includes data requirements gathering, full dataset migration, data loss run/reconciliation, and deployment to production
- Lead team in effective data management between initial extraction and cutover after conversion when going live
- Liaise day to day with clients and operation department to finalize business requirement
- Designed the mapping/code documents for fields and business logics process, coding the mapping documents logics and wrote transformation scripts in SQL server for different client's conversion
- Knowledgeable with fields mapping, transforming, and loading data from source to target enterprise application systems using the reusable ETL frameworks that was designed with SSIS packages
- Prepared the client setup into development and production database before running conversion scripts
- Worked on Data validation scripts to enhance the quality framework creation or reconciliation scripting
- Worked extensively with ETL, SSIS, SQL, XML, Microsoft Excel, DataBricks, Snowflake, SQL, ERM stored procedures or other data loading method
- Wrote different complex TSQL conversion scripts for the conversion of the data from client source to our target database such scripts like claims, claimant, payment, payee, reserve and multi-policy claim scripts
- Developed TSQL validation scripts to ensure that correct data has been converted to IVOS back end
- Loaded the new conversion data to UAT environment for operational department approval before moving t to production database
- Wrote different bat files scripting to move files around before sending though FTP with PGP file encryption
- Create different job on SQL Server agent, schedule them to run periodically and monitoring performance
- Wrote complex queries with Cursor, updates, insert, delete and manage trigger successfully to accomplish task and support daily client's ticket request
- Worked in agile scrum environment and reporting daily activities in the meeting to give updates on task at hand and completion reports
- Support and troubleshooting IVOS Enterprise Claims management Application written in Java programming
Database Developer - Tech Chiefs Group, Inc - Austell, Georgia USA
(2008-08 - 2011-03)
Led overall systems design and liaise with third party vendors for software updates
- Liaised with the System owner, system Builder and System User for the effectiveness of the system designs and implementation of the Medical Billing System
- Designed Program codes , analyzing programming tasks, writing software documentation, troubleshooting source codes and debugging
- Designed effective Requirement, Functional Specification, Non Functional Requirement, Test Requirement documentation
- Established and maintained effective working relationships with all clients and staff
- Upgraded the legacy application medical billing system in Access database to Microsoft SQL server and Visual Basic using Client Server architecture
- Designed database for patient medical records, appointment scheduling and billing us Visual basic and SQL
- Designed and implemented distributed medical billing system , patient accounting management using visual basic and SQL
- Integrated physician offices with the billing service providers, maintaining central billing servers
- Designed all the Medical Billing business process and system modeling tools such as Data Flow Diagrams, Process Models, ER diagrams, Context Models, Event Modeling, Process Decomposition, and Use Case
- Applied system development life cycle and train team member on SDLC methodology
- Trained users on implementation of new systems and building documentation
- Wrote Store procedure to generate crystal report data analysis
- Installed and configured SQL Server 2005/2008
- Designed and deployed SSIS Package for ETL and Schedule the package through SQL server agents
- Supported the deployment of new application for the Medical Billing System
- Was responsible for T/SQL development, including creating, views, triggers, indexes and tuning stored procedures
- Supported application and given timely report designed using SSRS report generator
- Created store procedure view, triggers and indexes for data maintenance
- Created SQL Server coding and maintenance support for a multiple functional product development and maintenance teams
- Was responsible for activity designing and project cost estimation, risk analysis and assessment, coding and maintenance of stored procedures and functions in Transact-SQL
- Created DTS package from different Data source and purging the database before conversion , using the Execute SQL task and performing data lookup
- Scheduled the DTS package maintenance and support of jobs in SQL Agent
- Troubleshot complex systems; diagnosed and resolved complex database issues using SQL profile and execution plan and recommended and/ or developed corrective SQL scripts and database fixes; supported legacy development, testing, and production code bases; analyzed and implemented database change requests and enhancements
- Actively participated in design and implementation meetings as an advocate for the DBA and development departments
- Supported other in-house software that designed for company business
- Configured and communicated with team using Lotus Notes
VB6 Developer/Support - Waltham Forest Ltd - London-UK
(2008-02 - 2008-07)
Modified existing codes in class modules and standard modules Action Educational Systems application designed in VB6/SQL/crystal 9 reporting.
- Created complex new procedures, functions in VB for invoicing and payroll modules for creating charges ,List charges, uncharged on personnel deployment to schools such as SNA, agent, Casual, Permanent mobile staff
- Created new modules and store procedures within the Legacy Human Resource application modules
- Created new Store procedures for generating report via crystal report 9 linkage for SNA charges report for (invoicing, non-invoicing) processing, SNA placement of the Active personnel report and Human resource personnel auditing
- Created new tables, views, store procedure, functions and triggers within their legacy database
- Created Complex MySQL script, store procedure, views for their existing personnel database and generate reports
- Scheduled daily backup and recovery on MySQL database
- Liaised with client service users to solve business problems highlighted and users perform interval testing as solution is provided
- Wrote different complex T-SQL scripts for data manipulation and report retrieval to meet their objective of business goals
- Troubleshot database and performance tuning, disaster recovery and Scheduling backup of their database day to day
- Performed upgrade using SQL server upgrade Advisor and setting all configurations using SQL Server configuration manager
- Responsible for Data Migration of educational database (Action) from SQL server 2000 to 2005 using SSIS via Microsoft management studio 2005 and writing some reports using Microsoft SQL server business intelligence studio
DBA/Developer/Support - BNP PARIBAS BANK - London-UK
(2007-12 - 2008-01)
Modified Existing Codes on T-SQL and VB Component on Anti-Money Laundering Banking application system User interface and back end.
- Analysed problems related to Database performance by creating indexes and finding solution to AML slow response to user interface report reques
