Mohammed Majid
Software Developer (MS SQL Developer)
Dubai
Summary of Career
Experience as
01 November 2012
02 December 2016
1 KMF-DOST (Karvy Mutual Funds -Distributors Operations Software Terminus)
Role Senior Developer
Duration Nov-2012 – Dec-2016
Team Size 6
Software Environment VB.Net,SQL Server 2008 / 2012, Active Reports
Description KMF is used for processing the Mutual Fund commission payments. KMF serves amongst largest AMC’s like KARVY, CAM’s, FRANKLIN TEMPLETON, and SUNDARAM.
Brokerage calculation starts with AMC’s (Asset Management Companies) confirming the rate structures to be uploaded for each scheme. Commission payments are done to our sub-brokers (Associates) in either DCB or warrants when funding summary report is confirmed by AMC. KMF Provides access to retrieve the commission payment details at folio, transaction level. This tool also provides the tracking of associate’s empanelment information, AMFI renewal information to the processing team. Annexure report of payment cycles is made available on associate’s logins.
Roles and Responsibilities
? Designed and developed the stored procedures on SQL Server 2008 / 2012.
? Creating Queries, Stored Procedures and User defined functions.
? Implementing error handling in existing stored procedures.
? Supported and assisted other database developers.
? Performance tuning of slow running queries.
? Designed the process module for commission calculation.
? Reviewed the stored procedures, functions, views and other SQL scripts developed by other database developers.
? Created SSIS packages to load data from various flat files into SQL database.
? Developing and deploying SSRS reports as per the customer requirements.
? Ensuring Pipelining of AMC controls and Processing Team Controls.
? Generation of Funding summary, High Value and Low Value Annexure.
? Generating Reports Like Audit Summary, MICR Upload, Dispatch Details, Circle Wise, Brokerage, Zone Wise Brokerage Reports
? Keeping track of the user activities and projecting them in process module.
Experience as
01 May 2008
31 October 2012
2 KFD-DOST (Karvy Fixed Deposits -Distributors Operations Software Terminus)
Role Senior Developer
Duration May-2008– Oct 2012
Team Size 7
Software Environment VB.Net,SQL Server 2008, Active Reports
Description KFD is used for processing the Fixed Deposits commission payments. KFD serves amongst largest Fixed Deposit’s like UNITECH Ltd, Kerala Transport Development Fin Corp Ltd, Dewan Housing Finance Corporation Ltd, Shriram Transport Finance Company, HDFC Fixed Deposits and Others. Brokerage calculation starts with reconciliation of branch (Karvy) data with the company data and once the data is finalized for the payment then the sub brokerage is calculated as per the commission rates which are uploaded in the KFD system as per the companies’ confirmation. Commission payments are done to our sub-brokers (Associates) in either DCB or warrants when funding summary report is confirmed by the Companies. KFD Provides access to retrieve the commission payment details at Company, Investor and transaction level. This tool also provides the tracking of associate’s empanelment information to the processing team. Annexure report of payment cycles is made available on associate’s logins.
Roles and Responsibilities
? Creating Queries, Stored Procedures, Triggers for Production server.
? Tables, Views, Constraints and Rules.
? Modifying existing stored procedures as per the requirements.
? Supported and assisted the other database developers.
? Designed the process module for commission calculation.
? Reviewed the stored procedures, functions, views and other SQL scripts developed by other database developers.
? Ensuring Pipelining of AMC controls and Processing Team Controls.
? Generation of Funding summary, High Value and Low Value Annexure.
? Generating Reports Like Audit Summary, MICR Upload, Dispatch Details, Circle Wise, Brokerage, Zone Wise Brokerage Reports
? Bulk Upload of Excel Data / DBF Data into SQL Server
? Keeping track of the user activities and projecting them in process module.
Experience as
18 July 2005
30 April 2008
3
KIPO-DOST (Karvy IPO’s -Distributors Operations Software Terminus)
Role Team Member
Duration July-2005– April 2008
Team Size 5
Software Environment VB.Net,SQL Server 2005, Active Reports
Description KIPO is used for processing the IPO’s commission payments. KIPO serves amongst largest Public Issues, Tax Free Bonds and NCD’s.
Brokerage calculation starts with Registry’s (Lead Managers / Syndicate Members) confirming the rates structures to be uploaded for each issue. Commission payments are done to our sub-brokers (Associates) in either DCB or warrants when funding summary report is confirmed by Registry. KIPO Provides access to retrieve the commission payment details at Application, transaction level. This tool also provides the tracking of associate’s empanelment information to the processing team. Annexure report of payment cycles is made available on associate’s logins.
Roles and Responsibilities
? Designed and developed the desktop applications.
? Designed the process module for commission calculation.
? Generation of Funding summary, High Value and Low Value Annexure.
? Generating Reports Like Audit Summary, MICR Upload, Dispatch Details, Circle Wise, Brokerage, Zone Wise Brokerage Reports
? Bulk Upload of Excel Data / DBF Data into SQL Server
? Keeping track of the user activities and projecting them in process module.
Master 05 August 2003
Master of Computer Application (MCA)