associate consultant resume example with 7+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000
Cell:
resumesample@example.com
:
Professional Summary
Core skills include Design, Development, Testing and DBA activities using COBOL, CICS, JCL, DB2, DB2 utilities and VSAM, debugging skills in IBM Debugger (Batch / Online modules) Client / End User support to resolve data issues while using DB2. Performance tuning / issue resolution for various DB2 objects / SQL Queries Expertise on BRIO for generation of Usage Reports Worked in DB2 V8 to V9 Migration process Application-side testing. Preparation and conducting training programs for newly joined team members. Contribution towards practice by taking interviews, preparing best practices / scenarios document. Active participation in various organizational activities / surveys giving feedback.
Skills
Guest services
Inventory control procedures
Merchandising expertise
Loss prevention
Cash register operations
Product promotions
Work History
Associate Consultant, 11/2010 to 06/2014 Avtex – Washington, ,
Wrote maintainable and extensible code in a team environment.
Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
Associate Consultant, 09/2010 to 06/2014 Avtex – Minneapolis, ,
HSBC Database
Directed software design and development while remaining focused on client needs.
SYSTEM ENGINEER, 02/2007 to 09/2010 Hcl Technologies Ltd. – Apache, ,
Completed IBM 703-DB2 V8 Application Developer (Score
Prepared detailed reports concerning project specifications and activities.
Education
Diploma: INSTRUMENTATION, Expected in 2002 to GOVERMENT POLYTECHNIQUE - AHMEDNAGAR INDIA, GPA:
MBA: Finance, Expected in 1 2011 to Symbiosis University - , GPA: Finance BE (Computer) - 2005, Pune University, Pune (63.63%)
DIPLOMA (IS) - 2002, MSBTE (77%)
SSC - 1999, Pune Divisional Board (75%)
Accomplishments
OHCB project is development of a new platform for processing the banking business of HSBC in mainframes Currently this project is in its SIT phase for Term Deposit and initial design for Lending.
As a part of one HSBC initiative HSBC is Developing new product named OHCB on Mainframes platform which will have all the existing functionality of it's existing core banking product HUB which is on AS400.
In conjuction with the current functionality of HUB, HSBC has decided to include additional functionality in the OHCB to meet One HSBC solution.
Currently 53 countries uses HUB as their primary banking system.
OHCB architecture is totally service based so that it remains very loosely coupled and can interact with other OH (One HSBC) financial product like OH payment, OH forex, OH cards , OHCDM etc easily.
This is the flagship project for HSBC and OHCB will be deployed in all the 85+ countries where HSBC is currently in business by year 2020.
2.
IBM INDIA PVT LTD, Pune (System Engineer: Mar 2007 - Oct 2010) PROJECT: MIW (MARKETPLACE INFORMATION WAREHOUSE) Developer / DBA Apr 2009 - Oct 2010 Client : IBM, USA Tools : SCLM, RMDS, DB2 Admin Panel, Spufi, QMF, Brio.
Platform : Z/OS.
Languages : PL1, JCL, VSAM, DB2.
Database : DB2 8.0 / 9.0 Team Size : 7 Roles / Responsibilities: DBA Activities (Solving user queries, Loading / Unloading data, Authorization, Execution of Utilities) Change request estimation / updating and scheduling, project metrics management using RPM tool Active participation in Application design.
Responsible for Change Request Management, Code development / delivery Creation of BRIO Reports Unit testing and documenting unit test results.
Review of program specifications, unit test specifications and unit test results Production Support (L3) / Resolution of abends Description: Marketplace Information Warehouse (MIW) is a part of IW suite of applications.
MIW houses multiple sources of data and makes this data easy to use by cleaning, processing, linking, and further defining the data for faster delivery of information that is critical to the business needs of sales and marketing professionals.
Data is both licensed from external sources and compiled by IBM internally.
MIW receives External data from its Vendors.
MIW refines and process raw information received from different vendors into useful information, which is loaded to DB2 tables.
IBM sales and marketing team access this data using different online interfaces.
The information that MIW receives and process differ for different vendors.
Creating Report on BRIO depending on Requirements.
Scheduling the jobs in OPC.
DBA Activities.
Participate in project meeting.
Description: EBI (Enterprise Business Information) Operation includes three batches, one for each GEO (EMEA, NA and AP) running overnight.
The batches feed daily IDOCs from CBS located on SAP environment to S&D IW located on MVS/DB2 environment through FODS (Fulfillment Operational Data Store).
The LDW ESW is physically located on an MVS/DB2 environment in UK/Portsmouth - UK MVS TSOBA.
There will be no direct access to the LDW ESW system on TSOBA for the common users (key users and LCM have direct access).
Edge-On-Demand is used as a front-end tool with BRIO as the query tool behind.
It's a WEB based solution, which supports different formats (BRIO, HTML, and L123).
PROJECT: LDS (LEGACY DATA SYSTEMS) Developer Oct 2007 - Mar 2009 Client : IBM, Germany Platform : Z/OS.
Creating Report on BRIO depending on Requirements.
Scheduling the jobs in OPC.
DBA Activities.
Participate in project meeting.
Description: The Legacy Data Store (LDS) as a logical part of the EDW consists of 12 tables.
It is a system which receives data from the Legacy Warehouse systems and stores it in the S&D Information Warehouse.
The whole transmission system consists of two parts: 1) The sending part on Legacy Warehouse Country side 2) The receiving part on S&D IW side For each sending system exists in the S&D IW one dedicated receiving System.
The sending and the receiving systems are developed as OPC job net running under MVS.
Each job net consists of several jobs, which usually executes one program, but there are also jobs executing more than one.
A program is a MVS/DB2 Utility or a PL/I Program.
Because up to 12 tables are fed, there are also 12 interfaces, each responsible for one target table.
Dependent from the target table, every interface has a specific layout and record format.
The two subsystems communicate with the help of a trigger file.
This file indicates that a sending action has successfully completed and the data can be accessed on the receiving side.
If no trigger file is received on the target side, no processing take place.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.