PROFESSIONAL SUMMARY:

• Skilled technology professional with over 18 years of overall IT experience developing solutions in ERP, OLTP, OLAP systems, data integrity, Master Data Management (MDM), metadata management, data service delivery, COTS implementation and legacy system retirement. Exposure to multiple business domains: banking, retail, health insurance, mortgage, credit card and government.
• Experience include; Enterprise Data Architecture, transactional systems, Data Warehousing, Physical and logical database design, data modeling, reverse database engineering, business solutions development, Business process engineering, data sourcing, application development coordination, system integration planning, data cleans, data migration, data integration and data conversion,
• Functioned in several roles including hands - on developer, data modeler, business analyst and requirements analyst, project team leader and project team member. Several years in a forward client facing and client interactive roles. Tactful experience in working with clients and senior stockholders in comprehending the business challenge in developing, presenting and reviewing business solution options.
• Exposure to industry standardized financial data models from IBM, Oracle and Teradata FSLDM supporting Banking, Finance.

EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• I was charged to build out and implement technical and business solutions.
• These solutions wear in line with the strategic plan or drove out gaps or other opportunities.
• Worked closely with technical leads, business and product owners.
• Facilitates many meetings of various topics and issues.
• Provided guidance and produced architectural artifacts to align cross-functional and cross-LOB projects to Confidential.
• Provided inter-project coordination on solutioning and data Provided a steady guidance to the Confidential
• Worked with senior business stakeholders to build out the data environment to align with information strategy.
• Provided guidance as new data environment included an expanding role for big data (Hadoop, Cassandra, Oracle Exadata)
• Created Conceptual Architectures, conceptual and logical data modeled. Lead compliance efforts for metadata.worked closely with junior data modeler and business analysts.
• Worked on a team of architects to implement and event streaming architecture. Implementing a real-time architecture. Incorporating in-house developed and vendor solution platforms providing backend infrastructural support. Provided support in upgrading legacy telephony infrastructures.
• Responsible for coaching and mentoring less experienced team members.
• Provided guidance and support in application integration, data, and infrastructure architecture disciplines. Worked on architecture and designs which cross all systems of the LOB.
• Develop and employ best practices in delivering architectural guidance and working within an agile development methodology.
• Understand and promote Information Strategy.
• Contributing and enforcing data governance across the organization.
• Ensure metadata is captures and documented.
• Work to in corporate high quality reference data into solutions.
• Engaging peers across IT, Business, PMO, Data Management to ensure consistency and open communications.
• Establishing data roadmaps / blueprints required to guide key aspects of data management for major functions.
• Develop and document Information Architecture for modeling Big Data.
• Participate and review proposed data model changes for adherence to data strategy and standards.
• Data modeling (Conceptual, Logical, Physical)
• Data integration, SOA, MDM, Metadata, Reporting and BI data layer development
• Excellent planning, interpersonal, influencing, and problem solving skills.
• Ability to drive out data requirements from the business with Business Analyst and developers. Ensure proper data model design and provide information architecture governance.
• Review data models of junior data modeler.
• Data modeling for big data technologies.
• Ability to quickly assess situations to develop a roadmap from concept to execution accounting for both business, requirements and IT impacts.

Tools: Erwin, SQL, Hadoop, Oracle Exadata, Cassandra, relational databases, NoSQL databases, SQL; JSON and XML

Confidential

Healthcare Data Architect

Responsibilities:

• Responsibility for architecture and design, of client healthcare data for integration and implementation into Confidential ’scustom Bi solution.
• Determines business information needs and identifies system requirements.
• Works with IT and business customers to develop requirements for designing the database model and architecture.
• Developed integration plan, scripts and testing.
• Created database models and ERDartifacts to support the solution migration and implementation plan.
• Built database objects and DDL scripts for testing and deployment to production.
• Worked on standardizations and delivery of models and processes.
• Build and maintain client data models.
• Provides support guidance to ensure architecture and framework are aligned with BI application needs.

Confidential, Charlotte, NC

Data Architect

Responsibilities:

• Contract consultant functioning as a Lead Data Architect initially charged to assess the data modeling team and increase their outreach, productivity and efficiency.
• Developed plans to implement and worked with senior management to transform the Data Modeling team into a higher functioning Data Architectural group to function at a more impacting enterprise level.
• I redesigned the teams business process, renegotiated the groups interdepartmental handshakes, artifacts and deliverables. Set in place in enterprise level publications to increase the team exposure and transfer of information for standardized and open consumption.
• Produced library of updates production data models.
• Developed and implemented a project plan to upgrade CA Erwin data modeling software tool from r7.3 to r9.6 (32 and 64 bit) for workgroups and Model Mart 9.6, with mid tier web server and software.
• Developed a plan and process to mass convert a large number of data models with thousands of entities, tables and attributes created in Erwin r7.3 to the new format of Erwin r9.6.
• Developed the process and program code to recreate the full library of production models by creating the PROD model via scripted code in VBA and the direct CA Erwin API access coding.
• This VBA application and code created converted data models from production DB metadata and recovered entity and attribute metadata definitions from non-production, non-current data models. VBA application manipulated the CA Erwin API interface.
• I developed all code and test plans.
• Introduced common and best business practices to spur team productivity, responsiveness and work quality.
• Introduced a change control process with new team standardizations to maintain concurrent production data models.
• Worked with infrastructure team to setup CA Erwin Model Mart 9.6 and Web server. Trained staff in use of Erwin Model Mart 9.6. And Introduced best practices.

Production DBMS: Oracle, Teradata, MS SQL Server, Sybase, DB2 and LUW

TOOLs: DDL SQL, DML SQL, CA Erwin 7.3, CA Erwin 9.6 (32bit and 64bit), large number of data models, Model Mart 9.6, VBA Erwin API, ADO / COM Object oriented development, VISIO

Confidential

Guidewire Data Architect

Responsibilities:

• Joined this client as a Data Architect to help Data managers and the organization to implement a new level of data management support by migrating to an Enterprise Data Architecture built atop a multi module Guidewire ERP implementation.
• I created extensive data modeling for Guidewire modules; PolicyCenter, BillingCenter, ClaimsCenter, Contacts and Accounts. Created data models for fun Guidewire environment. developed integration of internal and external data feeds. Developed data structures and extensions for realtime, near-real time processing and batch processes to support business processes, required reporting, risk analysis, underwriting and external partnership.
• Worked on multiple and simultaneous projects and program initiatives. Participated closely with Data Administration management, PMO and other business management leaders to build and maintain business relationships across the company with business units, technical, financial, reporting, and operational business units. As well as provide direct support to PMO as transactional processing migrated from Mainframe legacy to client server with normalized data and agile service delivery, build outs, support and data consistency across the enterprise.
• Participated in developing and delivering new business solutions in an extremely fast developing and turning environment. Key participant in assisting Data administration management with reaching out to major key business units previously supported in a legacy centered environment. Established and maintained direct relationships through all levels of management.
• Worked on a MDM framework and approach to integrate source contributions from multiple data sources applying our maturing MDM concepts. The MDM concept developed consolidated data from the transactional processing system, legacy mainframe system and multiple outside contributing systems from other business partners and data vendors. Created a BI data access layer to implement MDM and governance business rules on data extraction and consumption.
• Provided architectural support and guidance in a multiple lines of business. Provided direct data support to key business units: Actuarial, Statistic, Pricing, underwriting, Marketing and PMO initiatives. Supported financial analyst, bUsiness analyst, ETL developers and report developers. Created the BI presentation layer following the initial roll out of the new enterprise business transactional application. Then developed the code and data objects for enterprise BI data consumption. Designed conceptual, logical and physical ERD diagrams to support data consumption and providing data consistency.
• This was key to providing Decision Support Data to executive management and operational management. Functioned as the data expert for; Policy Administration, New Business Submissions, Policy Change, Renewals, Cancelations, Reinstatements, Enforced Policies and status at any point in time, Claims and Policy Events and Activities
• Develop close interactive relationship with other peer IT technical units such as infrastructure, Database Administration, UI development and ETL.
• Participated in the mainframe legacy retirement initiative. Developed a data transition and mapping plan from legacy to the new RDBMS MS SQL Server to support BI access, reporting and the SAS environment. Performed direct hands on data discovery of legacy data items and mapped them to the new SQL Server database data elements. Developed the Data flow and data presentation schema for the new Business Intelligence capability. Developed data objects to build a BI presentation layer. Developed an ODS environment with support services while providing amble time to define and develop a new Enterprise Data warehouse (EDW) environment. Work closely with major business units, Underwriting, Actuarial, Statistics and Customer Servicing. Directly provided development and coding support to build a presentation layer between the business and a very large, complex and heavily modified and enhanced transactional data environment. This involved heavy, complex and difficult SQL development. Built many complex and impounded view objects. These views also trapped and vetted the most complex and complicated SQL joins. After, I provided direct Production support. I was a trusted senior resource with full data access to all enterprise data.
• Documentation, discovery, analysis and data modeling for all major transactional data stores and other utility services such as persistence for transient data to and from our third party strategic partners providing digital integration support. Developed and created a large data store or the persistence of large amounts of transient second and third party data from any strategic data vender.
• Reviewed ADRM and ACCORD industry data models to assist in the creation of an open DB framework to support data export and consumption from multiple vendors and external data providers. This was normalized, open database structure for flexible and agile data consumption. Several vendors and products exchanged data via XML. I am fully versed in reading and processing XML data and XSD files with enumerations. Created physical data models and databases to persist XML data exchanged. Created full database including logical and physical data models and DDL SQL. Created schematic and other DB objects. Lead multiple JAD sessions with ETL team in this project.
• Created a repository of enterprise data models to cover all major production databases with CA ERWIN v9. Converted existing models to CA ERwin 9 from CA ERwin 7.x. Maintained enterprise production data models. Created numerous artifacts including ERD diagrams, data flow, data environment, other project planning and presentation material for team and management.
• Developed data presentation layer for data access and data security. Created data objects to support Business Intelligence (BI) and provide constant data access and data reporting for enterprise data consumers.
• Identified and maintained Subject area data concepts. Provided ERD's to ETL developers, report services developers, actuarial, statistics groups and BI user groups for SAS, Qlikview and Excel. Produced and published enterprise data presentation materials, data models, ERD's and

Tools: used: MS SQL Server, CA Erwin, Informatica, XML/XSD, SQL-DDL, SQL-DML, Visio, XML Spy, SAS, Qlikview, Guidewire (PolicyCenter, BillingCenter and ClaimsCenter)

Confidential

Lead Data Architect

Responsibilities:

• Primary project to reduce current claims backlog and build new business solutions and tools to assist the processing effectiveness of the nationwide workforce, improving the public image and reduce political pressures.
• As a lead Enterprise Data Architect, I function as a part of senior project management.
• I developed technical and detailed data plans to provide a technical solution for the business initiative.
• Developed and presented a functional Master Data Management (MDM) plans and design. This was to efficiently tie Primary Insures individuals or beneficiaries to services and benefits entitled under a claim and track multiple instances of same person to multiple claims. Built and implemented core physical database table, other database objects, ETL load processing and sequencing. Prepared many presentations and materials to the client’s executive, senior business and technical management staff.
• Partnered in the leadership of development teams (DBAs, ETL developers, UI developers and other junior Architects) in building and implementing the solution. I provided direct technical, hands on support and responsibilities for data deliverables.
• I develop and maintain direct client interactions for developing concept solutions, identifying high level expectations and requirements. Conducted meetings to drive out and record requirements. Worked on documenting business processes and establishing working relationships with SME's and other business contacts.
• Lead the data architecture and design efforts including data modeling effort.
• Developed architectural concepts that were new to the client and the environment.
• I presented the related business advantages and rationale to pursue a design and development approach I may have recommend or came from my team.
• Presented and built database models and DB objects to develop a new User UI toolset to better manage, assign and report on the very large backlog of request to be progressed in the workflow, adjudicated, artifacts collected, correspondence tracked and processing to completed.
• Technically, created data models, conceptual, logical and physical.
• Established a change control process to maintain data models thru all phases of discovery and development.
• Developed an ODS and data marts.
• Created naming standards, nomenclature and created and maintained standardized abbreviation via Erwin. Utilized Erwin Names (.nms) file.
• Created several metadata reports via Erwin.
• Developed the initial MDM process to uniformly identify and track key subject areas and build conceptual and logical constructs at the enterprise level. Developed a data registration process around person/org, entitlement services and other master data entities.
• Created enterprise identifiers and roles. Created enterprise reference domain structure and implementation plan.
• Maintained data architectural control throughout the project life cycles.
• Incorporating users requirements, development requirement and to future state requirements.
• Maintained close relationship between architecture and developers, ETL, BI and UI developers.
• Initiated a process to maintain a level of support for development teams as new items and change are sometimes required in the Database via the data model.
• Maintained Sharepoint site for artifacts collected, produced, deliverables and centralized distribution and collaboration.
• Created and maintained data dictionary, source to Confidential mapping data, ERD diagrams for many views: subject areas, ODS, Application databases, data mart, warehouse views and many other for presentations and concept development.
• Functioned within an Agile development environment.

Tools: used: Oracle 11g, CA Erwin, Informatica, TOAD, SAS, OBIEE

Confidential

Senior Data Architect/Data Modeler

Responsibilities:

• Functioned as a senior data architect for a major Healthcare Insurance provider in developing a data persistence solution for an integration and conversion enterprise project. This initiative included an iterative step down phasing to retire a legacy core processing system.
• Also, included was the phase up of a new core system to provide functional coverage of the retiring system of record and extended functionality beyond.
• Created an Operational Data Store (ODS) to persist data movement from multiple source contributing systems of record for post business consumption, downstream support, post processing, integrated data exchanges with downstream business partners, analysis, BI reporting and AdHoc querying.
• Developed the ODS to identify enterprise subject areas to apply MDM business rules and align to general governance prior to integrating data to the EDW (Enterprise Data Warehouse).
• Directly created and maintained data models, conceptual, logical and physical models.
• Conducted team and client reviews with principal stakeholders.
• Created presentation material of complex data schemas for business acceptance, metadata repositories and artifacts for input to other tasks within the project.
• This included ERD data models (physical and logical), data dictionary, ETL source/mapping documents requirements traceability documents and other material.
• Produces all DDL SQL to create, drop and alter DB objects. Created all Primary keys, indexes and column constraints.
• Developed and maintained data models in Ewing 7 and Ewing 8. Converted CA Erwin metadata reports and extractions to Erwin 8 via direct SQL and crystal reports.
• Functioned at various levels within development cycle from concept, requirements, DB design, integration, access planning, data flow, ETL source/targeting, staging area DDL. Other complex data issues which as data conversion, data transposition, reference data management, latency and cycles.

Tools: Ca Erwin 7 and Erwin 8, CA Erwin Model Mart, Oracle 11g

Confidential

Sr. Data Architect

Responsibilities:

• I was tasked to develop a new data infrastructure including data access, transport and architecture.
• The client, a national health care system and care provider, had multiple core systems and several downstream dependent systems (internal and external). The initiative included the decoupling of functionality from closely related system in which they were co-embedded.
• This included developing new business applications, UI, Data Services and database.
• I developed an architectural plan for development for the development of new applications, integrations (internal and external) and new data architecture, conceptual, logical data model, physical model and API plan for application data objects interfacing.
• I created presentation material for client management, team management and management of our partnering systems.
• I produced system supporting diagrams including data access diagram, details of the data environment, systems environment, logical data diagram, physical data diagram and application and Data services ERD diagrams.
• I created database DDL and deployments plans and scripts.
• I developed project plan to implement data services support for MDM scheme. Developed a callable API interface for web services development.
• Develop backend data services to imbed MDM business logic and registration processes.
• My solution was a paradigm shift to an enterprise solutions perspective supported by data services.
• My objective was to promote data development perspective which would yielded more flexibility, functionality with much increased ROI.
• Still, while delivering this architectural plan for systems, data and development. It was important to show a compliment to a code developers' only driving, development approach.

TOOLS: CA Erwin v7 and v8, Oracle, SQL, DDL, DML, PL/SQL.

Confidential

Senior Principle Analyst/Sr. Data Architect

Responsibilities:

• Participated as a member of an enterprise architectural team.
• This team was charge to stabilize the major systems within a newly awarded and large federal contract.
• The inherited environment included five major dissimilar systems and several smaller functional support systems.
• The system contained internal support and external client access
• Many silo-ed systems contained a functional and business inter-dependencies.
• As the data architect, I interacted directly with project management and team leads to iteratively move the development projects to align with the new enterprise architectural plan and support development to a more conforming SDLC.
• Provided hands-on development of data models, both logical and physical to restructure several de-normalized, improperly keyed entity structures and mis-indexed tables.
• Developed data model entity and attributes to an institutional names standard.
• Worked with DBA team to coordinate physical DB changes.
• Wrote all DDL code and scripts to be executed in all environments; DEV, TEST/QA and Production.
• Identified opportunities within an initiative to build-out and/or implement SOA component into the solution.
• Hosted database review meetings with management and development teams to show the new alignment to the enterprise data model and SOA architecture, enhanced utility and matching to requirements.
• Identified opportunities to move the system projects to a more conforming and standardized design in database architecture via the creation and implementation of structured data models, 3rd normal in logical.
• Aligned to enterprise subject area where possible or did a build out or extension to a subject area.

Confidential

Data Architect/Modeler

Responsibilities:

• Responsible to work with the lead enterprise data architect to develop a new data model and database to capture data from contributing transactional systems into a central enterprise ODS.
• Reviewed ACCORD insurance data model to provide a standardized data framework for the ODS design.
• Regularly attended and contributed to enterprise architectural planning meetings with enterprise systems architects, other management and tech leads.
• The business data included policyholder, member, employer, group administration data and member elections. Sections of data was stewarded by individual but separate systems.
• The contributing systems where responsible for initializing, processing and closing transactions.
• This ODS, as a centric repository, eliminated a number redundancies and provided an enterprise identifiers and tracking across multiple disparate systems. A primary objective of the development effort was to improve data report-ability, better handle data synchronization, latency issues and increased performance via an enhanced design.
• Participated with in-place staff and management to establish best practices in developing and implementing an enterprise solutions. Supported the enterprise team efforts to implement a broader SDLC to provide uniform and structured approach to development.
• Direct hands-on development of data models both logical and physical. The modeling tool was CA ERWIN

Tools: CA Erwin, Oracle RDBMS and proprietary vendor database engines

Confidential

Data Analyst, Logical Data Modeler and Physical Data Modeler

Responsibilities:

• Participated with the enterprise systems architecture team and technology leaders to develop a forward positioning technical solution for the assimilation and distribution of institutional data.
• This solution sourced from several major SOR Production systems including legacy system targeted for retirement.
• Solution also provided access structured and variably defined data both in bulk and fast real-time/near real-time messaging.
• Participated on an enterprise wide group of senior management, technology leaders, business group management and others to identify and resolve business and system impacts as the organization moves towards retirement of multiple prime SOR legacy systems after a long service life and multiple large mergers and integrations.
• The task was to identify data stewardship, consumption and look-alike data within the multiple legacy systems.
• Contribute to a solution to maintain synchronization between the transactional systems and the subsequent processing systems and reporting systems.
• Analyze business requirements to compose functional and implementable technical data solutions.
• Identify integration impact to dependent systems, data flows and data stewardship. Identify implementation impacts as they affect business processes. Work with multiple team members technical and business subject experts. Produce data models to meet functional data requirements. Data modeling at the enterprise level through to ETL and application.
• Created new data constructs and or leveraged existing constructs for reuse. Produce ER diagrams for presentation of requirements and solution for peer reviews and review with other technical team members, business team members, other leaders and stakeholders. Created data dictionary, Data mapping for ETL and application support. Created multiple deliverables; DFD, ERD, mapping documents, metadata, DDL and DML as required.
• Participated in review of the Teradata FSLDM to contribute and in part, justify, the logic and standardization used to compose this functional iteration of the EDW. Contributed in the logical modeling effort to secure approval from senior and executive management. Subject area logical entities were identified, constructed and the attributes which defined them. Metadata such as datatype were further defined as definitional contributions from the legacy mainframe conversion effort and the requirements from the new SOR/UI applications.
• Tasked on a project to reverse-engineer multiple subject data marts. Document individual subject data marts in use and mapped their inclusion in the EDW environment.
• Provided direct support to the ETL development team. Helped to compose the data mapping documents and identify and verify transformation logic in the prior ETL routines. Some logic carried over, others may be modified or dropped.
• Expanded data model for an initiative to support the development of a mid tier data service for real time e-commerce order processing, fulfillment and delivery of multiple third party vendor data products.
• Created data model for persistence of XML data source, including MISMO XML formatted data into a canonical, 3NF normalized database.
• Worked independently and within a formal PMO lead SDLC methodology on a defined timeline with assigned inputs and deliverables.

Tools: Sybase Power Designer, Teradata, MS SQL Server, Oracle, DB2, VSAM, XML xLink

Business: Banking, Mortgage, Real Estate and Finance

Confidential

Consultant

Responsibilities:

• Data Architecture, requirements and data modeling
• Constructed and re-engineered client databases to meet new and expanding business issues, market conditions and compliance considerations.
• Reviewed and participated in requirement gathering, business requirement sessions and composition (SRS and DFD). I composed and maintained metadata.
• Provided data support to ETL and UI development teams by presenting data models and data mapping documents.
• Composed all DDL SQL to create the physical database entities including tables, keys, indexes and statistics.
• Transactional databases, and reporting ODS DBs. Performed QA testing on all data marts created and aggregate functions executed.
• Maintained system documentation and metadata.
• Worked with management on business acceptance and commitment.

Tools: Teradata, Oracle, CA ERwin

Confidential

Database Architect/ Modeler/Developer/EDI/Data warehousing

Responsibilities:

• Development of an enterprise level business analytics system. Performed as lead database architect to produce ERD design, ERWIN modeling (Logical and physical), business process re-engineering, and defined business roles.
• Client has multi-company brands, 60+ million customers, billion + sales records.
• Large scale Teradata database, data aggregations, ODS and warehousing. RAD development of prototype aggregation and management application system (GUI and database) and developed ETL plan.
• Created data repository of aggregated data with multiple dimensions. Worked with all business role players from Business analyst to executives.
• Conducted project meetings, requirements gathering and authored functional specification documentation including process diagramming. Data and data work flow diagrams, ERWIN ERD entity diagrams development (Conceptual, logical and physical with attribute and table level views).
• Maintained data models at multiple levels including subject area and functional and application.
• Reverse engineered transactional database and ODS.
• Developed application data models to third normal form (3NF).
• Developed multiple Data Mart models to the appropriate normalization form to support the business requirements of the data warehousing.
• DW and data marts supported business/financial analyst and automated aggregate BI reporting systems in SAS and MicroStrategy.
• Worked with application development team on data sourcing and the proper implementation of the business requirements.

Database Analyst

Confidential

Responsibilities:

• Responsible for analyzing employee benefit enrollment data and maintaining the accuracy of data throughout the enrollment process and post-process.
• Responsible for the resolution of all technical issues.
• Maintain database to support assigned client benefit plan specifications.
• Responsible for importing client data (employee census including dependents, plan type, plan coverage and payroll deduction) pre and post enrollment process.
• Interface with vendor or carrier companies’ business and technical contacts to review and fulfill data extraction and integration request per project requirements and business request as they are presented and change. Import, load and extract data from database or create database or tables, queries and views to process data.
• Handle data in various file types and tables to support exchange.
• Developed scripting routines in VB and SQL to support repeatable processing and ensure data quality and accuracy.
• Generated audit data and matrix info to validate exchange data.

Confidential

Database Architect, Data Modeler, Developer

Responsibilities:

• Developed a database solution from enterprise wide data stores to feed BI and CRM initiatives.
• Solution to aggregate, analyze and report on customer orders, invoices and products through the product processing cycle.
• This includes product status from warehouse through fulfillment, returns, call centers and CRM issues.
• Developed and data sourced Business Intelligence solution to service multiple business entities cross multiple locations and platforms.
• Developed ERD diagrams for logical and physical database development. Created DDL SQL and physical database.
• Conducted business requirement gathering.
• Produced project development plan.
• Developed business process diagrams and data flow.
• Re-develop the data integration strategy to a standardized EDI plan for integration of enterprise Oracle data to a widely accessible data repository.
• Developed user interface for full data researching of current and year over data.
• Developed user GUI via RAD methodology.
• Wrote all SQL and VB code.
• Developed code for auto data cleansing, data and transaction typing.
• Developed ETL data load reversing routines.
• Coordinated user acceptance walk-throughs.
• Conducted user and administrator training.
• Designed new business processes to support date staging and integration plan.

Tools: Oracle, Erwin (ERD Logical Data Modeling and Physical Data Modeling), ETL, ODBC, MS Access 2003 and MS Access 2007 VBA development

Confidential

Database Analyst/Developer

Responsibilities:

• Defined and implemented loan processing procedures.
• Defined workflow processes for loan processing.
• Developed software to assist and track loan origination and loan processing functions.
• Implemented document imaging solution.
• Developed data integration plan to integrate 3rd party data origination application to backend business databases for business support and decision-making.
• Developed data transformation routines to import data into SQL Server database via DTS from various data sources such as MS Access, Excel, ASCII text, delimited files and MySQL.
• Define requirements and build data access layer.
• Developed front-end application interfaces via Rapid Application Development (RAD).
• Used crystal report to provide a reporting platform for management and business analyst.
• Created and maintained data marts to support reporting from crystal reports and ad hoc querying.
• Wrote stored procedures for class objects to support development in VB.Net, MS Access, MSA Forms and VBA. Setup ODBC connections to SQL Server to support dynamically created pass-thru queries.
• Hands-on development work to move Access/VBA application to VB.Net/ SQL Server.

Tools: MS SQL Server, Data Transformation Service (DTS), Stored Procedures, Erwin (ERD Logical Data Modeling and Physical Data Modeling), ODBC, crystal reports, MS Access 2003, MS Access 2007/VBA, Visual Basic. VB.NET and MS Visual WEB Developer