- Data Architect/ Data Modeler/ Data Analyst professional with extensive experience in Relational Databases RDBMS .
- Provided high-level expertise in data management as well as information management. Specialized in conceptual, logical, physical and dimensional data modeling, data architecture, database design, data analysis, data profiling, data integration, reverse-engineer, data conversion, data mapping, gap analysis, business analysis, functional design, functional documentation, decomposition analysis, data flow, and other aspects of the data management. Understand data integrity, data quality, and data accessibility.
- Strong at the enterprise level as well as application and project levels of deployment. Proficient at the high-level as well as at the detail-level. Handled complex new systems, project integration, and technical designs.
- Provided support to multiple Production Systems. Worked with numerous legacy mainframe systems.
- Provided evaluation and recommendation on technologies and tools for data management. Assisted with assessment preparation.
- Promoted use of data modeling, data management and their best practices.
- Possessed strong analytical and problem solving skills. Possessed ability of mentoring.
- Worked directly with clients and management to resolve conflicts. Kept log of production issues. Worked with cross-functional and global teams. Communicated project information to multiple levels in the organization. Worked with outside vendors and prioritizing the work.
- Proficient in developing varies levels of documentation: Context Diagram, Process Diagram, Decomposition Diagram, Data Flow Diagram, Data Exchange Diagram, Data Mapping Matrixes, and other. Worked with data stewards. Worked with ETL. Worked with SQL. Worked with master data management issues.
- Quick learner, self-starter, detail oriented, and quality conscious. Worked with several frameworks: DoDAF, Zachman, PLC, SDLC, and others.
- Certified in Standard Operational Procedures SOP and 21 CRF Part 11 Awareness Training. MS Project certified. Erwin certified. MS Project certified. PMP certification in progress.
- Industries: pharmaceutical, sales force automation, marketing, health care, mortgage, financial, banking, Telco, government, insurance, technology, and other.
Environments: OLTP, OLAP, ODS, DSS, b2b, data warehouse, SOA, CRM, pay-by-phone, and other web portals.
- Operational Systems and Technologies:
- Windows UNIX AIX/6000 TCP/IP TSO/ISPF Mainframe systems MS SQL Server Enterprise Manager T-SQL TOAD TOAD for Data Analysts TOAD for SQL Server SQL Navigator PL/SQL File-Aid SPUFI QMF SQL/DS STOBE VSAM IDCAMs Lotus Notes MS Visual Source Safe FTP Facilities Documentum Serena SharePoint
- CA AllFusion Data Modeler Erwin R7 Erwin Reports ModelMart BPwin Web Publisher Oracle Designer Cayenne/Bachman Case tool Power Designer Pervasive Software ETL formerly Conversion Designer MS Project 2007 MS Office 2007 MS VISIO 2007 Data Repository Adobe XML Spy Oracle SQL Developer Documentum eRoom Enterprise Architect by Sparx Systems IBM Rational Clear Case IBM Rational Clear Quest MS SQL Server Management Studio 2005 CaliberRM ProVision WebVision Click-To-Talk Click-To-Conference Click-To-Share
- ORACLE MS Access Teradata MS SQL Server 2005 Sybase DB2 SQL/DS IMS IDMS FOCUS VSAM CSV files
- HTML XML Java Script SQL CICS C COBOL COBOL II Sync Sort JCL Assembler PL/I
Sr. Data Architect / Data Modeler / Data Analyst
Worked for IBC and provided support to DA M organization as Data Architect / Data Modeler. Support Sales Marketing, Provider, Benefits Summary areas. Perform data analysis by analyzing data correctly, identifying potential problems and understanding metadata perform data modeling create PDM based on LDM using IBC standards sent PDM to the team to approve data model s via Erwin generate DDL scripts using complete compare function against the database s sent script to DBAs for implementation once the script is executed in development region, perform certification process of the model against the development region where DBA implemented the script sent communication e-mail to the team that environment is ready for testing. Completed mandatory training such as: Introduction to corporate and financial investigation department Annual compliance training: compliance matter HIPPA general training privacy 101 and HIPPA general security training security 101.
Lead Data Architect / Data Modeler / Data Analyst
Worked for Hewlett Packard HP and provided support to Enterprise Business Information Technology EB IT organization as Data Architect / Data Modeler. Worked with cross-functional and global teams that consist of: JAVA, SQL, and UI developers, Domain Core Lead Architect DCLA , Business Users, Enterprise Architects, Solution Architects and PMO. Translated business requirements into logical and physical data models, produce data mapping sources-to-target documents at the enterprise level as well as at the project level via TOAD access data in order to understand the data values. Designed CDM, LDM and PDM data models. Produced content diagrams, created list of Business Data Objects BDO , data dictionaries, worked with data services. Work with Enterprise Data Architecture EDA team. Consult with data stewards and subject matter exports SME . Worked on different projects including: the Next Education Services for Technology Software TS and Hardware HW project, the Care Pack Central-Good, Better, and Best project, and the Knowledge Management project. Attended Enterprise Data Architecture Review EDAR . Work with third party Learning Management Systems LMS SABA education application. Participate in the Data Architecture Process Maturity Survey assessment and evaluation of internal review of main process areas within Data Architecture DA and Business Process Management BPM teams.
Lead Data Architect / Data Modeler / Data Analyst
Worked for Defense Logistics Agency DLA and provided support to Common Food Management System CFMS program as Lead Data Architect / Data Modeler of Technical Integration team. Worked with JAVA, .NET, Business Object, ETL and UI developers worked with business functional, infrastructure, data migration and PMO teams. Translated business requirements into the database design Designed data models and produce data dictionaries for Custom databases: such as User Management, FFMIA, Portal Training and Announcements , Patron Mgt DEERS , CDS, and others. Created and enforced database standards and procedures. Worked with varies teams to resolve data conflicts and inappropriate data usage. Provide assistance in creating Capability Production Documents CPD . Develop and supply for each CFMS Custom database a CFMS Custom Data Model as ERD diagram, CFMS Custom Data Dictionary, CFMS Custom Relation Dictionary and other documents to satisfy the DoDAF requirements. Worked on SQL scripts with developers to prepare scripts for a weekly Release s worked with Release manager and infrastructure team to deploy weekly Release s into different environments Lab, development, test, and etc. . Work with User Reference data, as well as Technical Reference data. Write SQL scripts to resolve different data issues, analyzed the data to help with understanding various test cases and business processes provide the answers based on analysis. Performed integration and UAT testing. Create and restore MS SQL Server database backups. Identified and analyzed varies problems specific to data issues and data accuracy within information system s . Assigned work to others, as well as provide training across team and organization. Performed data profiling collected and examined data and collected certain statistics about the data for different purposes. Assisted with writing loading specs for ETL developers assisted with data mapping s and data validation.
Sr. Data Business Analyst / Data Modeler
Worked for Research Planning and Integration RPI IT MRL division as Sr. Data Modeler/Data Business Analyst. Performed report migration analysis process on Repository of Authoritative Data Sources RoADs data warehouse project. Focused on delivering authorize, reliable and a single authoritative repository/source of data to support business analytics and reporting analysis, specifically Book Of Business BoB Reports. Produced various levels of process diagrams, logical data mapping documents, performed various levels of analysis data and business , produced PowerPoint presentations, and organized MS net-meeting sections. Mapped RDR Oracle to Roads OPX2 and ePDR to RoADs. Worked on star schema for the RoADs reporting data warehouse application. Performed databases reverse-engineer ePDR, RDR created dataflow diagrams. Followed SOPs. Performed function as data profiler. Identified various trends of data by creating various matrixes: CRUD matrix risk of used different metadata data types matrixes provided data quality, data accuracy and data quantity matrixes performed risk assessment for the metadata and data values that existed in different data sources, databases, etc . Worked with Web services.
Sr. Enterprise Data Architect / Data Modeler / Data Analyst
Worked for Army Net-Centric Data Strategy ANCDS branch and provided support to CIO/G-6 office as SME in various efforts. Produced the Army Data Migration Strategy document and create Data Management Maturity Model and Data Technology Maturity Model. Assisted with putting together the Data Management Capability Maturity assessment questionnaire. Created varies forms/documents/matrices for the Capability Maturity Model Integration CMMI team document from the Data Management processes perspectives. Worked on multi-years 2007-2016 Army data strategy Road-map document from Current network-enable to Service enable to Net-centric enterprise . Developed new Contacts of Interest CoI while providing support for Net-Enabled Command Capability NECC program. Involved in various steps of discussions, planning and reviewing steps in establishing Data Governance Program Life Cycle including roll-out plan with and at different levels of DoD potential data stakeholders group , and identified most Common Data Governance Processes such as accountability, stewardship, managing change, resolving issues, defining data, data quality, ect . Organized and facilitated working teleconference sessions. Identified stakeholders. Worked with Command and Control Systems C2 . Worked on high-visibility effort for Joint Forces Command JFCOM with NECC Data Needs Matrix, based on Army existed business capabilities identified Army candidate systems, their data sources as well as candidate Authoritative Data Sources ADS . Developed various Department of Defense DoD Architectural Framework DODAF artifacts such as Context Diagram, Process Diagram, Decomposition Diagram, Data Flow Diagram, Data Exchange Diagram, Data Mapping Matrixes and other for SOA Data Mediation Service. Worked on and reviewed various joint services data models. Delivered EXSUM, meeting notes, and other forms of communication to the government. Uploaded documentation into Serena web documentation management system . Participated in varies User Group meetings. Performed function as data profiler. Identified various trends of data by creating various matrixes: CRUD matrix risk of use different metadata data types matrixes provided data quality, data accuracy and data quantity matrixes performed risk assessment for metadata and data values that existed in different data sources, databases, ect. . Discussed data quality issues with data stewards. Worked with Master Data Management MDM issues. Gathered data and prepared briefings.
Sr. Enterprise Data Architect/ Data Modeler
Worked for Data and Process Engineering DPE Group as Sr Enterprise Data Architect. Provided support for different applications Retail and International Retail systems . Worked on multiple projects simultaneously. Created Conceptual Data Model CDM based on Project Charter and Business Capabilities Documents. Produced Logical Data Model LDM in third normal form based on business requirements documents. Facilitated work sessions. Participated/led data gathering and design sessions to identify data requirements. Kept log of opened/closed issues. Created Data Mapping Document DMD , based on business requirements. Collaborated with IT developers and business during design and analysis phases. Conducted / facilitated JAD sessions. Participated and/or led data model reviews and inspections sessions, data analysis, and data discovery sessions. Worked with data, data definitions, and structures. Published models and other metadata documentations. Produced data dictionary for each project.
Sr. Enterprise Data Architect/ Data Modeler / Data Analyst
Worked for DMG Data Management Group . Created conceptual, logical, physical, and dimensional data models. Designed relational data models as well as star schema data models. Provided daily support to Production Systems as well as carry out responsibility for different applications ORS, B2C Portals, VETSS, E3-Cube/B2B Eligibility Gateway, NDB and others . Worked with production On-Line Reporting System ORS Data Warehouse. Worked on multiple projects simultaneously. Managed diversity of database design from pay-by-phone and various web portals applications to dimensional reports and small database change request changes. Performed analysis and design. Facilitated work sessions. Participated and/or led requirements and design meetings to identify data requirements. Collaborated with IT staff and business partners to share ideas synergistically. Captured business and functional processes, data definitions, data, and structures. Captured data change across time. Produced series of reports, matrixes, diagrams, data dictionaries, and other documentations. Worked with Master Data Management MDM issues. Identified various trends of data by creating varies matrices: CRUD matrix risk of use different metadata data types matrixes provide data quality, data accuracy and data quantity matrixes performed risk assessment for metadata and data values that existed in different data sources, databases, ect. .
Sr. Data Modeler
Worked on Automated Underwriting AU Discovery phase projects for GMAC Residential to developed and designed Risk Management analytical Data Mart/Data Warehouse and Enterprise Data Repository EDR and EDAP Data Warehouse EDAP DW . Created logical data model for EDAP EDR, and logical model for EDAP Risk Management RM data mart. Performed analysis and research. Worked with origination Pilot, Co-Pilot, DiTech, WALT, and Landscape , servicing Mortgage Serv , NEV, CMS, and Risk Management source systems clients to identify data requirements and system architecture. Facilitated work sessions. Produced data dictionaries. Performed data mapping, reverse-engineer databases. Captured data change across time.
Business Analyst/ Technical Writer
Provided support for Pfizer Business Technologies Marketing Animal Health division. Performed analysis. Worked with developers and QA personal. Created power point presentations. Produced Visio workflow using use cases for Opt-In web application. Worked with definitions, data, and metadata. Built matrixes.
Sr. Business Analyst / Data Analyst
Provided support for Sales Force Automation SFA system. Revised documentation for MobilSync database application, including FACTS system analysis. Created Risk analysis worksheets for each examines process. Identified areas of risk, including data integrity, replication keys, and performance issues documented each and every area. Update Mobil database project encyclopedia. Validated and documented business rules. Created matrixes. Created Configuration Items List for MobilDBSync project. Worked with MobilSync metadata. Worked with data warehousing team. Performed data profiling. Identified various trends of data, performed risk assessment of metadata and data values that exist in different data sources, databases, etc. .
Sr. Data Modeler /Data Analyst/ Business Analyst
Supported eVOC Reference Data Repository RDR web-based application in addition, it was a single point of reference application about compounds . Revised documentation for eVOC RDR, including creation of project-level data model ERD Reverse-engineered eVOC ORACLE databases separated model into 4-subject areas: Compounds, Clinical Trials and Protocols, WWA-World Wide Application and Submission, and Investigators and Institutions. Designed an assessment forms and conducted survey of each client regarding various services that eVOC was providing. Based on responses from survey, built CRUD matrix by clients, by eVOC RDR Subject Area. Worked on High Level design for CPM-eVOC interface. Performed high level analysis of existed As-Is business processes, including Capacity Management Planning, Project Accounting, Clinical Grants, Financial Forecasting, Clinical Trial, Corporate Finance, Headcount Management, and eVOC systems. Focused on Business Process Re-engineering BPR To-be . Analysis included interview management and staff from each system. Created and produced series of deliverable documents including context diagram, high-level business process diagram BPD , DFD level 0, and DFD Level 1 diagrams. Used RUP Rational Unified Process methodology. Created conceptual model for MRL Management Pipeline process at enterprise-level. Worked with data stewards on data quality issues. Worked with data, understand data structures, identified business terms, data definitions, and common meanings, also identified authoritative source, and alternative solutions for business needs. Involved with data governance process. Worked on defining reusable services SOA . Worked with drug development processes. Discussed data quality issues with data stewards. Facilitated JAD sessions.
Sr. Data Modeler/ Data Analyst
Oversaw data conversion effort of moving data from existed scientific mainframe Legacy systems into target Activity Base ORACLE db. Worked with scientists, developers, DBA, managers and data analysts. Identified and analyzed existing data and processes. Gathered detail information on specifics of each database. Developed logical data model that supports business functions and data. Performed data normalization. Identified relationships. Created subject areas SA based on business functions. Produced data dictionary. Mapped source to target. Gathered requirements wrote specifications. Captured business rules. Built transformation rules. Worked with taxonomy. Created physical model. Performed data cleaning. Ensured data quality and data integrity was not at risk. Verified test results with clients. Performed data analysis and tests. Led and worked with developers to guide them through process. Documented sequence of steps required in order to process data conversion extract programs for ETL process. Developed project plan and test cases. Prepared reports and memos for data conversion process from Data Management perspective. Documented data interfaces. Produced Process Flow Diagrams PFD , Data Flow Diagrams DFD , and Functional Decomposition Diagrams FDD . Performed data transformation using Data Junction ETL case tool. Worked with external vendors. Ensured project stayed on target. Kept project management up to date regarding project milestones, potential problems, and issues. Provided training. Conducted research and provided resulting recommendation of Meta Data Repository tool, as well as ETL tools for project. Trained in Standard Operational Procedures SOP and 21 CRF Part 11 Awareness Training.
Packaging Coordinators Inc, Prefer Network, Telcordia Technologies Inc, AT T, NCR, ACSIS Inc, The Vanguard Group, Prudential Insurance Company, CoreStates Bank, Smith Kline Beecham.