Hi, I’m
Irina Smilansky
King of Prussia,PA
Summary
19 years of IT experience in Health Care and Life Sciences industries with concentration in application and database design and development. Data Warehousing, Data Lake design and implementation. Experience with data Visualization, data Virtualization, Master Data Management, and metadata management to help meet business objectives. 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 24/7 basis. Experience in delivering projects in a SOX and CFR Part 11 compliant environments. 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 ETL 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 onshore and offshore development teams. Expert level knowledge in applying Data modeling technics, data governance, dimensional data modeling. Expert level knowledge of TOGAF 9.2 Framework and the TOGAF Architecture Development Method 'ADM'.
Overview
17
years of professional experience
1
Certification
Work History
Sr Data Architect
Job overview
- 19 years of IT experience in Health Care and Life Sciences industries with concentration in application and database design and development Data Warehousing, Data Lake design and implementation Experience with data Visualization, data Virtualization, Master Data Management, and metadata management to help meet business objectives 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 247 basis Experience in delivering projects in a SOX and CFR Part 11compliant environments 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 ETL 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 onshore and offshore development teams Expert level knowledge in applying Data modeling technics, data governance, dimensional data modeling Expert level knowledge of TOGAF 9.2 Framework and the TOGAF Architecture Development Method ADM
Clinical Systems World
Sr Application/Data Architect
11.2018 - Current
Job overview
- Involved in Complete Software Development Lifecycle SDLC from Business Analysis to Development, Testing, Deployment and Documentation
- Used Teradata utilities Fastload, multiload, tpump to load 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 to Teradata and PostgreSQL databases Performance tuning and optimization of various complex SQL queries
- Good knowledge of Teradata Manager, TDWM, PMON, pgAdmin Gathered system design requirements, design and write system specifications
- Excellent knowledge of 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 implemented the Python application to perform Data Visualization using Matplotlib, Plotly, pandas and Seaborn
GlaxoSmithKline
Sr IT System Solution Architect
06.2018 - 11.2018
Job overview
- Analyze and define clients business strategy and determine system architecture requirements to achieve business goals Formulate strategic plans for component development to sustain future project objectives
- Gather detailed business requirements and use cases, and translate technical specifications into product requirements Create team strategies and establish project scopes of work; communicate project deliverable time-frames and benchmarks to clients Develop data architecture design to facilitate targeted customer analysis Suggest architectural improvements, design and integration solutions, and formulate methodologies to optimize object-oriented software and database development Organize end-user training and problem analysis for server, desktop, and IT infrastructure work Diagnose and repair Unix and Windows processing errors, and implement solutions to improve efficiency Write and implement new server, middleware, and database standards
Clinical Systems World LLC
Enterprise Solution Architect
02.2014 - 05.2018
Job overview
- Provided guidance to business analysts on complex technical projects that required Advance SQL coding Maintained SQL scripts and complex queries for analysis and extraction 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 Exposure of database procedures via Web services API Translated technical specifications into project scopes of work and product requirements while spearheading design and development of databases and enterprise solutions Implemented application developments, resolved performance issues, and provided end-user training on hardware and software Integrated data from multiple sources by using DataLoader and ETL tools Configuration, Setup and management of Oracle Instances on the Cloud AWS Management of contributing 11 database developers onshore and offshore
AstraZeneca (via Innovative Development)
Sr. Information Technology Solution Architect of Managed Market USIS
07.2013 - 01.2014
Job overview
- 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)
Sr. Information Technology Analyst
01.2013 - 07.2013
Job overview
- 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 ABIM 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
Accenture/Pfizer Inc
Sr. Database Developer / Database Architect
08.2011 - 01.2013
Job overview
- 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 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 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 Design and development ETL processes with using Informatica PowerCenter 8.x, 9.x
- Development of UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle
UnitedHealth Group IT
Sr. Software Engineer
08.2008 - 08.2011
Job overview
- 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
IMany
Software Engineer
01.2008 - 08.2008
Job overview
- Ability to handle highly stressed situations and unexpected errors in an efficient manner Assist in the commercialization of service and project management software Attending weekly client meetings to discuss the specifics of the automated tests Coding, testing and fixing programming errors Conceptual, logical and physical database design Creating and executing unit test cases Creating contract management system that digitalizes contract generating, signing and organizing
Education
National University of KievKiev
Computer Science
Skills
- RDBMS
- ER/Studio Enterprise
- Team Edition UNIX Shells
- PL/SQL
- AWS
- API design and development
- Python 37
- AutoSys
- Oracle database
- ETL tools
- SQL server
- DB2
- PostgreSQL
- PgPL/SQL
Certification
- TOGAF 9.2 Certification
- Advanced PL/SQL Programming - Oracle corporation
- TOGAF 9.2 - Udemy
Personal Information
- Title: Sr Data Architect
- Date of Birth: 08/22/1968
- Nationality: American
Hobbies and Interests
- Traveling
- Reading
- Playing piano
- Gardening
- Spending time with kids
- Home improvement projects
Languages
Ukrainian
Native or Bilingual
Russian
Native or Bilingual
Software
Expert level
Timeline
Sr Application/Data Architect
Clinical Systems World
11.2018 - Current
Sr IT System Solution Architect
GlaxoSmithKline
06.2018 - 11.2018
Enterprise Solution Architect
Clinical Systems World LLC
02.2014 - 05.2018
Sr. Information Technology Solution Architect of Managed Market USIS
AstraZeneca (via Innovative Development)
07.2013 - 01.2014
Sr. Information Technology Analyst
ABIM American Board of Internal Medicine)
01.2013 - 07.2013
Sr. Database Developer / Database Architect
Accenture/Pfizer Inc
08.2011 - 01.2013
Sr. Software Engineer
UnitedHealth Group IT
08.2008 - 08.2011
Software Engineer
IMany
01.2008 - 08.2008
Sr Data Architect
National University of Kiev
Computer Science
Similar Profiles
Mohanad Abdel-RahmanMohanad Abdel-Rahman
Academic Peer Tutor at NAAcademic Peer Tutor at NA
Shlomo JaffeShlomo Jaffe
Highschool Math Tutor at NAHighschool Math Tutor at NA
CLÉLIA CROZE-LABBECLÉLIA CROZE-LABBE
Baby sitter at NABaby sitter at NA
Jaylen Tindale-SeymourJaylen Tindale-Seymour
Property Maintenance at NAProperty Maintenance at NA
Tommy AndersonTommy Anderson
Direct Bill Service Representative at United States Liability Insurance GroupDirect Bill Service Representative at United States Liability Insurance Group