Application Tech Lead Resume Simsbury, CT - Hire IT People

PROFILE:

Information Technology professional with over 15 years diversified database experience in design and development. Extensive experience in data modeling and data warehousing. Worked as Sr. Data Architect, Sr.
Database Developer, Sr. System Analyst, Data Modeler, Oracle DBA. Hands - on experience using ETL, Stored Procedures, Advanced Queue, Triggers, Materialized Views, Replication, Reports, UNIX scripting and
Autosys/Cron job scheduling. Strong technical skills developing and tuning large production databases. In-depth understanding of computing data structures, algorithms, operating systems and object-oriented technology.
Led teams as Project Manager and individual contributor. Highly motivated with excellent communication skills across all levels of the organization. Direct experience coordinating client and internal staff .

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i/7.x, SQL Server 7.0/6.5, Sybase 11/12.

Languages: SQL, PL/SQL, Triggers, Packages, C/C++, Java, Java Scripts, XML, TCP/IP, FTP, Java, Servlets, JSP, XML, Java Beans, EJB, JDBC

Database Tools: Oracle Warehouse Builder, Informatica, Oracle Designer, Oracle Discover, Erwin, TOAD, OEM, Data mirror Replication, SQL Navigator/Toad.

Server: IBM Websphere Application Serve (WAS), Weblogic Enterprise ServerOperating Systems:UNIX (SunOS, HP UX, Nial), EMC, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Simsbury, CT

Application Tech Lead

Responsibilities:

Provided business process or designed recommendations consistent with long term business and IT strategy.
Performance tuning on web applications and Oracle databases.
Implemented authentication and authorization architecture for user identity management such as LDAP and SAML based Single Sign-On(SSO ).
Delivered design documents for integrated data management system and provided guidance on enhancement.

Confidential, Shelton, CT

Systems Analyst and Development Specialist, Database Specialist

Responsibilities:

Worked with 3rd party vendors, different clusters, led projects and implemented business requirements.
Provided input to business charters, delivered high level architectural documents, detailed design document, including cost estimation at each life cycle.

Confidential, Shelton, CT

Senior Data Admin, Database Specialist

Responsibilities:

Designed, developed, and managed the Marketing Customer Knowledge Base (MCKB) Data Warehouse using Oracle (8I).Created Data Warehouse structures (Warehouse schemas, data sources, staging tables, transforms, loading scripts).
Tuned Oracle environment to reduce extract and load cycles for Teleweb reporting environment from 12 hours to 2 hours.
Supported developers on database issues, monitored bottlenecks, maintained and tuned testing database, QC database and production databases.
Developed logical database models and implemented physical structures (tables, views, materialized views, data extractions and data transformations).
Developed functional specifications and data flow diagrams for the data loading processes.
Created database links, users, roles, tables, tablespaces, views, indexes and database triggers and batch programs.
Provided integrity checks and assessed the quality of source data to ensure proper mapping to target fields.
Implemented scripts and procedures to populate defined tables with the extracted source data.
Performed evaluation and analysis of results through unit and integration tests.
Worked closely with Sr. Management and end users to understand business intelligence and reporting needs. Developed approaches to solve business problems through the creation / enhancement of data warehouse and data marts. Implemented programs to support operations and outcomes analysis for outpatient monitoring programs at the Call Center. Implemented using Oracle 8, PL/SQL, Cogno report and Perl scripts.
Allocated and managed physical storage structures (Data files, Redo log files and Control files). Also allocated and managed logical storage structures (Tablespaces, Schemas and Extents).
Implemented backup procedures for backups and recovery of the Database. Upgraded database from Oracle8.0 to Oracle8.1.6.
Controlled and monitored user access to the database.

Confidential

Project Manager/Senior Software Engineer

Responsibilities:

Led projects related to Khalix, a multi-dimensional 3 tier client/server application, supporting SQL Server, Oracle, Sybase and Informix at the backend. Supporting worldwide clients including Xerox, Mobil, Disney, Johnson & Johnson, with database issues, coding new Khalix software features and fixing urgent bugs.
Trained internal staff.
Detailed design, implementation, problem investigation, proposing new solutions, and systems analysis. Analyzing user’s requirements, conducting research and detailed design, writing program specifications.
Multidimensional data warehouse software development using C/C++, MFC, and Visual C++.

We provide IT Staff Augmentation Services!

Application Tech Lead Resume

Simsbury, CT

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship