Yahya Ashfaq Email & Phone Number

Lahore, Pk

Lahore, Punjab, Pakistan

JAC China (NETSOL Technologies, Inc.)Full-time JAN 2024 - Today Major Responsibilities are below as Principal Database Analyst:• Communicate with the client, understand the problem areas and assist the Team to fulfill the client requirement.• Requirement Gathering Workshop.• Development of Functional Specification (FS) Documents, Design Documents and Unit Test Plans• Software development. Monitoring and Guiding Teams members for completing Software Development Life Cycle (SDLC) and ensure all requirements are fulfilled.• Impact analysis Meeting.• Team management and task allocations• Coordinate with Team members• Providing Technical and Domain assistance to the teams.• Defining the project objectives and developing a project plan to accomplish the objective• Resource Management, assigning the tasks, see progress daily basis and motivating team members to work together on the project• Tracking progress with planned progress to meet the deadlines.

Guangzhou, Guangdong, China

Major Responsibilities as ETL\Data Analyst\Team LeadAs a ETL \ Data Analyst Consultant and a team leader, I was responsible to manage data analysis, migration & business process flow related activities during the full life cycle of project.Main responsibilities and duties included:• Explore new ETL methods & tools to minimize the delivery time and coop-up with industry standards• ETL process development using SQL Server Integrated Services (SSIS) tool• Design database, write SQL procedures, functions, triggers & PL/SQL Scripts• Design Staging database as per our System Requirement• Provide data warehouse design & mapping consultancy• Analyze different formats and types of data files of legacy system and transform into the desired format for target system• Create mapping between legacy & target systems• Identify risks / roadblocks and propose the mitigation plan and ensure timely delivery with high data quality• Performance turning & query optimization• Reconciliation of financial & non-financial data in every mockload• Data validation & verification reports development• Prepare technical documentations during requirement & development phases• Perform database administration tasks i.e. database backup, restoration, job scheduling, disk space monitoring and prepare data migration environment• Provide UAT & Production support• Requirement Gathering workshop• Impact Analysis &Solution discussion

Beijing, China

Major Responsibilities are on this project as mentioned below• Client communication• Performance turning & query optimization• Reconciliation of financial & non-financial data with the help of verification reports• Prepare technical documentations during requirement & development phases• Helping in product configuration by Scripts.• Provide UAT & Production support

Beijing, China

Major Responsibilities are on this project as mentioned below• Client communication• Performance turning & query optimization• Reconciliation of financial & non-financial data with the help of verification reports• Prepare technical documentations during requirement & development phases• Helping in product configuration by Scripts.• Provide UAT & Production support

Beijing, China

Major Responsibilities as Senior System Analyst.1- P1 & P2 issues resolution support. Regular follow-ups with back office team to arrange timely investigation and solution in case of critical issues. Also communicating ground level critical situation to back office team. Initiating instant investigation at the time of any issue is logged in order to save time till the back office support team joins in.2- Arranging quick GTM sessions between both sides for immediate investigation of issues. 3- Supporting on day end and Month-end. Even when required, performing late sittings in office to make sure these processes are successfully completed. Staying on standby from home in Shanghai when any of such activity is being performed late night or on weekends.4- Has helped in continuous monitoring and tracking of reported issues. 5- Supporting client’s team for arranging timely feedback to their queries from Back Office.6- Sitting through call discussions between Office and Chinese client and acting as a communication bridge for conclusive discussion between both sides. 7- Providing stand by support for production business on holidays.8- Late sitting support for (patch & hot fix) deployment into production.9- UAT support [Issue investigation and follow-up with team].10- Preparing Help desk sheet having updated status on all open items (Faults & CRs) of CAP, CMS, WFS & DAS and sharing it on weekly basis with both side stakeholders.11- Rigorous Follow-ups with team on all open help desk items and arranging timely delivery of fixes and CRs.12- Providing support in workshop for new requirements such as for Component financing CR.13- FS review support and follow up with teams on both sides for better understanding and smooth completion.14- Preparing Business Requirement Documents . 15- Helped in clarifying the scope and impacted areas of the CRs to the Business Users and IT team

Lahore, Punjab, Pakistan

Major Responsibilities as Technical Lead:• Requirement Gathering Workshop onsite with client business team.• Development of Functional Specification (FS) Documents, Design Documents and Unit Test Plans• Software development. Monitoring and Guiding Teams members for completing Software Development Life Cycle (SDLC) and ensure all requirements are full fill.• Impact analysis Meeting.• Team management and task allocations• Coordinate with Team members• Release Management• Providing Technical and Domain assistance to the teams.• Communicate with the client, understand the problem areas and assist the Team to fulfill the client requirement.• Defining the project objectives and developing a project plan to accomplish the objective• Resource Management, assigning the tasks, see progress daily basis and motivating team members to work together on the project• Tracking progress with planned progress to meet the deadlines.

Lahore, Punjab, Pakistan

Project Name (Syed Bhais, Shafi Leather, Qarshi Industries, BinZagr CO – RO)

Lahore, Punjab, Pakistan

Local Projects ( Punjab Drug House Pharmaceutical, Reko Pharmaceutical etc)

Computer Software Engineering

Master in Computer Science

Bachelor'S Degree, Computer Science