Data Warehouse Architecture Resume Profile

OBJECTIVE

To secure a challenging, growth-oriented position where professional experience, technical skills and commitment to excellence will be of value.

TECHNICAL KNOWLEDGE AND SKILLS

SQL Server 6.5, 7.0, 2000, 2005, 2008, T-SQL,
DTS, BCP, SSIS 2005/2008, SSRS 2005/2008, Business Object's Data Integrator BODI ,
ETL development for XML, Flat Files, Raw Files and Excel files,
Feed Aggregation Thompson Reuters, Russell Investment, IDC, Cyber Source, Morning Star,
Visual Studio 2003/2005/2008, TFS 2008/2010, Visio 2008/2010,
C , Visual Basic, ASP/VBScript, Visual C , VB.NET, C , XML, HTML,
FTP Scripting, DOS Scripting,
Unix Solaris , Unisys A Series, DMS II database management system,
CANDE, DASDL, ALGOL, COBOL, WFL, MCP, ODT.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect / DB Administrator / Sr. Sql Developer / Data Analyt

Confidential

Data Warehouse Architecture Development:

Defined data model and created tables, constraints, stored procedures, user defined functions, triggers and other database objects to manage large data sets across large scale database system. Warehouse, BI Servers, DataMart, application databases . Designed and created a landing area for feed study for multiple feeds.
Extracted, transformed and loaded information from various data feeds to landing area.
Created the data model to store and support the information in a data warehouse.
Planned, designed and created process to transfer required information to multiple data marts.
Analyzed the information and identified data points required for company's current and possible future needs.
Interacted with various departments in-house, in planning and implementation of required setup to extract data feeds PC Support, Network support, DBA, Business analyst .
Worked closely with project mangers and programming team for fast, reliable and easy access to data. Optimized database objects and code to ensure the best possible performance.
Provide 24/7 level 3 support to insure fast and reliable response to support company's online products.

Confidential

Data Acquisition Framework DAF

Designed highly reusable self documented process to download, transform and load the information from various data vendors to data warehouse using SQL in combination with SSIS
Defined feed, business roles and process in database
Interacted with various vendors to acquire software/hardware requirement, feed layout and communication process necessary for a solid and reliable transmission as well as processing of information. IDC, Hyperfeed, Spryware, ILX, Nasdaq, NYSE, Firstcall, Thomson one, Reuters, Russell, S P, Datastream, WorldScope and .
Performed QA testing at various stages of data extraction and storage process for accuracy and completeness.

Confidential

Mainframe to SQL Server Migration

T-SQL based custom utilities

SQLSearch Helped in locating objects and data points in tables, store procedures, user defined functions, and SQL Server jobs
WaitForFile SQL Server job triggered by file arrival
Parent / Child Job dependency process
Master / Slave Job dependency process
Error Collector to log errors, and notify operators
Monitor SQL job execution and notify operation and/or SMS.

Confidential

Sr. Programmer / Lead Programmer

Researched, designed and implemented as well as oversaw the implementation of multiple applications that listened on continuous TCP/IP multicast feed from NASDAQ S P Comstock DDF , Hyperfeed, IDC/Comstock CTF .
Analyzed, designed and developed ftp - process to automatically or manually download files from multiple venders via FTP or modem connections.
Researched, designed and implemented an order entry system for entering trades though PSE's Stratus system using X.25. patented by the company

Confidential

System Analyst

Supported company accounting system including Inventory, Order Entry, Sales, Marketing, Account Receivable, and Account payable.
Duties included: DMS II database design and update. Program maintained in COBOL and ALGOL.
Helped end user with their day to day tasks, PC support needs and program enhancement.
Planning, study and perform mainframe system upgrade.

Confidential

Engineering Analyst

Supported BOM Bill of material and ECR Engineering Control Revision system using DMSII Database and ALGOL.
Analyzed, designed and developed DCS Document Control System using DMSII Database and ALGOL.