We provide IT Staff Augmentation Services!

Associate It Consultant Resume

OBJECTIVE

  • Need an opportunity to make use of my skills and experience in the organization to achieve challenging and progressive position.

PROFESSIONAL EXPERIENCE

Confidential

Associate IT Consultant

Responsibilities:

  • Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
  • Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
  • Extensively use Excel functions in development, focusing on read/write integration to databases.
  • Deal with Migration related issue from windows7 to window10.

Confidential

VBA Team lead

Responsibilities:

  • Set up meeting with client for requirement gathering.
  • Feasibility check to determine whether it is possible to develop the solution using VBA or not.
  • Prepare the technical documents and develop the tool using VBA.
  • Testing of the developed tool by creating test cases to determine tool is working according to specified requirement or not.
  • Delivery of the project and technical support post - delivery if client faces any challenges.
  • Migration of the tool from windows 7 to windows 10 and MS access to mysql.

Confidential

VBA Team lead

Responsibilities:

  • Directly working with clients to Created Excel applications (VBA, Macros) to import historical data, which include multiple databases and perform various statistical analyses, Dashboards, charts, graphs and power point presentations.
  • Developed multiple Excel/VBA Forms for data capture and report generation
  • Developed procedures in MS Excel for export and import of data to and from MS Access and mysql.
  • Performed extensive analysis to debug, troubleshoot and optimize programs.
  • Created requirement details documentation, implementation documentation, user acceptance testing documentation, support documentation, user manuals and technical documentation throughout the application development.

Confidential

Senior Associate

Responsibilities:

  • Participation in business discussion with the different teams to understand the requirement.
  • Maintain, support and develop enhancements to the current assortment of Excel tools.
  • Track the code changes and update/create technical specification documents.
  • Support program and project managers with their changing requirements and needs.
  • Collaborate with other staff and business stakeholders reviewing, testing and piloting new tools.
  • Provide technical recommendations to the business analysts/leads
  • Document functional design of the requested enhancements.
  • Execute unit test cases for the new enhancements.
  • Assist in data calls by collecting, interpreting and consolidating data from various sources.
  • Provide basic reporting.
  • Conduct analysis as needed or required.
  • Participate in and prepare presentations to management and team members.
  • Design and develop automation tool and maintenance.
  • Determine and develop required enhancements to the system.
  • Initiate and implement full lifecycle development.
  • Develop designs to support business requirements and needs.
  • Manage and document concepts, practices, procedures, processes and issues.
  • Maintain and manage system specification life cycle documents of software applications.
  • Ensure compliance of organizational processes and procedures all the time.

Hire Now