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