Alena Satsunkevich

• Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
• Assessed accuracy and effectiveness of new and existing data sources and data analysis techniques.
• Built company A/B testing frameworks to test model quality.

• Create custom SQL data loads from various data sources utilizing Informatica, SQLLDR, and PL/SQL.
• Independent marketing research across multiple online sources to create complex analytical reports for senior management.
• Documented business workflows for stakeholder review.
• Experience using Microsoft Office tools including Word, Excel, and PowerPoint
• Enhanced collaboration between team members by preparing meeting materials and taking clear notes to distribute to stakeholders.
• Assessed urgency and priorities before accepting or declining appointments and meetings with CEO.
• Remained solutions-oriented in face of complex problems to assist management and overall business direction.
• Served as corporate liaison for Non-English new employees to adjust and thrive in company.
• Identify problem data and create data maintenance application to resolve issues.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
  

Creating efficient and well performed SQL queries utilizing hints, appropriate built-in or custom functions, etc. Researching bottleneck of complex SQL queries by investigating business logic efficiency, studying explanation plan, understanding/correcting object's structures and working with DBA to tune database if required.

SQL/shell / batch custom programming of ETL procedures. Report writing using advanced SQL analytical function and regular expression. Utilizing strong and deep knowledge of Oracle database to build balanced and very well performed Informatica jobs.
Working with Donnelley (3 party vendor) to support existing ETL processes and create new feeds for Data Warehouse.
Strong theoretical and practical knowledge of Data Warehouse and transactional database.
Design/support multi-system interfaces to bring together multiple data sources as ORACLE, Flat files, Informix into a Data warehouse to provide a global view of Wyndham business.
Full software development life cycle, design, build, test, troubleshoot application code based on user requirement documents and meetings.
Reading and troubleshooting a custom application written on Java, DOS and UNIX.
Customer support for application issues and errors utilizing problem tracking system.