SUMMARY:

• 15 years of strong IT experience
• Extensive experience in IT team management and process management
• Extensive experience in working with both internal groups and outside vendors
• Extensive experience in software management, database design, data migration, ETL
• Extensive experience in MS SQL Server, Oracle, Sybase RDBMSs
• Database Architect for system load balancing and reliability and scalability.
• Over 10 years of experience in database design from conceptual to logical to physical.
• Certified Big Data - Hadoop, Hbase, Hive, PIG

EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Consult Client on Best Practice and Best Usage of systems
• Design a Data warehouse from scratch
• Design extraction system extracting data from multiple different sources
• Revamp and Streamline Employee Scheduling system
• Act as Business Analyst interfacing different Business Groups on requirements
• SQL Server 2012, SSIS, SSRS, ETL, Visio, T-SQL, Erwin

Confidential

Senior Data Manager

Responsibilities:

• Managed a team of six engineers from Data Operations
• Guided and Designed solutions for daily OPS activities
• Architected and Redesigned current data model to tighten data security
• Responsible for Companywide Billing Systems
• Work with Engineers and Business Groups on requirements
• SQL Server 2012, SSIS, SSRS, ETL, Visio, T-SQL, Erwin

Confidential

Senior Database Architect - Contractor

Responsibilities:

• Designed Implementation plans to Reorganize Bank Customer data
• Remapped Customer data to proper Customer Tree
• Designed Data Migration Plans from Oracle to SQL Server
• Worked with Engineers and Business Groups on requirements
• Setup Daily, Weekly, Monthly Data Migration using SSIS
• SQL Server 2012, SSIS, ETL, Visio, T-SQL, PL SQL

Confidential

Senior Consultant

Responsibilities:

• Designed and architected the Data Migration system
• Utilized SQL Server SSIS packages to migrate large data from Oracle to SQL Server
• Designed the Notification system to notify key users if packages fail
• Strategized Disk Partitioning strategy to swap large amount of data in and out of the database quickly
• SQL Server 2012, SSIS, ETL, Visio, Erwin, T-SQL, PL SQL

Confidential

Database Architect/Manager

Responsibilities:

• Managed a team to convert a Healthcare system from Oracle to SQL Server 2012 Data Warehosue
• Requirements gathering, data mapping, and business rules generation
• Created Systems Process Flow and Data Flow diagrams
• Defined data profiles and Identified KPIs for various internal business groups from Revenue Forecasting to Fraud detection
• Managed a team to implement Big Data project to gather healthcare related data for fraud detection project
• Defined data profiles and Designed data migration strategies from various sources to a centralized database
• Designed and created data models from conceptual to logical to physical
• Designed SSIS scripts to migrate and transform data and load
• Guided DBA team to tune databases including index analysis, query analysis, and applied best practice methodology
• Created Training Operations Manual and trained staff on systems usage
• SQL Server 2012, SSIS, ETL, Visio, Erwin, Excel, T-SQL, PL SQL

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Managed Data Migration communication processes
• Manipulated data from satellite databases into master database
• Designed data migration strategies
• Business Requirements gathering. Interviewed key users to identify requirements and created the BRD
• Built Database Data Dictionary and Business Rules and Metadata
• Developed data load quality verifications and reports
• Database tuning: Index Analysis, Query Analysis
• Wrote complex SQL from scratch: Stored Procedures, Triggers
• Worked with Business Analysts on customer communication on the Wachovia merger conversion project
• SQL Server 2008, SSIS,, MS Confidential, Visio, Erwin, Crystal Reports, T-SQL, Excel

Confidential

Project Manager/Process Modeler

Responsibilities:

• Managed project timeline and schedules with reporting to management
• Communicated and applied project standards
• Managed resources in accordance with project schedule
• Consistently delivered high quality services to clients
• Created requirements and technical specs
• Data integration mapping from different sources to target database
• MS Confidential, MS SQL Server

Confidential

Data Steward

Responsibilities:

• Managed the Billing/Asset Management databases
• Automated SQL queries and stored procedures into self driven scripts
• Planned for data migration of external company into internal database
• Integrated external company functional requirements into stored procedures
• Designed and maintained database schemas, ERD
• Developed reports on Workqueue performances and trends using complexed SQL from scratch
• Built Confidential application to manage work queues
• Consolidated data from various data sources into raw database in single data format
• Created data process model using Visio for data mapping and data loading
• SQLServer 2005 DTS and SSIS packages for transformation of the data
• Built test scripts for QA
• SQL Server 2005, MS Excel Pivot Tables, ETL, VSS, MS Confidential 2000, Visio, Erwin, FTP

Confidential

Data Modeler/Project Manager

Responsibilities:

• Developed Compliance system for Confidential Group
• Designed database schema and functionality. Built Entity Relationship Diagrams
• Built Contact Management database system for internal Compliance team members
• Identified data sources and extracted data from data sources into a consolidated database.
• Built automation script to capture data on weekly basis.
• Developed SQL scripts from scratch
• Designed system to house regulatory inventory and annual plans implementation
• Full lifecycle development including requirements gathering and testing
• Managed project lifecycle of a web based software development
• Worked with engineers and DBA group to build an internal web portal database system
• Created process models and process flows
• Created technical specs on data migration for developers
• Technical Project Manager coordinating and presenting to upper management
• Created business analytic reports for Management, Finance, Customer Service, Marketing and Operations departments that will be used on a periodic basis to monitor business performance
• Acted as liaison between Business and IT
• SQL Server 2005, MS Confidential 2000, Visio, Erwin, JSP, JavaScript, JDBC, MS Project

Confidential

Data Modeler/Project Manager

Responsibilities:

• Designed and Built Compliance Risk Monitoring software for banking industry. Software was written in C#, .net. Backend is SQL Server 7 connected through ADO.
• Reversed Engineer from existing Confidential database to create new schema in SQL Server
• Designed data model, data dictionary for the Compliance software both logical and physical models using Erwin
• Wrote conversion software for Confidential 2000 to SQL Server 7
• Project Management - Oversee entire project lifecycle including software and hardware procurement, project timeline and budget.
• Set standards and guidelines for best designing process
• Designed reporting systems using Crystal Reports, .net framework, C#, Jscript
• SQL Server 7, MS Windows, MS Confidential 2000, Visio, Crystal Reports

Confidential

Database Architect/Database Manager

Responsibilities:

• Managed Engineering team to build Vectiv Web Based Commercial Real Estate software.
• Reported directly to VP of Engineering. Direct reports include two database administrators and one data modeler.
• Advised senior management on technical issues/trends, worked with client's in-house IT department to supply defined technologies and analyze benefits of new technology.
• Evaluated project feasibility and formulate/design detailed technology solutions to communicate to senior management
• Led all development activity includes system design, software development, database design, tuning and technical implementation of Vectiv server, Oracle DBMS
• Led all development of Professional Services consulting needs include building the dataload interface tools and stored procedures
• Created technical specs from functional specs for IT engineers for application development and QA
• Worked with outside vendors on collaboration efforts to build the product in conjunction with the product team
• Windows NT, UNIX, Oracle 8i, JSP, Toplink, XML, EJB, Erwin 3.5.2, Barker ER Notation

Confidential

Data Architect

Responsibilities:

• Database Administrator - SQL Server 6.0
• Led development of web based applications for worldwide customer support systems. ClearSupport, ClearContracts
• Designed Star Schema for Customer Support DSS
• Led the data migration from ClearSupport, ClearContracts into Dimension DB for reporting. Developed reports using Excel Pivot Tables linked to SQL Server Data Source
• Led the integration and migration of the in-house legacy reporting systems to utilize Crystal Reports software
• Windows NT, SQL Server 7.0, Erwin, Confidential, JSP, ASP, JavaScript, Business Objects

Confidential

Manager

Responsibilities:

• Managed a group of ten Professional Services engineers for Confidential product consulting division
• Setup training systems for new hires
• Managed West Coast regional clients and installations
• Worked on resource planning for entire staff leveraging skill levels in task allocations
• Designed interface schemas and helped in customization of interface process for best practice
• Budget and resource planning in recruiting and training of new talents
• Reported directly to VP of Professional Services

Confidential

Database Architect

Responsibilities:

• Designed and modeled the Confidential - EMR software database architecture
• Managed database processes
• Databases designed include Pharmaceutical, Medical Claims, Patient Medical Record, Billing
• Set technical standard and direction; provided leadership and general support in a technical environment for the software group
• Worked on MPI (Master Patient Index) scheme for Confidential Clinical software
• Created use cases and sequence diagrams and test plans
• Responsible for setting up the technical infrastructure and designed the strategic long-range plans
• SQLServer 2000 DTS packages for transformation of the data