Data Software Engineer

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

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 managing “on-” and “off-” shore development teams

Expert level knowledge in applying Data modeling technics, data governance, dimensional data modeling

BUSINESS PROCESSES AND APPLICATIONS

Claims Processing: I-Many Contract Management Software Suit for Life Sciences, Revitas Contract Lifecycle Management, Model N

Clinical Data Processing: Oracle Clinical

Document management: Veeva Vault

Conceptual, logical, and physical data models design: ERwin r 9.6, Ab Inito, ER Studio

TECHNICAL BACKGROUND

Databases: Oracle 8 through 11g, Oracle Database 12c Release 2, 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, Teradata Macros

EXPERIENCE:

Clinical Systems World 02/15/2014 – present

Wayne, PA 19087

Senior Solution - Information Architect

Lead information management development of an innovative of R&D Business Events management Software product called Actio.

Utilize my ETL background for the design, creation, and execution of Informatica workflow processes and complex

SQL code.

Responsibilities Included:

Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.

Used Teradata utilities fastload, multiload, tpump to load data

Wrote BTEQ scripts to transform data

Wrote Fastexport scripts to export data

Wrote, tested and implemented Teradata Fastload, Multiload scripts, DML and DDL.

Constructed Korn shell driver routines (write, test and implement UNIX scripts)

Wrote views based on user and/or reporting requirements.

Wrote Teradata Macros and used various Teradata analytic functions.

Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.

Performance tuned and optimized various complex SQL queries.

Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.

Gathered system design requirements, design and write system specifications.

Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.

Developed and tested extraction, transformation, and load (ETL) processes.

Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.

Maintained SQL scripts and complex queries for analysis and extraction.

Designed UNIX scripts to execute jobs that automated the ftp process of loading flat files posted on the ftp server.

Provided guidance to business analysts on complex technical projects that required Advance SQL coding

Developed ETL procedures to migrate data from an existing data warehouse to an integrated enterprise level data warehouse.

Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.

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 and ETL tools

Exposure of data base procedures via Web services API

Configuration, Setup and management of Oracle Instances on the Cloud (AWS)

Management of contributing 11 database developers on and off shore

07/15/2013 – 01/15/2014

AstraZeneca (via Innovative Development)

1800 Concord Pike, Wilmington, DE

Sr. Information Technology Solution Architect of Managed Market USIS

Accountable for AZ managed market domains: Validata, Contract Management and other managed market applications;

Responsibilities included:

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;

ABIM (American Board of Internal Medicine) 01/07/2013 – 07/10/2013

510 Walnut Street, Philadelphia, PA

Sr. Information Technology Analyst

Responsibilities included:

Production support of ABIM 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 ABIM 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;

Accenture/Pfizer Inc., Collegeville, PA 08/08/2011-01/01/2013

Sr. Database Developer / Database Architect

Participated in multiple projects to harmonize Pfizer and Wyeth processes and systems in the following business areas: Managed Care, Chargebacks/Rebates, Medicaid, Government Pricing, Contract Analytics, and Contract Data Warehouse (CDW)

Responsibilities included:

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

UnitedHealth Group IT, Horsham, PA 08/15/2008- 08/05/2011

Sr. Software Engineer

Responsible for detail design and development of enterprise Financial Service Center applications to support the core financial activities surrounding the Part D Pharmaceutical Claims for PDP and MAPD memberships including the following functionality: operational data warehouse of pharmaceutical claims, reporting and reconciliation services for Finance and Accounting teams, business financial process automation, feed of downstream financial and reporting systems of the state agencies (CMS).

Responsibilities include:

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

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.

I-Many, Ambler, PA 01/15/2008-08/05/2008

(New company name Revitas, Inc., Model N)

Sr. Software Engineer

Responsible for development and support tasks of a major software development project: Validata.

Responsibilities included:

Direct interactions with top pharmaceutical clients (GSK, Eli Lilly) 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

GHX Pharma Solutions Ambler, PA 09/15/2006-01/15/2008

Sr. Software Engineer

Participated in the design and development of an Oracle-based commercial software products, ClaimRight Medicaid and ClaimRight Commercial

Responsibilities included:

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

Bridge Information Technologies, Cincinnati, Ohio 03/2001-08/2006

Sr. Oracle Consultant

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

Workspace Solutions, Framingham MA 09/2000-03/2001

Oracle Developer

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

Staples, Framingham MA 08/1998 -09/2000

Senior Programmer Analyst

EDUCATION:

MS in Computer Science, National University of Kiev, Ukraine

PROFESSIONAL TRAINING: Advanced Oracle PL/SQL; IBM DataStage v8.0 ETL, Oracle Data Modeling; Advanced Unix shell programming, Advanced PL/SQL tuning.

US Citizen

Contact this candidate