Business Analyst Resume Profile CT - Hire IT People

Technical Skills Summary

Primary:
MS SQL Server 2008, SSIS, DTS, Data Architect , Project Lead 5 years , Data Architect, Crystal Reports 10, MS Office 2010, XML, Hyperion Data mart, SharePoint, Oracle 11, Systems Analyst, Data Analyst
Other:
VB.NET, ASP.Net, C , VBA, PL/SQL, VBScript, HTML, Java, PVCS, XSLT

Objective

I am looking for a challenging position that will allow me to use the skills I have acquired throughout my career.

Work Experience

Confidential

Systems Analyst

IBM Mainframe

Work with developers to maintain and enhance the Portal web systems Cigna provides its members and providers
Responsibilities include identifying source data for all Portals and defining load procedure from source system. Also document all processes and screen changes. The systems use a Java front-end and services built in-house to retrieve the data in real time to display on the portal. This data is comprised mostly of Claims and Coverage information. The data is retrieved through mainframe calls that are formatted in XML and returned to the Java front-end.

Confidential

Data Analyst/Data architect

Oracle 11
Work with developers to populate data warehouse for keeping track of Ad Sales
Responsibilities include identifying source data for warehouse and defining load procedure from source system. Also document all processes.

Confidential

Project Lead/Business Analyst

SQL Server 2005/2008, DTS, SSIS, Warehousing, WIKI, MS-Visio, C
Work with offshore developers to maintain and populate datawarehouse for keeping track of Spend amounts and vendors
Maintain Sharepoint sites
Oversee offshore development of C , ASP.Net applications for data loads

Applications Analyst/Data architect/Project Lead/Business Analyst

SQL Server 2000/2005, DTS, SSIS, Reporting Services, Warehousing, WIKI, MS-Visio
Responsible for the Student Affairs Data Warehouse
Create and maintain feeds into and out of SQL Server 2005 database including feeds to and from PeopleSoft, Housing Director Application and Hyperion Data mart.
Participated in the conversion from SQL Server 2000 to 2005. This included moving DTS packages to SSIS, testing feeds into and out of the converted database and learning new database configurations across servers. Project lead on conversion of warehouse.
Identifying and correcting any issues that may occur on the daily jobs run against the warehouse.
Create reports against data in the warehouse.
Write specifications for each project using MS-Word 2007, all DTS and SSIS jobs were documented in WIKI
database to 2005. Made modifications to application. This was an application which kept track of Heating Oil customers.

Applications Analyst/Systems Analyst

Terradata, DB2, TSO, Windows XP, Cognos, MS-Visio I worked on a team of systems analysts documenting existing applications running against a DB2 database. The data items needed to be mapped to tables in a Terradata database. There were templates used to maintain uniformity in the documentation. There were also Cognos reports which needed to be rewritten using the Terradata database so these reports needed to be documented and the data items mapped.

Applications Analyst/Data architect/Project Lead, MS-Visio/Business Analyst

XML, XSLT, XML Driver, SQL Server 2000/2005, Reporting Services, Crystal Enterprise, VB.Net, ASP.Net, Tidal Scheduler, INFRA, Excel, Access
Project Lead on series of cross training of all team members
Nightly processes for loading production
Daily Cash Process, Excel and Access Macros using VBA
Product Placement tool for marketing
I work on a team of six people. Our main focus is a data warehouse which stores data passed to us from the Bank of NY. The Bank of NY does the accounting for ING Institutional accounts. This data is then reconciled with in-house applications to insure its validity. I recently had this database converted from SQL Server 2000 to SQL Server 2005. As part of my responsibilities I also work with an ASP.Net application which is mainly a utility used

We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

CT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship