This project was a very critical section of application for one of our US based clients. The legacy application was generating the credit card statements in 8+ hours for around 1 million accounts. This time was too much for some customers of our client as they had around 10 million accounts to process. So management took the decision to rewrite all business logics embedded in C++ application in SQL server procedures. The final time came down to couple of minutes after all optmization and redesigning of application. The client was super happy. Project involved developing some complex stored procedures , where most of them spanned several thousands lines of code. Project invovled below important milestones:

► Understanding existing application functionality.
► Pick logics from application written in C++ and convert to stored procedures.
► Design a flexible database architecture where more functionalities and new columns can be added without disturbing the development already done.
► Design utility to restore database and all scripts again and again for testing while taking care of sysnonyms and database references.
► Unit test all tables data to compare data generated by new procedures and legacy application using RedGate Data compare tool.
► Performance tune all individual procs called inside the wrapper proc.
► Version controlling of all developed objects.
► Deployment to live server.