Software Engineer Development
Resume:
Irina Smilansky
Email: *********@********.***
Address: *** ********* ****
City: Wayne
State: PA
Zip: 19087
Country: USA
Phone: 610-***-****
Skill Level: Experienced
Salary Range: $90,000
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
Irina Smilansky
208 Hermitage drive,
Radnor, PA 19087
*********@********.***
SUMMARY:
aA 15+ years of IT experience in Health Care and Life Sciences industries with concentration in application and database design and development.
aA 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.
aA Practical knowledge of various SDLCs, corporate IT standards, compliance procedures, multiple operating systems, programming languages and IT infrastructure platforms
aA Expert-level Oracle PL/SQL Architect and Developer
aA Extensive design, development and testing experience with Informatica PowerCenter and IBM InfoSphere DataStage 8.0
aA Excellent hands-on experience in Korn shell scripting
aA Excellent knowledge in Data Warehousing design and implementation
aA Experience with business requirements gathering, business analysis and documentation
aA Expertise in applying data integration concepts in pharmaceutical and managed care industries
aA Experience in troubleshooting and handling production support duties on a 24x7 basis
aA Experience in delivering projects in a SOX and CFR Part 11compliant environments
aA Ability to work productively with on and off shore development teams
BUSINESS PROCESSES AND APPLICATIONS
Claims Processing: I-Many Medicaid Version 8.5, iDeal ECP, Model N
Clinical Data Processing: Oracle Clinical
TECHNICAL BACKGROUND
Databases: Oracle 8 through 11g, SQL*Loader, Erwin CASE, Data Junction,
ODBC, IDMS, MS Access, SAS
Programming: SQL, PL/SQL, IBM DataStage 7.5.2, 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
EXPERIENCE:
Accenture/Pfizer Inc. 08/08/2011-08/04/2012
Sr. Consultant/Oracle 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:
aa Design and development of PL/SQL packages, store procedures, configuration files, tables, views, and functions; implementation of best practices to maintain optimal performance
aa Training and technical management of developers, advising other development groups on development of Oracle databases, data warehousing and ETL best practices
aa Conduct of code walkthroughs and review peer code and documentation
aa Building efficient Oracle packages for processing fact and dimension tables with complex transformations
aa Creation of systems for capturing, reporting, and correcting error data
aa Working with developers, DBAs, and systems support personnel in elevating and automating successful code to production
aa Gathering of requirements and design of data warehouse and data mart entities, creation of Source-to-Target mapping documents for ETL processes
aa Cost benefit analysis of various ETL tools and technologies
aa Development of UNIX shell scripts, JCL mainframe procedures, and processes to extract data from various sources such as DB2 and Oracle
aa Implementation of complex transformations by creating custom transformations in addition to using built-in ones
aa Oversight of unit and system tests and assisting users with acceptance testing.
aa Peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
aa Design of scalable, reusable, and low maintenance ETL templates
aa 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:
aa Collection of user requirements
aa Project documentation for all required steps by the SDLC, corporate standards and SAX compliance procedures
aa Planning and execution of assembly and integration testing
aa Evaluation of test results and identification of process improvements
aa Change requests as necessary and assisting in the impact analysis of submitted change requests
aa Support development planning activities for project releases; identify the scope and structure, define management plans, execution and control plans and conduct process tailoring
aa 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
aa Design and development of ETL processes involving data quality and testing
aa Development of data warehouse technologies and BI
aa Use of the Common DataStage ETL Framework for all ETL projects.
aa Working with SQL Loader and External tables to perform data import as a part of ETL process.
aa 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
Sr. Software Engineer
Responsible for development and support tasks of a major software development project: Validata.
Responsibilities included:
aa Direct interactions with top pharmaceutical clients (GSK, Eli Lilly) on various production application issues and product enhancements
aa Troubleshooting of complex application environments (Oracle 10g database and Oracle objects, J2EE servers and Java applications as well as the application integration logic)
aa Development of built in packages, collections, performance tuning using b-tree, bitmap indexes, bulk updates for performance enhancements, and partitioning by range, lists
aa Work with SQL Loader and External tables to perform data import
aa 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 aaa all application logic resided in the Oracle layer Interactions with Product Mangers and the team leads through all the software development stages ClaimRight Medicaid 2.0
Bridge Information Technologies, Cincinnati, Ohio 03/2001-08/2006
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
PVS Consulting Int., Ashland MA 1997 -1998
Application Programmer
EDUCATION:
MS in Computer Science, University of Kiev, Ukraine
PROFESSIONAL TRAINING: Advanced Oracle PL/SQL; IBM DataStage ETL, Oracle Data Modeling; Advanced Unix shell programming, Advanced PL/SQL tuning.
US Citizen
Contact this candidate