SUMMARY:

• Self - starting, goal-oriented IT professional with 15 + years experience. Proficient in all facets of project life cycles. Extensive experience in Architecture. analysis, design, development and implementation of Oracle suite of database and Batch/ETL technology solutions.
• Skilled at organizing complex projects, defining project priorities, delegating tasks and mentoring engineers. Excellent analytical, problem solving, inter-personal and communication skills.
• Motivated leader with proven track record appreciated by clients and colleagues.

TECHNICAL SKILLS:

• Oracle Exadata/11g/10g/9i/8/7, Sybase System 12/11/10, MS SQL Server 2005/2000
• Oracle Golden Gate, Active-Active Architecture, TOGAF, Data Warehousing
• Data Modelling, Power Designer, ERWIN, S-Designer, Control-M, Autosys
• SQL*PLUS, PL/SQL,T-SQL, Packages, Stored Procedures, Trigger, TOAD
• SQL Navigator, Performance Tuning, MS Visio, ETL, EDI, SQL Loader, Informatica
• Oracle Reports, Crystal Reports, UNIX, LINUX, Shell Scripting
• Security (PGP) Proficient, PERL, Batch programming, FTP/SFTP, CVS, PVCS, Visual Source Safe, Clearcase

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Lead IS Architect

Responsibilities:

• As a lead Architect, work on architecting solutions for ETL batches and database for a highly visible and complex pharmacy system using multiple technologies for very large data sets..
• Architected multiple batch /Database/ETL components for Active-Active architecture (Assured DR/High Availability), data/file replication, latency, Control-M, Batch refactoring, remediation, load distribution.
• Initiate root cause analysis and provide architectural solutions of complex problems related to ETL/Data.
• Lead team of data & batch Architects/developers for performance solutions of database changes across multiple projects and for designing solutions for Informatica/Java batches.
• Prepared reports and presentations to enable decision making within the senior management and extended group of stakeholders.
• Work across multiple groups in a highly matrixed environment to promote architectural solutions and get consensus/approvals.
• Defined processes across technology functions for improving efficiency, reusability and maintenance.
• Design complex batch/DB solutions spanning four VLDB databases with a total size of 50 Terabytes.
• Mentor, conduct code reviews, evaluate work of team members. Manage and delegate work to onshore and offshore resources. Conduct regular status/review meetings.

Environment: Oracle 11g/12c, GoldenGate, Informatica 9.x, SQL, PL-SQL, ETL, SFTP, Control-M

Confidential, Boston, MA

Tech Lead Database -Warehouse Consultant

Responsibilities:

• As a tech lead, work with upper level management and business partners on multiple technology initiatives, gather requirements, provide estimates and deliver the projects related to the warehouse, ETL and database.
• Evaluate and convert System Design Specs to Technical Specs.
• Design/develop the data load process from other business units through Informatica. Experienced in ETL, data loads, conversion and migration using SQL Loader, Informatica.
• Extensive experience in PL/SQL, T-SQL, Stored Procedures, Packages.
• Estimated, planned, and managed the migration project for multiple applications from Oracle 10g to Exadata. Worked on multiple OLAP as well as OLTP databases.
• Hands on development on Oracle, Informatica and Linux, supporting multiple high visibility projects.

Environment: Exadata, Oracle 11g, Informatica, SQL, PL-SQL, ETL, SFTP, SQL Loader, Shell Scripting, Perl, LINUX

Confidential, Boston, MA

Data Warehouse Consultant

Responsibilities:

• Performance tuning, coding of complex SQL, ETL code and UNIX shell scripts in a multi-terabyte VLDB.
• Created and maintained code in a complex database with numerous schemas, partitioned tables and materialized views. UNIX shell scripts.
• Toiled with developers, analysts and system support personnel in elevating and automating successful code to production.

Environment: Oracle 10g, SQL, PL-SQL, ETL, SQL Loader, Shell Scripting, UNIX, LINUX

Confidential, Boston, MA

Principal Software Engineer

Responsibilities:

• Architected the complete database schema (Oracle 10g). Created Conceptual and Physical data models (CDM & PDM) and generated scripts for creating the database using PowerDesigner 12.x
• Performance tuned database objects and queries. Lead and executed the data modelling process.
• Analysed requirements and authored Technical Specifications for the database objects.
• Managed production support involving 6 mission critical web applications/17 developers on a 24/7 basis. Restructured and improved the support model.
• Improved performance of Reporting Applications using Crystal Reports, Oracle Reports with better design, new reports as well as new report formats.
• ‘On the Spot’ for excellence in transition of the production support from one department to another involving multiple applications.
• Perform SQL profiling, code reviews, documentation, design, and implementation of methodologies to ensure high quality software.

Environment: Oracle 10g/9i, Sybase 12x, SQL Server 2005, T-SQL, PowerDesigner, ETL, Perl, Linux, Shell Scripts

Confidential, Mansfield, MA

Lead Database consultant/DBA

Responsibilities:

• Architected the Oracle database, schemas, tablespaces, users, Stored Procedures, Packages, and Triggers.
• Converted a SQL Server 2000 database to Oracle 9i within record time and accuracy involving 500 + T-SQL objects resulting in significant time and cost savings.
• SSIS & DTS packages were used to move and massage data from SQL server into Oracle database.
• Tuned SQL queries and database performance for OLTP and DSS applications within development, testing and production environments. Optimization of application queries and database objects.

Environment: Oracle 9i, SQL Server 2000/2005, Toad, PL/SQL, T-SQL, SSIS, SSRS, DTS, VB, COM, Shell Scripts, LINUX

Confidential, Waltham, MA

Senior Software Consultant

Responsibilities:

• Analysed/designed multiple ETL/EDI systems, documented functional and technical specifications. Engineered the load of ETL/EDI data files into the databases.
• Designed, developed, tuned, maintained more than 26 different customers’ data load processes.
• Production support and interaction with users and customers during the all phases.
• Perl, SQL loader, Oracle triggers/procedures, PL/SQL, T-SQL and FTP were used for ETL operations and to load/transfer EDI files into database. Database design and ER Models done on Designer 2000.
• Optimization and Performance tuning on all database objects and application queries.

Environment: Oracle 8i, Sybase 11, SQL Server 2000/7.x, Designer 2000,PL/SQL, T-SQL, Perl, SQL Loader, FTP, ETL

Confidential

Project lead/Lead Consultant/ Sr. Software Engineer/Analyst

Responsibilities:

• Optimized and tuned application queries and database objects to improve performance.
• Database design and ER Models done on PowerDesigner, Designer 2000 and ERWIN.
• Analyzed information to determine, recommend and plan installation of a new tools and modification of existing systems. Spearheaded support efforts.
• Trained and managed developers and achieved significant improvements in their productivity.