Data Architect Resume Profile Albany, NY - Hire IT People

CAREER SUMMARY

Experienced in the analysis, design and development of n-tiered large scale systems
Proficient in all phases of systems development including inception, requirements definition, design, development, testing, training, implementation, and production support
Worked extensively with cross-functional user and IT communities, engineering solutions to complex business processes and data integration, utilizing focus groups, prototyping, and systems development methodologies
Experienced in data modeling, data warehousing and the use of RUP, UML, use case, flow charting, and diagramming techniques for presentation at summary and detail levels
Worked in ETL projects involving disparate data sources, requiring data analysis, validation, and exception processes
Worked with e-commerce systems for the sale of retail goods and custom document formatting
Experienced in project management including integration of custom and vendor-purchased systems
Proficient in RDBMS design and development in IBM, Microsoft, and Oracle environments

WORK EXPERIENCE

Confidential

Data Architect

Analyze domain models and gather business requirements to develop database design for the Unemployment Insurance Service Improvement UISIM modernization project
Gather business terms through user interviews and extraction from systems design packages, integrate with technical database terms to create an organizational-wide business glossary using MS Excel, IBM InfoSphere Business Glossary develop client-server web browser application using JavaScript, JQuery, and Java/Oracle
Research legacy system programming and documentation to develop data migration plan for employer registration and financial domains create ETL processes and load data into modernization database using Oracle PL/SQL and SQL Loader
As part of a service-oriented architecture, interface with IBM InfoSphere DataStage via SOAP for address cleansing of legacy data

Confidential

Systems Analyst/Research Assistant

Document and analyze existing processes for Citizen's Police Review Board system, create object-oriented UML/RUP deliverables: design database and new processes to improve data capture and quality develop analytical tracking system in MS Access/Excel and ASP.net/SQL Server, providing detailed drill-down case management integrate new process for electronic storage and web-based retrieval of hardcopy documents providing online access to critical information create user documentation, train staff as to design, operation and maintenance requirements
Integrate Patents and Trademarks Office data into n-tiered system for data mining requiring extensive data transformation using MS Access/Excel, and ASP.net/SQL Server

Independent Contractor

Confidential

Confidential

Project Manager

Manage RetailPro upgrade in national retail stores responsible for administrative, financial, and technical areas: user focus sessions, fit-gap analysis, integration/regression testing, change management effective use of new procedures , deployment, user documentation and training
Design e-commerce system to provide sale of retail goods in a WebSphere/AS400 environment
Define requirements and design n-tiered data warehouse for ETL of AS/400 data to SQL Server, providing vpn access for retail stores and management decision support in a Windows XP environment

Confidential

Business Analyst Consultant

Define requirements, design and develop object-oriented BI system involving major business areas instrumental in a five year recovery from an 8M per year loss to 4M per year profit: document existing system, conduct focus sessions, define user requirements, estimate costs, create UML documents and test plan including unit/stress/regression, design and develop system, create user documentation, perform user/IT staff training and support build ETL for AS/400-to-SQL Server including data analysis and quality assurance exception processing
Design and develop sales administration system for field sales reports and bonus compensation using Lotus Notes, MS Access/Excel/Crystal Reports/SQL Server document existing system, integrate changing market requirements/best practices into new system services multiple departments including finance, warehouse, sales and marketing develop change management plan to ensure successful transition and effective use

Confidential

Programmer Analyst Consultant

Develop DB2 application to collect data from worldwide systems and process for general ledger work with user community to define requirements, design and develop system, work with testing/integration team
Reengineer Swift/Telex messaging system in Cobol/Assembler/CICS manage feasibility study through implementation deliverables include business case, analysis of current system shortfall, functional specification