Irina Smilansky

• 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
• 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 database developers on and off shore.
• Worked closely with clients to establish problem specifications and system designs.
• Worked closely with clients to establish problem specifications and system designs.
• Worked closely with clients to establish problem specifications and system designs.
• Performed regression and system-level testing to verify software quality and function before it was released.
• Identified and suggested new technologies and tools for enhancing product value and increasing team productivity.
• Created, delivered and maintained scalable system architecture to support a high-availability internet site with various internal applications.
• Developed the next generation integration platform for internal applications.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.
• Led a group of 11 engineers in the design, and development of Oracle-based software solutions.
• Built databases and table structures following n-tier architecture methodology for web applications.
• Established compatibility with third party software products by developing program for modification and integration.
• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
• Built application platform foundation to support migration from client-server product lines to enterprise architectures and services.
• Designed Sharepoint masterpage and page layouts, serving as company's main Sharepoint support for all technical complications.
• Developed work-flow charts and diagrams to ensure production team compliance with client deadlines.
• Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.
• Provided methodologies for object-oriented software development and efficient database design.
• Recommended architectural improvements, design solutions and integration solutions.

·         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;  


• Recommended architectural improvements, design solutions and integration solutions.
• Developed data architecture design to enable analysts to perform targeted customer analysis.

·         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;

​

• Utilized a pipe and filter model to find bottlenecks and enable measurement of system resource usage and process behavior at boundary limits of all operations.
• Developed data architecture design to enable analysts to perform targeted customer analysis.

• 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).
  
• Established compatibility with third party software products by developing program for modification and integration.
•   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
  
• Coordinated with systems partners to finalize designs and confirm requirements.
• Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.

• 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).
• 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.
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.

• Responsible for development and support tasks of a major software development project
• 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
• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.

• Participated in the design and development of an Oracle-based commercial software products, ClaimRight Medicaid and ClaimRight Commercial.
• 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
• Diagnosed and troubleshooted UNIX and Windows processing problems and applied solutions to increase company efficiency.

• 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.

• 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

Responsible for the design, development and maintenance of the data mart to support corporate contract and commercial information systems. Architected an Oracle8 data warehouse utilizing star scheme for the database design, parallel processing and data partitioning.

Engineered Unix Oracle data warehouse integration with the AS/400 DB2 database using Oracle’s Transparent Gateway. Developed a client-server system for transferring AS/400 data into an Oracle based relational data mart. The system is written in Visual Basic with extensive use of various Oracle objects written in PL/SQL.