Працювала в 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
Ключова інформація
Languages: PL/SQL, 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
Microsoft data Analyst
Olga Григорівна
Olga Григорівна
Senior SQL database developer, Sr Data Analyst, Sr Technical Consultant
Київ
повна зайнятість
Оновлено 1 місяць тому