MAJOR PROJECTS

• Clinical Analytics Big Data Watson Project DB2, Hadoop, PowerDesigner, Informatica PowerCenter
• Clinical Analytics, Data Warehouse Big Data Explorys Hadoop, Amalga, SQL Server
• Healthcare Data Warehouse Claims Data Warehouse: Oracle, Informatica PowerCenter, IBM Initiate MDM, Erwin, PL/SQL
• FAA SOPLA Prototype: AIXM, Object Modeling, Sparx, AGIS, PostgreSQL, ERStudio
• Fannie Mae Enterprise Data Repository Program: Informatica MDM, PowerCenter, ILM, Informatica Data Quality, Oracle, ERStudio, Tibco BusinessWorks

METHODOLOGIES, FRAMWORKS CONCEPTS

• Service Oriented Architecture SOA Business Process Management BPM
• Business Intelligence B1 Master Data Management MDM
• Data Quality Governance Entity Relationship Diagram ERD
• Reference Data Modeling RDM Object Relational Mapping ORM
• Dimensional Modeling DM Unified Modeling Language UML
• Rational Unified Process RUP TOGAF, ArchiMate, CMMI Level III
• NIEM GJXDM, AIXM, DoDAF Object Oriented Modeling OOM
• HIPAA, HL7, CDISC, CCD, CCR Role Base Access Control RBAC
• Cloud Computing, Big Data ICD 9, ICD 10, MISMO, ULDD

INDUSTRY / SECTOR

• Energy Utility, Retail, Commodity Trading, Generation, Green Energy
• Healthcare Clinical Payer, HMO/Managed Care, Clinical, Provider
• Financial Services Debt Management, Mortgage Loans, Securities, Collateral
• Government DHS, ICE, FAA, DoD/BTA
• Legal Corporate Law, Patent Law, etc
• Supply Chain Distribution CRM, Distribution Channel, Procurement, etc
• Software Product Development, Consulting, Integration, etc

SKILLS

DBMS Platforms

• RDMBS: SQL Server 7, Sybase SQLAnywhere 8 12x, MS Access, Oracle 9i 10g 11g, MySQL 5.0, DB2 UDB 7x 8.x 9.5, ProstgreSQL 8.4, Sybase IQ 15.x ASE 12.x, Teradata, SQLite
• Big Data/NoSQL/Cloud DBs: Apache Hadoop HDFS, MapReduce, HBASE, Flume, Sqoop, Oozie Cassandra, Solr, CouchBase, MongoDB, Hive, Pig, Cloudera CDH, DataStax M5, Amazon SimpleDB, Amazon DynamoDB, CouchBase

Modeling/CASE Tools

• Turbo XML, Erwin 8.x/9.x, Microsoft Visio, Visual Studio 2005, IBM System Architect, Tibco Designer, ER/Studio Data Architect, PowerDesigner 12.x/15.x, Sparx Enterprise Architect, IBM Rational, Altovia XML Spy, Altovia Mission Kit, Mega Suite 2009, Orbus

ETL Integration Platform

• ETL Tools: SQL Server SSIS, Data Junction 7.5.5, Pentaho Spoon/Kettle, Informatica PowerCenter, Tableau
• SOA BPM Tools: Tibco BusinessWorks, Tibco EMS, Tibco ESB, Microsoft SOA BizTalk, IBM Websphere, Appian PBM and Point to Point custom implementations.

Data Quality, Governance Stewardship

Tools: Infomatica Data Quality IDQ, Informatica Data Director IDD, IBM Initiate Inspector Workbench

Master Data Management

Tools: IBM Initiate MDM, Informatica Siperian MDM 9.5.1

Applications / Platforms

• Operating Systems: Windows, Mac OS X, UNIX Solaris, Red Hat Linux RHEL, CentOS, Ubantu
• Business Intelligence: SQL Server Reporting Services, SQL Server Analysis Services, ProClarity, SAP Business Objects Crystal Reports/InfoView/Web Intelligence, OBEE, Pentaho BI Suite
• Integration Connectivity Security: SOA over HTTP, SOA over JMS, ODBC, JDBC, ADO, DAO, OLE DB, MS Jet Engine, Active Directory, LDAP
• COTS Applications: Siebel 7.8 Energy, Lodestar Energy, Lawson Procurement Suite 8.x, Navision Attain 3.10a, Ecometry 6.1i, GoldMine 5.7, Oracle Financials 11i, IBM Maximo 6.2, Facets 4.5. Meditech,
• Programming Languages : J2EE, JEE, JSE, VB.Net, VB Script, VBA, XSLT, XQuery, SQL, Oracle PL/SQL, T - SQL, Python, Shell Scripting, etc.
• Development Tools: Tibco Business Studio 2.0, MS Report Designer Builder, Visual Studio, Websphere Studio, Eclipse Dev Studio, Microsoft FrontPage, SQLite Analyzer, SQLite Browser, Quest Toad, Altovia Mission Kit, etc
• Software : Quest Toad, Quest Central, Quest Spotlight, SQL Packager, SQL Backup, SQL Compare, SQL Data Compare, SQL DTS Compare, SQLLitespeed, WordPerfect 6, Microsoft Office 9.x/2K/XP/2003, Adobe PhotoShop, Acrobat Reader, Power Point, Lotus Notes, Experian Account Advisor, Task Scheduler, OminiRush 6.0, XML Cannon, MS Visual SourceSafe, MS Project Server, MS Sharepoint, Mercury, Serena Team Track, Jira, Subversion/Tortoise, Documentum, Oracle UCM, etc.

WORK EXPERIENCE

confidential

Lead Solution Architect

• Enterprise Data Repository Program MDM, SOA, DG, Data Integration, Data Quality
• MDM Solution design: data model, data quality, data stewardship workflow, ETL processes data exceptions mgt
• Development of architecture solution options and positions papers for leadership decision making
• Work with all teams SOA, ETL, Shared Svcs, Architects, PMO, etc in the firm to design the Enterprise Data Repository/Corporate Information Factory solution for Party Master, Securities Master and Loan ODS
• Worked with Chief Data Office to provide executive level direction and resolution of strategy execution issues
• Design documentation: Architecture Docs, Diagrams, Architecture Feasibility, etc
• Guided the program through firm's architecture reviews 4 and advice mgnt.
• Designed and developed all TOGAF architecture artifacts using MEGA Suite modeling tool: ISA Level 1, 2 3 diagrams, data security, system context, engineering diagrams, component diagrams, infrastructure diagrams, business process diagrams and other diagrams for Securitization Utility Project, Collateral Data Store CDS, EDR Program

SKAI Data Virtualization PoC

• Provide architecture information management strategy advisory consulting services to executive level leadership.
• Review of vendor SKAI Big Data solution architecture and implementation patterns
• Review and validation of the Hadoop, HBase SKAI cluster infrastructure for SKAI proof of concept project
• Big Data technology and vendor solution tradeoff comparative analysis between DataStax, Cloudera, HortonWorks and Coral Networks SKAI
• SKAI code review: Forms, Relations, MapReduce mappers and reducers
• Data source and target analysis mapping for Loan entity state change SIR CLDF

confidential

• Development lead team of developers, data modeler, DBA Testers, driving the design and implementation pattern of all collateral data services solution components using Tibco BusinessWorks, Tibco EMS and ESB platform.
• Review and gap analysis of collateral data model and enterprise logical data model
• Review and gap analysis of collateral XML schema with enterprise logical data model
• Conducted Tibco code reviews, Test reviews and other project documentation
• Responsible for development, review and oversight of all SDLC artifacts for CDS project
• Developed and wrote the solution architecture document, diagrams business process, Workflow, system, context, and infrastructure and review with business stakeholders

confidential

Sr Data/Information Architect

• HP Cloud Services Integration Project ITSM Canonical Data Models Project A
• Logical Data modeling of ITIL Information objects: Change, Work Order, Incident, Interaction
• Reverse engineering of existing ITIL information objects: excel, schemas and data models
• Forwarding engineering of ITIL information objects defined with HP SMEs by conducting JAD sessions for requirements and validation of ITIL information objects with SMEs input
• Derived ITIL Canonical XML Schemas from the logical models for implementation of Cloud Services. Documentation of design patterns, naming standards and implementation approach.

confidential

Application Data Architect Business Intelligence Architect: WellPoint - IBM Watson Project: Utilization Management UMA Lung Cancer Birch

• Design of Watson training data repository: Hadoop DB2 based infrastructure for training Watson Supercomputer NLP to understand Clinical Diagnosis of Cancer illnesses.
• Designed the dimensional model OLAP for the IBM Watson performance trend, analysis, clinical analytics reporting.
• Designed and developed the utilization management UMA OLTP physical data model and DDL development for all agile iterations.
• Designed the IBM Watson clinical knowledge training data model for sending and evaluating IBM Watson training performance.
• Designed the WellPoint Care Assistant/Birch OLTP database: conceptual, logical, physical data models
• Designed the WellPoint Care Assistant /Birch Data Mart/OLAP database: conceptual, logical, physical data models. Conducted review of all data models with application development team and report development team.
• Data integration ETL design and solution architecture: data mapping, ETL logic documentation, data flow and transformation patterns.
• Business objects universe design and mapping to database for clinical analytics
• DB2 database development: store procs, functions, views and materialized views.
• Designed the business objects Universe for all reports, scorecards and charts
• Developed the business intelligence strategy and design document for the solution architecture.
• Develop business objects Web Intelligence reports matrix reports
• Universe to database objects mapping and reviews. Conducted reviews, meetings and design sessions.
• DB2 database development: views, materialized query tables, stored procs for reports

Facets Database Architect

• Derived Facets 4.7.1 logical data model from the physical data model through manual reverse engineering process.
• Designed the WellPoint Facets domains Member, Provider, Claim, Product, Billing, Group conceptual and logical model for categorizing and mapping automated business processes Jobs, user reports and application processes to the appropriate domain entities using PowerDesigner.
• Developed the data archiving strategy for Facets transaction history information.
• Researched the use of Sybase Replication Server for Facets data replication from Sybase ASE to Sybase IQ.
• Research and analysis of Sybase IQ indexes, security and role base access architecture for Facets data migration projects.
• Data analysis of Facets OLTP data store to identify domain model scope, data quality and mapping

confidential

Sr Database Architect

• Consulting to the CIO and Executive leadership of clients by defining three to five year IT strategy around cloud computing and big data solutions to support decision support in healthcare.
• Developed cloud computing roadmaps and strategies for healthcare clients.
• Evaluation, analysis and selection of Big Data technologies for clinical analytics. Hadoop based solutions for clinical decision support and clinical data exploration for MU Stage 2.
• Cloudera CDH deployment, configuration and development Pig, Hive MapReduce jobs for clinical decision support proof of concept
• Developed the master data management strategy, SOW, project plan for implementing the master Patient Index EMPI strategy using IBM Initiate
• Design the overall EMPI/MDM solution architecture: data flows, data mappings, matching rules, data governance process around patient, data cleansing rules, profiling and transformation.
• Defined the Big Data strategy using Hadoop ecosystem technology across SJHS in support of all clinical and business analytics.
• Client's enterprise application infrastructure, big data, business intelligence and cloud assessment to determine maturity of client environment. Develop execute level C Level presentation and present assessment to clients.
• Responsible for defining client Common Domain Model HL7 Messages: Orders, ADT, LAB, etc, CCD, CCR for future state SOA and Cloud enablement projects. Responsible for ICD 10 transition strategy and remediation design.
• Business process documentation, analysis and mapping through JAR /JAD session in the following functional areas: Emergency Department ED, LAB, Clinical Documentation, Clinical Quality, Case Management, Facilities Management, Materials Management, Radiology, Revenue Cycle, Finance, Surgical Services.
• Data Mapping of Common Domain Model entities to the business processes in each functional area
• Business intelligence capabilities rationalization to develop BI strategy for the organization
• Conducted executive level interviews to understand the organizations' information gaps and silos
• Application portfolio rationalization exercises and information management strategy definition around Patient Perfect Care, Clinical Analytics and Meaningful Use.
• Information integration and exchanges analysis and strategy definition around Health Information Exchange HIE projects.
• Collaborate and consult with client executive level to define information management strategies and a transition plan.

confidential

Sr. SOA Data Architect

• Analysis of CATS, JPAS and ACES data architecture to define TO BE state enterprise data architecture for future state of DISS Program.
• Designed and developed the business intelligence strategy and architecture solutions for DISS Program. Reverse engineered existing data stores for the legacy/ AS IS systems dbs Sybase, Oracle SQL Server into a logical model.
• Modeling and design of the integrated data store IDS layer of the data warehouse. Analysis of AS IS clearance and adjudication operational processes. Reviews and analysis of the TO BE state clearance and adjudication business processes.
• Review and analysis of the system architecture for the TO BE statement DISS Family of Systems.
• Reverse engineer the AS IS physical model from Sybase DDL to SQL Server and Oracle dbs.
• Defined data flow diagrams and the input output data elements for DFD processes across multiple systems.
• Define the DoDAF OV 7, SV 4, SV 11 for the DISS Program. Reviewed DoDAF OV 1, OV 5, OV - 2, SV -1, SV 2 for data related artifacts for DISS system integration.
• Canonical data modeling for Web Services message content and Data Mapping between Canonical Model and legacy Interfaces.
• Multiple XML Schemas/XSD data element mapping data consumers to Canonical data model for XSLT XQuery transformation logic.
• WSDL/Service contract reviews and operations mapping to core security entities.

confidential

Data Architect

• Conducted detail analysis of firms business processes to categorize master business entities domains.
• Used ArchiMate architecture methodology notation to design the business architecture for: Business Development, Legal Practice, New Business Intake, Human Resources and Finance operational departments.
• Derived the enterprise conceptual model master business entities from the business architecture.
• Data flow analysis to define the master data entities information integration patterns.
• Defined the enterprise master data management MDM strategy and recommendation to leadership.
• Conducted JAR sessions on business processes for Finance, NB/C and HR business process documentation.

confidential

Sr. Database Manager

• Mentoring of junior database administrators and developers 25 people, coaching, project management and project prioritization duties.
• Identified requirements, documented and design the data architecture layer for the Aeronautical Constrain Manager application.
• Logical physical data modeling of aeronautical static constraint information and requirements gathering of constraint data elements.
• Data Modeling: AIXM reverse engineering, conceptual, logical and physical data modeling of AIXM complaint databases on PostgreSQL 8.4.
• Data flow modeling, data analysis of multiple data sources for harmonization and conformance.
• Enterprise data flow architecture on the project level and conceptual data architecture for information integration.
• Wrote data architecture analysis documents, data architecture artifacts design and analysis and requirement gathering of data entities within FAA AIM organization.
• Object relation mapping between AIXM XML Schema and non-AIXM relation databases. Gap analysis of multiple data sources and AIXM schema.
• Design and development of XQueries for reading, transforming and loading Web Services Messages into relational table on PostgreSQL database.
• PostgreSQL database administration: backups, restores, DDL, DML, maintenance of indexes, partitioning and development.

confidential

Data Architect

• Data modeling, business process re-engineering, data integration, data migration.
• Health benefits data analysis, gap analysis and harmonization across data sources and systems in support of multi-organization business processes execution.
• Provided consulting technical, process, and functional advise to client on process improvement through process automation.
• Data profiling of multiple data sources to harmonize health benefit data for data cleansing.
• Business process re-engineering: business process modeling of AS IS, TO BE, process efficiency analysis using business process modeling notation.
• Designed and implemented quality assurance QA process automation solution to improve EOC production data accuracy reduce cycle turn-around time, using Excel, Access 2007 and SQL Server 2008. ETL design, development and deployment.
• Cost benefits analysis of solution architecture, project plan for solution architecture and system analysis.
• Project planning, resource allocation analysis, customer interfacing services. Conducted JAD sessions for requirements and presentations of design solutions to leadership.

confidential

Business Intelligence Developer / Architect

• Analysis and documentation of AS IS Crystal Reports and SQL Server 2005 DB Objects infrastructure for conversion to SQL Server 2008. Review and supervision of OLAP cube design and implementation.
• Requirement gathering, design and development of SSRS 2k8, SSIS 2k8 packages, tables, stored procs, views, function for conversion processes. Review of data process design and implementation.
• Analysis, design and identification of KPIs for Call Center Management Dashboard. Advisory to management on the approaches to migrating AS IS infrastructure from SQL Server 2000 to 2008.
• Project resource management: hours, project plan, statement of work, project schedule, scope and communication to leadership.
• Advisory to management on cost benefit, ROI and EVA for BI infrastructure conversion project.
• Data flow architecture design to support the BI data acquisition strategy and ETL processes.
• Reporting services design, development and deployment of reports. Presentation and training of reports to users.

confidential

Enterprise Data Architect

• Review, gap analysis and harmonization of HL7 RIM 3.0 and CCD/CCR to support EMR and PHR project. Analysis and mapping of CCD/CCR model and Claims canonical model 837,835 for PHR project.
• Entity relationship modeling for operational data stores ODS, UML class modeling for SOA Web service XML schemas WSDLs.
• Conceptual, logical and physical dimensional modeling star schema to build Healthcare Claims data warehouse. Modeling to support HIPAA X12 formats 837, 835, 277, 276 and other X12 formats.
• Profiling of multiple healthcare claims data source systems to identify enterprise definition of claims and for data cleansing for the data warehouse. Data governance activities for data quality project.
• Created data flow diagrams using Visio to document the enterprise claims information flow.
• Conducted, lead and gathered requirements business, technical and functional JAD sessions from subject matter experts to design enterprise data flow diagrams, logical data models and physical data model for business entities like Member, Product and Claims.
• Review of canonical models for Claims, Provider, Member, Subscriber and Product.
• Created solution architecture packet SAP documents for enterprise applications ITS, Blue2, Blue Exchange, CIAM, etc
• Designed logical and object oriented models for generating XML Schemas for SOA Web services on Tibco middleware. Used Tibco Designer for creating, modifying and designing XML Schemas and WSDLs for Tibco Web Services.
• Documented data elements for CA metadata repository. Created CRUD matrix document for data models, application processes and web services.
• Created data mapping documents between applications, source to target table mapping, object to relation mapping. Designed and generated XSLT for data transformation between Web Service XML Schemas and relational database using IBM Websphere development studio.
• Used Telelogic System Architect for creating Class Diagrams for XML Schemas for Web services message content.
• Designed conceptual, logical physical models and developed the Carefirst enterprise information security ODS privileges, authentication, authorization and delegation database for managing Single Sign On and Federated Single Sign On using the RBAC model.
• Designed logical, physical and DDL for Carefirst web services testing catalog database for managing test results of Web Services.
• Facets app data layer/model analysis for enterprise information integration with legacy systems.

confidential

Enterprise Data Architect: Immigration Customs Enforcement Department

• Conceptual, logical and object data modeling for information exchange packets IEP .
• Conducted JAD sessions, documentation and presentation of requirements and solutions for data models. Used the NIEM model to create immigrant and student IEP XML Schemas for the DHS USCIS, ICE department. Presented and educated management on the role of data modeling in SOA Data Services.

confidential

Enterprise Data Architect / CNE Lead SQL Server DBA

• Conceptual, logical and object oriented modeling for core enterprise business entities: Asset, Work, Work Order, Party, Customer, Usage, Contract, Service Account, Location, Product, etc.
• Created modeled XSD for geospatial data service message content using Work, Location Asset business entities for integrating information between Work Asset management system IBM Maximo and ESRI Arcview.
• Entity relationship UML modeling for SOA message content. Develop the EDA team's methodology for designing and developing SOA services message content XML schemas .
• Consulted, organized, presented and educate project leaders on data models. Set direction for data related issues on projects.
• Gathered requirements, analyzed business entities, technical and functional requirements documentation. Worked with EII team to develop principles for enterprise wide SOA strategy.
• Defined the enterprise wide LDM PDM for customer using OMG party abstraction concept.
• Defined the MDM road map for the organization and developed the guideline principles document for upper management.
• Designed CEG's Master Data Models for the following entities: Customer, Product and Usage.
• Involvement in data quality projects: customer data profiling, cleansing and governing.
• Developed CRUD matrix and System of Record guidelines for business units of the organization to support the MDM road map.
• Object data modeling using UML methodology for XML schemas for SOA Master Data Services.
• Designed message and transaction oriented content schemas W3C XML for SOA Master Data Services over Tibco enterprise message bus ESB .
• Created dimensional data models star schema for business intelligence data marts energy retail sales . Developed business objects universes BO Universes and data models for enterprise business intelligence infrastructure.
• Advised, consulted and designed database solutions for the different business units at CEG.
• Created the database code promotion process model and development lifecycle process for the SQL DBA Team. Train SQL DBAs Team of 8 on SQL Server Reporting Services and Analysis Services.
• ETL development using SQL Server Integration Services for data migration, integration, etc.
• Installed, configured and deployed SQL Server Analysis Services and implemented data model as an OLAP database.
• Database programming: T-SQL development, stored procedures, views, triggers, SSIS, SSRS.

confidential

Data Modeler/Database Engineer

• Created presentations for C level management about database architectural design and the NAV training system. Reverse engineered existing database applications from SQLite RDBMS, altered the dbs and forward engineered these databases to use MS SQL Server.
• Performed data modeling and data model integration using ER/Studio. Consolidated multiple data models and integrated multiple logical models to derive an enterprise wide data model.
• Consolidated existing databases from multiple database formats in to one SQL Server database.
• System architectural design and systems engineering of the NAV Submarine training systems.
• Database programming: T-SQL development, stored procedures, views, triggers, DTS, etc.

confidential

Data Modeler/Sr. Database Administrator

• Designed conceptual, logical and object data models based on the clinical data interchange standard CDISC . Created object models UML to derive the clinical data exchange sub-objects as XML schemas using Rational XDE. Design XSDs for data integration import export of CRO and sponsor datasets for integration.
• Designed the clinical data integration architecture and persisted data stores dbs based on CDISC ODM reference model. Data mapping between customer data store and ODM XSD schema for XSLT development.
• Gap analysis of CDISC ODM, SDTM and customer data model for data conformance.
• Data modeling using IBM Rational XDE. Requirements gathering with Rational ReqPro and implementation of database change request process using Rational ClearQuest.
• Business process and work-flow modeling using Visio 2003, IBM Rational ClearQuest, XDE and ReqPro Database Change Request, Database Code Promotion, Configuration Management, Database Code Review Process, etc .
• Designed reference logical models using the HL7 2.6 RIM. Derived XSD from logical model to be compliant with HL7 RIM for information integration application module.
• Performed business intelligence infrastructure design, configuration, development and maintenance using SQL Server, Analysis Services and MS Reporting Services.
• Designed and implemented enterprise database disaster-recovery infrastructure including database backup and recovery SOP and policy backup and restore topology .
• Configured SQL Servers for replication, database security and system backups. Restored databases and servers after disasters and system failures.
• Administered and supported sixty plus databases on SQL Server to support production, system testing, and development of client applications. Administered and supported production databases on Sybase SQLAnywhere which acted as the data store for IBM Rational software.
• Provided database support for Microsoft Sharepoint Team Services, MS BizTalk 2003 and MS Project Server 2003 System backups, restore, index fragmentation, index rebuild, Full-text maintenance in SQL Server 2000.

confidential

Data Modeler/ Sr. Database Administrator

• Designed a dimensional data model for a reporting database/data warehouse for company wide reporting. Developed OLAP Data warehouse Enterprise Reporting Systems to Support Sales Trend/Sales Analysis and Inventory Purchasing forecasting using SQL Server 2000 Analysis Services on the back end and implemented and deployed ProClarity OLAP client for end-users.
• Developed over 60 DTS packages to populate the data warehouse for business intelligence applications. Developed an Inventory Research and Forecasting Application using Access XP/VBA/ADO/SQL Server 2K. T-SQL development
• Developed databases, replications topology, DTS packages and SQL-DMO Scripts for domain to domain application support. Used Active Directory to manage security and user accounts in the database tier. Developed logical physical Tables including Views, Stored Procedures and Triggers. Developed client-tier application for reporting, manipulation and data entry Access XP.
• Performed the duties of GoldMine Systems Administrator Permissions, Analysis, Documentation, Custer Development, Integration, etc .
• Performed the duties of OminiRush Systems Analyst Backups, Configuration, Setup, Integration, Customization and Toolbar script development . Administrated Databases for Credit Reporting System Experian Account Advisor and D B software.

confidential

Software Developer

• Developed reports, tables, code-units, forms and dataports in Navision Financials 2.60.F, using C/SIDE, C/FRONT and C/AL programming methodologies. Navision Financials /Attain integration with Office XP using Automation Objects in C/SIDE. Integration using DJ COM/Access/VBA. Part of a three member team to grade from Navision Financials to Attain.
• Data extraction from flat files, Excel, Access and text files using Data Junction. Developed Cambio and DJ Scripts for data extraction. Researched on how to use Data Access Pages, SQL Server and ASP to web-enable an existing Access MDB Applications..
• Re-wrote an existing EDI business application using Access XP/2002, SQL Sever 2000, ADO and VBA. Converted Old Access 2K MDB Applications into Access XP ADP Applications.
• Performed Data Modeling, Data reversing and forward engineering with CA Erwin.
• Wrote specification, analysis and requirement documents for future client/server applications. Analyzed, documented and developed a customer service interface application using ADO, VBA, SQL Server and Access XP/2002. Database programming: T-SQL development, stored procedures, views, triggers, etc.

confidential

Computer Consultant I

• Performed help desk duties and assisted clients one on one, on all desktop applications and web development. Developed classes in J2EE Defined Oracle Views, Triggers, Stored Procedures and Tables. Administered four separate Oracle development Databases using Performance and Turning methodologies. Defined Oracle DML and other objects to support an online payment system. Wrote Enterprise Java Beans for online apps. Wrote Java Session, Stateful and Entity Beans. Developed small apps using ASP, ADO, HTML and Debugging and testing VB and Access application.

confidential

Data Analyst

• Analyzed system data Lawson and collected data to define errors and failures. Track data flow from one module to the other. Converting raw data from the system into Excel worksheet
• Run reports and analyze queries to ensure data integrity in Lawson is satisfied. Maintain and update inventory bin location, change of item number and item status.
• Developed a database in Access to work with the data conversion program in Lawson. Analyzed the logic query structure for the upgrade team in research department. Helped the test team in all testing process of upgrades. Researched the web on Lawson Procurement.

confidential

Applications Developer

• Analyzed the GL module and implement the GL tables in Lawson. Test retrieval procedures to ensure data obtained are valid. Implement the UOM system for each item.
• Developed database tables in Access and the conversion application in Lawson to upload them.
• Installed Lawson Application and train users to perform requisitions, issues, purchase orders and maintained the item master. Implemented the requisition templates.
• Performed consulting for the distribution department on issues related to Lawson: data quality, data governance, data stewardship and data sharing.