Business Intelligence Data Architect and Developer with 5 + years experience working with data integrations and migrations in data warehousing environments. I have experience working in all phases of the SDLC
Qualifications
Programming and design skills
SQL expert
Data Modeing
ETL Design
Database Servers
MS Visio, Embarcadero Data Architect
Technical Writing
Agile development methodologies
Requirements analysis and design phases
Technical Skills
Programming
SQL
7
Current
Programming
T-SQL
5
Current
Programming
PL-SQL
2
2011
Database
SQL Server 2008 & 2012
7
Current
Database
Oracle 10g & SQL Plus
2
2012
Data Modeling
Microsoft Visio
7
Current
Data Modeling
Embarcadero Data Architect
1
2012
ETL/Application Development
Visual Studio
3
Current
ETL
SSIS
3
Current
ETL
Informatica
1
2011
Ad Hoc & Canned Reports
SSRS Report Builder
2
Current
Application Development
C#
1
2010
Application Development
Java
2011
Application Development
JSON
2014
Operating System
Unix
2011
NoSQL
Mongo DB
2014
Data Analysis/Technical Documentation
Redgate
2
Current
Technical Documentation
Technical Specifications
7
Current
Work Experience
Senior Consultant, 04/2013 - Current National Financial Partners Corp. – Washington, DC,
Contracted to CDC, Atlanta, GA & Cleared for Public Trust
Designed and implemented a Data Migration and Archiving Strategy for tables containing 100+ million rows each, using type two slowly changing dimensions, reducing table sizes by 80%, & increasing database performance.
Improved communications between client and development team by implementing documentation, creating Data Models (MS Visio), Data Dictionaries (Redgate) & Technical Architecture Documents, & Source to Target Mappings of existing systems
Met with CDC directors and data team to determine requirements and business rules for a new reporting portal
Performed Data Quality Analysis and Database Reverse Engineering (MS Viso) of Source Databases
Analyzed inbound and outbound EDI X12 Interchanges and SAP IDocs to understand transaction types available, as well as data flows, within a Microsoft Biztalk Server for a new reporting portal
Created SQL Server Views and SSRS Data Sets for new Reports
Created SSIS ETL packages sourcing data from multiple production databases into to data warehouse
Production support of existing data warehouse SSIS packages, Stored Procedures, SQL Server Views, and SSRS reports
Data Modeler, 09/2012 - 04/2013 Accenture Contractor Jobs – Herndon, VA,
Reverse engineered SQL Server, Oracle, & MUMPS Hierarchal databases, to document and understand data structures & lineages (Embarcadero Data Architect)
Analyzed source data and source metadata in SQL Server
Identified common entities and attributes between disparate source systems and created a common Master Data Enterprise Target Model
Designed target architecture and data models for a new enterprise data warehouse and Analytics capability
Worked with IT team and managers to understand current state architecture and data flows
Worked with business unit directors to determine requirements, reports, current issues, and business rules
Researched analytics and key metrics being done in other hospital settings and wrote a Recommendation Paper for business unit Stakeholders
Created technical document templates to be used for future project deliverables
Implemented best practice methods for a new development shop within a hospital environment
Completed Vendor training in Embarcadero ER Studio
SQL Server, Oracle, Embarcadero Data Architect, Mumps Hierarchal database, Visio
Analyzed source data and source metadata from SQL Server and Oracle data marts and cubes, using SSMS to identify data redundancy, quality, shared, and degenerate dimensions
Determined data sets to be migrated to a new target SQL Server database and newly designed analytics area
Worked with client Directors, Business Analyst, and Data Architects to identify analytics requirements, business rules, and types of slowly changing dimensions needed to capture historical data
Created functional and technical design specifications for sign client sign offs and deliverables
Designed a migration strategy, source to target mappings, package design, and Audit Balance Control for error handling thresholds, of initial and subsequent data loads, for offshore development teams
Mapped data in Informatica PowerCenter 8
Worked as point of contact for offshore development teams and participated in weekly meetings remotely with offshore staff to track progress, determine risks and issues, and relayed back to onshore project management team
Contributed to RFI by conducting Gap Analysis of current to future state architecture, data architecture, and vendor scoring
Mentored junior level staff
Planned & organized team/client dinners
SQL Server, Oracle, Informatica PowerCenter 8, Viso
Data analysis in SQL Server and Oracle SQL Developer to determine data quality
Analyzed data and metadata from Oracle and SQL Server databases, in order to identify common data attributes across three disparate database systems located in the US, UK, and Singapore
Created a common conceptual and normalized logical model of common attributes, and a target data dictionary from disparate sources for a new data store
Created source to target mappings from multiple source systems to common target model and documented known data issues
Interacted with Business Analyst, end Users, and directors to determine requirements and understand current processes, reporting methods, and source systems
Conducted playbacks of analyses to clients for monthly deliverables
Attended weekly meetings remotely with offshore teams in India, Singapore and the United Kingdom to document and understand workflow processes and data stored in offshore source systems
Mentored junior level staff
Planned & organized team outings, & trainings with outside vendors for our consulting analytics and data warehousing group at direction of the PMs
IT Administrator, Intern, 09/2009 - 2010 Carestream – Ca, CA,
Designed and implemented a SQL Server database to be used for personal asset management that would allow clients to track personal art collections on loan between various exhibits and homes.
Documented Requirements & Database Attributes
Wrote use cases and designed process flows/workflows for application development
SQL Server, Visio
Contractor, 09/2007 - 09/2009 Solomon Edwards Group – City, STATE,
Assisted in the implementation of an insurance claims database, for the purpose of tracking claim trends to determine future premium and budget costs
Researched claimant information in an insurance claims system for discrepancies and updated records in the interim Access reporting database
Created a process improvement by designing a data model for a SQL Server database to be used by Claims Analyst that would replace redundant and complicated Excel spreadsheets and emails
Microsoft Access, Visio, and advanced Excel (vlookups, hlookups, macros)
Worked between Accounting and IT during a AR/AP systems integration
Served as Point of Contact and lead meetings with Pilot Plant Controllers & staff during an AR/AP systems integration rollout, to explain the purpose & capabilities of the new system, as well as to address any concerns pertaining to implementation roll outs and testing
Created weekly & end of month financial reports
Researched, tracked & reported on dollar amount variances that exceeded write off thresholds
Root cause analysis on AR/AP erroneous auto-matches for IT
Determined, reported, and tested Key Performance Indicators (KPI’s) for IT to bring the integrated system up to a 100% auto-match rate during the pilot plant implementation phase
Conducted testing & created reports for developers
Bachelor of Arts: Art History, Expected in May 1999 - Louisiana State University - Baton Rouge, LA GPA:
CIS Certificate: Computer Information Systems, Expected in December 2009 - Georgia State University - Atlanta, GA GPA:
SQL, Database Processing & Design- Course covered relational database design concepts as well as ANSI SQL & T-SQL: data ER modeling, data normalization & deNormalization (Dimensional Modeling), data cardinality, crowsfeet & Microsoft database notation, data integrity, database administration, OLAP, Data Mining, Reporting; Course projects completed using Microsoft SQL Server and Access rdbms; Conceptual, Logical & Physical data models completed in Microsoft Visio
Project Management- Course covered PMBOK, the SDLC, & project management methodologies such as agile and waterfall; Course Projects completed using Microsoft Project; Completed & presented a case study on the Denver Airport Automated Baggage System Implementation Failure
Systems Analysis: Course covered Systems Analysis & the SDLC. Final project presentation & deliverables included Requirements Specification Document including Formal Use Cases, Functional Specification Document, 8 UML Diagrams, which included 3 structural (Class, Object, Package) & 5 Behavioral (Use Case, Activity, Sequence, State Machine, & Communication) created using Rational Rose Software
Skills
Account Reconciliation, Accounting, Ad, agile, Analyst, AP, Application Development, AR, Architect, art, asset management, Balance, Billing, billings, billing system, BizTalk, budget, Business Analyst, Business Intelligence, Business Objects, Cognos 8, consulting, client, clients, Customer Service, Data Analysis, data dictionary, data migration, Data Mining, Data Modeling, data warehouse, database administration, databases, Database, data warehousing, designing, dimensions, direction, Drivers, EDI, Erwin, financial reports, Functional, Informatica, insurance, Macros, meetings, Access, Microsoft Access, C#, Microsoft C#, Excel spreadsheets, Excel, Microsoft Project, Microsoft Visio, migration, Modeling, Month end closing, MUMPS, Enterprise, object oriented programming, OLAP, Oracle, Developer, Oracle and SQL, Oracle SQL, package design, Pivot Tables, processes, process improvement, progress, Project Management, quality, Quest, Rational Rose, rdbms, relational database design, reporting, research, RFI, sales reports, SAP, SDLC, Specification, SQL Plus, Microsoft SQL Server, SQL, SQL Server, strategy, Systems Analysis, system analysis, systems integration, Technical Documentation, Teradata, Toad, T-SQL, UML, Visio, Microsoft Visual Studio, Visual Studio, workflow
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
