We provide IT Staff Augmentation Services!

Senior Solution - Information Architect Resume

SUMMARY:

  • Data Warehousing design and implementation
  • Experience with business requirements gathering, business analysis and documentation
  • Expertise in applying data integration concepts in pharmaceutical and managed care industries
  • Experience in troubleshooting and handling production support duties on a 24x7 basis
  • Experience in delivering projects in a SOX and CFR Part 11compliant environments
  • Ability to work productively 15+ years of IT experience in Health Care and Life Sciences industries with concentration in application and database design and development.
  • Expert software engineer - consultant and senior level corporate developer with fundamental background in advanced Oracle database development, performance tuning, data modeling, data extractions, transformation, validation, loading, and data warehousing.
  • Practical knowledge of various SDLCs, corporate IT standards, compliance procedures, multiple operating systems, programming languages and IT infrastructure platforms
  • Expert-level Oracle PL/SQL Architect and Developer, SQL Server, Erwin r9.6
  • Subject Matter Expert in Model N Technologies
  • Extensive design, development and testing experience with Informatica PowerCenter 8.x,9.x and IBM InfoSphere DataStage v11.5
  • Excellent hands-on experience in Korn shell scripting
  • Excellent knowledge in with on and off shore development teams
  • Expert level knowledge in applying Data modeling technics, data governance, dimensional data modeling, Kimball Dimensional Modeling Techniques

TECHNICAL SKILLS:

Databases: Oracle 8 through 11g, SQL*Loader, Erwin r9.6, ODBC, IDMS, MS Access, SAS, SQL Server

Programming: SQL, PL/SQL, IBM DataStage v11.5, TOAD, SQL Navigator, UNIX Shells, Crystal Reports, SAS, PL/1, IBM Web Sphere, J2EE Enterprise Services, CVS Repository, AutoSys 4.5, FTP, SFTP, MS SharePoint, Informatica PowerCenter 8.x,9.x

PROFESSIONAL EXPERIENCE:

Confidential

Senior Solution - Information Architect

Responsibilities:

  • Conversion of Business Requirements into the Product’s information architecture
  • Development of a complete Data Model for the product using Model Mart of ERwin for effective data models management.
  • Creating entity relationship diagram and multidimensional data models
  • Design and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service
  • Led focused project teams in the configuration and customization of SaaS applications
  • Integrated data from multiple sources by using DataLoader
  • Exposure of data base procedures via Web services API
  • Configuration, Setup and management of Oracle Instances on the Cloud (AWS)
  • Management of contributing database developers on and off shore

Confidential, Wilmington, DE

Sr. Information Technology Solution Architect

Responsibilities:

  • Requirements management: Delivery of Solution Blueprint, Technical Architecture Specification, Business Application Architecture Specification based on User Requirements Specification and System Requirements and Traceability Matrix;
  • Conduct of documentation review (Technical Lead);
  • Change management oversight (Technical Lead);
  • IT landscape management, architectural coordination of technical environments to support projects and small enhancements based on review of the Service Enhancement Schedule;
  • Architectural review of documents produced by vendors to ensure compliance with the Solution Blueprint and continuing delivery on budget;
  • Design of the overall systems as well as development of the Oracle procedures to support “big data” volume of daily loads;
  • Design and development ETL processes with using Informatica PowerCenter 8.x, 9.x, and custom PL/SQL packages to implement highly scalable, high-performance enterprise data integration applications;
  • Design and development of data migration PL/SQL scripts for Validata and CM projects, development and review of the UNIX shell scripts;
  • Working on complex production issues related to performance tuning of the Oracle 11g database;
  • Solution Expert on ETL design, Data modeling, Data Warehousing, and Data integration meeting with Business Intelligence and Business Operations teams to understand data sources, implement information flows and business requirements with using ERwin tool and ER Studio;
  • Analyze, validate, convert, and compute data to facilitate Business Intelligent decisions;

Confidential, Philadelphia, PA

Sr. Information Technology Analyst

Responsibilities:

  • Production support of Confidential Systems and WEB based applications;
  • Database architecture and design work for data migration project from Oracle 11g to SQL Server database of Continuous Maintenance of Certification (CMOC) System and IBIM databases.
  • Technical Lead role in Confidential applications and systems integration and enhancement projects with using Oracle Advanced Security Transparent Data Encryption (TDE);
  • Troubleshooting and deployment of bug fixes and enhancements within tight deadlines;
  • Preparing technical training and processing documentation for the support team;
  • Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, Explain Plan, TK PROF;
  • Using SQL* Loader and external tables approach for ETL processing;
  • Design and development ETL processes with using Informatica PowerCenter 9.5.1. ;
  • UNIX shell scripting for execution and control of ETL processing;

Confidential, Collegeville, PA

Sr. Database Developer / Database Architect

Responsibilities:

  • Technical Leadership for Contract Data Warehouse project
  • Design and development of PL/SQL packages, store procedures, configuration files, tables, views, and functions; implementation of best practices to maintain optimal performance
  • Training and technical management of developers, advising other development groups on development of Oracle databases, data warehousing and ETL best practices
  • Conduct of code walkthroughs and review peer code and documentation
  • Building efficient Oracle packages for processing fact and dimension tables with complex transformations
  • Creation of systems for capturing, reporting, and correcting error data
  • Working with developers, DBAs, and systems support personnel in elevating and automating successful code to production
  • Gathering of requirements and design of data warehouse and data mart entities, creation of Source-to-Target mapping documents for ETL processes using ERwin and ER Studio
  • Design and development ETL processes with using Informatica PowerCenter 8.x, 9.x.
  • Cost benefit analysis of various ETL tools and technologies
  • Development of UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle
  • Implementation of complex transformations by creating custom transformations in addition to using built-in ones
  • Oversight of unit and system tests and assisting users with acceptance testing.
  • Peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
  • Design of scalable, reusable, and low maintenance ETL templates
  • On-call support for production systems

Confidential, Horsham, PA

Sr. Software Engineer

Responsibilities:

  • Collection of user requirements as Technical Lead for multiple FSC projects
  • Project documentation for all required steps by the SDLC, corporate standards and SAX compliance procedures
  • Planning and execution of assembly and integration testing
  • Evaluation of test results and identification of process improvements
  • Change requests as necessary and assisting in the impact analysis of submitted change requests
  • Support development planning activities for project releases; identify the scope and structure, define management plans, execution and control plans and conduct process tailoring
  • Support of applications logical data models: review the conceptual data model, define the entities and attributes, define the entity relationships, determine referential integrity and other constraints, identify the usage and volume of data, normalize the data model, consider inventory key for aggregation and de-normalization
  • Design and development of ETL processes involving data quality and testing
  • Design and development ETL processes with using Informatica PowerCenter 8.x
  • Development of data warehouse technologies and BI
  • Use of the Common DataStage v8.0 ETL Framework for all ETL projects.
  • Working with SQL Loader and External tables to perform data import as a part of ETL process.
  • Implementation of advanced PL/SQL programming practice (table partitioning, global and local indexes, bitmap indexes, external tables, materialized views, advanced error logging process and advanced Pl/SQL tuning methodology to process and validate 4TB of production data with approximately 250GB of additional SAN space per month. Approximately 300 million records per month injected into the environment across six fundamental tables.

Confidential, Ambler, PA

Sr. Software Engineer

Responsibilities:

  • Direct interactions with top pharmaceutical clients ( Confidential, Confidential ) on various production application issues and product enhancements
  • Troubleshooting of complex application environments (Oracle 10g database and Oracle objects, J2EE servers and Java applications as well as the application integration logic)
  • Development of built in packages, collections, performance tuning using b-tree, bitmap indexes, bulk updates for performance enhancements, and partitioning by range, lists
  • Work with SQL Loader and External tables to perform data import
  • Development of software fixes and patches, product release management, and coordination of development and QA processes

Confidential, Ambler, PA

Sr. Software Engineer

Responsibilities:

  • Logical and physical design of an Oracle 10g database and database objects (packages, procedures, triggers, etc.)
  • Design of the application logic, including production of formal design specifications
  • Advanced manipulations with Oracle application programs to fill the needs of the .Net-based WEB interface - all application logic resided in the Oracle layer Interactions with Product Mangers and the team leads through all the software development stages Claim Right Medicaid 2.0

Confidential, Cincinnati, Ohio

Sr. Oracle Consultant

Responsibilities:

  • Participated in the design and development of Oracle 9i databases and procedures of a new case report forms management software package for the pharmaceutical industry.
  • Relational database design; Database storage for XML files; Custom role-based security package PL/SQL packages and procedures;
  • Database optimization and tuning;
  • Tracking database for software change control and problem management;
  • Backup and restore of the development database; Custom SQL*Plus reports

Confidential, Framingham, MA

Oracle Developer

Responsibilities:

  • Provided support of the Oracle back-end of the customers employee benefits WEB-based system.
  • Participated in the development of data loading and data validation programs for new clients.
  • Application development activities included: Analysis of client data sets, data mapping and development of PL/SQL loading modules;
  • Design and development of PL/SQL packages for data verification and cleaning; Performance tuning of PL/SQL programs and intermediate Oracle tables

Hire Now