SUMMARY:

• IT Architect with 15+ years of experience across multiple sectors including healthcare, telecommunications and manufacturing.
• Solid track record in large - scale systems integration and consolidation programs involving a wide spectrum of IT environments.
• Helping companies
• Adept Confidential analyzing and navigating data warehousing architecture, then shaping a vision and strategy to achieve high ROI data base optimization and quality assurance
• Communication: Demonstrated ability to communicate with diverse audiences
• Quickly gains and builds trust, partners with, guides and leads cross-functional teams on high visibility projects.
• Solution Development: Known for ability to analyze systems and utilize experience to bringing value by addressing system performance issues, dramatically improving data quality and processing speed.
• Known for bringing value by addressing system performance issues, dramatically improving data quality and processing speed.
• ETL Architecture / Project Management: Consistent on-time delivery on large complex engagements requiring alignment and execution across multiple divisions and external resources.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Manager/ ETL Architect

Responsibilities:

• Provides expertise and support of database and systems operations.
• Reviews data flows and interfaces for system performance and quality assurance.
• Brought in to address performance issues, slow speed and data inaccuracies of systems impacting all merchandise operations: pricing, catalogue, order, shipping and inventory
• Quickly built rapport, partnered with and guided cross functional teams of Vice Presidents, Directors and Managers of all interfacing systems and the IBM offshore team to define system performance issues, then develop and execute the solution.
• For systems pulling data loads of several million records, improved the base layer by introducing two servers. Reduced processing time from four hours to one hour, boosting performance by 400%.
• Lead ETL Architect on project to streamline processing and improve data quality while increasing efficiency of SQL coding.
• Developed SQL Scripts to be used by production teams and off-shore during “scripted deployments” of system updates, data & object modifications, etc.
• Lead on project to redesign data flow of pricing data to process only data that has changed versus the prior strategy of utilizing a full data load.
• Supported ETL’s using Informatica Power Center 9.5 & 9.6, ORACLE 10g/11g, DB2
• Jobs run in LINUX environment utilizing K-Shell scripts in UC4 / Automic1 Process Scheduler against Oracle and DB2 databases.

Confidential

Responsibilities:

• Responsible for database systems development and management for the project, including modeling, quality assurance, validation procedures, SSIS/ETL development, review of SQL code to be implemented and support of DB2, Oracle and SQL Server. Technical lead for database deployments to locations around the US and internationally.
• Developed SQL Scripts to be used by production teams during “scripted deployment” Confidential the plants.
• Technical lead (SME) for the integration of systems interfacing the formulation interface.
• Provided support for information/data logistics issues Confidential Nestle.
• Developed Business Intelligence reports for multiple clients.
• Worked with end-users to identify business requirements and prepare technical specifications.
• Proactively tuned SQL Server and DB2 databases, in an effort to better support the system and improve efficiency and accuracy.
• Reviewed security issues and instructed class on data integrity and how the data relates between SAP modules and how it is manipulated in the data flow process.
• Developed data validation and quality assurance procedures used utilizing C# and SQL.
• Assignment Confidential Metropolitan Sewer District documenting enterprise systems, performance tuning and PL/SQL development as pertains to the MAXIMO / GIS interface and related systems.
• On assignment Confidential Realtime Results as SQL Server DBA to develop a business intelligence / reporting system used for call center metrics Confidential.
• Other duties included development of ETL packages and SQL coding, stored procedures, functions, triggers, tables and related objects.

Confidential, St. Louis, MO

Responsibilities:

• Provided database systems development and management including development of quality assurance and validation procedures, SSIS/ETL development, and support of DB2, Oracle, and SQL Server.
• Functioned as the Technical Lead for database deployments to locations around the United States and internationally.
• Partnered with multiple departments to gather business requirements and prepare technical specifications.
• Acknowledged and addressed security issues by creating and delivering classes on data integrity, relationship of data in SAP, and manipulation in data flow, resulting in separate data systems to house user information, and page-specific access to the web interface used for recipe QA and delivery and plant reports.
• Created a dashboard for a formulation project data engine used to track ingredient waste, usage, and recipe recalibration.
• Documented data flows to target areas to improve data quality and processing efficiency.
• Documented systems architecture as it pertained primarily to the Maximo and GIS systems.
• Proposed and implemented solutions for improvements to existing interfaces.
• Redesigned interfaces, resulting in a substantial increase in processing speed.
• Identified and eliminated redundant processes that reduced processing time by more than 50%.
• Reviewed all operations and interfaces into the database systems, and provided performance improvement, error trapping, and quality assurance and control of data. While tuning and recoding interfaces, made them more efficient and improved accuracy.

Environment: Windows Server, Linux, UNIX, AIX, DB2, ORACLE 9i/10g/11g, MSSQL Server 2008-2012, SSIS, ODI, Confidential -SQL, C#, ASP.NET, VB.NET, UC4, PL/SQL, JVM, Java, VISIO, Visual Studio, SDLC, Agile, ERWIN

Confidential, Highland Park, IL

Project Manager

Responsibilities:

• Planned, implemented, tested technology asset management database system migration from SQL server to Oracle 9i.
• Managed project to create an e-system to identify cost savings options for materials management and finance departments. Subcontractor to Spherion.
• Supervised testing and QA.
• Developed and launched disaster recovery procedures.

Environment: Windows Server, Linux, UNIX, AIX, DB2, ORACLE 9i, MSSQL Server 2005, SSIS, ODI, Confidential -SQL, C#, ASP.NET, VB.NET, UC4, PL/SQL, JVM, Java, VISIO, Visual Studio, SDLC, Agile, Confidential Express methodology