We provide IT Staff Augmentation Services!

Consultant Resume

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

Hire Now