Sohail Khalid, System Analyst

Sohail Khalid

System Analyst

MetLife Alico

Location
Pakistan - Lahore
Education
Master's degree, MBA-Finance
Experience
10 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :10 years, 5 Months

System Analyst at MetLife Alico
  • United Arab Emirates - Sharjah
  • August 2010 to June 2013

• Overall responsibility for providing an on-line solution to partners with a wide range of sales and service support capabilities, matching the partner and end client needs, across a well-defined set of products and tools
• Design Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS
• Meticulously handle the preparation of the Business Requirement Document and convert business requirements into functional specifications
• Gather & define business requirements while managing the risks to improve business processes and translating the requirements into systems solution by preparing functional specifications
• Ensure technical solutions are designed for performance, reliability, scalability, maintainability, supportability, business continuity & business agility while leveraging industry’s best practices

Key Achievements
• Key player in gathering business requirements by conducting detailed interviews with business users & stakeholders
• Won appreciation for developing use cases from requirements and created UML diagrams that included use case diagrams, activity diagrams, and sequence diagrams
• Strategically aligned IT solutions with business objective, led selection of appropriate technology and vendor products

Oracle ERP Consultant(Part Time) at Blackhorse Trading LLC
  • United Arab Emirates - Dubai
  • January 2013 to March 2013

1. Responsible for gathering user requirements, data conversions, customizations and testing
2. Production Instance Setup
3. Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
4. Provided Training & Conducted Practice & Additional Business Requirements sessions
5. Co-ordination with DBA

Oracle ERP Consultant(Part Time) at Tasneem Trading LLC
  • United Arab Emirates - Sharjah
  • September 2012 to December 2012

1. Part of the Functional Implementation Team
2. Implementation and support of Oracle Applications R12(GL, AP, AR)
3. Business Requirements Mapping for General Ledger, Accounts Payable modules and Accounts Receivable
4. Study company COA and Implement in ERP
5. Defined Value Sets, Descriptive Flex fields, and Custom Profile Options

Java Developer at ITP Publishing Group
  • United Arab Emirates
  • January 2009 to January 2010

• Accomplished the responsibility for creating a new portal www.arabianbusiness.com
• Actively involved in the Analysis of Sales Illustration System and assisted with the Business case
• Drove the efforts for development of Core libraries of the Project to reuse for logging, security and transaction management
• Deftly handled the creation of technical specifications of components database design and Code reviews for the developers

Key Achievements
• Have the credential for Technical J2EE lead, Design and review test cases including Acceptance, Installation, deployment and Development of complex Servlet to interact with AJAX front-end
• Successfully introduced Software Engineering Methodologies and Processes to the site building strategy, including: proper application analysis, proper source repository use, Web Development standards

Senior Software Engineer (Contract) at Mercator. Dubai (UAE)
  • United Arab Emirates - Dubai
  • November 2008 to September 2009

• Assumed responsibility for designing logistics business for a wide spectrum of online services, from rate quote booking and reservations, sales, insurance and accounting to flight schedule updates, track and trace and delivery status
• Efficiently worked with the different modules of the application for bug fixing & Change Request including User delegation module which includes user and the community level delegation of services
• Interfaced & coordinated with customer and made technical presentations & Solution designing
• Organized various training sessions for the team to enhance their performance
• Accountable for ensuring seamless services to the customer with minimal manual effort and enhanced efficiency

Key Achievements
• Played a pivotal role in implementing the process of Multiple Special Handling Code for cargo Export Process for shipper/Consignee and Agents
• Instrumental in designing Reports for Dock Booking and Flexi Rates modules using Crystal Report, r module’s reports, Bug fixes of different reports from multiple modules and enhancement in several Invoices reports

Senior Software Engineer/Team leader at Accountancy Outsourcing Services(Pvt.) Ltd
  • Pakistan - Lahore
  • January 2008 to August 2008

• Shouldered the responsibility for leading the project of utilizing Java, Java EE, Enterprise Java Bean, and JSF to create fully-integrated client management systems
• Deftly managed the conversion of user requirements into use cases, system development including architectural design and overall implementation of core system and new features
• Associated closely in designing several JSF custom components for the application including Single & Multi List LOV and rendered Several Yahoo UI components into JSF component
• Significantly contributed in the design of different core libraries of the project

Key Achievements
• Credited for developing utility to handle thumb recognition for different property management processes, design and Implementation of role based security of the project
• Holds the distinction of design & coding of distributed objects using EJB, design integration & the deployment plan of the project with ERP and successfully implemented the plan on client side

Software Engineer at Innovative (Pvt.) Ltd
  • Pakistan - Lahore
  • September 2005 to June 2007

• Responsible for developing a flexible, feature-rich, Prepaid2.0-ready card processing platform with value-added services, rewards and loyalty options, cardholder communication tools, and extensive analytics of the client
• Geared the activities for the development of several UI with Struts framework and database services using JDBC API
• Effectively handled the Bug Fixing for current modules and Design reports for several modules of the application
• Established plan to ensure accessibility of Service Level Agreements (SLAs) and other relevant information to affected staff
• Tactically planned and analyzed the basic requirements while setting up the technical infrastructure of the project while reviewing the project proposals
• Identified, resolved/isolated areas of obstructions to catalyze project delivery within defined time & cost parameters

Key Achievements
• Introduced the concept of MIS reporting to update the Management on a regular basis
• Successfully handled the coding for User management modules which includes implementation of password policy viz. Password expiry password validation history forgot password, auto generates password, password encryption using MD5 algorithm
• Recognized for increasing the resolution turnaround of the customer issues, significantly resulting in the customer recommending the product to others

Software Developer at Syntax Lab IT Solutions Gujranwala
  • Pakistan
  • October 2001 to June 2005

• Entrusted with onus of developing Java based web based system involving pure Java programming, writing SQL stored procedures & crystal report development including desktop application in VB 6 for different clients
• Drove initiative for designing and coding the system for optimum maintenance and extendibility, using MVC
• Independently developed front end software modules in JSP, Servlet, programmed complete triggers behind transaction tables which handled all transactions posting from Master transaction to general Ledger
• Extensively worked in developing Procedures, Triggers, Views on database, viz. Oracle, SQL server
• Effectively supported the issues with reports on the crystal enterprise environments (Development, UAT, Test and Production)
• Drove the efforts for modifying the report content and export reports in multiple formats based on user input
• Efficiently managed item wise sales and inventory report regulatory submission using crystal report 8.5
• Designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s
• Collaborated with the team members and senior management to maintain a continuous stream of information regarding the project status and progress
• Regularly attended weekly change meeting, bridge call and conference discussion

Key Achievements
• Designed and developed the Java based web services to interact with existing system, which was integrated with existing System in telecom sector in USA
• Proactively contributed in design interactive Visual Basic 6.0 interfaces for report selection, criteria and display
• Gained invaluable experience in mapping client’s needs and conducting gap analysis to devise a cost effective end-to-end IT solutions to maximize the value perception of the customer

Education

Master's degree, MBA-Finance
  • at PIMSAT
  • September 2008
Master's degree, Computer Sciences
  • at The University of Lahore
  • December 2004
Bachelor's degree, Art/Art Studies, General
  • at University of the Punjab, Lahore
  • January 2001

Specialties & Skills

Hibernate
SQL database design
J2EE Architecture
Database
Financial Accounting
SQL Server
Hibernate
Android Development
Project Management

Languages

English
Intermediate

Memberships

Project Management Institute
  • Member
  • May 2013

Training and Certifications

Oracle Certified Expert, Web Component Developer (Certificate)
Date Attended:
May 2013
Valid Until:
May 2013
Oracle Certified Expert, Web Service Developer (Certificate)
Date Attended:
June 2013
Valid Until:
June 2013
Oracle Certified Professional, Java Programmer SE6 (Certificate)
Date Attended:
April 2013
Valid Until:
April 2013
Java EE 6 Enterprise Architect Certified Master (Certificate)
Date Attended:
April 2013
Valid Until:
April 2013
Project Management Professional(PMP) (Certificate)
Date Attended:
February 2013
Valid Until:
March 2013
Adobe Flex 3.5 (Certificate)
Date Attended:
September 2010
Valid Until:
September 2010
JFoundation (Certificate)
Date Attended:
October 2008
Valid Until:
October 2008
Oracle EBS 12(Financial (Certificate)
Date Attended:
March 2012
Valid Until:
June 2012