PROFESSIONAL SUMMARY:

• Result Oriented IT professional with extensive global experience working in diverse technical teams, large - scale projects providing complex database solutions in fast-paced time-focused environments.
• Strong leadership skills in architecting technical solutions and managing people, motivating and directing high profile projects, providing database solutions for business problems involving state of the art technologies and varied databases.
• DB Modeling and Architecture - DB Design and Performance Tuning
• Systems Architecture - Database Administration
• Project Management - IT Outsourcing
• IT Integration and Consolidation - Process improvement

EXPERIENCE AND SKILLS SUMMARY:

Over 25 years’ experience in ETL/data/database related areas.

HARDWARE OPERATING SYSTEMS LANGUAGES OTHER SKILLS:

• Over 15 years in Confidential 3090, RS-6000, pSeries, HP, Confidential -PC
• OS/390, z/OS, UNIX, Linux, NT, WINDOWS 2000
• PL/SQL, Java, C, C++, COBOL, Smalltalk, Perl, BASIC, Pascal, ADA
• DB2, Netezza, ORACLE RAC, Advanced Oracle Replication, Oracle-
• ASM, ERwin, XQuery, Power Designer, Teradata, CICS, EJB, Ant,
• DB2, DB2 UDB, WebSphere, Weblogic, IMS DB/DC, LEX, YACC
• Agile/Scrum, AD Lifecycle, RUP, CMM, RAPID, JAD, Waterfall Used Project Management Tools, developed work plans, estimations, staffing plans, project scoping, status reports, risk assessment and deliverables. Banking , Retail, Automobile, Government, Manufacturing, Insurance, and Telecoms

PROFESSIONAL EXPERIENCE:

Confidential

IT Architect

Responsibilities:

• Played the roles of Senior Data Architect/Manager, Data Modeler, Data Conversion Lead, and Project Manager on various Confidential .
• Responsibilities included managing 4 to 10 DBAs/developers, staff performance evaluations, providing status/risk/issue reports to customers, planning, gathering requirements, database architecture, database performance tuning, change control, data security, and improving availability for several clients. Other work involved responding to RFPs, mentoring and discussing long term process improvements as a member of AD(Application Development) Technical Steering Committee with other architects.
• Working on a roadmap and redesign of microservices based architecture for their e-billing system.
• The new system will run in an on-premise cloud environment. unum: Identified bottlenecks in the DB2 data model/SQLs in the ICR(Insourced Customer Reporting) for Claims and Leaves application that hindered the system from going live.
• This system serves all their customers (more than 1000). Over a period of 1 year in 3 releases, the customer was able to insource this application saving significant amount in outsourcing fees for the legacy application. Paypal: Reviewed the Paypal payment application and database architecture for performance, scalability and provided reports to the executives with current issues and alternate solutions. Paypal implemented one solution immediately and scheduled the other one for next release.
• This included change management, migration procedures, knowledge transfer and creating and enforcing standards.
• As part of the solution implemented a technology and business modernization initiative in multiple releases that allowed clients to apply for and manage benefits via the Internet, mail, or by phone.
• This included working with the Operations Support team and the Application Support team to in corporate the DR plan/architecture into a cohesive Business Continuity plan.
• Lead data architecture R&D activities, develop database architecture standards Developed database architecture and oversaw the implementation of the databases in 5 environments and 15 database instances. Responsible for detailed architecture, design, implementation and performance of database infrastructure with Oracle Advanced Replication.
• The main application database had more than 2000 tables with over 100 tables having 20 to 600 million rows each. Responsible for providing direction and performance of the conversion and reporting databases and teams Was responsible for performance tuning of CRIS database and automating database operations during the User Acceptance Testing. Other work involved verification and validation of migrated data from legacy systems.
• Performance Food Group: ETL Lead / Netezza DBA for Enterprise Reporting Strategy (ERS) group Project Description: Worked as ETL lead/Netezza DBA for new reporting requirements in a Cognos/Netezza/Informatica environment. Source data came from DB2 system.
• The work involved Creating mappings from MDM system to Data warehouse for access by Self service Business users. Helping Informatica developers with challenges they faced Designing and creating new tables per PFG standards in Netezza. Moving data as needed between Netezza environments as needed (Prod to UAT/test) Tuning Netezza environment for optimum performance.

Confidential, Tampa

Architect

Responsibilities:

• Database performance improvement was key issue. Improved the database performance by 70% with a series of major and minor changes to database and application design.
• Migrated databases from SQL server to Oracle in an effort to consolidate maintenance effort.

Confidential

Lead Database/Application Architect

Responsibilities:

• Worked in all phases of SDLC for this product starting with strategic planning, gap analysis, requirements gathering, design/development and most recently in level 2 support.
• Responsibilities included feasibility study, database design & administration, performance testing/tuning, mentoring junior DBAs/programmers in DB2/java and customer support.
• Designed a web based administration tool to automate routine DB2 database administration tasks on the z/OS.

Principal Architect

Confidential

Responsibilities:

• Principal responsibilities were designing the database for the Confidential (a B2B) product, developing and tuning all SQL where necessary, and developing an ORmapper for the database.
• The analysis and design phases were done using RUP. Other responsibilities included product integration with DB2 Text extender, designing & developing security and administration interfaces and co-ordination of product development.

Senior Consultant

Confidential

Responsibilities:

• Went thru the process of the certification to teach Data Warehousing and DB2 courses for Platinum.
• Duties include training, Confidential assessment for prospective and current clients, and managing Confidential projects and development of e-commerce site by customizing Open Markets Transact product.

Project Leader

Confidential

Responsibilities:

• Over 20 million dollars of payments were processed and paid by this system every week.
• As the system architect designed the development of a Health Insurance Decision Support System for Confidential Systems.
• This product is used by the nation's major health insurance companies and is supported on multiple platforms in a multi-tiered client/server environment.
• The work involves evaluation, design, documentation, implementation and testing in a Client/Server environment.
• This product was supported on two client platforms (Windows and OS/2) and three server platforms (MVS, OS2 and UNIX).
• Designed and implemented several general purpose utilities for different platforms to increase productivity and increase testing efficiency.