Business Integration Consultant Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • Date of Birth:
  • India:
  • :
  • single:
Career Overview

Experienced, Dedicated, Customer-focused individual with diverse industry experience in Engineering, banking, insurance and Professional expertise includes systems applications, disaster recovery planning and information protection analysis.

  • AS/400, Windows 2000, SQL Server 6.5/7.0/2000
  • Operating Systems: MS-DOS, HP UNIX, Sun Solaris, Windows 9x, Windows NT and Windows 2000, Windows XP, Windows server 2003/2008, Linux
  • Languages: T-sql, PL/SQL, C, C++, Pro * C, Java
  • Graphical User Interface: Visual Basic, Visual Studio .net, Crystal Reports, Active Reports and Business Objects, Batch scheduling tool Autosys
  • RDBMS: SQL Server 6.5/7.0/2000/2005/2008, Oracle 7.x/8i/9i/10g/11g
  • Internet Tools: HTML, ASP, XML, and JavaScript
  • Network Tools: Terminal Services, PC Anywhere, Remote Admin, Lotus notes, ODBC
  • SQL Tools: SQL Enterprise manager, SQL Query Analyzer, SQL Profiler, Data Transformation Services, Microsoft Visio, Erwin, ETL, SQL *PLUS, TOAD, Transformation Server, DBArtisan, SQL Server Reporting Services, Ascential Datastage
Technical Skills
Work Experience
Business Integration Consultant, 07/2008 to Current
Xcel Energy Silverthorne, CO,
  • Managed several projects that support Financial Accounting applications (GL/AP) for Mortgage and Insurance Accounting LOBs.
  • Active member of PeopleSoft Financials conversion project to build Custom Financial Accounting applications.
  • Managed the processes that can help users to manually upload Journals and Payment requests to Accounts Payable/General Ledger modules.
  • Managed Data Center migration project for moving legacy application infrastructure to Bank data center Managed automation of scheduled jobs through Autosys for interacting with Corporate GL and provide extracts to downstream systems.
  • End user training and support for day to day production BAU activities.
  • Managed TSA Exit divestiture project to spin off Insurance business from bank to QBE North America.
  • Managed projects that involve adding new LOB partners to Accounts Payable/General Ledger modules.
  • Configured new set of jobs to process Balboa legacy run off business GL & AP functions in bank Financial Account application.
  • Managed remediation project to interface with SAP, which is new Book of Record for bank.
  • Manages all change/release activities starting from requirements gathering, functional specs, design, development, testing and production migration for bug fixes, small enhancements and projects.
  • On boarded Financial Accounting applications user access requests/approval process to corporate access management tool.
  • Platform: Windows 2003/2008, SQL 2005/2008, Oracle 9i/10g/11g.
Systems Analyst, 07/2004 to 07/2008
Tampa, FL,
  • Worked as functional analyst in designing various interfaces to bring financial data from various production systems into for Mortgage Insurance Reporting Database for reporting and analysis.
  • Worked as functional analyst in supporting PeopleSoft EPM applications Scorecard, Planning & Budgeting and EPM Warehouse, release 8.8/8.9 Coordinating with development/testing team and user community throughout the development/testing and migration/implementation process, release 8.8/8.9 Gathering user requirements from business units and analyzing them to configure/customize Scorecard application to improve the functionality.
  • Enhancing the system functionality to improve system usability by customizing end user pages to minimize the number of clicks an user go through while building their scorecards in the system.
  • Worked with reporting team to design and build Business Objects Reports for EPM Scorecard and Planning & Budgeting applications.
  • Unit testing the enhancements/customizations to make sure all the requirements are met before migrating it to the target environment.
  • Coordinating with PeopleSoft administrators to resolve any issues that arose during the migration of projects/components.
  • Working with Security group to make sure all the page/data access requirements are met by implementing row/role based securities.
  • Working with PeopleSoft/Oracle customer connection to resolve break fixes.
  • Coordinating with development/testing team in resolving production support issues.
  • Actively participated in PeopleSoft EPM 8.9 Scorecard upgrade project.
  • Configure Scorecards for various business units of the organization in PeopleSoft EPM.
  • Implemented EPM 8.8 Scorecard application for Countrywide and migrated scorecards that are configured on Hyperion Balanced Scorecard application.
  • Migration of Scorecard application data from legacy system to PeopleSoft EPM 8.8 using Ascential Datastage.
  • Actively involved in build Vs buy and vendor selection process of choosing a Scorecard application that meets the business requirements and to integrate with other enterprise analytical applications.
  • Supported Hyperion Balanced Scorecard application for Countrywide Strategic Planning process.
  • Platform: Windows 2000, SQL 2000, Oracle 9i.
Sr. Database Administrator, 01/2003 to 06/2004
Roseland, NJ,
  • Installing, configuring and administering SQL Server 2000 environments.
  • Database design, implementation and production support.
  • Performance tuning of applications, database objects and SQL Servers configuration.
  • Setting up database maintenance plans to backup databases and to maintain routine procedures of the databases.
  • Maintaining database integrity and consistency.
  • Implementing database and server security.
  • Recovering databases from backups as required.
  • Creating DTS packages and scheduling them as jobs to move data into and out of SQL Servers.
  • Defining standards in designing database objects and assisting users and application developers.
  • Migration of database objects and data across development, test and production environments.
  • Creating disaster recovery plans, maintaining disaster recovery Servers.
  • Creating views, stored procedures, udf's and triggers.
  • Configured and managed replication servers.
  • Transforming data from legacy systems to SQL Server database to support client server applications.
  • Platform: AS/400, Windows 2000, SQL Server 2000.
, 03/1999 to 08/2003
, ,
  • Database administrator for various clients Analyzed, designed and implemented the data warehouse environment for VECO Corporation to integrate and support various regions of the company with their data needs.
  • Setup replication processes to publish data from head quarters to the regional branches.
  • Created disaster recovery plans and implemented database backup maintenance plans accordingly.
  • Creating the ETL processes to migrate data from legacy systems to SQL Server database and creation of DTS packages and scheduling them to run jobs as needed.
  • Performance tuning, installation, configuration and administration of SQL Servers.
  • Setting up database maintenance plans to maintain database integrity and consistency.
Education and Training
MBA: Financial Management, Expected in 1998
Financial Management
MS: Electrical Engineering, Expected in 1991
Calicut University - ,
Electrical Engineering
BS: Electrical and Electronics Engineering, Expected in 1989
Nagarjuna University - ,
Electrical and Electronics Engineering
.net, Accounting, Accounts Payable, analyst, AP, AS/400, ASP, automation, backup, Book, Budgeting, Business Objects, C, C++, client server, conversion, Crystal Reports, clients, DTS, data warehouse, databases, Database, database and creation, Database design, Datastage, designing, disaster recovery, downstream, Erwin, ETL, Financials, Financial, Financial Accounting, functional, General Ledger, GL, Graphical User Interface, HTML, Hyperion, Insurance, Java, JavaScript, Languages, Linux, Lotus notes, access, MCDBA, Microsoft Visio, Windows 9, Windows, Windows 2000, 2000, Windows NT, Windows XP, Migration, MS-DOS, Enterprise, Network, ODBC, Operating Systems, Oracle 9, Oracle, Oracle 7.x, PL/SQL, page, PC Anywhere, PeopleSoft, PeopleTools I, PeopleTools II, processes, Project Management, RDBMS, reporting, reporting 9.0, requirements gathering, SAP, scheduling, securities, Servers, Sun Solaris, SQL Server, SQL, SQL Server 2000, SQL 2000, SQL Server 6.5/7.0, Strategic Planning, user training, TOAD, T-sql, HP UNIX, upgrade, Visual Basic, Visual Studio, XML

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


Resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Calicut University
  • Nagarjuna University
Job Titles Held:
  • Business Integration Consultant
  • Systems Analyst
  • Sr. Database Administrator
  • MBA
  • MS
  • BS