Senior Software Engineer
trg
Total years of experience :15 years, 7 Months
I am working as Senior Database Engineer in a team developing automobile survey solution named as ClearView.
We are using SQL Server 2008 R2 Enterprise Edition.
I am responsible for
1. I am the database owner of the Product (ClearView).
2. I lead the development in Product and develop procedures and back end functionality of Product (ClearView).
3. Providing support for old features and bugs fixation.
4. Coordinate with QA for bug free release.
5. (EOMR) End of month reports to the client of stats of the surveys in production environment.
6. Fixes to the scrubbed records.
7. Collaboration with clients for new surveys and their issues.
8. Code reviews of the database scripts.
9. Coordinating with DBAs for the smooth functioning of Product databases.
10. Implemented and automated CDC (Change Data Capture) instead of using triggers to maintain history for critical data.
11. Implemented of SSIS packages for different database tasks like transferring data from CSV files to ClearView database.
12. Rebranding of data for Demos for different clients.
13. Presentation of DB architecture in meetings.
14. Writing Summarization (aggregation of stats and scores) of surveys for Organizations on geographical hierarchy basis.
15. Automated Summary execution on daily basis.
I have been the part of Faculty of Fast NU, Lahore and have taken labs of different subjects including Databases; Data ware house, Digital logic design and Intro to IT for business students.
Worked on Porthos for Wyless UK.
It is a complete solution for managing M2M communication over GSM, CDMA or any other technology.
We used SQL server 2008 R2 Enterprise Edition database.
It includes:
1. CRM
2. Price Plan Management
3. Network Management
4. Usage Processing
5. Billing
6. API
I was responsible for
1. Business process design for CRM, Billing
2. Wrote T-SQL procedures & functions for Porthos
3. Development of new features and support for old ones.
4. Coordinate with QA for bug free release.
5. Code reviews of the database scripts.
6. Automated CDC (Change Data Capture) instead of using triggers to maintain history for critical data.
7. Monthly invoice generation and assistance to billing manager for their verification.
8. I converted simple reports to generic reports using dynamic SQL and was awarded a certificate and cash prize by CEO.
Worked on DBMS of Payment Card Industry
Worked on real time transaction processing systems, data security, application performance tuning, database systems development and configuration control.
We used Informix database.
I was responsible for writing/modifying Procedures and other database side objects related to customization of the modules. I have written scripts to auto add the new cards and their activation, termination, transaction logging and monthly e-statement.
Designed and Developed Garments Management System (GMS) for the Aims International Pvt Ltd. This system included following modules.
1. Merchandising
2. Order Costing & Budgeting
3. Production Planning & Control
4. Product Engineering
5. Purchasing System (Fabric & Accessories)
6. Fabric Cutting
7. Production Floor Management
8. Quality Assurance System
9. Machine Maintenance
10. Inventory Control System
A part from the garment management system (GMS) also initiated the Human Resource Management System (HRMS) for Aims international. It included following functionalities:
1. Employee Management
2. Personal, Qualification, Experience
3. Time & Attendance Management
4. Employee In/Out (Scanning)
5. Leave Management
6. Payroll Management
7. Bonus
8. Salary Break up
9. Income Tax
10. Advance Calculations
11. Leave Management
12. Overtime calculations
13. Incentive System
We used MS SQL server 2005 and developed front end in C# dot net.
I was part of the requirement gathering, analysis and design of the GMS and HRMS .I wrote scripts to implement the database. I developed forms and reports. I was also responsible for administration of the database.