Резюме DB developer

Професійні навички

• Accounting
• API
• Automation
• Big Data
• Business
• Cloud
• Consultant
• CRM
• Design
• English
• Excel
• HR
• Jira
• Management
• Mobile
• MS SQL Server
• OLAP
• OOP
• Russian
• SAAS

Початковий текст

1. ​Oleksandr Krasnobryzhyi

1. ​DOB: **********

Contact Information:

Mail: ****************************

Skype: alexkrasnij

Tel: Показати контакти

Education:

1997 – 2000: Physic-Mathematic lyceum № 27

2000 – 2005: Kharkov National University of Radio Electronics. Computer Science

Languages:

Work Experience:

• Dec 2018 Visiquate, Senior DB developer

• • Performing analysis, tuning and optimizations

  • Maintenance and support of SQL Server databases

• Dec 2016 – Aug 2018 Ciklum/SBTech LTD, Senior BI developer, Gambling project

• • Introducing OLAP technology to the project, migrating the entire project to that

  • Performing analysis, tuning and optimizations of VLDB (including SQL and OLAP);

  • Optimizing a system based on the system logs results

  • Specification analysis and communication to Product owner

  • Code reviews

  • Cross team cooperation

• 2015 – Dec 2016 LTD “Sigma Software”.Senior BI developer

· Existing ETL process optimization to increase its performance;

· Development of out of box standard solutions

Projects overview:

2015-2016 – Product in area of social media marketing (licensing.mikz.com) –Senior BI engineer

Mikz platform – an advanced cloud-based service platform that offers fully supported white label solutions for influencer marketing, gift certificates, coupons and other consumer-centric mobile services.

Mar ************** – Qualco- Team Lead, Senior BI engineer

End-to-end collection and recovery solution that automates and streamlines operations across the entire credit lifecycle.

Main Responsibilities:

• ●●Performing analysis, tuning and optimizations of VLDB (including SQL and OLAP);

• ●●Maintenance and support of SQL Server databases;

• ●●Design and maintain ETL processes; Queries/ETL optimization. Query plan analysis;

• ●●Cross team cooperation, development process setup;

• ●●Experience in XML;

• ●●Management activities: DW Developers supervision;

• ●●Communication between different teams;

• 2014 –2015 LTD “Big Data Analytics” - Senior BI engineer

Project overview:

Main partner of Big Data Analytics is MedeAnalytics (www.medeanalytics.com) which is a cloud-based business intelligence company focused on improving the financial, clinical and operational performance of healthcare organizations (hospitals, physician practices and health plans).

Main Responsibilities:

• ●●Performing analysis, tuning and optimizations of VLDB (including SQL and OLAP);

• ●●Maintenance and support of SQL Server databases;

• ●●Design and maintain ETL processes; Queries/ETL optimization. Query plan analysis;

• ●●Cross team cooperation, development process setup;

• ●●Experience in XML;

• ●●Management activities: DW Developers supervision;

• ●●Communication between different teams;

• 2013-2014 LTD “VisiQuate”- Consultant

Project overview:

VisiQuate is a company that provides Business Intelligence and Big Data Analytics solutions in a field of US Healthcare. It combines predictive sciences service and technology, third party data integration, it delivers workflow automation and optimization and gives the ability to discover deeper connections between cause and effect, to understand customers and save money and walk through different audit types that are obligatory on the government level.

Responsibilities:

• ●●Performing analysis, tuning and optimizations of VLDB (including SQL and OLAP);

• ●●Maintenance and support of SQL Server databases;

• ●●Design and maintain ETL processes; Queries/ETL optimization. Query plan analysis;

• ●●Cross team cooperation, development process setup;

• ●●Experience in XML;

• ●●Work with EDI formats (835/837 Standards), parser creation;

• ●●Management activities: DW Developers supervision;

• ●●Monitoring and control tasks;

• ●●Communication between different teams;

• 2008 – 2013 LTD «Stella Systems»- Operational Engineers Group Lead

Project overview:

In cooperation with MedeAnalytics Inc. (www.medeanalytics.com) worked on customer-driven, web-based SaaS solution development which provides business intelligence and analytical tools for US healthcare industry. For each customer specific product solutions were developed based on a common platform and MS SQL Server Data Warehouse and Analysis Service OLAP database.

Responsibilities:

• ●●Design/architecture/development of data bases (MS SQL ****************/MS SQL 2012). Created over 50 clients.

• ●●Designed data warehouse solutions.

• ●●Developed new solutions. Worked both on the creation of standard solutions and non-standard client-driven modules.

• ●●Developed full cycle ETL processes, worked on performance optimization and automation, performance troubleshooting.

• ●●Created OLAP databases: architecture, development, support, and optimization.

• ●●Performed Queries/ETL optimization. Query plan analysis. Worked on optimization of DBs > 1 TB

• ●●Clarified technical questions; performed trainings, took part mentoring activities and best-practice policies development for the team.

• ●●Was responsible for tasks assignment/management.

• ●●Provided help with business logic questions and high complexity client change request implementation.

• ●●Determined an optimal architecture based solution on based detailed requirements.

• ●●Experience in XML

• ●●Have deep understanding of Healthcare processes, data storage formats (EDI, HL7 etc).

• 2005 – 2008 – LTD «Enigma Soft». Software developer

Responsibilities:

• ●●Architecture, development and support of the banking and accounting software products.

• ●●Developed and supported API to generate and read files in BIFF8 format (MS Excel), replication module.

• ●●Trained clients’ employees to work with software

Skills:

• ●●Strong experience with SQL Server 2************8/2012, SSAS, SSIS.

• ●●Deep knowledge of MDX, expert writing queries using MDX & SQL to aid generation of required Business Intelligence reports. 6 + years experience.

• ●●Expert building big and complex OLAP cubes at SSAS, size 100+ G, 200+ dimensions, 1000+ measures.

• ●●Good experience and understanding of database design, data model optimization for BI application.

• ●●Experience supporting Data warehouses and Data marts at MS SQL Server size 1+ Tb, 400+ million rows fact table.

• ●●Strong experience in T-SQL, developing ETL strategies based on SSIS, SQL scripts, Stored Procedures, UDF, tuning performance.

• ●●Experience with CRM and Workflow management tools such as Salesforce, JIRA.

• ●●MS SQL Server, OLAP(MDX, XMLA,DMX),Vertica, Clarion, Win API, GDI

• ●●The ability to architecture informational systems and relational data bases (MS SQL)

• ●●Experience with SVN.

Extracurricular Activities:

Weightlifting, fishing, reading