We provide IT Staff Augmentation Services!

Integration Consultant Resume

Boston, MA

SUMMARY

  • Self - starting, goal-oriented IT professional, proficient in all facets of project life cycles.
  • Extensive experience in Architecture. Analysis, design, development and implementation of Oracle suite of operational, data warehouse and Batch/ETL technology solutions.
  • Skilled at managing, 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/12c/11g/10g/9i/8/7
  • MS SQL Server 2008/2005/2000
  • Active-Active/High Availability Architecture
  • Oracle GoldenGate
  • SAP Hana
  • Data Warehousing
  • Business Intelligence
  • Data Modelling
  • PowerDesigner
  • ERWIN
  • Control-M
  • Autosys
  • Cron
  • PL/SQL
  • T-SQL
  • Packages
  • Stored Procedures
  • Trigger
  • TOAD
  • SQL Developer
  • MS Visio
  • Performance Tuning
  • SQL Loader
  • Informatica
  • SSIS
  • SSRS
  • SSAS
  • DTS
  • Cognos
  • Tableau
  • Business Objects
  • UNIX
  • LINUX
  • Shell
  • PERL
  • AWS
  • MySQL
  • NoSQL
  • Big Data
  • Hadoop
  • XML
  • SFTP
  • HTML
  • CVS
  • SVN
  • Jira
  • Clearcas
  • GIThub

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Integration Consultant

Responsibilities:

  • As a product owner, responsible for gathering requirements, POC, data mapping, design, develop and coordinate QA, UAT testing and implementation of a high priority compliance project with strict deadlines.

Environment: SQL Server 2014, MYSQL, Oracle 11g, Talend

Confidential, Cambridge, MA

Lead BI/DW Engineer

Responsibilities:

  • Work with Architecture Review Board to define technology roadmap, strategic solutions, process improvement & implementing new business functionality.
  • Defined the migration strategy for moving the legacy DW to in-memory cloud platform of SAP Hana. Hands-on techno manager, supported production operations on all levels.
  • Manage, delegate, oversee, and review work of other BI Engineers.
  • Used Agile development methodology to deliver projects in 2 week sprints.
  • Technical specs, Source to target data mapping, data analysis, OLAP design & modelling.
  • Support/resolve data issues and reporting on Cognos and Tableau reporting platforms.
  • Consolidate multiple data sources and ETL loads to load data into the warehouse using sqlloader, PL/SQL, SQL, Perl and UNIX scripts. Maintain and improvise 500+ daily ETL jobs.
  • Provide technical/functional support. Performance tuning of slow running queries.
  • Design new framework for ETL, data cleansing, data quality and data integrity.

Confidential, Woonsocket, RI

Lead IS Architect

Responsibilities:

  • Architect solutions for batches and database components for a highly visible and complex pharmacy system using multiple technologies.
  • Manage, lead and delegate work to Project managers, team leads and development managers both onshore and offshore. Own & deliver projects from start to finish. Conduct regular status/review meetings. Mentor, conduct code reviews, evaluate work of team members.
  • Architected batch /Database components for Active-Active architecture (Assured DR/High Availability), data/file replication, latency, Control-M, Batch refactoring, remediation, load distribution.
  • Define technology roadmap for database and ETL. Project Owner for the batch track, responsible for all batch and data related deliverables.
  • Initiate root cause analysis and provide architectural solutions of complex problems related to ETL/Data.
  • Lead batch & data Architects for designing solutions for Informatica/Java batches and for performance solutions of database changes across multiple projects.
  • Responsible for database design and modelling of both the OLTP and OLAP database systems.
  • Ensure a scalable, Available, Reliable and high performance architecture for database and batch systems.
  • 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.
  • 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.

Environment: Oracle 11g/12c, GoldenGate, Informatica 9.1/9.5, SQL Server, ERWIN, PL-SQL, ETL, SFTP, Control-M

Confidential, Boston, MA

Tech Lead Database

Responsibilities:

  • As a tech lead, work with senior 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 Design 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, materialized views and 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’ Award 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, Informatica, 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 for ETL. Tuned SQL queries. Optimized 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.
  • Perl, SQL loader, Oracle triggers/procedures, PL/SQL, ETL, EDI, 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

Hire Now