We provide IT Staff Augmentation Services!

Data Architect Resume Profile

4.00/5 (Submit Your Rating)

Albany, NY

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

  • Provide design, setup and support for Windows XP/Vista platforms
  • Create websites using MS FrontPage and JavaScript

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

We'd love your feedback!