Работала в 3 компаниях   23 года 10 месяцев

Фармацевтика, Банки, Страхование

Senior technical consultant

Calyx enterprise

Фармацевтика

10 лет 5 месяцев

03.2014 - 08.2024

The Data Analyses and Data Migration expert assist PAREXEL future CALYX Customers in the gathering business requirements, review, analysis, ETL Data Loads and migration of historical client data from multiple repositories into an Oracle database as part of the InSight Manager (eClinical Publishing and Submissions of clinical research pharmaceutical companies global) implementations. Participating in XVMPD migrations, Brexit migration. Analyzing and researching data issues and applying fixes customers required. Creation of Custom Reports (Power BI) in full PLC from requirements, data analyses, development, implementation and support for existing data and forecasts. Assist with internal and external documentation activities for reporting and data migration procedures and tools. These activities include the following:Leading Data Analyses of customer data from historical repositories to load to InSight Manager Database. Work closely with Project Manager and Clients in Business Case Creation, Requirement Gathering, Data Mapping, Implementation, Testing, Researching and debugging issues and providing ongoing client support. Development of SQL queries and scripts to gather both historical data and prepare the cleansed data for import into the InSight Manager system. Creation of Custom Reports (Power BI) from BR, data analyses, development, implementation and support for existing data and forecasts.Perform Unit Testing and validation activities as required. Assist in the creation of xml configuration override files as required for the InSight Manager System configuration. Driving all activities associated with data migration delivery.

Senior Database Architect

Jpmorgan chase co

Банки

11 лет 5 месяцев

03.2002 - 08.2013

Senior Database Architect Responsible for Application Database Architect, Data Analyzes and data model, technical system solution, design, development testing, implementation and support of the Global Performance Review and Talent Review application. Responsible for the design of Application Security model and application configurability based on User LOB and/or role in bank hierarchy. Serve as the primary communication conduit between internal divisions, infrastructure support groups, feeds design and development of data bridges/feeds to other systems like PeopleSoft, Global Date Warehouse, CompConnect (enterprise-wide compensation planning system). Technical lead and guidance for offshore database development team. Key Accomplishments: Responsible of database (Oracle 10g) architecture, data analyses, technical system solutions, and design direction. Tech Lead of the project life cycle PLC to gather requirements, design, build, implement, test and support the application Working in PL-SQL, writing Oracle Stored Procedure, Trigger, Packages. Working with large databases. Revise business rules, research and expertise solutions, define and implement globally minded/locally executed procedures and application configurations by LOB's, Admin Support and User Roles. Automate majority of manual steps to support and maintain the application. Performed the analysis and automation of data feeds from/to application using Oracle SQL Loader, shell scripts and Autosys. Work closely with Project Manager and Clients in business case creation, requirement gathering, implementation , testing and user training for enhancements to the workflows within Performance and Talent Reviews Management and Employee feedback areas. Ensure synergy in execution of multi-faceted initiatives across various functional and LOB groups. Direct Business Analysts design and developing of PMC Reporting Module and setting up PMC Business Objects Reporting Universe with delivery of production reporting, performance metrics, and business trend analyzes for department's business units and senior management with assured data security and user roles. Excellent quality and timely matter production support with ability to quickly analyze and provide creative solutions to best serve and accommodate Client needs. Key communication point in database hardware maintenance and upgrades, ability to coordinate events between AD teams and company support infrastructure.

Consultant

Swiss re new markets

Страхование

1 год 9 месяцев

08.1997 - 05.1999

Worked with oracle financials ( oracle applications receivable interface ) to create and support the process of amex billing transaction data files sent to company oracle financials. Developed the file process and data flow into the system using oracle financials edi interface. Paragon computer professional

Ключевая информация

Data Engineer| Data Migration developer | Report Developer | SQL developer | ETL developer | Data Analyst |Database Data Architect | Client Consultant| Snowflake Developer

Languages: PL/SQL, Snowflakes, Oracle Store Procedures, Triggers and Packages, SQL, MS SQL, T-SQL, Autosys, HTML, Java Script, PowerBuilder 5.0 - 9.0, Databases: Oracle 7 - 12g, Sybase 10-11, MS SQL Server 2022, Access, UNIX Shell Scripts, MS Access, MS AzureOracle Technologies: Job Scheduler, SQL Loader, SQL*Plus, Oracle Financials- EDI, T-SQL, PhytonSoftware: MS Office/MS Project, Autosys – CA Workload Control Center , Toad, SQL Navigator, SQL Developer, Business Objects, Mercury Quality Center, MS SQL Management Studio, Power BI Prototyping: iRiseOperating Systems: Windows10, UNIX, LINUX

Училась в 1 заведении

Національний технічний університет України «Київський політехнічний інститут імені Ігоря Сікорського»

Automation of chemical engineering

Kyiv, 1992

Владеет языками

Английский

свободно

Может проходить собеседование на этом языке

Может проходить собеседование на этом языке

Испанский

продвинутый

Может проходить собеседование на этом языке

Может проходить собеседование на этом языке

Курсы, тренинги, сертификаты

da-100 MS data analyses

Інші країни, 2020

Microsoft data Analyst

Olga Григорівна

Senior SQL database developer, Sr Data Analyst, Sr Technical Consultant

Киев

3 800 $

55 лет

Активно ищет работу

полная занятость

Обновлено 1 день назад