We provide IT Staff Augmentation Services!

Senior Consultant - Warehouse Resume

SUMMARY:

  • Senior database leader with significant experience in strategic data architecture and vision
  • Experienced in end to end data and technical process visualization
  • Managed projects from operations and development groups based on business needs and priorities
  • Experienced in normalized and de - normalized data structure design (OLTP and OLAP), and data warehousing
  • Experienced in single handed end to end database architecture, design and development.
  • Inherited projects significantly behind schedule and turned them around to meet KPI and SLA requirements.
  • Very experienced in discussing and understanding user requirements, and building data systems to support them.
  • Wrote Project’s database design and development standards and practices, including naming standards, data model guidelines and data migration Strategy.

TECHNICAL SUMMARY:

Platforms: HP Superdome, Sun SPARC, HP 9000, IBM PC, ES9000

OS: Solaris, HPUX, DOS, Windows, Unix SVR4

Tools: Oracle, Sql Server, Exadata, Toad, ERWIN, PostgreSQL, Goldengate Multimaster, Oracle Reports, Pro*C, Peoplesoft SQR, SQL, PL/SQL, OLAP, ERP systems, Developer 6, Designer 6, Oracle Discoverer, Control-M, Visual SourceSafe, Data warehousing, DB2/Spufi, MVS/JCL, Cobol, Java, Javascript, HTML, Perl DBI/DBD, MQSeries

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant - Warehouse

Technology: Oracle PL/SQL, Manhattan WMS

Responsibilities:

  • Analysis and design of new and changed processes for implementation of new WMS
  • Instituted for all designers and developers on efficient database batch processing with significant focus on performance

Confidential

Senior Consultant

Technology: Oracle R12, PL/SQL

Responsibilities:

  • Leadership of data conversion efforts from multiple sources into Oracle for OLBB
  • Lead conversion efforts for 3 phases of customer data migration into new systems.

Confidential

Architect - IT strategy

Technology: SQL Server, PostgreSQL, MS Access, VB

Responsibilities:

  • Resolution of complex technology and integration issues
  • Reviewed existing reporting models and architecture leading to new development that improved performance of reporting over 50%
  • Highlighted gaps in reporting and data management capabilities, and developed mitigation strategies.

Confidential

Senior Database Solution Designer

Technology: Oracle 11g, ANSI SQL, PL/SQL, Java

Responsibilities:

  • Responsible for all aspects of database design, development and ownership of Oracle/PLSQL code for FATCA
  • Leadership and mentoring of design and development teams, creation and oversight of design documents and code.
  • Driven endeavours to determine and fix important data and processing issues in a highly complex architecture
  • Identified capabilities and supporting applications imbalances resulting in revisions to corporate data models and reporting capabilities.
  • Worked with all levels of external and internal business customers for requirements development

Confidential

Database specialist, Manufacturing IT Database Development

Technology: Oracle 11g, Exadata reporting, Toad, ANSI SQL, PL/SQL, GoldenGate(Multimaster)

Responsibilities:

  • Responsible for all areas of manufacturing database transaction logging and reporting in a complex replicated global system
  • Conceptual integration of a very complex manufacturing (OLTP) and reporting (batch) environment.
  • Designed, developed and supported a complex Java based manufacturing reporting system with Oracle backend.
  • Supported global manufacturing in highly dynamic environment with massive transaction volumes to minimize downtime resulting in significant cost savings.
  • Actively involved with internal customers and external manufacturing partners in providing efficient solutions for end-to-end manufacturing.

Confidential

Senior Consultant

Technology: Oracle 9i, Pl/Sql, Unix (AIX), Confidential Shell scripts, AutoSys

Responsibilities:

  • Development of SQL scripts for consolidation of aggregates of credit card transactions for fraud prevention
  • Developed scheduler scripts to automate multi-module data generation and load scripts
  • Developed Confidential scripts for data validation and loading

Confidential

Senior Oracle Developer

Technology: Oracle 10g, Discoverer, Pl/Sql, Unix (AIX), SQL Server 2005

Responsibilities:

  • Re-engineered premium allocation stored procedures for Large Property Insurance
  • Developed procedures to queue up quotes and policies and pass it to clients for processing.
  • Documenting and fixing production problems reported by the business.

Confidential

Senior Database Developer

Technology: Oracle 10g, Pl/Sql, SQR, Unix (AIX), Ksh, Visual SourceSafe, Control-M

Responsibilities:

  • Architecture of database applications - requirements gathering, build, test and implementation.
  • Developed several API’s for commonly used HR and Benefits systems 24X7 support of production environment - monitoring execution, responding to alerts and notifying clients
  • Timely and accurate delivery of downstream data feeds
  • Meet with internal and external business clients on a frequent basis

Confidential

Senior DB Developer

Technology: Oracle 10g, Pl/Sql, Unix (AIX)

Responsibilities:

  • Development of PL/SQL scripts to migrate bank customer data from legacy mainframe to Oracle based client-server architecture

Hire Now